Item 4A - Building Dept and Finance Dept Monthly ReportsBUILDING DEPT. MONTHLY ACTIVITY REPORT
COMPARISON REPORT
REPORT FOR THE MONTH JULY 2015
COMPARISON 2014-2015
PERMIT TYPE NUMBER OF PERMITS I TOTAL INSPECTIONS
YTD 2014 YTD 2015 YTD 2014 YTD 2015 YTD 2014 YTD 2015
SINGLE FAMILY 14 62 $ 5,397,041 $ 12,209,575
DUPLEX -7 $ -$ 81,900
REMODEL/ADDITIONS 238 165 $ 3,573,858 $ 2,450,079
COMMERCIAL NEW 7 1 $ 2,225,427 $ 950,000
OTHER 1 571 923 $ 4,796,305 $ 1,351,745
TOTAL 1,830 1,158 $ 15,992,631 $ 17,043,299 2,942 3,460
PERMITS ISSUED FOR THE MONTH OF JULY 2015
NO.PERMITS PERMIT COST CONSTRUCTION VALUE INSPECTIONS PERFORMED
SINGLE FAMILY/SF ATTACH 9 $ 52,739 $ 4,273,982 BUILDING 368
NEW DUPLEX MUL Tl FAM 2 $ 13,677 $ 400,000 ELECTRICAL 83
RESIDENTIAL ADDITIONS 3 $ 3,375 $ 286,000 PLUMBING 90
RESIDENTIAL ALTERATIONS 11 $ 1,569 $ 111,087 MECHANICAL 59
COMMERCIAL NEW 0 $ -$ -MISC. 58
COMMERCIAL ADDITIONS 2 $ 3,310 $ 71,000
COMMERCIAL ALTERATIONS 0 $ -$ -TOTAL
PERMITS MISC 13 $ 1,025 $ 11,215 658
ELECTRICAL 64 $ 6,710 $ -
MECHANICAL GAS 10 $ 856 $ 1,400
MECHANICAL HVAC 55 $ 6,081 $ -
PLUMBING 29 $ 4,227 $ -
ROOFING 19 $ 2,078 $ 168,578 SURCHARGE COLLECTED:
WINDOW/DOOR 27 $ 3,664 $ 209,974 ~11480.62
DEMOLITION 0 ;j) -;p -
REINSPECTION FEES 0 $ -$ -TREE REMOVALS:
OCCUPANCY INSPECTIONS 0 $ -$ -
SIGNS 1 $ 79 $ 9,483 Inches Removed: 79
FENCES 8 $ 280 $ -Inches Preserved: 0
DRIVEWAYS/ROW 7 $ 890 $ -Inches Relocated: 0
SIDING 5 $ 903 $ 28,000 Inches Planted: 10 >
POOL I 0 $ -$ -Paid in Mitigation $1,469.00 c
('J
$ -$ -d
r;J
TOTAL 265 $ 101,463 $ 5,570,719 >-3
N
I ~,..
N
AGENDA ITEM# 4A
City of Atlantic Beach AUGUST 24, 2015
FINANCIAL REPORT
July 2015
Cash Balances
Prior Current Dollar Percent
Fund(s) 06/30/15 07/31/15 Change Change
General $ 8,101,080 $ 7,967,494 $ (133,586) -1.65%
Tree Replacement 18,606 19,001 396 2.13%
Convention Development Tax 77,141 95,643 18,502 23.98%
Local Option Gas Tax 94,383 118,586 24,203 25.64%
Better Jax 1/2 Cent Sales Tax 641,396 646,049 4,653 0.73%
Police Training, Forfeiture, Grants, etc. 142,131 135,829 (6,302) -4.43%
Capital Projects 3,058,407 3,042,939 (15,469) -0.51%
Utility 5,316,563 5,661,761 345,197 6.49%
Sanitation 412,293 391,306 (20,987) -5.09%
Building Code Enforcement 373,171 395,106 21,935 5.88%
Storm Water 1,780,115 1,782,024 1,908 0.11%
Pension -Police 6,646 4,730 (1,916) 0.00%
Pension -General 73,991 73,857 (134} -0.18%
Total $ 20,095,924 $ 20,334,323 $ 238,399 1.19%
Total Restricted Cash 7,064,556
Total Unrestricted Cash $13,269,767
Cash and Investments
Annual Prior Current Dollar Percent
Account Yield 06/30/15 07/31/15 Change Change
Bank of America-Depository $ 4,219,080 $ 4,416,740 $ 197,660 4.68%
Alliance Limited Duration High Income A 2.94% 1,213,712 1,213,884 171 0.01%
Delaware Diversified Inc. 2.79% 2,490,326 2,500,365 10,039 0.00%
Guggenheim Floating Rate Strategies Fund 4.06% 4,199,316 4,203,200 3,884 100.00%
lnvesco Floating Rate A 4.35% * 747,417 746,351 (1,066) -0.14%
Voya Floating Rate 4.01% 3,023,124 4,206,066 1,182,942 0.00%
Hartford Floating Rate Bond A 4.17% 4,198,050 (4,198,050) -100.00%
Lord Abbett St Duration Inc A 2.50% . 3,019,298 3,019,298 #DIV/0!
MSSB Money Market/Cash 2,462 2,462 0.00%
SBA-Florida Prime 334 22,808 22,473 6723.76%
Cash on Hand 3,150 3,150 0.00%
Subtotal $ 20,096,971 $ 20,334,323 $ 237,351 1.18%
Police Pension Investments $ 8,971,154 $ 9,135,163 $ 164,009 1.83%
General Pension Investments 16,110,222 16,398 657 288,434 1.79%
Subtotal $ 25,081,376 $ 25,533,820 $ 452,443 1.80%
Total $ 45,178,347 $ 45,868,142 $ 689,795 1.53%
* Denotes the 30 day SEC Yield Anualized
City of Atlantic Beach
FINANCIAL REPORT
July 2015
AGENDA ITEM# 4A
AUGUST 24, 2015
Revenues
Annual YTD YTD Dollar
Fund I (Footnote) Estimate Estimate Actual Variance
General $ 11,335,175 $ 9,444,685 $ 10,075,082 $ 630,397
Convention Development Tax 88,300 73,570 107,841 34,271
Local Option Gas Tax 435,909 363,250 371,402 8,152
Better Jax 1/2 Ct Sales Tax 714,864 595,710 633,856 38,146
Police Training, Forfeiture & Grants 99,954 82,945 67,337 (15,608)
Grants 91,386 76,150 -(76, 150)
Capital Projects 230,000 191 ,650 139,383 (52,267)
Utility 8,303,752 6,919,710 7,202,792 283,082
Sanitation 2,123,709 1,742,844 1,853,141 110,297
Building Code Enforcement 446,000 371,640 382,531 10,891
Storm Water 1 '135,500 946,240 943,882 (2,358)
Pension -Police 1,440,505 1,200,400 1,396,696 196,296
Pension -General 2,127,619 1,773,000 2,457,153 684,153
Total $ 28,572,673 $ 23,781,794 $ 25,631,096 $ 1,849,302
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 $630,397. 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.
Utility Fund has a positive variance of $283,082. 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, $196,296 for Police Officers and $684,153 for General Employees.
Percent
Variance
6.67%
46.58%
2.24%
6.40%
-18.82%
-100.00%
-27.27%
4.09%
6.33%
2.93%
-0.25%
16.35%
38.59%
7.78%
AGENDA ITEM# 4A
City of Atlantic Beach AUGUST 24, 2015
FINANCIAL REPORT
July 2015
Expenses
Annual YTD YTD Dollar
Department Estimate Estimate Actual Variance
Governing Body $ 41,665 $ 34,680 $ 32,630 $ 2,050
City Administration 2,691,488 2,242,520 1,893,117 349,403
General Government 965,031 777,164 474,848 302,316
Planning and Building 493,820 411,340 380,361 30,979
Public Safety 8,440,668 7,033,005 4,458,676 2,574,329
Recreation and Special Events 364,353 303,519 285,931 17,588
Public Works 8,328,143 6,946,589 5,105,652 1,840,937
Public Utilities 9,263,936 8,042,602 6,640,848 1,401,754
Pension -Police 753,119 627,540 516,419 111,121
Pension -General 957,880 798,200 903,947 {105,747}
Total $ 32,300,103 27,217,159 20,692,429 $6,524,730
Annual YTD YTD Dollar
Resource Allocation Estimate Estimate Actual Variance
Personnel Services $ 9,714,030 $ 8,108,903 $ 7,481,682 $ 627,221
Operating Expenses 11 ,681 ,491 9,661,381 8,558,292 1 '1 03,089
Capital Outlay 7,364,734 6,139,288 1,442,087 4,697,201
Debt Service 2,152,818 2,151,893 2,050,465 101,428
Grants and Aids 38,820 32,224 36,395 (4,171)
Transfers 1,348,210 1,123,470 1 '123,508 {38}
Total $ 32,300,103 $ 27,217,159 $ 20,692,429 $ 6,524,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 $2,574,329 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 ,840,937. 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,401,754. 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 $4,697,201. Most of the capital and project expenditures occur
in the middle to latter part of the fiscal year.
Percent
Variance
5.91%
15.58%
38.90%
7.53%
36.60%
5.79%
26.50%
17.43%
17.71%
-13.25%
23.97%
Percent
Variance
7.73%
11.42%
76.51%
4.71%
-12.94%
0.00%
23.97%
AGENDA ITEM# 4A
City of Atlantic Beach AUGUST 24, 2015
FINANCIAL REPORT
July 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 38,318 155,637 2,406,045 E
$2,600,000 $ 38,318 $ 155,637 $ 2,406,045
Public Utilities:
Reclaim Water Facility PU0805 135,399 133,686 1,713 c
PT Repair at Lift Station C PU1306 6,500 6,500 c
lnline Valve Installation PU1404 36,515 19,651 16,355 509 I
Effluent Outfall Replacement PU1408 11,625 11,624 1 I
Effluent Pump at WWTP PU1409 14,478 14,478 0 I
Connect A1A at Mallard Cove PU1410 126,662 6,024 86,331 34,306 I
Well Logging-6 Wells PU1501 s
Update Models PU1502 48,000 11,838 35,191 971 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 c
Lining of Wetwell at Fairway Villas Lift Station PU1506 20,341 6,200 14,141 0 c
Clean and Televise Effluent Gravity Outfall to ICW PU1507 15,218 15,218 I
Fence/Wall at WWTP PU1508 80,000 80,000 s
Replace Irrigation System With Reuse System PU1509 20,000 7,023 1,540 11,437 s
Subtotal $ 1,554,243 $ 210,950 $ 194,355 $ 1,148,938
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 c
Russell Park Renovation PM1501 250,000 5,442 59,092 185,466 A
Howell Park Parking Lot Improve mens PM1502 15,000 15,000 s
Donner Park Playground Lights PM1503 10,000 10,000 s
Bull Park Playground Equipment & Swing PM1504 75,000 74,300 649 51 c
Dutton Island Road Improvements PM1505 23,500 23,500 s
Marsh Project Pedestrian Path PW1408 97,220 40,716 56,504 0 E
March Overlook & Kayak Launch PW1409 311,500 152,826 (121 ,621) 280,295 B
Subtotal $ 890,098 $ 380,986 $ (5,377) $ 514,489
Public Works:
Robert Street Ditch PW1404 14,213 14,213 c
Salt Air/Sturdivant Drainage and Sidewalk lmprovmts PW1406 132,700 44,753 87,947 N
Seminole Streetscape PW1407 316,660 39,685 26,973 250,002 E
Saltair Drainage Improvements PW1411 250,000 86,066 163,934 I
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 16,252 2,740 6,789 6,723 B
Francis Avenue Drainage Improvements (CDBG) PW1502 94,200 83,685 11 ,014 (499) I
Begonia Street W 6th toW 9th-Design Only PW1503 30,000 30,000 c
City Hall Parking Lot Lighting-Last Section PW1504 10,000 9,554 446 B
Subtotal $ 1,524,991 $ 267,895 $ 306,212 $ 950,884
Total $ 6,569,332 $ 898,149 $ 650,826 $ 5,020,357
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