Agenda Item 4ACity of Atlantic Beach
FINANCIAL REPORT
June 2013
AGENDA ITEM # 4A
AUGUST 12, 2013
Cash Balances
Prior Current Dollar Percent
Fund(s) 05/31/13 06/30/13 Change Change
General $7,042,393 $6,908,012 ($134,380) -1.91%
Tree Replacement 6,493 6,493 0 0.00%
Convention Development Tax 74,105 64,287 (9,817) - 13.25%
Local Option Gas Tax 227,789 246,695 18,906 8.30%
Better Jax 1/2 Cent Sales Tax 292,832 313,112 20,280 6.93%
Police Training, Forfeiture, Grants, etc. 160,508 151,569 (8,939) -5.57%
Community Development Block & ARRA Grants 190,275 190,275 0 0.00%
Debt Service 50,702 55,482 4,780 9.43%
Capital Projects 2,783,038 2,727,353 (55,685) - 2.00%
Utility 4,918,672 5,092,158 173,486 3.53%
Sanitation 716,855 701,924 (14,931) - 2.08%
Building Code Enforcement 98,393 99,598 1,205 1.22%
Storm Water 1,560,168 1,566,469 6,302 0.40%
Pension - Police 877 (6,998) (7,875) - 897.63%
Pension - General 381,663 405,550 23,887 6.26%
Total $18,504,762 $18,521,980 $17,218 0.09%
Total Restricted Cash $8,142,259
Total Unrestricted Cash $10,379,721
Cash and Investments
Annual Prior Current Dollar Percent
Account Yield 05/31/13 06/30/13 Change Change
Bank of America - Depository N/A $2,633,068 $3,022,076 $389,009 14.77%
Guggenheim Floating Rate A 5.21% * 1,001,230 993,861 (7,369) -0.74%
Invesco floating Rate A 4.06% * 989,520 981,927 (7,593) -0.77%
Loomis Investment Grade Bond A 3.08% * 1,534,978 1,486,397 (48,581) - 3.16%
Lord Abbett Income A 3.53% * 1,521,270 1,475,630 (45,640) - 3.00%
Delaware Diversified Income Fund 2.31% * 1,684,266 1,636,586 (47,680) - 2.83%
Lord Abbett Short Duration Fund 2.17% * 1,017,614 1,007,395 (10,219) -1.00%
Invesco Corporate Bond A 2.40% * 1,883,521 1,826,368 (57,153) - 3.03%
Pioneer Strategic Income A 3.37% * 1,925,319 1,875,753 (49,566) - 2.57%
Legg Mason WA Cash Reserve Fund N/A 1,001,554 1,001,616 62 0.01 %
Nuveen Total Return Bond Fund A 3.88% * 1,997,230 1,934,784 (62,446) -3.13%
MFS Bond Fund A 1.36% * 1,309,496 1,273,888 (35,608) - 2.72%
MSSB Money Market/Cash 0.00% 2,206 2,206 0 0.00%
SBA - Florida Prime 0.00% * 341 341 0 0.00%
Cash on Hand 0.00% 3,150 3,150 0 0.00%
Subtotal 18,504,762 18,521,980 17,218 0.09%
Police Pension Investments
General Pension Investments
Subtotal
Total
* Denotes the 30 day SEC Yield Anualized
7,430,786 7,333,784 (97,002) -1.31
13,173,805 13,009,016 (164,790) -1.25%
20,604,591 20,342,799 (261,792) -1.27%
$39,109,353 $38,864,779 ($244,574) -0.63%
City of Atlantic Beach
FINANCIAL REPORT
June 2013
Revenues
AGENDA ITEM # 4A
AUGUST 12, 2013
Fund / (Footnote)
Annual
Estimate
YTD - 75% YTD Dollar Percent
of Estimate Actual Variance Variance
General (1) $11,102,740 $8,327,055 $9,097,469 $770,414 9.25%
Convention Development Tax 70,000 52,500 60,876 8,376 15.96%
Local Option Gas Tax 433,655 325,241 308,061 (17,180) -5.28%
Better Jax 1/2 Ct Sales Tax 657,738 493,304 498,653 5,350 1.08%
Police Training, Forfeiture & Grants, etc. 112,645 84,484 85,342 858 1.02%
Grants - (3) 108,866 81,650 240,556 158,907 194.62%
Debt Service 71,900 53,925 52,159 (1,766) -3.27%
Capital Projects 5,000 3,750 (51,513) (55,263) - 1473.68%
Utility - (4) 8,610,929 6,458,197 6,103,434 (354,763) -5.49%
Sanitation 1,814,950 1,361,213 1,335,516 (25,696) -1.89%
Building Code Enforcement - (5) 282,600 211,950 221,276 9,326 4.40%
Storm Water 1,097,430 823,073 799,889 (23,183) -2.82%
Pension - Police (2) 1,233,745 925,309 631,633 (293,676) - 31.74%
Pension - General (2) 2,174,392 1,630,794 1,287,409 (343,385) - 21.06%
Total $27,776,590 $20,832,443 $20,670,762 ($161,681) -0.78%
Analysis of Major Variances
In general, the major variances are the same as reported in the previous month.
Throughout all funds, the variances include a reversal of recent gains in investment
earnings year to date due to the sharp decrease in the fixed income bond market. Most
other revenue categories are near budget estimates.
(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. Also contributing to the large variance is the receipt of the donation for the
land purchase.
(2) The $293,676 negative variance in the Police Employee Pension Fund & the $343,385
negative variance in the General Employee Pension Fund resulted from reductions in
market values of the investments instead of the assumed increase amount.
(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.
(4) Utility sales were well under budget for Year to Date through June for both Water and
Sewer. Base charges are below budget by about 7% and 2% and volume sales are
below projections by about 14% in water and 7% 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 should increase over the summer months.
(5) Building Permit fee revenues continue to run about 6% above projections.
City of Atlantic Beach
FINANCIAL REPORT
June 2013
Expenses
AGENDA ITEM # 4A
AUGUST 12, 2013
Department / (Footnote)
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
Annual YTD - 75%
Estimate of Estimate
YTD
Actual
Dollar Percent
Variance Variance
$42,645
2,470,544
918,977
448,160
5,641,550
406,151
6,175,507
9,285,889
653,056
789,485
$26,831,964
$31,984
1,852,908
689,233
336,120
4,231,163
304,613
4,631,630
6,964,417
489,792
592,114
$20,123,973
$30,877
1,734,268
807,162
301,838
3,692,258
294,452
3,362,615
6,778,008
521,806
639,306
$18,162,590
$1,107 3.46%
118,640 6.40%
(117,929) -17A1 %
34,282 10.20%
538,904 12.74%
10,161 3.34%
1,269,015 27.40%
186,409 2.68%
(32,014) -6.54%
(47,192) -7.97%
$1,961,383
Resource Allocation
Personnel Services (5)
Operating Expenses (2)
Capital Outlay (1) & (2)
Debt Service (4)
Transfers
Annual
Estimate
YTD - 75%
of Estimate
YTD
Actual
Dollar Percent
Variance Variance
$9,666,784
10,227,299
3,089,015
2,519,412
1,329,454
Total $26,831,964
$7,250,088
7,670,474
2,316,761
1,889,559
997,091
$20,123,973
$6,761,282
6,508,316
1,446,740
2,447,863
998,389
$18,162,590
$488,806 6.74%
1,162,158 15.15%
870,021 37.55%
(558,304) - 29.55%
(1,298) -0.13%
$1,961,383
Analysis of Major Variances
In general, the major variances are the same as the previous month. They are as
follows:
(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
Lifeguard expenses have just begun and the deferral of the budgeted expenditures on
the Police Building add to that variance — 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 street paving and project activity budgeted that has not
been completed. The department has spent about 15% 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 43% 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. These seasonal expenses are just now affecting the expenses to
date numbers.
City of Atlantic Beach
FINANCIAL REPORT
June 2013
Project Activity - Current Year Activity Only
AGENDA ITEM # 4A
AUGUST 12, 2013
Project Name
Project
Number
Budget
YTD
Actual
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
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
PM1301
PM1303
PM1302
PW 1301
PW1302
PW1303
PW1304
PW1305
PW1306
$ 60,000 $
YTD
Balance Status
177 59,823 DE
177 $ 59,823
9,282
88,762
15,591
36,962
201,657
188,115
41,500
55,000
90,000
180,000
40,000
55,000
86,000
56,000
18,435
202,300
7,173
84,280
15,591
34,121
190,620
8,140
8,148
16,321
19,891
18,435
189,669
2,109 C
4,482 C
0 C
2,841 C
11,037 C
179,975
41,500
55,000
81,852
163,679
40,000
35,109 C
86,000
56,000
0
12,631 C
$ 1,364,604 $ 592,389 $ 772,215
38,700
34,000
225,000
79,064
10,000
32,000
4,600
33,000
360,000
6,618
26,090
18,500
6,041
24,896
4,600
25,669
6,527
32,082
7,910 E
206,500 E
79,064 E
3,959
7,104 B
0 C
7,331 C
353,473 E
$ 816,364 $ 118,941 $ 697,423
$2,240,968 $ 711,507 $1,529,462
E - Design Phase
I - Project In- progress
N - Complete /Non - Capital
R - Re- budget Next Fiscal Year OR Re- Evaluated
X - Project Cancelled
BUILDING DEPT. MONTHLY ACTIVITY REPORT
COMPARISON REPORT
REPORT FOR THE MONTH JUNE 2013
COMPARISION 2012 - 2013
PERMIT TYPE
NUMBER OF
YTD 2012
12
PERMITS
YTD 2013
8
YTD 2012
$ 3,682,970.00
YTD 2013
$1,269,300.00
TOTAL INSPECTIONS
YTD 2012
YTD 2013
SINGLE FAMILY
DUPLEX
0
0
$ -
$0.00
REMODEL/ADDITIONS
146
147
$ 2,989,413.00
$1,845,798.00
COMMERCIAL NEW
0
0
$ -
$ -
OTHER
975
1134
$ 6,501,450.00
$ 4,584,764.00
TOTAL
1133
1289
$ 13,173,833.00
$7,699,862.00
2101
2561
PERMITS
NO.PERMITS
2
ISSUED FOR
PERMIT COST
$ 1,190.00
THE MONTH
OF JUNE 2013
CONSTRUCTION VALUE
$ 559,750.00
INSPECTIONS PERFORMED
BUILDING
169
SINGLE FAMILY
NEW DUPLEX MULTI FAM
0
$ -
$ -
ELECTRICAL
80
RESIDENTIAL ADDITIONS
14
$ 1,145.00
$ 73,878.00
PLUMBING
64
COMMERCIAL NEW
0
$ -
$ -
MECHANICAL
85
COMERCIAL ADDITIONS
0
$ -
$ -
MISC.
17
COMMERCIAL ALTERATIONS
2
$ 130.00
$ 5,300.00
PERMITS MISC
6
$ 680.00
®$
-
TOTAL
415
ELECTRICAL
31
$ 2,604.00
$ -
MECHANICAL GAS
4
$ 375.00
$ -
MECHANICAL HVAC
43
$ 4,391.00
®$
-
PLUMBING
25
$ 1,977.00
-
$ -
ROOFING
14
$ 1,375.00
$ -
WINDOW /DOOR
12
$ 840.00
-
$ -
DEMOLITION
2
$ 200.00
-
$ -
REINSPECTION FEES
1
$ 55.00
-
$ -
PERMIT RENEWALS
0
$ -
$ -
OCCUPANCY INSPECTIONS
9
$ 900.00
$ -
PENALTY FEES
1
$ 130.00
$ -
-�
SIGNS
6
$ 440.00
$ -
FENCES
10
$ 350.00
$ -
DRIVEWAYS
7
$ 245.00
-
$
WELL
3
$ 233.00
$ -
SNl
JGI
SIDING
6
$ 425.00
$ -
POOL
2
$ 400.00
;
$ -
TOTAL
200
$ 18,085.00
$ 638,928.00
PREPARED 7/11/13,15:02 :44
City of Atlantic Beach
PROGRAM OL122L
AGENDA ITEM # 4A
AUGUST 12, 2013
LICENSE ACTIVITY REPORT BY BUSINESS NAME
NEW LICENSES FOR ALL YEARS BETWEEN: 06/01/13 TO 06/30/13
DEPT: ALL DEPARTMENTS CLASS: ALL CLASSES
LIC # BUSINESS NAME
ISSUED TYPE CLASSIFICATION
13- 00007691 ADESSA DESIGNERS
13- 00007692 ADESSA DESIGNERS
13- 00007693 ADESSA DESIGNERS
13- 00007694 ADESSA DESIGNERS
13- 00007695 ADESSA DESIGNERS
6/14/13 NEW
6/14/13 NEW
6/14/13 NEW
6/14/13 NEW
6/14/13 NEW
COSMETOLOGY SALON
COSMETOLOGIST
COSMETOLOGIST
COSMETOLOGIST
COSMETOLOGIST
13- 00007707 AMERICAN WELL & IRRIGATION,INC 6/06/13 NEW MISCELLANEOUS SALES, OTHER THAN LIST
13- 00007710 ARM SECURITY, INC.
13- 00007711 ARM SECURITY, INC.
13- 00007712 ARM SECURITY, INC.
13- 00007713 ARM SECURITY, INC.
13- 00007714 ARM SECURITY, INC.
13- 00007715 ARM SECURITY, INC.
13- 00007716 ARM SECURITY, INC.
13- 00007717 ARM SECURITY, INC.
13- 00007719 ARM SECURITY, INC.
13- 00007720 ARM SECURITY, INC.
13- 00007734 CUSTOM ADDICTION HYDROGRAPHICS
13- 00007722 SALON PS FLORIDA LLC
13- 00007723 SALON PS FLORIDA LLC
13- 00007665 SCRUBS RESIDENTIAL AND COMMERC
GRAND TOTALS
NEW LICENSES
AC: 17
PP: 3
IN: 0
VO: 0
PG: 0
BR: 0
OB: 0
UC: 0
LIC: 20
6/07/13 NEW
6/07/13 NEW
6/07/13 NEW
6/07/13 NEW
6/07/13 NEW
6/07/13 NEW
6/07/13 NEW
6/07/13 NEW
SOLICITATION, DOOR TO DOOR
SOLICITATION, DOOR TO DOOR
SOLICITATION, DOOR TO DOOR
SOLICITATION, DOOR TO DOOR
SOLICITATION, DOOR TO DOOR
SOLICITATION, DOOR TO DOOR
SOLICITATION, DOOR TO DOOR
SOLICITATION, DOOR TO DOOR
6/07/13 NEW SOLICITATION, DOOR TO DOOR
6/07/13 NEW SOLICITATION, DOOR TO DOOR
6/17/13 NEW SCREEN PRINTING
6/10/13 NEW COSMETOLOGY SALON
6/10/13 NEW COSMETOLOGY SALON
6/06/13 NEW CLEANING /JANITORIAL /MAID SERVICE
Gallons Actual Revenue
Accounts 0000 Revenue Per 1,000 gi',
Gallons Actual Revenue
0000 Revenue Per 1,000 gl
51.418 $251,594
17.953 $194,471
69.371 $446,065
$4.89
$10.83
$6.43
Gallons Actual Revenue
0000 Revenue Per 1,000 gl
54.576 $416,649 $7.63
54.576 $416,649 $7.63
5,213 32,198 $242,820 $7.54
2,364 18,118 $173,829 $9.59
7,577 50,316 $416,649 $8.28
Gallons Actual Revenue
Accounts 0000 Revenue Per 1,000 gl
5,207 34,323 $251,594 $7.33
2,344 21,321 $194,471 $9.12
7,551 55,644 $446,065 $8.02
5,627 39,124 $146,186
2,473 16,148 $84,059
$3.74
$5.21
8,100 55,272 $230,245 $4.17
Gallons Actual Revenue
Accounts 0000 Revenue Per 1,000 gl
5,630 44,237 $162,564 $3.67
2,446 19,261 $98,866 $5.13
8,076 63,498 $261,430 $4.12
AGENDA ITEM # 4A
AUGUST 12, 2013
City of Atlantic Beach, FI,
Utility Sales Report
June 2013
Water Sales
Gallons Actual Revenue
Accounts 0000 Revenue Per 1,000 gl
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
Gallons
0000
59,267
6,289
65,556
55,272
10,284
15.69%
11.68%
Sewer Sales
Atlantic Beach
Buccaneer
Total Sewer Sales
Sewer Treatment
Atlantic Beach
Total Sewer Treated
June 2012
Gallons
0000
48,316
18,879
67,195
63,498
3,697
5.50%
15.89%