Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
R-16-29 Capital Improvement Program 2017-2022
RESOLUTION NO. R-16-29 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 2017-2022; 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 2017-2022 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 McPartlan The motion was seconded by Councilmember Coy and, upon being put into a vote, the vote was as follows: Mayor Bob McPartlan Vice -Mayor Jerome Adams Councilmember Andrea B. Coy Councilmember Richard Gillmor Councilmember Jim Hill absent aye The Mayor thereupon declared this Resolution duly passed and adopted this 28`h day of September, 2016 ATTEST": anette ��tl�sms, City Clerk CITY OF SEBASTIAN, O DA By:wliziZ21, McPartlan, MayorAobr Approved as to form and legality for the reliance by the City of Sebastian only: Robert Ginsburg, City Attorney CITY OF SE113ASTIAN HOME OF PELICAN ISLAND CITY OF SEBASTIAN FLORIDA ANNUAL BUDGET FISCAL YEAR 2017-2022 CAPITAL IMPROVEMENT AOTSrd I �in CITY OF SEBASTIAN, FLORIDA CAPITAL IMPROVEMENT PROGRAM FISCAL YEAR 2017-22 CAPITAL IMPROVEMENT PROGRAM 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. CITY OF SEBASTIAN, FLORIDA FISCAL YEAR 2017-2022 SUMMARY OF CAPITAL PURCHASES AND IMPROVEMENTS List of Prolects FY 2016-17 FY 2017.18 FY 2018-19 FY 2019-20 FY 2020-21 FY 2021.22 Totals General Government Audio Visual Equipment $ 50,000 $ 30,000 $ - $ - $ - $ - $ 80,000 Computer Replacements - - 180,000 - - - 180,000 Computer Upgrades 50,000 35,000 35,000 35,000 35,000 35,000 225,000 MIS Servers 40,000 - - - - - 40,000 Police Department Police Operations Equipment 15,000 15,000 6,000 - - 36,000 Police Detective Equipment 61000 5,000 - - - - 11,000 Police Vehicles & Equipment 380,000 264,000 270,000 430,000 300,000 300,000 1,944,000 Roads and Special Projects Public Works Roads Equipment 95,000 150,000 130,000 185,000 80,000 115,000 755,000 Public Works Roads Equipment - 30,000 40,000 - - - 70,000 Sign Replacement 30,000 30,000 30,000 30,000 30,000 30,000 180,000 Street Reconstruction 150,000 50,000 - - 200,000 Street Repaving 750,000 350,000 450,000 250,000 250,000 250,000 2,300,000 Sidewalk Construction 40,000 40,000 40,000 40,000 40,000 40,000 240,000 Road Striping 20,000 20,000 20,000 20,000 20,000 20,000 120,000 Working Waterfront Phase 3. 400,000 - - - - 400,000 Stormwater Stormwater Equipment 10,000 10,000 106,000 55,000 10,000 45,000 236,000 Road CrossinglSideyard Pipes 100,000 90,000 80,000 70,000 60,000 50,000 450,000 Tulip Drive Road Crossing - 50,000 - - - - 50,000 Tractor - - - 165,000 - - 165,000 Track Excavator - - - - 145,000 145,000 Pipe Sliplining 140,000 - - - - - 140,000 Dump Trucks 150,000 160,000 - 125,000 - - 435,000 Transport Truck/Trailer - - 215,000 - - - 215,000 Parks & Recreation Public Works Parks Equipment - 85,000 30,000 52,000 48,000 - 215,000 Riverview Park Fencing 25,000 - - - - - 25,000 Friendship Park Improvements 250,000 - - - - - 250,000 Cemetery Columbariums 55,000 - - - - - 55,000 Facilities Maintenance City Hall Parking Lot - 50,000 - - - - 50,000 Fleet Management Public Works Fleet Equipment 4,000 19,000 40,000 5,000 14,000 - 82,000 Golf Course Golf Cart Fleet 334,059 - - - - 334,059 Golf Course Small Equipment - - 8,785 - - - 8,785 Rebuild Greens 165,000 - - - - - 165,000 Airport Airport Vehicle - 30,000 - - - - 30,000 Weather Observation System - 106,000 - - - - 106,000 Airport Master Plan Design 216,000 - - - - - 216,000 Airport Taxiway C,D,E 276,882 1,600,000 2,000,000 - - - 3,876,882 Construct Access Road West - 800,000 - - - - 800,000 Airport Shade Hangars - 400,000 - - - - 400,000 Totals $ 3,417,882 $ 4,753,059 $ 3,680,786 $ 1,462,000 $ 1,032,000 $ 885,000 $ 16,230,726 CITY OF SEBASTIAN, FLORIDA FISCAL YEAR 2017-2022 SUMMARY OF CAPITAL IMPROVEMENT PROJECTS SUMMARY FY 2016-17 FY 2017-18 FY 2018-19 FY 2019-20 FY 2020-21 FY 2021-22 Total Grouped by Department $ 195,000 $ 115,000 $ 215,000 $ 35,000 $ 35,000 $ 35,000 $ 630,000 General Government $ 140,000 $ 65,000 $ 215,000 $ 35,000 $ 35,000 $ 35,000 S 525,000 Police Department 401,000 284,000 276,000 430,000 300,000 300,000 1,991,000 Public Works Department 440,000 419,059 38,785 52,000 48,000 - 997,844 Roads and Special Projects 1,485,000 670,000 710,000 525,000 420,000 455,000 4,265,000 Stormwater 400,000 310,000 401,000 415,000 215,000 95,000 1,836,000 Parks & Recreation 275,000 85,000 30,000 52,000 48,000 - 490,000 Cemetery 55,000 - - - - - 55,000 Facilities Maintenance - 50,000 - - - - 50,000 Fleet Management 4,000 19,000 40,000 5,000 14,000 - 82,000 Golf Course 165,000 334,059 8,785 - - - 507,844 Airport 492,882 2,936,000 2,000,000 - - - 5,428,882 Total by Departments $3,417,882 $4,753,059 $ 3,680,785 $1,462,000 $1,032,000 $ 885,000 $15,230,726 Grouned by Function General Government $ 195,000 $ 115,000 $ 215,000 $ 35,000 $ 35,000 $ 35,000 $ 630,000 Public Safety 401,000 284,000 276,000 430,000 300,000 300,000 1,991,000 Transportation 1,981,882 3,625,000 2,750,000 530,000 434,000 455,000 9,775,882 Parks & Recreation 440,000 419,059 38,785 52,000 48,000 - 997,844 Physical Environment 400,000 310,000 401,000 415,000 215,000 95,000 1,836,000 Total by Functions $3,417,882 $4,753,059 $ 3,680,785 $1,462,000 $1,032,000 $ 885,000 $15,230,726 Grouped by Fundine Source General Fund $ 25,000 $ 154,000 $ 116,000 $ 57,000 $ 62,000 $ - $ 414,000 DST 988,910 970,200 715,000 650,000 415,000 450,000 4,189,110 LOGT 840,000 440,000 540,000 340,000 340,000 340,000 2,840,000 Recreation Impact Fees 275,000 - - - - - 275,000 Storrnwater Fund 400,000 260,000 401,000 415,000 215,000 95,000 1,786,000 Airport - 30,000 - - - - 30,000 Building Fund 165,000 - 8,785 - - 173,785 Grants/Bank Notes 668,972 2,898,859 1,900,000 - - - 5,467,831 Cemetery 55,000 - - - - - 55,000 Total Funding Sources $ 3,417,882 $ 4,753,059 $ 3,680,785 $ 1,462,000 $ 1,032,000 $ 885,000 $15,230,726 CITY OF SEBASTIAN, FLORIDA FISCAL YEAR 2017-22 CAPITAL IMPROVEMENT PROGRAM BY FUNDING SOURCE Local Recreation General Option Parking Impact Sta�r�m���w�nyater Cemeteq Grants/ Golf JARIl Fund Gas Tax DST In -Lieu -Of Fees Trust Bank Not Course Airport Buildin¢ Total FISCAL YEAR 2016/2017 General Government Audio Visual Equipment Sop" 50.001) Computer Upgrades 50,000 Sg000 MIS Servers 40,000 40,000 Police Department Police Operations Equipment 15,04)1) 15,001) Police Detective Equipment 6,(xm 6,000 Police Vehicles & Equipment 380,004) 380,000 Roads and Special Projects Public Works Roads Equipment 95,00D 95.000 Sign Replacement 30,0011 30,00) Street Reconstruction 150." 150.000 Sheet Repaving Main 350,000 Sidewalk Construction 40,00 40,0o0 Road Striping 20,000 20,000 Working Waterfront Phase 3. 200,00) 20,000 400.000 Stormwater Stomlwater Equipment lam i0.ao0 Road Crossing/Sldeyard Pipes 100,000 100,0) Pipe Sliplining 140.000 14.000 Dump Trucks Iso oto 150,00 Parks & Recreation Riverview Park Fencing 25,004) 25,000 Friendship Park Improvements no,000 25.000 Cemetery Colu ntadums 55.00 55.0110 Final Management Public Works Fleet Equipment 4.000 4.000 Golf Course Rebuild Greens 165.W11 165,000 Airport Airport Master Plan Design 10,80 205.20 - 216,000 Airport Taxiway C,D,E 13,110 263,772 276,662 Total FY 2016/2017 S 25,001 5 Mo.0x1 5 989,910 S - S 275.1100 S 40x00 S 55.11011 S 666.972 S 165.000 5 - S S 3,417,982 CITY OF SEBASTIAN, FLORIDA FISCAL YEAR 2017-22 CAPITAL IMPROVEMENT PROGRAM BY FUNDING SOURCE Local Recreation General Option Parking Impact Stormwater Cemetery Grants/ Calf Fund Cas Tax DST In -Lieu -Or Fees Ullllty Trust Bank No Course Alroort Buildine Total FISCAL YEAR 2017/2018 General Government Audio Visual Equipment 30,000 30,000 Computer Upgrades 35,000 35,000 Police Department Poll= Operations Equipment I5,000 15,000 Police Detective Equipment 5,M 5,000 Police Vehicles & Equipment 28x,000 284,0011 Roads and Special Projects Public Works Roads Equipment 30,000 150,0110 IM,000 Sip Replacement 30,000 30,000 Street Reconstruction 50,000 50,000 Street Repaving 350,001) 3510000 Sidewalk Construction 401010 40,000 Road Striping 20,000 20,000 Stornamler Smnnwater Equipment law 10,000 Road Crossin2/Sideyard Pipes 90.000 90,000 Pipe Sliplinmg - Tulip Drive Road Cmssivg 50,000 50.001) Dump Trucks IM,000 160,0011 Parks & Recreation Public Works Parks Equipment 85,M 85,0110 Facilities Maintenance City Hall Parking Lot 50.000 M,a10 Fleet Management Public Works Fleet Equipment Man) I9,Om Golr Course GOIf Can Fi=t 334,059 334,059 Airport Airport Vehicle 10,010 301001 Weather Observation System 21,200 84,800 106,1)00 Airport Taxiway CD,E 80,01X1 1,5211,000 1,6W,0S1 Construct Access Road West 160.000 640.010 S00.000 Airport Shade Hangars 80.000 320.00 400.000 Total FY 20172018 S 1540KI S 440,0011 S 970300 S 5 - S 2611.0X1 S S 2.898.859 5 S M.WU S - S 4.753,059 CITY OF SEBASTIAN, FLORIDA FISCAL YEAR 2017-22 CAPITAL IMPROVEMENT PROGRAM BY FUNDING SOURCE Local Recreulie. General Option Parking Impact Storm55ater Cemetery Grants/ Golf Fund Gas Tas DST In -Lieu -Of Fees Ulillty Trust Bank Not Course Almon Buildin Total FISCAL YEAR 2018/2019 General Government Computer Replacements S 190,000 1k&000 Computer Upgrades 35.000 15,000 Pollee Department Police Operations Equipment 6,000 6,0ma Police Vehicles & Equipment 270,000 270,n00 Roads and Special Projects Public Works Roads Equipment 40.0W 00.010 170,000 Sign Replacement 30,000 10,000 Street Repaving 450,0011 450,0110 Sidewalk Construction 40.000 40.000 Road Sniping 2nom N'on 1 Stormwster Slormwater Equipment 1116,0110 105,000 Road Crossing/Sideymd Pipes sum $a,m Transport TruckTruiler 215,000 215,000 Parks and Recreation Public Works Parks Equipment 30,0M 30,000 Fleet Management Public Works Fleet Equipment 40.000 40,000 Goll Course Golf Course Small Equipment 5,785 8,785 Airport Airport Taxiway C.D,E IoopW LM.000 10110.000 Total FY 2018/2019 5 11&1100 S N0.000 S 715.000 5 - S - 5 401.000 S - S 1.900,000 S 8.785 S - S - 5 1.6W.785 CITY OF SEBASTIAN, FLORIDA FISCAL YEAR 2017-22 CAPITAL IMPROVEMENT PROGRAM BY FUNDING SOURCE Local Recreation General Option Parking Impact Stormwater Cemetery Grants/ Golf Fund Gas To DST In -Lieu -Of Fees Utility Trust Bank Note Course Airport Buildin¢ Total FISCAL YEAR 20192020 General Government Computer Upgrades 35,0(10 35,000 Police Department Police Vehicles & Equipment 430,000 430,000 Roads and Special Projects Public Works Roads Equipment - 195,000 195,000 Sips Replacement 30,000 30,000 Street Repaving 250,000 2501000 Sidewalk Construction 40,000 40,000 Road Striping 20.000 20,000 Stormwnter Stonnwater Equipment 55,000 55,00 Road Crossing/Sideyard Pipes 70.W 70,000 Trector 165,000 165,000 Dump Trucks 12$Ogl 125,00) Parks and Recreation Public Works Parks Equipment 52,000 52,00 Fleet NanaFcment Public Works Fleet Equipment 5,000 5.000 Total FY 201912020 S 57,0(91 S 340.00a S 650.000 5 - S - 5 415.0cp 5 - 5 - 5 - S - S - S 1.462,000 FISCAL YEAR 2020/2021 General Government Computer Upgrades Police Department Police Vebicles & Equipment Roads and Special Projects Public Works Roads Equipment Sign Replacement Street Repaving Sidewalk Constmetion Road Striping SlormxTter Sump. ter Equipment Road C.in}/Sidcyard Pipes Track Excavator Transport TmckTmiler Parks and Recreation Public Works Parks Equipment Fleet Management Public Works Fleet Equipment Total FY 202012021 CITY OF SEBASTIAN, FLORIDA FISCAL YEAR 2017-22 CAPITAL IMPROVEMENT PROGRAM BY FUNDING SOURCE Loral Recreation General Option Parking Impact Stornamater Cemetery Grants/ Gulf Fund Gas Tas In -Lieu -Of Fees Otlllts. Trust Bank Not Course Airport Buildine Total 48,000 5510011 35,000 3011,0081 3011,000 80,000 811,000 30,1100 30,000 Mauna 2511,000 40,1100 40,0011 20,1100 20,000 litum 10,000 60.000 60,000 145,0041 145.000 4&000 14.000 14.000 S 62.000 5 340,000 S 415.01 S - S - S 215,000 5 - 5 - S 5 - S - S 111132.000 CITY OF SEBASTIAN, FLORIDA FISCAL YEAR 2017.22 CAPITAL IMPROVEMENT PROGRAM BY FUNDING SOURCE Local Recreation General Option Parking Impact Stormwnter Cemetery GmnW Golf Fund Gas To. DST Io -Lieu -Of Fees IARL Trust Bank Note Course Airport Building Total FISCAL YEAR 2021/2022 General Government Computer Upgmdm 35,000 35,0110 Police Department Police Vehicles & Equipment 200,000 300,000 Roads and Special Projects Public Works Roads Equipment - 115.ouo 115,000 Sign Replacement 30,M 20.000 Street Repaving 25g0ou 250.000 Sidewalk Construction 40,000 40,000 Road Striping 20,000 20,000 Storra.mr Sto rr water Equipment 45,000 45,000 Road Crossing/Sideyard Pipes Su,uoo 50,000 Total FY 20212022 5 - 5 240.000 5 450.(W11 S - S - S 9$.000 S 5 - 5 - S 5 S 885.000 Grand Total 5 414,000 S 2.840.000 5 4,189.110 S S 275,030 5 1,786.000 5 55.1110 S 5.467.931 S 173,785 5 20.000 S - S 15.23086 CITY OF SEBASTIAN, FLORIDA FISCAL YEAR 2017-2022 CAPITAL IMPROVEMENT PROJECT REQUEST AND JUSTIFICATION FORM GENERAL GOVERNMENT Project Name: JAudioVisual Funding Source: I General Fund Justification: 16/17 30K Digital/HD Conversion and 20K Channel Automation. 30K Audio Enhancements. The Digital/HD Conversion relates to the camera equipment. The Audio Enhancements include microphone replacements and make the sound system hearing aid compatible. Project Costs: FY 16-17 FY 17-18 FY 18-19 FY 19-20 FY 20-21 FY 21-22 Total $ 50,000 $ 30,000 $ - $ - $ - $ - $ 80,000 Operating Impact (Savings): $ - $ (4,000) $ (1,400) $ 6,600 $ 14,600 $ 21,600 $ 37,400 Project Name: Justification: Computer Replacements Project Description: Funding Source: IDiscretionary Sales Tax Re lace all desktop and laptop employee computers. A 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 16-17 FY 17-18 Operating Impact (Savings): $ - $ Project Name: Funding Source: Justification: FY 18-19 FY 19-20 - $ 180,000 $ - $ Tax FY 20-21 FY 21-22 Total - $ - $ 180,000 3,600 $ 21,600 $ 10,800 and software upgrades. This is needed to keep up-to-date with new technology and cover the cost of implementing new software releases. About $38K appropriated for 16/17 is expected to be applied to upgrades to meet Police FDLE requirements. The Discretionary Sales Tax Fund will cover this through FY 21/22 but unless DST is renewed, General Fund will need to budget for this. Project Costs: FY 16-17 FY 17-18 FY 18-19 FY 19-20 FY 20-21 FY 21-22 Total $ 50,000 $ 35,000 $ 35,000 $ 35,000 $ 35,000 $ 35,000 $ 225,000 Operating Impact (Savings): $ - $ (3,200) $ 800 $ 4,800 $ 7,200 $ 8,800 $ 18,400 Project Name: Justification: MIS Servers Funding Source: ProjectDescription: Discretionary Sales Tax A 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 16-17 FY 17-18 Operating Impact (Savings): $ - $ Project Name: Funding Source: Justification: FY 18-19 FY 19-20 - $ 180,000 $ - $ Tax FY 20-21 FY 21-22 Total - $ - $ 180,000 3,600 $ 21,600 $ 10,800 and software upgrades. This is needed to keep up-to-date with new technology and cover the cost of implementing new software releases. About $38K appropriated for 16/17 is expected to be applied to upgrades to meet Police FDLE requirements. The Discretionary Sales Tax Fund will cover this through FY 21/22 but unless DST is renewed, General Fund will need to budget for this. Project Costs: FY 16-17 FY 17-18 FY 18-19 FY 19-20 FY 20-21 FY 21-22 Total $ 50,000 $ 35,000 $ 35,000 $ 35,000 $ 35,000 $ 35,000 $ 225,000 Operating Impact (Savings): $ - $ (3,200) $ 800 $ 4,800 $ 7,200 $ 8,800 $ 18,400 Project Name: Justification: MIS Servers Funding Source: ProjectDescription: Discretionary Sales Tax Replacement of host servers. This is for the replacement of three aging servers used for computer operations for City Hall, Police Department and the Airport. This is to insure daily operations will continue without fail. The City also intends to use 'cloud" technology for daily back up of files. Project Costs: FY 16-17 FY 17-18 FY 18-19 FY 19-20 FY 20-21 FY 21-22 Total $ 40,000 $ - $ - $ - $ - $ - $ 40,000 Operating Impact (Savings): $ - $ (600) $ (1,100) $ (1,040) $ (990) $ (930) $ (4,660) CITY OF SEBASTIAN, FLORIDA FISCAL YEAR 2017-2022 CAPITAL IMPROVEMENT PROJECT REQUEST AND JUSTIFICATION FORM PUBLIC SAFETY Project Name: Funding Source: Justification: Project Costs: FY 16-17 $ 15,000 Police Operations Equipment Project Description: General Fund 16/17 5K for Patrol Rifles, 5K for Tasers, 5K Ballistic Shields. 17/18 5K for Patrol Rifles, 5K for Tasers, 5K Ballistic Shields. 18/19 6K Tasers 17/18 250K Patrol Units (5), 14K 2 Trailers. This will improve the capabilities and enhance the safety of Police Officers by replacing these equipment items. FY 17-18 FY 18-19 FY 19-20 FY 20-21 FY 21-22 Total $ 15,000 $ 6,000 $ - $ - $ - $ 36,000 Operating Impact (Savings): $ - $ (1,950) $ (1,703) $ 1,850 $ 6,024 $ 9,116 $ 13,337 Project Name: Funding Source: Justification: Police Detective Equipment Project Description: General Fund 16/17 lK Hyper Telephoto Lens, 5K Evidence Building Equipment. 17/18 5K Evidence Building Equipment. This will provide necessary equipment for the Detectives and allow for added equipment for the newly;) constructed evidence building. Project Costs: FY 16-17 FY 17-18 FY 18-19 FY 19-20 FY 20-21 FY 21-22 Total $ 6,000 $ 5,000 $ - $ - $ - $ - $ 11,000 Operating Impact (Savings): $ - $ (1,140) $ (2,030) $ (1,800) $ (1,590) $ (460) $ (7,020) Project Name: Funding Source: Justification: Project Costs: FY 16-17 $ 380,000 Police Vehicles & Equipment Project Description: Discretionary Sales Tax 16/17 350K Patrol Units (7),20K Boat Motor, 10K Light Tower. 17/18 250K Patrol Units (5), 14K 2 Trailers. 18/19 250K Patrol Units (5), 20K Motorcycle. 19/20 250K Patrol Units (5), 180K Generator. 20/21300K Patrol Units (5). 21/22 300K Patrol Units 95). These are scheduled replacements of Police Department vehicles and equipment due to high mileage and maintenance needs. FY 17-18 FY 18-19 FY 19-20 FY 20-21 FY 21-22 Total $ 264,000 $ 270,000 $ 430,000 $ 300,000 $ 300,000 $ 1,944,000 Operating Impact (Savings): $ - $ (83,600) $ (103,680) $ (98,680) $ (94,280) $ (56,280) $ (436,520) CITY OF SEBASTIAN, FLORIDA FISCAL YEAR 2017-2022 CAPITAL IMPROVEMENT PROJECT REQUEST AND JUSTIFICATION FORM PUBLIC WORKS - ROADS AND SPECLAL PROJECTS Project Name: Funding Source: Justification: Public Works Roads Equipment Project Description: Discretionary Sales Tax 16-17 95K Backhoe. 17-18 150K 15-17 Yard Dump Truck. 18-19 90K Brush Truck (Gas) and 40K Utility Truck. 19-20 185K 3 Yard Loader. 20-21 80K Skid Steer Trac Mower. 2121=22 50K Utility Truck and 65K Deisel Tractor. Scheduled replacement of equipment used in the Roads Division that is eligible to be purchased using Discretionary Sales Taxes. This equipment been scheduled for replacement by the Fleet Division. Project Costs: FY 16-17 FY 17-18 FY 18-19 FY 19-20 FY 20-21 FY 21-22 Total $ 95,000 $ 150,000 $ 130,000 $ 185,000 $ 80,000 $ 115,000 $ 755,000 Operating Impact (Savings): $ - $ (36,100) $ (101,650) $ (158,000) $ (214,950) $ (226,450) $ (737,150) Project Name: Public Works Roads Equipment Project Description: Funding Source: Justification: Scheduled replacement of other equipment used in the Roads Division. Project Costs: FY 16-17 FY 17-18 FY 18-19 FY 19-20 FY 20-21 FY 21-22 Total $ $ 30,000 $ 40,000 $ $ $ $ 70,000 Operating Impact (Savings): Included with above. $ - $ - $ - $ $ $ $ Project Name: Funding Source: Tax Justification: I New regulations are requiring this to be done. Project Costs: FY 16-17 FY 17-18 FY 18-19 FY 19-20 FY 20-21 FY 21-22 Total $ 30,000 $ 30,000 $ 30,000 $ 30,000 $ 30,000 $ 30,000 $ 180,000 Operating Impact (Savings): $ - $ (3,600) $ (5,100) $ (4,500) $ (1,800) $ 2,400 $ (12,600) Project Name: Justification: Street Reconstruction Funding Source: General Fund 17/18 30K for Pickup PW -11-2003. 18/19 40K for Utility Truck Justification: Scheduled replacement of other equipment used in the Roads Division. Project Costs: FY 16-17 FY 17-18 FY 18-19 FY 19-20 FY 20-21 FY 21-22 Total $ $ 30,000 $ 40,000 $ $ $ $ 70,000 Operating Impact (Savings): Included with above. $ - $ - $ - $ $ $ $ Project Name: Funding Source: Tax Justification: I New regulations are requiring this to be done. Project Costs: FY 16-17 FY 17-18 FY 18-19 FY 19-20 FY 20-21 FY 21-22 Total $ 30,000 $ 30,000 $ 30,000 $ 30,000 $ 30,000 $ 30,000 $ 180,000 Operating Impact (Savings): $ - $ (3,600) $ (5,100) $ (4,500) $ (1,800) $ 2,400 $ (12,600) Project Name: Justification: Street Reconstruction Funding Source: Project Description: Discretionary Sales Tax Reconstruction of Roadways. Project Costs: FY 16-17 $ 150,000 Operating Impact This will address a portion of Vocelle Avenue in FY 16-17 and Damask in FY 17-18 that requires reconstruction in order to restore them to good condition. FY 17-18 FY 18-19 FY 19-20 FY 20-21 FY 21-22 Total $ 50,000 $ - $ - $ - $ - $ 200,000 CITY OF SEBASTIAN, FLORIDA FISCAL YEAR 2017-2022 CAPITAL IMPROVEMENT PROJECT REQUEST AND JUSTIFICATION FORM PUBLIC WORKS - ROADS AND SPECIAL PROJECTS (CONTINUED) Funding Source: ILocal Option Gas Tax (Resurfacing of roadways. Justification: Necessary to keep streets in good condition. Repaving reduces pot -hole repairs and claims for damage: Timely repaving can avoid a more costly reconstruction. Funds will be transferred each year from Genen Fund to supplement amounts from local option gas taxes that can be applied to this work. Work for FY16-1 includes 150K to resurface part of Vocelle Avenue, $200K for Concha (Southern), $100K for Beva (Southern), 250K for Schumann (West of Railroad) and 50K of other minor areas. Work planned for FY] 18 includes 200K Day Drive, 100K for rest of Vocelle Avenue and 50K of other minor areas. Work fc FY 18-19 includes 200K for Indian River Drive and 250K of other unspecified roadways. Work for FY 19-2 and beyond includes $250K for unspecified roadways. Project Costs: FY 16-17 FY 17-18 $ 750,000 $ 350,000 Operating Impact (Savings): $ - $ (52,500 FY 18-19 FY 19-20 FY 20-21 $ 450,000 $ 250,000 $ 250,000 $ (39,500) $ (16,000) $ FY 21-22 Total $ 250,000 $ 2,300,000 $ 116,500 $ 52,500 Project Name: Sidewalk Construction Project Descri tion: Funding Source: Local O tion Gas Tax Construction and repair of sidewalks throughout the City. Justification: Projects focus on the safety of residents and bikers. Project Costs: FY 16-17 FY 17-18 FY 18-19 FY 19-20 FY 20-21 FY 21-22 Total $ 40,000 $ 40,000 $ 40,000 $ 40,000 $ 40,000 $ 40,000 $ 240,000 Operating Impact (Savings): $ - $ (2,800) $ (3,600) $ (2,400) $ 800 $ 6,000 $ (2,000) Project Name: Funding Source: Justification: IThese funds will be used when needed to stripe or restri a roadways throughout the City. Project Costs: FY 16-17 FY 17-I8 FY 18-19 FY 19-20 FY 20-21 FY 21-22 Total $ 20,000 $ 20,000 $ 20,000 $ 20,000 $ 20,000 $ 20,000 $ 120,000 Operating Impact (Savings): $ - $ (1,000) $ (400) $ 1,800 $ 5,600 $ 10,600 $ 16,600 Project Name: Working Waterfront Phase 3. Project Description: Justification:. Sales Tax - 50% SJRWIVID Grant - 50% Working Waterfront Shoreline Protection Funding Source: Discretionary This project is to continue with improvements to the Working Waterfront by construction of improvements that will protect the shoreline. The Citys matching requirement is expected to be 50% or $200,000. Project Costs: FY 16-17 FY 17-18 FY 18-19 FY 19-20 FY 20-21 FY 21-22 Total $ 400,000 $ - $ - $ - $ - $ - $ 400,000 Operating Impact (Savings): $ - $ 4,000 $ 8,000 $ 12,000 $ 16,000 $ 20,000 $ 60,000 CITY OF SEBASTIAN, FLORIDA FISCAL YEAR 2017-2022 CAPITAL IMPROVEMENT PROJECT REQUEST AND JUSTIFICATION FORM Project Name: Funding Source: Justification: Stormwater Equipment Project Description: Stormwater Fund FY1647 10K Pumps/Baffle Box Filters. This unit is needed to cut back rights -of way. FY17-18 10K Pumps/Baffle Box Filters FY 18-19 48K 1 Ton Crew Cab Truck SW606-2005, 1 OK Pumps/Baffle FY 17-18 FY 18-19 Box Filters, 48K Excavator Buckets/Mowing Heads. FY 20-21 FY19-20 30K 4x4 Pickup SW -614-2006, 15K Water Tank and Trailer, IOK Pumps/Baffle Box Filters. $ 100,000 FY20-21 l OK Pumps/Baffle Box Filters. $ 70,000 $ FY21-22 35K Pickup Truck Replacement, 10K Pumps/Baffle Box $ 50,000 Filters. Scheduled replacement of equipment essential to the stormwater maintenance program. Project Costs: FY 16-17 FY 17-18 FY 18-19 FY 19-20 FY 20-21 FY 21-22 Total $ 10,000 $ 10,000 $ 106,000 $ 55,000 $ 10,000 $ 45,000 $ 236,000 Operating Impact (Savings): $ - $ (3,800) $ (7,300) $ (46,980) $ (64,100) $ (62,470) $ (184,650) Project Name: Funding Source: Justification: Road Crossing/Sideyard Pipes I Project Description: Stormwater Fund I Replacement of road crossing pipes and sideyard piping. This work helps eliminate major flooding by replacing failing pipes. This also saves on maintenance done by the mowing contractor by eliminating the sideyard ditches that require maintenance. Project Costs: I Project Description: Stormwater Fund Replaces Slope Mower SW -688 that was auctioned due an unrepairable broken frame. This unit is needed to cut back rights -of way. FY 16-17 FY 17-18 FY 18-19 FY 19-20 FY 20-21 FY 21-22 Total $ 100,000 $ 90,000 $ 80,000 $ 70,000 $ 60,000 $ 50,000 $ 450,000 Operating Impact (Savings): $ - $ (29,000) $ (37,100) $ (78,300) $ (98,600) $ (116,000) $ (359,000) Project Name: ITulip Drive Road Crossing Project Description: Funding Source: IDiscretionary Sales Tax [Pipe Replacement Justification: This will replace the road crossing pipe under Tulip Drive near Laconia Street, which needs to be upsized for additional flow capacity. Project Costs: FY 16-17 FY 17-18 FY 18-19 FY 19-20 FY 20-21 FY 21-22 Total $ - $ 50,000 $ - $ - $ - $ - $ 50,000 Operating Impact (Savings): $ - $ - $ (14,500) $ (14,500) $ (14,500) S (14,500) $ (58,000) Project Name: Funding Source: Justification: Project Costs: FY 16-17 Tractor I Project Description: Stormwater Fund Replaces Slope Mower SW -688 that was auctioned due an unrepairable broken frame. This unit is needed to cut back rights -of way. FY 17-18 FY 18-19 FY 19-20 FY 20-21 FY 21-22 Total $ - $ - $ - $ 165,000 $ - S - $ 165,000 Operating Impact (Savings): $ - $ - $ - $ - $ (46,200) S (42,900) $ (89,100) CITY OF SEBASTIAN, FLORIDA FISCAL YEAR 2017-2022 CAPITAL IMPROVEMENT PROJECT REQUEST AND JUSTIFICATION FORM PUBLIC WORKS - STORMWATER UTILITY (CONTINUED) Project Name: Justification: Track Excavator Funding Source: Pro'ect Description: Stormwater Fund Provides replacement to 2011 CAT 308 for Stormwater use. This unit is needed for maintenance of stormwater ditches. Project Costs: FY 16-17 FY 17-18 FY 18-19 FY 19-20 FY 20-21 FY 21-22 Total $ - $ - $ - $ - $ 145,000 $ - $ 145,000 Operating Impact (Savings): $ - $ - $ - $ - $ - $ (40,600) $ (40,600) Project Name: Pie Sli lining I Project Description: Funding Source: I Stormwater Fund I Slipling of pipes. Justification: This will provide rehabilitation of the pipes at Schumann and in other smaller locations without removal and replacement. Project Costs: FY 16-17 FY 17-18 FY 18-19 FY 19-20 FY 20-21 FY 21-22 Total $ 140,000 $ - $ $ $ - $ $ 140,000 Operating Impact (Savings): $ - $ (25,200) $ (19,600) $ (14,000) $ (8,400) $ (2,800) $ (70,000) Project Name: Dump Trucks Project Description: Funding Source: Stormwater Fund 16/17 150K 15-16yd Dump Truck SW -628. Justification: Project Costs: FY 16-17 FY 17-18 FY 18-19 FY 19-20 FY 20-21 FY 21-22 Total $ 150,000 $ 160,000 $ - $ 125,000 $ - $ - $ 435,000 Operating Impact (Savings): $ - $ (42,000) $ (83,800) $ (77,600) $ (106,400) $ (97,700) $ (407,500) Project Name: ITransport Truck/Trailer Project Description: Funding Source: I Stormwater Fund 1145K Transport Truck SW -609-2000 and 35 ton Trailer SW -610-2002. Justification: These are scheduled replacements of equipment used by Stormwater crews. The Truck is estimated to cost $145K and the Trailer 70K. Project Costs: FY 16-17 FY 17-18 FY 18-19 FY 19-20 FY 20-21 FY 21-22 Total $ - $ - $ 215,000 $ - $ $ $ 215,000 Operating Impact (Savings): $ - $ - $ - $ (60,200) $ (55,900) $ (51,600) $ (167,700) 17/18 160K 15-16yd Dump Truck SW -615. 19/20 125K 8yd Dump Truck SW607. At the time of the scheduled replacement, these trucks will be over 15 years old. Project Costs: FY 16-17 FY 17-18 FY 18-19 FY 19-20 FY 20-21 FY 21-22 Total $ 150,000 $ 160,000 $ - $ 125,000 $ - $ - $ 435,000 Operating Impact (Savings): $ - $ (42,000) $ (83,800) $ (77,600) $ (106,400) $ (97,700) $ (407,500) Project Name: ITransport Truck/Trailer Project Description: Funding Source: I Stormwater Fund 1145K Transport Truck SW -609-2000 and 35 ton Trailer SW -610-2002. Justification: These are scheduled replacements of equipment used by Stormwater crews. The Truck is estimated to cost $145K and the Trailer 70K. Project Costs: FY 16-17 FY 17-18 FY 18-19 FY 19-20 FY 20-21 FY 21-22 Total $ - $ - $ 215,000 $ - $ $ $ 215,000 Operating Impact (Savings): $ - $ - $ - $ (60,200) $ (55,900) $ (51,600) $ (167,700) CITY OF SEBASTIAN, FLORIDA FISCAL YEAR 2017-2022 CAPITAL IMPROVEMENT PROJECT REQUEST AND JUSTIFICATION FORM PUBLIC WORKS - PARKS AND RECREATION Project Name: Funding Source - Justification: Public Works Parks Equipment Project Description: General Fund 17/18 55K Deisel Tractor P-340, 30K for 2 Mowers P-370 and P330. 18/19 30K Pickup P-382-2003. 19/20 46K for 3 Mowers -2011, 6K Open Trailer. 20/21 18K 15" Mower P-381-2012 and 30K Pickup. This will provide a barrier to prevent vehicle access to the Park. These are scheduled replacements of equipment used in the Parks Division. Project Costs: FY 16-17 FY 17-18 FY 18-19 FY 19-20 FY 20-21 FY 21-22 Total $ - $ 85,000 $ 30,000 $ 52,000 $ 48,000 $ - $ 215,000 Operating Impact (Savings): $ - $ - $ (6,800) $ (700) $ 6,640 $ 17,800 $ 16,940 Project Name: Justification: Riverview Park Fencing Funding Source: Project Description: Recreation Impact Fees Provide fencing at Riverview Park This will provide a barrier to prevent vehicle access to the Park. Project Costs: FY 16-17 FY 17-18 FY 18-19 FY 19-20 FY 20-21 FY 21-22 Total $ 25,000 $ - $ - $ - $ - $ - $ 25,000 Operating Impact (Savings): $ - $ (3,500) $ (2,750) $ (2,000) $ (1,250) $ (1,250) $ (10,750) Project Name: Friendship Park Improvements Project Description: Funding Source: Recreation Impact Fees Design, permitting and construction of new recreation facilities, parking Justification: The Parks and Recreation Committee has been looking to improve Friendship Park. This project will add new facilities, including providing the community with the new recreational sport of Pickle Ball. This will involve a feasibility assessment, permiting and development of detailed construction costs. Project Costs: FY 16-17 FY 17-18 FY 18-19 FY 19-20 FY 20-21 FY 21-22 Total $ 250,000 $ - $ - $ - $ - $ - $ 250,000 Operating Impact (Savings): $ - $ (20,000) $ (12,500) $ (5,000) $ 2,500 $ 10,000 $ (25,000) and drainage retention for Friendship Park The Parks and Recreation Committee has been looking to improve Friendship Park. This project will add new facilities, including providing the community with the new recreational sport of Pickle Ball. This will involve a feasibility assessment, permiting and development of detailed construction costs. Project Costs: FY 16-17 FY 17-18 FY 18-19 FY 19-20 FY 20-21 FY 21-22 Total $ 250,000 $ - $ - $ - $ - $ - $ 250,000 Operating Impact (Savings): $ - $ (20,000) $ (12,500) $ (5,000) $ 2,500 $ 10,000 $ (25,000) CITY OF SEBASTIAN, FLORIDA FISCAL YEAR 2017-2022 CAPITAL IMPROVEMENT PROJECT REQUEST AND JUSTIFICATION FORM PUBLIC WORKS - CEMETERY Project Name: Funding Source: Columbariums JProject Description: Cemetery Trust Fund Add a Columbarium, with 100 double niches back to back. Justification: We expect to be 50% sold out of niches and should be providing for additional ones. Project Costs: FY 16-17 FY 17-18 FY 18-19 FY 19-20 FY 20-21 FY 21-22 Total $ 55,000 $ - $ - $ $ $ - $ 55,000 Operating Impact (Savings): $ $ (4,950) $ (4,400) $ (3,300) $ (2,750) $ (1,650) $ (17,050) PUBLIC WORKS - FACILITIES MAINTENANCE Project Name: Mr i Hall Parking arkin Lot Project Description: Funding Source: Discretion Sales Tax Seal coat and stri a arkin lots at the Cit Hall com lex. Justification: This parking lot should be seal coated and striped. Project Costs: FY 16-17 FY 17-18 FY 18-19 FY 19-20 FY 20-21 FY 21-22 Total $ $ 50,000 $ $ $ $ $ 50,000 Operating Impact (Savings): $ $ $ $ $ $ $ PUBLIC WORKS - FLEET MANAGEMENT Project Name: Funding Source: Justification: Public Works Fleet Equipment Project Description: General Fund 16/17 4K Engine Scanner. 17/18 14K Four Post Lift, 5K Upper/Lower Tool Box. 18/19 40K Utility Service Truck. 19/20 5K Upper/Lower Tool Box. 20/21 7K Portable Welder, 7K Tire Balancer. This equipment is needed for the operations of the City Garage. The existing One Ton Service Utility Tmck will be over 18 years old. Project Costs: FY 16-17 FY 17-18 FY 18-19 FY 19-20 FY 20-21 FY 21-22 Total $ 4,000 $ 19,000 $ 40,000 $ 5,000 $ 14,000 $ $ 82,000 Operating Impact (Savings): $ - $ (320) $ (1,440) $ (2,340) $ 3,400 $ 8,080 $ 7,380 CITY OF SEBASTIAN, FLORIDA FISCAL YEAR 2017-2022 CAPITAL IMPROVEMENT PROJECT REQUEST AND JUSTIFICATION FORM GOLF COURSE FUND Project Name: JGolf Cart Fleet I Project Description: Funding Source: I Bank Note IReplace 86 Golf Carts. Justification: Carts were acquired in October 2013 via 4 year bank note and are expected to be replaced in FY 17-18. Project Costs: FY 16-17 FY 17-18 FY 18-19 FY 19-20 FY 20-21 FY 21-22 Total $ $ 334,059 $ $ - $ - $ - $ 334,059 Operating Impact (Savings): $ - $ - $ (26,725) $ 6,681 $ 40,087 $ 60,131 $ 80,174 Project Name: Golf Course Small Equipment Project Description: Funding Source: Golf Course Operating Fund Gang Picker, Ball Washer and Range Ball Dispenser. Justification: These units are aging and expected to need replacement in the future. Project Costs: FY 16-17 FY 17-18 FY 18-19 FY 19-20 FY 20-21 FY 21-22 Total $ $ $ 8,785 $ - $ - $ - $ 8,785 Operating Impact (Savings): $ - $ $ - $ (2,548) $ (2,372) $ (2,196) $ (7,116) Project Name: lRebuild Greens JProject Description: Funding Source: Golf Course Capital Fund I Fumigate and rebuild the greens. Justification: This would include fumigation to treat the different grass mutations growing on the greens. Within reason, it would bring the greens out to their original dimensions. Project Costs: FY 16-17 FY 17-18 FY 18-19 FY 19-20 FY 20-21 FY 21-22 Total $ 165,000 $ $ $ $ $ $ 165,000 Operating Impact (Savings): $ - $ (24,750) $ (13,200) $ (1,650) $ 9,900 $ 14,850 $ (14,850) CITY OF SEBASTIAN, FLORIDA FISCAL YEAR 2017-2022 CAPITAL IMPROVEMENT PROJECT REQUEST AND JUSTIFICATION FORM AIRPORT FUND Project Name: I Airport Vehicle Funding Source: I Airport Revenue Fund Justification: This is AP -2 used for Airport maintenance activities. Current vehicle is a 4 wheel drive and has accumulated over 76,000 miles. Project Costs: FY 16-17 FY 17-18 FY 18-19 FY 19-20 FY 20-21 FY 21-22 Total $ - $ 30,000 $ $ - $ - $ - $ 30,000 Operating Impact (Savings): $ - $ - $ (6,600) $ (3,600) $ (600) $ 2,400 $ (8,400) Project Name: Weather Observation System Funding ue: Justification:. Project Description: 75% FDOT Grant. City Matching Automated Weather Observation System Requirements at 25% from FY 17-18 FY 18-19 Discretionary Sales Tax funds. FY 20-21 FY 21-22 Total This is for the purchase of an AWAS III upgraded automated weather observation system. The City matching requirement of $21,200 will be from discretionary sales tax funds. Project Costs: Sorc 5% City Matching Requirements from Discretionary Sales Tax Master Plan FY 16-17 FY 17-18 FY 18-19 FY 19-20 FY 20-21 FY 21-22 Total $ $ 106,000 $ - $ - $ - S - $ 106,000 Operating Impact (Savings): (Savings): $ - $ - $ (8,480) $ 2,120 $ 12,720 S 19,080 $ 25,440 Project Name: Airport Master Plan Design Project Description: Project oject Descri tion: Justification: 5% City Matching Requirements from Discretionary Sales Tax Master Plan FY 16-17 FY 17-18 FY 18-19 This is for an update to the Airport Master Plan. The City matching requirement of $10,800 will be from discretionary sales tax funds. Funding ue: 90% FAA Grant. 5% FDOT Grant. Airport Project Costs: Justification: FY 16-17 FY 17-18 FY 18-19 FY 19-20 FY 20-21 FY 21-22 Total $ 216,000 $ $ - $ - $ - $ - $ 216,000 Operating Impact (Savings): $ - $ (6,480) $ 17,280 $ 41,040 $ 56,160 $ 66,960 $ 174,960 Project Name: Airport Taxiway Project oject Descri tion: Funding Source: 190% FAA Grant. 5% FDOT Grant. IDesign and Construction of Airport Taxiway C, D an Design will start in FYI 6-17. Phase I Construction will be for Taxiway D and E in FYI 7-18 and Phase 2 Construction will be for Taxiway C in FYI 8-19. City matching requirement will be from discretionary sales taxes and are projected to be $13,110 for design, $80,000 for Phase 1 an d E. d $100,000 for Phase 2. Project Costs: FY 16-17 FY 17-18 FY 18-19 FY 19-20 FY 20-21 FY 21-22 Total $ 276,882 $ 1,600,000 $ 2,000,000 $ - $ - $ - $ 3,876,882 Operating Impact (Savings): $ - $ (8,306) $ (25,849) $ 120,608 $ 535,989 $ 881,833 $ 1,504,274 CITY OF SEBASTIAN, FLORIDA FISCAL YEAR 2017-2022 CAPITAL IMPROVEMENT PROJECT REQUEST AND JUSTIFICATION FORM AIRPORT FUND (CONTINUED) Project Name: Construct Access Road West Project Description: Funding Source 80% FAA and FDOT Grants. City Design and Build Access Road West Justification: Project Costs: FY 16-17 FY 17-18 FY 18-19 FY 19-20 FY 20-21 FY 21-22 Total $ $ 800,000 $ $ $ - $ - $ 800,000 Operating Impact (Savings): $ - $ - $ (24,000) $ 64,000 $ 152,000 $ 208,000 $ 400,000 Project Name: Airport Shade Hangars Project Description: Funding Source: 80% FDOT Grants. City Matching Design and Build Shade Hangars Requirements at 20% from Discretionary Sales Tax funds. Justification: This project will allow an affordable way for local pilots to protect their aircraft from the elements. There are about 30 aircraft currently only tied down. This will provide 14 shade hangars and resurface the apron area where they will be located. $27,900 of annual revenue to the Airport is anticipated, if these are fully occupied. Project Costs: FY 16-17 FY 17-18 FY 18-19 FY 19-20 FY 20-21 FY 21-22 Total $ - $ 400,000 $ - $ - $ $ - $ 400,000 Operating Impact (Savings): $ - $ - $ (12,000) $ 32,000 $ 76,000 $ 104,000 $ 200,000 Matching Requirements at 20% from Discretionary Sales Tax Airport West development requires infrastructure. $160,000 will be needed as City matching funds. Justification: This project will allow an affordable way for local pilots to protect their aircraft from the elements. There are about 30 aircraft currently only tied down. This will provide 14 shade hangars and resurface the apron area where they will be located. $27,900 of annual revenue to the Airport is anticipated, if these are fully occupied. Project Costs: FY 16-17 FY 17-18 FY 18-19 FY 19-20 FY 20-21 FY 21-22 Total $ - $ 400,000 $ - $ - $ $ - $ 400,000 Operating Impact (Savings): $ - $ - $ (12,000) $ 32,000 $ 76,000 $ 104,000 $ 200,000 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 generally impact operating costs, the City applies four main factors, adjusted by the expected years of useful life. These factors are maintenance, efficiency, risk management and replacement. If applicable, some items may be further adjusted to reflect offsets from anticipated revenues the item will generate. Year of 1 Year 2 Years 3 Years 4 Years 5 Years Purchase After 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% 5% 20 Year Useful Life 0% 2% 4% 6% 8% 10% 10 Year Useful Life 0% 3% 6% 9% 12% 15% 7 Year Useful Life 0% 5% 10% 15% 20% 25% 5 Year Useful Life 0% 7% 14% 21% 28.0 35% 3 Year Useful Life 0% 10% 20% 30% 40% 50% Efficiency Factor - As items get older, the initially improved efficiency declines. Annual amount could be a loss in subsequent years 30+ Year Useful Life 0% -10% -10% -9% -9% -8% 20 Year Useful Life 0% -f0% -9% -8% -79a -6% 10 Year Useful Life 0% -f0% -8% -6% -4% -2% 7 Year Useful Life 0% -10% -7% -4% -1% 2% 5 Year Useful Life 0% -10% -6% -2% 2% 4% 3 Year Useful Life 0% -10% -5% 0% 5% f0% 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% -8% 20 Year Useful Life 0% -105/0 -9% -8% -7% -6% 10 Year Useful Life 0% -10% -8% -6% -4% -2% 7 Year Useful Life 0% -10% -7% -4% -1% 0% 5 Year Useful Life 0% -10% -6% -2% 0% 0% 3 Year Useful Life 0% -10% -5% 0% 0% 0% Replacement Factor - A savings would occur by taking replaced items out of service.Annual amount would continue to compound 30+ Year Useful Life 0% -30% -31% -32% -33% -34% 20 Year Useful Life 0% -20% -21% -22% -23% -24% 10 Year Useful Life 0% -10% -11% -12% -13% -14% 7 Year Useful Life 0% -7% -8% -9% -10% -11% 5 Year Useful Life 0% -5% -6% -7% -8% -9% 3 Year Useful Life 0% -3% -4% -5% -6% -7% Revenue Factor - Some items may be offset by additional revenue. These are handled on a case-by-case basis. General Fund: Maintenance Efficiency Risk Replacement Totals IMPACTS OF CAPITAL IMPROVEMENT PROJECTS ON OPERATING COST SUMMARY BY FUND Total FY 2016-17 FY 2017-18 FY 2018-19 FY 2019-20 FY 2020-21 FY 2021-22 Impacts - 80,090 228,410 402,420 644,870 925,610 2,281,400 - (124,500) (172,090) (234,090) (275,360) (275,210) (1,081,250) - (166,100) (236,000) (289,020) (305,150) (293,390) (1,289,660) - (118.650) (269.073) (445.561) (640.116) (776.274) (2.249.673) 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. Golf Course Fund: - 34,502 273,923 653,345 1,032,767 1,412,189 - Efficiency - (49,288) (323,173) Maintenance - 8,250 39,884 71,694 103,504 135,314 358,646 Efficiency - (16,500) (44,956) (27,522) (9,122) (10,684) (108,784) Replacement - (11,550) (29,903) (36,651) (41,729) (46,807) (166,640) Revenue (4,950) (4,950) (5,038) (5,038) (5,038) (25,014) Totals - (24,750) (39,925) 2,484 47,615 72,784 58,208 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. Airport Fund: Maintenance - 34,502 273,923 653,345 1,032,767 1,412,189 - Efficiency - (49,288) (323,173) (386,318) (189,178) (118,135) - Risk - (3,000) (2,100) (1,200) (300) - Replacement - (7,400) (8,760) (10,120) (11,480) - Totals - (14,786) (59,649) 256,168 832,269 1,282,273 2,296,274 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. I-WYRi U3 Maintenance - 122,842 542,218 1,127,459 1,781,141 2,473,112 6,046,772 Efficiency - (141,000) (217,046) (261,612) (284,482) (285,894) (1,190,034) Risk - (166,100) (239,000) (291,120) (306,350) (293,690) (1,296,260) Replacement - (130,200) (306,375) (490,971) (691,965) (834,562) (2,454,073) Revenue (4,950) (4,950) (5,038) (5,038) (5,038) (25,014) Totals (3i?�409) (22 i33f-7B�iB X33 �G-Tb , 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 16-17 FY 17-18 FY 18-19 FV 19-20 FY 20.21 —60—Current Cost With CIP impact Airport Fund Capital Improvements Operating Costs Impact 360,000 340,000 320,000 300,000 FY 16-17 FY 17-18 FY 16-19 FY 19-20 FY 20-21 1,400,000 1,300,000 1,200,000 1,100,000 1,000,000 900,000 800,000 FY 16-17 FY 17-18 FY 18-19 FY 19-20 FY 20-21 mo—Current Cost —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 16-17 FY 17-18 FY 18-19 FY 19-20 FY 20-21 Current Cost —With CIP Impact IMPACTS OF CAPITAL IMPROVEMENT PROJECTS ON OPERATING COST CALCULATIONS BY PROJECT List of Protects General Government Audio Visual Equipment Maintenance Efficiency Replacement Total Computer Replacements Maintenance Efficiency Replacement Total Computer Upgrades Maintenance Efficiency Replacement Total MIS Servers Maintenance Efficiency Replacement Total Police Department Police Operations Equipment Maintenance Efficiency Risk Replacement Total Police Detective Equipment Maintenance Efficiency Risk Total Police Vehicles & Equipment Maintenance Efficiency Risk Replacement Total Roads and Special Projects Public Works Roads Equipment Maintenance Efficiency Risk Replacement Total Sign Replacement Maintenance Risk Replacement Total Street Reconstruction Maintenance Risk Total Street Repaving Maintenance Risk Total Life Capital Years IY 2016.17 IY 2017-18 FY 2018-19 FY 2019.20 FY 2020.21 FY 2021-22 Totals 5 $ 50,000 $ 30,000 $ - $ - $ - $ - 80,000 - 3,500 9,100 14,700 20,300 25,900 - (5,000) (6,000) (2,800) 400 2,600 - (2,500) (4,500) (5,300) (6,100) (6,900) - (4,000) (1,400) 6,600 14,600 21,600 5 - - 180,000 - - - 180,000 - - - 12,600 25,200 37,800 - - - (18,000) (10,800) (3,600) - - - (9,000) (10,800) (12,600) - - - (14,400) 3,600 21,600 5 50,000 35,000 35,000 35,000 35,000 35,000 225,000 - 3,500 9,450 17,850 28,700 42,000 - (5,000) (6,500) (6,600) (7,300) (9,000) - (2,500) (4,750) (7,350) (10,300) (13,600) - (4,000) (1,800) 3,900 11,100 19,400 5 40,000 - - - - - 40,000 - 2,800 5,600 8,400 11,200 14,000 - (4,000) (2,400) (800) (800) (1,600) - (2,000) (2,400) (2,800) (3,200) (3,600) - (3,200) 800 4,800 7,200 8,800 5 15,000 15,000 6,000 - - - 36,000 - 1,050 3,150 5,670 8,190 10,710 - (1,500) (2,400) (1,800) (960) (420) - (1,500) (2,400) (1,800) (660) (120) - - (53) (221) (546) (1,054) - (1,950) (1,703) 1,850 6,024 9,116 30+ 6,000 5,000 - - - - 11,000 • 60 170 280 390 500 - (600) (1,100) (1,040) (990) (930) - (600) (1,100) (1,040) (990) (30) - (1,140) (2,030) (1,800) (1,590) (460) 7 380,000 264,000 270,000 430,000 300,000 300,000 1,944,000 - 19,000 51,200 96,900 164,1 DO 246,300 - (38,000) (53,000) (60,680) (76,260) (81,140) - (38,000) (53,000) (60,680) (68,660) (73,540) - (26,600) (48,880) (74,220) (113,460) (147,900) - (83,600) (103,680) (98,680) (94,280) (56,280) 20 95,000 180,000 170,000 185,000 80,000 115,000 825,000 - 1,900 7,400 16,300 28,900 43,100 - (9,500) (26,550) (40,800) (54,850) (56,550) - (9,500) (26,550) (40,800) (54,850) (56,550) - (19,000) (55,950) (92,700) (134,150) (156,450) - (36,100) (101,650) (158,000) (214,950) (226,450) 7 30,000 30,000 30,000 30,000 30,000 30,000 180,000 - 1,500 4,500 9,000 15,000 22,500 - (3,000) (5,100) (6,300) (6,600) (6,600) - (2,100) (4,500) (7,200) (10,200) (13,500) - (3,600) (5,100) (4,500) (1,800) 2,400 150,000 50,000 - - - - 200,000 - 4,500 10,500 16,500 22,500 28,500 - (15,000) (17,000) (13,000) (9,000) (5,000) - (10,500) (6,500) 3,500 13,500 23,500 10 750,000 350,000 450,000 250,000 250,000 250,000 2,300,000 - 22,500 55,500 102,000 156,000 217,500 - (75,000) (95,000) (118,000) (112,000) (101,000) - (52,500) (39,500) (16,000) 44,000 116,500 IMPACTS OF CAPITAL IMPROVEMENT PROJECTS ON OPERATING COST CALCULATIONS BY PROJECT (CONTINUED) Life Capital List of Projects Years FY 2016.17 FY 2017.18 FY 2018-19 FY 2019-20 FY 2020.21 FY 2021-22 Totals Roads and Special Projects (Continued) Sidewalk Construction 10 40,000 40,000 40,000 40,000 40,000 40,000 240,000 Maintenance - 1,200 3,600 7,200 12,000 18,000 Risk (4,000) (7,200) (9,600) (11,200) (12,000) Total - (2,800) (3,600) (2,400) 800 6,000 Road Striping 7 20,000 20,000 20,000 20,000 20,000 20,000 120,000 Maintenance - 1,000 3,000 6,000 10,000 15,000 Risk - (2,000) (3,400) (4,200) (4,400) (4,400) Total - (1,000) (400) 11800 5,600 10,600 Working Waterfront Phase 3. 30+ 400,000 - - - - - 400,000 Maintenance - 4,000 8,000 12,000 16,000 20,000 Total 4,000 8,000 12,000 16,000 20,000 Stormwater Stonnwaler Equipment 20 10,000 10,000 106,000 55,000 10,000 45,000 236,000 Maintenance - 200 600 3,120 6,740 10,560 Efficiency - (1,000) (1,900) (12,300) (16,540) (15,730) Risk - (1,000) (1,900) (12,300) (16,540) (15,730) Replacement - (2,000) (4,100) (25,500) (37,760) (41,570) Total - (3,800) (7,300) (46,980) (64,100) (62,470) Road Crossing/Sideyard Pipes 30+ 100,000 90,000 80,000 70,000 60,000 50,000 450,000 Maintenance - 1,000 20,900 5,600 9,000 13,000 Replacement - (30,000) (58,000) (83,900) (107,600) (129,000) Total - (29,000) (37,100) (78,300) (98,600) (116,000) Tulip Drive Road Crossing 30+ - 50,000 - - - - 50,000 Maintenance - - 500 1,000 1,500 2,000 Replacement - - (15,000) (15,500) (16,000) (16,500) Total - - (14,500) (14,500) (14,500) (14,500) Tractor 20 - - - 165,000 - - 165,000 Maintenance - - - - 3,300 6,600 Efficiency - - - - (16,500) (14,850) Replacement - - - - (33,000) (34,650) Total - - - - (46,200) (42,900) Track Excavator 20 - - - - 145,000 - 145,000 Maintenance - - - - 2,900 Efficiency - - - - (14,500) Replacement - - - - - (29,000) Total - - - - - (40,600) Pipe Sliplining 20 140,000 - - - - 140,000 Maintenance - 2,800 5,600 8,400 11,200 14,000 Efficiency - (14,000) (12,600) (11,200) (9,800) (8,400) Risk - (14,000) (12,600) (11,200) (9,800) (8,400) Total - (25,200) (19,600) (14,000) (8,400) (2,800) Dump Trucks 20 150,000 160,000 - 125,000 - - 435,000 Maintenance - 3,000 9,200 15,400 24,100 32,800 Efficiency - (15,000) (29,500) (26,400) (35,800) (31,450) Replacement - (30,000) (63,500) (66,600) (94,700) (99,050) Total - (42,000) (83,800) (77,600) (106,400) (97,700) Transport Truck/Trailer 20 - - 215,000 - - - 215,000 Maintenance - - - 4,300 8,600 12,900 Efficiency - - (21,500) (19,350) (17,200) Replacement - - - (43,000) (45,150) (47,300) Total - - - (60,200) (55,900) (51,600) IMPACTS OF CAPITAL IMPROVEMENT PROJECTS ON OPERATING COST CALCULATIONS BY PROJECT List of Prolects Parks Public Works Parks Equipment Maintenance Risk Replacement Total Riverview Park Fencing Maintenance Risk Replacement Total Friendship Park Improvements Maintenance Efficiency Total Cemetery Columbariums Maintenance Efficiency Total City Hall Parking Lot Normal Maintenance Fleet Management Public Works Fleet Equipment Maintenance Efficiency Replacement Total Golf Course Golf Cart Fleet Maintenance Efficiency Replacement Total Golf Course Small Equipment Maintenance Efficiency Replacement Revenue Total Rebuild Greens Maintenance Efficiency Replacement Revenue Total Airport Airport Vehicle Maintenance Efficiency Risk Replacement Total Life Capital Years FY 2016.17 FY 2017-18 FY 2018.19 FY 2019-20 FY 2020-21 FY 2021-22 Totals 5 - 85,000 30,000 52,000 48,000 - 215,000 - - 5,950 14,000 25,690 40,740 - - (8,500) (8,100) (8,700) (8,520) • - (4,250) (6,600) (10,350) (14,420) - - (6,800) (700) 6,640 17,800 10 25,000 - - - - - 25,000 - 750 1,500 2,250 3,000 3,750 - (2,500) (2,250) (2,000) (1,750) (1,500) - (1,750) (2,000) (2,250) (2,500) (3,500) - (3,500) (2,750) (2,000) (1,250) (1,250) 30+ 250,000 - - - - - 250,000 - 5,000 10,000 15,000 20,000 25,000 - (25,000) (22,500) (20,000) (17,500) (15,000) - (20,000) (12,500) (5,000) 2,500 10,000 30+ 55,000 - - - - 55,000 - 550 1,100 1,650 2,200 2,750 - (5,500) (5,500) (4,950) (4,950) (4,400) - (4,950) (4,400) (3,300) (2,750) (1,650) NIA - 50,000 - - - - 50,000 5 4,000 19,000 40,000 5,000 14,000 - 82,000 - 280 1,890 6,300 11,060 16,800 - (400) (2,140) (5,220) (3,360) (3,040) - (200) (1,190) (3,420) (4,300) (5,680) - (320) (1,440) (2,340) 3,400 8,080 5 - 334,059 - - - - 334,059 - - 23,384 46,768 70,152 93,537 - - (33,406) (20,044) (6,681) (6,681) - - (16,703) (20,044) (23,384) (26,725) - - (26,725) 6,681 40,087 60,131 20 - - 8,785 - - - 8,785 - - - 176 351 527 - - - (879) (791) (703) - - - (1,757) (1,845) (1,933) - - - (88) (88) (88) - - - (2,548) (2,372) (2,196) 7 165,000 - - - - - 165,000 - 8,250 16,500 24,750 33,000 41,250 - (16,500) (11,550) (6,600) (1,650) (3,300) - (11,550) (13,200) (14,850) (16,500) (18,150) - (4,950) (4,950) (4,950) (4,950) (4,950) - (24,750) (13,200) (1,650) 9,900 14,850 7 - 30,000 - - - - 30,000 - - 1,500 3,000 4,500 6,000 - - (3,000) (2,100) (1,200) (300) - - (3,000) (2,100) (1,200) (300) - - (2,100) (2,400) (2,700) (3,000) - - (6,600) (3,600) (600) 2,400 IMPACTS OF CAPITAL IMPROVEMENT PROJECTS ON OPERATING COST SUMMARY BY FUND List of Projects Airport (Continued) Weather Observation System Maintenance Efficiency Replacement Total Airport Master Plan Design Maintenance Efficiency Total Airport Taxiway C,D,E Maintenance Efficiency Total Construct Access Road West Maintenance Efficiency Total Airport Shade Hangars Maintenance Efficiency Total Life Capital Years FY 2016.17 FY 2017.18 FY 2018.19 FY 2019-20 FY 2020.21 FY 2021-22 Totals 7 - 106,000 - - - - 106,000 - - 7,420 14,840 22,260 29,680 - - (10,600) (6,360) (2,120) (2,120) - - (5,300) (6,360) (7,420) (8,480) - - (8,480) 2,120 12,720 19,080 30+ 216,000 - - - - - 216,000 - 15,120 30,240 45,360 60,480 75,600 - (21,600) (12,960) (4,320) (4,320) (6,640) - (6,480) 17,280 41,040 56,160 66,960 30+ 276,882 1,600,000 2,000,000 - - 3,876,682 - 19,382 150,763 422,145 693,527 964,909 - (27,688) (176,613) (301,538) (157,538) (83,075) - (8,306) (25,849) 120,608 535,989 881,833 30+ - 800,000 - - - - 800,000 - - 56,000 112,000 168,000 224,000 - - (80,000) (48,000) (16,000) (16,000) - - (24,000) 64,000 152,000 208,000 30+ - 400,000 - - - - 400,000 - - 28,000 56,000 84,000 112,000 - - (40,000) (24,000) (8,000) (8,000) - - (12,000) 32,000 76,000 104,000 Totals - (368,696) (548,327) (307,599) 304,128 935,794 15,230,726 LOCAL OPTION GAS TAX FUND PROJECTED BALANCES FISCAL YEARS 2017-2022 FY 14.15 FY 15.16 FY 16.17 FY 17-18 FY 18.19 FY 19.20 FY 2041 FY 21.22 Local Option Gas Taxes $ 633,096 $ 640,000 $ 665,600 $ 692,224 $ 719,913 $ 748,709 $ 778,658 $ 809,804 FDOT Lighting Agreement 10,050 10,352 12,532 12,532 12,532 12,532 12,532 12,532 Transfer from General Fund (AAF+Streets) 207,000 200,000 200,000 200,000 200,000 200,000 200,000 200,000 Investment Income 239 84 97 64 103 129 129 194 Total Revenues $ 850,385 $ 850,436 $ 878,229 $ 904,820 $ 932,548 $ 961,371 $ 991,319 $ 1,022,530 Debt Payment- Final FY22-23 $ 242,783 $ 242,748 $ 242,635 $ 242,445 $ 243,177 $ 243,802 $ 243,340 $ 242,801 Street Lights 176,795 180,000 - - - - - - R/RCrossing Maintenance 5,103 5,103 5,103 5,103 5,103 5,103 5,103 5,103 All Aboard Florida 586 99,414 - - - - - - Sidewalk Repairs - - - - - - - Road Striping 2,472 10,000 20,000 20,000 20,000 20,000 20,000 20,000 Indian River Drive Light Poles 5,000 5,000 - - - - - - Sign Replacement 30,377 30,000 30,000 30,000 30,000 30,000 30,000 30,000 Street Repaving TOTAL Street Repaving for FY15 + Main Street 136,742 246,678 TOTAL $ 599,858 Sidewalk Construction 50,000 Repaving (Bevan, Concha, Melrose, Benedictine, Schumann) 126,000 TOTAL $ 994,943 Sidewalk Construction 40,000 Catch-up Street Repaving 750,000 300,000 TOTAL $ 1,087,738 Sidewalk Construction 40.000 Street Repaving 50.000 TOTAL $ 687,548 Sidewalk Construction 40,000 Street Repaving 250,000 Repaving Indian River Drive 200,000 TOTAL $ 788,280 Sidewalk Construction 40,000 Street Repaving 250,000 TOTAL $ 588,905 Sidewalk Construction 40,000 Street Repaving 250,000 TOTAL $ 588,443 Sidewalk Construction - 40,000 Street Repaving 250,000 TOTAL $ 587,904 BEGINNING FUND BALANCE $ 156,668 $ 407,195 $ 262,688 $ 53,180 $ 270,452 414,720 787,185 1,190,061 BUDGET RESERVE -15%OF EXPENSES 53,561 112.829 126,765 66,765 81,765 51,765 51,765 51,765 UNRESTRICTED RESERVE BALANCE $ 103,107 $ 294,366 $ 135,923 $ (13,586) S 188,686 $ 362,954 $ 735,420 $ 1,138,296 TOTAL REVENUES 850,385 850,436 878,229 904,820 932,548 961,371 991,319 1,022,530 TOTAL EXPENDITURES+TRANSFERS 599,858 994,943 1,087,738 687,548 788,280 588,905 588,443 587,904 ENDING FUND BALANCE $ 353,634 $ 149,859 $ (73,586) $ 203,686 $ 332,954 $ 735,420 $ 1,138,296 $ 1,572,921 DST Revenue Principal from $285,000 Airport Advance 09/29/08 Interest from $285,000 Airport Advance Principal from $267,511 Airport Advance 01/05/11 Interest from $267,511 Airport Advance Investment Income DST PROJECT REVENUE City Hall Debt (Retires 2018) Stormwater Debt (Retires 5/01122) Computer Replacement and Annual Upgrades MIS Servers Audio Visual Equipment Police Vehicles and Equipment Diesel Fuel Tank and Software 1/4 Round Swale Improvement Presidential Streets Fish House Improvements Construct Hangars Airport Drive East Tulip Drive Pedestrian Bridge Goff Course Fuel Tank TOTAL FY 14 Roof Repairs (City Hall and PD) Painting City Hall Police - Public Parking City Hall Parking Lot Boat Lift Veteran's Memorial Fleming Engler Paving Tulip Drive Road Crossing Vac Truck SW -618 Patch Truck Diesel Tractor Goff Course Improvements Coolidge Drive TOTAL FY 15 Police Evidence Garage/Cameras Dispatch Consoles Upgrade Public Works Compound Equipment Shelters Working Waterfront Drainage Working Waterfront Phase 2A Enhancements Working Waterfront Drainage Phase 3 Shoreline Excavator (Grant matching) Replace Schumann Sidewalk Street Reconstruction (Barber) Runway Markings Automated Weather Observation System Electrical Boring for Sw p Pond Two Airport Gates Service Pathway Chipper TOTAL FY 18 Street Reconstruction (Vocals and Damask) Backhoe U.S.#1 Medians Airport Master Plan Design Taxiway'C",'D" and'E" TOTAL FY 17 15-17 Yard Dump Truck Airport Shade Hangars Taxiway *D' and 'E* Construct Access Road West TOTAL FY 18 Brush Truck - Gas UtilityTruck Taxiway *C' (West and East) TOTAL FY 19 3 Yard Loader TOTAL FY 20 Skid Steer Trac Mower TOTAL FY 21 UGIityTruck Diesel Tractor TOTAL FY 22 BEGINNING FUND BALANCE BUDGET RESERVE -10% OF EXPENSES RESERVE FOR ADVANCES UNRESTRICTED RESERVE BALANCE TOTAL REVENUES TOTAL EXPENDITURES+DEBT+TRANSFERS ENDING FUND BALANCE Cash on Hand Advances to Other Funds - Balanca After FY 2122: DISCRETIONARY SALES TAX FUND (DST) PROJECTED BALANCES FISCAL YEARS 2017-2022 FY 1415 FY 15-16 FY 16.17 FY 17.18 FY 18.19 FY 19.20 FY 20-21 FY 21-22 $ 2,916,092 $ 2,931,500 $ 3,004,788 $ 3,079,907 $ 789,226 $ - $ - $ - 624 649 675 702 6,730 6.999 7,279 7,570 11,376 11,351 11,325 11,298 11,270 11,001 10,721 10,721 0 0 1,800 1,872 1,946 2,024 2,105 2,105 8,025 8,025 10,700 10,628 10,554 10,476 10,395 10,311 9,839 3,328 2,918 1,387 2,358 2,748 2,230 1,391 $ 2,945,956 $ 2,954,853 $ 3,032,206 $ 3,105,794 $ 822,084 $ 33,248 $ 32,730 $ 32,098 1,027,126 867,112 352,927 167,550 401,141 402,963 403,792 402,914 401,355 400.961 234,292 34,949 89,981 50,000 35,000 215,000 35,000 35,000 35,000 40,000 50,000 311,876 232,000 380,000 264,000 270,000 430,000 300,000 300,000 29,117 25,000 260,494 76,474 904 215,596 127,671 13,056 307,294 116,689 566,975 20,000 172,540 50 - 5,795 52,787 70,595 - 50,000 - 51,938 50,000 7,976 10,277 322,346 19,968 - 50,000 361,587 156,125 55,000 141 599,859 480,112 $ 3,528,171 325,000 60,000 60,000 93,778 88,551 200,000 25,280 23,828 - 478,119 7,307 - 21,200 4,000 12,000 15,000 62,000 -f-5,034,793 150,000 50,000 95,000 30,000 100.000 100,000 100,000 10,800 13.110 $ 1,774,800 150,000 80,000 80,000 160,000 $ 1,443,992 90,000 40,000 100,000 $ 1,117,914 185,000 $ 1,151,355 80,000 $ 815,961 50,000 65,000 s7 684,292 $ 2,995,792 $ 2,413,577 $ 333,637 $ 1,591,043 $ 3.252,846 $ 2,957,016 $ 1,838,909 $ 1,055,678 352,817 503,479 177,480 144,399 111,791 115,136 81,596 68,429 528.798 528,149 525,674 523,100 514,424 505,401 496,017 486,342 $ 2,114,177 $ 1,381,949 $ (369,517) $ 923,544 $ 2,626,630 $ 2,336,480 $ 1,261,296 $ 600,907 2,945,956 2,954,853 3,032,206 3,105,794 822,084 33,248 32,730 32,098 Principal from$285,000 Airport Advance 09/29/08 $ 253,172 Principal from $267,511 Airport Advance 01/05/11 233,170 4 Tax Increment from City Tax Increment from County Rants Investment Income PROJECTED REVENUE Gateway Enhancements CAVCOR Landscaping vs. Shoreline Stabilization Waterfront Renovation4Expenses (Crabby Bills) Fapadel5ign Improvement Program Sewer Connection Program (Reduced by Master Plan) Update CRA Master Plan Special Events Operating Expenditures Settlement with Fishermari s Landing Ice Machine/Walkin Cooler for Crab E. Bills Veteran's Memorial Picnic Tables and Benches for Riverview Park Speed Bumps on Indian River Drive CavCorp Enhancements Landscaping on US#1 (Grant Match) Transfer to General Fund for Quality Maintenance TOTAL RIVERFRONT CRA FY15 Janitorial Services Contract Landscaping Maintenance Contract TOTAL RIVERFRONT CRA FY16 TOTAL RIVERFRONT CRA FY17 TOTAL RIVERFRONT CRA FY18 TOTAL RIVERFRONT CRA FY19 TOTAL RIVERFRONT CRA FY20 TOTAL RIVERFRONT CRA FY21 TOTAL RIVERFRONT CRA FY22 BEGINNING FUND BALANCE ANNUALREVENUES ANNUAL EXPENDITURES ENDING FUND BALANCE Detail on Ooeratino Expenditures: Indian River County Tax Assessor City of Sebastian Administration Street Lighting Water/Sewer Submerged Land Lease Legal Advertisements CRA Association Ad Valorem Taxes Tree Inventory Total Operating Expenditures RIVERFRONT CRA FUND PROJECTED BALANCES FISCAL YEARS 2017-2022 FY 14-15 FY 15-16 FY 16-17 FY 17-18 FY 18-19 FY 19-20 FY 20-21 FY 21-22 $ 158,885 $ 181,150 5 183,747 $ 189,259 $ 194,937 $ 200,785 $ 200.785 $ 200,785 137,535 157,874 162,610 167,489 172,513 177,689 177,689 177,689 36,000 36,000 36,000 36,000 36,000 36.000 36,000 36,000 1,890 3,140 1,322 1,430 2,715 4,084 5,548 7,022 $ 334,310 $ 378,164 If 383,680 $ 394,178 $ 406,166 $ 418,558 $ 420,022 $ 421,496 13,451 900 20,750 17,415 24,000 2000 24,000 2000 24,000 24,000 24,000 29.218 58,922 40,000 40,000 40.000 40,000 40,000 40,000 500 55.000 194,500 100,000 100,000 100,000 100,000 100,000 36,000 36.000 36.000 36,000 36.000 27,087 27,087 27,087 27,087 27,087 $ 227,087 $ 227,087 $ 227,087 $ 227,087 $ 227,087 $ 380.054 $ 446,728 $ 210,890 $ 222,983 $ 390.073 $ 569,152 S 760,623 $ 953,558 334,310 378,164 383,680 394,178 406,166 418,558 420,022 421,496 267,636 614,002 371,587 227,087 227,087 227,087 227,087 227,087 $ 446,728 $ 210,880 $ 222,983 $ 390,073 $ 569,152 $ 760,623 $ 953,558 $ 1,147,968 $ 5,000 $ 5,000 $ 50.000 37,452 36,000 36.000 44.370 43,865 27,087 18.000 13,202 13,202 26.096 13,202 13,202 5,919 11,209 16,000 8,471 - - - 3,875 - 3,075 188,907 - 2,769 14,155 - 60.000 21,667 4,710 $ 267,636 4,710 4,710 4,710 6,244 4,710 4,710 131,408 - $ 614,002 1,500 1,500 $ 371,587 36,000 36.000 36.000 36,000 36.000 27,087 27,087 27,087 27,087 27,087 $ 227,087 $ 227,087 $ 227,087 $ 227,087 $ 227,087 $ 380.054 $ 446,728 $ 210,890 $ 222,983 $ 390.073 $ 569,152 S 760,623 $ 953,558 334,310 378,164 383,680 394,178 406,166 418,558 420,022 421,496 267,636 614,002 371,587 227,087 227,087 227,087 227,087 227,087 $ 446,728 $ 210,880 $ 222,983 $ 390,073 $ 569,152 $ 760,623 $ 953,558 $ 1,147,968 $ 5,000 $ 5,000 $ 5,000 $ 5,000 $ 5,000 $ 5,000 $ 5,000 $ 5,000 13,202 13,202 13,202 13,202 13,202 13,202 13,202 13,202 15,944 16,000 - - - - - - 1,231 1,200 - - - - - - 4,710 4,710 4,710 4,710 4,710 4,710 4,710 4,710 1.540 1,295 1,600 1,500 1,500 1,500 1,500 1.500 175 175 175 175 175 175 175 175 2,568 2,033 2,500 2,500 2,500 2,500 2,500 2,500 - 250 - - - - - - $ 44,370 $ 43,865 $ 27,087 $ 27,087 $ 27,087 $ 27,087 $ 27,087 $ 27,087 Payments in Lieu of Parking Investment Income PROJECTED REVENUE Expenditures: Parking on Indian River Drive PROJECTED DISBURSEMENTS NONEXPENDABLE TRUST FUND: BEGINNING FUND BALANCE REVENUES EXPENDITURES ENDING FUND BALANCE PARKING IN LIEU OF FUND PROJECTED BALANCES FISCAL YEARS 2017-2022 FY 14-15 FY 15-16 FY 16-17 FY 17-18 FY 18-19 FY 19-20 FY 20-21 FY 21-22 $ 19,730 $ 19,730 $ 19,730 $ 19,730 $ 19,730 $ 19,730 $ 19,730 $ 19,730 284 419 107 285 465 647 830 1,015 20,014 20,149 19,837 20,015 20,195 20,377 20,560 20,745 2,800 54,858 - - - - 2,800 54,858 - - - $ 29,335 $ 46,549 $ 11,840 $ 31,677 $ 51,692 $ 71,887 $ 92,264 $ 112,824 20,014 20,149 19,837 20,015 20,195 20,377 20,560 20,745 2,800 54,858 0 0 0 0 0 0 $ 46,549 $ 11,840 $ 31,677 $ 51,692 $ 71,887 $ 92,264 $ 112,824 $ 133,570 Recreation Impact Fees Pelican Isles Escrow Release Investment Income PROJECTED REVENUE Riverview Park Irrigation and Fountains Bark Park Amenities Blueway/Signage Improvements Bleacher Shields Community Center Playground Handicap Pier - Yacht Club Mooring Fields Creative Playground Improvements Riverview Park Volleyball Lights Schumann Playground Equipment Barber Street Multi -use Field Lights Art and Senior Center Signs TOTAL FY 13 Community Center Needs Analysis Batting Cage/Dugouts Disc Golf Course Tennis Wall/Raquet Ball Court TOTAL FY 14 Equipment Building Community Center (Paving/Drainage/Lighting Rebuild Skate Park Ramps Barber Street Netting TOTAL FY 15 TOTAL FY 16 RECREATION IMPACT FEE FUNDS PROJECTED BALANCES FISCAL YEARS 2017-2022 FY 14-15 FY 15-16 FY 16.17 FY 17-18 FY 18.19 FY 19.20 FY 20-21 FY 21-22 $ 135,200 $ 135,200 $ 135,200 $ 135,200 $ 135,200 $ 135,200 S 135,200 S 135,200 146,250 - - - - - - - 1,976 1,830 2,084 1,763 2,083 2,403 2,403 2,724 283,426 137,030 137,284 $ 136,963 $ 137,283 137,603 137,603 137,924 4,372 8,200 3,013 16,584 $ 100 52,000 94,274 11,875 $ 109,959 $ 80,459 Riverview Park Fence 25,000 Friendship Park Improvements (Pickle Ball) 250,000 TOTAL FY 17 $ 275,000 - TOTAL FY 18 $ - TOTAL FY 19 $ - - TOTAL FY 20 $ - - TOTAL FY 21 $ - $ - BEGINNING FUND BALANCE $ 595,672 $ 769,139 $ 825,710 $ 687,994 $ 824,957 $ 962,240 $ 962,240 $ 1,099,843 TOTAL REVENUES 283,426 137,030. 137,284 136,963 137,283 137,603 137,603 137,924 TOTAL EXPENDITURES 109,959 80,459 275,000 0 0 0 0 0 ENDING FUND BALANCE $ 769,139 $ 825,710 $ 687,994 $ 824,957 $ 962,240 $ 1,099,843 $ 1,099,843 $ 1,237,767 STORMWATER UTILITY FUND PROJECTED BALANCES FISCAL YEARS 2017-2022 FY 14-15 FY 15-16 FY 16-17 FY 17.18 FY 18.19 FY 19-20 FY 20-21 FY 21-22 Stormwater Fees $ 987,440 $ 993,000 $ 993,000 $ 993,000 $ 993,000 $ 993,000 $ 993,000 $ 993,000 Transfer from General Fund 100,000 100,000 100.000 100,000 100.000 100,000 100,000 100,000 Investment Income 1,196 3,200 3,875 3,561 3.903 3,583 3.190 3,795 SW PROJECTED REVENUE $ 1,088,636 $ 1,096,200 $ 1,096,875 $ 1,096,561 $ 1,096,903 $ 1,096,583 $ 1,096,190 $ 1,096,795 Professional Services 146 Debt Service 234,187 Lagoon Improvements 100,000 Ditch Maintenance 131,317 37,100 Stomnvater Park Maintenance 11,751 SW -603 Pickup 27,925 SW -600 Pickup 27,925 Tmmfer to General Fund for Swale Maintenance 500,000 TOTAL STORMWATER FY15 $ 1,033,251 Lagoon Improvements (25K Oyster Mats, 113rd Interlocal) 100,000 Stonnwater Park Maintenance 10,000 Road CrossingsrSideyard Pipes 55,000 SW -6164X4 Pickup 30,909 4X4 HerbUBlity, Vehicle 13,726 Pumps/Baffle Box Maintenance 10,000 Armadillo 162,90D SW -628 Tandum Dump Truck - 150,000 Pipe Sliplining - 140.000 Transfer to General Fund for Swale Maintenance 550,000 TOTAL STORMWATER FY16 $ 969,635 Lagoon Improvements (25K Oyster Mats, 1/3rd Interlocal) 100,000 Stormwater Park Maintenance 10,000 Road Crossings/Sideyard Pipes 100,000 SW -6092000 Transport Truck - - 145,000 SW -615 2001 Dump Tnxk 160,000 SW -6061 Ton Crew Cab Pickup - - 48,000 SW -6144X4 Pickup - - - 30,000 PumpslBaffle Box Replacement 10,000 Transfer to Gerxnal Fund for Swale Maintenance 650,000 TOTAL STORMWATER FY17 $ 1,160,000 NPDES 5 Year Permit 7,988 Lagoon Improvements (25K Oyster Mats, 1I3rd Interlocal) 100,000 Stonnwater Park Maintenance 10,000 Road Crossings/Sideyard Pipes 90,000 SW -6102002 Interstate Trailer - 70,000 Tractor SW -688 - - 165,000 Pumps/Baffle Bax Replacement 10,000 Transfer to General Fund for Swale Maintenance 650,000 TOTAL STORMWATER FY18 $ 1.027,988 Lagoon Improvements 125K Oyster Mats, 1(drd Interlocal) 1001000 Slonnwater Park Maintenance 10,000 Road Crossings/Sideyard Pipes 80,000 Pumps/Baffle Bax Replacement 10,000 Transfer to General Fund for Swale Maintenance 650,000 Excavator Buckets/Mowing Heads 48,000 TOTAL STORMWATER FY19 $ 1,161,000 Lagoon Improvements (25K Oyster Mats, 113rd Interlocal) 100,000 Slonnwater Park Maintenance 10,000 SW -607 Byd Dump Truck 125,000 Water Tank and Trailer 15,000 Road Crossings/Sideyard Pipes 70,000 Pumps/Baffle Box Replacement 10,000 Transfer to General Fund for Swale Maintenance 650,000 TOTAL STORMWATER FY20 $ 1,175,000 Lagoon Improvements (25K Oyster Mats. 1133rd Interlocal) 100,000 Stomiwater Park Maintenance 10,000 Track Excavator 2011 CAT 3D8 145,000 Read Crossings/Sideyard Pipes 60,000 Pumps/Baffle Box Replacement 10,000 Transfer to General Fund for Swale Maintenance 650,000 TOTAL STORMWATER FY21 $ 975,000 Lagoon Improvements (25K Oyster Mats, 1/3rd Intedocal) 100,000 Stonnwater Park Maintenance 10,000 Pickup Truck Replacement 35.000 Road Crossings/Sideyaro Pipes 50.000 Pumps/Baffle Box Replacement 10,000 Transfer to General Fund for Swale Maintenance 650,000 TOTAL STORMWATER FY22 $ 855,000 BEGINNING FUND BALANCE $ 44,915 $ 100,300 $ 226,865 $ 163,740 $ 232,313 $ 168,216 $ 89,799 $ 210,990 BUDGET RESERVE -15%OF EXPENSES 154,988 145,445 174.000 154,198 174.150 176,250 146,250 128.250 UNRESTRICTED RESERVE BALANCE $ (110,072) $ (45,145) $ 52,865 $ 9,542 $ 58,163 $ (8,034) $ (56,451) $ 82,740 ANNUAL REVENUES 1,088,636 1,096,200 1,096,875 1,096,561 1,096,903 1,096,583 1,096,190 1,096,795 ANNUAL EXPENDITURES 1,033,251 969,635 1,160.000 1,027,988 1,161,000 1,175.000 975,000 855.000 ENDING FUND BALANCE $ (54,687) $ 81.420 $ (10,260) $ 78,115 $ (5,934) $ (86,451) $ 64,740 $ 324,535 EXPENDABLETRUSTFUND BEGINNING FUND BALANCE $ 27,953 $ 73,995 CEMETERY TRUST FUND $ 102,634 $ 147,596 $ 192,760 $ 238,128 $ 283,699 ANNUALREVENUES 46,042 PROJECTED BALANCES 45,007 44,962 45,164 45,367 45,572 45,777 ANNUAL EXPENDITURES FISCAL YEARS 2017-2022 6,200 55,000 FY 14-15 FY 15-16 FY 16-17 FY 17-18 FY 18-19 FY 19-20 FY 20-21 FY 21.22 Lot Sales $ 89,000 $ 89,000 $ 89,000 $ 89,000 $ 89,000 $ 89,000 $ 89,000 $ 89,000 Refunds Equipment Sales $ 1,418 Nonexpendable Trust Fund Interest 3,569 3,846 4,058 4,266 4,469 4,671 4,873 5,075 Expendable Trust Fund Interest 124 333 507 462 664 867 1,072 1,277 PROJECTED REVENUE 94,111 93,179 93,565 93,728 94,133 94,538 94,944 95,351 Expenditures from Expendable Trust Fund: Redo South Paved Roadway - - - - - - - 100,000 Columbadums - 6,200 55,000 - - - - - Nonexpendable Interest General Fund Transfer 3,012 1,398 2,171 3,846 4,058 4,266 4,469 4,671 PROJECTED DISBURSEMENTS 3,012 7,598 57,171 3,846 4,058 4,266 4,469 104,671 NONEXPENDABLE TRUST FUND: BEGINNING FUND BALANCE $ 809,707 $ 854,764 $ 901,712 $ 948,099 $ 993,019 $ 1,037,930 $ 1,082,834 $ 1,127,738 ANNUAL REVENUES 48,069 48,346 48,558 48,766 48,969 49,171 49,373 49,575 ANNUALTRANSFERS 3,012 1,398 2,171 3,846 4,058 4,266 4,469 4,671 ENDING FUND BALANCE $ 854,764 $ 901,712 $ 948,099 $ 993,019 $ 1,037,930 $ 1,082,834 $ 1,127,738 $ 1,172,642 EXPENDABLETRUSTFUND BEGINNING FUND BALANCE $ 27,953 $ 73,995 $ 112,627 $ 102,634 $ 147,596 $ 192,760 $ 238,128 $ 283,699 ANNUALREVENUES 46,042 44,833 45,007 44,962 45,164 45,367 45,572 45,777 ANNUAL EXPENDITURES - 6,200 55,000 - 100,000 ENDING FUND BALANCE $ 73,995 $ 112,627 $ 102,634 $ 147,596 $ 192,760 $ 238,128 $ 283,699 $ 229,476 DST Revenue Fund Transfer Bank Note Proceeds Investment Income TOTAL RECEIPTS Bank Charges Principal and Interest at Bond Payoff Principal Requirement - October 1 Principal Requirement - April 1 Interest Requirement - October 1 Interest Requirement - April 1 Other Debt Service Cost TOTAL DISBURSEMENTS DISCRETIONARY SALES TAX BOND SINKING FUND PROJECTED BALANCES FISCAL YEARS 2017-2022 FY 14-15 FY 15-16 FY 16.17 FY 17.18 FY 18.19 FY 19-20 FY 20.21 FY 21-22 $1,027,126 $ 867,112 $ 352,927 $ - $ 822 2,144 1,591 - - - - - $1,027,948 $ 869,256 $ 354,518 $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - 505,000 508,000 353,000 - - 503,000 508,000 353,000 - - - - 11,739 7,405 3,036 - - - - - 9,568 5,220 1,518 - - - - $1,029,307 $1,028,625 $ 710,554 $ - $ - $ - $ - $ - BEGINNING FUND BALANCE $ 516,764 $ 515,405 $ 356,036 $ - $ - $ - $ - $ - TOTAL RECEIPTS 1,027,948 869,256 354,518 - - - - TOTAL DISBURSEMENTS 1,029,307 1,028,625 710,554 ENDING FUND BALANCE $ 515,405 $ 356,036 $ - $ - $ - $ - $ - $ - SINKING FUND REQUIRED BALANCE 515,405 356,036 - - - - - RESERVE FUND REQUIRED BALANCE DIFFERENCES $ - $ - $ - $ - $ - $ - $ - $ - STORMWATER UTILITY REVENUE BOND FUND PROJECTED BALANCES FISCAL YEARS 2017-2022 FY 14-15 FY 15-16 FY 16-17 FY 17-18 FY 18.19 FY 19.20 FY 20-21 FY 21-22 Slonnwater Utility Revenue Fund Transfer 234,187 $ - $ - $ - $ - $ - $ - $ - DSTFundTransfer 167,550 401,141 402,963 403,792 402,914 401,355 400,961 234,292 Investment Income 557 133 112 112 112 112 111 112 TOTAL RECEIPTS $ 402,294 $ 401,274 $ 403,075 $ 403,904 $ 403,026 $ 401,467 $ 401,072 $ 234,403 Principal and Interest at Bond Payoff $ - $ - $ - $ - $ - $ - $ . $ - Principal Requirement - May 1 352,000 355,000 363,000 371,000 377,000 382,000 387,000 395,000 Interest Requirement - November 1 25,794 22,750 19,679 16,539 13,330 10,069 6,764 3,417 Interest Requirement - Mays 25,794 22,750 19,679 16,539 13,330 10,069 6,764 3,417 TOTAL DISBURSEMENTS $ 403,588 $ 400,500 $ 402,358 $ 404,078 $ 403,660 $ 402,138 $ 400,528 $ 401,834 BEGINNING FUND BALANCE $ 168,169 $ 166,875 $ 167,649 $ 168,366 $ 168,192 $ 167,558 $ 166,887 $ 167,431 TOTAL RECEIPTS 402,294 401,274 403,075 403,904 403,026 401.467 401,072 234,403 TOTAL DISBURSEMENTS 403,588 400,500 402,358 404,078 403.660 402.138 400,528 401,834 ENDING FUND BALANCE 166,875 167,649 168,366 168,192 167,558 166.887 167,431 - SINKING FUND REQUIRED BALANCE 166,875 167,649 168,366 168,191.67 167,557.50 166,887 167,431 - DIFFERENCES - (0) (0) 0 - 0 (0) - GOLF COURSE FUND PROJECTED BALANCES FISCAL YEARS 2017-2022 FY 14.15 FY 15-16 FY 16.17 FY 17.18 FY 18.19 FY 19-20 FY 20.21 FY 21-22 Charges for Services $ 1,235,405 $ 1,160,365 $ 1,273,500 $ 1,273,500 $ 1,273,500 $ 1,273,500 $ 1,273,500 $ 1,273,500 Proshop Sales 60,704 57,750 60,000 60,000 60,000 60,000 60,000 60,000 Rents 29,139 29,000 31,000 31,000 31,000 31,000 31,000 31,000 Other Revenue 1,637 3,460 4,460 4,460 4,460 4,460 4,460 4,460 Contributions 6,304 4,566 5,000 5,000 5,000 5,000 5,000 5,000 Sale of Carts or Equipment 224 3,900 - 135,975 - - - 135,975 Bank Note Proceeds - - 299,050 - - - 299,050 Transfer from DST Fund 130 - 5,795 - - - - - - Close out Capital Fund 18,463 Investment Income (66 5) PROJECTED REVENUE $ 1,333,413 $ 1,264,171 $ 1,392,423 $ 1,808,985 $ 1,373,960 $ 1,373,960 $ 1,373,960 $ 1,808,985 Operating Costs $ 1,223,336 $ 1,234,063 $ 1,260,551 $ 1,270,005 $ 1,279,530 $ 1,289,127 $ 1,298,795 $ 1,308,536 Proshop Cost of Sales 35,419 30,000 35,000 35,000 35,000 35,000 35,000 35,000 Transfer to Capital Fund 60,094 58,116 - - - - - - Bank Note Payments - Golf Carts 34,411 57,406 57,406 57,406 57,406 57,406 57,406 57,406 Other Capital/Picker, Washer, Dispense 5,618 8,785 Fuel Tank 5,795 TOTAL FY 15 $ 1,358,878 TOTAL FY 16 $ 1,385,380 Loan Interest Payment to Building Fund 5,527 7,629 7,629 7,629 7,284 6,934 Loan Principal Payment to Building - - 26,394 26,739 27,089 TOTAL FY 17 $ 1,358,484 Golf Cart Purchase 334,059 334,059 TOTAL FY 18 $ 1,712,884 TOTAL FY 19 $ 1,379,565 TOTAL FY 20 $ 1,415,556 TOTAL FY 21 $ 1,425,224 $ 1,769,024 BEGINNING FUND BALANCE $ (47,764) $ (73,229) $ (194,438) $ (160,499) $ (64,398) $ (70,003) $ (70,003) $ (111,599) TOTALREVENUES 1,333,413 1,264,171 1,392,423 1,808,985 1,373,960 1,373,960 1,373,960 1,808,985 EXPENDITURES 1,358,878 1,385,380 1,358,484 1,712,884 1,379,565 1,415,556 1,425,224 1,769,024 OPERATING FUND BALANCE $ (73,229) $ (194,438) $ (160,499) $ (64,398) $ (70,003) $ (111,599) $ (121,267) $ (71,638) BEGINNING FUND BALANCE $ 95,465 $ 140,923 $ 18,463 Transfer from DST Fund $ 141 $ 599,859 Transfer from Operating Fund 60,094 58,116 - Loan from Building Fund 433,472 165,000 Loan Principal Payment to Building Transfer from General Fund R&R Investment Income 948 Course Bathrooms 139 Irrigation System - DST & Building 141 Cart Path Repairs 14,700 Added Cart Path Work - Building Loan $ (264,935) Trash Recepticles 745 Golf Bag Rest and Stands Pump #1 Motor Replacement Ice Machine and Shed Ice Machine for Eagles Nest Pressure Wash/Paint Clubhouse Pump Replacement Electrical Work Cart Barn Re -wiring Starter Shack Repairs Parking Lot Lights - Building Loan Roofing - Building Loan Rebuild Greens - Building Loan Return Balance Back to Revenue Fund CAPITAL FUND BALANCE $ 140,923 Total Fund 410 and 415 Balances $ 67,694 Change in Value of Capital Assets (120,378) Golf Cart Bank Loan Balances (212,251) Building fund Loan Balance CAFR Unrestricted Balance $ (264,935) 24,600 650 103,406 906,621 12,250 15,000 1,735 7,312 7,890 5,810 2,391 3,300 3,185 25,011 23,886 9,650 51,285 60,425 165,000 $ (175,975) $ (160,499) $ (64,398) $ (70,003) $ (111,599) $ (121,267) $ (71,638) (150,000) (150,000) (150,000) (150,000) (150,000) (150,000) (150,000) (162,777) (110,910) (260,651) (212,251) (162,777) (110,910) (260,651) AIRPORT FUND PROJECTED BALANCES FISCAL YEARS 2017-2022 FY 14.15 FY 15.16 FY 16.17 FY 17-18 FY 18.19 FY 19.20 FY 20-21 FY 21.22 OPERATING FUND: Fuel Sales Revenue (2.5% Increase) $ 71,366 $ 72,000 $ 75,000 $ 76,875 $ 78,797 $ 80,767 $ 82,786 $ 84,856 Non-taxable Rents 391 391 391 391 391 391 391 391 Golf Course Rents 100,000 100,000 100,000 100,000 100,000 100,000 100,000 100,000 Taxable Rents 213,584 202,940 238,375 238,375 238,375 238,375 238,375 238,375 Insurance Proceeds - 31,830 Other Revenue 92,579 84,224 74,090 74,090 74,090 74,090 74,090 74,090 Investment Income (230) 137 128 103 92 82 PROJECTED REVENUE $ 477,690 $ 491,385 $ 487,856 $ 489,868 $ 491,780 $ 493,725 $ 495,734 $ 497,794 Operating Costs 295,856 Fuel Purchases for Resale 62,452 Repayment of General Fund Advance 50,000 Repayment of DST Fund Advance 20,025 TOTAL FY 15 $ 428,333 Operating Costs 321,529 Fuel Purchases for Resale 54,000 Equipment & Fencing 56,701 Vehicle Purchase 29,331 Repayment of General Fund Advance 50,000 Repayment of DST Fund Advance 20,025 TOTAL FY 16 $ 531,586 Operating Costs 382,901 Fuel Purchases for Resale 56,250 Repayment of General Fund Advance 10,000 Repayment of DST Fund Advance 24,500 TOTAL FY 17 $ 473,651 Operating Costs 387,496 Fuel Purchases for Resale 57,656 Repayment of General Fund Advance 10,000 Repayment of DST Fund Advance 24,500 TOTAL FY 18 $ 479,652 Operating Costs 392,146 Fuel Purchases for Resale 59,098 Repayment of General Fund Advance 10,000 Repayment of DST Fund Advance 30,500 TOTAL FY 19 $ 491,743 Operating Costs 396,852 Fuel Purchases for Resale 60,575 Repayment of General Fund Advance 10,000 Repayment of DST Fund Advance 30,500 TOTAL FY 20 $ 497,927 Operating Costs 401,614 Fuel Purchases for Resale 62,089 Repayment of General Fund Advance 10,000 Repayment of DST Fund Advance 30,500 TOTAL FY 21 $ 504,203 Operating Costs 406,433 Fuel Purchases for Resale 63,642 Repayment of General Fund Advance 10,000 Repayment of DST Fund Advance 30,500 TOTAL FY 22 510,575 BEGINNING FUND BALANCE $ 9,600 $ 58,957 $ 18,756 $ 32,961 $ 43,177 $ 43,214 $ 39,013 $ 30,544 TOTAL REVENUES 477,690 491,385 487,856 489,868 491,780 493,725 495,734 497,794 TOTAL EXPENDITURES+DEBT+TRANSFERS 428,333 531,586 473,651 479,652 491,743 497,927 504,203 510,575 ENDING FUND BALANCE $ 58,957 $ 18,756 $ 32,961 $ 43,177 $ 43,214 $ 39,013 $ 30,544 $ 17,763 CAPITAL FUND: BEGINNING FUND BALANCE $ - $ - $ - $ - $ - $ - $ - $ - Grants 702,154 1,397,483 263;772 2,564,800 1,900,000 - - - Transfers from DST 129,744 387,404 24,683 341,200 100,000 - - Capital Outlays 831,898 1,784,887 288,455 2,906,000 2,000,000 - ENDING FUND BALANCE $ - $ - $ - $ - $ - $ - $ - $ - TOTAL OPERATING AND CAPITAL $ 58,957 $ 18,756 $ 32,961 $ 43,177 $ 43,214 $ 39,013 $ 30,544 $ 17,763 Interfund Loans (701,287) (675,638) (648,163) (635,589) (616,913) (597,890) (597,890) (578,867) AIRPORT FUND COMBINED FUNDS $ (642,330) $ (656,882) $ (615,202) $ (592,412) $ (573,699) $ (558,877) $ (567,346) $ (561,104) Operating Revenue Other Revenue Transfer from General Fund Principal on Golf Course Loan Interest on Golf Course Loan Investment Income PROJECTED REVENUE Operating Costs Compact Pickup Clear Village Software Unsafe Structure Demolition Transfer to General Fund TOTAL FY 15 Operating Costs Compact Pickup Utility Vehicle Computer Monitors Surface Tablets Large Plan Scanner Transfer to General Fund Loan to Golf Course TOTAL FY 16 Operating Costs TOTAL FY 17 Operating Costs TOTAL FY 18 Operating Costs TOTAL FY 19 Operating Costs TOTAL FY 20 Operating Costs TOTAL FY 21 Operating Costs TOTAL FY 22 BUILDING FUND PROJECTED BALANCES FISCAL YEARS 2017-2022 FY 14.15 FY 15.16 FY 16.17 FY 17-18 FY 18-19 FY 19.20 FY 20-21 FY 21-22 $ 710,621 $ 792,100 $ 744,400 $ 774,176 $ 805,143 $ 837,349 $ 870,843 $ 905,676 1,999 8,501 2,500 2,500 2,500 2,500 2,500 2,500 - - 25,000 25,000 25,000 25,000 25,000 25,000 - - - 26,394 26,739 27,089 - - 5,527 7,629 7,629 7,629 7,284 6,934 4,650 3,790 2,793 2,940 3,611 4,333 5,183 5,287 $ 717,270 $ 804,391 $ 780,220 $ 812,245 $ 843,883 $ 903,205 $ 937,549 $ 972,487 529,012 18,923 27,579 23,953 10,376 105,294 $ 691,184 540,697 20,183 28,100 5,250 4,900 14,639 104,086 433,472 165,000 $ 1,175,280 578,601 $ 743,601 592,835 $ 592,835 607,418 $ 607,418 622,361 $ 622,361 637,671 $ 637,671 653,358 $ 653,358 BEGINNING FUND BALANCE $ 948,958 $ 975,044 $ 604,155 $ 640,774 $ 860,185 $ 1,096,650 S 1,096,650 $ 1,377,494 TOTAL REVENUES 717,270 804,391 780,220 812,245 843,883 903,205 937,549 972,487 EXPENDITURES+DEBT+TRANSFERS - 691,184 1,175,280 743,601 592,835 607,418 622,361 637,671 653,358 ENDING FUND BALANCE $ 975,044 $ 604,155 $ 640,774 $ 860,185 $ 1,096,650 $ 1,377,494 $ 1,396,528 S 1,696,623 Advances to Golf Fund - Balance After fY 21-22 518,250