Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
2021.07.20 Work Session Packet
4141 Douglas Drive North • Crystal, Minnesota 55422-1696 Tel: (763) 531-1000 • Fax: (763) 531-1188 • www.crystalmn.gov Posted: July 16, 2021 City Council Work Session Agenda Tuesday, July 20, 2021 at 6:00 p.m. Council Chambers/Zoom Pursuant to due call and notice given in the manner prescribed by Section 3.01 of the City Charter, the work session of the Crystal City Council was held on Tuesday, July 20, 2021 at _____ p.m. in the Council Chambers at City Hall, 4141 Douglas Dr. N., Crystal, Minnesota. If the agenda items are not completed in time for the regular City Council meeting at 7 p.m., the meeting will be continued and resumed immediately following the City Council meeting. The public may also monitor and participate in the meeting by connecting via Zoom, through one of the methods identified on the City Council Meeting Schedule. I. Attendance Council members Staff ____ LaRoche ____ Norris ____ Revering ____ Parsons ____ Therres ____ Sutter ____ Adams ____ Gilchrist ____ Serres ____ Banks ____ Elholm ____ Budziszewski ____ Larson ____ Cummings ____ McGann ____ Kiser ____ Ray II. Agenda The purpose of the work session is to discuss the following agenda items: 1. Interview Parks and Recreation Commission candidate. 2. 2022 budget preview and overview. 3. Blue Line Extension update. 4. Constituent issues update. 5. City manager monthly check-in. 6. New business. * 7. Announcements. * III. Adjournment The work session adjourned at ______ p.m. * Denotes no supporting information included in the packet. Auxiliary aids are available upon request to individuals with disabilities by calling the City Clerk at (763) 531-1145 at least 96 hours in advance. TTY users may call Minnesota Relay at 711 or 1-800-627-3529 July 20, 2021 ➢2022 Budget update ➢2022 Property taxes ➢General Fund overview ➢Long-term plan ❑Property taxes reduced from 6.1% increase to 4.3% increase ❑Health insurance premiums to remain at 2021 rates ❑Workers compensation insurance anticipated increase: 10– 15% ❑Insurance increases anticipated ❑Property: 5-10% ❑Liability: 5-12% ❑Auto: 3-7%Union contracts open ❑American Rescue Funds may be used to replace lost revenues ❑Utility rates consistent with 2018 rate study 2021 Adopted 2021 % Change 2022 Accepted 2022 Increase (Decrease) 2022 % Change 2022 Proposed 2022 Increase (Decrease) 2022 % Change General levy 12,084,489$ 19.14 %12,740,995$ 656,506$ 5.43 %12,508,518$ 424,029$ 3.51 % Capital improvements Police Equipment Revolving 158,037 2.00 161,197 3,160 2.00 158,037 - (2.00) Park Improvement 480,511 33.88 606,999 126,488 26.32 606,999 126,488 26.32 Street Construction 114,550 4.00 119,132 4,582 4.00 119,132 4,582 4.00 Total Capital Improvements 753,098 -61.20 887,328 134,230 17.82 884,168 131,070 17.40 EDA 300,000 6.10 310,000 10,000 3.33 310,000 - 0.00 Total levy 13,137,587$ 6.23 %13,938,323$ 800,736$ 6.10 %13,702,686$ 565,099$ 4.30 % % Increase from prior year Capital Project Funds 2022 Police Equipment Revolving 158,037$ Park Improvement 606,999 Street Construction 119,132 Internal Service Funds Information Technology 437,123 Buildings 1,082,603 Fleet 337,956 Total 2,741,850$ Capital Levies 2019 2020 2021 2022 2022 Actual Amended Adopted Accepted Proposed REVENUES Property taxes - operations 9,743,618$ 10,218,522$ 10,768,994$ 11,378,421$ 11,176,520$ Special assessments and other 70,500 52,000 52,000 52,000 Property taxes - Internal allocations 1,317,154 1,362,495 1,409,574 1,409,574 Licenses and permits 835,711 853,810 896,860 850,960 850,960 Intergovernmental revenues 1,907,764 1,787,339 1,777,489 1,777,489 1,777,489 Charges for services 811,940 891,402 846,711 863,853 863,853 Fines & forfeits 287,985 307,000 275,000 275,000 275,000 Investment income 116,464 94,512 125,000 125,000 125,000 Miscellaneous 69,675 82,683 68,000 68,000 68,000 Other - interfund services transfers in 458,861 474,258 479,502 505,185 505,185 TOTAL REVENUES 14,232,018 16,097,180 16,652,051 17,305,482 17,103,581 EXPENDITURES General Government 2,227,790$ 2,239,738$ 2,267,228$ 2,329,399$ 2,353,191$ Public safety 7,335,302 8,194,542 8,417,237 8,806,887 8,515,725 Community Development 557,867 721,723 707,745 737,197 742,832 Public works 2,402,399 2,867,494 3,071,311 3,177,913 3,239,982 Recreation 1,678,233 2,073,683 2,188,530 2,254,086 2,251,851 TOTAL EXPENDITURES 14,201,591$ 16,097,180$ 16,652,051$ 17,305,482$ 17,103,581$ Major Expenditure Changes 2021 Adopted 2022 Accepted 2022 Proposed 554,871$ 653,431$ (201,901)$ Wages and Benefits 338,301$ 455,811 (267,026) Human Resources - prof. services and service contracts 9,475 - - Assessing - County Assessor contract increase 26,000 7,000 - Finance - professional services 10,000 5,000 - Police - K9 Overtime 7,100 - - Police - Mental Health 35,000 - - Police - Legal services - 5,000 - Police - neighborhood outreach - - (250) Elections (includes wages and benefits)(112,596) 5,000 - Community Center - biennial refinishing of gym floor - 6,400 - Engineering - - 822 Streets - salt (7,000) - - Streets - contractual services and city utility charges - - 5,939 Parks - - 58,614 Utility reallocation, dues, miscellaneous and inflation 190,341 116,353 - West Metro Fire District 58,250 52,867 - 554,871$ 653,431$ (201,901)$ ➢Reference long-term plan in materials CITY OF CRYSTAL, MINNESOTA LONG TERM PLAN Prepared on July 14, 2021 Prepared by AEM Financial Solutions, LLC. THIS PAGE IS LEFT BLANK INTENTIONALLY City of Crystal, Minnesota Long Term Plan Table of Contents Page No. Compilation Disclosure 5 Introductory Section Transmittal Letter 8 Financial Section Schedule of Property Taxes Levied and Tax Rates 12 Schedule of Annual Fund Cash Balances 16 Outstanding Debt Schedule 18 Capital Improvement Plan Street Capital Fund 415 Schedule of Planned Capital Outlay 2019 to 2030 20 Schedule of Projected Revenue, Expenditures and Debt 24 Police Equipment Revolving Fund 235 Schedule of Planned Capital Outlay 2019 to 2030 26 Schedule of Projected Revenue, Expenditures and Debt 30 Park Improvements 420 Schedule of Planned Capital Outlay 2019 to 2030 32 Schedule of Projected Revenue, Expenditures and Debt 34 Water Fund 505 Schedule of Planned Capital Outlay 2019 to 2030 36 Statement of Cash Flows 38 Sanitary Sewer Fund 510 Schedule of Planned Capital Outlay 2019 to 2030 40 Statement of Cash Flows 42 Storm Drainage Fund 515 Schedule of Planned Capital Outlay 2019 to 2030 44 Statement of Cash Flows 46 Street Light Fund 520 Schedule of Planned Capital Outlay 2019 to 2030 48 Statement of Cash Flows 50 Fleet Fund 615 Schedule of Planned Capital Outlay 2019 to 2030 52 Statement of Cash Flows 56 Major Building Replacement Fund 408/625 Schedule of Planned Capital Outlay 2019 to 2030 58 Schedule of Projected Revenue, Expenditures and Debt 64 Information Technology Fund 620 Schedule of Planned Capital Outlay 2019 to 2030 66 Statement of Cash Flows 72 Selected Graphical Data from Projections 74 Appendix A Internal Loan Schedule for Public Safety Facility Renovation/Construction 78 Appendix B Internal Service Summary Schedule 83 3 THIS PAGE IS LEFT BLANK INTENTIONALLY 4 July 14, 2021 COMPILATION DISCLOSURE Honorable Mayor and City Council City of Crystal 4141 Douglas Drive North Crystal, Minnesota 55422 We have compiled the accompanying forecasted long-term plan that includes property tax, tax rate, fund balance and debt projections based on input from the City Council and City staff. This projection incorporates estimates through December 31, 2031 for all presented funds. This forecast was compiled in accordance with attestation standards established by the American Institute of Certified Public Accountants. A compilation is limited to presenting in the form of forecast information that is the representation of management and does not include evaluation of the support for the assumptions underlying the forecast. We have not examined the forecast and, accordingly, do not express an opinion or any other form of assurance on the accompanying statements or assumptions. Furthermore, there will usually be differences between the forecasted and actual results because events and circumstances frequently do not occur as expected, and those differences may be material. We have no responsibility to update this report for events and circumstances occurring after the date of this report. Sincerely, AEM FINANCIAL SOLUTIONS, LLC 5 THIS PAGE IS LEFT BLANK INTENTIONALLY 6 INTRODUCTORY SECTION CITY OF CRYSTAL, MINNESOTA LONG TERM PLAN 7 July 14, 2021 Honorable Mayor and City Council City of Crystal 4141 Douglas Drive North Crystal, Minnesota 55422 Introduction As discussed in prior communications to the City Council, we have been preparing a long term plan for the City that is intended to give a big picture view of the status now and five years from now. We have measured and projected operations, capital and debt for the City based on assumptions made by management. The City’s assumptions made are as follows: Assumptions The following assumptions have been used to calculate the projections in this report: Rates Interest Earnings 1.00% Governmental Fund Revenue Growth 3.00% Governmental Fund Expenditure Growth 3.00% Water and Sanitary Sewer Funds 2020 - 2022 11.00% 2023 - 2024 5.50% 2025 - 2030 3.00% Storm Drainage Fund Expense Growth (1) 5.00% Street Lighting 2.00% General Fund Levy Growth 3.00% EDA Fund Levy Growth 2.00% Population Growth 0.49% Median Home Value Growth 3.00% Tax Capacity Growth Rate (Including Fiscal Disparities)3.00% Governmental Fund Debt Interest Rate 3.00% Governmental Fund Debt Term 15 (1) Specific enterprise fund assumptions are noted in the Financial Section. 8 Assumptions with Future Action • General Fund property tax revenue has been increased for 2022 based on the results of the long-term plan and the Park System Master Plan. • PERF Fund 235 will need additional analysis and policy review in order to ensure capital needs are met. • Building Fund 408/625 will receive internal loans for the renovation/construction of a Public Safety Facility and for other capital needs. These loans are from the Street Improvement Fund, Police Revolving Fund, Park Improvement Fund, Water Fund, Storm Water Fund and IT Fund. All loans will be repaid by 2031 and the repayment schedule is included on page 78. Key Highlights • At December 31, 2020 the General fund had a 44.0 percent operating reserve. The Minnesota Office of the State Auditor defines an adequate reserve as 35-50 percent of the General fund expenditures. A 45 percent fund balance reserve has been assumed in the long-term plan. The projected General Fund reserve balance is anticipated to remain at or above 45 percent rage throughout the life of this Plan. We anticipate the General fund levy will grow by an average of 3 percent to maintain the desired reserve level. • The tax levy is projected to increase from $12.3 million (2020 adopted) to $19.1 million (2031 projected) over the duration of this Plan based on the anticipated construction of a public safety facility along with other capital levy needs. The levy increase will result in an increase in the projected tax rate, ranging from 47.855 percent (2020) to 63.963 percent throughout the life of this Plan. A decrease in the tax levy or applicable tax rate is not anticipated, given the capital needs outlined in our report. o Tax capacity is assumed to grow at a rate of 3 percent during the duration of this Plan. A growth in tax rate in excess of these projections may result in lower tax rates in future years. o The future captured tax increment capacity has not been analyzed for this report and is assumed to remain the same as it is projected in 2021. • Total debt outstanding is projected to decrease from $12.5 million (2020 actual) to $750,000 (2031 projected) over the duration of this Plan. As a result, the debt per capita will fall from an estimated $505 (2020 actual) per household to an estimated $29 (2031 projected) over the duration of this Plan. • Due to planned capital projects, the total cash position of the City is projected to decrease from $43.1 million (2020 actual) to $39.8 million over the duration of this Plan. • The Police Department facility has been allocated $4,000,000 based on the 2020 state bonding bill. This allocation is anticipated to be received in 2021. • Several funds were not analyzed for the purposes of this report and include a 1 percent interest rate earnings assumption the cash balance. These funds include: TIF Districts, Special Projects, Cable TV Equipment, Recycling, Self Insurance and Hennepin Recycling Group. The actual cash results for the years 2020 - 2031 will vary from the results estimated in this report. 9 THIS PAGE IS LEFT BLANK INTENTIONALLY 10 FINANCIAL SECTION CITY OF CRYSTAL, MINNESOTA LONG TERM PLAN 11 City of Crystal, Minnesota Schedule of Property Taxes Levied and Tax Rates For the Years Ended December 31, 2020 (Actual) and 2021 to 2031 (Estimated) 2020 2021 2022 2023 Actual Budgeted Proposed Estimated Amounts Amounts Amounts Amounts Property Taxes Levied for General Purposes 100 General 11,407,848$ 12,084,489$ 12,508,518$ 13,133,944$ 220 EDA/HRA Funds 283,935 300,000 310,000 316,200 415 Street Capital 110,144 114,550 119,132 123,897 235 PERF Fund 154,938 158,037 158,037 158,037 405 PIR Fund - - - - 408 Building Fund - - - 420 Park Improvements 359,138 480,511 606,999 741,026 615 Fleet - - - 620 Information Technology - - - Total Taxes Levied 12,316,003 13,137,587 13,702,686 14,473,104 Percent Levy Increase 6.67%4.30%5.62% Less: Value of Market Value Levies - - - - Less: Distribution from fiscal disparities (2,336,753) (2,321,749) (2,391,401) (2,463,144) City Net Levy 9,979,250$ 10,815,838$ 11,311,284$ 12,009,960$ Tax Capacity Personal and Real Estate 22,411,718$ 23,708,339$ 24,419,589$ 25,152,177$ Other assumed net growth factors - - - - Less: Contribution to fiscal disparities (1,297,703) (1,481,700) (1,526,151) (1,571,936) Less: Tax Increment (278,074) (288,561) (288,561) (288,561) Adjusted net tax capacity 20,835,941$ 21,938,078$ 22,604,877$ 23,291,680$ 12 2024 2025 2026 2027 2028 2029 2030 2031 Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated Amounts Amounts Amounts Amounts Amounts Amounts Amounts Amounts 13,790,641$ 14,480,173$ 15,204,182$ 15,964,391$ 16,762,610$ 17,600,741$ 18,480,778$ 19,404,817$ 322,524 328,974 465,000 342,265 349,110 356,093 363,214 370,479 128,853 134,007 139,367 144,942 150,740 156,769 163,040 169,562 158,037 158,037 158,037 158,037 158,037 158,037 158,037 158,037 - - - - - - - - - - - - - - - - 882,657 1,032,322 1,190,432 1,358,712 1,533,746 1,719,866 1,916,290 2,123,542 - - - - - - - - - - - - - - - - 15,282,712 16,133,513 17,157,018 17,968,347 18,954,243 19,991,505 21,081,359 22,226,436 5.59%5.57%6.34%4.73%5.49%5.47%5.45%5.43% - - - - - - - - (2,537,038) (2,613,149) (2,691,543) (2,772,290) (2,855,458) (2,941,122) (3,029,356) (3,120,237) 12,745,674$ 13,520,365$ 14,465,474$ 15,196,057$ 16,098,785$ 17,050,383$ 18,052,003$ 19,106,200$ 25,906,742$ 26,683,944$ 27,484,463$ 28,308,997$ 29,158,267$ 30,033,015$ 30,934,005$ 31,862,025$ - - - - - - - - (1,619,094) (1,667,666) (1,717,696) (1,769,227) (1,822,304) (1,876,973) (1,933,282) (1,991,281) (288,561) (288,561) - - - - - - 23,999,088$ 24,727,717$ 25,766,766$ 26,539,769$ 27,335,962$ 28,156,041$ 29,000,723$ 29,870,744$ 13 City of Crystal, Minnesota Schedule of Property Taxes Levied and Tax Rates (Continued) For the Years Ended December 31, 2020 (Actual) and 2021 to 2031 (Estimated) 2020 2021 2022 2023 Actual Estimated Estimated Estimated Amounts Amounts Amounts Amounts Tax Rates General 45.37%46.41%46.74%47.84% Capital levies 2.48%2.89%3.30%3.73% Scheduled debt levies 0.00%0.00%0.00%0.00% Total City Levy Tax Rate 47.855%49.302%50.039%51.563% Total EDA Tax Rate 1.070%1.128%1.137%1.131% Population 24,712 24,833 24,833 24,955 Taxes per Capita 498$ 529$ 552$ 580$ Tax Levy ($) General 11,407,848$ 12,084,489$ 12,508,518$ 13,133,944$ Capital 624,220 753,098 884,168 1,022,960 Economic Development Authority 283,935 300,000 310,000 316,200 Debt service - - - - Tax Levy (%) General 92.63%91.98%91.29%90.75% Capital 5.07%5.73%6.45%7.07% Economic Development Authority 2.31%2.28%2.26%2.18% Debt Service 0.00%0.00%0.00%0.00% 14 2024 2025 2026 2027 2028 2029 2030 2031 Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated Amounts Amounts Amounts Amounts Amounts Amounts Amounts Amounts 48.96%50.10%51.14%51.86%53.06%54.28%55.52%56.79% 4.15%4.58%5.00%5.40%5.83%6.28%6.72%7.17% 0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00% 53.109%54.677%56.140%57.258%58.892%60.557%62.247%63.963% 1.125%1.119%1.543%1.107%1.101%1.095%1.088%1.082% 25,077 25,200 25,323 25,448 25,572 25,698 25,824 25,950 609$ 640$ 678$ 706$ 741$ 778$ 816$ 856$ 13,790,641$ 14,480,173$ 15,204,182$ 15,964,391$ 16,762,610$ 17,600,741$ 18,480,778$ 19,404,817$ 1,169,547 1,324,366 1,487,836 1,661,691 1,842,522 2,034,672 2,237,366 2,451,141 322,524 328,974 465,000 342,265 349,110 356,093 363,214 370,479 - - - - - - - - 90.24%89.75%88.62%88.85%88.44%88.04%87.66%87.31% 7.65%8.21%8.67%9.25%9.72%10.18%10.61%11.03% 2.11%2.04%2.71%1.90%1.84%1.78%1.72%1.67% 0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00% 15 City of Crystal, Minnesota Schedule of Annual Fund Cash Balances For the Years Ended December 31, 2020 (Actual) and 2021 to 2031 (Estimated) 2020 2021 2022 2023 Actual Estimated Estimated Estimated Amounts Amounts Amounts Amounts Government-Type General Operations 101 General 8,638,151$ 8,638,151$ 8,638,151$ 8,858,151$ Special Revenue 220 Economic Development Authority 2,159,000 2,097,202 2,030,352 1,958,397 *206-210 TIF Districts Special Revenue 1,049,041 1,059,531 1,070,127 1,080,828 *240-245 Special Projects 148,919 148,920 148,921 148,922 Subtotal 3,356,960 3,305,653 3,249,400 3,188,147 Debt Service 329-337 Debt Service 4,492,080 4,305,042 4,175,108 4,044,695 Capital Projects 405 Permanent Improvement Revolving - - - - 415 Street Reconstruction 7,761,272 6,203,911 5,280,353 4,747,355 409 Fire Equipment Revolving - 100,000 202,750 308,326 235 Police Equipment Revolving 2,778,653 1,530,490 1,522,971 341,449 420 Park Improvement 1,185,687 1,241,174 601,173 38,211 *404 Cable TV Equipment 238,405 240,789 243,197 245,629 Subtotal 11,964,017 9,316,364 7,850,443 5,680,969 Total - Governmental-type Funds 28,451,208 25,565,211 23,913,102 21,771,961 Internal Service 620 Information Technology 538,420 700,747 380,403 213,584 408/625 Building 4,735,240 4,783,220 3,724,511 83,721 615 Fleet 2,542,989 2,407,568 2,072,165 1,591,766 *605 Self Insurance 604,584 610,630 616,736 622,903 Total - Internal Service-type Funds 8,421,233 8,502,164 6,793,814 2,511,974 Business-Type Enterprise Funds 505 Water 1,537,557 1,809,654 1,964,758 589,216 510 Sewer 1,160,442 1,047,991 1,149,180 937,161 515 Storm Drainage 2,149,587 434,367 80,408 590,746 520 Street Lights 776,217 815,076 852,914 388,272 *525 Recycling 135,533 136,888 138,257 139,640 Total - Business-type Funds 5,759,336 4,243,977 4,185,518 2,645,035 Agency Fund *250 Hennepin Recycling Group 509,263 514,356 519,499 524,694 Grand Total - City 43,141,040$ 38,825,707$ 35,411,934$ 27,453,665$ *Annual growth in fund balance of 1% assumed Trend indicator Adequate for reserve levels Adequate as of 2020 but decreasing balance, watch Below targeted reserve levels and should have a plan to address The fund has events in the future that need addressing now 16 2024 2025 2026 2027 2028 2029 2030 2031 Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated Amounts Amounts Amounts Amounts Amounts Amounts Amounts Amounts Trend 9,234,751$ 9,622,649$ 10,122,184$ 10,636,705$ 11,166,662$ 11,712,517$ 12,274,748$ 12,853,846$ 1,881,120 1,798,301 1,709,707 1,615,099 1,514,231 1,406,846 1,292,678 1,292,678 1,091,636 1,102,553 1,113,578 1,124,714 1,135,961 1,147,321 1,158,794 1,170,382 148,923 148,924 148,925 148,926 148,927 148,928 148,929 148,930 3,121,680 3,049,777 2,972,210 2,888,739 2,799,119 2,703,094 2,600,401 2,611,990 4,124,910 4,183,098 4,209,274 4,183,625 4,134,488 4,072,780 4,011,933 3,930,869 - - - - - - - - 6,645,982 6,073,251 5,100,152 4,322,897 3,533,667 2,742,574 1,602,841 2,185,931 416,805 528,267 642,794 760,471 881,384 1,005,622 1,133,276 1,264,442 242,736 403,037 439,940 487,212 1,139,957 1,749,229 2,044,624 2,222,973 (688,750) (1,223,316) (570,117) (92,106) (219,281) 1,073,392 1,388,415 2,095,841 248,085 250,566 253,072 255,602 258,158 260,740 263,347 265,981 6,864,858 6,031,804 5,865,840 5,734,076 5,593,884 6,831,556 6,432,504 8,035,168 23,346,198 22,887,328 23,169,508 23,443,144 23,694,153 25,319,948 25,319,586 27,431,873 195,092 279,872 364,182 447,895 531,751 766,760 755,069 705,969 983,344 1,064,932 1,851,455 3,146,113 3,282,140 3,357,104 3,093,550 4,883,251 1,501,575 1,382,103 1,398,417 1,270,056 1,545,643 1,688,661 1,516,132 1,384,190 629,133 635,424 641,778 648,196 654,678 661,225 667,837 674,515 3,309,143 3,362,332 4,255,832 5,512,259 6,014,212 6,473,750 6,032,589 7,647,925 363,966 300,634 505,941 737,109 964,631 1,330,432 1,703,893 2,988,349 826,405 579,580 609,443 497,160 271,007 175,715 55,900 (88,674) 895,234 1,591,623 1,450,172 1,539,986 2,173,732 1,064,515 1,571,640 700,291 414,133 435,039 450,561 460,240 463,592 460,104 449,232 455,402 141,036 142,447 143,871 145,310 146,763 148,230 149,713 151,210 2,640,773 3,049,323 3,159,988 3,379,805 4,019,725 3,178,995 3,930,377 4,206,578 529,941 535,241 540,593 545,999 551,459 556,973 562,543 568,169 29,826,056$ 29,834,224$ 31,125,921$ 32,881,208$ 34,279,548$ 35,529,666$ 35,845,095$ 39,854,543$ 17 City of Crystal, Minnesota Outstanding Debt Schedule For the Years Ended December 31, 2020 (Actual) and 2021 to 2031 (Estimated) 2020 2021 2022 2023 Original Issue Maturity Interest Actual Estimated Estimated Estimated Fund Issue Issue Date Date Rate Balance Balance Balance Balance Government-Type General Obligation Bonds 330 2009A Special Assessment 3,360,000$ 7/21/2009 2/1/2030 2.00 - 4.50 %485,000$ 320,000$ 160,000$ -$ 332 2011A Special Assessment 1,705,000 7/19/2011 2/1/2027 0.50 - 3.55 685,000 575,000 470,000 370,000 333 2012A Special Assessment 2,635,000 7/16/2013 2/1/2028 0.50 - 3.55 1,250,000 1,080,000 915,000 750,000 334 2013A Special Assessment 3,235,000 6/17/2015 2/1/2029 0.50 - 3.55 1,825,000 1,605,000 1,390,000 1,180,000 335 2015A Special Assessment 2,550,000 7/16/2015 2/1/2031 2.50 - 3.00 1,755,000 1,575,000 1,400,000 1,230,000 336 2016A Special Assessment 3,330,000 8/25/2016 2/1/2032 2.00 - 2.50 2,550,000 2,310,000 2,075,000 1,845,000 337 2017A Special Assessment 4,665,000 9/14/2017 2/1/2033 2.00 - 3.00 3,920,000 3,595,000 3,280,000 2,965,000 Total G.O. Tax Bonds 29,360,000 12,470,000 11,060,000 9,690,000 8,340,000 Total Government-Type 29,360,000$ 12,470,000$ 11,060,000$ 9,690,000$ 8,340,000$ Population 24,712 24,833 24,955 25,077 Debt Per Capita - Total 505$ 445$ 388$ 333$ 18 2024 2025 2026 2027 2028 2029 2030 2031 Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated Balance Balance Balance Balance Balance Balance Balance Balance -$ -$ -$ -$ -$ -$ -$ -$ 270,000 175,000 85,000 - - - - - 590,000 435,000 285,000 140,000 - - - - 975,000 770,000 570,000 375,000 185,000 - - - 1,065,000 900,000 740,000 585,000 435,000 285,000 140,000 - 1,620,000 1,400,000 1,185,000 975,000 770,000 570,000 375,000 185,000 2,655,000 2,345,000 2,040,000 1,740,000 1,440,000 1,145,000 855,000 565,000 7,175,000 6,025,000 4,905,000 3,815,000 2,830,000 2,000,000 1,370,000 750,000 7,175,000$ 6,025,000$ 4,905,000$ 3,815,000$ 2,830,000$ 2,000,000$ 1,370,000$ 750,000$ 25,200 25,323 25,448 25,572 25,698 25,824 25,950 26,078 285$ 238$ 193$ 149$ 110$ 77$ 53$ 29$ 19 City of Crystal, Minnesota Capital Improvement Plan - Street Capital Fund 415 Schedule of Planned Capital Outlay 2020 to 2031 2020 2021 2022 Business Unit Year to Budgeted Proposed Proposed Department Object Code Subledger Replace Item Cost Amounts Amounts Amounts Public works 0415.6305 TBA 2020 In house mill and overlay 52,500$ 52,500$ -$ -$ Public works 0415.6305 TBA 2020 Sidewalk shaving (trip hazard removal)20,000 20,000 - - Public works 0415.6305 TBA 2020 Misc concrete work 56,650 56,650 - - Public works 0415.6305 TBA 2020 Contract mill and overlay 1,478,000 1,478,000 - - Public works 0415.6305 TBA 2020 Flashing yellow arrows 26,000 26,000 - - Public works 0415.6305 TBA 2020 ADA Ped Ramp replacements 41,200 41,200 - - Public works 0415.6305 TBA 2020 Utility Reconstruction 300,000 300,000 - - Public works 0415.6305 TBA 2021 Replace retaining wall Douglas and 36th 50,000 - 50,000 - Public works 0415.6305 TBA 2021 In house mill and overlay 55,125 - 55,125 - Public works 0415.6305 TBA 2021 Sidewalk shaving (trip hazard removal)20,000 - 20,000 - Public works 0415.6305 TBA 2021 Misc concrete work 58,350 - 58,350 - Public works 0415.6305 TBA 2021 Contract mill and overlay 1,276,000 - 1,276,000 - Public works 0415.6305 TBA 2021 Flashing yellow arrows 35,000 - 35,000 - Public works 0415.6305 TBA 2021 ADA Ped Ramp replacements 42,436 - 42,436 - Public works 0415.6305 TBA 2021 Utility Reconstruction 300,000 - 300,000 - Public works 0415.6305 TBA 2022 In house mill and overlay 57,881 - - 57,881 Public works 0415.6305 TBA 2022 Sidewalk shaving (trip hazard removal)20,000 - - 20,000 Public works 0415.6305 TBA 2022 Misc concrete work 60,100 - - 60,100 Public works 0415.6305 TBA 2022 Contract mill and overlay 846,000 - - 846,000 Public works 0415.6305 TBA 2022 ADA Ped Ramp replacements 43,709 - - 43,709 Public works 0415.6305 TBA 2022 Utility Reconstruction 550,000 - - 550,000 Public works 0415.6305 TBA 2023 In house mill and overlay 60,775 - - - Public works 0415.6305 TBA 2023 Sidewalk shaving (trip hazard removal)20,000 - - - Public works 0415.6305 TBA 2023 Misc concrete work 61,903 - - - Public works 0415.6305 TBA 2023 Contract mill and overlay 882,000 - - - Public works 0415.6305 TBA 2023 ADA Ped Ramp replacements 45,020 - - - Public works 0415.6305 TBA 2023 Utility Reconstruction 300,000 - - - Public works 0415.6305 TBA 2024 Regent Ave mini-roundabout 250,000 - - - Public works 0415.6305 TBA 2024 Contract mill and overlay 1,120,000 - - - Public works 0415.6305 TBA 2024 In house mill and overlay 60,775 - - - Public works 0415.6305 TBA 2024 Sidewalk shaving (trip hazard removal)20,000 - - - Public works 0415.6305 TBA 2024 Misc concrete work 61,903 - - - Public works 0415.6305 TBA 2024 ADA Ped Ramp replacements 45,020 - - - Public works 0415.6305 TBA 2024 Utility Reconstruction 300,000 - - - Public works 0415.6305 TBA 2025 In house mill and overlay 60,775 - - - Public works 0415.6305 TBA 2025 Sidewalk shaving (trip hazard removal)20,000 - - - Public works 0415.6305 TBA 2025 Misc concrete work 61,903 - - - Public works 0415.6305 TBA 2025 ADA Ped Ramp replacements 45,020 - - - Public works 0415.6305 TBA 2025 Contract mill and overlay 882,000 - - - Public works 0415.6305 TBA 2025 Utility Reconstruction 300,000 - - - Public works 0415.6305 TBA 2026 Utility Reconstruction 300,000 - - - Public works 0415.6305 TBA 2026 In house mill and overlay 60,775 - - - Public works 0415.6305 TBA 2026 Sidewalk shaving (trip hazard removal)20,000 - - - Public works 0415.6305 TBA 2026 Misc concrete work 61,903 - - - Public works 0415.6305 TBA 2026 ADA Ped Ramp replacements 45,020 - - - Public works 0415.6305 TBA 2026 Contract mill and overlay 882,000 - - - Public works 0415.6305 TBA 2026 Retaining wall replacement 4009 Douglas Dr N 200,000 - - - Public works 0415.6305 TBA 2027 Utility Reconstruction 300,000 - - - Public works 0415.6305 TBA 2027 In house mill and overlay 60,775 - - - Public works 0415.6305 TBA 2027 Sidewalk shaving (trip hazard removal)20,000 - - - Public works 0415.6305 TBA 2027 Misc concrete work 61,903 - - - Public works 0415.6305 TBA 2027 ADA Ped Ramp replacements 45,020 - - - Public works 0415.6305 TBA 2027 Contract mill and overlay 882,000 - - - 20 2023 2024 2025 2026 2027 2028 2029 2030 2031 Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated Amounts Amounts Amounts Amounts Amounts Amounts Amounts Amounts Amounts -$ -$ -$ -$ -$ -$ -$ -$ -$ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 60,775 - - - - - - - - 20,000 - - - - - - - - 61,903 - - - - - - - - 882,000 - - - - - - - - 45,020 - - - - - - - - 300,000 - - - - - - - - - 250,000 - - - - - - - - 1,120,000 - - - - - - - - 60,775 - - - - - - - - 20,000 - - - - - - - - 61,903 - - - - - - - - 45,020 - - - - - - - - 300,000 - - - - - - - - - 60,775 - - - - - - - - 20,000 - - - - - - - - 61,903 - - - - - - - - 45,020 - - - - - - - - 882,000 - - - - - - - - 300,000 - - - - - - - - - 300,000 - - - - - - - - 60,775 - - - - - - - - 20,000 - - - - - - - - 61,903 - - - - - - - - 45,020 - - - - - - - - 882,000 - - - - - - - - 200,000 - - - - - - - - - 300,000 - - - - - - - - 60,775 - - - - - - - - 20,000 - - - - - - - - 61,903 - - - - - - - - 45,020 - - - - - - - - 882,000 - - - - 21 City of Crystal, Minnesota Capital Improvement Plan - Street Capital Fund 415 Schedule of Planned Capital Outlay 2020 to 2031 (Continued) 2020 2021 2022 Business Unit Year to Budgeted Proposed Proposed Department Object Code Subledger Replace Item Cost Amounts Amounts Amounts Public works 0415.6305 TBA 2028 In house mill and overlay 60,775$ -$ -$ -$ Public works 0415.6305 TBA 2028 Sidewalk shaving (trip hazard removal)20,000 - - - Public works 0415.6305 TBA 2028 Misc concrete work 61,903 - - - Public works 0415.6305 TBA 2028 Crack sealing 10,000 - - - Public works 0415.6305 TBA 2028 ADA Ped Ramp replacements 45,020 - - - Public works 0415.6305 TBA 2028 Contract mill and overlay 882,000 - - - Public works 0415.6305 TBA 2028 Utility Reconstruction 300,000 - - - Public works 0415.6305 TBA 2029 In house mill and overlay 60,775 - - - Public works 0415.6305 TBA 2029 Sidewalk shaving (trip hazard removal)20,000 - - - Public works 0415.6305 TBA 2029 Misc concrete work 61,903 - - - Public works 0415.6305 TBA 2029 Crack sealing 10,000 - - - Public works 0415.6305 TBA 2029 ADA Ped Ramp replacements 45,020 - - - Public works 0415.6305 TBA 2029 Contract mill and overlay 882,000 - - - Public works 0415.6305 TBA 2029 Utility Reconstruction 300,000 - - - Public works 0415.6305 TBA 2030 In house mill and overlay 60,775 - - - Public works 0415.6305 TBA 2030 Sidewalk shaving (trip hazard removal)20,000 - - - Public works 0415.6305 TBA 2030 Misc concrete work 61,903 - - - Public works 0415.6305 TBA 2030 Crack sealing 10,000 - - - Public works 0415.6305 TBA 2030 ADA Ped Ramp replacements 45,020 - - - Public works 0415.6305 TBA 2030 Contract mill and overlay 1,230,000 - - - Public works 0415.6305 TBA 2030 Utility Reconstruction 300,000 - - - 1,974,350$ 1,836,911$ 1,577,690$ 22 2023 2024 2025 2026 2027 2028 2029 2030 2031 Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated Amounts Amounts Amounts Amounts Amounts Amounts Amounts Amounts Amounts -$ -$ -$ -$ -$ 60,775$ -$ -$ -$ - - - - - 20,000 - - - - - - - - 61,903 - - - - - - - - 10,000 - - - - - - - - 45,020 - - - - - - - - 882,000 - - - - - - - - 300,000 - - - - - - - - - 60,775 - - - - - - - - 20,000 - - - - - - - - 61,903 - - - - - - - - 10,000 - - - - - - - - 45,020 - - - - - - - - 882,000 - - - - - - - - 300,000 - - - - - - - - - 60,775 - - - - - - - - 20,000 - - - - - - - - 61,903 - - - - - - - - 10,000 - - - - - - - - 45,020 - - - - - - - - 1,230,000 - - - - - - - - 300,000 - 1,369,699$ 1,857,699$ 1,369,699$ 1,569,699$ 1,369,699$ 1,379,699$ 1,379,699$ 1,727,699$ -$ 23 City of Crystal, Minnesota Capital Improvement Plan - Street Capital Fund 415 Schedule of Projected Revenue, Expenditures and Debt 2020 2021 2022 Actual Adopted Proposed Revenues Property taxes (4% increase, annually, beginning in 2021) *110,144$ 114,550$ 119,132$ Special assessments 600,322 460,000 230,000 Interest on investments 319,054 75,000 75,000 Franchise fees - - - Miscellaneous 28,933 - - Total Revenues 1,058,453 649,550 424,132 Expenditures Capital outlay Public works 2,794,624 1,836,911 1,577,690 Total Expenditures 2,794,624 1,836,911 1,577,690 Excess (Deficiency) of Revenues Over (Under) Expenditures (1,736,171) (1,187,361) (1,153,559) Other Financing Sources Transfers in - - - Intergovernmental revenue (Municipal State Aid - MSA)1,013,257 230,000 230,000 Internal loan to Building (600,000) Internal loan repayment Bond proceeds - - - Sale of Fixed Asset - - - Total Other Financing Sources 1,013,257 (370,000) 230,000 Net Change in Fund Balances (722,914) (1,557,361) (923,559) Cash Balance, January 1 8,484,186 7,761,272 6,203,911 Cash Balances, December 31 7,761,272$ 6,203,911$ 5,280,353$ Capital Project Fund Projected Activity 24 2023 2024 2025 2026 2027 2028 2029 2030 2031 Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated 123,897$ 128,853$ 134,007$ 139,367$ 144,942$ 150,740$ 156,769$ 163,040$ 169,562$ 230,000 150,000 166,500 166,500 166,500 166,500 166,500 167,500 167,500 52,804 47,474 66,460 60,733 51,002 43,229 35,337 27,426 16,028 - - - - - - - - - - - - - - - - - - 406,701 326,326 366,967 366,600 362,444 360,469 358,606 357,966 353,090 1,369,699 1,857,699 1,369,699 1,569,699 1,369,699 1,379,699 1,379,699 1,727,699 - 1,369,699 1,857,699 1,369,699 1,569,699 1,369,699 1,379,699 1,379,699 1,727,699 - (962,998) (1,531,372) (1,002,732) (1,203,099) (1,007,255) (1,019,230) (1,021,093) (1,369,733) 353,090 - - - - - - - - - 230,000 3,230,000 230,000 230,000 230,000 230,000 230,000 230,000 230,000 200,000 200,000 200,000 - - - - - - - - - - - - - - - - - - - - - - - - 430,000 3,430,000 430,000 230,000 230,000 230,000 230,000 230,000 230,000 (532,998) 1,898,628 (572,732) (973,099) (777,255) (789,230) (791,093) (1,139,733) 583,090 5,280,353 4,747,355 6,645,982 6,073,251 5,100,152 4,322,897 3,533,667 2,742,574 1,602,841 4,747,355$ 6,645,982$ 6,073,251$ 5,100,152$ 4,322,897$ 3,533,667$ 2,742,574$ 1,602,841$ 2,185,931$ Capital Project Fund Projected Activity 25 City of Crystal, Minnesota Capital Improvement Plan - Police Equipment Revolving Fund 235 Schedule of Planned Capital Outlay 2020 to 2031 2020 2021 2022 Business Unit Year to Budgeted Proposed Proposed Department Object Code Subledger Replace Item Cost Amounts Amounts Amounts Police 3500.6930 N/A 2020 2016 Ford Interceptor Utility (SUV)50,000$ 50,000$ -$ -$ Police 3500.6930 N/A 2020 2016 Ford Interceptor utility 50,000 50,000 - - Police 3500.6930 N/A 2020 2016 Ford Interceptor Utility 50,000 50,000 - - Police 3500.6930 N/A 2020 Mobile data tablets ($5,000 each)15,000 15,000 - - Police 3500.6930 N/A 2020 Rifle replacement /Replace Sniper Rifle 16,500 16,500 - - Police 3500.6930 N/A 2020 Bulletproof vests - mass replacement ($1,000 a piece)15,000 15,000 - - Police 3500.6930 N/A 2020 Tactical vests ($3,600 each)7,200 7,200 - - Police 3500.6931 N/A 2020 2020 Dodge Durango Investigations 40,000 40,000 - - Police 3500.6930 N/A 2021 2017 Ford Interceptor Utility (SUV)52,000 - 52,000 - Police 3500.6930 N/A 2021 2017 Ford Interceptor Utility 52,000 - 52,000 - Police 3500.6930 N/A 2021 2021 Ford Interceptor Utility, New K9 Ford Interc.52,000 - 52,000 - Police 3500.6930 N/A 2021 Mobile data tablets ($5,000 each)15,000 - 15,000 - Police 3500.6930 N/A 2021 Mobile radar/lidar replacement ($4,000-5,000 each)8,000 - 8,000 - Police 3500.6930 N/A 2021 In-squad digital video equipment ($6,000 each)18,000 - 18,000 - Police 3500.6930 N/A 2021 Bulletproof vests - mass replacement ($1,000 a piece)10,000 - 10,000 - Police 3500.6930 N/A 2021 Tactical vests ($3,600 each)7,200 - 7,200 - Police 3500.6930 N/A 2021 SWAT Gas Masks (7) @$1,000 a piece 7,000 - 7,000 - Police 3500.6930 N/A 2021 SWAT Helmets (7) @$1,000 a piece 7,000 - 7,000 - Police 3500.6930 N/A 2021 Body cameras 28,000 - 28,000 - Police 3500.6930 N/A 2022 2015 Ford Interceptor Utility, silver unmarked 52,000 - - 52,000 Police 3500.6930 N/A 2022 2018 Ford Interceptor Utility 52,000 - - 52,000 Police 3500.6930 N/A 2022 2018 Ford Interceptor Utility 52,000 - - 52,000 Police 3500.6930 N/A 2022 2018 Ford Interceptor Utility 52,000 - - 52,000 Police 3500.6930 N/A 2022 Mobile data tablets ($5,000 each)20,000 - - 20,000 Police 3500.6930 N/A 2022 In-squad digital video equipment ($6,000 each)24,000 - - 24,000 Police 3500.6930 N/A 2022 Bulletproof vests - mass replacement ($1,000 a piece)6,000 - - 6,000 Police 3500.6930 N/A 2022 Tactical vests ($3,600 each)7,200 - - 7,200 Police 3500.6930 N/A 2022 Upgrade FATS 30,000 - - 30,000 Police 3500.6930 N/A 2022 Upgrade Cellbrite 15,000 - - 15,000 Police 3500.6930 N/A 2023 2012 Dodge Journey 45,000 - - - Police 3500.6930 N/A 2023 2015 Ford F150 crew cab 52,000 - - - Police 3500.6930 N/A 2023 2011 Buick Sedan 40,000 - - - Police 3500.6930 N/A 2023 2010 Ford Crown Victoria 52,000 - - - Police 3500.6930 N/A 2023 2013 Ford Interceptor Sedan 7,500 - - - Police 3500.6930 N/A 2023 Mobile data tablets ($5,000 each)10,000 - - - Police 3500.6930 N/A 2023 In-squad digital video equipment ($6,000 each)12,000 - - - Police 3500.6930 N/A 2023 Bulletproof vests - mass replacement ($1,000 a piece)4,000 - - - Police 3500.6930 N/A 2023 Tactical vests ($3,600 each)7,200 - - - Police 3500.693 N/A 2024 SWAT Robot 15,000 - - - Police 3500.6930 N/A 2024 2016 Ford Interceptor Utility (SUV)55,000 - - - Police 3500.6930 N/A 2024 2016 Ford Interceptor utility 55,000 - - - Police 3500.6930 N/A 2009 Chevy Impala 40,000 - - - 26 2023 2024 2025 2026 2027 2028 2029 2030 2031 Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated Amounts Amounts Amounts Amounts Amounts Amounts Amounts Amounts Amounts -$ -$ -$ -$ -$ -$ -$ -$ -$ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 45,000 - - - - - - - - 52,000 - - - - - - - - 40,000 - - - - - - - - 52,000 - - - - - - - - 7,500 - - - - - - - - 10,000 - - - - - - - - 12,000 - - - - - - - - 4,000 - - - - - - - - 7,200 - - - - - - - - - 15,000 - - - - - - - - 55,000 - - - - - - - - 55,000 - - - - - - - - - - - - - - - - 27 City of Crystal, Minnesota Capital Improvement Plan - Police Equipment Revolving Fund 235 Schedule of Planned Capital Outlay 2020 to 2031 (Continued) 2020 2021 2022 Year to Year to Budgeted Proposed Proposed Department Replace Subledger Replace Item Cost Amounts Amounts Amounts Police 3500.6930 N/A 2024 2016 Ford Interceptor Utility 55,000$ -$ -$ -$ Police 3500.6930 N/A 2024 Mobile data tablets ($5,000 each)15,000 - - - Police 3500.6930 N/A 2024 In-squad digital video equipment ($6,000 each)18,000 - - - Police 3500.6930 N/A 2024 Body cameras 30,000 - - - Police 3500.6930 N/A 2024 Tactical vests ($3,600 each)7,200 - - - Police 3500.6930 N/A 2025 2017 Ford Interceptor Utility (SUV)65,000 - - - Police 3500.6930 N/A 2025 2017 Ford Interceptor Utility 55,000 - - - Police 3500.6930 N/A 2025 2015 Chevrolet Equinox 40,000 - - - Police 3500.6930 N/A 2025 2017 Ford Interceptor Utility 55,000 - - - Police 3500.6930 N/A 2025 2015 Ford Interceptor utility, dark blue unmarked 40,000 - - - Police 3500.6930 N/A 2025 2010 Ford Crown Victoria 55,000 - - - Police 3500.6930 N/A 2025 Mobile data tablets ($5,000 each)20,000 - - - Police 3500.6930 N/A 2025 Tactical vests ($3,600 each)7,200 - - - Police 3500.6930 N/A 2026 2018 Ford Interceptor Utility 55,000 - - - Police 3500.6930 N/A 2026 2020 Ford Interceptor Utility 40,000 - - - Police 3500.6930 N/A 2026 2018 Ford Interceptor Utility 55,000 - - - Police 3500.6930 N/A 2026 2018 Ford Interceptor Utility 55,000 - - - Police 3500.6930 N/A 2026 1999 Ford ambulance 150,000 - - - Police 3500.6930 N/A 2026 Mobile data tablets ($5,000 each)15,000 - - - Police 3500.6930 N/A 2026 Tactical vests ($3,600 each)7,200 - - - Police 3500.6930 N/A 2026 SWAT Pole Cam 35,000 - - - Police 3500.6930 N/A 2027 2014 Ford Interceptor utility 40,000 - - - Police 3500.6930 N/A 2027 2015 Ford F150 crew cab 55,000 - - - Police 3500.6930 N/A 2027 2010 Ford Crown Victoria 55,000 - - - Police 3500.6930 N/A 2027 2015 Ford Interceptor Utility, silver unmarked 55,000 - - - Police 3500.6930 N/A 2027 Mobile data tablets ($5,000 each)5,000 - - - Police 3500.6930 N/A 2027 Mobile radar/lidar replacement ($4,000-5,000 each)10,000 - - - Police 3500.6930 N/A 2027 In-squad digital video equipment ($6,000 each)6,000 - - - Police 3500.6930 N/A 2027 Tactical vests ($3,600 each)7,200 - - - Police 3500.6930 N/A 2027 SWAT Gas Launcher 6,000 - - - Police 3500.6930 N/A 2028 2016 Ford Interceptor Utility (SUV)60,000 - - - Police 3500.6930 N/A 2028 2016 Ford Interceptor utility 60,000 - - - Police 3500.6930 N/A 2028 2016 Ford Interceptor Utility 60,000 - - - Police 3500.6930 N/A 2028 Mobile radios ($5,000 each)75,000 - - - Police 3500.6930 N/A 2028 Mobile data tablets ($5,000 each)15,000 - - - Police 3500.6930 N/A 2028 Mobile radar/lidar replacement ($4,000-5,000 each)15,000 - - - Police 3500.6930 N/A 2028 In-squad digital video equipment ($6,000 each)18,000 - - - Police 3500.6930 N/A 2028 Portable radios ($3,000 each)150,000 - - - Police 3500.6930 N/A 2028 Tactical vests ($3,600 each)7,200 - - - Police 3500.6930 N/A 2029 2017 Ford Interceptor Utility (SUV)70,000 - - - Police 3500.6930 N/A 2029 2017 Ford Interceptor Utility 60,000 - - - Police 3500.6930 N/A 2029 2017 Ford Interceptor Utility 60,000 - - - Police 3500.6930 N/A 2029 2019 Ford Escape 40,000 - - - Police 3500.6930 N/A 2029 2010 Ford Crown Victoria 60,000 - - - Police 3500.6930 N/A 2029 Mobile data tablets ($5,000 each)20,000 - - - Police 3500.6930 N/A 2029 In-squad digital video equipment ($6,000 each)24,000 - - - Police 3500.6930 N/A 2029 Handgun Replacement 55,000 - - - Police 3500.6930 N/A 2029 Rifle replacement /Replace Sniper Rifle 30,000 - - - Police 3500.6930 N/A 2029 Tactical vests ($3,600 each)7,200 - - - Police 3500.6930 N/A 2029 Police Bicycles (3)6,000 - - - Police 3500.6930 N/A 2030 Estimate based on average 309,375 - - - NOTE: Grey area needs updating for leasing vs. purchase (projected expenditures reflect leasing)243,700$ 256,200$ 310,200$ 28 2023 2024 2025 2026 2027 2028 2029 2030 2031 Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated Amounts Amounts Amounts Amounts Amounts Amounts Amounts Amounts Amounts -$ 55,000$ -$ -$ -$ -$ -$ -$ -$ - 15,000 - - - - - - - - 18,000 - - - - - - - - 30,000 - - - - - - - - 7,200 - - - - - - - - - 65,000 - - - - - - - - 55,000 - - - - - - - - 40,000 - - - - - - - - 55,000 - - - - - - - - 40,000 - - - - - - - - 55,000 - - - - - - - - 20,000 - - - - - - - - 7,200 - - - - - - - - - 55,000 - - - - - - - - 40,000 - - - - - - - - 55,000 - - - - - - - - 55,000 - - - - - - - - 150,000 - - - - - - - - 15,000 - - - - - - - - 7,200 - - - - - - - - 35,000 - - - - - - - - - 40,000 - - - - - - - - 55,000 - - - - - - - - 55,000 - - - - - - - - 55,000 - - - - - - - - 5,000 - - - - - - - - 10,000 - - - - - - - - 6,000 - - - - - - - - 7,200 - - - - - - - - 6,000 - - - - - - - - - 60,000 - - - - - - - - 60,000 - - - - - - - - 60,000 - - - - - - - - 75,000 - - - - - - - - 15,000 - - - - - - - - 15,000 - - - - - - - - 18,000 - - - - - - - - 150,000 - - - - - - - - 7,200 - - - - - - - - - 70,000 - - - - - - - - 60,000 - - - - - - - - 60,000 - - - - - - - - 40,000 - - - - - - - - 60,000 - - - - - - - - 20,000 - - - - - - - - 24,000 - - - - - - - - 55,000 - - - - - - - - 30,000 - - - - - - - - 7,200 - - - - - - - - 6,000 - - - - - - - - - 309,375 - 229,700$ 250,200$ 337,200$ 412,200$ 239,200$ 460,200$ 432,200$ 309,375$ -$ 29 City of Crystal, Minnesota Capital Improvement Plan - Police Equipment Revolving Fund 235 Schedule of Projected Revenue, Expenditures and Debt 2020 2021 2022 Actual Adopted Proposed Revenues Property taxes 154,938$ 158,037$ 158,037$ Additional levy to balance - - - Interest on investments 110,668 20,000 20,000 Miscellaneous - 15,000 Intergovernmental 2,339 - - Total Revenues 267,945 193,037 178,037 Expenditures Capital outlay Public safety 443,534 256,200 200,556 Total Expenditures 443,534 256,200 200,556 Excess (Deficiency) of Revenues Over (Under) Expenditures (175,589) (63,163) (22,519) Other Financing Sources Transfer in - - - Bond proceeds - - - Internal Loan to Building Fund - (1,200,000) - Internal Loan repayment - - - Sale of Fixed Asset 27,030 15,000 15,000 Transfers out - - - Total Other Financing Sources 27,030 (1,185,000) 15,000 Net Change in Fund Balances (148,559) (1,248,163) (7,519) Unrestricted Cash Balance - (159,626) (1,409,789) Assigned Cash Balance 2,915,448 2,938,279 2,940,279 Cash Balance, January 1 2,915,448 2,778,653 1,530,490 Unrestricted Cash Balance (159,626) (1,409,789) (1,419,308) Assigned Cash Balance 2,938,279 2,940,279 2,942,279 Cash Balances, December 31 2,778,653$ 1,530,490$ 1,522,971$ Capital Project Fund Projected Activity 30 2023 2024 2025 2026 2027 2028 2029 2030 2031 Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated 158,037$ 158,037$ 158,037$ 158,037$ 158,037$ 158,037$ 158,037$ 158,037$ 158,037$ 10,000 20,000 30,000 40,000 50,000 60,000 70,000 80,000 90,000 15,230 3,414 2,427 4,030 4,399 4,872 11,400 17,492 20,446 - - - - - - - - - 183,266 181,451 190,464 202,067 212,436 222,909 239,436 255,529 268,483 229,788 295,164 295,164 295,164 295,164 295,164 295,164 295,134 295,134 229,788 295,164 295,164 295,164 295,164 295,164 295,164 295,134 295,134 (46,522) (113,713) (104,700) (93,097) (82,728) (72,255) (55,728) (39,605) (26,651) - - - - - - - - - - - - - - - - - - (1,150,000) - - - - - - - - - - 250,000 115,000 115,000 710,000 650,000 320,000 190,000 15,000 15,000 15,000 15,000 15,000 15,000 15,000 15,000 15,000 - - - - - - - - - (1,135,000) 15,000 265,000 130,000 130,000 725,000 665,000 335,000 205,000 (1,181,522) (98,713) 160,300 36,903 47,272 652,745 609,272 295,395 178,349 (1,419,308) (2,602,353) (2,701,407) (2,541,350) (2,504,850) (2,458,017) (1,805,760) (1,197,627) (903,981) 2,942,279 2,943,802 2,944,143 2,944,386 2,944,789 2,945,229 2,945,716 2,946,856 2,948,606 1,522,971 341,449 242,736 403,037 439,940 487,212 1,139,957 1,749,229 2,044,624 (2,602,353) (2,701,407) (2,541,350) (2,504,850) (2,458,017) (1,805,760) (1,197,627) (903,981) (727,677) 2,943,802 2,944,143 2,944,386 2,944,789 2,945,229 2,945,716 2,946,856 2,948,606 2,950,650 341,449$ 242,736$ 403,037$ 439,940$ 487,212$ 1,139,957$ 1,749,229$ 2,044,624$ 2,222,973$ Capital Project Fund Projected Activity 31 City of Crystal, Minnesota Capital Improvement Plan - Park Improvements 420 Schedule of Planned Capital Outlay 2020 to 2031 2020 2021 2022 Business Year to Budgeted Proposed Proposed Department Object Code Subledger Replace Item Cost Amounts Amounts Amounts Recreation 0420.6937 TBA 2020 New Park Name Signage 10,000$ 10,000$ -$ -$ Recreation 0420.6937 TBA 2020 ALL Pavement (Parking @ Trails)25,000 25,000 - - Recreation 0420.6937 TBA 2020 NP Fair Play Area (1999)125,000 125,000 - - Recreation 0420.6937 TBA 2020 Hockey Rink - North Lions 100,000 100,000 - - Recreation 0420.6937 TBA 2021 New Park Name Signage 10,000 - 10,000 - Recreation 0420.6937 TBA 2021 ALL Pavement (Sidewalks @ Trails)50,000 - 50,000 - Recreation 0420.6937 TBA 2021 Large Play Area - Valley Place (2001)325,000 - 325,000 - Recreation 0420.6937 TBA 2021 NP Yunkers (2001)175,000 - 175,000 - Recreation 0420.6937 TBA 2021 Picnic Shelter - Bass Lake 70,000 - 70,000 - Recreation 0420.6937 TBA 2021 NP Basketball Court - Yunkers 10,000 - 10,000 - Recreation 0420.6937 TBA 2021 NP Basketball Court - Bass Lake 10,000 - 10,000 - Recreation 0420.6937 TBA 2022 New Park Name Signage 10,000 - - 10,000 Recreation 0420.6937 TBA 2022 ALL Pavement (Sidewalks @ Trails)50,000 - - 50,000 Recreation 0420.6937 TBA 2022 CP Dog Park - Bassett Creek 100,000 - - 100,000 Recreation 0420.6937 TBA 2022 Parking Lot at Basset Creek Dog Park 300,000 - - 300,000 Recreation 0420.6937 TBA 2022 Soccer Field - Fair School Park 50,000 - - 50,000 Recreation 0420.6937 TBA 2022 Becker Tennis Court Lights/Surfacing 200,000 - - 200,000 Recreation 0420.6937 TBA 2022 Ped Bridge - Bassett Creek 100,000 - - 100,000 Recreation 0420.6937 TBA 2023 Large Play Area - Welcome (1997)325,000 - - - Recreation 0420.6937 TBA 2023 New Park Name Signage 10,000 - - - Recreation 0420.6937 TBA 2023 ALL Pavement (Sidewalks @ Trails)50,000 - - - Recreation 0420.6937 TBA 2023 NP Basketball Court - Broadway 10,000 - - - Recreation 0420.6937 TBA 2023 BP Basketball Court - Crystal Highlands 10,000 - - - Recreation 0420.6937 TBA 2023 Picnic Shelter - Broadway 70,000 - - - Recreation 0420.6937 TBA 2023 Play Area - Broadway (1999)175,000 - - - Recreation 0420.6937 TBA 2023 Valley Place Tennis Court Lights/Surfacing 200,000 - - - Recreation 0420.6937 TBA 2023 Picnic Shelter - Crystal Highlands 70,000 - - - Recreation 0420.6937 TBA 2023 Parking Lot - Valley Place Park (Near Play Area)390,000 - - - Recreation 0420.6937 TBA 2024 ALL Pavement (Sidewalks @ Trails)50,000 - - - Recreation 0420.6937 TBA 2024 New Park Name Signage 10,000 - - - Recreation 0420.6937 TBA 2024 Community Park Building - Bassett Creek 1,350,000 - - - Recreation 0420.6937 TBA 2024 Fiber & Technology at Basset Creek Park Building 50,000 - - - Recreation 0420.6937 TBA 2024 Disc Gold Course - Bassett Creek Park 150,000 - - - Recreation 0420.6937 TBA 2025 Parking Lot at Basset Creek Building 525,000 - - - Recreation 0420.6937 TBA 2025 ALL Pavement (Sidewalks @ Trails)50,000 - - - Recreation 0420.6937 TBA 2025 Play Area - Sunnyview (2000)175,000 - - - Recreation 0420.6937 TBA 2025 Picnic Shelter - Cavanagh 75,000 - - - Recreation 0420.6937 TBA 2025 Soccer Field - Bassett Creek 530,000 - - - Recreation 0420.6937 TBA 2025 Maintenance Binder - Play Area PIP Surfacing - Becker & Fair 30,000 - - - Recreation 0420.6937 TBA 2025 Play Area - Cavanaugh (2001)175,000 - - - Recreation 0420.6937 TBA 2026 ALL Pavement (Sidewalks @ Trails)50,000 - - - Recreation 0420.6937 TBA 2026 Play Area - Lee (2000)175,000 - - - Recreation 0420.6937 TBA 2026 Picnic Shelter - Lee 75,000 - - - Recreation 0420.6937 TBA 2026 Med. Shelter - Valley Place 150,000 - - - Recreation 0420.6937 TBA 2026 Sm. Picnic Shelter - Twin Oak 75,000 - - - Recreation 0420.6937 TBA 2027 Med. Shelter - North Lions 150,000 - - - Recreation 0420.6937 TBA 2027 Play Area - Twin Oak (2003)175,000 - - - Recreation 0420.6937 TBA 2027 ALL Pavement (Sidewalks @ Trails)50,000 - - - Recreation 0420.6937 TBA 2027 Large Play Area - North Lions (2006)325,000 - - - Recreation 0420.6937 TBA 2027 Play Area - Iron Horse (2004)175,000 - - - Recreation 0420.6937 TBA 2028 Park Building - Welcome 1,400,000 - - - Recreation 0420.6937 TBA 2028 ALL Pavement (Sidewalks @ Trails)50,000 - - - Recreation 0420.6937 TBA 2028 Med. Shelter - Welcome 160,000 - - - Recreation 0420.6937 TBA 2028 Fiber & Technology at Welcome Park Building 50,000 - - - Recreation 0420.6937 TBA 2029 Parking Lot at Welcome Park Building 325,000 - - - Recreation 0420.6937 TBA 2029 Med. Shelter - Bassett Creek (lake)175,000 - - - Recreation 0420.6937 TBA 2029 ALL Pavement (Sidewalks @ Trails)50,000 - - - Recreation 0420.6937 TBA 2029 Play Area - Bass Lake (2004)175,000 - - - Recreation 0420.6937 TBA 2030 ALL Pavement (Sidewalks @ Trails)50,000 - - - Recreation 0420.6937 TBA 2030 Fiber & Technology at North Lions Building 50,000 - - - Recreation 0420.6937 TBA 2030 Park Building - North Lions 1,450,000 - - - Recreation 0420.6937 TBA 2030 Replace Play Area PIP Surfacing - Becker 125,000 - - - Recreation 0420.6937 TBA 2030 Replace Play Area Structure Sun Sails - Becker 12,000 - - - Recreation 0420.6937 TBA 2030 Replace Patio Sun Sails - Becker 25,000 - - - Recreation 0420.6937 TBA 2030 Replace Play Area PIP Surfacing - FAIR School 50,000 - - - Recreation 0420.6937 TBA 2031 CP Soccer Field - North Lions 530,000 - - - Recreation 0420.6937 TBA 2031 ALL Pavement (Sidewalks @ Trails)50,000 - - - Recreation 0420.6937 TBA 2031 Med. Shelter - Becker 115,000 - - - Recreation 0420.6937 TBA 2031 Play Area - Forest (2005)175,000 - - - Recreation 0420.6937 TBA 2031 Replace Play Area PIP Surfacing - Valley Place & Yunkers 35,000 - - - Recreation 0420.6937 TBA 2031 Parking Lot at North Lions Park Building 350,000 - - - Recreation 0420.6937 TBA 2031 Play Area - Crystal Highlands (2007)175,000 - - - Recreation 0420.6937 TBA 2032 ALL Pavement (Sidewalks @ Trails)60,000 - - - Recreation 0420.6937 TBA 2032 Play Area - Grogan Park (2008)185,000 - - - Recreation 0420.6937 TBA 2032 Play Area - Skyway Park (2008)185,000 - - - Recreation 0420.6937 TBA 2032 Play Area - Kentucky Park (2010)185,000 - - - Recreation 0420.6937 TBA 2032 Picnic Shelter - Skywalk Park 80,000 - - - Recreation 0420.6937 TBA 2032 Medium Shelter - Bassett Creek (woods)190,000 - - - Recreation 0420.6937 TBA 2032 Medium Shelter - North Lions (picnic area)190,000 - - - Recreation 0420.6937 TBA 2032 Building - Becker 1,650,000 - - - 260,000$ 650,000$ 810,000$ 32 2023 2024 2025 2026 2027 2028 2029 2030 2031 Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated Amounts Amounts Amounts Amounts Amounts Amounts Amounts Amounts Amounts -$ -$ -$ -$ -$ -$ -$ -$ -$ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 325,000 - - - - - - - - 10,000 - - - - - - - - 50,000 - - - - - - - - 10,000 - - - - - - - - 10,000 - - - - - - - - 70,000 - - - - - - - - 175,000 - - - - - - - - 200,000 - - - - - - - - 70,000 - - - - - - - - 390,000 - - - - - - - - - 50,000 - - - - - - - - 10,000 - - - - - - - - 1,350,000 - - - - - - - - 50,000 - - - - - - - - 150,000 - - - - - - - - - 525,000 - - - - - - - - 50,000 - - - - - - - - 175,000 - - - - - - - - 75,000 - - - - - - - - 530,000 - - - - - - - - 30,000 - - - - - - - - 175,000 - - - - - - - - - 50,000 - - - - - - - - 175,000 - - - - - - - - 75,000 - - - - - - - - 150,000 - - - - - - - - 75,000 - - - - - - - - - 150,000 - - - - - - - - 175,000 - - - - - - - - 50,000 - - - - - - - - 325,000 - - - - - - - - 175,000 - - - - - - - - - 1,400,000 - - - - - - - - 50,000 - - - - - - - - 160,000 - - - - - - - - 50,000 - - - - - - - - - 325,000 - - - - - - - - 175,000 - - - - - - - - 50,000 - - - - - - - - 175,000 - - - - - - - - - 50,000 - - - - - - - - 50,000 - - - - - - - - 1,450,000 - - - - - - - - 125,000 - - - - - - - - 12,000 - - - - - - - - 25,000 - - - - - - - - 50,000 - - - - - - - - - 530,000 - - - - - - - - 50,000 - - - - - - - - 115,000 - - - - - - - - 175,000 - - - - - - - - 35,000 - - - - - - - - 350,000 - - - - - - - - 175,000 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 1,310,000$ 1,610,000$ 1,560,000$ 525,000$ 875,000$ 1,660,000$ 725,000$ 1,762,000$ 1,430,000$ 33 City of Crystal, Minnesota Capital Improvement Plan - Park Improvements 420 Schedule of Projected Revenue, Expenditures and Debt 2020 2021 2022 Actual Adopted Proposed Revenues Property taxes (1% overall levy increase, annually, beginning in 2020)359,138$ 480,511$ 606,999$ Interest on investments 57,118 13,000 13,000 Intergovernmental revenue (HCYSPG grants)200,617 - - Miscellaneous 14,432 24,000 - Total Revenues 631,305 517,511 619,999 Expenditures Capital outlay Difference from budget doc in Capital Acquisition Recreation 663,473 650,000 810,000 Total Expenditures 663,473 650,000 810,000 Excess (Deficiency) of Revenues Over (Under) Expenditures (32,168) (132,489) (190,001) Other Financing Sources (Uses) Transfers in Internal Loan to Building (450,000) Internal Loan repayment from Building EDA - - - PIR - - - Sale of fixed assets - - - Transfers out - - - Total Other Financing Sources - - (450,000) Net Change in Fund Balances (32,168) (132,489) (640,001) Cash Balances, January 1 1,405,831 1,373,663 1,241,174 Cash Balances, December 31 1,373,663$ 1,241,174$ 601,173$ Capital Project Fund Projected Activity 34 2023 2024 2025 2026 2027 2028 2029 2030 2031 Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated 741,026$ 882,657$ 1,032,322$ 1,190,432$ 1,358,712$ 1,533,746$ 1,719,866$ 1,916,290$ 2,123,542$ 6,012 382 (6,888) (12,233) (5,701) (921) (2,193) 10,734 13,884 - - - - - - - - - - - - - - - - - - 747,038 883,039 1,025,435 1,178,199 1,353,011 1,532,825 1,717,673 1,927,023 2,137,426 1,310,000 1,610,000 1,560,000 525,000 875,000 1,660,000 725,000 1,762,000 1,430,000 1,310,000 1,610,000 1,560,000 525,000 875,000 1,660,000 725,000 1,762,000 1,430,000 (562,962) (726,961) (534,565) 653,199 478,011 (127,175) 992,673 165,023 707,426 - - - - - - 300,000 150,000 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 300,000 150,000 - (562,962) (726,961) (534,565) 653,199 478,011 (127,175) 1,292,673 315,023 707,426 601,173 38,211 (688,750) (1,223,316) (570,117) (92,106) (219,281) 1,073,392 1,388,415 38,211$ (688,750)$ (1,223,316)$ (570,117)$ (92,106)$ (219,281)$ 1,073,392$ 1,388,415$ 2,095,841$ Capital Project Fund Projected Activity 35 City of Crystal, Minnesota Capital Improvement Plan - Water Fund 505 Schedule of Planned Capital Outlay 2020 to 2031 2020 2021 2022 Business Unit Year to Budgeted Proposed Proposed Department Object Code Subledger Replace Item Cost Amounts Amounts Amounts Water 0090.6935 TBA 2020 6207 - Upgrade Sensus meter software 30,000$ 30,000$ -$ -$ Water 0090.6935 TBA 2020 Utility Reconstruction 600,000 600,000 - - Water 0090.6935 TBA 2021 6235 -Gate Valve and Hydrant replacement 75,000 - 75,000 - Water 0090.6935 TBA 2021 Utility Reconstruction 600,000 - 600,000 - Water 0090.6935 TBA 2022 Utility Reconstruction 1,100,000 - - 1,100,000 Water 0090.6935 TBA 2023 6235 -Gate Valve and Hydrant replacement 75,000 - - - Water 0090.6935 TBA 2023 Utility Reconstruction 1,000,000 - - - Water 0090.6935 TBA 2024 Utility Reconstruction 1,500,000 - - - Water 0090.6935 TBA 2024 6235 -Gate Valve and Hydrant replacement 75,000 - - - Water 0090.6935 TBA 2025 Utility Reconstruction 1,500,000 - - - Water 0090.6935 TBA 2025 6235 -Gate Valve and Hydrant replacement 30,000 - - - Water 0090.6935 TBA 2026 Utility Reconstruction 1,500,000 - - - Water 0090.6935 TBA 2026 6235 -Gate Valve and Hydrant replacement 75,000 - - - Water 0090.6935 TBA 2027 Utility Reconstruction 1,600,000 - - - Water 0090.6935 TBA 2027 6235 -Gate Valve and Hydrant replacement 30,000 - - - Water 0090.6935 TBA 2028 Utility Reconstruction 1,750,000 - - - Water 0090.6935 TBA 2028 6235 -Gate Valve and Hydrant replacement 75,000 - - - Water 0090.6935 TBA 2029 Utility Reconstruction 1,850,000 - - - Water 0090.6935 TBA 2029 6235 -Gate Valve and Hydrant replacement 30,000 - - - Water 0090.6935 TBA 2030 Utility Reconstruction 2,000,000 - - - Water 0090.6935 TBA 2030 6235 -Gate Valve and Hydrant replacement 75,000 - - - Water 0090.6935 TBA 2031 Utility Reconstruction 1,300,000 - - - Water 0090.6935 TBA 2031 Gate Value and Hydrant Replacement 75,000 - - - Water 0090.6935 TBA 2032 Utility Reconstruction 1,200,000 - - - Water 0090.6935 TBA 2032 Gate Value and Hydrant Replacement 75,000 - - - 630,000$ 675,000$ 1,100,000$ 36 2023 2024 2025 2026 2027 2028 2029 2030 2031 Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated Amounts Amounts Amounts Amounts Amounts Amounts Amounts Amounts Amounts -$ -$ -$ -$ -$ -$ -$ -$ -$ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 75,000 - - - - - - - - 1,000,000 - - - - - - - - - 1,500,000 - - - - - - - - 75,000 - - - - - - - - - 1,500,000 - - - - - - - - 30,000 - - - - - - - - - 1,500,000 - - - - - - - - 75,000 - - - - - - - - - 1,600,000 - - - - - - - - 30,000 - - - - - - - - - 1,750,000 - - - - - - - - 75,000 - - - - - - - - - 1,850,000 - - - - - - - - 30,000 - - - - - - - - - 2,000,000 - - - - - - - - 75,000 - - - - - - - - - 1,300,000 - - - - - - - - 75,000 - - - - - - - - - - - - - - - - - - 1,075,000$ 1,575,000$ 1,530,000$ 1,575,000$ 1,630,000$ 1,825,000$ 1,880,000$ 2,075,000$ 1,375,000$ 37 City of Crystal, Minnesota Capital Improvement Plan - Water Fund 505 Statement of Cash Flows 2020 2021 2022 Actual Adopted Proposed Cash Flows from Operating Activities Receipts from customers and users based on utility rate analysis)3,623,424$ 4,769,442$ 5,195,116$ Payments to suppliers (based on utility rate analysis)(2,644,949) (3,046,935) (3,138,343) Payments to employees (based on utility rate analysis)(405,374) (398,702) (411,334) Net Cash Provided (Used) by Operating Activities 573,101 1,323,805 1,645,439 Cash Flows from Noncapital Financing Activities Transfers to other funds (198,427) (200,621) (211,367) Net Cash Provided (Used) by Noncapital Financing Activities (198,427) (200,621) (211,367) Cash Flows from Capital and Related Financing Activities Infrastructure improvements (547,321) (675,000) (1,100,000) Contribution to internal service funds (123,887) (126,768) Intergovernmental (Joint Water Commission)- .- Interest expense (6,000) (7,200) (7,200) Advance to/(from) building fund Advances to/(from) other funds (60,000) (60,000) (60,000) Net Cash Provided (Used) by Capital and Related Financing Activities (613,321) (866,087) (1,293,968) Cash Flows from Investing Activities Investment earnings 65,998 15,000 15,000 Net Increase (Decrease) in Cash and Cash Equivalents (172,649) 272,097 155,104 Cash and Cash Equivalents, January 1 1,710,206 1,537,557 1,809,654 Cash and Cash Equivalents, December 31 1,537,557$ 1,809,654$ 1,964,758$ New projected rates Average quarterly bill (9,000 gallons)77.62$ 86.16$ 93.91$ Average quarterly dollar increase 8.93$ 8.54$ 7.75$ Average annual dollar increase 35.72$ 34.15$ 31.02$ Enterprise Fund Projected Activity 38 2023 2024 2025 2026 2027 2028 2029 2030 2031 Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated 5,369,944$ 5,653,634$ 5,838,893$ 6,030,178$ 6,227,686$ 6,539,070$ 6,866,024$ 7,209,325$ 7,569,791$ (3,232,494) (3,329,468) (3,429,352) (3,532,233) (3,638,200) (3,747,346) (3,859,766) (3,975,559) (4,094,826) (482,400) (506,520) (531,846) (558,438) (586,360) (615,678) (646,462) (678,785) (712,724) 1,655,050 1,817,646 1,877,695 1,939,507 2,003,126 2,176,046 2,359,796 2,554,981 2,762,241 (231,778) (231,778) (231,778) (231,778) (231,778) (231,778) (231,778) (231,778) (231,778) (231,778) (231,778) (231,778) (231,778) (231,778) (231,778) (231,778) (231,778) (231,778) (1,075,000) (1,575,000) (1,530,000) (1,575,000) (1,630,000) (1,825,000) (1,880,000) (2,075,000) (1,375,000) (180,433) (178,981) (179,860) (177,399) (162,211) (146,088) (138,835) (135,017) (135,017) - - - - - - - - - (3,029) (3,029) (3,029) (3,029) (3,029) (3,029) (3,029) (3,029) (3,029) (1,500,000) - - 250,000 250,000 250,000 250,000 250,000 250,000 (60,000) (60,000) - - - - - - - (2,818,462) (1,817,010) (1,712,889) (1,505,428) (1,545,240) (1,724,117) (1,771,864) (1,963,046) (1,263,046) 19,648 5,892 3,640 3,006 5,059 7,371 9,646 13,304 17,039 (1,375,542) (225,250) (63,332) 205,308 231,168 227,523 365,800 373,461 1,284,456 1,964,758 589,216 363,966 300,634 505,941 737,109 964,631 1,330,432 1,703,893 589,216$ 363,966$ 300,634$ 505,941$ 737,109$ 964,631$ 1,330,432$ 1,703,893$ 2,988,349$ 100.49$ 105.51$ 108.68$ 111.94$ 115.29$ 118.75$ 122.31$ 125.98$ 125.98$ 6.57$ 5.02$ 3.17$ 3.26$ 3.36$ 2.74$ 2.74$ 2.74$ 2.74$ 26.30$ 20.10$ 12.66$ 13.04$ 13.43$ 10.94$ 10.94$ 10.94$ 10.94$ Enterprise Fund Projected Activity 39 City of Crystal, Minnesota Capital Improvement Plan - Sanitary Sewer Fund 510 Schedule of Planned Capital Outlay 2020 to 2031 2020 2021 2022 Business Unit Year to Budgeted Proposed Proposed Department Object Code Subledger Replace Item Cost Amounts Amounts Amounts Sewer 0092.6935 TBA 2020 Install Pad mount Generator at West Lift Station 85,000$ 85,000$ -$ -$ Sewer 0092.6935 TBA 2020 Utility Reconstruction 1,200,000 1,200,000 - - Sewer 0092.6935 TBA 2021 Utility Reconstruction 400,000 - 400,000 - Sewer 0092.6935 TBA 2021 Sanitary sewer lining (non-recon area)150,000 - 150,000 - Sewer 0092.6935 TBA 2021 Fiber to lift stations 100,000 - 100,000 - Sewer 0092.6935 TBA 2022 Equipment Replacement - South Lift Building/Generator and Pump #2 350,000 - - 350,000 Sewer 0092.6935 TBA 2022 Utility Reconstruction 250,000 - - 250,000 Sewer 0092.6935 TBA 2023 Utility Reconstruction 800,000 - - - Sewer 0092.6935 TBA 2023 Sanitary Sewer Lining (outside of Recon)100,000 - - - Sewer 0092.6935 TBA 2024 Utility Reconstruction 800,000 - - - Sewer 0092.6935 TBA 2024 Perry Lift Station Panel Replacement 70,000 - - - Sewer 0092.6935 TBA 2025 Utility Reconstruction 800,000 - - - Sewer 0092.6935 TBA 2025 Sanitary Sewer Lining (outside of Recon)100,000 - - - Sewer 0092.6935 TBA 2025 East Lift Generator Replacement 150,000 - - - Sewer 0092.6935 TBA 2026 Utility Reconstruction 850,000 - - - Sewer 0092.6935 TBA 2027 Utility Reconstruction 950,000 - - - Sewer 0092.6935 TBA 2027 Sanitary Sewer Lining (outside of Recon)100,000 - - - Sewer 0092.6935 TBA 2028 Utility Reconstruction 1,250,000 - - - Sewer 0092.6935 TBA 2029 Utility Reconstruction 950,000 - - - Sewer 0092.6935 TBA 2029 Add Generator at Maryland lift 150,000 - - - Sewer 0092.6935 TBA 2029 Sanitary Sewer Lining (outside of Recon)100,000 - - - Sewer 0092.6935 TBA 2030 Utility Reconstruction 1,300,000 - - - Sewer 0092.6935 TBA 2031 Sanitary Sewer Lining (outside of Recon)100,000 - - - Sewer 0092.6935 TBA 2031 Utility Reconstruction 1,300,000 - - - Sewer 0092.6935 TBA 2032 Utility Reconstruction 1,200,000 - - - 1,285,000$ 650,000$ 600,000$ 40 2023 2024 2025 2026 2027 2028 2029 2030 2031 Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated Amounts Amounts Amounts Amounts Amounts Amounts Amounts Amounts Amounts -$ -$ -$ -$ -$ -$ -$ -$ -$ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 800,000 - - - - - - - - 100,000 - - - - - - - - - 800,000 - - - - - - - - 70,000 - - - - - - - - - 800,000 - - - - - - - - 100,000 - - - - - - - - 150,000 - - - - - - - - - 850,000 - - - - - - - - - 950,000 - - - - - - - - 100,000 - - - - - - - - - 1,250,000 - - - - - - - - - 950,000 - - - - - - - - 150,000 - - - - - - - - 100,000 - - - - - - - - - 1,300,000 - - - - - - - - - 100,000 - - - - - - - - 1,300,000 - - - - - - - - - 900,000$ 870,000$ 1,050,000$ 850,000$ 1,050,000$ 1,250,000$ 1,200,000$ 1,300,000$ 1,400,000$ 41 City of Crystal, Minnesota Capital Improvement Plan - Sanitary Sewer Fund 510 Statement of Cash Flows 2020 2021 2022 Actual Adopted Proposed Cash Flows from Operating Activities Receipts from customers and users 2,671,477$ 3,094,129$ 3,350,727$ Payments to suppliers (based on utility rate analysis)(1,817,136) (1,848,293) (1,903,742) Payments to employees (based on utility rate analysis)(386,049) (398,702) (418,632) Net Cash Provided (Used) by Operating Activities 468,292 847,134 1,028,353 Cash Flows from Noncapital Financing Activities Transfers to other funds (198,427) (200,621) (211,367) Net Cash Provided (Used) by Noncapital Financing Activities (198,427) (200,621) (211,367) Cash Flows from Capital and Related Financing Activities Acquisition of capital assets (1,112,989) (650,000) (600,000) Contribution to internal service funds (156,964) (163,797) Advances to/(from) other funds 30,000 30,000 30,000 Grants and contributions - - - Net Cash Provided (Used) by Capital and Related Financing Activities (1,082,989) (776,964) (733,797) Cash Flows from Investing Activities Investment earnings 70,567 18,000 18,000 Net Increase (Decrease) in Cash and Cash Equivalents (742,557) (112,451) 101,189 Cash and Cash Equivalents, January 1 1,902,999 1,160,442 1,047,991 Cash and Cash Equivalents, December 31 1,160,442$ 1,047,991$ 1,149,180$ Projected rates Average quarterly bill (9,000 gallons)53.01$ 58.31$ 62.97$ Average quarterly dollar increase 5.68$ 5.30$ 4.66$ Average annual dollar increase 22.74$ 21.20$ 18.64$ Enterprise Fund Projected Activity 42 2023 2024 2025 2026 2027 2028 2029 2030 2031 Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated 3,561,382$ 3,713,834$ 3,835,545$ 3,961,216$ 4,090,976$ 4,295,525$ 4,510,301$ 4,735,816$ 4,972,607$ (1,960,854) (2,019,680) (2,080,270) (2,142,678) (2,206,958) (2,317,306) (2,433,171) (2,554,830) (2,682,571) (480,531) (504,558) (529,786) (556,275) (584,089) (613,293) (643,958) (676,156) (709,964) 1,119,997 1,189,596 1,225,489 1,262,263 1,299,929 1,364,925 1,433,172 1,504,830 1,580,072 (231,778) (231,778) (231,778) (231,778) (231,778) (231,778) (231,778) (231,778) (231,778) (231,778) (231,778) (231,778) (231,778) (231,778) (231,778) (231,778) (231,778) (231,778) (900,000) (870,000) (1,050,000) (850,000) (1,050,000) (1,250,000) (1,200,000) (1,300,000) (1,400,000) (244,918) (243,255) (235,216) (195,302) (175,114) (153,981) (141,366) (137,548) (137,548) 30,000 30,000 30,000 30,000 30,000 30,000 30,000 30,000 30,000 - - - - - - - - - (1,114,918) (1,083,255) (1,255,216) (1,015,302) (1,195,114) (1,373,981) (1,311,366) (1,407,548) (1,507,548) 14,680 14,680 14,680 14,680 14,680 14,680 14,680 14,680 14,680 (212,019) (110,757) (246,825) 29,863 (112,283) (226,153) (95,292) (119,815) (144,574) 1,149,180 937,161 826,405 579,580 609,443 497,160 271,007 175,715 55,900 937,161$ 826,405$ 579,580$ 609,443$ 497,160$ 271,007$ 175,715$ 55,900$ (88,674)$ 66.75$ 69.42$ 71.50$ 73.65$ 75.86$ 78.14$ 80.48$ 82.89$ 82.89$ 3.78$ 2.67$ 2.08$ 2.15$ 2.21$ 2.28$ 2.34$ 2.41$ 2.41$ 15.12$ 10.68$ 8.32$ 8.60$ 8.84$ 9.10$ 9.38$ 9.66$ 9.66$ Enterprise Fund Projected Activity 43 City of Crystal, Minnesota Capital Improvement Plan - Storm Drainage Fund 515 Schedule of Planned Capital Outlay 2020 to 2031 2020 2021 2022 Business Unit Year to Budgeted Proposed Proposed Department Object Code Subledger Replace Item Cost Amounts Amounts Amounts Storm water 0094.6935 TBA 2020 Central Core storm water model and flood analysis 125,000$ 125,000$ -$ -$ Storm water 0094.6935 TBA 2020 Rate Control, water quality, structure Rehab projects 50,000 50,000 - - Storm water 0094.6935 TBA 2020 W. Broadway and Kentucky Infiltration (2)450,000 450,000 - . Storm water 0094.6935 TBA 2020 Utility Reconstruction 50,000 50,000 - - Storm water 0094.6935 TBA 2021 6804 - Gaulke Pond design, dredging, lift station rehab 2,000,000 - 2,000,000 - Storm water 0094.6935 TBA 2021 Rate Control, water quality, structure Rehab projects 450,000 - 450,000 - Storm water 0094.6935 TBA 2021 Utility Reconstruction 50,000 - 50,000 - Storm water 0094.6935 TBA 2022 Utility Reconstruction 50,000 - - 50,000 Storm water 0094.6935 TBA 2022 Rate Control, water quality, structure Rehab projects 75,000 - - 75,000 Storm water 0094.6935 TBA 2023 Rate Control, water quality, structure Rehab projects 50,000 - - - Storm water 0094.6935 TBA 2023 Saving for flood control structure replacement 200,000 - - - Storm water 0094.6935 TBA 2023 Utility Reconstruction 50,000 - - - Storm water 0094.6935 TBA 2024 Rate Control, water quality, structure Rehab projects 150,000 - - - Storm water 0094.6935 TBA 2024 Saving for flood control structure replacement 200,000 - - - Storm water 0094.6935 TBA 2024 Utility Reconstruction 50,000 - - - Storm water 0094.6935 TBA 2024 Rate Control, water quality, structure Rehab projects 150,000 - - - Storm water 0094.6935 TBA 2025 Rate Control, water quality, structure Rehab projects 100,000 - - - Storm water 0094.6935 TBA 2025 Saving for flood control structure replacement 200,000 - - - Storm water 0094.6935 TBA 2025 Utility Reconstruction 50,000 - - - Storm water 0094.6935 TBA 2026 Bassett Creek Park Streambank Stabilization and 29th culvert replacement (3)1,000,000 - - - Storm water 0094.6935 TBA 2026 Rate Control, water quality, structure Rehab projects 150,000 - - - Storm water 0094.6935 TBA 2026 Saving for flood control structure replacement 200,000 - - - Storm water 0094.6935 TBA 2026 Utility Reconstruction 50,000 - - - Storm water 0094.6935 TBA 2026 Rate Control, water quality, structure Rehab projects 150,000 - - - Storm water 0094.6935 TBA 2027 Pond dredging - TBD 750,000 - - - Storm water 0094.6935 TBA 2027 Saving for flood control structure replacement 200,000 - - - Storm water 0094.6935 TBA 2027 Utility Reconstruction 50,000 - - - Storm water 0094.6935 TBA 2028 Rate Control, water quality, structure Rehab projects 100,000 - - - Storm water 0094.6935 TBA 2028 Saving for flood control structure replacement 200,000 - - - Storm water 0094.6935 TBA 2028 Utility Reconstruction 50,000 - - - Storm water 0094.6935 TBA 2028 Rate Control, water quality, structure Rehab projects 150,000 - - - Storm water 0094.6935 TBA 2029 Saving for flood control structure replacement 200,000 - - - Storm water 0094.6935 TBA 2029 Utility Reconstruction 50,000 - - - Storm water 0094.6935 TBA 2029 Bass Lake Road storm water pipe 2,000,000 - - - Storm water 0094.6935 TBA 2030 Capital 420,000 - - - Storm water 0094.6935 TBA 2030 Utility Reconstruction 50,000 - - - Storm water 0094.6935 TBA 2030 Rate Control, water quality, structure Rehab projects 150,000 - - - Storm water 0094.6935 TBA 2031 Yunkers Park storage project 1,500,000 - - - Storm water 0094.6935 TBA 2031 Rate Control, water quality, structure Rehab projects 250,000 - - - Storm water 0094.6935 TBA 2031 Saving for flood control structure replacement 200,000 - - - Storm water 0094.6935 TBA 2031 Utility Reconstruction 50,000 - - - 675,000$ 2,500,000$ 125,000$ (1) Secured grants of $1,325,000 have been included in the cash flow analysis below; the City has also applied for an additional $80K of grants and identified $400K in other potential grant opportunities. 44 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated Amounts Amounts Amounts Amounts Amounts Amounts Amounts Amounts Amounts Amounts -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 50,000 - - - - - - - - - 200,000 - - - - - - - - - 50,000 - - - - - - - - - - 150,000 - - - - - - - - - 200,000 - - - - - - - - - 50,000 - - - - - - - - - 150,000 - - - - - - - - - - 100,000 - - - - - - - - - 200,000 - - - - - - - - - 50,000 - - - - - - - - - - 1,000,000 - - - - - - - - - 150,000 - - - - - - - - - 200,000 - - - - - - - - - 50,000 - - - - - - - - - 150,000 - - - - - - - - - - 750,000 - - - - - - - - - 200,000 - - - - - - - - - 50,000 - - - - - - - - - - 100,000 - - - - - - - - - 200,000 - - - - - - - - - 50,000 - - - - - - - - - 150,000 - - - - - - - - - - 200,000 - - - - - - - - - 50,000 - - - - - - - - - 2,000,000 - - - - - - - - - - 420,000 - - - - - - - - - 50,000 - - - - - - - - - 150,000 - - - - - - - - - - 1,500,000 - - - - - - - - - 250,000 - - - - - - - - - 200,000 - - - - - - - - - 50,000 - - 300,000$ 550,000$ 350,000$ 1,550,000$ 1,000,000$ 500,000$ 2,250,000$ 620,000$ 2,000,000$ -$ 45 City of Crystal, Minnesota Capital Improvement Plan - Storm Drainage Fund 515 Statement of Cash Flows 2020 2021 2022 Actual Adopted Proposed Cash Flows from Operating Activities Receipts from customers and users 1,272,283$ 1,335,897$ 1,399,060$ Payments to suppliers and employees (5% growth assumption)(379,763) (420,801) (418,633) Net Cash Provided (Used) by Operating Activities 892,520 915,096 980,427 Cash Flows from Noncapital Financing Activities Transfers out (53,395) (53,985) (56,876) Net Cash Provided (Used) by Noncapital Financing Activities (53,395) (53,985) (56,876) Cash Flows from Capital and Related Financing Activities Acquisition of capital assets (811,677) (2,500,000) (125,000) Contribution to internal service funds (82,331) (158,510) Advance to/(from) building fund (1,000,000) Intergovernmental revenue (Watershed, Met Council, MNDNR and other)1,181,471 - - Net Cash Provided (Used) by Capital and Related Financing Activities 369,794 (2,582,331) (1,283,510) Cash Flows from Investing Activities Investment earnings 82,948 6,000 6,000 Net Increase (Decrease) in Cash and Cash Equivalents 1,291,867 (1,715,220) (353,959) Cash and Cash Equivalents, January 1 857,720 2,149,587 434,367 Cash and Cash Equivalents, December 31 2,149,587$ 434,367$ 80,408$ Projected rates Quarterly bill 20.15$ 21.15$ 22.15$ Annual dollar increase 1.00$ 1.00$ 1.00$ Percent increase 5%5% Enterprise Fund Projected Activity 46 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated 1,462,223$ 1,525,386$ 1,588,549$ 1,620,131$ 1,651,712$ 1,683,294$ 1,714,875$ 1,746,457$ 1,778,038$ 1,809,620$ (439,565) (461,543) (484,620) (508,851) (534,294) (561,008) (589,059) (618,512) (649,437) (681,909) 1,022,658 1,063,843 1,103,929 1,111,280 1,117,418 1,122,285 1,125,816 1,127,945 1,128,601 1,127,710 (59,720) (62,706) (65,841) (69,133) (72,590) (76,219) (80,030) (84,032) (88,233) (92,645) (59,720) (62,706) (65,841) (69,133) (72,590) (76,219) (80,030) (84,032) (88,233) (92,645) (300,000) (550,000) (350,000) (1,550,000) (1,000,000) (500,000) (2,250,000) (620,000) (2,000,000) - (153,405) (152,557) (150,651) (149,514) (139,516) (97,720) (96,741) (97,433) (97,433) - - 150,000 - 170,000 170,000 170,000 170,000 170,000 - - - - 500,000 - - - - - (453,405) (702,557) (350,651) (1,199,514) (969,516) (427,720) (2,176,741) (547,433) (1,927,433) - 804 5,907 8,952 15,916 14,502 15,400 21,737 10,645 15,716 7,003 510,338 304,488 696,389 (141,451) 89,814 633,746 (1,109,218) 507,125 (871,349) 1,042,068 80,408 590,746 895,234 1,591,623 1,450,172 1,539,986 2,173,732 1,064,515 1,571,640 700,291 590,746$ 895,234$ 1,591,623$ 1,450,172$ 1,539,986$ 2,173,732$ 1,064,515$ 1,571,640$ 700,291$ 1,742,359$ 23.15$ 24.15$ 25.15$ 25.65$ 26.15$ 26.65$ 27.15$ 27.65$ 28.15$ 28.65$ 1.00$ 1.00$ 1.00$ 0.50$ 0.50$ 0.50$ 0.50$ 0.50$ 0.50$ 0.50$ 5%4%4%2%2%2%2%2%2%2% Enterprise Fund Projected Activity 47 City of Crystal, Minnesota Capital Improvement Plan - Street Light Fund 520 Schedule of Planned Capital Outlay 2020 to 2031 2020 2021 2022 Business Unit Year to Budgeted Proposed Proposed Department Object Code Subledger Replace Item Cost Amounts Amounts Amounts Street light 0096.6915 TBA 2020 HPS to LED conversion 25,000$ 25,000$ -$ -$ Street light 0096.6915 TBA 2021 HPS to LED conversion 25,000 - 25,000 - Street light 0096.6915 TBA 2022 HPS to LED conversion 25,000 - - 25,000 Street light 0096.6915 TBA 2023 HPS to LED conversion 25,000 - - - Street light 0096.6915 TBA 2023 Underground utility poles (42nd)1,000,000 - - - Street light 0096.6915 TBA 2024 HPS to LED conversion 25,000 - - - Street light 0096.6915 TBA 2025 HPS to LED conversion 25,000 - - - Street light 0096.6915 TBA 2026 HPS to LED conversion 25,000 - - - Street light 0096.6915 TBA 2027 HPS to LED conversion 25,000 - - - Street light 0096.6915 TBA 2028 HPS to LED conversion 25,000 - - - Street light 0096.6915 TBA 2029 HPS to LED conversion 25,000 - - - Street light 0096.6915 TBA 2030 HPS to LED conversion 25,000 - - - 25,000$ 25,000$ 25,000$ 48 2023 2024 2025 2026 2027 2028 2029 2030 2031 Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated Amounts Amounts Amounts Amounts Amounts Amounts Amounts Amounts Amounts -$ -$ -$ -$ -$ -$ -$ -$ -$ - - - - - - - - - - - - - - - - - - 25,000 - - - - - - - - 1,000,000 - - - - - - - - - 25,000 - - - - - - - - - 25,000 - - - - - - - - - 25,000 - - - - - - - - - 25,000 - - - - - - - - - 25,000 - - - - - - - - - 25,000 - - - - - - - - - 25,000 - 1,025,000$ 25,000$ 25,000$ 25,000$ 25,000$ 25,000$ 25,000$ 25,000$ -$ 49 City of Crystal, Minnesota Capital Improvement Plan - Street Light Fund 520 Statement of Cash Flows Enterprise Fund Projected Activity 2020 2021 2022 Actual Proposed Proposed Cash Flows from Operating Activities Receipts from customers and users (2% growth assumption)192,080$ 194,200$ 194,200$ Payments to suppliers and employees (5% growth assumption)(163,942) (151,590) (151,764) Net Cash Provided (Used) by Operating Activities 28,138 42,610 42,436 Cash Flows from Noncapital Financing Activities Transfers out (15,084) (15,251) (16,098) Net Cash Provided (Used) by Noncapital Financing Activities (15,084) (15,251) (16,098) Cash Flows from Capital and Related Financing Activities Acquisition of capital assets (1,030) (25,000) (25,000) Intergovernmental revenue - - - Advances to/(from) other funds 30,000 30,000 30,000 Net Cash Provided (Used) by Capital and Related Financing Activities 28,970 5,000 5,000 Cash Flows from Investing Activities Investment earnings 30,168 6,500 6,500 Net Increase (Decrease) in Cash and Cash Equivalents 72,192 38,859 37,838 Cash and Cash Equivalents, January 1 704,025 776,217 815,076 Cash and Cash Equivalents, December 31 776,217$ 815,076$ 852,914$ 50 Enterprise Fund Projected Activity 2023 2024 2025 2026 2027 2028 2029 2030 2031 Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated 198,084$ 202,046$ 206,087$ 210,208$ 214,412$ 218,701$ 223,075$ 227,536$ 232,087$ (159,352) (167,320) (175,686) (184,470) (193,694) (203,378) (213,547) (224,225) (235,436) 38,732 34,726 30,401 25,738 20,719 15,322 9,528 3,312 (3,349) (16,903) (17,748) (18,635) (19,567) (20,546) (21,573) (22,652) (23,784) (24,973) (16,903) (17,748) (18,635) (19,567) (20,546) (21,573) (22,652) (23,784) (24,973) (1,025,000) (25,000) (25,000) (25,000) (25,000) (25,000) (25,000) (25,000) - 500,000 - - - - - - - - 30,000 30,000 30,000 30,000 30,000 30,000 30,000 30,000 30,000 (495,000) 5,000 5,000 5,000 5,000 5,000 5,000 5,000 30,000 8,529 3,883 4,141 4,350 4,506 4,602 4,636 4,601 4,492 (464,642) 25,861 20,907 15,521 9,679 3,352 (3,488) (10,871) 6,170 852,914 388,272 414,133 435,039 450,561 460,240 463,592 460,104 449,232 388,272$ 414,133$ 435,039$ 450,561$ 460,240$ 463,592$ 460,104$ 449,232$ 455,402$ 51 City of Crystal, Minnesota Capital Improvement Plan - Fleet Fund 615 Schedule of Planned Capital Outlay 2020 to 2031 2020 2021 2022 Business Unit Year to Budgeted Proposed Proposed Object Code Subledger Replace Item Cost Amounts Amounts Amounts Public Works 0615.6930 TBA 2020 Replace $=#153 Land Pride 72' Over Seeder 30,000$ 30,000$ -$ -$ Public Works 0615.6930 TBA 2020 Replace #341 - 2005 CAT 3 ton roller 60,000 60,000 - - Public Works 0615.6930 TBA 2020 Replace #123 - 11' Large Area Mower (replacement)68,000 68,000 - - Public Works 0615.6930 TBA 2020 Replace #339 Tack trailer 90,000 90,000 - - Public Works 0615.6930 TBA 2020 Replace #327 - 2008 message board 20,000 20,000 - - Public Works 0615.6930 TBA 2020 Replace # 125 Pickup 75,000 75,000 - - Public Works 0615.6930 TBA 2020 6237- water utility Replace #434 - 1996 Air Compressor 60,000 60,000 - - Public Works 0615.6930 TBA 2021 Replace #311 - 2007 Freightliner SA 260,000 - 260,000 - Public Works 0615.6930 TBA 2021 Replace Aerator and seeder 35,000 - 35,000 - Public Works 0615.6930 TBA 2021 Utility Water Main Break trailer 35,000 - 35,000 - Public Works 0615.6930 TBA 2021 Replace #116 John Deere utility tractor w/ implement 55,000 - 55,000 - Public Works 0615.6930 TBA 2021 Replace #326 Asphalt roller trailer 15,000 - 15,000 - Public Works 0615.6930 TBA 2021 Replace homemade utility trailer (replace Z turn trailer)15,000 - 15,000 - Public Works 0615.6930 TBA 2021 Replace #301 - 2011 Dodge Ram 75,000 - 75,000 - Public Works 0615.6930 TBA 2021 Replace #439 20 Kw portable generator with light tower (replace existing 37kW)45,000 - 45,000 - Public Works 0615.6930 TBA 2022 Replace #109 - 2003 Int'l 7400 Tandem drup truck (rehabbed in 2019)190,000 - - 190,000 Public Works 0615.6930 TBA 2022 Replace #303-1 - MTV Trackless MT-6 160,000 - - 160,000 Public Works 0615.6930 TBA 2022 Z Turn Mower (replacement)15,000 - - 15,000 Public Works 0615.6930 TBA 2022 Replace #144 - Kubota Zero-Turn Tractor w/Catcher 15,000 - - 15,000 Public Works 0615.6930 TBA 2022 Replace #158 (replace Z turn trailer)15,000 - - 15,000 Public Works 0615.6930 TBA 2022 Replace #309 - 2010 Freightliner TA 270,000 - - 270,000 Public Works 0615.6930 TBA 2022 Replace #307 - 2012 Ram 2500 (new is swap loader)75,000 - - 75,000 Public Works 0615.6930 TBA 2023 Replace #337 - 2013 Mauldin asphalt paver 195,000 - - - Public Works 0615.6930 TBA 2023 Replace #364 - SPH-1.3 pre-mix heater hot box/patching 45,000 - - - Public Works 0615.6930 TBA 2023 Replace #310 - 2010 Chevy 3500 75,000 - - - Public Works 0615.6930 TBA 2023 Replace #314 - 2012 International SA 265,000 - - - Public Works 0615.6930 TBA 2023 Replace #431 - Sterling Acterra w/jetter 275,000 - - - Public Works 0615.6930 TBA 2023 Replace #110 - Chevy K3500 Silverado and 9' plow w/Tommy gate 54,520 - - - Public Works 0615.6930 TBA 2024 Replace #108 Cushman Gas Truckster 4 Wheel (Replace with ToolCAT)75,000 - - - Public Works 0615.6930 TBA 2024 Replace #178 Graco Fieldlazer @100 striper 10,000 - - - Comm Dev 0615.6930 TBA 2024 Replace #56 - 2014 Ford Focus 21,587 - - - Public Works 0615.6930 TBA 2024 Replace #351 - Rayco brush chipper 52,804 - - - Public Works 0615.6930 TBA 2024 Replace #420 Tractor backhoe 250,000 - - - Public Works 0615.6930 TBA 2024 Replace #428 - GMC Sierra 3500HD 1 ton dump truck 75,000 - - - Public Works 0615.6930 TBA 2024 Replace #451 - SRECO easement machine (no title)44,590 - - - Public Works 0615.6930 TBA 2024 Replace #457 - Broot utility trailer 11,000 - - - Public Works 0615.6930 TBA 2025 Replace #102 Ford F350 Pickup 75,000 - - - Public Works 0615.6930 TBA 2025 Aerator 35,000 - - - Public Works 0615.6930 TBA 2025 Replace Engineering #42 40,000 - - - Public Works 0615.6930 TBA 2025 Replace #340 - Tenco TCS-172A-LMM Snow Blower 181,732 - - - Public Works 0615.6930 TBA 2025 Replace #390 - Veritec salt brine system/generator 96,924 - - - Public Works 0615.6930 TBA 2025 Replace 3-yd grapple bucket for use w/front end loaders 30,289 - - - Public Works 0615.6930 TBA 2025 Replace #106 - Ford F350 Pickup w/Henderson Dump body 90,000 - - - Public Works 0615.6930 TBA 2025 Replace #401 - Chevy Silverado 2500 (white)46,674 - - - Public Works 0615.6930 TBA 2026 Replace #453 Power Prime 6" trash pump 65,000 - - - Public Works 0615.6930 TBA 2026 Replace #115 - GMC 1 ton; Sierra 3500 (gray)50,037 - - - Public Works 0615.6930 TBA 2026 Replace #433-1 - John Deere 190D excavator 306,476 - - - Public Works 0615.6930 TBA 2026 Replace #433-2 - 30" V-bottom frost bucket (for #433)6,255 - - - Public Works 0615.6930 TBA 2026 Replace #433-3 - Empire excavator grapple (for #433)10,007 - - - Public Works 0615.6930 TBA 2026 Replace #433-4 - Allied hydraulic hammer (for #433)50,037 - - - Public Works 0615.6930 TBA 2027 Replace #111 - Chevy Silverado K2500 Pickup (blue)Utility box 77,495 - - - Public Works 0615.6930 TBA 2027 Replace #316 - Chevrolet 1 ton Silverado 3500 4X4 (white)41,330 - - - Public Works 0615.6930 TBA 2027 Replace #342 - TowMaster T-10DT Trailer 9,041 - - - Public Works 0615.6930 TBA 2027 Replace #450-1 - Caterpillar 930K wheel loader (no title)245,400 - - - Public Works 0615.6930 TBA 2027 Replace #462 - Elgin Pelican NP Sweeper 290,605 - - - Public Works 0615.6930 TBA 2028 Replace #455 - MacLander trailer 6,668 - - - Public Works 0615.6930 TBA 2028 Replace #306 - GMC Sierra 1500 Ext Cab 1/2 Ton (blue)42,674 - - - Public Works 0615.6930 TBA 2028 Replace #332 - Wacker WP1550AW plate tamper 6,668 - - - Public Works 0615.6930 TBA 2028 Replace #334 - Bobcat Skid loader Model A770 IT4 126,688 - - - Public Works 0615.6930 TBA 2028 Replace #430 - Sreco sewer rodder 93,349 - - - Public Works 0615.6930 TBA 2028 Replace #450-2 - 12 ft Plow & ACS Adapter (for #450)16,003 - - - Public Works 0615.6930 TBA 2029 Replace #118 - Bear Cat truckloader leaf blower & vacuum w/trailer 34,422 - - - Public Works 0615.6930 TBA 2029 Replace #312 - Int'l 7400 4x2 truck w/dump box, plow & sander 385,530 - - - Comm Dev 0615.6930 TBA 2029 Replace car #27 - 2007 Chevy Malibu 21,587 - - - Comm Dev 0615.6930 TBA 2029 Replace car #57 - 2006 Chevy Malibu 21,587 - - - Department 52 2023 2024 2025 2026 2027 2028 2029 2030 2031 Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated Amounts Amounts Amounts Amounts Amounts Amounts Amounts Amounts Amounts -$ -$ -$ -$ -$ -$ -$ -$ -$ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 195,000 - - - - - - - - 45,000 - - - - - - - - 75,000 - - - - - - - - 265,000 - - - - - - - - 275,000 - - - - - - - - 54,520 - - - - - - - - - 75,000 - - - - - - - - 10,000 - - - - - - - - 21,587 - - - - - - - - 52,804 - - - - - - - - 250,000 - - - - - - - - 75,000 - - - - - - - - 44,590 - - - - - - - - 11,000 - - - - - - - - - 75,000 - - - - - - - - 35,000 - - - - - - - - 40,000 - - - - - - - - 181,732 - - - - - - - - 96,924 - - - - - - - - 30,289 - - - - - - - - 90,000 - - - - - - - - 46,674 - - - - - - - - - 65,000 - - - - - - - - 50,037 - - - - - - - - 306,476 - - - - - - - - 6,255 - - - - - - - - 10,007 - - - - - - - - 50,037 - - - - - - - - - 77,495 - - - - - - - - 41,330 - - - - - - - - 9,041 - - - - - - - - 245,400 - - - - - - - - 290,605 - - - - - - - - - 6,668 - - - - - - - - 42,674 - - - - - - - - 6,668 - - - - - - - - 126,688 - - - - - - - - 93,349 - - - - - - - - 16,003 - - - - - - - - - 34,422 - - - - - - - - 385,530 - - - - - - - - 21,587 - - - - - - - - 21,587 - - 53 City of Crystal, Minnesota Capital Improvement Plan - Fleet Fund 615 Schedule of Planned Capital Outlay 2018 to 2030 (Continued) 2020 2021 2022 Business Unit Year to Budgeted Proposed Proposed Object Code Subledger Replace Item Cost Amounts Amounts Amounts Public Works 0615.6930 TBA 2030 Replace #101 - GMC Sierra 3500 4wd (white) w/V-Plow 54,022$ -$ -$ -$ Public Works 0615.6930 TBA 2030 Replace #113 - Chevy Silverado 3500 4X4 w/Crysteel dump body & hoist 65,396 - - - Public Works 0615.6930 TBA 2030 Replace #145 - Toro Workman MDX w/ballfield groomer 25,590 - - - Public Works 0615.6930 TBA 2030 Replace #305 - Dodge Ram 5500 4X4 Bucket Truck w/Dura-Lift (white)284,329 - - - Public Works 0615.6930 TBA 2030 Replace #347 - TowMaster 10,000 LB trailer (Skidsteer, 3 TN Roller)14,216 - - - Public Works 0615.6930 TBA 2030 Replace #350 - Tennant MS20GLP Floor Sweeper 78,190 - - - Public Works 0615.6930 TBA 2030 Replace #352 - Coats Wheel Balancer 14,216 - - - Public Works 0615.6930 TBA 2030 Replace #353 - Coats Tire Changer 21,325 - - - Public Works 0615.6930 TBA 2030 Replace #363 - Toyota 5000-lb forklift w/sideshifting positioner 71,082 - - - Public Works 0615.6930 TBA 2030 Replace #449 Chevy Silverado K2500 (white)40,000 - - - Public Works 0615.6930 TBA 2030 Replace #459 Aries CCTV Pathfinder Command Ctr and trailer (no title)150,000 - - - Public Works 0615.6930 TBA 2031 Replace #336 Cimline crack/joint sealer, Magma 150 75,000 - - - Public Works 0615.6930 TBA 2031 Replace #447 Freightliner 114SD w/plow,wing,sander,controls 280,000 - - - Public Works 0615.6930 TBA 2031 Replace #436 Landa portable hot water jetter w/trailer 8,000 - - - Public Works 0615.6930 TBA 2031 Replace #103 GMC Sierra 2500 4WD (white)32,000 - - - Public Works 0615.6930 TBA 2031 Replace #117 Case 321FHS Wheel Loader 125,000 - - - Public Works 0615.6930 TBA 2031 Replace #120 J.D. Gator 5710M w/Ballfield Drag & Sun Cab 19,000 - - - Public Works 0615.6930 TBA 2031 Replace #127 Toro Grounds Master 5910 (cab, leaft kit, road lights)125,000 - - - Public Works 0615.6930 TBA 2031 Replace #152 Felling FT-10IT-E00260 Trailer 20,000 - - - Public Works 0615.6930 TBA 2031 Replace #159 Felling FT-10 IT-E Trailer 20,000 - - - Public Works 0615.6930 TBA 2031 Replace #346 TowMaster T-20T Trailer 8,000 - - - Public Works 0615.6930 TBA 2031 Replace #365 Cimline asphalt crack router, PCR30 20,000 - - - Public Works 0615.6930 TBA 2031 Replace #429 GMC Sierra 3500 C/CH 4WD 85,000 - - - 403,000$ 535,000$ 740,000$ Department 54 2023 2024 2025 2026 2027 2028 2029 2030 2031 Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated Amounts Amounts Amounts Amounts Amounts Amounts Amounts Amounts Amounts -$ -$ -$ -$ -$ -$ -$ 54,022$ -$ - - - - - - - 65,396 - - - - - - - - 25,590 - - - - - - - - 284,329 - - - - - - - - 14,216 - - - - - - - - 78,190 - - - - - - - - 14,216 - - - - - - - - 21,325 - - - - - - - - 71,082 - - - - - - - - 40,000 - - - - - - - - 150,000 - - - - - - - - - 75,000 - - - - - - - - 280,000 - - - - - - - - 8,000 - - - - - - - - 32,000 - - - - - - - - 125,000 - - - - - - - - 19,000 - - - - - - - - 125,000 - - - - - - - - 20,000 - - - - - - - - 20,000 - - - - - - - - 8,000 - - - - - - - - 20,000 - - - - - - - - 85,000 909,520$ 539,980$ 595,619$ 487,812$ 663,871$ 292,048$ 463,127$ 818,366$ 817,000$ 55 City of Crystal, Minnesota Capital Improvement Plan - Fleet Fund 615 Statement of Cash Flows 2020 2021 2022 Actual Adopted Proposed Cash Flows from Operating Activities Receipts from interfund services provided -$ 336,537$ 341,585$ Receipts from property taxes (1% increase, annually, beginning in 2020)85,680 - - Payments to suppliers and employees (2.5% growth annually)(7,156) (3,599) (3,628) Net Cash Provided (Used) by Operating Activities 78,524 332,939 337,957 Cash Flows from Noncapital Financing Activities Transfers in/(out)- - - Net Cash Provided (Used) by Noncapital Financing Activities - - - Cash Flows from Capital and Related Financing Activities Acquisition of capital assets (563,243) (535,000) (740,000) Proceeds from sale of assets 89,293 46,640 46,640 Proceeds from bonds and notes issued - - - Net Cash Used by Capital and Related Financing Activities (473,950) (488,360) (693,360) Cash Flows from Investing Activities Investment earnings 88,158 20,000 20,000 Net Increase (Decrease) in Cash and Cash Equivalents (307,268) (135,422) (335,403) Cash and Cash Equivalents, January 1 2,850,257 2,542,989 2,407,568 Cash and Cash Equivalents, December 31 2,542,989$ 2,407,568$ 2,072,165$ Internal Service Fund Projected Activity 56 2023 2024 2025 2026 2027 2028 2029 2030 2031 Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated 365,496$ 391,081$ 418,456$ 447,748$ 479,091$ 512,627$ 548,511$ 586,907$ 627,990$ - - - - - - - - - (3,737) (3,849) (3,964) (4,083) (4,206) (4,332) (4,462) (4,596) (4,734) 361,759 387,232 414,492 443,665 474,885 508,295 544,049 582,311 623,256 - - - - - - - - - - - - - - - - - - (909,520) (539,980) (595,619) (487,812) (663,871) (292,048) (463,127) (818,366) (817,000) 46,640 46,640 46,640 46,640 46,640 46,640 46,640 46,640 46,640 - - - - - - - - - (862,880) (493,340) (548,979) (441,172) (617,231) (245,408) (416,487) (771,726) (770,360) 20,722 15,918 15,016 13,821 13,984 12,701 15,456 16,887 15,161 (480,399) (90,191) (119,471) 16,314 (128,362) 275,587 143,019 (172,529) (131,942) 2,072,165 1,591,766 1,501,575 1,382,103 1,398,417 1,270,056 1,545,643 1,688,661 1,516,132 1,591,766$ 1,501,575$ 1,382,103$ 1,398,417$ 1,270,056$ 1,545,643$ 1,688,661$ 1,516,132$ 1,384,190$ Internal Service Fund Projected Activity 57 City of Crystal, Minnesota Capital Improvement Plan - Building Fund 408/625 Schedule of Planned Capital Outlay 2020 to 2031 2020 2021 2022 Business Unit Year to Budgeted Proposed Proposed Department Object Code Subledger Replace Item Cost Amounts Amounts Amounts City Buildings 0625.6940 TBA 2021 City Hall - office cubes and desks 100,000$ -$ 100,000$ -$ Fire Department 2021 Install exterior ladder to roof at South Fire 20,000 - 20,000 - Police 0625.6940 TBA 2021 Public Safety Facility 1,250,000 - 1,250,000 - Police 0625.6940 TBA 2021 Public Safety Facility 4,000,000 - 4,000,000 - Fire Department 0625.6940 TBA 2021 Replace roof at south fire station 150,000 - 150,000 - Community Center 0625.6940 TBA 2021 Replace roll-up fire doors in kitchen(4)35,000 - 35,000 - Community Center 0625.6940 TBA 2021 Parking Lot Improvements 819,000 - 819,000 - Aquatic Building 0625.6940 TBA 2021 Install eyewash station 10,000 - 10,000 - Community Center 0625.6940 TBA 2021 Security camera upgrade 40,000 - 40,000 - Fire Department 0625.6940 TBA 2021 Irrigate campus (does not work currently) North Fire Station 25,000 - 25,000 - North Lions Park 0625.6941 TBA 2021 Replace exterior lighting 15,000 - 15,000 - North Lions Park 0625.6942 TBA 2021 Replace exterior lighting controls 5,000 - 5,000 - Pool 0625.6940 TBA 2021 New water feature 25,000 - 25,000 - Pool 0625.6940 TBA 2021 Fully replace umbrella (2)45,000 - 45,000 - Community Center 0625.6941 TBA 2021 Tuckpointing 55,000 - 55,000 - Community Center 0625.6941 TBA 2021 Install/replace Basketball scoreboard 35,000 - 35,000 - Valley Place Park 0625.6941 TBA 2021 Replace Roofing and Fascia 50,000 - 50,000 - Valley Place Park 0625.6942 TBA 2021 Replace Interior Lighting 15,000 - 15,000 - Valley Place Park 0625.6943 TBA 2021 Replace Exterior Doors 25,000 - 25,000 - Pool 0625.6940 TBA 2021 Replace smaller pump (main water slide)40,000 - 40,000 - Welcome Park 0625.6941 TBA 2021 Replace Interior Lighting 10,000 - 10,000 - Valley Place Park 0625.6940 TBA 2021 Paint interior 15,000 - 15,000 - Welcome Park 0625.6940 TBA 2021 Replace water heater 10,000 - 10,000 - Valley Place Park 0625.6940 TBA 2021 ADA drinking fountain upgrades 15,000 - 15,000 - Valley Place Park 0625.6940 TBA 2021 ADA park shelter restroom upgrades 10,000 - 10,000 - Welcome Park 0625.6940 TBA 2021 ADA restroom upgrades 10,000 - 10,000 - Police 0625.6940 TBA 2022 Public Safety Facility 8,000,000 - - 8,000,000 City Buildings 0625.6940 TBA 2022 Parking lot replacement 250,000 - - 250,000 City Buildings 0625.6940 TBA 2022 Investigate drainage in boiler room 10,000 - - 10,000 City Buildings 0625.6940 TBA 2022 Make cell phone boost system typical install 50,000 - - 50,000 City Buildings 0625.6940 TBA 2022 Replace alarms and sensors 50,000 - - 50,000 City Buildings 0625.6940 TBA 2022 Replace control panel 18,000 - - 18,000 City Buildings 0625.6940 TBA 2022 Upgrade system to code 10,000 - - 10,000 City Buildings 0625.6940 TBA 2022 Replace VFD on air handlers 10,000 - - 10,000 Old Utilities Bldg 0625.6940 TBA 2022 Replace garage door obstruction sensors 5,000 - - 5,000 Public Works 0625.6940 TBA 2022 Re-seal garage doors - PW 12,000 - - 12,000 Community Center 0625.6940 TBA 2022 Refinish Crystal Room Floors 50,000 - - 50,000 Community Center 0625.6940 TBA 2022 Replace South Parking lot 1,000,000 - - 1,000,000 Community Center 0625.6940 TBA 2022 Replace gym flashing 125,000 - - 125,000 Community Center 0625.6940 TBA 2022 Install motion sensors for lighting at CCC 35,000 - - 35,000 Community Center 0625.6940 TBA 2022 Replace skylights 220,000 - - 220,000 Bassett Creek Park 0625.6940 TBA 2022 Replace Parking lot 385,000 - - 385,000 North Lions Park 0625.6940 TBA 2022 Replace furnace/thermostat and chimney 15,000 - - 15,000 Public Works 0625.6940 TBA 2022 Interior touch up paint 20,000 - - 20,000 City Buildings 0625.6940 TBA 2022 Replace carpeting 100,000 - - 100,000 Community Center 0625.6940 TBA 2022 Replace Air Handler 45,000 - - 45,000 Police 0625.6941 TBA 2023 Public Safety Facility 4,000,000 - - - Community Center 0625.6940 TBA 2023 Replace flooring- Valley room 10,000 - - - Pool 0625.6940 TBA 2023 Replace all tile and caulking in all pools 2,510,000 - - - Community Center 0625.6940 TBA 2023 Replace dishwasher and on demand heater 30,000 - - - Valley Place Park 0625.6940 TBA 2023 Replace parking lot (West)250,000 - - - Aquatic building 0625.6940 TBA 2023 Repair Siding and Paint exterior building 100,000 - - - Aquatic building 0625.6940 TBA 2023 Replace fasade and replace building louvers 250,000 - - - Aquatic building 0625.6940 TBA 2023 Front Desk Security Improvement 100,000 - - - Aquatic building 0625.6940 TBA 2023 Replace staff lockers 15,000 - - - Welcome Park 0625.6941 TBA 2023 Replace Building Fascia and Soflits 25,000 - - - Welcome Park 0625.6942 TBA 2023 Replace Building Doors 20,000 - - - Welcome Park 0625.6943 TBA 2023 Replace Building Sidewalk Entry 10,000 - - - City Buildings 0625.6940 TBA 2023 Evaluate city hall system for space heater use 60,000 - - - City Buildings 0625.6940 TBA 2023 Parking lot lighting upgrade 14,000 - - - City Buildings 0625.6940 TBA 2023 Replace cabinets in copy room 10,000 - - - City Buildings 0625.6940 TBA 2023 Replace cabinets in Council Chambers 15,000 - - - City Buildings 0625.6940 TBA 2023 City Hall fire extinguisher mounts/cabinets 15,000 - - - City Buildings 0625.6940 TBA 2023 Install boiler for heater at PW 35,000 - - - City Buildings 0625.6940 TBA 2023 Fob access all doors - City Hall 25,000 - - - City Buildings 0625.6940 TBA 2023 Replace/improve to upstairs IT room 15,000 - - - Salt Building 0625.6940 TBA 2023 Paint exterior building, light panel replacement 10,000 - - - Community Center 0625.6940 TBA 2023 ADA and security update Front desk 50,000 - - - Community Center 0625.6940 TBA 2023 HVAC/mechanical updates 100,000 - - - Community Center 0625.6940 TBA 2023 Tile floor update/repair 5,000 - - - Community Center 0625.6940 TBA 2023 Replace Exterior Windows 50,000 - - - Pool 0625.6940 TBA 2023 Replaster Zero depth pool and replace play feature - from leak report 290,000 - - - Pool 0625.6940 TBA 2023 Replace starting blocks 25,000 - - - Pool 0625.6940 TBA 2023 Replace water walk pads 15,000 - - - Public Works 0625.6940 TBA 2023 Install boiler for heater 35,000 - - - Aquatic building 0625.6940 TBA 2023 Recoat water slides 80,000 - - - City Buildings 0625.6940 TBA 2023 HVAC cleaning 35,000 - - - Pool 0625.6940 TBA 2023 Gel coat water slides and drop slide 80,000 - - - 58 2023 2024 2025 2026 2027 2028 2029 2030 2031 Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated Amounts Amounts Amounts Amounts Amounts Amounts Amounts Amounts Amounts -$ -$ -$ -$ -$ -$ -$ -$ -$ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 4,000,000 - - - - - - - - 10,000 - - - - - - - - 2,510,000 - - - - - - - - 30,000 - - - - - - - - 250,000 - - - - - - - - 100,000 - - - - - - - - 250,000 - - - - - - - - 100,000 - - - - - - - - 15,000 - - - - - - - - 25,000 - - - - - - - - 20,000 - - - - - - - - 10,000 - - - - - - - - 60,000 - - - - - - - - 14,000 - - - - - - - - 10,000 - - - - - - - - 15,000 - - - - - - - - 15,000 - - - - - - - - 35,000 - - - - - - - - 25,000 - - - - - - - - 15,000 - - - - - - - - 10,000 - - - - - - - - 50,000 - - - - - - - - 100,000 - - - - - - - - 5,000 - - - - - - - - 50,000 - - - - - - - - 290,000 - - - - - - - - 25,000 - - - - - - - - 15,000 - - - - - - - - 35,000 - - - - - - - - 80,000 - - - - - - - - 35,000 - - - - - - - - 80,000 - - - - - - - - 59 City of Crystal, Minnesota Capital Improvement Plan - Building Fund 408/625 Schedule of Planned Capital Outlay 2020 to 2031 (Continued) 2020 2021 2022 Business Unit Year to Budgeted Proposed Proposed Department Object Code Subledger Replace Item Cost Amounts Amounts Amounts Community Center 0625.6940 TBA 2024 Replace floor scrubber 15,000$ -$ -$ -$ Aquatic building 0625.6940 TBA 2024 Install fiberglass doors in chemical areas (3)25,000 - - - City Buildings 0625.6940 TBA 2024 Lighting upgrade to LED at City Hall, including chambers 40,000 - - - City Buildings 0625.6940 TBA 2024 Replace can lighting in entire building 60,000 - - - City Buildings 0625.6940 TBA 2024 Replace popcorn ceiling in Council Chambers 30,000 - - - City Buildings 0625.6940 TBA 2024 Replace/improve to downstairs IT room (AC unit)15,000 - - - Community Center 0625.6940 TBA 2024 Replace Refrigerator/refrigerator 12,000 - - - Community Center 0625.6940 TBA 2024 Building Automation updates 100,000 - - - North Fire Station 0625.6940 TBA 2024 Replace generator 25,000 - - - North Fire Station 0625.6940 TBA 2024 Upgrade emergency/exit lighting 5,000 - - - Pool 0625.6940 TBA 2024 Replace waterwalk pads (5 floats)20,000 - - - City Buildings 0625.6940 TBA 2024 Replace NO/CO sensors 5,000 - - - South Fire Station 0625.6940 TBA 2024 Replace generator 15,000 - - - City Buildings 0625.6940 TBA 2024 Replace NO/CO sensors 5,000 - - - South Fire Station 0625.6940 TBA 2024 Replace Parking lot (concrete pad)60,000 - - - North Lions Park 0625.6940 TBA 2024 Replace West Parking lot asphalt 290,000 - - - City Buildings 0625.6940 TBA 2025 Replace water heater 25,000 - - - Aquatic Building 0625.6940 TBA 2025 Replace bathroom fixtures 25,000 - - - Aquatic Building 0625.6940 TBA 2025 Replace hand dryers 10,000 - - - Aquatic Building 0625.6940 TBA 2025 Replace security lighting 10,000 - - - Aquatic Building 0625.6940 TBA 2025 Replace staff office furniture 25,000 - - - Aquatic Building 0625.6940 TBA 2025 Upgrade emergency/exit lighting 5,000 - - - Bassett Creek Park 0625.6940 TBA 2025 ADA park building drinking fountain upgrades 15,000 - - - Bassett Creek Park 0625.6940 TBA 2025 ADA park shelter restroom upgrades 25,000 - - - Bassett Creek Park 0625.6940 TBA 2025 Electrical upgrades 25,000 - - - Bassett Creek Park 0625.6940 TBA 2025 Paint exterior building 18,000 - - - Bassett Creek Park 0625.6940 TBA 2025 Replace water heater 10,000 - - - City Buildings 0625.6940 TBA 2025 Elevator rehab 100,000 - - - City Buildings 0625.6940 TBA 2025 Replace Air Handler 150,000 - - - City Buildings 0625.6940 TBA 2025 Replace toilets and urinals 35,000 - - - Community Center 0625.6940 TBA 2025 Re-key building 100,000 - - - Community Center 0625.6940 TBA 2025 Bring CCC restrooms up to ADA code 50,000 - - - Old Utilities bldg 0625.6940 TBA 2025 Replace heating system and thermostat 51,000 - - - Pool 0625.6940 TBA 2025 Concrete repairs 50,000 - - - Pool 0625.6940 TBA 2025 Reline drop slides 75,000 - - - Pool 0625.6940 TBA 2025 Replace flooring on zero depth 75,000 - - - Public Works 0625.6940 TBA 2025 Fob access all doors 35,000 - - - Fire Department 0625.6941 TBA 2025 Replace exterior doors- south Fire Station 50,000 - - - Pool 0625.6940 TBA 2026 Replace cargo net 10,000 - - - Aquatic building 0625.6940 TBA 2026 Paint interior 19,000 - - - Aquatic building 0625.6940 TBA 2026 Replace heaters- building 45,000 - - - Aquatic building 0625.6940 TBA 2026 Replace sound system 20,000 - - - City Buildings 0625.6940 TBA 2026 Paint interior 60,000 - - - City Buildings 0625.6940 TBA 2026 Upgrade Generator 250,000 - - - Community Center 0625.6940 TBA 2026 Replace Carpet 30,000 - - - Community Center 0625.6940 TBA 2026 Window film- heat reducing all building 30,000 - - - City Buildings 0625.6940 TBA 2026 Replace restroom fixtures 10,000 - - - City Buildings 0625.6940 TBA 2026 Replacing upstairs ceiling 25,000 - - - Valley Place Park 0625.6940 TBA 2026 Replace furnace / thermostat 11,000 - - - Becker Park 0625.6940 TBA 2026 Replace Parking lot 300,000 - - - Community Center 0625.6940 TBA 2027 Divider Wall- gyms 40,000 - - - Community Center 0625.6940 TBA 2027 Replace Volleyball Standards/ref stands 15,000 - - - Pool 0625.6940 TBA 2028 Replace sun sail shade cover 19,000 - - - Valley Place Park 0625.6940 TBA 2028 Replace water heater 10,000 - - - Aquatic building 0625.6940 TBA 2028 Tuck pointing 25,000 - - - City Buildings 0625.6940 TBA 2028 Building wide public address system 75,000 - - - City Buildings 0625.6940 TBA 2028 Replace/relocate motion sensors for lights 10,000 - - - City Buildings 0625.6940 TBA 2028 Upgrade life safety systems 100,000 - - - Community Center 0625.6940 TBA 2028 Replace ovens 18,000 - - - Community Center 0625.6940 TBA 2028 Bring kitchen up to current code at CCC 150,000 - - - Pool 0625.6940 TBA 2028 Paint drop slide and water slide super structure 65,000 - - - Pool 0625.6940 TBA 2028 Replace drain covers 25,000 - - - Fire Department 0625.6940 TBA 2028 Replace exterior windows 200,000 - - - Fire Department 0625.6940 TBA 2028 Replace roof at North Fire Station 100,000 - - - 60 2023 2024 2025 2026 2027 2028 2029 2030 2031 Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated Amounts Amounts Amounts Amounts Amounts Amounts Amounts Amounts Amounts -$ 15,000$ -$ -$ -$ -$ -$ -$ -$ - 25,000 - - - - - - - - 40,000 - - - - - - - - 60,000 - - - - - - - - 30,000 - - - - - - - - 15,000 - - - - - - - - 12,000 - - - - - - - - 100,000 - - - - - - - - 25,000 - - - - - - - - 5,000 - - - - - - - - 20,000 - - - - - - - - 5,000 - - - - - - - - 15,000 - - - - - - - - 5,000 - - - - - - - - 60,000 - - - - - - - - 290,000 - - - - - - - - - 25,000 - - - - - - - - 25,000 - - - - - - - - 10,000 - - - - - - - - 10,000 - - - - - - - - 25,000 - - - - - - - - 5,000 - - - - - - - - 15,000 - - - - - - - - 25,000 - - - - - - - - 25,000 - - - - - - - - 18,000 - - - - - - - - 10,000 - - - - - - - - 100,000 - - - - - - - - 150,000 - - - - - - - - 35,000 - - - - - - - - 100,000 - - - - - - - - 50,000 - - - - - - - - 51,000 - - - - - - - - 50,000 - - - - - - - - 75,000 - - - - - - - - 75,000 - - - - - - - - 35,000 - - - - - - - - 50,000 - - - - - - - - - 10,000 - - - - - - - - 19,000 - - - - - - - - 45,000 - - - - - - - - 20,000 - - - - - - - - 60,000 - - - - - - - - 250,000 - - - - - - - - 30,000 - - - - - - - - 30,000 - - - - - - - - 10,000 - - - - - - - - 25,000 - - - - - - - - 11,000 - - - - - - - - 300,000 - - - - - - - - - 40,000 - - - - - - - - 15,000 - - - - - - - - - 19,000 - - - - - - - - 10,000 - - - - - - - - 25,000 - - - - - - - - 75,000 - - - - - - - - 10,000 - - - - - - - - 100,000 - - - - - - - - 18,000 - - - - - - - - 150,000 - - - - - - - - 65,000 - - - - - - - - 25,000 - - - - - - - - 200,000 - - - - - - - - 100,000 - - - 61 City of Crystal, Minnesota Capital Improvement Plan - Building Fund 408/625 Schedule of Planned Capital Outlay 2020 to 2031 (Continued) 2020 2021 2022 Business Unit Year to Budgeted Proposed Proposed Department Object Code Subledger Replace Item Cost Amounts Amounts Amounts Community Center 0625.6940 TBA 2029 Update Minnesota room 75,000$ -$ -$ -$ City Buildings 0625.6940 TBA 2029 Re-key building 50,000 - - - City Buildings 0625.6940 TBA 2029 Replace all window treatments 100,000 - - - Fire Department 0625.6940 TBA 2029 Improve upstairs ventilation 40,000 - - - Public Works 0625.6940 TBA 2029 Re-key building 25,000 - - - Fire Department 0625.6940 TBA 2029 Replace exterior doors 50,000 - - - Public Works 0625.6940 TBA 2029 Paint exterior building 25,000 - - - Public Works 0625.6940 TBA 2029 Re-key building 50,000 - - - Public Works 0625.6940 TBA 2029 Replace skylights 50,000 - - - City Buildings 0625.6940 TBA 2029 Replace asphalt with concrete in bins 50,000 - - - City Buildings 0625.6940 TBA 2029 Replace parking lot asphalt 50,000 Public Works 0625.6940 TBA 2029 Service door replacement 3,000 - - - City Buildings 0625.6940 TBA 2029 Fob access all doors 25,000 - - - Valley Place Park 0625.6940 TBA 2029 Re-key building 5,000 - - - Valley Place Park 0625.6940 TBA 2029 Fob access all doors 25,000 - - - Valley Place Park 0625.6940 TBA 2029 Replace exterior lighting controls 5,000 - - - Valley Place Park 0625.6940 TBA 2029 Replace exterior windows 50,000 - - - Welcome Park 0625.6940 TBA 2029 Re-key building 5,000 - - - Welcome Park 0625.6940 TBA 2029 Fob access all doors 25,000 - - - Pool 0625.6941 TBA 2029 Replace Diving Board 12,000 - - - Pool 0625.6941 TBA 2029 Replace Diving Board stand 10,000 Pool 0625.6941 TBA 2029 Paint raised walkway/ dropslide structure 25,000 - - - North Lions Park 0625.6940 TBA 2029 Fob access all doors 25,000 - - - North Lions Park 0625.6940 TBA 2029 Paint exterior building 20,000 - - - North Lions Park 0625.6940 TBA 2029 Re-key building 5,000 - - - North Lions Park 0625.6940 TBA 2029 Tuck pointing 40,000 - - - City Buildings 0625.6940 TBA 2030 Replace exterior windows 450,000 - - - Aquatic building 0625.6940 TBA 2030 Fob access all doors 25,000 - - - City Buildings 0625.6940 TBA 2030 Install building security system 50,000 - - - City Buildings 0625.6940 TBA 2030 Paint exterior building 100,000 - - - City Buildings 0625.6940 TBA 2030 Replace finance safe with building-integrated safe 10,000 - - - City Buildings 0625.6940 TBA 2030 Re-roof entire building 250,000 - - - Community Center 0625.6940 TBA 2030 Upgrade building safety systems 75,000 - - - Community Center 0625.6940 TBA 2030 Paint interior- meeting rooms 30,000 - - - Community Center 0625.6940 TBA 2030 Replace roof 225,000 - - - Community Center 0625.6940 TBA 2030 Tuckpointing 50,000 - - - Community Center 0625.6940 TBA 2030 Fob access all doors 25,000 - - - Community Center 0625.6940 TBA 2030 Replace bathroom fixtures 50,000 - - - Fire Department 0625.6940 TBA 2030 ADA restroom upgrades 25,000 - - - City Buildings 0625.6940 TBA 2030 Paint interior 30,000 - - - North Lions Park 0625.6940 TBA 2030 Replace exterior windows 75,000 - - - Pool 0625.6940 TBA 2030 Replace lounge chairs 15,000 - - - Pool 0625.6940 TBA 2030 Replace water play feature 50,000 - - - Pool 0625.6940 TBA 2030 Replace main pumps (2)50,000 - - - Pool 0625.6940 TBA 2030 Replace landscaping 50,000 - - - Public Works 0625.6940 TBA 2030 Exterior touch up paint 35,000 - - - Public Works 0625.6940 TBA 2030 Exterior touch up paint 25,000 - - - Fire Department 0625.6940 TBA 2030 Do something in downstairs training area 50,000 - - - Fire Department 0625.6940 TBA 2030 Exterior repair 125,000 - - - Fire Department 0625.6940 TBA 2030 Upgrade life safety systems 100,000 - - - Fire Department 0625.6940 TBA 2031 Install eyewash station at North Fire station 10,000 - - - Fire Department 0625.6940 TBA 2031 Install railing on roof by access door at North Fire 15,000 - - - Fire Department 0625.6940 TBA 2031 Replace entry door heater (in wall)15,000 - - - Public Works 0625.6940 TBA 2031 Replace pressure washer 20,000 - - - 526,500$ 6,829,000$ 10,410,000$ 62 2023 2024 2025 2026 2027 2028 2029 2030 2031 Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated Amounts Amounts Amounts Amounts Amounts Amounts Amounts Amounts Amounts -$ -$ -$ -$ -$ -$ 75,000$ -$ -$ - - - - - - 50,000 - - - - - - - - 100,000 - - - - - - - - 40,000 - - - - - - - - 25,000 - - - - - - - - 50,000 - - - - - - - - 25,000 - - - - - - - - 50,000 - - - - - - - - 50,000 - - - - - - - - 50,000 - - - - - - - - 3,000 - - - - - - - - 25,000 - - - - - - - - 5,000 - - - - - - - - 25,000 - - - - - - - - 5,000 - - - - - - - - 50,000 - - - - - - - - 5,000 - - - - - - - - 25,000 - - - - - - - - 12,000 - - - - - - - - 25,000 - - - - - - - - 25,000 - - - - - - - - 20,000 - - - - - - - - 5,000 - - - - - - - - 40,000 - - - - - - - - - 450,000 - - - - - - - - 25,000 - - - - - - - - 50,000 - - - - - - - - 100,000 - - - - - - - - 10,000 - - - - - - - - 250,000 - - - - - - - - 75,000 - - - - - - - - 30,000 - - - - - - - - 225,000 - - - - - - - - 50,000 - - - - - - - - 25,000 - - - - - - - - 50,000 - - - - - - - - 25,000 - - - - - - - - 30,000 - - - - - - - - 75,000 - - - - - - - - 15,000 - - - - - - - - 50,000 - - - - - - - - 50,000 - - - - - - - - 50,000 - - - - - - - - 35,000 - - - - - - - - 25,000 - - - - - - - - 50,000 - - - - - - - - 125,000 - - - - - - - - 100,000 - - - - - - - - - 10,000 - - - - - - - - 15,000 - - - - - - - - 15,000 - - - - - - - - 20,000 8,284,000$ 722,000$ 964,000$ 810,000$ 55,000$ 797,000$ 785,000$ 1,970,000$ 60,000$ 63 City of Crystal, Minnesota Capital Improvement Plan - Building Fund 408/625 Schedule of Projected Revenue, Expenditures and Debt 2020 2021 2022 Actual Proposed Proposed Revenues Property taxes (4% increase annually in 2021 - 2026, 0% increase thereafter)1,072,295$ -$ -$ Internal charges (1% increase in 2022 - 2023, 0% increase thereafter)1,323,092 1,467,403 Interest on investments 155,733 30,000 10,000 Intergovernmental revenue (local government aid, 0% increase projected)556,756 4,323,888 323,888 Miscellaneous 13,998 - - Total Revenues 1,798,782 5,676,980 1,801,291 Expenditures Capital outlay City Buildings 1,287,263 100,000 498,000 Community Center - 984,000 1,475,000 Aquatic Building - 10,000 - Public Safety - - - Public Works - - 32,000 Salt Building - - - Pool - 110,000 - Fire Department - 195,000 - Police - 5,250,000 8,000,000 Parks & Recreation - - - Bassett Creek Park - - 385,000 Becker Park - - - North Fire Station - - - South Fire Station - - - North Lions Park - 20,000 15,000 Valley Place Park - 130,000 - Bass Lake - - - Old utilities bldg - - 5,000 Welcome Park - 30,000 - Total Expenditures 1,287,263 6,829,000 10,410,000 Excess (Deficiency) of Revenues Over (Under) Expenditures 511,519 (1,152,020) (8,608,709) Other Financing Sources Bond proceeds - - 5,000,000 Internal Loan from Street Fund - - 600,000 Internal Loan from Police Revolving Fund - 1,200,000 - Internal Loan from Park Improvement Fund - - 450,000 Internal Loan from Storm Water - - 1,000,000 Internal Loan from IT - - 500,000 Internal Loan from Water Internal Loan repayment to Street Fund - - - Internal Loan repayment to Police Revolving Fund - - - Internal Loan repayment to Park Improvement Fund - - - Internal Loan repayment to Storm Water - - - Internal Loan repayment to IT - - - Internal Loan repayment to Water Transfers in - - - Total Other Financing Sources - 1,200,000 7,550,000 Net Change in Fund Balances 511,519 47,980 (1,058,709) Cash Balances, January 1 4,223,721 4,735,240 4,783,220 Cash Balances, December 31 4,735,240$ 4,783,220$ 3,724,511$ Internal Service Fund Projected Activity 64 2023 2024 2025 2026 2027 2028 2029 2030 2031 Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated -$ -$ -$ -$ -$ -$ -$ -$ -$ 1,482,077 1,496,898 1,511,867 1,526,985 1,542,255 1,557,678 1,573,255 1,588,987 1,604,877 37,245 837 9,833 10,649 18,515 31,461 32,821 33,571 30,936 323,888 323,888 323,888 323,888 323,888 323,888 323,888 323,888 323,888 - - - - - - - - - 1,843,210 1,821,623 1,845,588 1,861,523 1,884,658 1,913,027 1,929,964 1,946,446 1,959,701 224,000 155,000 310,000 345,000 - 185,000 225,000 890,000 - 245,000 127,000 150,000 60,000 55,000 168,000 75,000 455,000 - 545,000 25,000 75,000 84,000 - 25,000 - 25,000 - - - - - - - - - - 35,000 - 35,000 - - - 153,000 60,000 20,000 10,000 - - - - - - - - 2,920,000 20,000 200,000 10,000 - 109,000 37,000 165,000 - - - 50,000 - - 300,000 90,000 300,000 40,000 4,000,000 - - - - - - - - - - - - - - - - - - - 93,000 - - - - - - - - - 300,000 - - - - - - 30,000 - - - - - - - - 75,000 - - - - - - - - 290,000 - - - - 90,000 75,000 - 250,000 - - 11,000 - 10,000 85,000 - - - - - - - - - - - - - 51,000 - - - - - - 55,000 - - - - - 30,000 - - 8,284,000 722,000 964,000 810,000 55,000 797,000 785,000 1,970,000 60,000 (6,440,790) 1,099,623 881,588 1,051,523 1,829,658 1,116,027 1,144,964 (23,554) 1,899,701 - - - - - - - - - - - - - - - - - - 1,150,000 - - - - - - - - - - - - - - - - - - - - - 150,000 - (100,000) (100,000) (100,000) (100,000) (250,000) - - 1,500,000 - - 250,000 250,000 250,000 250,000 250,000 250,000 - (200,000) (200,000) (200,000) - - - - - - - (250,000) (115,000) (115,000) (710,000) (650,000) (320,000) (190,000) - - - - (300,000) (150,000) - - - - - (150,000) - (170,000) (170,000) (170,000) (170,000) (170,000) - - (100,000) (100,000) (100,000) (100,000) (250,000) - - - - - - - - - - - - 2,800,000 (200,000) (800,000) (265,000) (535,000) (980,000) (1,070,000) (240,000) (110,000) (3,640,790) 899,623 81,588 786,523 1,294,658 136,027 74,964 (263,554) 1,789,701 3,724,511 83,721 983,344 1,064,932 1,851,455 3,146,113 3,282,140 3,357,104 3,093,550 83,721$ 983,344$ 1,064,932$ 1,851,455$ 3,146,113$ 3,282,140$ 3,357,104$ 3,093,550$ 4,883,251$ Internal Service Fund Projected Activity 65 City of Crystal, Minnesota Capital Improvement Plan - Information Technology Fund 620 Schedule of Planned Capital Outlay 2020 to 2031 2020 2021 2022 Business Unit Year to Budgeted Proposed Proposed Department Object Code Subledger Replace Item Cost Amounts Amounts Amounts Information Technology 0620.6940 TBA 2020 Robbinsdale SD - Potential Replacement 18,833$ 18,833$ -$ -$ Information Technology 0620.6940 TBA 2020 Computer Hardware & Software 57,500 57,500 - - Information Technology 0620.6940 TBA 2020 Catalyst 3650 Fiber Switch 3,782 3,782 - - Information Technology 0620.6940 TBA 2020 City Hall Switch 2 - 48 Port POE 9,133 9,133 - - Information Technology 0620.6940 TBA 2020 City Hall Switch 3 - 48 port POE 9,133 9,133 - - Information Technology 0620.6940 TBA 2020 City Hall Switch 4 - 48 Port POE 8,081 8,081 - - Information Technology 0620.6940 TBA 2020 WiFi AP - PD Investigations 845 845 - - Information Technology 0620.6940 TBA 2020 Multi-Function Printer - Copy Room 9,000 9,000 - - Information Technology 0620.6940 TBA 2020 Multi-Function Printer - Finance 7,500 7,500 - - Information Technology 0620.6940 TBA 2020 Networked Department Printers 800 800 - - Information Technology 0620.6940 TBA 2020 Public Works Switch - 48 Port POE 9,133 9,133 - - Information Technology 0620.6940 TBA 2020 PW Switch - 24 Port POE (Pumphouse)3,682 3,682 - - Information Technology 0620.6940 TBA 2020 WiFi AP - PW Office 845 845 - - Information Technology 0620.6940 TBA 2020 WiFi AP - PW Garage East 845 845 - - Information Technology 0620.6940 TBA 2020 WiFi AP - PW Garage West 845 845 - - Information Technology 0620.6940 TBA 2020 Networked Department Printers 800 800 - - Information Technology 0620.6940 TBA 2020 Networked Department Printers 800 800 - - Information Technology 0620.6940 TBA 2020 Door Readers - Public Works (7)10,000 10,000 - - Information Technology 0620.6940 TBA 2020 Access Control Maintenance & Updates 6,000 6,000 - - Information Technology 0620.6940 TBA 2020 Council Chamber Door Security 6,500 6,500 - - Information Technology 0620.6940 TBA 2020 Audio Update - A/B Room 15,000 15,000 - - Information Technology 0620.6940 TBA 2021 Robbinsdale SD - Potential Replacement 18,833 - 18,833 - Information Technology 0620.6940 TBA 2021 Computer Hardware & Software 60,000 - 60,000 - Information Technology 0620.6940 TBA 2021 WiFi AP - Emergency Ops Center 732 - 732 - Information Technology 0620.6940 TBA 2021 Network Firewall ASA 5,365 - 5,365 - Information Technology 0620.6940 TBA 2021 WiFi AP - Conference A 732 - 732 - Information Technology 0620.6940 TBA 2021 WiFi AP - Cable Room 732 - 732 - Information Technology 0620.6940 TBA 2021 WiFi AP - Server Room 732 - 732 - Information Technology 0620.6940 TBA 2021 Multi-Function Printer - Police 12,000 - 12,000 - Information Technology 0620.6940 TBA 2021 Networked Department Printers 800 - 800 - Information Technology 0620.6940 TBA 2021 CCC Switch - 48 Port POE 6,937 - 6,937 - Information Technology 0620.6940 TBA 2021 WiFi AP - CCC AB Room 732 - 732 - Information Technology 0620.6940 TBA 2021 WiFi AP - CCC Activity Room 732 - 732 - Information Technology 0620.6940 TBA 2021 Multi-Function Printer - CCC 15,000 - 15,000 - Information Technology 0620.6940 TBA 2021 PW DVR Server 7,500 - 7,500 - Information Technology 0620.6940 TBA 2021 Building Security Upgrade/Repair/Replace 17,500 - 17,500 - Information Technology 0620.6940 TBA 2021 Building Access Control Upgrade/Repair/Rplc 25,000 - 25,000 - Information Technology 0620.6940 TBA 2021 REC - Conf Room Camera 2,000 - 2,000 - Information Technology 0620.6940 TBA 2021 REC - Mobile WebTrac 2,750 - 2,750 - Information Technology 0620.6940 TBA 2021 Utility/Lift Station Fiber 100,000 - 100,000 - Information Technology 0620.6940 TBA 2021 Canon Laserfiche Scanner 6,500 - 6,500 - Information Technology 0620.6940 TBA 2022 Networked Department Printers 800 - - 800 Information Technology 0620.6940 TBA 2022 Multi-Function Printer - Public Works 7,500 - - 7,500 Information Technology 0620.6940 TBA 2022 Large Format Plotter/Scanner 10,000 - - 10,000 Information Technology 0620.6940 TBA 2022 Building Security Upgrade/Repair/Replace 25,000 - - 25,000 Information Technology 0620.6940 TBA 2022 Building Access Control Upgrade/Repair/Rplc 25,000 - - 25,000 Information Technology 0620.6940 TBA 2022 Robbinsdale SD - Potential Replacement 18,833 - - 18,833 Information Technology 0620.6940 TBA 2022 Computer Hardware & Software 62,500 - - 62,500 Information Technology 0620.6940 TBA 2022 City Hall Switch - 24 Port | LOGIS 4,703 - - 4,703 Information Technology 0620.6940 TBA 2022 WiFi AP's - Crystal Cove (New)6,000 - - 6,000 Information Technology 0620.6940 TBA 2022 FIN - Tungsten to Laserfiche 3,000 - - 3,000 Information Technology 0620.6940 TBA 2022 Utility/Lift Station Fiber 100,000 - - 100,000 Information Technology 0620.6940 TBA 2023 Robbinsdale SD - Potential Replacement 18,833 - - - Information Technology 0620.6940 TBA 2023 Fiber Improvement & Adds 20,000 - - - Information Technology 0620.6940 TBA 2023 Computer Hardware & Software 65,000 - - - Information Technology 0620.6940 TBA 2023 Multi-Function Printer - ComDev 7,500 - - - Information Technology 0620.6940 TBA 2023 Networked Department Printers 800 - - - Information Technology 0620.6940 TBA 2023 Network Firewall ASA 5,252 - - - Information Technology 0620.6940 TBA 2023 Public Works Switch - 24 Port | LOGIS 4,703 - - - Information Technology 0620.6940 TBA 2023 Police Cellebrite Hardware 3,000 - - - Information Technology 0620.6940 TBA 2023 Building Security Upgrade/Repair/Replace 25,000 - - - Information Technology 0620.6940 TBA 2023 Building Access Control Upgrade/Repair/Rplc 25,000 - - - Information Technology 0620.6940 TBA 2024 Becker Park 24P POE Switch 3,715 - - - Information Technology 0620.6940 TBA 2024 Becker Park Outdoor AP & Antennas 1,770 - - - Information Technology 0620.6940 TBA 2024 Robbinsdale SD - Potential Replacement 18,833 - - - Information Technology 0620.6940 TBA 2024 Fiber Improvement & Adds 20,000 - - - Information Technology 0620.6940 TBA 2024 Computer Hardware & Software 55,000 - - - Information Technology 0620.6940 TBA 2024 City Hall Switch 1 - 48 Port POE 9,605 - - - Information Technology 0620.6940 TBA 2024 City Hall Switch 5 - 48 Port POE 11,128 - - - Information Technology 0620.6940 TBA 2024 Networked Department Printers 800 - - - Information Technology 0620.6940 TBA 2024 Pool Switch - 24 Port POE 3,141 - - - Information Technology 0620.6940 TBA 2024 WiFi AP - CCC Office 902 - - - Information Technology 0620.6940 TBA 2024 CH & PD DVR Server 10,000 - - - Information Technology 0620.6940 TBA 2024 Access Control Server 3,000 - - - Information Technology 0620.6940 TBA 2024 Building Security Upgrade/Repair/Replace 15,000 - - - Information Technology 0620.6940 TBA 2024 Building Access Control Upgrade/Repair/Rplc 22,000 - - - Information Technology 0620.6940 TBA 2025 6612 41st Lift Station Switch 4,890 - - - Information Technology 0620.6940 TBA 2025 4648 Tower Switch 4,360 - - - Information Technology 0620.6940 TBA 2025 Robbinsdale SD - Potential Replacement 18,833 - - - Information Technology 0620.6940 TBA 2025 Fiber Improvement & Adds 20,000 - - - Information Technology 0620.6940 TBA 2025 VOIP & VM Server Replacement 100,000 - - - Information Technology 0620.6940 TBA 2025 Computer Hardware & Software 57,500 - - - Information Technology 0620.6940 TBA 2025 City Hall Switch 2 - 48 Port POE 8,021 - - - Information Technology 0620.6940 TBA 2025 City Hall Switch 3 - 48 port POE 8,757 - - - Information Technology 0620.6940 TBA 2025 City Hall Switch 4 - 48 Port POE 7,345 - - - Information Technology 0620.6940 TBA 2025 WiFi AP - PD Investigations 845 - - - 66 2023 2024 2025 2026 2027 2028 2029 2030 2031 Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated Amounts Amounts Amounts Amounts Amounts Amounts Amounts Amounts Amounts -$ -$ -$ -$ -$ -$ -$ -$ -$ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 18,833 - - - - - - - - 20,000 - - - - - - - - 65,000 - - - - - - - - 7,500 - - - - - - - - 800 - - - - - - - - 5,252 - - - - - - - - 4,703 - - - - - - - - 3,000 - - - - - - - - 25,000 - - - - - - - - 25,000 - - - - - - - - - 3,715 - - - - - - - - 1,770 - - - - - - - - 18,833 - - - - - - - - 20,000 - - - - - - - - 55,000 - - - - - - - - 9,605 - - - - - - - - 11,128 - - - - - - - - 800 - - - - - - - - 3,141 - - - - - - - - 902 - - - - - - - - 10,000 - - - - - - - - 3,000 - - - - - - - - 15,000 - - - - - - - - 22,000 - - - - - - - - - 4,890 - - - - - - - - 4,360 - - - - - - - - 18,833 - - - - - - - - 20,000 - - - - - - - - 100,000 - - - - - - - - 57,500 - - - - - - - - 8,021 - - - - - - - - 8,757 - - - - - - - - 7,345 - - - - - - - - 845 - - - - - - 67 City of Crystal, Minnesota Capital Improvement Plan - Information Technology Fund 620 Schedule of Planned Capital Outlay 2020 to 2031 (Continued) 2020 2021 2022 Year to Budgeted Proposed Proposed Department Replace Item Cost Amounts Amounts Amounts Information Technology 0620.6940 TBA 2025 Multi-Function Printer - FINANCE 9,000 - - - Information Technology 0620.6940 TBA 2025 Multi-Function Printer - CCC 7,500 - - - Information Technology 0620.6940 TBA 2025 Networked Department Printers 800 - - - Information Technology 0620.6940 TBA 2025 Public Works Switch - 48 Port POE 6,937 - - - Information Technology 0620.6940 TBA 2025 PW Switch - 24 Port POE (Pumphouse)4,250 - - - Information Technology 0620.6940 TBA 2025 WiFi AP - PW Office 845 - - - Information Technology 0620.6940 TBA 2025 WiFi AP - PW Garage East 845 - - - Information Technology 0620.6940 TBA 2025 WiFi AP - PW Garage West 845 - - - Information Technology 0620.6940 TBA 2025 Networked Department Printers 800 - - - Information Technology 0620.6940 TBA 2025 Networked Department Printers 800 - - - Information Technology 0620.6940 TBA 2025 CCC DVR Server 10,000 - - - Information Technology 0620.6940 TBA 2025 Building Security Upgrade/Repair/Replace 15,000 - - - Information Technology 0620.6940 TBA 2025 Building Access Control Upgrade/Repair/Rplc 25,000 - - - Information Technology 0620.6940 TBA 2026 Lift Station Switch HW (5825, 6125, 3203, 3000)19,600 - - - Information Technology 0620.6940 TBA 2026 Robbinsdale SD - Potential Replacement 18,833 - - - Information Technology 0620.6940 TBA 2026 Fiber Improvement & Adds 20,000 - - - Information Technology 0620.6940 TBA 2026 VOIP Phone Hardware 40,000 - - - Information Technology 0620.6940 TBA 2026 Computer Hardware & Software 60,000 - - - Information Technology 0620.6940 TBA 2026 WiFi AP - Emergency Ops Center 732 - - - Information Technology 0620.6940 TBA 2026 Network Firewall ASA 5,365 - - - Information Technology 0620.6940 TBA 2026 WiFi AP - Conference A 732 - - - Information Technology 0620.6940 TBA 2026 WiFi AP - Cable Room 732 - - - Information Technology 0620.6940 TBA 2026 WiFi AP - Server Room 732 - - - Information Technology 0620.6940 TBA 2026 Multi-Function Printer - Police 12,000 - - - Information Technology 0620.6940 TBA 2026 Networked Department Printers 800 - - - Information Technology 0620.6940 TBA 2026 CCC Switch - 48 Port POE 6,937 - - - Information Technology 0620.6940 TBA 2026 WiFi AP - CCC AB Room 732 - - - Information Technology 0620.6940 TBA 2026 WiFi AP - CCC Activity Room 732 - - - Information Technology 0620.6940 TBA 2026 Multi-Function Printer - City Hall 15,000 - - - Information Technology 0620.6940 TBA 2026 PW DVR Server 7,500 - - - Information Technology 0620.6940 TBA 2026 Building Security Upgrade/Repair/Replace 25,000 - - - Information Technology 0620.6940 TBA 2026 Building Access Control Upgrade/Repair/Rplc 25,000 - - - Information Technology 0620.6940 TBA 2027 Robbinsdale SD - Potential Replacement 18,833 - - - Information Technology 0620.6940 TBA 2027 Fiber Improvement & Adds 20,000 - - - Information Technology 0620.6940 TBA 2027 Multi-Function Printer - Public Works 7,500 - - - Information Technology 0620.6940 TBA 2027 Networked Department Printers 800 - - - Information Technology 0620.6940 TBA 2027 Large Format Plotter/Scanner 10,000 - - - Information Technology 0620.6940 TBA 2027 Building Security Upgrade/Repair/Replace 25,000 - - - Information Technology 0620.6940 TBA 2027 Building Access Control Upgrade/Repair/Rplc 25,000 - - - Information Technology 0620.6940 TBA 2027 Robbinsdale SD - Potential Replacement 18,833 - - - Information Technology 0620.6940 TBA 2027 Computer Hardware & Software 62,500 - - - Information Technology 0620.6940 TBA 2027 City Hall Switch - 24 Port | LOGIS 4,703 - - - Information Technology 0620.6940 TBA 2027 WiFi AP's - Crystal Cove (New)6,000 - - - Information Technology 0620.6940 TBA 2027 WiFi AP - PD External 3,693 - - - Information Technology 0620.6940 TBA 2028 Robbinsdale SD - Potential Replacement 18,833 - - - Information Technology 0620.6940 TBA 2028 Fiber Improvement & Adds 20,000 - - - Information Technology 0620.6940 TBA 2028 Computer Hardware & Software 65,000 - - - Information Technology 0620.6940 TBA 2028 Multi-Function Printer - ComDev 7,500 - - - Information Technology 0620.6940 TBA 2028 Networked Department Printers 800 - - - Information Technology 0620.6940 TBA 2028 Network Firewall ASA 5,252 - - - Information Technology 0620.6940 TBA 2028 Public Works Switch - 24 Port | LOGIS 4,703 - - - Information Technology 0620.6940 TBA 2028 Police Cellebrite Hardware 3,000 - - - Information Technology 0620.6940 TBA 2028 Building Security Upgrade/Repair/Replace 25,000 - - - Information Technology 0620.6940 TBA 2028 Building Access Control Upgrade/Repair/Rplc 25,000 - - - Information Technology 0620.6940 TBA 2029 Becker Park 24P POE Switch 3,715 - - - Information Technology 0620.6940 TBA 2029 Becker Park Outdoor AP & Antennas 1,770 - - - Information Technology 0620.6940 TBA 2029 Robbinsdale SD - Potential Replacement 18,833 - - - Information Technology 0620.6940 TBA 2029 Fiber Improvement & Adds 20,000 - - - Information Technology 0620.6940 TBA 2029 Computer Hardware & Software 55,000 - - - Information Technology 0620.6940 TBA 2029 City Hall Switch 1 - 48 Port POE 9,605 - - - Information Technology 0620.6940 TBA 2029 City Hall Switch 5 - 48 Port POE 11,128 - - - Information Technology 0620.6940 TBA 2029 Wireless Controller - 25 AP License 5,459 - - - Information Technology 0620.6940 TBA 2029 Large Format Scanner 7,300 - - - Information Technology 0620.6940 TBA 2029 Networked Department Printers 800 - - - Information Technology 0620.6940 TBA 2029 Pool Switch - 24 Port POE 3,141 - - - Information Technology 0620.6940 TBA 2029 WiFi AP - CCC Office 902 - - - Information Technology 0620.6940 TBA 2029 CH & PD DVR Server 10,000 - - - Information Technology 0620.6940 TBA 2029 Access Control Server 3,000 - - - Information Technology 0620.6940 TBA 2029 Building Security Upgrade/Repair/Replace 15,000 - - - Information Technology 0620.6940 TBA 2029 Building Access Control Upgrade/Repair/Rplc 22,000 - - - Information Technology 0620.6940 TBA 2030 6612 41st Lift Station Switch 4,890 - - - Information Technology 0620.6940 TBA 2030 4648 Tower Switch 4,360 - - - Information Technology 0620.6940 TBA 2030 Robbinsdale SD - Potential Replacement 18,833 - - - Information Technology 0620.6940 TBA 2030 Fiber Improvement & Adds 20,000 - - - Information Technology 0620.6940 TBA 2030 Computer Hardware & Software 57,500 - - - Information Technology 0620.6940 TBA 2030 City Hall Switch 2 - 48 Port POE 8,021 - - - Information Technology 0620.6940 TBA 2030 City Hall Switch 3 - 48 port POE 8,757 - - - Information Technology 0620.6940 TBA 2030 City Hall Switch 4 - 48 Port POE 7,345 - - - Information Technology 0620.6940 TBA 2030 WiFi AP - PD Investigations 845 - - - Information Technology 0620.6940 TBA 2030 Multi-Function Printer - FINANCE 9,000 - - - Information Technology 0620.6940 TBA 2030 Multi-Function Printer - CCC 7,500 - - - Information Technology 0620.6940 TBA 2030 Networked Department Printers 800 - - - Information Technology 0620.6940 TBA 2030 Public Works Switch - 48 Port POE 6,937 - - - Information Technology 0620.6940 TBA 2030 PW Switch - 24 Port POE (Pumphouse)4,250 - - - Information Technology 0620.6940 TBA 2030 WiFi AP - PW Office 845 - - - Information Technology 0620.6940 TBA 2030 WiFi AP - PW Garage East 845 - - - Information Technology 0620.6940 TBA 2030 WiFi AP - PW Garage West 845 - - - Information Technology 0620.6940 TBA 2030 Networked Department Printers 800 - - - Information Technology 0620.6940 TBA 2030 Networked Department Printers 800 - - - Information Technology 0620.6940 TBA 2030 Access Control Maintenance & Updates 6,000 - - - 68 2023 2024 2025 2026 2027 2028 2029 2030 2031 Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated Amounts Amounts Amounts Amounts Amounts Amounts Amounts Amounts Amounts - - 9,000 - - - - - - - - 7,500 - - - - - - - - 800 - - - - - - - - 6,937 - - - - - - - - 4,250 - - - - - - - - 845 - - - - - - - - 845 - - - - - - - - 845 - - - - - - - - 800 - - - - - - - - 800 - - - - - - - - 10,000 - - - - - - - - 15,000 - - - - - - - - 25,000 - - - - - - - - - 19,600 - - - - - - - - 18,833 - - - - - - - - 20,000 - - - - - - - - 40,000 - - - - - - - - 60,000 - - - - - - - - 732 - - - - - - - - 5,365 - - - - - - - - 732 - - - - - - - - 732 - - - - - - - - 732 - - - - - - - - 12,000 - - - - - - - - 800 - - - - - - - - 6,937 - - - - - - - - 732 - - - - - - - - 732 - - - - - - - - 15,000 - - - - - - - - 7,500 - - - - - - - - 25,000 - - - - - - - - 25,000 - - - - - - - - - 18,833 - - - - - - - - 20,000 - - - - - - - - 7,500 - - - - - - - - 800 - - - - - - - - 10,000 - - - - - - - - 25,000 - - - - - - - - 25,000 - - - - - - - - 18,833 - - - - - - - - 62,500 - - - - - - - - 4,703 - - - - - - - - 6,000 - - - - - - - - 3,693 - - - - - - - - - 18,833 - - - - - - - - 20,000 - - - - - - - - 65,000 - - - - - - - - 7,500 - - - - - - - - 800 - - - - - - - - 5,252 - - - - - - - - 4,703 - - - - - - - - 3,000 - - - - - - - - 25,000 - - - - - - - - 25,000 - - - - - - - - - 3,715 - - - - - - - - 1,770 - - - - - - - - 18,833 - - - - - - - - 20,000 - - - - - - - - 55,000 - - - - - - - - 9,605 - - - - - - - - 11,128 - - - - - - - - 5,459 - - - - - - - - 7,300 - - - - - - - - 800 - - - - - - - - 3,141 - - - - - - - - 902 - - - - - - - - 10,000 - - - - - - - - 3,000 - - - - - - - - 15,000 - - - - - - - - 22,000 - - - - - - - - - 4,890 - - - - - - - - 4,360 - - - - - - - - 18,833 - - - - - - - - 20,000 - - - - - - - - 57,500 - - - - - - - - 8,021 - - - - - - - - 8,757 - - - - - - - - 7,345 - - - - - - - - 845 - - - - - - - - 9,000 - - - - - - - - 7,500 - - - - - - - - 800 - - - - - - - - 6,937 - - - - - - - - 4,250 - - - - - - - - 845 - - - - - - - - 845 - - - - - - - - 845 - - - - - - - - 800 - - - - - - - - 800 - - - - - - - - 6,000 - 69 City of Crystal, Minnesota Capital Improvement Plan - Information Technology Fund 620 Schedule of Planned Capital Outlay 2020 to 2031 (Continued) 2020 2021 2022 Year to Budgeted Proposed Proposed Department Replace Item Cost Amounts Amounts Amounts Information Technology 0620.6940 TBA 2030 CCTV System Adds & Improvements 6,500 - - - Information Technology 0620.6940 TBA 2030 CCC DVR Server 10,000 - - - Information Technology 0620.6940 TBA 2030 Building Security Upgrade/Repair/Replace 15,000 - - - Information Technology 0620.6940 TBA 2030 Building Access Control Upgrade/Repair/Rplc 25,000 - - - Information Technology 0620.6940 TBA 2031 Lift Station Switch HW (5825, 6125, 3203, 3000)19,600 - - - Information Technology 0620.6940 TBA 2031 Robbinsdale SD - Potential Replacement 18,833 - - - Information Technology 0620.6940 TBA 2031 Fiber Improvement & Adds 20,000 - - - Information Technology 0620.6940 TBA 2031 VOIP Phone Hardware 40,000 - - - Information Technology 0620.6940 TBA 2031 Computer Hardware & Software 60,000 - - - Information Technology 0620.6940 TBA 2031 WiFi AP - Emergency Ops Center 732 - - - Information Technology 0620.6940 TBA 2031 Network Firewall ASA 5,365 - - - Information Technology 0620.6940 TBA 2031 WiFi AP - Conference A 732 - - - Information Technology 0620.6940 TBA 2031 WiFi AP - Cable Room 732 - - - Information Technology 0620.6940 TBA 2031 WiFi AP - Server Room 732 - - - Information Technology 0620.6940 TBA 2031 Multi-Function Printer - Police 12,000 - - - Information Technology 0620.6940 TBA 2031 Networked Department Printers 800 - - - Information Technology 0620.6940 TBA 2031 CCC Switch - 48 Port POE 6,937 - - - Information Technology 0620.6940 TBA 2031 WiFi AP - CCC AB Room $732 - - - Information Technology 0620.6940 TBA 2031 WiFi AP - CCC Activity Room 732 - - - Information Technology 0620.6940 TBA 2031 Multi-Function Printer - City Hall 15,000 - - - Information Technology 0620.6940 TBA 2031 PW DVR Server 7,500 - - - Information Technology 0620.6940 TBA 2031 Building Security Upgrade/Repair/Replace 15,000 - - - Information Technology 0620.6940 TBA 2031 Building Access Control Upgrade/Repair/Rplc 25,000 - - - Information Technology 0620.6940 TBA 2032 Networked Department Printers 800 - - - Information Technology 0620.6940 TBA 2032 Multi-Function Printer - Public Works 7,500 - - - Information Technology 0620.6940 TBA 2032 Large Format Plotter/Scanner 10,000 - - - Information Technology 0620.6940 TBA 2032 Building Security Upgrade/Repair/Replace 25,000 - - - Information Technology 0620.6940 TBA 2032 Building Access Control Upgrade/Repair/Rplc 25,000 - - - Information Technology 0620.6940 TBA 2032 Robbinsdale SD - Potential Replacement 18,833 - - - Information Technology 0620.6940 TBA 2032 Computer Hardware & Software 64,000 - - - Information Technology 0620.6940 TBA 2032 City Hall Switch - 24 Port | LOGIS 4,703 - - - Information Technology 0620.6940 TBA 2032 WiFi AP's - Crystal Cove 6,000 - - - Information Technology 0620.6940 TBA 2032 Fiber Improvement & Adds 20,000 - - - 183,097$ 288,619$ 180,247$ 70 2023 2024 2025 2026 2027 2028 2029 2030 2031 Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated Amounts Amounts Amounts Amounts Amounts Amounts Amounts Amounts Amounts - - - - - - - 6,500 - - - - - - - - 10,000 - - - - - - - - 15,000 - - - - - - - - 25,000 - - - - - - - - - 19,600 - - - - - - - - 18,833 - - - - - - - - 20,000 - - - - - - - - 40,000 - - - - - - - - 60,000 - - - - - - - - 732 - - - - - - - - 5,365 - - - - - - - - 732 - - - - - - - - 732 - - - - - - - - 732 - - - - - - - - 12,000 - - - - - - - - 800 - - - - - - - - 6,937 - - - - - - - - 732 - - - - - - - - 732 - - - - - - - - 15,000 - - - - - - - - 7,500 - - - - - - - - 15,000 - - - - - - - - 25,000 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 179,134$ 178,942$ 317,223$ 264,479$ 206,916$ 179,144$ 191,711$ 229,733$ 254,489$ 71 City of Crystal, Minnesota Capital Improvement Plan - Information Technology Fund 620 Statement of Cash Flows 2020 2021 2022 Actual Proposed Proposed Cash Flows from Operating Activities Receipts from interfund services provided (3% growth annually)604,332$ 552,917$ 554,792$ Receipts from property taxes (1% increase, annually, beginning in 2020)- - - Payments to suppliers and employees (2.5% inflation annual starting in 2021)(671,401) (112,013) (117,800) Net Cash Provided (Used) by Operating Activities (67,069) 440,904 436,992 Cash Flows from Noncapital Financing Activities Transfers in - - - Net Cash Provided (Used) by Noncapital Financing Activities - - - Cash Flows from Capital and Related Financing Activities Acquisition of capital assets (38,603) (288,619) (180,247) Intergovernmental revenue - - - Proceeds from sale of assets - - - Internal loan to Building Fund (500,000) Internal loan repayment from Building Fund Proceeds from bonds and notes issued - - - Net Cash Provided (Used) by Capital and Related Financing Activities (38,603) (288,619) (680,247) Cash Flows from Investing Activities Investment earnings 19,885 6,000 6,000 Net Increase (Decrease) in Cash and Cash Equivalents (85,787) 158,285 (237,255) Cash and Cash Equivalents, January 1 624,207 538,420 696,705 Cash and Cash Equivalents, December 31 538,420$ 696,705$ 459,450$ Internal Service Fund Projected Activity 72 Internal Service Fund Projected Activity 2023 2024 2025 2026 2027 2028 2029 2030 2031 Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated 592,641$ 612,335$ 751,602$ 701,023$ 669,888$ 655,264$ 683,824$ 707,895$ 707,895$ - - - - - - - - - (434,029) (453,920) (451,448) (454,932) (482,799) (496,642) (512,320) (497,419) (509,854) 158,612 158,416 300,154 246,091 187,089 158,623 171,504 210,476 198,041 - - - - - - - - - - - - - - - - - - (179,134) (178,942) (317,223) (264,479) (206,916) (179,144) (191,711) (229,733) (254,489) - - - - - - - - - - - - - - - - - - (150,000) 100,000 100,000 100,000 100,000 250,000 - - - - - - - - - (329,134) (178,942) (217,223) (164,479) (106,916) (79,144) 58,289 (229,733) (254,489) 4,594 2,935 2,759 3,616 4,468 5,315 6,163 8,522 8,415 (165,927) (17,591) 85,690 85,228 84,641 84,794 235,956 (10,734) (48,033) 459,450 293,522 275,931 361,621 446,849 531,491 616,284 852,240 841,506 293,522$ 275,931$ 361,621$ 446,849$ 531,491$ 616,284$ 852,240$ 841,506$ 793,472$ 73 Tax Rates Tax Rates: General Fund Operations and All Funds Cash Balances General Fund Balance as a Percent of Expenditures:Cash Balance by Planned Use (000's): Tax rates are a function of the levy and total tax base. The city tax rate is computed by dividing the city levy by the taxable tax capacity. Future tax rates are based on the assumption of 3.0% growth in tax capacity (see Assumptions). Comparable communities are provided for reference. The General fund fund balance should be maintained at a level to provide for adequate working capital reserves. The MN State Auditor recommends a 35-50% reserve. As the expenditure budget grows, the required reserve should increase accordingly. The City can build to this target by adding to contingency each year. This can be accomplished by reducing expenditures and maintaining the same level of revenue or increasing tax levy. The balances represented in this graph are categorized by the planned use and/or limitations determined by statute. $- $5,000,000 $10,000,000 $15,000,000 $20,000,000 $25,000,000 $30,000,000 Total Fund Balance Budget (calculation based on next years budget) Target Fund Balance (45%) General Fund Balance as a Percent of Expenditures 2020 (Actual) 2021 -2031 (Estimated) 0.00% 10.00% 20.00% 30.00% 40.00% 50.00% 60.00% 70.00% 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 City Tax Capacity Rates 2020 (Actual) and 2021 -2031 (Estimated) General Capital levies Scheduled debt levies Total EDA Tax Rate $- $10,000,000 $20,000,000 $30,000,000 $40,000,000 $50,000,000 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 Cash Balance by Planned Use 2020 (Actual) and 2021 -2031 (Estimated) General fund Debt service Capital projects Special revenue Enterprise Internal service Agency (pass-through grant) 0.00% 10.00% 20.00% 30.00% 40.00% 50.00% 60.00% 70.00% 80.00% 2015 2016 2017 2018 2019 2020 Tax Capacity Tax Rate -Comparison Cities 2015 -2020 (Actual) New Hope Golden Valley Hopkins Brooklyn Center Crystal 74 Property Taxes by Type This graph highlights the percent of levy by planned use. Increases in the levy are primarily attributed to the growth in scheduled and proposed debt levies as well as growth in the City's General levy. Percent of Property Taxes - General Levy and Bonds $- $5,000,000 $10,000,000 $15,000,000 $20,000,000 $25,000,000 Property Taxes -General Levy, EDA, Debt Service and Capital 2020 (Actual) and 2021 -2031 (Estimated) General Capital Economic Development Authority Debt service 0 500 1000 1500 2000 2500 3000 3500 4000 4500 Debt Per Capita -Comparison Cities 2016 -2019 (Actual) 2020 -2030 (Estimated) New Hope Golden ValleyHopkinsBrooklyn Center Crystal 75 THIS PAGE IS LEFT BLANK INTENTIONALLY 76 A ppendix A 77 City of Crystal, Minnesota Internal Loan Schedule for Public Safety Facility Renovation/Construction Internal Loan From 2021 2022 2023 Total Street Improvement -$ 600,000$ -$ 600,000$ Police Revolving 1,200,000 - 1,150,000 2,350,000 Fleet - - - - IT - 500,000 150,000 650,000 Water fund - - 1,500,000 1,500,000 Storm Water 1,000,000 1,000,000 Park Improvement - 450,000 - 450,000 1,200,000$ 2,550,000$ 2,800,000$ 6,550,000$ Internal Loan To 2021 2022 2023 Total Building 1,200,000$ 2,550,000$ 2,800,000$ 6,550,000$ Crystal Internal Loans 2021 2022 2023 2024 2025 Amounts Amounts Amounts Amounts Amounts Amounts Building Fund Internal Loans Street Improvement -$ 600,000$ -$ (200,000)$ (200,000)$ Police Revolving Fund 1,200,000 - 1,150,000 - (250,000) Park Improvement Fund - 450,000 - - - IT - 500,000 150,000 - (100,000) Water - - 1,500,000 - - Storm Water - 1,000,000 - - (150,000) 1,200,000$ 2,550,000$ 2,800,000$ (200,000)$ (700,000)$ Repayment Fund Loan Amount Period Street Improvement 600,000$ 2024 - 2026 Police Revolving 2,350,000 2025 - 2031 IT 650,000 2025 - 2029 Water 1,500,000 2026 - 2031 Storm Water 1,000,000 2025 - 2031 Park Improvement 450,000 2029 - 2030 Total Internal Loans 6,550,000$ 78 2026 2027 2028 2029 2030 2031 Total Amounts Amounts Amounts Amounts Amounts Amounts Repayments (200,000)$ -$ -$ -$ -$ -$ (600,000)$ (115,000) (115,000) (710,000) (650,000) (320,000) (190,000) (2,350,000) - - - (300,000) (150,000) - (450,000) (100,000) (100,000) (100,000) (250,000) - - (650,000) (250,000) (250,000) (250,000) (250,000) (250,000) (250,000) (1,500,000) - (170,000) (170,000) (170,000) (170,000) (170,000) (1,000,000) (665,000)$ (635,000)$ (1,230,000)$ (1,620,000)$ (890,000)$ (610,000)$ (6,550,000)$ 79 THIS PAGE IS LEFT BLANK INTENTIONALLY 80 A ppendix B 81 THIS PAGE IS LEFT BLANK INTENTIONALLY 82 City of Crystal, Minnesota Internal Service Summary Schedule 2019 2020 2021 2022 Allocation to: Building -$ -$ 1,323,092$ 1,467,403$ Fleet - - 336,537 341,585 IT 459,394 604,332 552,917 554,792 Total Allocations IN 459,394 604,332 2,212,546 2,363,780 Allocation from: General Mayor and Council 82 220 12,419 13,182 Administration 43,673 43,755 81,234 88,618 Human resources 628,539 6,563 9,525 10,043 Assessing 45,401 46,158 50,488 53,280 Legal - 1,957 2,301 Election - 11,079 13,152 Finance 41,359 44,123 50,568 53,461 Police 157,960 205,428 595,427 672,571 Fire 318 855 107,707 117,641 Engineering 471 1,265 24,990 27,969 Street Maintenance 5,282 14,195 250,393 260,781 Park Maintenance 11,224 30,160 201,790 212,052 Forestry - - 3,839 4,273 Community Center 2,752 7,395 266,552 278,507 Pool 5,242 14,085 84,466 88,331 EDA - - 4,568 5,186 Community Development 52,036 65,059 68,630 74,006 Recreation 30,458 32,379 64,555 70,247 Total General Fund 1,024,715 511,420 1,890,188 2,045,601 Water 50,754 54,918 123,887 127,928 Sewer 57,998 74,384 156,964 163,796 Storm 29,031 30,474 82,331 71,293 Street Lights 3,416 9,180 1,773 1,947 Total Enterprise Fund 141,199 168,956 364,955 364,964 83 ___________________________________________________________________________________ FROM: John Sutter, Community Development Director TO: Anne Norris, City Manager (for July 20 work session) DATE: July 15, 2021 SUBJECT: Blue Line Extension update ___________________________________________________________________________________ Metro Transit has provided the attached rough conceptual layout of their baseline scenario for the Blue Line Extension through Crystal. This scenario would remove one lane in each direction from Bottineau Boulevard (County Road 81), reducing it from six lanes to four. Lane removal would create space for light rail tracks to run in a widened median within the roadway. At the work session, Councilmembers and staff will gather around tables with the printed conceptual layout for discussion. The same materials will be presented for public review and comment at a community open house at Becker Park from 5-7 p.m. on Monday, July 26. The traffic impacts from removing lanes on Bottineau would be significant during peak periods, especially (but not exclusively) at Bass Lake Road. Metro Transit is working on grade separation concepts to bridge the four remaining lanes of Bottineau Boulevard over Bass Lake Road with the light rail tracks and station platform at grade. Metro Transit is not currently exploring any grade separations or other traffic mitigation concepts at the other Crystal intersections (Wilshire, Corvallis and 47th) and as yet has not presented anything to address staff concerns about traffic delays at those intersections. Staff is especially concerned about the effect on Police Department response times for the north third of the city if lanes are reduced on the bridge over the Canadian Pacific Railway, as this bridge is the only option when long freights block the Douglas Drive and West Broadway crossings of the CP. Metro Transit will have traffic information to present on display boards at the work session and a traffic engineer will be present to answer questions. COUNCIL STAFF REPORT Blue Line Extension Update BlueLineExtensionUpdate EXISTING BOTTINEAU BLVD (COUNTY ROAD 81) NEAR THE CRYSTAL AIRPORT, CRYSTAL This is a visualization of a section of Bottineau Blvd (County Road 81) in Crystal as it exists today. Fremont Ave N7t 3r d /10th Ave NLyndale Ave NBrooklyn Center Brooklyn Park Golden ValleyNew HopeMinneapolis Robbinsdale Crystal CR 81 at Crystal Airport Location (looking northbound) CONCEPT MAINTAINS EXISTING CURB LINE CENTER-RUNNING LIGHT RAIL This visualization represents how light rail could fit in Crystal along Bottineau Blvd (County Road 81). This picture uses the typical width of the roadway at this location. DRAFT: CONCEPT IN DEVELOPMENT DRAFT: CONCEPT IN DEVELOPMENTNOTE: Proposed trees and other landscape material omitted for visual clarity. These elements will be added as the design progresses. METRO BLUE LINE LRT EXTENSION JULY 2021 EXISTING BOTTINEAU BLVD (COUNTY ROAD 81) SOUTH OF BASS LAKE ROAD, CRYSTAL This is a visualization of a section of Bottineau Blvd (County Road 81) in Crystal as it exists today. Fremont Ave N7t 3r d /10th Ave NLyndale Ave NBrooklyn Center Brooklyn Park Golden ValleyNew HopeMinneapolis Robbinsdale Crystal CR 81 S. of Bass Lake Rd Location (looking northbound) CONCEPT MAINTAINS EXISTING CURB LINE CENTER-RUNNING LIGHT RAIL This visualization represents how light rail could fit in Crystal along Bottineau Blvd (County Road 81). This picture uses the typical width of the roadway at this location. DRAFT: CONCEPT IN DEVELOPMENT DRAFT: CONCEPT IN DEVELOPMENTNOTE: Proposed trees and other landscape material omitted for visual clarity. These elements will be added as the design progresses. METRO BLUE LINE LRT EXTENSION JULY 2021 EXISTING BOTTINEAU BLVD (COUNTY ROAD 81) AT 48TH AVE, CRYSTAL This is a visualization of a section of Bottineau Blvd (County Road 81) in Crystal as it exists today. Fremont Ave N7t 3r d /10th Ave NLyndale Ave NBrooklyn Center Brooklyn Park Golden ValleyNew HopeMinneapolis Robbinsdale Crystal CR 81 at 48th Ave Location (looking northbound) CONCEPT MAINTAINS EXISTING CURB LINE CENTER-RUNNING LIGHT RAIL This visualization represents how light rail could fit in Crystal along Bottineau Blvd (County Road 81). This picture uses the typical width of the roadway at this location. DRAFT: CONCEPT IN DEVELOPMENT DRAFT: CONCEPT IN DEVELOPMENTNOTE: Proposed trees and other landscape material omitted for visual clarity. These elements will be added as the design progresses. METRO BLUE LINE LRT EXTENSION JULY 2021 62nd Avenue to 61st AvenueCITY OF CRYSTALMETRO BLUE LINE LRT EXTENSIONJULY 202120020022LRT TRACK AREA RETAINING WALLSTATION PLATFORMPROPOSED DIRECTIONAL LANE USEROADWAYPROPOSED SIGNALIZED INTERSECTIONSIDEWALK / TRAIL / MEDIANPROPOSED LRT ALIGNMENTN8040200 61st Avenue to Crystal Airport RoadCITY OF CRYSTALMETRO BLUE LINE LRT EXTENSIONJULY 2021200200LRT TRACK AREA RETAINING WALLSTATION PLATFORMPROPOSED DIRECTIONAL LANE USEROADWAYPROPOSED SIGNALIZED INTERSECTIONSIDEWALK / TRAIL / MEDIANPROPOSED LRT ALIGNMENTN8040200 Crystal Airport Road to Bass Lake RoadCITY OF CRYSTALMETRO BLUE LINE LRT EXTENSIONJULY 2021200200LRT TRACK AREA RETAINING WALLSTATION PLATFORMPROPOSED DIRECTIONAL LANE USEROADWAYPROPOSED SIGNALIZED INTERSECTIONSIDEWALK / TRAIL / MEDIANPROPOSED LRT ALIGNMENTN8040200 Bass Lake Road to Wilshire BoulevardCITY OF CRYSTALMETRO BLUE LINE LRT EXTENSIONJULY 2021200200LRT TRACK AREA RETAINING WALLSTATION PLATFORMPROPOSED DIRECTIONAL LANE USEROADWAYPROPOSED SIGNALIZED INTERSECTIONSIDEWALK / TRAIL / MEDIANPROPOSED LRT ALIGNMENTN8040200 CITY OF CRYSTALWilshire Boulevard to Canadian Pacific Railroad BridgeMETRO BLUE LINE LRT EXTENSIONJULY 2021200200LRT TRACK AREA RETAINING WALLSTATION PLATFORMPROPOSED DIRECTIONAL LANE USEROADWAYPROPOSED SIGNALIZED INTERSECTIONSIDEWALK / TRAIL / MEDIANPROPOSED LRT ALIGNMENTN8040200 ƌȄƌưǠƌȄژ¥ƌƩǠǑǠƩژ¨ƌǠǹȵȏƌưژ ȵǠưǒƷژto 51st AvenueMETRO BLUE LINE LRT EXTENSIONJULY 2021CITY OF CRYSTAL20020000LRT TRACK AREA RETAINING WALLSTATION PLATFORMPROPOSED DIRECTIONAL LANE USEROADWAYPROPOSED SIGNALIZED INTERSECTIONSIDEWALK / TRAIL / MEDIANPROPOSED LRT ALIGNMENTN8040200 51st Avenue to Lakeside Avenue200200200200LRT TRACK AREA RETAINING WALLSTATION PLATFORMPROPOSED DIRECTIONAL LANE USEROADWAYPROPOSED SIGNALIZED INTERSECTIONSIDEWALK / TRAIL / MEDIANPROPOSED LRT ALIGNMENTN8040200CITY OF CRYSTALMETRO BLUE LINE LRT EXTENSIONJULY 2021 2002002002000LRT TRACK AREA RETAINING WALLSTATION PLATFORMPROPOSED DIRECTIONAL LANE USEROADWAYPROPOSED SIGNALIZED INTERSECTIONSIDEWALK / TRAIL / MEDIANPROPOSED LRT ALIGNMENTN8040200Lakeside Avenue to 47th AvenueCITY OF CRYSTALMETRO BLUE LINE LRT EXTENSIONJULY 2021