Agenda Item 4A- W , w I - - 94 mpiiiiiiiiim
*., *Gomm 4 0 guov Tt X ^
IF
Z.M
A
' L
'7K
TEO
I .4p
ta t
-: �E
= I W I Z
MMU".2 t
C
A
' L
City of Atlantic Beach
FINANCIAL REPORT
DECEMBER 2010
AGENDA ITEM # 4A
FEBRUARY 14, 2011
Cash Balances
Prior Current Dollar
Fund(s) 11/30/10 12/31/10 Change
General
$4,651,170
$6,802,697
$2,151,526
Tree Replacement
3,989
3,989
0
Convention Development Tax
31,463
42,616
11,153
Local Option Gas Tax
111,765
131,641
19,876
Better Jax 1/2 Cent Sales Tax
323,139
303,904
(19,235)
Police Training, Forfeiture, Grants, etc.
155,824
139,399
(16,425)
Community Development Block Grant
0
0
0
Debt Service
85,698
24,303
(61,395)
Capital Projects
1,786,517
1,822,032
35,515
Utility
4,127,704
4,269,033
141,329
Sanitation
636,652
639,688
3,036
Building Code Enforcement
54,297
42,924
(11,373)
Storm Water
1,921,201
1,806,090
(115,111)
Pension - Police
15,918
17,802
1,884
Pension - General
59,762
93,787
34,026
Investments - Unallocated Gains (Losses)
(54,567)
(254,910)
(200,343)
Total
$13,910,532
$15,884,994
$1,974,462
11,078,916
445,084
4.270
Total Restricted Cash
17,487,952
$7,632,174
Total Unrestricted Cash
$8,252,820
Cash and Investments
Account
Prior
11/30/10
Bank of America - Depository
$6,289,541
Federal National Mortgage Association Bonds
0
US Treasury Notes
1,164,074
US Treasury Notes
2,182,377
Federal Farm Credit Bank Consolidated Bonds
1,171,586
Federal Home Loan Bank Consolidated Bonds
1,019,124
Pimco Mutual Fund
999,176
Putnam US Government Mutual Fund
1,001,327
MorganStanley SmithBarney Cash
80,125
SBA - Florida Prime
252
Cash on Hand
2,950
Subtotal 13,910,532
Police Pension Investments 6,221,559
General Pension Investments 10,633,832
Subtotal 16,855,391
Total $30,765,923
(1) Fiscal year to date rate of return is (2.3 %)
Current
Dollar
Interest
12/31/10
Change
Rate
$4,519,802
($1,769,739)
0.300
2,005,560
2,005,560
4.300
(1)
1,132,485
(31,589)
4.625
(1)
2,103,005
(79,372)
3.625
(1)
1,142,538
(29,048)
4.875
(1)
1,016,447
(2,677)
4.300
(1)
1,979,152
979,976
2.054
(1)
1,982,780
981,453
5.076
(1)
0
(80,125)
0.000
275
23
0.270
2,950
0
N/A
15,884,994
1,974,462
Rate of
Return
6,409,036
187,477
3.010
11,078,916
445,084
4.270
17,487,952
632,561
$33,372,946 $2,607,022
City of Atlantic Beach AGENDA ITEM # 4A
FINANCIAL REPORT FEBRUARY 14,2011
DECEMBER 2010
Revenues
Fund / (Footnote)
Annual
Estimate
YTD - 25%
of Estimate
YTD
Actual
Dollar
Variance
Percent
Variance
General (1) & (2)
$11,515,549
$2,878,887
$5,690,995
$2,812,108
97.68%
Convention Development Tax
192,857
48,214
25,584
(22,630)
- 46.94%
Local Option Gas Tax
463,523
115,881
117,751
1,870
1.61%
Better Jax 1/2 Ct Sales Tax
658,424
164,606
155,237
(9,369)
-5.69%
Police Training, Forfeiture & Grants, etc.
153,535
38,384
98,843
60,459
157.51%
Grants
647,352
161,838
15,230
(146,608)
- 90.59%
Debt Service
68,650
17,163
17,236
73
0.43%
Capital Projects
853,000
213,250
205,873
(7,377)
-3.46%
Utility (2)
19,061,825
4,765,457
3,290,760
(1,474,697)
- 30.95%
Sanitation
1,837,500
459,375
455,776
(3,599)
-0.78%
Building Code Enforcement
317,850
79,463
72,862
(6,601)
-8.31%
Storm Water
669,124
167,281
173,123
5,842
3.49%
Pension - Police (3)
964,726
241,182
426,359
185,177
76.78%
Pension - General (3)
1,522,969
380,742
916,602
535,860
140.74%
Total
$38,926,884
$9,731,723
$11,662,231
$1,930,508
Analysis of Major Variances
(1) The $2,812,108 positive variance in the General Fund resulted from having received
80.6% 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 $1,474,697 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 2.5 %.
(3) The $185,177 positive variance in the Police Employee Pension Fund & the $535,860
positive variance in the General Employee Pension Fund resulted from changes in
market values of the investments.
City of Atlantic Beach
FINANCIAL REPORT
DECEMBER 2010
AGENDA ITEM # 4A
FEBRUARY 14, 2011
Expenses
Department / (Footnote)
Governing Body
City Administration
General Government
Planning and Building
Public Safety
Recreation and Special Events
Public Works
Public Utilities (1) & (3)
Pension - Police
Pension - General
Total
Annual YTD - 25% YTD Dollar Percent
Estimate of Estimate Actual Variance Variance
$42,260
$10,565
$10,850
($285)
- 2.70%
2,465,322
616,331
690,107
(73,776)
- 11.97%
914,780
228,695
170,885
57,810
25.28%
531,131
132,783
112,557
20,226
15.23%
6,103,010
1,525,753
1,367,743
158,010
10.36%
392,160
98,040
127,772
(29,732)
- 30.33%
6,702,937
1,675,736
1,539,514
136,222
8.13%
19,711,651
4,927,911
3,586,231
1,341,680
27.23%
548,977
137,244
130,933
6,311
4.60%
555,445
138,861
161,803
(22,942)
- 16.52%
$37,967,673
$9,491,919
$7,898,395
$1,593,524
Annual YTD - 25% YTD Dollar Percent
Resource Allocation Estimate of Estimate Actual Variance Variance
Personal Services
$9,416,977
$2,354,244
$2,223,059
$131,185
5.57%
Operating Expenses
10,158,646
2,539,662
2,291,848
247,814
9.76%
Capital Outlay (1)
13,803,637
3,450,909
771,899
2,679,010
77.63%
Debt Service (2)
2,137,906
534,477
1,329,542
(795,065)
- 148.76%
Transfers (3)
2,450,507
612,627
1,282,047
(669,420)
- 109.27%
Total $37,967,673
$9,491,919
$7,898,395
$1,593,524
Analysis of Major Variances
(1)The positive variance in the Public Utilities department resulted from
limited activity on the various projects funded from this source — see Project
Activity Schedule.
(2)The negative variance in the Debt Service Accounts resulted from the
October and December payment of principal and interest on the Utility
Revenue Bonds.
(3)The positive variance in the Transfer Accounts resulted from the TMDL
related transfer from the Utility System Debt Service Fund to the General
Fun due to the receipt of loan proceeds. The accounts are now 97.5% of
the budgeted amounts.
City of Atlantic Beach
FINANCIAL REPORT
DECEMBER 2010
Project Activity - Current Year Activity Only
AGENDA ITEM # 4A
FEBRUARY 14, 2011
Project YTD YTD YTD
Project Name Number Budget Actual Balance
Public Safety
Lifeguard Building Roof Replacement
LG0901
8,000
0
8,000
Police Building Renovation /Design /Construction
PS0504
401,697
19,953
381,744
409,697
19,953
389,744
Public Utilities:
Replace Well at Water Plant #1
PUO304
287,018
94,652
192,366
TMDL - WWTP #1 Design
PU0905
91,276
91,204
72
TMDL - Lift Station /Main Transfer Flow
PU0906
1,708,740
53,888
1,654,852
Elevated Tank - Water Plant #1
PU 1001
1,688
0
1,688
Ground Storage Tank Rehab - Water Plant #1
PU1002
44,340
44,340
0
Collection System Inspection & Rehab
PU1004
42,836
27,789
15,047
Mimosa Cove Lift Station Upgrades
PU1005
48,590
0
48,590
Lift Station E Upgrades
PU1006
48,183
48,183
0
Tank Rehab - Water Plant #4
PU1014
814
0
814
Well Rehab - Well # 1 @ Water Plant #1
PU1101
50,000
0
50,000
Elevated Tank Rehab - Water Plant #2
PU1102
15,000
0
15,000
Ground Storage Tank Rehab - Water Plant #4
PU1103
40,000
0
40,000
Replace 2" Water Main - 11th Street
PU1104
120,000
0
120,000
Sewer Rehab - Sea Oats Drive
PU1105
300,000
0
300,000
TMDL Upgrade /Construction - WWTP #1
PU1106
5,312,070
0
5,312,070
Valve Replacement- Davco & Clarifier
PU1107
35,000
0
35,000
Replace Equipment- PW Yard Station
PU1108
30,000
0
30,000
Plant Improvements - Master Plan
PU1109
469,000
0
469,000
TMDL Sludge /Odor Improvements
PU1110
234,914
0
234,914
Subtotal
8,879,469
360,056
8,519,413
Public Works:
Riverbranch Preserve - Kayak & Canoe Launch
PM0804
196,306
1,758
194,548
Howell Park Bridge Replacement
PM1001
20,000
0
20,000
Veteran's Park - Flag & Pavilion
PM1006
72,063
69,776
2,287
Dog Park - Hopkins Creek
PM1008
27,800
18,049
9,751
Gate at Dutton Island
PM1101
20,000
0
20,000
Lighting - Basketball Court
PM1102
22,000
0
22,000
Lighting - Security at Community Center
PM1103
20,188
0
20,188
Sod - Baseball Field
PM1104
32,000
0
32,000
Sod - South End of Soccer Field
PM1105
20,000
0
20,000
Parking - Paved
PM1106
36,975
0
36,975
Water Fountain - Russell Park
PM1107
5,000
0
5,000
Royal Palms Design
PW0808
3,294
759
2,535
Royal Palms Stormwater Project
PW0905
580,405
130,622
449,783
Bulkhead - Ditch @ Cavalla
PW1005
9,472
9,472
0
Sidewalk & Curb Replacement
PW1101
25,000
9,869
15,131
Drain Line - Atlantic Blvd /East Coast Dr /Ahern St
PW1102
50,000
0
50,000
Subtotal
1,140,503
240,305
900,198
Total
$10,429,669
$620,314
$9,809,355
Status Key
Status
E
C
C
I
C
E
C
I
E
I
C
I
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
HlIC,1V lJA i i a. tea rt
FEBRUARY 14, 2011
U)
Z❑
N
t8
w
w
N
vwww
N
�
ti
tD
M
d
W
- a
- a
tM
x
O
O
LL
w
CLi
~
J
O
O
W
CL
IL
Q
-
In
N
Q
Z
Q
ca
v
v
Z
O
O
J
J
O
O
H
W
m
m
H
a
r
O
~
❑
�
N
wZ_d'?Z
U )
0
- 1
?u1W
Lo
T.-
Z 7JJ c)
Iq
0
on
I..r
�W
O
mwa22
CL
U)
qr-
®
O o
O o
0 0
O o
w
O o
O o
O o
0 0
O o
O o
0
I"
o
o
}
O o
0 0
W
r
o
0
Q
o
m
0
c
O
0
t>
N�
Q
Z
N
co
�
to
N
<D
M
M
to
N
to
ff!
Z
O
�
�
N �N
LL
I.fi
Z
N
Z
O
� y -
V
a
U
(n
H
40)
6.1
e11,
e11,
e11�
4
O
®
�
0
0
0
0
0
0
0
0
O
O
O
-
-
-
J
=
®
O
GOON
O
O
O
O
N
Z
o
Z
N
O
OCA1A0
0004ti
I
O
W
U)
O
Z
N
Z
®—
L
0
O
O
R
o
O
00000000
u>u>oulu>ou>o
000
000
00
00
-
0
O
-
0
u>
5
q
W
LL
{-
(J)
O
.4
M
�
M
W
W
LOt
00
e1
O
-
-Q<DN
d'
0110
W
O
( -
T"
h
O
O
am
T"
0)
�
OCl)
M
�
O
T"
N
M
O
�
O
T"
N
M
Iq
O
it
Ii
3
Q
®
O
q
N
N
I
Cl)
�
N
ti
e
N
a
t�
d9
ER
!fi
Ef*
WF
V
�
r
n
0
Ids
UU
LL
U
CO)
V�
CO)
a
®
♦^
O
-
-
H
�
�
ts�40
�����
��ts
� �
6e+
�
Z
a.
0
rZ
®
®
N
M
O
V
O
MI
N
J
r ❑
T
0
H
w
g
CL
LL
W�
O
v
0
0
Q ;9
N
�
N
N
O
N
S
O
N
M
M
Q
W
V)
Q
N
o
O
d
o
O
m r
Q
O
N
OA
N
OI
ti
Z
M
T
Z
Z
In
Q
QZ
OO
O
O
LL
O
F
In
U
O
Z ❑
j
Q
Q>
LL
a
W
0 -
'-
_JX
J
z
JJ
Q
J�
JJ
O
O
W
Z
— w
>
co
~
2
Q
Qa
]U
gWQQQQ
QJF UUU 2 QUU(7
-
Oz
❑OHwzLL
- Z
�Q}
(n
LL
W
LL LL Z��LY (A V
❑wW
ZZZ U r
F
W
F-
In
QLL
O
r L
WX❑W
J
w
W
J❑
❑222.N
W
W
F
Q
Q
m_
Z�S—
O
®0
J
d
2p <
H
_
d
J
W
V
>
=
N
0:
( D
z
a.
a2gx
(7
Z
�(n
oz
z-
O
Lu
7
W
0
F
W
W
O
O
O
W
W W
W
J
O®
W
W
W
0
W(D
W
S
O
a
05a
60
U)IZW
vawm�aa�❑aa0CL
LL
❑an.
AGENDA ITEM # 4A
FEBRUARY 14, 2011
PREPARED 2/04/11,15:26:42
LICENSE ACTIVITY REPORT BY BUSINESS NAME
- - - - -- NEW LICENSES - --
City of Atlantic Beach NEW
LICENSES
FOR YEAR: 2011 BETWEEN: 01 /01 /11 TO
01/31/11
PROGRAM OL122L
DEPT:
ALL DEPARTMENTS CLASS: ALL CLASSES
0
--------------------------------------------------------------------------------------------------------------
LIC # BUSINESS NAME
ISSUED
TYPE CLASSIFICATION
0
BUSINESS ADDRESS
--------------------------------------------------------------------------------------------------------------
0
UC:
BUS PHONE #
11- 00007342 JACKSONVILLE STUMP REMOVAL LLC
1/14/11
NEW MISC. SERVICE ESTABLISHMENT,
NOT LIS
769 JASMINE ST
904 - 463 -0332
ATLANTIC BEACH FL 32233
11- 00007347 OTO'MELARA NORTH AMERICA,INC.
1/27/11
NEW MISC. SERVICE ESTABLISHMENT,
NOT LIS
645 MAYPORT RD UNIT 1
904- 270 -2860
ATLANTIC BEACH FL 32233
11- 00007344 OVANA GLUTON FREE BAKERY
1/14/11
NEW BAKERY
363 ATLANTIC BLVD UNIT 09
904 - 318 -3576
ATLANTIC BEACH FL 32233
11- 00007346 VARICK ROSETE STUIDO LLC
1/31/11
NEW MISC. SERVICE ESTABLISHMENT,
NOT LIS
578 CRUISER LN
904- 874 -2025
ATLANTIC BEACH FL 32233
11- 00007345 WE R WIRELESS LLC
1/31/11
NEW COMMUNICATIONS EQPT. /CELL PHONES /BEE
753 ATLANTIC BLVD UNIT 2
786 - 837 -4444
ATLANTIC BEACH FL 32233
GRAND TOTALS
--------
- - - - -- NEW LICENSES - --
AC:
5
PP:
0
IN:
0
VO:
0
PG:
0
BR:
0
OB:
0
UC:
0
LIC:
5
AGENDA ITEM # 4A
FEBRUARY I4, 2011
City of Atlantic Beach, Fl.
Utility
Sales Report
January 2011
January 2010
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,566
38,172
$143,191
$3.75
5,563
35,850
$133,319
$3.72
Buccaneer
2,441
16,753
$81,124
$4.84
2,420
19,291
$83,963
$4.35
Total Water Sales
8,007
54,925
$224,315
$4.08
7,983
55,141
$217 ,282
$3.94
Gallons
Gallons
Water Plant Production
0000
0000
Atlantic Beach
39,683
48,544
Buccaneer
24,198
17,334
Total Production
63,881
65,878
Total Water Billed
54,925
55,141
Water Loss for month:
8,956
0, 7 3
10,737
Percentage Loss
14.02%
16.30%
Total 12 mo. Avg. Loss
14.70%
13.58%
Gallons
Actual
Revenue
Gallons
Actual
Revenue
Sewer Sales
Accounts
0000
Revenue
Per 1,000 gi
Accounts
0000
Revenue
Per 1,000 gI
Atlantic Beach
5,094
30,905
$234,298
$7.58 a
5,069
30,717
$212,917
$6.93 a
Buccaneer
2,324
17,062
$168,588
$9.88
2,293
18,225
$159,716
$8.76
Total Sewer Sales
7,418
47,967
$402,886
$8.40
7,362
48,942
$372,633
$7.61
Gallons
Actual
Revenue
Gallons
Actual
Revenue
Sewer Treatment
0000
Revenue
Per 1,000 gi
0000
Revenue
Per 1,000 gi
Atlantic Beach
42.237
$234,298
$5.55
48.577
$212,917
$4.38
Buccaneer
18.290
$168,588
$9.22
17.744
$159,716
$9.00
l Total Sewer Treated
60.527
$402,886
$6.660
66.321
$372,633
$5.62
AGENDA ITEM # 4A
FEBRUARY 14, 2011
b
'v,
•,. C
G
,eJ
�
�
�
as
^ cd 6�
i-. U � ••r
'b
as O.
bA
b
N �
cd
� O � 'Lf
R•
O
}'
i7
U
O � •�
>~
� � 0 0 �
�
�
N
O
p
�
ed
O
M Ln
c
O� NbA
bb
G
O
W
O o
O
3
-d
ov3�
�
..
O G4
y U G— O
'd � bA M � 0.
.�.
0 G
O "
"o
N N - .�.
pp n
O
N
Z W
N
p
' S
OO p
� U cn
O
a �
8 U�3
r.
to
" Cl
W Z
v1
U
U O v i7
U U U O
O
O
O ( z
lz H
p
^
o
?
W
a
as
b
3
3
a
p
Cn
ps
bb
bb
� °
3
on x G �,
5
:4
w U
E_
'"
�5
•y U
�+
�+
a1
��
cn
`s U
y
U 3
U
o�
�Z
75
U
Z
17 °'d
-�8
O
O
I^ I^ W
II ^ II U W
II II °�
i II o?
I II °'d
I
II II
a1UU
a U
a1UU
a1U U
AUU
AU U
AUU
P4
E�
Z
o
y
•� II
�
�
W
O
y O ,� II
o II 11 ,o st
o •ti
p II
a
O
U
U
Z
bq
O O
p� II Ci U .
�,
O by o
.�
G
+�
� O
cd o
N
y o
w F
5 o
.§4 �
II
as
"
u Q
II II
0 Q � `ti o �
� � II
�
� o II
\ II
\ II
.,o'°
U
0.
° ° °
° ° °
° '° st
z
U A
P-4 Q U
3 '" Q Q
y
a it
g w ��
�
�
a� � o
�
a o
o
a •� •� o
� •� o
w
�
� � •� o
Z � � .� o
r
�
II
AGENDA ITEM # 4A
FEBRUARY 14, 2011
W
d'
N
C7
z
}"
w
w
�
c
a
a
�
H II
r+
b
•A
d
O
w
d a U
H
U
z
0
v
DF
v
U
w
U
O�
W
Ca u u
suu
A4
E-�
z
0
U
�
II
�
U
p
G
�
\ ~
o II
C7
U
w
� ,,, o
•� , ,�
w sa
u
o
� Q U
v1 A V
00
A