Loading...
HomeMy WebLinkAboutItem #1 Budget PresentationI Y 3s_c:.y z� Public Works Dept. FY24 Preliminary Budget Presentation Highways, Streets, and Roads Budget Highlights • Budget includes $275,000 for new sweeper and small snow plow in accordance with Capital Equipment Plan. • Budget includes $404,400 for Pavement Maintenance to result in a balanced budget (expenses=revenue) • Pavement Management Plan shows a need for a minimum of $1.1M per year on pavement maintenance to maintain current pavement conditions. • Identified need of $695,600 to meet pavement management plan. • TIF Allocation following current split of property taxes would result in an additional $117,000 which could be used for pavement maint. Budget Request Summary FY23 Final Budget FY24 Proposed Budget $$$ Change % Change ESTIMATED Revenue $2,300,000.00 $2,474,000.00 $174,000.00 7.6% Wages & Benefits $778,700.00 $887,500.00 $108,800.00 13.97% Administration $276,200.00 $305,800.00 $29,600.00 10.72% H Operational Expenses (including Capital Equip. and Pavement Maint.) $1,109,100.00 $1,144,700.00 $35,600.00 3.21% Z W Additional Services $0.00 $0.00 $0.00 Debt Service $136,000.00 $136,000.00 $0.00 0.00% a W Q Total Planned Expenses $2,300,000.00 $2,474,000.00 $174,000.00 7.6% oc Capital Equipment (included in Operational Expenses above) $0.00 $275,000.00 $275,000.00 Pavement Maintenance (included in Operational Expenses above) $547,400.00 $404,400.00 -$143,000.00 Expenses Exceeding Revenue $0.00 $0.00 $0.00 Identified Additional Needs $695,600.00 Budget Highlights • Budget includes $275,000 for new sweeper and small snow plow in accordance with Capital Equipment Plan. • Budget includes $404,400 for Pavement Maintenance to result in a balanced budget (expenses=revenue) • Pavement Management Plan shows a need for a minimum of $1.1M per year on pavement maintenance to maintain current pavement conditions. • Identified need of $695,600 to meet pavement management plan. • TIF Allocation following current split of property taxes would result in an additional $117,000 which could be used for pavement maint. HSR Line Item Budget Summary FY23 Final Budget FY24 Proposed Budget $$$ Change % Change Wages & Benefits $778,700.00 $887,500.00 $108,800.00 14% Administration $276,200.00 $305,800.00 $29,600.00 11% Asphalt Maintenance $602,400.00 $459,400.00 -$143,000.00 -24% Pavement Markings $25,000.00 $35,000.00 $10,000.00 40% Signing $13,000.00 $13,000.00 $0.00 0% Sweeping $1,500.00 $23,000.00 $21,500.00 1433% N Snow Removal $16,000.00 $35,500.00 $4,500.00 28% CL Sidewalks $31,000.00 $46,000.00 $15,000.00 48% x LU 7E Shoulders $11,000.00 $11,000.00 $0.00 0% c Street Illumination $91,500.00 $121,000.00 $29,500.00 32% W Traffic Signals $13,000.00 $13,000.00 $0.00 0% p Storm Drains $84,000.00 $34,000.00 -$50,000.00 -60% Roadway Projects $25,000.00 $0.00 -$25,000.00 -100% Equipment Expenses $192,500.00 $347,500.00 $155,000.00 81% Safety $3,200.00 $6,300.00 $3,100.00 97% Additional Service $0.00 $0.00 $0.00 0% Debt Service $136,000.00 $136,000.00 $0.00 0% Total $2,300,000.00 $2,474,000.00 $174,000.00 8% Equipment ExpensesSafety 14% 1 0% Roadway Projects 0% Storm Drains 1% Traffic Signals 1% Street Illumination 5% Shoulders 0% Sidewalks 2% Snow Removal 1% Sweeping 1% Signing Pavement Markings 1% 1% Additional Service 0% Debt Service 5% Asphalt Maintenance 19% Wages & Benefits 36% Administration 12% 5 Sanitation Department Budget Highlights • Significant increase in Wages and Related Expenses, compared to FY23 Budget. 10.5% increase compared to actuals. • No major projects planned for yard (included in Administration budget). • Increased Landfill costs based on FY22 actuals. • Planning for one new truck in accordance with Equipment Capital Plan. • Planning to conduct rate study in FY24. Budget Request Summary FY23 Final Budget FY24 Proposed Budget $$$ Change % Change ESTIMATED Revenue $2,139,900.00 $2,191,000.00 $51,100.00 2.4% Wages & Benefits $955,100.00 $1,159,000.00 $203,900.00 21.3% Z Administration $736,500.00 $499,000.00 -$237,500.00 -32.2% 5NJ I— Operational Expenses (including Capital Equip.) $751,300.00 $1,227,300.00 $476,000.00 63.4% Additional Services $0.00 $0.00 $0.00 a W a Total Planned Expenses $2,442,900.00 $2,885,300.00 $442,400.00 18.1% Z O I— H Z a Capital Equipment (included in Operational Expenses above) $0.00 $350,000.00 $350,000.00 (A Capital Projects (included in Operational Expenses above) $0.00 $0.00 $0.00 Expenses Exceeding Revenue $303,000.00 $694,300.00 $391,300.00 Source of Funding for Overage Fund Balance Budget Highlights • Significant increase in Wages and Related Expenses, compared to FY23 Budget. 10.5% increase compared to actuals. • No major projects planned for yard (included in Administration budget). • Increased Landfill costs based on FY22 actuals. • Planning for one new truck in accordance with Equipment Capital Plan. • Planning to conduct rate study in FY24. Sanitation Line Item Budget Summary FY23 Final Budget FY24 Proposed Budget $$$ Change % Change Wages & Benefits $955,100.00 $1,159,000.00 $203,900.00 21% Administration $736,500.00 $499,000.00 -$237,500.00 -32% Residential Service Expenses $230,000.00 $272,000.00 $42,000.00 o 18/ Commercial Service Expenses $123,000.00 $140,000.00 $17,000.00 o 14/ N a Roll off Service Expenses $76,000.00 $106,500.00 $30,500.00 a 40% CL W Recycle Service Expenses $32,000.00 $62,500.00 $30,500.00 o 95/ � ° a Additional Service $0.00 $0.00 $0.00 a� O Equipment Expenses (including New Equip.) $285,000.00 $641,000.00 $356,000.00 125% Safety $5,300.00 $5,300.00 $0.00 0% Total $2,442,900.00 $2,885,300.00 $442,400.00 18% Equipment Expenses (including New Equip.) 22% Additional Service 0% Recycle Service Expenses 2% Roll off Service Expenses 4% Commercial Service Expenses 5% Residential Service Expenses 10% Safety 0% Wages & Benefits 40% Administration 17% O Water Department 10 Budget Highlights • Assumes an annual 5% increase in rates in accordance with the recent rate study. • Includes 1 additional employee, split between Water and Wastewater Depts. which was planned for FY23. • Majority of Capital Improvement Plan from FY23 has been moved to FY24 — currently underway with planning study. • Majority of Equipment Capital Planning budget eliminated and will remain in Fund Balance (we're not showing it as an expense to then fall to the fund balance) Budget Request Summary FY23 Final Budget FY24 Proposed Budget $$$ Change % Change ESTIMATED Revenue (Utility Rates) $3,106,500.00 $3,252,300.00 $92,800.00 3.0% Wages & Benefits $1,098,800.00 $1,195,300.00 $96,500.00 8.78% Administration $416,500.00 $489,000.00 $72,500.00 17.41% Operational Expense (including CIP) $2,561,000.00 $2,504,100.00 -$56,900.00 -2.22% Z W Additional Services $0.00 $0.00 $0.00 0% Debt Service $625,000.00 $750,000.00 $125,000.00 20% H GC aTotal Planned Expenses $4,701,300.00 $4,938,400.00 $237,100.00 5.0% LLI IO GC W Q Capital Equipment (included in Operational Expenses above) $75,000.00 $0.00 -$75,000.00 Capital Projects (included in Operational Expenses above) $1,519,800.00 $1,519,800.00 $0.00 Expenses Exceeding Revenue $1,594,800.00 $1,686,100.00 $91,300.00 Source of Funding for Overage • Rate Increase • Fund Balance • Previously Collected Capacity Fees Budget Highlights • Assumes an annual 5% increase in rates in accordance with the recent rate study. • Includes 1 additional employee, split between Water and Wastewater Depts. which was planned for FY23. • Majority of Capital Improvement Plan from FY23 has been moved to FY24 — currently underway with planning study. • Majority of Equipment Capital Planning budget eliminated and will remain in Fund Balance (we're not showing it as an expense to then fall to the fund balance) Water Line Item Budget Summary FY23 Final Budget FY24 Proposed Budget $$$ Change % Change Wages & Benefits $1,098,800.00 $1,195,300.00 $96,500.00 8.8% Administration $416,500.00 $489,000.00 $72,500.00 17.4% Production & Storage $353,900.00 $372,000.00 $18,100.00 5.11% Distribution System and CIP $1,767,300.00 $1,772,800.00 $5,500.00 0.31% N Q Meter / Service Connections $72,800.00 $74,500.00 $1,700.00 2.34% X W Fire Protections $25,000.00 $25,000.00 $0.00 0.00% o Pressure Irrigation $133,000.00 $142,000.00 $9,000.00 6.77% Additional Service $0.00 $0.00 $0.00 0% 0 Equipment Expenses $202,000.00 $110,000.00 -$92,000.00 -45.54% Safety $7,000.00 $7,800.00 $800.00 11.43% Debt Service $625,000.00 $750,000.00 $125,000.00 20.00% Total $4,701,300.00 $4,938,400.00 $237,100.00 5.04% Debt Service 15% Sa!ety Wages & Benefits ° 24 Equipment Expenses 2% Additional Service 0% Pressure Irrigation 3% Fire Protections 0% Administration 10% Meter / Service Connections 2% Production & Storage Distribution System and CIP g% 36% 13 Wastewater Department 14 Budget Highlights • Assumes an annual 3.5% increase in rates in accordance with the recent rate study. • Includes 1 additional employee, split between Water and Wastewater Depts. which was planned for FY23. • Significant Capital Projects Planned for FY24 in accordance with Rate Study and CIP. Budget Request Summary FY23 Final Budget FY24 Proposed Budget $$$ Change % Change ESTIMATED Revenue (Utility Rates) $3,506,000.00 $3,721,000.00 $222,000.00 6.3% Wages & Benefits $914,400.00 $1,031,700.00 $117,300.00 12.83% Z Administration $440,500.00 $442,700.00 $2,200.00 0.50% c Operational Expense (including CIP) $2,303,100.00 $4,889,600.00 $2,586,500.00 112.31% Additional Services $15,000.00 $0.00 -$15,000.00 -100.00% a Debt Service $0.00 $0.00 $0.00 W CC Total Planned Expenses $3,673,000.00 $6,364,000.00 $2,691,000.00 73.3% W Q W NExpenses Capital Equipment (included in Operational above) $0.00 $0.00 $0.00 Capital Projects (included in Operational Expenses above) $0.00 $3,039,000.00 $3,039,000.00 Expenses Exceeding Revenue $167,000.00 $2,643,000.00 $2,476,000.00 Source of Funding for Overage Ratelncrease Fund Balance Previously Collected Capacity Fees Budget Highlights • Assumes an annual 3.5% increase in rates in accordance with the recent rate study. • Includes 1 additional employee, split between Water and Wastewater Depts. which was planned for FY23. • Significant Capital Projects Planned for FY24 in accordance with Rate Study and CIP. Wastewater Line Item Budget Summary FY23 Final Budget FY24 Proposed Budget $$$ Change % Change Wages & Benefits $914,400.00 $1,031,700.00 $117,300.00 12.83% Administration $440,500.00 $442,700.00 $2,200.00 0.50% Collection System and CIP $287,500.00 $187,000.00 -$100,500.00 -34.96% Treatment / Pretreatment $1,600,800.00 $1,600,800.00 $0.00 0.00% N a, N C N X Pumping and CIP $363,000.00 $3,000,000.00 $2,662,000.00 733.33% W f4 C O L Additional Service $15,000.00 $0.00 -$15,000.00 -100.00% Q 0 Equipment Expenses $47,000.00 $95,000.00 $48,000.00 102.13% Safety $4,800.00 $6,800.00 $2,000.00 41.67% Debt Service $0.00 $0.00 $0.00 Total $3,688,000.00 $6,364,000.00 $2,676,000.00 72.56% Equipment Expenses 2% Additional Service 0% Pumping and CIP 47% Safety -Debt Service 0% 0% Wages & Benefits 16% Administration 7% Collection System and CIP 3% Treatement / Pretreatment 25% 17 r Public Works Dept. FY24 Preliminary Budget Presentation Highways, Streets, and Roads Budget Highlights • Budget includes $275,000 for new sweeper and small snow plow in accordance with Capital Equipment Plan. • Budget includes $404,400 for Pavement Maintenance to result in a balanced budget (expenses=revenue) Pavement Management Plan shows a need for a minimum of $1.1M per year on pavement maintenance to maintain current pavement conditions. • Identified need of $695,600 to meet pavement management plan. TIF Allocation following current split of property taxes would result in an additional $117,000 which could be used for pavement maint. Budget Request Summary FY23 Final Budget FY24 Proposed Budget $$$ Change % Change ESTIMATED Revenue $2,300,000.00 $2,474,000.00 $174,000.00 7.6% Wages & Benefits $778,700.00 $887,500.00 $108,800.00 13.97% Administration $276,200.00 $305,800.00 $29,600.00 10.72% I— Operational Expenses (including Capital Equip. and Pavement Maint.) $1,109,100.00 $1,144,700.00 $35,600.00 3.21% Z W Additional Services $0.00 $0.00 $0.00 0~C Debt Service $136,000.00 $136,000.00 $0.00 0.00% a W Q Total Planned Expenses $2,300,000.00 $2,474,000.00 $174,000.00 7.6% cc 2 Capital Equipment (included in Operational Expenses above) $0.00 $275,000.00 $275,000.00 Pavement Maintenance (included in Operational Expenses above) $547,400.00 $404,400.00 -$143,000.00 Expenses Exceeding Revenue $0.00 $0.00 $0.00 Identified Additional Needs $695,600.00 Budget Highlights • Budget includes $275,000 for new sweeper and small snow plow in accordance with Capital Equipment Plan. • Budget includes $404,400 for Pavement Maintenance to result in a balanced budget (expenses=revenue) Pavement Management Plan shows a need for a minimum of $1.1M per year on pavement maintenance to maintain current pavement conditions. • Identified need of $695,600 to meet pavement management plan. TIF Allocation following current split of property taxes would result in an additional $117,000 which could be used for pavement maint. Highway, Streets, and Roads Line Item Budget Summary FY23 Final Budget FY24 Proposed Budget $$$ Change % Change Wages & Benefits $778,700.00 $887,500.00 $108,800.00 14% Administration $276,200.00 $305,800.00 $29,600.00 11% Asphalt Maintenance $602,400.00 $459,400.00 -$143,000.00 -24% Pavement Markings $25,000.00 $35,000.00 $10,000.00 40% Signing $13,000.00 $13,000.00 $0.00 0% Sweeping $1,500.00 $23,000.00 $21,500.00 1433% Snow Removal $16,000.00 $35,500.00 $4,500.00 28% X Sidewalks $31,000.00 $46,000.00 $15,000.00 48% "' Shoulders $11,000.00 $11,000.00 $0.00 0% C Street Illumination $91,500.00 $121,000.00 $29,500.00 32% M Traffic Signals $13,000.00 $13,000.00 $0.00 0% a Storm Drains $84,000.00 $34,000.00 -$50,000.00 -60% O Roadway Projects $25,000.00 $0.00 -$25,000.00 -100% Equipment Expenses (including new equip.) $192,500.00 $347,500.00 $155,000.00 81% Safety $3,200.00 $6,300.00 $3,100.00 97% Additional Service $0.00 $0.00 $0.00 Debt Service $136,000.00 $136,000.00 $0.00 0% Totall $2,300,000.00 $2,474,000.00 $174,000.00 8% Equipment Expenses (including new equip.) Safety Additional Service Debt Service 14% 0% 0% _ 5% Roadway Projects 0% Storm Drains 1% Traffic Signals 1% Street Illumination 5% Shoulders - - 0% Sidewalks 2% Snow Removal 1% Sweeping 1% Signing Pavement Markings Asphalt Maintenance 1% 1% 19% Wages & Benefits 36% Administration 12% Highway, Streets, and Roads Department Asphalt Maintenance 11-4340-100 Crack seal $ FY23 Final Budget $ FY24 Draft Budget $ $$$ Change % Change Wages & Benefits Asphalt Patching $ 10,000.00 $ 10,000.00 $ - 0.00% 11-4311-110 Salaries $ 488,600.00 $ 558,000.00 $ 69,400.00 14.2% 11-4311-111 Overtime $ 17,000.00 $ 22,000.00 $ 5,000.00 29.4% 11-4311-210 FICA $ 39,400.00 $ 43,000.00 $ 3,600.00 9.1% 11-4311-220 Retirement $ 62,800.00 $ 69,000.00 $ 6,200.00 9.9% 11-4311-240 Workmens Compensation $ 11,100.00 $ 14,500.00 $ 3,400.00 30.6% 11-4311-250 Health Insurance $ 159,800.00 $ 181,000.00 $ 21,200.00 13.3% 11-4311-260 Unemployment $ - $ - $ - -50.00% $ 778,700.00 $ 887,500.00 $ 108,800.00 14.0% Support Services 11-4312-100 Engineering $ - $ - $ - 0.00% 11-4312-110 Planning / Development $ - $ - $ - 0.00% 11-4312-120 Fleet Maintenance $ - $ - $ - 11-4312-130 I.T. $ - $ - $ - 11-4312-140 Utility Billing $ - $ - $ - 11-4312-150 Finance $ - $ - $ - 11-4312-160 Human Resources $ - $ - $ - 11-4312-170 Administration $ - $ - $ - Administration 11-4333-100 Billing Expense $ - $ - $ - 11-4333-110 Certifications / Licensing $ 800.00 $ 800.00 $ - 0.00% 11-4333-120 City Hall Lease $ 78,000.00 $ 78,000.00 $ - 0.00% 11-4333-130 City Hall Operations $ 14,000.00 $ 14,000.00 $ - 0.00% 11-4333-140 Computer/ I.T. Hardware $ 20,000.00 $ 47,000.00 $ 27,000.00 135.00% 11-4333-150 Computer/ I.T. Software $ 30,000.00 $ 24,000.00 $ (6,000.00) -20.00% 11-4333-160 Employee Contunuing Education $ - $ - $ - 11-4333-170 Employee Phone Stipend $ 500.00 $ 500.00 $ - 0.00% 11-4333-180 Employee Recognition $ 1,300.00 $ 1,500.00 $ 200.00 15.38% 11-4333-190 Equipment Insurance $ - $ - $ - 11-4333-200 Liability Insurance $ - $ - $ - 11-4333-210 Mapping / GIS Systems $ 3,300.00 $ 7,500.00 $ 4,200.00 127.27% 11-4333-220 Memberships / Dues $ 70,000.00 $ 70,000.00 $ - 0.00% 11-4333-230 Office Equipment / Supplies $ 7,500.00 $ 4,000.00 $ (3,500.00) -46.67% 11-4333-240 Professional Services $ 10,000.00 $ 15,000.00 $ 5,000.00 50.00% 11-4333-250 Shop Facility Lease $ - $ - $ - 11-4333-260 Training / Seminars $ 1,800.00 $ 3,000.00 $ 1,200.00 66.67% 11-4333-270 Travel $ - $ 500.00 $ 500.00 11-4333-280 Utility - Telephone $ 6,500.00 $ 7,500.00 $ 1,000.00 15.38% 11-4333-290 Utiltiy - Electrical $ 6,500.00 $ 6,500.00 $ - 0.00% 11-4333-300 Utiltiy - Natural Gas $ 4,000.00 $ 4,000.00 $ - 0.00% 11-4333-310 Facility Maint/Janit $ 10,000.00 $ 5,000.00 $ (5,000.00) -50.00% 11-4333-320 Yard Facility Construction $ 7,000.00 $ 7,000.00 $ - 0.00% 11-4333-330 Yard Facility Operations $ 5,000.00 $ 10,000.00 $ 5,000.00 100.00% $ 276,200.00 $ 305,800.00 $ 29,600.00 10.72% Asphalt Maintenance 11-4340-100 Crack seal $ 10,000.00 $ 10,000.00 $ - 0.00% 11-4340-110 Asphalt Patching $ 10,000.00 $ 10,000.00 $ - 0.00% 11-4340-120 Pothole $ 10,000.00 $ 10,000.00 $ - 0.00% 11-4340-130 Surface Maintenance $ 547,400.00 $ 404,400.00 $ (143,000.00) -26.12% 11-4340-140 Street Construction $ 25,000.00 $ 25,000.00 $ - 0.00% $ 602,400.00 $ 459,400.00 $ (143,000.00) -23.74% Pavement Markings 11-4341-100 Lane Striping $ 5,000.00 $ 25,000.00 $ 20,000.00 400.00% 11-4341-110 Pavement Markings $ 20,000.00 $ 10,000.00 $ (10,000.00) -50.00% $ 25,000.00 $ 35,000.00 $ 10,000.00 40.00% Signing 11-4342-100 Sign Materials $ 13,000.00 $ 13,000.00 $ - 0.00% $ 13,000.00 $ 13,000.00 $ - 0.00% Highway, Streets, and Roads Department Sidewalks 11-4345-100 Maintenance $ FY23 Final Budget $ FY24 Draft Budget $ $$$ Change % Change Sweeping Weed Control $ 5,000.00 $ 5,000.00 $ - 0.00% 11-4343-100 Material Disposal $ 1,500.00 $ 3,000.00 $ 1,500.00 100.00% 11-4343-110 Storage Facility $ - $ 25,000.00 $ - 150.00% 11-4343-xxx Sweeping M&O $ - $ 20,000.00 $ 20,000.00 48.39% Shoulders Power $ 1,500.00 $ 23,000.00 $ 21,500.00 100.00% Snow Removal Maintenance $ 5,000.00 $ 6,000.00 $ 1,000.00 20.00% 11-4344-100 Salt $ 10,000.00 $ 25,000.00 $ 15,000.00 150.00% 11-4344-110 Sand $ 5,000.00 $ - $ (5,000.00) -100.00% 11-4344-120 Brine $ 1,000.00 $ 500.00 $ (500.00) -50.00% 11-4344-xxx Plow M&O $ - $ 10,000.00 $ 10,000.00 0.00% 11-4349-110 Construction / Installation $ 16,000.00 $ 35,500.00 $ 19,500.00 121.88% Sidewalks 11-4345-100 Maintenance $ 15,000.00 $ 1,000.00 $ (14,000.00) -93.33% 11-4345-110 Weed Control $ 5,000.00 $ 5,000.00 $ - 0.00% 11-4345-120 Repairs $ 1,000.00 $ 15,000.00 $ 14,000.00 1400.00% 11-4345-130 ADA $ 10,000.00 $ 25,000.00 $ 15,000.00 150.00% Traffic Signals New Equipment Planning $ 31,000.00 $ 46,000.00 $ 15,000.00 48.39% Shoulders Power $ 5,000.00 $ 5,000.00 $ - 0.00% 11-4346-100 Maintenance $ 5,000.00 $ 6,000.00 $ 1,000.00 20.00% 11-4346-110 Weed Control $ 5,000.00 $ 5,000.00 $ - 0.00% 11-4346-120 Repairs $ 1,000.00 $ - $ (1,000.00) -100.00% Storm Drains Training $ 11,000.00 $ 11,000.00 $ - 0.00% Street Illumination 11-4347-100 Power $ 85,000.00 $ 100,000.00 $ 15,000.00 17.65% 11-4347-110 Construction / Installation $ 500.00 $ 15,000.00 $ 14,500.00 2900.00% 11-4347-120 M&O $ 6,000.00 $ 6,000.00 $ - 0.00% 25,000.00 $ - $ $ 91,500.00 $ 121,000.00 $ 29,500.00 32.24% Traffic Signals New Equipment Planning $ 75,000.00 $ 225,000.00 $ 150,000.00 200.00% 11-4348-100 Power $ 5,000.00 $ 5,000.00 $ - 0.00% 11-4348-110 Construction / Installation $ 3,000.00 $ 3,000.00 $ - 0.00% 11-4348-120 M&O $ 5,000.00 $ 5,000.00 $ - 0.00% Safety $ 13,000.00 $ 13,000.00 $ - 0.00% Storm Drains Training $ 1,200.00 $ 2,000.00 $ 800.00 66.67% 11-4349-100 Cleaning/ Disposal $ 4,000.00 $ 4,000.00 $ - 0.00% 11-4349-110 Construction / Installation $ 75,000.00 $ 25,000.00 $ (50,000.00) -66.67% 11-4349-120 M&O $ 5,000.00 $ 5,000.00 $ - 0.00% $ 84,000.00 $ 34,000.00 $ (50,000.00) -59.52% Roadway Projects 11-4350-100 Siphon Road $ - $ - $ - 11-4350-110 Hawthorne Road $ - $ - $ - 11-4350-120 Hawthorne & Quinn $ 20,000.00 $ - $ (20,000.00) -100.00% 11-4350-130 Sacajawea Roundabout $ 5,000.00 $ - $ (5,000.00) -100.00% $ (25,000.00) $ 25,000.00 $ - $ (25,000.00) -100.00% Equipment Expenses 11-4351-100 Fuel & Lubricants $ 25,000.00 $ 30,000.00 $ 5,000.00 20.00% 11-4351-110 Equipment M & 0 $ 45,000.00 $ 20,000.00 $ (25,000.00) -55.56% 11-4351-120 Vehicle M & 0 $ 45,000.00 $ 20,000.00 $ (25,000.00) -55.56% 11-4351-130 Capital Planning $ - $ - $ - 11-4351-140 New Equipment Planning $ 75,000.00 $ 225,000.00 $ 150,000.00 200.00% 11-4351-150 New Vehicle Planning $ - $ 50,000.00 $ 50,000.00 11-4351-160 Small Tools and Equipment $ 2,500.00 $ 2,500.00 $ - $ 192,500.00 $ 347,500.00 $ 155,000.00 80.52% Safety 11-4352-100 Training $ 1,200.00 $ 2,000.00 $ 800.00 66.67% 11-4352-110 Clothing $ 1,000.00 $ 3,000.00 $ 2,000.00 200.00% 11-4352-120 Equipment $ 500.00 $ 1,000.00 $ 500.00 100.00% 11-4352-130 Testing $ 500.00 $ 300.00 $ (200.00) -40.00% $ 3,200.00 $ 6,300.00 $ 3,100.00 96.88 Highway, Streets, and Roads Department FY23 Final Budget FY24 Draft Budget $$$ Change % Change Additional Service 11-4353-100 Flags $ - $ - $ - 11-4353-110 Banners $ - $ - $ - 11-4353-120 Christmas Decorations $ - $ - $ - 11-4353-130 Chubbuck Days $ - $ - $ - 11-4353-140 Tree Trimming $ - $ - $ - 11-4353-150 Interagency Services $ - $ - $ - Finance / Accounting 11-4380-822 Wastewater Loan $ 136,000.00 $ 136,000.00 $ - 0.00% $ 136,000.00 $ 136,000.00 $ - 0.00% Wages / Benefits $ 778,700.00 $ 887,500.00 $ 108,800.00 13.97% Internal Support Services $ - $ - Administration $ 276,200.00 $ 305,800.00 $ 29,600.00 10.72% Base Services $ 1,109,100.00 $ 1,144,700.00 $ 35,600.00 3.21% Additional Services $ - $ - $ - Debt Service $ 136,000.00 $ 136,000.00 $ - 0.00% Total Expense $ 2,300,000.00 $ 2,474,000.00 $ 174,000.00 7.57% Capital Equipment Summary Item FY23 FY24 FY25 FY26 FY27 Snow Plow Truck $75,000.00 $50,000.00 $75,000.00 Street Sweeper $0.00 $225,000.00 $0.00 $250,000.00 Z Striping Grinder $0.00 5W Asphalt Roller $45,000.00 Q a Total $75,000.00 $275,000.00 $0.00 $370,000.00 $ W QSource of Funds Operations Budget $75,000.00 2 Sweeper Grants Total $75,000.00 $0.00 $0.00 $0.00 $ Total $0.00 -$275,000.00 $0.00 -$370,000.00 $ Capital Projects Request Summary Item FY23 FY24 FY25 FY26 FY27 Pavement Management $ 547,400.00 $ 404,400.00 $ 675,000.00 $ 400,000.00 $ 675,000.00 Chubbuck Roundabout - 1-15 Crossing (ITD Funded) ZSiphon - New Day / Yellowstone Intersection W CDA Potenial Projects (Council Agreement) Total $ 547,400.00 $ 404,400.00 $ 675,000.00 $ 400,000.00 $ 675,000.00 Q Identified Additional Needs a W Pavement Management $ 695,600.00 $ 425,000.00 $ 700,000.00 $ 425,000.00 0 2 Total $ - $ 695,600.00 $ 425,000.00 $ 700,000.00 $ 425,000.00 Total $ 547,400.00 $ 1,100,000.00 $ 1,100,000.00 $ 1,100,000.00 $ 1,100,000.00 Personnel Request Summary Position FY23 FY24 FY25 FY26 FY27 F- Road Maintenance Worker $ $ ,000.00 $ 45,000.00 $ $ Z cW G H a a W N Total $ 13$--�1000,00 $ 45,000.00 $ $ Sanitation Department Budget Highlights Significant increase in Wages and Related Expenses, compared to FY23 Budget. 10.5% increase compared to actuals. • No major projects planned for yard (included in Administration budget). • Increased Landfill costs based on FY22 actuals. • Planning for one new truck in accordance with Equipment Capital Plan. • Planning to conduct rate study in FY24. Budget Request Summary FY23 Final Budget FY24 Proposed Budget $$$ Change % Change ESTIMATED Revenue $2,139,900.00 $2,191,000.00 $51,100.00 2.4% F- Wages & Benefits $955,100.00 $1,159,000.00 $203,900.00 21.3% yzj Administration $736,500.00 $499,000.00 -$237,500.00 -32.2% t— Operational Expenses (including Capital Equip.) $751,300.00 $1,227,300.00 $476,000.00 63.4% aAdditional Services $0.00 $0.00 $0.00 a W a Total Planned Expenses $2,442,900.00 $2,885,300.00 $442,400.00 18.1% Z O Q ~ Z a Capital Equipment (included in Operational Expenses above) $0.00 $350,000.00 $350,000.00 N; Capital Projects (included in Operational Expenses above) $0.00 $0.00 $0.00 Expenses Exceeding Revenue $303,000.00 $694,300.00 $391,300.00 Source of Funding for Overage Fund Balance Budget Highlights Significant increase in Wages and Related Expenses, compared to FY23 Budget. 10.5% increase compared to actuals. • No major projects planned for yard (included in Administration budget). • Increased Landfill costs based on FY22 actuals. • Planning for one new truck in accordance with Equipment Capital Plan. • Planning to conduct rate study in FY24. Sanitation Department Line Item Budget Summary FY23 Final Budget FY24 Proposed Budget $$$ Change % Change Wages & Benefits $955,100.00 $1,159,000.00 $203,900.00 21% Administration $736,500.00 $499,000.00 -$237,500.00 -32% V1 Residential Service Expenses $230,000.00 $272,000.00 $42,000.00 18% Commercial Service Expenses$123,000.00 $140,000.00 $17,000.00 14% X Roll off Service Expenses $76,000.00 $106,500.00 $30,500.00 40% "' Recycle Service Expenses $32,000.00 $62,500.00 $30,500.00 95% = 0 Additional Service $0.00 $0.00 $0.00 Equipment Expenses (including New Equip.) $285,000.00 $641,000.00 $356,000.00 125% L W CL Safety $5,300.00 $5,300.00 $0.00 0% Totall $2,442,900.00 $2,885,300.001 $442,400.00 18% Equipment Expenses (including New Equip.) 22% Additional Service 0% Recycle Service Expenses 2% Roti off Service Expenses 4% Commercial Service Expenses 5% Residential Service Expenses 10% Safety 0% Wages & Benefits 40% Administration 17% Sanitation Department Wages & Benefits FY24 Draft Budget 33-4331-110 Salaries 33-4331-111 Overtime 33-4331-210 FICA 33-4331-220 Retirement 33-4331-240 Workmens Compensation 33-4331-250 Health Insurance 33-4331-260 Unemployment Support Services $89,000.00 33-4332-100 Engineering 33-4332-110 Planning / Development 33-4332-120 Fleet Maintenance 33-4332-130 I.T. 33-4332-140 Utility Billing 33-4332-150 Finance 33-4332-160 Human Resources 33-4332-170 Administration Administration 21.35% 33-4333-100 Billing Expense 33-4333-110 Certifications / Licensing 33-4333-120 City Hall Lease 33-4333-130 City Hall Operations 33-4333-140 Computer/ I.T. Hardware 33-4333-150 Computer/ I.T. Software 33-4333-160 Employee Contunuing Education 33-4333-170 Employee Phone Stipend 33-4333-180 Employee Recognition 33-4333-190 Equipment Insurance 33-4333-200 Liability Insurance 33-4333-210 Mapping / GIS Systems 33-4333-220 Memberships / Dues 33-4333-230 Office Equipment / Supplies 33-4333-240 Professional Services 33-4333-250 Shop Facility Lease 33-4333-260 Training / Seminars 33-4333-270 Travel 33-4333-280 Utility - Telephone 33-4333-290 Utiltiy - Electrical 33-4333-300 Utiltiy - Natural Gas 33-4333-310 Facility Maintenance/Janitor 33-4333-320 Yard Facility Construction 33-4333-330 Yard Facility Operations Residential Service Expenses 33-4340-100 Landfill 33-4340-110 Carts 33-4340-120 Cart Maintenance Commercial Service Expenses 33-4341-100 Landfill 33-4341-110 Containers 33-4341-120 Container Maintenance Roll off Service Expenses 33-4342-100 Landfill 33-4342-110 Containers 33-4342-120 Container Maintenance FY23 Final Budget FY24 Draft Budget $$$ Change % Change $573,900.00 $718,000.00 $144,100.00 25.1% $22,000.00 $22,000.00 $0.00 0.0% $46,500.00 $56,000.00 $9,500.00 20.4% $74,700.00 $89,000.00 $14,300.00 19.1 $20,900.00 $28,000.00 $7,100.00 34.0% $217,100.00 $246,000.00 $28,900.00 13.3 $0.00 $0.00 $0.00 $955,100.00 $1,159,000.00 $203,900.00 21.35% $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $31,000.00 $31,000.00 $0.00 0.00% $1,000.00 $1,000.00 $0.00 0.00% $139,000.00 $139,000.00 $0.00 0.00% $26,000.00 $26,000.00 $0.00 0.00% $16,000.00 $47,000.00 $31,000.00 193.75 $10,000.00 $22,000.00 $12,000.00 120.00% $3,000.00 $3,000.00 $0.00 0.00% $0.00 $0.00 $0.00 $2,000.00 $2,000.00 $0.00 0.00% $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $3,500.00 $8,000.00 $4,500.00 128.57 $1,000.00 $1,000.00 $0.00 0.00% $2,500.00 $4,500.00 $2,000.00 80.00% $0.00 $50,000.00 $50,000.00 $112,000.00 $112,000.00 $0.00 0.00% $500.00 $500.00 $0.00 0.00 $0.00 $1,000.00 $1,000.00 $7,000.00 $7,500.00 $500.00 7.14% $4,000.00 $5,500.00 $1,500.00 37.50% $3,000.00 $3,000.00 $0.00 0.00% $15,000.00 $5,000.00 -$10,000.00 -66.67% $350,000.00 $20,000.00 -$330,000.00 -94.29% $10,000.00 $10,000.00 $0.00 0.00% $736,500.00 $499,000.00 -$237,500.00 -32.25% $195,000.00 $220,000.00 $25,000.00 12.82 $35,000.00 $50,000.00 $15,000.00 42.86% $0.00 $2,000.00 $2,000.00 $230,000.00 $272,000.00 $42,000.00 18.26% $110,000.00 $125,000.00 $15,000.00 13.64% $8,000.00 $10,000.00 $2,000.00 25.00% $5,000.00 $5,000.00 $0.00 0.00 $123,000.00 $140,000.00 $17,000.00 13.82 $65,000.00 $90,000.00 $25,000.00 38.46% $10,000.00 $15,000.00 $5,000.00 50.00% $1,000.00 $1,500.00 $500.00 50.00% $76,000.00 $106,500.00 $30,500.00 40.13% Sanitation Department FY23 Final Budget Recycle Service Expenses 33-4343-100 Recycle waste $31,000.00 33-4343-110 Carts $0.00 33-4343-120 Cart Maintenance $1,000.00 Additional Service $$$ Change % Change 33-4360-100 Freebie 15 yd 33-4360-110 Freebie 3yd 33-4360-120 Branch Chipping 33-4360-130 Leaf Pickup 33-4360-140 Christmas Tree Pickup 33-4360-150 Extra Christmas Containers 33-4360-160 Spring Clean Up 33-4360-170 Chubbuck Days 33-4360-180 Interagency Services Equipment Expenses $0.00 33-4370-100 Fuel & Lubricants 33-4370-110 Small Tool/Equipment 33-4370-120 Vehicle M & O 33-4370-130 Capital Planning 33-4370-140 New Collection Vehicle 33-4370-150 Small Vehicle Replacement $32,000.00 FY24 Draft Budget $$$ Change % Change $45,000.00 $14,000.00 45.16% $17,000.00 $17,000.00 $500.00 -$500.00 -50.00% $62,500.00 $30,500.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $80,000.00 $8,000.00 $125,000.00 $67,000.00 $0.00 $5,000.00 $112,000.00 $4,000.00 $175,000.00 $0.00 $350,000.00 $0.00 $32,000.00 -$4,000.00 $50,000.00 -$67,000.00 $350,000.00 -$5,000.00 95.31% 40.00 -50.00% 40.00 -100.00% -100.00% Wages / Benefits $285,000.00 $641,000.00 $356,000.00 124.91 Safety $0.00 $0.00 Administration $736,500.00 33-4371-100 Training $1,000.00 $1,000.00 $0.00 0.00% 33-4371-110 Clothing $4,000.00 $3,000.00 -$1,000.00 -25.00% 33-4371-120 Equipment $0.00 $1,000.00 $1,000.00 33-4371-130 Testing $300.00 $300.00 $0.00 0.00% $5,300.00 $5,300.00 $0.00 0.00% Wages / Benefits $955,100.00 $1,159,000.00 $203,900.00 21.35% Internal Support Services $0.00 $0.00 $0.00 Administration $736,500.00 $499,000.00 -$237,500.00 -32.25% Base Services $751,300.00 $1,227,300.00 $476,000.00 63.36% Additional Services $0.00 $0.00 $0.00 Total Expense $2,442,900.00 $2,885,300.00 $442,400.00 18.11% Capital Equipment Summary Z Item FY23 FY24 FY25 FY26 FY27 W Residential Truck $0.00 $350,000.00 $0.00 $0.00 $400,000.00 Commercial Truck $0.00 $0.00 $0.00 $0.00 $400,000.00 Q Passenger Truck $0.00 $0.00 $0.00 $40,000.00 $0.00 a W In Total $0.00 $350,000.00 $0.00 $40,000.00 $800,000.00 ZSource O of Funds Fund Balance $0.00 $350,000.00 $0.00 $40,000.00 $800,000.00 Q Z Q Total $0.00 $350,000.00 $0.00 $40,000.00 $800,000.00 Total $0.00 $0.00 $0.00 $0.00 $0.00 Capital Projects Request Summary Z Item FY23 FY24 FY25 FY26 FY27 W Yard Improvements $ 275,000.00 Q a W o Total $ 275,000.00 $ - - - - ZSource O of Funds Fund Balance $ 275,000.00 Q F— Z Q Total $ 275,000.00 $ - $ - $ - $ - Total $ - $ - $ - $ - $ - Personnel Request Summary Z Position FY23 FY24 FY25 FY26 FY27 W Sanitation Driver $ ,000.00 $ 45,000.00 $ - Q a W In z O F - Q F - z Q Total $ - $ ,000.00 $ 45,000.00 $ - $ - Water Department 10 Budget Highlights • Assumes an annual 5% increase in rates in accordance with the recent rate study. • Includes 1 additional employee, split between Water and Wastewater Depts. which was planned for FY23. • Majority of Capital Improvement Plan from FY23 has been moved to FY24 — currently underway with planning study. • Majority of Equipment Capital Planning budget eliminated and will remain in Fund Balance (we're not showing it as an expense to then fall to the fund balance) Budget Request Summary FY23 Final Budget FY24 Proposed Budget $$$ Change % Change ESTIMATED Revenue (Utility Rates) $3,106,500.00 $3,252,300.00 $92,800.00 3.0% Wages & Benefits $1,098,800.00 $1,195,300.00 $96,500.00 8.78% Administration $416,500.00 $489,000.00 $72,500.00 17.41% Operational Expense (including CIP) $2,561,000.00 $2,504,100.00 -$56,900.00 -2.22% W Additional Services $0.00 $0.00 $0.00 0% Debt Service $625,000.00 $750,000.00 $125,000.00 20% II— IY aTotal Planned Expenses $4,701,300.00 $4,938,400.00 $237,100.00 5.0% W 0 DC W Q Capital Equipment (included in Operational Expenses above) $75,000.00 $0.00 -$75,000.00 Capital Projects (included in Operational Expenses above) $1,519,800.00 $1,519,800.00 $0.00 Expenses Exceeding Revenue $1,594,800.00 $1,686,100.00 $91,300.00 Source of Funding for Overage • Rate Increase Fund Balance • Previously Collected Capacity Fees Budget Highlights • Assumes an annual 5% increase in rates in accordance with the recent rate study. • Includes 1 additional employee, split between Water and Wastewater Depts. which was planned for FY23. • Majority of Capital Improvement Plan from FY23 has been moved to FY24 — currently underway with planning study. • Majority of Equipment Capital Planning budget eliminated and will remain in Fund Balance (we're not showing it as an expense to then fall to the fund balance) Water Department Line Item Budget Summary FY23 Final Budget FY24 Proposed Budget $$$ Change % Change Wages & Benefits $1,098,800.00 $1,195,300.00 $96,500.00 8.8% Administration $416,500.00 $489,000.00 $72,500.00 17.4% Production & Storage $353,900.00 $372,000.00 $18,100.00 5.11% Distribution System and CIP $1,767,300.00 $1,772,800.00 $5,500.00 0.31% x Meter / Service Connections $72,800.00 $74,500.00 $1,700.00 2.34% "' Fire Protections $25,000.00 $25,000.00 $0.00 0.00% c Pressure Irrigation $133,000.00 $142,000.00 $9,000.00 6.77% L Additional Service $0.00 $0.00 $0.00 0.00% CL Equipment Expenses $202,000.00 $110,000.00 -$92,000.00 -45.54% O Safety $7,000.00 $7,800.00 $800.00 11.43% Debt Service $625,000.00 $750,000.00 $125,000.00 20.00% Total $4,701,300.00 $4,938,400.00 $237,100.00 5.04% Safety 0% Equipment Expenses 2% Additional Service 0% Pressure Irrigation 3% Fire Protections 0% Meter / Service Connections 2% Debt Service 15% Distribution System and CIP 36% Wages & Benefits 24% Administration 10% Production & Storage 8% I Water Department FY23 Final Budget FY24 Draft Budget $$$ Change % Change Wages & Benefits 31-4341-110 Salaries $ 689,900.00 $ 749,500.00 $ 59,600.00 8.6% 31-4341-111 Overtime $ 8,800.00 $ 8,800.00 $ - 0.0% 31-4341-210 FICA $ 53,800.00 $ 54,000.00 $ 200.00 0.4% 31-4341-220 Retirement $ 87,100.00 $ 87,000.00 $ (100.00) -0.1% 31-4341-240 Workmens Compensation $ 20,100.00 $ 25,000.00 $ 4,900.00 24.4% 31-4341-250 Health Insurance $ 239,100.00 $ 271,000.00 $ 31,900.00 13.3% 31-4341-259 Unemployment $ - $ - $ 1,098,800.00 $ 1,195,300.00 $ 96,500.00 8.8% Administration 31-4353-100 Billing Expense $ 31,000.00 $ 31,000.00 $ - 0.0% 31-4353-110 Certifications / Licensing $ 9,000.00 $ 9,000.00 $ - 0.0% 31-4353-120 City Hall Lease $ 165,000.00 $ 165,000.00 $ - 0.0% 31-4353-130 City Hall Operations $ 3,000.00 $ 20,000.00 $ 17,000.00 566.7% 31-4353-140 Computer/ I.T. Hardware $ 20,000.00 $ 47,000.00 $ 27,000.00 135.0% 31-4353-150 Computer/ I.T. Software $ 17,000.00 $ 40,000.00 $ 23,000.00 135.3% 31-4353-160 Employee Contunuing Education $ 1,000.00 $ 1,000.00 $ - 0.0% 31-4353-170 Employee Phone Stipend $ - $ - $ - 31-4353-180 Employee Recognition $ 2,500.00 $ 2,500.00 $ - 0.0% 31-4353-190 Equipment Insurance $ - $ - $ - 31-4353-200 Liability Insurance $ - $ - $ - 31-4353-210 Mapping / GIS Systems $ 3,000.00 $ 3,000.00 $ - 0.0% 31-4353-220 Memberships / Dues $ 3,000.00 $ 16,000.00 $ 13,000.00 433.3% 31-4353-230 Office Equipment / Supplies $ 5,500.00 $ 5,500.00 $ - 0.0% 31-4353-240 Professional Services $ 100,000.00 $ 100,000.00 $ - 0.0% 31-4353-250 Shop Facility Lease $ 1,000.00 $ 1,000.00 $ - 0.0% 31-4353-260 Training / Seminars $ 4,000.00 $ 4,000.00 $ - 0.0% 31-4353-270 Travel $ 1,000.00 $ 1,000.00 $ - 0.0% 31-4353-280 Utility - Telephone $ 7,500.00 $ 8,500.00 $ 1,000.00 13.3% 31-4353-290 Utiltiy - Electrical $ 5,500.00 $ 10,000.00 $ 4,500.00 81.8% 31-4353-300 Utiltiy - Natural Gas $ 5,500.00 $ 5,500.00 $ - 0.0% 31-4353-310 Facility Maintenance/Janit $ 15,000.00 $ 2,000.00 $ (13,000.00) -86.7% 31-4353-320 Yard Facility Construction $ 7,000.00 $ 7,000.00 $ - 0.0% 31-4353-330 Yard Facility Operations $ 10,000.00 $ 10,000.00 $ - 0.0% $ 416,500.00 $ 489,000.00 $ 72,500.00 17.4% Production & Storage 31-4360-100 Well head protection $ - $ - $ - 31-4360-110 Building Maintenance & operation $ 1,000.00 $ 13,000.00 $ 12,000.00 1200.0% 31-4360-120 Scada M&O $ 12,000.00 $ 12,000.00 $ - 0.0% 31-4360-130 Electrical motor M&O $ - $ - $ - 31-4360-140 Pump M&O $ 82,900.00 $ 48,000.00 $ (34,900.00) -42.1% 31-4360-150 Well Equipment M&O (Daily well Checks) $ 4,500.00 $ 4,500.00 $ - 0.0% 31-4360-160 Disinfection equipment M&O $ 2,000.00 $ 2,000.00 $ - 0.0% 31-4360-170 Disinfection Chemical $ 15,000.00 $ 25,500.00 $ 10,500.00 70.0% 31-4360-180 Treatment Chemical $ 15,000.00 $ 5,000.00 $ (10,000.00) -66.7% 31-4360-190 QC Sampling & testing $ 6,000.00 $ 20,000.00 $ 14,000.00 233.3% 31-4360-200 Electrical power $ 165,000.00 $ 200,000.00 $ 35,000.00 21.2% 31-4360-210 Storage M&O $ 5,500.00 $ 5,500.00 $ - 0.0% 31-4360-220 Water Rights $ 11,000.00 $ 2,500.00 $ (8,500.00) -77.3% 31-4360-229 DEQ Assesment $ 34,000.00 $ 34,000.00 $ - 0.0% $ 353,900.00 $ 372,000.00 $ 18,100.00 5.1% Distribution System 31-4361-100 Piping M&O $ 22,000.00 $ 42,000.00 $ 20,000.00 90.9% 31-4361-110 Valve M&O $ 15,000.00 $ 5,000.00 $ (10,000.00) -66.7% 31-4361-120 Valve Replacement $ 4,000.00 $ 4,000.00 $ - 0.0% 31-4361-130 System Improvements $ 50,000.00 $ 50,000.00 $ - 0.0% 31-4361-140 Digline (locates) $ 1,500.00 $ 2,000.00 $ 500.00 33.3% 31-4361-150 Capital Planning $ 1,669,800.00 $ 1,669,800.00 $ - 0.0% 31-4361-160 Line Flushing $ 5,000.00 $ - $ (5,000.00) -100.0% $ 1,767,300.00 $ 1,772,800.00 $ 5,500.00 0.3% Water Department Meter / Service Connections 31-4362-100 New connections 31-4362-110 Service connection M&O 31-4362-120 Meters 31-4362-130 Meter reading equipment Fire Protections 31-4363-100 Fire Hydrant M&O 31-4363-110 Fire Hydrant Replacement 31-4363-120 Storz Fittings Pressure Irrigation Meter Can Adjustments 31-4364-100 Pump M&O 31-4364-110 Electrical power 31-4364-120 System M&O 31-4364-130 Digline (Locates) 31-4364-140 Fort Hall - Water Rights Additional Service 31-4370-100 Meter Can Adjustments 31-4370-110 Special Turn on-off 31-4370-120 Contractor Testing Assistance 31-4370-130 Interagency Services Equipment Expenses $ 31-4380-100 Pickup Repair and Maint 31-4380-110 Large truck Repair and Maint 31-4380-120 Heavy equipment Repair & Maint 31-4380-130 TRK & Equipment Capital Planning 31-4380-140 Fuel & Lubricants 31-4380-150 Small Tools & equipment 31-4380-160 Equipment rental Safety 31-4381-100 FY23 Final Budget $ FY24 Draft Budget $ $$$ Change % Change $ 1,000.00 $ 2,500.00 $ 1,500.00 150.0% $ 1,800.00 $ 2,000.00 $ 200.00 11.1% $ 45,000.00 $ 60,000.00 $ 15,000.00 33.3% $ 25,000.00 $ 10,000.00 $ (15,000.00) -60.0% $ 72,800.00 $ 74,500.00 $ 1,700.00 2.3% $ 15,000.00 $ 15,000.00 $ - 0.0% $ 10,000.00 $ 10,000.00 $ - 0.0% $ 25,000.00 $ 25,000.00 $ - 0.0% $ 15,000.00 $ 5,000.00 $ (10,000.00) -66.7% $ 2,000.00 $ 7,500.00 $ 5,500.00 275.0% $ 80,000.00 $ 90,000.00 $ 10,000.00 12.5% $ 1,000.00 $ 1,500.00 $ 500.00 50.0% $ 35,000.00 $ 38,000.00 $ 3,000.00 8.6% $ 133,000.00 $ 142,000.00 $ 9,000.00 6.8% $ 10,000.00 $ 5,000.00 $ (5,000.00) -50.0% $ 33,000.00 $ 33,000.00 $ - 0.0% $ 5,000.00 $ 10,000.00 $ 5,000.00 100.0% $ 125,000.00 $ 25,000.00 $ (100,000.00) -80.0% $ 24,000.00 $ 25,000.00 $ 1,000.00 4.2% $ 3,000.00 $ 10,000.00 $ 7,000.00 233.3% $ 2,000.00 $ 2,000.00 $ - 0.0% $ 202,000.00 $ 110,000.00 $ (92,000.00) -45.5% 31-4381-100 Training $ 1,500.00 $ 1,500.00 $ - 0.0% 31-4381-110 Clothing $ 2,500.00 $ 3,000.00 $ 500.00 20.0% 31-4381-120 Equipment $ 2,000.00 $ 2,000.00 $ - 0.0% 31-4381-130 Testing $ 1,000.00 $ 1,300.00 $ 300.00 30.0% Additional Services $ $ 7,000.00 $ 7,800.00 $ 800.00 11.4% Debt Service 31-4390-812 Bonds and Interest $ 600,000.00 $ 725,000.00 $ 125,000.00 20.8% 31-4390-813 Notes and Interest $ 25,000.00 $ 25,000.00 $ - 0.0% $ 625,000.00 $ 750,000.00 $ 125,000.00 20.0% Wages / Benefits $ 1,098,800.00 $ 1,195,300.00 $ 96,500.00 8.8% Internal Support Services $ - $ - $ - Administration $ 416,500.00 $ 489,000.00 $ 72,500.00 17.4% Base Services $ 2,561,000.00 $ 2,504,100.00 $ (56,900.00) -2.2% Additional Services $ - $ - $ - Debt Service $ 625,000.00 $ 750,000.00 $ 125,000.00 20.0% Total Expense $ 4,701,300.00 $ 4,938,400.00 $ 237,100.00 5.0% Capital Equipment Summary Item FY23 FY24 FY25 FY26 FY27 Z Hydro-Excavator (split w/Wastewater) $75,000.00 W Backhoe (split w/Wastewater) $115,000.00 Jet Truck (split w/Wastewater) $115,000.00 Q a Total $75,000.00 $0.00 $0.00 $115,000.00 $115,000.00 W 0 Source of Funds W Fund Balance $75,000.00 $115,000.00 $115,000.00 Q Total $75,000.00 $0.00 $0.00 $115,000.00 $115,000.00 Balance $0.00 $0.00 $0.00 $0.00 $0.00 Capital Projects Request Summary Item FY24 FY25 FY26 FY27 FY28 1A - 16" Line New Day to Buffalo $76,800.00 1B - 16" Line Buffalo to Tyhee $156,000.00 1H - 18" Line Tank to Booster (across 1-15) $82,000.00 2E - Well 7 Complex $1,157,600.00 $2,894,000.00 $1,736,400.00 2G - Bench Booster Improvements $47,400.00 $189,600.00 Z W RR - Repair and Replacement $1,600,000.00 $1,600,000.00 $1,600,000.00 $1,600,000.00 S 2B - 16" Line Well 6 to Philbin (Siphon Road) $32,000.00 $128,000.00 2C - 16" Line Angela to Siphon (Philbin Road) $33,000.00 $132,000.00 Q a 1G - 16" Line Canal to Siphon in Rio Vista $118,000.00 W 2D - 16" Line Philbin to Rio Vista (Siphon road) $58,400.00 $233,600.00 W Total $1,519,800.00 $4,715,600.00 $3,497,400.00 $1,790,400.00 $1,951,600.00 QSource of Funds Rate Funded Capital $82,000.00 $84,000.00 $87,000.00 $89,000.00 Fund Balance $120,800.00 $1,480,000.00 Water Capacity Fees $1,317,000.00 $1,224,600.00 $765,000.00 Revenue Bonds - New Debt $1,927,000.00 $2,645,400.00 $1,701,400.00 $1,951,600.00 Total $1,519,800.00 $4,715,600.00 $3,497,400.00 $1,790,400.00 $1,951,600.00 Balance $0.00 $0.00 $0.00 $0.00 $0.00 Personnel Request Summary Position FY23 FY24 FY25 FY26 FY27 z Z Water / Wastewater Technician 1 (0.5 FTE) $ 21,500.00 W Water / Wastewater Technician 1 (0.5 FTE) $ 24,250.00 Q a W W Q Total $ 21,500.00 $ - $ - $ - $ 24,250.00 Wastewater Department 14 Budget Highlights • Assumes an annual 3.5% increase in rates in accordance with the recent rate study. • Includes 1 additional employee, split between Water and Wastewater Depts. which was planned for FY23. Significant Capital Projects Planned for FY24 in accordance with Rate Study and CIP. Budget Request Summary FY23 Final Budget FY24 Proposed Budget $$$ Change % Change ESTIMATED Revenue (Utility Rates) $3,506,000.00 $3,721,000.00 $222,000.00 6.3% Wages & Benefits $914,400.00 $1,031,700.00 $117,300.00 12.83% ZAdministration $440,500.00 $442,700.00 $2,200.00 0.50% W Operational Expense (including CIP) $2,303,100.00 $4,889,600.00 $2,586,500.00 112.31% Additional Services $15,000.00 $0.00 -$15,000.00 -100.00% cc a Debt Service $0.00 $0.00 $0.00 W CC Total Planned Expenses $3,673,000.00 $6,364,000.00 $2,691,000.00 73.3% W Q Iyl N$0.00 Capital Equipment (included in Operational Expenses above) $0.00 $0.00 Q ?> Capital Projects (included in Operational Expenses above) $0.00 $3,039,000.00 $3,039,000.00 Expenses Exceeding Revenue $167,000.00 $2,643,000.00 $2,476,000.00 Source of Funding for Overage Rate Increase Fund Balance Previously Collected Capacity Fees Budget Highlights • Assumes an annual 3.5% increase in rates in accordance with the recent rate study. • Includes 1 additional employee, split between Water and Wastewater Depts. which was planned for FY23. Significant Capital Projects Planned for FY24 in accordance with Rate Study and CIP. Wastewater Department Line Item Budget Summary FY23 Final Budget FY24 Proposed Budget $$$ Change % Change Wages & Benefits $914,400.00 $1,031,700.00 $117,300.00 12.83% Administration $440,500.00 $442,700.00 $2,200.00 0.50% LA Collection System and CIP $287,500.00 $187,000.00 -$100,500.00 -34.96% CU Ln a Treatment /Pretreatment $1,600,800.00 $1,600,800.00 $0.00 0.00% X "' Pumping and CIP $363,000.00 $3,000,000.00 $2,662,000.00 o 733.33/0 o Additional Service $15,000.00 $0.00 -$15,000.00 -100.00% c� CL Equipment Expenses $47,000.00 $95,000.00 $48,000.00 102.13% O Safety $4,800.00 $6,800.00 $2,000.00 41.67% Debt Service $0.00 $0.00 $0.00 Total $3,688,000.00 $6,364,000.00 $2,676,000.00 72.56% Equipment Expenses 2% Additional Service 0% Pumping and CIP 47 Safety� Debt Service 0% 0% Wages & Benefits 16% Administration 7% Collection System and CIP 3% WL4���� Treatment / Pretreatment 25% Wastewater Department Administration 32-4353-100 Billing Expense $ FY23 Final Budget $ FY24 Draft Budget $ $$$ Change % Change Wages & Benefits Certifications / Licensing $ 15,000.00 $ 15,000.00 $ - 0.00% 32-4351-110 Salaries $ 584,200.00 $ 665,500.00 $ 81,300.00 13.9% 32-4351-111 Overtime $ 6,200.00 $ 6,200.00 $ - 0.0% 32-4351-210 FICA $ 45,500.00 $ 48,000.00 $ 2,500.00 5.5% 32-4351-220 Retirement $ 74,100.00 $ 77,000.00 $ 2,900.00 3.9% 32-4351-240 Workmens Compensation $ 17,300.00 $ 22,500.00 $ 5,200.00 30.1% 32-4351-250 Health Insurance $ 187,100.00 $ 212,500.00 $ 25,400.00 13.6% 32-4351-260 Unemployment $ - $ - $ - 0.00% 32-4353-190 Equipment Insurance $ 914,400.00 $ 1,031,700.00 $ 117,300.00 12.83% Administration 32-4353-100 Billing Expense $ 31,000.00 $ 31,000.00 $ - 0.00% 32-4353-110 Certifications / Licensing $ 15,000.00 $ 15,000.00 $ - 0.00% 32-4353-120 City Hall Lease $ 165,000.00 $ 165,000.00 $ - 0.00% 32-4353-130 City Hall Operations $ 3,000.00 $ 20,000.00 $ 17,000.00 566.67% 32-4353-140 Computer/ I.T. Hardware $ 20,000.00 $ 47,000.00 $ 27,000.00 135.00% 32-4353-150 Computer/ I.T. Software $ 17,000.00 $ 45,000.00 $ 28,000.00 164.71% 32-4353-160 Employee Contunuing Education $ 1,500.00 $ 1,500.00 $ - 0.00% 32-4353-170 Employee Phone Stipend $ - $ - $ - 32-4353-180 Employee Recognition $ 1,500.00 $ 1,500.00 $ - 0.00% 32-4353-190 Equipment Insurance $ - $ - $ - 32-4353-200 Liability Insurance $ - $ - $ - 32-4353-210 Mapping / GIS Systems $ 3,500.00 $ 8,000.00 $ 4,500.00 128.57% 32-4353-220 Memberships / Dues $ 1,000.00 $ 1,000.00 $ - 0.00% 32-4353-230 Office Equipment/ Supplies $ 2,500.00 $ 3,700.00 $ 1,200.00 48.00% 32-4353-240 Professional Services $ 125,000.00 $ 50,000.00 $ (75,000.00) -60.00% 32-4353-250 Shop Facility Lease $ - $ - $ - 32-4353-260 Training / Seminars $ 1,500.00 $ 1,500.00 $ - 0.00% 32-4353-270 Travel $ 500.00 $ 1,000.00 $ 500.00 100.00% 32-4353-280 Utility - Telephone $ 6,500.00 $ 7,500.00 $ 1,000.00 15.38% 32-4353-290 Utiltiy - Electrical $ 4,500.00 $ 6,500.00 $ 2,000.00 44.44% 32-4353-300 Utiltiy - Natural Gas $ 9,500.00 $ 10,500.00 $ 1,000.00 10.53% 32-4353-310 Facility Maintenance/Janito $ 15,000.00 $ 10,000.00 $ (5,000.00) -33.33% 32-4353-320 Yard Facility Construction $ 7,000.00 $ 7,000.00 $ - 0.00% 32-4353-330 Yard Facility Operations $ 10,000.00 $ 10,000.00 $ - 0.00% $ 440,500.00 $ 442,700.00 $ 2,200.00 0.50% Collection System 32-4360-100 System Maint (lines) $ 500.00 $ 500.00 $ - 0.00% 32-4360-110 System Maint (lift Stations) $ 500.00 $ 500.00 $ - 0.00% 32-4360-120 System improvements $ 3,500.00 $ 3,500.00 $ - 0.00% 32-4360-130 Digline (locates) $ 2,000.00 $ 2,500.00 $ 500.00 25.00% 32-4360-140 System Capital Planning $ 281,000.00 $ 180,000.00 $ (101,000.00) -35.94% $ 287,500.00 $ 187,000.00 $ (100,500.00) -34.96% Treatement / Pretreatment 32-4361-100 QC sampling/testing $ 500.00 $ 500.00 $ - 0.00% 32-4361-110 Treatment (Pocatello) $ 1,600,000.00 $ 1,600,000.00 $ - 0.00% 32-4361-120 Inspections $ 300.00 $ 300.00 $ - 0.00% 32-4361-130 Applications/ Approvals $ - $ - $ - $ 1, 600, 800.00 $ 1, 600, 800.00 $ - 0.00 Pumping 32-4362-100 Electrical Motor M&O $ 25,000.00 $ 15,000.00 0.00% 32-4362-110 Pumping Equipment M&O $ 30,000.00 $ 15,000.00 0.00% 32-4362-120 Electrical power $ 20,000.00 $ 28,000.00 $ 8,000.00 32-4362-130 Scada $ 10,000.00 $ 10,000.00 $ - 0.00% 32-4362-140 Building and grounds M&O $ 5,000.00 $ 20,000.00 $ 15,000.00 300.00% 32-4362-150 Capital Planning $ 273,000.00 $ 2,912,000.00 $ 2,639,000.00 966.67% $ 363,000.00 $ 3,000,000.00 $ 2,662,000.00 733.33% Additional Service 32-4370-100 Contractor Assistance $ - $ - $ - 32-4370-110 Interagency Services $ 15,000.00 $ - $ (15,000.00) -100.00% $ 15,000.00 $ - $ (15,000.00) -100.00% Wastewater Department Equipment Expenses 32-4381-110 32-4380-100 Pickup Repair and Maint 32-4380-110 Large truck Repair and Maint 32-4380-120 Heavy equipment Repair & Maint 32-4380-130 TRK & Equipment Capital Planning 32-4380-140 Fuel & Lubricants 32-4380-150 Small Tools & equipment Safety 32-4381-100 Training 32-4381-110 Clothing 32-4381-120 Equipment 32-4381-130 Testing Debt Service 31-4390-812 Bonds and Interest 31-4390-813 Notes and Interest Wages / Benefits FY23 Final Budget 914,400.00 FY24 Draft Budget 1,031,700.00 $$$ Change % Change $ 500.00 $ 5,000.00 $ 4,500.00 900.00% $ 500.00 $ 25,000.00 $ 24,500.00 4900.00% $ 1,000.00 $ 10,000.00 $ 9,000.00 900.00% $ 25,000.00 $ 25,000.00 $ - 0.00% $ 15,000.00 $ 25,000.00 $ 10,000.00 66.67% $ 5,000.00 $ 5,000.00 $ - 0.00% $ 47,000.00 $ 95,000.00 $ 48,000.00 102.13% $ 500.00 $ 1,500.00 $ 1,000.00 200.00% $ 2,000.00 $ 2,000.00 $ - 0.00% $ 2,000.00 $ 2,000.00 $ - 0.00% $ 300.00 $ 1,300.00 $ 1,000.00 333.33% $ 4,800.00 $ 6,800.00 $ 2,000.00 41.67% Wages / Benefits $ 914,400.00 $ 1,031,700.00 $ 117,300.00 12.83% Administration $ 440,500.00 $ 442,700.00 $ 2,200.00 0.50% Base Services $ 2,303,100.00 $ 4,889,600.00 $ 2,586,500.00 112.31% Additional Services $ 15,000.00 $ - $ (15,000.00) Debt Service $ - $ - $ - Total Expense $ 3,673,000.00 $ 6,364,000.00 $ 2,691,000.00 73.26% Capital Equipment Summary Z Item FY23 FY24 FY25 FY26 FY27 W S Hydro-Excavator (split w/Water) $ 25,000.00 Backhoe (split w/Water) $ 20,000.00 Q Jet Truck (split w/Water) $ 225,000.00 a W 0 Total $ 25,000.00 $ - $ - $ 20,000.00 $ 225,000.00 W Source of Funds Q Fund Balance $ 25,000.00 $ 20,000.00 $ 225,000.00 W H Q Total $ 25,000.00 $ - $ - $ 20,000.00 $ 225,000.00 Total $ - $ - $ - $ - $ - Capital Projects Request Summary Item FY23 FY24 FY25 FY26 FY27 Z Valenty Lift Station Upgrade $ 112,000.00 $ 1,676,000.00 W CCTV Evaluation $ 123,000.00 $ 127,000.00 $ 130,000.00 $ 135,000.00 Ellis Lift Station Upgrade $ 61,000.00 $ 913,000.00 Q Gravity Sewer Rehabilitation - Phase 1 $ 323,000.00 $ 1,064,000.00 $ 1,095,000.00 $ 1,128,000.00 a W Total $ 296,000.00 $ 3,039,000.00 $ 1,194,000.00 $ 1,230,000.00 $ 1,128,000.00 W Source of Funds Q Operations Budget $ 296,000.00 Uj W Fund Balance & CapacityFees $ - $ 3,039,000.00 Revenue Bonds - New Debt $ 1,194,000.00 $ 1,230,000.00 $ 1,128,000.00 Q Total $ 296,000.00 $ 3,039,000.00 $ 1,194,000.00 $ 1,230,000.00 $ 1,128,000.00 Total $ - $ - $ - $ - $ - Personnel Request Summary Z Position FY23 FY24 FY25 FY26 FY27 W Water / Wastewater Technician 1 (0.5 FTE) $ 21,500.00 Water / Wastewater Technician 1 (0.5 FTE) $ 24,250.00 Q a W W Q W Q Total $ 21,500.00 $ - $ - $ - $ 24,250.00