Loading...
09-13-2022 Option IIIB - Draft Proposed 2022 CIPYTD Actual 2019 2020 7/31/2021 2021 2022 2023 2024 2025 2026 Property taxes -$ -$ -$ 100,000$ 215,351$ 129,323$ 120,000$ 85,000$ 85,000$ Debt service levy -$ -$ -$ -$ -$ -$ -$ 96,750$ 96,750$ Intergovermental 74,874$ -$ -$ -$ 240,625$ 240,625$ -$ -$ -$ Special assessments 146$ -$ 50,035$ -$ 510$ 520$ 530$ 541$ 552$ Investment Income 12,751$ 11,020$ -$ 500$ 4,500$ 2,300$ 6,646$ 17,832$ 18,838$ Refunds and Reimbursements -$ -$ -$ -$ -$ -$ -$ -$ -$ Rental and lease income -$ -$ -$ -$ -$ -$ -$ -$ -$ Miscellaneous Revenue 21,500$ -$ 6,089$ -$ -$ -$ -$ -$ -$ Bond Proceeds -$ -$ -$ -$ -$ -$ 1,100,000$ -$ -$ Transfers In 550,602$ 30,000$ 200,000$ 200,000$ -$ -$ -$ -$ -$ 659,873$ 41,020$ 256,124$ 300,500$ 460,986$ 372,768$ 1,227,176$ 200,123$ 201,140$ Capital Outlay 64,359$ 276,565$ 327,496$ 397,000$ 631,280$ 634,899$ 481,442$ 40,945$ 128,965$ Miscellaneous 109,822$ (150)$ 14,286$ -$ -$ -$ -$ -$ -$ Debt Service Expense -$ -$ -$ -$ -$ -$ -$ 92,143$ 92,143$ Transfer Out -$ 17,700$ -$ 10,000$ -$ -$ -$ -$ -$ TOTAL EXPENDITURES 174,180$ 294,115$ 341,782$ 407,000$ 631,280$ 634,899$ 481,442$ 133,088$ 221,108$ Prior Period Adj NET REVENUE OVER (UNDER) EXPENSE 485,693$ (253,095)$ (85,658)$ (106,500)$ (170,294)$ (262,131)$ 745,734$ 67,035$ (19,968)$ YE Fund Balance 1,046,994$ 971,989$ 1,037,612$ 785,489$ 705,196$ 443,065$ 1,188,799$ 1,255,834$ 1,235,866$ CITY OF SCANDIA STATEMENT OF REVENUES AND EXPENDITURES - SUMMARY BUDGET - OPTION IIIA Borrowing and a Change in Tax Rate ACTUAL FOR YEAR ENDED DECEMBER 31, 2019 AND 2020, PERIOD TO DATE JULY 31, 2021, BUDGET FOR THE YEARS ENDED DECEMBER 31, 2021 AND 2022 AND PROJECTIONS FOR 2023-2026 Actual Budget Projected Fund 401 - OPTION IIIA Borrowing and a Change in Tax RateREVENUE TOTAL REVENUES EXPENDITURES DRAFT DRAFT YTD Actual 2019 2020 7/31/2021 2021 2022 2023 2024 2025 2026 CITY OF SCANDIA STATEMENT OF REVENUES AND EXPENDITURES - SUMMARY BUDGET - OPTION IIIA Borrowing and a Change in Tax Rate ACTUAL FOR YEAR ENDED DECEMBER 31, 2019 AND 2020, PERIOD TO DATE JULY 31, 2021, BUDGET FOR THE YEARS ENDED DECEMBER 31, 2021 AND 2022 AND PROJECTIONS FOR 2023-2026 Actual Budget Projected Fund 401 - OPTION IIIA Borrowing and a Change in Tax RateREVENUE Property taxes -$ 28,137$ 5,000$ 10,000$ 20,000$ 30,000$ 60,000$ 70,000$ 51,193$ Intergovernmental -$ -$ -$ -$ 104,000$ -$ -$ -$ -$ Charges for services 1,650$ -$ -$ 1,600$ -$ -$ -$ -$ -$ Investment Income 2,600$ 1,614$ -$ -$ 1,200$ 1,100$ 900$ 800$ 850$ Sale of capital assets -$ -$ -$ -$ -$ -$ -$ -$ -$ Park Dedication Fees 3,000$ -$ 3,000$ 6,000$ 3,000$ 3,000$ 3,000$ -$ -$ Rental and lease income -$ -$ -$ -$ -$ -$ -$ -$ -$ Miscellaneous Revenue 1,595$ 802$ -$ -$ -$ -$ -$ -$ -$ Bond Proceeds 140,000$ -$ -$ -$ -$ -$ -$ -$ -$ Transfers In -$ -$ -$ -$ -$ -$ -$ -$ -$ TOTAL REVENUES 148,845$ 30,553$ 8,000$ 17,600$ 128,200$ 34,100$ 63,900$ 70,800$ 52,043$ EXPENDITURES Capital Outlay 22,650$ 26,080$ 1,757$ 40,585$ 219,008$ 43,264$ 67,492$ 66,682$ 72,999$ Miscellaneous 2,472$ 8,663$ -$ -$ -$ -$ -$ -$ -$ Debt Service Expense -$ -$ -$ -$ -$ -$ -$ -$ -$ Transfer Out 103,000$ -$ -$ -$ (1,440)$ -$ -$ -$ -$ TOTAL EXPENDITURES 128,122$ 34,743$ 1,757$ 40,585$ 217,568$ 43,264$ 67,492$ 66,682$ 72,999$ Prior Period Adj NET REVENUE OVER (UNDER) EXPENSE 20,723$ (4,190)$ 6,243$ (22,985)$ (89,368)$ (9,164)$ (3,592)$ 4,118$ (20,956)$ YE Fund Balance 151,637$ 150,499$ 157,599$ 139,539$ 47,290$ 38,126$ 34,534$ 38,652$ 17,696$ Fund 404 - OPTION IIIA Borrowing and a Change in Tax RateREVENUE DRAFT 2 of 10 Presented 9/13/2021 DRAFT DRAFT YTD Actual 2019 2020 7/31/2021 2021 2022 2023 2024 2025 2026 CITY OF SCANDIA STATEMENT OF REVENUES AND EXPENDITURES - SUMMARY BUDGET - OPTION IIIA Borrowing and a Change in Tax Rate ACTUAL FOR YEAR ENDED DECEMBER 31, 2019 AND 2020, PERIOD TO DATE JULY 31, 2021, BUDGET FOR THE YEARS ENDED DECEMBER 31, 2021 AND 2022 AND PROJECTIONS FOR 2023-2026 Actual Budget Projected Fund 401 - OPTION IIIA Borrowing and a Change in Tax RateREVENUE YTD Actual 2019 2020 7/31/2021 2021 2022 2023 2024 2025 2026 Property taxes 27,894$ 28,137$ 65,000$ 130,000$ 30,000$ 50,000$ 75,000$ 115,000$ 61,224$ Debt Service Levy -$ -$ -$ -$ -$ -$ 95,268$ 95,268$ 95,268$ Intergovernmental -$ -$ -$ -$ -$ -$ -$ -$ -$ Sale of capital assets 500$ 13,500$ -$ 7,000$ -$ 35,000$ -$ -$ -$ Investment Income 4,376$ 1,887$ -$ 1,000$ 1,015$ 1,030$ 1,045$ 1,061$ 1,077$ Refunds and Reimbursements -$ -$ -$ -$ -$ -$ -$ -$ -$ Park Dedication Fees -$ -$ -$ -$ -$ -$ -$ -$ -$ Rental and lease income -$ -$ -$ -$ -$ -$ -$ -$ -$ Miscellaneous Revenue -$ -$ -$ -$ -$ -$ -$ -$ -$ Debt Proceeds -$ -$ -$ -$ -$ 815,000$ -$ -$ -$ Transfers In -$ -$ -$ -$ -$ -$ -$ -$ -$ TOTAL REVENUES 32,770$ 43,524$ 65,000$ 138,000$ 31,015$ 901,030$ 171,313$ 211,329$ 157,568$ Capital Outlay 75,961$ 93,498$ 11,224$ 52,500$ 260,000$ 666,266$ 112,486$ -$ -$ Miscellaneous -$ -$ -$ -$ -$ -$ -$ -$ -$ Debt Service Expense -$ -$ -$ -$ -$ -$ 90,731$ 90,731$ 90,731$ Transfer Out -$ -$ -$ -$ -$ -$ -$ -$ -$ TOTAL EXPENDITURES 75,961$ 93,498$ 11,224$ 52,500$ 260,000$ 666,266$ 203,218$ 90,731$ 90,731$ Prior Period Adj 1,195$ NET REVENUE OVER (UNDER) EXPENSE (43,192)$ (48,779)$ 53,776$ 85,500$ (228,985)$ 234,764$ (31,905)$ 120,598$ 66,837$ YE Fund Balance 223,786$ 181,507$ 237,259$ 267,007$ 39,998$ 274,762$ 242,858$ 363,455$ 430,292$ Fund 406 - OPTION IIIA Borrowing and a Change in Tax RateBudget Projected REVENUE EXPENDITURES Actual DRAFT 3 of 10 Presented 9/13/2021 DRAFT DRAFT YTD Actual 2019 2020 7/31/2021 2021 2022 2023 2024 2025 2026 CITY OF SCANDIA STATEMENT OF REVENUES AND EXPENDITURES - SUMMARY BUDGET - OPTION IIIA Borrowing and a Change in Tax Rate ACTUAL FOR YEAR ENDED DECEMBER 31, 2019 AND 2020, PERIOD TO DATE JULY 31, 2021, BUDGET FOR THE YEARS ENDED DECEMBER 31, 2021 AND 2022 AND PROJECTIONS FOR 2023-2026 Actual Budget Projected Fund 401 - OPTION IIIA Borrowing and a Change in Tax RateREVENUE YTD Actual 2019 2020 7/31/2021 2021 2022 2023 2024 2025 2026 Property taxes 352,326$ 357,831$ 219,270$ 438,539$ 273,713$ 350,000$ 310,960$ 230,075$ 209,726$ Debt Service levy -$ -$ -$ -$ -$ -$ -$ -$ 70,364$ Intergovernmental -$ -$ 44,681$ -$ -$ -$ -$ -$ -$ Special assessments 693$ -$ -$ -$ -$ -$ -$ -$ -$ Investment Income 23,740$ 16,749$ -$ -$ 19,613$ 13,405$ 4,773$ 9,509$ 13,103$ Refunds and Reimbursements -$ -$ -$ -$ -$ -$ -$ -$ -$ Rental and lease income -$ -$ -$ -$ -$ -$ -$ -$ -$ Miscellaneous Revenue -$ -$ -$ -$ -$ -$ -$ -$ -$ Bond Proceeds -$ -$ -$ -$ -$ -$ -$ -$ 800,000$ Transfers In -$ -$ 80,000$ 80,000$ -$ -$ -$ -$ -$ TOTAL REVENUES 376,759$ 374,580$ 343,951$ 518,539$ 293,326$ 363,405$ 315,733$ 239,584$ 1,093,193$ Capital Outlay 15,174$ 355,305$ 650,651$ 845,000$ 707,200$ 938,829$ -$ -$ 796,908$ Miscellaneous 72,644$ 70,925$ 82,107$ -$ -$ -$ -$ -$ -$ Debt Service Expense -$ -$ -$ -$ -$ -$ -$ -$ -$ Transfer Out -$ -$ -$ -$ -$ -$ -$ -$ -$ TOTAL EXPENDITURES 87,818$ 426,230$ 732,757$ 845,000$ 707,200$ 938,829$ -$ -$ 796,908$ Prior Period Adj NET REVENUE OVER (UNDER) EXPENSE 288,942$ (51,650)$ (388,807)$ (326,461)$ (413,874)$ (575,424)$ 315,733$ 239,584$ 296,285$ YE Fund Balance 1,667,903$ 1,633,974$ 1,207,472$ 1,166,587$ 893,638$ 318,214$ 633,947$ 873,532$ 1,169,817$ Fund 408 - OPTION IIIA Borrowing and a Change in Tax RateActual Budget Projected EXPENDITURES REVENUE DRAFT 4 of 10 Presented 9/13/2021 DRAFT DRAFT Actual Actual Actual Budget Actual Preliminary dif over PY Type Code Description 2018 2019 2020 2021 7/31/2021 2022 Budget Notes FUND 401 - GENERAL CAPITAL FUND R 401-31000 Washington City. Tax Settlement - - - 100,000 - 215,351 115,351 Based on FMP Option III Original Proposal R 401-31951 Special Assessments Principal - 77 - - - - - R 401-31952 SA Penalties & Interest - 34 - - 35 - - R 401-33422 Other State Grants & Aids 27,867 37,874 - - - 240,625 240,625 Bliss Addition Stormwater Grant with CMSCWSD R 401-33640 Other Grants 5,188 37,000 - - - - - R 401-36100 Special Assessments - 35 - - 50,000 510 510 R 401-36210 Interest Income 4,837 12,751 11,020 500 - 4,500 4,000 R 401-36250 Refunds & reimbursements - - - - - - R 401-36230 Donations 7,493 21,500 - - 6,089 - - R 401-39101 Sales of General Fixed Assets - - - - - - - R 401-39310 Bond proceeds - - - - - - R 401-39200 Interfund Operating Transfer 403,500 550,602 30,000 200,000 200,000 - (200,000) TOTAL FUND 401 REVENUE 448,884 659,873 41,020 300,500 256,124 460,986 160,486 FUND 401 EXPENSES E 401-41000-520 Administration Capital to Bldgs - - 3,236 - - - - E 401-41000-530 Administration Capital - - 3,293 250,000 18,815 319,280 69,280 E 401-42200-520 Fire Capital to Bldgs - - - - - - - E 401-42200-530 Fire Capital - - - 75,000 141,873 - (75,000) E 401-43000-520 Public Works Capital to Bldgs - - - - - - - E 401-43000-530 Public Works Capital - - 70,977 10,000 - - (10,000) E 401-43100-530 Streets and Roads - - - - - - - E 401-45000-520 Park Capital to Buildings - - - - - - - E 401-45000-530 Park Capital - - - - - - - E 401-45180-520 Community Center Building Impr - - - 15,000 - 52,000 37,000 E 401-45180-530 Community Center Capital - - - - - - - E 401-47000-601 Bond Principal - - - - - - E 401-47000-611 Bond Interest - - - - - - E 401-48000-101 Regular Wages & Salaries - - - - - - - Discontinued E 401-48000-303 Engineering Fees 20,206 104,822 (150) - - - - E 401-48000-308 Other Professional Services - - - - 6,800 - - E 401-48000-312 Planning Services - - - - 7,486 - - E 401-48000-435 Misc. Expense - 5,000 - - - - - E 401-48000-438 Misc. Contractual 9,350 - - - - - - E 401-48000-520 Capital Improvements to Bldgs.89,350 35,045 30,995 - - - - E 401-48000-530 Capital Imp Other Than Bldgs.5,785 29,314 168,065 47,000 166,575 - (47,000) E 401-48000-540 Heavy Machinery Capital - - - - - - - E 401-48000-550 Motor Vehicles Capital - - - - - - - E 401-48000-560 Furniture and Fixtures - - - - 233 - - E 401-48000-570 Office Equipment - - - - - - - E 401-48000-720 Operating Transfers 100,000 - 17,700 10,000 - - (10,000) $10k loan to Big Marine Sewer at 2% Interest for cashflow E 401-48500-303 Engineering Fees - - - - - - - TOTAL FUND 401 EXPENDITURES 224,691 174,180 294,115 407,000 341,782 371,280 (35,720) NET REVENUE OVER EXPENDITURES 224,193 485,693 (253,095) (106,500) (85,658) 89,706 FUND 404 PARK CAPITAL FUND R 404-31000 Washington City. Tax Settlement - - 28,137 10,000 5,000 20,000 10,000 2022 Draft City of Scandia Line-Item Budget Option IIIA - Original 9-1-2021 Bonding Option from FMP DRAFT 5 of 10 Presented 9/13/2021 DRAFT DRAFT Actual Actual Actual Budget Actual Preliminary dif over PY Type Code Description 2018 2019 2020 2021 7/31/2021 2022 Budget Notes 2022 Draft City of Scandia Line-Item Budget Option IIIA - Original 9-1-2021 Bonding Option from FMP R 404-33422 Other State Grants & Aids - 4,300 9,380 10,585 857 104,000 93,415 2022 Grant for Community Center Playground/Last Yr Lilleskogen Rest. R 404-33640 Other Grants - 5,000 - - - - - R 404-34730 Ballfield Ad Revenue 1,650 1,650 - 1,600 - (1,600) moving Ad revenue to Gen Fund for park maintenance R 404-34780 Park Dedication Fees 12,000 3,000 - 6,000 3,000 3,000 (3,000) R 404-36210 Interest Income 853 2,600 1,614 - - 1,200 1,200 R 404-36230 Donations 1,269 1,595 802 - - - - R 404-36260 Sale of Equipment - - - - - - - R 404-39101 Sales of General Fixed Assets - 140,000 - - - - - R 404-39203 Transfer from Other Funds 100,000 - - - - - - TOTAL 404 FUND REVENUE 115,772 158,145 39,933 28,185 8,857 128,200 100,015 E 404-48000-101 Regular Wages & Salaries - 1,200 3,000 - - - - Labor expenses must go through General Fund E 404-48000-104 Temporary Employee Wages - - - - - - - " E 404-48000-121 PERA Coord. Employer Contribu.- 90 100 - - - - " E 404-48000-122 FICA Employer Contribution - 92 100 - - - - " E 404-48000-126 MEDICARE Employer Contribution - - - - - - - " E 404-48000-210 Operating Supplies 181 - 843 - - - - Operating Expenses have been moved to the General Fund for Ballfield E 404-48000-302 Surveying - - 2,100 - - - - " E 404-48000-303 Engineering Fees - - - - - - - " E 404-48000-304 Legal Services - - - - - - - " E 404-48000-308 Other Professional Services - - 1,208 - - - - " E 404-48000-312 Planning Services - - - - - - - " E 404-48000-381 Utilities-Electric & Gas 466 223 375 - - - - " E 404-48000-384 Refuse/Garbage Disposal 765 867 937 - - - - " E 404-48000-510 Capital Outlay-Land - - - - - - - E 404-48000-512 Easement Acquisition - - - - - - - E 404-48000-520 Capital Improvements to Bldgs.- 1,137 - - - - - E 404-48000-530 Capital Impr Other Than Bldgs.- 21,513 26,080 40,585 1,757 219,008 178,423 Community Center Playground/ Lillleskogen Park Restoration E 404-48000-560 Furniture and Fixtures - - - - - - - E 404-48000-710 Residual Equity Transfers - 100,000 - - - - - E 404-48000-720 Operating Transfers - 3,000 - 1,440 - 1,440 - TOTAL FUND 404 EXPENDITURES 1,412 128,122 34,743 42,025 1,757 220,448 178,423 NET REVENUE OVER EXPENDITURES 114,360 30,023 5,190 (13,840) 7,100 (92,248) FUND 406 EQUIPMENT CAPITAL FUND R 406-31000 Washington City. Tax Settlement 30,000 27,894 28,137 130,000 65,000 30,000 (100,000) R 406-36210 Interest Income 3,212 4,376 1,887 1,000 - 1,015 15 R 406-36230 Donations 9,540 - - - - - - R 406-36250 Misc. Refund - - - - - - - R 406-36260 Sale of Equipment 14,300 500 13,500 7,000 - - (7,000) R 406-39200 Interfund Operating Transfer - - - - - - - R 406-39350 Certificate of Indebtedness - - - - - - - TOTAL 406 FUND REVENUE 57,052 32,770 43,524 138,000 65,000 31,015 (106,985) E 406-48500-304 Legal Services - - - - - - - E 406-48500-319 Other Services 400 - - - - - - E 406-48500-340 Advertising - - - - - - - E 406-48500-540 Heavy Machinery Capital 140,658 32,455 93,498 - - 260,000 260,000 Purchase of Road Tractor for mowing shoulders and its attachments DRAFT 6 of 10 Presented 9/13/2021 DRAFT DRAFT Actual Actual Actual Budget Actual Preliminary dif over PY Type Code Description 2018 2019 2020 2021 7/31/2021 2022 Budget Notes 2022 Draft City of Scandia Line-Item Budget Option IIIA - Original 9-1-2021 Bonding Option from FMP E 406-48500-550 Motor Vehicles Capital 116,819 43,506 - 52,500 11,224 - (52,500) E 406-48500-560 Furniture and Fixtures - - - - - - - E 406-48500-570 Office Equipment - - - - - - - E 406-48500-720 Operating Transfers - - - - - - - TOTAL FUND 406 EXPENDITURES 257,877 75,961 93,498 52,500 11,224 260,000 207,500 NET REVENUE OVER EXPENDITURES (200,826) (43,192) (49,974) 85,500 53,776 (228,985) FUND 408 LOCAL ROAD IMPROVEMENT FUND R 408-31000 Washington City. Tax Settlement 725,050 352,326 357,831 438,539 219,270 350,000 (88,539) 2023-2024 Cash will be low around 50k, 2025-2026 apx $280k R 408-33422 Other State Grants & Aids - - - - 44,681 - - HF 10 Pmnibus Trasport Funding from State of Minnesota 1 time road aid R 408-34304 Reimbursement for Services - - - - - - - R 408-36100 Special Assessments - 693 - - - - - R 408-36210 Interest Income 12,708 23,740 16,749 - - 19,613 19,613 R 408-39203 Transfer from Other Funds - - 80,000 80,000 - (80,000) R 408-39310 Proceeds-Gen Obligation Bond 3,842,638 - - - - - - R 408-36250 Misc. Refund - - - - - - - TOTAL 408 FUND REVENUE 4,580,396 376,759 374,580 518,539 343,951 369,613 (148,926) E 408-43100-303 Engineering Fees 420,212 72,644 70,925 - 82,107 - - E 408-43100-530 Capital Impr Other Than Bldgs.4,252,062 15,174 355,305 845,000 650,651 707,200 (137,800) Last Road Project funding for 5-6 years to rebuild funds for road. E 408-43100-720 Operating Transfers - - - - - - - Other levies could be lowered to continue this funding program. TOTAL FUND 408 EXPENDITURES 4,672,273 87,818 426,230 845,000 732,757 707,200 208,000 NET REVENUE OVER EXPENDITURES (91,877) 288,942 (51,650) (326,461) (388,807) (337,587) DRAFT 7 of 10 Presented 9/13/2021 DRAFT DRAFT CIP Inflation Factor 0.00%4.00%4.00%4.00%4.00%4.00%4.00%4.00%4.00%4.00%4.00% Item 2021 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 Code #Capital Project Name First Year Costs Budget Budget Projected 401-42200-520 1 2nd Fire Station 2029 180,000 - - - - - - - - 246,342 - - 401-45180-520 2 Annex Roof Replacement 2021 18,000 18,000 - - - - - - - - - - 401-41000-520 3 Arts & Heritage Center Amphitheater 2023 30,000 - - 32,448 - - - - - - - - 401-42200-520 4 Back-up Generator for Fire Hall 2021 20,000 20,000 - - - - - - - - - - 401-48000-435 5 Bliss Additions Stormwater plan 2022 250,000 - 260,000 - - - - - - - - - 401-48000-435 6 Bliss Additions Stormwater plan 2023 250,000 - - 270,400 - - - - - - - - 401-48000-435 7 Bliss Additions Stormwater Interceptor to Wetland 2024 110,000 - - - 123,735 - - - - - - - 401-48000-435 8 Bliss Additions Stormwater plan 2025 35,000 - - - - 40,945 - - - - - - 401-41000-530 9 Broadband Expansion 2021 250,000 250,000 - - - - - - - - - - 401-41000-530 10 Broadband Expansion 2022 307,000 - 319,280 - - - - - - - - - 401-41000-530 11 Broadband Expansion 2023 307,000 - - 332,051 - - - - - - - - 401-41000-530 12 Broadband Expansion 2024 250,000 - - - 281,216 - - - - - - - 401-43000-520 13 Cold Storage Building 2026 70,000 - - - - - 85,166 - - - - - 401-45180-520 14 Community Center Flooring & Paint 0 40,000 - - - - - - - - - - - 401-45180-520 15 Community Center Door Locks & ADA 2021 15,000 15,000 - - - - - - - - - - 401-45180-520 16 Community Center Front Door 2022 20,000 - 20,800 - - - - - - - - - 401-45180-520 17 Community Center HVAC Replacement 2022 30,000 - 31,200 - - - - - - - - - 401-45180-530 18 Community Center Park Survey 2021 6,800 6,800 - - - - - - - - - - 401-45180-520 19 Community Center Upgrade Renovations 2028 600,000 - - - - - - - 789,559 - - - 401-42200-530 20 Defibulator Replacement FD 2021 36,100 36,100 - - - - - - - - - - 401-41000-530 21 Development Code Update 2021 30,000 30,000 - - - - - - - - - - 401-42200-520 22 Exhaust removal system 2024 48,000 - - - 53,993 - - - - - - - 401-42200-520 23 FD/PW Bldg Roof Replacement 2021 119,000 119,000 - - - - - - - - - - 401-41000-530 24 Financial Mgmt Plan 2021 15,900 15,900 - - - - - - - - - - 401-42200-530 25 Fire Department Radio Replacement 2021 95,800 95,800 - - - - - - - - - - 401-42200-530 26 Jaws of Life 2028 12,000 - - - - - - - 15,791 - - - 401-43000-530 27 Radio Replacement 2021 10,000 10,000 - - - - - - - - - - 401-42200-530 28 Thermo Cameras 2026 8,000 - - - - - 9,733 - - - - - 401-42200-530 29 UTV/Trailer 2026 28,000 - - - - - 34,066 - - - - - 401-42200-530 30 Warning Sirens 2024 20,000 - - - 22,497 - - - - - - - 31 CIP placeholder 2028 75,000 - - - - - - - - 102,643 106,748 111,018 32 75,000 616,600 631,280 634,899 481,442 40,945 128,965 - 805,350 348,985 106,748 111,018 FUND 401 General Capital - Option IIIA - Original 9-1-2021 Bonding Option from FMP Project DRAFT 8 of 10 Presented 9/13/2021 DRAFT DRAFT CIP Inflation %0.00%4.00%4.00%4.00%4.00%4.00%4.00%4.00%4.00%4.00%4.00% Multiple 2021 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 Code Item #Year?First Year Last Year Costs Budget Budget Projected 404-48000-530 1 Playground Equipment - Community Center Park 2022 200,000 - 208,000 - - - - - - - - - 404-48000-530 2 Pleasure Rink Expansion 2024 10,000 - - - 11,249 - - - - - - - 404-48000-520 3 Replacement of the boards at the the rink 2024 50,000 - - - 56,243 - - - - - - - 404-48000-520 4 Lilleskogen Park Picnic Shelter 2023 10,000 - - 10,816 - - - - - - - - 404-48000-530 5 Park Sign at New unnamed Orwell Park 2023 30,000 - - 32,448 - - - - - - - - 404-48000-530 6 PlaygroundEquipment @ Wayne Erikson Mem Park 2025 57,000 - - - - 66,682 - - - - - - 404-48000-530 7 Cycling & Trails 2026 30,000 - - - - - 36,500 - - - - - 404-48000-530 8 Nature park trails 2021 10,000 10,000 - - - - - - - - - - 404-48000-530 9 Settlers Monument Improvements 2021 5,000 5,000 - - - - - - - - - - 404-48000-530 10 Lilleskogen Praire/Wetland Restoration Project 2022 10,585 - 11,008 - - - - - - - - - 404-48000-530 11 Lilleskogen Park Park Signage 2021 10,000 10,000 - - - - - - - - - - 404-48000-530 12 Lilleskogen Praire/Wetland Restoration Project 2021 10,585 10,585 - - - - - - - - - - 404-48000-530 13 Lilleskogen Praire/Wetland Restoration Project 2026 10,000 - - - - - 12,167 - - - - - 404-48000-530 14 Park Planning 2021 5,000 5,000 - - - - - - - - - - 404-48000-530 15 Replacement ballfield for South Field 2026 20,000 - - - - - 24,333 - - - - - 404-48000-530 16 Wayne Erikson Parking Lot Improvements 2030 52,000 - - - - - - - - - 74,012 - 404-48000-530 17 Wayne Erikson Portable Toilets Area Improvements 2030 28,000 - - - - - - - - - 39,853 - 404-48000-530 18 Wayne Erikson Consession Stand Extention 2029 40,000 - - - - - - - - 54,743 - - 404-48000-530 19 Addition of 2 Pickleball Courts at Com. Center 2028 46,000 - - - - - - - 60,533 - - - 404-48000-530 20 Repainting of Tennis Court to include Pickleball 2027 18,000 - - - - - - 22,776 - - - - 0 16 CIP placeholder Yes 2030 2031 50,000 - - - - - - - - - 74,012 17 Total Capital Projects 702,170 40,585 219,008 43,264 67,492 66,682 72,999 22,776 60,533 54,743 113,865 74,012 CIP Inflation %0.00%4.00%4.00%4.00%4.00%4.00%4.00%4.00%4.00%4.00%4.00% Multiple 2021 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 Code Item #Capital Project Name Year?First Year Last Year Costs Budget Budget Projected 406-48500-540 1 Tanker 5178 Replacement 2023 250,000 - - 270,400 - - - - - - - - 406-48500-550 2 Grass Rig 5175 Replacement 2023 60,000 - - 64,896 - - - - - - - - 406-48500-550 3 Fire Boat 2023 25,000 - - 27,040 - - - - - - - - 406-48500-540 4 Bolins Lawnmower 2021 9,000 9,000 - - - - - - - - - - 406-48500-540 5 Kubota F3990 Tractor Mower w/Broom & Blower (303-09)2024 45,000 - - - 50,619 - - - - - - - 406-48500-540 6 Western Star Dump Truck/ Plow (Replace 201-17)2029 200,000 - - - - - - - - 273,714 - - 406-48500-540 7 1999 JD-6410 Tractor Replacement (302-99)2022 250,000 - 260,000 - - - - - - - - - 406-48500-550 8 Asphalt Patching Equipment Trailer (312)2024 15,000 - - - 16,873 - - - - - - - 406-48500-540 9 Skid Loader and Trailer 2024 40,000 - - - 44,995 - - - - - - - 406-48500-540 10 2011 Mack Dump Truck/Plow Replacement (203-11)2023 225,000 - - 243,360 - - - - - - - - 406-48500-550 11 Pickup w/Plow Replacement 2011 Ford F250 (103-11)2021 43,500 43,500 - - - - - - - - - - 406-48500-550 12 One-Ton F-550 Work Truck 2023 56,000 - - 60,570 - - - - - - - - 13 Total Capital Projects 1,218,500 52,500 260,000 666,266 112,486 - - - - 273,714 - - Project Option IIIA - Original 9-1-2021 Bonding Option from FMP Fund 404 Park Capital Project FUND 406 Capital Replacement DRAFT 9 of 10 Presented 9/13/2021 DRAFT DRAFT CIP Inflation Factor 0.00%4.00%4.00%4.00%4.00%4.00%4.00%4.00%4.00%4.00%4.00% 2021 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 Code Item #Capital Project Name First Year Costs Budget Budget Projected 408-43100-530 1 2021 Local Road Improvement Project 2021 70,000 70,000 - - - - - - - - - - 408-43100-530 2 2021 Local Road Improvement Project 2021 845,000 845,000 - - - - - - - - - - 408-43100-530 3 2022 Local Road Improvement Project 2022 680,000 - 707,200 - - - - - - - - - 408-43100-530 4 2023 Seal Coating Project 2023 183,000 - - 197,933 - - - - - - - - 408-43100-530 5 Seal boring 2023 20,000 - - 21,632 - - - - - - - - 408-43100-530 6 2023 Local Road Improvement Project 2023 665,000 - - 719,264 - - - - - - - - 408-43100-530 7 2024 Local Road Improvement Project 2026 655,000 - - - - - 796,908 - - - - - 408-43100-530 8 2025 Seal Coating Project 2027 252,000 - - - - - - 318,860 - - - - 408-43100-530 9 2025 Local Road Improvement Project 2027 630,000 - - - - - - 797,151 - - - - 408-43100-530 10 Seal boring 2028 20,000 - - - - - - - 26,319 - - - 408-43100-530 11 2026 Seal Coating Project 2028 335,000 - - - - - - - 440,837 - - - 408-43100-530 12 2026 street reconstruction 2028 760,000 - - - - - - - 1,000,108 - - - 408-43100-530 13 2027 street reconstruction 2029 770,000 - - - - - - - - 1,053,798 - - 408-43100-530 14 2027 seal coating and boring 2029 98,000 - - - - - - - - 134,120 - - 408-43100-530 15 2028 street reconstruction 2030 790,000 - - - - - - - - - 1,124,416 - 408-43100-530 16 2029 street reconstruction 2031 770,000 - - - - - - - - - - 1,139,788 408-43100-530 17 2029 boring 2031 20,000 - - - - - - - - - - 29,605 18 Total Capital Projects 7,563,000 915,000 707,200 938,829 - - 796,908 1,116,011 1,467,264 1,187,918 1,124,416 1,169,393 FUND 408 - Option IIIA - Original 9-1-2021 Bonding Option from FMP Project DRAFT 10 of 10 Presented 9/13/2021