Loading...
07-19-2016 City Council Study Session Packet City of Grand Island Tuesday, July 19, 2016 Study Session Packet City Council: Linna Dee Donaldson Michelle Fitzke Chuck Haase Julie Hehnke Jeremy Jones Vaughn Minton Mitchell Nickerson Mike Paulick Roger Steele Mark Stelk Mayor: Jeremy L. Jensen City Administrator: Marlan Ferguson City Clerk: RaNae Edwards 7:00 PM Council Chamers - City Hall 100 East 1st Street Grand Island Study Session - 7/19/2016 Page 1 / 99 City of Grand Island Tuesday, July 19, 2016 Call to Order This is an open meeting of the Grand Island City Council. The City of Grand Island abides by the Open Meetings Act in conducting business. A copy of the Open Meetings Act is displayed in the back of this room as required by state law. The City Council may vote to go into Closed Session on any agenda item as allowed by state law. Invocation Pledge of Allegiance Roll Call A - SUBMITTAL OF REQUESTS FOR FUTURE ITEMS Individuals who have appropriate items for City Council consideration should complete the Request for Future Agenda Items form located at the Information Booth. If the issue can be handled administratively without Council action, notification will be provided. If the item is scheduled for a meeting or study session, notification of the date will be given. B - RESERVE TIME TO SPEAK ON AGENDA ITEMS This is an opportunity for individuals wishing to provide input on any of tonight's agenda items to reserve time to speak. Please come forward, state your name and address, and the Agenda topic on which you will be speaking. Grand Island Study Session - 7/19/2016 Page 2 / 99 City of Grand Island Tuesday, July 19, 2016 Study Session Item -1 Utilities Budget Presentation Staff Contact: Tim Luchsinger, Utilities Director Grand Island Study Session - 7/19/2016 Page 3 / 99 Council Agenda Memo From:Timothy Luchsinger, Utilities Director Meeting:July 19, 2016 Subject: Electric and Water Budgets for 2016 - 2017 Presenter(s):Timothy Luchsinger, Utilities Director Background The proposed budgets for Electric Utility Enterprise Fund 520 and Water Utility Enterprise Fund 525 have been developed for the City’s Fiscal Year 2016-17 by Department management and financial staff. Discussion These budgets will be presented for preliminary discussion by Council. Conclusion This item is presented to the City Council in a Study Session to allow for any questions to be answered and to create a greater understanding of the issue at hand. It is the intent of City Administration to bring this issue to a future council meeting for the Council to take action on the item. Grand Island Study Session - 7/19/2016 Page 4 / 99 Grand Island Study Session - 7/19/2016 Page 5 / 99 Grand Island Study Session - 7/19/2016 Page 6 / 99 Grand Island Study Session - 7/19/2016 Page 7 / 99 Grand Island Study Session - 7/19/2016 Page 8 / 99 Grand Island Study Session - 7/19/2016 Page 9 / 99 CAPITAL IMPROVEMENTS BUDGET – May 27, 2016 Draft #4 ELECTRIC DEPARTMENT FISCAL YEAR 2016-17 Page 1 of 3 ADMINISTRATION 1. Administrative Capital Additions: $55,000 $55,000 – Utility Customer Service Building 2. 2012 Revenue Bond Payment: $1,675,000 Anticipated debt service on Series 2012 Bonds. 3. 2013 Revenue Bond Payment: $1,300,000 Anticipated debt service on Series 2013 Bonds. TRANSMISSION 4. Transmission Line Improvements: $1,500,000 This is for the rebuild of 115 kV Line 1093 from Grand Island Substation E to Nebraska Public Power District Grand Island 115 kV Substation east of the City. This has been identified on the Electric System Master Plan and with Southwest Power Pool as a point of restriction in the future. The rebuild will allow greater capacity on the line. 5. Additional Substations: $0 6. Equipment & Vehicles: $125,000 $125,000 - New SF6 gas cart for servicing transmission breakers. 7. PCC Improvements: $150,000 $50,000 – Concrete expansion along new warehouse. $150,000 – repair of Substation F wall and new wall for Substation B. 8. Substation Upgrades: $180,000 $20,000 – Additional equipment for new backup control center at Substation J. $60,000 – Industrial HVAC units for substations. $100,000 – Various insulator replacements in substations. DISTRIBUTION 9. Overhead Material: $1,750,000 This routine item includes pole-mounted transformers, conductors, poles, meters, streetlights, small tools, hardware and labor necessary for overhead electrical distribution. The budgeted amount is based on historical expenditures. Grand Island Study Session - 7/19/2016 Page 10 / 99 CAPITAL IMPROVEMENTS BUDGET – May 27, 2016 Draft #4 ELECTRIC DEPARTMENT FISCAL YEAR 2016-17 Page 2 of 3 10. Underground Materials: $2,250,000 This is a routine item that includes the cable, pad-mounted transformers, conduit, small tools, hardware and labor necessary to supply underground electric service to new businesses and subdivisions. Cable nearing the end of its useful 30 year life is replaced from this line item. Most projects have a short lead-time, and the budgeted amount is based on the historic needs. 11. Equipment & Vehicles: $505,000 $35,000 – Unit 1889. Replacement for a 2004 Ford F150 4x4 Ext. Cab Pickup. $35,000 – GPS Base Station w/ Radio. The Department’s survey-grade GPS Base Station is also a part of the National Geodetic Survey’s (NGS) Continuously Operating Reference Station (CORS) system. The high-accuracy data from our Base is shared Nation wide. The existing Trimble R5 unit was purchased in 2007. We have had intermittent failures. The equipment is no longer supported, and repair parts are not available. $75,000 – Network, Computers, Hardware & Software. The Department relies on a robust and secure high-speed network. Due to a recent fire, a portion of the fiber optics system was destroyed resulting in extensive downtime. This item will cover system wide: automatic switching, failover devices, redundancy, restoration, hardware, software, licenses, consulting services, installation, training, support and safety. $280000 – Unit #1541. Replacement for a 2004 55’ Bucket Truck $50,000 – Unit #1688. Replacement for a 2004 Ford Extended Cab Pickup $30,000 – Unit #1040. Replacement for a 2004 Ford F150 Pickup 12. Outside Contractors: $140,000 Contractors used for underground boring to install conduit for the Underground Department 13. Distribution Building Improvements: $855,000 $150,000 – New Parking Lot. Design and construction of new parking lot at 4th Street and Washington Street. $50,000 – Enclosure of docking bay for the Underground Division to better utilize the facility. $100,000 – Remodel of Electric Service Building to provide better security and organization. $55,000 – Customer Service Area. Updates and remodel to interior and exterior at 1306 W 3rd St. $450,000 – Garage, Paving, Drainage and Fencing. Design services and construction of vehicle garage and parking lot on north side of 315 N Jefferson St. for Engineering and Meter Reader vehicles. $50,000 – Grading and Landscape. The old Rogers 1 Well site is located on Faidley Ave and Claude Road extended. Due to the adjacent commercial and residential development in the area, it is recommended the area be improved and landscaped. 14. Distribution Improvements: $0 Engineering computers and automated mapping. PRODUCTION Grand Island Study Session - 7/19/2016 Page 11 / 99 CAPITAL IMPROVEMENTS BUDGET – May 27, 2016 Draft #4 ELECTRIC DEPARTMENT FISCAL YEAR 2016-17 Page 3 of 3 15. PGS Improvements: $2,470,000 Bottom Ash Controls $200,000 Turbine Generator Parts $200,000 Control / Relay Room HVAC $150,000 Track Work $200,000 Coal Dozer $1,000,000 Highlift Loader $275,000 Arch Flash Study $40,000 Fork Lift $55,000 Road Grader $350,000 16. PGS Air Quality Control: $0 17. Equipment & Vehicles: $85,000 Unit 1301 replacement $40,000 SDA Dump Truck Replacement $45,000 18. Burdick Steam Units: $125,000 Arc Flash Study $25,000 Asbestos Removal $100,000 19. Burdick Gas Turbines: $300,000 HMI S plus Upgrade $300,000 Grand Island Study Session - 7/19/2016 Page 12 / 99 CAPITAL IMPROVEMENTS BUDGET – May 27, 2016 Draft #4 WATER DEPARTMENT FISCAL YEAR 2016-17 Page 1 of 1 ADMINISTRATION 1. Administrative Capital Additions: $0 2. 2012 Revenue Bond Payment: $230,000 Anticipated debt service on Series 2012 Bonds. 3. 2017 Revenue Bond Payment: $350,000 Anticipated debt service on Series 2017 Bonds. DISTRIBUTION 4. Water Main Districts: $100,000 This item includes unplanned extensions of water mains into new subdivisions and developments. Compliance with Federal regulations, annexation, and aquifer contamination will continue to produce additional requests for water main extensions 5. Equipment & Vehicles: $90,000 Unit 905 $35,000 Valve Operators $55,000 6. Distribution Improvements: $950,000 State St-Walnut to Huston $400,000 3rd St – Clark to Cedar $350,000 16th St & Locust (Storm Sewer) $100,000 16th St & Sycamore (Storm Sewer) $100,000 7. Trunk Line Expansion: $4,500,000 8th & Boggs, Pletcher Terrace $150,000 Engleman Rd – Stolley Park $350,000 Elevated Storage $4,000,000 PRODUCTION 8. Well Field Improvements: $75,000 Wellfield Access Improvement $75,000 9. Equipment & Vehicles: $0 10. Pumpstation Improvements: $65,000 Pine Pump 3 replacement $45,000 Pine Street PLC Upgrade $20,000 Grand Island Study Session - 7/19/2016 Page 13 / 99 Electric Utilities Capital Budget FY 2016-17 Draft #4 Utilities Department May 27, 2016 Capital Improvement Budget Draft #4 Fiscal Year 2016-17 Electric Fund 520 Budget Projected Budget Budget Budget Budget Budget FY 2015-16 FY 2015-16 Line items FY 2016-17 FY 2016-17 FY 2017-18 FY 2018-19 FY 2019-20 FY 2020-21 Administration $550,000 $550,000 Administrative Capital Additions $0 $0 $0 $0 $0 $1,750,000 $1,750,000 2012 Revenue Bond Payment $1,675,000 $1,795,000 $1,660,000 $1,645,000 $1,920,000 $1,165,000 $1,165,000 2013 Revenue Bond Payment $1,300,000 $1,240,000 $1,450,000 $1,580,000 $1,425,000 $3,465,000 $3,465,000 Administration Subtotal $2,975,000 $3,035,000 $3,110,000 $3,225,000 $3,345,000 Transmission $3,000,000 $2,000,000 Transmission line Improvements $1,500,000 $1,000,000 $1,000,000 $1,000,000 $1,000,000 $0 $0 Additional Substation $0 $0 $4,000,000 $0 $0 $300,000 $27,000 Equipment & Vehicles $125,000 $0 $25,000 $35,000 $35,000 $250,000 $150,000 PCC Improvements $150,000 $0 $0 $0 $0 $960,000 $700,000 Substation Upgrades $180,000 $100,000 $100,000 $100,000 $100,000 $4,510,000 $2,877,000 Transmission Subtotal $1,955,000 $1,100,000 $5,125,000 $1,135,000 $1,135,000 Distribution $1,260,000 $750,000 Overhead Material $1,750,000 $1,750,000 $2,000,000 $2,000,000 $2,250,000 $1,470,000 $1,200,000 Underground Material $2,250,000 $2,250,000 $2,500,000 $2,500,000 $2,750,000 $530,000 $400,000 Equipment & Vehicles $505,000 $75,000 $405,000 $320,000 $180,000 $105,000 $130,000 Outside Contractors $140,000 $150,000 $155,000 $160,000 $170,000 $1,535,000 $1,500,000 Building Improvements $855,000 $100,000 $100,000 $100,000 $100,000 $100,000 $0 Distribution Improvements $0 $0 $0 $0 $0 $5,000,000 $3,980,000 Distribution Subtotal $5,500,000 $4,325,000 $5,160,000 $5,080,000 $5,450,000 Production $2,025,000 $1,040,000 PGS Improvements $2,470,000 $4,500,000 $2,750,000 $3,025,000 $3,200,000 $0 PGS Air Quality Control $0 $0 $0 $0 $0 $99,000 $100,664 Equipment & Vehicles $85,000 $40,000 $45,000 $0 $0 $747,000 $845,800 Burdick Steam Units $125,000 $115,000 $120,000 $250,000 $300,000 $113,000 $91,677 Burdick Gas Turbines $300,000 $175,000 $185,000 $300,000 $150,000 $2,984,000 $2,078,141 Production Subtotal $2,980,000 $4,830,000 $3,100,000 $3,575,000 $3,650,000 Electric Total $15,959,000 $12,400,141 $13,410,000 $13,290,000 $16,495,000 $13,015,000 $13,580,000 Grand Island Study Session - 7/19/2016 Page 14 / 99 Water Utilities Capital Budget FY 2016-17 Draft #4 Utilities Department May 27, 2016 Capital Improvement Budget Draft #4 Fiscal Year 2016-17 Water Fund 525 Budget Projected Budget Budget Budget Budget Budget FY 2015-16 FY 2015-16 Line items FY 2016-17 FY 2016-17 FY 2017-18 FY 2018-19 FY 2019-20 FY 2020-21 Administration $25,000 $25,000 Administrative Capital Additions $0 $0 $0 $0 $0 $230,000 $230,000 2012 Revenue Bond $230,000 $235,000 $240,000 $245,000 $250,000 $0 $0 2017 Revenue Bond $350,000 $360,000 $370,000 $380,000 $390,000 $255,000 $255,000 Administration Subtotal $580,000 $595,000 $610,000 $625,000 $640,000 Distribution $250,000 $0 Water Districts $100,000 $110,000 $120,000 $140,000 $200,000 $110,000 $104,797 Equipment & Vehicles $90,000 $0 $0 $45,000 $115,000 $1,150,000 $750,000 Distribution Improvements $950,000 $1,050,000 $750,000 $900,000 $1,100,000 $800,000 $0 Trunk line Expansion $4,500,000 $4,400,000 $100,000 $1,000,000 $800,000 $2,310,000 $854,797 Distribution Subtotal $5,640,000 $5,560,000 $970,000 $2,085,000 $2,215,000 Production $140,000 $88,508 Well field Improvements $75,000 $50,000 $120,000 $550,000 $50,000 $0 $0 Equipment & Vehicles $0 $0 $0 $0 $0 $370,000 $516,863 Pumpstation Improvements $65,000 $50,000 $200,000 $550,000 $500,000 $510,000 $605,371 Production Subtotal $140,000 $100,000 $320,000 $1,100,000 $550,000 Water Total $3,075,000 $1,715,168 $6,360,000 $6,255,000 $1,900,000 $3,810,000 $3,405,000 Grand Island Study Session - 7/19/2016 Page 15 / 99 UTILITIES 2016-17 BUDGET OVERVIEW Electric Department – Fund 520 Water Department – Fund 525 Grand Island Study Session - 7/19/2016 Page 16 / 99 UTILITIES Budget Guidelines Conservative (low) revenue forecast Weather dependent Ensure debt service coverage Conservative (high) operating costs Generation fuel/purchased power Allow potential production capacity Maintain adequate cash reserves Manage controllable operating expenses and capital expenditures Grand Island Study Session - 7/19/2016 Page 17 / 99 UTILITIES Cash Reserve Guidelines Cash Reserve Considerations Working Capital Replacement Power Asset Replacement Capital Improvement Reserve Debt Service Reserve Electric Fund - $30,200,000 Water Fund - $4,600,000 Grand Island Study Session - 7/19/2016 Page 18 / 99 UTILITIES Capital Improvement Budgets Electric and Water Master Plans recently completed 5 and 20 Year System Requirements Technical Evaluation No Financial Evaluation Recommendations included in 5 year capital improvement budget forecasts Grand Island Study Session - 7/19/2016 Page 19 / 99 UTILITIES ELECTRIC DEPARTMENT FUND 520 Grand Island Study Session - 7/19/2016 Page 20 / 99 UTILITIES $0 $20,000,000 $40,000,000 $60,000,000 $80,000,000 $100,000,000 $120,000,000 Electric Department - Fund 520 Capital Expenditures Capital Expenditures less Air Quality Adjusted Expenditures Adjusted Revenues Cash Balance Grand Island Study Session - 7/19/2016 Page 21 / 99 UTILITIES $0 $20,000,000 $40,000,000 $60,000,000 $80,000,000 $100,000,000 $120,000,000 Electric Department - Fund 520 Capital Expenditures less Air Quality Fuel, purchase power, debt service Admin and Operating Grand Island Study Session - 7/19/2016 Page 22 / 99 UTILITIES Electric Capital Improvements Total Capital Budget - $13,410,000 Transmission line improvements - $1,000,000 Bond payments - $2,975,000 Distribution improvements - $4,000,000 Power plant maintenance/improvements - $2,895,000 Distribution Service Center improvements- $300,000 Engineering Center improvements - $ 450,000 Grand Island Study Session - 7/19/2016 Page 23 / 99 UTILITIES WATER DEPARTMENT FUND 525 Grand Island Study Session - 7/19/2016 Page 24 / 99 UTILITIES $0 $1,000,000 $2,000,000 $3,000,000 $4,000,000 $5,000,000 $6,000,000 $7,000,000 $8,000,000 $9,000,000 $10,000,000 2009 2010 2011 2012 2013 2014 2015 2016 (Projected) Water Department - Fund 525 Adjusted Revenues Adjusted Expenditures Cash Balance Adjusted Capital Expenditures Grand Island Study Session - 7/19/2016 Page 25 / 99 UTILITIES $0 $2,000,000 $4,000,000 $6,000,000 $8,000,000 $10,000,000 $12,000,000 Water Department - Fund 525 Adjusted Capital Expenditures Uranium Removal Operation Expense Adjusted Admin & Oper Grand Island Study Session - 7/19/2016 Page 26 / 99 UTILITIES Water Capital Improvements Total Capital Budget - $6,360,000 Bond payments - $580,000 Elevated Water Storage Reservoir - $4,000,000 Distribution improvements- $950,000 Production improvements - $140,000 Grand Island Study Session - 7/19/2016 Page 27 / 99 UTILITIES 0 2 4 6 8 10 12 14 16 18 20 22 24 26 2015 City Demand (MGD) millions of gallons per day Grand Island Study Session - 7/19/2016 Page 28 / 99 UTILITIES 0 5,000 10,000 15,000 20,000 25,000 30,000 0:00:000:36:001:12:001:48:002:24:003:00:003:36:004:12:004:48:005:24:006:00:006:36:007:12:007:48:008:24:009:00:009:36:0010:12:0010:48:0011:24:0012:00:0012:36:0013:12:0013:48:0014:24:0015:00:0015:36:0016:12:0016:48:0017:24:0018:00:0018:36:0019:12:0019:48:0020:24:0021:00:0021:36:0022:12:0022:48:0023:24:000:00:00City Total Water Flow Demand (gpm) Total Flow (gpm) Grand Island Study Session - 7/19/2016 Page 29 / 99 UTILITIES Grand Island Study Session - 7/19/2016 Page 30 / 99 UTILITIES -$15,000,000 -$10,000,000 -$5,000,000 $0 $5,000,000 $10,000,000 $15,000,000 Water Department - Fund 525 Adjusted Revenues Adjusted Expenditures Cash Balance Adjusted Capital Expenditures Grand Island Study Session - 7/19/2016 Page 31 / 99 UTILITIES Funding Considerations 2017 budget proposes 10% revenue increase for elevated storage reservoir debt service Future budgets should allow for increased capital improvements Rate increases over several years to support capital improvements may be required Grand Island Study Session - 7/19/2016 Page 32 / 99 UTILITIES Questions? Grand Island Study Session - 7/19/2016 Page 33 / 99 City of Grand Island Tuesday, July 19, 2016 Study Session Item -2 Solid Waste Budget Presentation Staff Contact: John Collins, P.E. - Public Works Director Grand Island Study Session - 7/19/2016 Page 34 / 99 Solid Waste Division FY 2017 Budget PUBLIC WORKS DEPARTMENT SOLID WASTE DIVISION Landfill on Husker Hwy @ Hall / Buffalo County Line Grand Island Study Session - 7/19/2016 Page 35 / 99 Enterprise Fund Receive no funding from General Fund All revenues generated from tipping fees One of the few Divisions with competition Serves residents and non- residents PUBLIC WORKS DEPARTMENT SOLID WASTE DIVISION Grand Island Study Session - 7/19/2016 Page 36 / 99 Landfill Site Life 5-6 years life left in current area (Cells 1 & 2) Approximately 31 years life left in total Phase 1 area PUBLIC WORKS DEPARTMENT SOLID WASTE DIVISION Grand Island Study Session - 7/19/2016 Page 37 / 99 Notable Items From FY 2016 Continued routine capital replacement schedule Transfer Station -New scale -New wheel loader -New truck-tractor -Two new transfer trailers Landfill -Additional perimeter litter fencing -Used excavator PUBLIC WORKS DEPARTMENT SOLID WASTE DIVISION Grand Island Study Session - 7/19/2016 Page 38 / 99 Notable Items From FY 2016 Landfill NDEQ Title 132 re-permitting process completed New permit expires April 15th, 2021 Landfill NPDES permit and Title V Air permit applications submitted to the NDEQ NPDES and Title V Air permits both expire in December PUBLIC WORKS DEPARTMENT SOLID WASTE DIVISION Grand Island Study Session - 7/19/2016 Page 39 / 99 FY 2017 Budget Personnel – $1,044,044 Operations - $1,017,491 Capital - $1,170,000 PUBLIC WORKS DEPARTMENT SOLID WASTE DIVISION Grand Island Study Session - 7/19/2016 Page 40 / 99 FY 2017 Budget Capital Expenditures New landfill compactor ($820,000) Two new ground water monitoring wells at the landfill ($20,000) Cell 3 engineering services ($250,000) PUBLIC WORKS DEPARTMENT SOLID WASTE DIVISION Grand Island Study Session - 7/19/2016 Page 41 / 99 Highlights of FY 2017 Budget No FTE changes No rate increase proposed One rate increase (FY 2014) in past 12 years PUBLIC WORKS DEPARTMENT SOLID WASTE DIVISION Location Transfer Station Rate Per Ton Landfill Rate Per Ton Grand Island $38.21 (uncompacted) $32.14 (uncompacted) $30.75 (compacted) $28.33 (compacted) Columbus $62.00 Norfolk $56.00 Gering $56.75 York $44.00 Holdrege $34.00 Hastings $36.00 Grand Island Study Session - 7/19/2016 Page 42 / 99 Questions? PUBLIC WORKS DEPARTMENT SOLID WASTE DIVISION Grand Island Study Session - 7/19/2016 Page 43 / 99 City of Grand Island Tuesday, July 19, 2016 Study Session Item -3 Wastewater Budget Presentation Staff Contact: John Collins, P.E. - Public Works Director Grand Island Study Session - 7/19/2016 Page 44 / 99 PUBLIC WORKS 2017 Wastewater Budget City of Grand Island Wastewater Treatment Plant recognized in industry magazine Grand Island Study Session - 7/19/2016 Page 45 / 99 PUBLIC WORKS Funding Sources Operating Revenue Sewer Assessments $ 150,000 Sewer Tap Fees $ 10,000 Sewer Revenue $11,500,000 Sewer Assessment Interest $ 25,000 Co-Pay Health Insurance $ 56,594 Interest & Dividend Revenue $ 10,000 State Revolving Fund $ 9,909,496 Other Revenue $ 140,000 Credit Card Rebate $ 12,000 $21,813,090 Grand Island Study Session - 7/19/2016 Page 46 / 99 PUBLIC WORKS Staff $ 2,683,200 Operating $ 3,914,928 Debt Service $ 2,940,757 Capital $13,284,496 $22,823,381 Expenditures Grand Island Study Session - 7/19/2016 Page 47 / 99 PUBLIC WORKS Operating Cash Balance $(16,393,432) Revenue $(21,813,090) Total Resources Available $(38,206,522) Total Requirements $ 22,823,381 Ending Cash Balance $ 15,383,141 2017 Overview *Ending Cash contains $2,560,000 restricted cash for bond reserve requirements Grand Island Study Session - 7/19/2016 Page 48 / 99 Wastewater Treatment FY 2017 - FY 2020 2017 2018 2019 2020 Budget Budget Budget Budget Beginning Cash Balance $16,393,432 15,383,141$ 14,413,308$ 11,407,558$ Revenue $21,813,090 $14,278,181 $12,112,317 $12,215,910 Transfers In Total Resources Available $38,206,522 29,661,322$ 26,525,625$ 23,623,468$ Expenditures $22,823,381 $15,248,014 $15,118,067 $16,643,891 Transfers Out Total Requirements $22,823,381 $15,248,014 $15,118,067 $16,643,891 Ending Cash Balance $15,383,141 14,413,308$ 11,407,558$ 6,979,577$ Unrestricted Cash 12,823,141$ 11,853,308$ 8,847,558$ 4,419,577$ Restricted Cash $2,560,000 $2,560,000 $2,560,000 $2,560,000 15,383,141$ 14,413,308$ 11,407,558$ 6,979,577$ Personnel $2,683,200 $2,817,360 $2,901,881 $2,988,937 Operating $3,914,928 $4,073,378 $4,211,007 $4,355,677 Debt $2,940,757 5,038,007$ 5,180,179$ 5,158,310$ Capital $13,284,496 $3,319,269 $2,825,000 4,140,967$ Total Expenditures $22,823,381 $15,248,014 $15,118,067 $16,643,891 Grand Island Study Session - 7/19/2016 Page 49 / 99 PUBLIC WORKS Sanitary Sewer Extended to I-80 Grand Island Study Session - 7/19/2016 Page 50 / 99 PUBLIC WORKS Grand Island Study Session - 7/19/2016 Page 51 / 99 PUBLIC WORKS Grand Island Study Session - 7/19/2016 Page 52 / 99 PUBLIC WORKS Hydrogen Sulfide reduced with Lift Station abandonment Increasing life expectancy of infrastructure Grand Island Study Session - 7/19/2016 Page 53 / 99 Grand Island Study Session - 7/19/2016 Page 54 / 99 PUBLIC WORKS 2016/2017 WASTEWATER CAPITAL PROJECTS North Interceptor Phase II $ 4,255,714 Concrete Dewatering Pad $ 100,000 Lift Station No. 20 - Upgrade $ 1,200,000 Lift Station No. 20 - Forcemain Rehabilitation $ 2,980,782 Airport Sanitary Sewer Collection System $ 1,350,000 Wastewater Collection System Rehabilitation $ 250,000 Wastewater Treatment Plant Building Improvements $ 600,000 WAS Tank Blowers $ 250,000 Safety Screening $ 25,000 Assessment Districts $ 250,000 Miscellaneous Wastewater Treatment Plant Paving $ 30,000 Lift Station No. 14 Abandonment $ 73,000 Westwood Phase I Low Pressure $ 1,400,000 $ 12,764,496 Grand Island Study Session - 7/19/2016 Page 55 / 99 PUBLIC WORKS Wastewater Vehicles $520,000 Combination sewer cleaning unit Combined vacuuming & flushing functions in one unit for more efficient & effective cleaning Van for Sample Collection Will allow for more collecting & analyzing of wastewater sent to the plant Grand Island Study Session - 7/19/2016 Page 56 / 99 PUBLIC WORKS Wastewater Awards NWEA Silver Safety Award NWEA Scott Wilbur Outstanding Facility Award WEF Laboratory Analyst Excellence Award – Dallas Powell Grand Island Study Session - 7/19/2016 Page 57 / 99 City of Grand Island Tuesday, July 19, 2016 Study Session Item -4 Jackrabbit Golf Course Budget Presentation Staff Contact: Todd McCoy, Parks & Recreation Director Grand Island Study Session - 7/19/2016 Page 58 / 99 Jackrabbit Run Golf Course Budget 2016-17 Grand Island Study Session - 7/19/2016 Page 59 / 99 Number of Golf Rounds 0 10,000 20,000 30,000 40,000 50,000 60,000 Opened in July -197719781979198019811982198319841985198619871988Indianhead - 1989199019911992Meadow Lark Hills -199319941995Cairo -19961997199819992000200120022003200420052006200720082009201020112012201320142015Rounds Year Number of Rounds Grand Island Study Session - 7/19/2016 Page 60 / 99 Golf Course Financial History 2010 2011 2012 2013 2014 2015 2016 projected 2017 budget Beginning Cash $ (213,302.00) $ 120,693.00 $ 184,690.00 $ 277,940.00 $ 190,367.00 $ 175,270.00 $ 111,481.00 $ 93,945.00 Revenue $ 577,224.00 $ 593,254.00 $ 671,917.00 $ 620,427.00 $ 611,087.00 $ 591,204.00 $ 635,389.00 $ 668,889.00 Transfer In $ 329,000.00 $ - $ - $ - $ 497,384.00 $ - $ - $ - Operating & Personnel $ 544,999.00 $ 520,255.00 $ 578,667.00 $ 600,948.00 $ 623,685.00 $ 619,950.00 $ 669,489.00 $ 671,279.00 Capital $ 27,230.00 $ 9,000.00 $ 107,052.00 $ 499,883.00 $ 35,042.00 $ 59,845.00 Total Appropriations $ 572,229.00 $ 529,255.00 $ 578,667.00 $ 708,000.00 $ 1,123,568.00 $ 654,992.00 $ 729,334.00 $ 671,279.00 Ending Cash $ 120,693.00 $ 184,692.00 $ 277,940.00 $ 190,367.00 $ 175,270.00 $ 111,481.00 $ 93,945.00 $ 91,555.00 Grand Island Study Session - 7/19/2016 Page 61 / 99 Golf Course Five Year Projection 2017 2018 2019 2020 2021 Beginning Cash $ 93,945.00 $ 91,555.00 $ 49,026.63 $ 25,822.41 $ (83,746.61) Revenue $ 668,889.00 $ 668,889.00 $ 688,955.67 $ 688,955.67 $ 709,624.34 Personnel Services $ 333,604.00 $ 343,612.12 $ 353,920.48 $ 364,538.10 $ 375,474.24 Operating Expense $ 337,675.00 $ 347,805.25 $ 358,239.41 $ 368,986.59 $ 380,056.19 Capital $ - $ 20,000.00 $ - $ 65,000.00 Total Appropriations $ 671,279.00 $ 711,417.37 $ 712,159.89 $ 798,524.69 $ 755,530.43 Ending Cash $ 91,555.00 $ 49,026.63 $ 25,822.41 $ (83,746.61) $ (129,652.70) Grand Island Study Session - 7/19/2016 Page 62 / 99 Seventy five tree removed this year 125 trees planted in the last five years Challenge of Pine Wilt Disease Grand Island Study Session - 7/19/2016 Page 63 / 99 Clubhouse: bathrooms, asphalt, tables and chairs, windows, paint Irrigation, golf car lease, new mower Recent Improvements Grand Island Study Session - 7/19/2016 Page 64 / 99 City of Grand Island Tuesday, July 19, 2016 Study Session Item -5 General Fund Discussion Cont. Staff Contact: Renae Griffiths, Finance Director Grand Island Study Session - 7/19/2016 Page 65 / 99 2017 2018 2019 2020 2021CommentsBeginning Cash 11,278,875 8,160,529 6,030,037 3,461,149 (122,370) Revenue 36,663,933 37,397,212 38,645,156 39,418,059 40,206,420 Assumes a 2% increase each year, with all Debt Service property tax coming to the General Fund in 2019Transfers In 1,670,000 1,670,000 1,670,000 1,670,000 1,670,000 See detail sheetTotal Revenue 38,333,933 39,067,212 40,315,156 41,088,059 41,876,420 Personnel Services 29,118,044 30,719,536 32,409,111 34,191,612 36,072,151 Assumes a 5.5% increase each yearOperating Expense 6,168,483 6,168,483 6,168,483 6,168,483 6,168,483 No increasesTransfers Out 3,145,000 2,145,000 2,145,000 2,145,000 2,145,000 See detail sheetDepartment Equipment 2,299,864 1,450,000 1,450,000 1,450,000 1,450,000 See detail sheet for 2017 and then $1.45M each year afterDebt Pymts 720,888 714,684 711,450 716,484 710,070 For HEC payment and Fire Truck/Ambulance paymentsTotal Appropriations 41,452,279 41,197,703 42,884,044 44,671,579 46,545,704 Unrestricted Cash 8,160,529 6,030,037 3,461,149(122,370) (4,791,654)Restricted Cash - - - - - Ending Cash 8,160,529 6,030,037 3,461,149(122,370) (4,791,654)Cash Required / (Surplus Cash) (397,493) 2,085,327 5,025,921 9,001,591 14,084,593 Amount needed/(surplus) to maintain 22% reservesUnrestricted Cash 8,160,529 6,030,037 3,461,149 (122,370) (4,791,654) Restricted Cash - - - - - General Fund Projection7‐19‐2016Grand IslandStudy Session - 7/19/2016Page 66 / 99 Category TOTAL TARGET $1,070,000.00 Revenue $169,411.00 Personnel $721,419.44 Operating $339,085.56 Capital $524,000.00 Total $1,753,916.00 2017 SUMMARY OF CHANGES Grand Island Study Session - 7/19/2016 Page 67 / 99 Non‐Departmental$0.00Category Amount CommentsRevenuePersonnelOperating $38,000.00 Contract ServicesCapitalTotal $38,000.00Department:Targeted Cut Amount:Grand IslandStudy Session - 7/19/2016Page 68 / 99 HR$18,213.00Category Amount CommentsRevenue $0.00Personnel $0.00Operating $25,000.00 Reduction from Epicor costsCapital $0.00Total $25,000.00Department:Targeted Cut Amount:Grand IslandStudy Session - 7/19/2016Page 69 / 99 Finance$15,895.00Category Amount CommentsRevenuePersonnelOperating $2,000.00 Contract ServicesCapitalTotal $2,000.00Department:Targeted Cut Amount:Grand IslandStudy Session - 7/19/2016Page 70 / 99 Legal$12,215.00Category Amount CommentsRevenuePersonnelOperating $2,500.00$1500 from contract services (85213); $300 printing and binding (85245); $700 repair & maint, furniture (85330)CapitalTotal $2,500.00Department:Targeted Cut Amount:Grand IslandStudy Session - 7/19/2016Page 71 / 99 PIO$5,752.00Category Amount CommentsRevenuePersonnelOperating $3,250.00$2k from repair and maint equip (85325); $750 from other repairs (85330); $500 from Travel and Training (85428)CapitalTotal $3,250.00Department:Targeted Cut Amount:Grand IslandStudy Session - 7/19/2016Page 72 / 99 City Administrator$13,632.00Category Amount CommentsRevenuePersonnelOperating $4,922.00 $2k from Travel and Training (85428); $2922 from contract services (85213)CapitalTotal $4,922.00Department:Targeted Cut Amount:Grand IslandStudy Session - 7/19/2016Page 73 / 99 Mayor$0.00Category Amount CommentsRevenuePersonnelOperating $1,500.00 $1000 Mayor printing and binding (85245); $500 Mayor travel and training (85428)CapitalTotal $1,500.00Department:Targeted Cut Amount:Grand IslandStudy Session - 7/19/2016Page 74 / 99 City Hall$18,410.00Category Amount CommentsRevenuePersonnelOperatingCapital $20,000.00 Vehicle purchaseTotal $20,000.00Department:Targeted Cut Amount:Grand IslandStudy Session - 7/19/2016Page 75 / 99 Building Inspection$6,643.00Category Amount CommentsRevenue $15,000.00 2% rate increasePersonnelOperatingCapitalTotal $15,000.00Department:Targeted Cut Amount:Grand IslandStudy Session - 7/19/2016Page 76 / 99 Grand Generation$0.00Category Amount CommentsRevenuePersonnelOperating $15,000.00 Reduction in contract services line item (85213)CapitalTotal $15,000.00Department:Targeted Cut Amount:Grand IslandStudy Session - 7/19/2016Page 77 / 99 PARKS TOTAL$88,198.00Category Amount CommentsRevenue $17,950.00 See DetailPersonnelOperatingCapital $73,000.00 See DetailTotal $90,950.0010044405 74790 Cemetery Lot Sales10044405 74513 Cemetery Burial Services10044511 74760 Add $10 Children's Theater Charge10044518 74538 FH ‐ Bday Park Pkg10044518 74564 FH ‐ Volleyball10044518 74565 FH ‐ Soccer10044518 74566 FH ‐ Softball10044518 74667 FH ‐ Football10044405 85625 Cut 4x4 Pickup Cemetery10044403 85615 Cut 72" Rotary Mower ParksDepartment:Targeted Cut Amount:DetailGrand IslandStudy Session - 7/19/2016Page 78 / 99 Library$63,759.00Category Amount CommentsRevenue $5,000.00 Purchase of books in trust fundPersonnelOperating $48,759.00 See detailCapital $10,000.00 See detailTotal $63,759.00Department:Targeted Cut Amount:Grand IslandStudy Session - 7/19/2016Page 79 / 99 DESC OBJECT2017 ORGINAL BUDGET2017 REVISED BUDGETAMOUNT OF CUTCOMPUTER SERVICES 85241 26,857     26,848     9               PRINTING & BINDING SERVICES 85245 3,000       2,000       1,000       REPAIR & MAINT ‐ BUILDING 85324 30,000     28,000     2,000       REPAIR & MAINT‐OFF FURN & EQ 85330 26,000     24,000     2,000       ADVERTISING 85416 1,600       1,350       250          DUES & SUBSCRIPTIONS 85422 26,000     24,000     2,000       BOOKS 85425 120,000  95,000     25,000     AV/ELECTRONIC MEDIA 85426 130,000  115,000  15,000     PERIODICALS 85427 19,000     18,000     1,000       TRAVEL & TRAINING 85428 6,000       2,500       3,500       OFFICE SUPPLIES 85505 65,000     63,000     2,000       OFFICE FURNITURE & EQUIPMENT 85620 25,000     15,000     10,000     TOTAL 478,457  414,698  63,759    Grand IslandStudy Session - 7/19/2016Page 80 / 99 Fire$235,515.00Category Amount CommentsRevenue($22,055.00)Removal of staff added in errorPersonnel $515,804.00 Removal of staff added in errorOperating $89,400.00 See detailCapital $284,000.00 See detailTotal $867,149.00Department:Targeted Cut Amount:Grand IslandStudy Session - 7/19/2016Page 81 / 99 ORIGINAL Cuts REVISED2017 2017 2017Printing & Binding 85245 1,000.00              500.00                 500.00                    Public Education Materials 85291 2,000.00              500.00                 1,500.00                Natural Gas 85317 22,500.00            3,500.00              19,000.00              Repair & Maint ‐ Mach & Equip 85325 29,000.00            3,000.00              26,000.00              Repair & Maint ‐ Office Furn 85330 3,000.00              1,000.00              2,000.00                Repair & Maint ‐ Vehicles 85335 82,000.00            10,000.00            72,000.00              Postage85413 500.00                  400.00                 100.00                    Dues & Subscriptions 85422 3,375.00              1,000.00              2,375.00                Books 85425 6,000.00              3,000.00              3,000.00                Travel & Training 85428 42,500.00            10,000.00            32,500.00              Gasoline 85515 13,000.00            1,500.00              11,500.00              Diesel 85520 43,000.00            5,000.00              38,000.00              Misc Operating Equipment 85540 63,000.00            10,500.00            52,500.00              Hose 85546 3,000.00              2,000.00              1,000.00                Protective Clothing 85548 47,000.00            30,000.00            17,000.00              Ambulance Supplies85591 83,750.00            7,500.00              76,250.00              Total Fire Operating Expenses444,625.00          89,400.00            355,225.00            Building Improvements85612 250,000.00            250,000.00            ‐                            Vehicles85625 1,004,000.00      34,000.00            970,000.00            Total Capital Outlay1,254,000.00      284,000.00          970,000.00            TOTAL1,698,625.00      373,400.00          1,325,225.00        Grand IslandStudy Session - 7/19/2016Page 82 / 99 Police$344,115.00Category Amount CommentsRevenuePersonnel $98,245.44 See DetailOperating $108,754.56 See DetailCapital $137,000.00 See DetailTotal $344,000.00Department:Targeted Cut Amount:Grand IslandStudy Session - 7/19/2016Page 83 / 99 10022301 85290 OTHER PROFESSIONAL & TECH 10022301 85317 NATURAL GAS 10022301 85324 REPAIR & MAINT -BUILDING 10022.301 85335 REPAIR & MAINT -VEHICLES 10022301 85463 INVESTIGATIVE EXPENSE 10022301 85505 OFFICE SUPPLIES 10022301 85515 GASOLINE 10022301 85540 MISC OPERATING EQUIPMENT 10022301 85546 PROTECTIVE VESTS/UNIFORMS 10022301 85550 AMMO AND TRAINING SUPPLIES 10022301 85625 VEHICLES* Police Expenses ::::::z~tz::t~i.4i~~< : : ·=.::: ::_· : : := :, ~ec•,m1nern:1atto•'s Iii 1~111111ldl1lf!-i :.!i!!\l ! !i\11111 42,083.17 19,985.91 $ 50,000.00 $ 45,000.00 $ 5,000.00 911.87 479.70 $ 1,500.00 $ 1,000.00 $ 500.00 1,764.88 801.83 $ 4,000.00 $ 2,000.00 $ 2,000.00 163,110.93 84,342.30 $ 184,400.00 $ 164,400.00 $ 20,000.00 27,673.28 17,576.36 $ 44,000.00 $ 35,000.00 $ 9,000.00 24,029.06 7,694.44 $ 22,500.00 $ 20,000.00 $ 2,500.00 141,569.46 55,821.42 $ 200,500.00 $ 140,245.44 $ 60,254.56 147,564.32 80,515.95 $ 157,000.00 $ 151,500.00 $ 5,500.00 7,127.60 880.62 $ 9,500.00 $ 8,000.00 $ 1,500.00 22,916.14 3,705.98 $ 22,500.00 $ 20,000.00 $ 2,500.00 280,581.00 22,524.00 $ 270,000.00 $ 133,000.00 $137,000.00 :r:::r1:r=:::::=:::::rrJ:rr:t:::r:::1:11rn:::::rrr:=r:1::::]f:]:t:t::::r::::~t:::r~1.t:1r11::i~v11.i~::t&::Ggtigr~[:fB.nlJ$.:~1&ft11;:ii':::: : ::::'e¢r$96H~I §~!\hg$:{@$~1m~tg) $. 9tt!#~fa::@$.??i?~@:(1:1) ~ 9$9@$ZQ,$P~ :$,: :~~i~4$;M $344,000.00 Grand Island Study Session - 7/19/2016 Page 84 / 99 Public Works$243,162.00Category Amount CommentsRevenue $153,516.00 Admin charges to Landfill and WastewaterPersonnel $107,370.00 Leave CADD and seasonal positions vacantOperatingCapitalTotal $260,886.00Department:Targeted Cut Amount:Grand IslandStudy Session - 7/19/2016Page 85 / 99 2014 2015 2016 2016 2017 ACTUAL ACTUAL BUDGET FORECAST BUDGET Beginning Cash Balance 11,331,491 12,441,930 12,610,385 13,572,770 11,278,875 Revenues General Government 2,225,359 1,447,672 1,672,351 1,686,388 1,805,452 Public Safety 4,495,054 5,169,856 5,335,238 4,631,063 6,065,262 Public Works 537,209 504,809 574,691 707,977 192,964 Environment & Leisure 1,613,391 1,614,657 1,687,284 1,684,524 1,742,782 Other 28,600,936 30,589,422 31,065,334 31,067,502 26,207,475 Total Revenue 37,471,948 39,326,416 40,334,898 39,777,454 36,013,935 Transfers In 4,544,206 3,761,606 5,070,000 4,670,000 1,670,000 Subtotal 42,016,154 43,088,022 45,404,898 44,447,454 37,683,935 Total Resources Available 53,347,645 55,529,952 58,015,283 58,020,224 48,962,810 Disbursements General Government 4,222,972 4,412,609 4,813,006 4,602,035 4,534,192 Public Safety 19,436,415 19,995,553 22,662,606 21,137,571 24,081,456 Public Works 6,387,054 5,961,380 8,655,812 8,654,451 1,366,450 Environment & Leisure 5,757,468 5,856,663 6,471,621 6,286,812 6,737,539 Other 1,591,475 1,600,679 2,422,391 2,809,156 1,587,642 State Fair Bldg 753,112 753,112 753,500 1,106,324 - Total Disbursements 38,148,495 38,579,996 45,778,936 44,596,349 38,307,279 Transfers Out 2,757,221 3,377,186 2,145,000 2,145,000 3,145,000 Total Requirements 40,905,715 41,957,182 47,923,936 46,741,349 41,452,279 Ending Cash Balance 12,441,930 13,572,770 10,091,346 11,278,875 7,510,531 Unrestricted Cash 11,271,753 11,912,999 8,539,651 11,278,875 7,510,531 Restricted Cash-Food & Drink 1,170,176 1,659,771 1,551,695 - - 12,441,930 13,572,770 10,091,346 11,278,875 7,510,531 GENERAL FUND Grand Island Study Session - 7/19/2016 Page 86 / 99 2014 2015 2016 2016 2017 Actual Actual Budget Forecast Budget ADMINISTRATION CO-PAY HEALTH INSURANCE 4,895 7,220 4,591 4,591 4,963 OTHER REVENUE 86,000 86,000 86,000 86,000 - CREDIT CARD REBATE - 91 - - - 90,895 93,311 90,591 90,591 4,963 CITY CLERK CLERK FEES 33,803 31,019 19,000 30,000 30,000 CO-PAY HEALTH INSURANCE 1,281 1,281 1,195 1,195 1,263 CREDIT CARD REBATE - 78 - - - 35,084 32,377 20,195 31,195 31,263 FINANCE OTHER FEES & SERVICES 14,293 14,975 10,500 14,009 14,000 CO-PAY HEALTH INSURANCE 46,325 40,714 46,487 46,487 50,817 SALARY REIMBURSEMENT 1,417,689 1,249,598 1,477,807 1,477,807 1,679,748 OTHER REVENUE 794 - - - - CREDIT CARD REBATE - 140 3,000 3,000 - 1,479,101 1,305,427 1,537,794 1,541,303 1,744,565 LEGAL STOP CLASS REVENUE 3,825 1,740 5,000 5,000 5,000 CO-PAY HEALTH INSURANCE 4,052 5,794 6,449 6,449 8,048 CREDIT CARD REBATE - 34 - - - 7,877 7,569 11,449 11,449 13,048 CITY HALL CO-PAY HEALTH INSURANCE 1,387 1,618 1,550 1,550 1,687 OTHER REVENUE 78 495 - - - CREDIT CARD REBATE - 11 - - - SALE OF FIXED ASSETS 590,975 - - - - 592,440 2,124 1,550 1,550 1,687 HUMAN RESOURCES CO-PAY HEALTH INSURANCE 7,563 6,391 10,265 10,265 9,926 OTHER REVENUE 12,400 5 - 35 - CREDIT CARD REBATE - 468 507 - - 19,963 6,865 10,772 10,300 9,926 TOTAL GENERAL GOVERNMENT 2,225,359 1,447,672 1,672,351 1,686,388 1,805,452 General Fund Revenue Detail Grand Island Study Session - 7/19/2016 Page 87 / 99 2014 2015 2016 2016 2017 Actual Actual Budget Forecast Budget General Fund Revenue Detail BUILDING INSPECTION BUILDING PERMIT 590,014 702,942 476,000 600,000 615,000 BUILDING LICENSE 54,940 55,604 52,000 55,000 55,000 BACKFLOW REIMBURSEMENT 80,189 83,248 70,000 70,000 70,000 CO-PAY HEALTH INSURANCE 22,697 22,574 19,447 19,447 18,818 OTHER REVENUE 6,755 6,835 5,000 5,000 7,500 CREDIT CARD REBATE - 6 - - - SALE OF FIXED ASSETS 1,700 - - - - 756,295 871,209 622,447 749,447 766,318 FIRE SERVICES HALL COUNTY AMBULANCE CONTRACT - - 196,200 196,200 196,200 FIRE - FEDERAL GRANTS - - - - 553,364 GRANTS-PAYROLL REIMBURSEMENT 10,854 8,352 10,000 13,834 10,000 INSPECTION FEES 52,737 69,879 40,000 65,000 60,000 BURN PERMIT 850 2,000 1,300 1,540 1,300 FIRE - AMBULANCE SERVICE FEES (7,029) 1,405,227 1,405,227 1,405,227 FIRE - OTHER FEES AND SERVICES 18,124 14,990 16,000 16,000 17,000 FIRE - RECOVERY OF BAD DEBTS - - 35,000 35,000 35,000 FIRE - CO-PAY HEALTH INSURANCE 145,913 88,464 143,311 143,311 148,785 FIRE - LOAN PROCEEDS - - 970,000 - 970,000 FIRE - OTHER REVENUE 15,538 44,784 1,000 4,205 1,000 CREDIT CARD REBATE - 512 3,000 - 3,000 FIRE - SALE OF FIXED ASSETS 32,790 585,883 3,000 34,505 3,000 AMBULANCE - COUNTY AMBULANCE CONTRACT 180,000 184,050 - 23 - GRANTS-PAYROLL REIMBURSEMENT - 1,445 - - - AMBULANCE - AMBULANCE SERVICE FEES 1,221,744 1,194,384 - - - AMBULANCE - RECOVERY OF BAD DEBTS 37,964 36,945 - - - AMBULANCE - CO-PAY HEALTH INSURANCE 11,555 65,146 - - - AMBULANCE - OTHER REVENUE 1,962 460 - - - CREDIT CARD REBATE - 450 - - - 1,728,068 2,290,714 2,824,038 1,914,846 3,403,876 POLICE SERVICES WEED ASSESSMENTS - 1,289 1,000 1,000 1,000 WEED ASSESSMENTS INTEREST 100 31 - 66 - FEDERAL GRANTS 368,389 329,067 195,000 195,000 94,500 DOG & CAT LICENSES 36,198 51,606 35,000 36,840 35,000 OTHER INTERGOVERNMENTAL 261,376 253,966 270,000 300,000 335,000 ALCOHOL TESTING 27,805 30,039 25,000 25,000 25,000 STORAGE FEES 98,478 122,941 80,000 80,000 80,000 IMPOUND FEES 24,810 27,355 22,000 22,000 22,000 TOWING CHARGES 79,332 97,524 72,000 72,000 72,000 SALE OF RECORDS 5,246 5,074 4,500 4,500 4,500 WEED MOWING SERVICES 1,715 3,881 2,500 3,500 2,500 OTHER FEES & SERVICES 6,490 5,580 4,200 5,011 4,200 UNCLAIMED PROPERTY 2,328 3,714 2,000 4,000 2,000 CO-PAY HEALTH INSURANCE 212,095 206,256 185,052 185,052 191,744 OTHER REVENUE 32,885 21,669 3,000 43,000 5,000 CREDIT CARD REBATE - 898 1,200 - - SALE OF FIXED ASSETS 19,040 36,445 20,000 20,000 18,000 LAW ENFORCEMENT-OTHER INTERGOV'T 74,826 82,817 76,500 80,000 80,000 LAW ENFORCEMENT-CO-PAY HEALTH INS 2,334 2,334 1,754 1,754 1,878 LAW ENFORCEMENT-OTHER REVENUE - - - - - LAW ENFORCEMENT-CREDIT CARD REBATE - 57 100 100 - POLICE GRANT-OTHER REVENUE - - - - 2,250 1,253,445 1,282,543 1,000,806 1,078,823 976,572 Grand Island Study Session - 7/19/2016 Page 88 / 99 2014 2015 2016 2016 2017 Actual Actual Budget Forecast Budget General Fund Revenue Detail EMERGENCY MANAGEMENT LEPC REIMBURSEMENT - 1,011 - - - COUNTY SHARE OF COMM/CIVIL 502,807 476,774 579,575 579,575 616,137 FEDERAL GRANTS 126,682 117,769 150,000 150,000 150,000 CONTINGENCY GRANTS - - 15,000 15,000 5,000 AMBULANCE SERV FEES COLLECTED - OTHER FEES & SERVICES - DONATIONS & CONTRIBUTIONS - EMERGENCY MGMT-CO-PAY HLTH INS - 8,035 EMERGENCY MGMT-CO-PAY HLTH INS 8,403 - 7,428 7,428 8,048 EMERGENCY MGMT-OTHER REVENUE 20 150 - - - CREDIT CARD REBATE - 75 - - - SALE OF FIXED ASSETS - - - - - ALARM FEES 82,924 77,471 97,000 97,000 97,000 AMBULANCE SERVICE FEES 16,750 21,500 16,000 16,000 16,000 COMMUNICATION CO-PAY HLTH INS 19,661 22,548 22,944 22,944 26,311 COMMUNICATION-OTHER REVENUE - - - - - CREDIT CARD REBATE - 58 - - - 757,247 725,391 887,947 887,947 918,496 TOTAL PUBLIC SAFETY 4,495,054 5,169,856 5,335,238 4,631,063 6,065,262 Grand Island Study Session - 7/19/2016 Page 89 / 99 2014 2015 2016 2016 2017 Actual Actual Budget Forecast Budget General Fund Revenue Detail ENGINEERING ENGINEERING PERMIT 9,644 10,851 8,000 8,000 8,000 LICENSE AGREEMENT FEES 2,165 1,900 2,000 2,000 2,000 ENGINEERING SERVICES 367,400 295,000 300,000 450,000 - MAPS & PRINT SALES 5 50 20 100 100 ADMI CHARGE-LANDFILL - 7,700 38,000 CO-PAY HEALTH INSURANCE 17,938 15,277 18,468 18,468 143,864 OTHER REVENUE 1,628 1,350 1,000 1,000 1,000 CREDIT CARD REBATE - 162 500 - - 398,780 324,590 329,988 487,268 192,964 STREET & ALLEY PAVING PERMIT 17,844 25,210 - - - INCENTIVE PAYMENT 4,000 4,000 27,775 27,775 - SERV & MAINT CONTRACT-STATE 40,815 34,932 8,000 4,000 - OTHER INTERGOVERNMENTAL - - 35,672 35,672 - CO-PAY HEALTH INSURANCE 56,248 55,208 - - - EMPLOYEE WITHHOLDINGS - - 53,236 53,236 - OTHER REVENUE 6,773 11,845 - - - CREDIT CARD REBATE - 843 7,500 7,500 - TRADE IN ALLOW-MACH & EQUIP - 47,588 300 - - TRADE IN ALLOW - VEHICLES - - 105,220 92,526 - SALE OF FIXED ASSETS 12,750 595 7,000 - - 138,429 180,220 244,703 220,709 - TOTAL PUBLIC WORKS 537,209 504,809 574,691 707,977 192,964 PLANNING COUNTY SHARE OF PLANNING 123,880 107,912 - - - FEDERAL GRANTS - - 118,780 118,780 118,780 MAPS & PRINT SALES 1,820 1,405 1,500 1,500 1,500 LETTER OF MAP REVIEW 750 1,100 1,000 1,000 1,000 PLANNING-CO-PAY HEALTH INSURANCE 7,498 7,195 4,973 4,973 5,422 OTHER REVENUE - - - - - CREDIT CARD REBATE - 34 - - - CRA-OTHER FEES & SERVICES 40,399 39,173 41,366 41,366 41,366 CRA-CO-PAY HEALTH INSURANCE - - - - 562 174,347 156,819 167,619 167,619 168,630 LIBRARY STATE GRANTS 8,235 7,834 - - - COPY MACHINE USE FEES 9,639 9,950 8,482 8,482 8,482 FINES & PENALTIES 29,574 27,843 11,330 11,330 15,000 NONRESIDENT CARD FEE 12,046 11,759 36,565 36,565 36,565 CO-PAY HEALTH INSURANCE 26,813 25,256 - - - OTHER REVENUE 8,834 3,921 - - - CREDIT CARD REBATE - 1,518 3,500 3,500 3,500 95,141 88,081 102,800 102,800 99,872 Grand Island Study Session - 7/19/2016 Page 90 / 99 2014 2015 2016 2016 2017 Actual Actual Budget Forecast Budget General Fund Revenue Detail PARKS PARK ADMINISTRATION - CO-PAY HLTH INS 3,197 3,003 3,594 3,594 3,903 PARK ADMINISTRATION - OTHER RENTAL - 184 - - - PARK ADMINISTRATION - CREDIT CARD REBATE - 31 - - - PARK OPERATIONS - CO-PAY HLTH INS 22,877 21,499 22,146 22,146 24,331 PARK OPERATIONS - OTHER REVENUE 46,928 60,023 48,000 58,000 60,000 PARK OPERATIONS - CREDIT CARD REBATE - 160 - - - PARK OPERATIONS - TRADE IN ALLOWANCE 1,500 - - - - PARK OPERATIONS - SALE OF FIXED ASSETS - 711 - - - GREENHOUSE - CO-PAY HEALTH INS 2,958 3,086 2,837 2,837 3,085 CEMETERY BURIAL SERVICES 67,250 83,200 70,000 70,000 80,500 CEMETERY - CO-PAY HEALTH INSURANCE 10,753 11,079 8,978 8,978 11,976 SALE OF CEMETERY LOTS 77,180 53,300 55,000 55,000 63,000 CEMETERY - CREDIT CARD REBATE - 54 - - - 232,643 236,331 210,555 220,555 246,795 RECREATION RECREATION - CO-PAY HEALTH INS 1,026 1,026 953 953 1,055 RECREATAION - CREDIT CARD REBATE - 7 - - - PLAYGROUND REVENUE 8,540 7,760 8,500 8,500 8,500 CHILDREN"S THEATRE REVENUE - - - - 750 FLAG FOOTBALL REVENUE 8,130 7,680 8,000 8,000 8,000 VOLLEYBALL REVENUE 150 SOCCER REVENUE 160 - - - - STOLLEY PARK RAILWAY 13,844 14,461 13,150 13,150 15,600 FIELDHOUSE 254,394 252,998 240,672 228,043 251,729 SWIMMING LESSONS - WATER PARK 13,225 14,000 15,000 14,000 18,000 WATER EQUIP RENTAL-WATER PRK 10,379 9,966 12,000 12,000 12,000 LIFEGUARD REIMBURSE TRAINING 2,844 3,535 2,750 2,750 2,750 CONCESSIONS - WATER PARK 92,494 91,088 100,000 95,000 95,000 SEASON PASSES - WATER PARK 57,277 50,353 65,000 60,000 60,000 ADMISSIONS - WATER PARK 195,024 201,698 240,000 235,000 235,000 GROUP SALES - WATER PARK 24,124 20,767 40,000 35,000 35,000 AQUATIC UNIFORM SALES 3,992 4,424 3,500 4,000 4,000 WATER PARK - CO-PAY HEALTH INS - - 887 887 1,002 SOUVENIR SALES 2,087 2,105 3,000 2,500 2,500 OTHER REVENUE-WATER PARK 2,935 1,292 2,400 2,400 2,400 WATER PARK - CREDIT CARD REBATE - 160 - - - WATER PARK - SALES TAX - - - - - SWIMMING LESSONS - LINCOLN POOL 9,325 9,550 10,000 9,500 12,000 ADMISSIONS - LINCOLN POOL 37,178 37,622 37,000 37,000 37,000 OTHER REVENUE-LINCOLN POOL 409 329 400 400 400 737,388 730,972 803,212 769,083 802,686 PUBLIC INFORMATION CABLE T.V. FRANCHISE FEES 43,947 43,263 45,000 45,000 45,000 CO-PAY HEALTH INSURANCE 3,615 3,111 596 2,440 - OTHER REVENUE 40 260 200 200 200 CREDIT CARD REBATE - 54 - - - 47,602 46,687 45,796 47,640 45,200 Grand Island Study Session - 7/19/2016 Page 91 / 99 2014 2015 2016 2016 2017 Actual Actual Budget Forecast Budget General Fund Revenue Detail HEARTLAND PUBLIC SHOOTING PARK MEMBERSHIP FEES 1,545 - - - - SPECIAL EVENTS REVENUE 189,723 250,985 205,000 260,000 260,000 SPORTING CLAY REVENUE 12,276 11,417 14,000 12,000 12,000 SPORTING CLAY REV-PUNCH CARDS 737 854 1,700 1,000 1,000 SPORTING CLAY REVENUE-YOUTH 4,121 6,140 4,250 6,500 7,000 SPORTING CLAY LEAGUE - 775 - - TRAP REVENUE 5,479 5,017 6,300 5,000 5,000 TRAP REVENUE-PUNCH CARDS 1,826 676 1,800 1,000 1,000 TRAP REVENUE-YOUTH 23,074 5,665 25,000 6,000 6,000 TRAP LEAGUE - 2,000 - - SKEET REVENUE 4,647 3,375 5,000 4,000 4,000 SKEET REVENUE-PUNCH CARDS 5,949 4,713 6,250 5,000 5,000 SHEET REVENUE-YOUTH 1,779 2,178 1,800 2,500 3,000 SKEET LEAGUE - 2,500 - - 5-STAND REVENUE 272 868 1,000 1,000 1,000 5-STAND REVENUE-YOUTH 24 191 300 300 300 SHOTGUN SHELL REVENUE 2,000 2,438 4,000 2,500 2,500 RIFLE-PISTOL LEAGUES 760 190 1,250 250 250 RIFLE-PISTOL REVENUE 20,204 18,765 27,000 25,000 25,000 ARCHERY REVENUE 718 362 1,000 500 1,000 MISC MERCHANDISE SALES 2,938 2,170 3,600 3,000 3,000 CART RENTAL FEE 6,370 6,322 6,000 6,400 6,500 CAMPING-RV FEES 4,389 4,735 4,400 5,000 5,500 OTHER RENTAL 3,129 1,723 6,500 3,000 3,000 DONATIONS & CONTRIBUTIONS 29,210 18,384 20,000 20,000 20,000 CONCESSIONS - SHOOT PARK 1,408 2,903 2,000 3,000 3,500 CO-PAY HEALTH INSURANCE 3,390 5,520 3,377 3,377 3,549 OTHER REVENUE 305 4 500 500 500 CREDIT CARD REBATE - 172 - - - 326,270 355,766 357,302 376,827 379,599 TOTAL ENVIRONMENT AND LEISURE 1,613,391 1,614,657 1,687,284 1,684,524 1,742,782 NONDEPARTMENTAL PROPERTY TAXES 7,027,318 7,859,984 8,357,940 8,357,940 6,066,889 MOTOR VEHICLE TAX 898,891 959,776 951,492 951,492 951,492 NATURAL GAS FRANCHISE 584,860 536,553 624,247 600,000 600,000 WIRELESS FRANCHISE 415,735 386,902 403,000 403,000 403,000 TELEPHONE FRANCHISE 89,577 101,140 100,000 100,000 100,000 FOOD & BEV OCCUPATION TAX 1,495,391 1,613,485 1,631,847 1,631,847 - CABLE T.V. FRANCHISE 527,759 555,349 550,000 550,000 550,000 LIQUOR OCCUPATION TAX 67,400 68,800 64,255 64,255 64,255 OTHER FRANCHISE TAXES 850 1,000 1,000 1,000 1,000 GENERAL SALES TAX 14,158,896 15,169,437 14,842,843 14,842,843 15,213,914 MOTOR VEHICLE SALES TAX 1,254,505 1,227,107 1,330,025 1,330,025 - MUNICIPAL EQUILIZATION FUNDS 507,332 425,821 589,075 589,075 580,000 ADMIN CHARGE - PLANNING 1,200 1,200 1,200 1,200 1,200 ADMIN CHARGE - LANDFILL 32,057 38,317 33,000 33,000 33,000 ADMIN CHARGE - GOLF COURSE 12,943 12,253 14,580 14,580 14,580 ADMIN CHARGE FOR SERV - ELEC 1,045,965 1,061,267 1,064,520 1,064,520 1,064,520 ADMIN CHARGE FOR SERV-WATER 92,076 88,671 92,610 92,610 92,610 ADMIN CHARGE FOR SERV-SEWER 221,481 268,069 264,000 264,000 264,000 COPY MACHINE USE FEES - - 15 15 15 OTHER RENTAL 11,000 11,000 11,000 11,000 11,000 INTEREST & DIVIDEND REVENUE 64,036 62,071 33,585 60,000 60,000 OTHER REVENUE 27,189 75,843 25,000 25,000 25,000 CREDIT CARD REBATE 58 100 100 31,000 SALES TAX 64,476 65,318 80,000 80,000 80,000 28,600,936 30,589,422 31,065,334 31,067,502 26,207,475 Total General Fund Revenues 37,471,948 39,326,416 40,334,898 39,777,454 36,013,935 Grand Island Study Session - 7/19/2016 Page 92 / 99 2014 2015 2016 2016 2017 Actual Actual Budget Forecast Budget General Government City Administrator's Office 356,121 470,673 422,053 419,095 424,930 Economic Development 375,001 466,070 525,000 525,000 100,000 Mayor's Office 16,371 18,713 24,865 25,583 23,365 Legislative 86,182 90,823 93,471 93,805 93,471 City Clerk 122,011 134,279 144,769 141,404 146,551 Finance 2,106,300 2,098,170 2,152,104 1,982,563 2,243,773 Legal 317,303 328,411 366,156 374,853 395,709 City Hall 341,820 367,498 500,383 471,891 547,168 Human Resources 501,863 437,973 584,205 567,840 559,225 4,222,972 4,412,609 4,813,006 4,602,035 4,534,192 Public Safety Building Inspection 865,464 875,497 943,051 887,900 960,784 Fire Services 4,080,223 4,217,032 8,858,561 7,678,637 10,000,321 Emergency Medical Services 3,068,772 3,114,430 - - - Police 10,275,570 10,492,938 11,401,155 11,185,462 11,585,104 Emergency Management 1,146,386 1,295,656 1,459,839 1,405,039 1,535,247 19,436,415 19,995,553 22,662,606 21,157,038 24,081,456 Public Works Engineering 1,036,639 1,116,026 1,441,795 1,420,726 1,366,450 Streets & Transportation 5,350,415 4,845,354 7,214,017 7,233,725 - 6,387,054 5,961,380 8,655,812 8,654,451 1,366,450 Environment & Leisure Planning 265,578 278,975 304,862 303,422 320,526 Library 1,777,408 1,751,799 1,963,214 1,901,334 2,046,548 Parks 1,629,560 1,552,809 1,852,419 1,777,517 1,966,797 Cemetery 472,894 543,525 547,856 547,735 555,469 Recreation 395,348 449,876 459,096 438,657 479,955 Aquatics 556,694 564,764 598,939 597,644 601,324 Public Information 173,475 188,721 234,466 214,867 223,332 Heartland Shooting Park 486,510 526,193 510,769 505,635 543,588 5,757,468 5,856,663 6,471,621 6,286,812 6,737,539 Non-Department Non-Department 2,344,586 2,353,791 3,175,891 3,915,481 1,587,642 Total General Fund Appropriation 38,148,495 38,579,996 45,778,936 44,615,815 38,307,279 General Fund Appropriation Summary Grand Island Study Session - 7/19/2016 Page 93 / 99 2014 2015 2016 2016 2017 Actual Actual Budget Forecast Budget General Government City Administrator's Office Personnel Services 289,484 358,287 361,156 355,632 368,955 Operating Expenses 59,423 100,887 60,897 63,463 55,975 Capital Outlay 7,214 11,499 - - - Total City Administrator's Office 356,121 470,673 422,053 419,095 424,930 Economic Development Operating Expenses 375,001 466,070 525,000 525,000 100,000 Total Economic Development 375,001 466,070 525,000 525,000 100,000 Mayor's Office Personnel Services 14,015 16,465 17,247 17,965 17,247 Operating Expenses 2,356 2,248 7,618 7,618 6,118 Total Mayor's Office 16,371 18,713 24,865 25,583 23,365 Council Personnel Services 75,524 80,166 84,072 83,675 84,072 Operating Expenses 10,657 10,657 9,399 10,130 9,399 Total Legislative 86,182 90,823 93,471 93,805 93,471 City Clerk Personnel Services 90,968 98,243 106,529 99,940 108,311 Operating Expenses 31,042 36,037 38,240 41,464 38,240 Total City Clerk 122,011 134,279 144,769 141,404 146,551 Finance Personnel Services 1,803,101 1,690,673 2,059,854 1,886,591 2,153,523 Operating Expenses 303,199 407,497 92,250 95,972 90,250 Total Finance 2,106,300 2,098,170 2,152,104 1,982,563 2,243,773 Legal Personnel Services 282,420 304,035 334,216 342,913 366,269 Operating Expenses 34,883 24,376 31,940 31,940 29,440 Total Legal 317,303 328,411 366,156 374,853 395,709 City Hall Personnel Services 89,672 104,216 113,179 104,687 124,964 Operating Expenses 182,300 242,281 367,204 367,204 352,204 Capital Outlay 69,848 21,001 20,000 - 70,000 Total City Hall 341,820 367,498 500,383 471,891 547,168 Human Resources Personnel Services 369,943 326,868 425,196 390,831 425,091 Operating Expenses 85,856 67,430 159,009 177,009 134,134 Capital Outlay 46,064 43,675 - - - Total Personnel 501,863 437,973 584,205 567,840 559,225 GENERAL GOVERNMENT Personnel Services 3,015,128 2,978,952 3,501,449 3,282,234 3,648,432 Operating Expenses 1,084,718 1,357,484 1,291,557 1,319,801 815,760 Capital Outlay 123,126 76,174 20,000 - 70,000 TOTAL GENERAL GOVERNMENT 4,222,972 4,412,609 4,813,006 4,602,035 4,534,192 General Fund Appropriation Detail Grand Island Study Session - 7/19/2016 Page 94 / 99 2014 2015 2016 2016 2017 Actual Actual Budget Forecast Budget General Fund Appropriation Detail Public Safety Building Inspection Personnel Services 797,815 816,857 867,701 811,415 885,434 Operating Expenses 50,158 41,211 75,350 76,485 75,350 Capital Outlay 17,491 17,429 - - - Total Building Inspection 865,464 875,497 943,051 887,900 960,784 Fire Services Personnel Services 3,628,328 3,824,176 7,012,652 6,950,454 7,323,312 Operating Expenses 347,351 337,794 629,725 686,842 599,461 Capital Outlay 104,544 55,062 1,216,184 41,341 2,077,548 Total Fire Services 4,080,223 4,217,032 8,858,561 7,678,637 10,000,321 Emergency Medical Services Personnel Services 2,582,319 2,850,063 - - - Operating Expenses 261,231 248,088 - - - Capital Outlay 225,222 16,279 - - - Total Emergency Medical Services 3,068,772 3,114,430 - - - Police Personnel Services 8,325,001 8,648,935 9,536,648 9,394,110 9,907,254 Operating Expenses 1,632,784 1,563,423 1,596,892 1,523,737 1,544,850 Capital Outlay 317,785 280,581 267,615 267,615 133,000 Total Police 10,275,570 10,492,938 11,401,155 11,185,462 11,585,104 Emergency Management Personnel Services 1,075,218 1,163,001 1,292,449 1,219,559 1,369,547 Operating Expenses 56,141 53,320 87,390 90,480 85,700 Capital Outlay 15,027 79,334 80,000 95,000 80,000 Total Emergency Management 1,146,386 1,295,656 1,459,839 1,405,039 1,535,247 PUBLIC SAFETY Personnel Services 16,408,681 17,303,032 18,709,450 18,375,538 19,485,547 Operating Expenses 2,347,666 2,243,835 2,389,357 2,377,544 2,305,361 Capital Outlay 680,068 448,685 1,563,799 403,956 2,290,548 TOTAL PUBLIC SAFETY 19,436,415 19,995,553 22,662,606 21,157,038 24,081,456 Grand Island Study Session - 7/19/2016 Page 95 / 99 2014 2015 2016 2016 2017 Actual Actual Budget Forecast Budget General Fund Appropriation Detail Public Works Engineering Personnel Services 946,789 902,800 1,057,202 1,050,505 992,700 Operating Expenses 89,850 188,293 378,593 365,333 373,750 Capital Outlay - 24,933 6,000 4,888 - Total Engineering 1,036,639 1,116,026 1,441,795 1,420,726 1,366,450 Streets & Transportation Personnel Services 1,920,251 2,089,856 2,161,511 2,116,072 - Operating Expenses 3,151,363 2,405,285 4,467,995 4,558,142 - Capital Outlay 278,802 350,213 584,511 559,511 - Total Streets & Transportation 5,350,415 4,845,354 7,214,017 7,233,725 - PUBLIC WORKS Personnel Services 2,867,040 2,992,656 3,218,713 3,166,577 992,700 Operating Expenses 3,241,212 2,593,578 4,846,588 4,923,475 373,750 Capital Outlay 278,802 375,146 590,511 564,399 - TOTAL PUBLIC WORKS 6,387,054 5,961,380 8,655,812 8,654,451 1,366,450 Environment & Leisure Planning Personnel Services 248,754 260,048 283,646 281,271 299,310 Operating Expenses 16,825 18,928 21,216 22,151 21,216 Total Planning 265,578 278,975 304,862 303,422 320,526 Library Personnel Services 1,196,934 1,190,328 1,365,827 1,303,359 1,532,920 Operating Expenses 568,127 561,471 552,387 552,975 498,628 Capital Outlay 12,347 - 45,000 45,000 15,000 Total Library 1,777,408 1,751,799 1,963,214 1,901,334 2,046,548 Parks Personnel Services 1,113,626 1,165,663 1,350,909 1,286,405 1,445,417 Operating Expenses 386,141 387,146 401,510 390,628 408,380 Capital Outlay 129,793 - 100,000 100,484 113,000 Total Parks 1,629,560 1,552,809 1,852,419 1,777,517 1,966,797 Cemetery Personnel Services 394,242 408,192 452,279 452,908 494,869 Operating Expenses 63,622 61,593 59,577 58,827 60,600 Capital Outlay 15,030 73,740 36,000 36,000 - Total Cemetery 472,894 543,525 547,856 547,735 555,469 Recreation Personnel Services 274,521 286,671 333,771 307,719 354,255 Operating Expenses 120,827 137,718 125,325 130,938 125,700 Capital Outlay - 25,487 - - - Total Recreation 395,348 449,876 459,096 438,657 479,955 Grand Island Study Session - 7/19/2016 Page 96 / 99 2014 2015 2016 2016 2017 Actual Actual Budget Forecast Budget General Fund Appropriation Detail Aquatics Personnel Services 355,805 368,166 386,149 386,149 395,034 Operating Expenses 200,889 196,598 212,790 211,495 206,290 Total Aquatics 556,694 564,764 598,939 597,644 601,324 Public Information Personnel Services 143,720 146,948 177,632 168,549 178,872 Operating Expenses 29,755 41,773 44,834 46,318 44,460 Capital Outlay - - 12,000 - - Total Public Information 173,475 188,721 234,466 214,867 223,332 Heartland Shooting Range Personnel Services 206,674 273,184 283,869 287,571 290,688 Operating Expenses 275,321 253,009 226,900 218,064 237,900 Capital Outlay 4,515 - - - 15,000 Total Heartland Shooting Range 486,510 526,193 510,769 505,635 543,588 ENVIRONMENT & LEISURE Personnel Services 3,934,275 4,099,199 4,634,082 4,473,931 4,991,365 Operating Expenses 1,661,507 1,658,235 1,644,539 1,631,396 1,603,174 Capital Outlay 161,686 99,228 193,000 181,484 143,000 TOTAL ENVIRONMENT & LEISURE 5,757,468 5,856,663 6,471,621 6,286,812 6,737,539 Non-Department Non-Department Personnel Services - - - - - Operating Expenses 276,894 281,937 1,108,438 1,118,159 1,070,438 Capital Outlay 2,067,692 2,071,854 2,067,453 2,797,322 517,204 TOTAL NON-DEPARTMENT 2,344,586 2,353,791 3,175,891 3,915,481 1,587,642 Total General Fund Appropriation Personnel Services 26,225,124 27,373,839 30,063,694 29,298,279 29,118,044 Operating Expenses 8,611,997 8,135,070 11,280,479 11,370,375 6,168,483 Capital Outlay-Departments 1,243,682 999,233 2,367,310 1,149,839 2,299,864 Captial Outlay-Debt 2,067,692 2,071,854 2,067,453 2,797,322 720,888 TOTAL GENERAL FUND 38,148,495 38,579,996 45,778,936 44,615,815 38,307,279 General Government:4,534,192 Public Safety:24,081,456 Public Works:1,366,450 Environment & Leisure:6,737,539 Non-Department:1,587,642 Total General Fund:38,307,279 General Government: 11.84% Public Safety: 62.86% Public Works: 3.57% Environment & Leisure: 17.59% Non- Department: 4.14% Grand Island Study Session - 7/19/2016 Page 97 / 99 2016 2016 2017 Budget Forecast Budget CITY HALL/BUILDING INSPECTIONS BLDG Building improvement 10011701 85612 - - 70,000 VEH Pick-up for snow removal 10011701 85625 20,000 - - CITY HALL/BUILDING INSPECTIONS TOTAL 20,000 - 70,000 FIRE/AMBULANCE SERVICES LAND IMP Training Tower 10022101 85608 - - 533,364 LAND IMP Training Tower with burn room - match and ground work 10022101 85608 - - 100,000 Subtotal - - 633,364 M & E Jaws 10022101 85615 - - 40,000 M & E Cardiac Moniotrs (6 units)10022101 85615 - - 150,000 M & E Radios 10022101 85615 42,500 41,341 32,000 M & E Compressor for Station 4 10022101 85615 - - 48,500 Subtotal 42,500 41,341 270,500 VEH 2016 Braun XL Chief Type 3 Ambulance 10022101 85625 220,000 - 220,000 VEH 75 foot Quint without CAFS 10022101 85625 750,000 - 750,000 Subtotal 970,000 - 970,000 FIRE/AMBULANCE SERVICES TOTAL 1,012,500 41,341 1,873,864 POLICE SERVICES VEH Police Vehicles-6 Vehicles 10022301 85625 168,000 168,000 92,600 VEH Police Vehicles-1 Vehicle, replace damaged patrol car 10022301 85625 27,000 27,000 - VEH Ford Fusion - Administration 10022301 85625 18,500 18,500 22,200 VEH Replacement CID SUV 10022301 85625 25,000 25,000 18,200 VEH Replacement Patrol SUV-Explorer 10022301 85625 29,115 29,115 - POLICE TOTAL 267,615 267,615 133,000 EMERGENCY MANAGEMENT M&E Outdoor Warning Sirens (2)10022601 85615 30,000 30,000 30,000 M&E Voting Repeater System 10022605 85615 35,000 50,000 - M&E Readio Repeater 10022601 85615 - - 50,000 M&E Second Operations Repeater (Ops2)10022601 85615 15,000 15,000 - EMERGENCY MANAGEMENT TOTAL 80,000 95,000 80,000 GENERAL FUND-CAPITAL Account Number Grand Island Study Session - 7/19/2016 Page 98 / 99 2016 2016 2017 Budget Forecast Budget GENERAL FUND-CAPITAL Account Number STREET AND ALLEY BLDG IMP Roof at West Yard, Main Building 10033501 85612 20,000 20,000 - Subtotal 20,000 20,000 - M & E Dump Truck 10033501 85615 - - - M & E One-ton Pickup, Flatbed 10033501 85615 - - - M & E Mastic Kettle/Applicator 10033501 85615 - - - M & E Roller (vibratory, steel rum)10033501 85615 - - - M & E Tractor 10033501 85615 - - - M & E Portable Video Inspection Equip for Sewer 10033501 85615 20,000 20,000 - M & E Backhoe Loader 10033501 85615 85,000 85,000 - M & E 11' reversible Snow Plow and Frame (6)10033501 85615 60,000 60,000 - M & E Motor grader 10033501 85615 25,000 - - M & E Heated Rubber Asphalt Crack Sealing Machine 10033501 85615 35,000 35,000 - M & E Snow Blower, Front-End Loader Mounted 10033501 85615 15,972 15,972 - M & E Asphalt Reclaiming/Trenching Machine 10033501 85615 22,415 22,415 - M & E Skid Steer Loader (track,buy back program)10033501 85615 47,500 47,500 - M & E Skid Steer Loader (tire, intital purchase for buy back program)10033501 85615 32,500 32,500 - Subtotal 343,387 318,387 - VEH Bucket Truck for Traffic Signals 10033501 85625 131,624 131,624 - VEH Sewer Combo Unit - Lease Purchase 10033501 85625 37,500 37,500 - VEH 1/2 Ton Pick-up 10033501 85625 30,000 30,000 - Subtotal 199,124 199,124 - STORM Storm Sewer Infrastructure Rehab/Improvement 10033501 85650 22,000 22,000 - Subtotal 22,000 22,000 - STREET AND ALLEY TOTAL 584,511 559,511 - LIBRARY OFF EQ IT Equipment 10044301 85620 45,000 45,000 25,000 LIBRARY TOTAL 45,000 45,000 25,000 M & E (2) 72" Rotary Mowers 10044403 85615 - - - M & E One 10' rotary mowers 10044403 85615 60,000 45,889 - M & E Six Heckendorn 36" Mowers 10044405 85615 36,000 36,000 - Subtotal 96,000 81,889 - VEH Utility Vehicle 10044801 85625 - - - VEH 3/4 Ton 4x4 with snow plow 10044405 85625 - - 45,000 VEH 4x4 one ton dump truck with snow plow 10044403 85625 - - 55,000 VEH Half-ton Pickup #1 10044403 85625 20,000 27,297 - VEH Half-ton Pickup #2 10044403 85625 20,000 27,298 - Subtotal 40,000 54,595 100,000 TOTAL PARKS & RECREATION 136,000 136,484 100,000 2,145,626 1,144,951 2,281,864 PARKS & RECREATION GENERAL FUND TOTAL Grand Island Study Session - 7/19/2016 Page 99 / 99