Agenda Item #4A - Building Dept. Monthly Report and Financial Report - Mar 2014BUILDING DEPT. MONTHLY ACTIVITY REPORT
-------------------------------------------------------------
COMPARISON REPORT
REPORT FOR THE MONTH MARCH 2014
COMPARISION 2013-2014
PERMIT TYPE----------,NUMBER OF PERMITS ---,------,------------------------------, -----TOTAL INSPECTIONS------
----------------------_j I _____ I
YTD 2013 YTD 2014 YTD 2013 YTD 2014 YTD 2013 YTD 2014
SINGLE FAMILY---------I 2 8 ~----~ $ 434,000.00 I $2,656,041.00 I --------------------o -o --IT ----------_-,----------$0.oo-----------
REMOoEu.A.i:>orfloNs ---------92-l----1~-----------~-------1,s22,so8.oo 1 --------$1 ,o6f476.oo 1 ------------T --------
COMMERCIAL NEW----' __ 0___ 0 -----~---------------_ -1$------11,132,911.00 I-------------------
OTHER ___ -----------t--536------~--$----1:489,912.ool$ __________ --2~156,s82.0ot---------------------------
~~=~~~ -TOTA~r-----630 ---546 ~--=------1$ _______ =!!446,?20.0[l----=---~-$17,oo7~010.00 I _ _13~ ___ .1 ___ 1125 ___ _
PERMITS ISSUED FOR THE MONTH OF MARCH 2014
--------------
1
AGENDA ITEM# 4A
City of Atlantic Beach MAY 12,2014
FINANCIAL REPORT
March 2014
Cash Balances
Prior Current Dollar Percent
Fund(s) 02/28/14 03/28/14 Change Change
General $ 8,795,295 $ 8,687,919 $ (107,376) -1.22%
Tree Replacement 10,949 10,949 0.00%
Convention Development Tax 71,958 61,749 (1 0,208) -14.19%
Local Option Gas Tax 134,837 156,428 21,591 16.01%
Better Jax 1/2 Cent Sales Tax 355,147 368,810 13,663 3.85%
Police Training, Forfeiture, Grants, etc. 131,434 107,197 (24,238) -18.44%
Community Development Block & ARRA Grants (952) (952) 0.00%
Debt Service 0.00%
Capital Projects 2,868,746 2,902,996 34,250 1.19%
Utility 5,294,866 5,480,503 185,637 3.51%
Sanitation 705,708 724,137 18,429 2.61%
Building Code Enforcement 200,120 201,668 1,548 0.77%
Storm Water 1,722,067 1,792,065 69,998 4.06%
Pension-Police 64,772 63,881 (891) -1.38%
Pension -General 132,764 220,943 88,178 66.42%
Total $ 20,487,713 $ 20,778,295 $ 290,582 1.42%
Total Restricted Cash 7,683,285
Total Unrestricted Cash $13,095,010
Cash and Investments
Annual Prior Current Dollar Percent
Account Yield 02/28/14 03/28/14 Change Change
Bank of America -Depository $ 3,593,151 $ 3,807,389 $ 214,238 5.96%
Guggenheim Floating Rate A 4.16% 3,666,453 3,680,750 14,297 0.39%
Hartford Floating Rate Bond A 3.34% 2,518,751 2,526,108 7,357 0.29%
lnvesco Floating Rate A 3.92% 3,639,028 3,650,288 11,260 0.31%
Main Stay Short Term Duration High Yield A 3.04% 2,536,787 2,556,074 19,287 0.76%
Legg Mason WA Cash Reserve Fund 1,777 1,777 0.00%
First Trust Short Duration High Income A 3.58% 2,010,949 2,014,204 3,255 0.16%
Putnam Diversified Inc. 4.23% 1,258,405 1,277,077 18,672 1.48%
Alliance Limited Duration High Income A 2.42% 1,258,914 1,261 '130 2,216 0.18%
MSSB Money Market/Cash 0.00%
SBA -Florida Prime 348 348 0.00%
Cash on Hand 3 150 3 150 0.00%
Subtotal $ 20,487,713 $ 20,778,295 $ 290,582 1.42%
Police Pension Investments $ 8,097,085 $ 8,025,662 $ (71 ,423) -0.88%
General Pension Investments 14740788 14,607,886 {132,902} -0.90%
Subtotal $ 22,837,873 $ 22,633,549 $ (204,324) -0.89%
Total $ 43,325,586 $ 43,411,843 $ 86,257 0.20%
• Denotes the 30 day SEC Yield Anualized
City of Atlantic Beach
FINANCIAL REPORT
March 2014
AGENDA ITEM# 4A
MAY 12,2014
Revenues
Annual YTD -50.00% YTD Dollar
Fund I (Footnote) Estimate of Estimate Actual Variance
General (1) $ 10,931,117 $ 5,465,559 $ 7,399,826 $ 1,934,268
Convention Development Tax 80,300 40,150 39,350 (800)
Local Option Gas Tax 421,009 210,505 211 ,484 980
Better Jax 1/2 Ct Sales Tax 694,870 347,435 358,518 11,083
Police Training, Forfeiture & Grants, etc. 110,041 55,021 50,887 (4, 134)
Grants (2) 75,000 37,500 7,641 (29,859)
Capital Projects (3) 495,000 247,500 206,665 (40,835)
Utility 8,611,203 4,305,602 4,085,494 (220,107)
Sanitation 1,789,000 894,500 903,524 9,024
Building Code Enforcement (4) 281,550 140,775 221,547 80,772
Storm Water 1 J 155,000 577,500 632,887 55,387
Pension-Police (5) 1,329,681 664,841 786,237 121,397
Pension -General (5)
Total $
2 190,980 1 095,490
28,164,751 $ 14,082,376
Analysis of Major Variances
(Variances >$25,000 AND 10.00%)
1,347,658 252,168
$ 16,251,718 $ 2,169,343
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:
(1) The positive variance in the General Fund is mostly due to the timing of property tax
receipts. The bulk of the receipts come in November and December.
(2) The city has not received expected grant monies from CDBG; therefore there is a
negative variance in Grants.
(3) The city has not received expected grant monies from the State of Florida nor the City
of Jacksonville; therefore there is a negative variance in Capital Projects.
(4) Building Code Enforcement permit activity is running above projected revenues,
similar to surrounding jurisdictions and counties.
(5) The $121,397 Bnd $252,168 positive variances in the Pension Fund-Police and
Pension Fund-General, respectively, resulted from changes in market values of the
investments of more than the anticipated amount.
Percent
Variance
35.39%
-1.99%
0.47%
3.19%
-7.51%
-79.62%
-16.50%
-5.11%
1.01%
57.38%
9.59%
18.26%
23.02%
15.40%
City of Atlantic Beach
FINANCIAL REPORT
March 2014
Expenses
Annual YTD-50.00% YTD Dollar
Department I (Footnote) Estimate of Estimate Actual Variance
Governing Body $ 42,933 $ 21,467 $ 20,278 $ 1,189
City Administration 2,647,727 1,323,864 1,249,329 74,535
General Government (1) 640,370 320,185 386,618 (66,433)
Planning and Building (2) 434,709 217,355 177,035 40,320
Public Safety (3) 5,692,612 2,846,306 2,007,794 838,512
Recreation and Special Events 396,901 198,451 175,976 22,475
Public Works (4) 7,877,621 3,938,811 2,601,777 1,337,033
Public Utilities (5) 10,793,308 5,396,654 4,599,895 796,759
Pension -Police 751,628 375,814 382,654 (6,840)
Pension -General (6) 852,850 426,425 496,385 (69,960)
Total $ 30,130,659 15,065,330 12,097,740 $2,967,589
Annual YTD-50.00% YTD Dollar
Resource Allocation Estimate of Estimate Actual Variance
Personnel Services (1,3) $ 9,541,493 $ 4,770,747 $ 4,317,888 $ 452,859
Operating Expenses (1-4) 10,734,003 5,367,002 4,275,886 1,091,115
Capital Outlay (1,4) 5,777,375 2,888,688 961,426 1,927,261
Debt Service (2,4) 2,448,768 1,224,384 1,728,028 (503,644)
Transfers
Total $
1,629,020 814,510
30,130,659 $ 15,065,330 $
Analysis of Major Variances
(Variances >$25,000 AND 10.00%)
814,512 (2)
12,097,740 $ 2,967,589
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:
(1) The negative variance in General Government resulted from the budget for insurance
premiums, other than health, and debt service being prorated over twelve months when
budgeted, but expensed when paid -insurance in October and SunTrust '99 debt
payoff in December.
(2) The positive variance in Planning and Building resulted from a vacant position for a
Redevelopment and Zoning Coordinator. The position has been vacant since the
beginning of the fiscal year.
(3) The positive variance in Public Safety was partially due to the budget proration
practice mentioned above -Fire contract with COJ is billed quarterly in arrears
(approximately $260,000 in January); and, lifeguard expenditures will appear
seasonally during April -September. The remaining variance is due to turnover/unfilled
positions in the Police Patrol and Crime Suppression divisions.
(4) The variance in the Public Works Department was due to: project activity budgeted
that has not been started/completed -see Project Activity schedule; only three
payments recorded to the trash hauler and fleet maintenance provider (October
payments for September activity were recorded in FY13 for year-end cut-off); 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.
(5) The positive variance in the Public Utilities Department Is due to budgeted project
activity that has not been started/completed.
(6) The negative variance in Pension -General resulted from a doubling from three to six
DROP participants with higher benefits.
AGENDA ITEM# 4A
MAY 12,2014
Percent
Variance
5.54%
5.63%
-20.75%
18.55%
29.46%
11.33%
33.95%
14.76%
-1.82%
-16.41%
19.70%
Percent
Variance
9.49%
20.33%
66.72%
-41.13%
0.00%
19.70%
AGENDA ITEM# 4A
City of Atlantic Beach MAY 12,2014
FINANCIAL REPORT
March 2014
Project Activity-Current Year Activity Only
Project YTD YTD
Project Name Number Budget Actual Balance Status
Public Safety:
Kennel Improvements PS1401 40,000 40,000 s
Life Guard Building Improvements PS1402 6,000 6,000 s
$ 46 000 $ $ 46 000
Public Utilities:
Reclaim Water Plant PU0805 1,352,858 210,297 1,142,561 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 10,280 10,280 8
Repair 24" Effluent Force Main PU1308 5,260 5,260 0 c
Repair 12" Force Main PU1309 3,363 3,363 0 c
Water Plant #2 Tank Rehabilitation PU1401 125,000 125,000 A
Water Plant #2 Rehabilitation GST PU1402 100,000 100,000 8
AC Main Sea Oats PU1403 390,000 390,000 R
lnline Valve Installations PU1404 50,000 50,000 I
Manhole Replace Saturiba PU1405 86,000 86,000 8
Sewer Rehabilitation Saturiba PU1406 27,264 27,264 8
Donner Subd Sewer Upgrade PU1407 155,000 155,000 E
Effluent Outfall Replacement PU1408 300,000 300,000 E
Effluent Pump at WWTP PU1409 50,000 50,000 I
Subtotal $2,767,076 $ 330,971 $ 2,436,105
Parks Maintenance:
Marsh Master Plan Signs PM1301 625 625 c
Rose Park Development PM1302 237,357 191,944 45,413 I
Russell Park Tennis Courts 1-2 PM1401 100,000 100,000 s
Bull Park Gazebo PM1402 X
Donner Park Ball field Improvements PM1403 75,000 103 74,897 8
Electric Gate at Dutton Island Park PM1404 8,000 I
Marsh Project Pedestrian Path PW1408 150,000 150,000 E
March Overlook and Kayak Launch PW1409 293,000 293,000 E
Marsh Preserve Path PHZ-1 PW1410 42,000 41,628 372 c
Subtotal $ 905,982 $ 234,300 $ 663,682
Public Works:
Dutton Isle Road Sidewalks PW1301 65,263 849 64,414 8
East Coast Drive Drainage Improvements PW1306 319,046 77 318,969 8
East Coast Drive Improvements PW1401 79,000 79,000 8
Fountain PW1402 7,500 7,500 E
Welcome Sign PW1403 11,000 5,579 5,421 E
Robert Street Ditch PW1404 50,000 50,000 E
Sidewalk and Curbs PW1405 25,000 25,000 I
Salt Air Drainage and Sidewalk Improvements PW1406 380,000 51 379,949 E
Seminole Road Improvements PW1407 490,000 54 489,946 E
Subtotal $1,426,809 $ 6,610 $ 1,420,199
Total $5,145,867 $ 571,880 $ 4,565,987
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