Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
406 Fund - Public Works
1 CITY OF SCANDIA 2 Capital Improvement Plan 3 Public Works Fund 406 4 5 Inflation Assumptions 6 Revenue (Non-property tax) 2.00% 2.00% 2.00% 2.00% 2.00% 2.00% 2.00% 2.00% 2.00% 2.00% 7 Interest Earnings 1.50% 1.50% 1.50% 1.50% 1.50% 1.50% 1.50% 1.50% 1.50% 1.50% 8 Expenses 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 9 CIP Inflation Factor (thru Jun of the previous year) 4.05% 3.36% 3.53% 2.00% 2.00% 2.00% 2.00% 2.00% 2.00% 2.00% 10 11 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 12 Audited Approved Proposed 13 ANNUAL TAX LEVY 125,000 50,000 51,250 52,275 53,321 54,387 55,475 56,585 57,717 58,871 14 Percent Change in Annual Tax Levy 13.64% -60.00% 2.50% 2.00% 2.00% 2.00% 2.00% 2.00% 2.00% 2.00% 15 16 REVENUE 17 Property Taxes 125,000 50,000 51,250 52,275 53,321 54,387 55,475 56,585 57,717 58,871 18 Franchise Taxes - - - - - - - - - - 19 Special Assessments - - - - - - - - - - 20 Licenses, Permits, and Fees - - - - - - - - - - 21 Intergovernmental - - - - - - - - - - 22 Charges for Services - - - - - - - - - - 23 Fines & Forfeits - - - - - - - - - - 24 Investment Earnings (Losses) 5,534 - - - - - - - - - 25 Miscellaneous Revenues 174,965 - - - - - - - - - 26 Total Revenue 305,499 50,000 51,250 52,275 53,321 54,387 55,475 56,585 57,717 58,871 27 28 EXPENSES 29 Current 30 General Government - - - - - - - - - - 31 Public Safety - - - - - - - - - - 32 Public Works 13,249 - - - - - - - - - 33 Parks and Recreation - - - - - - - - - - 34 Economic Development - - - - - - - - - - 35 Total Capital Projects 1,370,354 40,000 375,000 104,000 467,000 306,000 62,000 - - 150,000 36 Long Term Debt Principal - - - - - - - - - - 37 Long Term Debt Interest and Fiscal Agent Fees - - - - - - - - - - 38 Total Expenses 1,383,603 40,000 375,000 104,000 467,000 306,000 62,000 - - 150,000 39 40 Revenue Over / (Under) Expenses (1,078,104) 10,000 (323,750) (51,725) (413,679) (251,613) (6,525) 56,585 57,717 (91,129) 41 42 OTHER FINANCING SOURCES / (USES) 43 Bond Issuance and Premiums 640,000 - 350,000 - 450,000 300,000 - 350,000 - - 44 Sale of Capital Assets - - - - - - - - - - 45 Transfers In - - - - - - - - - - 46 Transfers Out - - - - - - - - - - 47 Total Other Sources / (Uses) 640,000 - 350,000 - 450,000 300,000 - 350,000 - - 48 49 Prior Period Adjustments - - - - - - - - - - 50 Ending Fund Balance 30,000 40,000 66,250 14,525 50,846 99,233 92,708 499,293 557,010 465,881 51CASH FLOW ANALYSIS 1 CITY OF SCANDIA 2 Capital Improvement Plan 3 Public Works Fund 406 4 5 Inflation Assumptions 6 Revenue (Non-property tax) 2.00% 2.00% 2.00% 2.00% 2.00% 2.00% 2.00% 2.00% 2.00% 2.00% 7 Interest Earnings 1.50% 1.50% 1.50% 1.50% 1.50% 1.50% 1.50% 1.50% 1.50% 1.50% 8 Expenses 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 9 CIP Inflation Factor (thru Jun of the previous year) 4.05% 3.36% 3.53% 2.00% 2.00% 2.00% 2.00% 2.00% 2.00% 2.00% 10 52 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 53 Priority Project #Capital Project Name Audited Approved Proposed 55 Fire Engine-1-25 2025 Kenworth Pumper 663,828 56 Fire 2003 Tanker 5178 Tender 2 Replacement 286,787 61 PW-007 312-08 Asphalt Patching Equipment Trailer (2008) 25,000 62 PW-010 201-14 Mack Single Axle w/Plow (2014) 415,000 63 PW-011 202-17 Western Star Single Axle Truck/Plow (2017) 350,000 64 PW-012 203-11 Mack Dump Truck/Plow Replacement (2011) 305,509 65 PW-014 John Deere 6130M (2021) tractor w/ attachments 66 PW-015 New Holland 325 Skid Steer (2024) 68 PW-018 101-18 Chev 1/2 ton pickup (2018) 44,000 69 PW-019 102-19 Dodge 3500 SRW w/plow (2019) 52,000 70 PW-020 103-21 Dodge 2500 w/plow (2021) 62,000 71 PW-021 Ford F550 Dump Truck (2024) 150,000 72 PW-025 John Deere 1575 w/ broom and blower 115,000 73 PW-026 304-21 Kubota UTV (2021) 16,000 74 PW-027 Addition Vehicle (truck for addl FT or PT staff) 60,000 76 PW-029 PJ Skid Trailer 14,000 lbs (2012) 20,000 77 PW-031 Utility Trailer 3,500 lbs (1998) 10,000 78 Pressure Washer 10,000 79 John Deere 324L Loader 175,000 80 81 Budget Deviation (Over/Under) 114,230 - - - - - - - - - 82 1,370,354 40,000 375,000 104,000 467,000 306,000 62,000 - - 150,000