Item 4A Bldg Dept and Financial ReportsBUILDING DEPT. MONTHLY ACTIVITY REPORT
------
COMPARISON REPORT
-------···-···~--·
REPORT FOR THE MONTH JUNE 2015
-----
COMPARISON 2014-2015
-----
PERMIT TYPE ········=---·~ NUMBER OF PERMITS TOTAL INSPECTIONS
···--
YTD 2014 YTD 2015 YTD 2014 YTD 2015 YTD 2014
i~:=~no~s--~::f 1!! t . I:--~:::::! : ~· ..
COMMERCIAL NEW···········-··---+--~ 3 1 ==li ·-1~0 ... ~~'! . $ 950,000 -·--..
OTHER 1 ,321. . .... ._. 683 . $ 4,266,404 • $ 852,095 '
TOTAL .. ···-~f,"563 ............ 895 ] . --~ $ .... . . ~?.!405,50ill ----11"]72,580 ". . .... u • ?,~6~ ·---
PERMITS ISSUED FOR THE MONTH OF JUNE 2015
2,802
City of Atlantic Beach AGENDA ITEM #4A
FINANCIAL REPORT JULY 27,2015
June 2015
Cash Balances
Prior Current Dollar Percent
Fund(s) 05/31/15 06/30/15 Change Change
General $ 8,385,874 $ 8,101,080 $ (284,795) -3.40%
Tree Replacement 18,606 18,606 0.00%
Convention Development Tax 83,903 77,141 (6,762) -8.06%
Local Option Gas Tax 71,149 94,383 23,234 32.66%
Better Jax 1/2 Cent Sales Tax 641,011 641,396 385 0.06%
Police Training, Forfeiture, Grants, etc. 125,338 142,131 16,794 13.40%
Capital Projects 3,069,181 3,058,407 (10,774) -0.35%
Utility 4,962,925 5,316,563 353,638 7.13%
Sanitation 405,962 412,293 6,332 1.56%
Building Code Enforcement 343,944 373,171 29,227 8.50%
Storm Water 1,723,595 1,780,115 56,521 3.28%
Pension -Police 6,516 6,646 130 0.00%
Pension -General 76,414 73,991 {2,423} -3.17%
Total $ 19,914,417 $ 20,095,924 $ 181,507 0.91%
Total Restricted Cash 7,066,606
Total Unrestricted Cash $13,029,318
Cash and Investments
Annual Prior Current Dollar Percent
Account Yield 05/31/15 06/30/15 Change Change
Bank of America -Depository $ 3,956,563 $ 4,219,080 $ 262,517 6.63%
Alliance Limited Duration High Income A 2.94% * 1,221,639 1,213,712 (7,927) -0.65%
Delaware Diversified Inc. 2.79% * 2,527,441 2,490,326 (37,116} 0.00%
Guggenheim Floating Rate Strategies Fund 4.06% * 4,199,316 4,199,316 100.00%
lnvesco Floating Rate A 4.35% * 753,369 747,417 {5,951) -0.79%
Voya Floating Rate 4.01% 2,525,569 3,023,124 497,555 0.00%
Hartford Floating Rate Bond A 4.17% 1,558,277 4,198,050 2,639,772 169.40%
MainStay Short Term Duration High Yield A 3.64% 2,650,954 (2,650,954) -100.00%
Lord Abbett St Duration Inc A 2.50% 3,027,335 (3,027,335) -100.00%
Putnam Diversified Inc. 3.97% * 1,687,323 (1 ,687,323) -100.00%
MSSB Money MarkeUCash 2,462 2,462 0.00%
SBA -Florida Prime 334 334 0 0.02%
Cash on Hand 3,150 2,103 {1 ,047} -33.25%
Subtotal $ 19,914,417 $ 20,095,924 $ 181,507 0.91%
Police Pension Investments $ 8,928,684 $ 8,971,154 $ 42,470 0.48%
General Pension Investments 16,049,480 16,110,222 60,742 0.38%
Subtotal $ 24,978,164 $ 25,081,376 $ 103,212 0.41%
Total $ 44,892,580 $ 45,177,300 $ 284,719 0.63%
• Denotes the 30 day SEC Yield Anualized
AGENDA ITEM #4A
City of Atlantic Beach JULY 27,2015
FINANCIAL REPORT
June 2015
Revenues
Annual YTD YTD Dollar
Fund I (Footnote) Estimate Estimate Actual Variance
General $ 11,335,175 $ 8,499,681 $ 9,428,325 $ 928,644
Convention Development Tax 88,300 66,213 82,256 16,043
Local Option Gas Tax 435,909 326,925 333,866 6,941
Better Jax 1/2 Ct Sales Tax 714,864 536,139 580,037 43,898
Police Training, Forfeiture & Grants 99,954 74,453 65,922 (8,531)
Grants 91,386 68,535 (68,535)
Capital Projects 230,000 172,485 149,290 (23, 195)
Utility 8,303,752 6,227,739 6,448,265 220,526
Sanitation 2,123,709 1,552,424 1,697,973 145,549
Building Code Enforcement 446,000 334,476 328,645 (5,831)
Storm Water
Pension -Police
Pension -General
1,135,500 851,616 861,218 9,602
1,440,505 1,080,360 1,175,658 95,298
2,127,619 1,595,700 2,068,591 472,891
Total $ 28,572,673 $ 21,386,746 $ 23,220,046 $ 1,833,300
Analysis of Major Variances
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. Highlighted variance explanations
follow:
General Fund has a positive variance of $928,644. Most of the variance is due to the
timing of receipt of ad valorem taxes, the majority of which are received in late November
and December.
Utility Fund has a positive variance of $220,526. The positive variance is a result of
receiving grant reimbursement in current year for prior year expenditures.
Pension Funds reflect significant, year to date positive variances due to the increased
value of investments, $95,298 for Police Officers and $472,891 for General Employees.
Percent
Variance
10.93%
24.23%
2.12%
8.19%
-11.46%
-100.00%
-13.45%
3.54%
9.38%
-1.74%
1.13%
8.82%
29.64%
8.57%
City of Atlantic Beach AGENDA ITEM #4A
FINANCIAL REPORT
JULY 27,2015
June 2015
Expenses
Annual YTD YTD Dollar
Department Estimate Estimate Actual Variance
Governing Body $ 41,665 $ 31,212 $ 29,446 $ 1,766
City Administration 2,691,488 2,018,268 1,707,653 310,615
General Government 965,031 683,312 768,700 (85,388)
Planning and Building 493,820 370,206 340,474 29,732
Public Safety 8,440,668 6,329,507 4,040,049 2,289,458
Recreation and Special Events 364,353 273,168 261,511 11 ,657
Public Works 8,328,143 6,256,135 4,320,722 1,935,413
Public Utilities 9,263,936 7,432,201 5,103,595 2,328,606
Pension -Police 753,119 564,786 459,868 104,918
Pension -General 957,880 718,380 803,684 (85,304}
Total $ 32,300,103 24,677,175 17,835,702 $6,841,473
Annual YTD YTD Dollar
Resource Allocation Estimate Estimate Actual Variance
Personnel Services $ 9,722,574 $ 7,306,958 $ 6,723,027 $ 583,931
Operating Expenses 11,669,997 8,655,595 8,142,107 513,488
Capital Outlay 7,367,684 5,523,125 1,148,995 4,374,130
Debt Service 2,152,818 2,151,439 774,021 1,377,418
Grants and Aids 38,820 28,935 36,395 (7,460)
Transfers 1,348,210 1,011 '123 1,011,157 (34}
Total $ 32,300,103 $ 24,677,175 $ 17,835,702 $ 6,841,473
Analysis of Major Variances
In general, the major variances are a result of timing differences created between the percentage of budget
elapsed-to-date and actual expenditures. Highlighted variance explanations follow:
Public Safety reflected a $2,289,458 positive variance due primarily to the timing of capital expenditures
related to the new Public Safety building.
Public Works had a positive variance of $1,935,413. Most of the variance is the result of project activity
budgeted that has not been started/completed-see Project Activity Schedule.
Public Utilities had a positive variance of $2,328,606. Most of the variance is the result of project activity
budgeted that has not been started/completed-see Project Activity Schedule.
Capital Outlay had a positive variance of $4,374,130. Most of the capital and project expenditures occur
in the middle to latter part of the fiscal year.
Debt Service reflects a significant variance of $1,377,418. The budgeted principal and interest
payments for October of this year were paid on September 30, 2014.
Percent
Variance
5.66%
15.39%
-12.50%
8.03%
36.17%
4.27%
30.94%
31.33%
18.58%
-11.87%
27.72%
Percent
Variance
7.99%
5.93%
79.20%
64.02%
-25.78%
0.00%
27.72%
City of Atlantic Beach AGENDA ITEM #4A
FINANCIAL REPORT JULY 27, 2015
June 2015
Project Activity-Current Year Activity Only
Project YTD YTD
Project Name Number Budget Actual Encumbrances Balance Status
Public Safety:
Design & Construct New Police Building PS1501 2,600,000 27,465 166,490 2,406,045 E
$2,600,000 $ 27,465 $ 166,490 $ 2,406,045
Public Utilities:
Reclaim Water Facility PU0805 135,399 127,431 7,968 0 c
PT Repair at Lift Station C PU1306 6,500 6,500 c
lnline Valve Installation PU1404 36,515 19,651 16,599 265 I
Effluent Outfall Replacement PU1408 11,625 11,624 1 I
Effluent Pump at WWTP PU1409 14,478 14,478 0 I
Connect A1A at Mallard Cove PU1410 126,662 6,024 96,598 24,039 I
Well Logging -6 Wells PU1501 s
Update Models PU1502 48,000 11,838 35,191 971 E
Replace WM on Seminole Rd 5-Way to Atlantic Blvd PU1503 700,000 700,000 E
Replace Effluent Outfall Line-Sherman Point (Cost Share) PU1504 320,000 320,000 I
Lining of Wetwell at Mimosa Cove Lift Station PU1505 19,505 5,550 13,954 1 c
Lining of Wetwell at Fairway Villas Lift Station PU1506 20,341 6,200 14,141 0 c
Clean and Televise Effluent Gravity Outfall to ICW PU1507 15,218 15,218 I
Fence/Wall at WWTP PU1508 80,000 80,000 s
Replace Irrigation System With Reuse System PU1509 20,000 4,240 1,710 14,051 s
Subtotal $ 1,554,243 $ 201,912 $ 213,003 $ 1 '139,328
Parks Maintenance:
Rose Park Development PM1302 5,276 5,293 (17) c
Russell Park Tennis Courts 1-2 PM1401 98,136 98,136 0 c
Electric Gate at Dutton Island Park PM1404 4,466 4,272 194 c
Russell Park Renovation PM1501 250,000 850 2,934 246,216 A
Howell Park Parking Lot lmprovemens PM1502 15,000 15,000 s
Donner Park Playground Lights PM1503 10,000 10,000 s
Bull Park Playground Equipment & Swing PM1504 75,000 74,300 649 51 c
Dutton Island Road Improvements PM1505 25,000 25,000 s
Marsh Project Pedestrian Path PW1408 97,220 35,155 62,065 0 E
March Overlook & Kayak Launch PW1409 310,000 1,700 29,505 278,795 B
Subtotal $ 890,098 $ 219,706 $ 95,153 $ 575,240
Public Works:
Robert Street Ditch PW1404 14,213 14,212 c
Salt Air/Sturdivant Drainage and Sidewalk lmprovmts PW1406 132,700 44,753 87,947 N
Seminole Streetscape PW1407 316,660 8,957 57,702 250,002 E
Saltair Drainage Improvements PW1411 250,000 86,066 163,934 I
South End of Seminole Road Drainage CIP PW1412 650,000 650,000 E
Batting Cage Mat I Russell Park PW1416 10,966 10,966 c
Bike Racks & Street Lights PW1501 16,252 2,740 6,789 6,723 B
Francis Avenue Drainage Improvements (CDBG) PW1502 94,200 45,115 49,584 (499) I
Begonia Street W 6th to W 9th -Design Only PW1503 30,000 30,000 c
City Hall Parking Lot Lighting -Last Section PW1504 10,000 9,554 446 B
Subtotal $ 1,524,991 $ 198,597 $ 389,722 $ 936,672
Total $ 6,569,332 $ 647,679 $ 864,367 $ 5,057,286
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