Agenda Item 4ACity of Atlantic Beach AGENDA ITEM 4A
JULY 23 2012FINANCIALREPORT
JUNE 2012
Cash Balances
Prior Current Dollar
Funds 053112 063012 Change
General 6928436 6686105 242331
Tree Replacement 3509 3509 0
Convention Development Tax 16397 28798 12401
Local Option Gas Tax 265033 294411 29378
Better Jax 12 Cent Sales Tax 113644 102117 11527
Police Training Forfeiture Grants etc 120201 133557 13356
Community Development Block ARRA Grants 106091 83432 22659
Debt Service 52895 56062 3167
Capital Projects 2553953 2595948 41995
Utility 3901209 5740687 1839478
Sanitation 689190 676784 12406
Building Code Enforcement 38305 49260 10955
Storm Water 1201804 1237432 35628
Pension Police 12012 17246 5234
Pension General 194241 240897 46656
Investments Unallocated Gains Losses 49032 89135 40103
Total 16033770 17868516 1834746
Total Restricted Cash 7867938
Total Unrestricted Cash 10000578
Cash and Investments
Prior Current Dollar Interest
Account 053112 063012 Change Rate
Bank of America Depository 2676766 4431530 1754764 025
Columbia Limited Duration Fund 2055583 2064727 9144 163 1
Delaware Diversified Income Fund 1631547 1640152 8605 264 1
Lord Abbett Short Duration Fund 1613999 1626487 12488 294 1
Putnam Diversified Income Fund 1949642 1956803 7161 542 1
Putnam Income Fund 2000554 2008009 7455 223 1
American Century GNMA Fund 1000890 999192 1698 238 1
Alliance Limited Duration High Income Fund 2095874 2128719 32845 417 1
Legg Mason WA Cash Reserve Fund 1000036 1000204 168 020
MSSB Money MarketCash 5432 9245 3813 000
SBA Florida Prime 297 298 1 031
Cash on Hand 3150 3150 0 NA
Subtotal 16033770 17868516 1834 746
Rate of
Return
Police Pension Investments 6595700 6704890 109190 934 2
General Pension Investments 11543743 11812716 268973 1175 2
Subtotal 18139443 18517606 378163
Total 34173213 36386122 2212909
1 30 day SEC Yield as of 063012
2 Fiscal Year to Date Rate of return as of 063012
City of Atlantic Beach AGENDA ITEM 4A
FINANCIAL REPORT JULY 23 2012
JUNE 2012
Revenues
Annual YTD 75 YTD Dollar Percent
Fund Footnote Estimate of Estimate Actual Variance Variance
General 1 10964642 8223482 9025151 801669 975
Convention Development Tax 72000 54000 129914 75914 14058
Local Option Gas Tax 472612 354459 322147 32312 912
Better Jax 12 Ct Sales Tax 646212 484659 482522 2137 044
Police Training Forfeiture Grants etc 138796 104098 119365 15267 1467
Grants 519658 389744 299461 90283 2316
Debt Service 71300 53475 54268 793 148
Capital Projects 2 2266207 1699656 410368 1289288 7586
Utility 3 8368949 6276712 11145298 4868586 7757
Sanitation 1804500 1353375 1328149 25226 186
Building Code Enforcement 265900 199425 197421 2004 100
Storm Water 972200 729150 725207 3943 054
Pension Police 4 1232311 924233 1046805 122572 1326
Pension General 4 2122019 1591514 2172114 580600 3648
Total 29917306 22437982 27458190 5020208
Analysis of Major Variances
1 The 801669 positive variance in the General Fund resulted from having received
994 of the budgeted property taxes Typically the majority of the property taxes are
received from the City of Jacksonville in December
2 The 1289288 negative variance in the Capital Projects Funds resulted from not
having received the proceeds from the proposed loan for the new Public Safety building
If the loan was not included in this calculation the variance would be a positive 76
3 The 4868586 positive variance in the Utility Funds resulted from receiving proceeds
from the State Revolving Fund Loan for the sewer plant improvements If the loan was
not included in this calculation the variance would be a positive 2
4 The 122572 positive variance in the Police Employee Pension Fund the 580600
positive variance in the General Employee Pension Fund resulted from changes in
market values of the investments
City of Atlantic Beach AGENDA ITEM 4A
FINANCIAL REPORT JULY 23 2012
JUNE 2012
Expenses
Annual YTD 75 YTD Dollar Percent
Department Footnote Estimate of Estimate Actual Variance Variance
Governing Body 41986 31490 31065 425 135
City Administration 2660587 1995440 1782699 212741 1066GeneralGovernment8026946020214703771316442187
Planning and Building 550867 413151 306046 107105 2592PublicSafety13101121387584105403731935467864677RecreationandSpecialEvents394207295655296343688023
Public Works 2 3 6123436 4592580 3835328 757252 1649
Public Utilities 14418298 10813718 10843363 29645 027
Pension Police 587832 440874 501528 60654 1376
Pension General 740710 555533 566971 11438 206
Total 36432755 27324567 22671039 4653528
Annual YTD 75 YTD Dollar Percent
Resource Allocation Estimate of Estimate Actual Variance Variance
Personnel Services 3 9826165 7369624 6923705 445919 605
Operating Expenses 1 2 10526058 7894544 7143169 751375 952
Capital Outlay 1 2 12114743 9086057 5559919 3526138 3881
Debt Service 2297807 1723355 1790776 67421 391
Transfers 1667982 1250987 1253470 2483 020
Total 36432755 27324567 22671039 4653528
Analysis of Major Variances
1 The positive variance in the Public Safety divisions resulted from 3 of the budgeted
amount expended fiscal year to date on the Police Building see Project Activity
Schedule The variance without the budget for the Police Building is a positive 57
2 The positive variance in the Public Works divisions resulted from 285 expended
fiscal year to date on the paving projects funded by the Local Option Gas Tax Fund only8ofthe9paymentsbeingpaidonthe1VehiclesAdvancedDisposalServices
contracts 411 expended fiscal year to date on the Stormwater Contractual Services
106 expended fiscal year to date on projects see Project Activity Schedule
3 The positive variance in the Personnel Services resulted from vacant positions that
have not been filled or have been filled with employees at a lesser wage benefits The
vacancies or replacements include the following departments Public Works Painters
City Manager Planning Development Police Public Utilities Finance Human
Resources Lifeguards The Lifeguards are typically seasonal employees working MaythroughSeptember
City of Atlantic Beach
FINANCIAL REPORT AGENDA ITEM 4A
JUNE 2012 JULY 23 2012
Project Activity Current Year Activity Only
Project YTD YTD
Project Name
Number Budget Actual Balance Status
Public Safety
Retrofit HVAC Systems GG1201 224135 54603 169532 ILifeguardBuildingRoofReplacementLG0901475047500CPoliceBuildingRenovationDesignConstructionPS05044432582143644418218E
4661467 73717 4587750
Public Utilities
TMDL Lift Station Main Transfer Flow PU0906 72810 51547 21263 IDonnerSubdivisionSewerRehabilitationPU10151755901738131777C
Replace 2 Water Main 11th Street PU1104 61283 57403 3880 ITMDLUpgradeConstructionWWTP1PU110632188512885596333255I
TMDL SludgeOdor Improvements PU1110 2392785 1665981 726804 IElevatedTank1InternalRehabilitationPU1201000RGroundStorageTankWP2InteriorRehabilitationPU1202000RGroundStorageTanksWP3RecoatInteriorPU1203000X
Water Main 12th Street at Ocean BlvdBeach Ave PU1204 60000 8456 51544 D
Water Main 14th 15th Street at Ocean Boulevard PU1205 294302 8363 285939 D
Sewer Rehabilitation Area B PU1206 380000 350684 29316 I
Water Plant 1 New Concrete Vault PU1207 13275 10730 2545 I
Subtotal 6668896 5212573 1456323
Public Works
Riverbranch Preserve Kayak Canoe Launch PM0804 16113 14906 1207 C
Parking Improvements Donner Park PM1106 109901 6000 103901 E
Veterans Park Phase II Memorial Garden PM1110 13102 2632 10470 D
Howell Park Bridge Replacement PM1201 25000 0 25000
Bull Park Playground Equipment Replacement PM1202 40000 0 40000
Sidewalk Curb Replacement PW1101 5406 5406 0 C
Sidewalk Curb Replacement PW1201 13543 19 13562 I
East Coast Drive Drainage Improvements PW1202 50000 0 50000
Subtotal 273065 28925 244140
Total 11603428 5315215 6288213
Status Key
A Bid Advertised I Project In progress
B Bid Awarded N Complete Non Capital
C Project Completed R Re budget Next Fiscal Year
D Design Completed X Project Cancelled
E Design Phase
BUILDING DEPT MONTHLY ACTIVITY REPORT
COMPARISON REPORT
REPORT FOR THE MONTH OF JUNE 2012
COMPARISION 2011 2012
PERMIT TYPE NUMBER OF PERMITS TOTAL INSPECTIONS
YTD 2011 YTD 2012 YTD 2011 YTD 2012 YTD 2011 YTD 2012
SINGLE FAMILY 13 12 196600000 368297000
DUPLEX 0 0 000
REMODELADDITIONS 246 146 584977700 298941300
COMMERCIAL NEW 1 0 2500000
OTHER 673 975 150121600 650145000
TOTAL 933 1133 934199300 1317383300 2165 2101
PERMITS ISSUED FOR THE MONTH JUNE
1
NOPERMITS PERMIT COST CONSTRUCTION VALUE INSPECTIONS PERFORMED
SINGLE FAMILY 4 921000 184000000 BUILDING 190
NEW DUPLEX MULTI FAM ELECTRICAL 54
RESIDENTIAL ADDITIONS 6 198000 32800000 PLUMBING 56
COMMERCIAL NEW MECHANICAL 52
COMERCIAL ADDITIONS MISC 2
COMMERCIAL ALTERATIONS 8 659250 136640000
PERMITS MISC 32 480950 55525300 TOTAL 354
ELECTRICAL 26 226480
MECHANICAL GAS FIRE 6 68200
MECHANICAL HVAC 30 329000 360000
PLUMBING 23 229400
ROOFING 23 155970 13054800
WINDOW DOOR 12 60500 1440500
DEMOLITION 4 40000
REINSPECTION FEES
PERMIT RENEWALS Projects to Note
OCCUPANCY INSPECTIONS 2 20000 New Homes
PENALTY FEES 2 29800 784000 YSIGNS3255001262817616thStc
toFENCES51750012696330CountryClubLnrz
RW DRIVEWAYS 5 21000 12 748 465 Inland Way d
POOLS 6 99750 10300000 12 756 310 6th Street W
WELLS 1 3500 0
SIDING 2 12000 525000
TOTAL 200 3597800 435429600 a
AGENDA ITEM 4ARecreationProgramsSpecialEventsJULY232012
City of Atlantic Beach Commission Report
June 2012
Upcoming Events Programs in Twilight Mo r g t
August Summer Camp ends
Events Rentals Facilities Participants
Featured Events in June Summer Camp Acoustic Night Wild 351
Wonders Songwriters Concert Brinkley visitsExhibit
One Time Facility Rentals Community Center Rentals 5 no fee 1
Adele Grage recurring use 18
Special Events Permits Weddings on beach or parks 6
Pavilions Parks 17
Camping Dutton 3
Beach handicap chair 2
Other 6
Recreation Usage of Facilities Donner Tennis off for s ummer 52
After School Programs Donner Summer Camp S2
City Sponsored Events Acoustic Night 2 90
Songwriters Concert 60
Wednesday Market weekly 75
Exhibit Beach Art Walk Reception 15
Sunset Boardwalk
Wild Wonders 37
City Contract Programs Yoga 4 weeks 19
Tennis Beaches Tennis 28
Kayak Dutton Island 30
ABET plays drama showcase 175
ABET summer camps 13
Staff D irector AA Recreation Leaders 4
Volunteers
Cultural Arts Rec Adv Comm 8
Summer Camp volunteers 4
0V ONAN
s p
x Acoustic Night
PUBLIC WORKS and UTILITY DEPARTMENTS
PROJECT STATUS REPORT
D DESIGN ENGINEER CE I CONSTRUCTION ENGINEER INSPECTION C CONTRACTOR VE VALUE ENGINEERING
PROJECT DESCRIPTION PROJECT NO AND INFORMATION STATUS ON 71012
1 TMDL Wastewater Project D J Collins Engineering Assoc Force main construction complete Master lift station at
Forcemain Construction 100 VE ATM Buccaneer complete New equipment installation and baffle
WWTP 1 Construction 96 C TB Landmark Forcemain walls completed in aerationtanks 3 4 Baffle walls
Sludge Odor Control 74 WPC Industrial Contractors WWTP and completed in aeration tanks 1 2 installing equipment
Sludge Odor Control Effluent filters installed and operational Plant reuse facility
installed New screens installed New blowers installedCEIJCollinsEngineeringAssoc
awaiting vendor installation of oil coolers and
programming Clarifier repairs complete New
generator installed Continuing construction of new sludge
building New centrifuge installed completing electrical and
electronic work Installing conveyor system Installing
diffusers equipment and piping in digester Odor control
unit placed installing piping electrical and controls
2 FY 12 Water Main Project D Bowen Civil Engineers Bids received 5212 Commission awarded entire project to
Design 100 Survey LD Bradley Gruhn May contingent upon approving Budget Modification
Construction 0 C Gruhn May Ordinance approved 62512 Preconstruction meeting
CE I Public Utilities scheduled held 7912
3 FY 12 Sewer Rehabilitation Project D Public Utilities Commission approved contracts on 1912 Construction
Design 100 C Insituform CCI Gruhn May underway Major sewer repair on Willow Cove complete
Construction 80 CE I Public UtilitiesPW Most of sewer main CIPP complete Manhole lining
underway
4
Donner Park Community Development Grant ProjectsectsPJ
a New lighting for basketball C Limbaugh Electric Complete
courts
b Security lighting for Donner C Limbaugh Electric Complete
Community Center
c Grade and sod baseball field Complete
rz
d Top Grade southern end
Complete a
of soccer field p W
D ATM Design complete Bid awarded 7912 Construction to beeAddpavedparkingcompletebyendofAugust
N
a