Item 4AAGENDA ITEM #4A
JANUARY 9, 2006
~
~ o ~
•~'O ~
p N •~
~
a°~d
~ ,
.b ca ~
U ,~ vi
o ago
3 oo~
a
~ 0
L
~ 0 ~ a~ .n •o
Q ,S ~
O
p N
,~
W W G~ O_ i+ v
a rr~rr„~~~ ~
~~ ~a b
~~ ~~~
Q .
~bQ
~^ ~
~ ~
~ b
°
~Q~a .
~z~
a ~' 3
3~.~ > ~ ~ .~yo 00 0°
~• ~ a
n' ~Uw ~ ~
~~ a
~ a~
~ y~,~ on"ti~
~~ a~•~~ ~ ~~ „
cx
~.
~~
owo M
,~.~ vi
~
~~ +
~ ~b~~ x
.~
d~b~~ ~
3~,;
~-~~
~
a~i ° ~~
3o .
a°
~ .
~on~oxU ova
•°a~~ a~ .,
ono -0 3~'aU;~,"° ~°'o
0 ob~ ~
~ ~ ~ ~ ~ °~ ~~U ° ~ ~ >,
ao a~ 3
~
~~ .
N a~
°' 3 ba a~ ~ ~ a~ ~ ~
oo~~a~ o ...
Uc~
~
. „ ~~ o a
~~++ ~
~ ~ O
v~ ~ ~"' ~ ~ ~ .+~ ~ ~ ~ ~ rn ~
~ U ~ i ~ v
v' ~ ~ ~ a'ti ~a ~
° ~ ~ ~ ~ ~b.~ c ~ o~
W N
~ ~ e
a ~ ~ b > V1
O N a
O
Q .~~ ~
~ a O '~' ~"" °~
a0 a ~ .`~ „y. 'b U a
~ ~~„ O
x m ...bM o o.o ~3 ~...~ .~ o BOO ;~
0 ~
o ~
~ y• `~ a N ~
~ c b
~
W
A F o.N
O c O
Q '~~ ~
,
W Q v ~
.
U° v zw .-~~
Lrl~ci w
.
AW ~ UU~c v, w
F rn a
O .. o
Fd Q
~
'fl ~ ~ O w
~ U F F ~
~ v ~
C
V ~ ~ ~ ~
C
a
~ ~
o2j
~
~
'~
°
. ~ ~
^SC
S
V
3
..
~& ~
~ o o
3 r"
'~ o
x ~ ~ 3
3 .~ ~; 3
w
"~ ~
A a
q oo
~~ ~
?,~ bbd
aa~ oo~
33 0
rs, ~ Z a U ,° 0. °' ~
~ ~ ~ ~ ~d .~ a
a ~
;~
w E. ~ ~ ~ II
a II $ °i II o
~¢ .
II
o^
z V
~ U
II ~
II a,~
II ~ U^
II ??}
II II °~ ,~ _
II ti ~
W
v a A A A U W
~~ ...-. W o
~~~F~ r. r,
A ~~
z o
~ v
o ~ ^ ~ ~ ~ I
x o
~
w ~ ~
~ a
~ ~
U
'~
C ~ , 9?
W ~ ~ ~ ~ O ~~ O ~~ D N cd q .~-~ a
°
U II
,x c II p~ ~ o II v~ ~ ~ Ii ~ ~ o~O° II II
~ oO~
~
w ~
a o
U ~ o ~ a °o ~ a ~ °o ~ ~b~ o ~
O
~ o ~
~
~
W F
U II v ~ II v
o ~ O II ~ ~ ~ II v
O "
II ~
~^ II
a o~~ d o ~ c o mm a o o :~ ~^ ~ o a°i cyi o
~ a`~i o 0
w a xw AU ~ AU pct,... AU W..,Z AU v~
AU o4 AU
A
0
..
.-~
N
M
d'
V1
~D
`'''" "" 2006
3 ANU ARY 9,
~.
W
H
F
WO
AW
~d
~~
~U
3 ~`
a
,~ M
.s p ~, ~
b ~
o ~ v ° N
~ ~
.a
a ~' o O v
...~
L ~ O U
~ V
a
~
~
a
w ,°'a ~ ~
0 vi c°v
p.° rU '~ ~
V ~ '~ ,n
~' Uo y bb
a,cs o
O
N
~ ~
'
~
CD + C1 '+'
'O r+ U ^, ~y
y
U ~
^~ rrri
~
A
v Q ~ ~
~ cd ~
v
~ ~+ a w °v an
C ~b
o
... 3 .~
~ ~ G +~ O O ~
~ O
U
.Nr O A O ~1 ^.~
U
O ~
Q bA
•' U
i
~
Cw r
~ ~ v 0 U p ~
e ~ °~ •~'` ~
O ~ O
U
~'~ Aa
~
*
O
O
.
o p
~^ ,.,
~~~
,.. o
°' U ~
~ d '~ ~ :^
w ~a
~ x ~ ~ e
W U ~U~
~ ~ ABU
o
11 G
U p
a
•U
W
~ A
w
,Z U
c7 ~ ~
'o
a `^
A
u
~ r
~
~~ ~
~ o
U
°' ~ Q! u~i ~ .~
wo3
U ~ ~3
O ~ ~ ~ ~3
U ~ '•'
o 3UU ~ ''t~
,
w vs ~
o ~ ' o ~ ~ ~
s~ ~' a3 -t
a~
~^
~ "
x~
~ ,
~ u
A U
~~ ~ ~•
0
a
o ~ I
ho
qv
on
f..
A
M
~ ~
0
~ a
O~
00
U
b
U
o O
an a°.,~
Q O +~ ~
~o v ~ ~
A _
rn
a
(~
bA
w+ • O
Ci
o. o
~ ~ ~
y U
~ o
o a
•~
U Z
o
U
~
U Q
~
~
o •^
U ~ o
o
,, p,, ~.
~ ~~
x~
,f `;-
w
v ~ .
A
.~ -
a~
.~
a
3
,~ °~°
Q
~r `n
y
~
'I
a V]
o ~ ~ o
o o ~'`
~, •~ \
~:.
o•q ~
v
U ~ ~•~
U
~ ~ ~ ~~
~ ~ y,
~ II
W y
.+
•b~~oU ~
•qv ~A ~
~~~ o"i O
qv
A
N
0
a
o a•
•~
n
CJ ~
~ o
~ ~~
ti~ U a „
~° ~ ~ o
Av 3a
0
.•
s
t~•
~.
~ ~o
o
o
U N
.
~ O
.b O
~,,, y ~ -~
U O~
O ~ .~ ~ ~
d
`~ ~~+ U
C~
O
O
q
~ ~ v
J
y
~.., • ~„
re Cl. q
~ O
a
~ ~
O O .~ . ~
~ 03
N
~ .,..y ~
~"
~ O ~r
C bOD
.S"" ..Nr ~
v> y
q M d
O q
Q., ,. n ~ OD
'~ ,~
^ ~
~ ~ `~
O ~
~ q 4
"
O ..
., b
N y
N C ~
~ b4
O ~
O ~ .
•~ q
q ~ O
'N Gr ~ ~ w
v> 0
'~ ~ q
w
H ~ ~ a a• U
Z ~.,
~ ~
o o
U U ~ ~ ~ q
O
~ ~ ~~, ~ ci, `~ ~
~
E., ~ ba~~
~v ~ ' a ~
O
,~ °
a p F. 0.m
3 '~ - ~ ~
e d 'b
~
~
"~
~
w
, (
• p
~
v,
+ U
D ( z o
~v ~
~~ ~ ° 3
~ c ~ .~
Oa v
C ~
~ ~
p"
~
3w ~
U ,., ~ ~
+; .
b "
~ o
a
a ~ ~~
~ ~3
~
w ~
°
° ~
x
z a
'
~ ~
~a
W F II ~',~, II
C U
~ ~
~
II U
II ~
~ W
V a v~ A ~
a
z
o
U
U +,
V]
~''
~
~.
M ~
yr N
~a o
b a ~
vii
~ ~
~
~ ~ o\° II a.
w o
.
a ~ a~
z ~ ~ '~N ~A II ~ ~ u
d ~; ; ~' ,~o ~ i .~o
w a y~~
C7 ~~ ~ o
3v~ AU y c"i
v~ A
A a ... ..
u
'~
A
M
•--~
d'
•--~
N
•--~
AGENDA ITEM #4A
JANUARY 9, 2006
i
~:
+~.
1
i
I
~w
.I
UM
~.
AGENDA ITEM #4A
JANUARY 9, 2006
ri I I
I I
I I N I
I
I 1
I
I
1 1
1 I
[/] I 1 I
I
W I 1
I
I
I I ~ 1 I
I I
a a 1 I
p
i I 1
I I
I I a I
I
1 I
I
I
I I
I 1
1 1
m
m I
I
I I
I
I I m m I u)
I 1 N N I W
I I N N I ~/]
I I m m I Z
w
a a ~ u
I I W w I H
I I I a
I 1 x x I
I I U U I z
I I a' Q,' I aooooo0
1 I W W I F
I 1 ~ ~ I
I I
I I
U
U
H I
I 1
I
1 I
1 1 H
r F
r F
m
o
r-1 1
1 1
1
I yt 1 ~ r-1 z m m m 1 I
I I a a s ~ N I-~ 1 1
I W I N N a ~ ~ O 1 I
I z 1 I F I F I I I I 1
I Q I H a H a ~ ~O tl1 I I
1 x l el vl a m m I I
tl1 t a 1 N N N a al d' !n I I
Q I I 1
q I q I H I 1 O I I •• (,~
' a
' a'
O /
~ O a 0 O \ I I U a z Q C' H
7 I
'-I U) I ,
mwl wl O 0.
rn> .
rn> ~ w~ rn Mw~ IaaH>aa
m I
N w
~ w
~
F a
m \ w
.
-r 4 ~ ~ z
a
ao ~ ~
a l I
W O U I 1 o
W o
W
F
O a l
W O U I I
1
I 1
F a I I
U
u 1-~
a h ~ E•1 I
I.~ 1 I
I
xivla 1 I H M (n q m 1
z I
O IQ I I F F z q m r ^4 I
oo I
U) H •• I 1 U N N [!~ H •• I 1
worn I I F a a \ m F N W o ~n 1 I
zNa ~ ~ ~ ~ ~ w ai a w "' z\v1 I 1
vela I I u v H w u a r-a N a, I
cn ,-a a l 1
I
U ~ N ~ a w x ul 1
~
i ~ ~ -1
a ' > x Rl •• I
% ~
% w a w a `~
~• w ~ ~ w ~
+ ~
+ a ~"w w
aowF I 1 a ~ o ~ x o w a a W wF I m
sa I z I
F F w I Q 1 a m
m a m
ra a H W a H
~ F H w w
~ q
0
~
E
F
F ~ I
O (Yj H
p
,
W I Q,' I
w~om l u 1 F a
ama F a
ama z
w F F
z ~ a ~ w~om ~ a
a o z I H 1 F q a F q a ~ a
O
U a F U
~ a a o z 1 gg
o W I w I
GNU I Hm I cn W
wua v) W
WUa z
-o
F
w h o W 1
~Nu I z 000000
a
F H I m ~n 1 a a a w a a F H I
H .. ,.] I mw I
>a 1 as 1 aaa~
a a aaA4
.~ a H u
~ o
z a -
a H ••a 1
> I I
I
Haalagl
Fwa I uq
I w o
axa w o
aa~z
aF
F
O
~ A
axa
H
H a l
(F
NZ
I
~
U~.z 1 1
O I I aF
O W
O W
1•-I F
z W
H o j
1
a Q I I
I
aH 1 W ~! I 33z 3SZ 3N0 30Ca
W W H 3~L]
W~ ' aH I I
W O F l a 1
rnwa I ~w I W F
zwa W F
zwa W W O
zaw
za~~n ++
z z
mwa
~ ~ F~ ~
w zH z~ oa Hz w°a z a I '
cn
uwu I z I
~naF
u1r•CF
~ a
v,aH
u, o
uwu ..
H
H(nU I q I oqz oqz of W o Wa oqU HtnU 1 1 UCLZOC~
azo 1 Wa I \Hw \Hw \a \ ~_a azo I I ~iaH>aa
w 1 pw I oa~ oa~ ~rwN
H C1 m ,-•~a4m
O O ~~~
H tf1 W I
(~ .. I
U •• I VI 1
H F I U] ~ I N O
\ a a m 0
\ a a \ O m \ w \ W r H F 1
a a 1 H p I Nwa Nwa N a N N H N C7 m a a 1
3 q l I 3 q 1 I
W z z
~ ~
z
I 1 O
I 1
I I
a
\
a
\
~
z U
H
I I (Ij N W N O
I 1 \ H \ r'1 a I•'~ I I
I 1 q m q m O m F m - m I I
I I F m F m v) m U m >+ m I 1
1 I H N H N N r7 N F N I 1
1 I U N
~ V N
~ a N a N
F m a N
a m 1 1
I I a
a m
aq a a m
a
aq a a m
zua
a
z a
a a
~ I
w
u, 1 m I > w > w d w
w o a w w ~ 1 m
~~, I v, I aaa aia ~F uq
x ma
wx .~ 1 z
I wl awx
U amx
O U x
O F U
z W U ~
U I w
u1 I W a l
aJ~ 1 q I
~ O
3Ua 3Ua a0a
H Q w OL~a
F H w HU~
a F'1 ~~ I H
• U I
I
N ro I z~ l F H w
wFw F H W
wF W
w W
a~mw
aFw .. U I
N ro I a
ri N I I I
z•~
'~ zz
7 ~
W U .Y. H z r•I v 1 3
.W I v)rn I „I
^
]
aU r
i
aU W •N
U HzU 3 U ,(p 1 W ulooooln
lD I U) m I a s H a a H ~
!.(y Fd a H H a H l0 I z
o U 1 W W I q F F q F H W W F W a F a F F
\ •rl I z Z I H a~ H a~ z ~
H ••~
m ~
Y W a~
F \ •rl I I
m J-1 a I H H I
O qN I m V) 1
\.roN I po 1 (~
Qma
a1~F a
Oma
a~F N
ama
mF r
i
i
Oa
~F
a111a
a~F m J-1 a I
O CN I I
I
`~
.,,~~, 1 mw I wma wma ~Na ~a z~a ~,~~ ~ ,
,~a 1 1 .ua l a l
~' Q I I a 0 1 F I
i ~ m N ~ ~
W ~ ~
W w ~ ~
O !f I I I
i
~ r
-1
VI -1
'
v .
-1
w dl w c!-,
a Q /~ I I
((
~~
~
0
0
o
a'l I ..
1
a ~.
c
~
~ 0 0
i
I
I
1
a~~ I
° .. .. .. ..
z I .. V
W 11 O I V I
a•.Ia I H I I
~ ~ ~ ~ ~ a ~
a ~ a ~ ~aH>aa
aUa l a 1 0 0 0 0 o aUa I c9
.•
City of Atlantic Beach
FINANCIAL REPORT
NOVEMBER 2005
AGENDA ITEM #4A
JANUARY 9, 2006
Cash Balances
Prior Current Dollar
Fund(s) 10/31/05 11/30/05 Change
General $3,837,514 $3,764,806 ($72,708)
Tree Replacement 30,978 30,978 0
Convention Development Tax 162,822 163,309 487
~
Local Option Gas Tax 357,815 367,787 9,972
Better Jax 1/2 Cent Sales Tax 1,005,380 1,028,928 23,548
Police Training, Forfeit, etc. 24,112 23,727 (385)
~"" Grants 42,690 40,314 (2,376)
Debt Service 82,155 88,243 6,088
Utility 3,202,915 3,440,648 237,733
~* Sanitation 568,340 658,577 90,237
Storm Water 2,980,914 2,997,487 16,573
Pension -Police 6,649 (421) - (7,070)
~„ Pension -General 37,764 56,888 19,124
Total $12,340,048 $12,661,271 $321,223
Total Restricted Cash $6,344,618
Total Unrestricted Cash $6,316,653
Cash and Investments
Prior Current Dollar Rate of
Account 10/31/05 11/30/05 Change Return
~..
Bank of America -Depository $138,741 $172,459 $33,718 3.02
SBA 12,198,757 12,486,262 287,505 3.98
~„
Cash on Hand 2,550 2,550 0 -
Subtotal 12,340,048 12,661,271 321,223
~"" Suntrust-Pension-Police 4,179,695 4,279,305 99,610 7.50 (1)
Merrill Lynch-Pension-Police 501,173 525,836 24,663 28.60 (1)
Suntrust-Pension-General 5,657,681 5,791,132 133,451 7.60 (1)
~* Merrill Lynch-Pension-General 1,063,557 1,115,752 52,195 28.60 (1)
Subtotal 11,402,106 11,712,025 309,919
Total $23,742,154 $24,373,296 $631,142
(1) FYTD rate of return through 09/30/05
,~.
~.
City of Atlantic Beach
FINANCIAL REPORT
NOVEMBER 2005
Revenues
AGENDA ITEM #4A
JANUARY 9, 2006
Annual YTD -16.7% YTD Dollar Percent
Fund / (Footnote) Estimate of Estimate Actual Variance Variance
General (1) $9,951,978 $1,661,980 $1,168,988 ($492,992) -29.66%
Tree Replacement 0 0 0 0 100.00%
Convention Development Tax 128,000 21,376 6,944 (14,432) -67.51
Local Option Gas Tax 564,042 94,195 95,042 847 0.90%
Better Jax 1/2 Ct Sales Tax 702,336 117,290 128,046 10,756 9.17%
Police Training, Forfeit, etc. 31,800 5,311 4,789 (522) -9.83%
Grants (2) 447,833 74,788 48,749 (26,039) -34.82%
Debt Service 71,100 11,874 12,143 269 2.27%
Utility 6,623,534 1,106,130 1,107,639 1,509 0.14%
Sanitation 1,362,300 227,504 216,410 (11,094) -4.88%
Storm Water (3) 1,067,868 178,334 122,363 (55,971) -31.39%
Pension -Police 702,355 117,293 122,783 5,490 4.68%
Pension -General (4) 1,015,029 169,510 203,238 33,728 19.90%
Total $22,668,175 $3,785,585 $3,237,134 ($548,451)
Analysis of Major Variances
(1) The $492,992 negative variance in the General Fund resulted from not having received
property taxes. Typically these taxes are received from the City of Jacksonville starting
in December.
(2) The $26,039 negative variance in the Grant Funds resulted from either items not having
been purchased or reimbursement requests not having been filed as of November 30,
2005.
(3) The $55,971 negative variance in the Stormwater Fund resulted from the award of a
grant in fiscal year 2006 that has not been received.
(4) The $33,728 positive variance in the General Employee Pension Fund resulted from
changes in the market values of the investments.
,..
~•
City of Atlantic Beach
FINANCIAL REPORT
NOVEMBER 2005
AGENDA ITEM #4A
JANUARY 9, 2006
Expenses
"~" ~ Annual YTD - 16.7% YTD Dollar Percent
Department / (Footnote) Estimate of Estimate Actual Variance Variance
Governing Body $45,938 $7,672 $8,516 ($844) -11.00%
City Administration 2,122,737 354,497 289,029 65,468 18.47%
General Government (1) 2,165,615 361,657 238,281 123,376 34.11%
~.. Planning and Building 591,118 98,717 59,823 38,894 39.40%
Public Safety (2) 4,714,649 787,348 458,020 329,328 41.83%
Parks and Recreation 1,023,072 170,854 132,270 38,584 22.58%
Public Works (3) 6,136,758 1,024,838 704,566 320,272 31.25%
~°" Public Utilities (4) 7,115,581 1,188,302 1,602,502 (414,200) -34.86%
Pension -Police .400,936 66,956 68,185 (1,229) -1.84%
Pension -General 405,798 67 768 67,422 346 0.51
Total $24,722,202 $4,128,609 $3,628,614 $499,995
Annual YTD - 16.7% YTD Dollar Percent
~'" Resource Allocation Estimate of Estimate Actual Variance Variance
Personal Services (5) $7,913,547 $1,321,562 $1,024,716 $296,846 22.46%
Operating Expenses (2) & (3) 9,514,916 1,588,992 1,019,322 569,670 35.85%
~" Capital Outlay (1), (2) & (3) 4,827,077 806,122 335,703 470,419 58.36%
Debt Service (4) 1,677,585 280,157 1,117,360 (837,203) -298.83%
Transfers 789,077 131776 131513 263 0.20%
,~„ Total $24,722,202 $4,128,609 $3,628,614 $499,995
Analysis of Major Variances
~.
(1) The positive variance in the General Government departments resulted from not having
begun the various projects funded from this source -see Project Activity Schedule.
(2) 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 2006 for October through December 2005. Also, the police
union contract has not been approved as of November 30`h so salaries and benefits are
less than the amount budgeted.
(3) The positive variance in the Public Works departments resulted from the waste
management contract and First Vehicle not having been paid in October 2005 and not
having begun various projects funded from this source -see Project Activity Schedule.
(4) The negative variance in the Public Utilities department resulted from the October
payment of principal and interest on the Utility Revenue Bonds and is partially offset by
not having begun various projects funded from this source -see Project Activity
Schedule.
(5) The positive variance in the Personal Services is related to 43% of the first payroll of
October, 2005 being expensed in the prior fiscal year. Also, the union contracts for the
police, white collar and blue collar employees has not been approved as of November
30, 2005.
~..
City of Atlantic Beach
FINANCIAL REPORT
NOVEMBER 2005
AGENDA ITEM #4A
JANUARY 9, 2006
Project Activity -Current Year Activity Only
Project YTD YTD YTD
Project Name Number Budget Actual Balance Status
~„ General Government:
City Hall Expansion GG0402 $2,816 $0 $2,816 I
Subtotal 2,816 0 2,816
Parks and Recreation:
~ Beautification PR0601 45,000 0 45,000
Subtotal 45,000 0 45,000
~" Public Safety
Police Building Renovations PS0504 475,000 0 475,000 D
Homeland Security Items PS0601 138,000 0 138,000
~. Subtotal 613,000 0 613,000
Public Works:
~„ Plaza Entrance/Post Office PW0305 55,080 54,687 393 I
Hopkins Creek Basin Pond PW0309 1,301,500 0 1,301,500 E
Mayport Road Medians PW0401 346,858 0 346,858 E
Welcome Sign and Landscaping PW0405 78,000 0 78,000
~ Ocean/13th -Coast Drive/12th PW0409 132,073 2,745 129,328 E
Five Points Intersection Improvement PW0502 346,643 123,659 222,984 I
Sidewalks -New PW0503 23,795 0 23,795 I
""' Sidewalks -Replacements PW0505 10,752 5,864 4,888 I
Seminole Ditch Headwall PW0507 12,974 0 12,974 I
Pathway -Plaza (West of Mayport Road) PW0508 24,676 0 24,676 I
*"" Concrete Floor for Shed PW0601 8,000 0 8,000
Medians Rehab -Atlantic Boulevard PW0602 20,000 0 20,000
Roll Off Concrete Pads PW0603 10,000 0 10,000
~,. Sidewalks & Curbs PW0604 50,000 0 50,000 I
Paving of City Hall Parking Lot PW0605 84,000 0 84,000
Pathways PW0606 150,000 0 150,000
Sidewalks - Sailfish,Royal Palm & Frances PW0607 90,800 0 90,800
~ Subtotal 2,745,151 186,955 2,558,196
Public Utilities:
0
Security Upgrade/Water Plants PU0305 2,485 2,485
~"' Headwork Improvements at WWTP2 PU0310 52,027 0 52,027
Water Line at 10th Street & Beach Avenue PU0503 99,776 31,138 68,638
Mayport Road Sewer Crossing PU0504 50,000 0 50,000
+~ Fence Replacement at Water Plant 1 PU0601 70,000 0 70,000
Water Main at Sailfish Drive & Plaza PU0602 60,000 0 60,000
Sewer Crossing Ditch at Palm Landing PU0603 30,000 0 30,000
Genset at Lift Station B PU0604 44,650 0 44,650
„ Clarifier Rehabilitation PU0605 100,000 0 100,000
Fence Replacement at WWTP 1 PU0606 15,000 0 15,000
Sludge Container Refurbishment PU0607 15,000 0 15,000
~, Subtotal 538,938 33,623 505,316
Total $3,944,905 $220,578 $3,724,327
~..
Status Key
B -Bid Awarded E -Design Phase
C -Project Completed t -Project In-progress
""~ D -Design Completed R - Re-budget Next Fiscal Year