Agenda Item 4ACity of Atlantic Beach
FINANCIAL REPORT
January 2013
AGENDA ITEM # 4A
MARCH 11, 2013
Fund
General
Tree Replacement
Convention Development Tax
Local Option Gas Tax
Better Jax 1/2 Cent Sales Tax
Police Training, Forfeiture, Grants, etc.
Community Development Block & ARRA Grants
Debt Service
Capital Projects
Utility
Sanitation
Building Code Enforcement
Storm Water
Pension - Police
Pension - General
Account
Prior
Current
12/31/12
01/31/13
$7,991,395
$81074,639
63493
61493
52$752
45,947
128,150
1505447
1763438
2017548
162,351
153,147
432352
24,398
22,595
28,509
21779,886
21779,578
51076,295
51292,407
669,664
696,171
84,364
89,416
11335,577
15394,928
16,315
13,034
158,294
1973023
Dollar
Change
$83,244
0
(6,805)
22,296
25,110
(9,204)
(18,954)
5,914
(307)
216,112
26,508
5,051
59,351
(3,281)
38,729
Percent
Change
1.04%
0.00%
- 12.90%
17.40%
14.23%
-5.67%
- 43.72%
26.17%
-0.01%
4.26%
3.96%
5.99%
4.44%
-20.11%
24.47%
Total $18,7033921 $19,147,685 $4433764 237%
Total Restricted Cash $7,953,764
Total Unrestricted Cash $11,193,920
Bank of America - Depository
Columbia US Government MTG A
Eaton Vance Government Obligations A
Loomis Investment Grade Bond A
Loomis Sayles Limited Gov an Agency
Lord Abbett Income A
Delaware Diversified Income Fund
Lord Abbett Short Duration Fund
Invesco Corporate Bond A
Pioneer Strategic Income A
Legg Mason WA Cash Reserve Fund
Nuveen Total Return Bond Fund A
MSSB Money Market/Cash
SBA - Florida Prime
Cash on Hand
Police Pension Investments
General Pension Investments
* Denotes the 30 day SEC Yield Anualized
Cash and Investments
Annual
Yield
0.25%
1.75%
1.63%
2.39%
1.37%
3.60%
2.12%
2.42%
2.34%
3.74%
0.01%
3.84%
0.00%
0.25%
0.00%
Subtotal
Prior
12/31112
$4,881,084
* 997,525
* 113193930
* 115205810
* 997,731
* 115115636
* 116923810
* 11008,489
* 11883,332
* 11883,332
* 11001,069
0
2,691
330
3,150
18,703,921
7,141,666
12,818,102
Subtotal 19,959,768
Current Dollar Percent
01/31/13 Change Change
$3,324,908
1,000,223
1,313,273
1,529,246
995,973
11512,583
1,686,613
1,011,965
1,872,942
11904,700
1,001,180
1,987,910
2,691
328
3,150
19,147,685
73201,786
12, 992, 068
20,193,854
($1,556,177)
2,698
(6,656)
8,436
(1,758)
947
(6,197)
3,476
(10,390)
21,368
111
1,987,910
0
(2)
0
443,764
60,120
173,966
234,086
-1 otal ,. N
- 31.88%
0.27%
-0.50%
0.55%
-0.18%
0.06%
-0.37%
0.34%
-0.55%
1.13%
0.01%
N/A
N/A
-0.53%
0.00%
2.37%
0.84%
1.36%
1.17%
1.75%
// City of Atlantic Beach
FINANCIAL REPORT
January 2013
Fund / (Footnote)
General (1)
Convention Development Tax
Local Option Gas Tax
Better Jax 1/2 Ct Sales Tax
Police Training, Forfeiture & Grants, etc.
Grants - (3)
Debt Service
Capital Projects
Utility - (4)
Sanitation
Building Code Enforcement - (5)
Storm Water
Pension - Police (2)
Pension - General (2)
Total
Revenues
AGENDA ITEM # 4A
MARCH 11, 2013
Annual
Estimate
YTD - 33%
of Estimate
YTD
Actual
Dollar
Variance
Percent
Variance
$101994,301
$3,664,767
$558277764
$2,1625997
59.02%
70,000
23,333
235246
(87)
-0.37%
433,655
144,552
1423481
(21071)
-1.43%
657,738
219,246
212,201
(71045)
-3.21%
109,860
36,620
34,722
(11898)
-5.18%
108,866
36,289
68,960
322672
90.03%
71,900
23,967
23,667
(300)
-1.25%
51000
11667
713
(954)
- 57.22%
81610,929
21870,310
21719,011
(151,299)
-5.27%
1,814,950
604,983
610,781
57798
0.96%
282,600
943200
103,369
91169
9.73%
1,097,430
365,810
369,525
31715
1.02%
11233,745
411,248
256,702
(154,546)
- 37.58%
21174,392
724,797
660,060
64,737
-8.93%
$27,665,366
$9,221,789
$11,0535202
$1,8319414
19.86%
Analysis of Major Variances
(1) The positive variance in the General Fund is mostly a result of having received property
taxes. Those taxes began to arriving in November. The bulk of the receipts came in
December.
(2) The $154,546 negative variance in the Police Employee Pension Fund & the $64,737
negative variance in the General Employee Pension Fund resulted from changes in
market values of the investments of less than the assumed amount..
(3) Grant revenues are higher than the budget because C.D.B.G. grant proceeds related to
last year's grant expenditures were received this year.
(4) Utility sales were slightly under budget for Year to Date through January for both Water
and Sewer.
(5) Building Permit activity is running above projected revenues.
City of Atlantic Beach AGENDA ITEM # 4A
FINANCIAL REPORT MARCH II, 2013
January 2013
Department / (Footnote)
Governing Body
City Administration
General Government (2)
Planning and Building
Public Safety (1)
Recreation and Special Events
Public Works (3)
Public Utilities (4)
Pension - Police
Pension - General
Total
Annual YTD - 33% YTD Dollar Percent
Estimate of Estimate Actual Variance Variance
$42,645 $14,215 $13,327 $888 6.25%
21376,735 792,245 783,580 81665 1.09%
811,922 2705641 527,971 (257,330) - 95.08%
443,666 147,889 141,031 61858 4.64%
51589,489 11863,163 11586,970 276,193 14.82%
3973376 132,459 138,799 (61340) -4.79%
61053,366 21017,789 11577,746 440,043 21.81%
91351,075 33117,025 31621,679 (504,654) - 16.19%
653,056 217,685 222,139 (41454) -2.05%
789,485 263,162 298,133 (34,971) - 13.29%
$26,508,815 $8,836,272 $89911,375 ($75,103)
Annual
YTD - 33%
YTD
Dollar
Percent
Resource Allocation Estimate
of Estimate
Actual
Variance
Variance
Personnel Services (5) $9,5493191 $3,183,064 $2,8823636 $300,428 9.44%
Operating Expenses (2) 10,130,872 31376,957 21888,523 488,434 14.46%
Capital Outlay (1) & (2) 21985,082 995,027 925,084 69,943 7.03%
Debt Service (4) 21519,412 839,804 1,773,714 (933,910) -111.21%
Transfers 15324,258 441,419 441,418 1 0.00%
Total $26,508,815 $8,836,272 $8,9113375 ($751103)
Analysis of Major Variances
(1) The positive variance in the Public Safety divisions is primarily due to not having paid for
the second quarter of the fire services contract with Jacksonville. This is about 249,000.
Also the deferral of the budgeted expenditures on the Police Building adds to that
variance - see Project Activity Schedule.
(2) The negative variance in General Government results from the purchase of land in
November for $225,422.
(3) The variance in the Public Works Department is due to project activity budgeted that
has not been completed. - see Project Activity Schedule.
(4) The negative variance in the Public Utilities divisions results from paying the majority of
the annual debt service payments on October 1, 2012.
(5) The positive variance in the Personnel Services resulted from vacant positions that
have not been filled. The City budgets full employment, so any vacancy contributes to a
positive variance. The Lifeguards are typically seasonal employees working May through
September.
City of Atlantic Beach
FINANCIAL REPORT
January 2013
Project Activity = Current Year Activity Only
Project YTD
Project Name Number Budget Actual
Public Safety
Police Building Renovation /Design /Construction PS0504
Public Utilities:
60,000
AGENDA ITEM # 4A
MARCH 11, 2013
YTD
Balance Status
0 60,000
$ 60,000 $ - $ 60,000
TMDL - Lift Station /Main Transfer Flow
PU0906
91282
11716
71566 c
TMDL Upgrade /Construction - WWTP #1
PU1106
1473862
633200
84,662 c
TMDL Sludge /Odor Improvements
PU1110
PM1301
1445606
15,261
129,345 c
Water Main -12th Street at Ocean Blvd /Beach Ave
PU1204
PM1303
36,962
16,673
20,288 1
Water Main -14th & 15th Street at Ocean Boulevard
PU1205
PM1302
201,657
96,364
105,292 1
Rehab of Interior of Tank #1
PU1301
PW1301
45,000
79,064
44,999 I
Rehab of Ground Storage Tank #2
PU1302
PW1302
20,000
25,000
19,999 I
Recoat Both Ground Storage Tanks WP #3
PU1303
PW1303
40,000
32,000
39,999 I
Replace the Water Main on Pine Street
PU1304
PW1304
903000
21648
87,351 I
Replace 4" Water ?Main at Wonderwood and Finegan
PU1305
PW 1305
180,000
51304
174,695 I
PT Repair at Lift Station C
PU1306
PW1306
407000
360,000
39,999 I
PT Repair at West 6th and Stock
PU1307
55,000
54,999 I
Repair 24" Effluent Force Main
PU1308
86,000
85,999 I
Repair 12" Force Main
PU1309
56,000
55,999 I
Replace Yard Pump
PU1310
187435
18,434 I
Sewer Rehabilitation 2013
PU1311
202,300
2022299 I
Status Key
A - Bid Advertised
B - Bid Awarded
C - Project Completed
D - Design Completed
DE - Deferred
Subtotal $ 831,364 $ 13,145 $ 818,219
Total $21264,468 $2143312 $2,050,146
E - Design Phase
I - Project In- progress
N - Complete /Non - Capital
R - Re- budget Next Fiscal Year
X - Project Cancelled
Subtotal
$ 1,373,104 $
201,168
$ 11171,926
Public Works:
Marsh Master Plan Signs
PM1301
38,700
38,700 I
Marsh Master Plan Project Design
PM1303
34,000
61800
27,200 c
Rose Park Development
PM1302
225,000
57888
219,112 1
Dutton Island Road Sidewalks
PW1301
79,064
79,064 I
Sidewalk and Curb Replacements
PW1302
25,000
457
24,543 1
City Hall Parking Lot Lights
PW1303
32,000
32,000 I
Irregation Improvements Atlantic Blvd.
PW1304
41600
4,600 1
Sidewalk on West 9th Street
PW 1305
33,000
33,000 I
East Coast Drive Drainage Improvements
PW1306
360,000
360,000 I
Status Key
A - Bid Advertised
B - Bid Awarded
C - Project Completed
D - Design Completed
DE - Deferred
Subtotal $ 831,364 $ 13,145 $ 818,219
Total $21264,468 $2143312 $2,050,146
E - Design Phase
I - Project In- progress
N - Complete /Non - Capital
R - Re- budget Next Fiscal Year
X - Project Cancelled
AGENDA ITEM # 4A
MARCH 11, 2013
PREPARED 3/04/13, 8:36:05 LICENSE ACTIVITY REPORT BY BUSINESS NAME
City of Atlantic Beach NEW LICENSES FOR YEAR: 2013 BETWEEN: 02/01/13 TO 02/28/13
PROGRAM OL122L DEPT: ALL DEPARTMENTS CLASS: ALL CLASSES
---------- -------------- -------------- -------------------------------- ----------- -----------------------
-----
LIC # BUSINESS NAME ISSUED TYPE CLASSIFICATION
BUSINESS ADDRESS BUS PHONE
---------------------------------------------------------------------------------------------------------
13- 00007657 ALANIA BOYLES PARKER
751 ATLANTIC BLVD 755,
ATLANTIC BEACH FL 32233
13- 00007659 A1A WOODWORKS
605 PLAZA
ATLANTIC BEACH FL 32233
13- 00007658 LA FITNESS
1021 ATLANTIC BLVD
ATLANTIC BEACH FL 32233
13- 00007660 MRHARDING ENTERPRISES INC
635 JASMINE ST
ATLANTIC BEACH FL 32233
13- 00007653 RICHARDS FURNITURE
1079 ATLANTIC BLVD 4
ATLANTIC BEACH FL 32233
13- 00007661 US ONE MM ONE INC.
317 2ND ST
ATLANTIC BEACH FL 32233
13- 00007649 VINTAGE BARBER SHOP LLC
1021 ATLANTIC BLVD
ATLANTIC BEACH FL 32233
13- 00007654 VINTAGE BARBER SHOP LLC
1021 ATLANTIC BLVD
ATLANTIC BEACH FL 32233
13- 00007655 VINTAGE BARBER SHOP LLC
1021 ATLANTIC BLVD
ATLANTIC BEACH FL 32233
13- 00007656 VINTAGE BARBER SHOP LLC
1021 ATLANTIC BLVD
ATLANTIC BEACH FL 32233
GRAND TOTALS
-------- - - - - --
NEW LICENSES ------- - - - - --
AC:
10
PP:
0
IN:
0
VO:
0
PG:
0
BR:
0
OB:
0
UC:
0
LIC:
10
2/19/13 NEW MASSAGE THERAPIST
A . {
904 - 874 -0299
2/19/13 NEW MISC. SERVICE ESTABLISHMENT, NOT LIS
904 - 382 -8321
2/19/13 NEW HEALTH SPA /GYM
904- 853 -2210
2/19/13 NEW MISC. SERVICE ESTABLISHMENT, NOT LIS
904- 352 -6064
2/19/13 NEW FURNITURE SALES
2/26/13 NEW INTERNET SALES
2/19/13 NEW BARBER SHOP
2/19/13 NEW BARBER
2/19/13 NEW BARBER
2/19/13 NEW COSMETOLOGIST
904 - 249 -3541
904 - 253 -0263
904 - 303 -5864
904 - 303 -5864
904 - 303 -5864
904 - 303 -5864