Agenda Item 4ACity of Atlantic Beach
FINANCIAL REPORT
September 2013
AGENDA ITEM # 4A
NOVEMBER 12, 2013
Cash Balances
Fund(s)
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
Prior
08/31/13
$ 6,529,285
6,493
88,590
(2,483)
390,071
150,374
67,231
2,725,534
5,712,233
676,870
118,960
1,641,438
94,615
36,708
Total $ 18,235,919
Total Restricted Cash
Total Unrestricted Cash
Current
09/30/13
$ 5,996,150
6,493
85,148
22,554
420,413
138,373
73,113
2,724,229
5,800,616
680,084
116,044
1,643,564
82,413
48,330
Dollar
Change
$ (533,135)
(3,442)
25,037
30,342
(12,001)
5,882
(1,305)
88,383
3,214
(2,917)
2,127
(12,202)
11,622
$ 17,837,524 $ (398,395)
$7,874,450
$9,963,074
Percent
Change
Cash and Investments
Account
Annual
Yield
Bank of America - Depository
Guggenheim Floating Rate A
Invesco Floating Rate A
Loomis Investment Grade Bond A
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
Putnam Diversified Inc.
Alliance Limited Duration High Income A
Lord Abbott Floating Rate
MSSB Money Market/Cash
SBA - Florida Prime
Cash on Hand
Subtotal
Police Pension Investments
General Pension Investments
Subtotal
Total
* Denotes the 30 day SEC Yield Anualized
N/A
3.97%
4.31%
2.56%
0.08%
4.15%
3.45%
4.08%
Prior
08/31/13
$ 2,741,200
2,172,238
2,490,016
1,001,363
472,380
498,704
1,011,554
331,843
1,014,685
1,001,749
2,500,692
1,998,106
997,895
2
344
3,150
$ 18,235,919
Current
09/30/13
$ 3,346,746
2,835,127
2,820,909
1,017,017
1,777
2,483,629
2,857,723
1,469,807
1,001,293
344
3,150
$ 17,837,524
$ 7,341,912 $ 7,593,617
13,374,481 13,847,140
$ 20,716,393 $ 21,440,757
$ 38,952,312 $ 39,278,281
Dollar
Change
$ 605,546
662,890
330,893
(1,001,363)
(472,380)
(498,704)
5,463
(331,843)
(1,014,685)
(999,971)
(17,063)
859,617
471,912
1,001,292
$ (398,395)
$ 251,706
472,659
$ 724,364
$ 325,969
-8.17%
0.00%
-3.89%
- 1008.39%
7.78%
-7.98%
0.00%
8.75%
-0.05%
1.55%
0.47%
-2.45%
0.13%
- 12.90%
31.66%
-2.18%
Percent
Change
22.09%
30.52%
13.29%
- 100.00%
- 100.00%
- 100.00%
0.54%
- 100.00%
- 100.00%
- 99.82%
0.00%
0.00%
0.00%
N/A
0.00%
0.00%
-2.18%
3.43%
3.53%
3.50%
0.84%
City of Atlantic Beach
FINANCIAL REPORT
September 2013
Revenues
AGENDA ITEM # 4A
NOVEMBER 12, 2013
Fund / (Footnote)
Annual
Estimate
YTD - 100.00%
of Estimate
YTD
Actual
Dollar
Variance
Percent
Variance
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)
$ 11,102, 740
87,500
433,655
657,738
112,645
108,866
71,900
5,000
8,610,929
1,814,950
282,600
1,097,430
1,233,745
2,173,963
Total $ 27,793,661
$
11,102, 740
87,500
433,655
657,738
112,645
108,866
71,900
5,000
8,610,929
1,814,950
282,600
1,097,430
1,233,745
2,173,963
27,793,661
10,951,205 $
88,536
415,405
670,455
126,325
255,206
69,790
(54,636)
8,271,547
1,784,948
299,151
1,074,148
1,130,248
2,046,752
27,129,079 $
(151,535)
1,036
(18,250)
12,717
13,680
146,340
(2,110)
(59,636)
(339,382)
(30,002)
16,551
(23,282)
(103,497)
(127,211)
(664,582)
- 1.36%
1.18%
-4.21%
1.93%
12.14%
134.42%
-2.93%
- 1192.73%
- 3.94%
- 1.65%
5.86%
- 2.12%
- 8.39%
- 5.85%
-2.39%
Analysis of Major Variances
This is the final monthly report for the year generated on a budget basis. Finance will
continue to make adjustments based on items that we are made aware of in October that
relate to last year. These adjustments will be reflected in the Audit report for 2013 later in
the year. Now that we have reached year end, all of the timing differences in the
variances have been overcome. The investment returns for the remained down by 2.2%
from last year as September returns were flat. The variances in revenues include a
reversal of prior gains from earlier in the year in investment earnings due to the sharp
decrease in the fixed income bond market. Most other revenue categories are near
budget estimates except for Public Utilities where sales volumes are down and the
Pension Plans as described below.
(1) The 1.36% slight negative variance in the General Fund indicates that revenues overall
approximated the budgeted amounts. A couple of other revenue sources that were
slightly down were the utility tax and franchise fees from JEA as well as revenues from
the communications services tax. Property tax collections ended the year slightly above
budget by $27,039. State shared tax revenues were also slightly above budget for the
year.
(2) The $103,497 negative variance in the Police Employee Pension Fund and the $127,211
negative variance in the General Employee Pension Fund resulted from the increase in
the market values of the investments being 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 for both Water and Sewer. Base charges
are below budget by about 7% and 2% and volume sales are below projections by about
12% 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 but there was not enough of an increase to
achieve budget this year..
(5) Building Permit fee revenues ended the year about 12% above projections.
City of Atlantic Beach
FINANCIAL REPORT
September 2013
Expenses
AGENDA ITEM # 4A
NOVEMBER 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
Estimate
YTD - 100.00%
of Estimate
YTD
Actual
Dollar Percent
Variance Variance
$ 42,645
2,474, 839
1,064,477
448,160
5,497,886
406,151
6,130,393
9,334,737
653,056
856,123
$ 26,908,467
$ 42,645
2,474,839
1,064,477
448,160
5,497,886
406,151
6,130, 393
9,334,737
653,056
856,123
26,908,467
$ 40,225
2,349,491
1,035,155
408,607
5,288,805
387,140
4,961,700
8,213,979
705,609
931,497
$ 2,420 5.67%
125,348 5.06%
29,322 2/5%
39,553 8.83%
209,081 3.80%
19,011 4.68%
1,168,693 19.06%
1,120,758 12.01%
(52,553) -8.05%
(75,374) - 8.80%
24,322,209 $2,586,258
Resource Allocation
Personnel Services (5)
Operating Expenses (2)
Capital Outlay (1) & (2)
Debt Service (4)
Transfers
Annual
Estimate
YTD - 100.00%
of Estimate
YTD Dollar Percent
Actual Variance Variance
$ 9,658,810
10,290,417
3,110,374
2,519,412
1,329,454
$ 9,658,810
10,290,417
3,110,374
2,519,412
1,329,454
$ 9,305,423 $ 353,387 3.66%
9,440,048 850,369 8.26%
1,799,422 1,310,952 42.15%
2,447,863 71,549 2.84%
1,329,454 - 0.00%
Total $ 26,908,467
$ 26,908,467 $ 24,322,209 $ 2,586,258
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. Now that we have reached
year end, the timing variances are eliminated. Some of the variances are described
below.
(1) The positive variance in the Public Safety divisions is mostly due to the Patrol and
Dispatch both experiencing employee turnover and some savings in operating expenses.
The Lifeguard expenses have now been fully expended and came in close to budget.
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 created by some turnover and savings on budgeted health
insurance..
(3) The variance in the Public Works Department is due to various contracted service
items not fully underway such as the East Coast Drive Drainage project or the Rose Park
project. The department has spent about 46% of its project budget — see Project Activity
Schedule.
(4) The positive variance in Public Utilities results mostly from operations savings in the
sewer division and from unspent funds on budgeted capital expenditures. The
department has spent approximately 77% of its project budget.
(5) The positive variance in the Personnel Services results from vacant positions that have
not been filled across multiple departments. 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 Finance,
Planning, Police Patrol and recently Human Resources.
City of Atlantic Beach
FINANCIAL REPORT
September 2013
Project Activity - Current Year Activity Only
AGENDA ITEM # 4A
NOVEMBER 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
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
PM1301
PM1303
PM 1302
PM 1304
PW 1301
PW 1302
PW1303
PW 1304
PW 1305
PW 1306
YTD
Balance Status
0 60,000 DE
$ 60,000 $
$ 60,000
9,282 9,282
88,762 88,762
15,591 15,591
34,122 34,121
190,620 190,620
192,889 191,039
41,500 37,927
55,000 51,253
90,000 61,347
180,000 98,888
17,000 10,280
55,000 19,891
86,000 7,851
56,000 5,019
18,435 18,434
202,300 189,669
0 C
0 C
0 C
1 C
0 C
1,850 B
3,573 C
3,747 C
28,653 I
81,112 I
6,721 I
35,109 C
78,149 R
50,981 R
1 C
12,631 C
$ 1,332,501 $ 1,029,974 $ 302,527
38,700
34,000
232,840
35,000
79,064
10,000
32,000
4,600
33,000
364,707
7,243
34,590
225,228
0
23,140
6,041
24,896
4,600
25,669
48,214
31,457 I
(590) E
7,612 I
35,000 R
55,924 I
3,959 I
7,104 C
0 C
7,331 C
316,493 R
$ 863,911 $ 399,622 $ 464,289
$2,256,412 $ 1,429,596 $826,817
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 SEPTEMBER 2013
COMPARISION 2012 - 2013
PERMIT TYPE
NUMBER OF
YTD 2012
20
PERMITS j
YTD 2013
9
YTD 2012
$ 7,075,045.00
YTD 2013
$4,550,300.00
TOTAL INSPECTIONS
YTD 2012
YTD 2013
SINGLE FAMILY I
DUPLEX
0
0
$ -
$3,386,132.00
REMODEUADDITIONS
237
217
$ 3,890,707.00
$0.00
COMMERCIAL NEW
0
0
$ -
$ -
OTHER
1891
1655
$ 7,741,095.00
$ 6,104,062.00
TOTAL
2148
1881
$ 18,706,847.00
$14,040,494.00
3468
3709
PERMITS ISSUED
NO.PERMITS
0
FOR THE
PERMIT COST
, $ -
MONTH
OF SEPTEMBER 2013
CONSTRUCTION VALUE
$ -
INSPECTIONS PERFORMED
BUILDING
123
SINGLE FAMILY
NEW DUPLEX MULTI FAM
0
$ -
$ -
ELECTRICAL
43
RESIDENTIAL ADDITIONS
18
$ 2,065.00
$ 364,975.00
PLUMBING
58
COMMERCIAL NEW
0
$ -
$ -
MECHANICAL
52
COMERCIAL ADDITIONS
0
$ -
$ -
MISC.
38
COMMERCIAL ALTERATIONS
0
$ -
$ -
PERMITS MISC
0
$ -
$ -
TOTAL
314
ELECTRICAL
22
$ 1,703.00
$ -
MECHANICAL GAS
5
$ 375.00
$ -
MECHANICAL HVAC
25
$ 2,369.00
$ -
PLUMBING
24
$ 2,141.00
$ -
ROOFING
16
$ 1,335.00
$ 99,890.00
WINDOW /DOOR
8
$ 637.00
$ 95,168.00
DEMOLITION
2
$ 200.00
$ -
REINSPECTION FEES
0
$ -
$ -
PERMIT RENEWALS
0
$ -
$ -
OCCUPANCY INSPECTIONS
2
$ 200.00
$ -
PENALTY FEES
2
$ 284.00
$ -
SIGNS
0
$ -
$ -
FENCES
7
$ 245.00
$ -
DRIVEWAYS
4
$ 140.00
$ -
WELL
0
$ -
$ -
SIDING
1
$ 145.00
$ 18,852.00
DA
vIB
POOL
3
$ 670.00
$ 104,000.00
TOTAL
139
$ 12,509.00
$ 682,885.00
PREPARED 10
City of Atl
PROGRAM OL1
/22/13, 9:22:21
antic Beach
22L
AGENDA ITEM # 4A
NOVEMBER 12, 2013
LICENSE ACTIVITY REPORT BY BUSINESS NAME
NEW LICENSES FOR ALL YEARS BETWEEN: 09/01/13 TO 09/30/13
DEPT: ALL DEPARTMENTS CLASS: ALL CLASSES
LIC #
BUSINESS NAME
BUSINESS ADDRESS
14- 00007828 ATLANTIC SPEECH THERAPY
447 ATLANTIC BLVD
ATLANTIC BEACH FL 32233
14- 00007830 ATLANTIC SPEECH THERAPY
447 ATLANTIC BLVD
ATLANTIC BEACH FL 32233
13- 00007831 BOWL OF PHO
725 ATLANTIC BLVD UNIT 09
ATLANTIC BEACH FL 32233
13- 00007832 CAROLINA BEDDING DIRECT LLC
377 8TH ST
ATLANTIC BEACH FL 32233
ISSUED TYPE CLASSIFICATION
BUS PHONE #
904 - 652 -5408
904 - 652 -5408
9/06/13 NEW RESTAURANTS(INC. SNACK BARS & TAKE 0
904 - 434 -8171
9/06/13 NEW CONSULTANT, NOT OTHERWISE CLASSIFIED
904- 307 -1765
9/13/13 NEW OCCUPATIONAL THERAPIST
9/13/13 NEW PROFESSIONAL, OTHER THAN LISTED
14- 00007838 COCA -COLA REFRESHMENTS USA, IN 9/13/13 NEW VENDING MACHINE
1085 ATLANTIC BLVD
ATLANTIC BEACH FL 32233
14- 00007836 CONTINENTAL INDEMNITY COMPANY 9/13/13 NEW INSURANCE COMPANY
OUTSIDE CITY
ATLANTIC BEACH FL 32233
14- 00007852 DOWNEY REALTY, INC.
372 AHERN ST
ATLANTIC BEACH FL 32233
14- 00007821 GRETCHEN DETERS - MURRAY
346 MAGNOLIA ST
ATLANTIC BEACH FL 32233
14- 00007825 J.W. CLEANING SERVICE
179 JACKSON RD
ATLANTIC BEACH FL 32233
14- 00007847 MADISON INSURANCE COMPANY
OUTSIDE CITY
ATLANTIC BEACH FL 32233
9/30/13 NEW REAL ESTATE BROKER
9/13/13 NEW MARRIAGE OR FAMILY COUNSELOR
9/05/13 NEW CLEANING /JANITORIAL /MAID SERVICE
9/30/13 NEW INSURANCE COMPANY
14- 00007839 NATIONAL TEACHERS ASSOCIATES L 9/30/13 NEW INSURANCE COMPANY
OUTSIDE CITY
ATLANTIC BEACH FL 32233
14- 00007841 NORTH FLORIDA PEST CONTROL, IN 9/30/13 NEW PEST CONTROL /EXTERMINATOR
36 W 6TH ST
ATLANTIC BEACH FL 32233
13- 00007822 PIE HEAVEN BAKERY CAFE
1980 MAYPORT RD
ATLANTIC BEACH FL 32233
813 - 569 -2600
402 - 827 -3424
904 -241 -4242
904 - 247 -9939
904 - 677 -6366
803 - 754 -2942
972 -532 -2100
904 - 223 -5843
9/04/13 NEW RESTAURANTS(INC. SNACK BARS & TAKE 0
904 -994 -5387
14- 00007848 PROTECTIVE LIFE AND ANNUITY IN 9/30/13 NEW INSURANCE COMPANY
OUTSIDE CITY
ATLANTIC BEACH FL 32233
GRAND TOTALS
AC:
PP:
IN:
VO:
PG:
BR:
OB:
UC:
LIC:
NEW LICENSES - - --
13
1
0
0
0
0
0
0
14
Gallons Actual Revenue
0000 Revenue Per 1,000 gi
66.642 $422,943 $6.35
66.642 $422,943 $6.35
Gallons Actual Revenue
0000 Revenue Per 1,000 gi
49.449 $421,657 $8.53
49.449 $421,657 $8.53
AGENDA ITEM # 4A
NOVEMBER 12, 2013
City of Atlantic Beach, FI.
Utility Sales Report
Water Sales
September 2013
Gallons Actual Revenue
Accounts 0000 Revenue Per 1,000 gi
September 2012
Gallons Actual Revenue
Accounts 0000 Revenue Per 1,000 gl
Atlantic Beach
Buccaneer
Total Water Sales
5,643 41,534 $155,981
2,489 17,364 $88,274
58,898 $244,254
8,132
$3.76
$5.08
$4.15
5,619 39,421 $147,637 $3.75
2,454 19,103 $95,961 $5.02
8,073 58,524 $243,598 $4.16
Gallons
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
0000
47,646
16,619
64,265
58,898
5,367
8.35%
9.93%
Gallons Actual Revenue
Accounts 0000 Revenue Per 1,000 gl
5,235 31,320 $242,312 $7.74
2,394 19,070 $179,344 $9.40
7,629 50,390 $421,657 $8.37
Gallons
0000
48,184
23,658
71,842
58,524
13,318
18.54%
16.01%
Gallons Actual Revenue
Accounts 0000 Revenue Per 1,000 gi
5,198 31,087 $236,406 $7.60
2,350 20,242 $186,537 $9.22
7,548 51,329 $422,943 $8.24