Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
2019 Capital Funds book
CAPITAL FUNDS INDEX: Fund Summaries: Buildings Improvement Capital Equipment Park Improvement Utilities Infrastructure Stormwater Streets Improvement & Debt Service APPENDIX: Sources & Uses 2019-2023 & 2024-2035 Fiscal Year 2019 SOURCES 2018 Est. Actual 2018 2019 2020 2021 2022 2023 2024-2029 2030-2035 Community Center Fund Transfer (1)90,185$ 90,185$ 90,000$ 90,000$ 90,000$ 110,000$ 110,000$ 684,000$ 796,000$ Reimbursement for Liquor Stores - - - - - 99,000 - 123,960 - Public Facilities Capital Levy (2)73,000 73,000 78,000 83,000 88,000 93,000 98,000 690,000 750,000 TOTAL 163,185$ 163,185$ 168,000$ 173,000$ 178,000$ 302,000$ 208,000$ 1,497,960$ 1,546,000$ USES City Hall/Community Center 22,500$ 26,371$ 109,000$ 177,100$ 180,000$ 27,500$ -$ 397,622$ 415,850$ Fire Station - - 12,000 - - 61,000 - 125,917 127,500 Public Works 16,500 10,202 12,000 - - 7,500 48,861 515,193 140,000 Park Shelters - 24,170 8,000 16,000 22,000 5,000 14,000 55,730 20,000 Liquor Stores - - - - - 99,000 - 123,960 - TOTAL 39,000$ 60,743$ 141,000$ 193,100$ 202,000$ 200,000$ 62,861$ 1,218,422$ 703,350$ NET CHANGE 124,185 102,442 27,000 (20,100) (24,000) 102,000 145,139 279,538 842,650 BEGINNING CASH BALANCE 249,911 249,911 352,353 379,353 359,253 335,253 437,253 437,253 716,791 ENDING CASH BALANCE 374,096$ 352,353$ 379,353$ 359,253$ 335,253$ 437,253$ 582,392$ 716,791$ 1,559,441$ (1) Community Center fund transfer increase coincides with increase in School District rent in 2022. (2) Additional Building Improvement Levy of $5,000 annually, beginning in 2019, ending in 2029. BUILDINGS IMPROVEMENT PLAN 2019 - 2035 BUILDINGS IMPROVEMENT PROGRAM BLDG YEAR BUILT DESCRIPTION LIFE CONDITION GOOD FAIR POOR QTY COST EST. INTERNAL SEBESTA 2018 EST ACTUAL 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 City Hall 1996 Building Components Metal Door Frame & Replacement PD and EE Entrances 2018 Multi.Internal 22,500$ 19,962$ -$ -$ -$ -$ -$ -$ -$ -$ -$ 28,000$ -$ -$ -$ -$ -$ -$ -$ Securtiy upgrades - Cameras 2016 7 Internal - - - - - - - - - - - 22,710 - - - - - - - Securtiy upgrades -Control Server 2016 1 Internal - - - - - - - - - - - 46,706 - - - - - - - Securtiy upgrades - Entrance controls 2017 Multi.Internal - 754 - - - - - - - - - 46,706 - - - - - - - Replacement of Fire Alarm Panel 2016 1 Internal - - - - - - - - - - - - - 25,000 - - - - - Parking Lot LED Lighting 2015 Multi.Internal - - - - - - - - - - - - - - - - - - 15,000 Building LED Lighting 2015 Multi.Internal - - - - - - - - - - - - - - - - - - 25,000 Boilers/Fans etc Replaced in 2015-130K 2 Sebesta - 5,655 - - - 7,500 - - - 7,500 - - - 7,500 - 160,850 - 7,500 - RTU-3 (Day Care)Fair 1 Sebesta - - 64,000 - - - - - - - - - - - - - - - - RTU-4 (City)Fair 1 Sebesta - - - 69,000 - - - - - - - - - - - - - - - RTU-1 (Gym)Fair 1 Sebesta - - - 46,000 - - - - - - - - - - - - - - - RTU-2 (Multi-purpose)Fair 1 Sebesta - - - 27,600 - - - - - - - - - - - - - - - RTU-5 (Police)Fair 1 Sebesta - - - 34,500 - - - - - - - - - - - - - - - Domestic Water Heaters Fair 2 Sebesta - - - - - - - 16,000 - - - - - - - - - - - Relamp & Reballast (LED-PD) Done w/2015 LED project Multi.Sebesta - - - - - - - - - - - - - - - - - - 5,000 Roof Poor - Fair 1 Sebesta - - - - 180,000 - - - - - - - - - - - - - - Acoustic panels/overflow AV 2017 1 Internal - - - - - - - - - - - - - - - - 15,000 - - Community Service VCF Tiles 2017 1 Sebesta - - - - - - - - - - - - - - - - 15,000 - - Overhead garage doors 25 years 2 Internal - - - - - 20,000 - - - - - - - - - - - - - Outdoor sign Fair 1 Internal - - 45,000 - - - - - - - - - 55,000 - - - - - - Tuck pointing -brick 35 years 1 Internal - - - - - - - - - - - - - - 140,000 - - - - Parking Lot mill and overlay 30 years 1 Internal - - - - - - - - - 175,000 - - - - - - - - - TOTAL 22,500$ 26,371$ 109,000$ 177,100$ 180,000$ 27,500$ -$ 16,000$ -$ 182,500$ -$ 144,122$ 55,000$ 32,500$ 140,000$ 160,850$ 30,000$ 7,500$ 45,000$ Fire Station 2005 Building Components Metal Door Frame & Replacement Fair Internal - - - - - 12,500 - - - - - - 15,000 - - - - - - Securtiy upgrades -Cameras 2016 4 Internal - - - - - - - - - - - 8,360 - - - - - - - Securtiy upgrades - Entrance controls 2017 Multi.Internal - - - - - - - - - - - 7,005 - - - - - - - Rooftop Units Fair - Good Multi.Sebesta - - - - 31,000 - - - - - - - - - - - - - Makeup Air Unit Fair 2 Sebesta - - - - - 17,500 - - - - - - - - - - - - - Domestic Water Heaters 2016 1 Sebesta - - - - - - - - - 12,880 - - - - - - - - - Relamp & Reballast Done w/2015 LED project Multi.Sebesta - - - - - - - - - - - - - - - - - - Roof Fair 1 Sebesta - - - - - - - - 47,672 - - - - - - - - - - Exterior Paint 1 Internal - - 12,000 - - - - - - - - - - - - - - - - Tuck pointing -brick 35 years 1 Internal - - - - - - - - - - - - - - - - - - 67,500 Parking Lot mill and overlay 30 years 1 Internal - - - - - - - - - 35,000 - - - - - - - - - Overhead garage doors 25 years 3 Internal - - - - - - - - - - - - - 60,000 - - - - - TOTAL -$ -$ 12,000$ -$ -$ 61,000$ -$ -$ 47,672$ 47,880$ -$ 15,365$ 15,000$ 60,000$ -$ -$ -$ -$ 67,500$ Public Works 2004 Building Components Metal Door Frame & Replacement Fair Internal - - - - - 7,500 - - - - - - 9,000 - - - - - - Securtiy upgrades -Cameras 2016 3 Internal - - - - - - - - - - - 6,990 - - - - - - - Securtiy upgrades - Entrance controls 2017 Multi.Internal - - - - - - - - - - - 17,515 - - - - - - - Rooftop Unit 2017 1 Sebesta 16,500 4,830 - - - - 23,000 - - - - - - - - - - - - Makeup Air Unit Good 3 Sebesta - - - - - - - 109,250 - - - - - - - - - - - Air Handling Unit Good 1 Sebesta - - - - - - - 8,050 - - - - - - - - - - - Exhaust Fans Good 6 Sebesta - - - - - - - 13,340 - - - - - - - - - - - Domestic Water Heaters Good 2 Sebesta - - - - - - 25,861 - - - - - - - - - - - - Relamp & Reballast (LED) Done w/2015 LED project Multi.Sebesta - - - - - - - - - - - - - - - - - - - Roof Fair 1 Sebesta - - - - - - - - 206,048 - - - - - - - - - - Overhead garage doors/Shop fixtures 25 years 7 Internal - 5,372 - - - - - - - - - - 105,000 - Exterior Paint Internal - - 12,000 - - - - - - - - - - - - - - - - Parking Lot mill and overlay 30 years Internal - - - - - - - - - - - - - - - - - 140,000 - Rehab salt storage 25 years Internal - - - - - - - - - - - - 40,000 - - - - - - TOTAL 16,500$ 10,202$ 12,000$ -$ -$ 7,500$ 48,861$ 130,640$ 206,048$ -$ -$ 24,505$ 154,000$ -$ -$ -$ -$ 140,000$ -$ BUILDINGS IMPROVEMENT PROGRAM BLDG YEAR BUILT DESCRIPTION LIFE CONDITION GOOD FAIR POOR QTY COST EST. INTERNAL SEBESTA 2018 EST ACTUAL 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 Central Park Pavillon 2003 Roof 2018 16,500 Securtiy upgrades -Cameras 2016 8,360 Securtiy upgrades - Entrance controls 2016 7,005 HVAC Fair 12,000 Domestic water heaters Fair 4,000 Exterior updates Fair 8,000 Interior updates 2018 7,670 Parking Lot mill and overlay 30 years 15,000 -$ 24,170$ 8,000$ 4,000$ 12,000$ -$ -$ -$ -$ -$ -$ 15,365$ -$ -$ -$ -$ -$ -$ -$ Emerald Park Pavillon 2009 Roof Fair 25,000 Securtiy upgrades -Cameras 2016 8,360 Securtiy upgrades - Entrance controls 2016 7,005 HVAC Fair 14,000 Domestic water heaters Fair 5,000 Exterior updates Fair 10,000 Interior updates Fair 12,000 Parking Lot mill and overlay 30 years 20,000 -$ -$ -$ 12,000$ 10,000$ 5,000$ 14,000$ -$ 25,000$ -$ -$ 15,365$ -$ -$ 20,000$ -$ -$ -$ -$ Park Shelters -$ 24,170$ 8,000$ 16,000$ 22,000$ 5,000$ 14,000$ -$ 25,000$ -$ -$ 30,730$ -$ -$ 20,000$ -$ -$ -$ -$ TOTAL IMPROVEMENTS GOVERMENTAL 39,000$ 60,743$ 141,000$ 193,100$ 202,000$ 101,000$ 62,861$ 146,640$ 278,720$ 230,380$ -$ 214,722$ 224,000$ 92,500$ 160,000$ 160,850$ 30,000$ 147,500$ 112,500$ Marketplace Liquor 2005 Building Components Rooftop Unit Fair 2 Sebesta - - - - - 35,000 - - - - - - - - - - - - - Securtiy upgrades -Cameras 2016 1 Internal - - - - - - 10,800 2,925 - - - - - - - Securtiy upgrades - Entrance controls 2017 1 Internal - - - - - - - - - - - 5,915 - - - - - - - Domestic Water Heaters Good 1 Sebesta - - - - - - - 5,500 - - - - - - - - - - - Install New Walk-In Cooler Refrigeration Fair Multi.Sebesta - - - - - - - -- - - - - - - - - - - Relamp & Reballast (LED) Done w/2015 LED project Multi.Sebesta - - - - - - - - - - - - - - - - - - Roof Fair 1 Sebesta - - - - - - - - 36,398 - - - - - - - - - - TOTAL -$ -$ -$ -$ -$ 35,000$ -$ 5,500$ 36,398$ 10,800$ -$ 8,840$ -$ -$ -$ -$ -$ -$ -$ Silver Lake Liquor 2005 Building Components Rooftop Units Good 1 Sebesta - - - - - 64,000 - - - - - - - - - - - - - Securtiy upgrades -Cameras 2016 1 Internal - - - - - - - - - 10,800 - 2,925 - - - - - - - Securtiy upgrades - Entrance controls 2017 Internal - - - - - - - - - - - 5,915 - - - - - - - Exhaust Fans Good 1 Sebesta - - - - - - - - - - - - - - - - - - - Domestic Water Heaters Good 1 Sebesta - - - - - - - - - - - - - - - - - - - Relamp & Reballast (LED) Done w/2015 LED project Multi.Sebesta - - - - - - - - - - - - - - - - - - - Roof Fair 1 Sebesta - - - - - - - - 42,782 - - - - - - - - - - TOTAL -$ -$ -$ -$ -$ 64,000$ -$ -$ 42,782$ 10,800$ -$ 8,840$ -$ -$ -$ -$ -$ -$ -$ TOTAL IMPROVEMENTS ENTERPRISE -$ -$ -$ -$ -$ 99,000$ -$ 5,500$ 79,180$ 21,600$ -$ 17,680$ -$ -$ -$ -$ -$ -$ -$ COMBINED TOTAL IMPROVEMENTS 39,000$ 60,743$ 141,000$ 193,100$ 202,000$ 200,000$ 62,861$ 152,140$ 357,900$ 251,980$ -$ 232,402$ 224,000$ 92,500$ 160,000$ 160,850$ 30,000$ 147,500$ 112,500$ BuildingsBuildings 1996 St. Anthony Community Center St. Anthony Village Liquor Store Marketplace 2005 St. Anthony Fire StaƟon 2004 St. Anthony Public Works Facility BuildingsBuildings 2005 St. Anthony Village Liquor Store Marketplace 2005 St. Anthony Village Liquor Store Silver Lake Village Fiscal Year 2019 SOURCES 2018 Est. Actual 2018 2019 2020 2021 2022 2023 2024-2029 2030-2035 Capital Improvement Levy 233,200$ 233,200$ 258,200$ 283,200$ 308,200$ 333,200$ 358,200$ 2,674,200$ 3,574,200$ MSA/Revolving Funds 90,000 90,000 90,000 90,000 90,000 90,000 90,000 540,000 540,000 Trade/Sale of Equipment 3,500 28,885 5,000 5,000 5,000 5,000 5,000 30,000 30,000 Donations/Grants 40,465 40,465 - - - - - 90,000 33,000 Interest / Equipment note proceeds - 9,459 6,500 5,500 2,500 1,000 1,000 1,390,000 35,000 TOTAL 367,165$ 402,009$ 359,700$ 383,700$ 405,700$ 429,200$ 454,200$ 4,724,200$ 4,212,200$ Uses Police 396,559$ 313,169$ 146,380$ 122,996$ 166,518$ 178,903$ 211,394$ 1,135,020$ 1,340,147$ Fire 88,356 80,201 107,297 187,664 82,955 141,184 79,490 1,426,952 1,567,106 Administration/Finance 103,864 117,674 23,096 2,920 36,850 25,307 5,825 216,109 123,234 Streets 55,332 2,500 163,016 35,388 80,340 48,933 83,916 176,604 206,079 Parks 26,648 21,401 22,726 68,858 83,708 72,009 9,599 106,913 327,334 DAILY OPERATIONS-MINIMAL EQUIPMENT NEEDS 670,759 534,945 462,514 417,826 450,371 466,336 390,225 3,061,598 3,563,901 MINIMAL SHORTFALL (303,594)$ (132,936)$ (102,814)$ (34,126)$ (44,671)$ (37,136)$ 63,975$ 1,662,602$ 648,299$ SPECIFIC OPERATIONS - EQUIPMENT NEEDS Scheduled Items Fire Engines*500,000 495,131 - - - - - 591,212 705,938 Dump Trucks (moved 1 DT to utility fund)- - - - 220,000 - - 270,108 311,538 F750 High Ranger Aerial Truck - - - - - - - 184,566 - 1995 Street 444G Front-End Loader - - - 179,259 - - - - - 1999 Parks 4500 Tractor - - - - - - 83,022 - - 500,000 495,131 - 179,259 220,000 - 83,022 1,045,886 1,017,476 OVERALL SHORTFALL (803,594)$ (628,067)$ (102,814)$ (213,385)$ (264,671)$ (37,136)$ (19,047)$ 616,716$ (369,177)$ NET CHANGE (803,594)$ (628,067)$ (102,814)$ (213,385)$ (264,671)$ (37,136)$ (19,047)$ 616,716$ (369,177)$ BEGINNING CASH BALANCE 1,305,198$ 1,305,198$ 677,131$ 574,316$ 360,931$ 96,261$ 59,125$ 59,125$ 675,840$ ENDING CASH BALANCE 501,604$ 677,131$ 574,316$ 360,931$ 96,261$ 59,125$ 40,078$ 675,840$ 306,664$ * CURRENT PLAN IS TO FINANCE FUTURE ENGINE PURCHASES, UNLESS POST 2023 DEBY LEVY FUNDING IS AVAILABLE CAPITAL EQUIPMENT 2019 - 2035 Fiscal Year 2019 2018 Est. Actual 2018 2019 2020 2021 2022 2023 2024-2029 2030-2035 Police Department Squads 83,160 83,174 85,655 86,058 90,871 93,598 94,037 636,883 760,471 Unmarked 29,561 29,515 - - 32,630 33,446 34,282 116,579 135,231 Retired to Other Services - 1,550 - 796 820 1,689 - 5,767 6,852 Technology 255,400 177,655 38,000 16,070 22,401 29,359 47,472 208,185 209,606 Specialty Equipment 12,448 10,207 22,172 12,396 15,110 6,636 17,273 98,304 120,858 Investigative Equipment 849 849 - 3,412 4,100 - - 9,815 13,098 General Equipment 15,141 10,218 552 4,265 586 14,176 18,329 59,488 94,031 TOTAL PD 396,559$ 313,169$ 146,380$ 122,996$ 166,518$ 178,903$ 211,394$ 1,135,020$ 1,340,147$ Fire Department Apparatus 500,000 495,131 - 90,000 - 46,897 - 705,850 768,964 Station Based Equipment - - - - - - - 15,103 62,966 Protective Gear 58,630 52,641 5,520 16,398 - 14,478 - 264,820 176,330 Technology 541 1,901 13,289 569 5,505 7,359 10,340 86,633 47,520 Protective Equipment/Tools 10,200 10,400 20,900 2,500 10,000 6,650 - 124,325 61,361 Office Furniture 8,021 4,295 1,987 9,098 - - 5,000 35,977 23,350 Debt Service Payments 10,963 10,963 65,600 69,100 67,450 65,800 64,150 785,458 1,132,553 TOTAL FD 588,356$ 575,332$ 107,297$ 187,664$ 82,955$ 141,184$ 79,490$ 2,018,165$ 2,273,045$ Administration/Finance Computer Hardware 13,050 1,500 5,330 930 26,850 15,655 825 62,609 55,263 Computer Software - 25,360 - - - - - 62,500 - Furniture and Equipment 8,920 8,920 15,834 - - - - 75,000 50,000 Council Chambers 81,894 81,894 1,932 1,990 10,000 9,652 5,000 16,000 17,971 TOTAL AF 103,864$ 117,674$ 23,096$ 2,920$ 36,850$ 25,307$ 5,825$ 216,109$ 123,234$ DEPARTMENTAL SUMMARIES 2019-2035 Fiscal Year 2019 2018 Est. Actual 2018 2019 2020 2021 2022 2023 2024-2029 2030-2035 DEPARTMENTAL SUMMARIES 2019-2035 PUBLIC WORKS Streets Department Fleet replacements - - 34,779 - 55,638 38,003 59,026 74,171 127,146 Plows/Dump trucks - - - - 220,000 - - 270,108 330,033 Heavy Equipment 6,623 2,500 6,788 186,217 7,132 7,310 7,493 265,732 56,896 Speciality Equipment 48,709 - 121,449 28,430 17,570 3,619 17,397 21,267 3,542 TOTAL 55,332$ 2,500$ 163,016$ 214,647$ 300,340$ 48,933$ 83,916$ 631,278$ 517,617$ Parks Department Fleet replacements - - - - 49,781 - - 103,894 55,938 Heavy Equipment 10,750 10,750 7,729 1,137 5,857 4,826 73,727 102,908 47,546 Mowers 9,201 - 9,753 62,546 18,571 45,744 - 30,571 138,567 Field Maintenance 500 500 - - 4,685 18,906 - 20,368 27,605 Rink Maintenance 216 6,002 2,539 - 586 - 12,029 5,020 20,909 Speciality Equipment 5,980 4,149 2,705 5,174 4,228 2,534 6,866 28,717 36,770 TOTAL 26,648$ 21,401$ 22,726$ 68,858$ 83,708$ 72,009$ 92,621$ 291,479$ 327,334$ TOTAL PW 81,979$ 23,901$ 185,742$ 283,505$ 384,048$ 120,942$ 176,538$ 922,757$ 844,951$ GRAND TOTAL 1,170,759$ 1,030,076$ 462,514$ 597,085$ 670,371$ 466,336$ 473,247$ 4,292,050$ 4,581,377$ FIXED ASSET SCHEDULE POLICE DEPARTMENT 2018 1.03 1.0609 1.092727 1.125509 1.159274 1.1940523 1.229874 1.26677 1.304773 1.34391638 1.384234 1.425761 1.468534 1.51258972 1.55796742 1.60470644 1.65284763 1.082432 1.104081 1.137203 1.171319 1.206459 1.242653 1.27993225 1.31833 1.35788 1.398617 1.44057502 1.483792 1.528306 1.574155 1.62137988 1.67002128 1.72012192 1.77172557 ASSET REPLACEMENT PROGRAM 36,579 FIXED ASSET #YEAR MAKE DESCRIPTION LIFE QTY UNIT COST 2018 EST. ACTUAL 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 Active Squads 1576 705 2016 DODGE DODGE CHARGER - PATROL 3 1 37,433 - - 41,775 - - 45,649 - - 49,882 - - 54,508 - - 59,562 - - 65,085 - 1577 706 2016 FORD FORD EXPLORER SUV - PATROL 3 1 39,876 - - 43,880 - - 47,948 - - 52,394 - - 57,253 - - 62,562 - - 68,363 - 1598 707 2017 DODGE DODGE CHARGER - PATROL 3 1 39,377 - - - 43,029 - - 47,019 - - 51,379 - - 56,143 - - 61,349 - - 67,037 1599 708 2017 DODGE DODGE CHARGER - PATROL 3 1 39,377 - - - 43,029 - - 47,019 - - 51,379 - - 56,143 - - 61,349 - - 67,037 709 2018 FORD FORD INTERCEPTOR SUV - PATROL 3 1 42,602 42,602 42,615 - - 46,552 - - 50,868 - - 55,585 - - 60,740 - - 66,372 - - 710 2018 DODGE DODGE CHARGER - PATROL 3 1 40,559 40,559 40,559 - - 44,320 - - 48,429 - - 52,920 - - 57,827 - - 63,189 - - 83,160 83,174 85,655 86,058 90,871 93,598 94,037 99,298 102,277 102,757 108,505 111,760 112,286 118,567 122,124 122,697 129,561 133,448 134,075 Unmarked 1557 6 2016 CHEV CHEV IMPALA - INVESTIGATOR 6 1 24,577 - - - - 32,630 - - - - - 37,841 - - - - - 43,896 - - 1600 2017 CHEV CHEV IMPALA - CHIEF 6 1 23,000 - - - - - 33,446 - - - - - 38,787 - - - - - 44,993 - 6902 2018 FORD FORD TAURUS - CAPTAIN 6 1 19,684 29,561 29,515 - - - - 34,282 - - - - - 39,951 - - - - - 46,343 29,561 29,515 - - 32,630 33,446 34,282 - - - 37,841 38,787 39,951 - - - 43,896 44,993 46,343 Retired To Other Services (1) 1558 702 2015 FORD FORD INTERCEPTOR SUV - CSO 7 1 700 - 775 - - - 845 - - - 951 - - - 1,070 - - - 1,204 - 1513 698 2013 FORD FORD INTERCEPTOR SUV - RESERVE 7 1 700 - - - 796 - - - 896 - - - 1,008 - - - 1,135 - - - 1559 703 2015 DODGE DODGE CHARGER - COURT 7 1 700 - 775 - - - 845 - - - 951 - - - 1,070 - - - 1,204 - 1482 2011 FORD FORD FUSION - COURT/SCHOOL 7 1 700 - - - - 820 - - - 923 - - - 1,039 - - - 1,169 - - - 1,550 - 796 820 1,689 - 896 923 1,901 - 1,008 1,039 2,140 - 1,135 1,169 2,408 - Technology NA NA 2018 VARIOUS SQUAD COMPUTERS 5 9 4,550 31,500 40,900 - - 3,519 - 47,472 - 3,960 - - 55,033 - 4,729 - 63,799 - - 1486 NA 2011 VARIOUS ETHERNET SWITCH 10 1 13,000 - - - 13,000 - - - - - - - - - 19,868 - - - - - NA 2018 VARIOUS PANASONIC INTEGRATED VIDEO SYSTEM 5 varies varies 160,500 122,759 38,000 - 18,882 26,101 - - 42,142 29,982 12,244 5,913 - - 34,757 51,829 14,203 - 7,273 NA NA VARIOUS VARIOUS PORTABLE/SQUAD RADIOS (2)varies varies varies 63,400 13,996 - 3,070 - 3,257 - 3,456 - 3,666 - 51,789 - 4,126 - 4,378 - 4,644 - 255,400 177,655 38,000 16,070 22,401 29,359 47,472 3,456 46,102 33,648 12,244 112,735 - 23,994 39,486 56,207 78,002 4,644 7,273 Specialty Equipment NA NA ~ 2005 VARIOUS REDMAN SUIT & TASER SUIT 15 1 ea 1,000 - - - - - - - - 1,318 1,358 - - - - - - - - - NA NA VARIOUS VARIOUS BULLET RESISTANT SHIELDS 5 2 2,500 - - - - 5,857 - - - - 6,789 - - - - 7,871 - - - - NA NA VARIOUS VARIOUS PBT (BREATHLIZERS)5 10 500 541 541 552 569 586 603 621 640 659 679 699 720 742 764 787 811 835 860 886 NA NA VARIOUS VARIOUS RIOT GEAR - 12 sets total 10 6/6 1,000 6,495 - - - - - 7,456 - - - - 8,643 - - - - 10,020 - - NA NA VARIOUS VARIOUS TASERS/BATTERIES 5 23 1,500 3,247 3,247 3,312 3,412 3,514 3,619 3,728 3,840 3,955 4,074 4,196 4,322 4,451 4,585 4,722 4,864 5,010 5,160 5,315 NA NA VARIOUS VARIOUS FIREARMS 15 23+varies 2,165 2,165 2,208 2,274 2,343 2,413 2,485 2,560 2,637 2,716 2,797 2,881 2,968 3,057 3,148 3,243 3,340 3,440 3,543 NA NA VARIOUS VARIOUS P.DEPT ISSUED SIDE ARMS+HOLSTERS 8-10 23 700 - 16,100 - - - - - - - 20,700 - - - - - - - 36,675 NA NA VARIOUS VARIOUS RADAR 4 7 1,200 - 4,254 - 2,729 2,811 - 2,982 3,072 - - 3,357 3,457 - - 3,778 3,891 - - 4,252 NA NA 2014 VARIOUS BIKES 10 2 1,500 - - - 3,412 - - - - - 4,074 - - - - - - - - - 12,448 10,207 22,172 12,396 15,110 6,636 17,273 10,111 8,569 19,689 31,749 20,024 8,161 8,406 20,307 12,809 19,205 9,461 50,671 3% AVERAGE ANNUAL INFLATION FIXED ASSET SCHEDULE POLICE DEPARTMENT 2018 1.03 1.0609 1.092727 1.125509 1.159274 1.1940523 1.229874 1.26677 1.304773 1.34391638 1.384234 1.425761 1.468534 1.51258972 1.55796742 1.60470644 1.65284763 1.082432 1.104081 1.137203 1.171319 1.206459 1.242653 1.27993225 1.31833 1.35788 1.398617 1.44057502 1.483792 1.528306 1.574155 1.62137988 1.67002128 1.72012192 1.77172557 ASSET REPLACEMENT PROGRAM 36,579 FIXED ASSET #YEAR MAKE DESCRIPTION LIFE QTY UNIT COST 2018 EST. ACTUAL 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 3% AVERAGE ANNUAL INFLATION Investigative Equipment NA NA VARIOUS VARIOUS TRANSCRIPTION EQUIP/RECORDERS 5-7 7 500 849 849 - - 4,100 - 965 - - 4,895 - - 1,528 - - 1,670 - - NA NA VARIOUS VARIOUS SECURITY CAMERAS/DVR/INTERVIEWS (3)5 16 5,600 - - - - - - - - - - - - - - - - - - - NA NA ~2007 VARIOUS SURVEILLANCE EQUIPMENT 10-15 1 3,000 - - - 3,412 - - - - 3,955 - - - - 4,585 - - - - 5,315 849 849 - 3,412 4,100 - - 965 3,955 - 4,895 - - 6,113 - - 1,670 - 5,315 General Equipment 1583 NA 2016 VARIOUS COPIER 1 7 11,250 - - - - - 13,573 - - - - - 16,206 - - - - - 19,351 - NA NA VARIOUS VARIOUS OFFICE COMPUTERS -18 / PRINTERS-2 6 20 750 14,600 9,677 - 2,559 - - 17,708 - 2,966 - - 20,528 - 3,439 - - 23,798 - - NA NA VARIOUS VARIOUS VARDA UNITS 10 2 3,000 - - - - - - - - - 8,147 - - - - - - - - - NA NA VARIOUS VARIOUS MAIN OFFICE FURNITURE / CHAIRS 15 30+250 541 541 552 1,706 586 603 621 640 659 679 699 720 742 764 787 811 835 860 886 NA NA 2014 VARIOUS FRONT OFFICE FURNITURE / LOCKER ROOM 10-15 NA EST - - - - - - - - 7,500 - - - - 35,000 - - - - 7,500 15,141 10,218 552 4,265 586 14,176 18,329 640 11,125 8,826 699 37,455 742 39,203 787 811 24,633 20,211 8,386 TOTAL POLICE 396,559 313,169 146,380 122,996 166,518 178,903 211,394 115,366 172,951 166,822 195,934 321,770 162,178 198,422 182,703 193,659 298,135 215,165 252,062 FOOTNOTES (1)EXTENDING LIFE OF ACTIVE/UNMARKED OFFICER VEHICLES WITH BUILD-UP/TEAR DOWN COSTS, ALSO REPLACES FIRE DEPARTMENT INSPECTION VEHICLE (2)PORTABLE RADIOS LEASED RATHER THAN PURCHASED IN 2018 (3)REMOVED AS EQUIPMENT BEING REPLACED AS PART OF THE PANASONIC INTEGRATED VIDEO SYSTEM Police Department 1 2016 Ford Explorer (1) 2015, 2018 Ford Interceptor SUV (2) 2015-2018 Dodge Charger (5) 2018 Ford Taurus 2016, 2017 Chevrolet Impala (3) 2011 Ford Fusion (1) FIXED ASSET SCHEDULE FIRE DEPARTMENT 1.082432 0 1.104081 1.137203 1.171319 1.206459 1.242653 1.2799323 1.31833 1.35788 1.398617 1.440575 1.483792 1.528306 1.574155 1.62138 1.670021 1.720122 1.771726 ASSET REPLACEMENT PROGRAM 1.03 1.0609 1.092727 1.125509 1.159274 1.1940523 1.229874 1.26677 1.304773 1.343916 1.384234 1.425761 1.468534 1.51259 1.557967 1.604706 1.652848 FIXED ASSET #YEAR MAKE DESCRIPTION LIFE QTY UNIT COST 2018 EST. ACTUAL 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 Apparatus 1155 2018 CUSTOM FIRE ENGINE - 14 25-30 1 425,000 500,000 495,131 - - - - - - - - - - - - - - - - - 1154 1999 TOYNE ENGINE - 11 25-30 1 425,000 - - - - - - - 591,212 - - - - - - - - - - - 1288 2000 HME ENGINE - 12 25-30 1 425,000 - - - - - - - - - - - - - 705,938 - - - - - 1156 1991 ROAD RESCUE UTILITY TRUCK (rebuild vs replace)30 1 150,000 - - - 90,000 - - - - - - - - - - - - - - - TBD 2016 FORD RESCUE - F350 10 1 80,000 - - - - - - - - - 100,189 - - - - - - - - - 1487 2011 FORD CHIEF VEHICLE 150 10 1 31,500 - - - - - 46,897 - - - - - - - - - 63,026 - - - 1385 2006 FORD INSPECTIONS VEHICLE (1)n/a 1 - - - - - - - - - - - - - - - - - 2006 BOAT AND MOTOR 20 1 8,000 - - - - - - - - - 14,449 - - - - - - - - - 500,000 495,131 - 90,000 - 46,897 - 591,212 - 114,638 - - - 705,938 - 63,026 - - - Station Based Equipment 1390 2006 COMPRESSOR 25-30 1 40,000 - - - - - - - - - - - - - 62,966 - - - - 2007 POWER WASHER 15-20 1 1,500 - - - - - - - 1,920 - - - - - - - - - - - 2003 TO WASHER DRYER 20 2 10,000 - - - - - - - 13,183 - - - - - - - - - - - - - - - - - 1,920 13,183 - - - - - 62,966 - - - - Protective Gear Various TURNOUT GEAR 10 25 2,000 - - - 16,398 - - - 51,197 - - - - - 21,396 - - 66,801 - - Various ROOKIE TURN OUT GEAR 10 6 2,000 12,989 7,000 - - - 14,478 - - - - 16,783 - - - - 19,457 - - - Dated HIGH VISABLITY EMS COATS 15 32 225 7,641 7,641 - - - - - - - 9,777 - - - - - - - - - 2001 SCBA COMPLETE PACK 20 30 4,700 - - - - - - - 180,470 - - - - - - - - - - - Various SCBA BOTTLES/FACEPIECE 15 65 800 38,000 38,000 - - - - - - - - - - - - 59,818 - - - - 2005 ICE RESCUE EQUIPMENT 10 4 1,250 - - 5,520 - - - - - 6,592 - - - - - - - - - 8,859 58,630 52,641 5,520 16,398 - 14,478 - 231,668 6,592 9,777 16,783 - - 21,396 59,818 19,457 66,801 - 8,859 Technology 1501 Various PAGERS/BATTERIES 5 35 600 - - 4,637 - 4,920 - 5,219 - 5,537 - 5,874 - 6,232 - 6,611 - 7,014 - 7,441 2006 VEHICLE COMPUTERS 5 2 2,000 - - 4,000 - - - - 5,120 - - - - 5,935 - - - - 6,880 - Various OFFICE COMPUTERS 5 7 800 - 1,360 - - - 6,756 - - - - 6,713 - - - - 7,783 - - - 2014 RADIOS/BATTERIES 12 12 2,500 - - - - - - - - - 20,368 20,979 - - - - - - - - 2008 AUDIO VISUAL EQUIPMENT 6 5 Various - - 4,100 - - - 4,500 - - - 5,734 - - - - - 6,847 - - Various OTHER BATTERIES 500 541 541 552 569 586 603 621 640 659 679 699 720 742 764 787 811 835 860 886 541 1,901 13,289 569 5,505 7,359 10,340 5,760 6,196 21,047 40,000 720 12,909 764 7,399 8,593 14,696 7,741 8,327 3% AVERAGE ANNUAL INFLATION OR ESTIMATED ACTUAL FIXED ASSET SCHEDULE FIRE DEPARTMENT 1.082432 0 1.104081 1.137203 1.171319 1.206459 1.242653 1.2799323 1.31833 1.35788 1.398617 1.440575 1.483792 1.528306 1.574155 1.62138 1.670021 1.720122 1.771726 ASSET REPLACEMENT PROGRAM 1.03 1.0609 1.092727 1.125509 1.159274 1.1940523 1.229874 1.26677 1.304773 1.343916 1.384234 1.425761 1.468534 1.51259 1.557967 1.604706 1.652848 FIXED ASSET #YEAR MAKE DESCRIPTION LIFE QTY UNIT COST 2018 EST. ACTUAL 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 3% AVERAGE ANNUAL INFLATION OR ESTIMATED ACTUAL Protective Equipment/Tools 2017 DEFIBRILLATOR 7 5 1,700 - - - - - - - 6,528 4,482 - - - - - 8,028 5,513 - - - 2017 DEFIBRILLATOR FOR POLICE DEPT 7 6 1,700 - - - - - - - 6,528 6,723 - - - - - 8,028 8,269 - - - Various HOSE REPLACEMENT 15 116 100-425 7,700 7,900 7,700 2,500 - 2,650 - 2,800 - 2,800 - 3,000 - 3,000 - 3,250 - 3,250 - Various HOSE APPLIANCES 10 30 150 - - - - 3,000 - - - - - - - - - 4,722 - - - - 1468 Various THERMAL IMAGER 10 5 5,500-12,000 - - 10,000 - - - - 12,000 - - - - 12,000 - - - - - - Various NOZZLE REPLACEMENT 15 1,000-2,500 - - - - 7,000 - - - - 7,300 - - - - 7,500 - - - - 2013 LUCAS DEVICE 15 1 16,500 - - - - - - - - - - - 23,769 - - - - - - - Various FANS AND BLOWERS 15 8 2,400 - 2,500 - - - - - - - - - - - - - - - 3,000 - Various SAWS (CHAIN AND CUT OFF)10 6 1,650 - - 2,000 - - 4,000 - - - - 4,500 - - - - 5,000 - - - Various GAS MONITOR 6 10 600 2,500 - 1,200 - - - - - 1,350 - - 750 - - - - - 1,800 - 1290 Various OUTDOOR WARNING SIRENS 30 2 22,600 - - - - - - - 29,794 - - - - - - - - - - 10,200 10,400 20,900 2,500 10,000 6,650 - 27,855 42,350 10,100 4,500 27,519 12,000 3,000 28,279 22,032 - 8,050 - Office Furniture 2004 OFFICE CHAIRS/FURNITURE 15 9 315 3,150 - - - - - 5,000 - - - 6,000 - - - - 6,000 - - - 2004 TRAINING ROOM CHAIRS 15 35 85 - - - - - - - - - - - - - 4,547 - - - - - 2004 DAY ROOM/KITCHEN/APPLIANCES 15 6 600 - - 1,987 2,047 - - - - - - - - 2,671 2,751 - - - - - 2014 COPIER 6 1 6,200 - - - 7,051 - - - - - 8,419 - - - - - 10,053 - - - 2003 FITNESS EQUIPMENT 10 3 4,500 4,871 4,295 - - - - - - - 6,110 6,294 6,483 - - - - - - - 8,021 4,295 1,987 9,098 - - 5,000 - - 14,529 12,294 6,483 2,671 7,298 - 16,053 - - - TOTAL FIRE 577,392 564,368 41,697 118,564 15,505 75,384 15,340 858,415 68,321 170,091 73,578 34,722 27,580 738,397 158,461 129,160 81,497 15,791 17,186 DEBT SERVICE PAYMENTS 10,963 10,963 65,600 69,100 67,450 65,800 64,150 153,568 151,768 154,968 153,018 86,068 86,068 188,759 188,759 188,759 188,759 188,759 188,759 588,356 575,332 107,297 187,664 82,955 141,184 79,490 1,011,983 220,089 325,059 226,596 120,790 113,648 927,155 347,220 317,919 270,256 204,549 205,945 500,000 495,131 500,000 ####### FOOTNOTES (1)REPLACED WITH RETIRING UNMARKED SQUAD Fire Department 2016 Rescue 11 1999 Engine 11 2 2000 Engine 12 1991 Utility 11 2011 Staff Vehicle 2018 Engine 14 5 6 7 8 Fire Department 2006 Inspections Vehicle 2006 Boat and Motor 2006 Compressor FIXED ASSET SCHEDULE ADMINISTRATION/FINANCE ASSET REPLACEMENT PROGRAM FIXED ASSET #YEAR DESCRIPTION LIFE QTY UNIT COST 2018 EST. ACTUAL 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 ADMINISTRATION/FINANCE Computer Hardware 1511 2012 CISCO ETHERNET SWITCH/TRANSCEIVER (RUNS ALL CITY BLDGS) 5 5 1,500 7,500 - 4,605 180 10,350 2,495 - - 10,478 925 10,650 4,600 200 10,350 2,500 - - 9,100 - NA VARIOUS FILE SERVER & SOFTWARE UPGRADES/ROSEVILLE 10 1 23,059 700 - 725 750 4,500 800 825 850 875 900 925 5,500 975 1,000 1,025 1,025 1,050 1,050 1,050 UNASSIGNED 2014 CITY HALL - BIZHUB 7 1 12,000 - - - - 12,000 - - - - - - 13,000 - - - - - - 14,000 NA VARIOUS COMPUTER EQUIPMENT 5 10 1,200 4,850 1,500 - - - 12,360 - - - - 12,731 - - - - 13,113 - - - 13,050 1,500 5,330 930 26,850 15,655 825 850 11,353 1,825 24,306 23,100 1,175 11,350 3,525 14,138 1,050 10,150 15,050 Computer Software 1532 2012 FINANCIAL SOFTWARE (CIVIC)15 1 55,000 - 7,300 - - - - - 55,000 - - - - - - - - - - - UNASSIGNED 2014 LASERFICHE 15 1 7,000 - - - - - - - - - - - 7,500 - - - - - - - 2018 POS LIQOUR CC SYSTEM MP 15 1 9,030 - 9,030 - - - - - - - - - - - - - - - - - 2018 POS LIQOUR CC SYSTEM SLV 15 1 9,030 9,030 - 25,360 - - - - - 55,000 - - - 7,500 - - - - - - - Furniture and Equipment 1581RC NA ELECTION MACHINES & EQUIPMENT 10 2 10,000 8,920 8,920 5,834 - - - - - 35,000 - - - - - - - - - 40,000 1523 2012/2015 OFFICES/CUBES/CARPET ETC NA NA VARIOUS - - 10,000 - - - - - - 40,000 - - - - - - 10,000 - - 8,920 8,920 15,834 - - - - - 35,000 40,000 - - - - - - 10,000 - 40,000 Council Chambers NA VARIOUS COUNCIL CHAMBERS A/V UPGRADES 20 VAR VARIOUS 80,000 80,000 - - - - 5,000 - - - - 5,000 - - - - 5,000 - - MULTIPLE VARIOUS COUNCIL CHAMBERS CAMERAS (1)10 5 8,200 - - - - - - - - - - - - - - - - - - - NA VARIOUS COUNCIL CHAMBERS COMPUTERS/MONITORS 7-10 4 1,750-8,000 1,894 1,894 1,932 1,990 - 9,652 - - - - - - - - - 12,971 - - - NA VARIOUS COUNCIL CHAMBERS FURNITURE NA NA VARIOUS - - - - 10,000 - - - - - - - 11,000 - - - - - - 81,894 81,894 1,932 1,990 10,000 9,652 5,000 - - - - 5,000 11,000 - - 12,971 5,000 - - TOTAL ADMIN/FINANCE 103,864 117,674 23,096 2,920 36,850 25,307 5,825 55,850 46,353 41,825 24,306 35,600 12,175 11,350 3,525 27,109 16,050 10,150 55,050 (1) ALL BROADCAST EQUIPMENT NOW INCLUDED IN A/V UPGRADES ESTIMATED ACTUAL FIXED ASSET SCHEDULE PUBLIC WORKS STREETS ASSET REPLACEMENT PROGRAM FIXED ASSET #YEAR MAKE DESCRIPTION LIFE QTY UNIT COST 2018 EST. ACTUAL 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2015 1536 2014 CHEVY 5 MALIBU PW DIRECTOR 15 1 22,000 - - - - - - - - - - - - 32,643 - - - - - - 1464 2010 FORD 1 F150 PICKUP 15 1 31,500 - - - - - - - - 41,527 - - - - - - - - - - 1289 2004 FORD 2 MECH F150 4X4 15 1 31,500 - - 34,779 - - - - - - - - - - - - - - 54,184 - 1409 2007 FORD 6 F150 PICKUP 4X4 PW SUPER 15 1 31,500 - - - - - 38,003 - - - - - - - - - - - - - 1601 2017 FORD 8 F350 PICKUP 4X4 15 1 45,000 - - - - - - - - - - - - - - - 72,962 - - - 1421 2008 FORD 9 F450 MINI DUMP 2 TON 4X4 15 1 47,500 - - - - - - 59,026 - - - - - - - - - - - - 1338 2006 FORD 10 F450 MINI DUMP 2 TON 4X4 15 1 47,500 - - - - 55,638 - - - - - - - - - - - - - - 256,500 - - 34,779 - 55,638 38,003 59,026 - 41,527 - - - 32,643 - - 72,962 - 54,184 - 1508 2013 IHC 14 7400 DUMP TRUCK 15-25 1 181,859 - - - - - - - - - - - - - - - - - - 322,203 1186 2003 STERLING 11 M8500 DUMP TRUCK 15-25 1 187,500 - - - - - - - - - - - 270,108 - - - - - - - 1181 1995 FORD 12 L8000 DUMP TRUCK 15-25 1 187,500 - - - - 220,000 - - - - - - - - - - - - - - 1582 2016 WESTERN 8 FT PLOW BLADE 15 1 6,682 - - - - - - - - - - - - - 7,830 - - - - - 563,541 - - - - 220,000 - - - - - - 270,108 - 7,830 - - - - 322,203 1450 2010 VERMEER BRANCH CHIPPER 15 1 32,105 - - - - - - - - 32,105 - - - - - - - - - - 1425 2008 FORD 17 F750 HIGH RANGER AERIAL TRUCK 15 1 140,000 - - - - - - - - 184,566 - - - - - - - - - - NA BOBCAT BOBCAT REPLACEMENT PROGRAM NA 1 6,000 6,623 2,500 6,788 6,958 7,132 7,310 7,493 7,681 7,873 8,069 8,271 8,478 8,690 8,907 9,130 9,358 9,592 9,832 10,077 1216 1995 JOHN DEERE 32 444G FRONT END LOADER 20 1 160,000 - - - 179,259 - - - - - - - - - - - - - - - 338,105 6,623 2,500 6,788 186,217 7,132 7,310 7,493 7,681 224,544 8,069 8,271 8,478 8,690 8,907 9,130 9,358 9,592 9,832 10,077 2017 DOOSAN AIR COMPRESSOR PULL BEHIND 20-25 1 23,350 - - - - - - - - - - - - - - - - - - - 2017 DOOSAN JACK HAMMER 10-15 1 6,000 - - - - - - - - - - - 6,429 - - - - - - - 1997 RHINO PD55 POST POUNDER 15-25 1 5,000 - - - - - - 6,213 - - - - - - - - - - - - 1222 1999 CRAFCO 200 PAVEMENT ROUTER (2)15-25 1 20,000 - - - - - - - - - - - - - - - - - - 1189 1997 BEARCAT 43 BK CRACK SEALER (REPL W/ABOVE)15-25 1 45,000 48,709 - 49,684 - - - - - - - - - - - - - - - - 1201 1995 ROSCO 42 VIBRASTAT 111(3) ASPHALT ROLLER 15-25 1 15,000 - - - 17,058 - - - - - - - - - - - - - - - 1202 1999 STEPP 51 SPH-2.0T ASPHALT HOT BOX 15-25 1 50,000 - - 55,204 - - - - - - - - - - - - - - - - 1997 WHACKER WP 1550AW VIBROPLATE 15-25 1 3,000 - - - - - 3,619 - - - - - - - - - - - - - 1998 TRAFFIC MANAGER SY3913060 ARROW BOARD 30X60"15-25 1 9,000 - - - - - - 11,184 - - - - - - - - - - - - 1997 ERSKINE 2418 - 61" SNOWBLOWER (1)15-25 1 5,000 - - - - - - - - - - - - - - - - - - - 1999 BOBCAT 70" ANGLE BROOM 15-20 1 10,000 - - - 11,372 - - - - - - - - - - - - - - - 1184 2000 MASTER TOW CAR DOLLY (2)NA 1 15,000 - - - - - - - - - - - - - - - - - - - 1183 1998 TOWMASTER T-5T SINGLE AXEL TRAILER 20 1 15,000 - - 16,561 - - - - - - - - - - - - - - - - 1182 1999 TOWMASTER T-10DDT TANDEM AXEL TRAILER 20 1 15,000 - - - - 17,570 - - - - - - - - - - - - - - 2015 WHACKER BS50-2I DIRT COMPACTOR 15 1 2,550 - - - - - - - - - - - - - - 3,542 - - - - 1579 2016 GRACO LINELAZER STREETS PAINTER 3900 13 1 10,000 - - - - - - - - - - - - 14,838 - - - - - - 1991 MUD TUB CONCRETE HAULER/DUMPER (2)NA 1 10,000 - - - - - - - - - - - - - - - - - - - 258,900 48,709 - 121,449 28,430 17,570 3,619 17,397 - - - - 6,429 14,838 - 3,542 - - - - TOTAL STREETS 55,332 2,500 163,016 214,647 300,340 48,933 83,916 7,681 266,071 8,069 8,271 285,015 56,171 16,737 12,672 82,320 9,592 64,016 332,281 - - 174,887 - - - 270,108 - 55,332 2,500 (11,871) 214,647 300,340 48,933 83,916 7,681 266,071 8,069 8,271 14,907 56,171 16,737 12,672 82,320 9,592 64,016 332,281 FOOTNOTES 326,032 (1)REPLACEMENT MADE RETAINED FOR BACKUP (2)NOT SCHEDULED FOR REPLACEMENT Specialty Equipment Fleet Plows/Dump Trucks Heavy Equipment 3% AVERAGE ANNUAL INFLATION Public Works Department—Street FLEET 2014 Chevrolet Malibu 2010 Ford F150 Pickup 2007 Ford F150 4x4 2008 Ford F450 Mini Dump 2 Ton 4x4 2006 Ford F450 Mini Dump 2 Ton 4x4 2017 Ford F350 Pickup Public Works Department—Street FLEET 2004 Ford F150 Pickup 4x4 Public Works Department—Street PLOW/DUMP TRUCKS 2003 Sterling M8500 Acterra 2013 International 7400 Dump Truck 1990 Ford L8000 Dump Truck 1995 Ford L8000 Dump Truck 2018 International 7500 Dump Truck Public Works Department—Street HEAVY EQUIPMENT 2011 Vermeer BC1500 Chipper 2008 Ford F750 High Ranger Aerial Truck 2018 Bobcat Replacement Program 1995 John Deere 444G Front End Loader Public Works— Streets SPECIALTY EQUIPMENT 1997 Bearcat Crack Sealer 1999 Stepp SPH-2.0 Asphalt Hot Box 1998 Towmaster T-5T Single Axel Trailer 1999 Towmaster T-10 DDT Tandem Axel Trailer 2016 Streets Painter Trailer 2016 Linelazer Streets Painter 3900 Public Works— Streets SPECIALTY EQUIPMENT 1992 Leroy Q185 Air Compressor 1995 Rosco Asphalt Roller FIXED ASSET SCHEDULE PUBLIC WORKS PARKS ASSET REPLACEMENT PROGRAM FIXED ASSET #YEAR MAKE DESCRIPTION LIFE QTY UNIT COST 2018 EST. ACTUAL 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 1379 2006 FORD 20 F350 MINI DUMP 1 TON 4X4 15 1 42,500 - - - - 49,781 - - - - - - - - - - - - - - 1516 2014 FORD 18 F250 CREW CAB FLATBED 15 1 37,500 - - - - - - - - - - - - 55,642 - - - - - - 1462 2011 FORD 21 F250 PICKUP 4X4 15 1 34,500 - - - - - - - - - 48,252 - - - - - - - - - 1604 2017 FORD 22 F250 PICKUP 4X4 15 1 34,500 - - - - - - - - - - - - - - - 55,938 - - - 149,000 - - - - 49,781 - - - - 48,252 - - 55,642 - - 55,938 - - - 2015 BOBCAT BOBCAT 3400G UTIL VEH (ATV)10 1 10,000 - - - - - - - - 13,183 - - - - - - - - - 17,717 1188 1999 JOHN DEERE 38 4500 TRACTOR 15-25 1 35,000 - - - - - - 43,493 - - - - - - - - - - - - 1999 JOHN DEERE 20" PTO AUGER (W/ TRACTOR)15-25 1 8,000 - - - - - - 9,652 - - - - - - - - - - - - 1999 JOHN DEERE 72" FLAIL MOWER (W/ TRACTOR)15-25 1 15,000 - - - - - - 18,097 - - - - - - - - - - - - 1488 2011 BOBCAT 36 TOOL CAT 5600 (V-Blade, Snblw, BF Drag)15 1 46,507 - - - - - - - - - 63,151 - - - - - - - - - 2012 MB HT HYDRAULIC TRACTOR SWEEPER 15 1 15,000 - - - - - - - - - - 20,979 - - - - - - - - 2004 GIANT-VAC 2501 LEAF VACCUM ATTACHMENT 10 1 6,000 6,400 6,400 - - - - - - - - - - - - - 9,728 - - - 2004 BIG TEX TRAILER 15 1 7,000 - - 7,729 - - - - - - - - - - - - - - 12,041 - 2004 TRAC VAC 880 LEAF VACCUM, DETHATCHER 10 1 4,000 4,350 4,350 - - - 4,826 - - - - 5,594 - - - - 6,486 - - - 2006 CARRY-ON TRAILER 5X8 2000 LBS 15 1 5,000 - - - - 5,857 - - - - - - - - - - - - - - 2001 TRAFFIC CT JR ROAD COUNTER 15 1 1,000 - - - - - - - - - - - - - - 1,574 - - - - 2000 HONDA 1400W GENERATOR 15 1 1,000 - - - 1,137 - - - - - - - - - - - - - - - 1974 VERMEER TREE SPADE 25+1 VARIES - - - - - - - - - - - - - - - - - - - 1974 GIBSON CEMENT MIXER 25+1 2,000 - - - - - - 2,485 - - - - - - - - - - - - 155,507 10,750 10,750 7,729 1,137 5,857 4,826 73,727 - 13,183 63,151 26,574 - - - 1,574 16,214 - 12,041 17,717 1449 2010 TORO 47 GRANDSTAND MOWER (SPRD., VAC )10 1 17,500 - - - - 18,571 - - - - - 24,476 - - - - - - - - 1491 2011 TORO 45 GROUNDSMASTER 360 (BLW, SWP, CAB)10 1 37,916 - - - - - 45,744 - - - - - - - - 59,685 - - - - 1578 2016 TORO ZERO TURN MOWER 5000 MYRIDE 60" 15 1 25,000 - - - - - - - - - - - - - - 39,354 - - - - 1196 2001 DEWEZE 44 SLOPE MOWER 72LC 15 1 55,000 - - - 62,546 - - - - - - - - - - - - - - - 1606 2017 TORO 48 Z MASTER G3 MOWER 10 1 15,000 - - - - - - - - - - - - - - 23,612 - - - - 2014 TORO LAWN MOWER 10 1 500 - - - - - - - 640 - - - - - - - - - 860 - 2014 TORO LAWN MOWER 10 1 500 - - - - - - - 640 - - - - - - - - - 860 - 1999 JOHN DEERE 5'6" FLAIL MOWER 15 1 8,500 9,201 - 9,201 - - - - - - - - - - - - - 14,195 - - 2005 HONDA PUSH MOWER 10 1 500 - - 552 - - - - - - - - - 742 - - - - - - 1975 JERRI JERRI SICLE MOWER 25+1 3,000 - - - - - - - - - 4,074 - - - - - - - - - 163,416 9,201 - 9,753 62,546 18,571 45,744 - 1,280 - 4,074 24,476 - 742 - 122,652 - 14,195 1,720 - 1580 2016 GRACO LINELAZER FIELD PAINTER 10 1 15,000 - - - - - - - - - 20,368 - - - - - - - - - 1999 INFIELD BLUES BALL FIELD DRAG/SCARIFIER/GROOMER 15 1 4,000 - - - - 4,685 - - - - - - - - - 6,297 - - - - 1999 NEW STRIPE BALL/SOCCER FIELD LINE STRIPER 15 1 500 500 500 - - - - - - - - - - - 764 - - - - - 2000 INFIELD BLUES BALL FIELD DRAG (1)na 1 2,000 - - - - - - - - - - - - - - - - - - - 2002 RYAN SOD CUTTER 20 1 5,000 - - - - - 6,032 - - - - - - - - - - - - - 1999 JOHN DEERE 3 PT POST HOLE AUGER HAND (2)15 1 2,000 - - - - - - - - - - - - - - - 3,243 - - - 2012 LAND PRIDE CA 1572 AIRATOR 10 1 2,500 - - - - - 3,016 - - - - - - - - - 4,053 - - - 1490 2012 LAND PRIDE OS 1548 SLIT SEEDER 10 1 8,171 - - - - - 9,857 - - - - - - - - - 13,248 - - - 39,171 500 500 - - 4,685 18,906 - - - 20,368 - - - 764 6,297 20,544 - - - 3% AVERAGE ANNUAL INFLATION Fleet Field Maintenance Mowers Heavy Equipment FIXED ASSET SCHEDULE PUBLIC WORKS PARKS ASSET REPLACEMENT PROGRAM FIXED ASSET #YEAR MAKE DESCRIPTION LIFE QTY UNIT COST 2018 EST. ACTUAL 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 3% AVERAGE ANNUAL INFLATION NA SHOP MADE RINK ICE SHAVER (2)10 1 5,000 - - - - - - - - - - - - - - - - - - - NA LITTLE WONDER SHO WALK BLOWER 5HP 5 1 500 - - - - 586 - - - - 679 - - - - 787 - - - - SNOWBLOWER 5,786 NA TORO CCR POWERLITE 20" SNOWBLOWER 5 1 500 - - 552 - - - - 640 - - - - 742 - - - - 860 - NA MB MCD-WB WALK BEHIND BROOM 10 1 1,800 - - 1,987 - - - - - - - - - 2,671 - - - - 3,096 - NA STIHL KW 85 PADDLE BROOM 5 1 200 216 216 - - - - 249 - - - - 288 - - - - 334 - - NA JOHN DEERE ICE RINK BROOM 10 1 9,480 - - - - - - 11,780 - - - - - - - - - 15,832 - - 17,480 216 6,002 2,539 - 586 - 12,029 640 - 679 - 288 3,413 - 787 - 16,166 3,956 - NA VARIOUS WEED WHIPS 5 4 VARIES 162 290 166 - 305 181 186 192 - 353 210 216 223 - 409 243 251 258 266 NA VARIOUS CHAIN SAWS 5 5 VARIES 758 422 221 284 586 724 870 283 330 679 839 1,008 419 382 787 973 1,169 721 443 NA STIHL LEAF BLOWERS 5 5 VARIES 271 271 221 227 234 241 311 256 264 272 280 360 297 306 315 324 418 344 354 NA STIHL BACKPACK LEAF BLOWERS 5 2 300 - - - 341 - 362 - - 395 - 420 - - 458 - 486 - - 532 NA BROYHILL WEED SPRAYER 5 1 2,500 2,706 2,706 - - - - 3,107 - - - - 3,601 - - - - 4,175 - - NA EARTHWAY FERTILIZER SPREADER 5 1 400 - - - 455 - - - - 527 - - - - 611 - - - - - NA VARIOUS EDGERS 5 3 VARIES 162 162 - - 586 - 186 - - 679 - 216 - - 787 - 251 - - NA VARIOUS TRIMMERS 5 4 VARIES - - - 455 176 181 - - 527 204 210 - - 611 236 243 - - - NA STIHL FS 86 BRUSH CUTTER 5 1 200 - - - - - 241 - - - - 280 - - - - 324 - - - NA NA WHEEL BLOWER 5 1 275 298 298 - - - - 342 - - - - 396 - - - - 459 - - NA STIHL HT75 POLE PRUNER 14'5 1 400 - - 442 - - - - 512 - - - - 594 - - - - 688 - NA SHOP MADE SIGN PAINTING TRAILER 10 2 1,500 - - - 1,706 - - - - 1,977 - - - - 2,292 - - - - 2,658 NA NA TRAFFIC WARNING SIGNS 5 MLTP 2,000 - - - - 2,343 - - - - 2,716 - - - - 3,148 - - - - NA NA TRAFFIC WARNING CONES 5 MLTP 500 - - - - - 603 - - - - 699 - - - - 811 - - - NA NA TRAFFIC WARNING BLINKER BARRICADE 5 MLTP 1,500 1,624 - - - - - 1,864 - - - - 2,161 - - - - 2,505 - - NA NA TRAFFIC WARNING BARRICADES 5 MLTP 1,500 - - 1,656 - - - - 1,920 - - - - 2,226 - - - - 2,580 - NA NA EVENT BARRICADES 5 MLTP 1,500 - - - 1,706 - - - - 1,977 - - - - 2,292 - - - - 2,658 18,535 5,980 4,149 2,705 5,174 4,228 2,534 6,866 3,162 5,998 4,902 2,937 7,959 3,758 6,954 5,683 3,405 9,227 4,592 6,910 TOTAL PARKS 26,648 21,401 22,726 68,858 83,708 72,009 92,621 5,082 19,182 141,426 53,987 8,247 63,555 7,718 136,992 96,100 39,588 22,309 24,627 958,735 FOOTNOTES - (1)DUPLICATE REMOVED 26,648 21,401 22,726 68,858 83,708 72,009 92,621 5,082 19,182 141,426 53,987 8,247 63,555 7,718 136,992 96,100 39,588 22,309 24,627 (2)NOT SCHEDULED FOR REPLACEMENT 6,478.61 spent 14,922.60 not spent 21,401 Parkland/Sidewalks/Trees Rink Maintenance Public Works - Parks FLEET 2014 Ford F250 Flatbed 2017 Ford F250 Park Utility 4x4 2006 Ford F350 Mini Dump 1 Ton 4x4 2011 Ford F250 Pickup 4x4 Public Works - Parks HEAVY EQUIPMENT 2015 Bobcat 3400G UTV 2018 Echo Bearcat Tow Behind Vaccum Debris Loader 2011 Bobcat Tool Cat 5600 2012 Hydraulic Tractor Sweeper Sidewalks and Ice Rinks 2004 Big Tex 18’ Tandem Park Utility Trailer Public Works - Parks HEAVY EQUIPMENT 2004 Trac Vac 880 Leaf Vaccum Dethatcher 1999 John Deere 4500 Tractor 1974 Vermeer Tree Spade Public Works - Parks MOWERS 2010 Toro Grandstand Mower 2011 Toro Grounds Master 360 2001 Deweze Slope Mower 72LC 2017 Toro Z Master G3 5000 Mower 2016 Toro Zero Turn Mower 5000 MYRIDE 60” Public Works - Parks FIELD MAINTENANCE 2016 Linelazer Field Painter Fiscal Year 2019 2018 Est. Actual 2018 2019 2020 2021 2022 2023 2024-2029 2030-2035 SOURCES Park Dedication Fees 1,500$ 1,500$ 1,500$ 25,000$ 7,500$ 1,500$ 1,500$ 9,000$ 9,000$ Donations - - - - - - - - - Micellaneous Income 1,136 1,136 725 800 850 900 900 5,795 5,853 TOTAL 2,636$ 2,636$ 2,225$ 25,800$ 8,350$ 2,400$ 2,400$ 14,795$ 14,853$ USES Central Park 42,966 3,385 4,150 30,000 - - - 63,000 - Emerald Park 37,662 1,100 5,000 30,000 - - - - - Salo Park - - - - - - - - - Silver Point Park 4,438 300 3,434 43,000 - - - - - Trillium Park - - - - - - - - - Water Tower Park 2,591 - 2,505 - - - - - - TOTAL 87,656 4,785 15,089 103,000 - - - 63,000 - NET CHANGE (85,020)$ (2,149)$ (12,864)$ (77,200)$ 8,350$ 2,400$ 2,400$ (48,205)$ 14,853$ BEGINNING CASH BALANCE 135,360 135,360 133,211 120,347 43,147 51,497 53,897 53,897 5,692 ENDING CASH BALANCE 50,340$ 133,211$ 120,347$ 43,147$ 51,497$ 53,897$ 56,297$ 5,692$ 20,545$ PARK IMPROVEMENT 2019 - 2035 PARKS IMPROVEMENT PROGRAM PARK CIRA DESCRIPTION CONDITION GRADE COST / INTERNAL EST / QUOTE 2018 EST ACT. 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 Central Park 2003 Park Amenities Signage -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ Ballfields - multi-use 2,646 850 950 - - - - - - - - - - - - - - - - Ballfields - soccer 1,929 - 400 - - - - - - - - - - - - - - - - Batting Cages - - - - - - - - - - - - - - - - - - - Off-Street Parking - - - - - - - - - - - - - - - - - - - Picnic Area 303 - - - - - - - - - - - - - - - - - Play Equipment 1,654 2,035 1,500 - - - - - - - - - - - - - - - - Skateboard Park 551 - 600 - - - - - - - - - - - - - - - - Skating Rink - general 331 250 350 - - - - - - - - - - - - - - - - Skating Rink - hockey 551 250 350 - - - - - - - - - - - - - - - - Tennis Courts Resurface - - - - - - - 63,000 - - - - - - - - - - - Walking Paths - - - - - - - - - - - - - - - - - - - Splash Pad water reuse assessment 5,000 - - - - - - - - - - - - - - - - - - Splash Pad/Shade Structures & Seating 30,000 - - 30,000 - - - - - - - - - - - - - - - TOTAL 42,966$ 3,385$ 4,150$ 30,000$ -$ -$ -$ 63,000$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ Emerald Park 2009 Park Amenities Signage - - - - - - - - - - - - - - - - - - - Ballfields - multi-use 2,646 600 800 - - - - - - - - - - - - - - - - Ballfields - soccer 1,929 - 1,500 - - - - - - - - - - - - - - - - Basketball Half-Court 276 - 200 - - - - - - - - - - - - - - - - Off-Street Parking - - - - - - - - - - - - - - - - - - - Picnic Area 303 - 300 - - - - - - - - - - - - - - - - Play Equipment 1,654 - 1,500 - - - - - - - - - - - - - - - - Skating Rink - general 303 250 350 - - - - - - - - - - - - - - - - Skating Rink - hockey 551 250 350 - - - - - - - - - - - - - - - - Walking Paths - - - - - - - - - - - - - - - - - - - Splash Pad/Shade Structures & Seating 30,000 - - 30,000 - - - - - - - - - - - - - - - TOTAL 37,662$ 1,100$ 5,000$ 30,000$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ Salo Park 2006 Park Amenities Signage - - - - - - - - - - - - - - - - - - - Amphitheater - - - - - - - - - - - - - - - - - - - TOTAL -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ Became part of 2018 Improvements funded by PUI fund PARK COMMISSION EVALUATION IN PROGRESS PARKS IMPROVEMENT PROGRAM PARK CIRA DESCRIPTION CONDITION GRADE COST / INTERNAL EST / QUOTE 2018 EST ACT. 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 Silver Point Park 1998 Park Amenities Signage - - - - - - - - - - - - - - - - - - - Ballfields - multi-use 1,929 300 800 - - - - - - - - - - - - - - - - Basketball Full-Court - - - - - - - - - - - - - - - - - - - Off-Street Parking - - - - - - - - - - - - - - - - - - - Picnic Area 303 - 318 - - - - - - - - - - - - - - - - Play Equipment 1,654 - 1,736 - - - - - - - - - - - - - - - - Skating Rink - general - - - - - - - - - - - - - - - - - - - Skating Rink - hockey 551 - 579 - - - - - - - - - - - - - - - - Walking Paths - - - - - - - - - - - - - - - - - - - Drinking Fountains - - - - - - - - - - - - - - - - - - - New hockey rink - - - 43,000 - - - - - - - - - - - - - - - TOTAL 4,438$ 300$ 3,434$ 43,000$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ Trillium Park 1980 Park Amenities Signage - - - - - - - - - - - - - - - - - - - Water Fountain - - - - - - - - - - - - - - - - - - - Off-Street Parking - - - - - - - - - - - - - - - - - - - TOTAL -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ Water Tower Park 2004 Park Amenities Signage - - - - - - - - - - - - - - - - - - - Basketball Half-Court - - - - - - - - - - - - - - - - - - - Off-Street Parking - - - - - - - - - - - - - - - - - - - Picnic Area 386 - 405 - - - - - - - - - - - - - - - - Play Equipment 1,654 - 1,500 - - - - - - - - - - - - - - - - Tennis Courts / Resurface 551 - 600 - - - - - - - - - - - - - - - - Walking Paths - - - - - - - - - - - - - - - - - - - TOTAL 2,591$ -$ 2,505$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ TOTAL PARK IMPROVEMENTS 87,656$ 4,785$ 15,089$ 103,000$ -$ -$ -$ 63,000$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ PARK COMMISSION EVALUATION IN PROGRESS ParksParks Park AmeniƟes Amphitheater Ballfields ‐ mulƟ‐use Ballfields ‐ soccer Basketball Courts Baƫng Cages Off‐Street Parking Picnic Area Play Equipment Shelter Skateboard Park SkaƟng Rink ‐ general SkaƟng Rink ‐ hockey Tennis Courts Walking Paths Splash Pads Central Park—2003 X X 1/2 X X X X X X X X X X Emerald Park —2009 X X 1/2 X X X X X X X X Salo Park—2006 X X Silver Point Park— 1998 X X X X X X X X X Trillium Park—1980 X Water Tower Park— 2004 X X X X X Fiscal Year 2019 SOURCES 2018 Est. Actual 2018 2019 2020 2021 2022 2023 2024-2029 2030-2035 Interfund Loan collections (1)46,061 46,061 45,766 45,470 198,667 191,976 801,457 690,050 - Utility Fund Transfer (2)- - - - - - - 225,000 1,350,000 Connection fees - 8,500 8,500 85,000 17,000 - - - - Interest and other income 32,400 48,653 46,183 49,058 48,256 47,691 58,868 288,348 360,318 TOTAL 78,461$ 103,214$ 224,658$ 179,529$ 263,923$ 239,667$ 860,325$ 1,203,398$ 1,710,318$ USES Water Infrastructure (3)185,000 320,039 80,920 27,500 18,843 17,500 197,675 1,139,348 363,523 Water Equipment 101,948 106,110 2,492 186,422 38,791 905 1,933 66,946 104,544 Sewer Infrastructure 40,000 40,000 15,000 - - - - 25,000 60,000 Sewer Equipment (4)101,948 106,110 382,492 1,422 3,651 905 1,933 66,946 572,225 Fiber Infrastructure 100,000 66,787 33,213 - - 15,000 - 15,000 22,000 TOTAL 528,897$ 639,047$ 514,117$ 215,343$ 61,285$ 34,310$ 201,542$ 1,313,241$ 1,122,292$ NET CHANGE (450,436)$ (535,832)$ (289,460)$ (35,814)$ 202,638$ 205,357$ 658,784$ (109,843)$ 588,026$ BEGINNING CASH BALANCE 3,458,223 3,458,223 2,922,391 2,632,931 2,597,116 2,799,754 3,005,111 2,799,754 2,689,911 ENDING CASH BALANCE 3,007,787$ 2,922,391$ 2,632,931$ 2,597,116$ 2,799,754$ 3,005,111$ 3,663,895$ 2,689,911$ 3,277,937$ (1) Principal collection of $959,326 estimated to begin 2021. (2) Utility Fund Transfer available upon retirement of Water Bonds in 2024. (3) 2018 Budget assumed bonding the cost of Central Park Water re-use, using available funds. (4) Anticipates 50% equipment grant program by Water Management Organization. UTILITIES INFRASTRUCTURE 2019 - 2035 UTILITES INFRASTRUCTURE PLANT, PRODUCTION,STORAGE, WASTE AND FIBER SYSTEM 0 0 1.03 1.0609 1.092727 1.1255088 1.1592741 1.1940523 1.2298739 1.2667701 1.3047732 1.3439164 1.3842339 1.4257609 1.4685337 1.5125897 1.5579674 1.0824322 1.0824322 1.1040808 1.1372032 1.1713193 1.2064589 1.2426527 1.2799323 1.3183302 1.3578801 1.3986165 1.440575 1.4837923 1.528306 1.5741552 1.6213799 DEPT PURPOSE DESCRIPTION Last Done 2018 EST. ACTUAL 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 Plant Facilities AOP Plant Plant Start up 25,000 3,500 - - - - - - - - - - - - - - - - - GAC / Iron plants (moved from Buildings CIP in 2017)- - - - - - - - - - - - - - - - - - - Metal Door Frame & Replacement - - - - - 15,000 - - - - - - - - - - - - - Security upgrades -Cameras - - - - - - - - - - - - - - - - - - - Security upgrades - Entrance controls / Fiber 2017 - 2,325 - - - - - - - - - - - - - - - - - Reznor Heating Units - -18,900 - - - - - - - - 24,190 - - - - - - - Dehumidifier - - - - - - 102,500 - - - - - - - - - - - - Domestic Water Heaters - - - - - - - 3,450 - - - - - - - - - - - Dehumidifier - - - - - - - - - - 77,900 - - - - - - - - Boiler - - - - - - - - 27,600 - - - - - - - - - - Relamp & Reballast - - - - 5,343 - - - - - - - - - - - - - - Flow meters- GAC & Iron 2017 - - - - - - - - - - - - 18,492 - - - - - - Chorine booster pump -GAC 2017 - - - - - - 5,796 - - - - - - - - - - - - GAC Roof 2016 / Iron plant roof 2026 GAC 2016 - - - - - - - - - 95,000 - - - - - - - - - Production Well No. 3 Well casing - - - - - - - - - - 80,000 - - - - - - - - Well No. 3 Pump restoration 2017 - - - - - - - - - - - - - - - - - - - Well No. 4 Pump restoration - - - - - - 86,878 - - - - - - - - - - - - Well No. 5 Pump restoration 2018 75,000 74,942 - - - - - - - - - 100,716 - - - - - - - Retro fit Well No. 5 for mobile Generator 2018 7,500 13,712 - - - - - - - - - - - - 300,000 - - - - Add permanent generator Well No. 4 - - - - - - - - - - - 275,000 - - - - - - - Central Park water re-use 138,880 59,520 - - - - - - - - - - - - - - - - Storage - Ground Storage and Tower Cleaning & Inspection - - - - 11,000 - - - 12,000 - - - - 13,500 - - Tower Painting (last painted in 2000)2000 - - - - - - - - 300,000 - - - - - - - Distribution System - - Watermains (Included in streets reconstruction)- - - - - - - - - - - - - - - - - - - Meter reading software upgrade / Customer portal 2017/2018 - 9,180 - - - - - - - - - - 80,000 - - - - - - Mandates - - Wellhead Protection Plan Documentation (MDHS)- - - 25,000 - - - - 30,000 - - - - 35,000 - - Education/Public Awareness 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,001 1,001 1,001 1,001 Update Inventory of Potential Contamination Sources 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,001 1,001 1,001 1,001 Annual Well Sampling 500 500 500 500 500 500 500 500 500 500 500 500 500 501 502 503 503 503 503 185,000 320,039 80,920 27,500 18,843 17,500 197,675 5,950 372,100 97,500 160,400 402,406 100,992 51,001 302,502 2,505 2,505 2,505 2,505 Lift Stations Lift Stations - SCADA system/Fiber 40,000 40,000 - - - - - - - - - - - - - - 60,000 - - Foss Road Lift Station Pump Replacement/re-hab - - 15,000 - - - - 10,000 - - - - - - - - - - - Harding Lift Station Pump Replacement/re-hab - - - - - - - - - 15,000 - - - - - - - - - Collection System Collection System (Included in streets reconstruction)- - - - - - - - - - - - - - - - - - - 40,000 40,000 15,000 - - - - 10,000 - 15,000 - - - - - - 60,000 - - Backbone Fiber to expansion (well houses and lift stations, etc)2018 100,000 66,787 33,213 - - - - - - - - - - - - - - - - Network switch City Hall 2015 - - - - - 15,000 - - - - - - 22,000 - - - - - 29,000 100,000 66,787 33,213 - - 15,000 - - - - - - 22,000 - - - - - 29,000 TOTAL PUBLIC UTILITES INFRASTRUTURE PLAN 325,000$ 426,826$ 129,133$ 27,500$ 18,843$ 32,500$ 197,675$ 15,950$ 372,100$ 112,500$ 160,400$ 402,406$ 122,992$ 51,001$ 302,502$ 2,505$ 62,505$ 2,505$ 31,505$ SEWER UTILITY FIBER LAN UTILITY WATER UTILITY UTILITES INFRASTRUCTURE EQUIPMENT FIXED ASSET #YEAR MAKE DESCRIPTION LIFE 2018 EST. ACTUAL 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 1403 2006 SPRINTER 4 W WATER UTILITY VAN 15 - - - - 35,140 - - - - - - - - - - - - - - 2015 FORD 7 D F350 UTILITY 4X4 W /CRANE 10 - - - - - - - - 68,224 - - - - - - - - - - - - - - 35,140 - - - 68,224 - - - - - - - - - - 1438 1999 STERLING 19 S STERLING VACTOR/JETTER 15 - - 380,000 - - - - - - - - - - - 354,185 - - - - 1174 1990 FORD 15 D L8000 DUMP TRUCK 15-25 200,000 204,355 - - - - - - - - - - - - - - - - - 2007 ZIEGLER CAT S 200KW - FOSS RD LS 25-30 - - - - - - - - - - - - - - - 113,497 - - - 1292 2004 FREIGHTLINER 16 W M2 WATER TANKER/FLUSHER 15-20 - - - 185,000 - - - - - - - - - - - - - - - 2013 CASE 590 D LOADER / BACKHOE 20-25 - - - - - - - - - - - - - - - - 175,290 - - 200,000 204,355 380,000 185,000 - - - - - - - - - - 354,185 113,497 175,290 - - 1212 2002 SPEEDSHORE D VARIABLE 4X6 TRENCH BOX 25-30 - - - - - - - - - - 6,993 - - - - - - - - 1213 1990 SHORING INT D 8X6, 24" & 48" TRENCH SHORING 25-30 - - - - - - - - - - 6,993 - - - - - - - - 1999 MAGNA TRAK D 100 FERROUS IRON LOCATOR 10 - - - - 1,288 - - - - 1,494 - - - - - - - - - 2013 LINE LOCATOR D RD400 UNDERGROUND LOCATOR 10 - 3,230 - - - 1,810 - - - - 2,098 - - - - 2,432 2,505 - - EST 2008 MINIGAS D OFCH MULTI-GAS MONITOR 5 1,191 1,191 - - - - 1,367 - - - - 1,585 - - - - - - - 1247 2008 HACH D DR2000 SPECTROPHOTOMETER 5 - - - 1,706 - - - - 1,977 - - - - 2,292 - - - - - 1209 2005 INGERSOL RAND D ROTO HAMMER 10 - - 276 - - - - - - - - - 371 - - - - - - 1417 2005 HONDA D EG1500W GENERATOR 10 - - 552 - - - - - - - - - 742 - - - - - - EST 2005 HOMELITE D 3" DIAPHRAM PUMP 5-10 1,624 - - - - - - - - - - - - - EST 2005 HOMELITE D 3" TRASH PUMP 250 GPM 5-10 1,082 - - - - - - 1,280 - - - - - 1,528 - - - - - EST 2005 HOMELITE D 2" TRASH PUMP 173 GPM 5-10 - - - 1,137 - - - - 1,318 - - - - - 1,574 - - - - EST 2005 NA D ELECTRIC SEWER SNAKE 5-10 - - - - 2,343 - - - - - - - 2,968 - - - - 3,440 - EST 2005 NA D 12V POWER VENT 5-10 - - - - - - - 1,920 - - - - - 2,433 - - - - - 1246 2005 MOHAWK D PERSONNEL SAFETY LIFT 5-10 - - 1,656 - - - - - - 2,037 - - - - - - 2,505 - - NEW D KERF CUTTER 5-10 - - - - - - - - - - - - - - - - - - - 2018 HACH WATER TESTING EQUIPMENT 5-10 - 3,445 - - - - - - 4,542 - - - - - - 5,586 - - - EST 2005 STIHL D TS460 PARTNER SAW 5-10 - - - - 1,171 - - - - - - - 1,484 - - 1,001 1,001 - - 3,897 7,866 2,484 2,843 4,802 1,810 1,367 3,200 7,837 3,530 16,084 1,585 5,564 6,254 1,574 9,019 6,011 3,440 - RTA D RTA FLEET SOFTWARE 15-20 - - - - - - - - - - - - - - - - - - - D COMPUTERS/PRINTERS 7-10 - - 2,500 - 2,500 - 2,500 - 2,500 - 2,500 - 2,500 - 2,500 - 2,500 - 2,500 1442 2009 SENSUS D COMPUTER SOFTWARE 20 - - - - - - - - - 20,368 - - - - - - - - - - - 2,500 - 2,500 - 2,500 - 2,500 20,368 2,500 - 2,500 - 2,500 - 2,500 - 2,500 TOTAL UTILITY 203,897 212,221 384,984 187,843 42,442 1,810 3,867 3,200 78,561 23,899 18,584 1,585 8,064 6,254 358,259 122,515 183,802 3,440 2,500 EQUIPMENT SPECIFIC TO WATER 0 0 0 185,000 35,140 0 0 0 0 0 0 0 0 0 0 0 0 0 0 EQUIPMENT SPECIFIC TO SEWER 0 0 380,000 0 0 0 0 0 0 0 0 0 0 0 354,185 113,497 0 0 0 DUAL PURPOSE EQUIPMENT 203,897 212,221 4,984 2,843 7,302 1,810 3,867 3,200 78,561 23,899 18,584 1,585 8,064 6,254 4,074 9,019 183,802 3,440 2,500 203,897 212,221 384,984 187,843 42,442 1,810 3,867 3,200 78,561 23,899 18,584 1,585 8,064 6,254 358,259 122,515 183,802 3,440 2,500 Technology Reassigned from Capital Equipment Fund 3% AVERAGE ANNUAL INFLATION Fleet Reassigned from Capital Equipment Fund Heavy Equipment Reassigned from Capital Equipment Fund Specialty Equipment Reassigned from Capital Equipment Fund Utilities InfrastructureUtilities Infrastructure 1953 Water Tower 2007 Foss LiŌ StaƟon 2001 Harding LiŌ StaƟon 1953 St. Anthony Water Treatment Facility, 1991 GAC, 2017 AOP Utilities InfrastructureUtilities Infrastructure 1957 Well #3 1959 Well #4 1961 Well #5 Utility InfrastructureUtility Infrastructure FLEETFLEET 1 1999 Sterling Vactor/Je Ʃer 2006 Sprinter UƟlity Van 2015 Ford F350 UƟlity 4x4 2004 Freightliner M2 Water Tanker/Flusher Utility InfrastructureUtility Infrastructure HEAVY EQUIPMENTHEAVY EQUIPMENT 1999 Onan 400K Gen Set 1992 Onan 375K Gen Set 1989 Sreco RSR‐38TR Sewer Rodder 2013 Case 590 Loader/Backhoe Fiscal Year 2019 SOURCES 2018 Est. Actual 2018 2019 2020 2021 2022 2023 2024-2029 2030-2035 Stormwater fees UB 201,393$ 201,700$ 205,734$ 209,849$ 214,046$ 218,327$ 222,693$ 1,271,683$ 1,284,400$ Partners -Silver Lake Mgmt plan 56,000 10,000 - - - - - - - Rice Creek Watershed District 180,987 148,307 - - - - - - - Ramsey county - Mirrior Lake 8,960 8,960 - - - - - - - Bond Proceeds (1)75,000 293,700 - - - - - - Grants-Silver Lake Rd Flooding 500,000 Grants-Industrial Park Flooding - - 250,000 - - - - - - Grant-Equipment - - - 110,000 - - - - 175,000 Interest 2,000 2,000 2,750 3,250 3,500 3,500 3,500 48,000 76,750 TOTAL 524,340$ 370,967$ 1,252,184$ 323,099$ 217,546$ 221,827$ 226,193$ 1,319,683$ 1,536,150$ USES Stormwater Maintenance 2,040$ -$ -$ -$ 50,000$ -$ -$ 245,000$ 190,000$ Flood Improvements 346,939 327,209 1,002,000 - - - - - - Water Quality 96,640 38,250 31,530 272,314 48,339 49,809 81,329 417,863 857,083 Mandates 6,558 7,836 8,100 8,260 8,422 8,587 8,755 66,205 63,020 Annual Reconstruction 95,000 95,000 85,000 85,000 85,000 95,000 105,000 225,000 - TOTAL 547,176 468,295 1,126,630 365,574 191,761 153,397 195,084 954,068 1,110,103 NET CHANGE (22,836)$ (97,328)$ 125,554$ (42,476)$ 25,784$ 68,430$ 31,109$ 365,615$ 426,047$ BEGINNING CASH BALANCE 164,871 164,871 67,543 193,097 150,622 176,406 244,836 176,406 542,021 ENDING CASH BALANCE 142,035$ 67,543$ 193,097$ 150,622$ 176,406$ 244,836$ 275,946$ 542,021$ 968,068$ STORMWATER 2019 - 2035 STORMWATER CAPITAL PLAN Improvement Type Location Potential Financial Sources Budget 2018 EST. ACTUAL 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 Stormwater Pond Maintenance Mirror Lake SAV - - - - - - - - - - - - 150,000 - - - - - - Silver Lake Ramsey, CH, SAV - - - - - - - - - - - - - - - - - - - Harding Pond SAV - - - - 50,000 - - - - - - - - 60,000 - - - - - Salo Pond SAV - - - - - - - - 45,000 - - - - - - - - 60,000 - Central Park Rain Garden SAV 2,040 - - - - - - - - 50,000 - - - - - - - - 70,000 2,040 - - - 50,000 - - - 45,000 50,000 - - 150,000 60,000 - - - 60,000 70,000 Flood Improvements Industrial Park Flood Improvements SAV/MWMO - 1,805 300,000 - - - - - - - - - - - - - - - - Mirror Lake - capacity increased RCWD, Ramsey County 346,939 264,787 - - - - - - - - - - - - - - - - - Mirror Lake - EriosIon/Pipe re-route RCWD, SAV Street Imp 33,800 Silver Lake Rd Flooding Preliminary Analysis SAV 11,817 Silver Lake Rd Flooding Project SAV,DNR,Ramsey,RCWS - 15,000 702,000 - - - - - - - - - - - - - - - - 346,939 327,209 1,002,000 - - - - - - - - - - - - - - - - Water Quality Street Sweeper MWMO/SAV - - - 220,000 - - - - - - - - - - - - 350,000 - - Salo Pond Treatment System SAV 32,640 18,250 18,980 19,739 20,529 21,350 22,204 23,092 24,016 24,976 25,975 27,014 28,095 29,219 30,388 31,603 32,867 34,182 35,549 Regional Stormwater Treatment system (1)MWMO 1,500 1,500 1,550 1,575 21,600 22,032 22,473 22,922 23,381 23,848 24,325 24,812 25,308 25,814 26,330 26,857 27,394 27,942 28,501 Clean Streets maintenance costs SAV 6,000 6,000 6,000 6,210 6,427 6,652 6,885 7,126 7,376 7,634 7,901 8,177 8,464 8,760 9,066 9,384 9,712 10,052 Silver Lake Delisting / Weed mgmt CO-OP 62,500 12,500 5,000 - - - - - - - - - - - - - - - - Water Re-use Tank cleaning SAV - - - 25,000 - - 30,000 - - 35,000 - - 40,000 - - 45,000 - - 50,000 96,640 38,250 31,530 272,314 48,339 49,809 81,329 52,899 54,522 91,200 57,934 59,727 101,580 63,496 65,478 112,526 419,645 71,836 124,102 Mandates SWIPP Stormwater Management Plan update SAV - - - - - - - 10,000 - - - - - - - - - - - MS4 MS4-Engineer costs SAV 4,658 1,336 1,500 1,560 1,622 1,687 1,755 1,825 1,898 1,974 2,053 2,135 2,220 2,309 2,402 2,498 2,598 2,701 2,809 Internal SW Education / Green Step Program SAV 1,900 6,500 6,600 6,700 6,800 6,900 7,000 7,100 7,200 7,300 7,400 7,500 7,600 7,700 7,800 7,900 8,000 8,100 8,200 6,558 7,836 8,100 8,260 8,422 8,587 8,755 18,925 9,098 9,274 9,453 9,635 9,820 10,009 10,202 10,398 10,599 10,802 11,010 Annual Reconstruction (2) Internal use for debt levy reduction 95,000 95,000 85,000 85,000 85,000 95,000 105,000 - - - - - - - - - - - - Contribution to streets reconstruction 2024-2026 - - - - - - - 75,000 75,000 75,000 - - - - - - - - - 95,000 95,000 85,000 85,000 85,000 95,000 105,000 75,000 75,000 75,000 - - - - - - - - - TOTAL STORMWATER CAPITAL PLAN 547,176 468,295 1,126,630 365,574 191,761 153,397 195,084 146,824 183,620 225,474 67,387 69,362 261,401 133,506 75,679 122,924 430,243 142,638 205,112 NOTES: (1) Final Project costs paid in 2017, subsequent year's costs are utilities and maintenance (2) Reconstruction of Street based Stormwater Improvements included within the Streets Capital Plan Stormwater RetentionStormwater Retention 2004‐2005 Salo Pond North 2004‐2005 Salo Pond South 2003 Harding Pond 1962 Mirror Lake Stormwater Treatment SystemsStormwater Treatment Systems 2015 Silver Lake Stormwater Treatment Facility at Salo Pond 2016 St. Anthony Regional Stormwater Treatment System 2014 Central Park Rain Garden Stormwater ReuseStormwater Reuse 2008 Water Reuse Fountain Stormwater EquipmentStormwater Equipment 2006 Elgin Pelican Street Sweeper Fiscal Year 2018 SOURCES 2018 Est. Actual 2018 2019 2020 2021 2022 2023 2024-2029 2030-2035 Bond Proceeds 2,634,494$ 2,634,494$ 1,150,000$ 1,765,000$ 2,062,000$ 2,400,000$ 1,834,000$ 15,968,000$ 1,722,775$ Road Improvement Levy 1,833,431 1,833,431 1,914,886 1,938,476 1,964,825 1,995,370 2,027,888 15,786,038 16,649,035 Prepaid Assessments 64,990 64,990 - 95,571 162,548 185,867 148,189 1,222,486 485,163 MSA Funds - not part of DLR - - - - - - 140,000 340,000 1,020,000 Grant Funding 25,000 25,000 - - - - 250,000 - - Debt Levy Reduction Funding 327,500 327,500 377,509 345,000 367,500 302,500 153,688 (480,080) - Miscellaneous - - - - - - - - - TOTAL 4,885,415$ 4,885,415$ 3,442,395$ 4,144,047$ 4,556,873$ 4,883,737$ 4,553,765$ 32,836,444$ 19,876,973$ USES Streets/Utilities Reconstruction (1)2,381,940$ 2,381,940$ 2,133,440$ 1,874,720$ 2,102,172$ 2,469,760$ 2,068,639$ 15,432,209 1,626,957 Mill and Overlays 60,700 60,700 40,100 - - - - - 1,722,775 Alleys - - - - 80,000 60,000 90,000 98,851 373,380 Sidewalks/Street Lights - - - - - - - - 2,181,592 Road Improvement debt 2,160,931 2,160,931 2,292,395 2,283,476 2,332,325 2,297,870 2,181,576 15,305,958 15,012,841 Miscellaneous - - - - - - - - - TOTAL 4,603,571$ 4,603,571$ 4,465,935$ 4,158,196$ 4,514,497$ 4,827,630$ 4,340,215$ 30,837,018$ 20,917,546$ NET CHANGE 281,844$ 281,844$ (1,023,540)$ (14,149)$ 42,376$ 56,107$ 213,550$ 1,999,426$ (1,040,573)$ BEGINNING ACTIVITY - - 281,844 (741,696) (755,845) (713,469) (657,362) (443,812) 1,555,614 CUMULATIVE ACTIVITY 281,844$ 281,844$ (741,696)$ (755,845)$ (713,469)$ (657,362)$ (443,812)$ 1,555,614$ 515,041$ STREETS IMPROVEMENT PLAN 2019 - 2035 STREETS IMPROVEMENTS PLAN Improvement Type Location YEAR Financial Source Estimated cost 2018 EST. ACTUAL 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 Street /Utility Reconstruction Program Skycroft, Maplewood, Penrod and Chemsford 2017 Debt Levy/Assmts/Grants & Aids 2,949,700 589,940 589,940 - - - - - - - - - - - - - - - - Foss, Macalaster and Highcrest 2018 Debt Levy/Assmts/Grants & Aids 2,240,000 1,792,000 1,792,000 448,000 - - - - - - - - - - - - - - Silver Lake Rd Flood Mitgation, County Rd C ,Utilities, Stormwater 2019 Debt Levy/Assmts/Grants & Aids 2,106,800 1,685,440 421,360 - - - - - - - Croft Dr and 32nd Ave, Silver Lane and Terrace Mill and Overlay 2020 Debt Levy/Assmts/Grants & Aids 1,816,700 - 1,453,360 363,340 - - - - - - Skycroft Dr, Croft Dr, 31st Ave.2021 Debt Levy/Assmts/Grants & Aids 2,173,540 - - 1,738,832 434,708 - - - - - - - - - - - No. Rankin, Townview 2022 Debt Levy/Assmts/Grants & Aids 2,543,815 - - - - 2,035,052 508,763 - - - - - - - - - - So. Rankin 2023 Debt Levy/Assmts/Grants & Aids 1,949,845 - - - - - 1,559,876 389,969 - - - - - - - - - Penrod , MaCalaster 2024 Debt Levy/Assmts/Grants & Aids 2,766,300 - - - - - - 2,213,040 553,260 - - - - - - - - Shamrock, Fordham 2025 Debt Levy/Assmts/Grants & Aids 2,565,700 - - - - - - - 2,052,560 513,140 - - - - - - - Skycroft and Downers 2026 Debt Levy/Assmts/Grants & Aids 2,776,800 - - - - - - - - 2,221,440 555,360 - - - - - - Skycroft Cir. and Skycroft Dr 2027 Debt Levy/Assmts/Grants & Aids 2,945,000 - - - - - - - - - 2,356,000 589,000 - - - - - - So. Anthony Ln 2028 Debt Levy/Assmts/Grants & Aids 3,375,500 - - 2,700,400 675,100 - - - - - - No. Anthony Lane 2029 Debt Levy/Assmts/Grants & Aids 3,034,785 - - 2,427,828 606,957 - - - - - TOTAL RECONSTRUCTION 33,244,485 2,381,940 2,381,940 2,133,440 1,874,720 2,102,172 2,469,760 2,068,639 2,603,009 2,605,820 2,734,580 2,911,360 2,221,440 2,356,000 - - - - - - Mill and Overlays Silver Lake Court 2017 Debt Levy/Assmts 60,700 60,700 60,700 - - - - - - - - - - - - - - - - - No. Anthony Ln 2018 Debt Levy/Assmts 44,100 40,100 - - - - - - - - - - - - - - - - Estimated M/O program 2023+Debt Levy/Assmts 1,722,775 - - - - - - - - - 253,278 265,942 279,239 293,201 307,861 323,254 TOTAL MILL AND OVERLAY 1,827,575 60,700 60,700 40,100 - - - - - - - - - - 253,278 265,942 279,239 293,201 307,861 323,254 Alleys Coolidge -1 2026 Debt Levy/Assmts 98,851 - - - - - - - - 98,851 - - - - - - - - Roosevelt-1 2020 Debt Levy/Assmts 80,000 - - 80,000 - - - - - - - - - - - - 145,000 Pahl Ave. area -3 2022 Debt Levy/Assmts 90,000 - - - - 90,000 - - - - - - - - - - 133,509 - Alleys North of Sliver Lake Blvd 2021 Debt Levy/Assmts 60,000 - - - 60,000 - - - - - - - - - - 94,871 - - TOTAL ALLEYS 328,851 - - - - 80,000 60,000 90,000 - - - 98,851 - - - - - 94,871 133,509 145,000 Sidewalks / Intersections / Signals / Lighting / Drainage Sidewalks, Intersections, Signals Stinson Boulevard North of 37th, 37th Avenue NE (County Road D)2016 HSIP / Debt levy/ County 1,460,000 - - - - - - - - - - - - - - - - - Street lighting Stinson Boulevard North of 37th 2016 Debt Levy 161,000 - - - - - - - - - - - - - - - - - Intersections Railroad Crossing Stinson Blvd 2016 Debt Levy 230,000 - - - - - - - - - - - - - - - - - Street lighting LED Silver Lake Rd 2017 TIF 206,000 - - - - - - - - - - - - - - - - - Sidewalk / Lighting Stinson South of 37th 2028-29 Debt Levy 299,785 - - - - - - - - - - - - 401,400 222,355 Sidewalk / Lighting Stinson Boulevard South of 33rd 2030-31 Debt Levy 374,731 - - - - - - - - - - - - - - - 294,871 303,717 Street lighting 37th Avenue NE (County Road D)2030 Debt Levy 327,890 - - - - - - - - - - - 458,481 - - - - - Street lighting 33rd Avenue NE (County Road C2)2026 Debt Levy 368,876 - - - - - - - - - - - - - - 500,768 - - TOTAL SIDEWALKS/LIGHTING ETC.3,428,282 - - - - - - - - - - - - - 458,481 401,400 222,355 500,768 294,871 303,717 TOTAL STREETS IMPROVEMENT PLAN 38,829,193 2,442,640 2,442,640 2,173,540 1,874,720 2,182,172 2,529,760 2,158,639 2,603,009 2,605,820 2,734,580 3,010,211 2,221,440 2,356,000 711,759 667,342 501,594 888,840 736,241 771,971 City of St. Anthony Debt Levy - Roads, Tax Abatement, Public Facilities 802,382 897,435 902,685 918,015 916,965 920,850 929,565 937,755 950,670 729,039 565,647 142,865 138,581 139,547 140,033 2019 Base 2019 Levy Year 60 61 62 63 64 2018 2019street 2020 Street 2021 2022 Existing Bonds Fund 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 2037 2038 2039 2040 $1,700,000 - 2003A (Refunding 2011A)503 118,057 121,103 123,992 121,473 124,204 132,028 134,286 $1,790,000 - 2004A (Refunded in 2011B)503 128,800 $1,695,000 - 2005A (Refunded in 2011B)503 121,500 $2,485,000 - 2006A (Refunded in 2012A)503 186,668 $2,050,000 - 2007A (Refunded in 2012A)503 137,737 $1,305,000 - 2008A (2014C)365 175,652 177,319 178,526 169,602 170,021 172,436 169,496 171,806 168,761 170,966 172,673 173,040 $2,630,000 - 2009A (Refunded in 2017A)512 184,768 185,450 185,975 186,343 186,553 186,605 172,921 179,549 180,612 181,518 187,516 187,949 182,974 $1,645,000 - 2009B (2001B & 2002A)503 196,995 192,401 187,808 193,714 183,608 106,150 $1,375,000 - 2010A 514 108,587 112,065 110,175 108,285 111,645 109,413 112,209 114,624 111,532 113,665 115,450 111,729 113,258 114,350 $1,940,000 - 2011A 516 141,991 138,684 140,626 142,411 138,789 140,416 141,886 142,871 138,434 139,248 139,537 139,642 139,183 138,526 137,266 $2,210,000 - 2011B (2004A and 2005A) 503 - 226,977 226,899 221,025 225,157 223,441 226,430 223,537 109,589 $9,495,000 - 2012A (2006A & 2007A)503/518 - 423,185 518,973 519,813 530,693 520,758 520,968 526,218 531,153 535,773 306,356 141,358 142,865 138,581 139,547 140,033 $1,775,000 - 2013B 520 - - 118,685 118,930 119,176 119,120 119,063 118,523 117,984 117,082 115,939 119,864 118,133 116,402 119,133 116,476 119,070 - $2,230,000 - 2014A 522 - - - 157,629 155,848 159,318 157,433 155,548 153,663 157,028 154,896 151,488 153,330 155,015 151,292 152,820 154,190 154,914 $2,580,000 - 2015A 524 - - - - 185,075 182,847 185,869 183,537 186,454 184,016 186,829 184,286 186,993 183,886 186,029 182,331 183,884 184,819 185,111 $1,455,000 - 2016A 526 102,173 106,135 104,742 103,349 101,956 105,813 104,315 102,817 106,568 104,965 103,362 107,009 105,025 103,042 105,757 $2,600,000 - 2017A 528 189,734 191,592 193,296 189,591 191,136 192,523 193,753 189,575 190,647 191,562 192,320 192,919 193,362 193,646 193,774 $2,610,000 - 2018A 530 179,849 180,959 181,585 177,298 177,998 178,467 178,737 178,797 180,484 176,764 178,294 179,666 180,382 180,927 181,302 Total Levy 1,500,755 1,577,184 1,791,659 1,939,225 2,130,768 2,154,706 2,236,431 2,292,395 2,175,786 2,072,428 1,853,442 1,684,191 1,511,772 1,321,640 1,207,676 1,067,068 933,237 815,971 661,181 479,785 374,701 181,302 - - - - - - - 2019 Road Improvements Bonds $1,150,000 - 2019A 2019A 107,690 107,690 107,690 107,690 107,690 107,690 107,690 107,690 107,690 107,690 107,690 107,690 107,690 107,690 107,690 2020-2027 Road Improvements Bonds $1,765,000 - 2020A 2020A 152,207 152,207 152,207 152,207 152,207 152,207 152,207 152,207 152,207 152,207 152,207 152,207 152,207 152,207 152,207 $2,062,000 - 2021A 2021A 184,531 184,531 184,531 184,531 184,531 184,531 184,531 184,531 184,531 184,531 184,531 184,531 184,531 184,531 184,531 $2,400,000 - 2022A 2022A 202,957 202,957 202,957 202,957 202,957 202,957 202,957 202,957 202,957 202,957 202,957 202,957 202,957 202,957 202,957 $1,834,000 - 2023A 2023A 157,514 157,514 157,514 157,514 157,514 157,514 157,514 157,514 157,514 157,514 157,514 157,514 157,514 157,514 157,514 $2,364,000 - 2024A 2024A 204,497 204,497 204,497 204,497 204,497 204,497 204,497 204,497 204,497 204,497 204,497 204,497 204,497 204,497 204,497 $2,428,000 - 2025A 2025A 215,083 215,083 215,083 215,083 215,083 215,083 215,083 215,083 215,083 215,083 215,083 215,083 215,083 215,083 215,083 $2,628,000 - 2026A 2026A 233,993 233,993 233,993 233,993 233,993 233,993 233,993 233,993 233,993 233,993 233,993 233,993 233,993 233,993 $2,787,000 - 2027A 2027A 245,924 245,924 245,924 245,924 245,924 245,924 245,924 245,924 245,924 245,924 245,924 245,924 245,924 $2,889,000 - 2029A 2029A 252,162 252,681 252,681 252,681 252,681 252,681 252,681 252,681 252,681 252,681 252,681 $2,872,000 - 2031A 2031A 252,162 252,162 252,162 252,162 252,162 252,162 252,162 252,162 252,162 2030-2032 Mill/Overlays, Sidewalks and Street Lighting $680,000 - 2028A 2028 62,477 62,477 62,477 62,477 62,477 62,477 62,477 62,477 62,477 62,477 62,477 62,477 $544,000 - 2030A 2030 34,619 34,619 34,619 34,619 34,619 34,619 34,619 34,619 34,619 34,619 $461,000 - 2032A 2032 38,661 49,216 49,216 49,216 49,216 49,216 49,216 49,216 $814,000 - 2033A 2033 68,215 68,215 68,215 68,215 68,215 68,215 68,215 Additional levy - - - - - - - - 107,690 259,897 444,428 647,384 804,899 1,009,396 1,224,478 1,458,472 1,704,396 1,766,873 2,019,035 2,054,173 2,306,335 2,344,996 2,423,766 2,316,076 2,163,869 1,979,339 1,776,382 1,618,867 1,414,371 Road levy before debt reduction 1,500,755 1,577,184 1,791,659 1,939,225 2,130,768 2,154,706 2,236,431 2,292,395 2,283,476 2,332,325 2,297,870 2,331,576 2,316,671 2,331,036 2,432,155 2,525,540 2,637,632 2,582,844 2,680,216 2,533,958 2,681,036 2,526,298 2,423,766 2,316,076 2,163,869 1,979,339 1,776,382 1,618,867 1,414,371 Stormwater Utilty (25,000) (170,000) (150,000) (95,000) (85,000) (85,000) (85,000) (95,000) (105,000) - - - - - - - - - - - - - - - - MSA Advance (7,500) (25,000) (85,000) (168,000) (152,500) (140,000) (120,000) (3,688) Excess Bond Balance/Project Savings (115,000) (101,921) (92,500) (140,000) (140,009) (120,000) (162,500) (207,500) (120,000) Conduit Fee (15,079) Public Facilities/Abatement Excess (5,000) (35,000) (55,000) (60,000) (65,000) (70,000) (75,000) (80,000) Infrastructure Levy (75,000) 55,873 178,534 173,806 80,421 (31,671) 23,117 (74,255) Road improvement levy 1,500,755 1,577,184 1,776,580 1,791,725 1,828,847 1,792,206 1,778,431 1,854,886 1,873,476 1,894,825 1,920,370 1,947,888 2,372,544 2,509,570 2,605,961 2,605,961 2,605,961 2,605,961 2,605,961 2,533,958 2,681,036 2,526,298 2,423,766 2,316,076 2,163,869 1,979,339 1,776,382 1,618,867 1,414,371 % Increase in Road levy 5.09%12.64%0.85%2.07%-2.00%-0.77%4.30%1.00%1.14%1.35%1.43%21.80%5.78%3.84%0.00%0.00%0.00%0.00%-2.76%5.80%-5.77%-4.06%-4.44%-6.57%-8.53%-10.25%-8.87%-12.63% $ Increase in Road levy 76,429 199,396 15,145 37,122 (36,641) (13,775) 76,455 18,590 21,349 25,545 27,518 424,656 137,026 96,391 0 0 (0) 0 (72,003) 147,078 (154,738) (102,532) (107,690) (152,207) (184,531) (202,957) (157,514) (204,497) TAX ABATEMENT (2009A/2016B/2017A)149,395 146,480 151,025 153,148 155,112 224,877 227,430 222,653 228,375 228,585 228,638 233,782 233,415 96,390 - - - - - - - - - - - - - - - PUBLIC FACILITIES (Refunded 2012A)409,773 379,197 378,462 382,872 387,322 396,207 399,882 403,347 406,602 414,897 422,683 424,289 - - - - - - - - - - - - - - - - - 559,168 525,677 529,487 536,020 542,434 621,084 627,312 626,000 634,977 643,482 651,321 658,071 233,415 96,390 - - - - - - - - - - - - - - - FLATL LINE 2,854,932 Total levied debt after reduction 2,059,923 2,102,861 2,306,067 2,327,744 2,371,281 2,413,290 2,405,743 2,480,886 2,508,453 2,538,307 2,571,691 2,605,959 2,605,959 2,605,960 2,605,961 2,605,961 2,605,961 2,605,961 2,605,961 2,533,958 2,681,036 2,526,298 2,423,766 2,316,076 2,163,869 1,979,339 1,776,382 1,618,867 1,414,371 0 1 1 0 0 (0) 0 (72,003) Total levied debt before reduction 2,059,923 2,102,861 2,321,146 2,475,244 2,673,202 2,775,790 2,863,743 2,918,395 2,918,453 2,975,807 2,949,191 2,989,647 2,550,086 2,427,426 2,432,155 2,525,540 2,637,632 2,582,844 2,680,216 2,533,958 2,681,036 2,526,298 2,423,766 2,316,076 2,163,869 1,979,339 1,776,382 1,618,867 1,414,371 % Increase in Debt Levied 2.08%9.66%0.94%1.87%1.77%-0.31%3.12%1.11%1.19%1.32%1.33%0.00%0.00%0.00%0.00%0.00%0.00%0.00%-2.76%5.80%-5.77%-4.06%-4.44%-6.57%-8.53%-10.25%-8.87%-12.63% % Increase in Debt Scheduled to be levied 2.08%10.38%6.64%8.00%3.84%3.17%1.91%0.00%1.97%-0.89%1.37%-14.70%-4.81%0.19%3.84%4.44%-2.08%3.77%-5.46%5.80%-5.77%-4.06%-4.44%-6.57%-8.53%-10.25%-8.87%-12.63% $ Increase in levied Debt 42,939 203,205 21,678 43,537 42,009 (7,547) 75,143 27,567 29,854 33,384 34,268 0 0 1 0 0 (0) 0 (72,003) 147,078 (154,738) (102,532) (107,690) (152,207) (184,531) (202,957) (157,514) (204,497) 1,000,000 1,100,000 1,200,000 1,300,000 1,400,000 1,500,000 1,600,000 1,700,000 1,800,000 1,900,000 2,000,000 2,100,000 2,200,000 2,300,000 2,400,000 2,500,000 2,600,000 2,700,000 2,800,000 2,900,000 3,000,000 3,100,000 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 Total Levied Debt before reduction Total Levied Debt after reduction Z:\Budget 2019\Capital Equipment\2019 Debt Levy Graph.xlsx 9/27/2018 Sources: Building improvement levy Community Center transfer Uses: HVAC Roofs Lighting Security Windows & Doors Tuck-pointing Buildings Improvement Fund Sources: Capital equipment levy Equipment sales & trade-ins & donations MSA allocation Uses: Fleet -Squads & unmarked -Public Works trucks -Fire trucks & rescue vehicles Heavy equipment Specialty equipment Technology Capital Equipment Fund Sources: Parkland dedication fees Donations & grants Uses: Athletic facilities & playground structures Park shelters Splash pads Trail construction Park Improvement Fund *See Parks matrix for specific park’s amenities Fund established in 2016 with: -Funds from closing the Water Filtration Fund -Army AOP settlement Sources: Connection fees Collection of inter-fund loans Grants as available Utility Fund transfer (Beginning in 2024) Uses: Water infrastructure & equipment Sewer infrastructure & equipment Fiber infrastructure & equipment Utilities Infrastructure Fund Sources: Stormwater fees Watershed grants & cost sharing Uses: Permitting (MS4) & agency reporting Engineering studies Stormwater pond maintenance Flood improvements Water quality activities Stormwater Fund Sources: Street improvement levy Bond proceeds Assessments MSA allocation One-time revenues & project savings Uses: Street improvement debt Street reconstruction Utility reconstruction Street lights Sidewalks Mill & overlays Alleys Street Improvement & Debt Service Funds