Agenda Item 4ABUILDING DEPT. MONTHLY ACTIVITY REPORT
COMPARISON REPORT
~~-' ~···~··· .. ···-"·~-· ..
REPORT FOR THE MONTH JUNE 2014
----------1
COMPARISION 2013-2014
PERMIT TYPE ________ 'NUMBER OF PERMITS 1 ____ _ T TOTAL INSPECTIONS
YTD 2013 YTD 2014 YTD 2013 YTD 2014 YTD 2013 YTD 2014
-~~;LLE~FAMILY 8 ~----_ ~2 I I: 1,269,300:001 ---$4,722,0fo~~~l ~~~~~~~~~~NS I + I 2~7 $ -1,845,798:~0 j$--$3,~:--:-ti---:~t-'-~~c--~~c-::--~--;I---_-------------=--=J---=-=-=--~=-
O_TH_ER_______ TOTA·L·--~.1---1f2138-49--I lli1 -~~=---[$-------4,584,764.00 $--~·~~~·~·00
_ •-1563
1
_L__ _ 7,699,862.00 l,-:---====$~1c-::2""':,4'="o5:!",5=-:o=7:--::.oc-::o'-i----=-25=-=6=-=-1--+----=-24-:-:6=-=-4---l
PERMITS ISSUED FOR THE MONTH OF JUNE 2014
NO.PERMITS PERMIT COST CONSTRUCTION VALUE INSPECTIONS PERFORMED
~~~g~:~!~l ~~~~~~~~ ~ I i m -----~_j --••• ---1~· ~ • -: i ~~~!~~~Al m 1 _2_:_;8~-1--
RESIDENTIA(._ALTERATIONS • 15 I$ 2,14Ko_-ol. _$__ 31_!~4o2.oo .MECHANICAl.. ~----.. _-=-1
16
o-=--__ 1 ~g~~~=~:~:ffi~~~~NS ~ ~ -lt-1,983.~0 I I i 509,000.;0 IMISC:. TOTAL 512
~~~~~~~c~Cc -· ------------3
3
4 --f :$ 2.~~~:~-~ j _ .. j l-----:Z'!.?§_()_.~O I Proje:t~ to Note:-New Duplex
~~~~~~:~~~ ~~!c _f 3 I $$ 4 ,~!~:~~
1
. , ~ __ -----·--: IN one __ -
PLUMBING ----------ii 2,652.00_, t : -----___ l ___ _
ROOFING ---------=1·----2
13
2
4
_____ -----_l. ! $!________ 2,664.00 ______ j_$~---__ -_ ___ 369,741 :QO !Projects to Note: New Dwelling > ~ ~~~~~~~~~oR --===---===[---cdin_ -~ --__ ~ ~ --=~~~:·=:oL--==-n
-----------6 ---~~--1t---~~~-~~~t---ll---------_----==~~ ------·-~:
--------------1 . $ 65.00 $m---------·----Projects to Note: New Commercial >
----=-~=-~~-----1t-_____ ~!~:~~ ~----lt--------,None ---,-,------+---------6 _____ $ ______ 460.00-~-------:-f----------30,125.00 1 E:XPIREDPERMIT¥-EESCOLLECTED
-+---~~==~==-~-------------rf=-------~~::gl----___ ---=Jt __________ -329,~ ______ $98Z:QO I ______________ _
248 I$ 26,527.00 , $ 1,644,256.00
City of Atlantic Beach AGENDA ITEM# 4A
FINANCIAL REPORT AUGUST 11, 2014
June 2014
Cash Balances
Prior Current Dollar Percent
Fund(s) 05/31/14 06/30/14 Change Change
General $ 7,958,175 $ 8,290,462 $ 332,287 4.18%
Tree Replacement 12,321 12,321 0.00%
Convention Development Tax 58,444 68,208 9,764 16.71%
Local Option Gas Tax 188,015 210,639 22,624 12.03%
Better Jax 1/2 Cent Sales Tax 420,702 442,182 21,480 5.11%
Police Training, Forfeiture, Grants, etc. 111,851 126,054 14,203 12.70%
Community Development Block & ARRA Grants (22, 185) 22,185 0.00%
Debt Service 0.00%
Capital Projects 2,941,524 2,974,792 33,268 1.13%
Utility 5,012,161 5,207,051 194,890 3.89%
Sanitation 727,770 729,966 2,196 0.30%
Building Code Enforcement 233,394 237,725 4,330 1.86%
Storm Water 1,826,781 1,804,837 (21 ,944) -1.20%
Pension -Police 10,834 10,704 (130) -1.20%
Pension -General 208,671 229,754 21,083 10.10%
Total $ 19,688,458 $ 20,344,694 $ 656,236 3.33%
Total Restricted Cash 7,638,919
Total Unrestricted Cash $12,705,775
Cash and Investments
Annual Prior Current Dollar Percent
Account Yield 05/31/14 06/30/14 Change Change
Bank of America -Depository 0.20% $ 2,628,574 $ 3,182,410 $ 553,836 21.07%
Guggenheim Floating Rate A 3.55% * 3,701,817 3,718,748 16,931 0.46%
Hartford Floating Rate Bond A 3.54% * 2,541,977 2,555,607 13,630 0.54%
lnvesco Floating Rate A 3.59% * 3,670,598 3,692,016 21,418 0.58%
MainStay Short Term Duration High Yield A 2.97% * 2,570,273 2,592,133 21,860 0.85%
First Trust Short Duration High Income A 3.26% * 2,025,642 2,036,773 11,131 0.55%
Putnam Diversified Inc. 3.90% * 1,273,720 1,288,535 14,815 1.16%
Alliance Limited Duration High Income A 2.30% * 1,270,578 1 ,273,192 2,614 0.21%
MSSB Money Market/Cash 0.05% 1,778 1,778 0 0.00%
SBA-Florida Prime 0.16% 351 352 1 0.28%
Cash on Hand 3,150 3,150 0.00%
Subtotal $ 19,688,458 $ 20,344,694 $ 656,236 3.33%
Police Pension Investments $ 8,181,225 $ 8,262,431 $ 81,206 0.99%
General Pension Investments 14,795,108 14,858,676 63,568 0.43%
Subtotal $ 22,976,333 $ 23,121,107 $ 144,774 0.63%
Total $ 42,664,791 $ 43,465,801 $ 801,010 1.88%
* Denotes the 30 day SEC Yield Anualized
City of Atlantic Beach
FINANCIAL REPORT
June 2014
AGENDA ITEM# 4A
AUGUST 11, 2014
Revenues
Annual YTD -75.00% YTD Dollar
Fund I (Footnote) Estimate of Estimate Actual Variance
General $ 10,931,117 $ 8,198,001 $ 9,550,407 $ 1,352,406
Convention Development Tax 80,300 60,219 77,182 16,963
Local Option Gas Tax 421,009 315,747 316,421 674
Better Jax 1/2 Ct Sales Tax 694,870 521,145 544,615 23,470
Police Training, Forfeiture & Grants, etc. 110,041 81,399 106,402 25,003
Grants 75,000 56,250 30,675 (25,575)
Capital Projects 495,000 371,232 314,245 (56,987)
Utility 8,611,203 6,458,292 6,295,980 (162,312)
Sanitation 1,789,000 1,341,747 1,353,931 12,184
Building Code Enforcement 281,550 211,131 316,648 105,517
Storm Water 1,155,000 866,250 934,810 68,560
Pension -Police , 1,329,681 997,245 1,072,304 75,059
Pension -General
Total
2,190,980 1,643,229
$ 28,164,751 $ 21,121,887 $
Analysis of Major Variances
(Variances >$25,000 AND 10.00%)
1,881,838 238,609
22,795,458 $ 1,673,571
In general, the major variances are created when the actual funds received-to-date are different from the
percentage of the budget elapsed-to-date. They are as follows:
The positive variance in the General Fund is mostly due to the timing of property tax receipts. The
bulk of the receipts come in November and December.
The city receives grant monies from CDBG on a reimbursement basis; therefore there is a delay in
revenue recognition during the fiscal year causing the negative variance in Grants.
The city has not received expected grant monies for the Marsh Master Plan from the State of Florida
nor the City of Jacksonville, as conceptual design discussions are still in progress; therefore there is a
negative variance in Capital Projects.
Building Code Enforcement permit activity is running above projected revenues, similar to
surrounding jurisdictions and counties.
The positive variance in the Pension Fund-General resulted from changes in market values of the
investments of more than the anticipated amount and a $60,000 transfer from the ICMA to the
defined benefit DROP, in accordance with ordinance changes to the Plan.
Percent
Variance
16.50%
28.17%
0.21%
4.50%
30.72%
-45.47%
-15.35%
-2.51%
0.91%
49.98%
7.91%
7.53%
14.52%
7.92%
City of Atlantic Beach
FINANCIAL REPORT AGENDA ITEM# 4A
June 2014 AUGUST 11, 2014
Expenses
Annual YTD -75.00% YTD Dollar Percent
Department I (Footnote) Estimate of Estimate Actual Variance Variance
Governing Body $ 42,933 32,157 $ 28,750 $ 3,407 10.59%
City Administration 2,647,720 1,985,358 1,819,262 166,096 8.37%
General Government 640,119 480,033 483,421 (3,388) -0.71%
Planning and Building 434,709 325,917 268,821 57,096 17.52%
Public Safety 5,691,716 4,267,425 3,994,157 273,268 6.40%
Recreation and Special Events 396,901 297,585 268,799 28,786 9.67%
Public Works 7,874,942 5,904,995 4,101,606 1,803,389 30.54%
Public Utilities 10,757,956 8,077,435 7,134,305 943,130 11.68%
Pension -Police 751,628 563,679 560,136 3,543 0.63%
Pension -General 852,850 639,585 693,720 {54,135} -8.46%
Total $ 30,091,474 22,574,169 19,352,977 $3,221,192 14.27%
Annual YTD -75.00% YTD Dollar Percent
Resource Allocation Estimate of Estimate Actual Variance Variance
Personnel Services $ 9,478,693 $ 7,124,136 $ 6,734,292 $ 389,844 5.47%
Operating Expenses 10,730,913 8,031,926 7,032,837 999,089 12.44%
Capital Outlay 5,767,260 4,332,322 2,018,388 2,313,934 53.41%
Debt Service 2,448,768 1,836,441 2,310,344 (473,903) -25.81%
Grants and Aids 36,820 27,603 32,895 (5,292) -19.17%
Transfers
Total $
1,629,020 1,221,741 1,224,221
30,091,474 $ 22,574,169 $ 19,352,977
Analysis of Major Variances
(Variances >$25,000 AND 10.00%)
{2,480}
$ 3,221,192
In general, the major variances are a result of timing differences created between the percentage
of budget elapsed-to-date and actual expenditures. They are as follows:
The positive variance in Planning and Building resulted from turnover and vacancy savings
during the fiscal year, coupled with reorganization of positions.
The variance in the Public Works Department was due to: project activity budgeted that has
not been completed -see Project Activity schedule; Storm Water Fund debt payments were
expensed in October when paid, but prorated for budget purposes; and minimal expenses
have been incurred towards the Parks Master Plan consultant or the resurfacing/street paving
program.
The positive variance in the Public Utilities Department is due to budgeted project activity
that has not been started/completed or will be re-budgeted in a future fiscal year.
-0.20%
14.27%
City of Atlantic Beach
FINANCIAL REPORT AGENDA ITEM# 4A
June 2014 AUGUST 11, 2014
Project Activity-Current Year Activity Only
Project YTD YTD
Project Name Number Budget Actual Balance Status
Public Safety:
Kennel Improvements PS1401 40,000 40,000 I
Enclose Under Portion of Lifeguard Bldg for Equipment Storage PS1402 6,000 3,634 2,366 c
$ 46,000 $ 3,634 $ 42,366
Public Utilities:
Reclaim Water Facility PU0805 1,352,269 825,045 527,224 I
Replace the Water Main on Pine Street PU1304 53,199 53,199 c
Replace 4" Water Main at Wonderwood and Finegan PU1305 58,852 58,852 c
PT Repair at Lift Station C PU1306 22,397 22,397 I
Repair 24" Effluent Force Main PU1308 5,260 5,260 0 c
Repair 12" Force Main PU1309 3,363 3,363 0 c
Water Plant #2-Rehab Elevated Tank PU1401 125,000 125,000 A
Water Plant #2 Rehabilitation Ground Storage Tank PU1402 121,528 57,519 64,009 I
Replace Water Maint-Sea Oats & Park Terrace PU1403 168,472 168,472 R
lnline Valve Installation PU1404 50,000 50,000 I
Replace Manhole on Saturiba PU1405 73,883 73,883 I
Sewer Rehab Saturiba & Sea Oats PU1406 190,000 190,000 I
Donner Subd Sewer Rehab-HMGP Grant PU1407 155,000 155,000 I
Effluent Outfall Replacement PU1408 137,264 8,746 128,518 E
Effluent Pump at WWTP PU1409 50,000 33,940 16,060 I
Connect A1A at Mallard Cove PU1410 130,000 130,000 E
Subtotal $ 2,696,487 $ 1,045,924 $ 1,650,563
Parks Maintenance:
Marsh Master Plan Signs PM1301 625 625 c
Rose Park Development PM1302 237,440 210,850 26,590 I
Russell Park Tennis Courts 1-2 PM1401 100,000 100,000 s
Bull Park Gazebo PM1402 X
Donner Park Ball field Improvements PM1403 82,056 38,375 43,681 I
Electric Gate at Dutton Island Park PM1404 8,000 8,000 I
Marsh Project Pedestrian Path PW1408 150,000 22,054 127,946 E
March Overlook & Kayak Launch PW1409 293,000 293,000 E
Marsh Preserve Path Phase-! PW1410 42,000 41,628 372 c
Subtotal $ 913,121 $ 313,532 $ 599,589
Public Works:
Dutton Isle Road Sidewalks PW1301 58,207 57,545 662 I
East Coast Drive Drainage Improvements PW1306 323,046 159,097 163,949 I
Fountain PW1402 7,500 7,500 I
Welcome Sign PW1403 15,200 6,974 8,226 I
Robert Street Ditch PW1404 50,000 23,256 26,744 I
Sidewalk and Curbs PW1405 25,000 497 24,503 I
Salt Air/Sturdivant Drainage and Sidewalk lmprovmts PW1406 380,000 42,382 337,618 E
Seminole Streetscape PW1407 498,000 54 497,946 E
Canopy Replacement on PW Building PW1413 75,000 75,000 I
Subtotal $ 1,431,953 $ 289,805 $ 1 '142, 148
Total $ 5,087,561 $ 1,652,895 $ 3,434,666
Status Key
A-Bid/RFP Advertised I -Project In-progress
B -Bid Awarded N -Complete/Non-Capital
C -Project Completed R-Re-budget Next Fiscal Year OR Re-Evaluated
D -Design Completed S -Staff Researching
DE -Deferred X -Project Cancelled
E -Design Phase