**The Master Book can be viewed at City Hall in the Clerks Office** - - PowerPoint PPT Presentation
**The Master Book can be viewed at City Hall in the Clerks Office** What a CIP IS Tool for the scheduling, planning, and financing of large construction projects and major pieces of equipment Written document that links with the
**The Master Book can be viewed at City Hall in the Clerk’s Office**
What a CIP IS “Tool” for the scheduling, planning,
Written document that links with the
Provides mayor, council, staff and citizens with a
Not “Cast in stone”, it can be revised at any time NOT a legal commitment to complete any particular
Does not obligate future Council’s to any course of
Total Proposed Projects $14,554,722 ($2,910,944 / year) Equipment = 5% Construction = 65% Improvement = 10% Building = 19% Land = 0% Other = 1% *There is another $16.5 million listed in future years
DEPARTMENT 2019-2023 Percent
Airport 2,340,000 $
16.08%
Facility Maint 56,000 $
0.38%
Fire 200,000 $
1.37%
Liquor 1,380,000 $
9.48%
Library 20,000 $
0.14%
Multiple 9,060,000 $
62.25%
Parks 170,000 $
1.17%
Planning 50,000 $
0.34%
Police 150,000 $
1.03%
Sewer 347,500 $
2.39%
Streets 221,222 $
1.52%
Urban Forestry 10,000 $
0.07%
Water 550,000 $
3.78% $14,554,722
Airport 16% Facility Maint 0% Fire 1% Liquor 9% Multiple 62% Parks 1% Police 1% Sewer 2% Streets 2% Water 4%
2019-2023
Airport Facility Maint Fire Liquor Multiple Parks Police Sewer Streets Water
PROJECT DEPARTMENT COST
A/D Building Concept / Remodel
Airport 750,000 $
Helicopter Operations Area
Airport 250,000 $
Squad Car (to be purchased in 2021)
Police 30,000 $
* TH71 S & 11th St
Multiple 1,650,000 $
Deane Park Improve Phase 2 - 2018 & 2019 Parks
25,000 $
Heated Storage Building (moved from 2018)
Water 75,000 $
Heated Storage Building (moved from 2018)
Sewer 75,000 $
Install access controls-doors (from 2017)
Facility Maint 40,000 $
Cover on Lift #2 (replace)
Sewer 20,000 $
Huntsinger Tower Recoat
Water 350,000 $
Rehab lift #5
Sewer 22,500 $ * Bonded projects
Total $3,287,500
Airport 30% Facility Maint 1% Multiple 50% Parks 1% Police 1% Sewer 4% Water 13%
2019
Airport Facility Maint Multiple Parks Police Sewer Water
PROJECT DEPARTMENT COST
Front End Loader/Blower Airport 240,000 $ East Apron Rehabilitation (FFY 2019) Airport 500,000 $
East 16 unit T Hangar Rehabilitation (FFY 2019)
Airport 250,000 $ FBO Industrial Lot Expansion Airport 100,000 $ Squad Car Police 30,000 $
* Fair,Stevens,Front,5th Str
Multiple 2,980,000 $ Wheel Loader Grapple Urban Forestry 10,000 $ Drive on Hoist for 1 ton truck Facility Maint 16,000 $ Tractor/Mower (moved from 2019) Sewer 175,000 $ New Well Water 125,000 $ Rehab Lift #9 Sewer 35,000 $
$4,461,000
* Bonded project
Airport 24% Multiple 67% Police 1% Sewer 5% Water 3%
2020
Airport Facility Maint Liquor Multiple Police Sewer Urban Forestry Water
PROJECT DEPARTMENT COST
Private Hangar Taxilane Ext/Site Prep Lot 5-8 Airport 250,000 $ Squad Car (to be purchased in 2021) Police 30,000 $
* Franklin,Grove,King Street Utility & Street Impr
Multiple 1,855,000 $
* Overlay Industrial Rd-Commerce-Ind. Ave
Multiple 325,000 $ Comprehensive Plan Update-(from 2018) Planning 50,000 $ Deane Park Improve Phase 2 - 2018 & 2019 Parks 72,500 $ Liquor Store Building (Moved from 2019) Liquor 1,380,000 $ TOTAL 3,962,500 $
* Bonded project
Airport 6% Liquor 35% Multiple 55% Parks 2% Planning 1% Police 1%
2021
Airport Liquor Multiple Parks Planning Police
PROJECT DEPARTMENT COST
Salt/Sand Shed w/ Pavement Streets 221,222 $
* 2nd Street, 4th Street & Adjacent Alleys
Multiple 2,250,000 $ Squad Car Police 30,000 $ Breathing Gear (Trying for a grant) Fire 200,000 $ Rehab lift #6 Sewer 20,000 $
* Bonded Projects
$2,721,222
Fir e… Multiple 83% Police 1% Sewer 1% Streets 8%
2022
Fire Multiple Police Sewer Streets
PROJECT DEPARTMENT COST
Library HVAC system plans Library 20,000 $ Squad Car (to be purchased in 2021) Police 30,000 $ Deane Park Improve Phase 2 - 2018 & 2019 Parks 72,500 $
$122,500
Library 16% Parks 59% Police 24%
2023
Library Parks Police
PROJECT DEPARTMENT COST
Squad Car (to be purchased in 2021) Police 30,000 $ Wood Chipper 2014 (move to other yrs) Streets 20,000 $ Gravel Conveyor Streets 10,000 $ Crack Fill Machine Streets 45,320 $ Library Building Admin 1,900,000 $ Garage Bay Additions-PW/Safety Bldg Police 273,000 $ Red Bridge Park Impr Bldg Parks 65,000 $
* Western Avenue Overlay (South)
Multiple 100,000 $
* Western Avenue Overlay (North)
Multiple 80,000 $ Rice Park Parks 384,000 $ Tennis Court Replacement (4) Parks 450,000 $
* Riverside Area Phase II
Multiple 2,300,000 $ Fire Engine Fire 500,000 $
* Central Ave & Baywood Extension
Multiple 3,800,000 $ Video & Access Control Facility Maint 60,000 $ Police Body Worn Camera Systems Police 19,645 $ Construct South Connector Twy to Rwy 36 Airport 400,000 $ Install Taxiwa MITLS-Rwy 36 S Conn. Twy Airport 150,000 $ Runway 13-31 Pavement Reconstruction Airport 1,200,000 $
* Bonded Projects
PROJECT DEPARTMENT COST
Construct South Connector Twy to Rwy 36 Airport 400,000 Install Taxiwa MITLS-Rwy 36 S Conn. Twy Airport 150,000 Runway 13-31 Pavement Reconstruction Airport 1,200,000 Pavement crack and joint repair Airport 60,000 16 Unit T-Hangar 2017 West Apron Airport 700,000 $ 16 Unit T-Hangar 2017 (Prep) West Apron Airport 300,000 $ T-Hangar Taxilane Extension Airport 350,000 $ East Apron Expansion (FFY 2019) Airport 500,000 $ East 16 unit T Hangar demolition (FFY 2019) Airport 100,000 $ Runway 18-36 Pavement Rehabilitation Airport 500,000 $ Pavement crack and joint repair Airport 60,000 $ Fuel System Upgrade Airport 100,000 $ Master Plan / ALP update Airport 500,000 $ Pavement crack and joint repair Airport 60,000 $ Runway 13-31 Pavement Rehabilitation Airport 500,000 $ Runway 18-36 Pavement Reconstruction Airport 1,000,000 $
* Bonded Projects
$16,516,965
2012 2013 2014 2015 2016 2017 SALES AND COST OF SALES Sales $3,196,977 $3,283,862 $3,356,957 $3,200,752 $3,168,028 $2,989,179 Cost of Sales $2,396,366 $2,464,476 $2,536,797 $2,380,582 $2,405,513 $2,231,452 Gross Profit $800,611 $819,386 $820,160 $820,170 $762,515 $757,727
25% 25% 24% 26% 24% 25%
OPERATING EXPENSES Wages and Salaries $319,189 $327,336 $334,215 $353,521 $370,564 $383,216 Materials and Supplies $9,230 $10,016 $10,177 $9,552 $9,899 $8,447 Repairs and Maintenance $7,054 $5,606 $17,057 $18,320 $1,883 $31,178 Professional Services $51,230 $56,494 $58,830 $58,819 $62,460 $66,903 Insurance $14,363 $16,969 $16,525 $13,836 $16,428 $15,170 Utilities $20,702 $21,409 $21,916 $20,165 $19,207 $20,091 Depreciation $34,186 $34,971 $35,668 $37,348 $39,965 $39,965 Other Expense $5,425 $3,259 $2,978 $6,046 $3,618 $2,760 Rent $570 $666 $588 $712 $738 $614 Total Operating Expenses $461,949 $476,726 $497,954 $518,319 $524,762 $568,344 Operating Income (Loss) $338,662 $342,660 $322,206 $301,851 $237,753 $189,383 Rent Investment Income $1,026 $1,247 $1,473 $1,919 $1,226 $1,780 Operating grants & contributions $1,183 $93 Other Income $338 $361 $197 $433 $215 Total Nonoperating Revenues (Expenses) $1,364 $1,608 $1,670 $2,352 $2,624 $1,873 Income (Loss) before Capital Contributions, Insurance Refunds and Transfers $340,026 $344,268 $323,876 $304,203 $240,377 $191,256 Capital Contributions Insurance Refunds $2,775 $5,845 $1,149 Transfers Out ($134,002) ($85,232) ($161,380) ($105,735) ($296,603) ($305,131) Change in Net Position $206,024 $261,811 $162,496 $204,313 ($56,226) ($112,726)
Liquor Store Audit Comparisons
2019-2023 Effect on Liquor Reserves
DEPT
2019 2020 2021 2022 2023
TOTAL
Admin
Airport 93,750 $ 172,500 $
266,250 $ Facility Maint 10,000 $
10,000 $ Fire
Liquor
1,380,000 $
1,380,000 $ Library
20,000 $ 20,000 $ Multiple
Parks
36,250 $
36,250 $ 72,500 $ Planning
25,000 $
25,000 $ Police
Sewer
Storm Sewer
Streets
221,222 $
221,222 $ Urban Forestry
W/S
Water
Grand Total
103,750 $ 172,500 $ 1,441,250 $ 221,222 $ 56,250 $ 1,994,972 $
Liquor Transfers from 2003 - 2017
DEPT TOTAL AMT % Airport 689,319 $ 21%
5,000 $ 0% Fire 291,699 $ 9% General 447,872 $ 14% Parks 636,794 $ 19% Planning 63,640 $ 2% Police 150,755 $ 5% Public Works 680,793 $ 21% PW/W/S 84,854 $ 3% Water/Sewer 40,830 $ 1% Library 90,900 $ 3% Admin 110,022 $ 3% 3,292,477 $ 100% BREAKDOWN OF DEPARTMENTS
Parks 2017 Chevy Silverado Pickup 2017 $52,144.00 Parks 2017
Deane Park Restrooms (Bal from 2016)
$51,185.22 Public Works 2017 Bucket Truck (#19) $19,248.10 Admin 2017 City Hall Renovations $109,195.04 Library 2017 Library Roof $65,899.64 Parks 2016 Pioneer Park Restrooms $798.16 Parks 2016 Deane Park Restrooms $54,666.37 Police 2016 Police laptops $17,968.80 Fire 2016 Old Liquor Store Acquistion $186,940.01 Admin 2016 City Hall remodel $826.77 Public Works 2016 2016 Ford F250 $35,402.89 Library 2015 Library Study $25,001 Police 2015 Police Equipment (car-laptops) $47,000 Parks 2015 Improv to depot and Lindquist $33,734 Parks 2014 Heartland Trail Project $113,161 Police 2013 Police Investigator car $17,186 Police 2012 Police Radio upgrade $44,610 Public Works 2011 Cat Loader $104,377 Public Works 2011 Plastic Cutting Edges-Main Ave $3,860 Public Works 2011 Snow Bucket - rubberized $5,846 Public Works 2011 Elgin Sweeper $174,374 Police 2011 Squad Car $23,990 Parks 2011 Portion of Red Bridge Parking Lot $14,500 Public Works 2010 Plow Truck (portion) $132,252 Parks 2010 Mower and Trailer $10,618 Fire 2010 Relief Association-Fire Dept $27,311
2010 Addt'l amt to HCREDC $5,000 Parks 2009 Kaywood Trail $47,651 Planning 2008 Downtown Revitalization Plan-Bal $8,269 Planning 2008 Community Center $18,000 Parks 2008 Kaywood Trail $35,980 General 2008 Balance General Fund $72,361 PW/W/S 2007 Cold Storage Building $84,854 Public Works 2007 Sterling Plow Truck-2007 $136,038 Planning 2007 Downtown Revitalization Plan $37,371 Parks 2007 Depot Park Playground Equip $139,170 Parks 2007 Depot Park Paving/Sidewalks $83,186 Water/Sewer 2006 2006 Chevy 3500 Truck w/ hoist $40,830 Public Works 2006 2006 Ford F350 w/ flatbed $42,812 Public Works 2006 Generator $26,583 Fire 2006 2007 Flatbed w/ Compart &Pump $77,448 General 2004 Balance General Fund $202,064 General 2003 Balance General Fund $173,447
Airport
2017
$7,458
2016
$0
2015
$0
2014
$48,219
2013
$68,046
2012
$89,392
2011
$65,351
2010
$109,255
2009
$10,615
2008
$96,406
2007
$49,255
2006
$40,054
2005
$18,224
2004
$44,692
2003
$42,351 $689,319
2019 2020 2021 2022 2023 2024 2025 2026 Tax Levy $711,505 $729,184 $757,991 $772,856 $782,197 $718,890 $735,779 $655,460 $711,505 $729,184 $757,991 $772,856 $782,197 $718,890 $735,779 $655,460 $580,000 $600,000 $620,000 $640,000 $660,000 $680,000 $700,000 $720,000 $740,000 $760,000 $780,000 $800,000
Additional Information Regarding Completed Bonded Projects – Assets on the following Pages
2001 $ 2,530,000 GO Bonds (refinanced in 2009) 2003 $ 925,000 GO Bonds (refinanced in 2009) CSAH 15 w/s Baywoods Addition Malm Easement McGrane's 2nd Addition Gilbert Timbers Phase 1 6th Street Malm's Addition 2004 $ 2,245,000 GO Bonds (refinanced in 2010) Sanquist Addition FishHook Lake/Deane Point 7th Street SE Timbers Phase 2 8th Street SE FishHook Avenue Alleys 8th Street W 2007 $ 3,945,000 GO Bond (refinanced in 2012) City Shop Utilities Hwy 34E Hydrants & Gate Valves State/DNR CSAH 15 Storm Sewer (City Share) Hwy 34W Barscreen Central/South Downtown Alleys 7 Block Sewer Sidewalk Reconstruction Pleasant 2008 $ 1,215,000 GO Bonds (refinanced 2015) 2009 $ 535,000 GO Refunding Bond Edmond Drive PW/Safety Bldg Hollinger Street/Eastern Avenue Bear Path Drive 2010 $ 1,440,000 GO bond (a) (refinanced in 2016) Eagle Drive Southwest 2nd Street West 4th Street $ 20,967,400 Total 2010 $ 4,740,000 GO Bond (b) $ 6,448,520 Interest Main Avenue $ 27,415,920 Grand Total (when completely paid) 2015 $ 3,392,400 GO Bond Riverside $ 1,126,526 Savings due to refinancing North Main
Bonded Projects Completed Since 2001
Total Assets
Fund/Department Total Assets Library 638,366 $ 1% Parks 3,120,332 $ 4% Water 14,136,987 $ 17% Sewer 26,144,360 $ 32% Liquor 1,086,973 $ 1% Storm Sewer 612,164 $ 1%
1,616,454 $ 2% Administration 23,849 $ 0% Internal Svc Fund 517,355 $ 1% Police 365,411 $ 0% Fire 3,150,325 $ 4% Streets 16,524,798 $ 20% Street Lighting 188,200 $ 0% Airport 14,647,674 $ 18% 82,773,248 $