Agenda Item 4ACity of Atlantic Beach
FINANCIAL REPORT
NOVEMBER 2010
AGENDA ITEM # 4A
JANUARY 10, 2011
Cash Balances
Fund(s)
Prior
10/31/10
General
$3,526,698
Tree Replacement
3,989
Convention Development Tax
32,116
Local Option Gas Tax
97,862
Better Jax 1/2 Cent Sales Tax
328,542
Police Training, Forfeiture, Grants, etc.
248,567
Community Development Block Grant
15,230
Debt Service
79,951
Capital Projects
1,766,629
Utility
3,859,394
Sanitation
618,125
Building Code Enforcement
50,583
Storm Water
1,931,800
Pension - Police
15,804
Pension - General
34,193
Total $12,609,483
Total Restricted Cash
Total Unrestricted Cash
Current Dollar
11/30/10 Change
$4,651,171 $1,124,473
3,989
0
31,463
(653)
111,765
13,903
323,139
(5,403)
155,824
(92,743)
0
(15,230)
85,698
5,747
1,786,517
19,888
4,127,704
268,310
636,652
18,527
54,297
3,714
1,921,201
(10,599)
15,918
114
59,762
25,569
$13,965,100 $1,355,617
$7,944,963
$6,020,137
Cash and Investments
Account
Bank of America - Depository
Federal National Mortgage Association Bonds
US Treasury Notes
US Treasury Notes
Federal Farm Credit Bank Consolidated Bonds
Federal Home Loan Mortgage Corporation
Federal Home Loan Bank Consolidated Bonds
Pimco Mutual Fund
Putnam US Government Mutual Fund
MorganStanley SmithBarney Cash
SBA - Florida Prime
Cash on Hand
Subtotal
Police Pension Investments
General Pension Investments
Prior
10/31/10
$4,950,953
1,015,286
1,199,095
2,198,967
1,181,893
1,019,920
1,040,171
0
0
0
248
2,950
12,609,483
6,235,209
10,681,854
Subtotal 16,917,063
Total $29,526,546
Current Dollar Rate of
11/30/10 Change Return %
$6,344,110
$1,393,157
0.300
0
(1,015,286)
3.100
1,164,074
(35,021)
4.625
2,182,377
(16,590)
3.625
1,171,586
(10,307)
4.875
0
(1,019,920)
4.000
1,019,124
(21,047)
4.300
999,176
999,176
2.054
1,001,327
1,001,327
5.076
80,125
80,125
0.030
251
3
0.300
2,950
0
N/A
13,965,100
1,355,617
6,221,559 (13,650) (0.220) (1)
10,633,832 (48,022) (0.450) (1)
16,855,391 (61,672)
$30,820,491 $1,293,945
(1) Rate of return as of 11/30/10
City of Atlantic Beach JANUARY 0, oaa
FINANCIAL REPORT
NOVEMBER 2010
Revenues
Fund / (Footnote)
Annual
Estimate
YTD - 16.7%
of Estimate
YTD
Actual
Dollar
Variance
Percent
Variance
General (1)
$11,515,549
$1,923,097
$2,428,758
$505,661
26.29%
Convention Development Tax
192,857
32,207
14,431
(17,776)
- 55.19%
Local Option Gas Tax
463,523
77,408
77,113
(295)
-0.38%
Better Jax 1/2 Ct Sales Tax
658,424
109,957
107,971
(1,986)
-1.81%
Police Training, Forfeiture & Grants, etc.
153,535
25,640
92,464
66,824
260.62%
Grants
647,352
108,108
15,230
(92,878)
- 85.91%
Debt Service
68,650
11,465
11,490
25
0.22%
Capital Projects
853,000
142,451
136,161
(6,290)
-4.42%
Utility (2)
19,061,825
3,183,325
1,698,490
(1,484,835)
- 46.64%
Sanitation
1,837,500
306,863
306,847
(16)
-0.01%
Building Code Enforcement
317,850
53,081
53,184
103
0.19%
Storm Water
669,124
111,744
112,484
740
0.66%
Pension - Police (3)
964,726
161,109
196,344
35,235
21.87%
Pension - General (3)
1,522,969
254,336
389,013
134,677
52.95%
Total
$38,926,884
$6,500,791
$5,639,980
($860,811)
Analysis of Major Variances
(1) The $505,661 positive variance in the General Fund resulted from having received 29%
of the budgeted property taxes. Typically the majority of these taxes are received from
the City of Jacksonville in December & January.
(2) The $1,484,835 negative variance in the Utility Funds resulted from not having received
the proceeds from the Bank - Qualified Loan. The anticipated receipt of the loan proceeds
is in mid - December, 2010. If the loan was not included in this calculation, the variance
would be a positive 12.5 %.
(3) The $35,235 positive variance in the Police Employee Pension Fund & the $134,677
positive variance in the General Employee Pension Fund resulted from changes in
market values of the investments.
City of Atlantic Beach
FINANCIAL REPORT
NOVEMBER 2010
AGENDA ITEM # 4A
JANUARY 10, 2011
Expenses
Department / (Footnote)
Governing Body
City Administration
General Government
Planning and Building
Public Safety (1)
Recreation and Special Events
Public Works (2)
Public Utilities (3)
Pension - Police
Pension - General
Total
Annual
Estimate
YTD -16.7%
of Estimate
YTD
Actual
Dollar
Variance
Percent
Variance
$42,260
$7,057
$7,485
($428)
-6.06%
2,465,322
411,709
400,585
11,124
2.70%
914,780
152,769
64,285
88,484
57.92%
531,131
88,699
63,668
25,031
28.22%
6,103,010
1,019,203
685,203
334,000
32.77%
392,160
65,491
85,412
(19,921)
- 30.42%
6,702,937
1,119,391
977,246
142,145
12.70%
19,711,651
3,291,845
1,955,279
1,336,566
40.60%
548,977
91,679
90,278
1,401
1.53%
555,445
92,759
113,227
(20,468)
- 22.07%
$37,967,673
$6,340,602
$4,442,668
$1,897,934
Resource Allocation
Personal Services (1) & (4)
Operating Expenses (1) & (2)
Capital Outlay (1) - (3)
Debt Service (5)
Transfers
Total
Annual YTD -16.7% YTD Dollar Percent
Estimate of Estimate Actual Variance Variance
$9,416,977
$1,572,635
$1,144,379
$428,256
27.23%
10,161,148
1,696,912
1,272,673
424,239
25.00%
13,801,135
2,304,790
439,090
1,865,700
80.95%
2,137,906
357,030
1,178,107
(821,077)
- 229.97%
2,450,507
409,235
408,419
816
0.20%
$37,967,673
$6,340,602
$4,442,668
$1,897,934
Analysis of Major Variances
(1) 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. The next
payment is due in January 2011 for October through December 2010. Also, there have
been vacant positions in the Police Patrol division, the Lifeguards are seasonal & there
has been limited activity on the Public Safety Building project funded from this source -
see Project Activity Schedule.
(2) The positive variance in the Public Works department resulted from only 1 of 2 monthly
payments for this fiscal year have been paid on the Advanced Disposal Services Jax LLC
and First Vehicles contracts.
(3) The positive variance in the Public Utilities department resulted from limited activity on
the various projects funded from this source - see Project Activity Schedule.
(4) The positive variance in the Personal Services is typical for the new fiscal year due to
the payroll expense only including two weeks of the month of October. The first payroll in
the first month of the new fiscal year is split between the current & prior fiscal year. Also,
there have been vacant positions in the Police Department and the Lifeguard expenses
are seasonal.
(5) The negative variance in the Debt Service Accounts resulted from the October
payment of principal and interest on the Utility Revenue Bonds.
Subtotal 1,140,503 208,589 931,914
Total $12,885,422 $313,359 $12,572,063
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
City of Atlantic Beach
AGENDA ITEM # 4A
FINANCIAL REPORT
JANUARY 10, 2011
NOVEMBER 2010
Project A - Current Year Activity Only
Project
YTD
YTD
YTD
Project Name
Number
Budget
Actual
Balance
Status
Public Safety
Lifeguard Building Roof Replacement
LGO901
8,000
0
8,000
Police Building Renovation /Design /Construction
PS0504
401,697
9,410
392,287
E
409,697
9,410
400,287
Public Utilities:
Replace Well at Water Plant #1
PUO304
287,018
0
287,018
1
TMDL - WWTP #1 Design
PU0905
91,276
0
91,276
E
TMDL - Lift Station /Main Transfer Flow
PU0906
3,729,967
0
3,729,967
E
Elevated Tank - Water Plant #1
PU1001
1,688
0
1,688
Ground Storage Tank Rehab - Water Plant #1
PU1002
44,340
19,388
24,952
1
Collection System Inspection & Rehab
PU1004
42,836
27,789
15,047
1
Mimosa Cove Lift Station Upgrades
PU1005
48,590
0
48,590
1
Lift Station E Upgrades
PU1006
48,183
48,183
0
C
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,981,510
0
5,981,510
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
Subtotal
11,335,222
95,360
11,239,862
Public Works:
Riverbranch Preserve - Kayak & Canoe Launch
PM0804
196,306
668
195,638
E
Howell Park Bridge Replacement
PM1001
20,000
0
20,000
Veteran's Park - Flag & Pavilion
PM1006
72,063
55,532
16,531
1
Dog Park - Hopkins Creek
PM1008
27,800
2,204
25,596
I
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
E
Royal Palms Stormwater Project
PWO905
580,405
130,622
449,783
1
Bulkhead - Ditch @ Cavalla
PW1005
9,472
9,472
0
C
Sidewalk & Curb Replacement
PW1101
25,000
9,332
15,668
Drain Line - Atlantic Blvd /East Coast Dr /Ahern St
PW1102
50,000
0
50,000
Subtotal 1,140,503 208,589 931,914
Total $12,885,422 $313,359 $12,572,063
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
JANUARY 10, 2011
PREPARED 1/03/11, 8:16:48
LICENSE ACTIVITY REPORT BY BUSINESS NAME
NEW LICENSES ------- - - ----
City of Atlantic Beach
NEW
LICENSES FOR YEAR: 2011 BETWEEN: 12/01/10 TO
12/31/10
PROGRAM OL122L
0
DEPT: ALL DEPARTMENTS CLASS: ALL CLASSES
---------------------------------------------------
0
-------------------------------------------------------------
LIC # BUSINESS NAME
0
ISSUED TYPE CLASSIFICATION
0
BUSINESS ADDRESS
--------------------------------------------------------------------------------------------------------------
0
UC:
BUS PHONE #
11- 00007338 ATLANTIC SUBS,LLC
DBA JIMMY
12/02/10 NEW RESTAURANTS(INC. SNACK BARS &
TAKE O
363 ATLANTIC BLVD
UNIT 14
904 - 246 -2033
ATLANTIC BEACH FL
32233
11- 00007342 JACKSONVILLE STUMP
REMOVAL LLC
12/21/10 NEW MISC. SERVICE ESTABLISHMENT,
NOT LIS
769 JASMINE ST
904 - 463 -0332
ATLANTIC BEACH FL
32233
11- 00007341 LAW OFFICE OF MAGGIE JO
12/15/10 NEW ATTORNEY
60 OCEAN BLVD UNIT
11
904- 247 -7600
ATLANTIC BEACH FL
32233
GRAND TOTALS
-------- - - - - --
NEW LICENSES ------- - - ----
AC:
3
PP:
0
IN:
0
VO:
0
PG:
0
BR:
0
OB:
0
UC:
0
LIC:
3