Exh 4AAGENDA ITEM #4A
JANUARY 24, ZOOS
City of Atlantic Beach, FI.
Utility Sates Report
December 2004 December 2003
Gallons Actual • Revenue Gallons Actual Revenue
Water Sales Accounts (000) Revenue ,Per 1,000 gl Accounts (000) Revenue Per 1,000 gt
Atlantic Beach 5,480 44,232 $120,367 , , , $2.72 ., 5,409 44,821 $89,915 $2.01
Buccaneer 2,663 28,547 $69,390 $2.43 2,550 28,802 $66,338 $2.30
Total Water Sales 8,143 72,779 $189,757 $2.61 7,959 73,623 $156,253 $2.12
Water Plant Produc tion
Gallons Gallons
(000}, (000)
Atlantic Beach 57,601 55,275
Buccaneer ~ ;2,856 30,983
Total Production 80,457 86,258
Total Water Billed ~ 72,779 73,623
Water Loss for month: 7,678 12.635
Percentage Loss 9.54% 14.65%
Total 12 mo. Avg. Loss 12.72% 13.42%
Gallons Actual Revenue Gallons Actual Revenue
Sewer Sales Accounts (000) Revenue Per 1,000 gi Accounts (000) Revenue Per 1,000 gi
Atlantic Beach 4,924 37,364 $162,727 4.36 4,856 34,173 $135,945 3.98
Buccaneer 2,548 27,847 $144,241 5.18 2,438 27,286 $125,416 4.60
Total Sewer Sales 7,472 65,211 $306,969 $4.71 7,294 61,459 $261,361 $4.25
Sewer Treatment
Millions of Gallons 66.92 70.15
Rev. r 1,000 Gallons $4.59 33.73
City of Atlantic Beach
FINANCIAL REPORT
DECEMBER 2004
Cash Balances
AGENDA ITEM #4A
JANUARY 24, 2005
Prior Current Dollar
Fund(s) 11130!04 12/31/04 Change
General $4,717,388 $5,572,522 $855,134
Tree Replacement 17,201 17,201 0
Convention Development Tax 149,996' 161,618 11,621
Local Option Gas Tax 296,386 , ~ • 302,41,6 6,030
BetterJax112CentSalesTax 1,151,306' ,1,136,086 (15,220)
Police Training, Forfeit, etc. 38,230 ~ " 39,928 ~ 1,698
Grants 11,223 829 (10,394)
Debt Service 86,922 31,829 (55,093)
Capital Project 39,979 40,022 43
Utility 3,963,359 3,974,921 11,562
Sanitation 535,597 530,354 (5,243)
Storm Water 1,388,070 1,550,497 162,427
Bond Construction 320 320 0
Pension -Police 10,558 5,072 (5,486)
Pension -General 64,486 (1,134), (65,620)
Total : • , .$12,471,021 $13,362,481 $891,460
Total Restricted Cash,.:.'` $6,292,089
Total Unrestricted Cash $7,070,392
Cash and Investments
Prior Current Dollar Rate of
Account 11!30104 12!31104 Change Return
Sank of America -Depository $73,293 $1,294,945 $1,221,652 1.07
SBA $12,395,678 $12,065,486 (330,192) 2.19
Cash on Hand $2,050 $2,050 0 -
Subtotal 12,471,021 13,362,481 891,460
Suntrust-Pension-Police 4,101,868 4,198,704 96,836 7.10 (1)
Merrill Lynch-Pension-Police 366,623 381,256 14,633 20.20 (1)
• Suntrust-Pension-General 5,471,863 5,684,384 212,520 7.00 (1)
Merrill Lynch-Pension-General 755,869 786,036 30,167 20.20 (1)
Subtotal 10,696,224 11,050,381 354,157
Total $23,167,245 $24,412,862 $1,245,617
(1) FYTD rate of return through 09/30/04
AGENDA ITEM #4A
JANUARY 24, 2005
City of Atlantic Beach
FINANCIAL REPORT
DECEMBER 2004
Revenues
Annual YTD - 25% YTD Dollar Percent
Fund / (Footnote) Estimate of Estimate Actual Variance Variance
General (1) $9,166,252 $2,291,563. $2,853,994 $562,431 24.54%
Tree Replacement 0 ~ ~ 0 0 0 100.00%
Convention Development Tax 177,000 4.4,250. 23,078 (21,172) -47.85%
Local Option Gas Tax 519,800 129,95,0 ~ 139;251 9,301 7.16°/a
Better Jax 1!2 Ct Sales Tax 617,300 15,4325 170,769 16,444 10.66%
Police Training, Forfeit, etc. 33,180 8,296 5,656 (2,640) -31.82%
Grants (2) 265,149 66,288 144,519 78,231 118.02%
Debt Service 73,035 18,259 18,419 160 0.88%
Capital Project 0 0 133 133 100.00%
Public Utilities 6,458,352 1,614,588 1,621,987 7,399 0.46%
Sanitation 1,319,500 329,875 321,635 (8,240) -2.50%
Storm Water 2,607,493 651,873 667,117 15,244 2.34%
Pension -Police (3) 523,361 930,840 320,452 189,612 144.92%
Pension -General (3) 775,943 193,986 512,285 318,299 164.08%
Total $22,536,365 $5,634,093 $6,799,295 $1,165,202
Analysis of Major Variances
(1) The $562,431 positive variance in the General Fund resulted from the receipt of
property taxes from the City of Jacksonville.
(2) The $78,231 positive variance in the Grant Funds resulted from cash being received in
fiscal year 2005 for the reimbursement of expenses incurred in fiscal year 2004 ($54,308
in the Community Development Block Grant & $57,465 in the FDOT - DU! Enforcement
Grant)
(3) The $189,612 positive variance in the Police Employee Pension Fund & the $318,299
positive variance in the General Employee Pension Fund resulted from increases in
the market values of the investments above estimates.
AGENDA ITEIVI #4A
JANUARY 24, 200
City of Atlantic Beach
FINANCIAL REPORT
DECEMBER 2004
Expenses
Annual YTD Estimate YTD Dollar Percent
Department ! (Footnote) Estimate 25% Actual Variance Variance
Governing Body $43,807 $10,952 $11,180 ($228) -2.08%
City Administration 1,878,828 469,707 - .461,560 8,147 1.73%
General Government (1) 3,976,583 994,147 668,329 325,818 32.77%
Planning and Building 697,108 174,278 ~ ~ .101,652 72,626 41.67%
Public Safety (2) 4,129,655 1,0'32,414 .686,665 345,749 33.49%
Parks and Recreation 976,291 244;073 201,185 42,888 17.57%
Public Works (3) 6,013,878 1,503,470 928,102 575,368 38.27%
Public Utilities (4) 7,489,105 1,872,272 2,043,060 (170,788) -9.12%
Pension -Police 337,266 84,317 72,480 11,837 14.04%
Pension -General 382,231 95,558 77,795 17,763 18.59%
Total $25,924,752 $6,481,188 $5,252,008 $1,229,180
Annual YTD Estimate YTD Dollar Percent
Resource Allocation Estimate 25% Actual Variance Variance
Personal Services (5) $7,434,659 $1,858,665 $1,573,605 $285,060 15.34%
Operating Expenses : 8,540,402 2,135,100 1,397,024 738,076 34.57%
Capital0utlay ~ 5,184,919 1,296,230 171,879 1,124,351 86.74%
Debt Service (4) ~ 1,756,403 439,101 1,357,407 (918,306} -209.13%
Transfers ~ 3,008,369 752,092 752,093. (1) 0.00%
Total $25,924,752 ~ $6,481,188 $5,252,008 $1,229,180
Analysis of Major Variances
(1) The positive variance in the General Government departments resulted from not having
begun some of 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 2005 for October through December 2004 and Lifeguard
services being seasonal (typically being expended June -August).
(3) The positive variance in the Public Works departments resulted from not having begun
some of the various projects funded from this source -see Project Activity Schedule.
(4) The negative variance in the Public Utilities departments resulted from the semi-annual
payment of principal and interest on the 1996 Utility Revenue Bonds in October
(5) The positive variance in the Personal Services is related to two things. The first is
vacant positions and the second is having recorded 100% of the first payroll and 36% of
the second payroll of October in the prior fiscal year.
City of Atlantic Beach AGENDA ITEM #4A
FINANCIAL REPORT JANUARY 24, 2005
DECEMBER 2004
• Project Activity -Current Year Activity Only
' ~ YTD YTD YTD
Project Name Budget Actual Balance Status
General Government:
• City Hall Expansion $409,264 $0 $409,264 I
City Hall Lobby Remodel ~ 35,000• 0 35,000 D
Subtotal , ,444,264 0 444,264
Parks and Recreation:
Skateboard Park • 180,827 1,296 179,531 D
Veteran's Memorial Park 34,000 0 34,000
Subtotal 214,827 1,296 213,531
Public Safety
Police Building Design 30,000 275 29,725
' Subtotal 30,000 275 29,725
0
Public Works:
Plaza Entrance/Post Office 100,000 0 100,000
Hopkins Creek Basin Pond 1,468,149 11,989 1,456,160 E
Mayport Road Medians r 551,942 0 551,942 E
Drainage-George & Dudley Streets ~ 107,723 0 107,723 D
Bike Paths on Seminole and Plaza ~' • •; 232,272 79,973 152,299
• ' Welcome Sign and Landscaping ~ 37,600 0 37,600
Ocean/13th -Coast Drive/12th 127,000 378 126,622
Shed -Equipment Storage 15,000 0 15,000
• Five Points Intersection Improvement 65,000 5,059 59,941 E
Sidewalks -New 80,000 0 80,000
' Pedestrian Path -Plaza Road 75,000 0 75,000 E
Sidewalks -Replacements 50,000 0 50,000 I
19th Street Ditch Bulkhead 12,000 0 12,000
• Subtotal 2,921,686 97,400 2,824,287
Public Utilities:
Replace Well 2 at WWTP1 6,389 6,389 (0) C
Security Upgrade/Water Plants 14,864 0 14,864 I
Telemetry at Lift Stations 90,811. 7,876 82,935 I
Headwork Improvements at WWTP2 330,000 0 330,000 D
Relocate Elevated Storage Tank at WP2 75,418 0 75,418 I
Kesner Road Waterline Replacement 33,938 0 33,938
Fence at Water Plants 1, 2 & 3 40,000 0 40,000
Water Line at 10th Street & Beach Avenue 200,000 0 200,000 E
Mayport Road Sewer Crossing 150,000 0 150,000 E
Lift Station Scada 50,000 0 50,000
Pond Liner Replacement 45,000 0 45,000
' Digester Blowers at WWTP 2 60,000 0 60,000
Utility Relocation - Wonderwood Connector 117,258 0 117,258 C
Subtotal 1,213,678 14,265 1,199,413
' Total $4,824,455 $113,236 $4,711,220
Status Key
B -Bid Awarded E -Design Phase
C -Project Completed I -Project In-progress
D -Design Completed
.__, R - Re-budget Next
.: Fiscal Year
0
0
N
m
W
W
O
H
Z
0
W
0
W
A G EN DA I TE M # 4A
J A NU AR Y 24, 20 05
~ w
N O N
O^ I
• 1
O Q ~ e!' M N CN t
9 0 1N fn r r r C7 e7 0
~ ~ M ~ H
U
w w
a Z
g
O
w
O
V
~ a
O
-~°
• Fa'• N~
V Z F
-
~ U
~ z
m -
Q
J
(n O
~"'
V C7
z
O ""
w
? w
~
~~~
N~
Z F-
w
~
v
v
w
a
~
z
°
a
~
la J
vo
w
z~ o J J w ~
m i
~
m
o
v
a v
i -
~ i
~
O
m V w a ,~ O t
-- r
i ~
i
~
i
~. ` ,' .
;
0
° 0
0 °
0 O
° O
0 O
° ~ o
° °
o
°
o
O
°
a
o
o
O
et
r O
ep co
r O
CD M
r O
!O (~
N W
~ N
er M
W t[j
OO p
O 1r
~A h
!D
~ u~ ch o ti m ~n J o~ ° r~ o ~ ~
tp
N
I tp
tD N
t1' 1~
M l'7
N tp
Qf
~
~
~
pp
r
~
O
~
N
~t~ N
N IO
~ r
et M
M 00
N W Z r
=
i Z O N m a
N
G ~
~ ~ ~ ~ ~
a~ U ~
J
i ~ W
0 N
0
Z L1. ' U
' ~ ~
vs
U w vs vs er- eri v~ ~ er- ~ vs us vs vs
= ,
~ 0
F-
0 0
o 0
o 0 0 0
z
.
o 0 a ~t o ao
Z O
O M'd' l0
M tD
r ~O
eP r
O r
M
OtA
U N M r
m r
a~ O
m N
v_ r
.r:
~
(n °o °o o °o °o °o °o, 0
o 0
0 0
0 0
0 0
0 0
0 0
0
U)
U)
N
ti
e~'1
~
~
r
O~f 0
E o
st r~
Of ~n
o is
o 0
O 0
ao
O O r et r tO r N tn r h ~ 1~
iFY V! W {I} !N V! ~ C~ ~ T' c7 N N O
I„„ ~"' ~ ~ ~ ~ r•
~
N. W
W °'
~'
O
~
O
~ N Qf
O
~
t0
~
O
(n
a^ N N ~ V' ~ ~ ~,,,
IL
O
M W ~ ~ Of ~ ~ ~ ~ r ~ ~ r ~ ~ ~ N ~ r c'f r N ~ tO MI M
w °o
° ~
N co ~' r
~^~ a ° ~
o a
O~
r o
N Z
~
Z}
o ¢ rn w ~ J
(L
a ~ Q p
~ g y p J J O ~ t F-
y
.
~ ^ J
s ~
o ~
w ~
a
J
-~
J a
>
a
a o
o c~
z p
t-
f- a I _ ~_ - a a Y o , ^ -
o
~ "' x w m
w u~ "- ~ Z m c~ w U z z a ~ z ¢ N
'
~ ~ w
J °
O
~ m
w w
J w
J ~
F- w
~ N
Y w
U
~ Z
~ v~
° c7 m
J
V7 m m
~ a
2 x
C~ ~ m ' 3
W '
3
D ~
O
~ W = ~ V (~ Z W, ~
W Z OI - ?. 7 D O W W 1 - O = a w O J J w O ~ ^ Q' ~ ~ ? W
n- ~ ^ ~ ° o v, ^ a ^ ^ w ^ c>c v~ c~ 3 ~n w a. ~ a. ~ V11 - u1 ^ 3 ^
c
c
u
c
C
i
C
a
u
'd
G
C
C~
L
C
LL
G
C
u.~
}
z
Q
Q
U