Item 4AAGENDA ITEM # 4A
City of Atlantic Beach JANUARY II,aolo
FINANCIAL REPORT
NOVEMBER 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
Prior Current
10/31 /09 11 /30/09
$2,435,841
14, 822
25,670
210,960
683, 563
182,606
50,490
80,325
733,400
3,438,275
490,939
56,224
4,058,703
23,707
34.099
Total $12,519,624
Total Restricted Cash
Total Unrestricted Cash
Subtotal
Cash and Investments
Account
Bank of America -Depository
5th 3rd Bank -Certificate of Deposit
SBA
Cash on Hand
Police Pension Investments
General Pension Investments
Subtotal
Prior Current
10/31 /09 11 /30/09
$6,508,835
6,006,610
1,279
2,900
12.519.624
5,478,084
9,096,789
14.574,873
$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
$7,456,813
Dollar
Change
$1,127,411
0
(0)
28
(27,250)
(1,095)
(63,844)
5,707
70,904
122,862
21, 726
(8,141)
(63,828)
(5,493)
26,912
$1,205,899
$6,268,710
$7,711, 348
6,009,972
1,303
2,900
13,725,523
Dollar
Change
$1,202,513
3,362
24
0
1,205,899
Rate of
Return
0.30
0.65
0.28
N/A
5,678,140
9,421,021
15,099,161
Total $27,094,497 $28,824,684
200,056
324,232
524,288
$1,730,187
20.82 (1)
21.56 (1)
(1) YTD rate of return through 09/30/09
City of Atlantic Beach
FINANCIAL REPORT
NOVEMBER 2009
Revenues
AGENDA ITEM # 4A
JANUARY 11, 2010
__
Annual I YTD -16.7% YTD Dollar Percent
Fund / (Footnote) Estimate of Estimate Actual Variance Variance
General (1) $11,796,728 $1,970,054 $2,334,490 $364,436 18.50%
Tree Replacement 0 0 0 0 100.00%
Convention Development Tax 80,500 13,444 5,576 (7,868) -58.52%
Local Option Gas Tax 455,764 76,113 78,162 2,049 2.69%
Better Jax 1/2 Ct Sales Tax 612,334 102,260 102,295 35 0.03%
Police Training, Forfeit, etc. 25,750 4,300 2,759 (1,541) -35.84%
Grants 116,296 19,421 63,844 44,423 228.74%
Debt Service 69,000 11,523 11,416 (107) -0.93%
Capital Projects 1,002,000 167,334 166,656 (678) -0.41%
Utility 13,484,898 2,251,978 1,268,587 (983,391) -43.67%
Sanitation 1,822,000 304,274 303,316 (958) -0.31%
Building Code Enforcement 308,050 51,444 36,613 (14,831) -28.83%
Storm Water 933,000 155,811 154,988 (823) -0.53%
Pension -Police (3) 910,823 152,107 204,822 52,715 34.66%
Pension -General (3) 1,449,292 242,032 345,995 103,963 42.95%
Total $
$5,079,519
Analysis of Major Variances
(1) The $364,436 positive variance in the General Fund resulted from having received 23%
of the budgeted amount of property taxes and 29% of the franchise fees from JEA to
date. Typically the majority of the property taxes are received from the City of
Jacksonville in December & January. The franchise fees received in November, 2009
were budgeted & recognized in the prior fiscal year.
(2) The $983,391 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 negative 1 %.
(3) The $52,715 positive variance in the Police Employee Pension Fund & the $103,963
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 11, 2010
NOVEMBER 2009
Expenses
Annual YTD -16.7% YTD Dollar Percent
Department / (Footnote) Estimate of Estimate Actual Variance Variance
Governing Body $43,303 $7,232 $7,715 ($483) -6.68%
City Administration 2,532,025 422,847 351,499 71,348 16.87%
General Government 642,296 107,264 71,528 35,736 33.32%
Planning and Building 520,632 86,945 67,041 19,904 22.89%
Public Safety (1) 6,343,731 1,059,403 637,610 421,793 39.81%
Recreation and Special Events 387,063 64,640 79,957 (15,317) -23.70%
Public Works (2) 8,859,846 1,479,595 878,551 601,044 40.62%
Public Utilities (3) 13,894,380 2,320,361 1,924,392 395,969 17.06%
Pension -Police 519,506 86,758 90,196 (3,438) -3.96%
Pension -General 513,359 85,731 77,317 8,414 9.81
Total $34,256,141 $5,720,776 $4,185,806 $1,534,970
Annual YTD -16.7% YTD Dollar Percent
Resource Allocation Estimate of Estimate Actual Variance Variance
Personal Services (1) & (4) $9,324,297 $1,557,157 $1,149,439 $407,718 26.18%
Operating Expenses (1) & (2) 9,806,748 1,637,727 1,224,309 413,418 25.24%
Capital Outlay (1) - (3) 10,291,693 1,718,713 134,644 1,584,069 92.17%
Debt Service (5) 1,755,495 293,168 1,164,428 (871,260) -297.19%
Transfers 3,077,908 514,011 512,986 1,025 0.20%
Total $34,256,141 $5,720,776 $4,185,806 $1,534,970
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 1 of 2 monthly
payments for this fiscal year have been paid on the Advanced Disposal Services Jax LLC
and First Vehicles contracts and 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 positive variance in the Personal Services is typical for the new fiscal year due to the
payroll expense only including two weeks of the month of October. The last 2 weeks of
October were paid in the first week of November. This explains why approximately 26%
of the budgeted payroll has not been expensed.
(5) 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
NOVEMBER 2009
Project Activity -Current Year Activity Only
AGENDA ITEM # 4A
JANUARY 11, 2010
Project Name
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
Project YTD YTD YTD
Number Budget Actual Balance
LG0901 2,979 0 2,979
PS0504 435,788 12,416 423,372
438,767 12,416 426,351
PU0304 794,675 0 794,675
PU0805 150,276 0 150,276
PU0905 543,716 13,735 529,981
PU0906 3,919,536 9,654 3,909,882
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
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 23,389 6,091,332
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,162,257 75,747 3,086,510
PW1001 43,732 0 43,732
PW1002 25,000 578 24,422
PW1003 15,000 0 15,000
Subtotal 3,511,427 89,737 3,421,690
Total $10,064,915 $125,542 $9,939,373
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
I
E
E
E
E
I
E
C
C
U
.~ ~
~ ~ a
O
V
Pte- ~, .p •~ ~
~ ~ .., MC
U ~
~ +' ~ O i.
O N ~ ~ .~ C
~ L
~ O O M ~ ~
o >
~ ¢ 3 ~
W ~ ~° ° 8
~ ~
t,
~ 'v ~ o o
~'
" ° ~
°
sx
w ~.c
~ w
~
~ o 0
w o ~ 'b
~,, ~ ^o ~ ,v
a ~ ~ ,din o '~;A ~
p~ ~ ~ p N ^~ ~ ~ ~ C
~,~ ~•~ ~~ ~~
o a ~~ o
w ~ ° ~ o~°U~ ~~
~ c z
o •~ .~ •~ ~ ~ ° ~ c
'
~~ ~
aF H ~ ~ ~ ~ o
•~ ~~ ~~ b
~ b~ ~~ ~
~
AW F ~' U ~3 CCU ~d U~ ~ ;
t~
z
0
Hd ~
.,
~
~,
z
~~" °
o ,~
~ °
~
~ w ~ 3
• •~
~ ~ ~
~
3 °~-
~ ~
° ~ ~
•~ 'on ° ~
~ a 'on x
o
~ °~ ~ ~ ~ ~ w ~~ w 3
~
a ~ ~ ~ ° W ~ 0
a ° ~ a
H ~~a a
i •
c ~~ o I
w
U
W C~ ^ ~ d
II
GO ~
= :.
f3~ ~-+
Z ~ II II ~ II ~ ,
II II ~ II II ~
Orx .-. ~. W
CaUU .~. ~
A .-• .-. W
QUU .~..-. W
Q U U
~ a.
x
z ~
o
U °p
~ o
~ p O
ti
•~ O
II
•~
U ~ ~ o\ W II
\° ~
W
H
A
.~ 0 0 o
~? .~~ o c
o o o
.~
~ o
w ,
~ '" u u ~ y ~
3 ~~ u
Q ° II ~ ~ II
3 b
~ w Qo~~ ~
~~ II ~ ~
a
•b
A ~ ;~, . •o
~ ~ o ~ ~ ~ v
~
~ c o
~ ,~, o
~ I
z
~
a. ;~ q .~ •~
a
~ A ~
~ ~ ~
~
~ ~
q
a o a~ •~ o
Chi tx ~L U ~ v •~
E-a 0., ~ ~, e, o
~ g U o ~ o
O° 4 U
u
..
A
•-+
N
M
d•
AGENDA TI•EM # 4A
JANUARY l 1, 2010
W
U
a
rn
O
M
~~
W~ O ~
a ~
z~a
oa
Cn\U
~ ~
woa
z~a
H N FC
]~..
xzai
YI W FC
~ 3 U
P; W
a~cn
~ o W
YIN
~a~
H~Ca
u~A
~rxa
~o~a
z
w m ••
U W H
Hma
azw
wQ
U
H
a
3
W
z
N .C
ro
N
Q1
O
H U
~ •~
c. a~ a
o C N
\ t 0 N
H H H
~a
QO
Q
W w ~
xoa
~ a
a >,t;
w,~c
a•~a
aua
~ I
wl
z~
O i
x
a
~ ~
07
z
O
H
I H
~w
I H
~~
I
la
I U
I
I W
la
I ~1
F
~Q
Iw
I
I Cn
I ~
I H
w
za
cn m
~ ~
H H
xwwx
u
H
a
w
w
m
z
w
u
H
a
3
w O N O O O O O O N
zH ~
I
I
ml
al
Q,• I
H I
of
H I
1
Q ..
.. .. .. .. .. .. .. .. u
~uazouxwuH
rx r~aHpawo]a
O
m
m
N N
r
lD
M O~
N
~O
lfl O
41
lfl
dl
I H
01
O
l0
1 O
O
O
In
I O~
lD
O~
Ol
I O
O
~O
r
I O
O
lD
r
I
1
,~
c
N I
io
~
N I
M
M
N ~n
~o
p~
I w
M
m
I r
~r,
~ Lfl
I m
r
N
I r
w
N
I r
~
N
1
c
O
01 I
v~
O
01 I
v~
O
Ol r
Lfl
r o
M
~D M
O
N a
O
O~ a
O
01 d'
O
O1
a
w
z
0
H
H
0
a
m
V'
m
I
N
N
I
m o
H O1
a
F
°z
H
z
w
x
a
~a
AGENDA ITEM # 4A
.-ANIIARY 11, 2010
a
I
0
r
r
I
0
V~
w
z
w
~
~ ~ z v ,
~ H ~ U U ~ a H U
'.
7 F 0.S F w D
~ c7 z m H u
z o u w w u u
~ ~ w w ~
w w ~ ~ ~ o ~ a
~
° m a H ~ w w o o H z
~ ~ H H H W FC
H
p7
3 S 3
W 3
W 3
W 3
W 3
W 3
W 3
W S
W S
W 3
W
W
z W
z z z z z z z z z z z
rn rn m m m rn m rn rn m rn m
0 0 0 0 0 0 0 ~ o 0 0 0 0
01 N N N
o L(1
H~ lfl
H l!1
H lfl
'-I ifl
r-1 L(1
H 01
N N
O
N O O
N N N N N N
H N
i N
H N
H N
H N
H N
.-1
H H H H H r
o ~'
H
H U
Ca H OU ~ ~
M
IU7 M
a M
M
~ M ~
~j' M
w
M
A M
o M
o M
w ~I M U
M
M a M a M M M fn M u M M r] M ~'] M C_) O n'1 W M
N N ~ N N w N z N N N H N H N ~ N U N
U N W N y+ N (n N N H N N U N W H N W H N A F N N
, M
'7 a' M P: M 7a M ~!S M M M ~ M H M H M
~
' O H M M
,
.
H H W O W a C7 F F
U tx
a x a m a H a x a w a cn a a c~Ha uHa a a a
w w w w ~ w ~ w ~ w a w H w w w ~~w ~~w cnc7w z w
x ~ x z x ] x a x x x u x x x - ax H x
aQ
tau ~ u v a u wFU u
~ w u HFV wQU
c w u
o~~c z u
oF~ u
H>+~
m ~ o~ 7
yFFC
~nw o
x .~
w am~c
w ~a
oFw w~
HF ~C
w ~m~t
x w o~~
aw aw aw aHw
Hw
O fZ W mew
x a m ~
H 0.'1 a q W H >+ W 0.l H !A a H ul W N PO W 0.l a1 W P7 W ~
O W H H p7
~au xu
F QHu wa u ~c~cu ~cuu c7u u wQ~u H~u Hz
u u~.u uuu
~
~ z
a W~ O~ U~ O F F
O~ w WH ~
F
W W W ~
H H
fxG1
~"+F
'r~ FC
zH F
F
w zFz FZz L1 fazFz
c
g
H g
Hu
~ z
z zd
~ Z
SO z
30 z
z
r z
z
cHn
~io~
~oF r
~
x01-7
~ F a o,.a
W InH 7
1
xm a
F cFrlma
QmF ~-Ia
~
l~(
OPH II
~--
P
~ a
F arn
OmF a
of
a a
of
a ma
I
Od'H a
a
H~H
~~~ ~Hf./; (QHrl; qrn ~ wHr~ wo~C O r•C xH~ ~~ ~~ a.~~c mo~C
O M
H N
O N
H r
H l11
H m
H ~
H O
H ~
H H
N ~
O
N
N N
r N
r N
r N
r N
r N
r N
r N
r N
r N
r N
r
r
0 0 0 0 0 0 0
0 0
0 0
0 0
0 0
0 0
0
0
0 0
0 0
0 0
0 0
0 0
0 0 0 0 0 0 0
0 0 0 0 0 0 0
I 0
I 0
I 0
I 0
I 0
I
I
0 I
0 I
0 I
0 I
0 I
0 0 0
H 0
i 0
H 0
H 0
1"I
ri H H H H H H r