Item 4A A
~~
~
O
O
O R e3
~ ~N N
' ~ p; °ppO O O ~
ti . ~ '~'
at ~t
U d 0
'b U N
~ ^C
~ N
o
.~ y
~ a
a ° c.
~D
.
N n a
~. ° ''?
w ~ '°
o ~
A ~
c ~" ~ `~ :° ~ °O A
~
p A
~~
p~ ~ ~ ~ ~
N 't3
~
p
N y i"'~ C~ bA O
U p~
O 'Ly ,s!
~ ~ ~ "d p , j U ..G 't" "~ ~
O y
a~
^O 'b N U
d rn
p ~ U y
~
~ ~,
ao +:,
a°~i
~
is ~ „
N c~ W ~~
rr
/-r ° ~ ~" i.i
z w coo
~ ~° ~ ~
° ~' o -d ~ .c ~ ~
°
p p ~ io (~ i
b y p N
N ~+ N Q~
~ , N
Q~ ~~
b0 ~ GL U~
y
.~ ~
vp w
O ~ Z .~ .~ '0 bA
~ ~ ,~-~' N
bQ ~ ~ O
~ .~ ..~ .
a°i o. 3 O ~ °' A
z M ~~ a ti ~ ° g
w ~ ~
~ ~~.~ X00 0 ~~~~ 0 ,~
3'au
V1 U .C N v~ ++
~ F" U "~ ~ ~ ~ "O ~
U p ~ ~ ~+ ~ ~"'
wp ~ F _
~.n ~~*r
~ ~ O
SAN ~
o0 b~A
00~, a ~ q
AW E^
z v~ ~-7 v
i.~~ L=rWM UN ~"d C7 UQ
Fa o
~ A ~
~~ z z ~ ~~
~~ o o ~ ~ ~
U ~ ~
O Ci ~
3
~
°~ ~ ~'
S
O ~ ,.'~ ~,
^~ . ~ ~
~
°°
~3
v ~
A i b
X 0 3 ~
~ S a o
X 0 3 °~ o
~w 3
x
a ~ z ~„'~ a U ~ b a
a ~.~ ~ a W
u
~ a~ a n 8~
z U
w ~
'^' O W~
'1 Q U ^ yy
P4 ~4
p "~ II it ~ II tl II ~ II ~ II ~ II Il
E, ~ .~..~. W
A U U .-.
A ,-• .-. W
A U U `-. .-. W
A U U .~.
U .~
A
a
H
z
o
O ~ ~ ~
'
~
n i ~ '
~
~
.. ~ ~ ap o O «3 W
x
w F
a OA c
x o o
~' o ~ i3 0
'° ~
a ~ o
.~o ° ~
~ c,
~ t
~ o II
b o II ~
_
A ~ o II ~
II
"~
~
~
3
(y
z
4
cU. o p
~
N O Q
.ti ~ O 0
-~
~ ~
'n N
~O
~
,~
~ a
i
~
~
z ~ ~~ tl o II ~ ~ o u a o ~~ ~ ~¢ 3
~.,
w
a h
o ~~ o o ~ ,,, h
~ eyi o ~ s. ... h
v~ d o ~ ~.., ~
o °' ~ o y , O
~
ca
u
a,
x w A U
E A U
O V A U
nG .~ a, U a
i
C7 rn
E-•
..
A
~-'
N
M
~
v~
\D
AGENDA ITEM # 4A
JANUARY 14, 2008
City of Atlantic Beach 1~ a Y 4M oog
FINANCIAL REPORT
NOVEMBER 2007
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
Storm Water
Pension -Police
Pension -General
Total
Total Restricted Cash
Total Unrestricted Cash
Prior
10/31 /07
Current
11 /30107
$4,484,907
9,713
208,381
295,426
1, 366, 964
62,140
103, 040
84,608
27, 560
3, 268, 372
397,960
2,353,355
2,668
31,981
$12,697,075
$5,507,036
9,713
211,829
269,051
1,311,531
64,878
103,040
27,298
55,060
3,374,432
391,635
2,443,979
(6,143)
41, 204
$13,804,543
$6,889,081
$6,915,462
Cash and Investments
Account
Bank of America -Depository
SBA
Banc of America Securities LLC
Cash on Hand
Subtotal
Police Pension Investments
General Pension Investments
Subtotal
Total
Prior
10/31 /O7
$434,611
12,259,914
0
2,550
12,697,075
6,024,256
9,249,176
15,273,432
$27,970,507
Current
11 /30107
$1,291,993
10,000
12,500,000
2,550
13,804,543
5, 916, 965
9,089,590
15,006,555
Dollar
Change
$1,022,129
0
3,448
(26,375)
(55,433)
2,738
0
(57,310)
27, 500
106,060
(6,325)
90,624
(8,811)
9,223
$1,107,468
Dollar Rate of
Change Return
$857,382 4.73
(12,249,914) 5.00
12,500,000 4.03
0 -
1,107,468
(107,291)
(159,586)
(266,877)
$28,811,098 $840,591
14.40 (1)
14.80 (1)
(1) FYTD rate of return through 09/30/07
City of Atlantic Beach
FINANCIAL REPORT
NOVEMBER 2007
Revenues
AGENDA ITEM # 4A
JANUARY 14, 2008
Annual I YTD -16.7% YTD Dollar Percent
Fund / (Footnote) Estimate of Estimate Actual Variance Variance
General (1) $11,336,598 $1,893,212 $2,381,243 $488,031 25.78%
Tree Replacement 0 0 0 0 100.00%
Convention Development Tax 90,500 15,114 8,914 (6,200) -41.02%
Local Option Gas Tax 537,196 89,712 56,294 (33,418) -37.25%
Better Jax 1/2 Ct Sales Tax 831,885 138,925 124,167 (14,758) -10.62%
Police Training, Forfeit, etc. 47,530 7,936 5,875 (2,061) -25.97%
Grants (2) 271,690 45,372 103,040 57,668 127.10%
Debt Service 70,966 11,851 11,782 (69) -0.58%
Capital Projects 330,000 55,110 55,060 (50) -0.09%
Utility (3) 9,585,150 1,600,720 1,072,502 (528,218) -33.00%
Sanitation 1,762,230 294,292 292,873 (1,419) -0.48%
Storm Water (4) 3,162,675 528,167 325,850 (202,317) -38.31%
Pension -Police (5) 745,841 124,555 56,044 (68,511) -55.00%
Pension -General (5) 1,244,005 207,749 142,644 (65,105) -31.34%
Total $30,016,266 $5,012,715
8
Analysis of Major Variances
(1) The $488,031 positive variance in the General Fund resulted from having received 26%
of the budgeted property taxes. Typically the majority of these taxes are received from
the City of Jacksonville in December & January.
(2) The $57,668 positive variance in the Grant Funds resulted from the reimbursement of
expenses from the prior fiscal year in October, 2007.
(3) The $528,218 negative variance in the Utility Funds resulted from not having received
the monies budgeted for the St. John's River Water Management District grant & bonds
to be issued in fiscal year 2008 in the Sewer Fund.
(4) The $202,317 negative variance in the Storm Water Fund resulted from not having
received the monies budgeted for the Hopkins Creek Project. This project is scheduled
to begin in December, 2007.
(5) The $68,511 negative variance in the Police Employee Pension Fund & the $65,105
negative variance in the General Employee Pension Fund resulted from changes in
market values of the investments.
City of Atlantic Beach
FINANCIAL REPORT
NOVEMBER 2007
AGENDA ITEM # 4A
JANUARY 14, 2008
Expenses
Annual YTD -16.7% YTD Dollar Percent
Department / (Footnote) Estimate of Estimate Actual Variance Variance
Governing Body
City Administration
General Government
Planning and Building
Public Safety (1)
Parks and Recreation
Public Works (2)
Public Utilities (3)
Pension -Police
Pension -General
$47,760 $7,976 $7,919 $57 0.71
2,184,959 364,888 346,986 17,902 4.91%
1,258,362 210,146 222,878 (12,732) -6.06%
503,305 84,053 62,354 21,699 25.82%
5,492,461 917,242 548,727 368,515 40.18%
354,137 59,141 68,416 (9,275) -15.68%
9,699,728 1,619,854 1,067,670 552,184 34.09%
10,125,589 1,690,973 1,869,137 (178,164) -10.54%
330,591 55,209 67,920 (12,711) -23.02%
371,843 62,098 79,335 (17 237) -27.76%
Total $30,368,735 $5,071,580 $4,341,342 $730,238
Annual YTD -16.7% YTD Dollar Percent
Resource Allocation Estimate of Estimate Actual Variance Variance
Personal Services (4)
Operating Expenses
Capital Outlay (1) & (2)
Debt Service (3)
Transfers
$8,474,591 $1,415,257 $1,095,776 $319,481
9,911,536 1,655,227 1,382,651 272,576
7,999,539 1,335,923 190,376 1,145,547
1,683,795 281,194 1,289,327 (1,008,133)
2,299,274 383,979 383,212 767
Total $30,368,735 $5,071,580 $4,341,342 $730,238
22.57%
16.47%
85.75%
-358.52%
0.20%
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 2008 for October through December 2007. Also, there are
vacant positions in the Police Patrol division and the Police Building project has not
begun -see Project Activity Schedule.
(2) The positive variance in the Public Works departments resulted only 1 of 2 monthly
payments being made on the Waste Services of Florida, Inc. and First Vehicle contracts
and 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 and not having begun
various projects funded from this source -see Project Activity Schedule.
(4) The positive variance in the Personal Services is related to 57% of the first payroll of
October, 2007 being expensed in the prior fiscal year and vacant positions that have not
been filled.
AGENDA ITEM # 4A
JANUARY 14, 2008
City of Atlantic Beach, Fi.
~
i Utility Sales Report
November 2007 Novem ber 2006
~.
,.,>
_,
_ ,,.
, ~ 1
~.,,„„~
;, ~
~ ,
Gallons Actual Revenue "`, Gallons Actual Revenue
Water Sales ~; Accounts
+ 0000 Revenue Per 1,000 gi ; Accounts 0000 Revenue Per 1,000 gi
Atlantic Beach r
5,636
43,498
$122,293 ~
$2.81 ~
5,613
51,765
$131,082
$2.53
Buccaneer 2,476 22,607 $73,176 $3.24'~i• 2,540 23,815 $67,232 $2.82.
Total Water Sales 8,112
i:' 66,105 5195,470 62.96 ~~ 8,153 75,580 ;198,314 ;2.62 .
Gallons Gallons
Water Plant Production 0000 0~0
Atlantic Beach 54,661 60,471
Buccaneer 19,792 19,248
Totaf Production 74,453 79,719
Total Water Billed 66,105 75,580
Water Loss for month: 8,348 4,139
Percentage Loss 11.21 % 5.19°~6
Total 12 mo. Avg. Loss 13.16% 10.56°~
. , .., . ~,H~a, 1; ~ ~„~
.. ..
Gallons Actual Revenue ~' Gallons Actual Revenue
Sewer Sales ~ Accounts 0000 Revenue Per 1,000 gi ~~~ Accounts 0000 Revenue Per 1,000 gi
Atlantic Beach 5,112 33,797 $176,380 $5.22 '~ 4,081 37,564 $171,685 $4.57
Buccaneer 2,335 21,135 $138,779 $6.57 z; 2,422 22,417 $129,317 $5.77
Total Sewer Sales ?:~ 7,447 54,932 5315,158 ;5.74 "~~
~, 6,503 59,981 6301,002 65.02
Gallons Actual Revenue .? Gallons Actual Revenue
Sewer Treatment ~ 0000 Revenue Per 1,000 g~ 0000 Revenue Per 1,000 gl
Atlantic Beach
47.872
$176,380 `,
$3.68,:';;
47.959
$171,685
$3.58
Buccaneer 20.057 $138,779 $6.92 ~°; 21.076 $129,317 $6.14
Total Sewer Treated
>, ''
;=
~:
~-, 67.929
~, 6315,158 64.64 ~ 69.035 6301,002 64.36
AGENDA ITEM # 4A
JANUARY 14, 2008
City of Atlantic Beach, FI.
Utility Sales Report
, December 2007
.
- Decem ber 2006
..
,.. _,.,
.;;.. ,
..., .. ~
r . _
Gallons Actual Revenue Gallons Actual Revenue
Water Sales ';~ Accounts 0000 Revenue Per ~,oo0 9i =r Accounts 0000 Revenue Per ~,ooo ~
;:~
,~
Atlantic Beach 5,580 43,474 $122,036 $2.81 :' 5,568 44,855 $113,747 $2.54
Buccaneer 2,460 22,919 $72,921 $3.18 ~': 2,456 24,805 $69,909 $2.82
Total Water Sales - 8,040 66,393 $194,957 $2.94 ~?~ 8,024 69,660 5183,656 $2.64
.r:- , ~
Gallons Gallons
`' Water Plant Production o000 0000
Atlantic Beach 54,908 43,834
Buccaneer 18,723 34,833
'~ Total Production 73,631 78,667
Total Water Btlled 66,393 69,660
Water Loss for month: 7,238 ~ 9,007
°'~ Percentage Loss 8.83°h
_-- 11.45%
Total 12 mo. Avg. LOSS 13.05% 11.02%
Gallons Actual Revenue ` Gallons Actual Revenue
SBWer Sales ~~ Accounts 0000 Revenue Per a,ooo gl -'' Accounts 0000 Revenue Per ~,ooo s~
Atlantic Beach 5,072 33,701 $177,040 $5.25 y : 5,033 34,206 $160,380 $4.69
Buccaneer 2,333 21,212 $138,184 $6.51 ~ 2,339 23,135 $134,402 $5.81
Total Sewer Sales 7,405 54,913 $315,224 $5.74'; 7,372 57,341 $294,782 $5.14
Gallons Actual Revenue `; Gallons Actual Revenue -
.;Sewer Treatment ~ 0000 Revenue Per 1,000 e~ '",: 0000 Revenue Per 1,000 gl
Atlantic Beach 44.651 $177,040 $3.96 , 47.959 $160,380 $3.34
Buccaneer 21.741 $138,184 $6.36.;, 21.076 $134,402 $6.38:"
Total Sewer Treated 66.392 $315,224 $4.75 69.035 $294,782 $4.27 `,
City of Atlantic Beach
FINANCIAL REPORT
NOVEMBER 2007
Project Activity -Current Year Activity Only
AGENDA ITEM # 4A
JANUARY 14, 2008
Project YTD YTD YTD
Project Name Number Budget Actual Balance Status
Public Safety
Police Building Design
Police Building Remodelling
Subtotal
Public Utilities:
Shangri La Sewer Improvements
TMDL Engineering WWTP 1
SCADA Improvements
Collection System Inspection & Rehabilitation
Hydroscreens
Taper Bottom of Equipment Tanks
Reclaimed Water Plant Construction
Fence City Property at Plant
Subtotal
Public Works:
Fence
Shelter at Donner Community Center
Lights at Veteran's Park
Buchman Trust Property
Hopkins Creek Retention
Mayport Road Medians
Storage Bins for Limerock
Sidewalk & Curb Replacement
Ocean Boulevard Between 14th & 15th Street
Royal Palms Valley Gutter
Pedestrian Paths Extensions
Sidewalk at George & Edgar Street
Sidewalk at Ardella &Mayport Road
Contingency for Sidewalks
Sidewalk & Curb Replacement
Ardella Road Drainage Project
Royal Palms Design
PS0504 330,000 0 330,000
PS0504 28,632 25,953 2,679
358,632 25,953 332,679
PU0704 58,109 0 58,109
PU0706 510,000 0 510,000
PU0801 30,000 0 30,000
PU0802 829,000 0 829,000
PU0803 30,000 0 30,000
PU0804 22,593 0 22,593
PU0805 1,800,000 0 1,800,000
PU0806 6,000 0 6,000
3,285,702 0 3,285,702
PM0801 8,000 0 8,000
PM0802 30,000 0 30,000
PM0803 15,000 0 15,000
PM0804 650,000 0 650,000
PW0309 1,570,072 10,119 1,559,953
PW0401 400,000 0 400,000
PW0701 26,272 26,272 0
PW0705 2,819 0 2,819
PW0708 264,769 109,244 155,525
PW0801 20,000 0 20,000
PW0802 100,000 0 100,000
PW0803 30,000 0 30,000
PW0804 25,000 0 25,000
PW0805 10,690 0 10,690
PW0806 30,000 0 30,000
PW0807 75,000 0 75,000
PW0808 400,000 0 400,000
Subtotal 3,657,622 145,635 3,511,987
Total $7,301,956 $171,588 $7,130,368
Status KeV
B -Bid Awarded E -Design Phase
C -Project Completed I -Project In-progress
D -Design Completed R - Re-budget Next Fiscal Year
D
E
C
I
I
w
z
w
u
H
a
a
Wes,-ioooooo~
z ~ ,~
~~
a.
I
F ~
O ~
F ~
q I
i
I va.zoc~rxwu~
~ ~ ~CaH>aaoo]a
AGENDA ITEM # 4A
JANUARY 14, 2008
~ o m ~ ~n a ~ u~ o ~
~ ~ ~ t+7 'i H Q1 H ~ l!1 H m N N m
~ d' aM V~ H 10 ~ H ''"~ 1D 10 p
~ ~ I I I I 1 ~ ~ r m N N r
I ~
u~ vi a cr <r ~ .-~ `n `"~ N ~ r r rn
m O r N N r ~D [O r ~ ~ ~ d' H
~ ~ I ~ I i i I r ~ N N N N
Cn O m O r0 ~ ~ d' cr vl p ~ ~ ~ I
O O O m O O ~ ~ d'
a ~ a ~ 1D 01 ~ Ol 01 a 01 01 H CO Q, H ~ ~ °
U
z° °z ~ z A z o
~' z
w W
~ H ~ H
~ ~ ~ w o w o w
F g ~.., 2
H o U ~ ~ A x ~
a ~ '~ H U H O H Q'
~ 4 a w a ww F ~ a
~ o w H ~ ~ a °
w w a~ a ~ H ~' w vi $ w o
a W w \ w A w U
w W o o ~ a w a w \
U U W U r.G U W ~
~ ~"'~ U a w cn H a H O ti H
w w v w ~ A w a w Q w ~ r a
~ ~' aka a w~ ~ ~' z `~ ~ `~ z z z
a F JWG \ H U
''" H Z O a 3 cn U vUi a ~ O O a
~ ~ H £ W ~ f ~ E ~ g ~ F"' Q
Q U
W W 3 z z z W 3 3
z z z z z z z z ``' W
z z z
r r r r r r r r r
° o 0 0 0 0 0 0 o r r r r r
M ~ \ \ \ \ \ \ \ ~ ° ° 0 0
O N r0 O W O lfl O r t71 m ~ ~ \
H r-1 O N O H
\ \ '~ \ \ \ \ \ \ O H H H N
N N N N N N N N N \ \ \ \ \
"~ .-1 e-1 H ~-i H H .-~ ~...~ ~ ~ N N N
H H ,~.~
~ ~ a
U U
F F W
W ~ U H
a a a H °
u
H ~ ~7 ri z M U r~ U rn a M r~ W r~ a M ,.i ,•~ ,.,i n~ ~
^~ cC r+~ r~ r+~ W r~ rn uJ ri r•~ ,•~ r.i n.~ N
N W N a N M
a rl F~ ~+Nj ~ ~ CQ N A N ~ N N F N a N N N N N N
O U A ri q r~ W ri A rn a m ~ N N z ~ r'1 N rn N N
F a a a u a u a a ~ ~ W W H
aFw waw v w ~ w H w v w mw ~cFi~w a~w w craw °iHa aH,.a a
H s u a w x ~ x w x w x z a x a x E F x a F x x a °~ x rx ~ x a~ x z x
u°wm Q~wm zu~ oxw axw aaw ~W °3W ~~w wHw ~Ha x>Q y~¢ Q
Fw zaw aw cn w
u uau uU FAQ awe' xHC° vFiq~ zHm wz~m wmm www wFw
UEU cnaU H awH xw~ zvu acne I cnu arxu °UU zau ~z~U ~z~u u`nu
H H H w W H
~~E" W WzFz P,'AF FC W F r1' W2zF zUzx2Fzr3zzF W rtzFz °UFZHz gAZFz w~CF x W zFz x W F CnFF
Ho~ FMrl rncn~ cFi~o~ Fnorl rSmQ 5~nr.~ ~ a F~cZ ~m~( W m~ aO~C .~70~ .7a~
Fin.] r,7 H~F 4~F wr,.a W o,..7 zN.] W N«.7 cn~~-7 3F..7 a,r~? .7 ~.] .7 .~ HN..]
a~a ~~Q r10~C UHC~ U~~ U~r.~ U~RC AaQ W ors W pF W of OoF OoF xHF
~ a. x~~ x~o~ ar,~
m ° m in a r
r m r-i m m m r m ~ o ~ m m m
~ ~ ~ ~ ~ ~ m m m m mm ~ m m
° ° 0 0 0 0 0 0 0 ~ 1D ~D `D `D
° 0 0 0 0 0 0 0 0 0 0 ° ° o
° ° ° 0 0 0 0 0 0 0 ° ° o 00
°, ° 0 0 0 0 0 0 0 °o °° o° o 0
m m m m m m m ~
° ° 0 0 0 0 0 o m ~ m m °~ m ~
0 0 0 0 0 °
a