Item 4A A GE ND A I TEM # 4 A
i A PRI L 2 3, 20 07
~ - ~
N O N
~ W
~ I ;
O0~ O° ~ N' ~ °D
V ~
~
w w
n a
.
o ~ O H U O V ~
J
o H O w - Z Z O
F-
~
~ W F"
Om
~ t- p
d J V, V ~ = W U
~ y ~ O J J w Q' N
?m v w a ~ F- ~
F- ti ~
~~ O
N °o °o °o o o °o o o °o ° o °o
W
U O
~ O
0 H
07 O
0 W
~ N
00 w 0
J O 0
O 00
~D 0
O O
~ ~
~
i
~
Q
~ ~
O
O
~
~
° O
0 ~
'.
~ oo
o ~ o
o t~
.- et
ti eo ~
e~i
~
N d
ZO m M
co" r~ ~
ti
s~ ~ 0 N Z ~
> ^
a ~
~ U
~
ti
O
~ (.~ N > ~ ZO
Q Z LL U
V
~ ~ ~ trs vs v- u- tR ~ ~ ~ tst ~ ~ ~
~J
Q U
~ 0
0
0
0
0
0 =
~
T CC 0
H 0
N 0
p 0
~ 0
~ 0
i Z
+ G
CG O~
fA tp 1~ t
Qs of Q1 Q
~ O
r (L
O
O Z r
Q 001 o0
00 1 ~
0 1~
t0 01
00 ~
~
~ O O
N V ON
N 00 0
M 00
O 01
t0 0
01 N
00
Q
Q N N ~ ~ r W
^ Z
U
~ O
1D O
O O
O O
O O
O O
u~ N
~ O
O O
O O
O O
O O
O O
O O
O N
et
~ ~
/~ O ~
Q N
(n F'-N
V1 W O
o0 tO
Q~ O
O
' O
ti et
O 1~
N ~
~O O
t0 ,M
' M
' ~
O u7
M O
~ O
O ~
Q1
1^in ~ O M ~ t~ ~ ~
' !C N lD !1 M r N 00
W ~ ~ ~ ~ ~ ~ ~ ~ () N M N ~ er N M N ~
~
O Z CC
^ G ~
a
~ to W
^O ~ ~
~ ~
o ~ WoM ~ M ~ I ~'
a
v a ~ ~
~
//~~
W ~ ~ } N
^ ~ a N N r r- N O N ~ M eP M ~ ~A ~ ~
I.f. l0
O
m N ti
~
O
O
E
M
d0'
l
Z
~ ~ tn l0
Z ~'
^
O J
J
O
Z
w
} ~
O N
~ O x
w J
a ~
~ 0
- ~
O
~ ~ °a a ~ °x ~ a ~ a ~ Y ~o a ~°-,, ,o g ~
~ a
"
x ~
W ~
W
~ a
W -
~ -
O mo
w o
~
>-
z
w ~
~ ~
?
Z
a ~
n
N
. ~
w
°C ~
Z
a
~ v,
~ W
o
,
~ w
J
C9 W
J O
O
~ ~
W
J
O w
J -
F-
~
~ cn
Y w
U
~
V'
O cn
O c9
g cn
J
J
y
Z ~
U m
~
=
U x
U
'
C~
- C9
Z
W ~
~
W
~ O
p
lJ.l
Z G.
~ ~
W ~
O 2
F-
Z f1
~ 0
~
O U
W Z
LI J
IF-
O W
=
a
W
O W
J ~
J
W a
O
~ -
~ W
OC -
~
~ Z
-
a in o ~ c~ o ~n ,o a c~ o .
u. ~ ~ cn c9 ~ rn w a ~ a ~ in F-- cn o ~~ ,
AGENDA ITEM # 4A
APRIL 23, 2007
Water Sales
Atlantic Beach
Buccaneer
s Total Water Sales
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
City of Atlantic Beach, FI.
Water and Sewer Utility Sales Report
March 2007 March 2006
Gallons Actual Revenue Gallons Actual Revenue
ounts 0000 Revenue Per 1,000 yi Accounts 0000 Revenue Per i,ooo gi
5,581 40,604 $100,002 $2.46 5,583 36,605 $89,609 $2.45
2.449 22.437 $65,510 $2.92 2,670 22,599 _$61.,362 $2.72
Gallons Gallons
0000 0000
55,506 57,647
23,376 21,871
78,882 79,518
63,041 59,204
15,841 20,314
20.08% 25.55%
11.61% 10.16%
Gallons Actual Revenue Gallons Actual Revenue
Accounts 0000 Revenue Per 1,000 gi Accounts 0000 Revenue Per 1,000 yl
5,038 33,564 $157,706 $4.70' 5,071 30,749 $143,715 $4.67
2.330 21.291 $124.783 $5.86 2,551 21,735 $120,848 $5.56
Sewer Treatment Gallons
0000 Actual
Revenue Revenue
Par 1,000 gi Gallons
0000 Actual
Revenue Revenue
Per 1,000 sl .
Atlantic Beach
Buccaneer 49.401
21.382 $157,706
$124,783 $3.19
$5.84 46.226
18.392 $143,715
$120,848 $3.11-
$6.57
Total Sewer Treated 70.783 $282,488 53.99 64.618 5264,563 $4.09
~.
City of Atlantic Beach
FINANCIAL REPORT
MARCH 2007
AGENDA ITEM # 4A
APRIL 23, 2007
Cash Balances
Fund
Prior
02/28/07
Current Dollar
03/31/07 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,789,533
$8,113,897
Cash and Investments
Account
Prior
2128107
Current
3/31107
Dollar Rate of
Change Return
Bank of America -Depository $277,489 $227,394 ($50,095) 4.36
SBA 14,766,649 14,673,486 (93,163) 5.39
Cash on Hand 2,550 2,550 0 -
Subtotal 15,046,688 14,903,430 (143,258)
Police Pension Investments 5,387,067 5,437,116 50,049 4.60 (1)
General Pension Investments 8,206,489 8,288,912 82,423 4.70 (1)
Subtotal 13, 593, 556 13, 726, 028 132,472
Total $28,640,244 $28,629,458 ($10,786)
(1) FYTD rate of return through 12/31/06
$6,721,771 $6,572,001 ($149,770)
20,913 13,713 ($7,200)
183,775 184,571 $796
351,612 150,196 ($201,416)
1,292,624 1,326,402 $33,778
5,514 4,039 ($1,475)
93,867 80,371 ($13,496)
44,520 50,612 $6,092
3,685,018 3,804,233 $119,215
490,428 495,330 $4,902
2,105,531 2,153,586 $48,055
31,154 24,498 ($6,656)
19,961 43,878 $23,917
$15,046,688 $14,903,430 ($143,258)
~-
City of Atlantic Beach
FINANCIAL REPQRT
MARCH 2007
Revenues
AGENDA ITEM # 4A
APRIL 23, 2007
Annual YTD - 50% YTD Dollar Percent
Fund / (Footnote) Estimate of Estimate Actual Variance Variance
A.
~.
~.
General (1)
Tree Replacement
Convention Development Tax
Local Option Gas Tax
Better Jax 1/2 Ct Sales Tax
Police Training, Forfeit, etc.
Grants
Debt Service
Utility
Sanitation (2)
Storm Water (3)
Pension -Police (4)
Pension -General (4)
Total
$10,576,532 $5,288,266 $6,934,849 $1,646,583 31.14%
0 0 0 0 0.00%
81,000 40,500 29,369 (11,131) -27.48%
563,042 281,521 266,786 (14,735) -5.23%
761,298 380,649 398,944 18,295 4.81
31,250 15,625 21,423 5,798 37.11
209,234 104,617 167,361 62,744 59.97%
73,048 36,524 36,781 257 0.70%
6,750,002 3,375,001 3,315,653 (59,348) -1.76%
1,558,200 779,100 662,669 (116,431) -14.94%
1,862,500 931,250 757,096 (174,154) -18.70%
765,862 382,931 490,933 108,002 28.20%
1,096,364 548,182 836,582 288,400 52.61
$24,328,332 $12,164,166 $13,918,446 $1,754,280
Analysis of Major Variances
(1) The $1,646,583 positive variance in the General Fund resulted from having received
88% of the budgeted property taxes in December, 2006 through March, 2007. Typically
the majority of these taxes are received from the City of Jacksonville in December &
January. Also, the 4th quarter of 2006 reimbursement. for .Beach Maintenance &
Lifeguards was received from the City of Jacksonville in October, 2006.
(2) The $116,431 negative variance in the Sanitation Fund resulted from the budgeted
revenues being increased $96,000 in anticipation of an increase in rates effective June
1, 2007.
(3) The $174,154 negative variance in the Stormwater Fund resulted from not having
received the grant for the Hopkins Creek Retention project -see Project Activity
Schedule. This project is partially funded on a reimbursement basis grant for $400,000
from the Florida Department of Environmental Protection. The new time line for this
project is to commence in December, 2007.
(4) The $108,002 positive variance in the Police Employee Pension Fund & the $288,400
positive variance in the General Employee Pension Fund resulted from changes in
market values of the investments.
City of Atlantic Beach
FINANCIAL REPORT
MARCH 2007
AGENDA ITEM # 4A
APRIL 23, 2007
Expenses
~., Annual YTD - 50% YTD Dollar Percent
Department / (Footnote) Estimate of Estimate Actual Variance Variance
Governing Body $50,898 $25,449 $26,114 ($665) -2.61
City Administration 2,250,891 1,125,445 1,086,413 39,032 3.47%
General Government 1,518,862 759,431 677,709 81,722 10.76%
Planning and Building 652,100 326,050 198,082 127,968 39.25%
~. Public Safety (1) 5,225,441 2,612,721 1,932,364 680,357 26.04%
Parks and Recreation 1,502,770 751,385 637,556 113,829 15.15%
Public Works (2) 8,524,534 4,262,267 3,256,641 1,005,626 23.59%
~" Public Utilities 7,602,680 3,801,340 3,567,177 234,163 6.16%
Pension-Police 424,133 212,066 215,027 (2,961) -1.40%
Pension -General 436,713 218,357 212,784 _ 5,573 2.55%
Total $28,189,022 $14,094,511 $11,809,867 $2,284,644
Annual YTD - 50% YTD Dollar Percent
"" Resource Allocation Estimate of Estimate Actual Variance Variance
Personal Services (1) & (3) $8,560,799 $4,280,399 $3,853,239 $427,160 9.98%
Operating Expenses (1) & (2) 9,806,814 4,903,407 4,179,822 723,585 14.76%
°"' Capital Outlay (1) & (2) 6,802,655 3,401,328 1,833,646 1,567,682 46.09%
Debt Service (4) 1,675,695 837,847 1,271,630 (433,783) -51.77%
Transfers 1 343 059 671,530 671,530 0_ 0.00%
~* Total $28,189,022 $14,094,511 $11,809,867 $2,284,644
Analysis of Major Variances
(1) 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. A payment was
made in January 2007 for October through December 2006. Also, .there are vacant
positions in the Police Patrol division and the Lifeguard expenses are seasonal (typically
June through September). Finally, no monies have been expended on the Police
Building Design -see the Project Activity Schedule:
(2) The positive variance in the Public Works departments resulted from only 5 of 6
payments having been made on the solid waste contract, the Sanitation Fund's
budgeted expenses being increased $68,000 in anticipation of an increase in expenses
effective June 1, 2007 and not having begun various projects -see the Project Activity
Schedule.
(3) The positive variance in the Personal Services is related to 50% of the first payroll of
October, 2006 being expensed in the prior fiscal year and vacant positions that have not
been filled.
(4) The negative variance in the Debt Service accounts resulted from the annual payment of
principal and semi-annual payment of interest on the Utility Revenue Bonds in October,
2006.
..
City of Atlantic Beach
FINANCIAL REPORT
MARCH 2007
AGENDA ITEM # 4A
APRIL 23, 2007
Project Activity -Current Year Activity Only
~" Project YTD YTD YTD
Project Name Number Budget Actual Balance Status
Parks and Recreation:
Buchman Trust Property
Jordan Park Shelter
Playground Equipment-Donner Park
Shade for the Skate Park
Russell Park Light Replacements
~"' Dune Crossover for 3rd Street
Subtotal
GG0701 $450,000 $0 $450,000
PR0701 10,000 0 10,000
PR0702 33,000 23,076 9,924
PR0703 20,000 19,519 481
PR0704 17,500 0 17,500
PR0705 20,000 19,642 358
550,500 62,237 488,263
Public Safety 466,850
Police Building Renovations PS0504 466,850 0
Subtotal 466,850 0 466,850
Public Utilities:
Fence Replacement at Water Plant 1
Genset at Lift Station B
Clarifier Rehabilitation at WWTP 1
Fence Replacement at WWTP 1
Sludge Container Refurbishment
Beach Habitat Subdivision
Remodel SCADA Control Area
Roof Replacement at Lab/Office
Begonia Street Water & Sewer Extension
Collection System Inspection & Rehabilitation
Replace 2 Hydroscreens
TMDL Engineering WWTP 1
Pumpout at Digester - WWTP2
Subtotal
PU0601 9,477 9,477 0
PU0604 29,007 0 29,007
PU0605 145,223 121,838 23,385
PU0606 3,133 3,133 0
PU0607 8,876 8,876 0
PU0608 110,554 110,553 1
PU0701 20,000 0 20,000
PU0702 17,695 17,695 0
PU0703 100,000 3,260 96,740
PU0704 315,400 0 315,400
PU0705 30,000 0 30,000
PU0706 338,500 0 338,500
PU0707 4,904 0 4,904
1,132,769 274,832 857,937
Public Works:
Hopkins Creek Retention
Mayport Road Medians
Five Points Intersection Improvement
Pathways
Sidewalks - Sailfish,Royal Palm & Frances
Storage Bins for Limerock
Mandalay Park Improvements
Repave Asphalt at Public Works Yard
Asphalt Stewart Street at West Main Street
Sidewalk & Curb Replacement
Pedestrian Path -Five Points to Selva Marina
New Sidewalks -Marsh Oaks
Ocean Boulevard Between 14th & 15th Street
Subtotal
Total
PW0309 2,530,730 906,914 1,623,816
PW0401 400,000 0 400,000
PW0502 8,164 8,164 0
PW0606 80,855 72,131 8,724
PW0607 5,102 0 5,102
PW0701 30,000 0 30,000
PW0702 50,000 0 50,000
PW0703 70,000 0 70,000
PW0704 10,000 0 10,000
PW0705 50,000 6,400 43,600
PW0706 120,000 323 119,677
PW0707 120,000 323 119,677
PW0708 350,000 21,087 328,913
3,824,851 1,015,342 2,809,509
$5,974,970 $1,352,411 $4,622,559
Status Key
B -Bid Awarded E -Design Phase
~. C -Project Completed I -Project In-progress
D -Design Completed R - Re-budget Next Fiscal Year
C
C
C
E
C
I
I
C
C
C
C
E
E
D
C
I
I
