Agenda Item 4AAGENDA
ITEM
#
4A
AUGUST
22,
2011
r
N
N
O
M
t
LO
r
O
r
r
Q
W
W
r
M
N
r
N
�
Ili
r
Z N
N
to
M
M
N
d
}}
O
N
O
C3
N
N
Q
Q
H
LL
Z
Z
Z
W _
_
w
Oct
000
O
a_
O
?°
Oct
o
0
0
Oct
a Q
O
--�
Q
a
J
Oct
O
~
z
0
d
T
H
H
M
r
0 C3
0
U (7
V
Z
Z
+�
to
���
w
co
de
ao
a F
x
v
d
M
Q
Q
Q
Q
Z J
W-i
N
p
w
2
v
ai
m
w
CL
a`
CO)
CO)
CO)
®
000000
o
0
0
0
o
O
0
W o
040
0
o
Co
O
O
O
Co
O
00
00
o0
0
0
0
0
0
CDP
CL
O
OhOh
d
r
O
J O
O
00
O
N
n
N
00
O
O
00�
tin
O®
A
O
O
O
V.-
��
W
O�
M
ti
to
O
M
N
r
M
CO
r
O
Q O
> O
O
tD
O
00
It
<D
Lf
M
O
to
to
M
M
d'
O
00
O
r
M
00
r
W
O
r
Ntf1
00
00
M
N
N
Z to
Nti
r
ti
X00
00
Cn
O N
tD
r
r
�"
O
r
N ER
ELY
r
Q
M
®
`
LL
N
N
=
V
Q a
®
N
t
� �
Z
��
eA
vw
to
�
J
W
O
400000
o
0
r
O
000400
Q
t00N
O
h
OOOOtt)
U)
t0
Z
O
Z
O OOMMOD
O
M
tp
M
M
W
'..�
/
c'^y
O
o
N
� hO N fti
N
N
r
O
O
O
RR
O
0
t f 1
0
O
0
00
0
O
0
00
0
O
0
O
0
t f 1
0
O
0
O
0
N
0
O
0
O
0
O
0
O
0
O
O
00
V/
^
Z
55
Q N
M
w
O
®�
Q N
�.
LL
L
O
N N
tf1Iq
r
r
r-
t`
t0
leQ0Nh.M000
M
O
w
4T
M
N
O
ppOtfltflOtfl
N
Iq
O
d'
N
Iq
N
N
tf1
Cl)
M
t0
Cl)
A
W
N
a
®
p t0
tp
'I
N
w
V
O
N
le
w
N
M
0
r
r
h
tf)
r
LL
�����
W
V N
M
to
N
r
r
N
C®
V
W
U
W
w
®
e
e
to
61)
6&
tro
W
60
61#
6&
6&
6&
t&
44
6&
ql�40
6&
6&
6&
Z
N
M
Cl)
LL
®
r
0
7
Cl)
�I
W
r
a
�
.�
w
t0
(L L
W tf)
d'
N
le
m
e
C14
N
r
Cl)
V)
N
h
CM
M
r
t`
r
O 0
a
r
W N cc
M
C14
cc
co
lei
Q
V)
co
O
Z
C3
N
M
r
r
Z
Q
Q
Z
O
O
QZ
"
O
Z~
O
40
CO)
U
W
}
O
Z
J
Q
z
O
�
t
Z
W
Z
-j
}
a
J
�
Oct
J
V
CO)
J JJ
O
W
W
O
a
j
r
Q
�V
QJ�VQV2
W
Cc
VC)U(�
o 0_V
F
LL
W
X
W�
O
w
LL
W�
dZR'V0'fA
W
W
W
H_
— zzzC7
�
Q
Q
Co
Z
0
H wy
J
d
W Zu' C �
F-
d
J�
z
W
Q
U)
J
Wp�W
JaOm
O�:F)2*�
V
==gtiD0
U
J
~ Z
Lu
C
z
n
w
o-
x
Zia
w
O
O
O
w
wou5oz
J
w
w
J
O —
W
w
W
U
W�
- §ZR
w�
08
R
� I
a
F)OWOO
v�zWP00aw2
, 2aW
§oWaomWL
AGENDA ITEM # 4A
AUGUST 22, 2011
City of Atlantic Beach, Fl.
Utility Sales Report
Wan w y
3
July 2011
July 2010
e y
Gallons Actual
Revenue
Gallons
Actual
Revenue
Water Sales
Accounts
0000 Revenue
Per 1,000 gi Accounts
0000
Revenue
Per 1,000 gi
Atlantic Beach
5,607
49,701 $183,797
$3.70 5,663
51,673
$187,825
$3.63
Buccaneer
1 2,469
20,666 $106,184
$5.14 2,442
21,012
$95,226
$4.53
Total Water Sales
8,076
70,367 $289,980
$4.12 8,105
72,685
$283,051
$3.89
Gallons
Gallons
Water Plant Production
0000
0000
Atlantic Beach
62,371
63,960
Buccaneer
17,638
y
19,736
E
Total Production
80,009
83,696
Total Water Billed
1
70,367
72,685
NA
Water Loss for month:
9,642
11,011
yr
'Percentage Loss
c
12.05%
K
EI
13.16%
K
Nd
Total 12 mo. Avg. Loss
NAM
14.98%
18.20%
C
z
v
i. az-
Gallons Actual
Revenue
Gallons
Actual
Revenue
Sewer Sales
rAccounts
0000 Revenue
Per 1,000 gi I Accounts
0000
Revenue
Per 1,000 gi `
Atlantic Beach
5,155
35,913 $261,079
$7.27 5,132
37,240
$245,615
$6.60-
Buccaneer
2,365
20,927 $190,847
$9.12 2,306
20,239
$169,545
$8.38
Total Sewer Sales
7,520
56,840 $451,926
$7.95 7,438
57,479
$415,160
$7.22
I
4
Gallons Actual
Revenue ;
Gallons
Actual
Revenue
3 Sewer Treatment
i
0000 Revenue
Per 1,000 gi
0000
Revenue
Per 1,000 g1
Atlantic Beach
48.232 $261,079
$5.41
45.946
$245,615
$5.35'
a Buccaneer
19.731 $190,847
$9.67
16.957
$169,545
$10.00
�Total Sewer Treated
67.963 $451,926
$6.65
62.903
$415,160
$6.60
a
# ;
City of Atlantic Beach
FINANCIAL REPORT
AGENDA ITEM # 4A
AUGUST 22, 2011
JULY 2011
Cash Balances
Total Restricted Cash $7,894,250
Total Unrestricted Cash $6,176,428
Cash and Investments
Prior Current Dollar
Account
Bank of America - Depository
Federal National Mortgage Association Bonds
US Treasury Notes
US Treasury Notes
Federal Farm Credit Bank Consolidated Bonds
Pimco Mutual Fund
Putnam US Government Mutual Fund
Eaton Vance Government Obligation Fund
MorganStanley SmithBarney AA Money Trust
SBA - Florida Prime
Cash on Hand
Subtotal
Interest
Rate
06/30/11 07/31/11 Change
$2,339,895
2,042,274
1,147,157
2,143,018
1,160,288
2,052,831
2,081,972
994,660
69,624
286
2,950
14,034,955
$2,195,951
0
1,171,443
2,206,566
1,148,496
2,098,716
2,096,980
999,055
2,150,239
282
2,950
14,070,678
($143,944)
(2,042,274)
24,286
63,548
(11,792)
45,885
15,008
4,395
2,080,615
(4)
0
35,723
Police Pension Investments 6,645,682 6,629,021 (16,661)
General Pension Investments 11,773,484 11,665,866 (107,618)
Subtotal 18,419,166 18,294,887 (124,279)
Total $32,454,121 $32,365,565 ($88,556)
0.300%
4.300%(l)
4.625%(1)
3.625%(l)
4.875%(l)
2.054%(1)
5.076%(1)
4.085%(l)
0.010%
0.210%
N/A
Rate of
Return
-1.20%(2)
-1.08%(2)
(1) Rate of return is 2.9% as of 07/31/11
(2) Rate of return as of 06/30/11
Prior
Current
Dollar
Fund(s)
06/30/11
07/31/11
Change
General
$6,155,308
$5,909,892
($245,416)
Tree Replacement
3,509
3,509
0
Convention Development Tax
138,102
158,971
20,869
Local Option Gas Tax
20,807
40,234
19,427
Better Jax 1/2 Cent Sales Tax
208,827
190,037
(18,790)
Police Training, Forfeiture, Grants, etc.
133,575
153,182
19,607
Community Development Block & ARRA Grants
(5,113)
(2,125)
2,988
Debt Service
54,853
60,657
5,804
Capital Projects
2,035,869
2,077,117
41,248
Utility
3,354,129
3,380,364
26,235
Sanitation
714,829
716,182
1,353
Building Code Enforcement
44,245
42,910
(1,335)
Storm Water
1,205,692
1,195,492
(10,200)
Pension - Police
8,573
3,291
(5,282)
Pension - General
91,861
119,288
27,427
Investments - Unallocated Gains (Losses)
(130,111)
21,677
151,788
Total
$14,034,955
$14,070,678
$35,723
Total Restricted Cash $7,894,250
Total Unrestricted Cash $6,176,428
Cash and Investments
Prior Current Dollar
Account
Bank of America - Depository
Federal National Mortgage Association Bonds
US Treasury Notes
US Treasury Notes
Federal Farm Credit Bank Consolidated Bonds
Pimco Mutual Fund
Putnam US Government Mutual Fund
Eaton Vance Government Obligation Fund
MorganStanley SmithBarney AA Money Trust
SBA - Florida Prime
Cash on Hand
Subtotal
Interest
Rate
06/30/11 07/31/11 Change
$2,339,895
2,042,274
1,147,157
2,143,018
1,160,288
2,052,831
2,081,972
994,660
69,624
286
2,950
14,034,955
$2,195,951
0
1,171,443
2,206,566
1,148,496
2,098,716
2,096,980
999,055
2,150,239
282
2,950
14,070,678
($143,944)
(2,042,274)
24,286
63,548
(11,792)
45,885
15,008
4,395
2,080,615
(4)
0
35,723
Police Pension Investments 6,645,682 6,629,021 (16,661)
General Pension Investments 11,773,484 11,665,866 (107,618)
Subtotal 18,419,166 18,294,887 (124,279)
Total $32,454,121 $32,365,565 ($88,556)
0.300%
4.300%(l)
4.625%(1)
3.625%(l)
4.875%(l)
2.054%(1)
5.076%(1)
4.085%(l)
0.010%
0.210%
N/A
Rate of
Return
-1.20%(2)
-1.08%(2)
(1) Rate of return is 2.9% as of 07/31/11
(2) Rate of return as of 06/30/11
City of Atlantic Beach
FINANCIAL REPORT
JULY 2011
Revenues
AGENDA ITEM # 4A
AUGUST 22, 2011
Annual YTD - 83% YTD Dollar Percent
Fund / (Footnote) Estimate of Estimate Actual Variance Variance
General (1) & (3)
$11,515,549
$9,592,452
$10,268,445
$675,993
7.05%
Convention Development Tax
264,857
220,626
148,880
(71,746)
- 32.52%
Local Option Gas Tax
463,523
386,115
376,894
(9,221)
-2.39%
Better Jax 1/2 Ct Sales Tax
658,424
548,467
526,369
(22,098)
-4.03%
Police Training, Forfeiture & Grants, etc.
185,917
154,869
245,581
90,712
58.57%
Grants (2)
647,352
539,244
37,668
(501,576)
- 93.01%
Debt Service
68,650
57,185
57,791
606
1.06%
Capital Projects
903,000
752,199
798,469
46,270
6.15%
Utility (3)
19,061,825
15,878,501
9,582,891
(6,295,610)
- 39.65%
Sanitation
1,837,500
1,530,638
1,506,975
(23,663)
-1.55%
Building Code Enforcement
317,850
264,769
246,787
(17,982)
-6.79%
Storm Water
669,124
557,380
571,856
14,476
2.60%
Pension - Police (4)
964,726
803,617
1,001,362
197,745
24.61%
Pension - General (4)
1,522,969
1 1,268,633
1,961,254
692,621
54.60%
Total
$39,081,266
$32,554,695
$2 7,331,222
($5,223,473)
Analysis of Major Variances
(1) The $675,993 positive variance in the General Fund resulted from having received
99.8% of the budgeted property taxes. Typically the majority of these taxes are received
from the City of Jacksonville in December & January. Also, the TMDL related transfer of
$892,560 from the Utility System Debt Service Fund was done due to the receipt of loan
proceeds.
(2) The $501,576 negative variance in the Grant Funds resulted from having expended
2.4% of the budgeted fiscal year to date amounts. All of these grants receive revenues
when the related expenditures are made on the projects and a reimbursement request is
filed with the granting agency.
(3) The $6,295,610 negative variance in the Utility Funds resulted from not having received
the budgeted fiscal year to date proceeds from the Bank - Qualified Loan. Partial receipt
of the loan proceeds was received in December, 2010. The City will receive additional
loan proceeds as needed when the related expenditures are made on the project. If the
loan was not included in this calculation, the variance would be a positive 12.4 %.
(4) The $197,745 positive variance in the Police Employee Pension Fund & the $692,621
positive variance in the General Employee Pension Fund resulted from changes in the
market values of the investments & realized gains from the sales of investments fiscal
year to date.
City of Atlantic Beach AGENDA ITEM It 4A
FINANCIAL REPORT AUGUST22,20II
JULY 2011
Expenses
Department / (Footnote)
Governing Body
City Administration
General Government
Planning and Building
Public Safety
Recreation and Special Events
Public Works (1) & (3)
Public Utilities (2) & (3)
Pension - Police
Pension - General
Total
Resource Allocation
Personal Services (1) & (2)
Operating Expenses (1) - (3)
Capital Outlay (1) & (2)
Debt Service
Transfers
Total
Annual
Estimate
YTD - 83%
of Estimate
YTD
Actual
Dollar
Variance
Percent
Variance
$42,260
$35,203
$33,405
$1,798
5.11%
2,522,102
2,100,911
2,021,043
79,868
3.80%
986,780
821,987
491,556
330,431
40.20%
531,131
442,432
389,208
53,224
12.03%
6,105,153
5,085,591
4,724,072
361,519
7.11%
392,160
326,669
317,170
9,499
2.91%
6,751,017
5,623,596
4,786,459
837,137
14.89%
19,695,451
16,406,313
11,045,337
5,360,976
32.68%
548,977
457,298
500,463
(43,165)
-9.44%
555,445
462,686
593,905
(131,219)
- 28.36%
$38,130,476
$31,762,686
$24,902,618
$6,860,068
Annual
Estimate
YTD - 83%
of Estimate
YTD
Actual
Dollar
Variance
Percent
Variance
$9,406,095
$7,835,277
$7,513,811
$321,466
4.10%
10,153,687
8,458,021
7,752,518
705,503
8.34%
13,982,281
11,647,240
5,741,215
5,906,025
50.71%
2,137,906
1,780,876
1,704,224
76,652
4.30%
2,450,507
2,041,272
2,190,850
(149,578)
-7.33%
$38,130,476
$31,762,686
$24,902,618
$6,860,068
Analysis of Major Variances
(1) The positive variance in the Public Works department resulted from: only 9 of 10
monthly payments have been paid on the Advanced Disposal Services contract; retiring
employees positions being vacant until replaced with employees at a lower salary; only
33.4% of the budget for the Stormwater Master Plan has been expended and limited
activity on the various Parks projects funded from this source — see Project Activity
Schedule.
(2) The positive variance in the Public Utilities department resulted from retiring employees
positions being vacant until replaced with employees at a lower salary and limited activity
on the various projects funded from this source — see Project Activity Schedule.
(3) The positive variance in the Operating Expenses is partially due to 57% of the budget
for repair & maintenance and 63% of the budget for professional & contractual services
has been spent City wide.
City of Atlantic Beach
FINANCIAL REPORT
JULY 2011
Project Activity - Current Year Activity Only
AGENDA ITEM # 4A
AUGUST 22, 2011
Project Name
Project
Number
Budget
YTD
Actual
YTD
Balance
Status
Public Safety
X - Project Cancelled
E - Design Phase
Lifeguard Building Roof Replacement
LG0901
8,000
0
8,000
Police Building Renovation /Design /Construction
PS0504
431,491
313,948
117,543
E
439,491
313,948
125,543
Public Utilities:
Replace Well at Water Plant #1
PUO304
287,018
212,550
74,468
1
TMDL - WWTP #1 Design
PU0905
91,205
91,204
1
C
TMDL - Lift Station /Main Transfer Flow
PU0906
1,708,709
1,504,185
204,524
1
Ground Storage Tank Rehab - Water Plant #1
PU1002
44,340
44,340
0
C
Collection System Inspection & Rehab
PU1004
27,788
27,789
(1)
C
Mimosa Cove Lift Station Upgrades
PU1005
61,498
61,498
0
C
Lift Station E Upgrades
PU1006
48,183
48,183
0
C
Well Rehab - Well # 1 @ Water Plant #1
PU 1101
51,026
0
51,026
1
Elevated Tank Rehab - Water Plant #2
PU1102
13,974
0
13,974
I
Ground Storage Tank Rehab - Water Plant #4
PU1103
40,000
0
40,000
I
Replace 2" Water Main -11th Street
PU1104
120,000
3,814
116,186
E
Sewer Rehab - Sea Oats Drive
PU1105
300,000
286,727
13,273
C
TMDL Upgrade/Construction - WWTP #1
PU1106
5,694,730
1,885,333
3,809,397
1
Valve Replacement - Davco & Clarifier
PU1107
0
0
0
X
Replace Equipment - PW Yard Station
PU1108
40,000
17,611
22,389
1
Plant Improvements - Master Plan
PU1109
75,753
0
75,753
TMDL Sludge /Odor Improvements
PU1110
2,656,914
166,318
2,490,596
1
Subtotal
11,261,138
4,349,552
6,911,586
Public Works:
Riverbranch Preserve - Kayak & Canoe Launch
PM0804
268,306
7,319
260,987
E
Howell Park Bridge Replacement
PM1001
20,000
0
20,000
Veteran's Park - Flag & Pavilion
PM 1006
72,063
71,643
420
C
Dog Park - Hopkins Creek
PM1008
27,800
26,448
1,352
C
Gate at Dutton Island
PM1101
20,000
0
20,000
1
Lighting - Basketball Court
PM1102
11,466
11,465
1
C
Lighting - Security at Community Center
PM1103
1,400
1,392
8
C
Sod - Baseball Field
PM1104
45,534
0
45,534
1
Sod - South End of Soccer Field
PM1105
17,000
0
17,000
1
Parking - Paved
PM1106
50,263
0
50,263
Water Fountain - Russell Park
PM1107
5,000
0
5,000
Veteran's Park- Phase II - Stage
PM1108
50,000
41,634
8,366
C
Security Camera - Donner Park
PM1109
5,500
4,380
1,120
C
Veteran's Park - Phase II - Memorial Garden
PM 1110
0
0
0
1
Royal Palms Design
PW0808
3,294
3,294
0
D
Royal Palms Stormwater Project
PW0905
507,129
507,129
0
C
Bulkhead - Ditch @ Cavalla
PW1005
9,472
9,472
0
C
Sidewalk & Curb Replacement
PW1101
25,000
14,734
10,266
1
Drain Line - Atlantic Blvd /East Coast Dr /Ahern St
PW1102
50,000
0
50,000
Subtotal
1,189,227
698,910
490,317
Total
$12,889,856
$5,362,410
$7,527,446
Status Key
A - Bid Advertised
I - Project In- progress
B - Bid Awarded
N - Complete /Non - Capital
C - Project Completed
R - Re- budget Next Fiscal Year
D - Design Completed
X - Project Cancelled
E - Design Phase
AGENDA ITEM # 4A
AUGUST 22, 201 I
C
.O
O
o 0 tb 0
O O
M rri p
y
b 0' O
Ej
0 0 cl
O
y •� ^Q
a p
o o 5. .o
-d
1 u 0
y
cd U b O rn 4a
W
U O O 0
z
cd O U >~ x O
A
O a
W
O O •p" O p
O
N O rr
U , O
d
�U
~ pU
b
z
o O
cu 0 U
W
y 4a
H d
¢^
p O �
a[yi
U on o C, O V N
U
pQ
a U
U O
cn
0
z
II
O
U
a cn
V
H
c0a V
r. }�-' 1V
N O bbo
0 U
cn
o
^
O
on >~
En —
o
En�
II
I�
W
Ez
U
a
o p
�U^d W
II II 4 d
II II
I ^I ^W
II II 4 d
F"
Q ✓U U
QUU
OU U
Qu
Qu
a
�
z
o
w
z
• o '� II •� II .o � p
a II o
p II
o
a
�
a,
U
C7
w�o�UO
cn
.o
a • o
o r .o
��
z
Q
cd
W � � •� .
� v
� II v
F4 II v
y II
�
�
u
Q �
AGENDA ITEM # 4A
AUGUST 22, 2011
�
�
m
a�
o
°
rl
a
W
C
cd
V
r7
rr
pp
O o r
a
N
N
oo
.4
rl
r
o
gi o
0
op
o
z
Z
bo
o�
O
rn
a��i
w
eo
y
.4 V
� C
C M
Cq
A,
� CN
U oU
U
U
U.�
U ccd
V.�
U o
ao
0
Aa u
� � n
U
r� r F F
�v a
U
►•� ►•�
a aa'
z
w
a
w
C1UU
U
U
C1VU
sUV
a�
O
o
•�
ce
W
r �
ce
`O
ce
ce
A m
lz u
0
o b
b o
w
\ II
o
a
'+�
ob
o
- d
ce
o
--"
b
y
N
= U
F
�.
b
C7 v
0. (n
a
b
a�
a an
y
a�
z8
Ui U
C7
H o
a
tea'°
u
�
�
o
..