Item 4ACity of Atlantic Beach AGJUNE 25, 2pp~ aA
FINANCIAL REPORT
MAY 2007
Cash Balances
Fund
Prior
04/30/07
Current
05/31/07
Dollar
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,805,475
$7,654,591
Cash and Investments
Account
Bank of America -Depository
SBA
Cash on Hand
Subtotal
$6,618,507 $6,274,998 ($343,509)
10,113 9,713 ($400)
200,818 208,887 $8,069
174,719 199,657 $24,938
1,363,832 1,301,099 ($62,733)
15,205 18,590 $3,385
66,679 93,877 $27,198
56,721 62, 868 $6,147
3,599,023 3,718,619 $119,596
358,982 362,624 $3,642
2,147, 369 2,174, 578 $27,209
11, 305 28,440 $17,135
55,752 6,116 ($49,636)
$14,679,025 $14,460,066 ($218,959)
Prior Current
04/30/07 05/31/07
$222,012
14,454,463
2,550
14,679,025
$242,489
14,215,027
2,550
14,460,066
Dollar Rate of
Change Return
$20,477 5.09 (1)
(239,436) 5.43 (1)
0 -
(218,959)
Police Pension Investments 5,571,785 5,644,872 73,087
General Pension Investments 8,493,494 8,701,507 208,013
Subtotal 14,065,279 14,346,379 281,100
Total $28,744,304 $28,806,445 $62,141
6.40 (2)
6.60 (2)
(1) Monthly rate of return annualized
(2) FYTD rate of return through 03/31/07
City of Atlantic Beach A JUNE 25,20074A
FINANCIAL REPORT
MAY 2007
Revenues
Fund / (Footnote)
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
Annual YTD - 67% YTD Dollar Percent
Estimate of Estimate Actual Variance Variance
$10,776,532 $7,187,947 $8,335,072 $1,147,125 15.96%
0 0 0 0 0.00%
81,000 54,027 53,686 (341) -0.63%
563,042 375,549 359,908 (15,641) -4.16%
761,298 507,786 538,117 30,331 5.97%
31,250 20,844 36,037 15,193 72.89%
216,450 144,372 211,438 67,066 46.45%
73,048 48,723 49,037 314 0.64%
6,750,002 4,502,252 4,418,416 (83,836) -1.86%
1,558,200 1,039,319 895,413 (143,906) -13.85%
1,862,500 1,242,288 1,009,590 (232,698) -18.73%
765,862 510,830 777,281 266,451 52.16%
1,096,364 731,275 1,291,916 560,641 76.67%
$24,535,548 $16,365,212 $17,975,911 $1,610,699
Analysis of Major Variances
(1) The $1,147,125 positive variance in the General Fund resulted from having received
95% of the budgeted property taxes in December, 2006 through May, 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 $143,906 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 $232,698 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 $266,451 positive variance in the Police Employee Pension Fund & the $560,641
positive variance in the General Employee Pension Fund resulted from changes in
market values of the investments.
City of Atlantic Beach
FINANCIAL REPORT
MAY 2007
AGENDA ITEM # 4A
JUNE 25, 2007
Expenses
Annual YTD - 67% YTD Dollar Percent
Department / (Footnote) Estimate of Estimate Actual Variance Variance
Governing Body $50,898 $33,949 $33,792 $157 0.46%
City Administration 2,250,891 1,501,344 1,401,389 99,955 6.66%
General Government 1,368,862 913,030 886,375 26,655 2.92%
Planning and Building 652,100 434,951 269,108 165,843 38.13%
Public Safety (1) 5,232,657 3,490,184 2,760,234 729,950 20.91%
Parks and Recreation 1,896,612 1,265,040 792,292 472,748 37.37%
Public Works (2) 8,524,534 5,685,864 4,099,123 1,586,741 27.91%
Public Utilities 7,602,680 5,070,987 4,737,186 333,801 6.58%
Pension -Police 424,133 282,897 218,522 64,375 22.76%
Pension -General 436,713 291,288 236,698 54,590 18.74%
Total $28,440,080 $18,969,534 $15,434,719 $3,534,815
Annual YTD - 67% YTD Dollar Percent
Resource Allocation Estimate of Estimate Actual Variance Variance
Personal Services (1) & (3) $8,536,540 $5,693,872 $5,103,010 $590,862 10.38%
Operating Expenses (1) & (2) 9,929,779 6,623,163 5,591,735 1,031,428 15.57%
Capital Outlay (1) & (2) 6,955,007 4,638,990 2,189,406 2,449,584 52.80%
Debt Service (4) 1,675,695 1,117,689 1,655,196 (537,507) -48.09%
Transfers 1,343,059 895,820 895,372 448 0.05%
Total $28,440,080 $18,969,534 $15,434,719 $3,534,815
Analysis of Major Variances
(1) The positive variance in the Public Safety departments is partially due to vacant
positions in the Police Patrol division and the Lifeguard expenses are seasonal (typically
June through September). Also, 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 7 of 12
monthly payments having been made on the solid waste contract as of the eighth month
of the fiscal year, 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 shown on the schedule 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 and the semi-annual payment of interest on the Utility
Revenue Bonds in April, 2007 as planned.
City of Atlantic Beach
FINANCIAL REPORT
MAY 2007
AGENDA ITEM # 4A
JANE 25, 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
Public Safety
Police Building Renovations
Public Utilities:
Fence Replacement at Water Plant 1
Genset at Lift Station B
Clarifier Rehabilitation at WWTP 1
Fence Replacement at WWTP 1
GG0701 $650,000 $0 $650,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
Subtotal 750,500 62,237 688,263
PS0504 466,850 9,452 457,398
Subtotal 466,850 9,452 457,398
Sludge Container Refurbishment
Beach Habitat Subdivision
Remodel SCADA Control Area
Roof Replacement at Lab/Office
Begonia Street Water & Sewer Extension
Collection System Inspection & Rehabilitation
TMDL Engineering WWTP 1
Pumpout at Digester - WWTP2
Subtotal
Public Works:
Hopkins Creek Retention
Mayport Road Medians
Five Points Intersection Improvement
Pathways
Sidewalks - Sailfish,Royal Palm & Frances
Storage Bins for Limerock
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
PU0601 9,477 9,477 0
PU0604 29,007 24,999 4,008
PU0605 145,223 139,147 6,076
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 150,000 3,786 146,214
PU0704 315,400 6,293 309,107
PU0706 338,500 0 338,500
PU0707 4,904 0 4,904
1,152,769 323,959 828,810
PW0309 2,530,730 954,147 1,576,583
PW0401 400,000 0 400,000
PW0502 8,164 8,164 0
PW0606 80,855 72,984 7,871
PW0607 5,102 612 4,490
PW0701 30,000 1,073 28,927
PW0703 70,000 0 70,000
PW0704 10,000 0 10,000
PW0705 50,000 8,225 41,775
PW0706 120,000 63,218 56,782
PW0707 120,000 61,856 58,144
PW0708 350,000 32,261 317,739
3,774,851 1,202,540 2,572,311
$6,144,970 $1,598,188 $4,546,782
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
C
E
C
C
C
C
C
C
E
I
E
D
C
AGENDA ITEM # 4A
J[JNE 25, 200'7
City of Atlantic Beach, FI.
Utili ty Sales Report
May 2007 May 2006
_~
Gallons Actual Revenue Gallons Actual Revenue
Water Sales Accounts 0000 Revenue Per 7,000 9i Accounts 0000 Revenue Per 1,000 gi ~'~
Atlantic Beach 5,616 50,027 $126,164 $2.52 5,615 53,933 $131,172 $2.43 ;;
Buccaneer 2,461 24,421 $70,118 $2.87 2,585 28,324 $74,036 $2.61
Total Water Sales 8,077 74,448 ;196,282 ;2.64 8,200 82 257 ;205,208 ;2.49
Gallons Gallons
Water Plant Production o000 0000
Atlantic Beach 62,108 71,720
Buccaneer 31,420 23,598
Total Production 93,528 95,318
F
Total Water Billed 74,448 82,257
Water Loss for month: 19,080 13,061
Percentage Loss 20.40°~6 13.70°~
Total 12 mo. Avg. Loss 12.22°i6 9.85°~
Gallons Actual Revenue Gallons Actual Revenue
Sewer Sales Accounts 0000 Revenue Per 1,000 9i Accounts 0000 Revenue Per 1,000 gi ;'
Atlantic Beach 5,080 37,759 $168,866 $4.47 5,093 40,681 $178,207 $4.38 -;
Buccaneer 2,336 22,909 $130,400 $5.69 2,467 26,937 $142,270 $5.28
Total Sewer Sales 7,416 60,668 ;299,266 ;4.93 7 560 67,618 ;320,477 ;4.74
Gallons Actual Revenue Gallons Actual Revenue :,
Sewer Treatment 0000 Revenue Per 1,000 9i ~ 0000 Revenue Per 1,000 gl '.
Atlantic Beach 49.501 $168,866 $3.41 ' 46.294 $178,207 $3.85
Buccaneer 22.066 $130,400 $5.91 21.091 $142,270 $6.75
Total Sewer Treated 71.567 ;299,266 ;4.18 67.385 ;320,477 ;4.76 ~J
i:'a
AGENDA ITEM # 4A
JUNE 25, 2007
~ o
.~ °>'V ° fir.
"
°
~ ~ Oj GEC U 'CS
~ o
~ N ~
~~ a~,a ~ ~~ ~
o .~ ~'~ o a v~ ~ ~.
~~ a.~ ~~ >~a~ ~
°o
~ s Q ~ ~ Q •~ o
N -
~ ~ ~ C7 .a C/1 ,_., ~ O U
~
° t~
~
o
~..~ ~
~ w
~ ~
N
x]. ~,
~
O O _
~ ~,
Q O
... v
i .^
~ ~ ~
~ N ~,
~ ~
~ "C3
GY
~ N • N V]
i ~
y W ~ ~
N ~
a
~i
L~ .~
o b~A
`
N ~
,
0 ~
~
~ ~
O ~' vVi
U Q ~'
~
O cC ~a 0
..~ ~ ~
bA ~ w p
•~ ~
ai .~.." ~+"+ v O ~
ti ~ ~
3
.~
~ O A
~v~ ~ s.
w
o ~-~.~ 3~~ b`° ~~3 ~~
z ~, o.~ N ~¢ ~ ~~ ~~~
~
a
z
•~ °
'~~ o
~ ~
,; o
~N~ >~
~~
; H °
r,
F p ~ : ~ b ~ N ~ ~ a ~ ~, ~, ~
ao d ~.~>~ °°0 a ~
A a,
z
~
a~ w
a, h w 3.~
~' ~ Q
~ ~
m
a
~ o
[-~ ~ U
F
~
U_ ~
Q .~.
~
~W w ~ ~ ~
~
~~
3 a ~ ~ ~ ~ .~ ~ o . e ° ~ .~
3 3 w ~
~ W ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ .~ ~
H ~ .~
~ z Q o 3 ~ :~ 3 ~ :~ ~ b ~ .~
w E~
U ~
U ¢
C7 ~ ~
a C7 I I ~ ~
a C7 I I ~ I I
W pQ", ' ~
Q~ I I
,~•
z ~ II II II it ~ II II ~ II it ~ II ~ it ~
0 ~ Ca Q Q U U Q U U Q U V Q U U
a
H
z
o ~ ~
u
.. a ~ k, °' v~
w z ~ -o ~ Q
U p >~ v, a, ~ ~, ~
GY" n'+
r.i N O v~ ~ ~ h 'x ~ O ~ ~ ~ ~
W ~ ~
~
II ~ o O
~ ~ II ~ o
N ~ O~
II CA ~
"d «3 o
~ "ti
II '~ ~
o O
II ~
>~ O
A .
o
~ ~
~
0
~ o~
3 0
~
~'
o
~
Q~ o
-d
o
~~
o II
0
0
~ ~ 0 ~ o '
I
W F" ~ II v II v II v ?~ p II v ~ ~ ~ G ai ~ II U
A a xw q U ~ qU 3 q U v
a q U O~ q U x ~ Q U
u i
. r
A ~ c~ cn ~t ~n ~o
AGENDA ITEM # 4A
JUNE 25, 2007
r
O
~
O ^O "'~
O
a~ ~
~ ~,
p,, ~ a ~
~' a
0
~o-o °.~ v
~ o ~
x N "a civ ~~~„
~ a
~
~ ~
~ ~ U
.~ O ~ U
t` ~
L
N o c ~ a
f~ O O ~MVS A
O •p ^O O =
3
0
>» ~
°
0 r
,
~
M ~O
L
ce
f~.
W ~ ~ CC
i
.
~ 'b O
~ '~'' ~ ~
~ ~ CD ~
N
c
N ~, CO ~
~ o ~o ~ C~ o
w on
~
W ~
`O cd ~ U
~~~ w ~
g a b >
y
F O O ~
~~ ~
[-+
d t/1 ~ ~ ~
~
~ _
~ C
B
°
a v H ~ Q,;~
~
a'O ~
as ~
~ o~~
~~~ ~~
aaL x
z
F~ O
F u
~F U
~
~
h ~ ~
U ~
~O ~ ~ ; U ~
x ~ ~
O U
_ Q
w F ~ ~ u ~ u ~
~
° u u ~3
,~ .. w a ii ~
,-. ,~ w n
•..
a
c A ~ ~ Q U U Q
v a,
O
0.
F
O >~
U o
11
~ 3
a~
w z
O b `r1
~ o
~ ~
~ .-.
w ~ ~ a 3~ o a
c7 w
A ~ ° o
^ .~ ~ ° o
^- -d
W
U c~
.
a ~~ ~ ~
~ ~~ ~
~
CZJ ~ ~
~ h .
o ~ ~ ~ N
~ ~ .
~ N O ~ O
~ ~ '.
g a ~ q U ~
at w ~1 U ~.
n
A
~
o0
0~