Item 4ACity of Atlantic Beach AAUG~UST24M~A
FINANCIAL REPORT
JULY 2009
Cash Balances
Fund(s)
General
Community Development Block Grant
Tree Replacement
Convention Development Tax
Local Option Gas Tax
Better Jax 1/2 Cent Sales Tax
Police Training, Forfeit, etc.
Debt Service
Capital Projects
Utility
Sanitation
Building Code Enforcement
Storm Water
Pension -Police
Pension -General
Total
Total Restricted Cash
Total Unrestricted Cash
Prior Current Dollar
06/30/09 07/31/09 Change
$5,610,192
0
14,822
13,689
273,147
715,590
211,120
57,432
576,479
2,958,377
376,119
88,129
3,835,950
35,176
59,915
$14,826,137
$4,916,149
(49,775)
14,822
21,973
290,294
711,169
211,909
63,165
599,481
3,129,009
508,800
74,253
3,946,973
25,813
89,605
$14,553,640
($694,043)
(49, 775)
0
8,284
17,147
(4,421)
789
5,733
23,002
170,632
132,681
(13,876)
111,023
(9,363)
29,690
($272,497)
$7,320,686
$7,232,954
Cash and Investments
Account
Prior
06/30/09
Bank of America -Depository $6,788,620
Bank ofAmerica -Certificate of Deposit 6,026,247
5th 3rd Bank -Certificate of Deposit 2,007,095
SBA 1,275
Cash on Hand 2,900
Subtotal 14,826,137
Police Pension Investments 4,892,884
General Pension Investments 8,078,231
Subtotal 12,971,115
Total $27,797,252
Current Dollar Rate of
07/31/09 Change Return
$6,506,913
6,032,653
2,009,915
1,259
2,900
14,553,640
5,169,980
8,551,627
13,721,607
($281,707) 0.30
6,406 1.24
2,820 1.66
(16) 0.47
0 N/A
(272,497)
277,096 7.95 (1)
473,396 8.27 (1)
750,492
$28,275,247 $477,995
(1) FYTD rate of return through 06/30/09
City of Atlantic Beach
FINANCIAL REPORT
JULY 2009
Revenues
AGENDA ITEM # 4A
AUGUST 24, 2009
Annual I YTD - 83% YTD Dollar Percent
Fund / (Footnote) Estimate of Estimate Actual Variance Variance
General (1) $10,391,868 $8,656,426 $9,340,386 $683,960 7.90%
Tree Replacement 0 0 4,914 4,914 100.00%
Convention Development Tax 85,000 70,805 53,698 (17,107) -24.16%
Local Option Gas Tax 496,872 413,894 381,264 (32,630) -7.88%
Better Jax 1 /2 Cent Sales Tax 638,188 531,611 531,978 367 0.07%
Police Training, Forfeit, etc. 40,150 33,446 28,291 (5,155) -15.41
Grants 214,284 178,499 69,378 (109,121) -61.13%
Debt Service 69,500 57,894 57,223 (671) -1.16%
Capital Projects 335,000 279,055 276,019 (3,036) -1.09%
Utility (2) 9,398,075 7,828,596 6,101,281 (1,727,315) -22.06%
Sanitation 1,872,500 1,559,793 1,628,451 68,658 4.40%
Building Code Enforcement 207,500 172,848 171,796 (1,052) -0.61
Storm Water (3) 2,374,600 1,978,042 2,568,415 590,373 29.85%
Pension -Police (4) 812,280 676,629 402,185 (274,444) -40.56%
Pension -General (4) 1,320,428 1,099,917 885,348 214,569 -19.51
Total $28,256,245 $23,537,455. $22,500,627 ($1,036,828)
Analysis of Major Variances
(1) The $683,960 positive variance in the General Fund resulted from having received 99%
of the budgeted amount of property taxes. Typically the majority of these taxes are
received from the City of Jacksonville in December & January.
(2) The $1,727,315 negative variance in the Utility Funds resulted from charges for services
$251,692 below projected year to date amounts and not having transferred the budgeted
amounts of $1,445,256 from the General Fund. These transfers will be executed as the
work progresses on the well replacement & TMDL projects.
(3) The $590,373 positive variance in the Stormwater Fund resulted from having received
the Florida Department of Environmental Protection grant monies in this fiscal year.
These revenues were budgeted & recognized in the prior fiscal year.
(4) The $274,444 negative variance in the Police Employee Pension Fund & the $214,659
negative variance in the General Employee Pension Fund resulted from changes in
market values of the investments.
City of Atlantic Beach
FINANCIAL REPORT
JULY 2009
AGENDA ITEM tt 4A
AUGUST 24, 2009
Expenses
Department / (Footnote)
Governing Body
City Administration
General Government (1)
Planning and Building
Public Safety (2)
Recreation and Special Events
Public Works (3)
Public Utilities (1)
Pension -Police
Pension -General
Total
Annual YTD - 83% YTD Dollar Percent
Estimate of Estimate Actual Variance Variance
$48,076 $40,047 $34,621 $5,426 13.55%
2,645,981 2,204,102 2,069,952 134,150 6.09%
4,101,465 3,416,520 2,011,741 1,404,779 41.12%
565,974 471,457 432,422 39,035 8.28%
6,019,866 5,014,548 4,012,681 1,001,867 19.98%
455,619 379,531 346,467 33,064 8.71%
9,862,108 8,215,138 4,887,383 3,327,755 40.51%
9,389,931 7,821,812 6,384,239 1,437,573 18.38%
451,236 375,880 412,492 (36,612) -9.74%
485,152 404,132 411,768 (7,636) -1.89%
$34,025,408 $28,343,167 $21,003,766 $7,339,401
Annual YTD - 83% YTD Dollar Percent
Resource Allocation Estimate of Estimate Actual Variance Variance
Personal Services (2)
Operating Expenses (2) & (3)
Capital Outlay (1), (2) & (3)
Debt Service (4)
Transfers (1)
Total
$9,275,843 $7,726,777 $7,424,633 $302,144 3.91%
10,347,645 8,619,591 7,473,631 1,145,960 13.29%
8,187,913 6,820,532 2,092,809 4,727,723 69.32%
1,681,207 1,400,445 1,680,416 (279,971) -19.99%
4,532,800 3,775,822 2,332,277 1,443,545 38.23%
$34,025,408 $28,343,167 $21,003,766 $7,339,401
Analysis of Major Variances
(1) The positive variance in the General Government and Transfers resulted from not
having transferred the budgeted amounts to date from the General Fund to the Public
Utilities departments. These transfers will be executed as the work progresses on .the
well replacement & TMDL projects in the Public Utilities departments -see Project
Activity Schedule.
(2) The positive variance in the Public Safety departments is due to the budget increase for
the employment settlement agreement to be paid in August; the payment being due
quarterly to the City of Jacksonville for fire & rescue services (three payments have been
expensed fiscal year to date); and the Police Building project has had limited activity -
see Project Activity Schedule.
(3) The positive variance in the Public Works departments resulted from only 9 of 10
monthly payments have been paid on the Advanced Disposal Services Jax LLC contract,
only 49% of the budget for paving has been spent in the Local Option Gas Tax Fund, the
projects for the renovation of the City Parks have had limited activity and the Royal Palms
Stormwater project has not started -see Project Activity Schedule.
(4) The negative variance in the Debt Service accounts is due to the payment on interest
and principal on 10/01/08 and 12/01/08 and the payment of interest only on 04/01/09
according to the amortization schedule. The variance is projected to be zero at fiscal year
end.
City of Atlantic Beach
FINANCIAL REPORT
JULY 2009
AGENDA ITEM # 4A
AUGUST 24, 2009
Project Activity -Current Year Activity Only
Project YTD YTD YTD
Project Name Number Budget Actual Balance Status
Public Safety
Police Building Renovation/Design/Construction PS0504 660,000 9,475 650,525
Public Utilities:
Replace Well #2 at Water Plant #1 PU0304 800,000 5,325 794,675
TMDL Engineering PU0706 84,005 84,005 0
SCADA Improvements PU0801 14,000 14,000 0
Collection System Inspection & Rehabilitation PU0802 183,939 183,938 1
Reclaimed Water Plant Construction PU0805 150,276 0 150,276
Collection System Rehabilitation PU0901 349,597 349,593 4
Check Valve -Water Plant #1 PU0902 30,000 20,325 9,675
Concrete to GRIT Container PU0903 18,708 18,428 280
New Well PU0904 0 0 0
Design TDML PU0905 710,000 86,201 623,799
TMDL -Lift Station Transfer Flow PU0906 390,000 45,919 344,081
Generator -Mimosa Cove Lift Station PU0907 40,000 0 40,000
Subtotal 2,770,525 807,734 1,962,791
Public Works:
Buckman Trust Property PM0804 191,000 190,410 590
Statue-Turtle PM0805 73,307 61,444 11,863
Cabinets for Donner PM0901 0 0 0
Gate at Dutton Island PM0902 0 0 0
Park Playground PM0903 45,000 42,109 2,891
Tennis Courts/Improvements/DonnerPark PM0905 147,000 55,305 91,695
Howell Park Bridge PM0906 15,000 14,850 150
Dune Crossover - 3rd Street Extnsion PM0907 7,075 7,075 0
Hopkins Creek Retention PW0309 1,110 1,110 0
Mayport Road Medians PW0401 156,428 73,477 82,951
Pedestrian Path Extensions PW0802 0 0 0
Sidewalks -George & Edgar Streets PW0803 51,732 39,508 12,224
Ardella Road Drainage Project PW0807 33,753 33,904 (151)
Royal Palms Design PW0808 400,000 285,983 114,017
Sidewalk/Pedestrian Path PW0901 0 0 0
Sidewalk & Curb PW0904 45,000 41,347 3,653
Royal Palms Stormwater Project PW0905 3,080,000 0 3,080,000
Subtotal 4,246,405 846,522 3,399,883
Total $7,676,930 $1,663,731 $6,013,199
Status Key
B -Bid Awarded I -Project In-progress
C -Project Completed N -Complete/Non-Capital
D -Design Completed R - Re-budget Next Fiscal Year
E -Design Phase X -Project Cancelled
E
AGENDA ITEM # 4A
AUGUST 24, 2009
City of Atlantic Beach, FI.
Utility Sales Report
July 2009 July 2008
Water Sales
Accounts Gallons
0000 Actual
Revenue Revenue
Per 1,000 gi
Accounts Gallons
0000 Actual
Revenue Revenue
Per 7,000 gi
Atlantic Beach
Buccaneer 5,615
2,494 43,202
21,532 $137,132
$77,889 $3.17
$3.62 5,631
2,490 50,102
21,047 $141,450
$67,070 $2.82
$3.19
Total Water Sales 8.109 64.734 5215.021 53.32 8.91 77 9dQ S9f1R ~~n c~ oz
Water Plant Production Gallons
o000
Atlantic Beach 53,322
Buccaneer 19,892
Total Production 73,214
Total Water Billed 64,734
Water Loss for month: 8,480
Percentage Loss 11.58%
Total 12 mo. Avg. Loss 12.59%
Gallons Actual Revenue
Sewer Sales Accounts 0000 Revenue Per 1.000 al
Atlantic Beach 5,148 34,996 $205,596 $5.87
Buccaneer 2,367 20,006 $152,330 $7.61
Total Sewer Sales 7,515 55,002 $357,926 $6.51
Gallons Actual Revenue
Sewer Treatment OOOO Revenue Per 1,000 9i
Atlantic Beach 54.933 $205,596 $3.74
Buccaneer 18.890 $152,330 $8.06
Total Sewer Treated 73.823 $357,928 $4.85
Gallons
0000
57,475
19,131
76,606
71,149
5,457
7.12%
12.83%
Gallons Actual Revenue
Accounts 0000 Revenue Per 1,000 gl
5,131 37,537 $190,965 $5.09
2,366 19,977 $131,382 $6.58
7.497 57.514 5322.347 55.60
Gallons Actual Revenue
0000 Revenue Per 1,000 g~
40.895 $190, 965 $4.67
21.308 $131,382 $6.17
62.203 $322,347 $5.18
A GE ND A I'
AU GU ST
~ L I
- - - - __ - - -... _ _ __
~
- _.
o
d1 N
r ^
~ O
N
OO
Of
~
j O^ N 0 r tr M M 0 N
} ~
V
W
__ W
N
Z - _.. ~ -
Z -- _ J _- -- --
O
J ~
O ~
Z
^
j O N ~ W V' V Z Z ~ ~
~~
r
az
z
~
~
m
a
~
3 ~
-
° c
.> ~ ~ ci a a ~
~ ~ - m w a ~ ~ a
a 0
o _
~ 0 0
O 0 0
O
~ _
~~
~
o
o
.
,
.
,
,
o
o
.
.
,
.
.
.
,
,
o
.
W ~ N
~ $ M
~ Y
Y
~ ~ ~
a 1~ ~
N Q
t0 ~
1A o
N
p~
~
~
ti
o
~
Z~
~
N
~ N
~
C N N .- m ~ O
~ ~ N ~ N V
j
C ~
H J ~
N ' Z
v a ~
~ ~; r~
~
~
' 0
0 0
0 0
0 0
0 0
0 O
O =
~ __ _
= z o ~ o
O o
O ~
M ~
N ~
ti o
ti z
O O
O O~ O r OO ~ O
Z '/~
~ 'n N~ O ~ 000 0 N
o Z ~ 0
a
z ~ W o
o
. O
~,
C o
O
b
. 0
o
. 0
o 0
O 0
O
~,
. 0
o 0
o 0
o 0
o 0
o
.
, O
~,
~
~
~
(
n
~ F Clf
N N
00
M O
1~ C
1~ ~
M O>
~ N
~A It~
O G
M O
M ti
0 er
r ti
N
~ O V) V N 1 0
0 N
`
r //
fi~
Y. K-
- V! //! iR ~ V} ~ r r r
W V ~ a -- - ~
a
. ~
~ I 0 ~ a
~
•
V
-
-
- LL! fR Ni M Ni /R Yi /R V~ M iR iA M /A iA M HI VI iA N W
z~ i
~,
o
_
-
a
-- --
-
__
_
_-
-
- __
___
_
-
--
---
0~ N
~ ~ ~ ~ ~~ ~ ~
~~
-- -
m W - W ~ O N M O N N N ~ M ~ 0 ~ 10 N N M O O M 0
Oo a
~° N I Z
mo ~ ~- ~ ~
j ~~
Z
a
W
z O ~
O O ~ z
a ~ o
^
Q }
J W
? O
^
J ~
w z
O ~
~ ~
N ~~
9~
a
j
v
a
o
=
a a
_
z
v ~
w J
a J
a
V ~
z ~
o
E- LL X w ~ u.
W
W W
^ ~
W o
fn
W
F a
~A a
W ~
z
M
C
9
N v
~ Z
OO
a
2 ~
a ~'
~~
~ J
U' J
a O
~ ~
~ W
2 „
j
~ d ~ ~ (Yj Z J Z ? O W g
¢ J Z F
-
W ~ V ~ ~ C7
Z W;
' Lll
a Z
w ~
^ W
~ O
c~ F-
0 Z
v ^ W O W W H W W 0 2 a W ~ .J J W p ~ ^ ~~
~ ^ ~ c~ ^ w ~ ~ uc ar ~n c9 3 v~ w a ~ a ~ v~ f-~