Item 4A v~.
o ~ S
:~
o `~ ~.
o °
o ~o
~~~~ ~
° ~ a~ o ~ ~
~~~ ~~ ~ o
o
~.
'Sr O ~ ~
~ 'C7 ~ o
N
~ ~ ~ s~ ~ e~
U ~
~ ~
a~
~°
~
Q ~ ~ ~,
~
° ~ti ~ ~
°~
•
~ ~
o
U b
~ ~ ~ o
~ o
,
~
y .
b
~
~ ~ ? ~ ^a s
~
a~ a, ~
a
o ~
.
~ -d <w ... ~, o .~
i U ' °
~ o o ~ ~ ~ >~ ~ ~ b ~ ~ cn
r
~ °.o °' ~ ao
°
U ~'~
o ~
•° a' D~
~' o ~ ~ ^
~
s~ ~
b°ip O ~ ~ ~ ~ O N O N ° Q ~ ~ ~ +r
~ a~ .? ~ ~ •.. ~ ~ ~ ~ ~ o a ~
~ a~
~
~ ~ N ~ ~ of ~ N ~ p ~ ' ~
~ y O c~
~'
. •
~ ~
~" c~ ~ O '~ ~ 'C7 C ~ W ~ ~ O ~ N ~' o v
~ a o
~ `~" ~
~ ~ p. ea
~
• o i
~
„ O ~ y ~ ~ ~ a ai 3 ~ ° O ~ ~ ~ °A ti o
Qp; E- ~;;°~ ~~; H a.~ ~ ~ ~~ ~ ~~ ~ a.~
p F o~ N ~' o~ O
Q o~ ~ ° ~
~
~
~
° d
U o
A
W
v~
U U~ 3 ~..., v~
w ~ ~. ~
A .
:
.
a
a a, o.~ a a a
U c, ~.
~ rx
F~
'~
F
r
.,
p
~ z Q .
,~ ~,
~ O „°
~ c Q ~ a
U ~ ~ ~
~ ~ ~ .~ 3 '~ ~ ~ ~ 3
a w z ~ ~ o~~ vb,~ °~~
~_. U ~
~" ~ o "' U
` .~a~ ~ a a paaa
w ~ ¢ ~u~ ~~u o~iu
U C7 Q.
C7 d d a sx
c c
,~
.~ ~
~. w .. ~ ~
~... w ~, ~
.~. ~,
E" a Q (.~ QUU LaUU ~ ~1UU
a
F" o
' b
~
o ~;
~
~ ,., ~
II
~ ~
~
Q
.,
~
4~
U z
~ ~
O N
~ ~
~ W
v
vi
w ~ c~ >~ o a~ o .b a1
a° ~ ~.
z U ~ ~ II `d ~ II 3 ~ II o
~ ~, ~ II o ~ ~ II
z q U oM .o ~ e .o o ° ,o a v o ,o
~ b ,o o ,o
w
z U ~, it v
~
~ ~ II ~
o
~ ~ ~ II v
~ ~ II v
~
~ o ~ II v
C~
"
~
C
7 h ~
~;
~ ~
~ Q„p. ~ '
~ o 4
o
w a ~ oyi o
o
x
qv v o
~
U :~ o ~ o ~ ~ o`'i o
a ~ ° ~ o
~
a a w q wc4 qv vi
, qU qv
a
II
..
~--~
N
M
~i'
v'~
AGENDA I'
EPTEMBE
AGEZyJ~AITE~ 2pp6
SEPTEMBER
H
AW
m
,H'~. H
~U
~~
3 ~'
a
~.
0
~~~
~ ~ ao ~ ~ ~
~~ ~ ~ b ~Go
~, .d r, ,n `*-'
~ ~ O G Y •~ J
N i'' ~ ~
00 ~ ~ xoo
" ~, on ~ A s.• U •
~a
o ~ ~ ~ fl" Y '~• ~'
~ q ..~ ~ O• ;~ ~- o
a.+
~ ~ ~ ~ ~ ^ ~
r
~ ,"n y N '~ `~ U ~
~. ~ ••~ d
~ ~ ~ v
N +~ cd
`° o ~ Ca o ~ `~ ~ ~
~~Z ~~ ~ r~ ~~~
yo3 ~~ o o ~,~o
"~ ~ c~a ~ ct~a
ao v p,,, a~ ~ ~ • ~c ~, o
a` y b0 ~ H w F Po a1 ~ ~ N
"~, Q
~'~ ~ ~ N +~-~ d UQ Ovr
V7 cUd '~ ~ ~, 3 ~
r~ ~" .~ r,"' N N
3 ~
U ~ ~"'
U
~ o ~ :~
x ~ T~
0 Oo- v ° x ~` ~ •~ ~ ~ ~ 11
w ~ ° ~ ~' ~ a' x ~ ~ d ~ q
0 0 ~'~ ~u U~ ~ u ~ r-^U
o U~ U W A ,•. •..~
O ti I~ It .~
~,, a Q ,,.~ .,~
U ~
O
.~ ~ ~
~ ~ ~
O ~ ~'' ~ v
n ~ a ~ :~ c ~ a ~, a
W O ?~ o p, ~, a~i ~ ' p• c~c c II a \ ~ ~' 0 0
pH., ~ °c~~ ~ ~G r~f~ 0 11 ~ 7 ~ o ~ °~ m lao 11
w ~~ y o n 3 a~~ o •~ •A '1t' 'U ,~ u ~
v-~ ~C Q
~ Ca ~ m O II `J . ~ .~N-1' bq ~n y ~ •'~'~ ~ ~ ~ ~ .,i Q U
~ +~-~ ~ ~A cad qv'j O ~ o,~`~ ~ q U ~ ~ 0
~ O .~ a'~ CV o0
A a. a' ~ A o0
n r-
A `~
AGENDA ITEM # 4A
SEPTEMBER 25, 2006
City of Atlantic Beach, FI.
Utility Sales Report
August 2006 August 2005
Water Sales
Accounts Gallons Actual Revenue
0000 Revenue Per 1,000 gi :
Accounts Gallons
0000 Actual
Revenue Revenue
Per 1,00o gi `<
Atlantic Beach
Buccaneer 5,630
2,576 60,617 $148,334 $2.45
31,143 $80,952 $2.60' 5,620
2,975 48,907
27,420 $112,971
$68,706 $2.31 <
$2.51
Total Water Sales 8,206 91,760 5229,286 52.50.,' 8,595 76,327 5181,677 52.38
Gallons Gallons
Water Plant Production 0000 0000
Atlantic Beach 69,704 65,626
Buccaneer 24,419 25,933
Total Production 94,123 91,559
Total Water Billed 91,760 76,327
Water Loss for month: 2,363 15,232
Percentage Loss 2.51 % 16.64%
Total 12 mo. Avg. Loss 9.68% 10.87%
Gallons Actual Revenue Gallons Actual Revenue
Sewer Sales Accounts 0000 Revenue Per 1,000 gi Accounts 0000 Revenue Per 1,00o gi
Atlantic Beach 5,103 44,120 $189,898 $4.30 5,068 37,624 $162,991 $4.33:
Buccaneer 2,461 25,289 $138,876 $5.49 2,590 26,165 $135,684 $5.19.
Total Sewer Sales 7,554 69,409 5328.774 54.74' 7.858 63.789 5298.615 54.68
Sewer Treatment Gallons
0000 Actual
Revenue Revenue
Per 1,000 gi Gallons
0000 Actual
Revenue Revenue
Per 7,000 gi ;
Atlantic Beach
Buccaneer 52.857
23.664 $189,898
$138,876 $3.59
$5.87 62.757
26.320 $162,991
$135,684 $2.60
$5.16
Total Sewer Treated 76.521 5328,774 54.30: 89.077 5298,675 53.35
City of Atlantic Beach
FINANCIAL REPORT
August, 2006
AGENDA ITEM # 4A
SEPTEMBER 25, 2006
Cash Balances
Prior Current Dollar
Fund(s) July, 2006 August, 2006 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
Total $26,855,305
Cash and Investments
,~ _ .~
Prior Current Doiiar Rate of
Account July, 2006 August, 2006 Change Return
Bank of America -Depository
SBA
Cash on Hand
Subtotal
Police Pension Investments
General Pension Investments
Subtotal
~.
$5,501,077
20,913
160,580
348,541
1,031,579
(20,408)
(22,529)
64, 994
3,953,201
530,227
2,798,054
8,683
55,166
$14,430,078
$87,429
14,340,099
2,550
14,430,078
5,027,847
7,397,380
12,425,227
$5,454,768
20,913
161,276
254,819
1,083,336
(608)
(88,447)
71,122
4,155,101
488,139
2,811,929
10, 262
59,442
$14,482,052
$6,569,321
$7,912,731
$214,471
14,265,031
2,550
14,482,052
5,119,570
7,537,295
12,656,865
$27,138,917
($46, 309)
0
696
(93,722)
51,757
19,800
(65, 918)
6,128
201,900
(42,088)
13,875
1, 579
4,276
$51,974
$127, 042 4.32
(75,068) 5.39
0 -
51, 974
91,723 5.70 (1)
139,915 6.20 (1)
231.638
$283,612
(1) FYTD rate of return through 06/30/06
~.
~.
City of Atlantic Beach
FINANCIAL REPORT
August, 2006
Revenues
Annual YTD - 92% YTD Dollar Percent
Fund / (Footnote) Estimate of Estimate Actual Variance Variance
AGENDA ITEM # 4A
SEPTEMBER 25, 2006
General (1) $9,951,978 $9,125,964 $9,685,416 $559,452 6.13%
Tree Replacement 0 0 0 0 0.00%
Convention Development Tax 128,000 117,376 58,763 (58,613) -49.94%
Local Option Gas Tax 564,042 517,227 511,746 (5,481) -1.06%
Better Jax 1/2 Ct Sales Tax 702,336 644,042 718,697 74,655 11.59%
Police Training, Forfeit, etc. 31,800 29,160 33,061 3,901 13.38%
Grants (2) 508,111 465,938 149,608 (316,330) -67.89%
~,. Debt Service 71,100 65,199 66,526 1,327 2.04%
Utility 6,779,543 6,216,841 6,089,760 (127,081) -2.04%
Sanitation 1,362,300 1,249,229 1,201,420 (47,809) -3.83%
Storm Water (3) 1,067,868 979,235 695,009 (284,226) -29.03%
°.
Pension -Police 702,355 644,060 742,153 98,093 15.23%
Pension -General (4) 1,015,029 930,782 1,144,390 213,608 22.95%
Total $22,884,462 $20,985,053 $21,096,549 $111,496
Analysis of Major Variances
(1) The $559,452 positive variance in the General Fund resulted from having received
103% of the year's budgeted property taxes by August, 2006. Typically the majority of
these taxes are received from the City of Jacksonville in December & January.
(2) The $316,330 negative variance in the Grant Funds resulted from either items not
having been purchased or reimbursement requests not having been filed as of August
31, 2006.
(3) The $284,226 negative variance in the Stormwater Fund resulted from the awara of a
grant in fiscal year 2006 that has not been received.
(4) The $213,608 positive variance in the General Employee Pension Fund resulted from
changes in the market values of the investments.
..
~.
City of Atlantic Beach
FINANCIAL REPORT
August, 2006
AGENDA ITEM # 4A
SEPTEMBER 25, 2006
Expenses
Annual YTD - 92% YTD Dollar Percent
Department / (Footnote) Estimate of Estimate Actual Variance Variance
Governing Body $53,538 $49,094 $44,454 $4,640 9.45%
'*" City Administration 2,177,933 1,997,166 1,712,949 284,217 14.23%
General Government (1) 2,256,185 2,068,922 1,031,819 1,037,103 50.13%
Planning and Building 684,579 627,759 471,028 156,731 24.97%
Public Safety (2) 4,736,835 4,343,679 3,678,543 665,136 15.31%
Parks and Recreation 1,022,247 937,400 854,783 82,617 8.81%
Public Works (3) 6,214,842 5,699,010 4,204,868 1,494,142 26.22%
Public Utilities (4) 7,266,608 6,663,476 5,848,790 814,686 12.23%
Pension -Police 400,936 367,658 362,444 5,214 1.42%
Pension -General 405,798 372,117 375,606 (3,489) -0.94%
Total $25,219,501 $23,126,281 $18,585,284 $4,540,997
Annual YTD - 92% YTD Dollar Percent
Resource Allocation Estimate of Estimate Actual Variance Variance
Personal Services (5) $7,851,980 $7,200,265 $6,680,797 $519,468 7.21%
Operating Expenses (2) & (3) 9,653,367 8,852,137 7,728,536 1,123,601 12.69%
Capital Outlay (1) & (3) 5,246,841 4,811,353 1,774,456 3,036,897 63.12%
,s Debt Service 1,678,236 1,538,942 1,678,174 (139,232) -9.05%
Transfers 78J,077 723,584 723,321 263 0.04%
Total $25,219,501 $23,126,281 $18,585,284 $4,540,997
Analysis of Major Variances
w.
~..
(1) The positive variance in the General Government departments resulted from not having
begun the various budgeted projects -see the Project Activity Schedule.
(2) The positive variance in the Public Safety department is due to the payment for the City of
Jacksonville fire contract being paid quarterly, the lifeguard expenses being seasonal, two
vacant positions in the Patrol division and no expenditures in some of the grants.
(3) The majority of the positive variance in the Public Works department resulted from not
having begun the various budgeted projects -see the Project Activity Schedule. Also, the
waste management contract and First Vehicle are not billed and paid until the month after the
services are provided.
(4) The positive variance in the Utility Fund resulted from not having begun the various
budgeted projects -see the Project Activity Schedule. Also, there are vacant positions in the
Sewer Wastewater division and the professional/contractual services are less than budgeted
amounts.
(5) The positive variance in Personal Services is due to vacant positions in Information
Technology, Sewer Wastewater, Police Department Patrol Division, Building Department,
Finance Department and the Lifeguard positions being seasonal.
~.
City of Atlantic Beach
FINANCIAL REPORT
August, 2006
AGENDA ITEM # 4A
SEPTEMBER 25, 2006
Project Activity -Current Year Activity Only
Project YTD YTD YTD
Project Name Number Budget Actual Balance Status
Parks and Recreation:
Beautification PR0601 45,000 0 45,000
Subtotal 45,000 0 45,000
Public Safety
Police Building Renovations PS0504 475,000 8,570 466,430
,~ Homeland Security Items PS0601 138,000 0 138,000
Subtotal 613,000 8,570 604,430
Public Works:
'~ Plaza Entrance/Post Office PW0305 54,686 54,686 0
Hopkins Creek Basin Pond PW0309 1,300,000 5,600 1,294,400
Mayport Road Medians PW0401 346,858 55,858 291,000
!~ Welcome Sign and Landscaping PW0405 78,000 3,852 74,148
Ocean/13th -Coast Drive/12th PW0409 141,816 141,797 19
Five Points Intersection Improvement PW0502 346,599 335,136 11,463
Sidewalks -New PW0503 26,175 26,175 0
~ Plaza Drive Phase 2 Pedestrian Path PW0504 37,500 37,109 391
Sidewalks -Replacements PW0505 5,864 5,864 0
Seminole Ditch Headwall PW0507 12,974 12,974 0
"" Pathway -Plaza (West of Mayport Road) PW0508 27,144 27,144 0
Concrete Floor for Shed ~ PW0601 8,800 8,800 0
Medians Rehab -Atlantic Boulevard PW0602 3,500 0 3,500
,~ Roll Off Concrete Pads PW0603 10,455 10,455 0
Sidewalks & Curbs PW0604 50,661 38,690 11,971
Paving of City Hall Parking Lot PW0605 79,130 79,128 2
Pathways PW0606 149,000 2,500 146,500
"'" Sidewalks - Sailfish,Royal Palm & Frances PW0607 90,800 40,580 50,220
Selva Tierra Ditch Improvements PW0608 25,954 25,954 0
Pathway -Seminole Road Phase 1 PW0609 63,000 62,973 27
.. Pathway -Seminole Road Phase 2 PW0610 46,516 ~ 45,496 1,020
Traffic Isle -Mandalay Park PW0611 17,000 16,068 932
2,922,432 1,036,839 1,885,593
Public Utilities:
Security Upgrade/Water Plants PU0305 2,485 2,485 0
Headwork Improvements at WWTP2 PU0310 52,027 52,027 0
Water Line at 10th Street & Beach Avenue PU0503 83,446 83,446 0
Lift Station Scada PU0505 5,820 5,443 377
Fence Replacement at Water Plant 1 PU0601 67,164 4,509 62,655
Water Main at Sailfish Drive & Plaza PU0602 68,539 51,872 16,667
~ Sewer Crossing Ditch at Palm Landing PU0603 30,000 0 30,000
Genset at Lift Station B PU0604 26,507 0 26,507
Clarifier Rehabilitation PU0605 132,020 0 132,020
"'" Fence Replacement at WWTP 1 PU0606 12,637 1,491 11,146
Sludge Container Refurbishment PU0607 8,900 0 8,900
Beach Habitat Subdivision PU0608 214,604 0 214,604
Subtotal 704,149 201,273 502,876
~, Total $4,284,581 $1,246,682 $3,037,899
,~, Status Key
B -Bid Awarded E -Design Phase
C -Project Completed I -Project In-prog ress
D -Design Completed R - Re-budget Nex t Fiscal Year
~.
E
C
E
E
I
C
I
C
C
C
C
C
C
C
I
C
C
C
C
C
C
C
C
C
I
I