Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
4. 5YR CIP Draft 7-29-2022 w-revenue-balance projections
Capital Improvement Program City of Scandia, Minnesota SOURCES AND USES OF FUNDS FY '23 FY '27thru 101 General Fund Source FY '23 FY '24 FY '25 FY '26 FY '27 1,492,462 1,492,462 1,492,462 1,492,462 1,492,462Beginning Balance Revenues and Other Fund Sources 0 0 0 0 0No Funds 0 0 0 0 0Total 1,492,462 1,492,462 1,492,462 1,492,462 1,492,462Total Funds Available 0 0 0 0 0Total Revenues and Other Fund Sources 1,492,462 1,492,462 1,492,462 1,492,462 1,492,462Ending Balance 0 0 0 0 0Change in Fund Balance Sunday, July 31, 2022Page 1DRAFT for 2021-2030 7/29/2022 401 Capital Improvement Fund Source FY '23 FY '24 FY '25 FY '26 FY '27 845,402 621,802 1,242,777 1,504,388 1,533,623Beginning Balance Revenues and Other Fund Sources Revenue 0 0 (96,750) (96,750) (96,750)(Less) Debt Service Payment 0 1,100,000 0 0 0Bond Proceeds 0 0 96,750 96,750 96,750Debt Service Levy 2,300 14,268 23,583 27,576 28,083Investment Income 420,100 185,000 472,000 85,000 50,000Property Tax Levy 422,400 1,299,268 495,583 112,576 78,083Total 1,267,802 1,921,070 1,738,360 1,616,964 1,611,706Total Funds Available 422,400 1,299,268 495,583 112,576 78,083Total Revenues and Other Fund Sources Expenditures and Uses Capital Projects & Equipment Administration (407,000) (281,216) 0 0 0Broadband Development Grants to MIDCO A-008 (407,000) (281,216) 0 0 0Total Community Center 0 0 (58,493) 0 0Large Hall and Heritage Room Carpeting CC=016 (40,000) 0 0 0 0Council Chambers remodel CC-013 (14,000) 0 0 0 0Security Improvements CCTV for Park CC-014 0 (33,746) 0 0 0CC AC Condenser Replacement CC-015 0 0 (17,548) 0 0Additional Comm Cent Elec Locks CC-017 0 0 0 0 (189,798)Community Center Design & Planning CC-018 (54,000) (33,746) (76,041) 0 (189,798)Total Fire 0 0 (17,548) 0 0Fire Department Radio Replacement F-003 0 (28,122) 0 0 0Warning Sirens F-009 0 0 0 0 (227,757)Second Fire Station F-016 0 0 (17,548) 0 0Lucas CPR Device F-027 0 (53,993) 0 0 0Exhaust removal system F-032 0 0 0 (42,583) 0UTV & Trailer F-033 0 0 0 (9,733) 0Thermal Imaging Cameras F-034 0 0 (40,945) 0 0Homatro 4050NCT Cutter Twin Line R-1 F-037 (65,000) 0 0 0 0Panel Joint Replacement Fire Hall F-039 0 0 0 (21,900) 0Station Bay floor coating F-041 0 0 0 (9,125) 0Washer/Extractor F-042 (65,000) (82,115) (76,041) (83,341) (227,757)Total Parks and Recreation 0 (33,746) 0 0 0Arts & Heritage Center Amphitheater PR-052 0 (123,735) 0 0 0Arts & Heritage Center Sidewalk and Walkways PR-065 0 (157,481) 0 0 0Total Sunday, July 31, 2022Page 2DRAFT for 2021-2030 7/29/2022 401 Capital Improvement Fund Source FY '23 FY '24 FY '25 FY '26 FY '27 Public Works 0 0 (81,890) 0 0Cold Storage Building PW-047 0 0 (81,890) 0 0Total Stormwater (120,000) (123,735) 0 0 0Bliss Additions Stormwater plan SW-003 (120,000) (123,735) 0 0 0Total (646,000) (678,293) (233,972) (83,341) (417,555)Total Expenditures and Uses 621,802 1,242,777 1,504,388 1,533,623 1,194,151Ending Balance (223,600) 620,975 261,611 29,235 (339,472)Change in Fund Balance Sunday, July 31, 2022Page 3DRAFT for 2021-2030 7/29/2022 404 Park Improvement Fund Source FY '23 FY '24 FY '25 FY '26 FY '27 148,216 105,835 13,851 (22,531) 50,469Beginning Balance Revenues and Other Fund Sources Revenue 66 0 0 0 0Investment Income 3,000 3,000 3,000 3,000 3,000Park Dedication Fees 40,000 40,000 70,000 70,000 70,000Property Tax Levy 43,066 43,000 73,000 73,000 73,000Total 191,282 148,835 86,851 50,469 123,469Total Funds Available 43,066 43,000 73,000 73,000 73,000Total Revenues and Other Fund Sources Expenditures and Uses Capital Projects & Equipment Parks and Recreation 0 0 (66,682) 0 0Playground Equipment - Erickson ballfield PR-044 (32,448) 0 0 0 0Gateway Trail Improvements @ Annex PR-045 0 0 (42,700) 0 0Nature park trails PR-048 0 0 0 0 (101,226)Hay Lake Park Shelter water & doors PR-050 (8,653) 0 0 0 0Hay Lake Park - sign PR-054 (35,693) 0 0 0 0Lilleskogen Park Picnic Shelter PR-055 0 0 0 0 (12,653)Expanded Pleasure Rink PR-058 0 0 0 0 (44,286)New Ballfield to Replace South Ball Field PR-059 0 (134,984) 0 0 0Replace rink boards PR-061 (8,653) 0 0 0 0Park signage at Orwell Park (Liten)PR-063 0 0 0 0 (37,960)Settlers MonutPossible Reloc/Imp PR-066 (85,447) (134,984) (109,382) 0 (196,125)Total (85,447) (134,984) (109,382) 0 (196,125)Total Expenditures and Uses 105,835 13,851 (22,531) 50,469 (72,656)Ending Balance (42,381) (91,984) (36,382) 73,000 (123,125)Change in Fund Balance Sunday, July 31, 2022Page 4DRAFT for 2021-2030 7/29/2022 406 Equipment Replacement Fund Source FY '23 FY '24 FY '25 FY '26 FY '27 316,433 806,241 748,820 11,406 (697,915)Beginning Balance Revenues and Other Fund Sources Revenue 0 (133,592) (133,592) (133,592) (133,592)(Less) Debt Service Payment 1,200,000 0 0 0 0Bond Proceeds 0 140,271 140,271 140,271 140,271Debt Service Levy 50,000 144,000 145,000 100,000 100,000Property Tax Levy 35,000 0 0 0 0Sale of Capital Assets 1,285,000 150,679 151,679 106,679 106,679Total 1,601,433 956,920 900,499 118,085 (591,236)Total Funds Available 1,285,000 150,679 151,679 106,679 106,679Total Revenues and Other Fund Sources Expenditures and Uses Capital Projects & Equipment Fire (292,465) 0 0 0 0Tanker 5178 Tender 2 Replacement F-014 0 0 (818,901) 0 0Engine 1 - 5176 Replacement F-015 (86,528) 0 0 0 0Utility 1 truck F-040 (378,993) 0 (818,901) 0 0Total Public Works 0 (67,492) 0 0 0303-17 Kubota F39000 Mower w/Broom & Blower PW-005 0 0 0 (426,000) 0202-17 Western Star Truck/ Plow PW-006 0 (73,116) 0 0 0202-02 Sterling Dump Truck/Plow PW-010 0 0 (40,945) 0 0312-08 Asphalt Patching Equipment Trailer PW-012 0 (67,492) 0 0 0308-12 New Holland Skit Steer PW-015 (337,459) 0 0 0 0203-11 Mack Dump Truck/Plow Replacement PW-017 (78,740) 0 0 0 0104-13 Ford F550 w/sander, plow mount, compressor PW-022 0 0 0 (390,000) 0201-14 Mack Single Axle w/Plow PW-063 0 0 (19,888) 0 0Utility Trailer 3,500 lbs PW-065 0 0 (9,359) 0 0PJ Skid Trailer 14,000 lbs PW-066 (416,199) (208,100) (70,192) (816,000) 0Total (795,192) (208,100) (889,093) (816,000) 0Total Expenditures and Uses 806,241 748,820 11,406 (697,915) (591,236)Ending Balance 489,808 (57,421) (737,414) (709,321) 106,679Change in Fund Balance Sunday, July 31, 2022Page 5DRAFT for 2021-2030 7/29/2022 408 Local Road Improvement Fund Source FY '23 FY '24 FY '25 FY '26 FY '27 1,278,399 405,117 2,272,951 1,994,513 397,890Beginning Balance Revenues and Other Fund Sources Revenue 0 0 (167,533) (167,533) (167,533)(less) Debt Service Payment 0 2,000,000 0 0 2,000,000Bond Proceeds 0 175,910 175,910 175,910 351,820Debt Service Levy 12,115 8,688 40,306 0 0Interest Income 350,000 600,000 600,000 200,000 200,000Property Tax Levy 362,115 2,784,598 648,683 208,377 2,384,287Total 1,640,514 3,189,715 2,921,634 2,202,890 2,782,177Total Funds Available 362,115 2,784,598 648,683 208,377 2,384,287Total Revenues and Other Fund Sources Expenditures and Uses Capital Projects & Equipment Public Works (183,000) 0 0 0 02023 Seal Coating Project PW-050 0 0 0 (335,000) 02026 Seal Coating Project PW-051 0 0 (272,000) 0 02025 Seal Coating Project and Boring PW-052 (21,632) 0 (23,397) 0 0Seal Boring PW-056 0 0 0 0 (98,000)2027 Seal Coating and Boring PW-058 (204,632) 0 (295,397) (335,000) (98,000)Total Road Projects 0 (916,764) 0 0 02024 Local Road Improvement Project PW-034 0 0 0 (1,470,000) 02026 Local Road Improvement Project PW-035 (1,030,765) 0 0 0 02023 Local Road Improvement Project PW-043 0 0 (631,724) 0 02025 Local Road Improvement Project PW-053 0 0 0 0 (1,000,000)2027 Local Road Improvement Project PW-057 (1,030,765) (916,764) (631,724) (1,470,000) (1,000,000)Total (1,235,397) (916,764) (927,121) (1,805,000) (1,098,000)Total Expenditures and Uses 405,117 2,272,951 1,994,513 397,890 1,684,177Ending Balance (873,282) 1,867,834 (278,438) (1,596,623) 1,286,287Change in Fund Balance Sunday, July 31, 2022Page 6DRAFT for 2021-2030 7/29/2022 602 Big Marine Sewer Fund (201) Source FY '23 FY '24 FY '25 FY '26 FY '27 86,122 208,764 336,315 424,976 (495,715)Beginning Balance Revenues and Other Fund Sources Revenue 126,579 146,199 168,859 195,033 0Charges for Service 428 102 52 26 0Interest Earnings 1,070,000 0 0 0 0Issuance of debt 1,197,007 146,301 168,911 195,059 0Total 1,283,129 355,065 505,226 620,035 (495,715)Total Funds Available 1,197,007 146,301 168,911 195,059 0Total Revenues and Other Fund Sources Expenditures and Uses Capital Projects & Equipment Big Marine Sewer 0 0 (60,000) 0 0A/E Drainfield 201S-002 (960,000) 0 0 0 0Bliss nitrate treatment equipment 201S-005 (2,500) 0 0 (350,000) 0Bliss LS 1 201S-006 (2,500) 0 0 (350,000) 0Bliss LS 2 201S-007 0 0 0 (2,500) 0Bliss LS 3 Dosage Tanks 201S-009 0 0 0 0 (2,500)Bliss LS 4 Dosage Tanks 201S-011 (3,250) (4,750) (3,250) (3,250) (3,250)AE LS 1 Pump 2 201S-015 (11,000) (14,000) (17,000) 0 0Distribution Network Replacement 201S-016 0 0 0 (350,000) 0Bliss Replace LS 2 201S-019 0 0 0 0 (10,000)Bliss LS 1 ControlPanel 201S-020 0 0 0 (50,000) (50,000)Forcemain replacement 201S--020 0 0 0 (10,000) 0Bliss LS 2 Control Panel 201S-021 (979,250) (18,750) (80,250) (1,115,750) (65,750)Total Other Uses 0 0 0 0 0Debt Service Expense (3,774) 0 0 0 0Materials (18,411) 0 0 0 0Other (12,852) 0 0 0 0Professional Services (33,864) 0 0 0 0Repair and Maintenance (26,214) 0 0 0 0Wages (95,115) 0 0 0 0Total (1,074,365) (18,750) (80,250) (1,115,750) (65,750)Total Expenditures and Uses 208,764 336,315 424,976 (495,715) (561,465)Ending Balance 122,642 127,551 88,661 (920,691) (65,750)Change in Fund Balance Sunday, July 31, 2022Page 7DRAFT for 2021-2030 7/29/2022 General Fund - Parks Source FY '23 FY '24 FY '25 FY '26 FY '27 0 0 0 0 (60,533)Beginning Balance Revenues and Other Fund Sources Revenue 0 0 0 0 0No Funds 0 0 0 0 0Total 0 0 0 0 (60,533)Total Funds Available 0 0 0 0 0Total Revenues and Other Fund Sources Expenditures and Uses Capital Projects & Equipment Parks and Recreation 0 0 0 (60,533) 0Tennis Court/Pickle Ball - repaint PR-064 0 0 0 (60,533) 0Total 0 0 0 (60,533) 0Total Expenditures and Uses 0 0 0 (60,533) (60,533)Ending Balance 0 0 0 (60,533) 0Change in Fund Balance Grants/Donations Source FY '23 FY '24 FY '25 FY '26 FY '27 0 0 0 (12,878) (12,878)Beginning Balance Expenditures and Uses Capital Projects & Equipment Parks and Recreation 0 0 (12,878) 0 0Lilleskogen Praire/Wetland Restoration Project PR-057 0 0 (12,878) 0 0Total 0 0 (12,878) 0 0Total Expenditures and Uses 0 0 (12,878) (12,878) (12,878)Ending Balance 0 0 (12,878) 0 0Change in Fund Balance Sunday, July 31, 2022Page 8DRAFT for 2021-2030 7/29/2022