Item 4ACity of Atlantic Beach AG~~i 20 ~4A
FINANCIAL REPORT
MARCH 2009
Cash Balances
Prior Current Dollar
Fund(s) 02/28/09 03/31/09 Change
General $6,627,163 $6,362,897 ($264,266)
Tree Replacement 33,693 15,518 (18,175)
Convention Development Tax 212,243 216,590 4,347
Local Option Gas Tax 232,738 245,244 12,506
Better Jax 1/2 Cent Sales Tax 782,507 777,728 (4,779)
Police Training, Forfeit, etc. 207,935 207,479 (456)
Debt Service 41,255 46,977 5,722
Capital Projects 470,482 498,123 27,641
Utility 2,619,333 2,747,722 128,389
Sanitation 311,386 339,346 27,960
Building Code Enforcement 124,427 107,107 (17,320)
Storm Water 3,161,619 3,591,673 430,054
Pension -Police 11,475 19,560 8,085
Pension -General 140,709 201,194 60,485
Total $14,976,965 $15,377,158 $400,193
Total Restricted Cash $7,426,022
Total Unrestricted Cash $7,951,136
Cash and Investments
Prior Current Dollar Rate of
Account 02/28/09 3/31/09 Change Return
Bank of America -Depository $8,972,225 $9,366,022 $393,797 0.27
Bank of America -Certificate of Deposit 6,001,033 6,007,440 6,407 1.24
SBA 1,307 1,296 (11) 0.86
Cash on Hand 2,400 2,400 0 N/A
Subtotal 14,976,965 15,377,158 400,193
Police Pension Investments 4,207,771 4,435,021 227,250 (12.20) (1)
General Pension Investments 6,676,868 7,035,019 358,151 (11.99) (1)
Subtotal 10,884,639 11,470,040 585,401
Total $25,861,604 $26,847,198 $985,594
(1) FYTD rate of return through 12/31/08
City of Atlantic Beach
FINANCIAL REPORT
MARCH 2009
Revenues
AGENDA ITEM # 4A
APRIL 27, 2009
Annual I YTD - 50% YTD Dollar Percent
Fund / (Footnote) Estimate of Estimate Actual Variance Variance
General (1) $10,431,720 $5,215,860 $6,606,089 $1,390,229 26.65%
Tree Replacement 0 0 3,510 3,510 100.00%
Convention Development Tax 85,000 42,500 30,596 (11,904) -28.01%
Local Option Gas Tax 496,872 248,436 225,401 (23,035) -9.27%
Better Jax 1/2 Ct Sales Tax 690,130 345,065 326,881 (18,184) -5.27%
Police Training, Forfeit, etc. 40,150 20,075 13,497 (6,578) -32.77%
Grants 214,284 107,142 30,125 (77,017) -71.88%
Debt Service 69,500 34,750 34,305 (445) -1.28%
Capital Projects 335,000 167,500 165,185 (2,315) -1.38%
Utility 7,498,075 3,749,038 3,578,866 (170,172) -4.54%
Sanitation 1,872,500 936,250 910,211 (26,039) -2.78%
Building Code Enforcement 207,500 103,750 105,943 2,193 2.11%
Storm Water (2) 2,374,600 1,187,300 1,754,062 566,762 47.74%
Water/Sewer Construction (3) 1,310,000 655,000 0 (655,000) -100.00%
Pension -Police (4) 812,280 406,140 (507,053) (913,193) -224.85%
Pension -General (4) 1,320,428 660,214 695,884 1,356,098 -205.40%
Total $27,758,039 $13,879,020 $12,581,734 ($1,297,286)
Analysis of Major Variances
(1) The $1,390,229 positive variance in the General Fund resulted from having received
86% 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 $566,762 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.
(3) The $655,000 negative variance in the Water & Sewer Construction Fund resulted
from not having issued the 2009 Revenue Notes.
(4) The $913,193 negative variance in the Police Employee Pension Fund & the
$1,356,098 negative variance in the General Employee Pension Fund resulted from
changes in market values of the investments.
City of Atlantic Beach
FINANCIAL REPORT
MARCH 2009
AGENDA ITEM # 4A
APRIL 27, 2009
Expenses
Annual YTD - 50% YTD Dollar Percent
Department / (Footnote) Estimate of Estimate Actual Variance Variance
Governing Body $48,076 $24,038 $20,622 $3,416 14.21
City Administration 2,645,981 1,322,991 1,245,049 77,942 5.89%
General Government 2,013,465 1,006,734 1,041,661 (34,927) -3.47%
Planning and Building 573,374 286,687 260,033 26,654 9.30%
Public Safety (1) 5,726,441 2,863,222 2,056,374 806,848 28.18%
Recreation and Special Events 455,619 227,810 220,550 7,260 3.19%
Public Works (2) 9,675,308 4,837,657 2,779,594 2,058,063 42.54%
Public Utilities 8,759,931 4,379,966 4,200,181 179,785 4.10%
Pension -Police 451,236 225,618 244,491 (18,873) -8.37%
Pension -General 485,152 242,576 235,554 7,022 2.89%
Total $30,834,583 $15,417,299 $12,304,109 $3,113,190
Annual YTD - 50% YTD Dollar Percent
Resource Allocation Estimate of Estimate Actual Variance Variance
Personal Services $9,091,380 $4,545,690 $4,250,202 $295,488 6.50%
Operating Expenses (1) & (2) 10,299,593 5,149,803 4,335,758 814,045 15.81%
Capital Outlay (1) & (2) 7,134,603 3,567,302 1,104,423 2,462,879 69.04%
Debt Service (3) 1,681,207 840,604 1,299,826 (459,222) -54.63%
Transfers 2,627,800 1,313,900 1,313,900 0 0.00%
Total $30,834,583 $15,417,299 $12,304,109 $3,113,190
Analysis of Major Variances
(1) The positive variance in the Public Safety departments is due to vacant positions in the
Police Administrative, Police Patrol & Police Dispatch divisions having been recently filled;
the payment being due quarterly to the City of Jacksonville for fire & rescue services (the
payment for October through December 2008 was paid in January, 2009); and the Police
Building project has not begun -see Project Activity Schedule.
(2) The positive variance in the Public Works departments resulted from only 5 of 6 monthly
payments have been paid on the Advanced Disposal Services Jax LLC and First Vehicle
contracts; only 16% of the budget for paving has been spent in the Local Option Gas Tax
Fund and the projects for the renovation of the City Parks have not started. -see Project
Activity Schedule.
(3) 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 AGENDA ITEM # 4A
FINANCIAL REPORT Arlul.a~,aoo9
MARCH 2009
Project Activity -Current Year Activity Only
Project YTD YTD YTD
Project Name Number Budget Actual Balance Status
Public Safety
Police Building Renovation/Design/Construction PS0504 660,000 0 660,000
Public Utilities:
Replace Well #2 at Water Plant #1 PU0304 210,000 0 210,000
TMDL Engineering PU0706 84,005 79,356 4,649
SCADA Improvements PU0801 14,000 0 14,000
Collection System Inspection & Rehabilitation PU0802 183,939 183,938 1
Reclaimed Water Plant Construction PU0805 150,276 0 150,276
Collection System Rehabilitation PU0901 349,597 347,806 1,791
Check Valve -Water Plant #1 PU0902 30,000 20,325 9,675
Concrete to GRIT Container PU0903 18,708 18,428 280
New Well PU0904 0 0 0
Design TDML PU0905 710,000 0 710,000
TMDL -Lift Station Transfer Flow PU0906 390,000 0 390,000
Subtotal 2,140,525 .649,853 1,490,672
Public Works:
Statue -Turtle PM0805 73,307 20,700 52,607
Cabinets for Donner PM0901 2,000 0 2,000
Gate at Dutton Island PM0902 0 0 0
Park Playground PM0903 45,000 0 45,000
Tennis Courts/Improvements/DonnerPark PM0905 147,000 0 147,000
Howell Park Bridge PM0906 50,000 0 50,000
Hopkins Creek Retention PW0309 1,110 1,110 0
Mayport Road Medians PW0401 156,428 11,089 145,339
Pedestrian Path Extensions PW0802 0 0 0
Sidewalks -George & Edgar Streets PW0803 51,732 0 51,732
Ardella Road Drainage Project PW0807 33,753 33,904 (151)
Royal Palms Design PW0808 400,000 94,952 305,048
Sidewalk/Pedestrian Path PW0901 8,200 0 8,200
Sidewalk & Curb PW0904 50,000 20,368 29,632
Royal Palms Stormwater Project PW0905 2,810,000 0 2,810,000
Subtotal 3,828,530 182,123 3,646,407
Total $6,629,055 $831,976 $5,797,079
Status Key
B -Bid Awarded
C -Project Completed
D -Design Completed
E -Design Phase
I -Project In-progress
R - Re-budget Next Fiscal Year
X -Project Cancelled
E
E
E
I
C
E
I
C
C
X
X
C
I
X
C
E
AGENDA ITEM # 4A
APRIL 27, 2009
City of Atlantic Beach, FI.
Utility Sales Report
March 2009
Water Sales
Atlantic Beach
Buccaneer
Total Water Sales
Gallons Actual Revenue
Accounts 0000 Revenue Per 1,000 si
5,591 34,934 $114,495 $3.28
2,437 20,093 $74,932 $3.73
Water Plant Production
Atlantic Beach
Buccaneer
Total Production
Total Water Billed
Water Loss for month:
Percentage Loss
Total 12 mo. Avg. Loss
1 Sewer Sales
Atlantic Beach
Buccaneer
Total Sewer Sales
f Sewer Treatment
Atlantic Beach
Buccaneer
Total Sewer Treated
Gallons
0000
61,345
9,367
70,712
55,027
15,885
22.18%
12.98%
March 2008
Gallons Actual Revenue
Accounts 0000 Revenue Per 1,000 gi
5,616 37,298 $105,638 $2.83
2,474 19,426 $63,619 $3.27
Gallons
0000
53,124
17,168
70,292
56,724
13,588
19.30%
12.83%
Gallons Actual Revenue Gallons Actual Revenue
Accounts 0000 Revenue Per ~,oo0 9i Accounts 0000 Revenue Per 1,000 gl
5,122 29,636 $184,015 $6.21 5,106 30,621 $164,799 $5.38
2,312 18,874 $144,908 $7.68 2,350 18,461 $125,622 $6.80
7,434 48.510 $328.923 $8.78 7.456 49.082 5290.421 $5.92
Gallons Actual Revenue
0000 Revenue Per 7,000 gl
Gallons Actual Revenue
0000 Revenue Per 1,000 9i
44.186 $184,015 $4.16 45.032 $164,799 $3.66
19.187 $144,908 $7.55 21.522 $125,622 $5.84
83.373 5328.923 55.19 66.554 5290.421 54.36
AGENDA ITEM # 4A
APRIL 27, 2009
H I I
1
I 1
I I
I 1
w I I
I I
I 1
(ll I I
I
I I
I I
I 1
I 1
I
I I
I I
I I
I 1
1
I 1
I I
I 1
I I
I I
I 1
I I
~ ~
r
n
C
H
H
o
01
o
H
M
H
a
H
'
'-i
r
M
~
D
I ~ I
I I N
~0 O
H H r d' N O O H lfl
I w I N N r O~ O M M M
I ~
I r
I
I z I
I O I I
r I
~ I
N I
~
l I
~
l I
a'
H I
m
l0 m
lD ~'
~O '~
CO
I x I
I pl I dl
N M
d' H
dl d
N d
N M
I 1f1
I U1
I ~
I ~
I
I I
01 I (n I
o I p I I
~
o I
VI
0 I
dl
o I
VI
W o I
VI
F o ~
0 cN
0 ~
o ~I
q o dl
o
W
\ I P7 I 01 Ol 41 H Ol V] 01 Ol 01 01 w O~
H O~
F H
a
H I I
I I a H
a U
F H w
M
\ I I
I
H
O
W
H
~
~ F
M I
O I I
z ~
w w
~
a
z
z
~
WOW I I W ~ F H ~ U W F
~ H m I I O a z a F H ~ z
z~a ~ ~
°a I I u
z o
o w
~ w
x a
~ ~ ~ ~
UI\U I I H q m O W F F 3 3 x
CA H I I
woal I H
H
o H W W IWi W x
H
a
z\al l
H M fI; ~ I a
s F a
W -
m W
a
x
w
\
]° ~ ~ i w o E a U ~ r
h
a o c
n F
v
W W I ~ FC A W W ~ H E O w
alw~ ~ z ~ a w
w
z W
H
w
wwalo l
3 U u q O U
i F I
a W a
CL >+ O H
a
W a
~ W
W FC
7.
F ~
W H
a
i U ~
oro W
a F
~
w
~a
o °
a ° ~ a w
a m I H I
wrnF I w I w
~ a H w a U w ~ a F ~'
aOzIH I
o W I cn I
~ ~
C7 H
U a
W
a
m
~
U
}I N ,~ I (n I
H H I r-Z I F
W
F H
a U
W U
(!7 O
O U
V]
U
z
O
W
j a~ ~ ~ ~
°m
~
c°n
~
~
w
~
o
°v
a H
~
Heal I
F W W I I
U YI q I W I
3
3
3
3
3
3
3
3
w
3
w
3
w
3
w
l a I
~ a a I ~.I I w
z w
z w
z w
z w
z w
z w
z z z z z
woalH I
mwr~ I I
I I
'T
01
O~
Ol
01
01
01
01
Ol
01
Ol
O~
+
W cn •• I q I
U W F I W I o
\ 0
\ 0
\ 0
\ 0
\ 0
\ 0
\ 0
\ 0
\ 0
\ 0
\
H U1 W I] I M M M M M M M
N M
N M
N M
N M
N
a 'T,~ W I U1 I
w q I Ul I N
\ N
\ N
\ N
\ N
\ N
\ \ \ \ \ \
U I H I M M M M M M M M M M M
H 1 I
a I I
I I U
I I
w ~ ~ a
I-?
cn
cZ7
a
z ~ I W a I-+ H H
°
° m
I I ~ M M M E M M
O a M CA M U] M M
M 7-I M
O M M
U M
I I
I I O M
Q N H M
H N
'
Z M
N M
a+ N U F M
a r H~+ N M
a N M
~ N qqy M
Fii N N F N a N
I I ~ M ~
.
H~ M M P+ M
~ O i-+ M O M ,Tx, M 'S. M U M ]~ M
a ~ M
m~ wow o~w w w w~w ~a w aqw ag
w ~~w ww
a ~q
w
I m l
~„ I w l H
Hx H a
wx
~
x W
z x F a
zmx
~
~ H a
F x
U w
H
H x
HWU
zax
o U
a x
~v a
m x
xwu
I wa I
I q I
~;
d ~ u
z~
~ U
FURC v>>+ U
FC Hau
xgFC H U
Ur•L
v za
HgFC
a w HW
aalQ
ow aaFC
ow H~~
Faw uu~C
zHw UaFC
How
I
a I
I w>
aHCQ mHw
FCQ wF
7
H w
CA a w
H~+LQ ,Hw
aF(Y1 OOCQ aZi FQ a7i LQ r'7aFQ HFCQ aZi frl
N,[ I z/y
•• U I I q Wz i
OU ~3a
au W~
q U Oa
a~CU OH
wzU OH
w~U as
oulU a]
w~CU H
U~U
rrt Icncnl
H~ I U] U] I AaU
7 H
w w u
a a H h
w U
H f.I; w H Zi a H [4 ~q H w H w H Cn f~ H ,Yi 'Zy H H w H
I W W I
rn~ I zz I .
UHH
zCnz FHF
Ulr~'
Z qq
H F
z HxF
C7 VJ7. HFF
W Ft'iz r.~F
V]U77y C7CllH
H C7ulF
~ W Fz
W U zH
Z 7F.Iu]Ez
O U I H H I
FC ~C i
H FC ~
W
FC
a rf
q FC
/
{ N/-~ HN
Boa F
~C
z~a CQ
RC
Ha r~lllr.~
Ana
£
r
a 1~] I ~Na
q m F Hlna
a N F a
q~ a
H o°a
W~ F a~na
ONE wu,
I
-
7
O M H ~
I-7
m H
~ co F O A F O o F O r H
~
.~ [:N I W W I FC~oI~ r.~rQ wo RC C7~nFC (7r~C hr~ Hµ' HFC ~u,FC zlnrL a,-IFC
\roN I I
~ ,-i ,~ I I
o
~
M
r
M
m
o
rn
~
rn
M
rn
r
m
co
co
a~ a l I
r.~ O I I o
H r
o co
O rn
o r
0 ao
0 0 0 0 0 0
q I I r r r r r
0 r
0 r
0 r
0 r
0 r
0 r
0
W w~ I I o 0 0 0 0 0 0 0 0 0
p I I
a l b I o
o 0
0 0
0 0
0 0
0 0 0 0 0 0 0
p, ~., O I I o 0 0 0 0 0 0 0 0
I 0
I 0
I
W jJ O I U I
a •~I a I H I I
rn I
m I
m I
rn I
rn I
rn I
m I
m m m
0 rn
0
• p, U p, l a I o 0 0 0 0 0 0 0 0
1
I
I
I
w
m
w
U
a
3
W~ o 0 0 0 0 0 o H
zH H
~ I
al
(.~ I
H I
O I
F I
q I ~.
U W zOUaWUrUi
I r~aH>awoxa
U