Item 4A - PW Project Status and Financial ReportCi ty of Atla ntic Bea ch
Major Publ ic Works Proj e cts
FY15/16 -Stat us 12/1/15
Proj ect Na me Budget Pr oject Acti vity N otes
Utili t ies
Effluent Outfall Replacement Design complete . DEP & ACOE permits received. This is replacement of the end of the beaches combined
$320,000 Awaiting permit from Coast Guard effluent pipeline and is shared by the 3 beach Cities
Atlantic Blvd Waterline Upgrade $100,000 Design only Waiting on water model completion
Update Water System Model
$30,000 Initial model built. Calibration has started.
Well Logging -6 wells Not started
This is a down hole check of the structural
$130,000 integrity of our drinking water wells.
Replace Water Main on Seminole Rd. Design underway -part of Seminole Road Design 95% complete
From Atlantic Blvd. to S-Way $700,000 Streetscape project
WTP2 North Fence Replacement $10,000 Pricing
Replace Seaspray water services Work needed because of recurring line breaks and
$100,000 Formal bids due 12/2 accompanying outages
Sewer Line rehab Sea Oats $200,000 Not started Potential grant may supplement
Phosphorus treatment Improvements Received grant to offset portion of cost.
WWTP Preliminary engineering Report completed.
$225,000 Contracting for engineering design underway.
2 repairs Gravity Outfall to ICW $30,000 Not started
Combined Plant Renewal and Packaging and bidding for potential economy. Contracting for engineering support underway.
replacement S27&,ooo Completed fee negotiation for consultant
Soft Starts WTP 1,2,3 support.
Chlorine AutoControl $10,000
Control Bubbler System $31,000
L5 Control Panel $15,000
L5 ABCD Softstarts $19,000
Replace Kruger Disks $55,000
2 new Influent Screens $6,000
Repl Eff Pump ##2 $20,000
Repl RAS Pump $50,000
Replace Influent Pump $50,000
$22,000
Parks Projects
Russell Park Renovation $160,000 Swing set to be installed 12/7 Other improvements being planned. Grant may supplement
funding
Bull Park Improvements $35,000 Pricing fence & swing Landscaping underway
Twin lake Parks Des ign $25,000 Design only Concept options design started
Marsh Multipurpose Path $540,000 ACOE permitting for wetland mitigation $50% FIND Grant funded. 95% design complete
underway. Working MOU with COJ .
Vet Park Playset Replacement $40,000 Pricing
Pub lic Works Projects
Semino le Road Improvements $900,000 Design 95% complete Bidding in Spring
Francis Avenue Drainage $650,000 $100% CDBG funding. Received CDBG Contract Anticipate start of construction about 1/2/16.
Improvements 11/20
Beach Renouri shment $0 Scheduled for summer of 2016 100% paid with Federal and Co unty funds
2016 Resurfacing Program $330,000 Borings complete. Contracti ng for construction Will include resurfscing of Seminole from Plaza to cui d e sac.
Construction 1st quarter of 2016
Ahern Bike Plaza $15,000 Installation by City forces in 1st quarter of 2016 Bike racks re ceived.
near lifeguard station.
Atlantic Blvd Bike Plaza $50,000 Negotiating with property owner for location. Design not started.
She r ry Safe Route to School Sidewalk $0 8' sidewalk a long Sherry & Seminole from Ahern Design & survey recently started. Neighborhood meeting
to 17th . Design and construction f u nded by DOT . sched uled for 1st quarter of 2016. Construction scheduled for
second half of 2017.
Police Building $2,892,700 Permitting Construction pricing to start in December
City of Atlantic Beach AGENDA ITEM# 4A
FINANCIAL REPORT DECEMBER 14,2015
October 2015
Cash Balances
Prior Current Dollar Percent
Fund(s) 09/30/15 10/30/15 Change Change
General $ 7,072,487 $ 7,176,015 $ 103,528 1.46%
Tree Replacement 18,955 18,955 (0) 0.00%
Convention Development Tax 103,297 104,319 1,022 0.99%
Local Option Gas Tax 170,386 194,994 24,608 14.44%
Better Jax 1/2 Cent Sales Tax 574,510 574,510 (0) 0.00%
Police Training, Forfeiture, Grants, etc. 138,947 127,281 (11,666) -8.40%
Capital Projects 2,738,086 2,764,336 26,250 0.96%
Utility 6,150,832 6,368,338 217,506 3.54%
Sanitation 398,424 414,977 16,553 4.15%
Building Code Enforcement 405,228 405,228 (0) 0.00%
Storm Water 1,786,912 1,786,912 0 0.00%
Pension -Police 68,610 13,943 (54,667) 0.00%
Pension -General 68,974 68,974 (0} 0.00%
Total $ 19,695,649 $ 20,018,782 $ 323,133 1.64%
Total Restricted Cash 7,280,532
Total Unrestricted Cash $12,738,250
Cash and Investments
Prior Current Dollar Percent
Account 09/30/15 10/30/15 Change Change
Bank of America -Depository $ 3,919,567 $ 4,230,511 $ 310,944 7.93%
Alliance Limited Duration High Income A 1 '189,005 (1,189,005) -100.00%
Delaware Diversified Inc. 2,483,596 (2,483,596) -100.00%
Delaware Limited-Term Diversified Inc A 2,488,868 2,488,868 #DIV/0!
Guggenheim Floating Rate Strategies Fund 4,165,322 ( 4,165,322) -100.00%
Global X Gold Explorers ETF 4,168,445 4,168,445 #DIV/0!
lnvesco Floating Rate A 727,801 727,863 62 0.01%
Voya Floating Rate 4,166,004 (4,166,004) -100.00%
Voya Short Term Bond Fund Class A 4,167,119 4,167,119 #DIV/0!
Lord Abbett St Duration Inc A 3,011,218 (3,011 ,218) -100.00%
MSSB Money Market/Cash 7,168 4,232,821 4,225,653 58949.74%
SBA -Florida Prime 22,817 5 (22,812) -99.98%
Cash on Hand 3,150 3,150 0.00%
Subtotal $ 19,695,649 $ 20,018,782 $ 323,133 1.64%
Police Pension Investments $ 8,783,271 $ 8,794,768 $ 11,497 0.13%
General Pension Investments 14 934,592 15,616 407 681 814 4.57%
Subtotal $ 23,717,864 $ 24,411,175 $ 693,311 2.92%
Total $ 43,413,512 $ 44,429,957 $ 1,016,445 2.34%
AGENDA ITEM# 4A
City of Atlantic Beach DECEMBER 14, 2015
FINANCIAL REPORT
October 2015
Revenues
Annual YTD YTD Dollar Percent
Fund I (Footnote) Estimate Estimate Actual Variance
General $ 11,762,799 $ 980,198 $ 752,432 $
Convention Development Tax 96,307 8,024 8,939
Local Option Gas Tax 461,611 38,467 40,441
Better Jax 1/2 Ct Sales Tax 790,128 65,843 55,432
Police Training, Forfeiture & Grants 89,150 7,427 1,528
Grants 650,000 54,166
Capital Projects 855,000 71,248 47,083
Utility 8,335,711 694,629 657,032
Sanitation 1,840,330 153,359 164,129
Building Code Enforcement 439,134 36,591 35,100
Storm Water
Pension -Police
Pension -General
875,708 72,975 72,216
1,530,544 127,544 440,808
2,336,217 194,684 799,965
Total $ 30,062,639 $ 2,505,155 $ 3,075,105 $
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 decrease of $227,766. Most of this decrease is due
to the timing of receipt of ad valorem taxes, the majority of which are received in late
November and December, and the quarterly reimbursement by COJ for lifeguard/beach
maintenance and mutual aid assistance. These decreases were partially offset by local
business tax receipts; and timing of the receipt of the annual County allocation of business
tax receipts; and the annual 10% true-up of the prior year's JEA franchise fees.
Pension Funds reflected significant, positive variances this month, $313,264 and
$605,281, respectively, from the increased value of investments.
(227,766)
915
1,974
(10,411)
(5,899)
(54, 166)
(24,165)
(37,597)
10,770
(1 ,491)
(759)
313,264
605,281
569,950
Variance
-23.24%
11.40%
5.13%
-15.81%
-79.43%
-100.00%
-33.92%
-5.41%
7.02%
-4.07%
-1.04%
245.61%
310.90%
22.75%
AGENDA ITEM# 4A
City of Atlantic Beach DECEMBER 14, 2015
FINANCIAL REPORT
October 2015
Expenses
Annual YTD YTD Dollar
Department Estimate Estimate Actual Variance
Governing Body $ 40,384 $ 3,362 $ 2,958 $ 404
City Administration 2,544,554 212,008 212,451 (443)
General Government 587,118 48,909 28,555 20,354
Planning and Building 607,232 50,586 38,628 11,958
Public Safety 9,414,454 784,486 420,052 364,434
Recreation and Special Events 574,568 31 '161 26,908 4,253
Public Works 8,491,734 707,581 229,733 477,848
Public Utilities 10,277,628 856,408 380,852 475,556
Pension -Police 621,607 51,795 55,851 (4,056)
Pension -General 986,941 82,242 307,331 (225,089}
Total $ 34,146,220 2,828,538 1,703,319 $1,125,219
Annual YTD YTD Dollar
Resource Allocation Estimate Estimate Actual Variance
Personnel Services $ 10,198,510 $ 849,765 $ 738,241 $ 111,524
Operating Expenses 11,380,871 948,265 754,154 194,111
Capital Outlay 8,954,744 729,510 76,686 652,824
Debt Service 1,964,401 163,696 1,276,444 (1,112,748)
Grants and Aids 36,820 3,067 3,067
Transfers 1,610,874 134,235 134,238 (3}
Total $ 34,146,220 $ 2,828,538 $ 2,979,763 $ (151,225)
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 $364,434 positive variance due primarily to the timing of capital expenditures
related to the new Public Safety building.
Public Works had a positive variance of $477,848. 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 $475,556. 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 $225,089 variance for the period. In October, a payout of
$207,381.11 was made to the estate of Marcia G. Baker.
Capital Outlay had a positive variance of $652,824. Most of the capital and project expenditures occur in
the middle to latter part of the fiscal year.
Debt Service reflects a negative variance of $1,112,748, this was the result of the largest annual debt
payment being made in October.
Percent
Variance
12.02%
-0.21%
41.62%
23.64%
46.46%
13.65%
67.53%
55.53%
-7.83%
-273.69%
39.78%
Percent
Variance
13.12%
20.47%
89.49%
-679.76%
100.00%
0.00%
-5.35%
AGENDA ITEM# 4A
City of Atlantic Beach DECEMBER 14, 2015
FINANCIAL REPORT
October 2015
Project Activity-Current Year Activity Only
Project YTD YTD
Project Name Number Budget Actual Encumbrances Balance Status
Public Safety:
NEW POLICE BLDG-DES/CONST PS1501 3,026,667 133,967 2,892,700
$ 3,026,667 $ $ 133,967 $ 2,892,700
Public Utilities:
INLINE VALVE INSTALLATION PU1404 16,355 16,355 (0) 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 23,442 I
EFF OUTFALL@ SHERMAN PT PU1504 320,000 320,000 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 10,000 E
SOFT STARTS -WTP1, 2 &3 PU1602 48,000 48,000 A
CHLORINE AUTO CONTROL VAL PU1603 31,000 31,000 A
CONTROL BUBBLER SYSTEM PU1604 15,000 15,000 A
REPLACE SEASPRAY H20 SERV PU1605 100,000 100,000 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 19,000 A
SOFTSTARTS LIFT ST. ABC&D PU1609 55,000 55,000 A
2 POINT REP. EFF GRAV ICW PU1610 30,000 30,000 E
PHORPHOROUSTREATMENTFAC PU1611 225,000 225,000 I
REPLACE DISKS KRUGER DISF PU1612 6,000 6,000 A
INFLUENT SCREENS (2) PU1613 20,000 20,000 A
REPLACE EFF PUMP #2 PU1614 50,000 50,000 A
REPLACE RAS PUMP & MOTOR PU1615 50,000 50,000 A
REPLAC INFLUENT PUMP WWTP PU1616 22,000 22,000 A
Subtotal $ 1,501,517 $ $ 70,517 $ 1,431,000
Parks Maintenance:
RUSSELL PK RENOVATION PM1501 233,180 72,642 160,538 I
DONNER PK PLAYGRND LIGHTS PM1503 6,500 6,500 E
BULL PK PLAYGRND EQUIPMT PM1504 35,000 (0) 35,000 I
DUTTON ISLE RD IMPROVMENT PM1505 25,000 25,000 E
Subtotal $ 299,680 $ $ 79,142 $ 220,538
Public Works:
SALTAIRISTURDIVAN SIDEWLK PW1406 32,090 2,080 30,010 0 I
SEMINOLE STREET SCAPE PW1407 976,974 26,973 950,001 D
Marsh Project Ped Path PW1408 56,504 56,504 1 I
SALTAIR DRAINAGE UPGRADE PW1411 61,707 4,000 57,706 1 I
SE SEMINOLE RD DRAIN IMPR PW1412 650,000 650,000 D
BIKE RACKS & STREET LIGHT PW1501 6,789 6,789 I
FRANCIS AVE DRAINAGE IMPR PW1502 650,000 650,000 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
Subtotal $ 2,523,618 $ 12,869 $ 180,747 $ 2,330,002
Total $ 7,351,482 $ 12,869 $ 464,373 $ 6,874,240
Status Key
A -Bid/RFP Advertised I -Project In-progress
8 -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