Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
4. Sources and Uses of Funds 5-23-23
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,580,895 1,390,575 1,390,575 1,138,575 850,575Beginning Balance Revenues and Other Fund Sources 0 0 0 0 0No Funds 0 0 0 0 0Total 1,580,895 1,390,575 1,390,575 1,138,575 850,575Total Funds Available 0 0 0 0 0Total Revenues and Other Fund Sources Expenditures and Uses Capital Projects & Equipment Road Projects (190,320) 0 0 0 02023 Seal Coat & Crack Filling Project PW-050 0 0 0 (288,000) 02026 Seal Coat & Crack Filling Project PW-051 0 0 (252,000) 0 02025 Seal Coat & Crack Filling Project PW-052 0 0 0 0 (78,000)2027 Seal Coat & Crack Filling Project PW-058 (190,320) 0 (252,000) (288,000) (78,000)Total (190,320) 0 (252,000) (288,000) (78,000)Total Expenditures and Uses 1,390,575 1,390,575 1,138,575 850,575 772,575Ending Balance (190,320) 0 (252,000) (288,000) (78,000)Change in Fund Balance Tuesday, May 23, 2023Page 1DRAFT for 2021-2030 7/29/2022 300s DEBT Source FY '23 FY '24 FY '25 FY '26 FY '27 74,158 74,158 (3,500,842) (3,500,842) (3,500,842)Beginning Balance Revenues and Other Fund Sources 0 0 0 0 0No Funds 0 0 0 0 0Total 74,158 74,158 (3,500,842) (3,500,842) (3,500,842)Total Funds Available 0 0 0 0 0Total Revenues and Other Fund Sources Expenditures and Uses Capital Projects & Equipment Road Projects 0 (3,575,000) 0 0 02024 Street Reconstruction Project PW-034 0 (3,575,000) 0 0 0Total 0 (3,575,000) 0 0 0Total Expenditures and Uses 74,158 (3,500,842) (3,500,842) (3,500,842) (3,500,842)Ending Balance 0 (3,575,000) 0 0 0Change in Fund Balance Tuesday, May 23, 2023Page 2DRAFT for 2021-2030 7/29/2022 401 Capital Improvement Fund Source FY '23 FY '24 FY '25 FY '26 FY '27 754,297 411,697 1,348,403 1,087,441 1,104,977Beginning 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,176,697 1,710,965 1,843,986 1,200,017 1,183,060Total 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 (432,000) (304,163) 0 0 0Broadband Development Grants to MIDCO A-008 (50,000) 0 0 0 0County Ped & Bicycle Accomodations A-012 (482,000) (304,163) 0 0 0Total Community Center (40,000) 0 0 0 0Council Chambers remodel CC-013 (14,000) 0 0 0 0Security Improvements CCTV for Park CC-014 0 0 (37,960) 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 (14,000) 0 0 0 0CCTV for Park at Community Center CC-019 (68,000) 0 (55,508) 0 (189,798)Total Fire 0 0 (17,548) 0 02010 Fire Radios Replace 3 unspupported radios F-003 0 0 0 (11,699) 0Fire/PW Potable Well Pump (2000) Replacement F-008 0 0 (31,633) 0 0new Warning Sirens F-009 0 0 0 0 (227,757)Second Fire Station F-016 0 0 (17,548) 0 02015 Lucas CPR Device-replacement F-027 0 (58,399) 0 0 0new Exhaust removal system for truck bays F-032 0 0 0 (42,583) 02012 UTV & Trailer replacement-off road rescue F-033 0 0 0 (9,733) 02017 Thermal Imaging Cameras (1of3) find hot spots F-034 0 0 (40,945) 0 02010 Homatro Cutter Twin Line R-1(Jaws of Life)F-037 (65,000) 0 0 0 0Wall Panel Joint Replacement Fire Hall-leaking F-039 0 0 0 (21,900) 02000 Station Bay floor epoxy coating-maintenance F-041 0 0 0 (9,125) 02010 Washer/Extractor-replacement F-042 (65,000) (58,399) (107,674) (95,040) (227,757)Total Parks and Recreation 0 0 (177,145) 0 0Arts & Heritage Center Amphitheater PR-052 Tuesday, May 23, 2023Page 3DRAFT for 2021-2030 7/29/2022 401 Capital Improvement Fund Source FY '23 FY '24 FY '25 FY '26 FY '27 0 0 (195,143) 0 0Arts & Heritage Center Sidewalk and Walkways PR-065 (50,000) 0 0 0 0County Ped & Bicycle Accomodations PR-069 (50,000) 0 (372,288) 0 0Total Public Works 0 0 (81,890) 0 0Cold Storage Building PW-047 0 0 (81,890) 0 0Total Stormwater (100,000) 0 (139,185) 0 0Bliss Additions Stormwater plan SW-003 (100,000) 0 (139,185) 0 0Total (765,000) (362,562) (756,545) (95,040) (417,555)Total Expenditures and Uses 411,697 1,348,403 1,087,441 1,104,977 765,505Ending Balance (342,600) 936,706 (260,962) 17,536 (339,472)Change in Fund Balance Tuesday, May 23, 2023Page 4DRAFT for 2021-2030 7/29/2022 404 Park Improvement Fund Source FY '23 FY '24 FY '25 FY '26 FY '27 138,797 129,461 (17,160) (87,187) (87,835)Beginning 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 181,863 172,461 55,840 (14,187) (14,835)Total 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 (78,009) 0 0Playground Equipment - Erickson ballfield PR-044 (35,096) 0 0 0 0Gateway Trail Improvements @ Annex PR-045 0 0 (49,953) 0 0Nature park trails PR-048 0 0 0 0 (128,083)Hay Lake Park Shelter water & doors PR-050 (8,653) 0 0 0 0Hay Lake Park - sign PR-054 0 (46,375) 0 0 0Lilleskogen Park Picnic Shelter PR-055 0 0 (15,065) 0 0Lilleskogen Praire/Wetland Restoration Project PR-057 0 0 0 0 (16,010)Expanded Pleasure Rink PR-058 0 0 0 0 (56,036)New Ballfield to Replace South Ball Field PR-059 0 (143,246) 0 0 0Replace rink boards PR-061 (8,653) 0 0 0 0Park signage at Orwell Park (Liten)PR-063 0 0 0 (73,648) 0Tennis Court/Pickle Ball - repaint PR-064 0 0 0 0 (48,032)Settlers MonutPossible Reloc/Imp PR-066 (52,402) (189,621) (143,027) (73,648) (248,161)Total (52,402) (189,621) (143,027) (73,648) (248,161)Total Expenditures and Uses 129,461 (17,160) (87,187) (87,835) (262,996)Ending Balance (9,336) (146,621) (70,027) (648) (175,161)Change in Fund Balance Tuesday, May 23, 2023Page 5DRAFT for 2021-2030 7/29/2022 406 Equipment Replacement Fund Source FY '23 FY '24 FY '25 FY '26 FY '27 200,548 669,048 646,498 (293,886) (660,885)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,485,548 819,727 798,177 (187,207) (554,206)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,000) 0 0 0 02003 Tanker 5178 Tender 2 Replacement F-014 0 0 (958,114) 0 02000 Engine 1 - 5176 Replacement F-015 (38,000) 0 0 0 02003 Boat & Trailer - water rescues F-028 (86,500) 0 0 0 01995 Utility 1misc purpose truck - replacement F-040 (416,500) 0 (958,114) 0 0Total Public Works 0 (73,116) 0 0 0303-17 Kubota F39000 Mower w/Broom & Blower (2017) PW-005 0 0 (45,624) 0 0312-08 Asphalt Patching Equipment Trailer (2008)PW-012 0 (73,116) 0 0 0308-12 New Holland Skit Steer (2012)PW-015 0 0 0 0 (607,353)301-98 John Deere Motor Grader (1998)PW-016 (325,000) 0 0 0 0203-11 Mack Dump Truck/Plow Replacement (2011) PW-017 (75,000) 0 0 0 0104-13 Ford F550 w/sander, plow mount, compressor PW-022 0 0 0 (473,678) 0201-14 Mack Single Axle w/Plow (2014)PW-063 0 0 (9,359) 0 0Utility Trailer 3,500 lbs (1998)PW-065 0 0 (19,888) 0 0PJ Skid Trailer 14,000 lbs (2012)PW-066 0 (26,997) 0 0 0Equipment Attachments (fit skid, loader, tractor)PW-067 0 0 (59,078) 0 0Addition Vehicle (truck for addl FT or PT staff)PW-068 (400,000) (173,229) (133,949) (473,678) (607,353)Total (816,500) (173,229) (1,092,063) (473,678) (607,353)Total Expenditures and Uses 669,048 646,498 (293,886) (660,885) (1,161,559)Ending Balance 468,500 (22,550) (940,384) (366,999) (500,674)Change in Fund Balance Tuesday, May 23, 2023Page 6DRAFT for 2021-2030 7/29/2022 408 Local Road Improvement Fund Source FY '23 FY '24 FY '25 FY '26 FY '27 932,798 (1,520,087) 1,264,511 (1,141,806) (3,668,429)Beginning 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,294,913 1,264,511 1,913,194 (933,429) (1,284,142)Total 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 (1,045,000) 0 0 0 02030 Street Reconstruction Project PW-072 (965,000) 0 0 0 02031 Street Reconstruction Project PW-073 (2,010,000) 0 0 0 0Total Road Projects 0 0 0 (2,735,000) 02026 Street Reconstruction Project PW-035 (780,000) 0 0 0 02023 Street Reconstruction Project PW-043 0 0 (3,030,000) 0 02025 Street Reconstruction Project PW-053 0 0 0 0 (1,225,000)2027 Street Reconstruction Project PW-057 (25,000) 0 0 0 0Soil Borings for 2024 & 2025 PW-061 0 0 (25,000) 0 0Soil Borings for 2026 & 2027 PW-062 0 0 0 0 (28,000)Soil Borings for 2028 & 2029 PW-069 (805,000) 0 (3,055,000) (2,735,000) (1,253,000)Total (2,815,000) 0 (3,055,000) (2,735,000) (1,253,000)Total Expenditures and Uses (1,520,087) 1,264,511 (1,141,806) (3,668,429) (2,537,142)Ending Balance (2,452,885) 2,784,598 (2,406,317) (2,526,623) 1,131,287Change in Fund Balance Tuesday, May 23, 2023Page 7DRAFT for 2021-2030 7/29/2022 602 Big Marine Sewer Fund Source FY '23 FY '24 FY '25 FY '26 FY '27 69,668 36,718 993,468 (678,182) (954,232)Beginning Balance Revenues and Other Fund Sources Revenue 141,900 177,400 211,800 266,100 319,3001. Charges for Service 600 600 600 600 6002. Special Assessments 400 800 900 1,000 1,6004. Interest 0 456,400 0 0 05. American Rescue Plan Act Fund 0 500,000 0 430,000 450,0006. Bond Proceeds 142,900 1,135,200 213,300 697,700 771,500Total 212,568 1,171,918 1,206,768 19,518 (182,732)Total Funds Available 142,900 1,135,200 213,300 697,700 771,500Total Revenues and Other Fund Sources Expenditures and Uses Capital Projects & Equipment Big Marine Sewer 0 0 (60,000) 0 0A/E Drainfield 201S-002 0 0 (1,600,000) 0 0Bliss nitrate treatment equipment 201S-005 (2,500) 0 0 (350,000) 0Bliss LS 1 201S-006 (2,500) 0 0 0 (350,000)Bliss 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 (19,250) (18,750) (1,680,250) (765,750) (415,750)Total Other Uses (26,600) (27,100) (27,600) (28,200) (28,800)1. Compensation of Personnel (5,400) (5,500) (5,600) (5,700) (5,800)2. Materials (24,400) (24,900) (25,400) (25,900) (26,400)3. Professional Services (36,400) (37,100) (37,800) (38,600) (39,400)4. Repair and Maintenance (9,500) (9,700) (9,900) (10,100) (10,300)5. Other (54,300) (55,400) (56,500) (57,600) (58,800)6. Depreciation 0 0 (41,900) (41,900) (77,900)7. Debt Service (Principal/Interest) (156,600) (159,700) (204,700) (208,000) (247,400)Total (175,850) (178,450) (1,884,950) (973,750) (663,150)Total Expenditures and Uses Tuesday, May 23, 2023Page 8DRAFT for 2021-2030 7/29/2022 602 Big Marine Sewer Fund Source FY '23 FY '24 FY '25 FY '26 FY '27 36,718 993,468 (678,182) (954,232) (845,882)Ending Balance (32,950) 956,750 (1,671,650) (276,050) 108,350Change in Fund Balance Tuesday, May 23, 2023Page 9DRAFT for 2021-2030 7/29/2022 612 Uptown Sewer Fund Source FY '23 FY '24 FY '25 FY '26 FY '27 14,022 10,472 583,472 590,572 610,972Beginning Balance Revenues and Other Fund Sources Revenue 27,700 34,300 41,900 51,100 62,3001. Charges for Service 0 0 0 0 02. Special Asssessments 0 0 0 0 03. Intergovernmental/Grants 200 200 300 500 9004. Interest 0 0 0 0 05. Miscellaneous 0 570,000 0 0 06. Arts and Heritage Barn Expansion 27,900 604,500 42,200 51,600 63,200Total 41,922 614,972 625,672 642,172 674,172Total Funds Available 27,900 604,500 42,200 51,600 63,200Total Revenues and Other Fund Sources Expenditures and Uses Capital Projects & Equipment Uptown Sewer 0 0 (4,500) 0 0Drain field Blower US-003 (1,000) (2,500) (1,000) (1,000) (30,000)Uptown Lift Station Replacement US-004 (2,500) (500) (500) (500) (500)Drainfield Lift Station Replacement US-006 (1,000) (1,000) (1,000) (1,000) (1,000)Repairs-TBD (Tanks/Castings/etc)US-009 (4,500) (4,000) (7,000) (2,500) (31,500)Total Other Uses (11,300) (11,500) (11,700) (11,900) (12,100)1. Compensation of Personnel (700) (700) (700) (700) (700)2. Materials (3,150) (3,200) (3,300) (3,400) (3,500)3. Professional Services (4,200) (4,300) (4,400) (4,500) (4,600)4. Repair and Maintenance (2,500) (2,600) (2,700) (2,800) (2,900)5. Other (5,100) (5,200) (5,300) (5,400) (5,500)6. Depreciation 0 0 0 0 07. Debt Service (Principal and Interest) (26,950) (27,500) (28,100) (28,700) (29,300)Total (31,450) (31,500) (35,100) (31,200) (60,800)Total Expenditures and Uses 10,472 583,472 590,572 610,972 613,372Ending Balance (3,550) 573,000 7,100 20,400 2,400Change in Fund Balance Tuesday, May 23, 2023Page 10DRAFT for 2021-2030 7/29/2022