Item 4ACity of Atlantic Beach J~ ,~Y 5M oio
FINANCIAL REPORT
DECEMBER 2009
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.
Grants
Debt Service
Capital Projects
Utility
Sanitation
Building Code Enforcement
Storm Water
Pension -Police
Pension -General
Total
Total Restricted Cash
Total Unrestricted Cash
Prior Current Dollar
11/30/09 12/31/09 Change
$3,563,252
14, 822
25,670
210,988
656,313
181,511
(13,354)
86, 032
804,304
3, 561,137
512,665
48,083
3,994,875
18,214
61,011
$13,725,523
$5,498,617
18,741
36,080
207,155
619,361
179, 566
(13,354)
25,668
887,683
3,512,090
525,616
38,973
3,852,330
10,258
91,786
$15,490,570
$7,479,632
$1,935,365
3,919
10,410
(3,833)
(36,952)
(1,945)
0
(60,364)
83, 379
(49,047)
12,951
(9,110)
(142,545)
(7,956)
30,775
$1,765,047
$8,010,938
Cash and Investments
Prior
Account
11 /30109
Bank of America -Depository
5th 3rd Bank -Certificate of Deposit
SBA
Cash on Hand
Police Pension Investments
General Pension Investments
Subtotal
Subtotal
Total
$7,711,348
6,009,972
1,303
2,900
13,725,523
5,678,140
9,421,021
15,099,161
$28,824,684
Current
12/31 /09
Dollar
Change
Rate of
Return
$9,473,148
6,013,228
1, 294
2,900
15,490,570
5,763,721
9,558,198
15,321,919
$1,761,800
3,256
(9)
0
1,765,047
85, 581
137,177
222,758
$30,812,489 $1,987,805
0.30
0.65
0.21
N/A
20.82 (1)
21.56 (1)
(1) YTD rate of return through 09/30/09
City of Atlantic Beach
FINANCIAL REPORT
DECEMBER 2009
Revenues
AGENDA ITEM # 4A
JANUARY 25, 2010
Annual I YTD - 25% YTD Dollar Percent
Fund I (Footnote) Estimate of Estimate Actual Variance Variance
General (1) $11,796,728 $2,949,182 $5,132,506 $2,183,324 74.03%
Tree Replacement 0 0 3,920 3,920 100.00%
Convention Development Tax 80,500 20,125 16,039 (4,086) -20.30%
Local Option Gas Tax 455,764 113,941 115,288 1,347 1.18%
Better Jax 1/2 Ct Sales Tax 612,334 153,084 148,677 (4,407) -2.88%
Police Training, Forfeit, etc. 25,750 6,438 5,569 (869) -13.50%
Grants 116,296 29,074 63,844 34,770 119.59%
Debt Service 69,000 17,250 17,127 (123) -0.71%
Capital Projects 1,002,000 250,500 250,035 (465) -0.19%
Utility 13,484,898 3,371,225 1,896,425 (1,474,800) -43.75%
Sanitation 1,822,000 455,500 453,895 (1,605) -0.35%
Building Code Enforcement 308,050 77,013 56,436 (20,577) -26.72%
Storm Water 933,000 233,250 232,767 (483) -0.21
Pension -Police (3) 910,823 227,706 326,258 98,552 43.28%
Pension -General (3) 1,449,292 362,323 552,615 190,292 52.52%
Total $33,066,435 $8,266,611 $9,271,401 $1,004,790
Analysis of Major Variances
(1) The $2,183,324 positive variance in the General Fund resulted from having received
78% 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 $1,474,800 negative variance in the Utility Funds resulted from not having issued
the 2009 Revenue Notes. If the 2009 Revenue notes were not included in this
calculation, the variance would be less than negative 1 %.
(3) The $98,552 positive variance in the Police Employee Pension Fund & the $190,292
positive variance in the General Employee Pension Fund resulted from changes in
market values of the investments.
City of Atlantic Beach AGENDA ITEM # 4A
FINANCIAL REPORT JANUARY 25, Zolo
DECEMBER 2009
Expenses
Annual YTD - 25% YTD Dollar Percent
Department / (Footnote) Estimate of Estimate Actual Variance Variance
Governing Body $43,303 $10,826 $11,435 ($609) -5.63%
City Administration 2,532,025 633,000 605,632 27,368 4.32%
General Government 642,296 160,574 178,375 (17,801) -11.09%
Planning and Building 520,632 130,159 117,143 13,016 10.00%
Public Safety (1) 6,343,731 1,585,936 1,081,311 504,625 31.82%
Recreation and Special Events 387,063 96,766 117,393 (20,627) -21.32%
Public Works (2) 8,859,846 2,214,962 1,498,795 716,167 32.33%
Public Utilities (3) 13,894,380 3,473,596 2,670,497 803,099 23.12%
Pension -Police 519,506 129,877 127,839 2,038 1.57%
Pension -General 513,359 128 340 115,950 12,390 9.65%
Total $34,256,141 $8,564,036 $6,524,370 $2,039,666
Annual YTD - 25% YTD Dollar Percent
Resource Allocation Estimate of Estimate Actual Variance Variance
Personal Services $9,303,297 $2,325,825 $2,152,850 $172,975 7.44%
Operating Expenses 9,803,649 2,450,912 1,912,807 538,105 21.96%
Capital Outlay (1) - (3) 10,315,792 2,578,948 375,771 2,203,177 85.43%
Debt Service (4) 1,755,495 438,874 1,313,465 (874,591) -199.28%
Transfers 3,077,908 769,477 769,477 0 0.00%
Total $34,256,141 $8,564,036 $6,524,370 $2,039,666
Analysis of Major Variances
(1) The positive variance in the Public Safety department is partially due to the payment
being due quarterly to the City of Jacksonville for fire & rescue services. The next
payment is due in January 2010 for October through December 2009. Also, there are
vacant positions in the Police Patrol division 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 2 of 3 monthly
payments for this fiscal year have been paid on the Advanced Disposal Services Jax LLC
and First Vehicles contracts. Also, the Royal Palms Stormwater project has had limited
activity -see Project Activity Schedule.
(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
DECEMBER 2009
AGENDA ITEM # 4A
JANUARY 25, 2010
Project Activity -Current Year Activity Only
Project YTD YTD YTD
Project Name Number Budget Actual Balance Status
Public Safety
Lifeguard Building Roof Replacement
Police Building Renovation/Design/Construction
LG0901 2,979 0 2,979
PS0504 435,788 12,416 423,372
438,767 12,416 426,351
Public Utilities:
Replace Well at Water Plant #1
Reclaimed Water Plant Construction
TMDL - WWTP #1 Design
TMDL -Lift Station/Main Transfer Flow
Generator -Mimosa Cove Lift Station
Elevated Tank -Water Plant #1
Ground Storage Tank Rehab -Water Plant #1
Water Main -Ocean Boulevard/10th to 14th Street
Collection Syatem Inspection & Rehab
Mimosa Cove Lift Station Upgrades
Lift Station E Upgrades
Gavagan Lift Station
Camelia & West 3rd Street Lift Station
Schooner's Bay Lift Station
Stewart Street Lift Station
Selva Norte Lift Station
Hydroscreen Replacement
Concrete to GRIT Container
Subtotal
Public Works:
Riverbranch Preserve
Tennis Courts at Donner Community Center
Howell Park Bridge #5
Howell Park Bridge Replacement
Jordan Park -Drainage & Parking
Jordan Park -Water Fountain
Jordan Park -Covered Shelter
Roof at Donner Park Community Center
Royal Palms Design
Royal Palms Stormwater Project
Sidewalk -Dutton Island Road & Donner Park
Sidewalk/Curb Replacement - FY 2010
Manhole - Saturiba & Seminole Road
PU0304 794,675 0 794,675
PU0805 150,276 0 150,276
PU0905 549,625 40,379 509,246
PU0906 3,913,627 26,616 3,887,011
PU0907 31,518 31,518 0
PU 1001 15, 000 0 15, 000
PU1002 30,000 0 30,000
PU1003 84,000 0 84,000
PU1004 100,000 0 100,000
PU1005 160,000 0 160,000
PU1006 200,000 0 200,000
PU1007 4,500 0 4,500
PU1008 12,000 0 12,000
PU1009 17,000 0 17,000
PU1010 17,000 0 17,000
PU1011 4,500 0 4,500
PU1012 6,000 0 6,000
PU1013 25,000 0 25,000
6,114,721 98,513 6,016,208
PM0804 74,828 54 74,774
PM0905 4,912 4,912 0
PM0908 8,500 8,500 0
PM1001 20,000 0 20,000
PM1002 30,000 0 30,000
PM1003 5,000 0 5,000
PM1004 25,000 0 25,000
PM1005 50,000 0 50,000
PM 1006 10,172 0 10,172
PW0808 37,026 12,656 24,370
PW0905 3,162,257 228,540 2,933,717
PW1001 43,732 0 43,732
PW1002 25,000 578 24,422
PW1003 15,000 0 15,000
Subtotal 3,511,427 255,240 3,256,187
Total $10,064,915 $366,169 $9,698,746
Status Key
B -Bid Awarded E -Design Phase
C -Project Completed I -Project In-progress
D -Design Completed R - Re-budget Next Fiscal Year
I
E
E
E
E
C
E
I
C
C
I
AGENDA ITEM # 4A
JANUARY 25, 2010
City of Atlantic Beach, FI.
Utility Sales Report
December 2009
Water Sales
Atlantic Beach
Buccaneer
Total Water Sales
Gallons Actual Revenue
Accounts 0000 Revenue Per 1,00o gi
5,589 36,057 $135,073 $3.75
2,467 19,145 $84,572 $4.42
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
50,283
13, 305
63,588
55,202
8,386
13.19%
13.65%
December 2008
Gallons Actual Revenue
Accounts 0000 Revenue Per 1,000 gi
5,526 38,269 $121,424 $3.17
2,432 21,113 $75, 857 $3.59
7.958 59.382 5197.281 $3.32
Gallons
0000
53, 790
15,698
69,488
59,382
10,106
14.54%
12.71
Gallons Actual Revenue Gallons Actual Revenue
Accounts 0000 Revenue Per ~,ooo y~ Accounts 0000 Revenue Per 1,000 9i
5,121 30,132 $211,274 $7.01 5,112 32,170 $192, 932 $6.00
2,342 18,000 $158,490 $8.81 2,336 19,861 $150,096 $7.56
7.463 48.132 $369.764 57.68 7.448 52.031 5343.028 56.59
Gallons Actual Revenue
0000 Revenue Per 7,000 9i
Gallons Actual Revenue
0000 Revenue Per 1,000 9i
53.011 $211,274 $3.99 40.306 $192,932 $4.79
19.348 $158,490 $8.19 20.844 $150,096 $7.20
72.359 $369,764 $5.11 61.150 $343,028 $5.61
'
A
GEN -
DA IT -~
EM # 4~
i i
I i J ANU ARY 25, 2010
_
-- -- ~-~
-
r-
-
---1
--
-,
-
--
--
-
-
--
_
-~
_
~
. I
I I
_
i
~
~ -
~ I ~ ~
'
i O
O
W N
~,
M
i p
W
eta
~
M
M
D
W i N
t0i j l
1
z
p
~'
M
N
r
N
M
M
O r
N
O
i v ~ ! ~
w I ~ ~
w
, ~ w a
_ a ! ~ _
-
z O
z I J ~ r.
N'
~ i
!
O
N
N
J
V
O C
~
x
!
I ~ Q N ! N Z ~~.. m Q ~ ~ ~
I p '.
~- I I z° c.>
W ~
H ~ ~
y I
i d
~O 3
~
~ '
- - ~
-
- I
- j m
--- w
- a w
~ g
- a` W
z ~
Oa
I
0 11
0
0
0
0 t
0
o
W ~
o
o
,
o'
,
,
o
o - - -
,
~!
,
.I
.,
.
,j
o
,
o
(~',
'
~ ~
~.i 0
o 0
rl ~
ef~ ~
M ~ M
m O
N J
Q C
°o C
vo I
i O
o O
ti 1~
°m I
'
' M
a
M
~ ~ M
00
~ ~7
eF 1A
tC 1p
r
' 00
tC
1 ~O
I~
~ ~
z
~ M
N t!'
N <O
r i
' ~I ~ i ~ N
~ r
d'
~
O O
ON
N r O
t~ ~
9
r p
N r
M W
~
O r i i ~
!
~;
!
!
N
p
r
~
~
~
~
i
i
.
`
/
~I O
N
~ ~
W
~
i
I
i I
~ !
!
I
_ W ! ~ W' Z ~
V'
O
m
I
I i
d,
~
u
U
'
I
r
i
~
Q I W ~ ~ i > ~+ `A d, d, ~' . d, ~ d, ~ ~, ~, ~, ~„ ~„ ~, d, ~, d, d, d, ~ ~, u, ~, ~ ;~ a, w, !d, ~,
~
~ w 0 0 0 0 0 O
O
_
I
- --_1
J V
;w
0
O 0
o
{n 0
o
O 0
~
~O 0
~
O~ 0
~
r 0
~
N. =
'~
~ Z I ~ I
~ ~O~//~~
~V~
~ O
N o~
NM o°~
OD M
M V~i
N nN.
O M
N !Q
~
~
i
!
~
~
~
Z
N
O
p~
d'
t~
N
M
N
_
'
i
I
t - --
LL
W i
~-. 0
N O
r ~ O
O ~ O
1A O
W O
r ~
y ~ 0
1A O
tp O
1~ ~ O
O ~ . . . O!O
O O O
O
O r
~ ~i+
~
Z
I~ i I
~ (/)
V , r
i <O 00
I N
I ~7 r
N O M 01
N I
!
! t+ ~ Of
00 M
OD O
V'
N
I O t0
r r
: N O tD
M N
1n
r O ~ /
Y. _ iA d! to fA~ ~ iR W I i r r r
i i r
W I
V !
a i
~. ~
~ _
~ I I I
~ !W ~
i a !
I
(~
I
jam'
I V
;
-
'
H
- -
1 ~
_- H,
,
,
,
w
__ _
w
~r,
~
_ -
,
~
s
---
-
=
~
~,
I --
s
~-
,
i
~
u~
,
~s
i
w
I
~us
I
~,
~ius
w ~
-
Z ~ w
o
~ ~ ' I ~
~ ~
i I
~
' ~ ~
~ p t0
r I
~ ~
N ~
~I ~
Cr0 ~
I W
~' ~ ~
J ~ ' ~ ~ r r a ~
~ ~ ~ a ! ~ i ~ I~
~
~ - -- { W O r ~ O 'O 01 0 r r ~ O O r O N O O t0 O ler ~ ~'9~
LL
o 00
~ i
a ! N N i ~
I 0
W N
O
~
M
M0
( Z
I ~
m p e
N N I t
0
I
~ ~
r
r
i
i
!
~
'
Z
i
~
i
1
i I.
- ~ ~- - ~ - --~ ~ _
_i _. I 1 -- f-- ~ ~ - - ~ J
p ~
~ I
~
w
'~ ~
I w ~ ~ o
. O
N ~ I I ~ ! i Y
~
~
W
Z
~
~
W
I
~
~
i
~N
w
Z
I~
-
y
~
~
!
~
,
N
V'
i
Z
a i
'J
0~~
=~
~
i
' ~
a ~
~ p
p ?
~ >-
~ N
p p
p
~ ~
w ~
w
w z
o
-
~
~ ~ ~
J o~
~
a
~, O
o
a r
0
a
O'
s
°
z
~ a j ~ -- a o j ~ ~ ~ v W a c~ c
i z O ~
- lol
i~ J J D ~ W ! J J Op ~ M
Y W ~ ~ W LL fn
p (9 J N ~ m .= V Q t9 ~ WO l~!
~
W
H
Z
W
W t~
p - Z ~
W
O t~
J ~
J O
~ Z
p ~ p
Z
i f
W
W Z
a v~ p ~ O
v o rn ~
p ~ O
c~ p j
w F-
~ W
nc W
~ O
~ =
v~ d
c~ 3 v~ w a W
~ O
a ~ m $
cn ~
p3 p