Item 4A- Monthly ReportsCity of Atlantic Beach
FINANCIAL REPORT
April 2016 AGENDA ITEM #4A
JUNE 13, 2016
Cash Balances
Prior Current Dollar Percent
Fund(s) 03/31/16 04/30/16 Change Change
General $ 9,401,973 $ 8,885,074 $ (516,899) -5.50%
Tree Replacement 26,470 26,470 0.00%
Convention Development Tax 115,189 107,556 (7,634) -6.63%
Local Option Gas Tax 304,626 326,658 22,033 7.23%
Better Jax 1/2 Cent Sales Tax 517,420 606,550 89,129 17.23%
Police Training, Forfeiture, Grants, etc. 108,510 129,555 21,044 19.39%
Capital Projects 3,034,812 3,088,792 53,980 1.78%
Utility 6,304,748 6,363,165 58,417 0.93%
Sanitation 453,015 461,474 8,458 1.87%
Building Code Enforcement 453,809 458,231 4,423 0.97%
Storm Water 1,748,783 1,760,847 12,064 0.69%
Pension -Police 138,831 143,312 4,481 0.00%
Pension -General 55,589 67,965 12,376 22.26%
Total $ 22,663,776 $ 22,425,649 $ (238,128) -1.05%
Total Restricted Cash 7,197,246
Total Unrestricted Cash $15,228,402
Cash and Investments
Prior Current Dollar Percent
Account 03/31/16 04/30/16 Change Change
Bank of America -Depository $ 6,820,113 $ 6,521,310 $ (298,803) -4.38%
Delaware Limited-Term Diversified Inc A 2,516,890 2,523,445 6,555 0.26%
Global X Gold Explorers ETF 4,161,309 4,188,064 26,755 0.64%
lnvesco Floating Rate A 720,477 737,571 17,094 2.37%
Voya Short Term Bond Fund Class A 4,179,734 4,189,925 10,191 0.24%
MSSB Money MarkeUCash 4,239,245 4,239,314 69 0.00%
SBA-Florida Prime 22,858 22,869 11 0.05%
Cash on Hand 3,150 3,150 0.00%
Subtotal $ 22,663,776 $ 22,425,649 $ (238,128) -1.05%
Police Pension Investments $ 8,856,909 $ 8,918,469 $ 61,560 0.70%
General Pension Investments 15,610,046 15,620,319 10,273 0.07%
Subtotal $ 24,466,955 $ 24,538,788 $ 71,833 0.29%
Total $ 47,130,730 $ 46,964,436 $ (166,295) -0.35%
City of Atlantic Beach
FINANCIAL REPORT AGENDA ITEM #4A
April 2016 JUNE 13, 2016
Revenues
Annual YTD YTD Dollar
Fund I (Footnote) Estimate Estimate Actual Variance
General $ 11,762,799 $ 6,861,386 $ 8,488,133 $
Convention Development Tax 96,307 56,168 60,037
Local Option Gas Tax 461,611 269,269 268,902
Better Jax 1/2 Ct Sales Tax 790,128 460,901 453,396
Police Training, Forfeiture & Grants 89,150 55,724 41,221
Grants-CDBG 650,000 379,162
Capital Projects 855,000 498,736 494,798
Utility 8,335,711 4,862,403 4,997,991
Sanitation 1,840,330 1,073,513 1 '153,669
Building Code Enforcement 439,134 256,137 303,849
Storm Water
Pension -Police
Pension -General
875,708 510,825 547,169
1,530,544 892,808 918,660
2,336,217 1,362,788 1,530,858
Total $ 30,062,639 $ 17,539,820 $ 19,258,683 $
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 $1,626,747. Most of this variance
is due to the timing of receipt of ad valorem taxes, the majority of which are received in
December.
1,626,747
3,869
(367)
{7,505)
(14,503)
(379, 162)
{3,938)
135,588
80,156
47,712
36,344
25,852
168,070
1,718,863
Grant Funds reflected a negative variance of $379,162, Grant revenue is reimbursement
based, revenue was billed in April and will be collected in May.
Percent
Variance
23.71%
6.89%
-0.14%
-1.63%
-26.03%
-100.00%
-0.79%
2.79%
7.47%
18.63%
7.11%
2.90%
12.33%
9.80%
AGENDA ITEM #4A
JUNE 13, 2016
City of Atlantic Beach
FINANCIAL REPORT
April2016
Expenses
Annual YTD YTD Dollar Percent
Department Estimate Estimate Actual Variance Variance
Governing Body $ 40,384 $ 23,534 $ 24,971 $ (1 ,437) -6.11%
City Administration 2,418,498 1,484,056 1,416,733 67,323 4.54%
General Government 5,115,740 3,173,485 670,833 2,502,652 78.86%
Planning and Building 1,337,724 825,009 468,578 356,431 43.20%
Public Safety 5,813,259 3,415,637 3,101,101 314,536 9.21%
Recreation and Beautification 1,286,900 871,583 871,601 (18) 0.00%
Public Works 5,368,085 3,231,417 2,308,051 923,366 28.57%
Public Utilities 10,070,138 5,991,106 4,544,250 1,446,856 24.15%
Pension -Police 621,607 362,565 350,229 12,336 3.40%
Pension -General 986,941 575,694 853,202 (277,508) -48.20%
Total $ 33,059,276 $ 19,954,086 $ 14,609,549 $ 5,344,537 26.78%
Annual YTD YTD Dollar Percent
Resource Allocation Estimate Estimate Actual Variance Variance
Personnel Services $ 10,198,510 $ 5,930,812 $ 5,493,371 $ 437,441 7.38%
Operating Expenses 11,089,341 6,687,459 5,417,182 1,270,277 18.99%
Capital Outlay 8,159,330 5,228,829 1,043,411 4,185,418 80.05%
Debt Service 1,964,401 1,145,872 1,683,485 (537,613) -46.92%
Grants and Aids 36,820 21,469 32,420 (10,951) -51.01%
Transfers 1,610,874 939,645 939,680 (35} 0.00%
Total $ 33,059,276 $ 19,954,086 $ 14,609,549 $ 5,344,537 26.78%
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 $2,502,652. 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 $356,431. 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 $314,536. 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 $923,366. 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 $1,446,856 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 $277,508 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,270,277. 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 $4,185,418. 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 $537,613; this was the result of the largest Public Utility debt service payment being
made in October.
City of Atlantic Beach
FINANCIAL REPORT AGENDA ITEM #4A Apri12016 JUNE 13, 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 $ 55,588 $ 8,636 $ 168,956 I
DONNER PK PLAYGRND LIGHTS PM1503 6,500 6,146 354 E
BULL PK PLAYGRND EQUIPMT PM1504 35,000 5,300 (0) 29,700 I
DUTION ISLE RD IMPROVMENT PM1505 25,000 7,386 17,234 380 E
NEW POLICE BLDG-DES/CONST PS1501 3,026,667 69,881 64,086 2,892,700
SAL TAIR/STURDIVAN SIDEWLK PW1406 32,090 2,080 2 30,008 I
SEMINOLE STREET SCAPE 1 PW1407 258,092 7,684 408 250,000 D
MARSH PROJECT PED PATH PW1408 56,504 12,075 44,429 1 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 820 427,340 111,840
Subtotal $ 4,309,376 $ 183,302 $ 562,135 $ 3,563,938
Planing, Zoning & Building
FRANCIS AVE DRAINAGE IMPR PW1502 650,000 82,060 556,037 11,903
Subtotal $ 650,000 $ 82,060 $ 556,037 $ 11,903
Public Works:
SEMINOLE STREET SCAPE 1 PW1407 $ 13,487 $ 12,807 $ 680 $ 0 D
SAL TAIR 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 2,625 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 320,000 64 319,936 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 -WTP 1, 2 &3 PU1602 48,000 552 (1) 47,449 A
CHLORINE AUTO CONTROL VAL PU1603 31,000 356 23,441 7,202 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 633 5,677 48,690 A
2 POINT REP. EFF GRAV ICW PU1610 30,000 30,000 E
PHORPHOROUS TREATMENT FAG 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 20,000 230 0 19,770 A
REPLACE EFF PUMP #2 PU1614 50,000 575 0 49,425 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 272 700,000 D
Subtotal $ 2,206,912 $ 172,126 $ 87,747 $ 1,947,038
Total $ 7,891,482 $ 454,296 $ 1,206,597 $ 6,230,589
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
City of Atlantic Be ach
M aj or Pu bli c Works Projects
FY 1 5/16 -Status 6/13/1 6
Proje ct Nam e Budget Project Activity N otes
Utilit ie s Projects
Effluent Outfall Replacement $320,000 Low bid exceeded amount budgeted. Jax Bch and This is r epl acement of the end of the beaches combined
Neptune Bch have agreed to split the additional effluent pipeline and is cost shared by the 3 beach Cities.
funding needed.
Atlantic Blvd Waterline Upgrade $100,000 Design only Wait ing on water model completion
Update Water System Model $30,000 Model built and calibrated. Consultant preparing Evaluating capital improvement requirements and impact if
and r unning and evaluating scenarios. Water Treatment Plant (WTP) #4 is removed from service .
Well logging-6 wells $130,000 Discussing scope with different consu ltant to This is a down hole check of t he structural integri ty of our
eliminate or reduce subconsultant layering. drinking water wells.
Replace Water Main on Semi nole Road $700,000 Design revisions underway-part of Seminole Fina lizing design revisions with stormwater and streetscape
from Atlantic Blvd to S-Way Road Streetscape project. com ponents of project.
WTP2 North Fence Rep lacement $10,000 Installation completed 4/7/16.
Rep l ace Seasp r ay water services $100,000 Project completed within budget.
Sewer Une rehab at Sea Oats $200,000 Received scope and cost for pipe lining; Involves lining of agi ng sewe r infrastructure to red uce water
coordinating manhole lining scop e and cost of inflow & infil tration (1&1).
SpectraShiel d
Phosphorus Treatment I mprovements $225,000 Pre liminary engi neering Report completed. 60% Received grant to offset portion of cost
at the Wastewater Treatment Plan t engineering design completed. Permitting
(WWTP) through FD EP and setting up temporary feed
system.
2 re pairs Gravity Outfall to ICW $30,000 Consultant preparing TV inspection review
assessment and maintenance p lan.
Combined Plant Renewal and $278,000 Addressing items sepa r ately in-house. Utility staff worki ng with vendors & purchasing.
Replacement
Soft Starts WTP 1,2,3 $10,000 Awaiting final quote from vendor.
Chlorine Auto Control $31,000 Equip. purchased -coordinating install date
Control Bubbler System $15,000 Awaiting shop drawing from vendor.
LS Control Panel $19,000 Under fabrication by supplier.
LS ABCD Softstarts $55,000 LS "8" softstart install in progress. Will evalua te prior to installing at other stations.
Replace Kruger Disks $6,000 On order.
New Influent Screens $20,000 In Purchasing.
Replace Eft Pump #2 $50,000 Commissioner Stinson investigating alternate equipment/suppliers.
Replace RAS Pump $50,000 Commissioner Stinson investigating alternate equipment/suppliers.
Replace Influent Pump $22,000 Awaiting results of hydraulic study. !Pump reqCJirements/specs may be updated.
Parks Projects
Russell Park Renovation $160,000 New swing set installed. Basketball lighting in Other improvements being planned for the racquetball court.
progress-equipment ordered by vendor. $50K grant to supplement funding
Scope/quotes & Schedule in progress for outfield
irrigating & sod.
Bull Pa rk Improvements $35,000 Replacement of playground fence in progress landscaping complete. New swing installed.
(Purchasing).
Twin Lake Parks Design $25,000 Re -evaluating task based on Commission direction Project revised; awaiting proposal for pond bank restoration.
and public input from community meeting. Appl ication for FIND grant funding not submitted this year.
Marsh Multipurpose Path -Dutton $540,000 Project started 5/9/16. $50% FIND Grant funded . Will overlay asphalt roadway
Island Path concur rently with Marsh Path project.
Veterans Park Play Set Replacement $40,000 Working with Vendors to select "ship" theme play Using COJ funding secured by Councilman Gulliford to
set. Vendors will be submitting final bids. supplement original budget for upgraded play set.
Public W o rk s Pr oj ects
Seminole Road Improvements $900,000 Consultant revising design to redirect stormwater Bidding late Summer.
from Saltair area and Howell Park up Seninole
Road.
Francis Avenue Drainage $650,000 $100% CDBG funding. Construction in progress.
Improvements Construction to be completed by the end of
August.
Beach Renourishment $0 Scheduled for summer of 2016 100% paid with Federa l and County funds
2016 Resurfacing Program $330,000 Milling & paving started 5/9/16. Anticipate 1 week for milling, 1 week for paving and 1 week for
striping and finishing.
~ern Bike Plaza $15,000 Installation by City forces in 1st quarter of 2016 Grading complete. Initial rack installation completed (3 racks).
near Lifeguard station. Monitoring to gauge usage/demand.
Atlantic Blvd Bike Plaza $50,000 Negotiating with property owner for location. Design not started.
Sherry Safe Route to School Sidewalk $0 8' sidewalk along Sherry & Seminole from Ahem Design & survey recently started. Town Hall meeting held on
to 17th Street. Design and construction funded by S/7 /16. Final path/plans TBD. Construction scheduled for
DOT. second hal f of 2017.
Police Building $2,892,700 Construction of new Polic Department building Police Department moved to WWTP week of May 23rd.
began