The URL can be used to link to this page

Home My WebLink AboutItem #1 Budget PresentationsCHUBBUCK FY24 Budget Schedule Office of the Treasurer 290 East Linden Avenue, Chubbuck, ID 83202 208.237.2400 — Fax 208.237.2371 www.CityofChubbuck.us Council, Attached are budget worksheets for each of the operational funds of the city. These worksheets have been updated with the current projections for wage/wage related expense, most notably in our emergency services department (fire control). The projection for estimated General Fund Revenue is - $9,782,813 As a summary of wage/wage related estimated expense by fund: General Fund - $8,060,650 HSR $882,500 Water $1,157,800 Wastewater $994,200 Sanitation $1,159,000 Wages are projected individually to fund the compensation plan and result in an overall 6% increase. Retirement was projected with a 13% increase for public safety and 12% for everyone else, this includes a 1% increase from PERSI. Health Insurance was calculated with a 13% increase. The budget worksheets are line -item reports that include the account number, account title, the current year budget, the current years actual to date, and a column for the coming year's budget. As scheduled for April the departments will be presenting their budgets. I hope you find this helpful as you work with department heads to finalize obligations and operations. City of Chubbuck Report Criteria: Print Fund Titles Page and Total by Fund Print Source Titles Total by Source Print Department Titles Total by Department All Segments Tested for Total Breaks Account.Account Number = "10411111 D'="104112694" Budget Worksheet Period: 00123 Modification Page: 1 Mar 28, 2023 08:24AM 2022-23 2022-23 2023-24 Cur Year Cur Year Fut Year Account Number Account Title Budget Actual Budget NON -BUSINESS LICENSES LEGISLATIVE 10-0111-110 LG Salaries 33,000 16,590 36,000 10-0111-111 LG Overtime .00 00 .00 104111-210 LG FICA 2,500 1,269 2,700 104111-220 LG Retirement 4,000 1,981 4,400 104111-240 LG Workers'Compensation 250 112 300 104111-250 LG Health Insurance 67,000 30,323 76,000 104112-370 LG Travel, Meetings & Other 51200 .00 .00 104112-480 LG Dues 6,500 6,228 .00 104112-490 LG Grant Consulting .00 .00 .00 104112-491 LG Feasability Study .00 .00 .00 104112-693 LG Land Use Compensation 700 170 .00 1041112-694 LG Legal .00 .00 .00 Total LEGISLATIVE: 119,150 56,673 119,400 GENERAL FUND Revenue Total: .00 .00 .00 GENERAL FUND Expenditure Total', 119,150 56,673 119,400 Net Total NON -BUSINESS LICENSES: 119,150- 56,673- 119,400 - Modification Page: 1 Mar 28, 2023 08:24AM City of Chubbuck Budget Worksheet Page: 1 Period: 00/23 Mar 28, 2023 08:31AM Report Crlterla: Print Fund Titles Page and Total by Fund Print Source Titles Total by Source Print Department Titles Total by Department All Segments Tested for Total Breaks Account.Account Number= "104131110"-"104133280" Modification 2022-23 2022-23 2023-24 Cur Year Cur Year Fut Year Account Number Account Title Budget Actual Budget NON -BUSINESS LICENSES EXECUTIVE 10-4131-110 EX Salary 40,000 18,383 45,000 10-4131-111 EX Overtime .00 .00 .00 10-4131-210 EX FICA 3,000 1,440 3,400 10-4131-220 EX Retirement 5,000 2,310 5,500 104131-240 EX Workers' Compensation .00 .00 .00 10-4131-250 EX Health Insurance 15,600 4,666 17,700 10-4131-260 EX Unemployment .00 .00 .00 10-4131-310 EX Office Equipment/Supplies 500 .00 .00 10-4131-759 EX Phone Stipend .00 .00 .00 10-4132-370 EX Travel, Meetings & Other 2,000 563 .00 10-4132-371 EX Crossing Guards .00 .00 .00 10-4132-372 EX Employee Recognition .00 .00 .00 10-4133-280 EX Phone 500 00 .00 Total EXECUTIVE: 66,600 27,371 71,600 GENERAL FUND Revenue Total: .00 .00 .00 GENERAL FUND Expenditure Total: 66,600 27,371 71,600 Net Total NON -BUSINESS LICENSES: - 86,600- 27,371- 71,600 - Modification City of Chubbuck Budget Worksheet Page: 1 Period: 00123 Mar 28, 2023 08:31AM Report Criteria: Print Fund Titles Page and Total by Fund Print Source Titles Total by Source Print Department Titles Total by Department All Segments Tested for Total Breaks Account.Account Number ='904142280"'904142761" Account Number Account Title NON -BUSINESS LICENSES CLERK 104142-280 CK Phone 104142-310 CK Office Equipment/Supplies 10.4142-370 CK Travel 10-4142-480 CK Dues 10-4142-761 CK Clothing Total CLERK: GENERAL FUND Revenue Total: GENERAL FUND Expenditure Total: Net Total NON -BUSINESS LICENSES: 0 2022-23 2022-23 2023-24 Cur Year Cur Year Fut Year Budget Actual Budget .00 .00 .00 9,200 .00 .00 .00 .00 .00 .00 .00 .00 .00 216 .00 9,200 216 .00 .00 .00 .00 9,200 216 .00 9,200- 216- .00 Modification City of Chubbuck Budget Worksheet Page: 1 Period: 00123 Mar 28, 2023 08:32AM Report Criteria: Print Fund Titles Page and Total by Fund Print Source Titles Total by Source Print Department Titles Total by Department All Segments Tested for Total Breaks Account.Accounl Number = '104151110"-"104155280" Account Number Account Title 2022-23 Cur Year Budget 2022-23 Cur Year Actual 2023-24 Fut Year Budget NON -BUSINESS LICENSES 12,500 FINANCIAL 57,045- 29,128- 12,500 - 10-4151-110 FN Salaries 00 .00 .00 10-4151-111 FN Overtime .00 .00 .00 10-4151-210 FN FICA .00 .00 .00 10-4151-220 FN Retirement .00 .00 .00 10-4151-240 FN Workers' Compensation .00 .00 .00 10-4151-250 FN Health Insurance 11,000 4,629 12,500 104151-280 FN Unemployment .00 .00 .00 10-4151-340 FN Office Equip & Maint 3,000 299 .00 10-4152-280 FN Phone 1,000 .00 .00 10.4152-310 FN Office Equipment/Supplies 22,500 3,160 .00 10-4152-345 FN Computers 14,945 19,135 .00 10-4152-370 FN Travel, Meetings & Other 3,500 1,607 .00 10-4152-480 FN Dues 600 300 .00 10-4152-490 FN Miscellaneous 500 2- .00 10-4152-781 FN Clothing .00 .00 .00 11 FN Lease Capital Outlay .00 .00 .00 10-4152-862 FN Lease Financing Expense .00 .00 .00 10-4152-864 FN Lease Interest Expense .00 .00 .00 10AI53-312 FN Elections & Supplies .00 .00 .00 10-4153-759 FN Phone Stipend .00 .00 .00 10-4153-B00 FN Capital Planning .00 .00 .00 10-4154-300 FN Human Resource .00 .00 .00 10-4155-280 US Phone .00 .00 .00 Total FINANCIAL 57,045 29,128 12,500 GENERAL FUND Revenue Total: .00 .00 .00 GENERAL FUND Expenditure Total: 57,045 29,128 12,500 Net Total NON -BUSINESS LICENSES: 57,045- 29,128- 12,500 - Modification City of Chubbuck Budget Worksheet Page: 1 Period: 00123 Mar28,2023 08:32AM Report Criteria, Print Fund Titles Page and Total by Fund Print Source Titles Total by Source Print Department Titles Total by Department All Segments Tested for Total Breaks AccountAccount Number= '104160110""104160881' Account Number Account Title 2022-23 Cur Year Budget 2022-23 Cur Year Actual 2023-24 Fut Year Budget NON -BUSINESS LICENSES .OD GENERAL FUND Expenditure Total: 135,700 LEGAL 35,500 Net Total NON -BUSINESS LICENSES: 10-4160-110 LL Salaries 58,000 5,121 13,000 10-4160-111 LL Overtime .00 .00 .00 10A160-210 LL. FICA 4,500 373 1,000 10-4160-220 LL Retirement 7,000 644 2,000 10-4160-240 LL Workers' Compensation .00 .00 .00 10.4160-250 LL Health Insurance 17,000 2,532 19,500 10.4160-260 LL Unemployment .00 .00 .00 10.4160-310 LL Office Supplies 9,200 26 .00 10-4160-320 LL Office Equipment & Maint .00 .00 .00 10-4160-330 LL Phone .00 474 .00 10-4160-340 LL Computers .00 257 .00 10-4160-350 LL Travel,Training & Other .00 65 .00 10-4160-360 LL Dues .00 50 .00 10-4160-370 LL Clothing .00 .00 .00 10-4160-380 LL Miscellaneous .00 .00 .00 10-4160420 LL Service 25,000 .00 .00 10-4160-440 LL Pub., Recording, etc. 6,500 1,677 .00 10-4160-680 LL Codification 7,000 5,372 .00 10-4160-661 LLSAUSA 1,500 1,108 .00 Total LEGAL: 135,700 17,701 35,500 GENERAL FUND Revenue Total: .00 .00 .OD GENERAL FUND Expenditure Total: 135,700 17,701 . 35,500 Net Total NON -BUSINESS LICENSES: 135,700- 17,7131- 35,5DO- Modification City of Chubbuck Budget Worksheet Page: 1 Period: 00/23 Mar 28, 2023 08:33AM Report Criteria: Print Fund Tltles Page and Total by Fund Print Source Titles Total by Source Print Department Titles Total by Department All Segments Tested for Total Breaks Account.Account Number = "104191210"-"104195700" Account Number Account Title 2022-23 Cur Year Budget 2022-23 Cur Year Actual 2023-24 Fut Year Budget NON -BUSINESS LICENSES 185,000 166,876 .00 OTHER GENERAL GOVERNMENT 185,000- 166,876- .00 10-4191-210 GV FICA .00 .00 .00 10-4191-220 GV Retirement .00 .00 .00 10-4191-290 GV Unemployment .00 .00 .00 10-4192-450 GV Printing .00 .00 .00 10-4193-240 GV Workers' Compensation .00 00 .00 104193-250 GV Health Insurance .00 .00 .00 10-4193415 GV Website M & O .00 .00 .00 10-4193-460 GV General Insurance 185,000 162,872 .00 10-4194-510 GV Telephone .00 .00 .00 10-4194-520 GV Electric .00 .00 .00 10-4194-521 GV SN/WW/SW Utilities .00 .00 .00 10-4194-522 GV Drug & Alcohol Program .00 .00 .00 10-4195-500 GV Custodial Cleaning .00 151 .00 10-4195-600 GV Building Maint & Repair .00 3,286 .00 10-4195-501 GV Outside Yard .00 337 .00 10-4195-602 GV Other Expense .00 .00 .00 10-4195-603 GV 144 Highway Ave .00 .00 .00 104195-604 GV 216 Highway Ave .00 .00 .00 10-4195-605 GV 234 Highway Ave .00 .00 .00 10-4195-606 GV 12562 N Rio Vista .00 .00 .00 10-4195-607 GV 204 Highway Ave .00 .00 .00 10-4195-609 GV 242-248 Highway Ave .00 .00 .00 10-4195-611 GV 252 Highway Ave .00 .00 .00 10-4195-613 GV 304 Highway Ave .00 .00 .00 10-4195-615 GV 158 Highway Ave .00 .00 .00 10-4195-620 GV Northgate Annexation Fees .00 .00 .00 10-4195-700 GV Miscellaneous Expense .00 231 .00 Total OTHER GENERAL GOVERNMENT: 185,000 166,876 .00 GENERAL FUND Revenue Total: .00 .00 .00 GENERAL FUND Expenditure Total: 185,000 166,876 .00 Net Total NON -BUSINESS LICENSES: 185,000- 166,876- .00 Modification City of Chubbuck Budget Worksheet Page: 1 Period: 00123 Mar 28, 2023 08:34AM Report Criteria: Print Fund Titles Page and Total by Fund Print Source Titles Total by Source Print Department Titles Total by Department All Segments Tested for Total Breaks AcccunLACee6nt Number = '104211110"2104229850" 2022-23 2022-23 2023-24 Cur Year Cur Year Fut Year Account Number Account Title Budget Actual Budget NON -BUSINESS LICENSES LAW ENFORCEMENT 10-4211-110 LE Salaries 2,285,000 953,723 2,366,000 10-4211-111 LE Overtime 12,785 58,249 107,000 10-4211-210 LE FICA 180,000 79,159 185,000 10-4211-220 LE Retirement 295,000 129,621 322,000 104211-230 LE Incentives .00 00 .00 104211-240 LE Workers' Compensation 65,000 36,875 92,000 10-4211-250 LE Health Insurance 580,000 268,174 655,400 10-4211-260 LE Unemployment .00 499 .00 104211420 LE Legal .00 .00 .00 10-4215-203 LE Community Police Grant .00 .00 .00 10-4215-207 LE Juvenile Defferal .00 00 .00 10-4215-300 LE Interagency Services .00 .00 .00 104215-310 LE Office Supplies 3,500 2,072 .00 104215-311 LE Forms, Citations 1,500 56 .00 104215-314 LE Film Purchase .00 .00 .00 104215-315 LE Paper; Copy, etc. 2,000 926 .00 104215-316 LE Misc Dues, Fees, Subscripti 6,000 4,924 .00 10-4215-317 LE Employment Costs 2,500 1,096 .00 10-4215-331 LE Firearms 10,000 523 .00 10-4215-333 LE Patrol New Purchases 8,450 8,228 .00 10-4215-334 LE Patrol Equipment Repair 4,300 .00 .00 10-4215-335 LE Detective - 2,750 1,000 .00 10-4215-336 LE Evidence Supplies 4,500 173 .00 10-4215-339 LE Office Equipment .00 .00 .00 10-4215-340 LE Office Equip Repair 2,500 777 .00 10-4215-341 LE Computer Purchase 5D,000 21,317 .00 10-4215-342 LE Computer Repair .00 .00 .00 10-4215-343 LE Computer Consult 5,000 .00 .00 10-4215-345 LE Computer Contracts 43,000 37,860 .00 10-4215-370 LE Meetings, School 5,000 6,359 .00 10-4215-371 LE Training Lodging 13,000 3,218 .00 10-4215-372 LE Training Per Diem 11,000 523 .00 10-4215-373 LE Training Travel 13,000 292 .00 10-4215-420 LE Legal 82,000 42,000 .00 10-4215-422 LE Court .00 .00 .00 104215-602 LE Miscellaneous 4,500 2,116 .00 104215-65D LE Animal Shelter Operations 3,000 708 .00 10-4215-651 LE Animal Control Donations .00 90- .00 10.4215-652 LE Animal Shelter Building .00 .00 .00 10-4215-653 LE Medical/Hospital .00 .00 .00 10-4215-759 LE Phone Stipend .00 .00 .00 10-4215-761 LE Clothing Allowance 12,000 2,696 .00 10-4215-762 LE Clothing Allowance Non-Swor 2,000 2,232 .00 Modification City of Chubbuck Budget Worksheet Page: 2 Period: 00123 Mar 28, 2023 08:34AM Account Number Account Title 2022-23 Cur Year Budget 2022-23 Cur Year Actual 2023-24 Modification Fut Year Budget 10.4215-830 LE Building Remodel/Addition .00 206 .00 Total LAW ENFORCEMENT: 3,709,285 1,665,507 3,727,400 LAW ENFORCEMENT 1,754,826- 3,727,400- 10-0222-510 LE Telephone/Repair 35,000 17,398 .00 10.4222-630 LE Radio/Repair 1,200 375 .00 10.4222-631 LE Gen Elec Repair .00 .00 .00 10-4222-632 LE Radio New Equipment .00 .00. .00 10-4222-633 LE Batteries 500 531 .00 10-4222-634 LE Dispatch 1,500 1,049 .00 10-4222-635 LE Teletype 8,000 3,650 .00 10-4223-203 LE Community Policing 00 .00 .00 10-4223-208 LE DARE 6,500 1,902 .00 10-4223-211 LE Vest Grant .00 3,653 .00 10-4223-215 LE LLCBG 2005 Match Grant .00 .00 .00 10-4223-217 LE Seat Belt Grant .00 .00 .00 10-4223-219 LE Spillman Grant .00 .00 .00 10-0223-221 LE Gang Grant 5th Year .00 .00 00 10-4223-223 LE Vest Grant .00 .00 .00 10.4223-225 LE Laptop "Cops More" Grant .00 .00 00 10-4229-350 LE Fuel& Lubricants 58,000 31,588 .00 10-4229-500 LE Custodial Contract .00 .00 .00 10-4229-502 LE Custodial Supplies .00 .00 .00 10-4229-520 LE Electric/Maintenance 7,500 4,592 .00 10-4229-521 LE Carpentry .00 .00 .00 10-4229-522 LE Natural Gas 2,000 10,601 .00 10-4229-523 LE Carpentry .00 .00 .00 10-4229-600 LE Building Mainl/Furnace 10,000 4,738 .00 10-4229-610 LE Vehicle Repair 18,500 9,243 .00 10-4229-750 LE Central Garage .00 .00 .00 10-4229-800 LE Capital Planning 16,515 .00 .00 10-4229-821 LE Capital Facilities Lease 375,000 .00 .00 10-4229-850 LE Car Lease/Purchase 80,000 .00 .00 Total LAW ENFORCEMENT: 620,215 89,320 .00 GENERAL FUND Revenue Total: .00 .00 .00 GENERAL FUND Expenditure Total: 4,329,500 1,754,826 3,727,400 Net Total NON -BUSINESS LICENSES: 4,329,500- 1,754,826- 3,727,400- City of Chubbuck Budget Worksheet Page: 3 Period: 00123 Mar 28, 2023 08:34AM 2022-23 2022-23 2023-24 Modification Cur Year Cur Year Fut Year Account Number Account Title Budget Actual Budget Report Criteria: Print Fund Titles Page and Total by Fund Print Source Titles Total by Source Print Department Titles Total by Department All Segments Tested for Total Breaks Account.Account Number ='104211110""104229850" City of Chubbuck Budget Worksheet Page: 1 Period: 00/23 Mar 29, 2023 02:06PM Report Criteria: Print Fund Titles Page and Total by Fund Print Source Titles Total by Source Print Department Titles Total by Department All Segments Tested for Total Breaks AccountAccount Number ="104231110'-"104238864" Account Number Account Title NONBUSINESS LICENSES FIRE CONTROL & PREVENTION 10-4231-110 FC Salaries 10-4231-111 FC Salaries OT 10-4231-112 FC Salaries Work Out Of Class 10-4231-115 FC Salaries Paycall 10-4231-210 FC FICA 10-4231-215 FC FICA Paycall 10-4231-220 FC Retirement 10-4231-240 FC Workers' Compensafion 10-4231-245 FC Workers' Comp Paycall 10-4231-250 FC Health Insurance 10-4231-255 FC Health Insurance Paycall 10-4231-260 FC Unemployment 10-4231-265 FC Unemployment Paycall 10-4231-300 FC Interagency Services 10-4231-310 FC Office Supplies 10-4231-345 FC Computer Software 10-4231-347 FC Dues 10-4231-517 FC Vaccine & Testing 10-4231-519 FC Physical Exams 10-4231-520 FC Electrical Power 10-4231-522 FC Natural Gas 10-4231-600 FC Building Maintenance 10-4231-730 FC Building Remodel/Addition 10-4231-740 FC Safely 10-4231-770 FC Debt Service 10-4231-771 FC Interest Expense 10-4231-801 FC EMS Grant 10-4231-802 FC Dedicated Grants 10-4231-803 FC ASPR Grants 10-4231-900 FC EMS 10-4231-901 FC EMS Improvements 10-4235-510 FC Telephone 10-4235-630 FC Communications 10-4235-632 FC Radio New 10-4236-370 FC Training 10-4236-371 FC Continuing Education 10-4236-375 FC Prevention 104236-376 FC Prevention Grants 104236-377 FC Pre -Fire Plans 10-4236-379 FC Supplies 10-4236-380 FC Fire Meals 10-4236-759 FC Phone Stipend 10-4236-761 FC Uniforms 2022-23 2022-23 2023-24 Modification Cur Year Cur Year Fut Year Budget Actual Budget 1,025,000 482,204 1,852,000 101,000 46,812 101,000 .00 .00 .00 81,000 27,968 81,000 79,000 41,697 147,000 6,000 2,239 6,100 136,726 68,129 255,000 30,000 15,482 63,000 12,000 6,131 15,300 231,650 111,903 441,650 5,000 1,733 5,000 .00 .00 .00 .00 .00 DO .00 .00 .00 5,492 748 .00 69,500 22,378 .00 4,000 290 .00 5,000 .00 .00 13,000 4,825 .00 7,500 2,620 .00 3,200 2,956 .00 18,500 5,535 .00 .00 .00 .00 5,000 .00 , .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 5,000 553 .00 .00 .00 .00 7,500 3,738 .00 3,000 .00 .00 .00 .00 .00 14,262 6,303 .00 738 245- .00 5,000 1,696 .00 .00 .00 .00 .00 .00 .00 7,000 1,990 .00 3,000 83 .00 .00 .00 .00 9,500 582 .00 City of Chubbuck Budget Worksheet Page: 2 Period: 00/23 Mar 29, 2023 02:06PM Report Criteria: Print Fund Titles Page and Total by Fund Print Source Titles Total by Source Print Department Titles Total by Department All Segments Tested for Total Breaks Account.Account Number = "104231110"2104238864' Modification 2022-23 2022-23 2023-24 Cur Year Cur Year Fut Year Account Number Account Title Budget Actual Budget 10-4236-763 FC Drug Testing 1,500 98 .00 10-4237-350 FC Fuel 22,000 5,830 .00 10-4237-610 FC Equipment Maintenance 14,500 1,824 .00 10-4237-611 FC Vehicle Maintenance 16,500 5,722 .00 10-4237-661 FC SCBA 30,000 .00 .00 10-4237-670 FC Grant Purchase .00 .00 .00 10-4238-369 FC Equipment 25,545 2,077 .00 10-4238-392 FC Protection 25,000 5,486 .00 10-4238-700 FC COVID 19 00 .00 .00 10-4238-800 FC Capital Planning .00 .00 .00 10-4236-601 FC Lease Airial 117,000 .00 .00 10-4238-860 FC Lease Capital Outlay .00 .00 .00 1OA238-862 FC Lease Financing Expense .00 .00 .00 10-4238-864 FC Lease Interest Expense .00 .00 .00 Total FIRE CONTROL & PREVENTION: 2,145,613 879,365 2,967,050 GENERAL FUND Revenue Total: .00 .00 .00 GENERAL FUND Expenditure Total: 2,145,613 879,385 2,967,050 Net Total NON -BUSINESS LICENSES: 2,145,613- 879,385- 2,967,050 - Net Grand Totals: 2,145,613- 879,385- 2,967,050 - Report Criteria: Print Fund Titles Page and Total by Fund Print Source Titles Total by Source Print Department Titles Total by Department All Segments Tested for Total Breaks Account.Account Number = "104231110"2104238864' Modification City of Chubbuck Budget Worksheet Page: 1 Period: 00/23 Mar 28, 2023 08:42AM Report Criteria: Print Fund Titles Page and Total by Fund Print Source Titles Total by Source Print Department Titles Total by Department All Segments Tested for Total Breaks Account.Account Number= 104250339-104250800 Account Number Account Title 2022-23 Cur Year Budget 2022-23 Cur Year Actual 2023-24 Fut Year Budget NON -BUSINESS LICENSES 118,000 3,440 .00 INFORMATION TECHNOLOGY 118,000- 3,449- .00 10-4250-339 IT Office Equipment 1,500 .00 .00 104250-340 IT Office Equip Repair .00 .00 .00 101250-341 IT Computer Purchase 25,000 .00 .00 10-4250-342 IT Computer Repair 20,000 .00 .00 10-4250-345 IT Computer Contracts 6,500 .00 .00 10-4250-346 IT Computer Contracts - Sollus 25,OD0 .00 .00 10-4250-348 IT Software 32,500 .00 .00 10-4250-350 IT Fuel .00 .00 .00 10-4250-36D IT Small Tools/Equipment .00 .00 .00 10-4250-370 IT Training 6,000 594- .00 104250-415 IT Website M & O .00 4,043 .00 10-4250-416 IT Hardware .00 .00 .00 10-4250-800 IT Capital Planning 1,500 .00 .00 Total INFORMATION TECHNOLOGY: 118,000 3,449 .00 GENERAL FUND Revenue Total: .00 .00 .00 GENERAL FUND Expenditure Total: 118,000 3,440 .00 Net Total NON -BUSINESS LICENSES, 118,000- 3,449- .00 Modification City of Chubbuck Budget Worksheet Page: 1 Period: 00123 Mar 28, 2023 08:35AM Report Criteria: Print Fund Titles Page and Total by Fund Print Source Titles Total by Source Print Department Titles Total by Department All Segments Tested for Total Breaks Accounl.Accounl Number = "104260110"2104261280" Account Number Account Title 2022-23 Cur Year Budget 2022-23 Cur Year Actual 2023-24 Fut Year Budget NON -BUSINESS LICENSES .00 GENERAL FUND Expenditure Total: 59,200 HUMAN RESOURSE 57,000 10-4260-110 HR Salaries .00 .00 .00 10-4260-111 HR Overtime .00 .00 .00 10-4260-210 HR FICA .00 .00 .00 10-4260-220 HR Retirement .00 .00 .00 10-4260-240 HR Workers' Compensation .00 .00 .00 10-4260-250 HR Health Insurance 50,000 .00 57,000 10-4260-260 HR Unemployment .00 .00 .00 10-4260-310 HR Office Supplies .00 .00 .00 10-4260-315 HR Dues, Fees, Subscriptions 2,500 2,500 .00 10-4260-340 HR Office Equipment .00 .00 .00 10-4260-345 HR Computer Purchase 2,500 .00 .00 10-4260-346 HR Computer Repair .OD .00 .00 10-4260-347 HR Computer Software 2,500 .00 .00 10-4260-360 HR Small Tools and Equipment .00 .00 .00 10-4260-370 HR Training 1,700 .00 .00 10-4260-480 HRTravel .00 .00 .00 1042604190 HR Miscellaneous Expense .00 476 .00 10-4260-759 HR Phone Stipend .00 .00 .00 10-4260-800 HR Capital Planning .00 .00 .00 10-4261-280 HR Phone .00 .00 .00 Total HUMAN RESOURSE: 59,200 2,976 57,000 GENERAL FUND Revenue Total: .00 .00 .00 GENERAL FUND Expenditure Total: 59,200 2,976 57,000 Net Total NON -BUSINESS LICENSES: 59,200- 2,976- 57,000 - Modification City of Chubbuck Budget Worksheet Page: , Period: 00/23 Mar 28, 2023 08.37AM Report Criteria: Print Fund Titles Page and Total by Fund Print Source Titles Total by Source l" Print Department Titles U'v W 444 i s Total by Department All Segments Tested for Total Breaks Account Account Number ="104330600" 2022-23 2022-23 2023-24 Modification Cur Year Cur Year Fut Year Account Number Account Title Budget Actual Budget 2S,000 City of Chubbuck Budget Worksheet Page: 1 Period: 00123 Mar 28, 2023 08:38AM Report Criteria: Print Fund Titles Page and Total by Fund Print Source Titles Total by Source Print Department Titles Total by Department All Segments Tested for Total Breaks Account.Account Number ="104400110'-"104569130" 2022-23 2022-23 2023-24 Cur Year Cur Year Fut Year Account Number Account Title Budget Actual Budget NON -BUSINESS LICENSES CS PERSONNEL EXPENSE 10-4400-110 CS Salaries 267,000 85,965 299,000 10-4400-111 CS Overtime 1,000 386 1,000 10-4400-210 CS FICA 20,000 6,343 22,500 10-4400-220 CS Retirement 32,000 10,231 36,000 10-4400-240 CS Workers' Compensation 2,500 1,076 2,700 10-4400-250 CS Health Insurance 63,500 22,736 72,000 10-4400-260 CS Unemployment .00 .00 .00 10-4400-759 CS Phone Stipend .00 .00 .00 10-4400-761 CS Clothing .00 .00 .00 Total CS PERSONNEL EXPENSE: 386,000 126,738 433,200 CS SUPPORT SERVICES 10-4412-101 CS Engineering .00 .00 .00 10-4412-111 CS Planning & Development .00 .00 .00 10-4412-121 CS Fleet Maintenance .00 .00 .00 10-4412-130 CS IT .00 .00 .00 104412-140 CS Utility Billing .00 .00 .00 10-4412-150 CS Finance .00 .00 .00 10-4412-170 CS Human Resource .00 .00 .00 Total CS SUPPORT SERVICES: .00 .00 .00 CS ADMINISTRATION 10-4423-100 CS Billing Expense .00 69 .00 10-4423-111 CS Certification/Licensing 500 30 .00 10-4423-120 CS City Hall Lease .00 .00 .00 1OA423-130 CS City Hall Operations .00 .00 .00 10-4423-140 CS Computer/IT Hardware 2,000 .00 .00 10-4423-150 CS Computer/IT Software 7,500 1,797 .00 10-4423-160 CS Employee Continuing Educati .00 .00 .00 10-4423-170 CS Employee Phone Stipend .00 .00 .00 10-4423-180 CS Employee Recognition 500 26 .00 10-4423-190 CS Equipment Insurance .00 .00 .00 10-4423-200 CS Liability Insurance .00 .00 .00 10-4423-210 CS Mapping/OIS System .00 .00 .00 10-4423-220 CS Membership Dues 18,000 848 .00 10-4423-230 CS Office Equipment/Supplies 1,386 21 .00 10-4423-240 CS Professional Services 1,500 76 .00 10-4423-250 CS Shop Facilty Lease .00 .00 .00 10-4423-260 CS Training/Seminars 1,500 464 .00 10-4423-270 CS Travel 2,000 304 .00 10-4423-280 CS Utility Telephone 1,000 412 .00 Modification City of Chubbuck Budget Worksheet Period: 00/23 2022-23 2022-23 2023-24 Cur Year Cur Year Fut Year Account Number Account Title Budget Actual Budget 10.4423-290 CS Utility Electrical .00 .00 .00 10.4423-300 CS Utility Natural Gas .00 .00 .00 10-4423-310 CS Facility MaintlJanitorial .00 .00 .00 10-4423-320 CS Pocatello Trade Inspections 10,000 16,543 .00 10-4423-321 CS FC Subdivision Fees remit .00 .00 .00 Total CS ADMINISTRATION: 45,886 20,591 .00 CS EQUIPMENT 10-4434-100 CS Fuel & Lubricants 1,500 546 .00 10-4434-110 CS Small Tools/Equipment .00 .00 .00 10-4434-120 CS Vehicle M & O 2,500 .00 .OD 104434-130 CS Vehicle Replacement .00 .00 .00 Total CS EQUIPMENT: 4,000 546 .00 CS SAFETY 10-4455-100 CS Training 500 .00 .00 10-4455-110 CS Clothing 500 348 .00 10-4455-120 CS Equipment .00 .00 .00 Total CS SAFETY: 1,000 348 .00 CS FINANCE 104469-100 CS Transfer from Depreciation .00 .00 .00 104469-160 CS Interagency Services .00 .DO .00 Total CS FINANCE: .00 .00 .00 CS PK PERSONNEL EXPENSE 10-4470-110 CS PK Salaries 302,000 124,106 356,000 10-447D-111 CS PK Overtime 13,000 4,448 13,000 10-4470-112 CS PK Seasonal Temporary 50,000 630 65,000 104470-210 CS PK FICA 28,000 9,542 28,000 104470-220 CS PK Retirement 42,000 15,177 45,000 10-4470-240 CS PK Workers' Compensation 12,000 5,484 14,000 10-4470-250 CS PK Health Insurance 102,000 33,072 116,000 104470-260 CS PK Unemployment .00 .00 .00 104470-759 CS PK Phone Stipend 800 180 .00 10-4470-761 CS PK Clothing .00 263 .00 Total CS PK PERSONNEL EXPENSE: 549,800 192,901 637,000 CS PK SUPPORT SERVICES - 10-4481-100 CS PK Engineering .00 .00 .00 10-4481-110 CS PK Planning & Development .00 .DO .00 104481-120 CS PK Fleet Maintenance 24,000 .00 .00 104481-140 CS PK Utility Billing .00 .00 .00 10-4481-150 CS PK Finance .00 .00 .00 10-4481-160 CS PK Human Resource .00 .00 .00 10-4481-170 CS PK Administration .00 .00 .00 Total CS PK SUPPORT SERVICES: 24,000 .00 .00 CS PK ADMINISTRATION 10-4492-100 CS PK Billing Expense .00 228 .00 Modification Page: 2 Mar 28, 2023 08:38AM City of Chubbuck Budget Worksheet Page: 3 Period: 00123 Mar 28, 2023 08:38AM 2022-23 2022-23 2023-24 Modification Cur Year Cur Year Fut Year Account Number Account Title Budget Actual Budget 10-4492-110 CS PK Certifications/Licensing 3,000 1,349 .00 1OA492-120 CS PK City Hall Lease .00 .00 .00 10-4492-130 CS PK City Hall Operations 5,500 2,311 .00 10-4492-140 CS PK ComputerllT Hardware .00 127 .00 10-4492-150 CS PK ComputedlT Software .00 13,389 AO 10-4492-160 CS PK Employee Continuing Educ .00 .00 .00 10-4492-170 CS PK Employee Phone Stipend .DO .DO .00 10-4492-180 CS PK Employee Recognition .00 8 .00 10-4492-190 CS PK Equipment Insurance .00 .00 .00 10-4492-200 CS PK Liability Insurance .00 .00 .00 10-4492-210 CS PK Mapping GIS System .00 .00 .00 10.4492-220 CS PK Membership Dues .00 454 .00 10-4492-230 CS PK Office Equipment Supple 800 353 .00 10-4492-240 CS PK Professional Services .00 2,945 .00 10-4492-250 CS PK Shop Facility Lease .00 .00 .00 10-4492-260 CS PK Training Seminars 2,000 268 .00 104492-270 CS PK Travel 3,400 640 .00 10-4492-280 CS PK Utility Telephone 800 284 .OD 10-4492-290 CS PK Utility Electrical 9,000 3,177 .00 10-4492-300 CS PK Utility Natural Gas 1,400 1,484 .00 10-4492-310 CS PK Facility Maintenance Jan 1,000 667 .00 10-4492-320 CS PK Yard Facility Construct! 2,500 1,421 .00 10-4492-330 CS PK Yard Facility Operations .00 4 .00 Total CS PK ADMINISTRATION: 29,400 29,107 .00 CS PK Maintenance 10-4503-100 CS PK Mowing .00 231 .00 10-4503-110 CS PK Irrigation 7,500 408 .00 10-4503-120 CS PK Weeds 5,200 .00 .00 10-4503-130 CS PK Trees 6,000 650 .00 10-4503-140 CS PK Fertilizer 2,000 .00 .00 Total CS PKMaintenance: 20,700 1,289 .00 CS PK Facility Maintenance 10-4514-100 CS PK Playgrounds .00 2,319 .00 10-4514-110 CS PK Restroom 9,000 1,656 .00 10-4514-120 CS PK Building 1,500 6,182 .00 10-4514-130 CS PK Walking Path 1,500 1,033 .00 1 OA514-140 CS PK Pavilion 1,000 347 .00 10-4514-150 CS PK Light Poles 1,000 .00 .00 10-4514-160 CS PK Basketball Court .00 .00 .00 10-4514-170 CS PK Fence 500 .00 .00 10-4514-180 CS PK Splash Pad 12,500 665 .00 10.4514-190 CS PK Volleyball Court 1,000 .00 .00 10-4514-200 CS PK Ball Fields 2,500 5,790 .00 10-4514-210 CS PK Tennis Court 60,000 .00 .00 Total CS PK Facility Maintenance: 90,500 17,992 .00 CS PK Shoulder Work 10-4524-541 CS SEICCA .00 .00 .00 10-4525-100 CS PK Mowing .00 .00 .00 10-4525-110 CS PK Weeds .00 .00 .00 1 OA525-120 CS PK Trees .00 .00 .00 City of Chubbuck Budget Worksheet Page: 4 Period: 00/23 Mar 28, 2023 08:38AM Account Number Account Title 2022-23 Cur Year Budget 2022-23 Cur Year Actual 2023-24 Fut Year Budget 104525-130 CS PK Snow Removal 2,500 95 .DO Total CS PK Shoulder Work: 2,500 95 .00 CS PK Property Net Total NON -BUSINESS LICENSES: 1,201,886- 10-4536-100 CS PK Mowing .00 .00 .00 10-4536-110 CS PK Weeds .00 .00 .00 10-4536-120 CS PK Trees .00 100 .00 10-4536-130 CS PK Trash 3,500 .00 .00 10-4536-140 CS PK ADA 1,500 .00 .00 Total CS PK Property: 5,000 100 .00 CS PK Additional Services 10-4547-120 CS PK Park Reservations .00 .00 .00 10-4547-140 CS PK Hanging Flowers 9,000 .00 .00 104547-150 CS PK Assist Departments .00 .00 .00 10-4547-160 CS PK Interagency Services .00 .00 .00 Total CS PK Additional Services: 9,000 .00 .00 CS PK Equipment 10-4558-100 CS PK Fuel & Lubricants 13,500 9,576 .00 10-4558-110 CS PK Small Tool/Equipment 3,500 316 .00 10-4558-120 CS PK Large Equipment 10,000 4,581 .00 Total CS PK Equipment: 27,000 14,472 .00 CS PK Safety 10-4569-100 CS PK Training 4,000 1,060 .00 10-4569-110 CS PK Clothing 2,000 728 .00 10-4669-120 CS PK Equipment 600 1,965 .00 104569-130 CS PK Testing 500 65 .00 Total CS PK Safety: 7,100 3,818 .00 GENERAL FUND Revenue Total: .00 .00 .00 GENERAL FUND Expenditure Total: 1,201,886 407,997 1,070,200 Net Total NON -BUSINESS LICENSES: 1,201,886- 407,997- 1,070,200 - Report Criteria: Print Fund Titles Page and Total by Fund Print Source Titles Total by Source Print Department Titles Total by Department All Segments Tested for Total Breaks Account, Account Number = '104400110'="104569130" Modification City of Chubbuck _ Budget Worksheet Page: 1 Period: 00/23 Mar 28, 2023 08:22AM Report Criteria: Print Fund Titles Page and Total by Fund Print Source Titles Total by Source Print Department Titles Total by Department All Segments Tested for Total Breaks Account.Account Number = "114311110"2114380822" Modification 2022-23 2022-23 2023-24 Cur Year Cur Year Ful Year Account Number Account Title Budget Actual Budget HIGHWAY, STREETS, AND ROADS HSR PERSONNEL EXPENSES 11-4311-110 HSR Salaries 488,600 216,867 558,000 11-4311-111 HSR Overtime 17,000 15,724 17,000 11-4311-210 HSR FICA 39,400 18,063 43,000 11-4311-220 HSR Retirement 62,800 28,712 69,000 11-4311-240 HSR Workers' Compensation 11,100 5,773 14,500 11-4311-250 HSR Health Insurance 159,800 69,508 181,000 11-4311-260 HSR Unemployment .00 .00 .00 11-4311-759 HSR Phone Stipend .00 188 .00 11-4311-761 HSR Clothing .00 54 .00 114312-100 HSR Engineering .00 .00 .00 114312-110 HSR Planning & Development .00 .00 .00 11-4312-120 HSR Fleet Maintenance .00 .00 .00 11-4312-130 HSR IT .00 .00 .00 11-4312-140 HSR Utility Billing .00 .00 .00 11-4312-150 HSR Finance .00 .00 .00 11-4312-160 HSR Human Resource .00 .00 .00 11-4312-170 HSR Administration .00 .00 .00 Total HSR PERSONNEL EXPENSES: 778,700 354,888 882,500 HSR ADMINISTRATION 11-4333-100 HSR Billing Expense .00 .00 .00 11-4333-110 HSR Certifications/Licensing 800 451 .00 11-4333-120 HSR City Hall Lease 78,000 .00 .00 11-4333-130 HSR City Hall Operations 14,000 4,911 .00 11-4333-140 HSR Computer/IT Hardware 20,000 191 .00 11-4333-160 HSR Computer/IT Software 30,000 20,757 .00 11-4333-160 HSR Employee Continuing Educat .00 .00 .00 11-4333-170 HSR Employee Phone Stipend 500 .00 .00 114333-180 HSR Employee Recongnilion 1,300 380 .00 11-4333-190 HSR Equipment Insurance .00 .00 .00 11-4333-200 HSR Liability Insurance .00 .00 .00 11-4333-210 HSR Mapping/GIS Systems 3,300 414 .00 11-4333-220 HSR Membership/Dues 70,000 29,388 .00 114333-230 HSR Office EquipmenUSupplies 7,500 163 .00 114333-240 HSR Professional Services 10,000 2,518 .00 114333-250 HSR Shop Facility Lease .00 .00 .00 11-4333-260 HSR Training/Seminars 1,800 697 .00 11-4333-270 HSR Travel .00 39 .00 114333-280 HSR Utility Telephone 6,500 3,066 .00 11-4333-290 HSR Utility Electrical 6,500 3,416 .00 11-4333-300 HSR Utility Natural Gas 4,000 2,031 .00 11-4333-310 HSR Facility Maintenance/Janit 10,000 794 .00 Modification City of Chubbuck Account Number 11-4333-320 11-4333-330 Account Title HSR Yard Facility Construction HSR Yard Facility Operations Total HSR ADMINISTRATION: Budget Worksheet Period: 00/23 2022-23 2022-23 2023-24 Modification Cur Year Cur Year Fut Year Budget Actual Budget 7,000 4,163 5,000 1,036 276,200 74,416 .00 .00 .00 HSR ASPHALT MAINTENANCE 11-4340-100 HSR Crack Seal 10,000 .00 .00 11-4340-110 HSR Asphalt Patching 10,000 32 .00 11-4340-12D HSR Pothole 10,000 .00 .00 11 A340-130 HSR Surface Maintenance 547,400 2,365 .00 11-4340-140 HSR Street Construction 25,000 12,047 .00 11-4341-100 HSR Lane Striping 51000 .00 .00 11-4341-110 HSR Pavement Marking 20,000 2,948 .00 11-4342-100 HSR Sign Materials 13,000 8,928 .00 11-4343-100 HSR Material Disposal 1,500 .00 .00 11.4343-110 HSR Storage Facility .00 .00 .00 11-4343-120 HSR Sweeper M&O .00 .00 .00 11-4344-100 HSR Salt 10,000 16,580 .00 11-4344-110 HSR Sand 5,000 .00 .00 11-4344-120 HSR Brine 1,000 20 .00 11-4344-130 HSR Snow Equipment M&O .00 .00 .00 114345-100 HSR Maintenance 15,000 .00 .00 11-4345-110 HSR Weed Control 5,000 .013 .00 11-4345-120 HSR Repairs 1,000 .00 .00 114345-130 HSRADA 10,000 .00 .00 114346-100 HSR Maintenance 5,000 .00 .00 11-4346-110 HSR Weed Control 5,000 .00 .00 11-4346-120 HSR Repairs 1,000 .00 .00 11-4347-100 HSR Power 85,000 40,945 .00 11-4347-110 HSR Construction/Installation 500 .00 .00 11-4347-120 HSR M & O 6,000 2,3D1 .00 11-4348-100 HSR Power 5,000 2,072 .00 11-4348-110 HSR Construction/Installation 3,000 .00 .00 11-4348-120 HSR M & O 5,000 919 .00 11-4349-100 HSR Cleaning/Disposal 4,000 00 .00 11-4349-110 HSR Construction/Installation 75,000 23,086 .00 11-4349-120 NSR M & 0 5,000 .00 .00 Total HSR ASPHALT MAINTENANCE: 888,400 112,243 .00 HER ROADWAY PROJECT 11-4350-100 HSR Siphon Rd .00 .00 .00 11-4350-110 HSR Hawthorne Rd .00 .00 .00 114350-120 HSR Hawthorne & Quinn 20,000 .00 .00 11-4350-130 HSR Sacajawea Roundabout 5,000 .00 .00 11-4351-100 HSR Fuel & Lubricants 25,000 15,225 .00 11-4351-110 HSR Equipment & 0 45,000 1,950 .00 11-4351-120 HSR Vehicle M & O 45,000 668 .00 11-4351-130 HSR Capital Planning .00 .00 .00 11-4351-140 HSR New Equipment Planning 75,000 1,358- .00 11-4351-150 HSR New Vehicle Planning .00 5,000 .00 11-4351-160 HSR Small Tools & Equipment 2,500 93 .00 114352-100 HSR Training 1,200 3,764 .00 114352-11D HSR Clothing 1,000 1,637 .00 11-4352-120 HSR Equipment 500 442 .0D 11-4352-130 HSR Testing SOD 16 .00 Page: 2 Mar 28, 2023 08:22AM City of Chubbuck Budget Worksheet Page: 3 Period: 00/23 Mar 28, 2023 08:22AM Account Number Account Title 2022-23 Cur Year Budget 2D22-23 Cur Year Actual 2023-24 Ful Year Budget 11-4353-100 HSR Flags .00 .00 .00 11-4353-110 HSR Banners .00 00 .OD 11-4353-120 HSR Christmas Decorations .DO 00 .OD 11-4353-130 HSR Chubbuck Days .00 .00 .00 11-4353-140 HSR Tree Trimming .00 .00 .00 11-4353-150 HSR Interagency Services .00 .00 .00 Total HSR ROADWAY PROJECT: 220,700 27,438 .00 HSR FINANCE 114380-100 HSR Transfer from Depreciation .00 .00 .00 11-4380-500 HSR City Hall Construction - .00 384 .00 11-4380-798 HSR Notes Interest Expense .00 .00 .00 11-4380-800 HSR Capital Planning .00 .00 00 11-4380-822 HSR Wastewater Loan 136,000 .00 .00 Total HSR FINANCE: 136,000 384 .00 HIGHWAY, STREETS, AND ROADS Revenue Total: .DO .00 .00 HIGHWAY, STREETS, AND ROADS Expenditure Total: 2,300,000 569,369 882,500 Net Total HIGHWAY, STREETS, AND ROADS: 2,300,000- 569,369- 882,500 - Report Criteria: Print Fund Titles Page and Total by Fund Print Source Titles Total by Source Print Department Titles Total by Department All Segments Tested for Total Breaks Account.Account Number = "114311110"-"114380822" Modification City of Chubbuck Budget Worksheet Page: 1 Period: 00/23 Mar 28, 2023 08:18AM Report Criteria: Print Fund Titles Page and Total by Fund Print Source Titles Total by Source Print Department Titles Total by Department All Segments Tested for Total Breaks Account.Account Number = "31 43 4111 0"-"314390904" 2022-23 2022-23 2023-24 Cur Year Cur Year Fut Year Account Number Account Title Budget Actual Budget WATER UTILITY WW PERSONNEL EXPENSE 31-4341-110 WW Salaries 689,900 296,685 712,000 31-4341-111 WW Overtime 8,800 11,284 8,800 31-4341-210 WW FICA 53,800 23,810 54,000 31-4341-220 WW Retirement 67,100 38,145 87,000 314341-221 WW PERSI Pension Expense .00 .00 .00 314341-240 WW Workers'Compensation 20,100 10,055 25,000 31-4341-250 WW Health Insurance 239,100 95,029 271,000 31-4341-260 WW Unemployment .00 .00 .00 31-4341-759 WW Phone Stipend .00 163 .00 31-4341-761 WWClolhing .00 10 .00 31.4342-100 WW Engineering .00 .00 .00 31-4342-110 W W Planning & Development .00 .00 .00 31-4342-120 WW Fleet Maintenance .00 .00 .00 31-4342-130 WW IT .00 .00 .00 31-4342-140 WW Utility Billing .00 .00 .00 31-4342-150 WW Finance .00 .00 .00 31-4342-160 WW Human Resource .00 .00 .00 31-4342-170 WW Administration .00 .00 .00 Total WW PERSONNEL EXPENSE: 1,098,800 475,182 1,157,800 WW ADMINISTRATION 31-4353-100 WW Billing Expense 31,000 7,370 .00 314353-110 WW Certifications/Licensing 9,000 683 .00 31-4353-120 WW City Hall Lease 165,000 .00 00 31-4353-130 WW City Hall Operations 3,000 10,064 .00 31-4353-140 W W Computer/IT Hardware 20,000 286 .00 31-4353-150 WW Computer/IT Software 17,000 33,415 .00 31-4353-160 WW Employee Contunuing Educati 1,D00 .00 .00 31-4353-170 WW Employee Phone Stipend .00 .00 .00 31-4353-160 WW Employee Recongnition 2,500 389 .00 314353-190 WW Equipment Insurance .00 .00 .00 314353-200 WW Liability Insurance 00 .00 .00 31-4353-210 WW Mapping/GIS Systems 3,000 414 .00 31-4353-220 WW Membership/Dues 3,000 13,015 .00 31-4353-230 WW Office Equipment/Supplies 5,500 843 .00 31-4353-240 WW Professional Services 100,000 14,316 .00 314353-250 WWF Shop Facility Lease 1,000 .00 .00 31-4353-260 WW Training/Seminars 4,000 1,064 .00 31-4353-270 WW Travel 1,000 39 .00 31-4353-280 WW Utility Telephone 7,500 3,995 .00 31-4353-290 WW Utility Electrical 5,500 4,527 .00 31-4353-300 WW Utility Natural Gas 5,500 3,307 .00 Modification City of Chubbuck Budget Worksheet Page: 2 Period: 00/23 Mar 28, 2023 08:18AM Modification 2022-23 2022-23 2023-24 Cur Year Cur Year Ful Year Account Number Account Title Budget Actual Budget 314353-310 WW Facility Maintenance/Janito 15,000 208 .00 314353-320 WW Yard Facility Construction 7,000 5,806 .00 31-4353-330 WW Yard Facility Operations 10,000 1,036 .00 Total WW ADMINISTRATION: 416,500 100,777 .00 WW PRODUCTION AND STORAGE 31-4360-100 WW Well Head Protection .00 .00 .00 31-4360-110 WW Building M & 0 1,000 2,499 .00 31-4360-120 W W Scada M & 0 12,000 701 .00 31-4360-130 WW Electrical Motor M & O .00 .00 .00 31-4360-140 WW Pump M & 0 82,900 .00 .00 31-4360-150 WW Well Equipment M & 0 4,500 .00 .00 31-4360-160 WW Disinfection Equipment M&0 2,000 347 .00 31-4360-170 WW Disinfection Chemical 15,000 .00 .00 314360-180 WW Treatment Chemical 15,000 .00 .00 31-4360-190 WW QC Sampling & Testing 6,000 4,762 .00 314380-200 WW Electrical Power 185,000 67,909 .00 31-4380-210 WW Storage M & O 5,500 413 .00 31-4380-220 WW Water Rights 11,000 12,682 .00 31-4360-230 WW DEQ Assesment 34,000 13,632 .00 31-4361-100 WW Piping M & 0 22,000 3,297 .00 31-4361-110 WW Valve M & 0 15,000 .00 .00 31-4361-120 WW Valve Replacement 4,000 .00 .00 31-4361-130 WW System Improvements 50,000 44 .00 31-4361-140 WW Digline 1,500 .00 .00 31-4361-150 WW Capital Planning 1,669,800 4,393 .00 314361.160 WW Line Flushing 5,000 .00 .00 31-4362-100 WW New Connections 1,000 1,607 .00 31-4362-110 WW Service Connection M & 0 1,800 1,020 .00 314362-120 WW Meters 45,000 58,275 .00 314362-130 WW Meter Reading Equipment 25,000 .00 .00 31-4363-100 WW Fire Hydrant M & O 15,000 3,531 .00 31-4363-110 WW Fire Hydrant Replacement 10,000 1,600 .00 314383-120 WW Storz Fittings .00 .00 .00 31-4384-100 WW Pump M & 0 15,000 .00 .00 31-4364-110 WW Electrical Power 2,000 1,265 .00 31-4364-120 WW System M & 0 80,000 .00 .00 31-4364-130 WWDigline 1,000 761 .00 31-4364-140 WW Fort Hall Water Rights 35,000 37,735 .00 Total WW PRODUCTION AND STORAGE: 2,352,000 216,472 .00 WW ADDITIONAL SERVICES 31-4370-100 WW Meter Can Adjustments .00 .00 .00 314370-110 WW Special Turn On/Off .00 .00 .00 314370-120 WW Contractor Testing Assistan .00 .00 .00 31-4370-130 WW Interagency Services .00 .00 .00 Total WW ADDITIONAL SERVICES: .00 .00 .00 WW EQUIPMENT EXPENSE 31-4380-100 VAN Pickup Repair & Maintenance 10,000 393 .00 31-4380-110 WW Large Truck Repair & Mainle 33,000 25,420 .00 314380-120 WW Heavy Equipment Repair & Me 5,000 988 .00 314380-130 WW Truck & Equipment Capital P 125,000 .00 .00 Modification City of Chubbuck Budget Worksheet Page: 3 Period: 00123 Mar 28, 2023 0&18AM Account Number Account Title 2022-23 Cur Year Budget 2022-23 Cur Year Actual 2023-24 Fut Year Budget 31-4380-140 WW Fuel& Lubricants. 24,000 10,450 .00 31-4380-150 WW Small Tools/Equipment 3,000 4,967 .00 31-4380-160 WW Equipment Rental 2,000 12 .00 314381-100 WW Training 1,500 2,683 .00 314381-110 WWClothing 2,500 1,539 .00 31-4381-120 WW Equipment 2,000 4,425 .00 31-4381-130 WW Testing 1,000 434 .00 Total WW EQUIPMENT EXPENSE: 209,000 51,289 .00 WW FINANCE 31-4390-500 WW COP Amortization .00 00 .00 31-4390-501 WW City Hall Construction .00 809 .00 314390-502 WW COP .00 .00 .00 31-4390-812 WW Bonds & Interest 000,000 .00 .00 31-4390-813 WW Notes & Interest 25,000 .00 .00 314390-820 WW Lease Financing Expense .00 .00 .00 314390-821 WW Lease Amortization Expense .00 .00 .00 31-4390-822 WW Lease Interest Expense .00 .00 .00 31-4390-900 WW Bad Debt Expense 00 .00 .00 31-4390-901 W W Transfers Out .00 .00 .00 31-4390-902 WW Depreciation .00 .00 .00 31-4390-903 WW Loss on Asset Disposal .00 .00 .00 31-4390-904 WW Miscellaneous Expense .00 .00 .00 Total WW FINANCE: 625,000 809 .00 WATER UTILITY Revenue Total: .00 .00 .00 WATER UTILITY Expenditure Total: 4,701,300 844,528 1,157,800 Net Total WATER UTILITY: 4,701,300- 844,528- 1,157,800 - Report Criteria: Print Fund Titles Page and Total by Fund Print Source Titles Total by Source Print Department Titles Total by Department All Segments Tested for Total Breaks Account.Account Number ="314341110"-"314390904" Modification City of Chubbuck Budget Worksheet Page: 1 Period: 00/23 Mar28,2023 08:19AM Report Criteria: Print Fund Titles Page and Total by Fund Print Source Titles Total by Source Print Department Titles Total by Department All Segments Tested for Total Breaks Amount Account Number = '324351110"-"324390904" Account Number Account Title SW WASTEWATER SW PERSONNEL EXPENSE 32-4351-110 SW Salaries 32-4351-111 SW Overtime 32-4351-210 SW FICA 324351-220 SW Retirement 32-4351-221 SW PERSI Pension Expense 32-4351-240 SW Workers'Compensatlon 32-4351-250 SW Health Insurance 32-4351-260 SW Unemployment 32-4351-759 SW Phone Stipend 32-4351-761 SW Clothing 32-4352-100 SW Engineering 32-4352-110 SW Planning & Development 324352-120 SW Fleet Maintenance 32-4352-130 SW IT 32-4352-140 SW Utility Billing 32-4352-150 SW Finance 32-4352-160 SW Human Resource 324352-170 SW Administration 324353-100 SW Billing Expense 324353-110 SW Certifications/Licensing 32-4353-120 SW City Hall Lease 32-4353-130 SW City Hall Operations 32-4353-140 SW Computer/IT Hardware 32-4353-150 SW ComputedlT Software 32-4353-160 SW Employee Continuing Educati 32-4353-170 SW Employee Phone Stipend 32-4353-180 SW Employee Recognition 32-4353-190 SW Equipment Insurance 32-4353-200 SW Liability Insurance 32-4353-210 SW Mapping/GIS System 324353-220 SW Memberships/Dues 324353-230 SW Office Equipment/Supplies 32-4353-240 SW Professional Services 32-4353-250 SW Shop Facility Lease 32-4353-260 SWTmining/Seminars 32-4353-270 SW Travel 32-4353-280 SW Utility Telephone 32-4353-290 SW Utlity, Electrical 32-4353-300 SW Utility Natural Gas 32-4353-310 SW Facility Maintenance/Janito 32-4353-320 SW Yard Faciltiy Construction 32-4353-330 SW Yard Facility Operations 2022-23 2022-23 2023-24 Modification Cur Year Cur Year Fut Year Budget. Actual Budget 584,200 256,804 628,000 6,200 9,182 6,200 45,500 20,537 48,000 74,100 32,877 77,000 .00 .00 .00 17,300 9,011 22,500 187,100 79,578 212,500 .00 .00 .00 .00 163 .00 .00 12 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 31,000 7,370 .00 15,000 874 .00 165,000 .00 .00 3,000 10,101 .OD 20,000 286 .00 17,000 33,835 .00 1,500 120 .00 .00 .00 00 1,500 389 .00 .00 .00 .00 .co .00 .00 3,500 414 .00 1,000 443 .00 2,500 856 .00 125,000 2,439 .00 .00 .00 .00 1,500 1,066 .00 500 39 .00 6,500 3,080 .0c 4,500 3,035 .00 9,500 10,329 .00 15,000 772 .00 7,000 6,573 .00 10,000 .00 .00 City of Chubbuck Budget Worksheet Page: 2 Period: 00123 Mar28,2023 08:19AM Account Number Account Title Total SW PERSONNEL EXPENSE SW COLLECTION SYSTEM 324360-100 SW Collection Sys Maint Lines 32-4360-110 SW Collection Sys Malnt Lift S 32-4360-120 SW Collection Sys Improvement 32-4360-130 SW Digline Locates 32-0360-140 SW Capital Planning 32-4361-100 SW QC Sampling✓Testiog 32A361-110 SW Treatment Pocatello 32-4361-120 SW Inspections 32-4361-130 SW Applications/Approvals 32-0362-100 SW Electrical Motor M & O 32-4362-110 SW Pumping Equipment M & O 32-4362-120 SW Electrical Power 32-4362-130 SW SCADA 324362-140 SW Building & Grounds M & 0 32-4362-150 SW Capital Planning 1 GI F.169NLK�] � 114H 1 U7 � 69'69 Y q rri SW ADDITIONAL SERVICES 32-4370-100 SW Contractor Assistance 32-4370-110 SW Interagency Services Total SW ADDITIONAL SERVICES: SW EQUIPMENT EXPENSE 32-4380-100 SW Pickup Repair & Maintenance 32-4380-110 SW Large Truck Repair & Mainte 32-4380-120 SW Heavy Equipment Repair & Me 32-4380-130 SW Truck & Equipment Capital P 32A380-140 SW Fuel & Lubricants 3241380-150 SW Small Tools & Equipment 32-4381-100 SW Training 32-4381-110 SW Clothing 32-4381-120 SW Equipment 32A381-130 SW Testing Total SW EQUIPMENT EXPENSE SW FINANCE 2022-23 32-4390-100 SW Transfer from Depreciation 32-4390-500 SW City Hall Construction 32-4390-501 SW COP 32A390-502 SW COP Amortization 32-4390-820 SW Lease. Financing Expense 32-4390-821 SW Lease Amortization Expense 32-4390-822 SW Lease Intereset Expense 32.4390-900 SW Bad Debt Expense 32-4390-902 SW Depreciation 32-4390-903 SW Loss on Asset Disposal 32-4390-904 SW Miscellaneous Expense 2022-23 2022-23 2023-24 Cur Year Cur Year Fut Year Budget Actual Budget 1,354,900 490,186 994,200 500 .00 .00 500 177 .DO 3,500 .00 .00 2,000 491 .00 281,000 .00 .00 500 .00 .00 1,600,000 555,842 .00 300 .00 .00 .00 .00 .00 25,000 2,746 .00 30,000 5,473 .00 20,000 11,153 .00 10,000 1,345 .00 5,000 3,296 .00 273,000 .00 .00 2,251,300 580,523 .00 .00 .00 .00 15,000 .00 .00 15,000 .00 .00 500 .00 .00 500 24,761 .00 1,000 245 .00 25,000 .00 .00 15,000 5,711 .00 5,000 237 .00 500 2,294 .00 2,000 992 .00 2,000 4,533 .00 300 701 .00 51,800 39,474 .00 .00 .00 .00 .00 612 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .09 .00 .00 .00 .00 .00 .00 .00 .00 00 .00 00 Modification City of Chubbuck Account Number Account Title Total SW FINANCE: SW WASTEWATER Revenue Total: SW WASTEWATER Expenditure Total: Net Total SW WASTEWATER: Report Criteria: Print Fund Titles Page and Total by Fund Print Source Titles Total by Source Print Department Titles Total by Department All Segments Tested for Total Breaks Account.Account Number ='824351110'-"324390004" Budget Worksheet Period: 00/23 2022-23 2022-23 2023-24 Cur Year Cur Year Fut Year Budget Actual Budget .00 812 .00 .00 .00 .00 3,673,000 1,110,994 994,200 3,673,000- 1,110,994- 994,200 - Modification Page: 3 Mar 28, 2023 08:19AM City of Chubbuck Budget Worksheet Page: 1 Period: 00/23 Mar 28, 2023 08:21AM Report Criteria: Print Fund Titles Page and Total by Fund Print Source Titles Total by Source Print Department Titles Total by Department All Segments Tested for Total Breaks Account.Accounl Number = "334331110"-"334390904" 2022-23 2022-23 2023-24 Modification Cur Year Cur Year Fut Year Account Number Account Title Budget Actual Budget SN SANITATION SN OPERATIONS 33-4331-110 SN Salaries 573,900 280,445 718,000 33-4331-111 SN Overtime 22,000 14,720 22,000 33-4331-210 SN FICA 46,500 23,001 56,000 33-4331-220 SN Retirement 74,700 36,660 89,000 33-4331-221 SN PERSI Pension Expense .00 .00 .00 3341331-240 SN Workers' Compensation 20,900 11,418 28,000 33-4331-250 SN Health Insurance 217,100 95,787 246,000 33-4331-260 SN Unemployment .00 .00 .00 33-4331-759 SN Phone Stipend .00 138 .00 33-4331-761 SN Clothing .00 2D .00 33-4332-100 SN Engineering .00 .00 .00 33-4332-110 SN Planning & Development .00 .00 .00 33-4332-120 SN Fleet Maintenance .00 .00 .00 33-4332-130 SN IT .00 .00 .00 334332-140 SN Utility Billing .00 .00 .00 3341332-150 SN Finance .00 .00 .00 33-0332-160 SN Human Resource .00 .00 .00 33-4332-170 SN Administration .00 .00 .00 33-4333-100 SN Billing Expense 31,000 7,370 .00 33-4333-110 SN Certifications/Licensing 1,000 310 AO 33-4333-120 SN City Hall Lease 139,000 .00 .00 33-4333-130 SN City Hall Operations 26,000 8,533 .00 334333-140 SN Computer/IT Hardware 16,000 302 .00 33-4333-150 SN Computer/IT Software 10,000 23,899 .00 33-4333-160 SN Employee Continuing Educati 3,000 .00 .00 33-4333-170 SN Employee Phone Stipend .00 .00 .00 33-4333-180 SN Employee Recognition 2,000 387 .00 33-0333-190 SN Equipment Insurance .00 .00 .00 33-4333-200 SN Liability Insurance .00 .00 .00 33-4333-210 SN MappinglGIS Systems 3,500 414 .00 33-4333-220 SN Memberships/Dues 1,000 411 .00 33-4333-230 SN Office Equipment/Supplies 2,500 4,310 .00 33-4333-240 SN Professional Services .00 245 .00 33-4333-250 SN Shop Facility Lease 112,000 18,643 .00 33-4333-260 SN Training/Seminars 500 167 .00 33-4333-270 SN Travel .00 39 .00 33-4333-280 SN Utility Telephone 7,000 3,086 .00 33-4333-290 SN Utility Electrical 4,000 2,480 .00 33A333-300 SN Utility Natural Gas 3,000 1,852 .00 33-4333-310 SN Facility MalmonanceManit 15,000 740 .00 33-4333-320 SN Yard Facility Construction 350,000 3,944 .00 33-4333-330 SN Yard Facility Operations 10,000 .00 .00 City of Chubbuck Budget Worksheet Page: 2 Period: 00123 Mar 28, 2023 08:21AM 2022-23 2022-23 2023-24 Cur Year Cur Year Fut Year Account Number Account Title Budget Actual Budget Total SN OPERATIONS: 1,691,600 539,298 1,159,000 SN RESIDENTIAL SERVICE 33-4340-100 SN Residential Landfill 195,000 73;366 .00 33-4340-110 SN Residential Carts 35,000 .00 .00 33-4340-120 SN Residential Cart Maintenanc .00 8,680 .00 33-4341-100 SN Commercial Landfill 110,000 46,028 .00 33-4341-110 SN Commerical Containers 8,000 58,560 .00 33-4341-120 SN Commercial Container Malnte 5,000 443 .00 33-4342-100 SN Rolloff Landfill 65,000 25,893 .00 33-4342-110 SN Rolloff Containers 10,000 14,887 .00 334342-120 SN Rolloff Container Maintenan 1,000 .00 .00 33-4343-100 SN Recycle Waste 31,000 20,379 .00 33-4343-110 SN Recycle Carts .00 00 .00 33-4343-120 SN Recycle Cart Maintenance 1,000 .00 .00 Total SN RESIDENTIAL SERVICE: 461,000 248,235 .00 SN ADDITIONAL SERVICE 33-4360-100 SN Freebie 15YD .00 .00 .00 33-4360-110 SN Freebie 3YD .00 .00 .00 33-4360-120 SN Branch Chipping .00 .00 .00 33-4360-130 SN Leaf Pickup .00 .00 .00 33-4360-140 SN Christmas Tree Pickup .00 .00 .00 33-4360-150 SN Extra Christmas Containers .00 .DO .00 33-4360-160 SN Spring Clean Up .00 .00 .00 33-4360-170 SN Chubbuck Days .00 .00 .00 33-4360-180 SN Interagency Services .00 .00 .00 Total SN ADDITIONAL SERVICE: .00 .00 .00 SN EQUIPMENT EXPENSE 33-4370-100 SN Fuel & Lubricants 80,000 55,925 .00 33-4370-110 SN Small Tool/Equipment 8,000 359 .00 33-4370-120 SN Vehicle M & O 125,000 12,881 .00 334370-130 SN Capital Planning 67,000 395 .00 33A370-140 SN New Collection Vehicle .00 .00 .00 33-4370-150 SN Small Vehicle Replacement 5,000 .00 .00 33-4371-100 SN Training 1,000 1,892 .00 33-4371-110 SN Clothing 4,000 993 .00 33-4371-120 SN Equipment .00 304 .00 33-4371-130 SN Testing - 300 184 .00 33-4371-140 SN Damage Claims .00 .00 .00 Total SN EQUIPMENT EXPENSE: 290,300 72,934 .00 SN FINANCE 33-4390-100 SN Transfer from Depreciation .00 .00 .00 33-4390-300 SN Interest .00 .00 .00 33-4390-500 SN COP Amortization .00 .00 .00 33-4390-501 SN COP .00 .00 .00 33-4390-502 SN City Hall Construction .00 686 .00 33-4390-820 SN Lease Financing Expense .00 .00 .00 334390-821 SN Lease Amortization Expense- .00 .00 .OD 334390-822 SN Lease Interest Expense .00 .00 .00 Modification City of Chubbuck Budget Worksheet Page: 3 Period: 00123 Mar 28, 2023 08:21AM Account Number Acoounl Title 33.4390-900 SN Bad Debt 33-4390-901 SN Transfers Out 33-4390-902 SN Depreciation 33-4390-903 SN Loss on Asset Disposal 33-4390-904 SN Miscellaneous Expense Total SN FINANCE: SN SANITATION Revenue Total: SN SANITATION Expenditure Total: Net Total SN SANITATION: Report Criteria: Print Fund Titles Page and Total by Fund _ Print Source Titles Total by Source Print Department Titles Total by Department All Segments Tested for Total Breaks Account, Account Number = "334331110"-"334390904" 2022-23 2022-23 2023-24 Cur Year Cur Year Fut Year Budget Actual Budget 00 .00 .00 :00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 686 .00 .00 .00 .00 2,442,900 851,153 1,159,000 2,442,900- 881,153- 1,159,000 - Modification Planned Salaries for FY24 -Prepared 03/27/2023 City of Chubbuck FY23 Salary Schedule Market Range Effective 10/1/2023 Point Maximum Range High Range Minimum Above Market +114/ *Comps -Ra io; 85�c 89Yc 95°A 100% 107% 115% 120% relation io mkt point) Market Range 107/. thru 114% Proficiency Range Salary 95% thru106Y Hiring Range Grade 89/ thru94/ Less than 89% 20 $51.03 $64.10 $68.34 $68.35 $72.02 576.49 $77.00 $82.75 1192.76 $86.42 19 $54.49 $57.23 $51.02 $61.03 $64.30 $68.74 $68.75 $73.88 1,7189 $77.16 18 $48.55 $51.10 $54.48 $54.44 $57.41 $51.37 $61.38 $65.47 1165.98 $68.89 17 $43.44 $45.62 $4.8.55 $48.66 $51.26 $54.80 $54.81 $58.40 1153.91 $61.51 15 $38.79 $40.73 $43.43 $43.44 $45.77 $48.43 $48.44 $52.54 52.60 $54.92 15 $34.63 $35.37 $38.73 $38.74 $40.86 $43.68 $43.69 $46.45 6.36 $49.04 14 $31.48 $33.06 $35.25 $35.26 $37.15 534.71 $39.72 $42.68 2.63 $44.55 13 $28.62 $30.06 $32.45 $32.06 $33.77 $36.10 $35.11 $38.80 1133.81 $40.53 12 $25.02 $27.32 $29.14 $24.15 $30.70 532.82 $32.83 535.28 1135.29 $36.54 11 $23.65 $24.84 $26.49 $26.50 $27.91 $24.84 $29.85 $32.07 32.08 $33.43 10 $21.50 $22.58 $24.08 $24.04 $25.37 527.12 $27.13 $24.15 1129.26 $30.45 9 $19.55 $20.53 $21.89 $21.30 $23.07 $24.65 $24.67 $26.50 1126.51 $27.68 8 $17.77 $18.66 $19.90 $14.41 $20.47 522.42 $22.43 $24.04 1124.20 $25.16 7 $15.61 $17.44 $18.60 $18.61 $19.60 $20.95 $20.96 822.52 22.53 $23.52 6 $15.52 $15.30 $17.38 $17.34 $18.32 $14.58 $19.59 Pr S2_.C4 1121.05 $21.35 5 $14.51 $15.23 $15.24 $16.25 $17.12 $18.30 $18.31 $19.67 1119.68 $20.54 4 $13.56 $14.24 $15.18 $15.14 $16.00 517.10 $17.11 1118.39 $19.20 3 $12.67 $13.31 $14.19 $14.20 $14.95 $15.38 $15.99 $17.18 1117.29 $17.94 2 $11.84 $12.44 $13.26 $13.27 $13.47 514.94 $14.95 $16.06 1116.07 $16.77 1 $11.07 $11.52 $12.39 $12.40 $13.06 $13.95 $13.97 r $15.00 $15.01 $15.67 *Comps -Ra io; 85�c 89Yc 95°A 100% 107% 115% 120% relation io mkt point) Planned Salaries for FY24 -Prepared 03/27/2023 FY24 Salary Distribution: Hiring Range Proficiency Range M a rket Range below 8-9 6 89 thru 94 5% 9.5 th ru 106 4% Above Market 107 thru 114 3 High R:3nge Personnel Policy 3,3,2 Annual pair increases are determined using a market-based system. Employees whose salaries are below the market point for their position wiII receive a higher percentage increase than employees whose .salaries are above the market point. The specific amount of each increase will be recommended by Human Resources based on the employee's salary in proximity to the market point. Another factor is the amount of the budget dedicated to salaries as determined by the department head in consultation with Human Resources and the Mayor. FY24 Budget is Compiled from Individual Salary Projections (and related allocations): B c o H FY23 Salary Job Base Mage Grade Level Patrol Sergeant X35.22 J Patrol Officer -First Class X29.39 13 Communications Officer- First Class 22.55 10 Communications Officer First Class $22.79 10 Communications Officer First Class X22.79 10 Maintenance Mechanic 1 525.71 10 Roadway Maintenance Worker 1 523.18 8 E F G H Adjusted 6.5% for 2022 inflation 531.15 6.096 Min Mkt Max Comparatio 34.63 40.86 49.04 86.2% 28.62 33.77 40.53 87.0% 21.50 25.37 30.45 88.9% 21.50 25.37 30.45 89.8% 21.50 25.37 30.45 89.8% ` 21.50 25.37 30.45 101.395 17.77 20.97 25.16 110.5`5 I FY24 J FY24 Percent Base Wage Base Increase 537.33 6.0% 531.15 6.096 $23.90 6.096 $23.93 5.096 523.93 5.0% 526.74 4.0% X23.88 3.0% Planned Salaries for FY24 —Prepared 03/27/2023 FY24 Base Salaries Budget- By Fund 3/27/2023 Exec 10-4131 10-4160 CS 10-4400 P a rks 10-4470 H S R 11-4311 Water 31-4341 WW 32-4351 Sari 33-4331 Police Fire Council 10-4111 Tota �45rOOO 13FOOD 529 9' OOD 535 6' OOD 5 8' GOO 5712'OOD 6 28 F. 000 5718 F. 000 2F. 3 66p 000 $1r 161F 000 $6r 99 2F 000 Planned Salaries for FY24 —Prepared 03/27/2023 Salaries Comparision to Market 3/22/2023 70 City Wide FY23 FY24 89% 15 23 89% to <95% 44 54 95% to < 107% 60 43 107% to < 115% 2 2 115%+ 2 0 123 122 60 50 40 30 20 10 0 11 11 11 C 89% 89% to C95% 95% to C 107% ■ FY23 ■ FY24 107% to 115% 115%+ Planned Salaries for FY24 —Prepared 03/27/2023 20 Police FY23 FY24 89% 1❑ 16 89% to <95% 16 12 95% to < 1❑7% 11 9 1❑7% to < 115% ❑ ❑ 115%+ 0 ❑ 37 37 Fi re FY23 FY24 89% ❑ ❑ 89% to <95% 19 25 95% to < 1❑7% 16 9 1❑7% to C 115% ❑ ❑ 115%+ ❑ ❑ 35 34 15 10 5 0 30 25 20 15 10 5 0 111111 89% 89% to <95% 95% to r 107% ■ FY23 ■ FY24 11 11 89% 89% to <95% 95% to r 107% ■ FY23 ■ FY24 107% to C 115% 107% to r 115% 115%+ 115%+ Planned Salaries for FY24 —Prepared 03/27/2023 Public Works FY23 FY24 89% 3 4 89% to <95% 5 8 95% to r• 107% 16 13 107% to < 115% 1 1 115%+ 1 0 26 26 Community Services FY23 FY24 89% 2 3 89% to <95% 3 4 95% to < 107% 6 4 107% to < 115% 0 0 115%+ 0 0 11 11 20 15 10 5 0 7 6 5 4 3 2 1 0 ON 11 11 r 89% 89% to <95% 95% to 107% ■ FY23 ■ FY24 11 11 11 C 89% 89% to C95% 95% to r 107% ■ FY23 ■ FY24 mm m 107% to < 115%+ 115% 107% to r 115%+ 115% Planned Salaries for FY24 —Prepared 03/27/2023 Treasury FY23 FY24 89% 0 0 89% to <95% 1 2 95% to < 107% 6 5 107% to < 115% 0 0 115%+ 0 0 7 7 Admin.Clerk.Facilities FY23 FY24 89% 0 0 89% to <95% 0 3 95% to < 107% 5 3 107% to < 115% 1 1 115%+ 1 0 7 7 7 G 5 4 3 2 1 0 I 4 3 2 1 0 01 11 C 89% 89% to <95% 95% to C 107% ■ FY23 ■ FY24 89% 89% to ¢95% 95% to r 107% ■ FY23 ■ FY24 107% to C 115%+ 115% on 1 107% to ¢ 115%+ 115% March Trend Cases by Type Crealed Lasl 90 Days Reeved ci,unt 2I1 11 Resrrmsa Rutea'. Compare wrtn Tel M. - Yl Rem (SR - Cases h' Type) February Trend: Cases by Type Created Lasl W Days Record Count 251 1w EulJness Rules Compare wNh Technology Model Vlew Report (SR -Cases by Type) IT Service Reviews •� Trend. OPENED Last 36 Days Type 57 Imaswcli ■ Apprnarinn ■ Business Rules Follm ti—C Usm Upenenee ■ Nwv Repos iSR•[reed Opened Las1306a}s:• •• Trerd: OPENED Last 30 pays PE 77 =- TY Intasrrull ■ Appliadon■ Business Rules Follow need 0— Experbace ■ View Rapod (SR - Trend Opened L-30 Oa Trend OPENED Las[ 31 to 60 Days X 85 Busaress Rules: Fueow tread V— Reporl (SR - TmM. Opened Wal 31 to 60 Da'. Trend: OPENEO Last 31 to .-. 89 Business Rules Follow bend Vlaw Repod(SR - Trend Opened Last 31 to Trend OPENED Las[ 61 to 90 D.. •� 86 .. ?ess Rales: Follu:r lrentl .:S'. Report lS R - T rendOpened Last 6110 5C Da Trend: 0PENE0 Last 61 to ..- 95 Business Rules Full trend V— Repod (SR - Trend Opened Last 61 ro Trend Cases by Priority Created Last 91) Days R—I Ceun1. 319 --�ineSs Ayre' Preaedee rs nw—o Repoli (SR - =m 0) pnorrtrl Trend: Cases 4y Priority created Lasl 90 Days Record Cwrd 248 1w E -I— Ruta P—Mil a n Roacllva View Rapex iSR - Cases by Niel Pr—ty 5-Medum ■ I - High ■ 1 - VYaklmg ■ 9-1lryen[ ■ 3-L4w ■ pripriry, 5-Me6un ■ 7 -Fill ■ 3 -Lew ■ 1- Warding ■ 9-urgrml ■ City of Chubbuck General Fund Fiscal Year 2024 Budget FY23./FY24 Fiscal Year 2023 Fiscal Year 2024 Difference 104211-110 LE SALARIES 2,285,000 2,366,000 81,000 0.04 6% Fund Compensation Plan 104211.111 LE OVERTIME 12,785 107,000 94,215 7.37 Adjustment to move OT from Salaries 104211.210 LE FICA 180,000 185,000 5,000 0.03 7.45% 104211-220 LE RETIREMENT 296,000 322,000 27,000 0.09 14% including a 1% raise In rates 10-4211-240 LE WORKMAN'S COMPENSATION 65,000 92,000 27,000 0.42 State Workman Comp Rates 10-4211-250 LE MEDICAL INSURANCE 580,000 655,400 75,400 0.13 13% premium Increase Law Enforcement Wages and Related 3,417,785 3,727,400 309,615 0.09 10-4215-310 LE OFFICE SUPPLIES 3,500 3,500 0 0.00 10-4215-311 LE FORMS, CITATION 1,500 1,500 0 0.00 10-4215-315 LE PAPER COPY ETC 2,000 2,000 0 0.00 104215.318 LE MISC DUES, FEES, SUBSCRIPT 8,000 6,000 0 0.00 104215.317 LE EMPLOYMENT COST 2,500 2,500 0 0.00 104215331 LE FIREARMS 10,000 10,000 0 0.00 104215-333 LE PATROL NEW PURCHASE 8,450 9,000 550 0.07 Increase expense of equipment 104215-334 LE PARTOL EQUIP REPAIR 4,300 4,300 0 0.00 10.4216-335 LE DETECTIVE 2,750 2,750 0 0.00 10-4215336 LE EVIDENCE SUPPLIES 4,500 4,500 0 0.00 103215.340 LE OFFICE EQUIP REPAIR 2,500 2,500 0 0.00 104215-341 HE COMPUTER PURCHASE 50,000 50,000 0 0,00 104215-343 LE COMPUTER CONSULTING 5,000 5,000 0 0,00 104215-345 LE COMPUTER CONTRACTS 43,000 45,000 2,000 005 Increased IT Expense 10-4215-370 LE MEETINGS, SCHOOL 5,000 7,500 2,500 0,50 Increase expenses training 10-4215-371 LE TRAINING LODGING 13,000 13,000 0 0,00 10-4215-372 LE TRAINING PER DIEM 11,000 11,000 0 000 10.4215373 LE TRAINING TRAVEL 13,000 13,000 0 0.00 10-4215420 LELEGAL 82,000 82,000 0 0.00 10-4215-602 LE MISC, ETC. 4,500 4,500 0 0.00 10-4215-650 LE ANIMAL CONT. SHELTER 3,000 10,000 7,000 2.33 New Building 104215.652 LEANIMALCONT. BUILDING 0 30,000 30,000 New Building 104215.761 LE CLOTHING ALLOWANCE 12,000 12,000 0 0.00 104215-762 HE CLOTHING ALLOWANCE NOWSWOR 2,000 2,000 0 0.00. 104222510 HE TELEPHONE REPAIR 35,000 35,000 0 0.00 104222-630 LE RADIO/REPAIR 1,200 1,200 0 0.00 10.4222,633 LE BATTERIES 500 500 0 0.00 104222-634 LE DISPATCH 1,500 1,500 0 0.00 104222-635 LETELETYPE 8,000 17,175 9,175 1.15 104223-208 HE DARE 6,500 6,500 0 0.00 104229-350 LE FUEL 8 LUBRICANTS 68,000 58,000 0 0.00 104229-520 LE ELECTRICl MAINT 7,500 10,000 2,500 0.33 Remodel 10.4229-522 LE NATURAL GAS 2,000 4,000 2,000 1.00 Remodel 10-4229-600 LE BUILDING MAINT/FURNACE 10,000 10,000 0 0.00 10-4229810 LE VEHICLE REPAIR 18,500 18,500 0 0.00 10-4229800 LE CAP FILING CAMERA 16,515 40,000 23,485 1.42 Updated technology for Body Cameras 10-4229-821 LE CAPITAL FACILITIES LEASE 375,000 375,000 0 0.00 10-4229,850 LE CAR LEASE4'URCHASE 80,000 80,000 0 0.00 Law Enforcement Total 4,329,500 4,718,325 388,825 0.09 Period Comparison ]. 54K 7.42K 6.4K 4.8K 3.2K 1.6K t 513 541 451 469 -9-m" ms a FE ilgenryAssis4 PII Na[u res Qiiltl Pm[eRion U's Crash P1: 05 -Apr -2021 -04 -Apr -2022 flr P2 05 -AP -2022-O Apr 2D23 zoo no 5� 350 100 All Natures WELFARE PALMAE AGENCY CML SUSPICIOUS ACCIDENT EHSURBONCE THEFT PARKMG ORDINANCE JUVENILE HARASSMENT VIN I RM CHECK PROBLEM A IST PROBLEM NOL PROB INSPECTION P1: 05 - Apr -2021-M-Apr -2022 ii, P2 05 -Apr -2022 -M -Apr -2023 Ifni I �FIT 229 212� 193 207 206 � 173 164 �206. M WELFARE PALMAE AGENCY CML SUSPICIOUS ACCIDENT EHSURBONCE THEFT PARKMG ORDINANCE JUVENILE HARASSMENT VIN I RM CHECK PROBLEM A IST PROBLEM NOL PROB INSPECTION P1: 05 - Apr -2021-M-Apr -2022 ii, P2 05 -Apr -2022 -M -Apr -2023 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