Exh 4AAGENDA ITEM #4A
APRIL 25, 2005
-~
5'
m
-INS fnn--I~l'OC~--I-Z~
m O ~ -p ~ m ~ ~ '~~ m 'a ~ N
Cn N rp ~ C7 n ~ ~ n
m ~a-~Dmm~ o
c~'n x ~ ~ <' ~ No m ~ ~ ~D vAi ~
~ O -rim °~ Oamv ~ N
~ ~
v~zrn~~ w~~co~~
m N Ul ~ ~ ~_ ~ ~_ a.
_ m N N~ rt _. m~ m Q~ c'U
-~o ~ m ~D~...-,
3 ~ ~ ~ ~ ~ ~ N N ~ ~ (L]
N d. ~. ~ N~ ~' N N N
m O O n v ~O <~
,~-.,
rn cn' ~ m co D ~ N N
-~ ~ .~ (~
n ~ G ~ n x
rmp ~ d
Slr ~ m ~ n O
~ ? ~
m
aN '"' ~ >
vi cn
~ m m
m ~
r m
~ rn
N
O
O
W
D
rt
~D
N
"~
v
N
O
O
N
v
N
O
O
W
-i
r
v
N
O
O
-0.
v
N
O
O
CJfI
D r' a~ Cn D ~ -n ~
O ~ O o
~ ( ~
C7 (~_ 1 ) Q~
~ ~ 11J rp ~ rp ~" m
~ m
m D ~
~ ~ a m °1
_ N m N
_ N ~
C
~ C ~
~ ^' m
N -,
N
I
OD W .L1
-~ W (O .A. V 0 ~ O
-+ (O N W -L
V O V N W Cn N O
~ OD W .A -~
-- A W .A V 0 0 0
CJr --~ W
(O ~ 0 N V 00 .A O
c
.a
Oc
Q
V
t\:
~'
o ~ v
~ D ~
~ C
m ~
a ~ ~
n ~ "~
~ ~
~ N
p
N h ~ e~1~
''G
O
~ "h
N '~
~ ~
fD
•
~
N
~
~
O (p
o ,
~
A
0
'~ N
'i N
D 3
d
C1
S
~ O
-I o
j W
3
C>
S
'~ N
-I °o
3
d
C9
S
{ N
I ~°or
~3
A~
n
AGENDA ITEM #WA
APRIL 25, 2005
C1
0
a
co
m
0
3
m
cn --
~ c
m
D ~
~_
~ ~
m ~
m
Z
0
O
C
v
cu
A
as
n
0
0
C) D D D D v
_. > > ~ ~ ~-
v m w m m
N ~ ~ C7 ~ v
m o n~ N U,
m °- m ~D
a a o
o ~
Q
cn
C
w
~7
fll
a'
(D
W
CJ1 ~ .p W
.A O N .A .A. O
~ ~
0o N -~ O .A
O .A -~ ~ CJ1 W
.A
W N ~1 OD
O O CD O a) ~I
N
0
0
N
L
"+
N
D
D
V
P
7
V
7
h
n
c~
-o
0
co
..;
0
D
r:
co
N
n ~ ~ ~ ~
~' m ~ ~, -'
o ~-
O~~o'~ ~ v
m ~ ~ m
< ~ N n
~~;aim~
cn `~ o
~vDcna,
~ (D ~ ~ N
~ N ~ N~ N
n.
~~c=ucn o
N ~ Z N
N N. ("~ (D N
. ~
~ (~ ~ a' a ,
NO n N O ~.
. (D
Q'~ p(Q
°'o'afl-o
~m~~m
co < ~ p~
Cn~Q,~~
m ~~ ~
o
n to N cn
~ ~I O
m v, v ~
~ O N
~ N ~,
l~D O U)~
.+
O~
7
n
fD
-_h
n
N
O
7
cn-I(~oD-IDD?t~
cn w
rnom~.~oo tu-~
cn cn N ~ ~ ~" ~ ~ Q. ~
< ~ ~ ~ ~ ~ ~ ~ ~ co
N 2 -i n C7 ~ ~ n
ca ~ n = N n
~ ~ n ~ ~ ~ ~ N ~' ~
•~ ~ ~'~
~ ~~j, ~ O 7 ~ n =0 ~
cn ~- N a ~ N ~, p o
c m ^: n ~' Z
~ ~ v fl: o
O .~.: (p ~
~ ~ ~ 'i~
~ N ~
~• n
~' ~•
ca
-v
m
0
-a
m
-~ ~ ~ -+ o ~ -+ ~ ~ -~ ~ ~ AGENDA ITEM #4A
oma
-~-r om~
-i- oma
-i-r oma
-i-r APRIL 252005
D v r_
N a v r_
~ N2z a v r
~
2 a v r_
frAZz
zz
_IN N ~N z
3 ~N 'tl _IN C.
T -I T
I ~ T Q 'fl ~
v ~' o ~ c w c w
y. 0 A + O + + O+ N O N
n
~~
O,,d ~
N
W N W A N N W O W Q1 O Q~
N O N 0 0 0 + O+ + O+
~N~~
~N`
V N (]I + O + N O N A N N
tWD ~
O fa + N r
O t0 ~• O O
N N O O Q1
OD OD O fj~~`C9
~9pi1
+ NS,
+ W
A - V1 + A V .ta W N O O
~~»
~da
_ ~N~~
N O~ .D. N N O ~1 A W W N+ C~
N~~~ m
~~ 1
m
+ ~
Z
dN`
_ _
<O cD O O N A O Q~ A W+ N Q
,~OZ
S`~N
3
~S
fT Of ~O W + N ~D A f7f W + N
S~
3nOSd
r r ONi + +
tND Cn A _ _
tD m W _ _
tD O (D 5~~~1N
G1
N5~
~~~~ z
\La
_
(WT N W W O1 N W A tO J- N N d~
1 •~
m
v
oN
wnN~S~
Sb'~9
o
N N O ++ O O O O + O ~
`~~ YS
N
1~
3ydM
+O+ +o+ o0 0 0O o ~
O
N
w~Nd
~ 1d
p~1~ v
+ + _ _ N
S
O O QI V1 O CT + O + 0 0 0
M_a`
-~
Y
~°N
; ~ ~ ~ ° o
W `D
w
a s1dL°
c , c
i c
a
~
~ A y ~ moza-r~o3oc~
rn ~
~^ c>z-ozm~v
rn
G)z-ramvva
N O C~ ~ v Y
v
~ v t o -I
~ cn
~ ~ ~ - o m c n ~ G~ c
D n ~
O c
~ m m O O C _
z -l
= om
" Z
c-
~ m
G~
m
~ Z ~
~ ~ m o O
~ m
(7 C m
O O
Z m
r ~ m O _
r zC
C7 7 )
C ~
~ v
~ i
r 0 m ~~
~O O
rr ~
3 Y
-.%~i
~ v0 m ~ ~ ~ ~ = D W -
i ~ ~ ~ cn Z ~ m ~
~ m m ~
~ mv Xm
~ ~d
"
~
O ~
~ ~
D Z
0 m v
~ z z
O ~ m G)
D ? ~ D
~ nC D
~
~ t
Y
N
3
O Z ,
v C
v 'D 0
< r D
r ~ r m
~ o
C r -I ~ p
v - G C
~ u
,
n~ ~
O O
~ D
~ O
o D
r O cn ~ O - =i fl1 ° -~-~
°
r ~ m ~ r Z Y
I (~
z A .~
I j „ , s o ~ ~
O ~ W A t 0 O N N W D
'fl A ~
~ ~
N
(
J
I~
N
W
A
~
N
'
A
Vt
.P
N
V
j
~
W
(N71
•a
W
~
fD
~
A
G1
~
'~
O
V)
~U TT
W
,
N ~ -+ ~ O O C
_
~ V ~p
I ~
A .p
-i .s
0 .a
0 v
N ~ Z /'~ ,..~
~
Z C7
m ~ ~ rn
c~ w+ ~- H- ~, ~ ~„ ~ ~„ ~, ~, ~- a - d- ~- ~- ~, a, ~ m ~ ~ ~
' ~ ~
O
~ u o ~ v
W
~ N ~, ~, ~ ~, ~ ~ v ~ rn
~ N A W W W O N V C) N ~ O T
V
~
~ ~
O fD
T ~
O OD
V W
W W
cD OD
tp V
•~
W ~
~. f0
V
W N O
W ~ ~
O OOO
O W W ~ O
~ C ~
rn Z
~
O
0
V
0
CJI
0
O
0
V
O
V
C
V
p
W
0
t0
0
O
0
(n
0
N
CI O
O N O
0 A
0 rn
0 "~
~
~ ~
T
2
~~
O O O O O 0 0 0 0 0 0 O O O 0 0
lfl
y
to
o
a N N
~ W O
~ o 0
. i I' I I I i' I' I~ I~ I
V
O
0
0
~ m 0 3~ O O c
mcn-I "'~vzl=
z o ln., n ~ m Z v
oz ~oczi
OI~I-+I IIOIOIOIOI-~
~ V tD V tT O N O ~] O
O
Z N
V tD
W A
-+~ O
Qf tD
fD OO
_C)
O
Z ^
l
. Q.
N t0
O f0
00 ~
~1 Q~
O V
V
~
N
D
G C O O O C C Q ~]
O 0 0 0 0 0 0
n ~
fiR t!f ~ fA EA d9 Efl O ~ EA M b°1 EA !fl ffl O /
Z N
~ n D -< ~ ~
~ 2 ~ ~ y C
~ ~ ~
c ~ ~
_
j0
Z •..
V ~ ~ ~
is
as ~
i~, ~
:~ ~'
o o
ct+ Z 0
~ v+
W ~+ rn
~ iv
~ < m
<W7f
A
fWD
A
CNl
l ~ ~
v
m
~
co m t
0
o ~
m
O rn
V rn ~
V r ~
O m
Of a
O o
t0 r
oo
Q w
1 t[7 y ..O
O
~p W
N O
O
l0
N
O C' ~p
° O
o O
° W C I O
°
rn
O
o
O io
O 0
O 0
O 0
O o m
O o o 0 0 o ~
~ ~
n
2
3
~ ~ m rm-
c rm-
m np c ..(
-1 -{
0 N
v m
m n
=
g
~ z
v ~
v
N
p
-I 0
o
N Z Z ~ m z Z ao N ~ Cn
~ v o
n D o m m ,A z
c
r r' n
n
-t -< m
O
-+
n
W
W V
IO N
A -~
f0 O
A A
W ~.
A OO
t0 Z
V) V
O D T
~ ~
AGENDA ITEM #-IA
APRIL 25, 2005
City of Atlantic Beach, FI.
Utility Sates Report
,. .:.
March 2005 March 2004
F ,.,
_
~`
_
Gallons Actual Revenue Gallons Actual Revenue
Water Sales Accounts (000) Revenue Per 1,000 gl Accounts (000) Revenue Per 1,000 gt
~
Beach
Atlantic 5,503 41,943 $99,256 $2.37 5,509 41,000 $86,176 $2.10
Buccaneer 2,708 26,516 $69,222 $2.61 2,566 25,501 $56,474 $2.21
Total Water Sales
.a . .: 8,211
„.,... 68,459
, . 5168,478
-; , 52.46
. ~ .: 8,075
.. ;, 66,501 $142,650
.
ii $2.15,
.
A '.Y~
Water Plant Produc tion
-,r, - _ . _ - .~.
Gallons Gallons
(aoo) (ooo)
Atlantic Beach 56,818 53,082
Buccaneer 22,310 37,290
Total Production 79,128 90,372
Total Water Billed
Water Loss for month:
Percentage Loss
Total 12 mo. Avg. Loss
I Sewer Sales
Atlantic Beach
Buccaneer
Total Sewer Sales
I Sewer Treatment
Millions of Gallons
Rev. per 1,000 Gallons
68,459 66,501
10,669 23,871
13.48% 26.41
10.77% 15.15%
Gallons Actual Revenue Gallons Actual Revenue
Accounts (000) Revenue Per 1,000 gt Accounts (000) Revenue Per 1,000 gt
4,945 33,622 $144,997 4.31 4,944 32,839 $132,988 4.05
2,594 24,925 $131,375 5.27 2,465 24,531 $116,433 4.75
7,539 58,547 5276,372 54.72 7,409 57,370 $249,421 54.35
68.13
80.07
53.12
AGENDA ITEM #4A
APRIL 2s, 200s
City of Atlantic Beach
' FINANCIAL REPORT
MARCH 2005
' ~ Cash Balances
Prior Current Dollar
• ~ Fund(s) 02/28/05 03131/05 Change
General 56,519,169 $6,144,610 ($374,559)
Tree Replacement 17,201 30,978 13,777
Convention Development Tax 205,765 138,101 (67,664)
' Local Option Gas Tax 311,117 271,497 (39,620)
Better Jax 1/2 Cent Sales Tax 1,000,225 992,506 (7,719)
Police Training, Forfeit, etc. 33,701 33,383 (318)
Grants 69,092 (132,663) (201,755)
Debt Service 44,031 50,164 6,133
' Capital Project 27,879 27,936 57
Utility 3,991,554 4,288,612 297;058
Sanitation 605,390 586,811 (18,579)
Storm Water 1,969,996 2,181,879 211,883
Pension -Police (8,778) (13,717) (4,939)
' ~ Pension -General 27,184 43,927 16,743
• ~ Total $14,813,526 $14,644,024 ($169,502)
Total Restricted Cash $6,318,361
' Total Unrestricted Cash $8,325,663
Cash and Investments
Prior Current Dollar Rate of
Account 02/28105 03/31/05 Change Return
Bank of America -Depository $875,687 $499,509 ($376,178) 1.38
SBA $13,935,789 $14,142,465 206,676 2.54
Cash on Hand $2,050 $2,050 0 -
Subtotal 14,813,526 14,644,024 (169,502)
Suntrust-Pension-Police 4,188,968 4,066,229 (122,739) 5.40 (1)
Merrill Lynch-Pension-Police 391,208 456,462 65,254 13.60 (1)
Suntrust-Pension-General 5,672,528 5,425,938 (246,590) 5.30 (1)
Merrill Lynch-Pension-General 806,551 968,679 162,128 13.60 (1)
Subtotal 11,059,255 10,917,308 (141,947)
Total $25,872,781 $25,561,332 ($311,449)
(1) FYTD rate of return through 12/31/04
City of Atlantic Beach
FINANCIAL REPORT
MARCH 2005
Revenues
AGENDA ITEM #4A
APRIL 25, 2005
Annual YTD - 50% YTD Dollar Percent
Fund !(Footnote) Estimate of Estimate Actual Variance Variance
• General (1)
Tree Replacement
Convention Development Tax
Local Option Gas Tax
Better Jax 1/2 Ct Sales Tax (2)
Police Training, Forfeit, etc.
.. Grants (3)
Debt Service
' Capital Project
. Public Utilities
Sanitation
' Storm Water
. Pension -Police (4)
Pension -General (4)
' ' Total
29.13%
0.00%
13.04%
-11.80%
14.79%
-28.03%
31.02°/p
0.65%
100.00%
-0.47%
5.20%
1.91
25.22%
48.66%
Analysis of Major Variances
(1) The $1,339,770 positive variance in the General Fund resulted primarily from the receipt
of 91 % of the property taxes from the City of Jacksonville having been received in the
first half of fiscal year 2005.
(2) The $45,636 positive variance in the Better Jacksonville '/Z Cent Sales Tax Fund
resulted from 58% of the revenues from the State of Florida having been received in the
first half of fiscal year 2005.
(3) The $41,985 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 ($8,049
in the Local Law Enforcement Block Grant & $57,465 in the FDOT -DUI Enforcement
Grant)
$9,197,252 $4,598,626 $5,938,396 $1,339,770
0 0 13,778 13,778
177,000 88,500 100,044 11,544
519,800 259,900 229,242 (30,658)
617,300 308,650 354,286 45,636
33,180 16,590 11,939 (4,651)
270,707 135,355 177,340 41,985
73,035 36,518 36,754 236
0 0 286 286
6,593,352 3,296,677 3,281,266 (15,411)
1,319,500 659,750 694,070 34,320
2,607,493 1,303,747 1,328,595 24,848
523,361 261,681 327,684 66,003
775,943 387,972 576,747 188,775
$22,707,923 $11,353,966 $13,070,427 $1,716,461
(4) The $66,003 positive variance in the Police Employee Pension Fund & the $188,775
positive variance in the General Employee Pension Fund resulted from increases in
the market values of the investments above estimates.
AGENDA ITEM #i-tA
APRIL 25, 2005
City of Atlantic Beach
' FINANCIAL REPORT
MARCH 2005
Expenses
- Annual YTD Estimate YTD Dollar Percent
Department! (Footnote) Estimate 50% Actual Variance Variance
Governing Body
City Administration
General Government (1)
Planning and Building
Public Safety (2)
Parks and Recreation
Public Works (3)
Public Utilities (3)
Pension -Police
Pension -General
$43,807 $21,904 $22,351 ($447) -2.04%
2,005,228 1,002,616 968,384 34,232 3.41
4,076,583 2,038,293 1;856,873 181,420 8.90%
697,108 348,556 337,333 11,223 3.22%
4,137,749 2,068,879 1,643,544 425,335 20.56%
981,301 490,652 456,743 33,909 6.91
6,051,878 3,025,942 1,846,671 1,179,271 38.97%
7,653,105 3,826,553 3,481,935 344,618 9.01%
337,266 168,633 154,442 14,191 8.42%
382,231 191,116 171,146 19,970 10.45%
Total $26,366,256 $13,183,144 $10,939,422 $2,243,722
Resource Allocation
Personal Services (4)
Operating Expenses (2)
Capital Outlay (1) & (3)
Debt Service (5)
Transfers
YTD Estimate YTD Dollar Percent
50% Actual Variance Variance
$3,708,369 $3,204,025
4,438,427 3,485,896
2,603,685 1,286,956
878,202 1,357,807
1,554,461 1,604,738
$13,183,144 $10,939,422
$504,344 13.60%
952,531 21.46% -
1,316,729 50.57%
(479,605) -54.61
(50,277) -3.23%
$2,243,722
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 until January, 2005- see
Project Activity Schedule. The variance includes: City Hall Expansion, City Hall Lobby
Remodel & Skateboard Park projects.
(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 City
received the request for payment from the City of Jacksonville for the period of October
through December 2004 in February, 2005 and Lifeguard services being seasonal
(typically being expended June -August) has not begun.
(3) The positive variance in the Public Works & Public Utilities departments resulted from
not having begun or a less than 50% completion status of some of the various projects
funded from this source -see Project Activity Schedule.
(4) The positive variance in the Personal Services is primarily related to three things. The
first is vacant positions, the second is having recorded 100% of the first payroll and 36%
of the second payroll of October in the prior fiscal year and the third is turnover of higher
paid employees.
(5) The negative variance in the Debt Service accounts resulted from the semi-annual
payment of principal and interest on the 1996 Utility Revenue Bonds made in October.
Annual
Estimate
$7,416,737
8,876,825
5,207,369
1,756,403
Total $26
City of Atlantic Beach
FINANCIAL REPORT
MARCH 2005
AGENDA ITEM #4A
APRIL 25, 2005
Project Activity -Current Year Activity Only
YTD YTD YTD
• Project Name Budget Actual Balance Status
General Government:
_
City Hall Expansion $409,264 $222,764 $186,500 I
City Hall Lobby Remodel 35,000 0 35,000 D
Subtotal 444,264 222,764 221,500
Parks and Recreation:
Skateboard Park 184,827 148,159 36,668 I
Veteran's Memorial Park 34,000 22,963 11,037
Subtotal 218,827 171,122 47,705
' Public Safety
Police Building Design 30,000 275 29,725 A
Subtotal 30,000 275 29,725
Public Works:
Plaza Entrance/Post Office 100,000 1,750 98,250 E
.. Hopkins Creek Basin Pond 1,468,149 15,489 1,452,660 E
Mayport Road Medians 301,942 11,648 290,294 E
' Drainage-George & Dudley Streets 107,723 97,930 9,793
Bike Paths on Seminole and Plaza 232,272 164,710 67,562 I
Welcome Sign and Landscaping 37,600 0 37,600
• Ocean/13th -Coast Drive/12th 127,000 378 126,622 A
Shed -Equipment Storage 15,000 2,821 12,179 I
Five Points Intersection Improvement 315,000 10,559 304,441 E
. Sidewalks -New 61,500 0 61,500 I
Pedestrian Path -Plaza Road 75,000 2,150 72,850 E
Sidewalks -Replacements 50,000 258 49,742 I
19th Street Ditch Bulkhead 12,000 0 12,000
Subtotal 2,903,186 307,693 2,595,493
Public Utilities:
Replace Well 2 at WWTP1 6,389 6,389 0 C
' ~ Security Upgrade/V1later Plants 14,864 14,864 0 C
Telemetry at Lift Stations 90,811 90,811 0 C
Headwork Improvements at WWTP2 341,270 4,405 336,865 D
• ~ Relocate Elevated Storage Tank at WP2 87,908 71,993 15,915 I
Kesner Road Waterline Replacement 33,938 250 33,688 I
' Fence at Water Plants 1, 2 & 3 40,000 0 40,000
Water Line at 10th Street & Beach Avenue 200,000 5,000 195,000 E
Mayport Road Sewer Crossing 138,730 6,656 132,074 E
Lift Station Scada 50,000 22,740 27,260 I
Pond Liner Replacement 45,000 0 45,000
Digester Blowers at WWTP 2 60,000 0 60,000 I
. Utility Relocation - Wonderwood Connector 122,386 122,386 0 C
Subtotal 1,231,296 345,494 885,802
Total $4,827,573 $1,047,348 $3,780,225
Status Kev
' ' A -Bid Advertised D -Design Completed
B -Bid Awarded E -Design Phase
C -Project Completed I -Project In-prog ress