Agenda Item 4AFund
City of Atlantic Beach AGENDA ITEM # 4A
FINANCIAL REPORT APRIL 8, 2013
February 2013
Cash Balances
Prior
01/31/13
Current
02/28/13
Dollar Percent
Change Change
General
$8,074,639
$7,648,928
($425,711)
-5.27%
Tree Replacement
6,493
6,493
0
0.00%
Convention Development Tax
45,947
57,244
11,297
24.59%
Local Option Gas Tax
150,447
169,506
19,059
12.67%
Better Jax 1/2 Cent Sales Tax
201,548
232,890
31,341
15.55%
Police Training, Forfeiture, Grants, etc.
153,147
169,717
16,570
10.82%
Community Development Block & ARRA Grants
24,398
23,875
(524)
-2.15%
Debt Service
28,509
34,504
5,995
21.03%
Capital Projects
2,779,578
2,785,918
6,339
0.23%
Utility
5,292,407
5,252,691
(39,715)
-0.75%
Sanitation
696,171
692,784
(3,388)
-0.49%
Building Code Enforcement
89,416
91,471
2,056
2.30%
Storm Water
1,394,928
1,442,434
47,506
3.41%
Pension - Police
13,034
3,134
(9,901)
- 75.96%
Pension - General
197,023
233,794
36,771
18.66%
Subtotal
Total $19,147,685
$18,845,382
($302,303)
-1.58%
Total Restricted Cash $7,980,635
Total Unrestricted Cash $10,864,747
Cash and Investments
Annual Prior Current Dollar Percent
Account Yield 01/31/13 02/28/13 Change Change
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
0.25%
$3,324,908
$2,973,805
($351,102)
- 10.56%
1.69% *
1,000,223
1,003,541
3,318
0.33%
1.62% *
1,313,273
1,319,312
6,039
0.46%
2.47% *
1,529,246
1,525,764
(3,482)
-0.23%
1.50% *
995,973
997,666
1,693
0.17%
3.55% *
1,512,583
1,523,619
11,036
0.73%
2.25% *
1,686,613
1,693,272
6,658
0.39%
2.27% *
1,011,965
1,014,982
3,017
0.30%
2.44% *
1,872,942
1,886,670
13,728
0.73%
3.56% *
1,904,700
1,911,581
6,880
0.36%
0.01% *
1,001,180
1,001,274
94
0.01%
3.84%
1,987,910
1,987,726
(184)
N/A
0.00%
2,691
2,691
0
N/A
0.25%
328
328
0
0.12%
0.00%
3,150
3,150
0
0.00%
Subtotal
19,147,685
18,845,382
(302,303)
-1.58%
7,201,786
7,266,401
64,615
0.90%
12,992,068
13,041,365
49,297
0.38%
Subtotal
20,193,854
20,307,766
113,912
0.56%
Total
$39,341,539
$39,153,148
($188,391)
-0.48%
City of Atlantic Beach AGENDA ITEM # 4A
FINANCIAL REPORT APRIL 8, 2013
February 2013
Revenues
Fund / (Footnote)
Annual
Estimate
YTD - 42%
of Estimate
YTD
Actual
Dollar
Variance
Percent
Variance
General (1)
$10,994,301
$4,580,959
$6,375,368
$1,794,409
39.17%
Convention Development Tax
70,000
29,167
36,097
6,930
23.76%
Local Option Gas Tax
433,655
180,690
178,419
(2,271)
-1.26%
Better Jax 1/2 Ct Sales Tax
657,738
274,058
284,966
10,909
3.98%
Police Training, Forfeiture & Grants, etc.
109,860
45,775
58,741
12,966
28.33%
Grants - (3)
108,866
45,361
68,960
23,600
52.03%
Debt Service
71,900
29,958
29,741
(217)
-0.73%
Capital Projects
5,000
2,083
7,052
4,969
238.50%
Utility - (4)
8,610,929
3,587,887
3,382,915
(204,972)
-5.71%
Sanitation
1,814,950
756,229
755,632
(597)
-0.08%
Building Code Enforcement - (5)
282,600
117,750
127,194
9,444
8.02%
Storm Water
1,097,430
457,263
464,927
7,665
1.68%
Pension - Police (2)
1,233,745
514,060
381,078
(132,982)
- 25.87%
Pension - General (2)
2,174,392
905,997
800,636
105,361
- 11.63%
Total $27,665,366 $11
Analysis of Major Variances
$12,951,726 $1,424,491
(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. Also included is the receipt of the donation for the land purchase.
(2) The $132,982 negative variance in the Police Employee Pension Fund & the $105,361
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 well under budget for Year to Date through February for both Water and
Sewer. Base charges are below budget by about 4% and volume sales are below
projections by about 14% in water and 8% in sewer.
(5) Building Permit fee revenues are running 9% above projections.
12.36%
City of Atlantic Beach
FINANCIAL REPORT AGENDA ITEM
APRIL 8, 2013 3
February 2013
4A SIT=
Department / (Footnote)
Annual
Estimate
YTD - 42%
of Estimate
YTD
Actual
Dollar
Variance
Percent
Variance
Governing Body
$42,645
$17,769
$16,952
$817
4.60%
City Administration
2,376,735
990,306
941,031
49,275
4.98%
General Government (2)
811,922
338,301
548,661
(210,360)
- 62.18%
Planning and Building
443,666
184,861
169,126
15,735
8.51%
Public Safety (1,5 )
5,592,274
2,330,114
1,914,336
415,778
17.84%
Recreation and Special Events
397,376
165,573
163,733
1,840
1.11%
Public Works (3)
6,078,591
2,532,746
1,830,283
702,463
27.74%
Public Utilities (4)
9,351,075
3,896,281
4,215,155
(318,874)
-8.18%
Pension - Police
653,056
272,107
280,619
(8,512)
-3.13%
Pension - General
789,485
328,952
362,721
(33,769)
- 10.27%
Total
$26,536,825
$11,057,010
$10,442,617
$614,393
Annual
YTD - 42%
YTD
Dollar
Percent
Resource Allocation
Estimate
of Estimate
Actual
Variance
Variance
Personnel Services (5)
Operating Expenses (2)
Capital Outlay (1) & (2)
Debt Service (4)
Transfers
Total
$9,549,191
$3,978,830
$3,570,546
$408,284
10.26%
10,156,097
4,231,707
3,626,890
604,817
14.29%
2,987,867
1,244,945
919,693
325,252
26.13%
2,519,412
1,049,755
1,773,714
(723,959)
- 68.96%
1,324,258
551,774
551,774
0
0.00%
$26,536,825
$11,057,010
$10,442,617
$614,393
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.
The Lifeguard expenses have not begun yet and the deferral of the budgeted
expenditures on the Police Building add 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. Another part of this variance is the prepayment of Insurance at
the beginning of the year.
(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 and insurance at the beginning of the year.
(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 AGENDA ITEM #4A
APRIL 8, 2013
February 2013
Project Activity - Current Year Activity Only
Project YTD YTD
Project Name Number Budget Actual Balance Status
Public Safety
PM1301
38,700
38,700 1
Police Building Renovation /Design /Construction
PS0504
60,000
0
60,000
Rose Park Development
PM1302
$ 60,000 $
6,813
218,187 E
-
$ 60,000
79,064
79,064 E
Public Utilities:
PW1302
25,000
5,378
19,622 1
TMDL - Lift Station /Main Transfer Flow
PU0906
9,282
1,716
7,566
TMDL Upgrade /Construction - WWTP #1
PU1106
147,862
63,200
84,662
TMDL Sludge /Odor Improvements
PU1110
144,606
15,261
129,345
Water Main - 12th Street at Ocean Blvd /Beach Ave
PU1204
36,962
16,673
20,289
Water Main - 14th & 15th Street at Ocean Boulevard
PU1205
201,657
96,364
105,293
Rehab of Interior of Tank #1
PU1301
45,000
45,000
Rehab of Ground Storage Tank #2
PU1302
20,000
$1,855,763
20,000
Recoat Both Ground Storage Tanks WP #3
PU1303
40,000
40,000
Replace the Water Main on Pine Street
PU1304
90,000
4,156
85,844
Replace 4" Water ?Main at Wonderwood and Finegan
PU1305
180,000
8,324
171,676
PT Repair at Lift Station C
PU1306
40,000
40,000
PT Repair at West 6th and Stock
PU1307
55,000
55,000
Repair 24" Effluent Force Main
PU1308
86,000
86,000
Repair 12" Force Main
PU1309
56,000
56,000
Replace Yard Pump
PU1310
18,435
18,435
Sewer Rehabilitation 2013
PU1311
202,300
162,823
39,477
Subtotal $ 1,373,104 $ 368,517 $ 1,004,588
Public Works:
Marsh Master Plan Signs
PM1301
38,700
38,700 1
Marsh Master Plan Project Design
PM1303
34,000
8,500
25,500 E
Rose Park Development
PM1302
225,000
6,813
218,187 E
Dutton Island Road Sidewalks
PW 1301
79,064
79,064 E
Sidewalk and Curb Replacements
PW1302
25,000
5,378
19,622 1
City Hall Parking Lot Lights
PW 1303
32,000
32,000 B
Irregation Improvements Atlantic Blvd.
PW 1304
4,600
4,600 C
Sidewalk on West 9th Street
PW 1305
33,000
19,499
13,501 C
East Coast Drive Drainage Improvements
PW 1306
360,000
360,000 R
Subtotal
$ 791,174
$ 831,364
$ 40,190
Total
$1,855,763
$2,264,468
$ 408,707
Status Key
A - Bid Advertised E - Design Phase
B - Bid Awarded I - Project In- progress
C - Project Completed N - Complete /Non - Capital
D - Design Completed R - Re- budget Next Fiscal Year OR Re- Evaluated
DE - Deferred X - Project Cancelled
AGENDA ITEM # 4A
APRIL 8, 2013
PREPARED 4/01/13,10:53:32
LICENSE ACTIVITY REPORT BY BUSINESS NAME
City of Atlantic Beach NEW
LICENSES
FOR YEAR: 2013 BETWEEN: 03/01/13 TO 03/31/13
PROGRAM OL122L
DEPT:
ALL DEPARTMENTS CLASS: ALL CLASSES
----------------------------------------------------------------------------------------------------------------
LIC #
BUSINESS NAME
ISSUED
TYPn
CLASSIFICATION
----------------------------------------------------------------------------------------------------------------
BUSINESS ADDRESS
BUS PHONE #
13- 00007668
ADVANTAGE SIGNS & ADVERTISING,
3/22/13
NEW
PRINTER /PRINT SHOP
31 LEWIS ST
904- 247 -1228
ATLANTIC BEACH FL 32233
13- 00007672
BEACHES LAWN ENFORCEMNT
3/27/13
NEW
LAWN/YARD-SERVICE
1108 VIOLET ST
904 - 708 -3254
ATLANTIC BEACH FL 32233
13- 00007666
BEACHES TUTORING
3/19/13
NEW
MISC. SERVICE ESTABLISHMENT, NOT
LIS
447 ATLANTIC BLVD UNIT 03
904- 994 -1005
ATLANTIC BEACH FL 32233
13- 00007671
CEVICHE JAX
3/26/13
NEW
RESTAURANTS(INC. SNACK BARS & TAKE 0
695 ATLANTIC BLVD
305 -910 -6205
ATLANTIC BEACH FL 32233
13- 00007670
COASTAL ACUPUNCTURE, INC.
3/22/13
NEW
ACUPUNCTURIST
60 OCEAN BLVD
904 - 477 -4898
ATLANTIC BEACH FL 32233
13- 00007663
HIGH POINT DELIVERY
3/11/13
NEW
SOLICITATION, DOOR TO DOOR
OUTSIDE CITY
866- 941 -1492
ATLANTIC BEACH FL 32233
13- 00007662
JOLIVETTE CLEANING SERVICE
3/11/13
NEW
CLEANING /JANITORIAL /MAID SERVICE
680 PALM AVE
904 - 469 -9734
ATLANTIC BEACH FL 32233
13- 00007664
JURIJ P. OZIMKOVSKI
3/11/13
NEW
AUTO: CAR WASH
1110 MAYPORT RD
904 - 742 -0642
ATLANTIC BEACH FL 32233
13- 00007660
MRHARDING ENTERPRISES INC.
3/11/13
NEW
MISC. SERVICE ESTABLISHMENT, NOT
LIS
635 JASMINE ST
904 - 352 -6064
ATLANTIC BEACH FL 32233
13- 00007665
SCRUBS RESIDENTIAL AND COMMERC
3/19/13
NEW
CLEANING /JANITORIAL /MAID SERVICE
554 STOCKS ST
904- 234 -4042
ATLANTIC BEACH FL 32233
Jt
13- 00007667
THE MUSEUM
3/19/13
NEW
MISC. SERVICE ESTABLISHMENT, NOT
LIS
210 MAYPORT RD
904 - 398 -7060
ATLANTIC BEACH FL 32233
13- 00007661
US ONE MM ONE INC.
3/11/13
NEW
INTERNET SALES
317 2ND ST
904- 253 -0263
ATLANTIC BEACH FL 32233
GRAND TOTALS
-------- - - - -
-- NEW LICENSES ------- - - - - --
AC:
11
pp:
1
IN:
0
VO:
0
PG:
0
BR:
0
OB:
0
uc:
0
LIC:
12