The URL can be used to link to this page

Home My WebLink AboutR-17-32 Adopted CIP 2018-2023RESOLUTION NO. R-17-32 A RESOLUTION OF THE CITY COUNCIL OF THE CITY OF SEBASTIAN, INDIAN RIVER COUNTY, FLORIDA ADOPTING A SIX-YEAR CAPITAL IMPROVEMENT PROGRAM FOR FISCAL YEARS ENDING 2018-2023; PROVIDING REPEAL OF RESOLUTIONS OR PARTS OF RESOLUTIONS IN CONFLICT HEREWITH; PROVIDING FOR SEVERABILITY AND PROVIDING FOR AN EFFECTIVE DATE. WHEREAS, the City of Sebastian, Indian River County, Florida finds that it is in the best interest of its citizens and taxpayers to provide for financial planning; and WHEREAS, a detailed capital budget is necessary for the proper annual operation of the City and its desired capital program; WHEREAS, the Six -Year Capital Improvement Program has been reviewed by both the City Council and the City Planning Zoning Commission; NOW, THEREFORE, BE IT RESOLVED BY THE CITY COUNCIL OF THE CITY OF SEBASTIAN, INDIAN RIVER COUNTY, FLORIDA as follows: Section 1. The Six -Year Capital Improvement Program for Fiscal Years Ending 2018-2023 for the City of Sebastian is attached hereto. Section 2. All Resolutions or parts of Resolutions in conflict herewith are hereby repealed. Section 3. This Resolution shall take effect immediately upon its adoption. The foregoing Resolution was moved for adoption by Councilmember Hill . The motion was seconded by Councilmember Kinchen and, upon being put into a vote, the vote was as follows: Mayor Bob McPartlan ave Vice -Mayor Andrea B. Coy AVP Councilmember Jim Hill ave Councilmember Linda Kinchen aye Councilmember Ed Dodd aye The Mayor thereupon declared this Resolution duly passed and adopted this 27`x' day of September, 2017 CITY 7STIAANrFLORIDA By: Bob McPartlan, Mayor ATTEST: "e6W-dUlams, City Clerk Approved as to form and legality for the reliance by the City of Sebastian only: _ = Cynthia V. Hall, Interim City Attorney CITY OF 5E13A$TbkN HOME OF PELICAN ISLAND CITY OF SEBASTIAN FLORIDA ANNUAL BUDGET FISCAL YEAR 2018-2023 CAPITAL IMPROVEMENT PROGRAM CITY OF SEBASTIAN, FLORIDA CAPITAL IMPROVEMENT PROGRAM FISCAL YEAR 2018-23 City of Sebastian's adopted financial policies requires the City to coordinate the development of the Capital Improvement Program with the development of the strategic plan and operating budget, as well as ensuring compliance with the Comprehensive Plan Capital Improvement Element. Operating expenditures and revenues associated with new capital improvements will be projected and included in the Capital Improvement Program Five - Year Forecast. The Capital Improvement Program is updated and approved by the City Council annually and encompasses a period of six years. What are Capital Improvements? Capital improvements include construction, reconstruction, expansion, upgrades and major repairs to streets, drainage systems, buildings, computer systems, parks, recreation centers, airport facilities, the cemetery, the golf course and other major components of the City's infrastructure. Vehicles and equipment additions and replacements are also included in the capital improvement program for consistency with the criteria used for defining capital purchases in the accounting records and the annual operating budget. Therefore, items in the Capital Improvement Program generally cost more than $750 and are expected to last at least one year. Policies Used in Developing the Capital Improvement Program Capital projects submitted for approval must be justified in terms of how the project supports the achievement of the City's Strategic Priorities. Projects are prioritized and approved based on the relevancy of the project to the City's Strategic Plan and the impact on the end stakeholder(s). The following statements are included in the City's adopted Financial Policies: 1. The City shall adopt an annual Capital Budget based on the Capital Improvement Program. Future capital improvement expenditures necessitated by changes in population, real estate development, or in economic base will be calculated and included in the capital improvement budget projections. 2. The City shall make all capital improvements in accordance with an adopted Capital Improvement Program budget. 3. The City will determine and use the most prudent financial methods for acquisition of capital improvement projects based upon market conditions at the time of acquisition. The pages that follow provide details and summary information on capital purchases scheduled for the next six years for all the City's operations. The expected sources of funding are identified for all the capital purchases but are ultimately dependent on the funds being legally appropriated within the City's adopted annual operating budget. Changes may ultimately be made in conjunction with alternative sources as they become available or adjustments may become necessary due to reductions in projected revenues. The timing of projects identified may also be altered from year to year to meet changing circumstances. Anticipated Continuation of Capital Projects Underway at Year -End The nature of some capital projects is such that they may continue into the following year(s) due to workload issues, permitting, design approval or other delays. The following is a listing of current projects that are anticipated to be carried forward to the FY 2017-18: Project Project Name Funding Remaining Remarks Number Sources Amount A1611 Police Evidence Garage DST $ 55,875 Construction initiated but will not be finalized by year-end. A1621 Working Waterfront Phase 2A DST/Grant $ 14,250 Construction initiated but will not be completed by year-end. A1713 MIS Server User Licenses DST $ 15,002 Delaying until October to match due dates on other licenses. AI724 Football Field Restrooms RIF $125,500 Bids too high. Project on hold to reconsider project scope. A1741 Golf Clubhouse Upgrades DST/Grant $189,683 Tenant vacated, upgrades to restrooms, A/C and floors initiated. A1764 Oyster Point Baffle Box SW $150,000 Project initiated late in year and will not be completed by year-end. A1765 Oyster Mat Project DST/Grant $ 24,000 Project initiated late in year and will not be completed by year-end. CITY OF SEBASTIAN, FLORIDA FISCAL YEAR 2018-2023 SUMMARY OF CAPITAL PURCHASES AND IMPROVEMENTS List of Prolects FY 2017.18 FY 2018.19 FY 2019-20 FY 2020.21 FY 2021-22 FY 2022.23 Totals General Government Audio Visual Equipment $ 30,000 $ - $ - $ - $ - $ - $ 30,000 Laserfiche Software Upgrade 50,000 - - - - - 50,000 Computer Replacements - 180,000 - - - 180,000 Computer Upgrades 30,000 30,000 30,000 30,000 30,000 30,000 180,000 Wireless System 5,000 - - - - - 51000 Firewall Software 75,650 - - - - - 75,650 UPS Bypass Switches - 12,000 - - - - 12,000 Police Department Police Vehicles and Equipment 350,000 350,000 300,000 300,000 300,000 300,000 1,900,000 Evidence Building Fixtures 20,000 50,000 - - - - 70,000 Police Personnel Equipment 20,000 6,000 6,000 6,000 6,000 6,000 50,000 Radio System Upgrades 57,000 50,000 100,000 50,000 - - 257,000 Power Source/Generator 17,000 - 200,000 - - - 217,000 Community Development Wayfinding Signage 50,000 - - - - - 50,000 Street Signage - 50,000 50,000 - - - 100,000 CRA Master Plan 50,000 - - - - - 50,000 Engineering -Streets & Special Projects Engineering Equipment - 14,500 10,000 - - - 24,500 CavCorp Paving - - - - - - - Stonecrop Drainage 750,000 - - - - - 750,000 Speed Cushions and Signage 5,000 - - - - 5,000 Street Milling and Repaving 451,000 320,000 250,000 250,000 250,000 250,000 1,771,000 Street Reconstruction 356,500 - - - - - 356,500 City Hall Parking Lot - 50,000 - - - - 50,000 Working Waterfront Phase 3 - 400,000 - - - - 400,000 Public Works - Road Operation & Maintenance Public Works Heavy Equipment - 275,000 125,000 - - - 400,000 Public Works Roads Vehicles - - 28,000 - - - 28,000 Public Works Garage Compound 100,000 2,850,000 1,150,000 - - - 4,100,000 Stormwater Stomwater Heavy Equipment - 145,000 290,000 70,000 145,000 - 650,000 Swale Improvement Grants 250,000 - - - - - 250,000 Slormwater Equipment - 1,800 78,000 20,000 80,000 35,000 214,800 Parks & Recreation Public Works Parks Mowers - 26,000 38,000 - - - 64,000 Public Works Parks Pickup Trucks - 30,000 30,000 - - - 60,000 Pickle Ball Courts 213,000 172,000 - - - - 385,000 Barber Street Ballfield Lighting 375,000 - - - - - 375,000 Replace Playground Components 25,000 25,000 25,000 25,000 25,000 25,000 150,000 ADA Playground 80,000 - - - - - 80,000 Riverview Park Tree Canopy 10,000 10,000 10,000 10,000 10,000 10,000 60,000 Cemetery Cemetery Mower - 13,000 - - - - 13,000 Irrigation System 150,000 - - - - - 150,000 Straightening of Headstones 24,375 - - - - - 24,375 Facilities Maintenance City HallfPolioe Air Conditioners 40,000 40,000 40,000 40,000 40,000 40,000 240,000 Fleet Management Public Works Fleet Equipment - 20,000 40,000 7,000 7,000 - 74,000 Golf Course Golf Course Small Equipment - 2,500 - - - - 2,500 Airport Airport Entrance Signage 10,000 - - - - - 10,000 Modernize Security Cameras 100,000 - - - - - 100,000 Taxiways C,D & E Construction 1,998,658 2,391,136 - - - - 4,389,794 Construct Access Road West - - - - 2,000,000 2,000,000 Engineer and Construct Hangar - - 1,125,000 1,125,000 - - 2,250,000 Construct Shade Hangars 625,000 - - 200,000 - - 825,000 Totals $ 6,318,183 $ 7,513,936 $ 3,926,000 $ 2,133,000 $ 2,893,000 $ 696,000 $ 23,479,119 CITY OF SEBASTIAN, FLORIDA FISCAL YEAR 2018-2023 SUMMARY OF CAPITAL IMPROVEMENT PROJECTS Total by Functions S 6,318,183 $ 7,513,936 $ 3,925,000 $ 2,133,000 $ 2,893,000 $ 696,000 $ 23,479,119 Grouped by Funding Source General Fund FY 2017-18 FY 2018-19 FY 2019-20 FY 2020-21 FY 2021-22 FY 2022-23 $ 463,500 Total Groaned by Department 4,532,819 2,460,000 755,000 615,000 370,000 10,748,664 LOGT 456,000 General Government $ 190,650 $ 222,000 $ 30,000 $ 30,000 $ 30,000 $ 30,000 $ 532,650 Police Department 464,000 456,000 606,000 356,000 306,000 306,000 $ 2,494,000 Community Development 110,000 60,000 60,000 10,000 10,000 10,000 $ 260,000 Public Works Department 35,000 464,800 Golf Course - 2,500 - - - Streets and Special Projects 1,562,500 784,500 260,000 250,000 250,000 250,000 $ 3,357,000 Road Operation & Maintenance 100,000 3,125,000 1,303,000 - - - $ 4,528,000 Stormwater 250,000 146,800 368,000 90,000 225,000 35,000 $ 1,114,800 Parks & Recreation 693,000 253,000 93,000 25,000 25,000 25,000 $ 1,114,000 Cemetery 174,375 13,000 - - - - $ 187,375 Facilities Maintenance 40,000 40,000 40,000 40,000 40,000 40,000 $ 240,000 Fleet Management - 20,000 40,000 7,000 7,000 - $ 74,000 Golf Course - 2,500 - - - - $ 2,500 Airport 2,733,658 2,391,136 1,125,000 1,325,000 2,000,000 - $ 9,574,794 Total by Departments $ 6,318,183 $ 7,513,936 $ 3,925,000 $ 2,133,000 $ 2,893,000 $ 696,000 $ 23,479,119 Grouped by Function General Government $ 515,025 $ 335,000 $ 130,000 $ 80,000 $ 80,000 $ 80,000 $ 1,220,025 Public Safety 464,000 456,000 606,000 356,000 306,000 306,000 2,494,000 Transportation 4,396,158 6,320,636 2,728,000 1,582,000 2,257,000 250,000 17,533,794 Parks & Recreation 693,000 255,500 93,000 25,000 25,000 25,000 1,116,500 Physical Environment 250,000 146,800 368,000 90,000 225,000 35,000 1,114,800 Total by Functions S 6,318,183 $ 7,513,936 $ 3,925,000 $ 2,133,000 $ 2,893,000 $ 696,000 $ 23,479,119 Grouped by Funding Source General Fund $ 45,000 $ 134,500 $ 177,000 $ 38,000 $ 38,000 $ 31,000 $ 463,500 DST 2,015,845 4,532,819 2,460,000 755,000 615,000 370,000 10,748,664 LOGT 456,000 320,000 250,000 250,000 250,000 250,000 1,776,000 Recreation Impact Fees 455;000 - - - - - 455,000 Riverfront CRA 110,000 60,000 60,000 10,000 10,000 10,000 260,000 Stormwater Fund 250,000 1,800 78,000 20,000 80,000 35,000 464,800 Golf Course - 2,500 - - - - 2,500 Airport 10,000 - - - - - 10,000 Grants 2,951,963 2,462,317 900,000 1,060,000 1,900,000 - 9,274,280 Cemetery 24,375 - - - - - 24,375 Total Funding Sources S 6,318,183 $ 7,513,936 $ 3,925,000 S 2,133,000 $ 2,893,000 S 696,000 $ 23,479,119 CITY OF SEBASTIAN, FLORIDA FISCAL YEAR 2018-23 CAPITAL IMPROVEMENT PROGRAM BY FUNDING SOURCE Local Community Recreation General Option Redevelopment Impact Storemealer Cemetery Grants/ Golf Airport Fund Gas Tax DST Agents. Fee, Fund Trust Bank Note Fund Fund Total FISCAL YEAR 20172018 General Government Audio Visual Equipment 30,000 30,000 Lanerfrche Software Upgrade 50,000 50,000 Computer Upgrades 30,000 30,000 Wifeless System 5,000 5,000 Firewall Software 75,650 75,650 Police Department Police Vehicles and Equipment 350,000 350,000 Evidence Building Futures 20,000 20,000 Police Personnel Equipment 20,000 20,000 Radio System Upgrades 57,000 57,000 Power Socace/Ge unalor 17,000 17,000 Community Development Waylu ding Signage 50.000 50,000 CRA Muster Plan 50,000 50,000 Streets and Special Projects CavCogs Paving - - StonecropDrainage 187.500 562,500 750.000 Speed Cushions and Signage 5,000 5,000 Street Milling and Repaving 451,000 451,000 Street Reconstruction 356,500 356,500 Road Operatic. & Maintenance Public Works Garage Compound 100.000 100.000 Sternmaler Swale Improvement Grants 250,000 250,000 Parks & Recreation Pickle Ball Coups 213,000 213.000 Barber Street Ballfield Lighting 375.000 375,000 Replace Playground Components 25,000 25,000 ADA Playground 80,000 80,000 Riverview Park Tree Canopy 10,000 10,000 Cemetery Irrigation System 150,000 150,000 Straightening of Headstones 24,375 24375 Facilities Maintenance City Hall/Pofice Air Conditioners 40,000 40,000 Airport Airport Entrance Signage 10,000 10,000 Medertsue Security Contents 100,000 100,000 Taxiways CD & E Construction 109,195 1,889,463 1,998,658 Construct Shade Hangars 125.000 500,000 625,000 Total FY 2017/20/8 S 45,000 S 456,000 5 2.015.945 S 130.000 5 455,000 S 250;000 $ 24.375 S 2.951,963 S - S 10.000 5 6318,183 CITY OF SEBASTIAN, FLORIDA FISCAL YEAR 2018-23 CAPITAL IMPROVEMENT PROGRAM BY FUNDING SOURCE Local Community Recreation General Option Redevelopment Impact Stormwater Cemetery Grants/ Golf Airport Food Gas To DST Aeencv Fees Fond Trust Bank Note Funtl Funtl Total FISCAL YEAR 2018/2019 General Government Computer Replacements 180,000 180,000 Computer Upgrades 30,000 30,000 UPS Bypass Switches 12,000 12,000 Police Department Police Vehicles and Equipment 350,000 350,000 Evidence Building Futures 50,000 50,000 Police Personnel Equipment 6,000 6,000 Radio System Upgrades 50,000 50,000 Community Development Street Signage 50,000 50,000 Streets and Special Projects Engineering Equipment 14,500 14.500 Street Milling and Repaving 320,000 320,000 City Hell Parking Lot 50,000 50,000 Working Waterfront Phase 3 200,000 200,000 400,000 Road Operation & Maintenance Public Warks Heavy Equipment - 275,000 275,000 Public Works Garage Compound 2,850,000 2,850,000 Slormwater Stomswater Heavy Equipment 145,000 145.000 Stormwater Equipment 1,800 1,800 Parks & Recreation Public Works Parks Mowers 26,000 26,000 Public Works Parks Pickup Trucks 30.000 30,000 Pickle Ball Courts 172,000 172,000 Replace Playground Components 25,000 25,000 Riverview Park Tree Canopy 10,000 10,000 Cemetery Cematuy, Mower 13,000 13.000 Facilities M.mumanee City Hall/Police An Conditioners 40,000 40,000 Fleet Management Public Works Fleet Equipment 20,000 20,000 Golf Course Golf Course Small Equipment 2,500 2,500 Airport Taxiways C.D & E Construction 128,819 2162,317 2391,136 Total FY 2018/2019 S 134.500 $ 320A00 S 4.532419 S 60.000 S - S 1.800 5 - S 2.462317 5 2.500 S - S 7513.936 CITY OF SEBASTIAN, FLORIDA FISCAL YEAR 2018-23 CAPITAL IMPROVEMENT PROGRAM BY FUNDING SOURCE Local Community Recreation General Option Redevelopment Impact Stormwater Cemetery Grants/ Golf Airport Fund Gas Tax DST Aeencv Fees Fond Trust Dank Not Fund Fund Total FISCAL YEAR 20198020 General Government Computer Upgrades S 30,000 30,000 Police Department Police Vehicles and Equipment 300,000 300,000 Police Personnel Equipment 6,000 6,000 Radio System Upgrades 100,000 100,000 PowerSousWGenemtor 200,000 200,000 Community Development Street Signage 50,000 50,000 Streets and Special Projects Engineering Equipment 10,0110 10,000 Street Milling and Repaving 250,000 250,000 Road Operation & Maintenance Public Works Heavy Equipment 125.000 125,000 Public Works Roads Vehicle 28,0D0 28,000 Public Works Garage Compound 11150.000 1,150,000 Stormwater Stormwater Heavy Equipment 290,000 290,000 Stormwater Equipment 78.000 78,000 Parks and Recreation Public Works Parks Mowers 38,000 38,000 Public Works Pada Pickup Tracks 30,000 30,000 Replace Playground Components 25.000 25,000 Riverview Park Tree Canopy 10,000 10,000 Facilities Nummmvice City Hat"olica Air Conditioners 40.000 40,000 Fleet Management Public Works Fleet Equipment 40,000 40,000 Airport Engineer and Construct Hangar 225.000 900,000 1,125,000 Total FY 20/9/2020 S 177.000 S 250.000 S 2A60.000 S 60.000 S S 78.000 S - S 900.000 S - S - S 3925.000 CITY OF SEBASTIAN, FLORIDA FISCAL YEAR 2018-23 CAPITAL IMPROVEMENT PROGRAM BY FUNDING SOURCE Local Commumi0 Recreation General Option Redevelopment Impact Stormweter Cemetery Grunts/ Galr Airport Fund Gas Tax DST Amar v Fees Fund Trust Dank Note Ford Food Total FISCAL YEAR 20202021 General Government Computer Upgrades 30,000 30.000 Pollee Department Police Vehicles and Equipment 300,000 300,000 Police Personnel Equipment 6,000 6.000 Radio System Upgrades 50,000 50,000 Streets and Special Projects Street Milling and Repaving 250.000 250.000 Stormwater Smrsawarer Heavy Equipment 70,000 70,000 Smnnwatcr Equipment 20.000 20,000 Par" and Recreation Replace Playground Components 25,000 25.000 Riverview Park Tree Canopy 10000 10,000 Facilities Maintenance City HaIVPolice Air Conditioners 40,000 40.000 Fleet Management Public Works Fleet Equipment 7,000 7,000 Airport Engineer and Construct Hangar 225,000 900.000 1,125,000 Construct Shade Hangars 40,000 160,000 200.000 Total FY 20202021 S 38.000 S 250.000 S 755.000 $ 10.000 S 5 20.000 5 - S 1060.000 S - S - S 2,133.000 CITY OF SEBASTIAN, FLORIDA FISCAL YEAR 2018-23 CAPITAL IMPROVEMENT PROGRAM BY FUNDING SOURCE Local Community Recreation General Option Redevel.pom nt Impact Stormwater Cemetery Grants/ Golf Airport Fund Gus Tux DST Aeenev Fees Fond Trust Bonk Note Fund Fund Total FISCAL YEAR 2021/2022 General Government Computer Upgrades 30,000 30,000 Police Department Police Vehicles and Equipmerol 300,000 300,000 Police Personnel Equipment 6,000 6.000 Streets and Special Projects Street Milling and Repaving 250,000 250,000 Stormwater Stormwater Heavy Equipment 145,000 145.000 Stormwater Equipment 80,000 80,000 Parks and Recreation Replace Playground Components 25,000 25,000 Riverview Park Tree Canopy 10,000 10,000 Facllitin Maintenance City Hall/Police AG Conditioners 40,000 40,000 Fleet Management Public Works Fleet Equipment 7,000 7,000 Airport Construct Access Road West 100,000 1.900,000 2,000,000 Total FY 20212022 5 38.000 S 250,000 5 615.000 S 10,000 S - S 80,000 S - S 1.900.000 5 - S S 2993.000 CITY OF SEBASTIAN, FLORIDA FISCAL YEAR 2018-23 CAPITAL IMPROVEMENT PROGRAM BY FUNDING SOURCE Local Community Recreation General Option Redevelopment Impact Stormwater Cemetery Grants/ Golf Airport Food Gas Tax DST Aerate Fees EMW Trust Rank Note Fund Fund Total FISCAL YEAR 202212021 General Government Computer Upgrades 30,000 Police Department Police Vehicles and Equipmeat 300,000 Police Persamel Equipment 6,000 Streets and Special Projects Street Milling and Repaving 250,000 Stormsvater Stamwater Equipment Parks and Recreation Replace Playground Components 25,000 Riverview Park Tree Canopy Facilities Maintemnce City HallPolice AG Conditioners 40,000 Total FY 2022/2023 S 31.000 S 250,000 5 370.000 S Grand Total S 463.500 S 1,776,000 S 10.748.664 5 30,000 300,000 6,000 250.000 35,000 35,000 25,000 10,000 10,000 40,000 10.000 S - S 35A00 S - S - S - $ - S 696.000 260.000 5 455.000 S 464.800 S 24375 S 9.274.280 S 2.500 S 10,000 5 23.479,119 CITY OF SEBASTIAN, FLORIDA FISCAL YEAR 2018-2023 CAPITAL IMPROVEMENT PROJECT REQUEST AND JUSTIFICATION FORM GENERAL GOVERNMENT Project Name: JAudio Visual Equipment Project Description: Funding Source: Discretionary Sales Tax Project includes upgrading the capabilities of the current hearing assistance system in the City Council Chambers and acquiring) equipment to make it hearing aid compliant. Justification: The current hearing assistance system in the City Council Chambers is not hearing aid compliant in accordance with ADA requirements. Part of the project is also to try to reduce some of the echo that is making it hard for some people to hear clearly. Project Costs: FY 17-18 FY 18-19 FY 19-20 FY 20-21 FY 21-22 FY 22-23 Total $ 30,000 $ - $ - $ - $ - $ - $ 30,000 Operating Impact (Savings): $ - $ (5,400) $ (1,200) $ 3,000 $ 6,600 $ 9,000 $ 12,000 Project Name: ILaserfiche Software Upgrade Project Description: Funding Source: Discretionary Sales Tax Project includes upgrading from the currrent Laserfiche Classic tol Laserfiche Avante software. Justification: With Laserfiche Avante, we will be able to add features that enable more departments to manage their public records effectively. This update will provide the ability to have the software import on it's own and enable departments to use the scanning capability of the copiers to enter the the data into Laserfiche. The City has been advised that Laserfiche Classic will eventually no longer be supported. Project Costs: FY 17-18 FY 18-19 FY 19-20 FY 20-21 FY 21-22 FY 22-23 Total $ 50,000 $ - $ - $ - $ - $ - $ 50,000 Operating Impact (Savings): $ - $ (9,000) $ (2,000) $ 5,000 $ 11,000 $ 15,000 $ 20,000 Project Name: Computer Replacements Project Description: Funding Source: (Discretionary Sales Tax (Replace all desktop and laptop employee computers. Justification: IA City-wide replacement of all desktops and laptops was done in July 2014. It is anticipated that a complete change out of these computers should be completed every five years to keep up-to-date with technology and maintain reliability and performance. Project Costs: FY 17-18 FY 18-19 $ - $ 180,000 Operating Impact (Savings): $ - $ - FY 19-20 FY 20-21 $ $ - $ $ (32,400) $ (7,200) $ FY 21-22 18,000 $ FY 22-23 Total - $ 180,000 39,600 $ 18,000 Project Name: I Computer Upgrades Project Description: Funding Source: IDiscretionary Sales Tax Computer equipment and software upgrades. Justification: This is needed to keep up-to-date with new technology and cover the cost of implementing new software) releases. Project Costs: FY 17-18 FY 18-19 $ 30,000 $ 30,000 $ Operating Impact (Savings): $ - $ (5,400) $ FY 19-20 FY 20-21 FY 21-22 FY 22-23 Total 30,000 $ 30,000 $ 30,000 $ 30,000 $ 180,000 (6,600) $ (3,600) $ 3,000 $ 12,000 $ (600) CITY OF SEBASTIAN, FLORIDA FISCAL YEAR 2018-2023 CAPITAL IMPROVEMENT PROJECT REQUEST AND JUSTIFICATION FORM GENERAL GOVERNMENT (CONTINUED) Project Name: (Wireless System (Project Description: Funding Source: [Discretionary Sales Tax Implement wireless at City Hall and Police Department. I Justification: This will enable a "hot -spot" for Staff and citizens to log in and have internet on their phonestlaptops, while) at City Hall or the Police Station. Project Costs: FY 17-18 FY 18-19 FY 19-20 FY 20-21 FY 21-22 FY 22-23 Total $ 5,000 $ - $ - $ - $ - $ - $ 5,000 Operating Impact (Savings): $ - $ (900) $ (200) $ 500 $ 1,100 $ 1,500 $ 2,000 Project Name: Firewall Software Project Description: Funding Source: (Discretionary Sales Tax (Purchase two Cisco firepower 2110 NGFW appliances. I Justification: The City's Technical Consultant recommends an investment in redundant next generation firewall technology that filters not only active attempts to penetrate the City s firewal from the outside but also filters email and Internet traffic for malware (malicious software, such as viruses, trojans, worms spyware, ransomware, etc.). The estimated cost includes a five year support contract. Project Costs: FY 17-18 FY 18-19 FY 19-20 FY 20-21 FY 21-22 FY 22-23 Total $ 75,650 $ - $ - $ - $ - $ - $ 75,650 Operating Impact (Savings): $ - $ (9,835) $ 1,513 $ 12,861 $ 22,695 $ 29,504 $ 56,738 Project Name: (UPS Bypass Switches Project Description: Funding Source: I Discretionary Sales Tax (Install 3 bypass switches on whole -room UPS units. Justification: Two of the City's five major datacenters already have "whole -room" UPS bypass switches. In the event o necessary installations or maintenance, the other three must be completely powered down to facilitate the work. This equipment would allow the affected UPS to be completely bypassed and allow continued operation without interruption. Project Costs: FY 17-18 FY 18-19 $ S 12,000 Operating Impact (Savings): $ - $ FY 19-20 FY 20-21 $ (1,560) $ 240 $ PUBLIC SAFETY Project Name: Police Vehicles and Equipment Funding Source: Discretionary Sales Tax FY 21-22 FY 22-23 Total - $ - $ 12,000 2,040 $ 3,600 $ 4,320 Project Description: 17/18 350K 6 Police Units. 18/19 350K 6 Police Units. 19/20 300K 5 Police Units. 20/21 300K 5 Police Units. 21122 300K 5 Police Units. 22/23 300K 5 Police Units. Justification: (Replacement of vehicles with higher milage and repair costs. Project Costs: Project FY 17-18 FY 18-19 FY 19-20 FY 20-21 FY 21-22 FY 22-23 Total $ 350,000 $ 350,000 $ 300,000 $ 300,000 $ 300,000 $ 300,000 $ 1,900,000 Operating Impact: $ - $ (77,000) $ (119,000) $ (115,000) $ (81,000) $ (38,000) $ (430,000) CITY OF SEBASTIAN, FLORIDA FISCAL YEAR 2018-2023 CAPITAL IMPROVEMENT PROJECT REQUEST AND JUSTIFICATION FORM PUBLIC SAFETY (CONTINUED) Project Name: Evidence Building Fixtures Project Description: Funding Source: Discretionary Sales Tax 17/18 20K Equipment and shelving for building. 118/19 50K Work space additions for evidence building. Justification: IAdditonal costs provided for growth and improved utilization of evidence storage. Project Costs: Project FY 17-18 FY 18-19 FY 19-20 FY 20-21 FY 21-22 FY 22-23 Total $ 20,000 $ 50,000 $ - $ - $ - S - $ 70,000 Operating Impact: $ - $ (5,400) $ (17,700) $ (13,500) $ (9,300) S (5,100) $ (51,000) Project Name: Police Personnel Equipment Project Description: Funding Source: General Fund 17/18 1 O Rifles and storage containers, 6K Tasers and accessories, 4K Ballistic shields. 18/19 6K Tasers and accessories. 19/20 6K Tasers and accessories. 20/21 6K Tasers and accessories. 21/22 6K Tasers and accessories. 22/23 6K Tasers and accessories. Justification: Replacement of necessary personal equipment for Police Officers, including hand held radio upgrades inl stages with a 2021 completion date. Project Costs: Project FY 17-18 FY I8-19 FY 19-20 FY 20-21 FY 21-22 FY 22-23 Total $ 20,000 $ 6,000 $ 6,000 $ 6,000 $ 6,000 $ 6,000 $ 50,000 Operating Impact: $ - $ (4,400) $ (3,720) $ (2,440) $ (560) $ 720 $ (10,400) Project Name: Radio System Upgrades Project Description: Funding Source: Discretionary Sales Tax 17/18 7K 4 Mobile radios for dispatch, 50K 15 Hand-held radios. 18/19 50K 15 Hand-held radios. 1919=20 50K Radio console, 50K 15 Hand-held radios. 20/21 50K 15 Hand-held radios. Justification: to 2020 deadline, these are radio replacements for Dispatch personnel, radio console replacement and (Due replacements for hand-held radios for Police Officers. Project Costs: Project FY 17-18 FY 18-19 FY 19-20 FY 20-21 FY 21-22 FY 22-23 Total $ 57,000 $ 50,000 $ 100,000 $ 50,000 S - $ - $ 257,000 Operating Impact: $ - $ (12,540) $ (17,840) $ (29,140) $ (19,440) $ 2,840 $ (76,120) Project Name: JPower Source/Generator Project Description: Funding Source: (Discretionary Sales Tax 17/18 17K Power Source for the 911 Center 119/20 200K Generator. Justification: IA Power Source for the 911 Center is necessary, as well as the replacement of the generator needed for thel Dispatch radios. Project Costs: Project FY 17-18 FY 18-19 FY 19-20 FY 20-21 FY 21-22 FY 22-23 Total $ 17,000 $ - $ 200,000 $ - $ - $ - $ 217,000 Operating Impact: $ - $ (4,590) $ (3,570) $ (56,550) $ (43,530) $ (30,510) $ (138,750) CITY OF SEBASTIAN, FLORIDA FISCAL YEAR 2018-2023 CAPITAL IMPROVEMENT PROJECT REQUEST AND JUSTIFICATION FORM COMMUNITY DEVELOPMENT Project Name: I Wayfinding Signage Project Description: Funding Source: Community Redevelopment Install decorative wayfinding signs in the Presidential Street areas. (Agency Justification: This will help identify businesses and community buildings in this area with cohesive and attractive business directional signs at each end of the streets on U.S. Highway #1 and Indian River Drive. Concurrently, it is expected that actions will be initiated to reduce the sign clutter within these areas. Project Costs: FY 17-18 FY 18-19 FY 19-20 FY 20-21 FY 21-22 FY 22-23 Total $ 50,000 $ - $ - $ - $ - $ - $ 50,000 Operating Impact (Savings): $ - $ (7,500) $ (2,000) $ 3,500 $ 9,000 $ 11,500 $ 14,500 Project Name: IStreet Signage Project Description: Funding Source: Community Redevelopment Purchase and install decorative street and directional signage. Agency Justification: To be done in conjunction with the wayfinding signage. Most street signs, stop signs and directional signage) post and frames would be replaced with materials of similar design to the wayfinding signage. Project Costs: FY 17-18 FY 18-19 FY 19-20 FY 20-21 FY 21-22 FY 22-23 Total $ - $ 50,000 $ 50,000 $ $ $ - $ 100,000 Operating Impact (Savings): $ - $ - $ (7,500) $ (9,500) $ 1,500 $ 12,500 $ (3,000) Project Name: ICRA Master Plan Project Description: Funding Source: Community Redevelopment Update the CRA Master Plan. Agency Justification: IThe current CRA Master is outdated and should be updated. I Project Costs: FY 17-18 FY 18-19 FY 19-20 FY 20-21 FY 21-22 FY 22-23 Total $ 50,000 $ $ $ $ $ $ 50,000 Operating Impact (Savings): $ - $ $ $ $ $ $ ENGINEERING - STREETS & SPECIAL PROJECTS Project Name: IEngineering Equipment Project Description: Funding Source: General Fund 18/19 4.5K Survey Data Collector and IOK Sign Plotter. 119/20 IOK CAD Plotter/Scanner. Justification: I These are useful tools for use by the Engineering Technician and Personnel at the Sign Shop. Project Costs: FY 17-18 FY 18-19 FY 19-20 FY 20-21 FY 21-22 FY 22-23 Total $ $ 14,500 $ 10,000 $ - $ $ $ 24,500 Operating Impact (Savings): $ - $ - $ (3,190) $ (3,940) $ (1,490) $ 960 $ (7,660) CITY OF SEBASTIAN, FLORIDA FISCAL YEAR 2018-2023 CAPITAL IMPROVEMENT PROJECT REQUEST AND JUSTIFICATION FORM ENGINEERING - STREETS & SPECIAL PROJECTS (CONTINUED) Project Name: CavCorp Paving Project Description: Funding Source: Discretionary Sales Tax (Complete paving of CavCorp Boat Parking Area. (Cancelled) Justification: IAs part of the original 2017 CIP paving, the CavCorp paving project placed 1" layer of asphalt pavement inn] 2016-2017 and then a final V layer of AC for the entire lot in 2017-2018. Project Costs: FY 17-18 FY 18-19 FY 19-20 FY 20-21 FY 21-22 FY 22-23 Total $ $ $ $ $ $ $ Operating Impact (Savings): Project Name: I Stonecrop Drainage Project Description: Funding Source: 75% Hazard Mitigation FEMA Install new dual 60" drainage pipes from Laconia to Stonecrop. Grant. 25% City Matching Requirements from Discretionary Sales Tax Justification: This drainage project is identified in the City s stormwater master plan to pipe the existing drainage ditch. Due to erosion of the side slopes, the ditch has become difficult to maintain and therefore the system needs to be piped with dual 60" pipe. The system drains the entire central section of the City and therefore critical to maintain flow to avoid any flooding. City matching requirement from discretionary sales taxes and is projected to be $187,500. Project Costs: FY 17-18 FY 18-19 FY 19-20 FY 20-21 FY 21-22 FY 22-23 Total S 750,000 $ - $ - $ - $ - $ - $ 750,000 Operating Impact (Savings): $ - $ (67,500) $ (60,000) $ (45,000) $ (37,500) $ (22,500) $ (232,500) Project Name: I Speed Cushions and Signage Project Description: Funding Source: Local Option Gas Tax Purchase two sets of speed cushions and signage for the neighborhood traffic calming program. Justification: The City is receiving more citizen requests for traffic calming on residential streets. Currently, there are two possible streets which may qualified for traffic calming devices like speed cushions, so staff is budgetting two sets of speed cushions and signage Project Costs: FY 17-18 FY 18-19 FY 19-20 FY 20-21 FY 21-22 FY 22-23 Total $ 5,000 $ - $ - $ - $ - $ - $ 5,000 Operating Impact (Savings): $ - $ (250) $ 150 $ 550 $ 950 S 1,250 S 2,650 Project Name: Street Milling and Repaving Project Description: Funding Source: Local Option Gas Tax Resurfacing of roadways. Justification: Necessary to keep streets in good condition. Repaving reduces pot-hole repairs and claims for damages. Timely repaving can avoid a more costly reconstruction. For FY17-18, $451K is projected for Indian River Drive, $320K is planned for FY18-19 (Pleasant View $60K, Rolling Hills Drive $108K and Schumann Drive $152K). $250K per year is scheduled for future years with actual projects dependent on annual review of roadwav conditions. Project Costs: FY 17-18 FY 18-19 FY 19-20 FY 20-21 FY 21-22 FY 22-23 Total $ 451,000 $ 320,000 $ 250,000 $ 250,000 $ 250,000 $ 250,000 $ 1,771,000 Operating Impact (Savings): $ - $ (76,670) $ (113,030) $ (124,690) $ (126,350) $ (118,010) $ (558,750) CITY OF SEBASTIAN, FLORIDA FISCAL YEAR 2018-2023 CAPITAL IMPROVEMENT PROJECT REQUEST AND JUSTIFICATION FORM ENGINEERING - STREETS & SPECIAL PROJECTS (CONTINUED) Project Name: I Street Reconstruction Project Description: Funding Source: IDiscretionary Sales Tax Reconstruct 250 linear feet of Damask, plus Other Roads. Justification: work involves more than just an overlay of the surface due to the condition of the roadway. Because of� (This this, it is eligible for funding by discretionary sales taxes. $6,500 is for a road priority study. Project Costs: FY 17-18 FY 18-19 FY 19-20 FY 20-21 FY 21-22 FY 22-23 Total $ 356,500 $ - $ - $ - $ - $ $ 356,500 Operating Impact (Savings): $ . $ (174,685) $ (174,685) $ (167,555) $ (167,555) $ (178,250) $ (862,730) Project Name: I City Hall Parking Lot Project Description: Funding Source: IDiscretionary Sales Tax Seal coat and stripe parking lots at the City Hall Complex. Justification: These parking areas should be seal coated and striped. Project Costs: FY 17-18 FY 18-19 FY 19-20 FY 20-21 FY 21-22 FY 22-23 Total $ $ 50,000 $ $ $ - $ - $ 50,000 Operating Impact (Savings): $ - $ - $ (8,500) $ (6,500) $ (4,500) $ (2,500) $ (22,000) Project Name: Working Waterfront Phase 3 Project Description: I Funding Source: Discretionary Sales Tax - 50% Working Waterfront Shoreline Protection. SJRWMD Grant -50% Justification: This project has been rescheduled. It is for improvements to the Working Waterfront by construction oil measures to protect the shoreline. The City s matching is from discretionary sales taxes for $200,000. Project Costs: FY 17-18 FY 18-19 FY 19-20 FY 20-21 FY 21-22 FY 22-23 Total $ $ 400,000 $ - $ - $ - $ - $ 400,000 Operating Impact (Savings): $ $ - $ (196,000) $ (196,000) $ (188,000) $ (188,000) $ (768,000) PUBLIC WORKS - ROAD OPERATION AND MAINTENANCE Project Name: Public Works Heavy Equipment Project Description: Funding Source: Discretionary Sales Tax 18/19 200K Cat Loader, 75K Bobcat Skid Steer. 119/20 125K 8yd Brush Truck. Justification: Scheduled replacement of equipment used in the Roads Division that is eligible to be purchased using) Discretionary Sales Taxes. Project Costs: FY 17-18 FY 18-19 FY 19-20 FY 20-21 FY 21-22 FY 22-23 Total $ $ 275,000 $ 125,000 $ - $ - $ - $ 400,000 Operating Impact (Savings): $ . $ - $ (74,250) $ (91,500) $ (67,500) $ (43,500) $ (276,750) Project Name: Public Works Roads Vehicles Project Description: Funding Source: General Fund 28K 3/4 Ton Pickup PW -5-2004. Justification: Scheduled replacement of a Pickup Truck used in the Roads Division. Project Costs: FY 17-18 FY 18-19 FY 19-20 FY 20-21 FY 21-22 FY 22-23 Total $ - $ - $ 28,000 $ $ $ - $ 28,000 Operating Impact (Savings): Included with above. $ - $ . $ - $ (6,160) $ (3,360) $ (560) $ (10,080) CITY OF SEBASTIAN, FLORIDA FISCAL YEAR 2018-2023 CAPITAL IMPROVEMENT PROJECT REQUEST AND JUSTIFICATION FORM PUBLIC WORKS - ROAD OPERATION AND MAINTENANCE (CONTINUED) Project Name: Public Works Garage Compound Project Description: Funding Source: (Discretionary Sales Tax. Design and construct new City Garage and Public Works Compound to be located at the Sebastian Municipal Airport. Justification: Existing City Garage and Public Works Compound is reaching its capacity to park and service vehicles and equipment. Existing compound sits on commercially valuable property. Relocating the compound to the airport will provide room for growth and allow the city to sell existing property. Airport benenfits by receiving rent on the land used by the new City Garage. Project Costs: Project FY 17-18 FY 18-19 FY 19-20 FY 20-21 FY 21-22 FY 22-23 Total $ 100,000 $ 2,850,000 $ 1,150,000 $ - $ - $ - $ 4,100,000 Operating Impact: $ - $ (9,000) $ (264,500) $ (337,500) $ (266,152) $ (166,582) $ (1,043,734) PUBLIC WORKS - STORMWATER UTILITY Project Name: Stormwater Heavy Equipment Project Description: Funding Source: Discretionary Sales Tax 18/19 145K Transport Truck SW609-2002. 19/20 125K 8 Yard Brush Truck SW607, 165K Slope Mower SW688. 20/21 70K 35 Ton Lowbed Trailer SW610-2002. 21/22 145K 2011 Track Excavator. Justification: Scheduled replacement of equipment essential to the stormwater maintenance program, Includes a Transport Truck, Brush Truck and Lowbed Trailer that will all be over 15 years old when replaced, plus a Slope Mower and a 2011 Track Excavator used for stormwater ditches. Project Costs: FY 17-18 FY 18-19 FY 19-20 FY 20-21 FY 21-22 FY 22-23 Total $ - $ 145,000 $ 290,000 $ 70,000 $ 145,000 $ - $ 650,000 Operating Impact (Savings): $ - $ - $ (39,150) $ (108,750) $ (101,550) $ (110,400) $ (359,850) Project Name: Swale Improvement Grants Project Description: Funding Source: Stormwater Fund I Establish a grant program to repair or replace swale improvements. Justification: This will address a long standing problem with property owners that have been unable or unwilling to keep the swales on their property clear and in effective working order. These funds will permit the City act on these problems and direct a contractor to perform the necessary work. Project Costs: FY 17-18 FY 18-19 FY 19-20 FY 20-21 FY 21-22 FY 22-23 Total $ 250,000 $ - $ - $ - $ $ $ 250,000 Operating Impact (Savings): $ - $ (70,000) $ (65,000) $ (60,000) $ (55,000) $ (50,000) $ (300,000) Project Name: IStormwater Equipment Project Description: Funding Source: Stormwater Fund 18/19 lK 3' Pump and .8K 2' Pump. 19/20 48K 1 Ton Utility Crew Cab Truck SW606-2205, 30K Pickup Truck SW614-2006. 20/2120K Water Tank and Trailer. 21/22 45K Excavator Buckets & Mowing Heads, 35K Pickup Truck. 22/23 35K Pickup Truck. Justification: I Scheduled replacement of equipment for the stormwater maintenance program. Project Costs: FY 17-18 FY 18-19 FY 19-20 FY 20-21 FY 21-22 FY 22-23 Total $ - $ 1,800 $ 78,000 $ 20,000 $ 80,000 $ 35,000 $ 214,800 Operating Impact (Savings): $ - $ - $ (396) $ (17,376) $ (13,796) $ (21,416) $ (52,984) CITY OF SEBASTIAN, FLORIDA FISCAL YEAR 2018-2023 CAPITAL IMPROVEMENT PROJECT REQUEST AND JUSTIFICATION FORM PUBLIC WORKS - PARKS AND RECREATION Project Name: JPublic Works Parks Mowers Project Description: Funding Source: General Fund 18/19 13K Mowers P-370-2010 and P-330 - 2010. 119/20 38K for 3 Mowers. Justification: I These are scheduled replacements of the mowers used in the Parks Division. Project Costs: FY 17-18 FY 18-19 FY 19-20 FY 20-21 FY 21-22 FY 22-23 $ - $ 26,000 $ 38,000 $ - $ - $ Operating Impact (Savings): $ - $ - $ (4,680) $ (7,880) $ 1,080 $ Project Name: Public Works Parks Pickup Trucks Project Description: Funding Source: General Fund 18/19 30K 3/4 Ton Pickup P328-2001. 119/20 30K Pickup P-707-2003. Justification: These are scheduled replacements of the Pickup Trucks used in the Parks Division. Project Costs: Total - $ 64,000 9,520 $ (1,960) FY 17-18 FY 18-19 FY 19-20 FY 20-21 FY 21-22 FY 22-23 Total $ - $ 30,000 $ 30,000 $ - $ - $ - $ 60,000 Operating Impact (Savings): $ - $ - $ (6,600) $ (10,200) $ (4,200) $ 1,800 $ (19,200) Project Name: Pickle Ball Courts Project Description: Funding Source: (Discretionary Sales Tax Initially construct 4 courts, followed by 4 more the following year. Justification: This project was budgeted in FY 16/17 from Recreation Impact Fees but due to the unreasonably high construction bids, that project was cancelled and is now being revised to spread the total cost over two years and utilize discretionary sales taxes for funding. Project Costs: FY 17-18 FY 18-19 FY 19-20 FY 20-21 FY 21-22 FY 22-23 Total $ 213,000 $ 172,000 $ $ $ $ $ 385,000 Operating Impact (Savings): Project Name: )Barber Street Ballfield Lighting Project Description: Funding Source: Recreation Impact Fees I Upgrade to energy—efficient lighting and automation of the controls. Justification: The lighting at the Ballfields is outdated and beyond repair. This project would allow an upgrade to energy) efficient lighting and include the addition of automated and possibly wireless offsite controls. Project Costs: FY 17-18 FY 18-19 FY 19-20 FY 20-21 FY 21-22 FY 22-23 Total $ 375,000 $ - $ - $ - $ - $ - $ 375,000 Operating Impact (Savings): $ - $ (67,500) $ (15,000) $ 37,500 $ 82,500 $ 112,500 $ 150,000 Project Name: Replace Playground Components Project Description: Funding Source: General Fund IAs needed replacement of components of playground equipment. Justification: This will allocate funds on an annual basis toward replacing rusted or damaged components of playground equipment in parks throughout the City. Many of these have been in service beyond their expected lifespan) land need to be regularly inspected for problems and replaced immediately. Project Costs: FY 17-18 FY 18-19 FY 19-20 FY 20-21 FY 21-22 FY 22-23 Total $ 25,000 $ 25,000 $ 25,000 $ 25,000 $ 25,000 $ 25,000 $ 150,000 Operating Impact (Savings): $ - $ (4,500) $ (5,500) $ (3,000) $ 2,500 $ 10,000 $ (500) CITY OF SEBASTIAN, FLORIDA FISCAL YEAR 2018-2023 CAPITAL IMPROVEMENT PROJECT REQUEST AND JUSTIFICATION FORM PUBLIC WORKS - PARKS AND RECREATION (CONTINUED) Project Name: I ADA Playground Project Description: Funding Source: lRecreation Impact Fees Construction of ADA Playground. Justification: Due to construction of the Police Evidence Building where a playground was previously, it is anticipated that a new playground will be constructed at Friendship Park- Project arkProject Costs: FY 17-18 FY 18-19 FY 19-20 FY 20-21 FY 21-22 FY 22-23 Total $ 80,000 $ - $ - $ $ $ $ 80,000 Operating Impact (Savings): $ - $ (22,400) $ (20,800) $ (19,200) $ (17,600) S (16,000) $ (96,000) Project Name: I Riverview Park Tree Canopy Project Description: Funding Source: (Community Redevelopment Provide for tree maintenance and new plantings that will ensure a future Agency tree canopy at Riverview Park. Justification: The priceless value of the tree canopy at Riverview Park provides a very special setting for community events and gatherings. There is a concern that as the large oaks continue to age that this may be lost. It is recommended that we begin to take measures to ensure they are maintained properly and that a program for planting replacement trees be implemented. Project Costs: FY 17-18 FY 18-19 FY 19-20 FY 20-21 FY 21-22 FY 22-23 Total $ 10,000 $ 10,000 $ 10,000 $ 10,000 $ 10,000 $ 10,000 $ 60,000 Operating Impact (Savings): $ - $ (2,900) $ (5,800) $ (8,700) $ (11,600) $ (14,500) $ (43,500) Project Name: I Cemetery Mower Project Description: Funding Source: JGeneral Fund Replace mower purchased in 2005. Justification: The mower currently used requires frequent repair and is no longer cost effective to maintain. Project Costs: FY 17-18 FY 18-19 FY 19-20 FY 20-21 FY 21-22 FY 22-23 Total $ $ 13,000 $ - $ - $ - $ - $ 13,000 Operating Impact (Savings): $ - $ - $ (2,340) $ (520) $ 1,300 $ 2,860 $ 1,300 PUBLIC WORKS - CEMETERY Project Name: Irrigation System Project Description: Funding Source: (Discretionary Sales Tax Install a new irrigation system at the Cemetery. Justification: The present irrigation system requires frequent repairs due to its age. This project would entirely replace thel current system. Project Costs: FY 17-18 FY 18-19 FY 19-20 FY 20-21 FY 21-22 FY 22-23 Total $ 150,000 $ - $ - $ $ $ - $ 150,000 Operating Impact (Savings): $ - $ (42,000) $ (39,000) $ (36,000) $ (33,000) $ (30,000) $ (180,000) CITY OF SEBASTIAN, FLORIDA FISCAL YEAR 2018-2023 CAPITAL IMPROVEMENT PROJECT REQUEST AND JUSTIFICATION FORM PUBLIC WORKS - CEMETERY (CONTINUED) Project Name: I Straightening of Headstones Project Description: Funding Source: (Cemetery Trust Fund I Straighten and level headstones or markers. Justification: Over time, the headstones and markets at the Cemetery have become out of place. This will provide funds for a contractor to completely address the problem. Project Costs: FY 17-18 FY 18-19 $ 24,375 $ Operating Impact (Savings): FY 19-20 FY 20-21 FY 21-22 FY 22-23 $ - $ - $ - $ $ PUBLIC WORKS - FACILITIES MAINTENANCE Total 24,375 Project Name: City Hall/Police Air Conditioners Project Description: Funding Source: (Discretionary Sales Tax I Replace air conditioners on the roofs of City Hall and Police Station. Justification: These units have served beyond the expected lifespan and are having mechanical issues. One unit will be replaced per year. Discretionary sales taxes can be used as these facilities were built using them. Project Costs: FY 17-18 FY 18-19 FY 19-20 FY 20-21 FY 21-22 FY 22-23 Total $ 40,000 $ 40,000 $ 40,000 $ 40,000 $ 40,000 $ 40,000 $ 240,000 Operating Impact (Savings): $ $ (6,800) $ (12,000) $ (15,600) $ (17,600) $ (18,000) $ (70,000) PUBLIC WORKS - FLEET MANAGEMENT Project Name: Public Works Fleet Equipment Funding Source: General Fund Project Description: 18/19 15k Four Post Lift, lK Bore Scope,4K Air Conditioning Recovery Machine, 19/20 40K 3/4 Ton 4WD Utility Service Truck 20/21 7K Tire Balancer. 21/22 7K Portable Welder/Generator Justification: I Equipment needed for the City Garage. The existing Utility Service Truck will be over 18 years old. Project Costs: FY 17-18 FY 18-19 FY 19-20 FY 20-21 FY 21-22 FY 22-23 Total $ $ 20,000 $ 40,000 $ 7,000 $ 7,000 $ - $ 74,000 Operating Impact (Savings): $ $ $ (5,400) $ (15,000) $ (13,290) $ (11,160) $ (44,850) GOLF COURSE FUND Project Name: Golf Course Small Equipment Project Description: Funding Source: Golf Course Operating Fund I Replace Range Ball Dispenser. Justification: This unit is expected to need replacement in the future. Project Costs: FY 17-18 FY 18-19 FY 19-20 FY 20-21 FY 21-22 FY 22-23 Total $ $ 2,500 $ $ - $ - $ - $ 2,500 Operating Impact (Savings): $ - S - $ (300) $ (125) $ 50 $ 225 $ (150) CITY OF SEBASTIAN, FLORIDA FISCAL YEAR 2018-2023 CAPITAL IMPROVEMENT PROJECT REQUEST AND JUSTIFICATION FORM AIRPORT FUND Project Name: Airport Entrance Signage Project Description: Funding Source: (Airport Revenue Fund Add signage at Airport Entrance. Justification: (Additional signage is needed to clearly mark the entranceway from Main Street. Project Costs: Project FY 17-18 FY 18-19 FY 19-20 FY 20-21 FY 21-22 FY 22-23 Total $ 10,000 $ - $ - $ - $ - S - $ 10,000 Operating Impact: $ - $ (500) $ 300 $ 1,100 $ 1,900 S 2,500 $ 5,300 Project Name: Modernize Security Cameras Project Description: Funding Source: (Discretionary Sales Tax I Upgrade flightline and gate security cameras. Justification: All of the flight line and gate security cameras are outdated or broken and no longer capable of capturing quality video. This project involves the purchase of twelve camera units and software to archive previous videos and alert the Police Department of unusual activities. Project Costs: Project FY 17-18 FY 18-19 FY 19-20 FY 20-21 FY 21-22 FY 22-23 Total $ 100,000 $ - $ - $ - $ - $ - $ 100,000 Operating Impact: $ - $ (18,000) $ (4,000) $ 10,000 $ 22,000 S 30,000 $ 40,000 Project Name: I Taxiways C,D & E Construction IProject Description: Funding Source: 90% FAA Grant. 5% FDOT Grant. lConstruction of Airport Taxiway D and E will be done in FY17-18 and 5% City Matching Requirements Taxiway C is planned for FY18-19. from Discretionary Sales Tax Justification: New taxiway construction will improve safety by eliminating the current need to cross the intersection of two runways to reach runway thresholds. City matching requirement will be from discretionary sales taxes and are projected to be $109,195 for Taxiways D and E $128,819 for Taxiway C. Project Costs: FY 17-18 FY 18-19 FY 19-20 FY 20-21 FY 21-22 FY 22-23 Total $ 1,998,658 $ 2,391,136 $ $ $ $ $ 4,389,794 Operating Impact (Savings): $ - $ (179,879) $ (375,095) $ (311,210) $ (243,401) $ (179,517) $ (1,289,102) Project Name: IConstruct Access Road West Project Description: Funding Source: 190% FAA Grant. 5% FDOT Grant. Design and Contruct Access Road on west side of airport from Roseland 5% City Matching Requirements Road to new areas of development on the airport. from Discretionary Sales Tax Justification: Land on the West side of the Airport that is available for future economic development requires an access road. $100,000 is estimated to be needed as City matching funds. Project Costs: FY 17-18 FY 18-19 FY 19-20 FY 20-21 FY 21-22 FY 22-23 Total S - $ - $ - $ $ 2,000,000 $ - $ 2,000,000 Operating Impact (Savings): $ - $ - $ - $ $ - $ 20,000 $ 20,000 CITY OF SEBASTIAN, FLORIDA FISCAL YEAR 2018-2023 CAPITAL IMPROVEMENT PROJECT REQUEST AND JUSTIFICATION FORM AIRPORT FUND (CONTINUED) Project Name: I Engineer and Construct Hangar Project Description: Funding Source: I80% FDOT Grants. City Matching Engineer and construct a hangar capable of housing (3) corporate Requirements at 20% from aircraft owners or to configure as a large business hangar. Discretionary Sales Tax funds. Justification: New hangar to meet the growing need for corporate hangar(s) capable of housing large twin engine aircraft, with the option of configuring the building for a future business tenant. Airport benefits from rents paid by tenant(s). City matching requirement will be from discretionary sales taxes and are projected to be $225,000 for FY19-20 and FY20-21. Project Costs: Project FY 17-18 FY 18-19 FY 19-20 FY 20-21 FY 21-22 FY 22-23 Total $ - $ - $ 1,125,000 $ 1,125,000 $ - $ - $ 2,250,000 Operating Impact: $ - $ - $ - $ 11,250 $ 33,750 $ 56,250 $ 101,250 Project Name: I Construct Shade Hangars Project Description: Funding Source: 80% FDOT Grants. City Matching Apron improvements and installation of pre-engineered open -sided Requirements at 20% from Shade Hangars. Phase -1 involves 14 -hangars. Phase -2 will erect 7 Discretionary Sales Tax funds. Shade Hangars. Justification: Shade hangars offer a lower cost aircraft sheltering alternative to local aircraft owners. Shade hangars will contribute much needed revenue to help bring economic sustainability to the airport. Annual rental revenues are expected bring in over $33,600. Follow up Phase -2 involves 7 additional Shade Hangars. $125,000 in FYI 7-18 and $40,000 in FY20-21 will be funded by discretionary sales taxes. Project Costs: FY 17-18 FY 18-19 $ 625,000 $ - Operating Impact (Savings): $ - $ 6,250 FY 19-20 FY 20-21 $ - $ 200,000 $ $ 12,500 $ 18,750 $ FY 21-22 FY 22-23 27,000 $ Total $ 825,000 35,250 $ 99,750 IMPACTS OF CAPITAL OUTLAYS ON OPERATING COST CALCULATION CRITERIA Capital Improvements may impact operating costs in several ways. To quantify the amount various projects will ger operating costs, the City applies four main factors, adjusted by the expected years of useful life. These factors are I efficiency, risk management and replacement. If applicable, some items may be further adjusted to reflect anticipated revenues the item will generate. Year of 1 Year 2 Years 3 Years 4 Years Purchase After After After After Maintenance Factor - As items get older, costs for maintaining them will increase. Annual amount should not exceed 100% 30+ Year Useful Life 0% 1% 2% 3% 4% 20 Year Useful Life 0% 2% 4% 6% 8% 10 Year Useful Life 0% 3% 6% 9% 12% 7 Year Useful Life 0% 5% 10% 15% 20% 5 Year Useful Life 0% 79/5 14% 21% 28% 3 Year Useful Life 0% 10% 20% 30% 40% Efficiency Factor - As items get older, the initially improved efficiency declines. Annual amount could be a loss in subsequent ye, 30+ Year Useful Life 0% -10% -10% -9% -9% 20 Year Useful Life 0% -10% -9% -8% -7516 10 Year Useful Life 0% -10% -8.0 -6% -0% 7 Year Useful Life 0% -10% -7% -4% -1% 5 Year Useful Life 0% -10% -6% -2% 2% 3 Year Useful Life 0% -10% -5% 0% 5% Risk Management Factor - Items may have savings by reducing liability exposure. Annual amount should not be positive 30+ Year Useful Life 0% -10% -10% -9% -9% 20 Year Useful Life 0% -10% -9% -8% -7% 10 Year Useful Life 0% -10% -8% -6% -4% 7 Year Useful Life 0% -10% -7% -4% -1% 5 Year Useful Life 0% -10% -6% -2% 0% 3 Year Useful Life 0% -10% -5% 0% 0% Replacement Factor - A savings would occur by taking replaced items out of service.Annual amount would continue to compoun 30+ Year Useful Life 0% -30% -31% -32% -33% 20 Year Useful Life 0% -20% -21% -22% -23% 10 Year Useful Life 0% -10% -11% -12% -13% 7 Year Useful Life 0% -7% -8% -9% -10% 5 Year Useful Life 0% -5% -8% -7% -8% 3 Year Useful Life 0% -3% -4% -5% -6% Revenue Factor - Some items may be offset by additional revenue. These are handled on a case-by-case basis. IMPACTS OF CAPITAL IMPROVEMENT PROJECTS ON OPERATING COST SUMMARY BY FUND Total FY 2018-19 FY 2019-20 FY 2020-21 FY 2021-22 FY 2022-23 Impacts General Fund Maintenance 107,311 322,796 614,842 940,647 1,508,388 3,493,983 Efficiency (185,115) (599,969) (770,319) (677,854) (625,397) (2,858,654) Risk (311,015) (480,769) (531,999) (478,027) (432,643) (2,234,453) Replacement (356,990) (675,046) (863,214) (993,514) (1,140,872) (4,029,636) Totals (745,810) (1,432,988) (1,550,691) (1,208,748) (690,525) (5,628,761) All the capital outlays for General Fund taken collectively indicate that net operating impacts should be favorable in the initial years but can be expected to decline in future periods. This supports the premise that the City would financially benefit by diligently scheduling replacements before net maintenance cost become excessive. - (300) (125) 50 Golf Course Fund Maintenance - 125 250 375 500 1,250 Efficiency - - - - - - Risk - (250) (175) (100) (25) (550) Replacement - (175) (200) (225) (250) (850) Totals - (300) (125) 50 225 (150) With the capital outlay items funded for the Golf Course, the value of replacing capital items on a timely basis is supported by the projections of net maintenance cost. (158,751) (35,517) (1,022,802) Airport Fund Maintenance 33,737 91,385 160,282 242,430 344,578 872,412 Efficiency (10,000) (6,000) (2,000) 2,000 4,000 (12,000) Risk (210,866) (445,679) (421,393) (395,181) (375,095) (1,848,214) Replacement (5,000) (6,000) (7,000) (8,000) (9,000) (35,000) Totals (192,129) (366,295) (270,110) (158,751) (35,517) (1,022,802) The construction of additional infrastructure in the Airport Fund results in a progressively higher annual net maintenance cost Building Fund: Maintenance Efficiency Risk Replacement Totals There are no projected scheduled capital purchases or replacements over this time period. All Funds Maintenance 141,047 414,306 775,374 1,183,452 1,853,466 4,367,645 Efficiency (195,115) (605,969) (772,319) (675,854) (621,397) (2,870,654) Risk (521,881) (926,698) (953,567) (873,308) (807,763) (4,083,217) Replacement (361,990) (681,221) (870,414) (1,001,739) (1,150,122) (4,065,486) Totals (937,939) (1,799,583) (1,820,926) (1,367,449) 725,816) (6,651,713) IMPACTS OF CAPITAL OUTLAYS ON OPERATING COST SUMMARY OF RESULTS The graphs below show the impact of scheduled capital purchases on the Operating Budget for each Fund. These reflect that there are often initial savings from removing replaced items from service, efficiencies gained by acquiring the new items and reduced exposure to potential injury and liability claims that initially outweigh the projected maintenance costs of the new items. General Fund Capital Improvements Operating Costs Impact 13,000,000 12,000,000 11,000,000 10,000,000 9,000,000 8,000,000 FY 1&19 FY 19-20 FY 20-21 FY 21-22 FY 22-23 —i—Current Cost —With CIP Impact Airport Fund Capital Improvements Operating Costs Impact 400,000 200,000 (200,000) FY 1B-19 FY 19-20 FY 20.21 FY 21-22 FY 22-23 Current Cost .With CIP Impact 1,500,000 1,400,000 1,300,000 1,200,000 1,100,000 1,000,000 900,000 FY 18-19 FY 19-20 FY 20-21 FY 21-22 FY 22-23 Current Cast With CIP Impact Golf Course Capital Improvements Operating Costs Impact Building Fund Capital Improvements Operating Costs Impact 600,000 580,000 560,000 540,000 520,000 500,000 FY 18-19 FV 19-20 FY 20.21 FY 21-22 FY 22-23 +With CIP Impact � Current Cost IMPACTS OF CAPITAL OUTLAYS ON OPERATING COST SUMMARY OF RESULTS Project Names FY 18-19 FY 19.20 FY 20-21 FY 21-22 FY 22-23 Audio Visual Equipment $ (5,400) $ (1,200) $ 3,000 $ 6,600 $ 9,000 Laserfiche Software Upgrade (9,000) (2,000) 5,000 11,000 15,000 Computer Replacements - (32,400) (7,200) 18,000 39,600 Computer Upgrades (5,400) (6,600) (3,600) 3,000 12,000 Wireless System (900) (200) 500 1,100 1,500 Firewall Software (9,835) 1,513 12,861 22,695 29,504 UPS Bypass Switches - (1,560) 240 2,040 3,600 Police Vehicles and Equipment (77,000) (119,000) (115,000) (81,000) (38,000) Evidence Building Fixtures (5.,400) (17,700) (13,500) (9,300) (5,100) Police Personnel Equipment (4,400) (3,720) (2,440) (560) 720 Radio System Upgrades (12,540) (17,840) (29,140) (19,440) 2,840 Power Source/Generator (4,590) (3,570) (56,550) (43,530) (30,510) Wayfinding Signage (7,500) (2,000) 3,500 9,000 11,500 Street Signage - (7,500) (9,500) 1,500 12,500 Engineering Equipment - (3,190) (3,940) (1,490) 960 CavCorp Paving - - - - - Stonecrop Drainage (67,500) (60,000) (45,000) (37,500) (22,500) Speed Cushions and Signage (250) 150 550 950 1,250 Street Milling and Repaving (76,670) (113,030) (124,690) (126,350) (118,010) Street Reconstruction (174,685) (174,685) (167,555) (167,555) - City Hall Parking Lot - (8,500) (6,500) (4,500) (2,500) Working Waterfront Phase 3 - (196,000) (196,000) (188,000) (188,000) Public Works Heavy Equipment - (74,250) (91,500) (67,500) (43,500) Public Works Roads Vehicles - - (6,160) (3,360) (560) Public Works Garage Compound (9,000) (264,500) (337,500) (266,152) (166,582) Stonnwater Heavy Equipment - (39,150) (108,750) (101,550) (110,400) Swale Improvement Grants (70,000) (65,000) (60,000) (55,000) (50,000) Stonnwater Equipment - (396) (17,376) (13,796) (21,416) Public Works Parks Mowers - (4,680) (7,880) 1,080 9,520 Public Works Parks Pickup Trucks - (6,600) (10,200) (4,200) 1,800 Pickle Ball Courts (59,640) (103,540) (95,840) (88,140) (80,440) Barber Street Ballfield Lighting (67,500) (15,000) 37,500 82,500 112,500 Replace Playground Components (4,500) (5,500) (3,000) 2,500 10,000 ADA Playground (22,400) (20,800) (19,200) (17,600) (16,000) Riverview Park Tree Canopy (2,900) (5,800) (8,700) (11,600) (14,500) Cemetery Mower - (2,340) (520) 1,300 2,860 Irrigation System (42,000) (39,000) (36,000) (33,000) (30,000) City Hall/Police Air Conditioners (6,800) (12,000) (15,600) (17,600) (18,000) Public Works Fleet Equipment - (5,400) (15,000) (13,290) (11,160) Total General Fund (745,810) (1,432,988) (1,550,691) (1,208,748) (690,525) Golf Course Small Equipment - (300) (125) 50 225 Total Golf Course (300) (125) 50 225 Airport Entrance Signage (500) 300 1,100 1,900 2,500 Modernize Security Cameras (18,000) (4,000) 10,000 22,000 30,000 Taxiways C,D R E Construction (179,879) (375,095) (311,210) (243,401) (179,517) Construct Access Road West - - - - 20,000 Engineer and Construct Hangar - - 11,250 33,750 56,250 Construct Shade Hangars 6,250 12,500 18,750 27,000 35,250 Total Airport (192,129) (366,295) (270,110) (158,751) (35,517) None Projected - - - - - Total Building Department Total All Funds $ (937,939) $ (1,799,583) $ (1,820,926) $ (1,367,449) $ (725,816) IMPACTS OF CAPITAL IMPROVEMENT PROJECTS ON OPERATING COST CALCULATIONS BY PROJECT Life List of Prolects Years FY 2017-18 FY 2018.19 FY 2019-20 FY 2020-21 FY 2021-22 FY 2022-23 General Government Audio Visual Equipment 5 S 30,000 $ - $ - S - $ - S - Maintenance - 2,100 4,200 6,300 8,400 10,500 Efficiency - (3,000) (1,800) (600) 600 1,200 Risk - (3,000) (1,800) (600) - - Replacement - (1,500) (1,800) (2,100) (2,400) (2,700) Total - (5,400) (1,200) 3,000 6,600 9,000 Laserfiche Software Upgrade 5 50,000 - - - - - Maintenance - 3,500 7,000 10,500 14,000 17,500 Efficiency - (5,000) (3,000) (1,000) 1,000 2,000 Risk (5,000) (3,000) (1,000) - - Replacement (2,500) (3,000) (3,500) (4,000) (4,500) Total - (9,000) (2,000) 5,000 11,000 15,000 Computer Replacements 5 - 180,000 - - - - Maintenance - - 12,600 25,200 37,800 50,400 Efficiency - - (18,000) (10,800) (3,600) 3,600 Risk - - (18,000) (10,800) (3,600) - Replacement - - (9,000) (10,800) (12,600) (14,400) Total - - (32,400) (7,200) 18,000 39,600 Computer Upgrades 5 30,000 30,000 30,000 30,000 30,000 30,000 Maintenance - 2,100 6,300 12,600 21,000 31,500 Efficiency - (3,000) (4,800) (5,400) (4,800) (3,600) Risk - (3,000) (4,800) (5,400) (5,400) (5,400) Replacement - (1,500) (3,300) (5,400) (7,800) (10,500) Total - (5,400) (6,600) (3,600) 3,000 12,000 Wireless System 5 5,000 - - - - - Maintenance - 350 700 1,050 1,400 1,750 Effrclency - (500) (300) (100) 100 200 Risk - (500) (300) (100) - - Replacement - (250) (300) (350) (400) (450) Total - (900) (200) 500 1,100 1,500 Firewall Software 5 75,650 - - - - - Maintenance - 5,296 10,591 15,887 21,182 26,478 Efficiency - (7,565) (4,539) (1,513) 1,513 3,026 Risk - (7,565) (4,539) (1,513) - - Total - (9,635) 1,513 12,861 22,695 29,504 UPS Bypass Switches 5 - 12,000 - - - - Malntenance - - 840 1,680 2,520 3,360 Efficiency - - (1,200) (720) (240) 240 Risk - - (1,200) (720) (240) - Total - - (1,560) 240 2,040 3,600 Police Department Police Vehicles and Equipment 7 350,000 350,000 300,000 300,000 300,000 300,000 Maintenance - 17,500 52,500 102,500 167,500 247,500 Efficiency - (35,000) (59,500) (68,500) (68,500) (73,500) Risk - (35,000) (59,500) (66,500) (68,500) (66,500) Replacement - (24,500) (52,500) (80,500) (111,500) (145,500) Total - (77,000) (119,000) (115,000) (81,000) (38,000) Evidence Building Fixtures 10 20,000 50,000 - - - - Maintenance - 600 2,700 4,800 6,900 9,000 Efficiency - (2,000) (6,600) (5,200) (3,800) (2,400) Risk - (2,000) (6,600) (5,200) (3,800) (2,400) Replacement - (2,000) (7,200) (7,900) (8,600) (9,300) Total - (5,400) (17,700) (13,500) (9,300) (5,100) IMPACTS OF CAPITAL IMPROVEMENT PROJECTS ON OPERATING COST CALCULATIONS BY PROJECT (CONTINUED) Life List of Protects Years FY 2017-18 FY 2018.19 FY 2019.20 FY 2020.21 FY 2021-22 FY 2022-23 Police Department (Continued) Police Personnel Equipment 7 20,000 6,000 6,000 6,000 6,000 6,000 Maintenance - 1,000 2,300 3,900 5,800 8,000 Efficiency - (2,000) (2,000) (1,820) (1,460) (1,720) Risk - (2,000) (2,000) (1,820) (1,460) (1,320) Replacement - (1,400) (2,020) (2,700) (3,440) (4,240) Total - (4,400) (3,720) (2,440) (560) 720 Radio System Upgrades 7 $ 57,000 $ 50,000 $ 100,000 $ 50,000 $ - $ - Maintenance - 2,850 8,200 18,550 31,400 44,250 Efficiency - (5,700) (8,990) (15,780) (14,570) (9,140) Risk - (5,700) (8,990) (15,780) (14,570) (8,000) Replacement - (3,990) (8,060) (16,130) (21,700) (24,270) Total - (12,540) (17,840) (29,140) (19,440) 2,840 Power Source/Generator 10 17,000 - 200,000 - - - Malntenance - 510 1,020 7,530 14,040 20,550 Efficiency - (1,700) (1,380) (21,020) (16,680) (12,340) Risk - (1,700) (1,360) (21,020) (16,680) (12,340) Replacement - (1,700) (1,870) (22,040) (24,210) (26,380) Total - (4,590) (3,570) (56,550) (43,530) (30,510) Community Development Department Way6nding Signage 7 50,000 - - - - - Maintenance - 2,500 5,000 7,500 10,000 12,500 Efficiency - (5,000) (3,500) (2,000) (500) (1,000) Risk - (5,000) (3,500) (2,000) (500) - Total - (7,500) (2,000) 3,500 9,000 11,500 Street Signage 7 - 50,000 50,000 - - - Malntenance - - 2,500 7,500 12,500 17,500 Efficiency - (5,000) (8,500) (5,500) (2,500) Risk - - (5,000) (8,500) (5,500) (2,500) Total - - (7,500) (9,500) 1,500 12,500 CRA Master Plan N/A 50,000 - - - - - Normal Operations and Maintenance - - - - - Engineering - Street Paving and Special Projects Engineering Equipment 7 - 14,500 10,000 - - - Malntenance - - 725 1,950 3,175 4,400 Efficiency - - (1,450) (2,015) (1,280) (545) Risk - - (1,450) (2,015) (1,280) (545) Replacement - - (1,015) (1,860) (2,105) (2,350) Total - - (3,190) (3,940) (1,490) 960 CavCorp Paving 10 - - - - - - Malntenance - - - - - - Risk Total - Stonecrop Drainage 30+ 750,000 - - - - - Maintenance - 7,500 15,000 22,500 30,000 37,500 Risk - (75,000) (75,000) (67,500) (67,500) (60,000) Total - (67,500) (60,000) (45,000) (37,500) (22,500) Speed Cushions and Signage 7 5,000 - - - - - Maintenance - 250 500 750 1,000 1,250 Risk - (500) (350) (200) (50) - Total - (250) 150 550 950 1,250 Street Milling and Repaving 10 $ 451,000 $ 320,000 $ 250,000 $ 250,000 $ 250,000 $ 250,000 Maintenance - 13,530 36,660 67,290 105,420 151,050 Risk - (45,100) (68,080) (77,660) (82,240) (81,820) Replacement - (45,100) (81,610) (114,320) (149,530) (187,240) Total - (76,670) (113,030) (124,690) (126,350) (118,010) IMPACTS OF CAPITAL IMPROVEMENT PROJECTS ON OPERATING COST CALCULATIONS BY PROJECT (CONTINUED) FY 2019.20 Life FY 2021.22 List of Projects Years FY 2017.18 FY 2018.19 Engineering - Street Paving and Special Projects (Continued) Street Reconstruction 30+ 356,500 - Maintenance - 3,565 Efficiency - (35,650) Risk - (35,650) Replacement (110,515) (106,950) Total - (174,685) City Hall Parking Lot 10 - 50,000 Maintenance - - Risk - (4,000) Replacement - - Total (6,000) (6,500) Working Waterfront Phase 3 30+ - 400,000 Maintenance - - Efficiency - - Risk - (36,000) Replacement - - Total - - Public Works - Road Operation and Maintenance (196,000) Public Works Heavy Equipment 10 - 275,000 Maintenance - - Efficiency - - Risk - - Replacement - - Total - - Public Warks Roads Vehicles 7 - - Maintenance - - Efficiency - - Risk - - Replacement - - Total - - Public Works Garage Compound 30+ 100,000 2,850,000 Maintenance - 1,000 Efficiency - (10,000) Replacement - - Total - (9,000) Stormwater - - Stomiwater Heavy Equipment 10 - 145,000 Maintenance - - E/Rciency - - Risk - 1,848 Replacement - - Total (166,582) 290,000 Swale Improvement Grants 20 $ 250,000 $ - $ Maintenance - 5,000 Efficiency - (25,000) Replacement - (50,000) Total - (70,000) Stonnwater Equipment 7 - 1,800 Maintenance - - Efciency - - Risk Replacement - - Total (22,500) (20,000) FY 2019.20 FY 2020.21 FY 2021.22 FY 2022.23 7,130 10,695 14,260 178,250 (35,650) (32,085) (32,085) (28,520) (35,650) (32,085) (32,085) (28,520) (110,515) (114,080) (117,645) (121,210) (174,685) (167,555) (167,555) - 1,500 3,000 4,500 6,000 (5,000) (4,000) (3,000) (2,000) (5,000) (5,500) (6,000) (6,500) (8,500) (6,500) (4,500) (2,500) 4,000 8,000 12,000 16,000 (40,000) (40,000) (36,000) (36,000) (40,000) (40,000) (36,000) (36,000) (120,000) (124,000) (128,000) (132,000) (196,000) (196,000) (188,000) (188,000) 125,000 - - - 8,250 20,250 32,250 44,250 (27,500) (34,500) (26,500) (18,500) (27,500) (34,500) (26,500) (18,500) (27,500) (42,750) (46,750) (50,750) (74,250) (91,500) (67,500) (43,500) 28,000 - - • 1,400 2,800 4,200 - (2,800) (1,960) (1,120) • (2,800) (1,960) (1,120) - (1,960) (2,240) (2,520) - (6,160) (3,360) (560) 1,150,000 - - - 30,500 71,500 112,500 198,500 (295,000) (409,000) (380,500) (368,000) - - 1,848 2,918 (264,500) (337,500) (266,152) (166,582) 290,000 70,000 145,000 - 4,350 17,400 32,550 52,050 (14,500) (40,600) (38,900) (43,300) (14,500) (40,600) (38,900) (43,300) (14,500) (44,950) (56,300) (75,850) (39,150) (108,750) (101,550) (110,400) 10,000 15,000 20,000 25,000 (22,500) (20,000) (17,500) (15,000) (52,500) (55,000) (57,500) (60,000) (65,000) (60,000) (55,000) (50,000) 78,000 20,000 80,000 35,000 90 4,080 9,070 18,060 (180) (7,926) (7,532) (12,538) (180) (7,926) (7,532) (12,538) (126) (5,604) (7,802) (14,400) (396) (17,376) (13,796) (21,416) IMPACTS OF CAPITAL IMPROVEMENT PROJECTS ON OPERATING COST CALCULATIONS BY PROJECT (CONTINUED) Life List of Protects Years FY 2017-18 Parks FY 2019-20 FY 2020-21 FY 2021-22 Public Works Parks Mowers 5 - Maintenance - - - Efficiency 6,300 10,780 - Risk (2,600) (5,360) - Replacement - (2,600) - Total (760) - - Public Works Parks Pickup Trucks 7 - Maintenance (7,880) 1,080 - Eficiency 30,000 - - Risk - 1,500 - Replacement 10,500 - - Total (3,300) (1,500) - Pickle Ball Courts (5,100) 20 213,000 Maintenance (2,100) (4,500) - Risk - (6,600) (10,200) Replacement 1,800 172,000 - Total - - - Barber Street Ballfield Lighting 5 375,000 Maintenance (36,370) (32,520) - E(Fciency (42,600) (79,130) - Risk (90,680) (59,640) - Replacement (88,140) (80,440) - Total 78,750 105,000 - Replace Playground Components 5 25,000 Maintenance (37,500) (22,500) - Effiiciency - (18,750) - Risk (30,000) (33,750) (67,500) Replacement 37,500 82,500 - Total 25,000 25,000 - ADA Playground 1,750 20 80,000 Maintenance 26,250 (2,500) - Risk (4,000) (3,000) (2,500) Replacement (4,500) (4,500) - Total (2,750) (4,500) (6,500) Riverview Park Tree Canopy 30+ 10,000 Maintenance 10,000 1,600 - Replacement 6,400 8,000 - Total (6,400) (5,600) - Cemetery (16,800) (17,600) (18,400) Cemetery Mower (22,400) 5 - Maintenance (16,000) 10,000 - Efficiency 10,000 10,000 - Risk 600 1,000 - Replacement (6,100) (9,300) - Total (2,900) (5,800) - Irrigation System (14,500) 20 $ 150,000 $ FY 2018-19 FY 2019-20 FY 2020-21 FY 2021-22 FY 2022-23 (780) 26,000 38,000 - - - - 1,820 6,300 10,780 15,260 - (2,600) (5,360) (2,800) (240) - (2,600) (5,360) (2,800) (760) - (1,300) (3,460) (4,100) (4,740) - (4,680) (7,880) 1,080 9,520 30,000 30,000 - - - - 1,500 4,500 7,500 10,500 - (3,000) (5,100) (3,300) (1,500) - (3,000) (5,100) (3,300) (1,500) - (2,100) (4,500) (5,100) (5,700) - (6,600) (10,200) (4,200) 1,800 172,000 - - - - 4,260 11,960 19,660 27,360 35,060 (21,300) (36,370) (32,520) (28,670) (24,820) (42,600) (79,130) (82,980) (86,830) (90,680) (59,640) (103,540) (95,840) (88,140) (80,440) 26,250 52,500 78,750 105,000 131,250 (37,500) (22,500) (7,500) 7,500 15,000 (37,500) (22,500) (7,500) - - (18,750) (22,500) (26,250) (30,000) (33,750) (67,500) (15,000) 37,500 82,500 112,500 25,000 25,000 25,000 25,000 25,000 1,750 5,250 10,500 17,500 26,250 (2,500) (4,000) (4,500) (4,000) (3,000) (2,500) (4,000) (4,500) (4,500) (4,500) (1,250) (2,750) (4,500) (6,500) (8,750) (4,500) (5,500) (3,000) 2,500 10,000 1,600 3,200 4,600 6,400 8,000 (8,000) (7,200) (6,400) (5,600) (4,800) (16,000) (16,800) (17,600) (18,400) (19,200) (22,400) (20,800) (19,200) (17,600) (16,000) 10,000 10,000 10,000 10,000 10,000 100 300 600 1,000 1,500 (3,000) (6,100) (9,300) (12,600) (16,000) (2,900) (5,800) (8,700) (11,600) (14,500) 13,000 Maintenance - 3,000 Risk - (15,000) Replacement - (30,000) Total - (42,000) Straightening of Headstones NIA 24,375 - Normal Operations and Maintenance - 910 1,820 2,730 3,640 (1,300) (780) (260) 260 (1,300) (780) (260) - (650) (780) (910) (1,040) (2,340) (520) 1,300 2,860 6,000 91000 12,000 15,000 (13,500) (12,000) (10,500) (9,000) (31,500) (33,000) (34,500) (36,000) (39,000) (36,000) (33,000) (30,000) IMPACTS OF CAPITAL IMPROVEMENT PROJECTS ON OPERATING COST CALCULATIONS BY PROJECT (CONTINUED) List of Protects Facility Maintenance City Hall/Police Air Conditioners Maintenance Efficiency Replacement Total Fleet Management Public Works Fleet Equipment Maintenance Efficiency Risk Replacement Total Golf Course Golf Course Small Equipment Maintenance Risk Replacement Total Airport Airport Entrance Signage Maintenance Risk Total Modernize Security Cameras Maintenance Efficiency Risk Replacement Total Taxiways C,D 8 E Construction Maintenance Risk Total Construct Access Road West Maintenance Total Engineer and Construct Hangar Maintenance Total Construct Shade Hangars Maintenance Total Totals Life 125 250 375 500 Years FY 2017-18 FY 2018-19 FY 2019-20 FY 2020.21 FY 2021-22 FY 2022.23 10 40,000 40,000 40,000 40,000 40,000 40,000 - 1,200 3,600 7,200 12,000 18,000 - (4,000) (7,200) (9,600) (11,200) (12,000) - (4,000) (8,400) (13,200) (18,400) (24,000) - (6,800) (12,000) (15,600) (17,600) (18,000) 10 - 20,000 40,000 7,000 7,000 - - - 600 2,400 4,410 6,630 - (2,000) (5,600) (5,100) (4,460) - - (2,000) (5,600) (5,100) (4,460) - - (2,000) (6,200) (7,500) (8,870) - - (5,400) (15,000) (13,290) (11,160) 7 2,500 7 10,000 5 100,000 30+ 1,998,658 30+ 30+ 30+ 625,000 - 125 250 375 500 - (250) (175) (100) (25) - (175) (200) (225) (250) - (300) (125) 50 225 500 1,000 1,500 2,000 2,500 (1,000) (700) (400) (100) - (500) 300 1,100 1,900 2,500 7,000 14,000 21,000 28,000 35,000 (10,000) (6,000) (2,000) 2,000 4,000 (10,000) (6,000) (2,000) - - (5,000) (6,000) (7,000) (8,000) (9,000) (18,000) (4,000) 10,000 22,000 30,000 2,391,136 - - - - 19,987 63,885 107,782 151,680 195,578 (199,866) (438,979) (418,993) (395,081) (375,095) (179,879) (375,095) (311,210) (243,401) (179,517) - - - 2,000,000 - - - - 20,000 - - - - 20,000 - 1,125,000 1,125,000 - - - - 11,250 33,750 56,250 - - 11,250 33,750 56,250 - - 200,000 - - 6,250 12,500 18,750 27,000 35,250 6,250 12,500 18,750 27,000 35,250 $ (937,939) $ (1,799,583) $ (1,820,926) $ (1,367,449) $ (725,816) Local Option Gas Tates FOOT Lighting Agreement Transfer from General Fund (AAF -Streets) Investment Income Total Revenues Street Lights R/R Grassing Maintenance All Aboard Florida Road Striping Indian River Drive Light Poles Road Signs and Markings Sidewalk Construction and Repair Total Operational and Maintenance Debt Payment - Final FY22.23 School Crossing Beacons Street Repaving for FY15 + Main Street Repaving TOTAL Catch-up Street Repaving TOTAL Repaving (Indian River Drive) TOTAL Repaving (Pleasant View/Rollinghills/Schumann) TOTAL Repaving, as needed TOTAL Repaving, as needed TOTAL Repaving, as needed TOTAL Repaving, as needed TOTAL BEGINNING FUND BALANCE BUDGET RESERVE -15% OF EXPENSES UNRESTRICTED RESERVE BALANCE TOTAL REVENUES TOTAL EXPENDITURES+TRANSFERS ENDING FUND BALANCE LOCAL OPTION GAS TAX FUND PROJECTED BALANCES FISCAL YEARS 2018-2023 FY 16-16 FY 16-17 FY 17-18 FY 1849 FY 19-20 FY 20-21 FY 21.22 FY 22-23 8 646,132 $ 656,732 $ 683,001 $ 710,321 $ 736,734 $ 768,283 $ 799,015 $ 830,975 10,352 12,532 12,908 12,908 12,908 12,908 12,908 12,908 200,000 200,000 - - - - - - 1,780 1,700 1,258 1,114 1,326 1,760 2,263 2,840 $ 858,264 $ 870,964 $ 697,167 $ 724,343 $ 752,968 $ 782,951 $ 814,186 $ 846,723 $ 183,067 $ - $ - $ - $ - $ - It - $ - 5,103 5,103 5,103 5,103 5,103 5,103 5,103 5,103 106,000 3,350 20,000 20,000 20,000 20,000 20,000 20,000 2,846 23,553 20,512 35,000 44,077 23,000 23,000 $ 258,646 $ 157,965 $ 83,103 $ 242,748 242,635 242,445 9,488 246,678 153,500 $ 901,572 663,423 $ 1,073,511 451,000 $ 776,548 35,000 35,000 23,000 23,000 83,103 $ 83,103 $ 243,177 243,802 320,000 It 646,280 250,000 $ 576,905 35,000 35,000 35,000 23,000 23,000 23,000 83,103 $ 83,103 $ 83,103 243,340 242,801 122,174 250,000 $ 576,443 $ 418,661 $ 375,353 $ 172,806 $ 93,425 171,488 98,824 124,631 80,115 60,465 49,965 $ 319,838 $ 250,722 3 92,691 $ 32,960 $ 121,523 It 858,264 870,964 697,167 724,343 752,968 901,572 1,073,511 776,548 646,280 576,905 $ 276,530 $ 48,175 $ 13,310 $ 111,023 3 297,586 $ 250,000 $ 575,904 250,000 $ 455,277 347,551 554,059 792,341 49,965 49,965 49,965 297,586 $ 504,094 $ 742,376 782,951 814,166 846,723 576,443 575,904 455,277 504,094 $ 742,376 $ 1,133,822 DISCRETIONARY SALES TAX FUND (DST) PROJECTED BALANCES FISCAL YEARS 2018-2023 FY 15-16 FY 16.17 FY 17-16 FY 18-19 FY 19-20 FY 20-21 FY 21.22 FY 22.23 DST Revenue $ 3,052,152 $ 3,110,OOD $ 3,187,750 $ 3,267,444 S 3,349,130 $ 3,432,858 $ 3,518,680 S 3,600.647 Principal from $285,000 Airport Advance 09/29/08 649 675 702 6,730 6,999 7,279 7,570 7,873 Interest from $285,000 Airport Advance 11,351 11,325 11,298 11,270 11,001 10,721 10,430 10,127 Principal from $287,511 Airport Advance 01/05/11 0 1,800 1,872 1,946 2,024 2,105 8.189 8,517 Interest from $267,511 Airport Advance 8,025 10,700 10,628 10,554 10,476 10,395 10,311 9,983 Investment Income 8,424 2.985 3.206 2,597 3,225 2,030 2.452 4,219 DST PROJECT REVENUE $ 3,080,601 $ 3,137.465 $ 3,215,458 S 3,300,540 S 3,382,855 It 3,465,388 $ 3,557.832 $ 3,647,365 City Hall Debt (Rattles 2018) 868,342 354,253 Stormwater Debt (Retinas 5/01/22) 401,143 402,178 403,792 402,914 401,355 400,961 234,292 - Compuler Replacement and Annual Upgrades 27,541 112,440 30,000 210,000 30,000 30,000 30,000 30,000 MIS Servers 40,000 Firewall Software 75,650 UPS Bypass Switches 12,000 Audio Visual Equipment 50,000 30,000 Laserliche Software Upgrade 50,000 Wireless Capability at City Hell and Police Station 51000 Police Vehicles and Equipment 249,341 388,250 350,000 350,000 300,000 300,000 300,000 300,000 City HaIBPolice Air Conditioners 40,000 40,000 40,000 40,000 40,000 Diesel Fuel Tank and Software - 25,000 Presidential Streets 28,856 Fish House Improvements 107,372 Construct Hangar"C" 24,143 283,151 Airport Drive East 109,062 101,396 Tulip Drive - 177,124 CavCor Boal Parking Paving Completion 41,915 - Roof Repairs (City Hall and PD) 40,640 32,517 Painting City Hall - 36,600 Police - Public Parking 62 29,335 City Hall Parking Lot - - - 50,000 Patch Truck - 158,252 Diesel Tractor 49,224 Goff Course Improvements 599,858 Police Evidence Garage/Fixtures 22,915 345,261 20,000 50,000 Dispatch Consoles Upgrade - 63,390 Working Waterfront Phase 2A Enhancements 15,791 202.193 Working Waterfront Drainage Phase 3 Shoreline - - 200,000 Excavator (Grant matching) 25,280 Replace Schumann Sidewalk 23,828 Street Rewnstruction 136,121 479,045 306,500 Runway Markings 7,307 Automated Weather Observation System - 21,200 Electrical Boring for Swoop Pond 4,000 Service Pathway 12,104 Chipper 60,999 TOTAL FY 16 $ 2,765,073 Street Reconstruction (Vowlle and Damask) 130,545 50,000 Backhoe 84,169 Purchase 190 Sebastian Blvd. 71,162 Stonecrap Drainage 22,000 187,500 - Airport Master Plan Design/Environmental Study 25,800 Taxiway "C-, "D" and "E" Design 13,110 Dump Truck ( Split with Stormwater/General Fund) 60,000 Gaff Clubhouse Reconstruction 175,000 Cemetery Columbariums (Excess of Trust Fund Budget) 40,093 TOTAL FY 17 $ 3,992,053 Dispatch Console and Radio System Replacement 57,000 50,000 100,000 50,000 Dispatch Power Source/Generator 17,000 200,000 Public Works Garage Compound 100,000 2,850,000 1,150,000 Pickle Ball Courts 213,000 172,000 Stormwater Heavy Equipment 145,000 290,000 70,00D 145,000 Airport Shade Hangars 125,000 40,00D Taxiway "D" and "E" Construction 109,195 Airport Security Cameras 100,000 Construct Access Road West - - - - 100,000 Cemetery Initiation System 150,000 TOTAL FY 19 $ 2 Cat Loader 200,000 8 yd. Brush Truck - 125,000 Skid Steer Track Mower 75,000 - - Taxiway "C' Construction (West and East) 128,819 Engineering and Construction of Hangar "D' 225,000 225,000 TOTAL FY 19 4,935,733 TOTAL FY 20 2,861,355 TOTAL FY 21 1,155,961 TOTAL FY 22 849,292 Cemetery South Paved Roadway 100,000 TOTAL FY 23430, 00 BEGINNING FUND BALANCE $ 2,413,577 $ 2,709,105 $ 1,854,518 It 2,650,340 $ 1,015,147 $ 1,538,647 $ 3,846,074 $ 6,554,414 BUDGET RESERVE - 10% OF EXPENSES 278,507 399,205 241,964 493,573 286,136 115.596 84,929 43,000 RESERVE FOR ADVANCES 528,149 525,674 523,100 514,424 505,401 496,017 480,258 463,868 UNRESTRICTED RESERVE BALANCE $ 1,606,921 $ 1,784,226 $ 1,089,454 It 1,642,342 It 223,611 S 925,034 $ 3,280,887 $ 6,047,545 TOTALREVENUES 3,080,601 3,137,465 3,215,458 3,300,540 3,382,855 3,465,388 3,557,632 3,647,365 TOTAL EXPENDITURES -DEBT -TRANSFERS 2,785,073 3,992,053 2,419,637 4,935,733 2.861.355 1.155.961 849,292 430,000 ENDING FUND BALANCE $ 1,902,449 $ 929,639 $ 1,885,276 S 7,150 S 745,111 $ 3,234,461 $ 5,989,227 $ 9,264,912 Cash on Hand $ 2,180,956 It 1,328,844 It 2,127,240 $ 500,723 It 1,031,246 S 3,350,057 $ 6,074,156 It 9,307,912 RECREATION IMPACT FEE FUNDS PROJECTED BALANCES FISCAL YEARS 2018-2023 BEGINNING FUND BALANCE TOTALREVENUES TOTAL EXPENDITURES ENDING FUND BALANCE BEGINNING FUND BALANCE: Zone A Zone B Zone C Zone D All Zones Recreation Impact Fees Zone A Zone B Zone C Zone D All Zones Investment Income Zone A Zone B Zone C Zane D All Zones Transfers: Zone A Zone B Zane C Zone D All Zones Ending Balances: Zone A Zone B Zone C Zone D All Zones $ 769,138 $ 904,892 $ 847,662 $ 561,342 $ 168,153 168,981 168,680 167,177 32,399 226,211 455,000 0 $ 904,892 $ 847,662 $ 561,342 $ 728,519 $ 728,519 $ 896,574 $ 1,065,511 $ 1,235,334 168,055 168,937 169,824 170,715 0 0 0 0 896,574 $ 1,065,511 $ 1,235,334 $ 1,406,050 FY 15-16 FY 16-17 FY 17.18 FY 18-19 FY 19.20 FY 20.21 FY 21.22 FY 22-23 $ 305,003 $ 375,034 $ 374,205 $ 281,310 $ 358,578 $ 436,248 $ 514,323 $ 592,807 117,095 135,946 108,947 24,600 53,524 82,612 111,861 141,269 38,818 47,733 48,100 61,025 74,041 87,122 100,270 113,485 308,223 346,180 316,410 194,407 242,376 290,592 339,057 387,773 $ 769,138 $ 904,892 $ 847,662 $ 561,342 $ 728,519 $ 896,574 5 1,065,511 $ 1,235,334 $ 75,576 $ 75,576 $ 75,576 $ 75,576 $ 75,576 $ 75,576 $ 75,576 $ 75,576 28,776 28,776 28,776 28,776 28,776 28,776 28,776 28,776 12,649 12,649 12,649 12,649 12,649 12,649 12,649 12,649 46,800 46,800 46,800 46,800 46,800 46,800 46,800 46,800 $ 163,800 $ 163,800 $ 163,800 $ 163,800 $ 163,800 $ 163,800 $ 163,800 $ 163,800 $ 1,726 $ 2,147 $ 2,154 $ 1,692 $ 2,094 $ 2,500 $ 2,908 $ 3,319 663 778 627 148 313 473 632 791 220 273 277 367 432 499 567 635 1,744 1,982 1,822 1,170 1,416 1,665 1,917 2,171 $ 4,353 $ 5,181 $ 4,880 $ 3,377 $ 4,255 $ 5,137 $ 6,024 $ 6,915 $ 7,271 $ 78,552 $ 170,625 $ - $ - $ - $ - $ - 10,587 56,553 113,750 - - - - - 3,954 12,555 - - - - - - 10,587 78,552 170,625 - - - - - $ 32,399 $ 226,211 $ 455,000 $ - $ - $ - $ - $ - 436,248 $ 514,323 $ 592,807 $ 671,701 $ 375,034 $ 374,205 $ 281,310 $ 358,578 $ 135,946 108,947 24,600 53,524 47,733 48,100 61,025 74,041 346,180 316,410 194,407 242,376 $ 904,892 $ 847,662 $ 561,342 $ 728,519 $ 82,612 111,861 141,269 170,836 87,122 100.270 113,485 126,769 290,592 339,057 387,773 436,744 896,574 $ 1,065,511 $ 1,235,334 $ 1,406,050 FY 15-16 FY 16-17 FY 17-18 FY 18.19 FY 19-20 FY 20-21 FY 21.22 FY 22-23 Recreation Impact Fees $ 163,800 $ 163,800 $ 163,800 $ 163,800 $ 163,800 $ 163,800 $ 163,800 $ 163,800 Investment Income 4,353 5,181 4,880 3,377 4,255 5,137 6,024 6,915 PROJECTED REVENUE $ 168,153 $ 168,981 $ 168,680 $ 167,177 $ 168,055 $ 168,937 $ 169,824 $ 170,715 Equipment Building 16,584 Community Center(Paving/Drainage/Lighting) 940 50,220 Barber Street Netting 14,875 TOTAL FY 15 TOTAL FY 16 $ 32,399 Pickle Ball (See DST) - Parks & Recreation Comprehensive Plan 19,600 Parks Inspection 12,800 Football Field Restrooms 128,100 CavCorp Boat Parking Landscaping 15,491 Barber Street Ballfield Lighting 375,000 TOTAL FY 17 $ 226,211 ADA Playground 80,000 TOTAL FY 18 $ 455,000 - TOTAL FY 19 $ - - TOTAL FY 20 $ - - TOTAL FY 21 $ - - BEGINNING FUND BALANCE TOTALREVENUES TOTAL EXPENDITURES ENDING FUND BALANCE BEGINNING FUND BALANCE: Zone A Zone B Zone C Zone D All Zones Recreation Impact Fees Zone A Zone B Zone C Zone D All Zones Investment Income Zone A Zone B Zone C Zane D All Zones Transfers: Zone A Zone B Zane C Zone D All Zones Ending Balances: Zone A Zone B Zone C Zone D All Zones $ 769,138 $ 904,892 $ 847,662 $ 561,342 $ 168,153 168,981 168,680 167,177 32,399 226,211 455,000 0 $ 904,892 $ 847,662 $ 561,342 $ 728,519 $ 728,519 $ 896,574 $ 1,065,511 $ 1,235,334 168,055 168,937 169,824 170,715 0 0 0 0 896,574 $ 1,065,511 $ 1,235,334 $ 1,406,050 FY 15-16 FY 16-17 FY 17.18 FY 18-19 FY 19.20 FY 20.21 FY 21.22 FY 22-23 $ 305,003 $ 375,034 $ 374,205 $ 281,310 $ 358,578 $ 436,248 $ 514,323 $ 592,807 117,095 135,946 108,947 24,600 53,524 82,612 111,861 141,269 38,818 47,733 48,100 61,025 74,041 87,122 100,270 113,485 308,223 346,180 316,410 194,407 242,376 290,592 339,057 387,773 $ 769,138 $ 904,892 $ 847,662 $ 561,342 $ 728,519 $ 896,574 5 1,065,511 $ 1,235,334 $ 75,576 $ 75,576 $ 75,576 $ 75,576 $ 75,576 $ 75,576 $ 75,576 $ 75,576 28,776 28,776 28,776 28,776 28,776 28,776 28,776 28,776 12,649 12,649 12,649 12,649 12,649 12,649 12,649 12,649 46,800 46,800 46,800 46,800 46,800 46,800 46,800 46,800 $ 163,800 $ 163,800 $ 163,800 $ 163,800 $ 163,800 $ 163,800 $ 163,800 $ 163,800 $ 1,726 $ 2,147 $ 2,154 $ 1,692 $ 2,094 $ 2,500 $ 2,908 $ 3,319 663 778 627 148 313 473 632 791 220 273 277 367 432 499 567 635 1,744 1,982 1,822 1,170 1,416 1,665 1,917 2,171 $ 4,353 $ 5,181 $ 4,880 $ 3,377 $ 4,255 $ 5,137 $ 6,024 $ 6,915 $ 7,271 $ 78,552 $ 170,625 $ - $ - $ - $ - $ - 10,587 56,553 113,750 - - - - - 3,954 12,555 - - - - - - 10,587 78,552 170,625 - - - - - $ 32,399 $ 226,211 $ 455,000 $ - $ - $ - $ - $ - 436,248 $ 514,323 $ 592,807 $ 671,701 $ 375,034 $ 374,205 $ 281,310 $ 358,578 $ 135,946 108,947 24,600 53,524 47,733 48,100 61,025 74,041 346,180 316,410 194,407 242,376 $ 904,892 $ 847,662 $ 561,342 $ 728,519 $ 82,612 111,861 141,269 170,836 87,122 100.270 113,485 126,769 290,592 339,057 387,773 436,744 896,574 $ 1,065,511 $ 1,235,334 $ 1,406,050 RIVERFRONT CRA FUND PROJECTED BALANCES FISCAL YEARS 2018-2023 FY 15-16 FY 16-17 FY 17-18 FY 18-19 FY 19-20 FY 20-21 FY 21-22 FY 22-23 Tax Increment from City $ 181,150 $ 181,631 $ 178,556 $ 183,913 $ 189,430 $ 195,113 $ 200,966 $ 206,995 Tax Increment from County 157,874 160,610 171,433 176.576 181,873 187.329 192.949 198,738 Renta 36,000 36,000 36,000 36,000 36.000 36,000 36,000 36,000 Investment Income 3,019 3,227 1,878 2,433 3,037 3,324 4,064 4,873 PROJECTED REVENUE $ 378,043 $ 381,468 $ 387,867 $ 398,921 $ 410,341 $ 421,766 $ 433.980 It 446,606 Waterfront Renovation/Experaes(Crabby Bills) 23,572 24,000 24,000 24,000 24,000 24,000 24,000 24,000 Farade/Sign Improvement Program 10.196 30,000 40,000 40,000 40,000 40,000 40,000 40,000 Sewer Connection Program 69.500 230,000 - 100,000 100,000 100,000 100,000 100,000 Special Events 37,120 42,000 42,000 42,000 42,000 42,000 42,000 42,000 Operating Expenditures 63,014 26,654 101,192 103.824 106,535 109,328 112,204 115.167 Update CRA Master Plan - 50,000 Signage for Clamber of Commerce 15,000 Veteran's Memorial 11,209 Speed Cushions on Indian River Drive 3,875 CavCorp Enhancements 8,195 188,730 Transfer to General Fund for Quality Maintenance 21,667 Landscaping Maintenance Contract 118,370 TOTAL RIVERFRONT CRA FY16 $ 366,718 TOTAL RIVERFRONT CRA FY17 $ 556,384 Riverview Park Tree Canopy 10,000 10.000 10,000 10.000 10.000 10,000 Waylinding Signage 50,000 TOTAL RIVERFRONT CRA FY18 $ 317,192 Street Signage 50,000 50,000 TOTAL RIVERFRONT CRA FY19 $ 319,824 TOTAL RIVERFRONT CRA FY20 $ 372,535 TOTAL RIVERFRONT CRA FY21 $ 325,328 TOTAL RIVERFRONT CRA FY22 $ 328,204 TOTAL RIVERFRONT CRA FY23 $ 331,167 BEGINNING FUND BALANCE $ 446,728 $ 458.053 $ 283,137 $ 353,812 $ 432,909 $ 470,714 $ 567,153 $ 672,929 ANNUAL REVENUES 378,043 381,468 387.867 398,921 410,341 421,766 433.980 446,606 ANNUAL EXPENDITURES 366.718 556.384 317,192 319,824 372.535 325.328 328,204 331,167 ENDING FUND BALANCE $ 458,053 $ 283,137 $ 353,812 $ 432,909 $ 470.714 $ 567,153 $ 672,929 $ 788,368 ' Note: $270,000 is also currently available from the $100,000 per year allocation from ad valorem taxes for Indian River Lagoon cleanup. Detail on Ooeratina Expenditures: Indian River County Tax Assessor $ 5,000 $ 5,000 $ 5,000 $ 5,000 $ 5,000 $ 5,000 $ 5,000 $ 5,000 City of Sebastian Administration 13,202 13,202 87,740 90,372 93,083 95,876 98,752 101,715 Street Lighting 15,579 - - - - - - - Water/Sewer 946 - - - - - - - Janitodal Services 20,398 Submerged Land Lease 3,968 4,710 4,710 4,710 4,710 4,710 4,710 4,710 Legal Advertisements 1,463 1,500 1,500 1,500 1,500 1,500 1,500 1,500 CRA Association 175 175 175 175 175 175 175 175 Ad Valorem Taxes 2,033 2,067 2,067 2,067 2,067 2,067 2,067 2,067 Tree Inventory 250 - - - - - - - Total Operating Expenditures $ 63,014 $ 26,654 $ 101,192 $ 103,824 $ 106,535 $ 109,328 $ 112,204 $ 115,167 Stormwater Fees Transfer from General Fund Investment Income SW PROJECTED REVENUE Professional Services Permit Stormwater Park Maintenance Ditch Maintenance Road Crossings/Sideyard Pipes Pipe Sliplinin9 Pumps/Satle Bon Maintenance or Replacement Total Operational and Maintenance Lagoon Improvements (25K Oyster Mats, 1/3rd Intedocel) SW -618 and SW -619 Pickups SW -6164X4 Pickup 04 Herb/Utility Vehicle and Equipment Armadillo SW -628 Tandum Dump Truck Swale Improvement Grants Transfer to General Fund for Swale Maintenance TOTAL STORMWATER FY16 SW -606 1 Tan Crew Cab Pickup SW -614 04 2006 Pickup Transfer to General Fund for Swale Maintenance TOTAL STORMWATER FY17 NPDES 5 Year Permit Transfer to General Fund for Swale Maintenance TOTAL STORMWATER FY18 Pumps Transfer to General Fund for Swale Maintenance Excavator Buckets/Mowing Heads TOTAL STORMWATER FY19 Water Tank and Trailer Transfer to General Fund for Swale Maintenance TOTAL STORMWATER FY20 Transfer to General Fund for Swale Maintenance TOTAL STORMWATER FY21 Pickup Truck Replacement Transfer to General Fund for Swale Maintenance TOTAL STORMWATER FY22 Pickup Truck Replacement Transfer to General Fund for Swale Maintenance TOTAL STORMWATER FY23 BEGINNING FUND BALANCE BUDGET RESERVE -15% OF EXPENSES UNRESTRICTED RESERVE BALANCE ANNUALREVENUES ANNUAL EXPENDITURES ENDING FUND BALANCE STORMWATER UTILITY FUND PROJECTED BALANCES FISCAL YEARS 2018-2023 FY 15-16 FY 16-17 FY 17-18 FY 18-19 FY 19-20 FY 20-21 FY 21-22 FY 22.23 $ 991,055 $ 998.000 $ 998,000 $ 998,000 $ 998,000 $ 998,000 $ 998,000 $ 998,000 100,000 100,000 - - - - - - 3,400 4,109 4.170 3,376 4,357 4,966 5,868 6.474 $ 1,094,455 $ 1,102,109 $ 1,002,170 $ 1,001,376 $ 1,002,357 $ 1,002,966 $ 1,003,868 $ 1,004,474 $ 148 $ 150 $ - $ - $ - $ - $ - $ - 500 8,682 10,000 10,000 10,000 10,000 10,0D0 10,000 10,000 37,100 50,827 - 90,000 - 90,000 50,000 4,770 3,000 3,000 $ 101,527 $ 103,650 $ 153,000 S 100,000 100.000 47,851 30,349 17,612 72,860 90,027 - 150,000 250,000 550,000 $ 920,199 650,000 $ 1,093,677 7,988 700,000 $ 1,110,988 90,000 90,000 90,000 90,000 90,000 3,000 3,000 3,000 3,000 3,000 103,000 $ 103,000 $ 103,000 $ 103,000 $ 103,000 - 48,000 - 30,000 1,800 700,ODO - 45,000 $ 804,800 20,000 700,000 $ 881,000 700,000 $ 823,000 35,000 700,000 $ 883,000 35,000 700,000 -F--838,000 $ 100,300 $ 274,556 $ 282,988 $ 174,170 $ 370,747 $ 492,104 $ 672,070 $ 792,938 138,030 164,052 166,648 120,720 132.150 123,450 132.450 125,700 $ (37,730) $ 110,505 $ 116,340 $ 53,450 $ 238,597 $ 368,654 S 539,620 3 667,238 1,094,455 1,102,109 1,002,170 1,001,376 1,002,357 1,002,966 1,003,868 1,004,474 920,199 1,093,677 1,110,988 804.800 881,000 823,000 883,000 838,000 $ 136,526 $ 118,937 $ 7,522 $ 250,027 $ 359,954 $ 548,620 $ 660,488 $ 833,712 Payments in Lieu of Parking Investment Income PROJECTED REVENUE Expenditures: Parking on Indian River Drive CavCor Boat Parking Lot PROJECTED DISBURSEMENTS NONEXPENDABLE TRUST FUND: BEGINNING FUND BALANCE REVENUES EXPENDITURES ENDING FUND BALANCE PARKING IN LIEU OF FUND PROJECTED BALANCES FISCAL YEARS 2018-2023 FY 15-16 FY 16-17 FY 17-18 FY 18-19 FY 19-20 FY 20-21 FY 21.22 FY 22-23 $ 26,130 $ 28,418 $ 13,775 $ - $ - $ - $ - S - 358 547 429 432 436 439 442 535 26,488 28,965 14,204 432 436 439 442 535 62 44,703 13,792 62 58,495 - - - - $ 46,549 $ 72,975 $ 43,445 $ 57,649 $ 5802 $ 58,517 $ 58,956 $ 59,398 26,488 28,965 14,204 432 436 439 442 535 62 58,495 - - - - - $ 72,975 $ 43,445 $ 57,649 $ 58,082 $ 58,517 $ 58,956 $ 59,398 $ 59,933 GOLF COURSE FUND PROJECTED BALANCES FISCAL YEARS 2018-2023 FY 15-16 FY 16.17 FY 17.18 FY 18.19 FY 19.20 FY 20-21 FY 21-22 FY 22-23 Charges for Services (5% Rate Increase; $ 1,030,793 Proshop Sales 58,461 Rents 28,473 Other Revenue 4,587 Contributions 9,143 Sale of Carts or Equipment 3,900 Temporary Loan from General Fund 402,000 Transfer from General Fund R&R 42,000 Advance from Building Fund (Greens) 4,460 Investment Income 4,460 PROJECTED REVENUE $ 1,537,357 Operating Costs $ 1,295,329 Proshop Cost of Sales 44,954 Transfer to Capital Fund 51,664 Bank Note/Capital Lease - Golf Carts 57,278 Rebuild Greens Other Capital/Picker, Washer, Dispenser 2,000 Fuel Tank 6,568 TOTAL FY 16 $ 1,457,793 Close out Capital Fund 20,916 Repayment of Temporary Loans Interest Payment to Building Fund Principal Payment to Building Fund TOTAL FY 17 TOTAL FY 18 TOTAL FY 19 $ 1,254,320 TOTAL FY 20 $ 1,446,620 TOTAL FY 21 $ 1,446,620 TOTAL FY 22 $ 1,446,620 TOTAL FY 23 $ 1,258,748 BEGINNING FUND BALANCE TOTALREVENUES EXPENDITURES OPERATING FUND BALANCE BEGINNING FUND BALANCE Transfer from DST Fund Transfer from Operating Fund Advance from Building Fund Transfer from General Fund R&R Investment Income Course Bathrooms Irrigation System - DST & Building Loan Cart Path Repairs Trash Recepticles Golf Bag Rest Golf Bag Stands Pump #1 Motor Replacement Ice Machine Ice Machine for Eagles Nest Pressure Wash/Paint Clubhouse Pump Replacement Electrical Work Starter Shack Repairs Cart Barn Repairs Parking Lot Lights - Building Loan Roofing/Shutters - Building Loan Painting and Carpet CAPITAL FUND BALANCE Total Fund 410 and 415 Balances Due to Other Funds Balances Building Fund Advance Balance CAFR Unrestricted Balance $ 911,464 $ 1,274,434 $ 1,338,156 $ 1,338,156 $ 1,338,156 $ 1,338,156 $ 1,338,156 37,750 55,000 55,000 55,000 55,000 55,000 55,000 26,119 42,000 42,000 42,000 42,000 42,000 42,000 4,460 4,460 4,460 4,460 4,460 4,460 4,460 9,133 7,004 7,004 7,004 7,004 7,004 7,004 88,313 25,011 9,650 88,313 23,886 1,907 10,242 20,916 61,940 175,174 $ 1,254,320 $ 1,382,898 $ 1,446,620 $ 1,446,620 $ 1,446,620 $ 1,534,933 $ 1,446,620 $ 1,268,056 $ 1,258,748 $ 1,268,189 $ 1,277,700 $ 1,287,283 $ 1,296,937 $ 1,306,664 29,000 35,000 35,000 35,000 35,000 35,000 35,000 167,534 57,406 57,406 57,406 57,406 57,406 57,406 175,174 1,907 2,500 34,818 52,000 45,000 35,000 114,000 15,621 4,544 7,118 6,796 6,470 6,139 5,804 5,465 24,626 24,948 25,274 25,605 25,940 26,279 $ 1,681,033 $ 1,382,898 $ 1,446,838 $ 1,446,850 $ 1,446,432 $ 1,535,087 $ 1,446,435 $ (248,172) $ (168,608) $ (595,321) $ (595,321) $ (595,539) $ (595,769) $ (595,582) $ (595,737) 1,537,357 1,254,320 1,382,898 1,446,620 1,446,620 1,446,620 1,534,933 1,446,620 1,457,793 1,681,033 1,382,898 1,446,838 1,446,850 1.,446,432 1,535,087 1,446,435 $ (168,608) $ (595,321) $ (595,321) $ (595,539) $ (595,769) $ (595,582) $ (595,737) $ (595,552) $ 140,923 $ (34,818) $ 599,858 51,664 34,818 356,700 26,913 24,600 616 103,396 884,376 5,997 59,055 2,384 4,627 2,685 7,890 5,161 2,391 3,300 3,185 25,011 9,650 23,886 10,242 20,916 61,940 $ (34,818) $ - $ - $ - $ - $ - $ - $ $ (203,426) $ (595,321) $ (595,321) $ (595,539) $ (595,769) $ (595,582) $ (595,737) $ (595,552) (535,800) (535,800) (535,800) (483,800) (438,800) (403,800) (289,800) (274,179) /358,700) /356,700) /332,074) f307,126) JJ281,852) /256,247) /230,308) /204,029) $(1,095,926) $({,487,821) $( ,463,15 $({,386,466) $(1,316,421 $( ,255,629 $({,115,844) $({,073,760) OPERATING FUND: Fuel Sales Revenue (2.5% Increase) Non-taxable Rents Golf Course Rents Taxable Rents Other Revenue Transfer from General Fund Investment Income PROJECTED REVENUE Operating Costs Fuel Purchases for Resale Mower Fencing Repairs Air Conditioners Gate Installation Vehicle Purchase Swoop Pond Wind Sock and Pole Repayment of General Fund Advance Repayment of DST Fund Advance TOTAL FY 16 TOTAL FY 17 Entrance Signage TOTAL FY 18 TOTAL FY 19 TOTAL FY 20 TOTAL FY 21 TOTAL FY 22 TOTAL FY 22 BEGINNING FUND BALANCE TOTAL REVENUES TOTAL EXPENDITURES+DEBT+TRANSFERS ENDING FUND BALANCE CAPITAL FUND: BEGINNING FUND BALANCE Grants Transfers from General Fund Transfers from DST Total Expended ENDING FUND BALANCE TOTAL OPERATING AND CAPITAL General Fund Advance Balance DST Fund Advance Balance CAFR Unrestricted Balance AIRPORT FUND PROJECTED BALANCES FISCAL YEARS 2018-2023 FY 15.16 FY 16.17 FY 17.18 FY 18.19 FY 19.20 FY 20.21 FY 21.22 FY 22-23 $ 78,095 $ 74,000 $ 74,000 $ 75,850 $ 77,746 $ 79,690 $ 81,682 $ 83,724 391 391 391 391 391 391 391 391 100,000 100,000 106,000 106,000 106,000 106,000 106,000 106,000 231,847 238,375 298,625 298,625 298,625 298,625 298,625 298,625 106,070 80,793 73,840 73,840 73,840 73,840 73,840 73,840 4,826 5,526 892 567 600 784 1,031 956 874 791 $ 522,121 $ 499,652 $ 553,455 $ 555,490 $ 557,634 $ 559,502 $ 561,412 $ 563,371 379,515 381,946 437,956 443,211 448,530 453,912 459,359 464,872 57,919 55,000 56,000 57,400 58,835 60,306 61,814 63,359 2,524 27,416 14,061 12,000 29,331 6,020 4,826 50,000 10,000 25,000 10,000 10,000 10,000 10,000 10,000 19,376 24,500 24,500 30,500 30,500 30,500 30,500 30,500 $ 598,162 $ 476,272 10,000 $ 553,456 $ 541,111 $ 547,865 $ 554,718 $ 561,673 $ 568,730 $ 17,944 $ (58,097) $ (34,717) $ (34,717) $ (20,339) $ (10,570) S (5,786) $ (6,047) 522,121 499,652 553,456 555,490 557,634 559,502 561,412 563,371 598,162 476,272 553,456 541,111 547,865 554,718 561,673 568,730 S (58,097) $ (34,717) $ (34,717) $ (20,339) $ (10,570) $ (5,786) $ (6,047) $ (11,407) 532,818 1,179,906 2,389,463 2,262,317 900,000 900,000 1,900,000 2,800 181,895 297,267 334,195 128,819 225,000 225,000 717,513 1,477,173 2,723,658 2,391,136 1,125,000 1,125,000 $ (58,097) $ (34,717) $ (34,717) $ (20,339) $ (10,570) $ (5,786) $ ((100,000) ((90,000)) ((65,000)) ((55,000)) ((45,000)) ((35,000)) $ (708,75) $ (872,880} $ (645,306} $ (612,252} $ (583,460) $ (559,292) $ 100,000 2,000,000 - (6,047) $ (11,407) (25,000) (15,000) 502,747 533,79) $ 486,357 512,76 ) BUILDING FUND PROJECTED BALANCES FISCAL YEARS 2018-2023 FY 15.16 FY 16.17 FY 17.18 FY 18.19 FY 19-20 FY 20.21 FY 21-22 FY 22-23 Operating Revenue $ 801,641 $ 645,400 $ 652,400 $ 671,972 $ 692,131 $ 712,895 $ 734,282 $ 756,310 Other Revenue 8,428 2,000 2,500 2,500 2,500 2,500 2,500 2,500 Transfer from General Fund - 25,000 - - - - - - Principal on Golf Course Loan - - 24,626 24,948 25,274 25,605 25,940 26,279 Interest on Golf Course Loan - 4,544 7,118 6,796 6,470 6,139 5,804 5,465 Investment Income 5,323 5,700 4,200 4,172 4,550 4,948 5,011 5,432 PROJECTED REVENUE $ 815,392 $ 682,644 $ 690,844 $ 710,386 $ 730,925 $ 752,087 It 773,536 $ 795,986 Operating Costs Compact Pickup Clear Village Software - 14,383 Operating Costs 532,915 Compact Pickup 20,183 Utility Vehicle 28,100 Surface Tablets 2,814 Large Plan Scanner 14,639 Transfer to General Fund 104,086 Loan to Golf Course 356,700 202,067 TOTAL FY 16 $ 1,059,437 Operating Costs 535,772 TOTAL FY 17 $ 752,242 Operating Costs 607,723 TOTAL FY 18 $ 607,723 Operating Costs 622,673 TOTAL FY 19 $ 622,673 Operating Costs 637,991 TOTAL FY 20 $ 637,991 Operating Costs 653,685 -T TOTAL FY 21 653,685 Operating Costs 669,766 TOTAL FY 22 $ 669,766 Operating Costs 686,242 TOTAL FY 23 $ 686,242 BEGINNING FUND BALANCE $ 975,044 $ 730,999 $ 661,401 $ 744,522 $ 832,237 $ 832,237 $ 925,171 $ 930,639 TOTAL REVENUES 815,392 682,644 690,844 710,388 730,925 752,087 773,536 795,986 EXPENDITURES+DEBT+TRANSFERS 1,059,437 752,242 607,723 622,673 637,991 653,685 669,766 686,242 ENDING FUND BALANCE $ 730,999 $ 661,401 $ 744,522 $ 832,237 $ 925,171 $ 930,639 $ 1,028,941 $ 1,040,383 Golf Course Fund Advance Balance 356,700 558,787 534,161 509,213 483,939 458,334 432,395 406,116 CAFR Unrestricted Balance $ 1,087,699 $1,220,188 $ 1,278,683 $ 1,341,450 $ 1,409,110 It 1,388,973 $ 1,461,336 $ 1,446,499