Loading...
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