Agenda Item 4ACity of Atlantic Beach
FINANCIAL REPORT
July 2013
AGENDA ITEM # 4A
SEPTEMBER 9, 2013
Cash Balances
Fund(s)
Prior Current Dollar Percent
06/30/13 07/31/13 Change Change
General $6,908,012 $6,912,273 $4,261 0.06%
Tree Replacement 6,493 6,493 0 0.00%
Convention Development Tax 64,287 81,853 17,565 27.32%
Local Option Gas Tax 246,695 (25,963) (272,659) - 110.52%
Better Jax 1/2 Cent Sales Tax 313,112 345,925 32,813 10.48%
Police Training, Forfeiture, Grants, etc. 151,569 154,310 2,741 1.81%
Community Development Block & ARRA Grants 190,275 0 (190,275) - 100.00%
Debt Service 55,482 61,810 6,328 11.41%
Capital Projects 2,727,353 2,745,606 18,253 0.67%
Utility 5,092,158 5,351,538 259,379 5.09%
Sanitation 701,924 723,823 21,899 3.12%
Building Code Enforcement 99,598 104,897 5,299 5.32%
Storm Water 1,566,469 1,618,039 51,570 3.29%
Pension - Police (6,998) 12,239 19,237 - 274.90%
Pension - General 405,550 2,620 (402,929) - 99.35%
Total $18,521,980 $18,095,462 ($426,518) - 2.30%
Total Restricted Cash $7,758,566
Total Unrestricted Cash $10,336,896
Cash and Investments
Account
Annual Prior Current Dollar Percent
Yield 06/30/13 07/31/13 Change Change
Bank of America - Depository N/A $3,022,076 $2,470,959 ($551,117) - 18.24%
Guggenheim Floating Rate A 5.02% * 993,861 1,002,832 8,971 0.90%
Invesco Floating Rate A 3.91% * 981,927 992,614 10,687 1.09%
Loomis Investment Grade Bond A 3.16% * 1,486,397 1,505,306 18,909 1.27%
Lord Abbett Income A 4.02% * 1,475,630 1,486,940 11,310 0.77%
Delaware Diversified Income Fund 2.76% 1,636,586 1,645,284 8,698 0.53%
Lord Abbett Short Duration Fund 2.43% • 1,007,395 1,012,790 5,395 0.54%
Invesco Corporate Bond A 2.85% * 1,826,368 1,842,956 16,588 0.91 %
Pioneer Strategic Income A 3.28% • 1,875,753 1,887,730 11,977 0.64%
Legg Mason WA Cash Reserve Fund 0.08% 1,001,616 1,001,684 68 0.01%
Nuveen Total Return Bond Fund A 4.66% * 1,934,784 1,956,699 21,915 1.13%
MFS Bond Fund A 2.05% * 1,273,888 1,283,971 10,083 0.79%
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,521,980 18,095,462 (426,518) - 2.30%
Police Pension Investments
General Pension Investments
Subtotal
Total
* Denotes the 30 day SEC Yield Anualized
7,333,784 7,427,152 93,368 1.27%
13,009,016 13,573,452 564,436 4.34%
20,342,799 21,000,604 657,804 3.23%
$38,864,779 $39,096,066 $231,286 0.60%
City of Atlantic Beach
FINANCIAL REPORT
July 2013
Revenues
AGENDA ITEM # 4A
SEPTEMBER 9, 2013
Fund / (Footnote)
Annual
Estimate
YTD - 83.3% YTD Dollar Percent
of Estimate Actual Variance Variance
General (1) $11,102,740 $9,252,283 $9,734,615 $482,332 5.21%
Convention Development Tax 70,000 58,333 81,842 23,508 40.30%
Local Option Gas Tax 433,655 361,379 342,971 (18,408) -5.09%
Better Jax 1/2 Ct Sales Tax 657,738 548,115 553,717 5,602 1.02%
Police Training, Forfeiture & Grants, etc. 112,645 93,871 120,403 26,532 28.26%
Grants - (3) 108,866 90,722 240,556 149,834 165.16%
Debt Service 71,900 59,917 58,487 (1,430) -2.39%
Capital Projects 5,000 4,167 (33,260) (37,426) - 898.23%
Utility -(4) 8,610,929 7,175,774 6,871,542 (304,232) -4.24%
Sanitation 1,814,950 1,512,458 1,494,556 (17,902) -1.18%
Building Code Enforcement - (5) 282,600 235,500 248,929 13,429 5.70%
Storm Water 1,097,430 914,525 902,870 (11,655) -1.27%
Pension - Police (2) 1,233,745 1,028,121 797,951 (230,170) - 22.39%
Pension - General (2) 2,174,392 1,811,993 1,585,941 (226,052) - 12.48%
Total $27,776,590 $23,147,158 $23,001,120 ($146,038) -0.63%
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. July
earnings did help recover some of the June decline. Most other revenue categories are
near budget estimates. Other variances by fund are 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. Also contributing to the large variance is the receipt of the donation for the
land purchase.
(2) The $230,170 negative variance in the Police Employee Pension Fund & the $226,052
negative variance in the General Employee Pension Fund resulted from increases in the
market values of the investments being lower than budgeted.
(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 July 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 6% 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 7% above projections.
City of Atlantic Beach
FINANCIAL REPORT
July 2013
Expenses
AGENDA ITEM # 4A
SEPTEMBER 9, 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 - 83.3%
Estimate of Estimate
YTD
Actual
Dollar
Variance
$42,645
2,475,244
920,977
448,160
5,641,550
406,151
6,175,507
9,285,889
653,056
789,485
$26,838,664
$35,538
2,062,703
767,481
373,467
4,701,292
338,459
5,146,256
7,738,241
544,213
657,904
$22,365,553
$33,806
1,921,118
827,001
336,615
4,083,693
324,365
4,051,324
7,193,114
540,857
779,703
$20,091,597
$1,732
141,585
(59,521)
36,851
617,599
14,094
1,094,932
545,126
3,356
(121,799)
$2,273,956
Percent
Variance
4.87%
6.86%
-7.76%
9.87%
13.14%
4.16%
21.28%
7.04%
0.62%
-18.51
Resource Allocation
Personnel Services (5)
Operating Expenses (2)
Capital Outlay (1) & (2)
Debt Service (4)
Transfers
Total
Annual
Estimate
YTD - 83.3%
of Estimate
YTD
Actual
Dollar Percent
Variance Variance
$9,664,784
10,228,963
3,096,051
2,519,412
1,329,454
$26,838,664
$8,053,987
8,524,136
2,580,043
2,099,510
1,107,878
$22,365,553
$7,573,236
7,401,823
1,559,931
2,447,863
1,108, 744
$20,091,597
$480,750 5.97%
1,122,313 13.17%
1,020,111 39.54%
(348,353) - 16.59%
(865) -0.08%
$2,273,956
Analysis of Major Variances
In general, the major variances are the same as the previous month. Variances are
created when the actual funds spent to date are different from the percentage of the
budget elapsed to date. 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 now been expended but there are some salary budgets
unexpended in the police 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 35% 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 47% 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
July 2013
Project Activity - Current Year Activity Only
AGENDA ITEM # 4A
SEPTEMBER 9, 2013
Project Name
Project
Number
YTD
Budget 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
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
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
Status Key
A - Bid Advertised
B - Bid Awarded
C - Project Completed
D - Design Completed
DE - Deferred
PS0504
PU0906
PU1106
PU1110
PU1204
P U 1205
PU0805
PU1301
PU1303
PU1304
Finegan PU1305
PU1306
PU1307
PU1308
PU1309
PU1310
PU1311
Subtotal
Subtotal
Total
PM 1301
PM1303
PM1302
PW1301
PW1302
PW1303
PW 1304
PW1305
PW1306
60,000
YTD
Balance Status
60,000 DE
$ 60,000 $
$ 60,000
9,282
88,762
15,591
36,962
201,657
188,115
41,500
55,000
90,000
180,000
17,000
55,000
86,000
56,000
18,435
202,300
9,282
88,762
15,591
34,121
190,620
50,100
0
0
8,148
16,321
0
19,891
0
0
18,435
189,669
0 C
0 C
0 C
2,841 C
11,037 C
138,015 E
41,500 C
55,000 C
81,852 A
163,679 A
17,000
35,109 C
86,000 R
56,000 R
0 C
12,631 C
$ 1,341,604 $ 640,941 $ 700,663
38,700
34,000
225,000
79,064
10,000
32,000
4,600
33,000
361,200
6,618
29,490
19,750
0
6,041
24,896
4,600
25,669
17,800
32,082
4,510 E
205,250 A
79,064 E
3,959
7,104 C
0 C
7,331 C
343,400 C
$ 817,564 $ 134,864 $ 682,700
$2,219,168 $ 775,805 $1,443,364
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 JULY 2013
COMPARISION 2012 - 2013
PERMIT TYPE
NUMBER OF
YTD 2012
17
PERMITS
YTD 2013
8
j
YTD 2012
$ 1,269,300.00
YTD 2013
$12,696,300.00
TOTAL INSPECTIONS
YTD 2012
YTD 2013
SINGLE FAMILY
DUPLEX
0
0
$ -
$0.00
REMODEUADDITIONS
173
166
$ 2,212,482.00
$2,212,482.00
COMMERCIAL NEW
0
2
$ 700,000.00
$ 700,000.00
OTHER
1177
1338
$ 4,603,245.00
$ 4,603,245.00
TOTAL
1367
1514
$ 14,902,751.00
$8,785,027.00
2490
2975
PERMITS
NO.PERMITS
0
ISSUED FOR
PERMIT COST
$ -
THE MONTH
OF JULY 2013
CONSTRUCTION VALUE
$ -
INSPECTIONS PERFORMED
BUILDING
132
SINGLE FAMILY
NEW DUPLEX MULTI FAM
0
$ -
$ -
ELECTRICAL
60
RESIDENTIAL ADDITIONS
19
$ 2,215.00
$ 366,684.00
PLUMBING
62
COMMERCIAL NEW
2
$ 655.00
$ 700,000.00
MECHANICAL
79
COMERCIAL ADDITIONS
0
$ -
$ -
MISC.
81
COMMERCIAL ALTERATIONS
2
$ 265.00
$ 33,000.00
PERMITS MISC
1
$ 80.00
$ -
TOTAL
414
ELECTRICAL
36
$ 3,069.00
$ -
MECHANICAL GAS
3
$ 215.00
$ -
MECHANICAL HVAC
48
$ 4,650.00
$ -
PLUMBING
29
$ 2,652.00
$ -
ROOFING
22
$ 1,835.00
$ 138,519.00
WINDOW /DOOR
17
$ 1,230.00
$ 69,592.00
DEMOLITION
3
$ 300.00
$ -
REINSPECTION FEES
0
$ -
$ -
PERMIT RENEWALS
0
$ -
$ -
OCCUPANCY INSPECTIONS
15
$ 1,400.00
$ -
PENALTY FEES
8
$ 1,370.00
$ -
SIGNS
1
$ 65.00
$ -
FENCES
8
$ 280.00
$ -
DRIVEWAYS
4
$ 140.00
$ -
WELL
2
j $ 150.00
$
vD
'Eh
SIDING
3
$ 455.00
$ 61,000.00
POOL
2
$ 325.00
$ 44,980.00
TOTAL
225
$ 21,351.00
$ 1,413,775.00
PREPARED 8/16/13;17:42:47
City of Atlantic Beach
PROGRAM OL122L
AGENDA ITEM # 4A
SEPTEMBER 9, 2013
LICENSE ACTIVITY REPORT BY BUSINESS NAME
NEW LICENSES FOR ALL YEARS BETWEEN:. 07 /01/13 TO 07/31/13
DEPT: ALL DEPARTMENTS CLASS: ALL CLASSES
LIC # BUSINESS NAME
BUSINESS ADDRESS
ISSUED TYPE CLASSIFICATION
BUS PHONE #
13- 00007729 ALESCH CONTRACTING, INC.
1946 BEACHSIDE CT
ATLANTIC BEACH FL 32233
13- 00007730 ALESCH CONTRACTING, INC.
1946 BEACHSIDE CT
ATLANTIC BEACH FL 32233
13- 00007758
13- 00007732
ARTISTREE STUDIOS, INC.
1089 ATLANTIC BLVD UNIT 30
ATLANTIC BEACH FL 32233
BIG CITY TREE SERVICE, INC
466 STURDIVANT AVE
ATLANTIC BEACH FL 32233
13- 00007741 BRUSH PAINTERS, INC.
1089 ATLANTIC BLVD UNIT 30
ATLANTIC BEACH FL 32233
13- 00007762 DONALD A. PADGETT, P.A.
447 ATLANTIC BLVD UNIT 05
ATLANTIC BEACH FL 32233
13- 00007763 DONALD A. PADGETT, P.A.
447 ATLANTIC BLVD UNIT 05
ATLANTIC BEACH FL 32233
13- 00007784 DWIGHT HOLLER LAWN MAINTENANCE 7/18/13 NEW LAWN /YARD SERVICE
405 ROYAL PALMS DR
ATLANTIC BEACH FL 32233
7/01/13 NEW GENERAL CONTRACTOR (FIRM /CORP.)
7/01/13 NEW GENERAL CONTRACTOR
7/01/13 NEW PAINTING /PAPER HANGING
7/10/13 NEW TREE SERVICE /TREE SURGEON
7/01/13 NEW PAINTING /PAPER HANGING
7/08/13 NEW ACCOUNTANCY FIRM/ CORPORATION
7/08/13 NEW ACCOUNTANT
10- 00007773 FANCY•NAILS, INC.
363 ATLANTIC BLVD UNIT 10
ATLANTIC BEACH FL 32233
10- 00007774 FANCY NAILS, INC.
363 ATLANTIC BLVD UNIT 10
ATLANTIC BEACH FL 32233
13- 00007750 FLORIDA FIRST CAPITAL FINANCE
468 STURDIVANT AVE
ATLANTIC BEACH FL 32233
13- 00007751 HAPPY TRAILS 4X4
490 LEVY RD
ATLANTIC BEACH FL 32233
13- 00007785 JAX DIRTWORKS INC.
310 MEALY DR
ATLANTIC BEACH FL 32233
13- 00007787 JAX DIRTWORKS INC.
310 MEALY DR
ATLANTIC BEACH FL 32233
GRAND TOTALS
'AC:
PP:
IN:
VO:
PG:
BR:
OB:
UC:
LIC:
NEW LICENSES
27
0
0
0
0
0
0
0
27
7/15/13 NEW COSMETOLOGY SALON
904 - 613 -6517
904 - 613 -6517
904 - 434 -2185
904 - 707 -5486
904 - 343 -3536
904- 249 -1776
904- 249 -1776
904 - 422 -8058
904 - 246 -7070
7/15/13 NEW NAILS /SKIN CARE (FULL SPECIALIST)
904- 246 -7070
7/08/13 NEW MISC. SERVICE ESTABLISHMENT, NOT LIS
904 - 861 -2270
7/01/13 NEW AUTO: SERVICE /REPAIR
7/18/13 NEW MISC. PROFESSIONAL ESTABLISHMENT
904 - 222 -8358
904 -683 -3124
7/18/13 NEW MISC. CONTRACTOR, OTHER THAN LISTED
904 - 683 -3124
PAGE 1
PREPARED 8/16/13,17:42:47
City of Atlantic Beach
PROGRAM OL122L
AGENDA ITEM # 4A
SEPTEMBER 9, 2013
LICENSE ACTIVITY REPORT BY BUSINESS NAME
NEW LICENSES FOR ALL YEARS BETWEEN: 07/01/13 TO 07/31/13
DEPT: ALL DEPARTMENTS CLASS: ALL CLASSES
LIC #
BUSINESS NAME ISSUED TYPE CLASSIFICATION
BUSINESS ADDRESS • BUS PHONE #
13- 00007770 JAX FEDERAL CREDIT UNION
801 ATLANTIC BLVD
ATLANTIC BEACH FL 32233
7/10/13 NEW BANKS, NATIONAL,STATE OR CREDIT UNIO
904- 475 -8032
13- 00007760 KAREN J. DAVIS, C.P.A., P.A. 7/08/13 NEW ACCOUNTANCY FIRM/ CORPORATION
447 ATLANTIC BLVD UNIT 05
ATLANTIC BEACH FL 32233
13- 00007761 KAREN J. DAVIS, C.P.A., P.A.
447 ATLANTIC BLVD UNIT 05
ATLANTIC BEACH FL 32233
13- 00007721 LADY MAINTENANCE
74 W 6TH ST
ATLANTIC BEACH FL 32233
13- 00007735 LGBT JAX
1913 MAIN ST
ATLANTIC BEACH FL 32233
13- 00007708 LUCAS TREE SERVICE INC
205 EDGAR ST
ATLANTIC BEACH FL 32233
13- 00007726 NAILS AND SPA
725 ATLANTIC BLVD UNIT 02 904 - 242 -0922
ATLANTIC BEACH FL 32233
13- 00007768 NAVY FEDERAL CREDIT UNION 7/08/13 NEW BANKS, NATIONAL,STATE OR CREDIT UNIO
961 ATLANTIC BLVD 888 -842 -6328
ATLANTIC BEACH FL 32233
13- 00007747 PROFESSOR PLUMB 7/01/13 NEW PLUMBING /SEPTIC TANK CONTRACTOR (FIR
97 LEVY RD 904 - 270 -2266
ATLANTIC BEACH FL 32233
7/08/13 NEW ACCOUNTANT
904 - 224 -0045
904 - 224 -0045
7/01/13 NEW MISC. SERVICE ESTABLISHMENT, NOT LIS
904 - 236 -1212
7/01/13 NEW MISC.'SERVICE ESTABLISHMENT, NOT LIS
904 - 401 -0093
7/01/13 NEW TREE SERVICE /TREE SURGEON
7/01/13 NEW NAILS /SKIN CARE (FULL SPECIALIST)
904 -241 -3533
13- 00007748 PROFESSOR PLUMB 7/01/13 NEW PLUMBER
97 LEVY RD 904- 270 -2266
ATLANTIC BEACH FL 32233
13- 00007765 SHORE THINGS OF NORTH BEACH 7/08/13 NEW GIFTS /GREETING CARDS
725 ATLANTIC BLVD UNIT 04 904 -249 -1313
ATLANTIC BEACH FL 32233
13- 00007727 SUNSTATE ROOFING CONTRACTORS, 7/01/13 NEW ROOFING CONTRACTOR (FIRM /CORP.)
1946 BEACHSIDE CT 904 - 613 -6517
ATLANTIC BEACH FL 32233
13- 00007728 SUNSTATE ROOFING CONTRACTORS, 7/01/13 NEW MISC. CONTRACTOR, OTHER THAN LISTED
1946 BEACHSIDE CT 904 -613 -6517
ATLANTIC BEACH FL 32233
GRAND TOTALS
NEW LICENSES
AC: 27
PP: 0
IN: 0
VO: 0
PG: 0
BR: 0
OB: 0
UC: 0
LIC: 27
PAGE 2
Gallons Actual Revenue
Gallons Actual Revenue
Water Sales t Accounts 0000 Revenue Per 1,000 gl Accounts 0000 Revenue Per 1,000 gl
Atlantic Beach 5,651 41,305 $153,843 $3.72 k., 5,607 40,310 $150,486 $3.73
Buccaneer 2,480 17,622 $88,884 $5.04 N 2,478 17,869 $91,898 $5.14
Total Water Sales 8,131 58,927 $242,727 $4.121 8,085 58,179 $242,384 $4.17
5,238 33,006 $247,193 $7.49
2,372 19,372 $180,594 $9.32
7,610 52,378 $427,787 $8.17
Gallons Actual Revenue
0000 Revenue Per 1,000 gl
51.383 $238,921
16.921 $184,722
68.304 $423,643
$4.65
$10.92
$6.20
Gallons Actual Revenue
0000 Revenue Per 1,000 gl
54.069 $427,787 $7.91
54.069 $427,787 $7.91
Gallons Actual Revenue
Accounts 0000 Revenue Per 1,000 gl
5,187 31,956 $238,921 $7.48
2,375 19,967 $184,722 $9.25
7,562 51,923 $423,643 $8.16
Gallons Actual Revenue
Accounts 0000 Revenue Per 1,000 gl
AGENDA ITEM # 4A
SEPTEMBER 9, 2013
City of Atlantic Beach, FI.
Utility Sales Report
July 2013
July 2012
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
Gallons
0000
64,223
4,395
68,618
58,927
9,691
14.12%
10.17%
Gallons
0000
55,994
24,360
80,354
58,179
22,175
27.60%
17.37%