Item 4ACit of Atlantic Beach AGENDA ITEM#4A
Y NOVEMBER 23, 2009
FINANCIAL REPORT
OCTOBER 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
09/30/09
$2,918,635
14,822
20,091
222,345
720,569
186,166
(63,844)
74,605
649,961
4,307,091
525,894
57,654
4,190,853
33,748
8,122
$13,866,712
Current
10/31 /09
$2,496,432
14,822
25,667
210,925
683,447
182,576
(13,354)
80, 313
733,296
3,439,665
490,902
56,349
4,058,564
23,702
34,098
$12,517,404
$7,435,388
$5,082,016
Dollar
Change
($422,203)
0
5,576
(11,420)
(37,122)
(3,590)
50,490
5,708
83,335
(867,426)
(34,992)
(1,305)
(132,289)
(10,046)
25,976
($1,349,308)
Cash and Investments
Account
Bank of America -Depository
5th 3rd Bank -Certificate of Deposit
5th 3rd Bank -Certificate of Deposit
SBA
Cash on Hand
Subtotal
Police Pension Investments
General Pension Investments
Subtotal
Total
Prior Current
09/30/09 10/31 /09
$5,845,110
2,014,064
6,003,358
1,280
2,900
13,866,712
5,541,835
9,205,224
14,747,059
$28,613,771
Dollar
Change
Rate of
Return
$6,506,615
0
6,006,610
1,279
2,900
12,517,404
5,478,084
9,096,789
14,574,873
$661,505
(2,014,064)
3,252
(1)
0
(1,349,308)
(63,751)
(108,435)
(172,186)
0.30
1.65
0.65
0.30
N/A
$27,092,277 ($1,521,494)
7.95 (1)
8.27 (1)
(1) FYTD rate of return through 06/30/09
City of Atlantic Beach AGENDA ITEM # 4A
NOVEMBER 23, 2009
FINANCIAL REPORT
OCTOBER 2009
Revenues
Fund / (Footnote) Annual
Estimate YTD - 8%
of Estimate YTD
Actual Dollar
Variance Percent
Variance
General (1) $11,796,728 $979,128 $616,121 ($363,007) -37.07%
Tree Replacement 0 0 0 0 100.00%
Convention Development Tax 80,500 6,682 5,576 (1,106) -16.55%
Local Option Gas Tax 455,764 37,828 36,599 (1,229) -3.25%
Better Jax 1/2 Ct Sales Tax 612,334 50,824 46,211 (4,613) -9.08%
Police Training, Forfeit, etc. 25,750 2,137 2,761 624 29.20%
Community Development Block Grant 116,296 9,653 63,844 .54,191 561.39%
Debt Service 69,000 5,727 5,708 (19) -0.33%
Capital Projects 1,002,000 83,166 83,335 169 0.20%
Utility (2) 13,484,898 1,119,246 653,779 (465,467) -41.59%
Sanitation 1,822,000 151,226 151,035 (191) -0.13%
Building Code Enforcement 308,050 25,568 20,576 (4,992) -19.52%
Storm Water 933,000 77,439 77,500 61 0.08%
Pension -Police (3) 910,823 75,598 (29,542) (105,140) -139.08%
Pension -General (3) 1,449,292 120,291 43,322 163,613 -136.01
Total $33,066,435 $2,744,513 $1,690,181 ($1,054,332)
Analysis of Major Variances
(1) The $363,007 negative variance in the General Fund resulted from not having received
property taxes. Typically the majority of these taxes are received from the City of
Jacksonville in December & January.
(2) The $465,467 negative variance in the Utility Funds resulted from not having issued the
2009 Revenue Notes.
(3) The $105,140 negative variance in the Police Employee Pension Fund & the $163,613
negative variance in the General Employee Pension Fund resulted from changes in
market values of the investments.
City of Atlantic Beach
FINANCIAL REPORT
OCTOBER 2009
Expenses
AGENDA ITEM # 4A
NOVEMBER 23, 2009
Annual YTD - 8% YTD Dollar Percent
Department / (Footnote) Estimate of Estimate Actual Variance Variance
Governing Body $43,303 $3,594 $3,356 $238 6.62%
City Administration 2,532,025 210,159 122,624 87,535 41.65%
General Government 557,296 46,255 38,985 7,270 15.72%
Planning and Building 508,068 42,170 25,317 16,853 39.96%
Public Safety (1) 6,343,731 526,530 279,100 247,430 46.99%
Recreation and Special Events 387,063 32,126 55,349 (23,223) -72.29%
Public Works (2) 8,944,846 742,423 468,937 273,486 36.84%
Public Utilities (3) 13,906,944 1,154,274 1,414,449 (260,175) -22.54%
Pension -Police 519,506 43,119 44,226 (1,107) -2.57%
Pension -General 513,359 42,609 39,108 3,501 8.22%
Total $34,256,141 $2,843,259 $2,491,451 $351,808
Annual YTD - 8% YTD Dollar Percent
Resource Allocation Estimate of Estimate Actual Variance Variance
Personal Services (4) $9,324,297 $773,917 $463,110 $310,807 40.16%
Operating Expenses (1) & (2) 9,807,448 814,018 515,814 298,204 36.63%
Capital Outlay (1) & (2) 10,290,993 854,152 91,608 762,544 89.27%
Debt Service (3) 1,755,495 145,706 1,164,428 (1,018,722) -699.16%
Transfers 3,077,908 255,466 256,491 (1,025) -0.40%
Total $34,256,141 $2,843,259 $2,491,451 $351,808
Analysis of Major Variances
(1) The positive variance in the Public Safety departments 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 have
been vacant positions in the Police Patrol division.
(2) The positive variance in the Public Works departments resulted from not having paid the
October charge for the First Vehicle or Advanced Disposal Services contracts. Also,
there has been limited activity on the various projects funded from this source -see
Project Activity Schedule.
(3) The negative variance in the Public Utilities department resulted from the October
payment of principal and interest on the Utility Revenue Bonds.
(4) The positive variance in the Personal Services is typical for the first month of the new
fiscal year due to the payroll expense only including two weeks of the month of October.
The last 2 weeks of October will not be paid until the first week of November. This
explains why approximately 40% of October's budgeted payroll has not been expensed.
City of Atlantic Beach
FINANCIAL REPORT
OCTOBER 2009
Project Activity -Current Year Activity Only
AGENDA ITEM # 4A
NOVEMBER 23, 2004
Project YTD YTD YTD
Project Name Number Budget Actual Balance
Status
Public Safety
Lifeguard Building Roof Replacement
Police Building Renovation/Design/Construction
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
LG0901 2,979 0 2,979
PS0504 435,788 0 435,788
438,767 0 438,767
PU0304 794,675 0 794,675
PU0805 150,276 0 150,276
PU0905 543,716 0 543,716
PU0906 3,919,536 0 3,919,536
PU0907 31,518 0 31,518
PU1001 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
PU 1010 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 0 6.114,721
PM0804 85,000 0 85,000
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
PW0808 37,026 0 37,026
PW0905 3,161,557 75,747 3,085,810
PW1001 43,732 0 43,732
PW1002 25,000 0 25,000
PW1003 15,000 0 15,000
Subtotal 3,510,727 89,159 3,421,568
Total $10,064,215 $89,159 $9,975,056
Status Kev
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
E
I
C
C
AGENDA ITEM # 4A
NOVEMBER 23, 2009
City of Atlantic Beach, FI.
Utility Sales Report
October 2009
Water Sales
Atlantic Beach
Buccaneer
Total Water Sales
Gallons Actual Revenue
Accounts 0000 Revenue Per 1,00o gi
5,578 41,201 $143,196 $3.4£
2,452 20,948 $80,725 $3.8;
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
r Sewer Treatment
Atlantic Beach
Buccaneer
Total Sewer Treated
Gallons
0000
50, 944
18, 575
69,519
62,149
7,370
10.60%
12.39%
October 2008
Gallons Actual Revenue
Accounts 0000 Revenue Per 1,00o gi
5,627 40,704 $124,358 $3.06
2,482 21,522 $71,452 $3.32
Gallons
0000
52,648
19,764
72,412
62,226
10,186
14.07%
13.33%
Gallons Actual Revenue Gallons Actual Revenue
Accounts 0000 Revenue Per ~,ooo gi Accounts 0000 Revenue Per 1,000 gl
5,110 33,037 $216,795 $6.56' 5,138 32,173 $185,022 $5.75'
2,332 19,526 $153.534 $7.86 2,363 20.365 $144.476 $7.09
Gallons Actual Revenue
0000 Revenue Per 1,000 ei
Gallons Actual Revenue
0000 Revenue Per 1,00o gi
46.557 $216,795 $4.66
18.189 $153,534 $8.44
42.647 $185,022 $4.34'
21.573 $144.476 $6.70
AG EN DA ITE M # 4A
~ NO VE MBE R 2 3, 200 9
-- -- -- ___ --- ---~ _ _ -- --- -- -- - - -- - __ . __ .. _ - __t _ _ ~ - ~ __
~ G
W
Z ~ ~ N a M ~ M
I O
O N O r N ~
V LL
W
a - W
a
-
-
-
- - ~
-- ~
_
a '
I z z ~ ~
J~ O J -~ O
~ Z ~ ~ ~ ~
'
''N o ~ ~ ~ ~ $ I ~ ~ I
~ N d Z _
~ z Z
~ m Q
~
I
F. Z= W ~ W N I i~
` ~
~ - m w a ~ ~ a _
O I 00 °O °o °o °o W °o °o a °o ~ .~ °o °o o° °o
~I
W ~
1~ ~ O
00 ,
ti
et dO'
e+7 tOG
M
O~ J ~ O ti 0 0 0 O
~ M
r
I M e= ~ v 1p O ~ M a v N t0 O I N M
~~
~ ~ OCO
O W
I~ Of
N O
ly ~ O
N Z h
d N
M 1~
~ M M ~
O NN M r N O1 O I r
' ~ N ~
~ W 7
~ ~ N ~ Fes- ~
O W i V V
~ ~ V °o °o °o °o, °o °o O i
J Z O ao o
O o
O rS
M ~
1n
t a;
O
1 n:
OD
2 O
O
O 0
Otfl 0
O 0
10 ff
0>
~ p
O O
r
'
Z
~
Z ~ O c~ r
~~ OI
~ a0
~ 1
~ P
~ ~
~ O
W QM r tG 1p N ~ C
L - -
-
--
---
- -
--
---
---
--
-
--
-
--
--
O ~ '^
V Z ~ ^
. 0
W 0
O
. O
O
. O
O
. 0
O 0
~lf
~
. 0
0 0
0 0
0 0
0 0
0
.
. 0
0 0
0 0
0 0
0 0
0 O
O
/~
A
Z
O
W
t/1 h
~O tp
00 1fW
~ Ip
M Its
ti 1
t0 ~
us 1A
tC 1p
N ~"~
Qf M
r 1A
r C
~. ~
O O
1p O
O t0
tG
• ~
~"~ ti
r N ti
r N
N OD
r N
N ~ N ~ P M tp
a C
~ N
I.I. ~ to M ~ N ~ IA ~ V
~ i
O a - - - --- -- __ ~
W V a a N ~ i ~
~ ~ ~ F- a
O
~ ~
j
- ~
- - v,
-- v,
-- ~
- .r,
__ vo
_ w,
- d,
- v, u,
_ ~
__ v,
- w
-- rs er, a, ~+, ~ v,
- us v,
- us
- w
- .~s
- u-
---
p~
Z O W
Q ~ N O O> Q.
-J
~ ~ ~~ O N N N~
r ~
r fA
~
I I
~
~
~ '
~
-
~
M
~
N
N
O
'
'
N
N
N
O
'O
N
-
e'9
~
~'91
~
~ W O O O I ~ O ~ e r ~
O oo a
pO
W OOI
OD r,
~ ti
oI M
M O
Z I
N ~ ~
~
I
I ~ ~
Z -
~ _ _ -
J __- --- I - - - -- - -
-
-
--
_-
_ I
__
_
___
_
_ ~
1_
y W
~ y >
o ~ ~ ~,
it O W 0
i
W }
O
Z
} W
W
S (~
O H ~
n' J
O ~
Q ~
~
~ J ~
F
E- LL ~
W c~
~ a
~. = j
W c
00 »
0 v
a a
~ v t9
z t~
Z O c7
z ~
a N 0
~
W
J x
W O
O W
~ S
W W
J ~
W ~
O W
~ N
Y W ~ tA 3
W z
LL N
G W
U' (A
J
N ~
~ m
=' Q
= 2
V ~
Q
' O ~ 3
W 3
Q J
O
W Z J
~ W O H ? J W W v
W -
= Z
W W Q
~ ~ W ~ V
J J W U
m Z
m ~
~ m O
Z W
I a v~ o a c~ 0 w ~
o m O
c~ o ~ I
~ oc oc m 2
m Q
t~ 3 w w a ~ O
a ~ ~n y
cn c 3 c