Item 4AAGENDA ITEM # 4A
JiJNE 23.2008
', o ° ~ ~
W I
~ ~
~
i N N E
~O
Z ~ O
O~ O
N O
N !O
E ~ ~
N
~
O i I
F-
U W ~
I W
d
~
d -
J ___
I Z ~ Z i ~ ~ i
J O O J
O Q
V , O
~
ENO
p c o V C9
z F' V ~.
~
~ a
~ ~,
il ~ m
~ Q
v N
w
ti vs
~ ~
~~ ~~
~ z w
~ m v w a ~ ~ ~ °c
a ~ i o a o o o o' er o o a
w
0
0
~
~
~
~
~
°
~
~
a
~
o
~ ~ ~ N ~ ~ ~ N > N N ~ OOD I 01
t0 ~
O
N o~
o mo d' oo ~ Z
O
~
i
0 ~ ~ ~
~." ~ ~ LL ~
(~ ~ O to
a
o
o N
>
~ z
~
i ~
O
Z
J W N ~ ~ «~ ~ «~ ~ O ~, ~ «~ ~
~ ~'
a ~ o
0 o~
0 o
0 o
0 o
0 o
0 ~
~ '
Z
Z
~ ~
N 0
o
1A 0~
o
O 11A
N
O ~
ao
~O N
o~
M N
o
t0 0
W
O ~/O~/~ LL
Z 1~1.
~• O ~
i. ~
ao M
M 01
O
V/ O o
M ~ ~ O ~ ~
~
A/
LL = O Q M ~ N CI ~ 00 (n ~
f
II
~
r Q
a ~
I (~
~ ~ ~
~ O
1A O
~
~ O
O O
~ O
0 O
0 O
0 O
0 O
0 I O
O O
O I
W
~ o
n _
C
L ~
O ~,
N~
~ o
N
~ ~
~ o
~ ~
O o
~ M
N ~
O> ~
~ o
~
i
~
I
I
Q O ~ .
~ fA FA fR V! 1R V- ~/
N
LL V N ~ N r N ~j
~ ~
V ~ O W i
O
(
Z ~- a
~
Z ~ v~ ~ v~ ~a ~r v~ v~ ~- v~ ~ v- i I ~
J ~~
_ H
O ~°
`°
m
~
~I
ti
~ j
m ao
~~ ~
a O W ~ ~ I
W ~
~ ~ t0 N O N N M N M ~
~ o a
I
~ G ti m ~O o
~I ~
! ti Z
z j
J
Q J
Q
i
O W , ~
I O jW
Z O
Y
J I
W ~. O } W W
O V ~~ J J
° O ~ '
a
J
a
j
v
a
=
~
J
v
~
a
Qi
p
~
O
c~
~
Q
~
~
g ,
H LL ~ w Z ~ c9 v c9
z - z Q -
W
J ~C
W w
G W
~ y
~ W
J ~
W O
F- w
~ G
~
N
W
~ z
-
f/) W
C9
(n a
~ -
m z
Q
2 F-
Q
O W
~ -
$
3
W ~
0 F
-
J
C9 J 0 W (, J - Y C) J LL G q J Z V ~ = V C9 Z W ~ p O
W
a Z
in ~
o W
a O
v H
o Z
m ~
c G
a O
c~ W
o W
u. F-
~ O
~ =
m Q
c~ W
3 C7
m J
w J
a W
~ O
a 0'
~ G
m ~
~ 3
~n ~
c Z
3 W
o
AGENDA ITEM # 4A
JUNE 23, 2008
City of Atlantic Beach, FI.
Utility Sales Report
May 2008 May 2007
Gallons Actuat Revenue Gallons Actual Revenue
Water Sales Accounts 0000 Revenue Per 1,000 eI Accounts 0000 Revenue Per 1,000 gl
Atlantic Beach 5,635 43,405 $121,720 $2.80 5,616 50,027 $126,164 $2.52
Buccaneer 2,464 22,367 $70,694 $3.16 2,461 24,421 $70,118 $2.87
Total Water Sales 8,099 65,772 $192,414 $2.93 8,077 74,448 $196,282 $2.64
Gallons Gallons
Water Plant Production 0000 0000
Atlantic Beach 60,520 62,108
Buccaneer 22,170 31,420
Total Production 82,690 93,528
Total Water Billed 65,772 74448
Water Loss for month: 16,918 19,080
Percentage Loss 20.46% 20.40%
Total 12 mo. Avg. Loss 12.75% 12.22°k
Gallons Actual Revenue Gallons Actual Revenue
Sewer Sales Accounts 0000 Revenue Per 1,000 gr Accounts 0000 Revenue Per 1,000 gl
Atlantic Beach 5,132 34,239 $179,028 $5.23 5,080 37,759 $168,866 $4.47
Buccaneer 2,347 21,114 $137,172 $6.50 2,336 22,909 $130,400 $5.69
Total Sewer Sales 7,479 55,353 $316,200 $5.71 7,416 60,668 $299,266 $4.93
Gallons Actual Revenue Gallons Actual Revenue
Sewer Treatment 0000 Revenue Per 1,000 gi 0000 Revenue Per 1,000 gl
Atlantic Beach 38.612 $179,028 $4.64 49.501 $168,866 $3.41
Buccaneer 20.114 $137,172 $6.82 22.066 $130,400 $5.91
Total Sewer Treated 58.726 $316,200 $5.38 71.567 $299,266 $4.18
City of Atlantic Beach AGENDA ITEM#4A
JiJNE 23, 2008
FINANCIAL REPORT
MAY 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
$6,831,997
23,519
222,927
380,512
1,131,762
60, 788
6,293
56,251
193,704
3,604,124
454,637
88,684
2,481,191
23, 924
74,124
Total $15,634,437
Total Restricted Cash
Total Unrestricted Cash
Current Dollar
05/31/08 Change
$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,957,743
$8,681,980
($66,680)
5, 382
5,290
8,256
(26,411)
(3,922)
(12,927)
(2,149)
27,790
(23,149)
(1,828)
$12,265
77,692
(11,360)
17,037
$5,286
Cash and Investments
Account
Prior
04/30/08
Current
05/31 /08
Bank of America -Depository
SBA
Banc of America Securities LLC
Cash on Hand
Subtotal
Police Pension Investments
General Pension Investments
Subtotal
Tota I
Prior
04/30/08
$3,011,901
1, 343
12,618,643
2, 550
15,634,437
5,762,378
9,032,888
14,795,266
$30,429,703
$2,997,047
1, 340
12,638,786
2,550
15,639,723
5,812,548
9,107, 532
14,920,080
$30,559,803
Dollar Rate of
Change Return
($14, 854)
(3)
20,143
0
5,286
1.95
2.49
1.84
50,170
74, 644
124,814
$130,100
(3.70) (1)
(3.40) (1)
(1) FYTD rate of return through 03/31/08
City of Atlantic Beach
FINANCIAL REPORT
MAY 2008
Revenues
AGENDA ITEM # 4A
JUNE 23, 2008
Annual I YTD - 67% YTD Dollar Percent
Fund / (Footnote) Estimate of Estimate Actual Variance Variance
General (1) $11,007,888 $7,342,261 $8,371,195 $1,028,934 14.01%
Tree Replacement 0 0 19,188 19,188 100.00%
Convention Development Tax 90,500 60,364 25,301 (35,063) -58.09%
Local Option Gas Tax 537,196 358,310 346,275 (12,035) -3.36%
Better Jax 1/2 Ct Sales Tax 831,885 554,867 489,774 (65,093) -11.73%
Police Training, Forfeit, etc. 47,530 31,701 23,978 (7,723) -24.36%
Grants 290,478 193,749 109,333 (84,416) -43.57%
Debt Service 70,966 47,334 46,525 (809) -1.71%
Capital Projects 330,000 220,110 221,494 1,384 0.63%
Utility (2) 9,585,150 6,393,295 4,406,800 (1,986,495) -31.07%
Sanitation 1,762,230 1,175,407 1,210,245 34,838 2.96%
Building Code Enforcement 513,329 342,390 262,192 (80,198) -23.42%
Storm Water (3) 3,162,675 2,109,504 1,699,195 (410,309) -19.45%
Pension -Police (4) 745,841 497,476 181,021 (316,455) -63.61%
Pension -General (4) 1,244,005 829,751 428,885 400,866 -48.31%
Total $30,219,673 $20,156,519 $17,841,401 ($2,315.118)
Analysis of Major Variances
(1) The $1,028,934 positive variance in the General Fund resulted from having received
96% of the budgeted property taxes. Typically the majority of these taxes are received
from the City of Jacksonville in December & January.
(2) The $1,986,495 negative variance in the Utility Funds resulted from not having received
$614,974 budgeted for the St. John's River Water Management District grant, $933,800
for bonds that were to be issued in fiscal year 2008 & a variance of $437,455 from
decreased sales.
(3) The $410,309 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 $316,455 negative variance in the Police Employee Pension Fund & the $400,866
negative variance in the General Employee Pension Fund resulted from changes in
market values of the investments.
City of Atlantic Beach
FINANCIAL REPORT
MAY 2008
AGENDA ITEM # 4A
JiJNE 23, 2008
Expenses
Department / (Footnote)
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
Tota I
Resource Allocation
Personal Services (4)
Operating Expenses (1) & (2)
Capital Outlay (1), (2) & (3)
Debt Service (5)
Transfers
Total
Annual YTD - 67% YTD Dollar Percent
Estimate of Estimate Actual Variance Variance
$47,760 $31,856 $28,428 $3,428 10.76%
2,290,906 1,528,034 1,329,367 198,667 13.00%
1,220,481 814,061 786,388 27,673 3.40%
235,024 156,762 118,913 37,849 24.14%
5,562,686 3,710,312 2,905,992 804,320 21.68%
354,137 236,210 230,894 5,316 2.25%
9,391,078 6,263,850 4,735,585 1,528,265 24.40%
10,125,589 6,753,768 4,987,800 1,765,968 26.15%
268,281 178,943 161,639 17,304 9.67%
437,323 291,694 278,608 13,086 4.49%
459,094 306 216 297,675 8,541 2.79%
$30,392,359 $20,271,706 $15,861,289 $4,410,417
Annual
Estimate YTD - 67%
of Estimate YTD
Actual Dollar
Variance Percent
Variance
$8,531,966 $5,690,821 $5,093,035 $597,786 10.50%
10,256,012 6,840,763 5,958,799 881,964 12.89%
7,436,663 4,960,254 1,470,872 3,489,382 70.35%
1,683,825 1,123,111 1,682,655 (559,544) -49.82%
2,483,893 1,656 757 1,655,928 829 0.05%
$30,392,359 $20,271,706 $15,861,289 $4,410,417
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, 2 vacancies in the Patrol division, lifeguard
services being seasonal 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 7 of 8 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. The raises for the bargaining unit employees retroactive
to 10/01/07 are still pending.
(5) The negative variance in the Debt Service Category resulted from the October
payment of principal and interest on the Utility Revenue Bonds.
City of Atlantic Beach
FINANCIAL REPORT
MAY 2008
AGENDA ITEM # 4A
JiJNE 23, 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 28,632 27,733 899
358,632 27,733 330,899
PU0704 58,109 49,399 8,710 I
PU0706 510,000 88,103 421,897 E
PU0801 30,000 2,926 27,074 I
PU0802 829,000 0 829,000 I
PU0803 30,000 9,088 20,912 I
PU0804 22,593 22,593 0 C
PU0805 1,800,000 0 1,800,000 E
PU080ti 1,595 0 1,595
3,281,297 172,109 3,109,188
PM0802 20,500 0 20,500 I
PM0803 15,000 5,302 9,698 I
PM0805 70,000 0 70,000 I
PM0807 12,000 11,075 925 I
PW0309 1,512,872 582,985 929,887 I
PW0401 400,000 5,007 394,993 I
PW0701 26,272 26,272 0 C
PW0705 2,819 0 2,819 I
PW0708 271,969 271,965 4 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
PW080ti 30,000 11,605 18,395 I
PW0807 75,000 0 75,000 R
PW0808 400,000 0 400,000
Subtotal 3,038,410 914,211 2,124,199
Total $6,678,339 $1,114,053 $5,564,286
Status Kev
B -Bid Awarded E -Design Phase
C -Project Completed I -Project In-progress
D -Design Completed R - Re-budget Next Fiscal Year