Item 4AAGENDA ITEM # 4A
City of Atlantic Beach FEBRUARY 23,2009
FINANCIAL REPORT
JANUARY 2009
Cash Balances
Prior
Fund(s)
General
Tree Replacement
Convention Development Tax
Local Option Gas Tax
Better Jax 1/2 Cent Sales Tax
Police Training, Forfeit, etc.
Debt Service
Capital Projects
Utility
Sanitation
Building Code Enforcement
Storm Water
Pension -Police
Pension -General
Total
Total Restricted Cash
Total Unrestricted Cash
12/31 /08
Current
01 /31 /09
$7,413,583
34,693
205,096
203,494
763,003
206,756
29,853
415,664
2,584,610
309,879
148,983
2,675,282
56, 994
139,202
$15,187,092
$7,035,917
33,693
209,039
201,297
759,602
207,554
35, 553
443,052
2,640,736
306,027
131,419
2,987,301
45,683
161,185
$15,198,058
$7,412,136
$7,785,922
Dollar
Change
($377,666)
(1,000)
3,943
(2,197)
(3,401)
798
5,700
27,388
56,126
(3,852)
(17,564)
312,019
(11,311)
21.983
$10,966
Cash and Investments
Account
Prior Current
12/31 /08 1 /31 /09
Bank of America -Depository
SBA
Banc of America Securities PLC
Cash on Hand
Subtotal
Police Pension investments
General Pension Investments
Subtotal
Total
$8,449,059
1,311
6,734,322
2,400
15,187,092
$8,459,910
1,310
6,734,438
2,400
15.198.058
4,589,614
7,288,561
11.878.175
$27,065,267
4,414,538
7,003,995
11,418, 533
$26,616,591
Dollar Rate of
Change Return
$10,851 0.03
(1) 0.85
116 0.00
0 -
10, 966
(175,076)
(284,566)
(459,642)
(11.64) (1)
(12.10) (1)
($448,676)
(1) FYTD rate of return through 09/30/08
City of Atlantic Beach
FINANCIAL REPORT
JANUARY 2009
Revenues
AGENDA ITEM # 4A
FEBRUARY 23, 2009
Annual I YTD - 33% YTD Dollar Percent
Fund / (Footnote) Estimate of Estimate Actual Variance Variance
General (1) $10,538,732 $3,509,398 $5,533,423 $2,024,025 57.67%
Tree Replacement 0 0 3,510 3,510 100.00%
Convention Development Tax 94,000 31,302 23,045 (8,257) -26.38%
Local Option Gas Tax 530,872 176,780 150,370 (26,410) -14.94%
Better Jax 1/2 Ct Sales Tax 732,630 243,966 215,476 (28,490) -11.68%
Police Training, Forfeit, etc. 40,150 13,371 9,525 (3,846) -28.76%
Grants 214,284 71,357 30,125 (41,232) -57.78%
Debt Service 69,500 23,144 22,881 (263) -1.14%
Capital Projects 335,000 111,555 110,114 (1,441) -1.29%
Utility 7,551,075 2,514,507 2,464,090 (50,417) -2.01%
Sanitation 1,880,500 626,207 606,981 (19,226) -3.07%
Building Code Enforcement 207,500 69,098 84,184 15,086 21.83%
Storm Water 2,377,000 791,541 957,698 166,157 20.99%
Water/Sewer Construction (2) 1,310,000 436,230 0 (436,230) -100.00%
Pension -Police (3) 812,280 270,489 (582,286) (852,775) -315.27%
Pension -General (3) 1,320,428 439,703 846,092 1,285,795 -292.42%
Total $28,013,951 $9,328,648. $8,783,044 ($545,604)
Analysis of Major Variances
(1) The $2,024,025 positive variance in the General Fund resulted from having received
81 % 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 $436,230 negative variance in the Water & Sewer Construction Fund resulted
from not having issued the 2009 Revenue Notes.
(3) The $852,775 negative variance in the Police Employee Pension Fund & the
$1,285,795 negative variance in the General Employee Pension Fund resulted from
changes in market values of the investments.
City of Atlantic Beach
FINANCIAL REPORT
JANUARY 2009
AGENDA ITEM # 4A
FEBRUARY 23, 2009
Expenses
Annual YTD - 33% YTD Dollar Percent
Department / (Footnote) Estimate of Estimate Actual Variance Variance
Governing Body
City Administration
General Government
Planning and Building
Public Safety (1)
Recreation and Special Events
Public Works (2)
Public Utilities (3)
Pension -Police
Pension -General
Total
$48,076 $16,009 $13,265 $2,744 17.14%
2,709,964 902,418 882,780 19,638 2.18%
1,884,365 627,493 678,508 (51,015) -8.13%
563,748 187,728 165,382 22,346 11.90%
5,742,080 1,912,113 1,458,900 453,213 23.70%
455,619 151,721 148,522 3,199 2.11%
9,903,063 3,297,721 1,947,638 1,350,083 40.94%
8,817,584 2,936,255 3,356,619 (420,364) -14.32%
451,236 150,262 163,592 (13,330) -8.87%
485,152 161,556 156,379 5,177 3.20%
$31,060,887 $10,343,276 $8,971,585 $1,371,691
Resource Allocation
Personal Services
Operating Expenses (4)
Capital Outlay (1) & (2)
Debt Service (3)
Transfers
Total
Annual
Estimate YTD - 33%
of Estimate YTD
Actual Dollar
Variance Percent
Variance
$9,093,980 $3,028,296 $2,887,174 $141,122 4.66%
10,299,788 3,429,829 3,033,281 396,548 11.56%
7,371,612 2,454,747 879,871 1,574,876 64.16%
1,681,207 559,842 1,299,826 (739,984) -132.18%
2,614,300 870,562 871,433 (871) -0.10%
$31,060,887 $10,343,276 $8,971,585 $1,371,691
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 and the Police Building
project has not begun -see Project Activity Schedule.
(2) The positive variance in the Public Works departments resulted from not having begun
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 Operating Expenses is partially due to: 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); only 3 of 4 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.
City of Atlantic Beach
FINANCIAL REPORT
JANUARY 2009
Project Activity -Current Year Activity Only
AGENDA ITEM # 4A
FEBRUARY 23, 2009
Project Name
Public Safety
Police Building Renovation/Design/Construction
Public Utilities:
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
Subtotal
Public Works:
Statue -Turtle
Cabinets for Donner
Gate at Dutton Island
Park Playground
Tennis Courts at Donner Community Center
Howell Park Bridge
Hopkins Creek Retention
Mayport Road Medians
Pedestrian Path Extensions
Sidewalks -George & Edgar Streets
Sidewalks -Contingency
Ardella Road Drainage Project
Royal Palms Design
Sidewalk/Pedestrian Path
Sidewalk & Curb
Royal Palms Stormwater Project
Project YTD YTD YTD
Number Budget Actual Balance
PS0504 660,000 0 660,000
PU0706 84,005 56,131 27,874
PU0801 14,000 0 14,000
PU0802 184,132 183,938 194
PU0805 150,276 0 150,276
PU0901 349,000 314,117 34,883
PU0902 30,000 20,325 9,675
PU0903 22,208 18,428 3,780
PU0904 800,000 0 800,000
PU0905 510,000 0 510,000
2,143,621 592,939 1,550,682
PM0805 73,307 20,700 52,607
PM0901 2,000 0 2,000
PM0902 10,000 0 10,000
PM0903 50,000 0 50,000
PM0905 70,000 0 70,000
PM0906 50,000 0 50,000
PW0309 1,110 1,110 0
PW0401 156,428 11,089 145,339
PW0802 100,000 535 99,465
PW0803 44,000 0 44,000
PW0805 7,732 0 7,732
PW0807 36,333 33,904 2,429
PW0808 400,000 26,476 373,524
PW0901 50,000 0 50,000
PW0904 50,000 20,368 29,632
PW0905 2,810,000 0 2,810,000
Subtotal 3,910,910 114,182 3,796,728
Total $6,714,531 $707,121 $6,007,410
Status Kev
B -Bid Awarded E -Design Phase
C -Project Completed I -Project In-progress
D -Design Completed R - Re-budget Next Fiscal Year
Status
AGENDA ITEM # 4A
FEBRUARY 23, 2009
City of Atlantic Beach, f=1.
Utility Sales Report
Janua 2009 January 2008
Water Sales
Accounts Gallons
0000 Actual
Revenue Revenue
Per 1,000 gI
Accounts Gallons
0000 Actual
Revenue Revenue
Per 1,000 gl
Atlantic Beach
Buccaneer 5,657
2,444 38,097
20,204 $123,905
$74,061 $3.25
$3.67 5,607
2,562 40,211
20,681 $113,193
$66,622 $2.81
$3.22
Total Water Sales 8,101 58,301 x197,966 $3.40 8,169 60,892 5179,815 x2.95
Gallons Gallons
Water Plant Production 0000 0000
Atlantic Beach 54,019 50,601
Buccaneer
Total Production 16,176
70,195 17,824
68,425
Total Water Billed 58,301 60,892
Water Loss for month: 11,894 7,533
Percentage Loss 16.94% 11.01°h
Total 12 mo. Avg. Loss 13.18% 12.97%
Gallons Actual Revenue Gallons Actual Revenue
Sewer Sales Accounts 0000 Revenue Per 1,000 gi Accounts 0000 Revenue Per 1,000 gi
Atlantic Beach
Buccaneer 5,113
2,318 29,969
19,017 $186,834
$146,218 $6.23
$7.69 5,088
2,432 32,456
19,664 $172,102
$131,253 $5.30
$6.67
Total Sewer Sales 7,431 48,988 $333,052 56.80 7,520 52,120 $303,355 55.82
Gallons Actual Revenue Gallons Actual Revenue
Sewer Treatment 0000 Revenue Per ~,ooo gi 0000 Revenue Per 1,000 gi
Atlantic Beach
Buccaneer 40.306
20.844 $186,834
$146,218 $4.64
$7.01 43.754
21.114 $172,102
$131,253 $3.93
$6.22
Total Sewer Treated 61.150 5333,052 $5.45 64.868 5303,355 54.68
AGENDA ITEM # 4A
FEBRUARY 23, 2009
~
~
~
~ ~
~
~ ~ ~ ,G
fi, '
' ' O O ti O
~ ~
o x ~ a 3
0
~
oU~ c
~
~ ~
O ~
~
~o a .
~~ ~
~..+ ,
° ~
+~ N F
y °~
o
~ ~ ~
U ~
.~c;~ ~p o
v~p ~
~
Q We ~~
'~ .~
-o~
~ o°
~ c
z o0
U
Z~ a
i`o
.--i w
v ~
0 3 ~ ;
~
O ~
oo
~ ,~ o
~ ~
0 3w ~
p ~
a"'
N N
~'-'
~
V]
O D;
p
~
b
° ~
•-+
" O
~
+-OJ O
.
a.~o ~
,.~ ~
o ar N
~
~
a N
z
o q N
~.c,~ ~
' ~~
3
• o
~'•~ o•~
•
a E
o
~ ~ o M
~ ~ ~ ~
,~ ~
.~ .~ ~ a
.~
~a ~ ~ ~ ~o
~ ~.~ ~ ~ ~~
ao
~
A ~ e
~ ,
~, a
o
O
~
~ ~
W~ ~
~ U ~~
U v
U
,
.
O
~ U
F
~~ ...
z
z
aN o
~o ~ ~ ~~ ~
3a ~ ~ ~°`'
~ ~ ~
o ~
~~ v
~ U -~
o
a a ~ ~
o ~
~ 3 ~ ~~3 3
~
~ z° ~.~ c7 ~ ~ ~ ~ ~ ~
x H ¢~~ u y ° x ~
~ u
,
s AU v A U, V A A U U
a
a
o ~
U
II •~
~ ~ O
.^~
°~
~ Q ~ y
'
°
~, z
c
~ on
II
w ~i
~ '
W p~ ~
`n a ~ o
M o C
`r .°0 ~ $
~ y ~
a O
40
U
w ;v o II S ~ II II ~ A ~ II ~ o II
G7 a~ o~
0 ~ a
~
o
.~o~ ~ c
~ 3 o fi
a
w a o~ o
~ o
~ » o
~ ,~ o, .» ~ ~ o
A
u a qU a;, ,U ryZw ~~ q U
C~
G
^~
N
M
1ri