Item 4A - Bldg Report, Financial ReportBUILDING DEPT. MONTHLY ACTIVITY REPORT
-----~~~-~ ~~~~~~ ~~ ~-------
COMPARISON REPORT
----------~ ----------
REPORT FOR THE MONTH APRIL 2015
PERMIT TYPE
COMPARISON 2014-2015 ---~~NUMBER O~F-PERM-IT_S __ ---,--__ _:_:_:_~
~~-J TOTAL INSPECTIONS
YTD 2014 YTD 2015 YTD 2014 YTD 2015 YTD 2014 YTD 2015
9 : 1LL n~-~ $ 2,914,941 I $ 2,041~~~0'-+--1 ---
·~-~~~-J
SINGLE FAMILY
DUPLEX
REMODEL/ADDITIONS
COMMERCIAL NEW
-I 7 ! .. · 1 $$ -.l 819,ooo . -~---+--
1
. 181 • ······ 109~ . 1 ...• s .... 4. 8,896 ·1 $ ~~1 ,615,554 ·I
OTHER ··~-~·. 61~1 40~ 'i, .. ·~· .. 1 ~ 2,9~~:~~~ •. ~. :~~:~~~=~~-----~
--===~T--=.0--==-TA=--:.{.L~ 808 i 543 J~~L ~ 7,4~~.681 I$ ··~~ 6,010,342~· ___ 1,~g~L ---
PERMITS ISSUED FOR THE MONTH OF APRIL 2015
·-~~--····-----
NO.PERMITS PERMIT COST CONSTRUCTION VALUE INSPECTIONS PERFORMED
__ Sit-IGLE FAMILY ··~~~···· -I 4 t• $$_.__ ___ J~,9231 $ 1,666,~QQ_ BUILDING -189 ----l
NEW DUPLEX MULTI FAM ______ 7 ------+· .'_____ 7,682 , -----t· $ 819,000 J§~ECTRICAL 72
RESIDENTIAL ADDITIONS 3 -----t'-::$ 653 [ $ 45,400 :PLUMBING ····~· ~-1· 82
RESIDENTIAL AL TERATIOt-fs 14 I ~ .. 2,030~ I r$ ------,c1~~l50 MECHANICAL ·~~ _4_2 __
gg~~~~g::~ :~~liONS ___ 1_ 3, .. 9.971• I~ ~ . 950,000 Ml~~-····~·I 5
COMMERCIAL j).L TERATIONS_j ~-1 ~-~t~ ----734 . --rF-~··· __ ---1c-O-O,OOOJ TOTAL -39_0 ___ ,
~~;~~1~c~ICc _ . __ __L_____ .. 393 .•. ~ •••...•......
1
~ ... ~:~;~ 1· . $ . 96,436 :
~~g~:~:g:~ ~~!c 3~ • $ 3~-~ -_··· -----·
PLUMBING T---·~-42____ t ~ 81 .,4545~82 +-'1, ------·~· ·····----~~·~·
ROOFING 15 I $ i $ .139,976 IS.URCHAR.G .. E. c. o. LL.ECTE .. D.:
WINDOW/DOOR 10 r $ 1 ,357 ..
1
.. --·~-_-__j-+[~$-_ . 62,29? ·.·. $1 ,218.00_----f-__ ~ ..... __ _
DEMOLITION 4 '$ 416 '. $ ---400 1
REINsPECTION FEEs · ··· I . --~~ I i'REE REMovA:t.s:-t~, -·
OCCUPANCY INSPECTIONS r:~~-~-~ , . -~--~--··
SIGNS 1~ $ ··~····· 20?±--· _ .... f--'1 $'-----~?,51!_~~~~== ~~ei~~~: +-· --~93 ~~~~~~AYSffiOW ~---12 _ !!---.~-....... ~_ ~: 1 .. ~·-· ~-_····___ ······ ~llnches Relocated: 1· _ -···-~ . ___ ··~-~-1------.. ·~··-~-~--~······ $-~······
604
.. ·····-----t$.. 44,200 !Inches Planted: ------40
:o~L ___ ~ ___ l_-._-.. -.•... ~~-~~ .. ~~-~·-.·-· .. r_-~T~.A ... L .. [.· -~c---'--I ~r--.~-·~~ _____
4
_, 1-:-:·-.:o-7:.~~ Pa·····id-i·n-Mitiga.· tio~ t .. -.--$~·-1,4··· ·.~.~-~ ~ ~ ~ ' ·~-~-----217 ·~ ---~-~-: $ -~---~~093 ==--···· '' (_1 _____ ···· ' ~ ~~ ' ~ ~ ~·~ ..
City of Atlantic Beach AGENDA ITEM #4A
FINANCIAL REPORT MAY26,2015
March 2015
Cash Balances
Prior Current Dollar Percent
Fund(s) 02/28/15 03/31/15 Change Change
General $ 9,046,449 $ 8,949,430 $ (97,019) -1.07%
Tree Replacement 16,480 17,837 1,357 8.23%
Convention Development Tax 69,700 77,142 7,442 10.68%
Local Option Gas Tax 206,501 221,107 14,606 7.07%
Better Jax 1/2 Cent Sales Tax 636,119 666,185 30,065 4.73%
Police Training, Forfeiture, Grants, etc. 145,017 139,584 (5,433) -3.75%
Capital Projects 3,056,814 3,055,777 (1 ,037) -0.03%
Utility 4,737,625 5,042,644 305,019 6.44%
Sanitation 682,917 717,950 35,033 5.13%
Building Code Enforcement 1,591,336 1,605,293 13,957 0.88%
Storm Water 1,612,544 1,683,905 71,361 4.43%
Pension -Police 11,727 6,193 (5,534) -47.19%
Pension -General 77 996 85 897 7 901 10.13%
Total $ 21,891,225 $ 22,268,943 $ 377,717 1.73%
Total Restricted Cash 7,078,059
Total Unrestricted Cash $15,190,884
Cash and Investments
Annual Prior Current Dollar Percent
Account Yield 02/28/15 03/31/15 Change Change
Bank of America -Depository 0.20% $ 6,066,879 $ 6,438,996 $ 372,117 6.13%
Delaware Diversified Inc. 2.64% 2,525,009 2,529,136 4,127 0.00%
Hartford Floating Rate Bond A 4.79% 1,535,833 1,538,937 3,104 0.20%
lnvesco Floating Rate A 4.10% 742,359 745,662 3,303 0.44%
MainStay Short Term Duration High Yield A 3.99% 2,609,580 2,611,851 2,271 0.09%
Lord Abbett St Duration Inc A 2.77% 2,997,933 3,007,529 9,596 0.32%
Putnam Diversified Inc. 4.43% 1,700,487 1,677,513 (22,973) -1.35%
Alliance Limited Duration High Income A 3.22% 1,205,403 1,207,121 1,718 0.14%
Voya Floating Rate 3.84% 2,502,480 2,507,933 5,453 0.00%
MSSB Money MarkeUCash 0.02% 1,778 2,462 684 0.00%
SBA -Florida Prime 0.19% 334 334 0 0.01%
Cash on Hand 3 150 1 467 (1 ,683} -53.42%
Subtotal $ 21,891,225 $ 22,268,943 $ 377,717 1.73%
Police Pension Investments $ 8,878,300 $ 8,829,504 $ (48,796) -0.55%
General Pension Investments 16 015 438 15,903,005 (112,433} -0.70%
Subtotal $ 24,893,737 $ 24,732,509 $ (161,229) -0.65%
Total $ 46,784,962 $ 47,001,451 $ 216,489 0.46%
• Denotes the 30 day SEC Yield Anualized
City of Atlantic Beach AGENDA ITEM #4A
FINANCIAL REPORT MAY26,2015
March 2015
Revenues
Annual YTD YTD Dollar
Fund I (Footnote) Estimate Estimate Actual Variance
General $ 11,335,175 $ 5,664,669 $ 7,443,318 $ 1,778,649
Convention Development Tax 88,300 44,142 61,008 16,866
Local Option Gas Tax 435,909 217,950 224,146 6,196
Better Jax 1/2 Ct Sales Tax 714,864 357,426 377,047 19,621
Police Training, Forfeiture & Grants 99,954 48,977 37,604 (11,373)
Grants 91,386 45,690 (45,690)
Capital Projects 230,000 114,990 100,416 (14,574)
Utility 8,303,752 4,151,826 4,245,381 93,555
Sanitation 2,123,709 981 '164 918,287 (62,877)
Building Code Enforcement 446,000 222,984 203,016 (19,968)
Storm Water
Pension -Police
Pension -General
1 '135,500 567,744 563,580 (4, 164)
1,440,505 720,240 884,273 164,033
2,127,619 1,063,800 1,596,290 532,490
Total $ 28,572,673 $ 14,201,602 $ 16,654,366 $ 2,452,764
Analysis of Major Variances
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. Highlighted variance explanations
follow:
General Fund has a positive variance of $1,778,649. Most of the variance is due to the
timing of receipt of ad valorem taxes, the majority of which are received in late November
and December.
Grant Fund has a negative variance of $45,690. Grant revenues are delayed as the initial
reimbursement request is fully audited before the state will disburse funds. FDLE has a
routine scheduled site visit May 191h. At which point previously expended funds will be
reimbursed.
Utility Fund has a positive variance of $93,555. The positive variance is a result of
receiving grant reimbursement in current year for prior year expenditures.
Pension Funds reflect significant, year to date positive variances due to the increased
value of investments, $164,033 for Police Officers and $532,490 for General Employees.
Percent
Variance
31.40%
38.21%
2.84%
5.49%
-23.22%
-100.00%
-12.67%
2.25%
-6.41%
-8.95%
-0.73%
22.77%
50.06%
17.27%
City of Atlantic Beach AGENDA ITEM #4A
FINANCIAL REPORT MAY26,2015
March 2015
Expenses
Annual YTD YTD Dollar
Department Estimate Estimate Actual Variance
Governing Body $ 41,665 $ 20,808 $ 19,033 $ 1,775
City Administration 2,691,488 1,345,512 1,123,607 221,905
General Government 965,031 401,756 320,662 81,094
Planning and Building 493,820 246,804 212,370 34,434
Public Safety 8,440,668 4,219,013 2,501,449 1,717,564
Recreation and Special Events 364,353 182,112 181,443 669
Public Works 8,328,143 4,146,589 2,638,906 1,507,683
Public Utilities 9,263,936 5,072,463 3,304,782 1,767,681
Pension -Police 753,119 376,524 314,832 61,692
Pension-General 957,880 478,920 546,687 (67,767}
Total $ 32,300,103 16,490,501 11,163,771 $5,326,730
Annual YTD YTD Dollar
Resource Allocation Estimate Estimate Actual Variance
Personnel Services $ 9,754,170 $ 4,876,720 $ 4,256,824 $ 619,896
Operating Expenses 11,646,516 5,657,680 5,295,521 362,159
Capital Outlay 7,359,569 3,679,593 615,213 3,064,380
Debt Service 2,152,818 1,583,358 286,199 1 ,297,159
Grants and Aids 38,820 19,068 35,910 (16,842)
Transfers 1 348 210 674 082 674 104 (22}
Total $ 32,300,103 $ 16,490,501 $ 11,163,771 $ 5,326,730
Analysis of Major Variances
In general, the major variances are a result of timing differences created between the percentage of budget
elapsed-to-date and actual expenditures. Highlighted variance explanations follow:
Public Safety reflected a $1,717,564 positive variance due primarily to the timing of capital expenditures
related to the new Public Safety building.
Public Works had a positive variance of $1,507,683. Most of the variance is the result of project activity
budgeted that has not been started/completed -see Project Activity Schedule.
Public Utilities had a positive variance of $1,767,681. Most of the variance is the result of project activity
budgeted that has not been started/completed-see Project Activity Schedule.
Capital Outlay had a positive variance of $3,064,380. Most of the capital and project expenditures occur
in the middle to latter part of the fiscal year.
Debt Service reflects a significant variance of $1,297,159. The budgeted principal and interest
payments for October of this year were paid on September 30, 2014.
Percent
Variance
8.53%
16.49%
20.18%
13.95%
40.71%
0.37%
36.36%
34.85%
16.38%
-14.15%
32.30%
Percent
Variance
12.71%
6.40%
83.28%
81.92%
-88.33%
0.00%
32.30%
City of Atlantic Beach AGENDA ITEM #4A
FINANCIAL REPORT MAY26,2015
March 2015
Project Activity-Current Year Activity Only
Project YTD YTD
Project Name Number Budget Actual Encumbrances Balance Status
Public Safety:
Design & Construct New Police Building PS1501 2,600,000 188,702 2,411,298 s
$2,600,000 $ $ 188,702 $ 2,411,298
Public Utilities:
Reclaim Water Facility PU0805 135,399 121,330 14,069 0 I
PT Repair at Lift Station C PU1306 6,500 6,500 c
lnline Valve Installation PU1404 36,515 36,250 265 I
Effluent Outfall Replacement PU1408 11,625 11,624 1 I
Effluent Pump at WWTP PU1409 14,478 14,478 0 I
Connect A 1 A at Mallard Cove PU1410 126,662 650 6,662 119,350 D
Well Logging-6 Wells PU1501 30,000 30,000 s
Update Models PU1502 30,000 11,838 18,162 E
Replace WM on Seminole Rd 5-Way to Atlantic Blvd PU1503 700,000 700,000 E
Replace Effluent Outfall Line-Sherman Point (Cost Share) PU1504 320,000 320,000 I
Lining of Wetwell at Mimosa Cove Lift Station PU1505 19,505 5,550 13,954 1 I
Lining of Wetwell at Fairway Villas Lift Station PU1506 20,341 6,200 14,141 0 I
Clean and Televise Effluent Gravity Outfall to ICW PU1507 15,218 15,218 s
Fence/Wall at WWTP PU1508 80,000 80,000 s
Replace Irrigation System With Reuse System PU1509 20,000 2,600 480 16,920 s
Subtotal $ 1,566,243 $ 169,146 $ 112,398 $ 1,284,700
Parks Maintenance:
Rose Park Development PM1302 5,276 5,293 (17) c
Russell Park Tennis Courts 1-2 PM1401 98,136 98,136 0 c
Electric Gate at Dutton Island Park PM1404 4,466 4,272 194 I
Russell Park Renovation PM1501 250,000 250,000 s
Howell Park Parking Lot lmprovemens PM1502 25,000 25,000 s
Donner Park Playground Lights PM1503 10,000 10,000 s
Bull Park Playground Equipment & Swing PM1504 75,000 75,000 s
Dutton Island Road Improvements PM1505 25,000 25,000 s
Marsh Project Pedestrian Path PW1408 97,220 18,576 78,644 0 E
March Overlook & Kayak Launch PW1409 300,000 1,700 298,300 E
Subtotal $ 890,098 $ 127,976 $ 153,644 $ 608,478
Public Works:
Robert Street Ditch PW1404 14,213 14,212 1 I
Salt Air/Sturdivant Drainage and Sidewalk lmprovmts PW1406 132,700 2,700 130,000 E
Seminole Streetscape PW1407 316,660 8,957 57,702 250,002 E
Saltair Drainage Improvements PW1411 250,000 250,000 E
South End of Seminole Road Drainage CIP PW1412 650,000 650,000 E
Batting Cage Mat I Russell Park PW1416 10,966 10,966 c
Bike Racks & Street Lights PW1501 20,000 20,000 s
Francis Avenue Drainage Improvements (CDBG) PW1502 94,200 94,200 E
Begonia Street W 6th to W 9th -Design Only PW1503 30,000 30,000 s
City Hall Parking Lot Lighting -Last Section PW1504 10,000 10,000 s
Subtotal $ 1,528,739 $ 19,923 $ 74,614 $ 1,434,203
Total $ 6,585,080 $ 317,045 $ 529,357 $ 5,738,678
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