Item 4A
AGENDA ITEM # 4A
FEBRUARY 26, 2007
ti
~ o
Z N~
o
o
~
ti
o
0
0
~
O [] r ~ Q r M N N r r
~
O ~
W
d
~
a
H
J
v
~
J
v J
Q
O
o
M ?
JN~ ~~
f~ W Z W ~ ? Z H
~Qr, z aQ V ~ ~ = w
o
OF ~
~. U
W W
~ ~
m U W d ~ F
-- ~
O o
0 0
0 0
0 0
0 0
0 o
0 Z 0
~ 0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0
a Z o
1~ O o
O o
O o
O ~
ao ~
c~ o
V o o a o
iA o
fA o
fR o
~ o
~ o
fR a
tf? a
iA o
fA o
tf1 o
iA o
fR o
E9 o
1A o
fi? o
fA ~
W
A/ I`
O I`
O
OOSA
F- Nti
O
O
1~
O
0
Q1
1~
1+
0
Y> W O
> > P O
O 1~
O O
Q~
N r
~ O
o
ii O 0 a Q M N 000 N ~ ti ~ Q M N O00 N t~R ~ ~
~' N N ~ s 's ~' ~ ~' ~ z ~' ~ ~ ~ ~ ~
,
Q
~ ,
~ U
> > O
=
~p
~ Z U 0
0 0
0
0 0
0
~ 0
0
O 0
0
N 0
0
7
a O a
- ~ 00
~ per 0
c~
ti 1
O ts N
r• Y
r
N
N ~
LL ~oo
~Nr ~ ti
~ ,
ti O
J
~
O Z Q M
o ~~ N
~ 1p
~ r
~, M
N
=
a ~
1-
Z
W
Z
O O
O o
o o
a O
o
o
~ 0
o 0
o 0
~ 0
o 0
o 0
o 0
o 0
0 0
0
M
0
~ O
0
0
0
0
0
0
0
0
0 o
0
0
~O
O ~ ~ ~ a
~ ~ ~ O
tOA ~
CO~ N
C10l H ~l
O O
V! Cg
M O
fii O
lA O
~ O
~ 1~
M N M 0
~ OfA~ EOR ~ N 0
~ ~
~~//
d V d~9 ~
1!9
~
~
~
~
~
~ ~
~ <D
~ 1~
N
O LL
~ ll_.
^ O N
a ~ ~
W a Z Q r N ~ M M ~ ~ N
p a F= N
~~ ~
m
n ~ ~ N M O M O t0 O O N r ~ M M O O O N N ~L!
• ~ 0 ~ W r r ~ ~
p O Woo ~a
~ ~
J
~
J
~ -
~ a
m
o
O m
o
~
J v
~~
O v) O J ~ O
W
a ~„
o }
~
O
w p
a
a t
o
~
„
1-- J
¢ j Q
~ N
0 a = 0-~ Q
c~ y
z J
v t~ ¢
c~ p t~ ~ p
N ~
F. w W c
~ ~ w ~ z ~ ~
Q c7 W z z ~
w
~ z Q 3 c
'
J W
J Q
O r2 W J W
J O
- rL
fi W
t) ~
- 1%. ~
D O
~ J ~
z H
t~ m
~ = V
~7 (~
z
w ~
~ W
> O
Q D
~
~
W t9
Z a
Q ~
W ~
O a
y c9
? a
Q Q
Q ~
O c~
W z
W d
F ~
O W
2
Q -j
W
~ w
J ~
J v
W ~
0
~
~ w
~ -
~ -
~ z
-
' m
a ~ Q ~ v ? rn G a t~ Q w ~ ~ N C9 ~ cn w a ~ a ~ cn ~- N Q S ~-
~.
~w
lilt of Atlantic Beach
Y AGENDA ITEM # 4A
FEBRUARY 26, 2007
FINANCIAL REPORT
JANUARY 2007
Cash Balances
-- Prior Current Dollar
Fund 12/31/06 01/31/07 Change
General $6,043,138 $7,005,155 $962,017
Tree Replacement 20,913 20,913 $0
Convention Development Tax 163,448 177,110 $13,662
Local Option Gas Tax 309,762 325,594 $15,832
~. Better Jax 1/2 Cent Sales Tax 1,252,422 1,231,325 ($21,097)
Police Training, Forfeit, etc. 9,587 9,717 $130
Grants 65,956 62,867 ($3,089)
~" Debt Service 32,430 38,471 $6
041
Utility 3,511,406 3,603,647 ,
$92,241
Sanitation 569,424 489,657 ($79,767)
'" Storm Water 1,971,166 2,024,825 $53,659
Pension -Police 14,177 (5,769) ($19,946)
Pension -General 64,621 79,773 $15,152
Total $14,028,450 $15,063,285 $1,034,835
Total Restricted Cash $6,817,216
Total Unrestricted Cash $8,246,069
Cash and Investments
Prior Current Dollar Rate of
Account 12/31/06 1/31/07 Change Return
Bank of America -Depository $85,266 $409,646 $324,380 4.33
SBA 13,940,634 14,651,089 710,455 5.38
Cash on Hand 2,550 2,550 0 -
Subtotal 14,028,450 15,063,285 1,034,835
Police Pension Investments 5,387,366 5,434,203 46,837 4.60 (1)
General Pension Investments 8,059,747 8,126,237 66,490 4.70 (1)
Subtotal 13,447,113 13,560,440 113,327
Total $27,475,563 $28,623,725 $1,148,162
(1) FYTD rate of return through 12/31/06
City of Atlantic Beach
FINANCIAL REPORT
JANUARY 2007
Revenues
AGENDA ITEM # 4A
FEBRUARY 26, 2007
Fund / (Footnote) Annual
Estimate YTD - 33%
of Estimate YTD
Actual Dollar
Variance Percent
Variance
General (1) $10,576,532 $3,521,985 $5,635,604 $2,113,619 60.01%
Tree Replacement 0 0 0 0 100.00%
Convention Development Tax 81,000 26,973 21,908 (5,065) -18.78%
Local Option Gas Tax 563,042 187,493 184,757 (2,736) -1.46%
Better Jax 1/2 Ct Sales Tax 761,298 253,512 258,506 4,994 1.97%
Police Training, Forfeit, etc. 31,250 10,406 16,908 6,502 62.48%
Grants 209,234 69,675 123,389 53,714 77.09%
~,. Debt Service 73,048 24,325 24,639 314 1.29%
Utility (2) 6,750,002 2,247,750 2,186,093 (61,657) -2.74%
Sanitation 1,462,200 486,913 441,272 (45,641) -9.37%
Storm Water (3) 1,862,500 620,213 505,062 (115,151) -18.57%
Pension -Police (4) 765,862 255,032 388,733 133,701 52.43%
Pension -General (4) 1,096,364 365,089 639,720 274,631 75.22%
"" Total $24,232,332 $8,069,366 $10,426,591 $2,357,225
Analysis of Major Variances
(1) The $2,113,619 positive variance in the General Fund resulted from having received
82% of the budgeted property taxes in December, 2006 and January, 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 $61,657 negative variance in the Utility Funds resulted from the lower sales
volume of water & sewer.
(3) The $115,151 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 $133,701 positive variance in the Police Employee Pension Fund & the $274,631
positive variance in the General Employee Pension Fund resulted from changes in
market values of the investments.
"" C It of Atlantic Beach AGENDA ITEM # 4A
y FEBRUARY 26, 2007
FINANCIAL REPORT
JANUARY 2007
Expenses
Annual YTD - 33% YTD Dollar Percent
Department / (Footnote) Estimate of Estimate Actual Variance Variance
~"" Governing Body $50,898 $16,949 $18,493 ($1,544) -9.11%
City Administration 2,253,291 750,347 708,961 41,386 5.52%
General Government (1) 3,037,978 1,011,648 548,604 463,044 45.77%
Planning and Building 652,227 217,192 112,716 104,476 48.10%
Public Safety (2) 4,759,060 1,584,766 1,325,638 259,128 16.35%
Parks and Recreation 1,185,330 394,715 374,350 20,365 5.16%
Public Works (3) 7,723,057 2,571,776 2,178,152 393,624 15.31%
Public Utilities (4) 7,650,855 2,547,735 2,642,222 (94,487) -3.71
Pension -Police 424,133 141,236 146,008 (4,772) -3.38%
Pension -General 436,713 145,425 142,702 2,723 1.87%
~. Total $28,173,542 $9,381,789 $8,197,846 $1,183,943
Annual YTD - 33% YTD Dollar Percent
,~ Resource Allocation Estimate of Estimate Actual Variance Variance
Personal Services (2) & (5) $8,570,674 $2,854,034 $2,383,084 $470,950 16.50%
., Operating Expenses (2) & (3) 9,701,051 3,230,450 2,634,587 595,863 18.45%
Capital Outlay (1) & (3) 6,883,063 2,292,060 1,460,858 831,202 36.26%
Debt Service (4) 1,675,695 558,006 1,271,630 (713,624) -127.89%
Transfers 1,343,059 447,239 447,687 (448) -0.10%
~. Total $28,173,542 $9,381,789 $8,197,846 $1,183,943
Analysis of Major Variances
(1) The positive variance in the General Government departments resulted from not having
begun the Buchman Trust Property project or the Police Building Renovations --see the
Project Activity Schedule.
(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. 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).
(3) The positive variance in the Public Works departments resulted from only 3 of 4
payments having been made on the solid waste contract, not purchasing the budgeted
trash truck as of January 31, 2007 and not having begun various projects -see the
Project Activity Schedule.
(4) The negative variance in the Public Utilities department resulted from the annual
payment of principal and semi-annual payment of interest on the Utility Revenue Bonds.
(5) 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.
~"" ~ I
~" City of Atlantic Beach AGENDA ITEM # 4A
FEBRUARY 26, 2007
FINANCIAL REPORT
JANUARY 2007
Project Activity -Current Year Activity Only
- Project YTD YTD YTD
Project Name Number Budget Actual Balance Status
General Government:
Buchman Trust Property GG0701 $450,000 $0 $450,000
Subtotal 450,000 0 450,000
~„ Parks and Recreation:
Jordan Park Shelter PR0701 10,000 0 10,000
Playground Equipment-Donner Park PR0702 33,000 0 33,000
Shade for the Skate Park PR0703 20,000 0 20,000
Russell Park Light Replacements PR0704 17,500 0 17,500
Dune Crossover for 3rd Street PR0705 20,000 0 20,000
Subtotal 100,500 0 100,500
Public Safety
Police Building Renovations PS0504 466,850 0 466,850
Subtotal 466,850 0 466,850
Public Utilities:
Fence Replacement at Water Plant 1 PU0601 12,049 0 12,049
Genset at Lift Station B PU0604 29,007 0 29,007
Clarifier Rehabilitation at WWTP 1 PU0605 145,223 89,840 55,383
Fence Replacement at WWTP 1 PU0606 3,984 0 3,984
'~"` Sludge Container Refurbishment PU0607 8,900 8,876 24
Beach Habitat Subdivision PU0608 151,179 63,035 88,144
Remodel SCADA Control Area PU0701 20,000 0 20,000
~* Roof Replacement at Lab/Office PU0702 17,695 12,000 5,695
Begonia Street Water & Sewer Extension PU0703 100,000 3,260 96,740
Collection System Inspection & Rehabilitation PU0704 365,400 0 365,400
Replace 2 Hydroscreens PU0705 30,000 0 30,000
TMDL Engineering WWTP 1 PU0706 338,500 0 338,500
Subtotal 1,221,937 177,011 1,044,926
"""' Public Works:
Hopkins Creek Retention PW0309 2,530,730 906,914 1,623,816
Mayport Road Medians PW0401 400,000 0 400,000
Five Points Intersection Improvement PW0502 8,164 8,164 0
Pathways PW0606 81,500 66,917 14,583
Sidewalks - Sailfish,Royal Palm & Frances PW0607 5,102 0 5,102
~,,, Storage Bins for Limerock PW0701 30,000 0 30,000
Mandalay Park Improvements PW0702 50,000 0 50,000
Repave Asphalt at Public Works Yard PW0703 70,000 0 70,000
Asphalt Stewart Street at West Main Street PW0704 10,000 0 10,000
Sidewalk & Curb Replacement PW0705 50,000 6,400 43,600
Pedestrian Path -Five Points to Selva Marina PW0706 120,000 0 120,000
New Sidewalks -Marsh Oaks PW0707 120,000 0 120,000
'" Ocean Boulevard Between 14th & 15th Street PW0708 350,000 0 350,000
Subtotal 3,825,496 988,395 2,837,101
Total $6,064,783 $1,165,406 $4,899,377
Status Key
B -Bid Awarded E -Design Phase
~. C -Project Completed I -Project In-progress
D -Design Completed R - Re-budget Next Fis cal Year
E
I
E
E
D
C
I
I
E
AGENDA ITEM # 4A
FEBRUARY 26, 2007
Water Sales
Atlantic Beach
Buccaneer
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, f=1.
Water and Sewer Utility Sales Report
Janua 2007 January 2006
~,
Gallons Actual Revenue Gallons Actual Revenue
Accounts 0000 Revenue Per t,000 yi ' Accounts 0000 Revenue Per 1,000 yi I`
5,620 42,868 $106,951 $2.49' 5,564 39,222 $96,178 $2.45`
2,481 22,196 $64.114 $2.89'. 2.689 23.638 $60.872 52.58
Gallons Gallons
0000 0000
46,443 50,164
27,661 20,980
74,104 71,144
65,064 62,860
9,040 8,284
12.20% 11.64°k
11.17°k 9.86%
Gallons Actual Revenue Gallons Actual Revenue
Accounts 0000 Revenue Per 1,000 gi Accounts 0000 Revenue Per 1,000 gl
5,071 34,295 $157,450 $4.59 5,031 32,344 $149,107 $4.61
2,363 20.531 $122.236 $5.95 2.566 22.880 $123,223 $5.39
Sewer Treatment Gallons
0000 Actual
Revenue Revenue
Per 1,000 9i Gallons
0000 Actual
Revenue Revenue
Per 1,000 gi
Atlantic Beach
Buccaneer 47.004
22.643 $157,450
$122,236 $3.35.
$5.40': 50.090
17.956 $149,107
$123,223 $2.98
$6.86
Total Sewer Treated 69.647 $279,686 $4.02 68.046 $272,330 $4.00