Item 4An n~.m n rra~ ~ u . .
AU GU ST 11 200 8A
O ~
N Q ,
O to
Z O N ~ W
~ N
N
~
~
~
CA
~
~
O ~"' r
F } O r
~ G
~
W W ` ~
a 0 O. J ~ O
? ~. ~ 2 IQ- w+ ~ ~ ~
Q o,s
N ~ W Q U Q
V ~ Z ~ ~ °o
~
~'
o
~
UU
E-
V
C
R
a
go _
I-- o ao ~ ~ 0° = ~ ~ o ° '~
N ,,,~ c
i
Z U ~ V W ~j ~ t/!
Z~ O J J W ~ y .~ M ~
O
m
c~
w
a
~
E-
~
T r
+
a o
a oo °O o o° °o °O °O o°° ° o °
ti
~
~
O
~ O
M ,
~ O
~ o
n o
N
~ a0
r i.
CV ~ M °
N ate ~ ~ ~ o
o
r ~
` ~ ti
p r N
N ~
'
F ~ 000
7 ,
~' N O M ~ ~ LNp
~
~ N O C 0 Z Q r r
` N = ~
= 0
} ~ U
~
~
O
Q
O N
~
N
C ~
N
~..~ W ~ ~ ~ ~ ~ O ors ~ ~ ~ r~ va
_ ~ Z
= O
O 0
0 0
0 0
0 0
0 0
0 0
0 ~
Z
' N O O K1 1f1 N N 0
Z 7 O
47 O
O N
O OO
t0 CA
M O
ttl
W
O O
v/ LL
O Z ~'1~
O 1~
OM 0
~ ~'
(~ d'
00 M
M CA
O
g
O
QM
r 0
N 00
CA r
r lf
Op cA
(n
. = N
~
a. Q
a- ~
z ~
a ~. N
~ O
~~, O
~ o
~ a
O O
o O
0 o
0 o
0 0
0 0
0 O
~ o
o 0
N 0
~ o
a
C
C ~N
O N ~
N ~
M o ~ 11~
M ~l
CA O
O r
~ OCI
1p N
N ~
~ o
M
Q O 5
G C
C Ef} fR EA fR ER fR ~
/
N V r ~ N t0 r M ~Cl ~ O
O
r r r 0
V r
~ o v a ~
Z ~ a
-
0 Z ~ ~ ~, ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~
J
_
~ ~ °° r I y
m a o °° ; o t
-
a ~. ~ ~
W ~ n. a N N N t0 ~ r M ~ N N d' M N
O
00 00 N N
I
rL x ~ O
O ~ Z
Z }-
J
a
.~
0
~ o
W ~,
o ~
~ o ~ z ~
H ~ Q a ~ O ~ a z J a w ~ a a ~ z
LL w ~ ~ = z o o ~ o W a ° o
~ J x
J r ~
W J O W ~ ~
LLf ~C W
9f A ~ Z
m Z
Q S ~ Z ~ O J
W C9 a O
~ L
~ = C70 J
. G ~C Y
> Z- ~ O W ~ J y
Z V ~ 2
V VC
' Q
~ O
Z W ~
~ ~ Q O
~ ? ~ W
' OF - ? ~ ~ O W WF - O 2 Q W C9 W
~ ~
J
W Q- -
~ -
~ W - - Z L
- fn OO V O fn O Q V D I L ~ G ' f n C 7 ~ ,
to ~ ,,
w a ~ a ~ N ~ ~ o ~ o
City of Atlantic Beach AAUGUST I1M#~gA
FINANCIAL REPORT
JUNE 2008
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
Building Code Enforcement
Storm Water
Pension -Police
Pension -General
Total
Total Restricted Cash
Total Unrestricted Cash
Prior Current
05/31/08 06/30/08
$6,765,317
28,901
228,217
388,768
1,105, 351
56, 866
(6,634)
54,102
221,494
3,580,975
452,809
100,949
2,558,883
12,564
91,161
$15,639,723
$6,587,403
28,901
231,696
391,284
1,066,135
61,573
(10,291)
59,891
249,307
3,760,256
566,026
114,455
2,534,435
19, 550
12,112
$15,672,733
$6,885,681
$8,787,052
Dollar
Change
($177,914)
0
3,479
2,516
(39,216)
4, 707
(3,657)
5,789
27,813
179,281
113,217
13, 506
(24,448)
6, 986
(79,049)
$33,010
Cash and Investments
Prior Current Dollar Rate of
Account 05/31/08 06/30/08 Change Return
Bank of America -Depository $2,997,047 $3,010,296 $13,249 1.91
SBA 1,340 1,340 0 2.43
Banc of America Securities LLC 12,638,786 12,658,547 19,761 1.87
Cash on Hand 2,550 2,550 0 -
Subtotal 15,639,723 15,672,733 33,010
Police Pension Investments 5,812,548 5,508,178 (304,370) (3.70) (1)
General Pension Investments 9,107,532 8,755,400 (352,132) (3.40) (1)
Subtotal 14,920,080 14,263,578 (656,502)
Total $30,559,803 $29,936,311 ($623,492)
(1) FYTD rate of return through 03/31/08
City of Atlantic Beach AGENDA ITEM # 4A
FINANCIAL REPORT AUGUST 11,2008
JUNE 2008
Revenues
Fund / (Footnote) Annual
Estimate YTD - 75%
of Estimate YTD
Actual Dollar
Variance Percent
Variance
General (1) $11,007,888 $8,255,916 $8,984,803 $728,887 8.83%
Tree Replacement 0 0 19,188 19,188 100.00%
Convention Development Tax 90,500 67,875 28,781 (39,094) -57.60%
Local Option Gas Tax 537,196 402,897 386,716 (16,181) -4.02%
Better Jax 1/2 Ct Sales Tax 831,885 623,914 544,725 (79,189) -12.69%
Police Training, Forfeit, etc. 47,530 35,649 31,267 (4,382) -12.29%
Grants 290,478 217,859 109,333 (108,526) -49.81%
Debt Service 70,966 53,225 52,314 (911) -1.71%
Capital Projects 330,000 247,500 249,307 1,807 0.73%
Utility (2) 9,585,150 7,188,863 4,978,299 (2,210,564) -30.75%
Sanitation 1,762,230 1,321,673 1,355,458 33,785 2.56%
Building Code Enforcement 513,329 384,997 294,240 (90,757) -23.57%
Storm Water (3) 3,162,675 2,372,006 1,861,975 (510,031) -21.50%
Pension -Police (4) 745,841 559,381 (74,746) (634,127) -113.36%
Pension -General (4) 1,244,005 933,004 40,954 892,050 -95.61
Total $30,219,673 $22,664,759 $18,862,614 ($3,802,145)
Analysis of Major Variances
(1) The $728,887 positive variance in the General Fund resulted from having received
100% of the budgeted property taxes. Typically the majority of these taxes are received
from the City of Jacksonville in December & January.
(2) The $2,210,564 negative variance in the Utility Funds resulted from not having received
$922,000 budgeted for the St. John's River Water Management District grant, $1,050,000
for bonds that were to be issued in fiscal year 2008 & a variance of $447,192 from
decreased sales.
(3) The $510,031 negative variance in the Storm Water Fund resulted from having received
$400,000 of the $1,200,000 budgeted for the Hopkins Creek Project
(4) The $634,127 negative variance in the Police Employee Pension Fund & the $892,050
negative variance in the General Employee Pension Fund resulted from changes in
market values of the investments.
City of Atlantic Beach
FINANCIAL REPORT
JUNE 2008
AGENDA ITEM # 4A
AUGUST 11, 2008
Expenses
Annual YTD - 75% 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)
Building Code Enforcement
Pension -Police
Pension -General
Total
$47,760 $35,820 $33,142 $2,678 7.48%
2,282,915 1,712,186 1,495,367 216,819 12.66%
1,220,481 915,362 867,735 47,627 5.20%
235,024 176,268 134,747 41,521 23.56%
5,561,417 4,171,063 3,251,134 919,929 22.06%
354,092 265,569 287,713 (22,144) -8.34%
9,372,299 7,029,225 5,727,006 1,302,219 18.53%
10,102,092 7,576,570 5,375,513 2,201,057 29.05%
268,281 201,211 180,259 20,952 10.41
437,323 327,992 320,224 7,768 2.37%
459,094 344,321 340,926 3,395 0.99%
$30,340,778 $22,755,587 $18,013,766 $4,741,821
Annual YTD - 75% YTD Dollar Percent
Resource Allocation Estimate of Estimate Actual Variance Variance
Personal Services (4) $8,525,966 $6,394,474 $5,878,808 $515,666 8.06%
Operating Expenses (1) & (2) 10,249,309 7,686,985 6,759,345 927,640 12.07%
Capital Outlay (1), (2) & (3) 7,397,785 5,548,339 1,830,039 3,718,300 67.02%
Debt Service (5) 1,683,825 1,262,869 1,682,655 (419,786) -33.24%
Transfers 2,483,893 1,862,920 1,862,919 1 0.00%
Total $30,340,778 $22,755,587 $18,013,766 $4,741,821
Analysis of Major Variances
(1) The positive variance in the Public Safety departments resulted from: only 2 of 4
quarterly payments being made on the City of Jacksonville fire services contract, no
expenditures in the related grant funds, 3 vacancies in the Patrol division, lifeguard
services being seasonal, not having completed union negotiations with the police officers
and not having begun various projects funded from this source -see the Project Activity
Schedule.
(2) The positive variance in the Public Works departments resulted from only 8 of 9 monthly
payments being made on the Waste Services of Florida, Inc. and First Vehicle contracts
and limited activity on various projects funded from this source -see the Project Activity
Schedule.
(3) The positive variance in the Public Utilities departments resulted from limited activity on
various projects funded from this source -see the Project Activity Schedule.
(4) The positive variance in the Personal Services Category resulted from not having
completed union negotiations until 05/05/08 for the blue & white collar bargaining unit
employees. The merit raises for the blue & white collar bargaining unit employees
retroactive to 10/01/07 were paid 06/20/08 & the COLA raises are still pending as of
06/30/08. The police officers bargaining unit has not completed their union negotiations.
(5) The negative variance in the Debt Service Category resulted from the October
payment of principal and interest on the Utility Revenue Bonds.
AGENDA ITEM # 4A
City of Atlantic Beach AUGUST Il,aooa
FINANCIAL REPORT
JUNE 2008
Project Activity -Current Year Activity Only
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:
Shelter at Donner Community Center
Lights at Veteran's Park
Public Art Turtle Statue
Jordan Park -Irrigation & Sod
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 27,733 27,733 0 C
357,733 27,733 330,000
PU0704 49,399 49,399 0 C
PU0706 510,000 105,338 404,662 E
PU0801 30,000 2,926 27,074 I
PU0802 829,000 0 829,000 I
PU0803 30,000 10,588 19,412 C
PU0804 22,593 22,593 0 C
PU0805 1,800,000 0 1,800,000 E
PU0806 1,595 0 1,595
3,272,587 190,844 3,081,743
PM0802 22,500 0 22,500 I
PM0803 13,000 5,302 7,698 I
PM0805 70,000 0 70,000 I
PM0807 12,000 11,282 718 I
PW0309 1,478,372 907,370 571,002 I
PW0401 400,000 5,007 394,993 I
PW0701 26,272 26,272 0 C
PW0705 2,819 2,819 0 C
PW0708 271,965 271,965 0 C
PW0801 20,000 0 20,000
PW0802 100,000 0 100,000
PW0803 30,000 0 30,000 E
PW0804 25,000 0 25,000 R
PW0805 26,978 0 26,978
PW0806 30,000 23,064 6,936 I
PW0807 75,000 0 75,000 R
PW0808 400,000 0 400,000
Subtotal 3,003,906 1,253,081 1,750,825
Total $6,634,226 $1,471,658 $5,162,568
Status Key
B -Bid Awarded E -Design Phase
C -Project Completed I -Project In-progress
D -Design Completed R - Re-budget Next Fiscal Year
AGENDA ITEM # 4A
AUGUST 11, 2008
City of Atlantic Beach, FI.
Utility Sales Report
June 2008
Water Sales
Atlantic Beach
Buccaneer
Total Water Sales
Gallons Actual Revenue
Accounts 0000 Revenue Per 1,000 9i
5,609 48,183 $135,455 $2.81
2,475 22,161 $71,181 $3.21
Water Plant Production
Atlantic Beach
Buccaneer
Total Production
Total Water Billed
Water Loss for month:
Percentage Loss
Total 12 mo. Avg. Loss
®Sewer Sales
Atlantic Beach
Buccaneer
Total Sewer Sales
~ Sewer Treatment
Atlantic Beach
Buccaneer
Total Sewer Treated
Gallons
0000
59,228
21, 063
80,291
70,344
9,947
12.39%
13.37%
June 2007
Gallons Actual Revenue
Accounts 0000 Revenue Per 1,000 gi
5,641 53,957 $137,844 $2.55
2,465 24,670 $71,025 $2.88
8,106 78.627 $208.869 52.66
Gallons
0000
58,853
24,387
83,240
78,627
4,613
5.54%
12.02%
Gallons Actual Revenue Gallons Actual Revenue
Accounts 0000 Revenue Per 1,000 9i Accounts 0000 Revenue Per 1,000 g'
5,106 36,428 $187,060 $5.14 5,112 39,964 $180,576 $4.52
2,355 20,727 $136,195 $6.57 2,331 22,521 $130,414 $5.79
7,461 57.155 $323.254 $5.66 7.443 62.485 5310.990 54.98
Gallons Actual Revenue
0000 Revenue Per 1,000 a
Gallons Actual Revenue
0000 Revenue Per 1,000 gi
38.545 $187,060 $4.85 52.916 $180,576 $3.41
19.061 $136,195 $7.15 22.532 $130,414 $5.79
57.606 $323,254 $5.61 75.448 $310,990 $4.12
AGENDA ITEM # 4A
AUGUST 11, 2008
H
w
0
a
O
0
N1
0
wow
F CA
z o.~7
m ~ U
~ ~
woa
z~a
H ~O a'
~ O
~ •• ~
z~
wwa
F F U
Yx W
a~cn
W m F
cxoz
~ N £
H..a
I>-I Q a ',
F W W
U>+q i
Q ~
woa~
U] w r.~ i
z
w m ••
U W F I
H~na
azw~
wq l
U
H i
a
w
z
W
z
O
x
a
5
q
0
H
F
U
H
W
W
a
U
W
a
F
q
W
m
H
H
N Ewa
r
~x ~z~~
• U i
~ ~ I W ~
N ~ C!] Cn ~
~m ~ ww
o U ~ Uzi H ~
~ ~~ ~ cn cn
HJJa i qq
N C N i (17 p]
~ b N
r ~ .-, ~
1' .a
~ O
i
r V-
O ~'
~ ~ ~
•~. r'J .
W i! O ~ U
G: - 1 ~
Q+ U Cy i .] i
O r~l O 01 VI 'cM Vl N CO N Ol
l11 V1 01 r+) N f+1 O 01 W O C
C U1 O ~ Lf1 lfl O e-i t!1 fD Ill r
N O~ ~-i N [O ~ 'V' r r w lD
I I I I ~ I I I I I
r L11 l!1 cl sr r+) N ~O 01 01 rl
r ~o ~ rn rn ~ r a ~ a ~
V' r sM 01 O~ vl M N N N f~l
I I I I I I I I I I
o Fo 0 o Fo qo 0 o qo Fo ago
rn ~rn rn rn Wrn Wrn rn rn Wrn vlm H01
I"I F H H H H a
a z a w w a
W H H Ey
~ W W
w ~ w m ~ °z
H W F U U F
~ F
a z
H ~ \ W W
W W W
a O 3 O 3 IUi 3 O ~
w a ~ ~. a x w o a H
~ ~ m w
m w z ~ ~ o w o ~' w
z w z w w
cn ] O AC q a U
£ W U W W F E F F W >~
~ ~ ~ ~ ~ ~ W
W z~'j.,~ o W ~ A ~ W ~.
H U c( •
a W £ U W F Z Cn U U
W H H c~ H O W ]~ O H H
Q £ w W £ U a a U £ £
3 3 3 3 3 3 ~ 3 3 3 3
w w w w w w w w w w w
z z z z z z z z z z z
0 0 0 0 0 0 0 0 0 0 0
co vl m ~ rn r rn M ui ~ in
'~ O r•1 O H N 'i N O O N
\ \ \ \ \ \ \ \ \ \ \
~O l0 l0 ~O ~ 10 ~O l0 10 l0 tD 1D
z a ~
a ~ ~ H w Iz
r~ M U .-7 r~ ri r1 ri o r~ q n ~ r+i r~-I r+~ F ri
,~, ~, a w r, r•, ,-, r, F I-, r, w ~., a M
N N a N N N N H N ~S N ,7. N P.' N W N
N W N U N N N N ,7, N H N O cl' N W N x N
rn R; t~ H r+l r+l rn N7 .7 rn 7+ o r+~ U rn F m M
a w mQw Q~w w w w aQw Qqw zHw wuw ~ w
¢ w u a F m a ~a H~ ~. w a
x ~+ x F F x x W x W x H W x ~ W x O x F q x m q x
u Fvu a¢u u >u u m U aEU acav HHu HaU
Q a wH~ o a a as ocna Ua as >d zma d
F W H Fz W £ .~ W f0 W W H Q W x H W U FC W W a W H aS W W cr+ W
2WQ ~aW P4 WFCO 2U~ ~~GO ~UZCO SRI CO Q W W zH W 2aP7
HzU >aU ~HU F WU HrSU FHV W rSU aU FZU H~7 ~U QiJ
R' H H F H F H H P: ~~[" H W H Cn CIJ H N a H Cn F( FL H H
H~~ gmct amp a~z rx~z ~nxz~ H~a Gated ~o~ aorL aua~
aHa ora wlna x~a xr.] ara cz~a zz a m a cxra aHa
WoF >'oF HrF rl .1F QHH H~F ONH Q~F xoE-~ QHF Hin c+
Q~r-C W Hr.>: C7riQ hr~ry h,~r-C Z~Q 2r4 ar-.Q F~or.~ s H S 3rQ
lf7 N r RJ l0 N r N H O T
~ to ~ ~ ~ ~ to ~ to to ~
Ol O~ O~ Ol 01 Q~ 01 O~ O~ ;r~ C*~
~O ~D lO ~D ~O lD ~D ~D l0 l[1 ~C
O O O O O O O O O O G
O O O O O O G O O O O
O O O O O O O O ^~ O C
O C O O G O O O O C
of m ~] rA O O7 ~A RJ :L` W
O O O O O O O G O C` O
w
W
z
W
U
a
3
W Ol N O O O O O O H
z ,~
F
''
o ~ ..
~ U a. ~. O L rY W U H
~ ~ ~ cL H > G~ [A O ~ a
N p y 0 ~:~ p
C, O O G~ ~.~,~~ ~N~ ~ O
C~jr "C! .$L.~:
p M ~~ ~ ca~~ ~ ~ o ~wq'' e~ O ,~
F-7 +-~ G
O N O Q a `b y i" ~ ~ ~ i+ ~
.a i ~ ~ ea ~ ~.aae~' o ~~U r°'.
,~' . ~ ~ p bq .~ p ~ R3 ~ O C O
O
a~ R py ~ b~ ~ 3 y pn ~i U N N CI
~~" ~ ~ C~ ~ SFr "L' ~ U ~ •~" ~~c~rr
G G •~ O ~~.~ O rn O ~ ~ w O~ r~r ~
O ~ ~ 'a ~+ N d O p0 ,.p ..~ O
Op„ ~ ~~(~ N ~.5: ~ q Oct., U.t~.
Z ~~ ~ ~ O O ~ ~ ~ N "O O ~ ~
z ~ .a ~
F p ° ~~ ~~ ~~a ~~~~ ~~vNb
~ ~. ~ z ~ •r~ ~, ...,
`~ a ~ ~ ~ ~
a o a ~ ~~ a ~ o ~ ~ o
Aa zFZ v~ U ~ U w as ae UA ~~ d ar.~d ~~
~~ o
F
a°a U ~ ~ y
~ F x '~ °~
O a ~ a ,~ ~ ~d a,
>~
U ~~~~ ~~ O °p o i i U o
W F ~ ~ tl ~ ~ II >7A'„ ^= II ~ ~ '~ II
p II II ~ II II ~ II ~ II ~ II II II
~ A v~ A~~ A `.~ A A~~
a
F >~
z ~
o ~ ~
U a~
II ~ O
..~ ~ .~ c ~ ~ II W II ~ o
~r N h y O .~ ~ ~ ,~ ~
W py/ q a, ~ ..+ 4
~ .~E oO° II ~ oO° II ~ y ~ II 3 ~ ~ o° ~
G7 W ~°., o o ~i o o v, q A~ °~A~, ~~~.~ o~
W U y ~ V ~ ti V ~~ ~ V 3 ~ ~~ ti.
cz7 ~ x ~' ,boo °~ ,boo a o ~ ~ a a; ~
A a xw 4U° ~ qU° rho ~ a,U° H 0. ~~ q C°
u
.,
A '-' N c~ et ~
AGENDA ITEM # 4A
AUGUST 11, 2008