Agenda Item 4AAGENDA
ITEM
# 4A
DECEMBER
12,
2011
r
a
0
0
M
E
co
to
le
M
N
fn
O 0
O
LL
Q
Q
w
W
W
w
z
? O
z
0
J
O
p
0
v
v
n
J
N
O
H N
V (7
V
Z
U
r
r
0
t"1
w z
_
?
V
N
W
0
N
0
N
J
J
W
p
--
mwa
a
z
O
o °O O
° oo
o
° o
w ° o
°
O
°,
°
° o
° o
o
° o
°
o
IL
r
oole
o�IoIR
ot0�
�
w M
t;
a
t;
O
t;4
°
°
o
W
r
w
t0
M
t0
N
W
o
> O
0
N
0
t0
I�
t0
0o
O
n
r
d
O
N
r n
ro
MNM
noor>
n
co
Z N
r
M
N
a)
co
O
14
O N
N to
ti
6
co
tt
r
W
O
W
O
m
Z
H
r
r
L
` >
r
W
>
0
z
Q
N
V
Q
a
Z
��
O
O
O
O
O
Lu
LL
O
O
I.L.
O
O
C
O
N
O>
OoONOO
O
Ld
tV
tD
r
..j
Z
O
=
Z
(O
OOOtV
V " N
0
LO
0
r
0)
tAM
N
r
0
co
N
O
W
O
N
N N
v
r
O
O
O
Z co
V/
v
et
�
—
-
-
O 1■L,
�/
N
}
N
LL.
O
O
O
O
0
N0000
0
0
0
0
0
�O�DO
N
0
0
O
O
00
O
O
O
O
O
00
O
O
LO
O
IT
N
n
t000
O
O
r
nn t0 0o 0
N
00
r
WO
CO)
U)
Oto
IT
pp
r
N
M
a=
0.
O
fw
Mt0
coNN0ot"M
rW
■
C
G
ER
t/}
tR
tR
40
tH
U r
r
r
t7
r
r
ago
w
LL
N
w
a
v,
to
es
t
to
t�
tR
to
to
0).
4&
to
O
r
Z
0.
W �/
~ o
M
O
CO)
n
c co
LL
�I
}
a
w
a
X0 0000
0404
c
V-MN
OOrOOr
000
r1
P-
m
LL
0O
W
a
r
z
co)
rr
O
z
0
O
O
O
~
LL
O
zz
~
oW
V
=
J
<>
LLav
d
_J
O
J
J�QJQJV
(9
0
z
W z w
Qa
WQQJQ�JQQ
�H V Q V �V V VC7
0z � z (.)
aOVw
W
LL
N�
}
Q
� V
Q-
le
H
LL
w
x
W
W
ow
u'=
W
W
W12W
W
fn
IF"
—
�zle(j
— zzKo
~ 22
QQmZ
t =W
JaF-
a
�
J
U)
w
C9
J
00.22m
JO
OH5222�WC�c>aOz2Kwoz
LLOO�
to
W
H
zJ
W
z
n
w
O
H
z
W
W
0
0
0
W
J
W
W
J
O—
W
W
w
o
w—
W
W
4
rnawoo
wzw(
uumw22mR
§owaOav)LLowcn5
AGENDA ITEM # 4A
DECEMBER 12, 2011
City of Atlantic Beach, Fl.
Utility Sales Report
_. gg mr_ , , _,_.. a _, __
,.r
Novembe 2011
November
er
Gallons Actual Revenue Gallons Actual Revenue
Water Sales
Accounts
0000 Revenue
Per 1,000 gl ` Accounts
0000
Revenue
Per 1,000 gi
Atlantic Beach
5,581
38,654 $144,364
$3.73 5,598
42,348
$158,918
$3.75
Buccaneer
2,458
18,483 $102,247
$553 2,469
16,670
$85,424
$512
Total Water Sales
8,039
57,137 $246,612
$4.32 8,067
59,018
$244,342
$4.14
r
a
�
r _ r
Gallons
Gall
Water Plant Production
0000
0000
Atlantic Beach
47,043
49,727
N
Buccaneer
20,753
18,091
Total Production
67,796
67,818
Total Water Billed
57,137
59,018
MR
Water Loss for month:
10,659
8,800
Percentage Loss
15.72%
12.98%
Total 12 mo. Avg. Loss
17.40%
15.81%
Gallons Actual Revenue
Gallons
Actual
Revenue
Sewer Sales
Accounts
0000 Revenue
Per 1, gi -Accounts
0000
Revenue
Per 1, 000 g1
Atlantic Beach
5,143
30,870 $235,261
$7.62 5,126
31,650
$239,910
$7.58
$9.59
Buccaneer
2,354
18,188 $175,246
$9.64 2,334
18,182
$174,412
Total Sewer Sales
7,497
49,058 $410,507
$8.37 7,460
49,832
$414,322
$8.31
O ffla
Gallons Actual
Revenue
Gallons
Actual
Revenue 0
Sewer Treatment
0000 Revenue
Per 1, 000 gi q
0000
Revenue
Per 1 , 000 gi :
Atlantic Beach
43.336 $235,261
$5,431-
43.046
$239,910
$5.57
$981
Buccaneer
18.452 $175,246
$9.50
17.775
$174,412
Total Sewer Treated
61.788 $410,507
$6.640
60.821
$ 414,322
$6.81
K
�
AGENDA ITEM # 4A
DECEMBER 12, 20I 1
qsysprt
PREPARED 12/05/11,10:56:18 LICENSE ACTIVITY REPORT BY BUSINESS NAME
City of Atlantic Beach NEW LICENSES FOR YEAR: 2012 BETWEEN: 11/01/11 TO 11/30/11
PROGRAM OL122L DEPT: ALL DEPARTMENTS CLASS: ALL CLASSES
----------------------------------------------------------------------------------------------
LIC # BUSINESS NAME ISSUED TYPE CLASSIFICATION
BUSINESS ADDRESS
---------------------------------------------------------------------------------------- - - - - --
12- 00007473 BLUE RIBBON COURTESIES, LLC
2051 VELA NORTE CIR
ATLANTIC BEACH FL 32233
12- 00007472 D &K REPAIRS, INC.
1420 MAYPORT RD
ATLANTIC BEACH FL 32233
12- 00007471 EDWARD D JONES INVESTMENT
OUTSIDE CITY
ATLANTIC BEACH FL 32233
12- 00007470 KROOZER CUPS USA, LLC
901 OCEAN BLVD UNIT 047
ATLANTIC BEACH FL 32233
12- 00007474 MSHACK
299 ATLANTIC BLVD
ATLANTIC BEACH FL 32233
12- 00007460 THE UNITED STATES LIFE INS.
OUTSIDE CITY
ATLANTIC BEACH FL 32233
11/22/11 NEW MISC. SERVICE ESTABLISHMENT, NOT LIS
11/29/11 NEW MISC. SERVICE ESTABLISHMENT, NOT LIS
11/02/11 NEW SOLICITATION, DOOR TO DOOR
11/01/11 NEW MISCELLANEOUS SALES, OTHER THAN LIST
11/23/11 NEW RESTAURANTS(INC. SNACK BARS & TAKE 0
CO 11/29/11 NEW INSURANCE COMPANY
------------------------------------------
GRAND TOTALS
-------- - - - - --
NEW LICENSES ------- - - - - --
AC:
6
PP:
0
IN:
0
V0:
0
PG:
0
BR:
0
OB:
0
UC:
0
LIC:
6
Page 1
City of Atlantic Beach
FINANCIAL REPORT
OCTOBER 2011
Prior Current
09/30/11 10/31/11
Cash Balances
Total Restricted Cash $7,789,642
Total Unrestricted Cash $6,161,946
Cash and Investments
Account
Bank of America - Depository
Pimco GNMA Fund
Putnam US Government Income Fund
Eaton Vance Government Obligation Fund
Loomis Sayles Limited Term Government & Agency Fund
Delaware Corporate Bond Fund
Loomis Sayles Investment Grade Bond Fund
Lord Abbett Income Fund
MorganStanley SmithBarney AA Money Trust
SBA - Florida Prime
Cash on Hand
Subtotal
Police Pension Investments
General Pension Investments
$11,385,072
1,071,820
1,066,569
1,008,204
998,362
0
0
0
0
277
2,950
15,533,254
$3,740,153
1,074,697
1,069,971
2,009,887
1,001,853
2,020,236
1,010,586
2,020,979
0
277
2,950
13,951,588
AGENDA ITEM # 4A
DECEMBER 12, 2011
Dollar Interest
Change Rate
($7,644,918)
Prior
Current
Dollar
Fund(s)
09/30/11
10/31/11
Change
General
$5,234,897
$5,085,407
($149,489)
Tree Replacement
3,509
3,509
0
Convention Development Tax
50,225
(13,880)
(64,105)
Local Option Gas Tax
75,012
93,290
18,279
Better Jax 1/2 Cent Sales Tax
167,095
153,619
(13,476)
Police Training, Forfeiture, Grants, etc.
166,105
162,547
(3,558)
Community Development Block & ARRA Grants
0
(6,318)
(6,318)
Debt Service
72,585
78,851
6,267
Capital Projects
2,215,475
2,252,997
37,523
Utility
5,597,241
4,306,688
(1,290,553)
Sanitation
661,643
669,870
8,228
Building Code Enforcement
54,991
40,338
(14,653)
Storm Water
1,193,226
1,039,838
(153,388)
Pension - Police
27,365
28,322
958
Pension - General
13,888
56,746
42,858
Investments - Unallocated Gains (Losses)
0
(236)
(236)
Total $15,533,254
$13,951,588
($1,581,666)
Total Restricted Cash $7,789,642
Total Unrestricted Cash $6,161,946
Cash and Investments
Account
Bank of America - Depository
Pimco GNMA Fund
Putnam US Government Income Fund
Eaton Vance Government Obligation Fund
Loomis Sayles Limited Term Government & Agency Fund
Delaware Corporate Bond Fund
Loomis Sayles Investment Grade Bond Fund
Lord Abbett Income Fund
MorganStanley SmithBarney AA Money Trust
SBA - Florida Prime
Cash on Hand
Subtotal
Police Pension Investments
General Pension Investments
$11,385,072
1,071,820
1,066,569
1,008,204
998,362
0
0
0
0
277
2,950
15,533,254
$3,740,153
1,074,697
1,069,971
2,009,887
1,001,853
2,020,236
1,010,586
2,020,979
0
277
2,950
13,951,588
AGENDA ITEM # 4A
DECEMBER 12, 2011
Dollar Interest
Change Rate
($7,644,918)
0.250%
348,495
2,877
1.780%
(1)
3,402
3.080%
(1)
1,001,683
2.470%(l)
$31,702,880
3,490
1.440%(l)
2,020,236
4.170%(l)
1,010,586
3.780%(l)
2,020,979
3.800%
(1)
0
0.010%
0
0.260%
0
N/A
(1,581,666)
6,149,798
6,498,294
348,495
10,434,616
11,252,999
818,383
Subtotal 16,584,414
17,751,292
1,166,878
Total $32,117,668
$31,702,880
($414,788)
Rate of
Return
5.66%(2)
7.84% (2)
(1) 30 day SEC Yield as of 10/31/11
(2) Rate of return as of 10/31/11
City of Atlantic Beach AGENDA ITEM # 4A
DECEMBER 12, 2011
FINANCIAL REPORT
OCTOBER 2011
Revenues
Fund / (Footnote)
Annual
Estimate
YTD - 8%
of Estimate
YTD
Actual
Dollar
Variance
Percent
Variance
General (1) & (3)
$10,964,642
$910,065
$681,268
($228,797)
- 25.14%
Convention Development Tax
72,000
5,976
30
(5,946)
- 99.50%
Local Option Gas Tax
472,612
39,227
36,231
(2,996)
-7.64%
Better Jax 1/2 Ct Sales Tax
646,212
53,636
47,357
(6,279)
-11.71%
Police Training, Forfeiture & Grants, etc.
134,974
11,203
41,871
30,668
273.75%
Grants (2)
318,214
26,412
44,789
18,377
69.58%
Debt Service
71,300
5,918
6,267
349
5.90%
Capital Projects
2,255,737
187,226
51,670
(135,556)
- 72.40%
Utility (3)
8,368,949
694,623
941,398
246,775
35.53%
Sanitation
1,804,500
149,774
150,219
445
0.30%
Building Code Enforcement
265,900
22,070
12,500
(9,570)
- 43.36%
Storm Water
972,200
80,693
75,500
(5,193)
-6.44%
Pension - Police
1,232,311
102,282
408,057
305,775
298.95%
Pension - General
2,122,019
176,128
931,589
755,461
428.93%
Total
$29,701,570
$2,465,233
$3,428,746
$963,513
Analysis of Major Variances
(1) The $228,797 negative variance in the General Fund resulted from not having received
property taxes. Typically the majority of these taxes are received from the City of
Jacksonville in December & January.
(2) The $135,556 negative variance in the Capital Projects Funds resulted from not having
received the proceeds from a Loan. If the loan was not included in this calculation, the
variance would be a positive 5.19 %.
(3) The $246,775 positive variance in the Utility Funds resulted from receiving proceeds
from the State Revolving Fund Loan and 100% of the tower lease for antennas. If these
items were not included in this calculation, the variance would be a positive 10.21 %.
(4) The $305,775 positive variance in the Police Employee Pension Fund & the $755,461
positive variance in the General Employee Pension Fund resulted from changes in
market values of the investments
City of Atlantic Beach AGENDA ITEM # 4A
FINANCIAL REPORT DECEMBER 12, 2011
OCTOBER 2011
Expenses
Analysis of Major Variances
(1) The positive variance in the Public Safety divisions resulted from no expenditures fiscal
year to date on the Police Building - see Project Activity Schedule. The variance without
the budget for the Police Building is 21 %.
(2) The negative variance in the Public Utilities department resulted from the October
payment of principal and interest on the Utility Revenue Bonds and the State Revolving
Fund Loan. The variance without the monies expended for Debt Service is (0.92) %.
(3) The positive variance in the Personal Services is typical for the first month of the new
fiscal year due to the payroll expense only including two weeks of the month of October.
The last 2 weeks of October will not be paid until the first week of November. This
explains why approximately 42% of October's budgeted payroll has not been expensed
Annual
YTD - 8%
YTD
Dollar
Percent
Department / (Footnote)
Estimate
of Estimate
Actual
Variance
Variance
Governing Body
$41,986
$3,485
$4,386
($901)
- 25.85%
City Administration
2,673,887
221,933
171,213
50,720
22.85%
General Government
765,368
63,526
123,546
(60,020)
- 94.48%
Planning and Building
478,867
39,746
34,305
5,441
13.69%
Public Safety (1)
10,054,574
834,530
291,415
543,115
65.08%
Recreation and Special Events
394,207
32,719
55,647
(22,928)
- 70.08%
Public Works
5,976,228
496,027
553,823
(57,796)
- 11.65%
Public Utilities (2)
14,301,191
1,186,999
2,102,586
(915,587)
- 77.13%
Pension - Police
587,832
48,790
58,402
(9,612)
- 19.70%
Pension - General
740,710
61,479
70,416
(8,937)
- 14.54%
Total
$36,014,850
$2,989,234
$3,465,739
($476,505)
Annual
YTD - 8%
YTD
Dollar
Percent
Resource Allocation
Estimate
of Estimate
Actual
Variance
Variance
Personal Services
$9,872,555
$819,422
$471,573
$347,849
42.45%
Operating Expenses
10,384,222
861,890
1,081,968
(220,078)
- 25.53%
Capital Outlay (1)
11,802,218
979,586
531,638
447,948
45.73%
Debt Service (2)
2,297,807
190,718
1,242,388
(1,051,670)
- 551.43%
Transfers
1,658,048
137,618
138,172
(554)
-0.40%
Total
$36,014,850
$2,989,234
$3,465,739
($476,505)
Analysis of Major Variances
(1) The positive variance in the Public Safety divisions resulted from no expenditures fiscal
year to date on the Police Building - see Project Activity Schedule. The variance without
the budget for the Police Building is 21 %.
(2) The negative variance in the Public Utilities department resulted from the October
payment of principal and interest on the Utility Revenue Bonds and the State Revolving
Fund Loan. The variance without the monies expended for Debt Service is (0.92) %.
(3) The positive variance in the Personal Services is typical for the first month of the new
fiscal year due to the payroll expense only including two weeks of the month of October.
The last 2 weeks of October will not be paid until the first week of November. This
explains why approximately 42% of October's budgeted payroll has not been expensed
City of Atlantic Beach
FINANCIAL REPORT
OCTOBER 2011
Project Activity - Current Year Activity Only
AGENDA ITEM # 4A
DECEMBER 12, 2011
Project Name
Project
Number Budget
YTD YTD
Actual Balance
Status
Public Safety
Retrofit HVAC Systems
GG1201
190,414
0
190,414
Lifeguard Building Roof Replacement
LG0901
4,750
0
4,750
Police Building Renovation /Design /Construction
PS0504
4,432,582
0
4,432,582
4,627,746
0
4,627,746
Public Utilities:
TMDL - Lift Station /Main Transfer Flow
PU0906
72,810
0
72,810
Donner Subdivision Sewer Rehabilitation
PU1015
175,590
0
175,590
Replace 2" Water Main - 11th Street
PU1104
61,283
21,213
40,070
TMDL Upgrade /Construction - WWTP #1
PU1106
3,218,851
365,906
2,852,945
TMDL Sludge /Odor Improvements
PU1110
2,392,784
74,218
2,318,566
Elevated Tank #1 - Internal Rehabilitation
PU1201
40,000
0
40,000
Ground Storage Tank WP #2 - Interior Rehabilitation
PU1202
40,000
0
40,000
Ground Storage Tanks WP #3 - Recoat Interior
PU1203
60,000
0
60,000
Water Main - 12th Street at Ocean Blvd /Beach Ave
PU1204
60,000
0
60,000
Water Main - 14th & 15th Street at Ocean Boulevard
PU1205
140,000
0
140,000
Sewer Rehabilitation -Area B
PU1206
300,000
0
300,000
Subtotal
6,561,318
461,337
6,099,981
Public Works:
Riverbranch Preserve- Kayak & Canoe Launch
PM0804
16,113
14,676
1,437
Veteran's Park - Phase II - Memorial Garden
PM1110
2,632
0
2,632
Howell Park Bridge Replacement
PM1201
25,000
0
25,000
Bull Park Playground Equipment Replacement
PM1202
40,000
0
40,000
Sidewalk & Curb Replacement
PW1101
5,406
5,406
0
Sidewalk & Curb Replacement
PW1201
25,000
1,790
23,210
East Coast Drive Drainage Improvements
PW1202
50,000
0
50,000
Subtotal
164,151
21,872
142,279
Total
$11,353,215
$483,209
$10,870,006
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