Item 4A~.
City of Atlantic Beach
FINANCIAL REPORT
NOVEMBER 2006
AGENDA ITEM # 4A
JANUARY 8, 2007
Cash Balances
Prior Current Dollar
Fund(s) 10/31/06 11/30/06 Change
General
~, Tree Replacement
Convention Development Tax
Local Option Gas Tax
Better Jax 1/2 Cent Sales Tax
Police Training, Forfeit, etc.
Grants
Debt Service
Utility
Sanitation
'~' Storm Water
Pension -Police
Pension -General
Total
Total Restricted Cash
Total Unrestricted Cash
$6,795,018
$5,403,526
Cash and Investments
*~ Prior Current Dollar
Account 10/31/06 11/30/06 Change
Bank of America -Depository $253,135 $484,092 $230,957
SBA 12,639,963 11,711,902 (928,061)
'" Cash on Hand 2,550 2,550 0
Subtotal 12,895,648 12,198,544 (697,104)
"'~" Police Pension Investments 5,265,033 5,370,217 105,184
General Pension Investments 7,866,383 8,026,344 159,961
Subtotal 13,131,416 13,396, 561 265,145
Total $26,027,064 $25,595,105 ($431,959)
(1) FYTD rate of return through 09/30/06
$4,469,113 $4, 331,168 ($137, 945)
20,913 20,913 $0
162,105 162,759 $654
287,365 312,488 $25,123
1,167,238 1,214,663 $47,425
7,042 6,627 ($415)
64,907 56,510 ($8,397)
83,482 89,718 $6,236
3,369,073 3,441,157 $72,084
486,121 570,453 $84,332
2,721,689 1,924,473 ($797,216)
26,770 20,309 ($6,461)
29,830 47,306 $17,476
$12,895,648 $12,198,544 ($697,104)
Rate of
Return
4.36
5.37
9.40 (1)
10.00 (1)
..
City of Atlantic Beach
FINANCIAL REPORT
NOVEMBER 2006
Revenues
AGENDA ITEM # 4A
JANUARY 8, 200?
Annual YTD -17% YTD Dollar Percent
Fund / (Footnote) Estimate of Estimate Actual Variance Variance
~.
General (1) $10,576,532 $1,766,281 $1,373,092 ($393,189) -22.26%
Tree Replacement 0 0 0 0 100.00%
Convention Development Tax 81,000 13,527 7,557 (5,970) -44.13%
Local Option Gas Tax 563,042 94,028 93,471 (557) -0.59%
Better Jax 1/2 Ct Sales Tax 761,298 127,137 133,678 6,541 5.14%
~
Police Training, Forfeit, etc. 31,250 5,219 6,468 1,249 23.93%
Grants (2) 209,234 34,942 88,005 53,063 151.86%
~„ Debt Service 73,048 12,199 12,453 254 2.08%
Utility 6,750,002 1,127,250 1,153,886 26,636 2.36%
Sanitation 1,462,200 244,187 220,386 (23,801) -9.75%
~. Storm Water (3) 1,862,500 311,038 255,631 (55,407) -17.81
Pension -Police (4) 765,862 127,899 271,312 143,413 112.13%
Pension -General (4) 1,096,364 183,093 432,748 249,655 136.35%
Total $24,232,332 $4,046,800 $4,048,687 $1,887
Analysis of Major Variances
(1) The $393,189 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 $53,063 positive variance in the Grant Funds resulted from .the reimbursement of
expenses from the prior fiscal year in October and November, 2006.
(3) The $55,407 negative variance in the Stormwater Fund resulted from the award of a
grant in fiscal year 2007 that has not been received.
(4) The $143,413 positive variance in the Police Employee Pension Fund & the $249,655
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 8, 200
NOVEMBER 2006
Expenses
Annual YTD - 17% YTD Dollar Percent
Department / (Footnote) Estimate of Estimate Actual Variance Variance
~"" Governing Body $50,898 $8,500 $9,587 ($1,087) -12.79%
City Administration 2,253,291 376,300 398,202 (21,902) -5.82%
General Government (1) 3,037,978 507,342 226,475 280,867 55.36%
„~ Planning and Building 652,227 108,921 60,089 48,832 44.83%
Public Safety (2) 4,759,060 794,763 515,608 279,155 35.12%
Parks and Recreation 1,185,330 197,950 164,154 33,796 17.07%
Public Works (3) 7,723,057 1,289,751 1,546,355 (256,604) -19.90%
~
Public Utilities (4) 7,650,855 1,277,693 1,693,884 (416,191) -32.57%
Pension -Police 424,133 70,830 66,497 4,333 6.12%
Pension -General 436,713 72,931 68,091 4,840 6.64%
Total , $28,173,542 $4,704,981 $4,748,942 ($43,961)
~. Annual YTD Estimate YTD Dollar Percent
Resource Allocation Estimate 17% Actual Variance Variance
Personal Services (5) $8,571,044 $1,431,364 $1,117,066 $314,298 21.96%
~'" Operating Expenses (2) 9,714,880 1,622,385 1,171,218 451,167 27.81
Capital Outlay 6,868,864 1,147,100 1,108,929 38,171 3.33%
Debt Service (4) 1,675,695 279,841 1,127,886 (848,045) -303.05%
~* Transfers 1,343,059 224,291 223,843 448 0.20%
Total $28,173,542 $4,704,981 $4,748,942 ($43,961)
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 8~ rescue services. The next
payment is due in January 2007 for October through December 2006. Also, there are
vacant positions in the Police Patrol division, capital items have not been purchased and
the Lifeguard expenses are seasonal (typically June through September).
(3) The negative variance in the Public Works departments resulted from the purchase of
land in the Stormwater Fund in November, 2006 for the Hopkins Creek retention pond.
(4) The negative variance in the Public Utilities department resulted from the annual
payment of principal and semi-annual payment of interest on the Utility Revenue Bonds.
(5) The positive variance in the Personal Services is related to 50% of the first payroll of
October, 2006 being expensed in the prior fiscal year.
~ ~
+~ City of Atlantic Beach
FINANCIAL REPORT
NOVEMBER 2006
Project Activity -Current Year Activity Only
AGENDA ITEM # 4A
JANUARY 8, 2007
Project Name
General Government:
Buchman Trust Property
,~, Parks and Recreation:
Jordan Park Shelter
Playground Equipment-Donner Park
Shade for the Skate Park
Russell Park Light Replacements
Public Safety
Police Building Renovations
Project YTD YTD YTD
Number Budget Actual Balance
GG0701 $450,000 $0 $450,000
Subtotal 450,000 0 450,000
PR0701 10,000 0 10,000
PR0702 33,000 0 33,000
PR0703 20,000 0 20,000
PR0704 17,500 0 17,500
Subtotal 80,500 0 80,500
PS0504 466,850 0 466,850
Subtotal 466,850 0 466,850
Public Utilities:
Fence Replacement at Water Plant 1
Genset at Lift Station B
Clarifier Rehabilitation at WWTP 1
Fence Replacement at WWTP 1
Sludge Container Refurbishment
Beach Habitat Subdivision
Remodel SCADA Control Area
Roof Replacement at Lab/Office
Begonia Street Water & Sewer Extension
Collection System Inspection & Rehabilitation
Replace 2 Hydroscreens
TMDL Engineering WWTP 1
Subtotal
~. Public Works:
Hopkins Creek Retention
Mayport Road Medians
~ Five Points Intersection Improvement
Pathways
Sidewalks - Sailfish,Royal Palm & Frances
Storage Bins for Limerock
Mandalay Park Improvements
Repave Asphalt at Public Works Yard
Asphalt Stewart Street at West Main Street
Sidewalk & Curb Replacement
Pedestrian Path -Five Points to Selva Marina
New Sidewalks -Marsh Oaks
*^ Ocean Boulevard Between 14th & 15th Street
Subtotal
Total
PU0601 12,049 0 12,049
PU0604 29,007 0 29,007
PU0605 145,223 0 145,223
PU0606 3,984 0 3,984
PU0607 8,900 8,876 24
PU0608 151,179 63,035 88,144
PU0701 20,000 0 20,000
PU0702 10,000 0 10,000
PU0703 100,000 0 100,000
PU0704 365,400 0 365,400
PU0705 30,000 0 30,000
PU0706 350,000 0 350,000
1.225.742 71.911 1.153.831
PW0309 2,530,730 883,978 1,646,752
PW0401 400,000 0 400,000
PW0502 8,164 8,164 0
PW0606 81,500 998 80,502
PW0607 5,102 0 5,102
PW0701 30,000 0 30,000
PW0702 50,000 0 50,000
PW0703 70,000 0 70,000
PW0704 10,000 0 10,000
PW0705 50,000 0 50,000
PW0706 120,000 0 120,000
PW0707 120,000 0 120,000
PW0708 350,000 0 350,000
3,825,496 893,140 2,932,356
$6,048,588 $965,051 $5,083,537
Status Key
B -Bid Awarded E -Design Phase
,.. C -Project Completed I -Project In-progress
D -Design Completed R - Re-budget Next Fiscal Year
Status
E
E
E
C
I
I
AGENDA ITEM # 4A
JANUARY 8, 2007
City of Atlantic Beach, FI.
Water and Sewer Utility Sales Report
November 2006 November 2005
` ~
Gallons Actual Revenue Gallons Actual Revenue
Water Sales '~ Accounts 0000 Revenue Per 1,000 s~ Accounts 0000 Revenue Per 1,00o gi
Atlantic Beach 5,613 51,765 $131,082 $2.53 ~ 5,506 45,279 $109,598 $2.42
Buccaneer 2,540 23,815 $67,232 $2.82 `; 2,668 27,118 $69,112 $2.55
`~~ Total Water Sales 8,153 75,580 $198,314 $2.62 8,174 72,397 $178,710 $2.47 ,~
Gallons Gallons
Water Plant Production o000 0000
Atlantic Beach 60,471 55,397
Buccaneer 19,248 22,548
Total Production 79,719 77,945
Total Water Billed 75,580 72,397
Water Loss for month: 4,139 5,548
Percentage Loss 5.19% 7.12%
Total 12 mo. Avg. Loss 10.56% 10.35%
Galli~ns Actual Revenue Gallons Actual Revenue
Sewer Sales Accounts 0000 Revenue Per 1,000 9i Accounts 0000 Revenue Per 1,000 gl
Atlantic Beach 5,081 37,564 $171,685 $4.57 5,032 36,620 $161,585 $4.41
Buccaneer 2,422 22,417 $129,317 $5.77 2,561 25,619 $137,677 $5.37
Total Sewer Sales 7,503 59,981 $301,002 $5.02 7,593 62,239 $299,262 $4.81:'
Gallons Actual Revenue Gallons Actual Revenue
Sewer Treatment 0000 Revenue Per 1,000 9i , 0000 Revenue Per 1,000 gl
Atlantic Beach 47.959 $171,685 $3.58 45.495 $161, 585 $3.55 ,p
Buccaneer 21.076 $129,317 $6.14 16.946 $137,677 $8.12 ~;
Total Sewer Treated 69.035 $301,002 $4.36 62.441 $299,262 $4.79
AG EN DA ITE M # 4A
JA NU AR Y 8 , 20 07
O
m
N° W
~
oa
O ~ N C O
O M
~ r
~ N
W
a W
a
Z Z J Q Q
,moo
a O
~ U O
? U
Z F-
~
NO
o Z a'
O~r
i d~
N - V
W ~
~ U W
W V
~
?m w a W
~ ~ ~
O 0
0 0
0 0
0 0
0 0
0 0
0
0
0
0
0
0
a
W (~ t[!
o N
~ ~
~ r
~ h
ti O
~ W O
J O D M r
w
O N O
0 Q1
O I w N r
~ 0 0 ~ ti
N r
c~ 0
ao <
ti r
m O
~n Q
m ; p e} O M M
a/ ~
~ N CA
~C1 N
01 e'7
I~ O
M r
00 Q1
z r N U7 r O
N
W Z N r N tf> O bq
~ ~ O 0 V
> 5 a ~
W
J ~
y'
' ~ O
Q Z Z ~ O U
~. LL ~ V ~ ups v~ vs tss as ~ r~ e~ vi erg
J ~ N ~ 0 0 0 0 0 0 Z
_
~ ~ 0 0 0 0 0
: 0
~
' Q F- a
(A ~G
' v
r ~f
O o
O ~
0~ of
t0
Z
a Z
d~
O 0 M
M ~ Gf
p 00
r 0
O
O
C
O 01
V O 00
r -~
tp O
D
r
Of
1~ W
G ~ M 00 N CO M
Q `
V ~ ~ 0 00 0 O O 0 0 0 0 O O O O 0 0 0
'
~ O N O O O O O O O O O O O O O 0
N
/~ LL
V) I-' ~
N tD
O ao
d O ao
eh O
N N Clf
~ O
~
~
M
M
~
~
M
~i
W Z ~ O
() 00 00 e- r r 00
N r t0
N p
~ ~ ~ ~ ~ ~ M
,~
~
O a a
~ p~ ~ ~o
0
o
a pN CNn r
Ni °~ ~l i° F
~~ ~
O W M N N e
' ~
O } N N N ~"~ r N r r r r
W O to
O M d
0~ N N M O
OI r Z ~Y
'
Z r N ~
O
a
W Q
Q W
W
F- {
-
~ O X J O N
~ t ~
-~ p J J ~ W .~ Z ~ a
O O
a Q O z O
~
Q Q a
~ ~
LL x ~
Z a ~
~ Q
U a
V Y
~
~
O a
~ O
N >
O ~
V
~ w x W
~ cn ~ -
~' O w z z a W z a
~
p g w
a
~
~ ~
U' W
J
O g ~
W ~
Q w
J ~
_ g N
Y w
U F
.
J Z
~ m
0 C9
a v~
J N
Z ~
U m
~ a
x x
V N
U' t~
Z_ ~
W g
~
W
G -
O .
Z
-
~ ,~
Q
W
a Z ~
o W
~ O I- Z
m ~ O O W W F- O x a W
3 C7
v J J W O ~
~ O ~ ~ ~ ? W
o W
~ ~ ¢
~ ~
rn v o o a c~ o w ~ ~ cn t9 ~ w a ~ a m ~ cn o 3 o v ~
Ld
eA.
amr
..
aiw
Y
Qy
~F-1
~ ~ ~ Q
~ N
'
~
s~
on ~ ,
,
.
~ '° ~ ~ a,
.~ ~ ~ 3
3
~
b
\ ~ ov, o ~
.--~
~ Q o ~ ~. a
' ~
o
o ~ ~,
~
~ ~ ~ ~ o o
~ ~, ~
~ ~ ~ .~ ~ ~ a ~ ~ o ~
~p ~ ~ N ~ °+ ~ .~ ~ ~ C
N~ ~
~a 3c, ~0 3
~
~
~ ~ ~ a
i ~ d o ~ U «S
. ~
> ~ o ~ N ~ aai on ~ O ~
~ ~°~3~ '~ z
~
>~~ ~ ~ a
_
d ~
~+ . ~
U
O ~
~
S3, U . ~ ~' a
°Q o
~~ o
~ ~~z ~s
o .
0 3 '~ ca ~ o a~ ~° ~ ~ ,a? "
H N p •.. - y ''~
W ~ ~ O a> x
w Z
O ~ i
'a ~
c, ooQ ~ a
i
o ~ biD
>~~
~
~~
H O
E,
v~ a" ~ o
v ~ O ~ :' ~ ^o
a~ rn a~ o ;;
~ c~ '~ on
~ ~ . ~ o
as ~'
~ ~
A py t"' tFI~ .1 vi .~
~ w c°~ .C ~ (~ ° Q U °s.' C7 -v
O
~ fx
H ~ U
a D u
~-. F
-1 ~
F" d ~ q
b~ z z
~F ~ °
ao a ~ ~ ~ x ~3
~ ~
°~
3
~ ~ ~
•~
~
.-7 x
W P~ ~ ~
~, ~
~
o v a ~ o a,
U ~
o
~ W ~ ~
A - o ~ 3 .a ~ ~
-d ~ ~ o .o
W F
U ~
U ¢
C7 ~ II H
a ^ C7 y ~ II
rs! C7 >~ II
r~
Z ti II II II ~ II II II °~ II °?~
° ~. r, ., w .. .. ~. w „ w
a Q Q Q~ ~ Q ~ ~ Uv
U
D a
C4
~
C >~
,o b
~ ~
o
U
a~i
'~ ~,
II ~ y ~
~ c~ A ~ r, ~
~
W z ~ ~
~ ~? ~ a
.. O
~.
F °
o
.~
~
a
o >,
~ ~ ~
~^
a ~ ;
o
w a ~ ° \
~ o i a ~
°? ~
o ~. ~
~ ~°o
~ ~ ~ ~ II ro o~
° II 3 0~
° II 3 ~ o~
° II .
~ ~ ~ o
~° II
c~ A ~ h o O
°'o
o 0 °
oa ~, ~ °
~0 3a~ °
oo
~ . ~~
~
W U
~ II
~~ ~ ~ ~ II ~
~~
~ ~ ~
G..a II ~
~~ W ~ a
~ ~ II ~
~~ ~
~ N
i d~ II ~
~
C7
W a .
O ~ e~i O ,
`~ ~ o ~ O ~ O '~ ~ ~ d o _
~ ~ ~ oyi O
A a xw q U ~ qU imams qU i~~~ qU q
C7 ... ., q U
n
A
~
N
M
~
~/l
AGENDA ITEM # 4A
JANUARY 8, 2007
a~
° O O
~
N
~
N N
. N ~ ~
d
a ~ ,~
~
~
~ L
y ~ ~ r~.~ raj ~ C/1
~ ~ ~
~
~
b ~
A ~
b ~~_
•~ ~
.
~
.
~ ~ ~ ...
C ...
b ~
C
O
..a ° '~ ~ "CI .Z7
x° o a a o 0
° U ~ 6
°
o ~
~
~ A ~
as o
~'
°~ ~ ~
o v u ~ G
`
o ~ G ~ ~
a
~ w w ~ C
v~
i
~ a '
'y ~p ~ ~' ~' ~y "'fl
'C
~ o °
° ~, ° a ~
c ca
~ ~ b
~, ~ ^°
O .b r' .~ h h h p p~
U ~ cd ~ ti b ~ •
~i ~
~
~
~ 6
O O c
C
p U ~
F N
.~ b w..:~ y
C7 .~.:' ~
." d
~ •~
a
w b o
°
U
~ ~
F
~ p
FF ~
~ ~
o
~~
~
~ ~
~ >
~
~ b o o
•~ V
~" 04 .
~. c
d
CJ ] ~
~
W a F H Q~ 0 N 0 ~
'~ ~
'~ L~,~A ~
qW
O ~n U Q o t~ U a g o
~ A4
F ~ U
'
~ H i^
, U
F
.o ~' z z an
°p° U H O •~
U as
p~ ~
3a
~
~ ° ~~
° y ~
• o o w° o
v 3 ~
° °
°
.~ ~ 3 ~ 3 ., 3
~
~ 3 ~ ~ v
a. ~
z C ~
~~ a ~
~~ ~
a, ~
~ ~
a a ~
w ,~ o
a a
w F
~ U C7 ~ a a1 ^ a ~ ~
Pr ~ W ~
p ~ II II °23 II II ~ II II °~ II II °~ II II W
~ a A U U A U v U U A U U A U
~ U
U a ... ~..~ ..~ .~ ~ ... .,. ....~ `. ... `..,.
a
~
z
~ as
c -~ - w
~ ~
~ ~ A
~
~
~ z
~ a ~
~ o
a, a,
.. ° o 0 3 0
°\
~
°x ~
c~ a 3 0
H a ~
oo o
o
a ~ ~
o ~~ o ~ o
~ ~
~ ~ ~ II ~
. ~ II ~ c II ~ ; e II A ~ II
w .~ ~ °o ~ ~ °o = 3 o e ° ~
tx o c ~o ~ o 0
z A U o ~ ~ ~
~ ~ ~ ,~ a ;r ~ a ~ > 8 0 ;r
w v ~ w u ~ " ~ u ~ a II ~ o o li ~ pa ~ II ~
~„
O
a
3 ~ ~ ~
~ m o a 3
~
m
~
m
~
o v,
„
h
m
~
o ,p
~
c~ o ~
n ~
o ~ CS' ~
~ o
w
q w rn `. q U v~ 3 g U 3 A V v~ a A v O ~., A V
n
~
~o
~
o0
0~
°
AGENDA ITLM # 4A
JANUARY 8, 2007
.~
H
w
a
0
~,
N
H
~N
z~
0
m~
Cn H
w o
~„ z
H N
pl r-1
pq ..
?~ W
ww
H H
a P4
W r
x o
O
,~ F N
>~
U >+
~. '~ a
wo
V1 W
z
wm
U W
~, a z
W
U
N
a
3
~. z
~~
•• u
o ~
~ N
• W
h
O U
~ ~.~
N L
O ~.,
~ ro
H rl
a.i
a
~r q
W w
a o
a ~.
W ~
a •~+
~ a U
z
0
U
w
H
a
U
w
a
H
q
W
H
w
O
W
z
0
~~
~a
H l0 ~'1 N N O
1D N ~D [~ V' H
l0 N 01 H ~O 07
N O
i rl
i ul
i ~
i N
i
i
N N h ~D ~D l(1
~ r in ao r m
~o rn ui ~o a~ ~
sr ~ ui ~ a ~
0 o r+ o o q o
m rn ~ rn m W m
w
H
a
u
w
W
3
a
w
x
F
~ .~" W ~
~~
pi p, H O
o a z
0
U U ~
F H
H
U z
U 7
y
RC F W F
F "' ~ z
u v, u
i m
o ~ z ~ 0 0
a
z z
z z z z z
~ ~ ~ ~ ~ ~ ~
0 0 0 0 0 0 0
~ ~ ~ ~ ~ ~ ~
m ~n rn m m m r~
H O H O N N r-I
\ \ \ \ \ \ \
N N N N N N N
'-I H H H H H H
O H
O U Z
U h O
U z W
y
a
F
C U
u r, ~ rn ri ri
z r,
z r, z r,
u r, ri
~
w r,
Cn N ~ ~,
N ~,
N ] M
Cq N O N H N N
N Cn N N "j. N F N UJ N N
~ f'1 H f+l ~"l H R1 f+l
~ f+) ai Nl
a. ~
w a a w a w a uHa - a ua
w w w w w w w w uw z w w
H w a w
vi x H x o x a x - ~tx w x wx
v a u x u u a~uu a u xu
x a ~~ q a m~a uo~c a ~ a~
uqw aFw urx w HFw ~Fw ~ w qaw
oaw aHw s w aHw Few x[-aoo w co
a Fu ~a ou ma w wa
a~u z u qw u a v au w v a~u
~.] ' H W W H H A; W H a' V1 H O F H a H
a ~ ~
z w~ W~~ w
~
~ Hn~a a ~a m
d a
a a ~
~
aha zFa a Fa Fu,a ama z~a
° ° ~ ~
u~a uo~ ~ ~ oa a~~Q a°~ a~~
H lD N O1 r+1 V' O
r ~ r ~ r 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
i 0
~ 0
~
~
r ~
r i
t~ ~
r r r r
0 0 0 0 0 0 0
AGENDA ITEM # 4A
JANUARY 8, 2007
w
w
m
z
w
u
H
a
z
rx 0 0 0 0 0 0
H
~ .. .. .. .. .. U
~ UaZOC~H
~~aH~aa
i
i
W
W
w
w
u
a
0 0 0 0 0 0
U
Uaz0C7H
~CaH>aa
i
i
m
w
w
u
a
W ~o.~ooor
z
~ ~
a~
~ ~
H ~
o~
F ~
q ~ ..
~~uazooH
~~aH~aa
u