Item 4AAGENDA TEEM # 4A
JULY 27, 2009
O ~ •;
~ F U
•~ c ~
o cp ~, o b
d 8 ~ o E
E
~ ~
~
~23' ~c:.
~~ ~~ .~
.~ ~
'
W
w~°
- z~ "
c
'- A
cs
o a~ ~ °~'
~°
~ ~
~ . ¢' ~ ~ ~
~ ice ~ ~
~
. N
.~ o .b .~
0
~°~ °
' w^a ~ ~~'
t/j
°~ ~
bo
~ N ~ ~.
> ~-~ o.
R3 R
C. ~
~
ap v ~ ~~ ~ ¢
~ ~'
~
~
A ~ ~ °
w •
z ~ bo
UW c
W . .
0
U
a H
U
~ F
~
~
~
o ~
v
H ~ 3
x~ w
as W zq X23 ~ t j
D
Q ~
~
W 3
~
~
a,
z a
~
Q ~
z II p II
z w w
I x r~
I
H
o
a
°~
mo. w
QUU
°.
(~
,~ °. w
(~UU
~
a
H
z
o ~,
~
'~
u ~ o 0
23 ~ ° ~
w
U
~ ~,
pp ~ ~ '~ II
W II I
~
' ~
w ~ ~ ~o ~ y~oo
3 °' 0 0
°
Z ~ Q I I II
~ s I I
~ II
~ w ~ ,o .~ .o ~ ~' ~ .~o II o
w Q ~~ o c ~ o~ o ono
z w a~q ~ '-~ .~ ~q ~ ~ ~
v~
A
~
a >, .c ~ ~
o ~ .~ o '~ r., o
~ ~ ~ .~ ~' ~ ~
°' ~ o
3
xxwv H ~2w a ~
~~
A
~
N
M
AGENDA ITEM # 4A
NLY 27, 2009
City of Atlantic Beach, FI.
Utility Sales Report
June 2009 June 2008
Gallons Actual Revenue Gallons Actual Revenue
Water Sales Accounts 0000 Revenue Per 1,000 yi Accounts 0000 Revenue Per 1,000 9i
Atlantic Beach 5,589 42,625 $133,505 $3.13 5,631 50,102 $141,450 $2.82
Buccaneer 2,469 20,749 $75,003 $3.61 2,490 21,047 $67,070 $3.19
Total Water Sales 8,058 63,374 $208,508 $3.29 8,121 71,149 $208,520 $2.93
Gallons Gallons
Water Plant Production o000 0000
Atlantic Beach 53,094 57,475
Buccaneer 19,554 19,131
Total Production 72,648 76,606
Total Water Billed 63,374 71,149
Water Loss for month: 9,274 5,457
Percentage Loss 12.77% 7.12%
Total 12 mo. Avg. Loss 12.18% 12.83%
Gallons Actual Revenue Gallons Actual Revenue
Sealer S81eS Accounts 0000 Revenue Per 1,000 9i Accounts 0000 Revenue Per 1,000 yi
Atlantic Beach 5,122 34,690 $204,423 $5.89 5,131 37,537 $190,965 $5.09
Buccaneer 2,339 19,219 $146,411 $7.62 2,366 19,977 $131,382 $6.58
Total Sewer Sales 7,461 53,909 $350,834 $6.51 7,497 57,514 $322,347 $5.60
Gallons Actual Revenue Gallons Actual Revenue
Sewer Treatment 0000 Revenue Per 1,000 gi 0000 Revenue Per 1,000 gi
Atlantic Beach 60.349 $204,423 $3.39 40.895 $190,965 $4.67
Buccaneer 19.612 $146,411 $7.47 21.308 $131,382 $6.17
Total Sewer Treated 79.961 $350,834 $4.39 62.203 $322,347 $5.18
AGENDA ITEM # 4A
City of Atlantic Beach JuLV2~,2o09
FINANCIAL REPORT
JUNE 2009
Cash Balances
Fund(s)
Prior Current
05/31 /09 06/30/09
Dollar
Change
General $5,770,052 $5,610,191 ($159,861)
Tree Replacement 14,822 14,822 0
Convention Development Tax 2,825 13,689 10,864
Local Option Gas Tax 253,750 273,147 19,397
Better Jax 1/2 Cent Sales Tax 783,290 715,590 (67,700)
Police Training, Forfeit, etc. 208,243 211,120 2,877
Debt Service 58,431 57,432 (999)
Capital Projects 548,761 576,479 27,718
Utility 2,717,913 2,958,377 240,464
Sanitation 360,905 376,119 15,214
Building Code Enforcement 94,487 88,129 (6,358)
Storm Water 3,746,216 3,835,950 89,734
Pension -Police 48,119 35,176 (12,943)
Pension -General 40,656 59,915 19,259
Total $14,648,470 $14,826,136 $177,666
Total Restricted Cash $7,300,359
Total Unrestricted Cash $7,525,777
Cash and Investments
Prior Current Dollar Rate of
Account 05/31/09 6/30/09 Change Return
Bank of America -Depository $6,620,374 $6,788,619 $168,245 0.30
Bank of America -Certificate of Deposit 6,020,047 6,026,247 6,200 1.24
5th 3rd Bank -Certificate of Deposit 2,004,366 2,007,095 2,729 1.66
SBA 1,283 1,275 (8) 0.60
Cash on Hand 2,400 2,900 500 N/A
Subtotal 14,648,470 14,826,136 177,666
Police Pension Investments 4,882,378 4,892,884 10,506 3.51 (1)
General Pension Investments 8,067,385 8,078,231 10,846 3.46 (1)
Subtotal 12,949,763 12,971,115 21,352
Total $27,598,233 $27,797,251 $199,018
(1) FYTD rate of return through 03/31/09
City of Atlantic Beach
FINANCIAL REPORT
JUNE 2009
Revenues
AGENDA ITEM # 4A
JULY 27, 2009
Annual I YTD - 75% YTD Dollar Percent
Fund / (Footnote) Estimate of Estimate Actual Variance Variance
General (1) $10,391,868 $7,793,901 $8,765,834 $971,933 12.47%
Tree Replacement 0 0 4,914 4,914 100.00%
Convention Development Tax 85,000 63,750 47,176 (16,574) -26.00%
Local Option Gas Tax 496,872 372,654 342,909 (29,745) -7.98%
Better Jax 1/2 Ct Sales Tax 638,188 478,641 484,934 6,293 1.31
Police Training, Forfeit, etc. 40,150 30,113 25,685 (4,428) -14.70%
Grants 214,284 160,713 30,125 (130,588) -81.26%
Debt Service 69,500 52,125 51,491 (634) -1.22%
Capital Projects 335,000 251,250 248,279 (2,971) -1.18%
Utility (2) 9,398,075 7,048,556 5,448,567 (1,599,989) -22.70%
Sanitation 1,872,500 1,404,375 1,365,230 (39,145) -2.79%
Building Code Enforcement 207,500 155,625 154,359 (1,266) -0.81%
Storm Water (3) 2,374,600 1,780,950 2,349,017 568,067 31.90%
Pension -Police (4) 812,280 609,210 94,662 (514,548) -84.46%
Pension -General (4) 1,320,428 990,321 344,749 (645,572) -65.19%
Total $28,256,245
$19,757,931 ($1,434,253
Analysis of Major Variances
(1) The $971,933 positive variance in the General Fund resulted from having received 99%
of the budgeted amount of property taxes. Typically the majority of these taxes are
received from the City of Jacksonville in December & January.
(2) The $1,599,989 negative variance in the Utility Funds resulted from charges for services
$257,889 below projected year to date amounts and not having transferred the budgeted
amounts of $1,335,256 from the General Fund. These transfers will be executed as the
work progresses on the well replacement & TMDL projects.
(3) The $568,067 positive variance in the Stormwater Fund resulted from having received
the Florida Department of Environmental Protection grant monies in this fiscal year.
These revenues were budgeted & recognized in the prior fiscal year.
$21,192,184
(4) The $514,548 negative variance in the Police Employee Pension Fund & the $645,572
negative variance in the General Employee Pension Fund resulted from changes in
market values of the investments.
AGENDA ITEM # 4A
City of Atlantic Beach JULY 27, aoo9
FINANCIAL REPORT
JUNE 2009
Expenses
Annual YTD - 75% YTD Dollar Percent
Department / (Footnote) Estimate of Estimate Actual Variance Variance
Governing Body $48,076 $36,057 $31,126 $4,931 13.68%
City Administration 2,645,981 1,984,487 1,814,255 170,232 8.58%
General Government (1) 4,101,465 3,076,099 1,807,522 1,268,577 41.24%
Planning and Building 565,974 424,481 378,202 46,279 10.90%
Public Safety (2) 5,728,176 4,296,133 3,340,032 956,101 22.25%
Recreation and Special Events 455,619 341,714 309,430 32,284 9.45%
Public Works (3) 9,592,108 7,194,082 4,392,842 2,801,240 38.94%
Public Utilities (1) 9,349,931 7,012,449 5,886,833 1,125,616 16.05%
Pension -Police 451,236 338,427 372,702 (34,275) -10.13%
Pension -General 485,152 363,864 374,254 (10,390) -2.86%
Total $33,423,718 $25,067,793 $18,707,198 $6,360,595
Annual YTD - 75% YTD Dollar Percent
Resource Allocation Estimate of Estimate Actual Variance Variance
Personal Services $9,091,380 $6,818,536 $6,409,697 $408,839 6.00%
Operating Expenses (2) & (3) 10,247,118 7,685,342 6,568,890 1,116,452 14.53%
Capital Outlay (1 ), (2) & (3) 7,871,213 5,903,410 1,982,601 3,920,809 66.42%
Debt Service (4) 1,681,207 1,260,905 1,680,416 (419,511) -33.27%
Transfers (1) 4,532,800 3,399,600 2,065,594 1,334,006 39.24%
Total $33,423,718 $25,067,793 $18,707,198 $6,360,595
Analysis of Major Variances
(1) The positive variance in the General Government and Transfers resulted from not
having transferred the budgeted amounts to date from the General Fund to the Public
Utilities departments. These transfers will be executed as the work progresses on the
well replacement & TMDL projects in the Public Utilities departments -see Project
Activity Schedule.
(2) The positive variance in the Public Safety departments is due to the lifeguards season
just beginning, the payment being due quarterly to the City of Jacksonville for fire &
rescue services (the payment for January to March was paid in April, 2009); and the
Police Building project has had limited activity -see Project Activity Schedule.
(3) The positive variance in the Public Works departments resulted from only 8 of 9 monthly
payments have been paid on the Advanced Disposal Services Jax LLC contract, only 3%
of the budget for Park repairs and maintenance has been spent in the General Fund, only
46% of the budget for paving has been spent in the Local Option Gas Tax Fund, the
projects for the renovation of the City Parks has had limited activity and the Royal Palms
Stormwater project has not started -see Project Activity Schedule.
(4) The negative variance in the Debt Service accounts is due to the payment on interest
and principal on 10/01/08 and 12/01/08 and the payment of interest only on 04/01/09.
City of Atlantic Beach
FINANCIAL REPORT
JUNE 2009
Project Activity -Current Year Activity Only
AGENDA ITEM # 4A
JULY 27, 2009
Project YTD YTD YTD
Project Name Number Budget Actual Balance
Status
Public Safety
Police Building Renovation/Design/Construction
Public Utilities:
Replace Well #2 at Water Plant #1
TMDL Engineering
SCADA Improvements
Collection System Inspection & Rehabilitation
Reclaimed Water Plant Construction
Collection System Rehabilitation
Check Valve -Water Plant #1
Concrete to GRIT Container
New Well
Design TDML
TMDL -Lift Station Transfer Flow
Public Works:
Buckman Trust Property
Statue -Turtle
Cabinets for Donner
Gate at Dutton Island
Park Playground
Tennis Courts/Improvements/DonnerPark
Howell Park Bridge
Dune Crossover - 3rd Street Extnsion
Hopkins Creek Retention
Mayport Road Medians
Pedestrian Path Extensions
Sidewalks -George & Edgar Streets
Ardella Road Drainage Project
Royal Palms Design
Sidewalk/Pedestrian Path
Sidewalk & Curb
Royal Palms Stormwater Project
Status Kev
B -Bid Awarded
C -Project Completed
D -Design Completed
Subtotal
PS0504 660,000 4,738 655,262
PU0304 800,000 2,541 797,459
PU0706 84,005 84,005 0
PU0801 14,000 14,000 0
PU0802 183,939 183,938 1
PU0805 150,276 0 150,276
PU0901 349,597 349,593 4
PU0902 30,000 20,325 9,675
PU0903 18,708 18,428 280
PU0904 0 0 0
PU0905 710,000 50,639 659,361
PU0906 390,000 36,564 353,436
2,730,525 760,033 1,970,492
PM0804 191,000 190,410 590
PM0805 73,307 61,444 11,863
PM0901 2,000 0 2,000
PM0902 0 0 0
PM0903 45,000 42,109 2,891
PM0905 147,000 0 147,000
PM0906 15,000 14,850 150
PM0907 7,075 7,075 0
PW0309 1,110 1,110 0
PW0401 156,428 73,477 82,951
PW0802 0 0 0
PW0803 51,732 39,508 12,224
PW0807 33,753 33,904 (151)
PW0808 400,000 284,278 115,722
PW0901 0 0 0
PW0904 45,000 41,347 3,653
PW0905 2,810,000 0 2,810,000
Subtotal 3,978,405 789,512 3,188,893
Total $7,368,930 $1,554,283 $5,814,647
E -Design Phase
I -Project In-progress
R - Re-budget Next Fiscal Year
X -Project Cancelled
E
C
C