Agenda Item 4ACity of Atlantic Beach
FINANCIAL REPORT
August 2013
AGENDA ITEM # 4A
OCTOBER 14, 2013
Cash Balances
Prior Current Dollar Percent
Fund(s) 07/31/13 08/31/13 Change Change
General $6,912,273 $6,529,285 ($382,988) -5.54%
Tree Replacement 6,493 6,493 0 0.00%
Convention Development Tax 81,853 88,590 6,737 8.23%
Local Option Gas Tax (25,963) (2,483) 23,480 - 90.44%
Better Jax 1/2 Cent Sales Tax 345,925 390,071 44,146 12.76%
Police Training, Forfeiture, Grants, etc. 154,310 150,374 (3,936) -2.55%
Community Development Block & ARRA Grants 0 0 0 0.00%
Debt Service 61,810 67,231 5,421 8.77%
Capital Projects 2,745,606 2,725,534 (20,072) -0.73%
Utility 5,351,538 5,712,233 360,695 6.74%
Sanitation 723,823 676,870 (46,953) -6.49%
Building Code Enforcement 104,897 118,960 14,063 13.41%
Storm Water 1,618,039 1,641,438 23,398 1.45%
Pension - Police 12,239 94,615 82,376 673.05%
Pension - General 2,620 36,708 34,087 1300.87%
Total $18,095,462 $18,235,919 $140,456 0.78%
Total Restricted Cash $7,875,030
Total Unrestricted Cash $10,360,889
Cash and Investments
Annual Prior Current Dollar Percent
Account Yield 07/31/13 08/31/13 Change Change
Bank of America - Depository N/A $2,470,959 $2,741,200 $270,240 10.94%
Guggenheim Floating Rate A 3.94% * 1,002,832 2,172,238 1,169,405 116.61%
Invesco Floating Rate A 3.73% * 992,614 2,490,016 1,497,402 150.85%
Loomis Investment Grade Bond A 3.12% * 1,505,306 1,001,363 (503,943) - 33.48%
Lord Abbett Income A 4.17% * 1,486,940 472,380 (1,014,560) - 68.23%
Delaware Diversified Income Fund 2.77% * 1,645,284 498,704 (1,146,581) - 69.69%
Lord Abbett Short Duration Fund 2.51% * 1,012,790 1,011,554 (1,236) -0.12%
Invesco Corporate Bond A 3.47% * 1,842,956 331,843 (1,511,113) - 81.99%
Pioneer Strategic Income A 3.74% * 1,887,730 1,014,685 (873,045) - 46.25%
Legg Mason WA Cash Reserve Fund 0.08% 1,001,684 1,001,749 65 0.01%
Nuveen Total Return Bond Fund A N/A 1,956,699 0 (1,956,699) - 100.00%
MFS Bond Fund A N/A 1,283,971 0 (1,283,971) - 100.00%
Putnam Diversified Inc. 4.46% * 0 2,500,692 2,500,692 0.00%
Alliance Limited Duration High Income A 3.44% * 0 1,998,106 1,998,106 0.00%
Lord Abbott Floating Rate 4.10% * 0 997,895 997,895 0.00%
MSSB Money Market/Cash 0.00% 2,206 2 (2,204) - 99.93%
SBA - Florida Prime 0.00% 341 344 4 1.05%
Cash on Hand 0.00% 3,150 3,150 0 0.00%
Subtotal 18,095,462 18,235,919 140,457 0.78%
Police Pension Investments
General Pension Investments
Subtotal
Total
* Denotes the 30 day SEC Yield Anualized
7,427,152 7,341,912 (85,240) -1.15%
13,573,452 13,374,481 (198,971) -1.47%
21,000,604 20,716,393 (284,211) -1.35%
$39,096,066 $38,952,312 ($143,754) -0.37%
City of Atlantic Beach
FINANCIAL REPORT
August 2013
Revenues
AGENDA ITEM # 4A
OCTOBER 14, 2013
Fund / (Footnote)
Annual
Estimate
YTD - 91.7% YTD Dollar Percent
of Estimate Actual Variance Variance
General (1) $11,102,740 $10,177,512 $10,332,419 $154,907 1.52%
Convention Development Tax 87,500 80,208 88,578 8,369 10.43%
Local Option Gas Tax 433,655 397,517 378,410 (19,107) -4.81%
Better Jax 1/2 Ct Sales Tax 657,738 602,927 618,862 15,936 2.64%
Police Training, Forfeiture & Grants, etc. 112,645 103,258 124,154 20,896 20.24%
Grants - (3) 108,866 99,794 240,556 140,762 141.05%
Debt Service 71,900 65,908 63,908 (2,000) -3.03%
Capital Projects 5,000 4,583 (53,331) (57,915) - 1263.59%
Utility - (4) 8,610,929 7,893,352 7,586,027 (307,325) -3.89%
Sanitation 1,814,950 1,663,704 1,638,425 (25,279) -1.52%
Building Code Enforcement - (5) 282,600 259,050 282,305 23,255 8.98%
Storm Water 1,097,430 1,005,978 983,107 (22,871) -2.27%
Pension - Police (2) 1,233,745 1,130,933 841,177 (289,756) - 25.62%
Pension - General (2) 2,173,963 1,992,799 1,480,444 (512,356) -25.71%
Total $27,793,661 $25,477,523 $24,605,040 ($872,483) -3.42%
Analysis of Major Variances
Throughout all funds, the variances resulting from timing are being reduced as we near
year end. The variances include a reversal of prior gains in investment earnings year to
date due to the sharp decrease in the fixed income bond market now down 2.2 %. Most
other revenue categories are near budget estimates except for Public Utilities and the
Pension Plans as described below.
(1) The positive variance in the General Fund is again mostly a result of having received
property taxes early in the year. The bulk of the receipts came in December as
expected. This variance should be eliminated by year end. Also contributing to the large
variance is the receipt of the donation for the land purchase.
(2) The $289,756 negative variance in the Police Employee Pension Fund and the $512,356
negative variance in the General Employee Pension Fund resulted from the increase in
the market values of the investments being much lower than the budget year to date.
(3) Grant revenues are higher than the budget because C.D.B.G. and F.E.M.A. Wind retro -fit
grant proceeds related to last year's grant expenditures were received this year. Those
balances were then used to off -set the funds spent last year bringing the cash balance
back to zero.
(4) Utility sales were well under budget for Year to Date through August for both Water and
Sewer. Base charges are below budget by about 7% and 2% and volume sales are
below projections by about 13% in water and 5% in sewer. These are partially off -set by
the receipt of a rebate from electric energy savings from JEA of $142,066. Water and
sewer volume sales normally increase over the late summer months.
(5) Building Permit fee revenues running about 11% above projections.
City of Atlantic Beach
FINANCIAL REPORT
August 2013
Expenses
AGENDA ITEM # 4A
OCTOBER 14, 2013
Department / (Footnote)
Annual YTD - 91.7%
Estimate of Estimate
YTD
Actual
Dollar
Variance
Governing Body
City Administration (2)
General Government (2)
Planning and Building
Public Safety (1,5 )
Recreation and Special Events
Public Works (3)
Public Utilities (4)
Pension - Police
Pension - General
Total
$42,645
2,474,839
920,977
448,160
5,641,386
406,151
6,209,457
9,255,673
653,056
856,123
$26,908,467
$39,091
2,268,602
844,229
410,813
5,171,271
372,305
5,692,002
8,484,367
598,635
784,779
$24,666,095
$36,845
2,097,882
863,791
370,820
4,710,155
353,456
4,503,040
7,635,394
645,575
845,788
$22,062,746
$2,247
170,720
(19,562)
39,993
461,116
18,849
1,188,963
848,973
(46,941)
(61,008)
$2,603,349
Percent
Variance
5.75%
7.53%
-2.32%
9.74%
8.92%
5.06%
20.89%
10.01%
-7.84%
-7.77%
Resource Allocation
Personnel Services (5)
Operating Expenses (2)
Capital Outlay (1) & (2)
Debt Service (4)
Transfers
Annual
Estimate
YTD - 91.7%
of Estimate
YTD
Actual
Dollar Percent
Variance Variance
$9,658,810
10,290,417
3,110,374
2,519,412
1,329,454
Total $26,908,467
$8,853,909
9,432,882
2,851,176
2,309,461
1,218,666
$24,666,095
$8,322,597
8,455,403
1,617,783
2,447,863
1,219,099
$531,312 6.00%
977,479 10.36%
1,233,393 43.26%
(138,402) -5.99%
(432) -0.04%
$22,062,746 $2,603,349
Analysis of Major Variances
Overall, the major variances are the result of capital projects that have been postponed
or are behind schedule. Variances are created when the actual funds spent to date are
different from the percentage of the budget elapsed to date. Some of the variances are
described below.
(1) The positive variance in the Public Safety divisions is partly due to paying for the fire
contract services quarterly to Jacksonville. This is about $249,000 per quarter. The
Patrol and Dispatch divisions have had vacant positions and the Lifeguard expenses
have now been expended but there are some salary budgets unexpended in the police
patrol and dispatch divisions. The budgeted expenditures on the Police Building add to
that variance since the project is on hold. — see Project Activity Schedule.
(2) The positive variance in City Administration results from various small amounts in
Finance, City Clerk and IT for items not yet spent. The negative variance in General
Government results from the purchase of land in November and in March totaling
$328,665. 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 various contracted service
items not fully underway such as the Dutton Island Road sidewalks or the Rose Park
project that have not been started. The department has spent about 34% of its project
budget — see Project Activity Schedule.
(4) The positive variance in Public Utilities results from paying the majority of the annual
debt service payments and insurance early in the year creating a negative variance that
by this report has been overcome by savings in personnel and operating expenses. Also
lower than budgeted capital expenditures year to date has contributed to the positive
variance. The department has spent approximately 48% of its project budget.
(5) The positive variance in the Personnel Services results 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 June
through September. This includes vacancies in Planning, Police Patrol and recently
Human Resources.
City of Atlantic Beach
FINANCIAL REPORT
August 2013
Project Activity - Current Year Activity Only
AGENDA ITEM # 4A
OCTOBER 14, 2013
Project Name
Project
Number
Budget
YTD
Actual
YTD
Balance Status
Public Safety
Police Building Renovation /Design /Construction
Public Utilities:
TMDL - Lift Station /Main Transfer Flow
TMDL Upgrade /Construction - WWTP #1
TMDL Sludge /Odor Improvements
Water Main - 12th Street at Ocean Blvd /Beach Ave
Water Main - 14th & 15th Street at Ocean Boulevard
Reclaim Water Plant
Rehab of Interior of Tank #1
Recoat Both Ground Storage Tanks WP #3
Replace the Water Main on Pine Street
Replace 4" Water ?Main at Wonderwood and Finegan
PT Repair at Lift Station C
PT Repair at West 6th and Stock
Repair 24" Effluent Force Main
Repair 12" Force Main
Replace Yard Pump
Sewer Rehabilitation 2013
Subtotal
Public Works:
Marsh Master Plan Signs
Marsh Master Plan Project Design
Rose Park Development
Marsh Path at Tideviews
Dutton Island Road Sidewalks
Sidewalk and Curb Replacements
City Hall Parking Lot Lights
Irregation Improvements Atlantic Blvd.
Sidewalk on West 9th Street
East Coast Drive Drainage Improvements
Subtotal
Total
Status Key
A - Bid Advertised
B - Bid Awarded
C - Project Completed
D - Design Completed
DE - Deferred
PS0504 60,000
PU0906
PU1106
PU1110
PU1204
PU1205
PU0805
PU1301
PU1303
PU1304
PU1305
PU1306
PU1307
PU1308
PU1309
PU1310
PU1311
PM 1301
PM1303
PM1302
PM1304
PW 1301
PW 1302
PW 1303
PW 1304
PW 1305
PW 1306
$ 60,000 $
0 60,000 DE
$ 60,000
9,282 9,282
88,762 88,762
15,591 15,591
36,962 34,121
201,657 190,620
188,115 50,100
41,500 0
55,000 0
90,000 8,148
180,000 16,321
17,000 0
55,000 19,891
86,000 2,591
56,000 1,656
18,435 18,435
202,300 189,669
0
0
0
2,841
11,037
138,015
41,500
55,000
81,852
163,679
17,000
35,109
83,409
54,344
0
12,631
$ 1,341,604 $ 645,188 $ 696,416
38,700
34,000
225,000
35,000
79,064
10,000
32,000
4,600
33,000
361,200
6,618
29,490
19,750
0
0
6,041
24,896
4,600
25,669
17,800
32,082
4,510
205,250
35,000
79,064
3,959
7,104
0
7,331
343,400
$ 852,564 $ 134,864 $ 717,700
$2,254,168 $ 780,052 $1,474,117
E - Design Phase
I - Project In- progress
N - Complete /Non - Capital
R - Re- budget Next Fiscal Year OR Re- Evaluated
X - Project Cancelled
C
C
C
C
C
E
C
C
A
A
I
C
R
R
C
C
I
E
A
E
I
C
C
C
C
BUILDING DEPT. MONTHLY ACTIVITY REPORT
COMPARISON REPORT
REPORT FOR THE MONTH AUGUST 2013
COMPARISION 2012 - 2013
I PERMIT TYPE NUMBER OF PERMITS TOTAL INSPECTIONS I
YTD 2012 YTD 2013 YTD 2012 YTD 2013 YTD 2012 YTD 2013
PERMITS ISSUED FOR THE MONTH OF AUGUST 2013
NO.PERMITS PERMIT COST CONSTRUCTION VALUE INSPECTIONS PERFORMED
Mll_i1
OCTOBER
V LA
11 1,1Y1
I4,
TT
2013
T!]
in
M
M
M
55
64
70
N
3124
ELECTRICAL
PLUMBING
MECHANICAL
MISC.
TOTAL
0
OEA
$3,021,157.00
'
40
$ 5,786,152.00
$13,357,609.00
'
40
0 ' • 0
h O
ED 0
CO OM)
Eli 40 EA EA
700.00
EA
EA
ER
Efl
EA
00
000EO
r
M
T-
40
0
0
r
EA
'
EA
'
ER
' '
E9 40
0
0
0
N
N
40
'
EA
'
Eli
'000
00
10
r
40 40
0
r
r
Eli
r
N
a)
ti
4
40
l
EA
$ 3,164,337.00
Eft
$ 7,235,444.00
$ 17,474,826.00
'
40
0 0
0' "0
N 00
(■ co
CO
M
40 40 40 40
125.00 I
00
00
MO
r00
O
M
El}
N
EA
$ 4,219.00
0000
0000
E000
ti
N
EA
N
CO.,
r
El}
100
)n0
N M
r
40 40
'
EA
'
40
0 0
0000
0NOO
0r�•cl•
N d:,
r r
EA EA
0
r
40
0
r
40
1 $ 175.00
0
' 0
600
'0'
N
EA ER
0
0
NI'
ER
0
0
M
h
E'M
N
40
0
00)
r
N
•i'I
N
r
1744 C
0
M 0 0 N
CO
j 40
M
N,
N co
0
0
M
N
In
0 E°)
MI
230
0
Q)
r
O
n
Al
r
1586
SINGLE FAMILY
DUPLEX
REMODEL/ADDITIONS
COMMERCIAL NEW
OTHER
TOTAL
(SINGLE FAMILY
INEVV DUPLEX MULTI FAM
RESIDENTIAL ADDITIONS
COMMERCIAL NEW
COMERCIAL ADDITIONS
COMMERCIAL ALTERATIONS
PERMITS MISC
ELECTRICAL
MECHANICAL GAS
MECHANICAL HVAC
PLUMBING
ROOFING
WINDOW /DOOR
DEMOLITION
REINSPECTION FEES
PERMIT RENEWALS
OCCUPANCY INSPECTIONS
PENALTY FEES
SIGNS
FENCES
IDRIVEWAYS
Z
W CI
C7)
0
0-
TOTAL
PREPARED 9/13/13, 9:47:29
City of Atlantic Beach
PROGRAM OL122L
AGENDA ITEM # 4A
OCTOBER 14, 2013
LICENSE ACTIVITY REPORT BY BUSINESS NAME
NEW LICENSES FOR ALL YEARS BETWEEN: 08/01/13 TO 08/31/13
DEPT: ALL DEPARTMENTS CLASS: ALL CLASSES
LIC # BUSINESS NAME
BUSINESS ADDRESS
ISSUED TYPE CLASSIFICATION
BUS PHONE #
13- 00007804 AIR WAVES HEATING AND COOLING
97 LEVY RD 103
ATLANTIC BEACH FL 32233
13- 00007805 AIR WAVES HEATING AND COOLING
97 LEVY RD 103
ATLANTIC BEACH FL 32233
13- 00007753 B R AUTO SERVICE
97 LEVY RD 147
ATLANTIC BEACH FL 32233
13- 00007817 BEACH FRAMES LLC
1089 ATLANTIC BLVD 25
ATLANTIC BEACH FL 32233
13- 00007818 BEACH FRAMES LLC
1089 ATLANTIC BLVD UNIT 02
ATLANTIC BEACH FL 32233
13- 00007788 BEST WESTERN
2389 MAYPORT RD
ATLANTIC BEACH FL 32233
13- 00007775 FANCY NAILS, INC.
363 ATLANTIC BLVD UNIT 10
ATLANTIC BEACH FL 32233
13- 00007776 FANCY NAILS, INC.
363 ATLANTIC BLVD UNIT 10
ATLANTIC BEACH FL 32233
13- 00007803 FOR THE TROOPS, INC.
1864 BEACHSIDE CT
ATLANTIC BEACH FL 32233
12- 00007797 HAMMER TIME ROOFING
627 AQUATIC DR
ATLANTIC BEACH FL 32233
12- 00007800 HAMMER TIME ROOFING
627 AQUATIC DR
ATLANTIC BEACH FL 32233
13- 00007796 METABOLIC RESEARCH CENTER
599 ATLANTIC BLVD UNIT 01
ATLANTIC BEACH FL 32233
13- 00007808 RCM HEALTH CARE SERVICES
60 OCEAN BLVD UNIT 9
ATLANTIC BEACH FL 32233
13- 00007722 SALON PS FLORIDA LLC
1 FLEET LANDING BLVD MAIN
ATLANTIC BEACH FL 32233
8/21/13 NEW AIR CONDITIONING /HEATING (FIRM /CORP.
904- 697 -6313
8/21/13 NEW MISC. CONTRACTOR, OTHER THAN LISTED
904 - 697 -6313
8/02/13 NEW AUTO: SERVICE /REPAIR
904- 265 -8590
8/28/13 NEW MISCELLANEOUS SALES, OTHER THAN LIST
800- 469 -1304
8/28/13 NEW MISCELLANEOUS SALES, OTHER THAN LIST
800 - 469 -1304
8/02/13 NEW HOTEL /MOTEL /ROOMING HOUSES
8/14/13 NEW NAILS /SKIN CARE (FULL SPECIALIST)
8/14/13 NEW NAIL SPECIALIST
904 - 435 -3500
904 - 246 -7070
904 - 246 -7070
8/02/13 NEW MISC. SERVICE ESTABLISHMENT, NOT LIS
904 - 254 -0020
8/14/13 NEW ROOFING CONTRACTOR (FIRM /CORP.)
904 - 716 -9149
8/14/13 NEW MISC. CONTRACTOR, OTHER THAN LISTED
904- 716 -9149
8/14/13 NEW MISCELLANEOUS SALES, OTHER THAN LIST
904 -284 -4021
8/21/13 NEW MISC. SERVICE ESTABLISHMENT, NOT LIS
917 - 286 -5263
8/02/13 NEW COSMETOLOGY SALON
440- 600 -1592
PREPARED 9
City of Atl
PROGRAM OL1
/13/13, 9:47:29
antic Beach
22L
AGENDA ITEM # 4A
OCTOBER 14, 2013
LICENSE ACTIVITY REPORT BY BUSINESS NAME
NEW LICENSES FOR ALL YEARS BETWEEN: 08/01/13 TO 08/31/13
DEPT: ALL DEPARTMENTS CLASS: ALL CLASSES
LIC #
BUSINESS NAME
BUSINESS ADDRESS
ISSUED TYPE CLASSIFICATION
BUS PHONE #
13- 00007723 SALON PS FLORIDA LLC
1 FLEET LANDING BLVD MAIN
ATLANTIC BEACH FL 32233
8/02/13 NEW COSMETOLOGY SALON
440 - 600 -1592
12- 00007807 SANDPIPER ASSET MANAGEMENT, LL 8/21/13 NEW MISC. SERVICE ESTABLISHMENT, NOT LIS
60 OCEAN BLVD UNIT 12 904 -372 -4042
ATLANTIC BEACH FL 32233
13- 00007815 STITCHES & SCREENS,INC.
30 SIMMONS RD UNIT 1
ATLANTIC BEACH FL 32233
8/28/13 NEW MISC. SERVICE ESTABLISHMENT, NOT LIS
904 - 246 -7616
13- 00007802 TNT LANDSCAPE AND LAWN MAINTEN 8/01/13 NEW LAWN /YARD SERVICE
29 W 11TH ST
ATLANTIC BEACH FL 32233
GRAND TOTALS
AC:
PP:
IN:
VO:
PG:
BR:
OB:
UC:
LIC:
NEW LICENSES
18
0
0
0
0
0
0
0
18
904 - 247 -4477
Gallons Actual Revenue
Accounts 0000 Revenue Per 1,000 gI
5,235 31,116 $242,752 $7.80
2,394 20,340 $186,189 $9.15
7,629 51,456 $428,941 $8.34
Gallons Actual Revenue
0000 Revenue Per 1,000 gl
66.885 $257,427
12.967 $187,524
79.852 $444,951
$3.85
$14.46
$5.57
Gallons Actual Revenue
0000 Revenue Per 1,000 gI
53.235 $428,941 $8.06
53.235 $428,941 $8.06
Gallons Actual Revenue
Accounts 0000 Revenue Per 1,000 gl
5,196 35,331 $257,427 $7.29
2,349 20,656 $187,524 $9.08
7,545 55,987 $444,951 $7.95
;Accounts
Gallons Actual Revenue
0000 Revenue Per 1,000 gI
5,615 46,041 $169,430 $3.68
2,456 19,406 $96,451 $4.97
8,071 65,447 $265,881 $4.06
Gallons Actual Revenue
Accounts 0000 Revenue Per 1,000 gI
5,643 40,757 $151,611 $3.72
2,502 17,752 $89,267 $5.03
8,145 58,509 $240,878 $4.12
AGENDA ITEM # 4A
OCTOBER 14, 2013
City of Atlantic Beach, Fl.
Utility Sales Report
Water Sales
Atlantic Beach
Buccaneer
Total Water Sales
Water Plant Production
Atlantic Beach
Buccaneer
Total Production
Total Water Billed
Water Loss for month:
Percentage Loss
Total 12 mo. Avg. Loss
Sewer Sales
Atlantic Beach
Buccaneer
Total Sewer Sales
Sewer Treatment
Atlantic Beach
Total Sewer Treated
August 2013
Gallons
0000
53,819
12,404
66,223
58,509
7,714
11.65%
10.92%
August 2012
Gallons
0000
48,331
19,528
67,859
65,447
2,412
3.55%
15.76%