Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
Tab 5: Preliminary Capital Improvement Plan & Five-Year Forecast (2015-2019)
a m 4ATME" Im CAPITAL IMPROVEMENT PLAN (2015 - 2019) VILLAGE OF MOUNT PROSPECT 2015 - 2019 CAPITAL IMPROVEMENTS PLAN SUMMARY OF PROJECT REQUESTS Recapitulation by Department Department 2015 2016 2017 2018 2019 Total Administration 0 0 0 0 0 0 Community Development 700,000 550,000 550,000 550,000 550,000 2,900,000 Fire 185,000 0 250,000 75,000 78,000 588,000 Police 185,000 561,000 70,000 115,000 200,000 1,131,000 Public Works 13,070,823 16,021,031 9,963,795 10,174,479 11,640,026 60,870,154 Information Technology 330,252 211,059 113,900 94,742 55,419 805,372 Total 14,471,075 17,343,090 10,947,695 11,009,221 12,523,445 66,294,526 A -1 VILLAGE OF MOUNT PROSPECT 2015 - 2019 CAPITAL IMPROVEMENT PLAN SUMMARY OF PROJECT REQUESTS Department: Administration Page Project Dept. Project Name No. Type 2015 Priority 2016 2017 2018 No Projects Anticipated for this Capital Improvement Plan (E) = Established Project (1) = New Project (•) = Federal Mandate Project Type Codes: 700 = Water System 701 = Sanitary Sewer 702 = Flood Control Projects 703 = Storm Sewer 704 = Street Construction and Reconstruction 705 = Resurfacing/Curbs and Gutters /Sidewalks 2019 Total 706 = Construction of and Improvements to Public Buildings 707 = Computer Hardware /Software 708 = Vehicles and Automotive Equipment 709 = Non- Automotive Equipment 710 = Miscellaneous A -2 VILLAGE OF MOUNT PROSPECT 2015 - 2019 CAPITAL IMPROVEMENTS PLAN SUMMARY OF PROJECT REQUESTS Department: Community Development (N) = New Project (E) = Established Project ( *) = Federal Mandate Project Type Codes: 700 = Water System 706 = Construction of and Improvements to Public Buildings 701 = Sanitary Sewer 707 = Computer Hardware /Software 702 = Flood Control Projects 708 = Vehicles and Automotive Equipment 703 = Storm Sewer 709 = Non - Automotive Equipment 704 = Street Construction and Reconstruction 710 = Miscellaneous 705 = Resurfacing/Curbs and Gutters /Sidewalks A -3 Page Project Dept. Project Name No. Type 2015 Priority 2016 2017 2018 2019 Total Fagade/Interior Buildout Program (E) C -2 710 100,000 1 100,000 100,000 100,000 100,000 500,000 Corridor Improvements (E) C -3 704 200,000 2 250,000 250,000 250,000 250,000 1,200,000 Downtown Wayside Signage (N) C -4 710 200,000 3 0 0 0 0 200,000 Downtown Pedestrian Impr. (I) C -5 704 200,000 4 200,000 200,000 200,000 200,000 1,000,000 Total 700,000 550,000 550,000 550,000 550,000 2,900,000 (N) = New Project (E) = Established Project ( *) = Federal Mandate Project Type Codes: 700 = Water System 706 = Construction of and Improvements to Public Buildings 701 = Sanitary Sewer 707 = Computer Hardware /Software 702 = Flood Control Projects 708 = Vehicles and Automotive Equipment 703 = Storm Sewer 709 = Non - Automotive Equipment 704 = Street Construction and Reconstruction 710 = Miscellaneous 705 = Resurfacing/Curbs and Gutters /Sidewalks A -3 VILLAGE OF MOUNT PROSPECT 2015 - 2019 CAPITAL IMPROVEMENTS PLAN SUMMARY OF PROJECT REQUESTS Department: Fire 2016 Page Project 2019 Dept. Project Name No. Type 2015 Priority Village Warning Sirens (N) D -2 710 90,000 1 SCBA Bottles (1) D -3 709 70,000 2 Fitness Treadmills (I) D -4 709 25,000 3 Hose and Appliances (N) D -5 709 0 N/A Cardiac Monitors (N) D -6 709 0 N/A Safety Trailer (I) D -7 708 0 N/A SCBA Facepiece (1) D -8 709 0 N/A Cardiac Monitors (N) D -9 708 0 N/A Total 185,000 2016 2017 2018 2019 Total 0 0 0 0 90,000 0 0 0 0 70,000 0 25,000 0 0 50,000 0 25,000 0 0 25,000 0 200,000 0 0 200,000 0 0 75,000 0 75,000 0 0 0 63,000 63,000 0 0 0 15,000 15,000 0 250,000 75,000 78,000 588,000 (N) = New Project (E) = Established Project ( *) = Federal Mandate Project Type Codes: 700 = Water System 701 = Sanitary Sewer 702 = Flood Control Projects 703 = Storm Sewer 704 = Street Construction and Reconstruction 705 = Resurfacing/Curbs and Gutters /Sidewalks 706 = Construction of and Improvements to Public Buildings 707 = Computer Hardware /Software 708 = Vehicles and Automotive Equipment 709 = Non - Automotive Equipment 710 = Miscellaneous A -4 VILLAGE OF MOUNT PROSPECT 2015 - 2019 CAPITAL IMPROVEMENTS PLAN SUMMARY OF PROJECT REQUESTS Department: Police Project Name Page Project No. Type 2016 Dept. 2015 Priority 44,000 1 21,000 2 120,000 3 0 N/A 0 N/A 0 N/A 0 N/A 185,000 0 2016 2017 2018 2019 Total 706 Firing Range Control System (N) 40,000 0 0 0 84,000 21,000 0 0 0 42,000 0 0 0 0 120,000 500,000 0 0 0 500,000 0 70,000 0 0 70,000 0 0 115,000 0 115,000 0 0 0 200,000 200,000 561,000 70,000 115,000 200,000 1,131,000 Furniture Replacement (E) E -2 709 Restroom Renovations (E) E -3 706 Firing Range Control System (N) E -4 706 Admin Section Renovation (N) E -5 706 Renovate Roll Call Room (I) E -6 706 Public Safety Lobby/Bathrooms (N) E -7 706 Evidence Lab E -8 706 Total (E) = Established Project (I) = New Project ( *) = Federal Mandate Project Type Codes: 700 = Water System 701 = Sanitary Sewer 702 = Flood Control Projects 703 = Storm Sewer 704 = Street Construction and Reconstruction 705 = Resurfacing/Curbs and Gutters /Sidewalks 706 = Construction of and Improvements to Public Buildings 707 = Computer Hardware /Software 708 = Vehicles and Automotive Equipment 709 = Non - Automotive Equipment 710 = Miscellaneous A -5 VILLAGE OF MOUNT PROSPECT 2015 - 2019 CAPITAL IMPROVEMENTS PLAN SUMMARY OF PROJECT REQUESTS Department: Public Works A -6 Page Project Dept. Project Name No. Type 2015 Priority 2016 2017 2018 2019 Total Street Improvement Program (E) F -2 705 4,218,000 1 4,442,000 4,472,000 4,502,000 4,532,000 22,166,000 Combined Sewer Improvements (E) F -3 701 1,000,000 2 0 0 0 0 1,000,000 Flood Control Program (E) F -4 702 215,000 3 1,550,000 50,000 80,000 50,000 1,945,000 Sidewalk Cost Share Program (E) F -5 705 86,700 4 88,400 90,200 92,000 93,800 451,100 New Sidewalks (E) F -6 705 120,000 5 140,000 160,000 190,000 220,000 830,000 Traffic Improvements (N) F -7 710 245,000 6 180,000 50,000 50,000 50,000 575,000 Other Public Buildings (E) F -8 706 160,000 7 155,000 160,000 160,000 165,000 800,000 Streetlight Improvements 2 (E) F -9 710 125,000 8 125,000 125,000 125,000 125,000 625,000 Detention Pond Improvements (E) F -10 703 900,000 9 810,000 490,000 300,000 270,000 2,770,000 Ash Replacement Plantings (N) F -11 710 116,969 10 90,066 42,460 0 0 249,495 Ash Tree & Stump Removals (N) F -12 710 179,760 11 125,832 53,928 0 0 359,520 Water Facility Roof Rehab (N) F -13 706 65,000 12 65,000 70,000 70,000 0 270,000 Storm Sewer Inspection Program (N) F -14 703 100,000 13 100,000 100,000 100,000 100,000 500,000 Booster Station (N) F -15 700 55,000 14 55,000 55,000 55,000 55,000 275,000 Levee 37 (E) F -16 702 30,000 15 35,000 40,000 40,000 45,000 190,000 VH Parking Deck Maintenance (N) F -17 706 50,000 16 50,000 50,000 50,000 50,000 250,000 Wireless Telemtetry Upgrade (N) F -18 700 70,000 17 75,000 110,000 115,000 75,000 445,000 Residential AMR/AMI (N) F -19 700 1,000,000 18 0 0 0 0 1,000,000 HVAC Replacement Program (N) F -20 706 25,000 19 50,000 50,000 275,000 25,000 425,000 Traffic Signal Replacement (E) F -21 704 98,000 20 385,000 585,000 440,000 50,000 1,558,000 Brick Sidewalk Sealing (E) F -22 705 75,000 21 75,000 75,000 75,000 75,000 375,000 Tree Planting Program (E) F -23 710 163,394 22 179,733 197,707 217,479 239,226 997,539 Neighborhood Drainage Improv. (N) F -24 702 100,000 23 100,000 100,000 100,000 100,000 500,000 Infrastructure Aesthetics (N) F -25 710 40,000 24 40,000 40,000 40,000 40,000 200,000 Sewer Main Rehabilitation (E) F -26 701 500,000 25 525,000 550,000 550,000 550,000 2,675,000 KBC Jogging Path Rehab (N) F -27 710 350,000 26 205,000 0 0 0 555,000 Melas/Meadows Ped. Bridge (N) F -28 710 140,000 27 2,900,000 0 0 0 3,040,000 PW Roof Repair (N) F -29 706 470,000 28 1,030,000 0 0 0 1,500,000 Water Main Replacement (E) F -30 700 1,200,000 29 600,000 600,000 600,000 4,000,000 7,000,000 Salt Storage Building (N) F -31 706 600,000 30 0 0 0 0 600,000 Lift Station Rehab (N) F -32 701 325,000 31 350,000 650,000 450,000 325,000 2,100,000 Parking Lot Improvements (E) F -33 706 58,000 32 0 25,000 0 0 83,000 PW Radio System (N) F -34 709 65,000 33 0 0 0 0 65,000 Bridge Rehab (N) F -35 710 125,000 34 0 0 0 0 125,000 NW Hwy Bike Rte/Ped Signals (N) F -36 705 0 N/A 75,000 0 0 0 75,000 Water Tank Rehabilitation (E) F -37 700 0 N/A 650,000 0 675,000 0 1,325,000 Deep Well Rehab (E) F -38 700 0 N/A 300,000 0 315,000 0 615,000 Leak Detecting Euipment (N) F -39 700 0 N/A 75,000 0 0 0 75,000 HVAC Upgrade - VH F -40 706 0 N/A 395,000 0 0 0 395,000 PS Training Rm Rehab (N) F -41 706 0 N/A 0 86,000 0 0 86,000 Streetscape Improvements (N) F -42 705 0 N/A 0 200,000 0 0 200,000 PW Vehicle Lifts (N) F -43 708 0 N/A 0 102,500 98,000 0 200,500 A -6 VILLAGE OF MOUNT PROSPECT 2015 - 2019 CAPITAL IMPROVEMENTS PLAN SUMMARY OF PROJECT REQUESTS Department: Public Works (N) = New Project (E) = Established Project Project Type Codes 700 = Water System 706 = Construction of and Improvements to Public Buildings 701 = Sanitary Sewer 707 = Computer Hardware /Software 702 = Flood Control Projects 708 = Vehicles and Automotive Equipment 703 = Storm Sewer 709 = Non - Automotive Equipment 704 = Street Construction and Reconstruction 710 = Miscellaneous 705 = Resurfacing/Curbs and Gutters /Sidewalks A -7 Page Project Dept. Project Name No. Type 2015 Priority 2016 2017 2018 2019 Total Public Safety Garage Sprinkler (N) F -44 706 0 N/A 0 44,000 0 0 44,000 Levee 37 Emer Generators (N) F -45 702 0 N/A 0 210,000 175,000 0 385,000 Public Safety Parking Deck (N) F -46 706 0 N/A 0 250,000 0 0 250,000 Televising System Upgrades (N) F -47 709 0 N/A 0 80,000 80,000 0 160,000 PW Exterior Bldg Improv. (N) F -48 706 0 N/A 0 0 40,000 200,000 240,000 Hydro Excavator (N) F -49 709 0 N/A 0 0 115,000 0 115,000 VH Window Replacement (N) F -50 706 0 N/A 0 0 0 205,000 205,000 Total 13,070,823 16,021,031 9,963,795 10,174,479 11,640,026 60,870,154 (N) = New Project (E) = Established Project Project Type Codes 700 = Water System 706 = Construction of and Improvements to Public Buildings 701 = Sanitary Sewer 707 = Computer Hardware /Software 702 = Flood Control Projects 708 = Vehicles and Automotive Equipment 703 = Storm Sewer 709 = Non - Automotive Equipment 704 = Street Construction and Reconstruction 710 = Miscellaneous 705 = Resurfacing/Curbs and Gutters /Sidewalks A -7 VILLAGE OF MOUNT PROSPECT 2015 - 2019 CAPITAL IMPROVEMENTS PLAN SUMMARY OF PROJECT REQUESTS Department: IT (N) = New Project (E) = Established Project ( *) = Federal Mandate Project Type Codes: 700 = Water System 701 = Sanitary Sewer 702 = Flood Control Projects 703 = Storm Sewer 704 = Street Construction and Reconstruction 705 = Resurfacing/Curbs and Gutters /Sidewalks 706 = Construction of and Improvements to Public Buildings 707 = Computer Hardware /Software 708 = Vehicles and Automotive Equipment 709 = Non - Automotive Equipment 710 = Miscellaneous on Page Project Name No. Dept. 2015 2016 2017 2018 2019 Total PC for Conference Room (N) G -2 Fin 1,400 0 0 0 0 1,400 Laptop for DD (1) G -3 Fin 1,250 0 0 0 0 1,250 Incident Command Mobile Software (N) G -4 Fire 1,200 0 0 0 0 1,200 Web Server to Cloud (N) G -5 IT 57,700 12,285 12,899 13,544 14,221 110,649 Desktop Virtualization (1) G -6 IT 95,000 0 0 0 0 95,000 IT Strat Plan & Security Assessmnt (1) G -7 IT 50,000 0 0 0 0 50,000 VH Door Access (N) G -8 IT 50,000 0 0 0 0 50,000 Security Cameras (N) G -9 IT 27,860 0 0 0 0 27,860 Microsoft Licensing (N) G -10 IT 17,200 14,100 0 0 0 31,300 Police Integrity Software (I) G -11 Pol 10,600 1,400 1,400 1,400 1,400 16,200 Guardian Tracking System (N) G -12 Pol 2,732 2,732 2,732 3,278 3,278 14,752 PW Laptops (E) G -13 PW 5,860 2,930 2,930 0 0 11,720 Computer Workstations (N) G -14 Pol 5,600 5,600 0 0 0 11,200 Tablets for Vlg Board (I) G -15 VMO 3,850 0 0 0 0 3,850 Coplogic (N) G -16 Pol 0 18,500 7,000 7,000 7,000 39,500 Instant Messaging (N) G -17 IT 0 26,512 0 0 0 26,512 Telephone Call Accounting (N) G -18 IT 0 12,000 0 0 0 12,000 Microsoft Office Suite Upgrades (1) G -19 IT 0 85,000 0 0 0 85,000 GIS Interface (N) G -20 PW 0 30,000 0 0 0 30,000 Wireless Access Points (N) G -21 IT 0 0 6,000 0 0 6,000 SharePoint Server (N) G -22 IT 0 0 35,939 29,520 29,520 94,979 License Plate Recognition (N) G -23 Pol 0 0 45,000 0 0 45,000 CS Interface (N) G -24 PW 0 0 0 40,000 0 40,000 Total 330,252 211,059 113,900 94,742 55,419 805,372 (N) = New Project (E) = Established Project ( *) = Federal Mandate Project Type Codes: 700 = Water System 701 = Sanitary Sewer 702 = Flood Control Projects 703 = Storm Sewer 704 = Street Construction and Reconstruction 705 = Resurfacing/Curbs and Gutters /Sidewalks 706 = Construction of and Improvements to Public Buildings 707 = Computer Hardware /Software 708 = Vehicles and Automotive Equipment 709 = Non - Automotive Equipment 710 = Miscellaneous on VILLAGE OF MOUNT PROSPECT 2015 - 2019 CAPITAL IMPROVEMENTS PLAN SUMMARY OF PROJECT REQUESTS Recapitulation by Project Type Group Project Type Group 2015 2016 2017 2018 2019 Total Water and Sanitary Sewer Projects (700 -701) 4,150,000 2,630,000 1,965,000 2,760,000 5,005,000 16,510,000 Flood Control and Related Projects (702 -703) 1,345,000 2,595,000 990,000 795,000 565,000 6,290,000 Street and Related Projects (704 -705) 4,997,700 5,655,400 6,032,200 5,749,000 5,420,800 27,855,100 Public Buildings (706) 1,569,000 2,266,000 805,000 710,000 845,000 6,195,000 Computer Hardware /Software (707) 330,252 211,059 113,900 94,742 55,419 805,372 Equipment (708 -709) 204,000 40,000 432,500 368,000 78,000 1,122,500 Miscellaneous (7 10) 1,875,123 3,945,631 609,095 532,479 554,226 7,516,554 Total 14,471,075 17,343,090 10,947,695 11,009,221 12,523,445 66,294,526 B -1 VILLAGE OF MOUNT PROSPECT 2015 - 2019 CAPITAL IMPROVEMENTS PLAN SUMMARY OF PROJECT REQUESTS Project Type Group: Water and Sanitary Sewer Projects (Codes 700 and 701) (l) = New Project (E) = Established Project ( *) = Federal Mandate Project Type Codes: 700 = Water System 701 = Sanitary Sewer B -2 Page Project Project Name No. Type 2015 2016 2017 2018 2019 Total Booster Station (N) F -15 700 55,000 55,000 55,000 55,000 55,000 275,000 Wireless Telemtetry Upgrade (N) F -18 700 70,000 75,000 110,000 115,000 75,000 445,000 Residential AMR /AMl (l) F -19 700 1,000,000 0 0 0 0 1,000,000 Water Main Replacement (E) F -30 700 1,200,000 600,000 600,000 600,000 4,000,000 7,000,000 Water Tank Rehabilitation (E) F -37 700 0 650,000 0 675,000 0 1,325,000 Deep Well Rehab (E) F -38 700 0 300,000 0 315,000 0 615,000 Leak Detecting Euipment (1) F -39 700 0 75,000 0 0 0 75,000 Combined Sewer Improvements (E) F -3 701 1,000,000 0 0 0 0 1,000,000 Sewer Main Rehabilitation (E) F -26 701 500,000 525,000 550,000 550,000 550,000 2,675,000 Lift Station Rehab (N) F -32 701 325,000 350,000 650,000 450,000 325,000 2,100,000 Total 4,150,000 2,630,000 1,965,000 2,760,000 5,005,000 16,510,000 (l) = New Project (E) = Established Project ( *) = Federal Mandate Project Type Codes: 700 = Water System 701 = Sanitary Sewer B -2 VILLAGE OF MOUNT PROSPECT 2015 - 2019 CAPITAL IMPROVEMENTS PLAN SUMMARY OF PROJECT REQUESTS Project Type Group: Flood Control and Related Projects (Codes 702 and 703) (N) = New Project (E) = Established Project ( *) = Federal Mandate Project Type Codes: 702 = Flood Control Projects 703 = Storm Sewer B -3 Page Project Project Name No. Type 2015 2016 2017 2018 2019 Total Flood Control Program (E) F4 702 215,000 1,550,000 50,000 80,000 50,000 1,945,000 Levee 37 (E) F -16 702 30,000 35,000 40,000 40,000 45,000 190,000 Neighborhood Drainage Improv. (l) F -24 702 100,000 100,000 100,000 100,000 100,000 500,000 Levee 37 Emer Generators (N) F -45 702 0 0 210,000 175,000 0 385,000 Detention Pond Improvements (E) F -10 703 900,000 810,000 490,000 300,000 270,000 2,770,000 Storm Sewer Inspection Program (N) F -14 703 100,000 100,000 100,000 100,000 100,000 500,000 Total 1,345,000 2,595,000 990,000 795,000 565,000 6,290,000 (N) = New Project (E) = Established Project ( *) = Federal Mandate Project Type Codes: 702 = Flood Control Projects 703 = Storm Sewer B -3 VILLAGE OF MOUNT PROSPECT 2015 - 2019 CAPITAL IMPROVEMENTS PLAN SUMMARY OF PROJECT REQUESTS Project Type Group: Street and Related Projects (Codes 704 and 705) (N) = New Project (E) = Established Project (') = Federal Mandate Project Type Codes: 704 = Street Construction and Reconstruction 705 = Resurfacing/Curbs and Gutters /Sidewalks B -4 Page Project Project Name No. Type 2015 2016 2017 2018 2019 Total Corridor Improvements (E) C -3 704 200,000 250,000 250,000 250,000 250,000 1,200,000 Downtown Pedestrian Impr. (N) C -5 704 200,000 200,000 200,000 200,000 200,000 1,000,000 Traffic Signal Replacement (E) F -21 704 98,000 385,000 585,000 440,000 50,000 1,558,000 Street Improvement Program (E) F -2 705 4,218,000 4,442,000 4,472,000 4,502,000 4,532,000 22,166,000 Sidewalk Cost Share Program (E) F -5 705 86,700 88,400 90,200 92,000 93,800 451,100 New Sidewalks (E) F -6 705 120,000 140,000 160,000 190,000 220,000 830,000 Brick Sidewalk Sealing (E) F -22 705 75,000 75,000 75,000 75,000 75,000 375,000 NW Hwy Bike Rte/Ped Signals (1) F -36 705 0 75,000 0 0 0 75,000 Streetscape Improvements (I) F -42 705 0 0 200,000 0 0 200,000 Total 4,997,700 5,655,400 6,032,200 5,749,000 5,420,800 27,855,100 (N) = New Project (E) = Established Project (') = Federal Mandate Project Type Codes: 704 = Street Construction and Reconstruction 705 = Resurfacing/Curbs and Gutters /Sidewalks B -4 VILLAGE OF MOUNT PROSPECT 2015 - 2019 CAPITAL IMPROVEMENTS PLAN SUMMARY OF PROJECT REQUESTS Project Type Group: Public Buildings (Code 706) Total (1) = New Project (E) = Established Project ( *) = Federal Mandate 2015 Page Project Project Name No. Type Restroom Renovations (E) E -3 706 Firing Range Control System (I) E -4 706 Admin Section Renovation (1) E -5 706 Renovate Roll Call Room (I) E -6 706 Public Safety Lobby/Bathrooms (I) E -7 706 Evidence Lab (1) E -8 706 Other Public Buildings (E) F -8 706 Water Facility Roof Rehab (1) F -13 706 VH Parking Deck Maintenance (1) F -17 706 HVAC Replacement Program (N) F -20 706 PW Roof Repair (N) F -29 706 Salt Storage Building (I) F -31 706 Parking Lot Improvements (E) F -33 706 HVAC Upgrade - VH F -40 706 PS Training Rm Rehab (N) F-41 706 Public Safety Garage Sprinkler (N) F-44 706 Public Safety Parking Deck (N) F-46 706 PW Exterior Bldg Improv. (N) F -48 706 VH Window Replacement (1) F -50 706 Total (1) = New Project (E) = Established Project ( *) = Federal Mandate 2015 2016 2017 2018 2019 Total 21,000 21,000 0 0 0 42,000 120,000 0 0 0 0 120,000 0 500,000 0 0 0 500,000 0 0 70,000 0 0 70,000 0 0 0 115,000 0 115,000 0 0 0 0 200,000 200,000 160,000 155,000 160,000 160,000 165,000 800,000 65,000 65,000 70,000 70,000 0 270,000 50,000 50,000 50,000 50,000 50,000 250,000 25,000 50,000 50,000 275,000 25,000 425,000 470,000 1,030,000 0 0 0 1,500,000 600,000 0 0 0 0 600,000 58,000 0 25,000 0 0 83,000 0 395,000 0 0 0 395,000 0 0 86,000 0 0 86,000 0 0 44,000 0 0 44,000 0 0 250,000 0 0 250,000 0 0 0 40,000 200,000 240,000 0 0 0 0 205,000 205,000 1,569,000 2,266,000 805,000 710,000 845,000 6,195,000 Project Type Codes: 706 = Construction of and Improvements to Public Buildings B -5 VILLAGE OF MOUNT PROSPECT 2015 - 2019 CAPITAL IMPROVEMENTS PLAN SUMMARY OF PROJECT REQUESTS Project Type Group: Computer HardwareJSoftware (Code 707) (N) = New Project (E) = Established Project ( *) = Federal Mandate Project Type Codes: 707 = Computer Hardware /Software B -6 Page Project Name No. Dept. 2015 2016 2017 2018 2019 Total PC for Conference Room (N) G -2 Fin 1,400 0 0 0 0 1,400 Laptop for DD (N) G -3 Fin 1,250 0 0 0 0 1,250 Incident Command Mobile Software (N) G-4 Fire 1,200 0 0 0 0 1,200 Web Server to Cloud (N) G -5 IT 57,700 12,285 12,899 13,544 14,221 110,649 Desktop Virtualization (N) G -6 IT 95,000 0 0 0 0 95,000 IT Strat Plan & Security Assessmnt (N) G -7 IT 50,000 0 0 0 0 50,000 VH Door Access (N) G -8 IT 50,000 0 0 0 0 50,000 Security Cameras (N) G -9 IT 27,860 0 0 0 0 27,860 Microsoft Licensing (N) G -10 IT 17,200 14,100 0 0 0 31,300 Police Integrity Software (N) G -11 Pol 10,600 1,400 1,400 1,400 1,400 16,200 Guardian Tracking System (N) G -12 Pol 2,732 2,732 2,732 3,278 3,278 14,752 PW Laptops (E) G -13 PW 5,860 2,930 2,930 0 0 11,720 Computer Workstations (N) G -14 Pol 5,600 5,600 0 0 0 11,200 Tablets for Vlg Board (N) G -15 VMO 3,850 0 0 0 0 3,850 Coplogic (N) G -16 Pol 0 18,500 7,000 7,000 7,000 39,500 Instant Messaging (N) G -17 IT 0 26,512 0 0 0 26,512 Telephone Call Accounting (N) G -18 IT 0 12,000 0 0 0 12,000 Microsoft Office Suite Upgrades (N) G -19 IT 0 85,000 0 0 0 85,000 GIS Interface (N) G -20 PW 0 30,000 0 0 0 30,000 Wireless Access Points (N) G -21 IT 0 0 6,000 0 0 6,000 SharePoint Server (N) G -22 IT 0 0 35,939 29,520 29,520 94,979 License Plate Recognition (N) G -23 Pol 0 0 45,000 0 0 45,000 CS Interface (N) G -24 PW 0 0 0 40,000 0 40,000 Total 330,252 211,059 113,900 94,742 55,419 805,372 (N) = New Project (E) = Established Project ( *) = Federal Mandate Project Type Codes: 707 = Computer Hardware /Software B -6 VILLAGE OF MOUNT PROSPECT 2015 - 2019 CAPITAL IMPROVEMENTS PLAN SUMMARY OF PROJECT REQUESTS Project Type Group: Equipment (Codes 708 and 709) (N) = New Project (E) = Established Project • = Federal Mandate Project Type Codes: 708 = Vehicles and Automotive Equipment 709 = Non - Automotive Equipment B -7 Page Project Project Name No. Type 2015 2016 2017 2018 2019 Total Safety Trailer (1) D -7 708 0 0 0 75,000 0 75,000 Cardiac Monitors (1) D -9 708 0 0 0 0 15,000 15,000 SCBA Bottles (N) D -3 709 70,000 0 0 0 0 70,000 Fitness Treadmills (1) D -4 709 25,000 0 25,000 0 0 50,000 Hose and Appliances (l) D -5 709 0 0 25,000 0 0 25,000 Cardiac Monitors (1) D -6 709 0 0 200,000 0 0 200,000 SCBA Facepiece (1) D -8 709 0 0 0 0 63,000 63,000 Furniture Replacement (E) E -2 709 44,000 40,000 0 0 0 84,000 PW Vehicle Lifts (N) F -43 708 0 0 102,500 98,000 0 200,500 PW Radio System (1) F -34 709 65,000 0 0 0 0 65,000 Televising System Upgrades (1) F -47 709 0 0 80,000 80,000 0 160,000 Hydro Excavator (N) F49 709 0 0 0 115,000 0 115,000 Total 204,000 40,000 432,500 368,000 78,000 1,122,500 (N) = New Project (E) = Established Project • = Federal Mandate Project Type Codes: 708 = Vehicles and Automotive Equipment 709 = Non - Automotive Equipment B -7 VILLAGE OF MOUNT PROSPECT 2015 - 2019 CAPITAL IMPROVEMENTS PLAN SUMMARY OF PROJECT REQUESTS Project Type Group: Miscellaneous (Code 710) (N) = New Project (E) = Established Project ( *) = Federal Mandate Project Type Codes: 00 = Miscellaneous B -8 Page Project Project Name No. Type 2015 2016 2017 2018 2019 Total Fai;ade/Interior Buildout Program (E) C -2 710 100,000 100,000 100,000 100,000 100,000 500,000 Downtown Wayside Signage (l) C -4 710 200,000 0 0 0 0 200,000 Village Warning Sirens (N) D -2 710 90,000 0 0 0 0 90,000 Traffic Improvements (N) F -7 710 245,000 180,000 50,000 50,000 50,000 575,000 Streetlight Improvements 2 (E) F -9 710 125,000 125,000 125,000 125,000 125,000 625,000 Ash Replacement Plantings (N) F -11 710 116,969 90,066 42,460 0 0 249,495 Ash Tree & Stump Removals (N) F -12 710 179,760 125,832 53,928 0 0 359,520 Tree Planting Program (E) F -23 710 163,394 179,733 197,707 217,479 239,226 997,539 Infrastructure Aesthetics (1) F -25 710 40,000 40,000 40,000 40,000 40,000 200,000 KBC Jogging Path Rehab (I) F -27 710 350,000 205,000 0 0 0 555,000 Melas/Meadows Ped. Bridge (N) F -28 710 140,000 2,900,000 0 0 0 3,040,000 Bridge Rehab (1) F -35 710 125,000 0 0 0 0 125,000 Total 1,875,123 3,945,631 609,095 532,479 554,226 7,516,554 (N) = New Project (E) = Established Project ( *) = Federal Mandate Project Type Codes: 00 = Miscellaneous B -8 FIVE -YEAR FINANCIAL FORECAST (2015 - 2019) 4/17/2014 VILLAGE OF MOUNT PROSPECT FIVE -YEAR FINANCIAL FORECAST GENERAL FUND 2015-2019 (a) (b) (c) (d) (e) M (g) 2013 2014 Forecast Actual Projected 2015 2016 2017 2018 2019 Beginning Balance, January 1st 11,564,329 12,081,695 12,105,547 12,131,262 11,920,786 11,429,755 10,621,271 Revenues Property Taxes - General 7,659,915 9,205,000 9,914,000 10,260,990 10,620,125 10,991,829 11,376,543 Assumes 3.5% increase Property Taxes - Police Pension 2,565,834 2,857,000 3,059,000 3,273,130 3,502,249 3,747,407 4,009,725 Assumes 7.0% increase Property Taxes - Fire Pension 2,305,098 2,402,000 2,572,000 2,752,040 2,944,683 3,150,811 3,371,367 Assumes 7.0% increase Property Taxes - Other 203,596 210,466 212,664 120,500 120,500 120,500 120,500 No growth Other Taxes Home Rule Sales Tax 1,285,012 1,346,000 1,406,000 1,434,120 1,462,802 1,492,058 1,521,900 2.0% growth Food and Beverage Tax 719,190 725,000 750,000 772,500 795,675 819,545 844,132 3.0% growth Real Estate Transfer Tax 853,617 900,000 900,000 927,000 954,810 983,454 1,012,958 3.0% growth Telecommunications Tax 2,168,091 2,200,000 2,200,000 2,200,000 2,200,000 2,200,000 2,200,000 No growth Utility Taxes 1,723,621 1,750,000 1,820,000 1,856,400 1,893,528 1,931,399 1,970,027 2.0% growth Other Taxes 221,281 230,000 256,000 258,560 261,146 263,757 266,395 1.0% growth Licenses, Permits & Fees Vehicle Licenses 1,399,010 340,000 - - - - - No growth Other Licenses, Permits & Fees 2,050,366 2,050,000 2,050,000 2,091,000 2,132,820 2,175,476 2,218,986 2.0% growth Intergovernmental Revenues State Sales Tax 12,342,154 11,910,000 12,375,000 12,746,250 13,128,638 13,522,497 13,928,172 3.0% growth State Income Tax 5,161,051 5,275,000 5,430,000 5,484,300 5,539,143 5,594,534 5,650,480 1.0% growth Use Tax 912,204 922,000 950,000 969,000 988,380 1,008,148 1,028,311 2.0% growth Other Intergovernmental Revenues 598,245 526,100 544,000 554,880 565,978 577,297 588,843 2.0% growth Charges for Services 1,631,445 1,516,000 1,527,000 1,572,810 1,619,994 1,668,594 1,718,652 3.0% growth Fines and Forfeits 439,405 440,000 491,000 491,000 491,000 491,000 491,000 No growth Investment Income 6,567 10,000 22,500 12,100 11,900 11,400 10,600 Miscellaneous 787,701 1,293,000 931,500 931,500 931,500 931,500 931,500 No growth Total Revenues 45,033,402 46,107,566 47,410,664 48,708,080 50,164,870 51,681,206 53,260,088 Increase over Previous Year 2.4% 2.8% 2.7% 3.0% 3.0% 3.1% C -1 4/17/2014 VILLAGE OF MOUNT PROSPECT FIVE -YEAR FINANCIAL FORECAST GENERAL FUND 2015-2019 Excess (Deficiency) of Revenues over Operating Expenditures and Equity Transfers 517,366 23,852 25,715 (210,476) (491,031) (808,484) (1,166,778) Ending Balance, December 31st 12,081,695 12,105,547 12,131,262 11,920,786 11,429,755 10,621,271 9,454,493 26.37% 25.55% 24.80% 23.53% 21.78% 19.51% 16.74% C -2 (a) (b) (C) (d) (e) M (g) 2013 2014 Forecast Actual Projected 2015 2016 2017 2018 2019 Operating Expenditures Public Representation 550,880 626,321 625,622 637,895 650,613 663,799 677,480 Village Administration 2,817,368 2,633,208 2,816,709 2,879,149 2,961,060 3,046,487 3,135,633 Television Services Division 169,139 181,176 189,087 192,952 199,096 205,537 212,294 Village Clerk's Office 198,945 219,574 224,654 232,132 239,968 248,184 256,804 Finance Department 1,843,581 1,846,374 1,886,141 1,945,854 2,006,120 2,069,089 2,134,919 Community Development 2,023,299 2,332,932 2,338,585 2,418,822 2,497,556 2,579,998 2,666,369 Human Services 1,061,125 1,086,836 1,109,629 1,148,693 1,187,649 1,228,506 1,271,379 Police 15,783,922 16,535,251 17,056,841 17,604,407 18,245,923 18,920,552 19,630,373 Fire 12,678,982 12,879,787 13,309,021 13,778,658 14,375,379 15,013,519 15,696,668 Public Works 7,137,785 7,520,954 7,782,204 8,032,664 8,244,313 8,464,884 8,694,885 Emergency Events 204,860 175,000 - - - - - Pensions 46,150 46,301 46,456 47,332 48,225 49,135 50,063 Total Operating Expenditures 44,516,036 46,083,714 47,384,949 48,918,556 50,655,901 52,489,690 54,426,867 Increase over Previous Year 3.5% 2.8% 3.2% 3.6% 3.6% 3.7% Excess (Deficiency) of Revenues Over Operating Expenditures 517,366 23,852 25,715 (210,476) (491,031) (808,484) (1,166,778) Other Financing Sources (Uses) Transfers In - - - - - - - Transfers Out - - - - - - - Total Other Financing Sources (Uses) - - - - - - - Excess (Deficiency) of Revenues over Operating Expenditures and Equity Transfers 517,366 23,852 25,715 (210,476) (491,031) (808,484) (1,166,778) Ending Balance, December 31st 12,081,695 12,105,547 12,131,262 11,920,786 11,429,755 10,621,271 9,454,493 26.37% 25.55% 24.80% 23.53% 21.78% 19.51% 16.74% C -2 4/17/2014 VILLAGE OF MOUNT PROSPECT FIVE -YEAR FINANCIAL FORECAST GENERAL FUND 2015 -2019 C -3 (a) (b) (c) (d) (e) M (g) 2013 2014 Forecast Actual Projected 2015 2016 2017 2018 2019 Operating Expenditure Projections Public Representation Personal Services 174,158 174,458 174,758 175,058 175,358 Employee Benefits 58,865 62,986 67,395 72,112 77,160 7% increase after 2013 Other Employee Costs 2,030 2,071 2,112 2,154 2,197 Assumes 2.0% increase Contractual Services 314,960 321,259 327,684 334,238 340,923 Assumes 2.0% increase Utilities 432 441 449 458 468 Assumes 2.0% increase Commodities 64,327 65,614 66,926 68,264 69,630 Assumes 2.0% increase Other Expenditures 10,850 11,067 11,288 11,514 11,744 Total 625,622 637,895 650,613 663,799 677,480 Village Manager's Office Personal Services 1,002,066 1,022,107 1,042,549 1,063,400 1,084,668 Assumes 2.0% increase Employee Benefits 501,465 536,568 574,127 614,316 657,318 7% increase after 2013 Other Employee Costs 28,781 29,357 29,944 30,543 31,153 Assumes 2.0% increase Contractual Services 1,122,977 1,145,437 1,168,345 1,191,712 1,215,546 Assumes 2.0% increase Utilities 9,144 9,327 9,513 9,704 9,898 Assumes 2.0% increase Commodities 11,131 11,354 11,581 11,812 12,049 Assumes 2.0% increase Capital Outlay 141,145 125,000 125,000 125,000 125,000 Total 2,816,709 2,879,149 2,961,060 3,046,487 3,135,633 Television Services Division Personal Services 91,160 92,983 94,843 96,740 98,675 Assumes 2.0% increase Employee Benefits 46,457 49,709 53,189 56,912 60,896 7% increase after 2013 Other Employee Costs 765 780 796 812 828 Assumes 2.0% increase Contractual Services 30,924 31,542 32,173 32,817 33,473 Assumes 2.0% increase Utilities 1,581 1,613 1,645 1,678 1,711 Assumes 2.0% increase Commodities 6,200 6,324 6,450 6,579 6,711 Assumes 2.0% increase Capital Outlay 12,000 10,000 10,000 10,000 10,000 Total 189,087 192,952 199,096 205,537 212,294 C -3 4/17/2014 VILLAGE OF MOUNT PROSPECT FIVE -YEAR FINANCIAL FORECAST GENERALFUND 2015-2019 C -4 (a) (b) (c) (d) (e) (fl (g) 2013 2014 Forecast Actual Projected 2015 2016 2017 2018 2019 Village Clerk's Office Personal Services 128,213 130,777 133,393 136,061 138,782 Assumes 2.0% increase Employee Benefits 59,692 63,870 68,341 73,125 78,244 7% increase after 2013 Other Employee Costs 960 979 999 1,019 1,039 Assumes 2.0% increase Contractual Services 33,942 34,621 35,313 36,020 36,740 Assumes 2.0% increase Utilities 807 823 840 856 874 Assumes 2.0% increase Commodities 1,040 1,061 1,082 1,104 1,126 Assumes 2.0% increase Total 224,654 232,132 239,968 248,184 256,804 Finance Department Personal Services 836,648 853,381 870,449 887,858 905,615 Assumes 2.0% increase Employee Benefits 399,798 427,784 457,729 489,770 524,054 7% increase after 2013 Other Employee Costs 9,435 9,624 9,816 10,012 10,213 Assumes 2.0% increase Contractual Services 239,853 244,650 249,543 254,534 259,625 Assumes 2.0% increase Utilities 4,910 5,008 5,108 5,211 5,315 Assumes 2.0% increase Insurance 356,174 363,297 370,563 377,975 385,534 Assumes 2.0% increase Commodities 39,323 40,109 40,912 41,730 42,564 Assumes 2.0% increase Capital Outlay - 2,000 2,000 2,000 2,000 Total 1,886,141 1,945,854 2,006,120 2,069,089 2,134,919 Community Development Personal Services 1,210,238 1,234,443 1,259,132 1,284,314 1,310,001 Assumes 2.0% increase Employee Benefits 569,307 609,158 651,800 697,426 746,245 7% increase after 2013 Other Employee Costs 26,626 27,159 27,702 28,256 28,821 Assumes 2.0% increase Contractual Services 492,794 502,650 512,703 522,957 533,416 Assumes 2.0% increase Utilities 19,885 20,283 20,688 21,102 21,524 Assumes 2.0% increase Commodities 19,735 20,130 20,532 20,943 21,362 Assumes 2.0% increase Capital Outlay - 5,000 5,000 5,000 5,000 Total 2,338,585 2,418,822 2,497,556 2,579,998 2,666,369 C -4 4/17/2014 VILLAGE OF MOUNT PROSPECT FIVE -YEAR FINANCIAL FORECAST GENERAL FUND 2015-2019 Police Department (a) (b) (c) (d) (e) (f) (g) Personal Services 2013 2014 9,897,690 Forecast 10,297,557 10,503,508 Emp. Benefits (excl. Police Pension) Actual Projected 2015 2016 2017 2018 2019 Human Services 3,126,384 3,273,130 3,502,249 3,747,407 4,009,725 Personal Services 680,489 694,099 707,981 722,140 736,583 Employee Benefits 299,475 320,438 342,869 366,870 392,551 Other Employee Costs 4,405 4,493 4,583 4,675 4,768 Contractual Services 104,867 106,964 109,104 111,286 113,511 Utilities 11,136 11,359 11,586 11,818 12,054 Commodities 9,157 9,340 9,527 9,717 9,912 Capital Outlay 100 2,000 2,000 2,000 2,000 Total 1,109,629 1,148,693 1,187,649 1,228, 506 1,271,379 Police Department 7,611,636 7,763,869 7,919,146 8,077,529 8,239,080 Personal Services 9,703,618 9,897,690 10,095,644 10,297,557 10,503,508 Emp. Benefits (excl. Police Pension) 2,356,491 2,521,445 2,697,947 2,886,803 3,088,879 Police Pension Transfer 3,126,384 3,273,130 3,502,249 3,747,407 4,009,725 Other Employee Costs 164,828 168,125 171,487 174,917 178,415 Contractual Services 1,521,653 1,552,086 1,583,128 1,614,790 1,647,086 Utilities 31,886 32,524 33,174 33,838 34,514 Commodities 122,730 125,185 127,688 130,242 132,847 Other Expenditures 18,845 19,222 19,606 19,998 20,398 Capital Outlay 10,406 15,000 15,000 15,000 15,000 Total 17,056,841 17,604,407 18,245,923 18,920,552 19,630,373 Fire Department Personal Services 7,611,636 7,763,869 7,919,146 8,077,529 8,239,080 Emp. Benefits (excl. Fire Pension) 1,669,543 1,786,411 1,911,460 2,045,262 2,188,430 Fire Pension Fund Transfer 2,640,080 2,904,088 3,194,497 3,513,946 3,865,341 Other Employee Costs 145,305 148,211 151,175 154,199 157,283 Contractual Services 1,049,076 1,070,058 1,091,459 1,113,288 1,135,554 Utilities 33,058 33,719 34,394 35,081 35,783 Commodities 46,375 47,303 48,249 49,214 50,198 Capital Outlay 113,948 25,000 25,000 25,000 25,000 Total 13,309,021 13,778,658 14,375,379 15,013,519 15,696,668 C -5 Assumes 2.0% increase 7% increase after 2013 Assumes 2.0% increase Assumes 2.0% increase Assumes 2.0% increase Assumes 2.0% increase Assumes 2.0% increase 7% increase after 2013 Assumes 7.0% increase Assumes 2.0% increase Assumes 2.0% increase Assumes 2.0% increase Assumes 2.0% increase Assumes 2.0% increase Assumes 2.0% increase 7% increase after 2013 Assumes 7.0% increase Assumes 2.0% increase Assumes 2.0% increase Assumes 2.0% increase Assumes 2.0% increase 4/17/2014 VILLAGE OF MOUNT PROSPECT FIVE -YEAR FINANCIAL FORECAST GENERALFUND 2015-2019 Public Works Department Personal Services Employee Benefits Other Employee Costs Contractual Services Utilities Commodities Infrastructure Capital Outlay Total Pension Benefits Retirement Pensions Disability Pensions Total (a) (b) (c) (d) (e) M (g) 2013 2014 Forecast Actual Projected 2015 2016 2017 2018 2019 2,946,274 3,005,199 3,065,303 3,126,610 3,189,142 1,252,252 1,339,910 1,433, 703 1,534,063 1,641,447 34,294 34,980 35,679 36,393 37,121 2,320,493 2,366,903 2,414,241 2,462,526 2,511,776 154,731 157,826 160,982 164,202 167,486 321,418 327,846 334,403 341,091 347,913 206,700 200,000 200,000 200,000 200,000 546,042 600,000 600,000 600,000 600,000 7,782,204 8,032,664 8,244,313 8,464,884 8,694,885 Assumes 2.0% increase 7% increase after 2013 Assumes 2.0% Assumes 2.0% Assumes 2.0% Assumes 2.0% 5,325 5,378 5,432 5,486 5,541 Assumes 1.0% increase 41,131 41,954 42,793 43,649 44,522 Assumes 2.0% increase 46,456 47,332 48,225 49,135 50,063 C -6 4/17/2014 VILLAGE OF MOUNT PROSPECT FIVE -YEAR FINANCIAL FORECAST CAPITAL IMPROVEMENT FUND 2015-2019 CQWl (a) (b) (c) (d) (e) M (g) 2013 2014 Forecast Actual Projected 2015 2016 2017 2018 2019 Beginning Balance, January 1st 2,293,222 2,097,303 1,463,456 (1,063,104) (3,879,604) (4,424,584) (4,728,014) Revenues Home Rule Sales Tax (4th) 1,180,962 1,246,000 1,200,000 1,226,000 1,252,520 1,279,570 1,307,162 Investment Earnings 875 1,000 500 500 0 0 0 Grants /Other Intergovernmental Rev. 443,171 0 0 0 0 0 0 Developer Donations 283,233 10,000 5,000 5,000 5,000 5,000 5,000 Intergovernmental Revenues 0 0 0 0 0 0 0 Other Reimbursements 0 0 0 0 0 0 0 Other 24,000 0 0 0 0 0 0 Total Revenues 1,932,241 1,257,000 1,205,500 1,231,500 1,257,520 1,284,570 1,312,162 Expenditures Police Admin Renovation 0 0 0 500,000 0 0 0 Per CIP Board Room Cameras 33,754 0 0 0 0 0 0 Per CIP Broadcast Camera Replacement 12,450 0 0 0 0 0 0 Per CIP Bunker Gear Lockers 0 30,000 0 0 0 0 0 Per CIP Cardiac Monitors 0 0 0 0 200,000 0 0 Per CIP Command Software 0 0 1,200 0 0 0 0 Per CIP Corridor Improvements 0 0 200,000 200,000 200,000 200,000 200,000 Per CIP Desktop Virtualization 0 0 95,000 0 0 0 0 Per CIP Detention Pond Improvements 141,667 138,400 900,000 810,000 490,000 300,000 270,000 Per CIP Door Access Card System - VH 0 0 50,000 0 0 0 0 Per CIP Downtown Pedestrian Improvements 0 0 200,000 200,000 200,000 200,000 200,000 Per CIP Evidence Lab 0 0 0 0 0 0 200,000 Per CIP Extrication Equipment 0 65,000 0 0 0 0 0 Per CIP Fire Safety Trailer 0 0 0 0 0 75,000 0 Per CIP Firing Range Control System 0 0 120,000 0 0 0 0 Per CIP Furniture Replacement - Police 0 33,000 44,000 40,000 0 0 0 Per CIP Hose & Appliances 0 0 0 0 25,000 0 0 Per CIP HVAC Replacement Program 443,768 446,000 25,000 50,000 50,000 275,000 25,000 Per CIP HVAC Upgrade - VH 0 0 0 395,000 0 0 0 Per CIP Kensington Jogging Path Rehab 0 240,000 350,000 205,000 0 0 0 Per CIP Kensington Improvements 354,063 66,000 0 0 0 0 0 Per CIP Kitchen Remodel - FS #13 0 75,000 0 0 0 0 0 Per CIP Melas /Meadows Park Bridge 0 120,000 35,000 145,000 0 0 0 Per CIP Mobile Video Recording System 155,444 16,600 0 0 0 0 0 Per CIP NW Hwy /MP Road Bike Path 0 25,000 0 75,000 0 0 0 Per CIP Office Suite Software 0 0 0 85,000 0 0 0 Per CIP Other Public Building Improvements 177,966 95,000 160,000 155,000 160,000 160,000 165,000 Per CIP CQWl 4/17/2014 VILLAGE OF MOUNT PROSPECT FIVE -YEAR FINANCIAL FORECAST CAPITAL IMPROVEMENT FUND 2016-2019 Per CIP Per CIP Per CIP Per CIP Per CIP Per CIP Per CIP Per CIP Per CIP Per CIP Per CIP Per CIP Per CIP Per CIP Per CIP Per CIP Per CIP Per CIP Per CIP Per CIP Per CIP Per CIP Per CIP Per CIP Per CIP Per CIP Per CIP Per CIP C -8 (a) (b) (c) (d) (e) M (g) 2013 2014 Forecast Actual Projected 2015 2016 2017 2018 2019 Parking Lot Improvements 0 0 58,000 0 25,000 0 0 Police Lobby /Restroom Renovation 0 0 0 0 0 115,000 0 Police Roll Call Room Renovation 0 0 0 0 70,000 0 0 Public Safety - Police Radios 63,495 62,860 0 0 0 0 0 Public Safety - Fire Radios 86,591 64,387 0 0 0 0 0 Public Works Radio System 0 0 65,000 0 0 0 0 Police /Fire Gutter Replacement 40,285 4,800 0 0 0 0 0 Public Safety Building Roof Repairs 343,247 40,000 0 0 0 0 0 Public Safety Garage Sprinkler 0 0 0 0 44,000 0 0 Public Safety Training Room Rehab 0 0 0 0 86,000 0 0 Public Works Exterior Improvements 0 0 0 0 0 40,000 200,000 Public Works Roof Repair 183,875 2,000 470,000 1,030,000 0 0 0 Restroom Renovations 50,000 21,000 21,000 21,000 0 0 0 Salt Storage Building 0 26,800 600,000 0 0 0 0 SCBA Bottles 0 0 70,000 0 0 0 0 SCBA Facepieces 0 0 0 0 0 0 63,000 SCI Computer Conversion 0 16,000 0 0 0 0 0 Security Cameras - VH 0 0 27,860 0 0 0 0 Streetlight Improvements 19,423 75,000 125,000 125,000 125,000 125,000 125,000 Streetscape Improvements 0 195,000 0 0 0 0 0 ERP System Software /Hardware 22,133 0 0 0 0 0 0 Telephone Call Accounting 0 0 0 12,000 0 0 0 Thermal Imaging Cameras 0 33,000 0 0 0 0 0 Treadmills 0 0 25,000 0 25,000 0 0 Vehicle Lifts 0 0 0 0 102,500 98,000 0 Village Warning Sirens 0 0 90,000 0 0 0 0 Window Replacement - VH 0 0 0 0 0 0 205,000 Zodiac Boat w/Trailer 0 0 0 0 0 0 15,000 Total Expenditures 2,128,160 1,890,847 3,732,060 4,048,000 1,802,500 1,588,000 1,668,000 Excess (Deficiency) of Revenues Over Expenditures (195,919) (633,847) (2,526,560) (2,816,500) (544,980) (303,430) (355,838) 0 Other Financing Sources (Uses) Transfer Out 0 0 0 0 0 0 0 Total Other Financing sources (Uses) 0 0 0 0 0 0 0 Ending Balance, December 31st 2,097,303 1,463,456 (1,063,104) (3,879,604) (4,424,584) (4,728,014) (5,083,852) Per CIP Per CIP Per CIP Per CIP Per CIP Per CIP Per CIP Per CIP Per CIP Per CIP Per CIP Per CIP Per CIP Per CIP Per CIP Per CIP Per CIP Per CIP Per CIP Per CIP Per CIP Per CIP Per CIP Per CIP Per CIP Per CIP Per CIP Per CIP C -8 4/17/2014 VILLAGE OF MOUNT PROSPECT FIVE -YEAR FINANCIAL FORECAST DOWNTOWN REDEVELOPMENT FUND 2015-2019 Beginning Balance, January 1st Revenues Property Tax Increment Property Taxes Investment Income Total Revenues Expenditures Return of Increment Auditing Fees Legal and Financing Costs Real Estate Taxes Other Professional Services Corridor Maintenance Brick Sidewalk Sealing Fagade /Interior Build out Program Downtown Pedestrian Improvements Downtown Streetscape Brick Sidewalks Furnishing Maintenance Northwest Electric Sales Tax Rebate Total Expenditures Excess (Deficiency) of Revenues Over Expenditures Other Financing Sources (Uses) Transfers In Transfers Out Total Other Financing sources (Uses) Ending Balance, December 31st (a) (b) (c) (d) (e) (f) (g) 2013 2014 Forecast Actual Projected 2015 2016 2017 2018 2019 1,362,120 1,068,934 318,972 (194,948) (266,808) (518,901) (550,623) 2,423,329 2,425,000 2,556,000 2,632,680 2,711,660 2,793,010 2,876,801 Assumes 3.0% growth 241,350 246,000 252,000 259,560 267,347 275,367 283,628 Assumes 3.0% growth 1,068 1,000 1,000 0 0 0 0 2,665,747 2,672,000 2,809,000 2,892,240 2,979,007 3,068,377 3,160,429 2,567,531 2,629,922 2,693,829 2,759,000 2,826,000 2,895,000 2,965,000 Per agreement 960 1,040 1,091 1,100 1,100 1,100 1,100 0 10,000 10,000 10,000 10,000 10,000 10,000 6,969 7,000 7,000 7,000 7,000 7,000 7,000 19,665 20,000 20,000 20,000 20,000 20,000 20,000 56,350 57,000 57,000 57,000 57,000 57,000 57,000 Per CIP 75,000 75,000 75,000 0 0 0 75,000 0 120,000 100,000 100,000 100,000 100,000 100,000 Per CIP 0 0 200,000 0 0 0 0 Per CIP 88,005 345,000 0 0 200,000 0 0 Per CIP 5,855 10,000 10,000 10,000 10,000 10,000 10,000 40,000 40,000 40,000 0 0 0 0 Per CIP 98,598 107,000 109,000 0 0 0 Agreement Ends in 2015 2,958,933 3,421,962 3,322,920 2,964,100 3,231,100 3,100,100 3,245,100 (293,186) (749,962) (513,920) (71,860) (252,093) (31,723) (84,671) 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1,068,934 318,972 (194,948) (266,808) (518,901) (550,623) (635,295) C -9 4/17/2014 VILLAGE OF MOUNT PROSPECT FIVE -YEAR FINANCIAL FORECAST STREET IMPROVEMENT CONSTRUCTION FUND 2015-2019 Expenditures Financing Costs (a) (b) (c) (d) (e) 0 (9) Resurface Testing 2013 2014 30,000 30,000 Forecast 30,000 30,000 Street Reconstruction /Resurfacing Actual Projected 2015 2016 2017 2018 2019 Beginning Balance, January 1st 334,442 866,951 460,171 191,271 (87,679) (236,679) (385,679) Revenues 0 58,000 0 0 0 0 0 Per CIP Home Rule Sales Tax 1,285,012 1,346,000 1,406,000 1,435,000 1,465,000 1,495,000 1,525,000 Assumes 2.0% growth Municipal Motor Fuel Tax 360,802 711,000 722,000 722,000 722,000 722,000 722,000 Vehicle Licenses 0 1,045,000 1,540,000 1,735,000 1,735,000 1,735,000 1,735,000 Investment Earnings 191 100 100 50 0 0 0 Grants 3,612 0 0 0 0 0 0 Bond Proceeds 0 6,500,000 0 0 0 0 0 Miscellaneous Income 11,726 6,000 6,000 6,000 6,000 6,000 6,000 No growth Total Revenues 1,661,342 9,608,100 3,674,100 3,898,050 3,928,000 3,958,000 3,988,000 Expenditures Financing Costs 0 41,000 0 0 0 0 0 Resurface Testing 26,883 30,600 30,000 30,000 30,000 30,000 30,000 Street Reconstruction /Resurfacing 1,068,120 9,705,280 3,668,000 3,892,000 3,922,000 3,952,000 3,982,000 Per CIP Traffic Improvements 33,830 180,000 245,000 180,000 50,000 50,000 50,000 Per CIP Parking Lot Improvements 0 58,000 0 0 0 0 0 Per CIP Brick Sidewalk Sealing 0 0 0 75,000 75,000 75,000 0 Total Expenditures 1,128,833 10,014,880 3,943,000 4,177,000 4,077,000 4,107,000 4,062,000 Excess (Deficiency) of Revenues Over Expenditures 532,509 (406,780) (268,900) (278,950) (149,000) (149,000) (74,000) Other Financing Sources (Uses) Transfer In 0 0 0 0 0 0 0 Total Other Financing Sources (Uses) 0 0 0 0 0 0 0 Ending Balance, December 31st 866,951 460,171 191,271 (87,679) (236,679) (385,679) (459,679) C -10 4/17/2014 VILLAGE OF MOUNT PROSPECT FIVE -YEAR FINANCIAL FORECAST FLOOD CONTROL CONSTRUCTION FUNDS 2015-2019 Excess (Deficiency) of Revenues Over Expenditures Ending Balance, December 31st 8,168,030 (10,604,832) 18,468 (1,323,508) (41,917) (29,791) 179,425 11,672,318 1,067,486 1,085,954 (237,554) (279,471) (309,262) (129,837) C -11 (a) (b) (c) (d) (e) (f) (g) 2013 2014 Forecast Actual Projected 2015 2016 2017 2018 2019 Beginning Balance, January 1st 3,504,288 11,672,318 1,067,486 1,085,954 (237,554) (279,471) (309,262) Revenues Home Rule Sales Tax 625,738 289,468 263,468 361,492 358,583 365,709 374,825 Portion not allocated to D/S Levee 37 Reimbursement 108,438 0 0 0 0 0 0 PH reimbursement Bond Proceeds 9,909,542 0 0 0 0 0 0 Investment Earnings 6,342 500 500 500 0 0 100 Total Revenues 10,650,059 289,968 263,968 361,992 358,583 365,709 374,925 Expenditures Creek Tree Trimming 21,391 25,000 25,000 25,000 25,000 25,000 25,000 Per CIP Financing Costs 167,846 0 0 0 0 0 0 Bank Stabilization Maintenance 0 38,800 25,000 25,000 25,000 25,000 25,000 Per CIP Basin Analysis 0 0 65,000 0 0 0 0 Per CIP Neighborhood Drainage Imp. 80,510 100,000 100,000 100,000 100,000 100,000 100,000 Per CIP McDonald Creek 0 0 0 1,500,000 0 0 0 Per CIP Levee 37 13,564 175,000 30,000 35,000 40,000 40,000 45,000 Per CIP Levee 37 Standby Generator 0 0 0 0 210,000 175,000 0 Per CIP Levee 37 Electricity /Other 287 1,000 500 500 500 500 500 Residential Reimbursement 2,000 5,000 0 0 0 0 0 Isabella Combined Sewer 42,500 9,800,000 0 0 0 0 0 Hatlen Heights Storm Sewer 1,557,629 0 0 0 0 0 0 Per CIP Hatlen Heights Sanitary Sewer 103,760 0 0 0 0 0 0 Per CIP Lonnquist Combined 197,720 0 0 0 0 0 0 Per CIP Lonnquist Storm 133,510 0 0 0 0 0 0 Per CIP Lawrence Lane Storm 49,341 0 0 0 0 0 0 Per CIP Golfview Estates 84,592 0 0 0 0 0 0 Per CIP Prospect Meadows 27,379 720,000 0 0 0 0 0 Per CIP Weller Creek Silt Removal 0 30,000 0 0 0 30,000 0 Per CIP Total Expenditures 2,482,029 10,894,800 245,500 1,685,500 400,500 395,500 195,500 Excess (Deficiency) of Revenues Over Expenditures Ending Balance, December 31st 8,168,030 (10,604,832) 18,468 (1,323,508) (41,917) (29,791) 179,425 11,672,318 1,067,486 1,085,954 (237,554) (279,471) (309,262) (129,837) C -11 4/17/2014 VILLAGE OF MOUNT PROSPECT FIVE -YEAR FINANCIAL FORECAST MOTOR FUEL TAX FUND 2015-2019 Beginning Balance, January 1st Revenues Motor Fuel Tax Allotments Investment Income MFT Projects Reimbursement Supplemental Payment Other Reimbursements Total Revenues Expenditures Crack Filling Contractual Snow Removal Pavement Markings Salt, Calcium Chloride Traffic Light Maintenance Electricity, Northwest Highway Traffic Signal Replacement Street Resurfacing Total Expenditures Excess (Deficiency) of Revenues Over Expenditures Ending Balance, December 31st (a) (b) (c) (d) (e) (f) (g) 2013 2014 Forecast Actual Projected 2015 2016 2017 2018 2019 509,470 338,861 788,061 829,423 602,590 617,401 618,588 1,325,341 1,290,000 1,290,000 1,290,000 1,290,000 1,290,000 1,445,000 No growth 111 100 100 0 0 0 0 7,663 5,000 5,000 5,000 5,000 5,000 5,000 No growth 244,341 0 0 0 0 0 0 5,320 1,000 1,000 1,000 1,000 1,000 1,000 No growth 1,582,776 1,296,100 1,296,100 1,296,000 1,296,000 1,296,000 1,451,000 52,433 53,497 54,567 55,658 56,771 57,907 59,065 Assumes 2.0% increase 0 75,000 0 0 0 0 0 46,982 62,000 63,240 64,505 65,795 67,111 68,453 Assumes 2.0% increase 302,544 284,796 290,492 296,302 302,228 308,272 314,438 Assumes 2.0% increase 80,024 88,607 90,379 92,187 94,030 95,911 97,829 Assumes 2.0% increase 156,402 153,000 156,060 159,181 162,365 165,612 168,924 Assumes 2.0% increase 0 130,000 50,000 305,000 50,000 50,000 50,000 Per CIP 1,115,000 0 550,000 550,000 550,000 550,000 550,000 Per CIP 1,753,385 846,900 1,254,738 1,522,833 1,281,189 1,294,813 1,308,709 (170,609) 449,200 41,362 (226,833) 14,811 1,187 142,291 338,861 788,061 829,423 602,590 617,401 618,588 760,878 C -12 4/17/2014 VILLAGE OF MOUNT PROSPECT FIVE -YEAR FINANCIAL FORECAST WATER AND SEWER FUND 2015-2019 C -13 (a) (b) (c) (d) (e) M (g) 2013 2014 Forecast Actual Projected 2015 2016 2017 2018 2019 Beginning Cash Balance, January 1st 4,356,739 5,874,047 3,949,994 3,122,261 4,657,584 6,408,903 5,619,220 Revenues SSA Taxes 1,507,661 1,530,000 1,530,000 1,530,000 1,530,000 0 0 SSA Levy Ends 2017 License, Permits and Fees 63,104 57,000 57,000 57,000 57,000 57,000 57,000 No Change Water Sales 8,524,850 9,763,000 10,842,000 11,817,780 12,408,669 13,029,102 13,680,558 Per Proposed Rate Schedule Sewer Fees 2,130,068 2,223,000 2,223,000 2,223,000 2,223,000 2,223,000 2,223,000 Per Proposed Rate Schedule Sewer Construction Charge 682,805 685,000 685,000 685,000 685,000 685,000 685,000 No increase Late Fees 115,894 100,000 100,000 100,000 100,000 100,000 100,000 No increase Reimbursements /Other 52,184 1,000 1,000 1,000 1,000 1,000 1,000 No increase Investment Income 3,036 1,100 1,100 1,100 1,100 1,100 1,100 Miscellaneous Income 46,871 25,000 25,000 25,000 25,000 25,000 25,000 No increase Total Revenues 13,126,474 14,385,100 15,464,100 16,439,880 17,030,769 16,121,202 16,772,658 Expenses Administration Personal Services 391,187 397,260 405,155 413,258 421,523 429,954 438,553 Assumes 2.0% increase Employee Benefits 232,562 209,833 216,163 231,294 247,485 264,809 283,346 7.0% increase after 2014 Other Employee Costs 24,873 36,660 36,371 37,098 37,840 38,597 39,369 Assumes 2.0% increase Contractual Services 675,262 685,826 678,365 691,932 705,771 719,886 734,284 Assumes 2.0% increase Utilities 33,017 43,758 44,633 45,526 46,436 47,365 48,312 Assumes 2.0% increase Insurance 79,383 80,474 81,708 83,342 85,009 86,709 88,443 Assumes 2.0% increase Commodities & Supplies 8,932 12,382 12,615 12,867 13,125 13,387 13,655 Assumes 2.0% increase Office Equipment 0 0 0 6,500 6,500 6,500 6,500 Other Equipment 2,158 2,200 2,245 2,200 2,200 2,200 2,200 Total Administration 1,447,375 1,468,393 1,477,255 1,524,018 1,565,889 1,609,407 1,654,662 Equipment Maintenance Vehicle Lease Payment 263,200 283,500 283,500 292,005 300,765 309,788 319,082 Assumes 3.0% increase Vehicle Maintenance Payment 516,087 503,146 517,617 533,146 549,140 565,614 582,582 Assumes 3.0% increase Total Equipment Maintenance 779,287 786,646 801,117 825,151 849,905 875,402 901,664 C -13 4/17/2014 VILLAGE OF MOUNT PROSPECT FIVE -YEAR FINANCIAL FORECAST WATER AND SEWER FUND 2015-2019 C -14 (a) (b) (c) (d) (e) (f) (g) 2013 2014 Forecast Actual Projected 2015 2016 2017 2018 2019 Maintenance of Buildings Personal Services 156,214 151,739 154,745 157,840 160,997 164,217 167,501 Assumes 2.0% increase Employee Benefits 68,558 69,065 71,566 76,576 81,936 87,671 93,808 7.0% increase after 2014 Contractual Services 14,864 63,500 16,830 17,167 17,510 17,860 18,217 Assumes 2.0% increase Utilities 4,191 6,000 6,120 6,242 6,367 6,495 6,624 Assumes 2.0% increase Commodities & Supplies 998 1,530 1,560 1,591 1,623 1,655 1,689 Assumes 2.0% increase Total Maintenance of Buildings 244,825 291,834 250,821 259,416 268,433 277,898 287,840 Maintenance of Grounds Personal Services 62,999 63,415 64,674 65,967 67,287 68,633 70,005 Assumes 2.0% increase Employee Benefits 20,273 20,218 20,902 22,365 23,931 25,606 27,398 7.0% increase after 2014 Contractual Services 32,665 28,560 29,130 29,713 30,307 30,913 31,531 Assumes 2.0% increase Commodities & Supplies 5,561 5,915 6,033 6,154 6,277 6,402 6,530 Assumes 2.0% increase Total Maintenance of Grounds 121,499 118,108 120,739 124,199 127,801 131,554 135,465 Lake Michigan Water Supply Water Purchase 3,790,743 3,952,000 4,537,000 3,952,000 4,537,000 5,044,000 5,187,000 Per JAWA Schedule Power Cost 111,382 90,812 92,628 107,000 109,000 112,000 114,000 Per JAWA Schedule O & M Cost 343,859 331,267 342,993 339,000 355,000 371,000 388,000 Per JAWA Schedule Fixed Cost 984,630 938,594 938,757 1,060,000 1,249,000 1,282,000 1,317,000 Per JAWA Schedule Total Lake Michigan Water Supply 5,230,614 5,312,673 5,911,378 5,458,000 6,250,000 6,809,000 7,006,000 Water Supply Maint. & Repair Personal Services 392,910 386,247 393,891 401,769 409,804 418,000 426,360 Assumes 2.0% increase Employee Benefits 144,090 144,562 149,276 159,725 170,906 182,870 195,670 7.0% increase after 2014 Contractual Services 50,190 120,431 129,719 132,313 134,960 137,659 140,412 Assumes 2.0% increase Utilities 66,088 85,000 85,000 86,700 88,434 90,203 92,007 Assumes 2.0% increase Commodities & Supplies 21,951 80,000 80,700 82,314 83,960 85,639 87,352 Assumes 2.0% increase Tank Repair /Inspection 18,828 25,000 25,500 25,000 25,000 25,000 25,000 Total Water Supply Maint. & Repair 694,057 841,240 864,086 887,822 913,064 939,371 966,802 C -14 4/17/2014 VILLAGE OF MOUNT PROSPECT FIVE -YEAR FINANCIAL FORECAST WATER AND SEWER FUND 2015-2019 Water Meter Maint. & Repair Personal Services (a) (b) (c) (d) (e) (f) (g) Assumes 2.0% increase Employee Benefits 2013 2014 45,434 48,614 Forecast 55,659 59,555 7.0% increase after 2014 Contractual Services Actual Projected 2015 2016 2017 2018 2019 Assumes 2.0% increase Water Distribution Maint. & Repair 2,884 2,178 2,581 2,633 2,685 2,739 2,794 Assumes 2.0% increase Personal Services 298,622 299,223 305,171 311,274 317,500 323,850 330,327 Assumes 2.0% increase Employee Benefits 100,680 100,817 104,080 111,366 119,161 127,502 136,428 7.0% increase after 2014 Contractual Services 185,407 227,383 231,045 235,666 240,379 245,187 250,091 Assumes 2.0% increase Commodities & Supplies 88,242 71,403 71,990 73,430 74,898 76,396 77,924 Assumes 2.0% increase Office Equipment 0 1,370 1,397 1,500 1,500 1,500 1,500 7.0% increase after 2014 Other Equipment 0 0 0 1,500 1,500 1,500 1,500 Assumes 2.0% increase Total Water Distribution M & R 672,952 700,196 713,683 734,736 754,939 775,936 797,769 Assumes 2.0% increase Water Meter Maint. & Repair Personal Services 161,254 154,026 157,106 160,248 163,453 166,722 170,057 Assumes 2.0% increase Employee Benefits 46,078 44,099 45,434 48,614 52,017 55,659 59,555 7.0% increase after 2014 Contractual Services 69,893 99,505 101,295 103,321 105,387 107,495 109,645 Assumes 2.0% increase Commodities & Supplies 2,884 2,178 2,581 2,633 2,685 2,739 2,794 Assumes 2.0% increase Residential Water Meters 27,938 65,000 66,000 1,000,000 1,000,000 1,000,000 800,000 Per CIP Total Water Meter M & R 308,047 364,808 372,416 1,314,816 1,323,543 1,332,615 1,142,050 Water Valve /Hydrant Maint. & Repair Personal Services 282,826 275,631 281,104 286,726 292,461 298,310 304,276 Assumes 2.0% increase Employee Benefits 111,358 111,117 115,036 123,089 131,705 140,924 150,789 7.0% increase after 2014 Contractual Services 16,620 19,588 19,924 20,322 20,729 21,144 21,566 Assumes 2.0% increase Commodities & Supplies 75,051 95,784 97,699 99,653 101,646 103,679 105,753 Assumes 2.0% increase Total Water Valve /Hydrant M &R 485,855 502,120 513,763 529,790 546,540 564,056 582,384 Water & Sewer System Improvements Sewer Main Rehab (CIP) 0 0 0 0 0 0 0 Total W& S System Improvements 0 0 0 0 0 0 0 Sanitary Sewer Maint. & Repair Personal Services 223,864 225,123 229,594 234,186 238,870 243,647 248,520 Assumes 2.0% increase Employee Benefits 86,651 88,182 91,246 97,633 104,468 111,780 119,605 7.0% increase after 2014 Contractual Services 124,699 150,300 152,425 155,474 158,583 161,755 164,990 Assumes 2.0% increase Utilities 14,953 23,000 23,460 23,929 24,408 24,896 25,394 Assumes 2.0% increase Commodities & Supplies 25,610 26,530 26,920 27,458 28,008 28,568 29,139 Assumes 2.0% increase Total Sanitary Sewer M & R 475,777 513,135 523,645 538,680 554,335 570,646 587,647 C -15 4/17/2014 VILLAGE OF MOUNT PROSPECT FIVE -YEAR FINANCIAL FORECAST WATER AND SEWER FUND 2015-2019 C -16 (a) (b) (c) (d) (e) M (g) 2013 2014 Forecast Actual Projected 2015 2016 2017 2018 2019 Capital Improvements AMR System 27,922 1,727,100 1,000,000 0 0 0 0 Per CIP Booster Pump /Panel Replacement 50,000 50,000 55,000 55,000 55,000 55,000 55,000 Per CIP Combined Sewer Improvements 797,852 800,000 1,000,000 0 0 0 0 Per CIP Computer Equipment - New 0 0 2,930 2,930 0 0 0 Per CIP Customer Service Interface 0 0 0 0 10,000 0 0 Per CIP Deep Well Rehab 171,235 302,000 0 300,000 0 315,000 0 Per CIP Emergency Generator - Wells 3,184 911,400 0 0 0 0 0 Per CIP GeoCotex Interface 0 0 0 10,000 0 0 0 Per CIP Hydro Excavator 0 0 0 0 0 115,000 0 Per CIP Leak Detection Equipment 0 0 0 75,000 0 0 0 Per CIP Lift Station Rehab 0 265,000 325,000 350,000 650,000 450,000 325,000 Per CIP Lift Station Standby Generator 0 0 500,000 0 0 0 0 Per CIP SCADA Wireless Telemetry 40,494 52,000 70,000 75,000 110,000 115,000 75,000 Per CIP Sewer Main - Repair /Replacement 0 375,000 500,000 525,000 550,000 550,000 550,000 Per CIP Software Development 0 10,000 0 0 0 0 0 Per CIP Tank Design Engineering 3,132 25,000 25,000 0 0 0 0 Per CIP Tank Repair /Renovation 55,060 850,000 0 650,000 0 675,000 0 Per CIP Televising Camera System Upgrades 0 0 0 0 80,000 80,000 0 Per CIP Water Facility Roof Rehab 0 42,500 65,000 65,000 70,000 70,000 0 Per CIP Water Main Replacement 0 0 1,200,000 600,000 600,000 600,000 4,000,000 Per CIP 1,148,879 5,410,000 4,742,930 2,707,930 2,125,000 3,025,000 5,005,000 Total Expenses 11,609,166 16,309,153 16,291,833 14,904,557 15,279,450 16,910,885 19,067,283 Excess of Revenues over Expenses 1,517,308 (1,924,053) (827,733) 1,535,323 1,751,319 (789,682) (2,294,626) Ending Cash Balance, December 31 5,874,047 3,949,994 3,122,261 4,657,584 6,408,903 5,619,220 3,324,595 C -16