Loading...
HomeMy WebLinkAbout6 a. Capital Improvement Program (CIP) Budget (2) � RQSEMO EXECUTIVE SUMMARY PARKS AND RECREATION COMMISSION Parks and Recreation Commission Meeting: November 27, 2017 AGENDA ITEM: Capital Improvement Program (CIP) AGENDA SECTION: Budget Old Business PREPARED BY: Dan Schultz, Parks and Recreation AGENDA NO. Director 6 a. ATTACHMENTS: 2018—2027 CIP Budget and Parks and Recreation Commission Project List APPROVED BY: dls Memo RECOMMENDED ACTION: Motion to recommend the City Council approve the CIP Budget as presented in the Parks and Recreation Commission Packet. ISSUE The City of Rosemount is in the process of updating the 10 yeax Capital Improvement Pla.n (CIP) Budget. The CIP includes larger parks and recreation pxojects and equipment purchases and is updated annually. Included in the packet is a draft copy of the 2018—2027 CIP Budget. Based on the funding currendy available, sta.ff supports the CIP Budget as pYesented. Staff would like for the Commission to discuss the CIP Budget and consider supporting its approval. 10- YEAR C/P WORKING PROGRAM 2018-2027 , . � � �� ���� . , . � � � � �- . . . . :�� ; �����.�� � ,.�, a� F �"�� ` � ti� . �� t�. -�.' `� :► � . . .' —' ��^� �I . � � � -,�r �e,3� _,.- .}., ° , $ § q . _..�.. .�,.A»-<.- ,rz ; � r � � .., W..Ar�`�d? _� +_,',�$ �g— a y'. ,. . .. .,. . ,r.�>w'`��• . . . n � ,� ` � ..- �.�.�.,,;� . v a�` �.�,e� ' �a t�, „�./��Jr �f � ..�� . . ..�t . . � � . 't •v`� qy k ' } ... � y� t �- . �' 't 1� �eifYRtc�' 6 i . ,. 1 ..�+�����'�4"�'�F s ��.. � � `s.° , .� . ; _ _ . c',r..*�s>x.,t:. ,e.x�':.�,L4'�_CxS.,_x.��. �' .�r �t: 4 �� M1Tit+.��,;'. . `�N. { „�< e a .. � � ' _ !: �{t .:,y� a ,. � �s k .a,�, �....� .. �9 ,�F '�y,� , N i!� ��w < ' a� '� F � . �- �.�. � . ' � \€ . . � � �i' ��ns9r( ��' � . � n . . � :. _ t �.� « � v � ,3 ' . � � . . „ �` ,' sV� 1 ��� .�'� ` ",- .'. ..----^^` ., . ��. . 1�;�'�.._;V:� �' , �"�" orw+�r,;.. , '' � ' n' - a� , _�: �...,, . . . _. �. . ' . . . -.,� . . ,-z,.��.,�'"� *- - .�- - r _~'� -�, `�� �:- ,;;,,. � ,� 4, �.-.� �� +E" i � . �+z�„ .. -..ti."'.��'�� .,.:��-�,... :. . i� MINNESOTA 10-YEAR CAPITAL IMPROVEMENT PLAN (CIP) BACKGROUND Historically,the City of Rosemount has usually had some form of CIP in place to utilize for its capital improvements. T'here have been times where just a single year's capital improvements have been addressed and funded. For many years a 5-year CIP was utilized. Over time it was felt that the best way to plan for the future was to look out over a period of at least 10 years. What evolved is the following 10-year Capital Improvement Plan. We believe that great strides have been made to more accurately plan for the future of the City of Rosemount. This document is only a working guide that is utilized by the City Council and its staff to prepare for the future. The first year of the plan will be included as part of the formal budget that is prepared yearly as part of our Truth-in-T�ation process with the following years developed as a working tool for future years' discussions. GENERAL/ADMIIVISTRATIVE DESCRIPTION The CIP provides for specific funding of items that are generally of a higher estimated cost than$5,000 and will have a life expectancy of 3 years or greater. T'he source of funding for these expenditures is typically the general ta�c levy. In some instances, other funding is utilized. For example,revenues received from user fees are being designated in various CIP funds for capital improvement/equipment purchases. Individual deparlments aze designated for each item proposed for purchase in this plan. TYPES OF CAPITAL IMPROVEMENT FUNDS The CIP includes three separate funds to isolate and better track the types of capital improvements being planned for. The following briefly describes each of the three: Building& Facilities CIP Fund -This fund is used to account for the on-going capital improvements and possible additions to government buildings and other facilities. This fund also is utilized for"special projects/items"that are funded mainly with SKB revenues— monies outside of the typical tax levy funding. Street CIP Fund-This fund is used to account for the on-going street and trail construction and reconstruction projects within the City and all other major maintenance items related to both paved and unpaved streets including,but not limited to, street lights, signal lights, sidewalks and gravel road resurfacing. Equipment CIP Fund-This fund is used to account for the on-going replacement of and additions to City equipment. „ Building , , � MSA' 11 15 7 Funds " 8 Facilities SUeet Equipment Park lmp From � Water Sewer , Storm � Water Sewer, 8tortn Debt Serv Total Year Item-Descri tion De errt CIP CIP CIP Assess Fund State Core Care Core Util' Util Util' Le Other Cost 2018 1 Floor Scrubber Arena 9,000 1 9,000 2018 2 Re lace Condenser/Coolin Tower Arena 65,000 1 65,000 2018 3 Data Center Cablin Fiber/Co r C' Hall Finance 7,000 7,000 2018 4 Re lace Council&Staff Tablets Finance 12,500 12,500 2018 5 C' Hall Main Network Switch&Host Server Addition �nance 58,000 58,000 2018 6 Re la�Handheld Radios 17 Fire 76,500 76,500 2018 7 Add Extrication Tools to New En ine 12 Fire 95,000 95,000 2018 S C' -Wide Software Gen'I.Govt. 25,000 25,000 2018 9 Covered Du outs at UMore Bali Field 8 Erickson Park Park&Rec 70 000 70,000 2018 10 Flint Hilis Field Im rovements-Phase 1 ear 1 Park&Rec 900,000 900,000 2018 11 Trail Plans 8�Desi n-R ional Greernva s Park&Rec 50,000 50,000 2018 12 Dunmore Park Develo ment Park 8�Rec 150,000 150,000 2018 13 Horsehoe Lake Park-Phase 1 Park&Rec 300,000 300,000 2018 14 Re lace Bikes Police 3,000 3,000 2018 15 Re Iace S Trailers Police 7,000 7,000 2018 16 Evidence Processin Room E ui ment U rades SoRware Police 9,000 9,000 2018 17 S uad Set U and E ui ment Installation Police 39,000 39,000 2018 18 Re lace uad Mobile Radios Police 54,000 54,000 2018 19 Additional Severe Weather Siren Flint Hills Fields Police 75,000 75,000 2018 20 3 uads Sell Back 3-#3520,#3580 8#35120 Poli� 90,000 20,000 2 110,000 2018 21 PW Buildin Addition Lease/Purchase ear 20 of 20 Pub Works 24,000 10,000 10,000 44,000 2018 22 PedesUian Im rovements P ram Pub Works 125,000 � 125,000 2018 23 PMP December Trail Area Pub Works 655,900 262,600 918,500 2018 24 Coun Road 38-CSAH 31 to TH 3 Construc6on Pub Works 533,000 300,000 3 833,000 2018 25 Bonaire Path-Akron Avenue to Gre stone with Quiet Zone Desi n Pub Works 200,000 3 200,000 2018 26 CSAH 42 at TH 55 Construction Pub Works 35,800 3 35,800 2018 27 CR 73-Bonaire Path to IGH Desi n Pub Works 200,000 3 200,000 2018 28 Bisca e Avenue-Boulder Ave.to CSAH 46 Desi n Pub Works 150,000 3 150,000 2018 29 Connemara Trail-East Extension Desi n Pub Works 170,000 3 170,000 2018 30 Lease Program-Year 1 Pub Works 43,347 9,418 (48,500) (4) 4,265 2018 31 Bobcat Trailer Re lace�10503 Purchased 1999 Pub Works 18,500 1,500 5 20,000 2018 32 Bobcat Re lace#8420 2008 Vehicle Pub Works 15,000 50,000 5,000 5 70,000 2018 33 Groundsmaster Mower Re lace#8068 Purchased 2008 Pub Works 77,000 5,000 5 85,000 2018 34 Sidewalk Trac&Blower Re lace#8417&0121 Purchased 2003 Pub Works 130,000 15,000 5 145,000 2018 35 Sin le-Axle Dum Truck Re lace#8436 2005 Vehicle Pub Works 145,000 35,000 5 180,000 2018 36 1-Ton Picku Re lace#8345 2007 Vehicle Pub Works 52,000 8,000 5 60,000 2018 37 Investi ate and Seal Wells 1&2 Pub Works 150,000 150,000 6 300,000 2018 38 Extend Utilities to UMore Pub Works 300,000 1,648,000 4,310,000 7 6,258,000 0 994,000 780 900 979,847 262,600 500,000 1,288,800 300,000 1,648,000 0 221,418 10,000 350,000 0 4,578,000 11,913,565 Totai CIP Funding Requirements-Year 2018 $2,754,747 $0 (#) These items will be funded with the issuance of Equipment Certificates. $0 (1) Floor scrubber and repiacement of Condenser/Cooling Tower funding comes from Arena Fund operetions/reserves. (2) Other funding for Squad Cars comes from auction sales of old vehicles. (3) Other funding for these projects are not included. Costs are RosemounYs share only. (4) Highlighted items are part of a lease program. This is a summary of the total for the year. Detail is provided in an acxompanying document. (5) Other funding for Public Works equipment comes from hade-in value of old vehicles. (6) Other funding for Wells 1&2 project an6cipated from a MDH Grant(50%of project). (7) Other funding for Extending Util'�ies to Umore wiil come from the University and the devefoper. Total Building CIP levy for 2018 is$24,000. If there is a difference,the difference befinreen this number and the number from above is a result of a 10-year funding progrem and other funding altematives(such as potential SKB revenues). Total Street CIP levy for 2018 is$783,900. If there is a d'rfference,the difference between this number and the number from above is a result of a 10-year funding program and other funding altematives. Total Equipment CIP levy for 2018 is$600,000. If there is a difference,the difference between this number and the number from above is a result of a 10-year funding program and other funding altematives(such as poten6al SKB revenues). 1 of 11 MSA 11/15/17 Building Funds 8�Facilities Street Equipmetrt Park Imp From Water Sewer Stortn Water Sewer Storm Debt Serv Total Year (tem-Descxi tion Da er�t CIP CIP CIP Assess Fund State � Core Core Core Util' UUI" Util Le Other Cost 2019 1 Pairtt Arena Ceilin Arena 85,000 1 85,000 2019 Z Re Iace Chiiler Barrel Arena 135,000 1 135,000 2019 3 PC Workstation U rades From 2014 Admin,Park 8�Rec Finance 83,000 83,000 2019 4 Re lace Air Com ressor Station#1 Fire 65,000 65,000 2019 5 Add Station Exhaust S stems Station#1 and Station#2 Fire 75,000 75,000 2019 6 Re lace Handheld Radios 17 Fire 76 500 76,500 2019 7 C' -Wide Software Gen'I.Govt. 25,000 25,000 2019 S Du outs Bloomfield Park Park 8 Rec 15,000 15,000 2019 9 Baseline Fencin for 3 Fields Park&Rec 30,000 30 000 2019 10 Communi Center/Armo Remodel Park&Rec 150,000 150,000 2019 11 Flint Hills Field Im rovements-Phase 1 ear 2 Park 8�Rec 900,000 900,000 2019 12 Koch Trail Restora6on Park 8�Rec 50,000 2 50,000 2019 13 Skate Park U redes-Phase 1 Park 8�Rec 65,000 2 65,000 2019 14 Develo Park N-5 Park 8�Rec 200,000 200,000 2019 15 S uad Set U and E ui ment Installation Police 40,000 40,000 2019 16 3 uads Sell Back 3-#35150,#35100 E�#35110 Police 93,000 24,000 3 117,000 2019 17 Re lace Police Portable Radios Enc ted Police 142,000 142,000 2019 18 Pedestrian Im rovements P ram Pub Works 125,000 125,000 2019 19 PMP O'Lea s,Carrollton,Oak Rid e Estates,145th St. Pub Works 990,300 430,500 1,420,800 2019 20 CR 73-Bonaire Path to IGH RO Pub Works 337,500 4 337,500 2019 21 Connemara Trail-East Extension ConsVuetion Pub Works 800,000 15,000 312,000 5 1,127,000 2019 22 Bonaire Path-Akron Avenue to Gre stone with Quiet Zone Const. Pub Works 2,000,000 4 2,000,000 2019 23 Lease Program-Year 2 Pub Works 62,347 8,418 (44,500) (6) 26,265 2019 24 Blower Attach for#841 S&#8420 Re lace#0123 2008 Pub Works 6,000 6,000 2019 25 Blower Attach for#8071 8�#8072 Re lace#0119 2001 Pub Works 7,500 7,500 2019 26 Re lace Paint Mixer Pub Works 15,000 15,000 2019 27 Bobcat Re lace#8418 2008 Vehicle Pub Works 45,000 5,000 7 50,000 2019 28 Swee r Re lace#8443 Purohased 2007 Pub Works 101,500 101,500 12,000 7 215,000 2019 29 Sno Go Blower Re lace#0130 Purchased 1987 Pub Works 150,000 150,000 2019 30 6"Trash Pum Re lace#8089 Purchased 1995 Pub Works 16,600 16,700 16,700 50,000 2018 31 Generator Re Iace#805 Purchased 1996 Pub Works 30,000 30,000 5,000 7 65,000 2019 32 Util' Picku w/Crane Re lace#8342 2007 Vehicle Pub Works 32,000 32,000 31,000 15,000 7 110,000 2019 33 Jetter Re lace#8445 2006 Vehicle � Pub Works 92,500 92,500 25,000 210,000 2019 34 Water Stora e Facil' Pub Works 5,000,000 8 5,000,000 2019 35 Water Treatment Facil' Pub Works 8,500,000 8,500,000 8 17,000,000 1,095,000 1,115,300 986,847 430,500 200,000 3,137,500 13,515,000 0 0 8,587,018 171,200 241,700 0 688,500 30,168,565 Total CIP Funding Requirements-Year 2019 $3,197,147 $� (#) These items will be funded with the issuance of Equipment Certificates. $0 (1) Painting Arena Ceiling&Chiller Barrel Replacement funding comes from Arena Fund operations/reserves. (2) Koch Trail Restoration funding will come from a grant Skate Park funding will come from the General Fund Parks Maintenance Budget. (3) Other funding for Squad Cars comes from auction sales of old vehicles. (4) Other funding for these prajects are not included. Costs are RosemounYs share only. (5) Other funding comes from prepaid special assessments collected over the last 5-7 years. (6) Highlighted items are part of a lease program. This is a summary of the total for the year. Detail is provided in an acxompanying document. (7) Other funding for Public Works equipment comes from trade-in value of old vehicles. (8) Funding for the Water Storage Facility and the Water Treatment Facility will come from a Water Revenue bond issue. Total Building CIP levy for 2019 is$0. If there is a difference,the d'rfference between this number and the number from above is a result of a 10-year funding program and other funding altematives(such as potential SKB revenues). Total Street CIP levy for 2019 is$852,327. If there is a difference,the d'ifferen�between this number and the number from above is a result of a 10-year funding program and other funding altematives(such as potential SKB revenues). Total Equipment CIP levy far 2019 is$620,000. If there is a difference,the difference between this number and the number from above is a result of a 10-year funding program and other funding altematives(such as potential SKB revenues). 2of11 MSA 11/15/17 Building Funds &Facil'�ties Street EquipmeM Park Imp From Water Sewer Storm Water Sewer Storm Debt Serv Total Year Item-Descri tion De rtment CIP CIP CIP Assess Fund State Core Core Core Utif Util' Util' Le Other Cost 2020 1 Restroom Rehab-Lower Arena 25,000 1 25,000 2020 2 Scoreboards Arena 30,000 1 30,000 2020 3 LED Li htin Arena 65,000 1 65,000 2020 4 Phone Server Re lacements From 2015 Finance 20,000 20,000 2020 5 Re lace Fire De rtment Mobile Com uters From 2016 Finance 35,000 35,000 2020 6 4 Server Environment 8�Stora e Re lacements From 2015 Finance 75,000 75,000 2020 7 Aerial Platfarm Truck Re lacement Purchased in 2020 Fire 1,200,000 # 1,200,000 2020 8 C' -Wide Software Gen'I.Govt. 25,000 25,000 2020 9 Skate Park U rades-Phase 2 Park 8�Rec 65,000 2 65,000 2020 10 Flint Hills Field Im rovements-Phase 1 ear 3 Park&Rec 900,000 900,000 2020 11 Umore Ball Field Im rovements-Phase 2 Park&Rec 1,900,000 1,900,000 2020 12 Re lace 1/2 ofAED's 5 Police 8,000 8,000 2020 13 S uad Set U and E ui ment Installation Police 39,000 39,000 2020 14 3 S uads Sell Back 3-#3550,#3580&#35170 Police 96,000 24,000 3 120,000 2020 15 Pedestrian Im rovements Pr ram Pub Works 125,000 125,000 2020 16 PMP est Rid e A,Chi ndale A Pub Works 621,041 98,875 719,916 2020 17 Roundabout 140th Street/Diamond Path Desi n Pub Works 45,000 4 45,000 2020 18 CR 73-Bonaire Path to IGH Construction Pub Works 1,320,000 4 1,320,000 2020 19 Bisca e Avenue-Boulder Trail to CR 46 Pub Works 2,000,000 5 2,000,000 2020 20 Lease Program-Year 3 Pub Works 114,647 8,418 (99,000) (6) 24,065 2020 21 Pavement Roller Re lace#8129 Purchased 2003 Pub Works 58,000 2,000 60,000 2020 22 Sin le-Axle Dum Truck Re Iace#8430 2009 Vehicle Pub Works 145 000 35,000 7 180,000 2,800,000 746,041 615,647 98,875 0 3,365,000 0 0 0 8,418 0 0 0 1,347,000 8,980,981 Total CIP Funding Requirements-Year 2020 $4,161,688 $0 (#) These items will be funded with the issuance of Equipment Certificates. $1,200,000 (1) Lower Restroom Rehab,Scoreboards 8�LED Lighting funding comes from Arena Fund operations/reserves. (2) Skate Park funding will come from the General Fund Parks Maintenance Budget. (3) Other funding for Squad Cars comes from auction sales of old vehicles. (4) Other funding for these projects are not included. Costs are RosemounYs share only. (5) Other funding for Biscayne Avenue project for the University of Minnesota are not included. Costs are RosemounYs share only. (The University needs a 2-year notice prior to project start) (6) Highlighted items are part of a lease program. This is a summary of the total for the year. Detail is provided in an acxompanying document. (7) Other funding for Public Works equipment comes from trade-in value of old vehicles. Total Buiiding CIP levy for 2020 is$0. If there is a difference,the difference between this number and the number from above is a result of a 10-year funding progrem and other funding altematives(such as potential SKB revenues). Total Street CIP levy for 2020 is$877,897. If there is a difference,the difference between this number and the number from above is a result of a 10-year funding program and other funding altematives(such as potential SKB revenues). Total Equipment CIP levy for 2020 is$640,000. If there is a difference,the difference between this number and the number from above is a result of a 10.year funding program and other funding altematives(such as potential SKB revenues). 3of11 MSA 19/15N 7 � Building ' Funds 8 Faalities Street Equtpment Park Imp From Water Sswer Stortn Water Sewer Storm Debt Serv Total Year Item-Descri tion De rtment CIP CIP CIP Assess Fund State Core Core Core Utll' Util' Util' Le Other Cost 2021 1 Arena Refi eration/Rink S stem Arena 375,000 1 375,000 2021 2 Aerial Platform Truck Re lacement ear 1 of 5 Fire 252,000 252,000 2021 3 C' -Wide Software Gen'I.Govt. 25,000 25,000 2021 4 Re lace Less Lethal Wea ns Police 6,000 6,000 2021 5 S uad Set U and E ui ment Instailation Police 52,000 52,000 2021 6 Re lace uad Ydeo S stem Police 120,000 120,000 2021 7 4 S uads Sell Back 4-#3530,#3540,#3570&#35140 Police 128,000 32,000 2 160,000 2021 8 Pedestrian Im rovements Pr ram Pub Works 125,000 125,000 2021 9 PMP est Rid e C,Shannon Pond,Dodd,Bisca e B,» Pub Works 1,437,990 383,921 1,821,911 2021 10 Roundabout 140th Street/Diamond Path RO Pub Works 78,800 3 78,800 2021 11 Lease Program-Year 4 Pub Works 163,147 8,418 (82,000) (4) 89,565 2021 12 Sho Hoist Re lace#0002 Purohased 2006 Pub Works 55,000 5,000 5 60,000 2021 13 JD Tractor&Blower Re lace#8406&�128 2006 8�2011 Pub Works 108,000 7,000 5 115,000 PMP Cont:Rosemount Hills B,Ja Simons 0 1,562,990 909,147 383,921 0 78,800 0 0 0 8,418 0 0 0 337 000 3,280,276 Total CIP Funding Requirements-Year 2021 $2,472,137 $0 (#) These ftems will be funded with the issuance of Equipment Certificates. $0 (1) Arena Refigeration/Rink System funding comes from Arena Fund operations/reserves. (2) Other funding for Squad Cars comes from auction sales of old vehicles. (3) Other funding for these projects are not included. Costs are RosemounYs share only. (4) Highlighted items are part of a lease program. This is a summary of the total for the year. Detail is provided in an accompanying document. (5) Other funding for Public Works equipment comes from trade-in value of old vehicles. Total Building CIP levy for 2021 is$0. If there is a d'rfferance,the difference between this number and the number from above is a result of a 10-year funding progrem and other funding altematives(such as potential SKB revenues). Total Street CIP levy for 2021 is$904,234. If there is a d'rfierence,the difference between this number and the number from above is a result of a 10-year funding program and other funding altematives(such as potential SKB revenues). Total Equipment CIP levy for 2021 is$660,000. If there is a difference,the d'ifference between this number and the number from above is a resuit of a 10-year funding program and other funding altematives(such as potential SKB revenues). 4of11 MSA 11/15/17 Building , Funds 8�Facilfies Street Equipmerrt Park Imp From ' Water Sewer' Storm Water Sewer Storm Debt Serv ' Total Year'' ' kem-Descri tion De rtment CIP CIP CIP Assess Fund State Core Core Core Udl" Util' Util' Le Other Cost 2022 1 Re lace Zamboni Batteries Arena 15,000 1 15,000 2022 2 Restroom Rehab-U r Arena 20,000 1 20,000 2022 3 Re lace Com ressors Arena 70,000 1 70,000 2022 4 PC Workstation U rades From 201 Police,Fire,P.W. Finance 80,000 80,000 2022 5 Aerial Platform Truck Re lacement ear 2 of 5 Fire 252,000 252,000 2022 6 C' -Wide Soflware Gen'I.Govt. 25,000 25,000 20?2 7 CenVal Park Im rovements Park 8 Rec 1,200,000 1,200,000 2022 8 Re lace Police Portable Radio Batteries Police 5,000 5,000 2022 9 S uad Set U and E ui ment Installation Police 45,000 45,000 2022 10 Re lace S uad La to s 5 /Printers/Netmotion Police 55,000 55,000 2022 11 3 S uads Sell Back 3-#3520,#3560 8#3580 Police 100,000 20,000 2 120,000 2022 12 Pedestrian Im rovements P ram Pub Works 125,000 125,000 2022 13 PMP ensmann A/B/C,December Trail,Stonebrid e,» Pub Works 2,408,824 752,215 3,161,039 2022 14 Roundabout 140th Street/Diamond Path ConsVuction Pub Works 440,000 3 440,000 2022 15 Lease Program-Year 5 Pub Works 197,397 10,918 2,500 4,750 (85,000) (4) 130,565 2022 16 Blower Attach for#8409 Re lace#0122 2001 Pub Works 15,000 15,000 2022 17 Crash Attenuator Re lace#0049 Purohased 2007 Pub Works 20,000 20,000 2022 18 Loader,Win &Plow Re lace#8419 Purchased 2005 Pub Works 275,000 50,000 5 325,000 2022 19 Well#17 Construction Pub Works 1,500,000 6 1,500,000 PMP Cont.-Dee woods,White Lake Acres 1,200,000 2,533,824 1,069,397 752,215 0 440,000 1,500,000 0 0 10,918 2,500 4,750 0 90,000 7,603,604 Total CIP Funding Requirements-Year 2022 $4,803,221 $� (#) These items wili be funded with the issuance of Equipment Certificates. $0 (1) Zamboni Battery Replacements,Upper Restroom Rehab 8�Compressors funding comes from Arena Fund operationsJreserves. (2) Other funding for Squad Cars comes from auction sales of old vehicles. (3) Other funding for these projects are not included. Costs are RosemounYs share only. (4) Highlighted ftems are part of a lease program. This is a summary of the total for the year. Detail is provided in an acxompanying document. (5) Other funding for Public Works equipment comes from trade-in value of old vehicles. (6) Funding for Well#17 will come from a Water Revenue bond issue. Total Building CIP levy for 2022 is$0. If there is a difference,the difference between this number and the number from above is a result of a 10-year funding program and other funding altematives(such as poten6al SKB revenues). Total Street CIP levy for 2022 is$931,361. If there is a difference,the d'rfference befinreen this number and the number from above is a result of a 10-year funding program and other funding altematives(such as potential SKB revenues). Total Equipment CIP levy for 2022 is$680,000. If there is a difference,the difference beriveen this number and the number from above is a result of a 10-year funding program and other funding altematives(such as potential SKB revenues). 5of11 MSA 11/15/17 Building Funds 8�Faalfies SVeet Equipment Park Imp From Water Sewer Storm Water Sewer Stortn Debt Serv Total Year kem-Dascri tion De eM CIP' ' C1P "' CIP' Assess Fund ' State' Core ' Core Core UUI' ' Util' Util Le Other Cost 2023 1 Re Iace Skate Tile Arena 90,000 1 90,000 2023 2 Aerial Platform Truck Re lacement ear 3 of 5 Fire 252,000 252,000 2023 3 C' -Wide Soflware Gen'I.Govt. 25,000 25,000 2023 4 S uad Set U and E ui ment Installation Police 50,000 50,000 2023 5 3 S uads Sell Back 2-#3590 8�#35110&1 New Addition Police 105,000 16,000 2 121,000 2023 6 Pedestrian Im rovements P ram Pub Works 125,000 125,000 2023 7 PMP Geronime Pond,Town Center,Cameo&143rd,McNamara Pub Works 811,581 225,016 1,036,597 2023 S Lease Program-Year 6 Pub Works 204,050 12,500 2,500 4,750 (77,000) (3) 146,800 2023 9 Aerator Re lace�157 Purchased 2013 Pub Works 18,000 2,000 4 20,000 2023 10 Generetor Re Iace#8059 Purchased 2003 Pub Works 35,000 35,000 5,000 4 75,000 0 936,581 654,050 225,016 0 0 0 0 0 47,500 37,500 4,750 0 36,000 1,941,397 Total CIP Funding Requirements-Year 2023 $1,590,631 $0 (#) These items will be funded with the issuance of Equipment Certificates. $0 (1) Skate Tile funding comes from Arena Fund operations/reserves. (2) Other funding for Squad Cars comes from auction sales of old vehicles. (3) Highlighted items are part of a lease program. This is a summary of the total for the year. Detail is provided in an accompanying document. (4) Other funding for Public Works equipment comes from trade-in value of old vehicles. Total Building CIP levy for 2023 is$0. If there is a difFerence,the difference between this number and the number from above is a result of a 10-year funding program and other funding altematives(such as potential SKB revenues). Total Street CIP levy for 2023 is$959,302. If there is a difference,the differen�between this number and the number from above is a result of a 10-year funding program and other funding altematives(such as potential SKB revenues). Total Equipment CIP levy for 2023 is$700,000. If there is a d'�fference,the difference between this number and the number from above is a result of a 10-year funding program and other funding altema6ves(such as potential SKB revenues). 6of11 MSA , 11N5N7 Building Funds ` , &Facilities Street Equipment Par9c Imp From Water Sewer Storm Water Sewer Stortn Debt Serv Total Year Item-Descri tion De rtrnent CIP CIP CIP Assess Furtd State Core Core Core Util' Util' Util" Le Other Cost 2024 1 Re lace Skate Sha ner Arena 20,000 1 20,000 2024 2 Re lace Fire De artment Mobile Com uters From 2020 Finance 35,000 35,000 2024 3 PC Workstation U rades From 2019 Admin,Park 8 Rec Finance 70,000 70,000 2024 4 Aerial Piatfortn Truck Re lacement ear 4 of 5 Fire 252,000 252,000 2024 5 C' -Wide Software Gen'I.Govt. 25,000 25,000 2024 6 S uad Set U and E ui ment Installation Police 30,000 30,000 2024 7 2 S uads Sell Back 2-#3510 8�Ki5100 Police 66,000 16,000 2 82,000 2024 8 Pedesfian Im rovements P ram Pub Works 125,000 125,000 2024 9 PMP Boomfield B,O'Lea 's Hills C,Connemara A,» Pub Works 1,222,832 305 817 1,528,649 2024 10 Lease Program-Year T Pub Works 210,550 12,500 2,500 4,750 (66,000) (3) 164,300 2024 11 Groundsmaster Mower Re lace#8066 Purchased 2015 Pub Works 87,000 8,000 4 95,000 2024 12 Groundsmaster Mower Re iace#8073 Purchased 2015 Pub Works 87,000 5,000 4 95,000 2024 13 Sin le-Axle Dum Truck Re lacs#8432 2012 Vehicle Pub Works 151,000 39,000 4 190,000 PMP Cont.-Aubum Ave.,145th St.A , 0 1,347,832 1,013,550 305,817 0 0 0 0 0 12,500 2,500 4,750 0 25,000 2,711,949 Total CIP Funding Requirements-Year 2024 $2,361,382 $� (#) These items will be funded with the issuance of Equipment Certificates. $0 (1) Skate Sharpener funding comes from Arena Fund operations/reserves. (2) Other funding for Squad Cars comes from auction sales af old vehicles. (3) Highlighted items are part of a lease program. This is a summary of the total for the year. Detail is provided in an acxompanying document. (4) Other funding for Public Works equipment comes from trade-in value of old vehicles. Total Building CIP levy for 2024 is$0. If there is a difference,the d'rfFeren�beiween this number and the number from above is a result of a 10-year funding program and other funding altematives(such as potential SKB revenues). Total Street CIP levy for 2024 is$988,081. If there is a difference,the d'dference�tween this number and the number from above is a result of a 10-year funding program and other funding altematives(such as potential SKB revenues). Total Equipment CIP levy for 2024 is$720,000. If there is a difference,the difference between this number and the number from above is a result of a 10-year funding program and other funding altematives(such as potential SKB revenues). 7of11 MSA 11l15/17 Building , Funds �` ' ' 8 Facilities Street Equfpment ' Park Imp From Water ' Sewer Storm Water Sewer 5tortn Debt Serv Total,' Year Item-D 'tion De errt CIP CIP ' CIP Assess Fund State Core Core Core Util' Util' Util' Le Other Cost 2025 1 Re lace Ice Ed er Arena 8,000 1 8,000 2025 2 Phone Server Re lacements From 2020 Finan� 20,000 20,000 2025 3 PC File Server Re lacements 8�Backu S stem From 2020 Finance 120,000 120,000 2025 4 Aerial Platform Truck Re lacement ear 5 of 5 Fire 252,000 252,000 2025 5 C' -Wide Softvware Gen'I.Govt. 25,000 25,000 2025 6 S uad Set U and E ui ment Installation Police 75,000 75,000 2025 7 5 S uads Sell Back 5-#3530,#3550,#3570,35140 8�#35170 Police 175,000 40,000 2 215,000 2025 8 Pedestrian Im rovements Pr ram Pub Works 125,000 125,000 2025 9 PMP Bloomfield A,West Rid e B,Coun Hills A,» Pub Works 1,044,591 351,968 1,396,559 2025 10 Lease Program-Year 8 Pub Works 210,550 12,500 2,500 4,750 (105,000) (3) 125,300 2025 11 Water Truck Re Iace#8431 2013 Vehicle Pub Works 180,000 20,000 4 200,000 2025 12 Dum Tandem Re lace#8434 2013 Vehicle Pub Works 795,000 35,000 4 230,000 PMP Cont.-Conle ,Chi endale B 0 1,169,591 1,252,550 351,968 0 0 0 0 0 12,500 2,500 4,750 0 2,000 2,791,859 Total CIP Funding Requirements-Year 2025 $2,422,141 $0 (#) These items will be tunded with the issuance of Equipment Certificates. $0 (1) Ice Edger funding comes from Arena Fund operations/reserves. (2) Other Tunding for Squad Cars comes from aucdon sales of otd vehicles. (3) Highlighted items are part of a lease program. This is a summary of the total for the year. Detail is provided in an accompanying document. (4) Other funding for Public Works equipment comes from trade-in value of old vehicles. Total Building CIP levy for 2025 is$0. If there is a difference,the difference between this number and the number from above is a result of a 10-year funding program and other funding altematives(such as potenUal SKB revenues). Total Street CIP levy for 2025 is$1,017,723. If there is a difference,the difference between this number and the number from above is a result of a 10-year funding program and other funding aitematives(such as poterttial SKB revenues). Total Equipment CIP levy for 2025 is$740,000. If there is a difference,the difference between this number and the number from above is a result of a 10-year funding program and other funding altematives(such as potential SKB revenues). 8 of 11 MSA 11/15N7 Building Funds &Facilities Street Equipmeiit Park Imp From Water Sewer Stortn Water Sewer Stortn Debt Serv Total Year Item-Descri �on De eM CIP CIP CIP Assess Fund State Core Core Core Util' Util' Util' Le Other Cost 2026 1 Re lace Ice Resurfacer Arena 120,000 1 120,000 2026 2 C' -Wide Software Gen'I.Govt. 25,000 25,000 2026 3 S uad Set U and E ui ment Installation Palice 45,000 45,000 2026 4 3 S uads Sell Back 3-#3520,3540 8�#3580 Police 110,000 24,000 2 134,000 2026 5 Pedestrian Im rovements Pr ram Pub Works 125,000 125,000 2026 6 PMP Coun Hills B,Hawkins Pond Broback Paric,» Pub Works 883,238 318,103 1,201,341 2026 7 Lease Program-Year 8 Pub Works 220,050 12,500 2,500 4,750 (96,000) (3) 143,800 2026 8 John Deere Trailer Re Iace#0525 Purchased 2010 Pub Works 12,000 12,000 2026 9 Wood Chi r Re lace#8161 Purchased 2014 Pub Works 45,000 5,000 4 50,000 PMP Cont.-Bisca ne A,Autumn Path 0 1,008,238 457,050 318,103 0 0 0 0 0 12,500 2,500 4,750 0 53,000 1,856,141 Total CIP Funding Requirements-Year 2026 $1,465,288 $0 (#) These items will be funded with the issuance of Equipment Certificates. (1) Ice Resurfacer funding comes from Arena Fund operations/reserves. $0 (2) Other funding for Squad Cars comes from auction sales of old vehicies. (3) Highlighted items are part of a lease program. This is a summary of the total for the year. Detail is provided in an accompanying document. (4) Other funding for Public Works equipment comes from trade-in value of old vehicles. Total Building CIP levy for 2026 is$0. If there is a difference,the difference between this number and the number from above is a result of a 10-year funding program and other funding altematives(such as potential SKB revenues). Total Street CIP levy for 2026 is$1,048,255. If there is a d'rfference,the d'rfference between this number and the number from above is a result of a 10-year funding program and other funding altematives(such as potenUal SKB revenues). Total Equipment CIP Ievy for 2026 is$760,000. If there is a d'ifference,the d'rfference between this number and the number from above is a result of a 10-year funding program and other funding altematives(such as potenUal SKB revenues). 9of11 � MSA � , 11l1S(17 Building " Funds� ' ' �Faalities Street EquipmeM Park Imp From Water Sewer Storm Water Sewer Storm Debt Serv Total Year Item-Descri tion De eM CIP CIP CIP Assess Fund State Core Core Core Util' UUI' Util' Le Other Cost " 2027 1 PC Workstation U rades From 2022 Police,Fire,P.W. Finance 80,000 80,000 2027 2 C' -Wide Soflware Gen'I.Govt. 25,000 25,000 2027 3 S uad Set U and E ui ment Installation Police 45,000 45,000 2027 4 3 S uads Sell Back 3-#3560,#35110&#35120 Police 110,000 20,000 2 130,000 2027 5 Pedestrian Im rovements P ram Pub Works 125,000 125,000 2027 6 PMP Evermoor B,Bisca ne Pointe C,Shannon Pond East Pub Works 804,803 432,028 1,236,831 2027 7 Lease Program-Year 10 Pub Works 229,800 13,000 3,000 3,000 (90,000) (3) 158,800 2027 8 Groundsmaster Mower Re lace#8068 Purchased 2018 Pub Warks 85,000 10,000 4 95,000 2027 9 Dum Sin le Re lace#8437 2014 Vehicle Pub Works 160,000 40,000 4 200,000 2027 10 Swee r Re lace#8444 Purchased 2017 Pub Warks 110,000 110,000 20,000 4 240,000 0 929,803 844,800 432,028 0 0 0 0 0 13,000 3,000 113,000 0 0 2,335,631 Total CIP Funding Requirements-Year 2027 $1,774,603 $0 (#) These ftems will be funded with the issuance of Equipment Certificates. (1) �0000000000a funding comes from Arena Fund opera6ons/reserves. $0 (2) Other funding for Squad Cars comes from auction sales of old vehicles. (3) Highlighted items are part of a lease progrem. This is a summary of the totai for the year. Detail is provided in an accompanying document. (4) Other funding for Public Works equipment comes from trade-in value of old vehicles. Total Building CIP levy for 2027 is$0. If there is a difference,the difference between this number and the number from above is a result of a 10-year funding program and other funding altematives(such as potential SKB revenues). Total Street CIP levy for 2027 is$1,079,702. If there is a difference,the difference between this number and the number from above is a result of a 10-year funding program and other funding altematives(such as potential SKB revenues). Total Equipment CIP levy for 2027 is$780,000. if there is a difference,the difference between this number and the number from above is a result of a 10-year funding program and other funding altematives(such as poten6al SKB revenues). 10 of 11 MSA 11h5/17 Building Funds �Faalities SVeet Equipmerrt Park Imp From Water Sewer Storm Water Sewer Stortn Debt Serv Total Year Item-Descr� tion De ent CIP CIP CIP Assess Fund State Core Core Core Util' Util' Util' Le Other Cost Future 1 S lash Pad Water Reuse Pro'ect Council 750,000 1 750,000 Future 2 Public Works/C' Hall Buildin Ex ansion/Police Council 5,000,000 2 5,000,000 Future 3 Tender Truck Addition Fire 180,000 3 180,000 Future 4 En ine Truck Addition Fire 700,000 4 700,000 Future 5 Add Fire Station#3 Same time as additional En ine Truck Fire 4 Future 6 ADA Com liant U rades Stud Park&Rec 20,000 20,000 Future 7 Commun' Center Covered Walk Park 8 Rec 175,000 175,000 Future 8 S lash Pad-Phase 2 Park 8�Rec 1,000,000 1,000,000 Future 9 Umore BaII Fields-Phase 2 Park&Rec 2,600,000 2,600,000 Future 10 Flint Hills Athletic Fieids Im rovements-Phases 2&3 Park&Rec 3,200,000 3,200,000 Future 11 TH 3 Aesthetic Im rovements Pub Works 448,500 5 448,500 Future 12 NoRh Central Sanita Sewer Extension Pub Works 6 Future 13 Street Construction-BoulderAvenue Extension Pub Works 3,000,000 7 3,000,000 Future 14 Shannon Pond Outlet Pub Works 8 Future 15 Gravel Road Im rovements Pub Works 8 Future 16 Akron Avenue South of Coun Road 42 Pub Works 1,250,000 1,250,000 Future 17 Soccer Goal Trailer Re lace i1A501 Purchased 1980 Pub Works 12,000 12,000 Future 18 Hose Treiler Re lace#0502 Purohased 1990 Pub Works 12,000 12,000 Future 19 Barricade Trailer Re lace#0510 Purchased 1986 Pub Works 12,000 12,000 Future 20 Hose Trailer Re lace#0517 Purchased 1995 Pub Works 12,000 12,000 Future 21 Stri r Trailer Re lace#0518 Purchased 1994 Pub Works 12,000 12,000 Future 22 Easement Trailer Re Iace iW521 Purchased 2003 Pub Works 12,000 12,000 Future 23 Pu t Trailer Re lace�l0515 Purchased 1991 Pub Works 12,000 12,000 Future 24 Fire House Trailer Re lace#0519 Purchased 1994 Pub Works 12,000 12,000 Future 25 Surveillance Trailer Re lace i�0523 Purchased 2008 Pub Works 12,000 12,000 6,975,000 0 792,000 0 0 1,250,000 0 0 0 0 0 0 0 9,378,500 18,395,500 Total CIP Funding Requirements-Future Years $7,767,000 $0 (#) These items will be funded with the issuance of Equipment Certifiptes. $0 (1) Funding and timing for the splash pad water resuse project still to be determined. (2) Funding for the City Hall Expansion($1,000,000)8�PW Building Expansion($4,000,000)will come from a general bond issue. (3) Funding and timing of purchase of Tender Truck(Addition)stlll to be determined. (4) Timing for Fire Station#3 and Additional Engine Truck still to be determined. (5) Other funding for TH 3 projects will come from grants or other incentives. (6) Future costs associated with the sanftary sewer will include extensive street reconstruction on the foilowing streets: 124th St,125th St,Bianca Ave W,128th St,Bolivia Ave,130th St W,Biscayne Ave,Bengal Ave,129th St W,CR 38,132nd Court and Bonnaire Path. Costs and funding are not available at this time. (7) Other funding for Boulder Avenue extension will come from a PoR Authority bond issue. (8) Costs and funding are not available at this time. 11 of 11