Item 4A Recreation And Finance Report 7-2016Eve & Facilities
Featured Events In July Songwriters' Concert, Art Walk Re ce ption, Acou stic
Ni ght w/ Food Truck, Intracoastal Pa dd le Tours
Time Facility Rentals
Events/Permits
Contract Programs
Upcomlns Events & Prosrams
In August
Songwriters'
••sign up
II of
AGENDA ITEM 4A
AUGUST 22, 2016
regi stration s/ II of II of parti ci pants/
It of staff/ vo l,
co mm ittee
atte nd ed occurre nces atte nd ees
AGENDA ITEM 4A
City of Atlantic Beach AUGUST 22, 2016
FINANCIAL REPORT
July 2016
Cash Balances
Prior Current Dollar Percent
Fund(s) 06/30/16 07/31/16 Change Change
General $ 7,526,251 $ 7,550,158 $ 23,908 0.32%
Tree Replacement 26,470 27,792 1,322 5.00%
Convention Development Tax 119,923 112,006 (7,917) -6.60%
Local Option Gas Tax 371,965 198,448 (173,517) -46.65%
Better Jax 1/2 Cent Sales Tax 670,696 612,051 (58,645) -8.74%
Police Training, Forfeiture, Grants, etc. 136,097 129,703 (6,394) -4.70%
Capital Projects 3,740,460 3,360,257 (380,203) -10.16%
Utility 6,777,992 7,003,452 225,460 3.33%
Sanitation 588,302 684,554 96,252 16.36%
Building Code Enforcement 472,489 480,734 8,245 1.75%
Storm Water 1,819,856 1,838,468 18,612 1.02%
Pension -Police 160,203 174,005 13,802 0.00%
Pension -General 102,368 121,205 18,837 18.40%
Total $ 22,513,074 $ 22,292,834 $ (220,239) -0.98%
Total Restricted Cash 7,281,179
Total Unrestricted Cash $15,011,655
Cash and Investments
Prior Current Dollar Percent
Account 06/30/16 07/31/16 Change Change
Bank of America-Depository $ 6,520,084 $ 6,234,680 $ (285,404) -4.38%
Delaware Limited-Term Diversified Inc A 2,543,334 2,552,832 9,498 0.37%
Global X Gold Explorers ETF 4,227,101 4,264,121 37,020 0.88%
lnvesco Floating Rate A 743,204 756,274 13,070 1.76%
Voya Short Term Bond Fund Class A 4,213,851 4,219,344 5,492 0.13%
MSSB Money MarkeUCash 4,239,456 4,239,528 72 0.00%
SBA-Florida Prime 22,893 22,905 12 0.05%
Cash on Hand 3,150 3,150 0.00%
Subtotal $ 22,513,074 $ 22,292,834 $ (220,240) -0.98%
Police Pension Investments $ 9,021,261 $ 9,029,470 $ 8,210 0.09%
General Pension Investments 15,819,253 15,820,058 805 0.01%
Subtotal $ 24,840,513 $ 24,849,528 $ 9,015 0.04%
Total $ 47,353,586 $ 47,142,362 $ (211,225) -0.45%
AGENDA ITEM 4A
City of Atlantic Beach AUGUST 22,2016
FINANCIAL REPORT
July 2016
Revenues
Annual YTD YTD Dollar
Fund I (Footnote) Estimate Estimate Actual Variance
General $ 11,762,799 $ 9,801,980 $ 10,639,355 $ 837,375
Convention Development Tax 96,307 80,240 88,238 7,998
Local Option Gas Tax 461,611 384,670 386,149 1,479
Better Jax 1/2 Ct Sales Tax 790,128 658,430 663,064 4,634
Police Training, Forfeiture & Grants 89,150 82,496 80,522 (1,974)
Grants -CDBG 650,000 541,660 79,144 (462,516)
Capital Projects 855,000 1,057,660 1,224,239 166,579
Utility 8,335,711 6,946,290 7,289,845 343,555
Sanitation 1,840,330 1,533,590 1,617,474 83,884
Building Code Enforcement 439,134 365,910 418,877 52,967
Storm Water 875,708 729,750 773,421 43,671
Pension -Police 1,530,544 1,275,440 1,214,303 (61 '137)
Pension -General 2,336,217 1,946,840 2,031,870 85,030
Total $ 30,062,639 $ 25,404,956 $ 26,506,501 $ 1,101,545
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 revenues show a net positive variance of $837,375. Most of this variance is
due to the timing of receipt of ad valorem taxes, the majority of which are received in
December.
Grant Funds reflected a negative variance of $462,516, Grant revenue is reimbursement
based, reimbursements #2 and #3 were submitted in July.
Capital Project Fund reflected a positive variance of $166,579. This variance is a result of
a mid year budget modification and subsequent transfer of funding to the Public Safety
Building Project.
Utility Fund reflected a positive variance of $343,555. Majority of this variance is system
development charges equaling $374,311 year to date, compared to an adjusted budget
equaling $100,040.
Percent
Variance
8.54%
9.97%
0.38%
0.70%
-2.39%
-85.39%
15.75%
4.95%
5.47%
14.48%
5.98%
-4.79%
4.37%
4.34%
AGENDA ITEM 4A
AUGUST 22, 2016
City of Atlantic Beach
FINANCIAL REPORT
July 2016
Expenses
Annual YTD YTD Dollar Percent
Department Estimate Estimate Actual Variance Variance
Governing Body $ 40,384 $ 33,620 $ 36,329 $ (2,709) -8.06%
City Administration 2,418,498 2,157,580 2,010,951 146,629 6.80%
General Government 5,115,740 5,454,031 2,039,313 3,414,718 62.61%
Planning and Building 1,337,724 1 '193,934 747,840 446,094 37.36%
Public Safety 5,813,259 4,884,306 4,403,948 480,358 9.83%
Recreation and Beautification 1,286,900 1,252,932 1 '125,528 127,404 10.17%
Public Works 5,368,085 4,616,310 3,472,135 1,144,175 24.79%
Public Utilities 10,070,138 8,556,580 6,068,508 2,488,072 29.08%
Pension -Police 621,607 517,950 503,947 14,003 2.70%
Pension -General 986,941 822,420 1 '1 03,528 (281,108) -34.18%
Total $ 33,059,276 $ 29,489,663 $ 21,512,027 $ 7,977,636 27.05%
Annual YTD YTD Dollar Percent
Resource Allocation Estimate Estimate Actual Variance Variance
Personnel Services $ 10,198,510 $ 8,434,567 $ 7,815,170 $ 619,397 7.34%
Operating Expenses 11,089,341 9,630,055 8,036,861 1,593,194 16.54%
Capital Outlay 8,159,330 7,839,761 1,742,305 6,097,456 77.78%
Debt Service 1 ,964,401 1,636,960 1,964,401 (327,441) -20.00%
Grants and Aids 36,820 30,670 35,590 (4,920) -16.04%
Transfers 1,610,874 1,917,650 1,917,700 {50} 0.00%
Total $ 33,059,276 $ 29,489,663 $ 21,512,027 $ 7,977,636 27.05%
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:
General Government had a positive variance of $3,414,718. Most of the variance is the result of the Capital Project Fund-Public
Safety Building, Francis Ave Drainage and Marsh Preserve Path projects-see Project Activity Schedule.
Planning and Building had a positive variance of $446,094. Most of the variance is the result of the Francis Ave Drainage
Improvement Project (CDBG Grant)-see Project Activity Schedule.
Public Safety had a positive variance of $480,358. Majority of the variance consists of positive variances in Salaries, City of
Jacksonville Fire Contract that is billed quarterly and Lifeguard Salaries that expense in the summer.
Public Works had a positive variance of $1,144,175. 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 $2,488,072 variance for the period. Most of the variance is the result of project activity budgeted that
has not been started/completed -see Project Activity Schedule
Pension-General shows a negative $281,108 variance for the period. In October, a large payout of $207,381.11 was made to a
former employee's beneficiary.
Operating Expenses had a positive variance of $1,593,194. Various contractual services contribute to this balance. The largest
contracts are the Fire Contract (COJ), Sanitation Contract, and Road Paving.
Capital Outlay had a positive variance of $6,097,456. Most of the capital and project expenditures occur in the middle to latter part of
the fiscal year-see Project Activity Schedule.
Debt Service reflects a negative variance of $327,441; this was the result of the largest Public Utility debt service payment being
made in October.
City of Atlantic Beach AGENDA ITEM 4A
FINANCIAL REPORT AUGUST 22, 2016
July 2016
Project Activity-Current Year Activity Only
Project YTD YTD
Project Name Number Budget Actual Encumbrances Balance Status
General Government
RUSSELL PK RENOVATION PM1501 $ 233,180 $ 61,844 $ 5,725 $ 165,611 I
DONNER PK PLAYGRND LIGHTS PM1503 6,500 6,146 354 E
BULL PK PLAYGRND EQUIPMT PM1504 35,000 5,300 10,739 18,961 I
DUTTON ISLE RD IMPROVMENT PM1505 25,000 7,386 17,234 380 E
NEW POLICE BLDG-DES/CONST PS1501 3,601,967 342,026 3,259,941
SAL TAIR/STURDIVAN SIDEWLK PW1406 32,090 2,080 2 30,008 I
SEMINOLE STREET SCAPE 1 PW1407 258,092 7,684 11,383 239,025 D
MARSH PROJECT PED PATH PW1408 56,504 12,075 36,537 7,893 I
BIKE RACKS & STREET LIGHT PW1501 6,789 6,789 I
CH PARK LOT LIGHTS-LAST PW1504 9,554 9,554 (0) I
TOWNCENTER IMPR DECK & BR PW1601 40,000 40,000 E
VET PARK PLAYSET PW1602 40,000 40,000 E
MARSH PRESERVE PATH PHZ-1 PW1603 540,000 230,902 228,758 80,340
Subtotal $4,884,676 $ 691,786 $ 3,570,318 $ 622,572
Planing, Zoning & Building
FRANCIS AVE DRAINAGE IMPR PW1502 650,000 207,772 430,325 11,903
Subtotal $ 650,000 $ 207,772 $ 430,325 $ 11,903
Public Works:
SEMINOLE STREET SCAPE 1 PW1407 $ 13,487 $ 12,807 $ 680 $ 0 D
SALTAIR DRAINAGE UPGRADE PW1411 61,707 4,000 (2) 57,709 I
SE SEMINOLE RD DRAIN IMPR PW1412 650,000 650,000 D
Subtotal $ 725,194 $ 16,807 $ 678 $ 707,709
Public Utilities:
INLINE VALVE INSTALLATION PU1404 $ 16,355 $ 16,253 $ $ 102 D
EFFLUENT OUTFALL REPLCMT PU1408 2,625 3,653 (1,028) I
WELL LOGGING-6 WELLS PU1501 130,000 130,000 s
UPDATE MODELS PU1502 23,442 16,831 6,611 I
EFF OUTFALL@ SHERMAN PT PU1504 559,404 64 532,764 26,577 I
WETWLL LINE-MIM COVE LS PU1505 13,954 13,954 (0) I
WETWELL LINE-FAIRWAY V LS PU1506 14,141 14,141 0 I
NORTH FENCE REPLACE WTP2 PU1601 10,000 9,295 705 E
SOFT STARTS -WTP1, 2 &3 PU1602 48,000 552 31,856 15,591 A
CHLORINE AUTO CONTROL VAL PU1603 31,000 2,476 23,441 5,083 A
CONTROL BUBBLER SYSTEM PU1604 15,000 172 14,828 A
REPLACE SEASPRAY H20 SERV PU1605 100,000 97,339 2,661 A
ATLANTIC WATER MAIN REPLA PU1606 100,000 100,000 E
SEWER SYSTEM REHAB SEAOAT PU1607 200,000 200,000 E
CONTROL PANEL LIFT STA WW PU1608 19,000 218 13,853 4,929 A
SOFTSTARTS LIFT ST. ABC&D PU1609 55,000 6,310 13,821 34,869 A
2 POINT REP. EFF GRAV ICW PU1610 30,000 30,000 E
PHORPHOROUSTREATMENTFAC PU1611 225,000 17,658 7,174 200,167 I
REPLACE DISKS KRUGER DISF PU1612 6,000 5,999 1 A
INFLUENT SCREENS (2) PU1613 27,373 230 27,142 1 A
REPLACE EFF PUMP #2 PU1614 42,627 575 0 42,052 A
REPLACE RAS PUMP & MOTOR PU1615 50,000 575 49,425 A
REPLAC INFLUENT PUMP WWTP PU1616 22,000 253 21,747 A
SEMINOLE STREET SCAPE 1 PW1407 705,395 5,123 11,247 689,025 D
Subtotal $ 2,446,316 $ 211,671 $ 666,881 $ 1,567,764
Total $8,706,186 $ 1,128,036 $ 4,668,202 $ 2,909,949
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
1-Seminole Road Street Scape Project totals $976,974