Item 4A A CiI;N ll A 1'1'~M i1 4A
~ MA RC H 22, 2 010
i '~
~ I
I
I ~
~
~
~ ~
~ ---
- __ _ i --- - - _ - _
-
I ~ _
~-~
I~
--
_ ~
~ _
I
'
j ~
i ~
o
~N N
D i ~"~
M W
Z" ~ tD
tC ~
~O
~ 0
e- ~ ~ 0
~
~ ~ ~ ~„~ ~
i
'
W
__ - --
~ -
~ -
~ _ _ w - _ __ -_ - -
i -_ - -- --
~ - C ~ - -
~ U Q
~ ~ p N
~ J p
'QN
O ~
F- Q
O Q
V i Z I G>
i
I
~OD
~
aZ U
m
Q p
3 ,
w i
~ !
I
~
J
,J w _ o
L
d ~ I
i
~
' -
~- - -- - -
m
w
a
~
~
i
~
0 o
o 0
0 0
0 o
o
w
o°
OO
ii i
.;
.
~, ~
01
O
W ' ~ i
o
co
o
o
et
o~
v
~ ~ Q ~ O
~
~
N
M
O~1
N
Z a
~ o
N !
~
~ I, I I
I I
~ W
~
~
~;N
°
~
~ i
I
~i
_
~ ;~I~I I N m ~ I ! II ~ I
-- -- -- -
WI
~ f
-
~ ~~
~,m
o 0 0
~ 0 0 o u.
~
w
z
o O
O
o ~
..
~ O
o
0 ~
~ ~
~. ~ o ~ i
~~
(,~ ~
'A ~ ~
Z' ° ~°-
NM o ~
1A a
~ oMi
N ~ F-
' ~I
I i
I ~i
Z '
~
Q
0
~ I ~I O -
L ~
_._
-
__
_
_
-
-
- - -
1 - --I
t
~
O ~ ~j„i
Q ~ ~ ~ ~ . 0
0
' 0
0 . O
O . . O
O . . 0
0
'~ 0
0
O 0
0 00
00 .
M . . . . 0
0 010
0,0 O
0
~
/~
Z ~
Q
I
~ F
~ ~!
P
~ O
N
O> 0
et
N 0
O
Of
~ U
0
M
r OO
p>
P. r i
1~ O
~ M 0
O
r N O
1~ O
tt OD
1~
O!I
~
- 5 -
` F~
! ~
a'
V! ~
tA
19 ~
fA
~
fA
F t0 V'
i r
~
N
~ ~ I
~ M
e-
e=
N~
1A O ~ ~ ~i ~ i i j
li
W
~ O
V;a~
i~ i O
v ~ ' ~
-
~ ~
W
a (
~ i
~ _- - Hs us~w u>~ u~ wl ~ v, wus v~i__
~ i ~ N i ~,(,~ ~
~ ~ ~ ~ ~O O
N ~ 0001 ~ 0. i
~
TTT i
~
~ ~
w
a
---
~
--
-
- ~
0
0
N ~
~
0
10
0
0
~
O
O
r-
N
~
N
NOO
0
0
0 ~
0
0
l ~
~~li
~'
I
OW
d
N
M i
i
N~
I
~i
~ O
W NN
OM
N
~
I
If i
i i
Z ~ I
; ~
~ ' ~
i ~
~
~
'
~G
~ ~
N
i
N
i
I I
Z
-
--- ~
--~
J j
Q
__ _ i
-
~
--
- -
-
_
~
- -
~
~
~
--
~
- _ 1
~
+
~
-
-
r-
}
~
~_
i O
~ ' W
a' ~
~ ~ ~~
~i ~ I ~
O~
l N
I ~ O D ~ I
I W ~ w V ~ J O L
~ I ~ a ~ ~ ' ~ la z ~ ~ ~ I ~ ~ a~
i
~
_N
z ~
O
~
Q
~ °o~
i t_- ~ xw m __ '+- ~ w m o a c9 w ~ ~
zZ ~ ,
W~ z i
a 3F-
~ ~
i ~ J
~ C9 JO
a~ Zi
~ W
= J
O J
a O
~ rd
~ U~
Y
U W
U ~
-
J ~
Z ~
O tA
G O
~ M
J
~ ~
Z ~
U m~2
~ V
U
' Q
U'
- (~
Z ~
W ~'
~ W
~ QJ
C 0
a a
O
w
V
O
~
z
o
~
~
o Z
~
~ T
W
~ W
a
~ -
3
n- w ~
a
~a
~ -
a- W -
~ Z~
,
G
C v
i c
, a' i i w a i~ ~ o 3o
AGENDA ITEM # 4A
MARCH 22, 2010
City of Atlantic Beach, FI.
Utility Sales Report
February 2010
Water Sales
Atlantic Beach
Buccaneer
Total Water Sales
Gallons Actual Revenue
Accounts 0000 Revenue Per 1,000 gi
5,571 34,972 $123,985 $3.55
2,453 20,754 $84,522 $4.07
Water Plant Production
Atlantic Beach
Buccaneer
Total Production
Total Water Billed
Water Loss for month:
Percentage Loss
Total 12 mo. Avg. Loss
Sewer Sales
Atlantic Beach
Buccaneer
Total Sewer Sales
Sewer Treatment
Atlantic Beach
Buccaneer
Total Sewer Treated
Gallons
0000
43,290
15,677
58,967
55,726
3,241
5.50%
14.05%
February 2009
Gallons Actual Revenue
Accounts 0000 Revenue Per 1,000 yi
5,585 38,982 $125,588 $3.22
2,420 22,411 $81,110 $3.62
8.005 61.393 $206.698 X3.37
Gallons
0000
47, 569
13,537
61,106
61,393
-287
-0.47%
12.73%
Gallons Actual Revenue Gallons Actual Revenue
Accounts 0000 Revenue Per 1,000 gi Accounts 0000 Revenue Per 1,000 gi
5,105 30,593 $212,918 $6.96 5,115 32,531 $195,956 $6.02
2,327 19,463 $166,293 $8.54 2,300 19,449 $147,392 $7.58
____..7,432 50,056 $379,211 $7.58 7,415 51.980 5343.348 16.61
Gallons Actual Revenue
0000 Revenue Per 7,000 gi
43.896 $212,918 $4.85
16.420 $166,293 $10.13
Gallons Actual Revenue
0000 Revenue Per 7,00o gi
37.100 $195, 956 $5.28 ?
18.095 $147,392 $8.15
55.195 5343.348 56.22
City of Atlantic Beach AGENDA ITEM#4A
FINANCIAL REPORT M~cIIZZ,ZOIo
FEBRUARY 2010
Cash Balances
Fund(s)
General
Tree Replacement
Convention Development Tax
Local Option Gas Tax
Better Jax 1/2 Cent Sales Tax
Police Training, Forfeit, etc.
Community Development Block Grant
Debt Service
Capital Projects
Utility
Sanitation
Building Code Enforcement
Storm Water
Pension -Police
Pension -General
Total
Total Restricted Cash
Total Unrestricted Cash
Subtotal
Cash and Investments
Account
Subtotal
Bank of America -Depository
5th 3rd Bank -Certificate of Deposit
SBA -Florida Prime
Cash on Hand
Police Pension Investments
General Pension Investments
Prior Current
01 /31 /10 02/28/10
$5,458,141
18,741
36,079
203,173
583,663
177,161
(100)
31, 375
970,023
3,530,632
539,192
35,749
3,802,581
5,571
119,371
$15,511,352
Prior Current
01/31/10 02/28/10
$9,491,652
6,016,593
207
2,900
15,511,352
$9,608,276
6,019,961
220
2,900
15,631, 357
5,650,868
9,362,080
15,012,948
$5,544,289
18,741
35,431
199,245
564,398
176,179
(100)
37,083
1,052,896
3,584,265
528,916
41,240
3,700,425
916
147,433
$15,631,357
$7,525,937
Dollar
Change
$86,148
0
(648)
(3,928)
(19,265)
(982)
0
5,708
82,873
53,633
(10,276)
5,491
(102,156)
(4,655)
28, 062
$120,005
$8,105,420
5,745,338
9,504,718
15,250,056
Rate of
Return
0.30
0.65
0.20
N/A
4.00 (1)
3.83 (1)
Dollar
Change
$116,624
3, 368
13
0
120, 005
94,470
142,638
237.108
Total $30,524,300 $30,881,413 $357,113
(1) YTD rate of return through 12/31/09
City of Atlantic Beach
FINANCIAL REPORT
FEBRUARY 2010
Revenues
AGENDA ITEM # 4A
MARCH 22, 2010
Annual I YTD - 42% YTD Dollar Percent
Fund / (Footnote) Estimate of Estimate Actual Variance Variance
General (1) $11,796,728 $4,919,236 $6,768,028 $1,848,792 37.58%
Tree Replacement 0 0 3,920 3,920 100.00%
Convention Development Tax (2) 80,500 33,569 25,080 (8,489) -25.29%
Local Option Gas Tax 455,764 190,054 189,295 (759) -0.40%
Better Jax 1/2 Ct Sales Tax 612,334 255,343 260,380 5,037 1.97%
Police Training, Forfeit, etc. 25,750 10,738 9,936 (802) -7.47%
Community Development Block Grant 116,296 69,002 77,198 8,196 11.88%
Debt Service 69,000 28,773 28,542 (231) -0.80%
Capital Projects 1,002,000 417,834 416,649 (1,185) -0.28%
Utility (3) 13,484,898 5,623,203 3,591,161 (2,032,042) -36.14%
Sanitation 1,822,000 759,774 849,660 89,886 11.83%
Building Code Enforcement (4) 308,050 128,457 105,967 (22,490) -17.51
Storm Water 933,000 389,061 413,538 24,477 6.29%
Pension -Police 910,823 379,813 381,877 2,064 0.54%
Pension -General 1,449,292 604,355 638,284 33,929 5.61
Total $33,066,435 $13,809,212 $13,759,515
Analysis of Major Variances
(1) The $1,848,792 positive variance in the General Fund resulted from having received
87% of the budgeted amount of property taxes to date. Typically the majority of the
property taxes are received from the City of Jacksonville in December & January.
(2) The $8,489 negative variance in the Convention Development Tax Fund resulted from
the receipts being below projected amounts and not having received distributions from
the City of Jacksonville on a timely basis. The November, 2009 distribution was received
in February, 2010.
(3) The $2,032,042 negative variance in the Utility Funds resulted from not having issued
the 2009 Revenue Notes and not having received the funds from the SRF loan. If the
amounts to be financed were not included in this calculation, the variance would be a
positive 12.5%.
(4) The $22,490 negative variance in the Building Code Enforcement Fund resulted from
not having issued projected to date building permits. Typically October through February
are slow months for construction activity and the majority of the permits are anticipated to
be issued in the warmer months.
City of Atlantic Beach
FINANCIAL REPORT
FEBRUARY 2010
AGENDA ITEM # 4A
MARCH 22, 2010
Expenses
Department / (Footnote)
Annual YTD - 42% YTD Dollar Percent
Estimate of Estimate Actual Variance Variance
Governing Body $43,303 $18,056 $20,862 ($2,806) -15.54%
City Administration 2,532,025 1,055,854 1,024,190 31,664 3
00%
General Government 642,296 267,838 266,120 1,718 .
0.64%
Planning and Building 508,068 211,864 208,391 3,473 1
64%
Public Safety (1) 6,343,731 2,645,336 2,123,210 522,126 .
19.74%
Recreation and Special Events 387,063 161,405 171,594 (10,189) -6.31
Public Works (2) 8,916,675 3,718,254 2,676,935 1,041,319 28.01%
Public Utilities (3) 13,894,380 5,793,957 3,912,580 1,881,377 32.47%
Pension -Police 519,506 216,634 243,972 (27,338) -12.62%
Pension -General _ 513,359 214 071 228 290 (14 219) -6.64%
Total $34,300,406 $14,303,269 $10,876,144 $3,427,125
Annual YTD - 42% YTD Dollar Percent
Resource Allocation Estimate of Estimate Actual Variance Variance
Personal Services (1) $9,301,713 $3,878,814 $3,813,357 $65,457 1.69%
Operating Expenses (1) - (2) 9,795,135 4,084,571 3,568,944 515,627 12.62%
Capital Outlay (1) - (3) 10,370,155 4,324,355 897,915 3,426,440 79.24%
Debt Service (4) 1,755,495 732,041 1,313,465 (581,424) -79.43%
Transfers 3,077,908 1,283,488 1,282,463 1025 0.08%
Total $34,300,406 $14,303,269 $10,876,144 $3,427,125
Analysis of Major Variances
(1) The positive variance in the Public Safety department resulted from: vacant positions in
the Police Patrol and Detectives division, payments due quarterly on the Fire and Rescue
contract with the City of Jacksonville, seasonality of the Lifeguards and the Police Building
project has had limited activity -see Project Activity Schedule.
(2) The positive variance in the Public Works department resulted from only 4 of 5 monthly
payments for this fiscal year have been paid on the Advanced Disposal Services Jax LLC
contract. Also, the Royal Palms Stormwater and Park Improvement projects have had
limited activity -see Project Activity Schedule. The paving budgeted in the Local Option
Gas Tax Fund will not be expended until the Royaf Palms Stormwater project is
completed.
(3) The positive variance in the Public Utilities department resulted from limited activity on
the projects budgeted in the Sewer Fund -see Project Activity Schedule.
(4) The negative variance in the Debt Service accounts resulted from the semi-annual
payment of principal and interest on the Utility Revenue Bonds in October, 2009.
City of Atlantic Beach
FINANCIAL REPORT
FEBRUARY 2010
Project Activity -Current Year Activity Only
AGENDA ITEM # 4A
MARCH 22, 2010
Project YTD YTD YTD
Project Name Number Budget Actual Balance Status
Public Safety
Lifeguard Building Roof Replacement LG0901 2,979 0 2 979
Police Building Renovation/Design/Construction PS0504 435,788 18,068 417,720
438,767 18,068 420,699
Public Utilities:
Replace Well at Water Plant #1 PU0304 794,675 24,166 770,509
Reclaimed Water Plant Construction PU0805 150,276 0 150,276
TMDL - WWTP #1 Design PU0905 555,125 97,317 457,808
TMDL -Lift Station/Main Transfer Flow PU0906 3,847,296 43,302 3,803,994
Generator- Mimosa Cove Lift Station PU0907 31,518 31,518 0
Elevated Tank -Water Plant #1 PU1001 15,000 0 15,000
Ground Storage Tank Rehab -Water Plant #1 PU1002 30,000 0 30,000
Water Main -Ocean Boulevard/10th to 14th Street PU1003 150,331 21,422 128,909
Collection Syatem Inspection & Rehab PU1004 100,000 0 100,000
Mimosa Cove Lift Station Upgrades PU1005 160,000 0 160,000
Lift Station E Upgrades PU1006 200,000 0 200,000
Gavagan Lift Station PU1007 4,500 0 4,500
Camelia & West 3rd Street Lift Station PU1008 12,000 0 12,000
Schooner's Bay Lift Station PU1009 17,000 0 17,000
Stewart Street Lift Station PU1010 17,000 0 17,000
Selva Norte Lift Station PU1011 4,500 0 4,500
Hydroscreen Replacement PU1012 6,000 0 6,000
Concrete to GRIT Container PU1013 19,500 0 19,500
Subtotal 6,114,721 217,725 5,896,996
Public Works:
Riverbranch Preserve PM0804 74,828 54 74,774
Tennis Courts at Donner Community Center PM0905 13,354 4,912 8,442
Howell Park Bridge #5 PM0908 8,500 8,500 0
Howell Park Bridge Replacement PM1001 20,000 9,500 10,500
Jordan Park -Drainage & Parking PM1002 30,000 0 30,000
Jordan Park -Water Fountain PM1003 5,000 0 5,000
Jordan Park -Covered Shelter PM1004 25,000 0 25,000
Roof at Donner Park Community Center PM1005 50,000 0 50,000
Veteran's Park -Flag & Pavilion PM1006 10,172 4,776 5,396
Donner Park -Accessory Building PM1007 48,387 100 48,287
Royal Palms Design PW0808 37,026 22,338 14,688
Royal Palms Stormwater Project PW0905 3,162,257 437,540 2,724,717
Sidewalk -Dutton Island Road & Donner Park PW1001 43,732 0 43,732
Sidewalk/Curb Replacement - FY 2010 PW1002 25,000 578 24,422
Manhole - Saturiba & Seminole Road PW1003 15,000 0 15,000
Subtotal 3,568,256 488,298 3,079,958
Total $10,121,744 $724,091 $9,397,653
Status Kev
B -Bid Awarded I -Project In-progress
C -Project Completed N -Complete/Non-Ca pital
D -Design Completed R - Re-budget Next F iscal Year
E -Design Phase X -Project Cancelled
X
E
E
E
E
C
A
I
C
I
E
A