Exh 4ACity of Atlantic Beach
FINANCIAL REPORT
AUGUST 2005
AGENDA ITEM #4A
SEPTEMBER 2G, 2005
Cash Balances
Prior Current Dollar
Fund(s) 07/31/05 08/31/05 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,326,266
$7,653,097
Cash and Investments
Prior Current Dollar Rate of
Account 07/31/05 08/31/05 Change Return
Bank of America -Depository $33,282 $298,562 $265
280 2
03
. SBA $14,066,702 $13,678,751 ,
(387,951) .
3
07
Cash on Hand $2,050 $2,050 0 .
-
Subtotal 14,102,034 13,979,363 (122
671)
,
Suntrust-Pension-Police 4,153,131 4,230,747 77,616 6.10 (1)
. Merrill Lynch-Pension-Police 480,100 496,498 16,398 14.50 (1)
Suntrust-Pension-General 5,736,826 5,707,343 (29,483) 6
10 (1)
Merrill Lynch-Pension-General 1,018,765 1,053,563 34,798 .
14.50 (1)
Subtotal 11,388,822 11,488,151 gg,329
Total $25,490,856 $25,467,514 ($23,342)
$4,807,170 $4,631,291 ($175,879)
30,978 30,978 0
. 138,053 146,400 8,347
335,634 335,237 (397)
1,047,461 951,689 (95,772)
34,220 35,333 1,113
(23,423) (33,077) (9,654)
63,640 69,856 6,216
4,189,379 4,215,708 26,329
635,686 582,952 (52,734)
2,823,164 2,974,881 151,717
20,366 22,346 1,980
(294) 15,769 16,063
$14,102,034 $13,979,363 ($122,671)
(1) FYTD rate of return through 06/30/05
City of Atlantic Beach
FINANCIAL REPORT
AUGUST 2005
AGENDA ITEM #=tA
SEPTEMBER 2G, ?005
Revenues
Annual YTD - 92% YTD Dollar Percent
Fund ! (Footnote) Estimate of Estimate Actual Variance Variance
General (1)
Tree Replacement $9,274,236 $8,504,474 $8,958,125 $453,651 5.33%
Convention Development Tax 13,778
177,000 12,634
162
309 13,778
178
343 1,144
1 9.05%
Local Option Gas Tax
519,800 ,
476,657 ,
500,557 6,034
23
900 g.gg%
5
01%
Better Jax 1/2 Ct Sales Tax (2)
Police Training, Forteit
etc 617,300
33
180 566,064 648,822 ,
82,758 .
14.62%
,
.
Grants ,
392,109 30,427
359,564 30,653
383,771 226
24
207 0.74%
6
73%
Debt Service
Capital Project 73,035 66,973 67,654 ,
681 .
1.02%
Public Utilities 0
6,627,412 0
6,077,337
6,071,962
(5
3~5
Ogo~a
_O
Sanitation
Storm Water 1,413,367 1,296,058 1,307,848 ,
11,790 .
0.91%
Pension -Police (3) 2,608,063
523
361 2,391,594
479
922 2,433,765
7 42,171 1.76%
Pension -General (3) ,
775,943 ,
711,540 14,289
1,084,161 234,367
372,621 48.83%
52
37%
Total $23,048,584 $21,135,553 $22,394,014 $1,258,461 .
Analysis of Major Variances
(1) The $641,176 positive variance in the General Fund resulted from the receipt of
revenues exceeding the budgeted amounts in first the first eleven months of fiscal
year 2005. Most of this variance consists of: $220,364 in property taxes, $136,047
in the One-half Cent Sales Tax and $62,038 in interest earnings.
(2) The $82,758 positive variance in the Better Jacksonville'/z Cent Sales Tax Fund
resulted from the receipts exceeding the budgeted amounts in the first eleven
months of fiscal year 2005.
(3) The $234,367 positive variance in the Police Employee Pension Fund and the
$372,621 positive variance in the General Employee Pension Fund resulted from
increases in the market values of the investments above estimates.
City of Atlantic Beach AGENDA ITEM #4A
FINANCIAL REPORT SEPTEMBER 26, zoos
AUGUST 2005
Expenses
Department !(Footnote) Annual
Estimate YTD - 92%
of Estim
t YTD Dollar Percent
a
e Actual Variance Variance
Governing Body
City Administration $47,607
2
037
979 $43,656
1
868
827 $41 251
1 $2,405 5.51
General Government (1) ,
,
4,102,314 ,
,
3,761,822 ,688,661
3,062,397 180,166
699
425 9.64%
18
59%
Planning and Building
Public Safety 774,953 710,632 585,662 ,
124,970 .
17.59%
Parks and Recreation 4,148,554
981
209 3,804,225
899
770 3,533,747 270,478 7.11%
Public Works (2) ,
5,944,450 ,
5,451,061 833,218
3,557,475 66,552
1
893
586 7.40%
34
74%
Public Utilities (2)
Pension -Police 7,669,539 7,032,963 6,294,918 ,
,
738,045 .
10.49%
Pension -General 337,266
382,231 309,273
350
506 301,169
341
459 8,104 2 62%
Total
$26,426,102 ,
$24,232,735 ,
$20,239,957 8,047
$3,992,778 2 58%
Resource Allocation Annual
Estimate YTD Estimate
of Estimate YTD
Act
l Dollar Percent
ua Variance Variance
Personal Services
Operating Expenses (3) $7,398,591
8
92 $6,784,507 $6,386,423 $398,084 5.87%
Capital Outlay (1) & (2) ,
0,187
5,317,652 8,179,812
4
876
287 7,021,924
2
292
652 1,157,888
2
58 14.16%
Debt Service
1,647,725 ,
,
1,510,964 ,
,
1,647,711 ,
3,635
{136
747) 52.98%
-9
05%
Transfers 3,141,947 2,881,165 2,891,247 ,
10,082 .
-0.35%
Total $26,426,102 $24,232,735 $20,239,957 $3,992,778
Analysis of Major Variances
(1) The positive variance in the General Government departments resulted from a less
than 92% completion status of some of these projects funded from this source -see the
Project Activity Schedule. The variance includes: the Mayport Road Medians, the Plaza
Road Entrance for the Post Office and the Five Points Intersection Improvements.
(2) The positive variance in the Public Works & Public Utilities departments resulted from
not having begun or a less than 92% completion status of some of the various projects
funded from this source -see the Project Activity Schedule. The largest of these
projects is the Hopkins Creek Drainage project that has not begun due to issues
surrounding the land acquisition.
(3)The positive variance in the Operating Expenses resulted from the following expenses
being less than the budgeted amounts: $426,384 in the Public Utility Funds, $170,044 in
the Public Safety and $238,894 in the Public Works divisions of the General Fund.
City of Atlantic Beach
FINANCIAL REPORT
AUGUST 2005
AGENDA ITIrM #-tA
SIrPTIJMBER 2G, 20U5
Project Activity -Current Year Activity Only
Project YTD YTD YTD
Project Name Number Budget Actual Balance Status
General Government:
City Hall Expansion GG0402 $463,005 $450,612 12
393 I
Subtotal
Parks and Recreation: 463,005 450,612 ,
12,393
• Skateboard Park
• Veteran's Memorial Park PR0303 195,927 195,780 147 C
PR0501 22,963 22,963 0 C
Subtotal 218 890 218,743 147
Public Safety
Police Building Design ~ PS0504 30,000 275 29,725 A
Subtotal 30,000 275 29,725
Public Works:
• Plaza Entrance/Post Office
Hopkins Creek Basin Po
d PW0305 100,000 3,002 96,998 E
n
• Mayport Road Medians PW0309
PW0401 1,423,149
301
942 21,405 1,401,744 E
Drainage-George & Dudley Streets
PW0402 ,
97
930 11,648
97
930 290,294 E
Bike Paths on Seminole and Plaza
PW0404 ,
230,291 ,
171
689 0
58
602 C
I
Welcome Sign and Landscaping PW0405 37,600 ,
1
927 ,
35
673 E
Ocean/13th -Coast Drive/12th
. Shed -Equipment Stora
e PW0409
P 137,000 ,
19,300 ,
117,700 E
g
Five Points Intersection Improvement W0501
PW0502 15,000
313
974 12,637
34
371 2,363
2
Sidewalks -New
PW0503 ,
60,100 ,
9,616 79,603
50
484 B
Pedestrian Path -Plaza Road PW0504 76,400 2,150 ,
74
250 E
Sidewalks -Replacements PW0505 50,000 16,629 ,
33
371 I
19th Street Ditch Bulkhead PW0506 12,000 0 ,
12
000
Seminole Ditch Headwall PW0507 35,000 1,439 ,
33,561 E
Subtotal
Public Utilities: 2,890,386 403,743 2,486,643
Telemetry for Water System PU0211 6,043 6,043 0 C
• Replace Well 2 at WWTP1 PU0304 6,389 6
389 0 C
Security Upgrade/Water Plants PU0305 14,864 ,
14
864 0 C
Telemetry at Lift Stations PU0307 90,811 ,
90
811 0 C
• Headwork Improvements at WWTP2 PU0310 368,441 ,
193,375 175
066
Relocate Elevated Storage Tank at WP2 PU0314 89,108 82
913 ,
6
195 C
Kesner Road Waterline Replacement PU0501 56,123 ,
29,537 ,
26
586
Fence at Water Plants 1, 2 & 3 PU0502 24,500 20,000 ,
4
500 I
Water Line at 10th Street & Beach Avenue PU0503 287,292 129,844 ,
157
448 I
Mayport Road Sewer Crossing PU0504 58,604 6,656 ,
51
948 E
Lift Station Scada
• Pond Liner Replacement PU0505 105,550 97,290 ,
8,260 I
Digester Blowers at WWTP 2 PU0506
PU0507 45,000
60
000 44,212
5 788 C
Utility Relocation - Wonderwood Connector
PW0001 ,
122
386 1,417
122
386 8,583 I
Subtotal ,
1,335,111 ,
895 737 0
439 374 C
Total $4,937,392 $1,969,110 $2,968,282
Status Key
A -Bid Advertised D -Design Completed
B -Bid Awarded E -Design Phase
C -Project Completed I -Project In-progress
AGIJNDA ITIJIYI #4A
SEPTEMBER 2C, 2005
City of Atlantic Beach, FI.
Utility Sales Report
-
aL
'a
i~ . rn.a5'~i.'Yu ^
4'q - ti - W LL
.
i ~".~ w
w
. ~
~
L
f
..._
~
r
n. .
~
August 2005 . .
r
wr
r
...
August 2004 ~~~
.~~.
.
U
..W
,. '~ ..
~
~ €
~ r
Gallons Actual Revenue Gal{ons Actual Revenue
Water Sales
- Accounts (000)
.
.
..
.
-
- Revenue
.
. Per 1,000 gi
.
.
,
- Accounts (000)
- Revenue Per 1,000 gt
....
~.---~,- _-,- ~
,
.
..,--.
..~,
~ m.~
.
r~--- -r.
...
...
. ~,~ .,.
Atlantic Beach 5,620 48,907 $112,971 $2.31 5,505 50,561 $108,861 $2.15
Buccaneer 2,975 27,420 $68,706 $2.51 2,747 29,296 $66,278 $2.26
Total Water Sales 8,595 76,327 $181,677 $2.38 8,252 79,857 $175,139 $2.19
.... r y
,'
~
Water Plant Produc tion
~T~.~ ,
Gallons Gallons
(ooo) (oao)
Atlantic Beach 65,626 64,667
Buccaneer 25,933 25,066
Total Production 91,559 89,733
Total Water Billed 76,327 79,857
Water Loss for month: 15,232 9,876
Percentage Loss 16.64°/° 11.01%
Total 12 mo. Avg. Loss 11.24% 13.75%
Gallons Actual Revenue Gallons Actual Revenue
Sewer Sales Accounts (000) Revenue Per 1,000 gt Accounts (000) Revenue Per 1,000 gt
Atlantic Beach 5,068 37,624 $162,991 4.33 4,950 36,762 $154,063 4.19
Buccaneer 2,590 26,165 $135,684 5.19 2,621 27,150 $136,032 5.01
Total Sewer Sales 7,658 63,789 5298,fi75 $4.68 7,571 63,912 $290,095 $4.54
Sewer Treatment
Millions of Gallons 89.08 71.89
Rev, er 1,000 Gallons 53.35 $4.04
v ~ v cn -I Cn ~ -o 3 v m
' v, ~ O cn ~ c ~n v n D V Cn O n g
m - ~ ~ ~ p ~ O m r r ~ m D 2 0 =+ m m O O C Z -i O m
3 z
v -
m
3 m
m _
z -
O
~1
V
n
2 c
3 m
v
~
r
r'
~ m
v
O
-n
r z
n n
T.
3 v
_ 'o
r
G1 =
m
3 3
o
r
G1
7~3
~
3
O
~
~
~
~
O
~
S
D
°
~
~
O
N
Z .i
-<
m
cn 3
m -e
O
m r
m
N 3
m
v
X r
m
~
=
O
N y
~ z
0 m
3 v
~ z
~ z
O _
~ m O ~
v ~
° z
~ ~ -n
b ~
~ m
C m
n i
z O V 'o ~ ~ D ~ i ~ m o 3 D o 3
,-~ r
- r
-
~ ~ r X ~ n ~ m
D, ~ ~ O v
m m
~ b
r- r' z
- - -
~ z
°
z j
t+. ~
N
w
o
s
N
v
3
.9 ~ ~
O
10 O ~I O i~ W O -~ ~ ~ ~ W A O N ~ O ~I O O W A N ~ ~
~
to °1 l
;' w °~ O W °
.
i -
+ Jf
f
V t
O
N Z1
N -~
O 3
to -1
~ ~ ~, ~ ~ ~ ~ ~ ~ ~ ~ ~ .~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ rn
~ ~
~ ~
3 ,_,~
~ N ~„~ ~- .i t0 N W (7 ~ EA to d! V- 4A EH
W
0o- N
-+ N
co --
.a 01
rn tp
W Q1
w -+
w -+
.A. --
tD A
-f N
.A, O
.~ A
<ff 00
v O
fT
O
tlt
~
C11
N
01
t0
U1
O
O
~P
N
~
W
A
V
~ ~
O
O ~ ~ O
O ~ ~ O
O O
0 O
0 C
0 O
0 C
0 O
0 ~ 0
O 0
O ~ O
O 1 0
O 0
O 0
O C
m ~
v
00
N
A
A
-+
Ct~
W
N
N
cp
O
A
N
W
'J
OD
tO
N N
O
O
n
o cn m y to w ,p, O
0 ~ 00 N O j1 O Z
Z w ~ o ~ w cn N
-i o o c o o o ;q
= o 0 0 0 0 o C
to cs v- ~n ~r- t» to ~ to ~ d+ ~n en fn ~ tt- ~n tw ~w ~+ to <n v- efl (~ to tt- to En v- w -O1
~ Z
C r
~
C ~ D
N v o
'~ N 2
N
-~
N
QNf
W
N
07
N ~
-' O
_
O
..-
V
W
~
QO
V
o
~ L71
~ w 01 A rO
i r-1 rc
p ~
- t
7~ ~ W N A A N
~„)
~p fJ1
O V
O ~1
O tT
00 00
'V 00
W N
O O
O N
Qt O
OD <D
O Q1
d1 ~1
A 00
V
Q~ O O O N fJt -+ 00 O C11 N O fD 01 00
p ~ ~ r ~ ~ O ~ O ~ ~ ~ ~ ~ X 0 0 ~ O ~ X 0 0 0 p p 0 0 0 0
p ~ -I 3 ~o c~ l~ ao 3 --1 3 v m c~ v~ -
'v
z m
O o
b ~ ~ p
° O C N
cz ~ m r r O c ~ -C
n ~
c m Z p m
N = 3 n n o
-- m N p 0
m
~
z
0
~
~
~ D
z ~
z
n ~
~
~
~
V
o -i
A
m
O r
-
° 3
' y n D
r m z ,A, a
° r r ~ ~
'~
rn ~°
m
N O N O O OD O A ~ I'p' w f~Jt O N o COl~
3 V
C N
m N
0
v ~ 'O AGI/NDA ITIrM #dA
cv Z m SEPTI;hIBCR 2G, 200
7
JZ
1
T]
D
0
D
In
C
N
O
.p. i
N
D
0
i
D
~"!
rn
D
C
C
rA
N
O
0
vt
N
"~
Z
^'~
Z ~,
0
C
C
N
N
O
O
cn
~ ~ D
~
w 3
~ =
~
o w
3
(~ ~t7 fD
- o w
~ ~
T C
t~D
o~
O.
A
w
n
C
~D
N
O
O
N
D
V C
"(
v
i
J
n
N
O
O
W
D
,c
,v
N
O
O
A
D
c
1
b
N
Q
O
w
C
-c
v
° m
i m a
?~ c°n
~ ~' _
' ~ ~
w+ 2
r
D
m
r
-~
Z
m
n
O
z
m
m
m
Z
n
N m
O
O
N
D
C
!Q
_Z
~'
N
4
O
W
D
~_
.b
N
O
O
~P
D
c
-C
b
N
O
O
w
b
AGENDA ITRM #4A
SEPTEMBIJR 2G, 2005
~ v
a °
O
.~ n
~
~
°' m
3
n
~. °
'~
(G
W n
'~C
cp
w
-1
1 ~ ~' N
~ ~ °o
Q ~
m o
~
m °1
~ c
...
~ N ~N
N
O
O
N
b'
C
1
v
N
O
O
w
a
b
N
O
O
.r+
D
c
-~
b
N
O
d
N
a
v
v
co
v
m
3~
N ~ ~
0
~' `t -~+~
~ ~ C
~ '~ o'
.~- ~ n
N
cD
AGENDA ITEM #~A
SEPTEMBER 26, 2005
0
d
9
a
so
0
G
Zl
e~
M
a
D
m
..
w
u
3
C
N
O
O
A
N
Qf
V
c
a
v
w
H
O
w
y
.+
n
N
O
O
N
a
0
1
7
oma orna omn oma om
~-F
~~~~
1-
~~~
~~~
y-
~~~ a
~~~ orna
~~~ oma
~~~ ornn
~-~ oma AGRNDAIT~M#4A
~~
F
S~PT~MBPR2G
2005
~ c c m Z
Z
y ,
o a
- o ~ p I O
b
l b m b m
~ m r -`
'
I d
c 3
p
i a O p b
p b m
l „~ ~
Vt p a O a
D N rn N O N ~ O r A O A
N N W V Q~d
N O N
r O ...
r 0 ~. }
g
N O N S`\~
• ~ U
J pl N
N O N
A W W
N r
W
f
,
n
~~3
p
N V tp O)
W O) U
A
1Ld
N N W O W W O O) N0
'fOU o00
-'0-•
A W..
A W E 1
N371
W W o 000 moo.. -~o~ c,N1S
i N ~ cn N W ~ O
~ O -•
O O O
f7~ W N
~ ~~
N N r p ... N O N A N N ~N`
O W V OWi r N N
01 U ... OJ O)
V V O NN,p N
00 W ~` r
5
O (T U O O ~p ~. N N D7 D) ~~1
S
O p) W O
N N
O N [n p~ U W
O A QI
N W N ~y
9n0
V A W N r A V A W N Ol Of ~S,9
W r
~p tp
W V r
N
~~~
tp W W O W tp W T A ~ad d
N N N N O V A W W N ... ~JN,
~ ~
O
(,~
O ~ ~,~
O W W N O N
•Ql N A
fl1 N W
V A W µ
a~L mm
m
Of N A O pl A W r N I•'~M
Z
CnN WAN VOV yNW yrA N SS~~N~N~
NO WrN tpAU W+N S~~ i
Z
r A ~ 00d
y
A N 1p W W N
~ W m W
N O W N N O N 1~`~3n
t
p W A ~ornw nom S3 y
~1
o ~ NS
~
000 000 ~
A W+ NON 1d3,~
A W.+ W pf N W Alp 1d~1 z
ANN .Z7
a
ON
10 AAO W W O UfJ~O NNO 9w~NaSn y
000 r0 000 ...0 S~3
.Z!
~yL4
p' 00o AoA o00
000 ~dN
`d k` c
000 O ~ 0 00 000 ~~1 i
N
W
dw`N,~ 0
0
w,
rn o m ~ 0 ~ o 0 0
mom
o0o
n
i o,La~,~
c
o
n
-•0~
00o SN
A y
A N A may,
N
V A O
U
A N Oµ~~
W O
D
il
f f
.l W O pp~~
.p N (y
W tp A A N N
W OL
N
'
'/J L
pl Ip V (
ig O N tp W S
`
W W W
tp
pWi N
O N
~
~
N
W
(N.1
W
~'
A
N
V
W V N ~ V ~
mC1zD-rvgOC)
rn c~z-czmv
Liz-rAmy~y