Agenda Item 4A - Monthly ReportsBUILDING DEPT. MONTHLY ACTIVITY REPORT
~~~~-
COMPARISON REPORT
REPORT FOR THE MONTH JULY 2014
!-~~~~~---~----------~---~--~~~~~~~~~-
COMPARISION 2013-2014
PERMIT TYPE
-~~-
~~---TOTAL INSPECTIONS __ __]NUMBER OF PERMITS~ Hl~ ___ :
YTD 2013 YTD 2014 YTD 2013 YTD 2014 YTD 2013 YTD 2014
~~~~t~~1~M!L:Y ---~-~ .. 2~ ~ .. ~=-==-=i I : :::;:::-:-:~-:-: +~~-===+-~=-~~~~~~!"~~~N::_·---=+--:--....•.
1
~-7 --------=+ -[ $ 2,225,427.00
OTHER -TOTAL---~_ ~ _l=~=-=c~-------------~_]~[=~----1::~:~!~~:~~ r-------=-29=-=7=-=5----r----:2::-::9-:-:42=----t
PERMITS ISSUED FOR THE MONTH OF JULY 2014
~~~--~--~-----
City of Atlantic Beach
FINANCIAL REPORT AGENDA ITEM# 4A
July 2014 SEPTEMBER 8, 2014
Cash Balances
Prior Current Dollar Percent
Fund(s) 06/30/14 07/31/14 Change Change
General $ 8,290,461 $ 7,840,056 $ (450,405) -5.43%
Tree Replacement 12,321 12,321 0.00%
Convention Development Tax 68,208 57,586 (10,622) -15.57%
Local Option Gas Tax 210,639 231,892 21,253 10.09%
Better Jax 1/2 Cent Sales Tax 442,182 460,494 18,312 4.14%
Police Training, Forfeiture, Grants, etc. 126,054 123,580 (2,474) -1.96%
Community Development Block & ARRA Grants (9,212) (9,212) 0.00%
Debt Service 0.00%
Capital Projects 2,974,792 2,983,334 8,542 0.29%
Utility 5,207,051 5,301,662 94,611 1.82%
Sanitation 729,966 739,435 9,469 1.30%
Building Code Enforcement 237,725 250,515 12,790 5.38%
Storm Water 1,804,837 1,724,309 (80,528) -4.46%
Pension -Police 10,704 (9,231) (19,935) -186.23%
Pension -General 229,754 251,795 22,041 9.59%
Total $ 20,344,694 $ 19,958,536 $ (386, 158) -1.90%
Total Restricted Cash 7,641,026
Total Unrestricted Cash $12,317,510
Cash and Investments
Annual Prior Current Dollar Percent
Account Yield 06/30/14 07/31/14 Change Change
Bank of America -Depository 0.20% $ 3,182,410 $ 2,849,601 $ (332,809) -10.46%
Guggenheim Floating Rate A 4.00% * 3,718,748 3,723,507 4,759 0.13%
Hartford Floating Rate Bond A 3.47% * 2,555,607 2,548,969 (6,638) -0.26%
lnvesco Floating Rate A 3.97% * 3,692,016 3,685,718 (6,298) -0.17%
MainStay Short Term Duration High Yield A 2.92% 2,592,133 2,564,151 (27,982) -1.08%
First Trust Short Duration High Income A 3.71% * 2,036,773 2,027,280 (9,493) -0.47%
Putnam Diversified Inc. 3.76% * 1,288,535 1,290,462 1,927 0.15%
Alliance Limited Duration High Income A 2.23% * 1 ,273,192 1,263,566 (9,626) -0.76%
MSSB Money Market/Cash 0.05% 1,778 1,778 0.00%
SBA-Florida Prime 0.16% 352 354 2 0.57%
Cash on Hand 3,150 3,150 0.00%
Subtotal $ 20,344,694 $ 19,958,536 $ (386, 158) -1.90%
Police Pension Investments $ 8,262,431 $ 8,151,570 $ (110,861) -1.34%
General Pension Investments 14,858,676 14,667,936 {190,7402 -1.28%
Subtotal $ 23,121,107 $ 22,819,506 $ (301 ,601) -1.30%
Total $ 43,465,801 $ 42,778,042 $ (687,759) -1.58%
* Denotes the 30 day SEC Yield Anualized
City of Atlantic Beach
FINANCIAL REPORT
July 2014
AGENDA ITEM# 4A
SEPTEMBER 8, 2014
Revenues
Annual YTD -83.00% YTD Dollar
Fund I (Footnote) Estimate of Estimate Actual Variance
General $ 10,933,571 $ 9,109,708 $ 10,206,572 $ 1,096,864
Convention Development Tax 80,300 66,910 77,019 10,109
Local Option Gas Tax 421,009 350,830 353,519 2,689
Better Jax 1/2 Ct Sales Tax 694,870 579,050 599,178 20,128
Police Training, Forfeiture & Grants, etc. 110,041 90,939 108,842 17,903
Grants 141,399 84,633 131,286 46,653
Capital Projects 489,780 410,740 329,232 (81 ,508)
Utility 8,727,453 7,214,630 7,111,235 (103,395)
Sanitation 1,789,000 1,490,830 1,513,339 22,509
Building Code Enforcement 281,550 234,590 351,028 116,438
Storm Water 1 '155,000 962,500 1,025,407 62,907
Pension -Police 1,329,681 1 '1 08,050 1,060,158 (47,892)
Pension -General
Total $
2,190,980 1,825,810 1,791,847
28,344,634 $ 23,529,220 $ 24,658,662
Analysis of Major Variances
(Variances >$25,000 AND 10.00%)
(33,963)
$ 1,129,442
In general, the major variances are created when the actual funds received-to-date are different
from the percentage of the budget elapsed-to-date. They are as follows:
The positive variance in the General Fund is mainly due to the timing of property tax
receipts. The bulk of the receipts come in November and December. Additional items
included in revenues that provided a favorable variance to the amounts budgeted for this
period are increased earnings on pooled cash investments and proceeds from the sale of
the foreclosed property at 765 Sabalo Road.
A positive variance in Grant Funds occurred this period, as projects were completed and
grant reimbursement was requested and received earlier in the year.
The city has not received expected grant monies for the Marsh Master Plan from the State
of Florida nor the City of Jacksonville, as conceptual design discussions are still in progress;
therefore there is a negative variance in Capital Project Funds.
Building Code Enforcement Fund permit activity is running above projected revenues,
similar to surrounding jurisdictions and counties.
Percent
Variance
12.04%
15.11%
0.77%
3.48%
19.69%
55.12%
-19.84%
-1.43%
1.51%
49.63%
6.54%
-4.32%
-1.86%
4.80%
City of Atlantic Beach
FINANCIAL REPORT AGENDA ITEM# 4A
July 2014 SEPTEMBER 8, 2014
Expenses
Annual YTD-83.00% YTD Dollar Percent
Department Estimate of Estimate Actual Variance Variance
Governing Body $ 42,933 $ 35,730 $ 31,679 $ 4,051 11.34%
City Administration 2,689,720 2,219,997 2,033,107 186,890 8.42%
General Government 653,078 537,662 518,915 18,747 3.49%
Planning and Building 434,709 362,130 298,084 64,046 17.69%
Public Safety 5,715,716 4,749,979 4,375,738 374,241 7.88%
Recreation and Special Events 411,551 335,533 293,874 41,659 12.42%
Public Works 7,926,078 6,578,462 4,651,110 1,927,352 29.30%
Public Utilities 10,757,956 8,970,687 7,756,426 1,214,261 13.54%
Pension -Police 751,628 626,310 645,615 (19,305) -3.08%
Pension -General 11102,850 793,983 776,998 16,985 2.14%
Total $ 30,486,219 25,210,473 21,381,546 $3,828,927 15.19%
Annual YTD-83.00% YTD Dollar Percent
Resource Allocation Estimate of Estimate Actual Variance Variance
Personnel Services $ 9,495,693 $ 7,914,301 $ 7,460,721 $ 453,580
Operating Expenses 11,075,513 9,049,554 7,791,882 1,257,672
Capital Outlay 5,783,296 4,812,265 2,428,951 2,383,314
Debt Service 2,448,773 2,040,492 2,310,344 (269,852)
Grants and Aids 51,470 35,553 32,895 2,658
Transfers
Total $
1,631,474 1,358,308 1,356,753
30,486,219 $ 25,210,473 $ 21,381,546
Analysis of Major Variances
(Variances >$25,000 AND 10.00%)
1,555
$ 3,828,927
In general, the major variances are a result of timing differences created between the percentage
of budget elapsed-to-date and actual expenditures. They are as follows:
The positive variance in Planning and Building resulted from turnover and vacancy savings
during the fiscal year, coupled with reorganization of positions.
Recreation and Special Events has also experienced savings due to turnover and vacancy in
their department.
The variance in Public Works was due to: project activity budgeted that has not been
completed -see Project Activity schedule; Storm Water Fund debt payments were expensed in
October when paid, but prorated for budget purposes; and minimal expenses have been
incurred towards the Parks Master Plan consultant or the resurfacing/street paving program.
The variance in Public Utilities is due to budgeted project activity that has not been started I
completed or will be re-budgeted in a future fiscal year.
The negative variance in Debt Service resulted from timing differences between payment of
debt service and the budgeted expense allocation.
5.73%
13.90%
49.53%
-13.22%
7.48%
0.11%
15.19%
City of Atlantic Beach
FINANCIAL REPORT AGENDA ITEM# 4A
July 2014 SEPTEMBER 8, 2014
Project Activity -Current Year Activity Only
Project YTD YTD
Project Name Number Budget Actual Encumbrances Balance Status
Public Safety:
Kennel Improvements PS1401 40,000 35,957 4,043 I
Enclose Under Portion of Lifeguard Bldg for Equipment Storage PS1402 6,000 3,634 2,366 c
$ 46 000 $ 3 634 $ 35 957 $ 6 409
Public Utilities:
Reclaim Water Facility PU0805 1,352,269 968,534 384,322 (587) I
Replace the Water Main on Pine Street PU1304 53,199 53,199 c
Replace 4" Water Main at Wonderwood and Finegan PU1305 58,852 58,852 c
PT Repair at Lift Station C PU1306 22,397 22,397 I
Repair 24" Effluent Force Main PU1308 5,260 5,260 c
Repair 12" Force Main PU1309 3,363 3,363 c
Water Plant #2-Rehab Elevated Tank PU1401 125,000 122,540 2,460 I
Water Plant #2 Rehabilitation Ground Storage Tank PU1402 121,528 121,528 c
Replace Water Maint-Sea Oats & Park Terrace PU1403 168,472 168,472 R
lnline Valve Installation PU1404 50,000 16,599 33,401 I
Replace Manhole on Saturiba PU1405 73,883 54,450 19,433 I
Sewer Rehab Saturiba & Sea Oats PU1406 190,000 153,000 37,000 I
Donner Subd Sewer Rehab -HMGP Grant PU1407 155,000 137,719 17,281 I
Effluent Outfall Replacement PU1408 137,264 8,746 13,395 115,123 E
Effluent Pump at WWTP PU1409 50,000 33,940 14,478 1,582 I
Connect A1A at Mallard Cove PU1410 130,000 12,873 117,127 E
Subtotal $2,696,487 $ 1,253,422 $ 931,773 $ 511,292
Parks Maintenance:
Marsh Master Plan Signs PM1301 625 625 c
Rose Park Development PM1302 237,440 210,850 14,399 12,191 I
Russell Park Tennis Courts 1-2 PM1401 100,000 100,000 s
Bull Park Gazebo PM1402 X
Donner Park Ball field Improvements PM1403 83,192 74,000 9,192 c
Electric Gate at Dutton Island Park PM1404 8,000 7,465 535 I
Marsh Project Pedestrian Path PW1408 150,000 22,054 125,165 2,781 E
March Overlook & Kayak Launch PW1409 293,000 293,000 E
Marsh Preserve Path Phase-1 PW1410 42,000 41,628 372 c
Subtotal $ 914,257 $ 349,157 $ 147,029 $ 418,071
Public Works:
Dutton Isle Road Sidewalks PW1301 61,707 61,033 674 c
East Coast Drive Drainage Improvements PW1306 319,546 213,837 1 '128 104,581 I
Fountain PW1402 7,500 6,245 1,255 I
Welcome Sign PW1403 15,200 6,974 8,147 79 I
Robert Street Ditch PW1404 50,000 25,840 17,227 6,933 I
Sidewalk and Curbs PW1405 25,000 497 583 23,920 I
Salt Air/Sturdivant Drainage and Sidewalk lmprovmts PW1406 380,000 49,083 26,156 304,761 E
Seminole Streetscape PW1407 498,000 54 117,920 380,026 E
Canopy Replacement on PW Building PW1413 78,900 48,420 30,468 12 I
Subtotal $ 1,435,853 $ 405,738 $ 207,874 $ 822,241
Total $ 5,092,597 $ 2,011,951 $ 1,322,633 $ 1,758,013
Status Key
A -Bid/RFP Advertised I -Project In-progress
B -Bid Awarded N -Complete/Non-Capital
C -Project Completed R-Re-budget Next Fiscal Year OR Re-Evaluated
D -Design Completed S -Staff Researching
DE -Deferred X -Project Cancelled
E -Design Phase