Item 4ABUILDING DEPT. MONTHLY ACTIVITY REPORT
COMPARISON REPORT f--------------------------------------------------------------------------------------------
REPORT FOR THE MONTH AUG 2014
-------------------------------------------------
--------------------------------------------
COMPARISION 2013-2014
PERMIT TYPE NUMBER OF PERMITS =-~ --------------I TOTAL INSPECTIONS
YTD 2013 YTD 2014 YTD 2013 YTD 2014 YTD 2013 YTD 2014
~~~:LLEEXFAMILY ---:20 _15 !--------1 ~ -----__ 4,550,~00 I ~ -----------~918,026_!_________ ------+-
I-R__::E_M_O_cDc_:_E_L_/A_D_D_IT-IO_N_S ____ ____J ______ 1_99----I ------281 $ 3,021,157 $ __ ~!7~_,!~Q_1 -=--=--:-=t-_ ----------!
COMMERCIAL NEW -7 $ ----:---:$-------------2,225,427 ----------
......
~O._._T_._.H-=E._._R __________ -=-=-=-=--:-f--:_=_=_=_='"-=--1=,-=-3=6=7,__-1" 1,844 $-5,786,152 $ 5,303,599 j
______________ TOTAL 1,586 I 2,147 $ 13,357,6()_!!~~-----1~.203,1?_~ --_________ },3~§__1 ___ ----~.4_1'!
PERMITS ISSUED FOR THE MONTH OF AUG 2014
NO.PERMITS PERMIT COST CONSTRUCTION VALUE INSPECTIONS PERFORMED
SINGLE FAMILY 1 I$ 1,722 I$ 520,985 BUILDING I 170
NEW DUPLEX MUL Tl FAM ! 0 ~ $ -! -----n---ELECTRICAL 68
RESIDENTIAL ADDITIONS
1
7 --$-------600T_____ ,--$ ---------46,400 PLUMBING . 78
RESIDENTIAL ALTERATIONS 36 $ 6,604 $ 1,135,862 MECHANICAL 67 ~~~~----------~--------~------~--------~~+-------~----------~--~-+~-~----------------I ~Ofv1M~RCIAL._t.1EW ____ --~-_____ Q__ _ _ ___ ·-~ -_ _ _ _i__ _ __ -:MISC. 89
gg~~~~~1~-t~fi~~~NS i --~ -------Jl~-------siJ---------:-~ ----------------9~~~i_o_1 _ TOTAL· 472
~~~~~~~~~C ----~ ~ _-__ -~~}?_----~-~~----------~~-~-----t~--------------: 'ProjectstoNote:N~wDuplex ____ _
'~~~~:~:~:~ ~~!c I :1 : 4.~~~ ' : : ron-• u--. I :~~~~~G __ ----~~------;~ _______ t~~ ~~-=-~~~~-~-=tt=-· __ L __ _ ~~~o~~~~OR -_::__ -J~~~-~=~=t=-~=fF -----~~~ -1·. ·-j ~ 2~~;~~~ f~~~~:~~!~!:~~~:w Dwelling
~f.~~!!ON_f_E~------9 • $ 449 1 $ _____ _ __ _ -1 Beach Drive J $ 520,985
~~~~f,W~~~~CTIONS t ~ 1 : i.~ii-L _ _ JL -_ ~-1~:0~: .. to No•·:rco~~ ~ ~
~~~}~AYS ! ~---ft --~;~ I -~-~ -----: I ----I -----------; ~
:;~:HrCKFEES -T-:J -+.-----+! 3~:~~1--A -2.2:::.:: IEXPIRED~ERMIT~~:~~O~lECT9~: ~~
City of Atlantic Beach
FINANCIAL REPORT AGENDA ITEM# 4A
August 2014 SEPTEMBER 22,2014
Cash Balances
Prior Current Dollar Percent
Fund(s) 07131114 08131114 Change Change
General $ 7,840,056 $ 7,533,042 $ (307,014) -3.92%
Tree Replacement 12,321 12,321 0.00%
Convention Development Tax 57,586 69,457 11,871 20.61%
Local Option Gas Tax 231,892 255,364 23,472 10.12%
Better Jax 112 Cent Sales Tax 460,494 498,849 38,355 8.33%
Police Training, Forfeiture, Grants, etc. 123,580 153,594 30,014 24.29%
Community Development Block & ARRA Grants (9,212) (650) 8,562 0.00%
Debt Service 0.00%
Capital Projects 2,983,334 3,013,245 29,911 1.00%
Utility 5,301,662 4,414,862 (886,800) -16.73%
Sanitation 739,435 684,961 (54,474) -7.37%
Building Code Enforcement 250,515 270,568 20,053 8.00%
Storm Water 1,724,309 1,591,635 (132,674) -7.69%
Pension -Police (9,231) 12,579 21,810 -236.28%
Pension -General 251,795 6,010 (245,785) -97.61%
Total $ 19,958,536 $ 18,515,837 $ (1 ,442,699) -7.23%
Total Restricted Cash 7,417,049
Total Unrestricted Cash $11 ,098, 788
Cash and Investments
Annual Prior Current Dollar Percent
Account Yield 07131114 08131114 Change Change
Bank of America-Depository 0.20% $ 2,849,601 $ 2,657,841 $ (191,760) -6.73%
Guggenheim Floating Rate A 4.00% * 3,723,507 3,073,700 (649,807) -17.45%
Hartford Floating Rate Bond A 3.40% * 2,548,969 2,556,941 7,972 0.31%
lnvesco Floating Rate A 3.97% * 3,685,718 3,048,310 (637,408) -17.29%
MainStay Short Term Duration High Yield A 3.31% * 2,564,151 2,581,631 17,480 0.68%
First Trust Short Duration High Income A 3.71% * 2,027,280 2,041,440 14,160 0.70%
Putnam Diversified Inc. 3.76% * 1,290,462 1 ,276,184 (14,278) -1.11%
Alliance Limited Duration High Income A 2.50% * 1,263,566 1,274,508 10,942 0.87%
MSSB Money MarkeUCash 0.05% 1,778 1,778 0.00%
SBA-Florida Prime 0.16% 354 354 0.00%
Cash on Hand 3,150 3,150 0.00%
Subtotal $ 19,958,536 $ 18,515,837 $ (1 ,442,699) -7.23%
Police Pension Investments $ 8,151,570 $ 8,411,148 $ 259,578 3.18%
General Pension Investments 14,667,936 15,157,490 489,554 3.34%
Subtotal $ 22,819,506 $ 23,568,638 $ 749,132 3.28%
Total $ 42,778,042 $ 42,084,475 $ (693,567) -1.62%
* Denotes the 30 day SEC Yield Anualized
City of Atlantic Beach
FINANCIAL REPORT
August 2014
AGENDA ITEM# 4A
SEPTEMBER 22,2014
Revenues
Annual YTD-91.67% YTD Dollar
Fund I (Footnote) Estimate of Estimate Actual Variance
General $ 10,933,571 $ 10,021,415 $ 10,777,105 $ 755,690
Convention Development Tax 80,300 73,601 99,347 25,746
Local Option Gas Tax 421,009 385,913 390,372 4,459
Better Jax 1/2 Ct Sales Tax 694,870 636,955 673,783 36,828
Police Training, Forfeiture & Grants 110,041 100,479 138,878 38,399
Grants 141,399 113,016 139,848 26,832
Capital Projects 489,780 450,248 359,143 (91,105)
Utility 8,727,453 7,970,968 7,860,793 (110,175)
Sanitation 1,789,000 1,639,913 1,663,791 23,878
Building Code Enforcement 281,550 258,049 388,939 130,890
Storm Water 1 '155,000 1,058,750 1,130,681 71,931
Pension -Police 1,329,681 1,218,855 1,340,759 121,904
Pension -General
Total $
2,190,980 2,008,391 2,097,751
28,344,634 $ 25,936,553 $ 27,061,190
Analysis of Major Variances
(Variances >$25,000 AND 10.00%)
89,360
$ 1,124,637
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:
Increased hotel occupancy has resulted in a positive variance in bed tax monies received in
the Convention Development Tax Fund.
Receipts from the sale of seized vehicles contributed to the majority of variance in the
Police Training, Forfeiture & Grants Funds.
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.
The variance in the Pension -Police Fund represents Chapter 185 premium tax money
received in August.
Percent
Variance
7.54%
34.98%
1.16%
5.78%
38.22%
23.74%
-20.23%
-1.38%
1.46%
50.72%
6.79%
10.00%
4.45%
4.34%
City of Atlantic Beach
FINANCIAL REPORT AGENDA ITEM# 4A
August 2014 SEPTEMBER 22, 2014
Expenses
Annual YTD-91.67% YTD Dollar Percent
Department Estimate of Estimate Actual Variance Variance
Governing Body $ 42,933 $ 39,303 $ 35,097 $ 4,206 10.70%
City Administration 2,689,720 2,454,636 2,191,545 263,091 10.72%
General Government 653,078 595,291 549,798 45,493 7.64%
Planning and Building 434,709 398,343 327,288 71,055 17.84%
Public Safety 5,715,716 5,232,533 4,772,217 460,316 8.80%
Recreation and Special Events 411,551 373,481 332,234 41,247 11.04%
Public Works 7,926,078 7,251,929 5,151,845 2,100,084 28.96%
Public Utilities 10,757,956 9,863,939 8,159,238 1,704,701 17.28%
Pension -Police 751,628 688,941 701,660 (12,719) -1.85%
Pension -General 1 '1 02,850 948,381 843,704 104,677 11.04%
Total $ 30,486,219 27,846,777 23,064,626 $4,782,151 17.17%
Annual YTD-91.67% YTD Dollar Percent
Resource Allocation Estimate of Estimate Actual Variance Variance
Personnel Services $ 9,487,018 $ 8,698,466 $ 8,185,293 $ 513,173
Operating Expenses 11,102,145 10,072,777 8,455,540 1,617,237
Capital Outlay 5,765,339 5,292,613 2,534,035 2,758,578
Debt Service 2,448,773 2,244,543 2,351,344 (1 06,801)
Grants and Aids 51,470 43,503 46,535 (3,032)
Transfers
Total $
1,631,474 1,494,875 1 ,491 ,879
30,486,219 $ 27,846,777 $ 23,064,626
Analysis of Major Variances
(Variances >$25,000 AND 10.00%)
2,996
$ 4,782,151
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:
City Administration expense savings are related to the Finance Director vacancy for most of
the fiscal year and less than anticipated repair and maintenance expense in the IT Department.
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.
Pension-General expenditures are below budget due to the timing of a lump-sum benefit that
has yet to be applied for and distributed.
5.90%
16.06%
52.12%
-4.76%
-6.97%
0.20%
17.17%
City of Atlantic Beach
FINANCIAL REPORT AGENDA ITEM # 4A
August 2014 SEPTEMBER 22, 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 13,634 22,323 4,043 I
Enclose Under Portion of Lifeguard Bldg for Equipment Storage PS1402 6,000 3,634 2,366 c
$ 46,000 $ 17,268 $ 22 323 $ 6,409
Public Utilities:
Reclaim Water Facility PU0805 1,352,269 971,819 381,037 (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 36,514 13,486 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 146,015 8,985 I
Effluent Outfall Replacement PU1408 137,264 9,246 13,395 114,623 R
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 R
Subtotal $2,696,487 $ 1,257,207 $ 956,699 $ 482,581
Parks Maintenance:
Marsh Master Plan Signs PM1301 625 625 c
Rose Park Development PM1302 225,250 210,850 14,399 1 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 R
Marsh Preserve Path Phase-1 PW1410 42,000 41,628 372 c
Subtotal $ 902 067 $ 349 157 $ 147 029 $ 405,881
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 43,400 27,993 15,073 334 I
Sidewalk and Curbs PW1405 25,000 943 138 23,919 I
Salt Air/Sturdivant Drainage and Sidewalk lmprovmts PW1406 380,000 52,434 22,805 304,761 R
Seminole Streetscape PW1407 498,000 22,910 95,064 380,026 R
Canopy Replacement on PW Building PW1413 78,900 72,200 6,688 12 I
Batting Cage Mat I Russell Park PW1416 11,000 10,966 34 I
Subtotal $ 1,440,253 $ 458,324 $ 166,254 $ 815,675
Total $ 5,084,807 $ 2,081,956 $ 1,292,305 $ 1,710,546
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