Loading...
HomeMy WebLinkAboutHearing #1 Department Budget Presentations—WIL � b 4 Legislative50-203 FA M I L x SERVICES PRT ALLIANCE Pocatello Regional Transit ""l-rhv `° We're With You! City of Chubbuck Legislative FY2024 Budget FY2023 FY2024 $$$ Change %Change 10-4111-110 LG SALARIES 33,000 36,000 3,000 0.09 THINK LEARN BE 10-4111-210 LG FICA 2,500 2,700 200 0.08 SouthEastern Idaho 10-4111-220 LG RETIREMENT 4,000 4,400 400 0.10 CommurrityActronRgency i 10-4111-240 LG WORKMANS COMPENSATIC 250 300 50 0.20 pSCHOO DIST ICT 25 10-4111-250 LG HEALTH INSURANCE 67,000 76,000 9,000 0.13 10-4112-370 LG TRAVEL, MEETING & OTHEF 5,200 5,200 0 0.00 10-4112-480 LG AIC DUES 6,500 6,500 0 0.00 10-4112-693 LG LAND USE COMPENSATION 700 700 0 0.00 10-4113-100 LG TRANSIT BUS 43,000 43,000 0 0.00 10-4113-110 LG SEICCA (MEALS ON WHEEL 7,000 7,000 0 0.00 4%r=;k. hO.. 10-4113-120 LG SENIOR CITIZEN 7,500 7,500 0 0.00 s�e.juc��ru* 10-4113-130 LG SEICOG 2,500 3,000 500 0.20 10-4113-140 LG POCATELLO FREE CLINIC 7,000 7,000 0 0.00 10-4113-150 LG VISIT POCATELLO 0 10,000 10,000 1.00 10-4113-160 LG FAMILY SERVICES ALLIANC 5,000 6,000 1,000 0.20 10-4113-170 LG CROSSING GUARDS 4,000 4,000 0 0.00 POCATILLO Legislative Total 195,150 219,300 24,150 0.12 CHUUBU::•. g Pocatello Free Clinic 7 Oue- caw.a+w-++.+,t�f, Our htnjh,. The Legislative budget represents approximately 2.2% of the General Fund budget. The legislative budget represents approximately 1.0% of the City's entire budget. Executive Executive 50-203 City of Chubbuck Executive FY2024 Budget 10-4131-110 EX SALARY 10-4131-210 EX FICA 10-4131-220 EX RETIREMENT 10-4131-250 EX HEALTH INSURANCE 10-4131-310 EX OFFICE SUPPLIES 10-4132-370 EX TRAVEL, MEETINGS & OTHER 10-4133-280 EX PHONE Executive Total FY2023 40,000 33000 5,000 155600 500 2,000 500 FY2024 45,000 3,400 5,500 171700 500 2,000 500 $$$ Change 5,000 400 500 2,100 0 0 0 %Change 0.13 0.13 0.10 0.13 0.00 0.00 0.00 661600 741600 8, 000 0.12 The Executive budget represents approximately .7% of the General Fund budget. The Executive budget represents approximately .3% of the City's entire budget. Clerk 50-204 Joey Bowers The Mission of the Clerk's Office is to build trust and confidence by promoting transparency, engaging the community, support elected officials, inform the public by providing accessibility to public records. City of Chubbuck Clerk FY2024 Budget 10-4142-280 CK PHONE 10-4142-310 CK OFFICE SUPPLIES 10-4152-370 CK COMPUTERS 10-4142-370 CK TRAVEL FY2023 FY2024 $$$ Change %Change 500 500 0 0.00 2,700 2,700 0 0.00 2,000 2,000 0 0.00 4,000 4,000 0 0.00 9,200 9,200 0 0.00 The Clerk budget represents approximately .9% of the General Fund budget. The Clerk budget represents approximately .4% of the City's entire budget. Treasurer So -zoo Rich Morgan The City's accounting department strives to provide factually correct financial information to decision makers based on Generally Accepted Accounting Principles (GAAP) with assurances to the citizen that financial resources are used and reported legally and lawfully. City of Chubbuck Treasurer FY2024 Budget FY2023 FY2024 $$$ Change %Change 10-4151-250 FN HEALTH INSURANCE 11,000 12,500 1,500 0.14 10-4151-340 FN OFFICE EQUIPMENT & MAID 3,000 3,000 0 0.00 10-4152-280 FN PHONE 1,000 500 (500) (0.50) 10-4152-310 FN OFFICE SUPPLIES & ADM 22,500 6,000 (16,500) (0.73) 10-4152-345 FN COMPUTERS 14,945 30,000 15,055 1.01 10-4152-370 FN TRAVEL TRAINING PUBLICA 3,500 5,000 1,500 0.43 10-4152-480 FN DUES 1,100 500 (600) (0.55) 10-4152-490 FN AUDIT 30,000 30,000 0 0.00 Treasurer Total 87,045 87,500 455 0.01 The Treasurer budget represents approximately .9% of the General Fund budget. The Treasurer budget represents approximately .4% of the City's entire budget. City of Chubbuck Legal 10-4160-110 10-4160-210 10-4160-220 10-4160-240 10-4160-250 10-4160-420 10-4160-440 10-4160-680 10-4160-681 Lega l 50-204 Ryan Lewis FY2024 Budget LL SALARIES LL FICA LL RETIREMENT LL HEALTH INSURANCE LL OFFICE SUPPLIES & ADMIN LL SERVICE LL PUB., RECORDNG, ETC. LL CODIFICATION LL SAUSA Legal Total FY2023 FY2024 $$$ Change %Change 58,000 13,000 (45, 000) (0.78) 4,500 1,000 (3,500) (0.78) 7,000 2,000 (5,000) (0.71) 17,000 19,500 2,500 0.15 9,200 9,200 0 0.00 25,000 25,000 0 0.00 6,500 6,500 0 0.00 7,000 7,000 0 0.00 1,500 1,500 0 0.00 135,700 84,700 (51,000) (0.38) The Legal budget represents approximately .8% of the General Fund budget. The legal budget represents approximately .3% of the City's entire budget. Liability Insurance Joey Bowers City of Chubbuck Liability Insurance FY2024 Budget ICRMP Member Owned, Member Driven FY2023 FY2024 $$$ Change %Change 10-4193-460 GV GENERAL INSURANCE 185,000 185,000 The Liability Insurance budget represents approximately 1.8% of the General Fund. The Liability Insurance budget represents approximately .8% of the City's entire budget. C AM Information Technology (51 Joey Bowers SOLINFORMATIOEUS Partner Since 2015 City of Chubbuck Information Techology FY2024 Budget FY2023 FY2024 $$$ Change %Change 10-4250-339 IT OFFICE EQUIP 1)500 17000 (500) (0.33) 10-4250-341 IT COMPUTER PURCHASE 25, 000 25, 000 0 0.00 10-4250-342 IT COMPUTER REPAIR 20,000 5,000 (15,000) (0.75) 10-4250-345 IT COMPUTER CONTRACTS 8,000 25,000 17,000 2.13 10-4250-346 IT COMPUTER CONTRACT - SO 25,000 35,000 10,000 0.40 10-4250-348 IT SOFTWARE 32,500 25,000 (7,500) (0.23) 10-4250-370 IT TRAINING 6,000 27000 (4,000) (0.67) Information Technology Total 118,000 118,000 0 0.00 The Information Technology budget represents approximately 1.3% of the General Fund budget. The Information Technology budget represents approximately .6% of the City's entire budget. Human Resources Scott Gummersall The City of Chubbuck's Human Resources Department seeks to ensure that great employees work for a great employer; an employer that succeeds in delivering quality services with maximum efficiency. City of Chubbuck Human Resource 10-4260-315 10-4260-315 10-4260-345 10-4260-347 10-4260-370 FY2024 Budget HR HEALTH INSURANCE HR DUES FEES SUBSCRIPTIONS HR COMPUTER PURCHASE HR COMPUTER SOFTWARE HR TRAINING Human Resource Total FY2023 FY2024 $$$ Change %Change 50,000 57,000 7,000 0.14 2, 500 2,500 0 0.00 2,500 2,000 (500) (0.20) 2,500 37000 500 0.20 1,700 1,000 (700) (0.41) 591200 657500 61300 0.11 The Information Technology budget represents approximately .6% of the General Fund budget. The Information Technology budget represents approximately .3% of the City's entire budget. Storm Water Bridger Morrison This budget is intended to cover the City of Chubbuck's expenses associated with the Pocatello Urbanized Area NPDES MS4 Stormwater permit as managed by DEQ. The permit applies to Pocatello, Chubbuck, Bannock County, ISU, and ITD. The requirements of the permit include training, education outreach, stormwater monitoring, and reporting. City of Chubbuck Storm Water FY2024 Budget FY2023 FY2024 $$$ Change %Change 10-4330-690 STORMWATER SERVICES 25,000 25,000 1 0.00 CHURRUCK Community Celebration Our CommUNITY: A great place to live, work, & raise a family City of Chubbuck Community Celebrati FY2024 Budget 10-4903-550 GA CHUBBUCK DAYS CELEBR 10-4903-551 GA MOVIES IN THE PARK 40-4903-552 GA CHRISTMAS IN THE PARK General Government Total FY2023 FY2024 $$$ Change %Change 57000 5, 000 0 0.00 0 1,000 1,000 0 1,000 1,000 5,000 7,000 2,000 0.40 Facility Maintenance City of Chubbuck Facility Maintenance FY2024 Budget 10-5001-310 FM SUPPLIES & TOOLS 10-5001-330 FM PHONE 10-5001-340 FM COMPUTER 10-5001-350 FM TRAVEL, TRAINING, OTHER 10-5001-370 FM CLOTHING 10-5001-380 FM EMPLOYEE RECOGNITION 10-5002-290 FM UTILITY ELECTRICAL 10-5002-310 FM FACILITY MAINENANCEfJAP 10-5002-320 FM GROUNDS 10-5002-330 FM HVAC 10-5003-100 FM SAFETY TRAINING 10-5003-110 FM SAFETY CLOTHING 10-5003-120 FM SAFETY EQUIPMENT 10-5004-110 FM CAPITAL FACILITIES LEASE FY2023 FY2024 $$$ Change %Change 0 800 800 1.00 0 1,200 1,200 1.00 0 1,000 1,000 1.00 0 1,000 1,000 1.00 0 500 500 1.00 0 500 500 1.00 0 1,000 1,000 1.00 0 2,000 2,000 1.00 0 8,000 8,000 1.00 0 11,000 11,000 1.00 0 500 500 1.00 0 500 500 1.00 0 1,000 1,000 1.00 78,000 78,000 0 0.00 78,000 107,000 29,000 1.00 General Fund General Fund ■ Legislative ■ Executive ■ Clerk Treasurer ■ Legal ■ Liabilty Insurance ■ Information Technology ■ Human Resource ■ Storm Water ■ Community Celebration ■ Facilities Maintenance ■ LE FC'. CS CS/PK General Fund 1F L 0 2,000,000 4,000,000 ■ LE FC CS CS/PK ■ Community Celebration ■ Human Resource ■ Liabilty Insurance 5,000,000 8,000,000 10,000,000 ■ Facilities Maintenance ■ Storm Water ■ Information Technology ■ Legal SK 4.6K 3.2EC 1.6K 513 541 0_ Agency Assists 7,54K 7.42K All Natures Period Comparison 105 125 Child Protection Li's P1. 05-A.pr-2421 - 04 -Apr -2022 451 469 Crash P2. 05 -Apr -2022 - 04 -Apr -2023 900 805 f 845 720 10 502 519 513 541 540 -- 364 1�tJ {I 472 -481 475 448---'451 469 iuu All Natures 444 WELFARE ANIMAL AGENCY CIVIL SUSPICIOUS ACCIDENT DISTURBANCE THEFT PARKING ORDINANCE JUVENILE HARASSMENT VIN ALARM CHECK PROBLEM ASSIST PROBLEM VIOL PROS INSPECTION P1: 05 -Apr -2021 - € -Apr-2022 P2: 05 -Apr -2022 - 04 -Apr -2020 MISSION STATMENT We are dedicated to preserving Life, Property, and the Environment. It is our goal to be trained to the highest level of current technology and provide service to our commUNITY. We are committed to the principles of RESPECT, ACCOUNTABILITY, BROTHERHOOD, and SERVICE. We appreciate and recognize the value of each member. We stand united CURRENT BUDGET CHUBBUCK FIRE DEPT BUDGET 10/22 - 9/23 MONTHLY EXPENDITURES Columnl Column2 Column3 Column4 1,Column5 OCTOBER NOVEMBER Column6 DECEMBER Column7 JANUARY Column8 Column9 FEBRUARY MARCH Columnl0 Columnll Column12 Column13 Column14 Column15 lColumn16 APRIL MAY JUNE JULY AUGUST SEPTEMBER Column17 Remaining Budge Colu 10-4231-110 REGULAR SALARIES 1,025,000.00 57,161.43 79,195.44 117,352.16 78,854.05 72,743.56 405,306.64 619,693.36 39.5 10-4231-111 OVERTIME SALARIES 101,000.00 2,884.85 8,341.50 12,289.73 6,577.62 8,660.32 38,754.02 62,245.98 38.4 10-4231-115 PAY -CALL SALARIES 81,000.00 3,097.06 3,448 5,751.44 6,151.53 4,455.69 22,903,27 58,096.73 28.3 104231-210 REGULAR FICA 79,000.00 6,451.05 6,580.30 9739.40 6,415.45 6,107.31 35,293.51ii 43,706.49 44.7 10-4231-215 PAY -CALL FICA 6,000.00 336.63 263.74 439.96 470.61 340.85 1,851.79 4,148.21 30.9 10-4231-220 RETIREMENT 136,726.00 10,610.16 10,736.78 15,900.87 10,478.24 9,983.64 57,709.69 79,016.31 42.2 10-4231-240 REGULAR WORKMANS COMP 30,000.00 0 2305,7 5,356.20 2,606.58 2,606.58 12,875.06 17,124.94 42.9 10-4231-245 PAY -CALL WORKMANS COMP 12,000.00 0 913.03 2,121,00 1,032.18 1,032.18 5,098.39 6,901.61 42.5 10-4231-250 REGULAR HEALTH INSURANCE 231,650.00 17,246,65 16,830.66 17,987.56 14,790.70 24,833.16 91,688.73 139,961.27 39.6 10-4231-255 PAY -CALL HEALTH INSURANCE 5,000.00 290.07 290.59 583.18 0 284.44 1,448.28 3,551.72 29 10-4231-260 REGULAR UNEMPLOYMENT 0 0 0 0 0 0 0 0 0 10-4231-265 PAY -CALL UNEMPLOYMENT 0 0 0 0 0 0 0 0 10-4231-310 OFFICE SUPPLIES 10-4231-345 COMPUTER SOFTWARE 5,492.00 69,500.00 599.71 149.25 761.86 1456.99 332.55 9,433.53 125,09 5,980.80 109.5 3,269.09 729.29 19,991.16 4,762.71 49,508.84 13.3 28.8 10-4231-347 ANNUAL DUES 4,000.00 0 0 0 0 290 290.00 3,710.00 7.3 10-4231-517 EMS VACCINES & TESTING 5,000.00 0 0 0 0 0 0 5,000.00 0 10-4231-519 PHYSICAL EXAMS 13,000.00 4,825.00 0 0 0 0 4,825.00 8,175.00 37.1 10-4231-520 IDAHO POWER 7,500.00 0 463,93 440.2 593.06 567.06 2,064.25 5,435.75 27.5 10-4231-522 INTERMOUNTAIN GAS 3,200.00 0 20.79 250.25 855.5 992.51 2,049.05 1,150.95 64 10-4231-600 BUILDING REPAIRS/MAINTENAC 18,500.00 89.48 1,245.00 0 230.86 18.1 1,583.44 16,916.56 8.6 10-4231-740 FITNESS/SAFETY 5,000.00 0 0 0 0 0 0 5,000.00 0 10-4231-900 EMS SUPPLIES TOTAL OPERATING EXPENSES 5,000.001 1,843,568.00 21.21 102,222.21 69.45 132,923.31 61.45 198,039.48 12.98 135,175.25 0 136,223.99 122.67 4,877.33 2.5 10-4235-510 TELEPHONE 7,500.00 415.32 665.03 665.04 664.07 664.12 3,073.58 4,426.42 41 10-4235-630 COMMUNICATIONS 3,000.00 0 0 0 0 0 0.00 3,000.00 0 COMMUNICATIONS EXPENSE 415.32 665.03 2,245.29 664.07 664.12 10-4236-370 TRAINING 14,262.00 0 0 0 5,127,28 1,175.40 6,302.68 7,959.32 44.2 10-4236-371 CONTINUING EDUCATION 738.00 0 0 0 264 19.48 244.52 982.52 33.1 OCTOBER NOVEMBER DECEMBER JANUARY FEBRUARY APRIL MAY JUNE JULY AUGUST SEPTEMBER Remaining _ Budget 10-4236-375 PREVENTION 5,000.00 107.49 107.49 992.94 276.48 496.38 1,695.80 3,304.20, 33.9 10-4236-379 ISUPPLIES 7,000.00 41.96 277.38 555.95 219 762.98 1,773.37 5,226.63 25.3 10-4236-379 FIRE MEALS/PR 3,000,00 0 0 0 0 0 0 3,000.00 0 10-4236-761 UNIFORMS 9,540.00 0 120 54.96 0 407 581.96 8,918.04 6.1 10-4236-763 DRUG TESTING (PRE -EM) 1,500.00 0 98 0 0 oi 98 1,402.00 6.5 TRAINING &'PREVENTION 149.53 602.87 1,533.85 5,358.76 2,861.24 30 792.71 71,824.710 10-4237-350 FUEL 22,000.00 0 1827.23 1,086.84 1,300.21 0 17,785.72. 19.2 10-4237-610 EQUIPMENT REPAIRS/MAINTAIN14,500.00 10-4237-611 VEHICLE REPAIRS/MAINTENCE 10-4237-661 SCBA 16,500.00 30,000.00. 123.9 1,279.16 D 123.9 0 0 1,824.10 452 0 0 0 0 0 3,564.07 0 5,295.23 0 12,675.90 12.6 11,204.77 32.1 30,000,00 0 71,666.39 VEHICLE & EQUIPMENT EXPENSE 83,000.00 1,155.26 1951.13 3,362.94 1,300.21 3,564.07 10-4238-369 AUX EQUIPMENT 25,545.00 0.00 11.46 0 728.77 74.14 818.37 24,726.63 3.2 10-4238-392 PROTECTION 25,000.00 0.00 5486.17 0 0 0 5,486.17 19,513.83 21.9 TOTAL PROTECTION/MISC AUX. TOTAL FIRE EXPENDITURES ****TOTAL FIRE BUDGET 10-4238-801 TOWER 12 LEASE 50,540 0.00 2,028,613.00 103,643.36 2,028,613.00: 103,643.36 11.7,410.06 5497.63 141,639.97 141,639.97 0 203,601.31 203,601.31 728.77 143,227.06 143,227.06 74.14 143,391.56 143,391.56 117,410.06 44,240.46'' I 1,293,109.74 1,293,109.74'.. Police Hall A 2017 NEEDS ASSESSMENT Study ■ Fire Ri�4i 1 Tybeie = E� 'a • �Zi n�r�,� ��y- r J� ti Pon- a VP Districk tibraryr 9 e I l U Lu'e k 34 _ o Complex 6 = 14 41 dI2 OK Ward Pla �k GroDklk m s p ,ro _ Fn ti, l�J i i 9T it Tyhee ., New Day Pkwy *ay pkwy 4 0+"+' Po f District Library91 , •-'"• Chuwwck 4f EI ry 0001 1 00 OK Ward Park � / Brooklyn's Playground Chubbuck E Chubbuck Rd • I ----W Quinn Rd o �i r Vellnes"s .orrnplex Call Volume Zoon 23.75 Ove -r L�p� � n n IMW Cal l 1500 1000 500 19. 14.25 9.5 4.75 0 0. 1 F I" 2016 2018 2020 2022 2016 2017 2018 2019 2020 2021 2022 ewHo s 60 New0 mes esid Hal Devel e t Acres A exe For r 41b Industrial/ m ercial 600 ew Ho es ase. and Church L4W T w Ho es 44 Fire Service Area Current City Limits Recent Annexations Future Roads Fire Station Locations Existing Station Future Philbin Station Future New Day Station Future Rio Vista Station 1.5 Mile Service Area Existing Service Area Philbin Service Area New Day Service Area 0 0.375 0.75 1.5 Miles arr: i -In oF-,qr: e1spons :ers like �•n u tt j %--a C; ed Ih ry fj R.i f - _-- i t, Mo -rv�.=sa•e� moo An y �g � j� 7 e! s � N a _ N �` 3 2622-23 2622-23 2023-24 Modification Cur Year Cur Year Fut Year Account Number Account Title Budget Actual Budget NON -BUSINESS LICENSES FIRE CONTROL & PREVENTION 10-4231-110 FC Salaries 1,025,000 482,204 1,852,000 10-4231-111 FC Salaries OT 101,000 48,812 101,040 10-4231-112 FC Salaries Work Out Of Gass .00 .00 .00 10-4231-115 FC Salaries Paycall 81,000 27,968 81,000 104231-210 FC FICA 79,000 41,697 147,000 10-4231-215 FC FICA Paycall 6,000 2,239 6,100 10-4231-220 FC Retirement 136,726 68,129 255,000 10-4231-240 FC Workers' Compensation 30,000 15,482 63,000 10-4231,245 FC Workers' Comp Paycall 12,000 6,131 15,300 10-4231-250 FC Health Insurance 231,050 111,903 441,650 10-4231-255 FC Health Insurance Paycall 5,000 1,733 5,000 10-4231-260 FC Unemployment DO .00 .00 10-4231-265 FC Unemployment Paycall .00 .00 .00 10-4231-300 FC Interagency Services .00 .00 .00 10-4231-310 FC Office Supplies 5,492 748 .00 10-4231-345 FC Computer Software 89,500 22,378 .00 10.4231-347 FC [lues 4,000 280 .00 10-4231-517 FC Vaccine & Testing 5,000 .00 .00 10-4231-519 FC Physical Exams 13,000 4,825 .00 10-4231-52C FC Electrical Power 7,500 2,620 .00 10-4231-522 FC Natural Gas 3,200 2,956 .00 104231-600 FC Building Maintenance 18,500 x,535 C0 104231-730 FG Building RemodeVAddition 00 .00 .00 10-4231-740 FG Safety 5,000 .00,- .00 10-4231-770 FG Debt Service .00 .00 .00 10-4231-771 FC Interest Expense .00 .00 .00 10-4231-801 FC EMS Grant .00 .00 .00 10-4231-802 FC Dedicated Grants 00 .00 .00 10-4231-803 FC ASPR Grants .00 .00 .00 10-4231-900 FC EMS 5,000 553 .00 10-4231-901 FC EMS Improvements .00 .00 _00 10-4235-510 FC Telephone 7,5100 3,738 .00 10-4235-630 FC Communications 3,000 .00 .00 10-4235-632 FC Radio New ,00 .00 .00 10-4236-370 FC Training 14,262 8,303 .00 10-4236-371 FC Continuing Education 738 245- .00 10-4236-375 FC Prevention 5,000 1,696 .00 10-423+6-376 FC Prevention Grants .00 .00 .00 Capital Improvement Fund More Personnel 'w' --q" AIR F Additional Fire Station State of the City Address "Mayor Cotant" "we are again bulging at the seams and the council must immediately look towards in the fire station a new facility" "...sell the city 5 acres on Yellowstone and generating enough cash to continue our building program ... An addition to the present fire station or a new station completely must be given every opportunity to happen provide adequate housing for the fire department. This should be our number one priority "We need to continue the pursuit of a new fire station" Lack of adequate day time fire coverage 2018 Priories Meeting: F.D."Being Patient on building the new Fire Station until TIFF District expires " When fire is cried and danger is nigh, "God and the firemen"is the peoples cry; But when 'tis out and all things righted, God is forgotten and the firemen slighted. MOWy is - COMMUNITY SERVICES' �'� FY24 BUDGET PRESENTATION APRIL 5, 2023 Who We Are Building 0 M M M M M M M M M M M M M 0 Development Services Planning Parks &Recreation CDA, Impact Fee Admin, random code/policy revisions, community boards, etc. fanning, conomic Development Building Other Duties as Assigned Development Services Parks & Recreation D Ongoing Efforts to Adapt to Changing Conditions Bui'ld'ing • 3 FTE o Building Official o Building Inspector (Oct -March '23 = vacant) o Permit Coordinator- now hiring Development Services �� • 2 FTE Development Services Manager * 1 Development Construction Inspector Planning • 1 FTE- Planning Manager Parks & Recreation • 4 FTE * Parks & Recreation Manager * 3 Parks Maintenance Workers • Plus temporary employees (through Temp Agency) � Other Duties as Assigned • 1 FTE- Community Services Director • Department Administration • Chubbuck Development Authority Administration o 4 urban renewal plans ■ 1 plan is terminating in 2023 ■ 2 plans created in past 2 years • Impact Fee Administration • Internal Economic Development contact • Community organization participation- Bannock Development Corp., Visit Pocatello-Chubbuck • Assistance with Design Review applications • Assistance with other departments' policies/codes (such as public park vendor ordinance) • Etcetera, etcetera, etcetera ALEN AR YEAR 10/1/22 - 3/31/23 FEES COLLECTED $108,155 Building Division (permits only) $12,147 Dev,, Services Division $4,429 Planning $1,873 Parks& Recreation $126,604 TOTAL , ALEN AR YEAR 10/1/22 - 3/20/23 GRANTS $88,000 BCIF Park Grant $30,000 BCIF Comp Plan Grant $11811000 Total Awarded Community Services Department's Priorities • Retention and training of existing personnel is Backlogged Maintenance in Parks is Support for Fire Department & Streets 0 With the 1992 Plan termination, we believe that the funds should be used to help make those general fund departments whole that have sacrificed for the 30 year life of the Plan FY'23 ITEMS OF NOTE- Community Services (NON -PARKS) 2 employees retired (Rob Humpherys/Kammi Kinney) Revised Design Review process to make more efficient Starting Comp Plan process (12-18 months) April'23- Transition to Online Permit Program May/june'23- Fina lize arterial sidewalk and maintenance/buffering standards is 2023- Significant development/building projects - commercial & multi -family " FY 124 REQUEST- COMMUNITY SERVICES (NON - PARKS) Funding Needs: • Rec/Program Specialist Position • Oversee Baseball and other Rec programs • Assist Director with: ■ Impact Fee administration ■ Urban Renewal administration ■ Adopt -A -Park Program administration ■ Policy Analysis ■ Property Disposal ■ Park Planning ■ Personnel Tracking, ■ Etc. CHUBBUCK 1 0 A H o 9 CS Personnel I E 1111 T SEI I PARKS) F 23 Approved YTD ActuaI FY24 Proposed Salaries 267..000.007 94..565.00 S X99: 000.00 over -time 10000.00 394.00 S 1,000.00 FI C. 20F 000.00 S 6,974.00 22:5 0 0.0 0 Retirement 32p000.00 11,259.00 36,00MO Workers' Come 2,5 00.00 L 258.00 2.a 70 0,: 0 0 Health insurance 63p500.00 22.,886.00 72,000.00 3S6.pODO.00 S 137p336.00 43 3'2-00.00 Additional Coram a ntE; 1- If unable to find way to fund the Rec/Frogram Specialist position in FY23, will reed approx. $110,000 for the position. This is inot included in the above chart. Can possibly be split between general and enterprise funds based on job description. CHUBBUCK 1 0 A H 0 220 M-Nme'' SAdministration FY23 Avvr B'i II Expense YTD Actual Cert ificat ion/Licensing $ City Hall Lease 500.00 City Hall Operations 30.00 Computer/IT Hard,.,gare Computer/IT Software Employee Continuing Ed Employee Rhone Stipend $ Employee Recognition 7,500.00 Equipment Insurance 12,943.74 Liability Insurance Mapping/GJS System Membership Dues Office Equipment/Supplies $ Professional Services $ Shop Facility Luse $ Training/seminars $ Travel Utility- Telephone $ Utility- Electrical $ Utility- "Vat. Cas 1,3915.00 Facility Maint/Jan'itoria l $ Poky Trade Inspections $ Subdivision Fee Remit. $ Cells/Tablets $ Cellular Plans $ 404.00 2, 000.00 owed YTD Actual - $ 65.00 500.00 $ 30.00 2,000.00 $ - 7,500.00 $ 12,943.74 500.00 $ 215.00 19,000.00 $ 15,348.00 1,3915.00 $ 21.00 1,500.00 $ 76.00 1,.5 00.00 $ 404.00 2, 000.00 $ 304.00 1,000.00 $ 020.00 10,0001.00 $ 115,543.00 45,996.00 46,944.74 p11\ FY24 Proposed Justification $ .500.00 $ 3 000.00 $ 3,750.00 $ 500.00 $ 13,000.00 $1.5,000 is B $ 1,356.00 $ 1,.500.00 $ $ $ $ 25,000.00 Pay a portio $ 4,000.00 2tab lets, 1 $ 4,500.00 2 tablets, 4 78,1365.00 C: 7500.00 adding rec manager role- training; virtual CEUs going akeaa°Y 7,500.00 Adding rec manager role- training; virtual C:EUs going aavvay 1,000.00 Additional Comments 1- ?oky Trade Inspections are like pass-through fees based on our col lected fees for D..lumbing and Electrical Permits. Poky does reviews and 'inspect Bons. If -,,qe don't have those permits, there isn't a cost. n of the electrical/plumbing fees %.ve collect to Poky phone � nea+v} phones (includes some existing plans; CHUBBUCK 1 0 R H 0 ES Equipment FY23 Approved YTD Acta a =uels & Lubricants 11500.00 2e213.27 Small Too Is/Equ ipment - - Vehic:le M&O 2,500.00 Vehicle Replacement CS Safety Training Clothing Equipment 2,21-9.27 FY23 Approved YTD Actuall 500.00 500.00 348.00 -. I.P000.00 $ 348.00 p11\ FY24Proposed Justification 3500.00 150.00 Building Division utilizes small tools for inspections 2,500.00 6.pI. 00 FY24 Proposed Justification 500.00 - Ip. FY'24 REQUEST- SUMMARY • Non -Parks Budget • Doesn't include Rec/Pro9 ram Specialist • +$81,850 vs FY23 ■ $47,200 are personnel (inflationary adjust; insurance) ■ X44,650 are: • Increases to match actuals • Training, cells/tablets, data plans o Carry over funds for comp plan not used in FY23 rFY'23 ITEMS OF NOTE- Community Services I- IN (PARKS & REC) • Spring'23- standing upAdopt-a-Park program (recent press release) • Spring'23- Grove park area disposal • Parks Impact Fee Projects: • Long Park • Hiram Park • Miller Park • More certifications: o Certified Pool Operator (splash pad) • Decreasing flower baskets- time consuming • Existing Facility Capital Needs Assessment Aft ;;hI IN -, NEEDS (CURRENT & FUTURE) -PARKS & REC Every new park, community space, trail, street landscaping strip, fence against a sidewalk, etc., comes with an increased burden on the department or on other city departments that the City should account for. 4 000 If we can't provide adequate funding for our parks facilities, we may want to re-evaluate our collection of parks development impact fees/building new parks. FY'24 REQUEST- PARKS & REC • increasedieMDorarvworKerFuncjinq o Currently allocated $50,000 ■ = 2,754 hours at-$18.15/hr (temp + agency cost) ■ = 17.2 months of work for 1 worker ■ or 3.4 months for 5 FT temp workers ■ or 4.3 months with 4 FT temp workers o Best Practices for Parks = 12-14 acres of park land ■ Excluding undeveloped Miller Park, we have -1 park space / FT employee 00 acres of managed ■ Need for 3 FT temps in April/September, 4 from May - August ■ Seeking $65,000 to accommodate inflationary costs in 2024 season CHUBBUCK 1 0 A H o CS Park- Personnel FY24 Proposed Justification 356:000.00 13,009.00 65,000.00 -50k covers 3temps for 3.2 months. Need temps fors months. 45,000.00 14,000.00 1.1.6,000.00 637.pOOO.00 FY23 Approved YTD, D, Actu a Salaries 302,0.0 153,62-4.00 Over -time e 13 ,000.90 6,124.00 seasonal 50,000.00 4p 941.00 = ICA 2-3,000.00 12578.00 Retirement 42,000.00 19,747.00 Workers' Comp 12,000.00 5r409.GG Health Insurance 102,000.00 3gr325.00 Dhone Stipend 8-00.00 213.00 Clothing - 269.00 $ 549r900.00 242.pM.00 FY24 Proposed Justification 356:000.00 13,009.00 65,000.00 -50k covers 3temps for 3.2 months. Need temps fors months. 45,000.00 14,000.00 1.1.6,000.00 637.pOOO.00 za �, CHUBBUCK F 24 RE Q1 IF ES I F ARI I S & RE14 CS Park- Support Services FY23 Approved YT Actual FY24 Proposed hi5tifiCatiOrl Flet Maintenance 24,000.00 S - 24,000.00 CS Farb- Administration FY23 Ap1)roved VTD AdUal FY24 Proposed mast if CatiOn B i I I'ing Expense C, _ Certifications 'Licensing 3..000, 0C = _. .L-9. .00C, City Hall Lease 17 - - City Hall Operations 5,500 00 S 3.582 00 550C, Computer/IT Hardware - 12-7.00 300.00 Computer/JT Software - _= 861.CC. 2C. : Adget should match actual Continuing Education - Phone Stipend - - Employee Recognition - 8.00 300.00 Equipt. Insurance - - - Liability Insurance - - - Mapping GIS System - - - Membership Dues - 454.00 500.00 Office Equipt S upp I ies 300.00 533.00 300.00 ?rofessional Services - 2..945.00 3,000.00 Darla design fees Shop Facility Lease - - - Training Seminars 2,000.00 2-68.0 Travel 3,400.00 640.00 Utility -Telephone 300.00 524.00 SC� Utility- Electr'ica1 9..000.00 5,72-3.00 9,0CC_CC Utility- Flat. Gas 1.400.00 2,053.00 Z..100.0C Budget should match actua Facility Maintenance 1,000.00 667.00 1r000.0C Yard Facility Construction 2,500.00 1..501.00 Yard Facility Operations - 62.00CC CC 29J00. 00 35p902.00 52-e900.00 FY'24 REQUEST- PARKS & REC • There is an approx. -$800,000 backlog in park improvement maintenance projects • Toy replacement • Bathroom updates • Field renovations o Walking Path/Basketball Court resealing/replacing portions o Parking lot resurfacing o Dri • Not to mention, the existing maintenance backlog does not include nking Fountain replacement funding needs for future Miller and Truman/Espie Parks. Armstrong Park Bicentennial Park Ail Bicentennial Park sMw Cotant Park k plkl�- IN, - M Cotant Park w I�k r..nta nt a ric It Jerry Rowland Park 74 i y& i 1- t 41 � r _ Ati �b +s ii410Arsy+ � „�,. �� - -. �' _._ tY�+.�-fie• � �n�� �:tJ ,.:$` YI\ .y t. p� Mary Harker Park Mary's/Heartland Parks Mary's/Heartland Parks z �RRM� 7*4�• ti e z �RRM� Community Park (Garden Dr.) "�s +we: E4t � v Sh v-. i CHUBBUCK 10AI10 !�OkAmoll] 7.7SJ: S Park- Maintenance FY23 Approved YTD .Actual Mowing Remodel outdated restroorns for better ,,�interizat'ion - 231.0G Irrigation 5,000.00 7:500.00 11000.00 1,249.00 weeds Update backboards, nets, cracks, etc 5,2-00.00 - Trees 1,0CLc. CC 6,000.00 80,00C CC 6-.50.00 Fertilizer 60k carried over from FY23 into FY24, 30k from fend balance from parks capital planning 21000.00 - 2-0,700.00 $ 2,130.00 5Park- Facility Maintenance FY23 Approved YTD ,Actual Iaygrounds - 2,519.00 Restroom 9,000.00 1,964.00 Building 1'500.00 6,152.00 Walking Path 1,.500.00 109.00 Pavilion 1'000.00 547.00 Light Poles 1,000.00 - Basketball Court - 199.00 'ence 500.00 - Splash Pad 12,500.00 665.00 Volleyball Court 1,000.00 - Ball Fields 21500.00 3,965.00 Tennis Courts 601000.00 - 90,900.00 15,144.00 FY24 Proposed Justification 0 20r000.0C Contraffng ,.where rake financia I sense 7,500 5,200.00 61000 2,CC: 1 s 40,700.00 FY24 Proposed Justification 125,CCC ;--0 Replace/repair outdated and-,�;orn out equ`ipt all over city 50,000 CC Remodel outdated restroorns for better ,,�interizat'ion 5,000.00 25,000.00 Paths need sealed, patched, or portions removed/replaced 5,000.00 Pavilions need painted and bird proofed 11000.00 91500.00 Update backboards, nets, cracks, etc 500 CC 12r50C _ 1,0CLc. CC 80,00C CC 1ackstop renovation, field renovation, bleachers 90,000 60k carried over from FY23 into FY24, 30k from fend balance from parks capital planning $ 401,500.00 5 Park- ShoulderWork FY23 Approved YTD ,Actual FY24 Proposed Justification Sno,,v Removal 7,900.00 S 366.00 1,500.00 5P°arks- Property FY23 Approved Trash 9,500.00 ADA 1,500.00 5.000.00 YTD ActuaI FY24 Proposed Justification - 5,500.00 - 11500.00 - 5.000.00 za �, CHUBBUCK 1 0 R H 0 2 m ImIkA as : rA LI I5kA irk4qb 9 61N� 0 S Farb- Shoulder Work FY23 Approved YTD Actual FY2-4 Proposed JUst if icat ion Sr ovq Remova I 7PS00.00 366.00 1x500.00 SPark- Property FY23 Approved Trash 3.500.00 ADA 1500.00 5,000.00 YTD Acta a S - Spark- Additional Services FY23 Approved YTD Actuai FY24Proposed Justification 3,500.00 1,500.00 Sr000.00 FY24 Proposed Just if icat ion %000.00 FY'24 REQUEST- PARKS & REC • Side by Side w/ attachments (weed spraying, snow removal, fertilizing) - $40,000 • Trim Mower- $17,000 • Commercial mower- $90,000 • $60k was budgeted for Osborn Tennis Court resurfacingin '23. No capacity to advertise the job this year and court holding up for 1 more year. Anticipated cost - $90k (carry over FY23, add $20k for FY24)0 za �, CHUBBUCK 1 0 II H H 5 Park- Additional Services =uel & Lubricants Small Tool/Equipment Large Equipment FY23 Approved 13:500.00 3:500.00 10:000.00 27,{x.00 !M:Amoll] 7.7SJ: YTD Actua 9,576.00 664.00 4:531.00 $ 14, 921.00 0 ►� -w0 FY24 Proposed Justification 13..500.00 3:500.00 147: 000.00 $107k from =und Balance for Mo,,,- er and Trimmer Mo-b-gerr 401< for side-by-side ,,�q ith attachments $ ILC4, 000.00 za �, CHUBBUCK 1 0 R H H Cs Park- safety Training Clothing Equipment Testing FY'23 Approved 4. C a1 L• a1 4: e1 e1 e1 e1 e1 71100.00 YTa Acku a 6r2 0.00 FY24Proposed Justification 3.=0.00 2—..000.00 600.00 1 500 -OC 6eoo.00 . _... _� Budget � +$581,480 vs FY23 ■ X87,200 are personnel (inflationary adjust; insurance) FY'24 REQUEST- SUMMARY ■ $494,200 are: • From 1992 Plan $ o Increases to lines t o match actuals • Contracting services when better deal than city can o Facility Backlog Maintenance o Dept side-by-side for more efficiency • From Fund Balance o $60k carryover from FY23 budget for tennis courts o $107k from fund balance from parks capital planning- mower/trimmer Public Works Dept. FY24 Preliminary Budget Stu 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. Budget Request Summary FY23 Final Budget FY24 Proposed Budget $$$ Change % Change ESTIMATED Revenue $2,300,000.00 $2,474,000.00 $174,000.00 7.6% Wages & Benefits $778,700.00 $887,500.00 $108,800.00 13.97% Administration $276,200.00 $305,800.00 $29,600.00 10.72% H Operational Expenses (including Capital Equip. and Pavement Maint.) $1,109,100.00 $1,144,700.00 $35,600.00 3.21% Z W Additional Services $0.00 $0.00 $0.00 I-- Debt Service $136,000.00 $136,000.00 $0.00 0.00% a W Q Total Planned Expenses $2,300,000.00 $2,474,000.00 $174,000.00 7.6% oc Capital Equipment (included in Operational Expenses above) $0.00 $275,000.00 $275,000.00 Pavement Maintenance (included in Operational Expenses above) $547,400.00 $404,400.00 -$143,000.00 Expenses Exceeding Revenue $0.00 $0.00 $0.00 Identified Additional Needs $695,600.00 Budget Highlights • Budget includes $275,000 for new sweeper and small snow plow in accordance with Capital Equipment Plan. • Budget includes $404,400 for Pavement Maintenance to result in a balanced budget (expenses=revenue) • Pavement Management Plan shows a need for a minimum of $1.1M per year on pavement maintenance to maintain current pavement conditions. • Identified need of $695,600 to meet pavement management plan. HSR Line Item Budget Summary FY23 Final Budget FY24 Proposed Budget $$$ Change % Change Wages & Benefits $778,700.00 $887,500.00 $108,800.00 14% Administration $276,200.00 $305,800.00 $29,600.00 11% Asphalt Maintenance $602,400.00 $459,400.00 -$143,000.00 -24% Pavement Markings $25,000.00 $35,000.00 $10,000.00 40% Signing $13,000.00 $13,000.00 $0.00 0% Sweeping $1,500.00 $23,000.00 $21,500.00 1433% N Snow Removal $16,000.00 $35,500.00 $4,500.00 28% a Sidewalks $31,000.00 $46,000.00 $15,000.00 48% x u' ci Shoulders $11,000.00 $11,000.00 $0.00 0% c Street Illumination $91,500.00 $121,000.00 $29,500.00 32% a, Traffic Signals $13,000.00 $13,000.00 $0.00 0% p Storm Drains $84,000.00 $34,000.00 -$50,000.00 -60% Roadway Projects $25,000.00 $0.00 -$25,000.00 -100% Equipment Expenses $192,500.00 $347,500.00 $155,000.00 81% Safety $3,200.00 $6,300.00 $3,100.00 97% Additional Service $0.00 $0.00 $0.00 0% Debt Service $136,000.00 $136,000.00 $0.00 0% Total $2,300,000.00 $2,474,000.00 $174,000.00 8% Equipment Expenses 14% Roadway Projects 0% Storm Drains 1% Traffic Signals 1% Street Illumination 5% Shoulders 0% Sidewalks 2% Snow Removal 1% Sweeping 1% Safety■ Additional Service 0% 0% -- Signing' Pavement Markings 1% 1% Debt Service 5% Asphalt Maintenance 19% Wages & Benefits 36% Administration 12% Highway, Streets, and Roads [department FY23 Final Budget FY24 Draft Budget $$$ Change % Change Wages & Benefits 11-4311-110 Salaries 488,600.00 $ 558,000.00 $ 69,40C1.C1C1 14.2% 11-4311-111 Overtime 17,DDO.00 $ 22,000..00 $ 5,0OC9.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,2DO. DO 9.9% 11.4311-240 Workmens Compensation $ 11,iDD.DO $ 14,500,00 $ 3,400.00 30.6% 11-4311-250 Health Insurance $ 159,80D.D0 181,00o.oc $ 21,200.00 13.3% 11-4311-2601 Unemployment $ - $ - $ $ 778, 700. DO $ 887, 500.00 $ 108, 800.00 14.D% Support Services 11-4312-100 Engineering $ - $ - $ 11-4312-110 Planning / Development $ - $ - $ 11.4312-120 Fleet Maintenance $ - $ - $ - 11-4312-130 I.T. $ - $ - $ 11.431.2-140 Utility Billing $ - $ - $ - 11-431.2-150 Finance 11-4312-160 Human Resources - 11 -4312-170 Administration $ - $ - $ Administration 11-4333-100 Billing. Expense - $ - $ - 11-4333-110 Certifications J 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,DOO.Do $ 24,000.00 $ (6,000.00) -20.00% 11.4333-1601 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.010 $ 200.00 15.39% 11-4333-1901 Equipment Insurance $ - $ - $ 11.4333-200 Liability Insurance $ - $ - $ - 11-4333-210 Mapping / GIS Systems $ 3,30D.D0 $ 7,500.00 $ 4,2DO. DO 127.27% 11.4333-220 Memberships / Dues $ 70,000.00 $ 70,000.00 $ - 0.0096 11-4333-230 Office Equipment/ Supplies $ 7,500.00 $ 4,000.00 $ (3,500.00) -46.67% Highway, ay, Streets, and Roads Department FY23 Final Budget FY24 Draft Budget $$$ Change % Change 11-4333-240 Professional Services 5,000:00 1D,DDD:OO 25,000.00 15,000.00 20,000.00 400.00% 5,000.00 50.00% 11-4333-250 Shop Facility Lease 10,000.00 s (10,000.00) -50.00% 1,500.00 $ $ - $ 11 -4333-250 Training f Seminars 10,01111.00 40.00% 1,800:OD 3,000.00 $ 1,200.00 56.67% 11-4333-270 Travel $ - $ 500.00 $ 500.00 11-4333-280 Utility - Telephone $ 6,500:DD $ 7,500.00 1,000.00 15.38% 11-4333-290 Utiltiy - Electrical 6,50O:D0 5,500.00 $ - 0.00% 11-4333-300 Utiltiy - Natural Gas 4,000.00 4,000.00 - 0.00% 11-4333-310 Facility MaintJJanit 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,OOO.DO $ 10,000.00 5,000.00 100.00% 276,2DD.DD $ 305,800.00 $ 29,600.00 10.72% Asphalt Mai•,ntenance 11-4340-100 Crack seal $ 10,00O.DO 10,000.00 - 0.00% 11-4340-110 Asphalt Patching 10,000.00 10,000.00 $ - 0.0D 11-4340-120 Pothole $ 10,DDD.00 10,000.00 $ O.DO% 11-4340-130 Surface Maintenance $ 547,400:0D 404,400,00 $ (143,DOO.DD) -25.12% 11-4340-140 Street Construction 25,ODD.DD 25,000.00 $ - 0.00% $ 602,4OO.DO 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 s (10,000.00) -50.00% 1,500.00 $ $ 25,0W.DD $ 35,000.00 $ 10,01111.00 40.00% Signing 11-4342-100 Sign Materials $ 13,D .00 13,000.00 - 0.00% $ 13,D0D.00 $ 13,000.00 $ - 0.00% Sweeping 11-4343-100 Material Disposal $ 1,500.00 $ 3,000.00 1,500.00 100.00% 11-4343-110 Storage Facility $ - $ - 11-4343-xxx Sweeping M&O - $ 20,000.00 $ 20,000.00 $ 1,500.00 $ 23,000.00 $ 21,500.00 100.00% Highway, Streets, and Roads Department Snow Removal 11-4344-100 .salt 11.4344-110 Sand 11.4344.120 Brine 11-4344-xxx Plow M&D Sidewalks 11-4345-100 Maintenance 11-4345-110 Weed Control 11-4345-32C Repairs 11.4345.130 ADA Shoulders 11 -4346 -IOC Maintenance 11.4346.110 '~Need Control 11-4346-120 Repairs Street Illumination 10,DOD.OD 11-4347-10C Power 11-4347-11C Construction / Installation 11-4347-12C M&Cf Traffic Signals 10,DOD.OD 11-4348-100 Power 11-4348-110 Construction / Installation 11.4348.120 M&O Storm Drains 11.4349.100 Cleaning/ Disposal 11-4349-110 Construction / Installation 11-4349-120 M&O FY23 Final Budget FY24 Daft Budget $$$ Change % Change $ 10,DOD.OD $ 25,000.00 15,000.00 150.00% $ 5,DDD.DD $ $ (5,000.00) $ 1,DOD.OD $ 500.00 $ (500.00) -50.00% $ 10,000.00 $ 10,DDO.00 $ 16,DOO.OD $ 35,500.00 $ 19,500.00 121.88°1 $ 15,DDD.DD $ 1,000.00 $ (14,DOD.00) -93.33% $ 5,DOD.OD $ 5,000.00 $ D.0D96 $ 1,DOD.OD $ 15,000.00 $ 14,DOD.00 1400.OD% 1D,DDD.OD $ 25,000.00 $ 15,DOD.00 150.DCY% $ 31,D00.00 $ 46,000.00 15,000.00 48.39% $ 5,DOD.OD $ 6,000.00 $ 1,DOD.00 20.DD°1 $ 5,DDD.DD $ 5,000.00 $ D.OD% $ 1,DaD.aD $ - $ (1,00D.OD) -100.00% 11,DDO.OD $ 11,000.00 $ D.DD 85,DDO.OD 100,000.00 $ 15,0DO.00 17.65% $ 5DO.OD $ 15,000.00 $ 14,500.00 29DO.00% $ 6,000.0D $ 6,000.00 $ - 0.00% $ 91,500.00 $ 121,000.00 $ 29,504.04 32.24% $ S,DOD.OD $ 5,000,00 $ 0.00% $ 3,DOD.OD $ 3,000.00 $ D.06% $ 5,DDD.DD $ 5,000,00 $ - D.DCY% $ 13,DOD.OD $ 13,000.00 $ - D.00Y% $ 4,DOD.OD $ 4,000.00 $ 0.0096 $ 75,DOD.OD $ 25,000.00 $ (50,DDD.00) 65.57% $ 5,DOD.OD $ 5,000.00 $ 0.0096 $ 84,DOD.OD $ 34,000.00 $ (50,000.00) -59.52% Highway, Struts, and Roads Department Flags 11-4353.110 Banners 11-4353-120 Christmas Decorations 11-4353-130 Chubbuck Lays 11-4353.140 Tree Trimming FY23 Final Budget FY24 Draft Budget $ Change % Change Roadway Projects 3,000.00 $ 2,DDD.DD 2DD.DD% $ 500.00 $ 1,oco. o 11.4350.100 Siphon Road 100.DD% $ 5DD.00 $ 3i]{lM $ (2DD.00) 11-4350-110 Hawthorne Road $ $ � $ 3,10C,00 96.88% 11-4350-120 Hawthorne & Quinn $ 20,DDD.DD $ (20,000M) -100,00% 11-4350-130 Sacajawea Roundabout $ 5,DDD.00 $ - $ (5,DDD.00) -100.00% $ 25,DDD.DD $ (25,DDD.DD) -100.00% Equipment Expenses 11-4351-100 Fuel & Lubricants $ 25,D0D.0D $ 30,000.00 $ 5,DDD.DD 20.DD% 11-4351-110 Equipment M & 0 $ 45,D0D.0D $ 20,000.00 (25,0DD.DD) -55.56% 11-4351-120 Vehicle M & 0 $ 45,DDD.00 $ 20,000.00 $ (25,DDD.00) -55.56% 11-4351-130 Capital Planning $ $ $ 11.4351-140 New Equipment Planning $ 75,DDD.DD $ 225,000.00 $ 15D,DDD.DD 2DD.DD% 11-4351-150 New Vehicle Planning $ $ 50,000.00 $ 5D,DDD.DD 11-4351-160 Small Tools and Equipment $ 2,50D.DD $ 2,500.00 $ Safety 11-4352-100 Training 11-4352-110 Clothing 11.4352.120 Equipment 11-4352-130 Testing Additional Service 11-4353-100 Flags 11-4353.110 Banners 11-4353-120 Christmas Decorations 11-4353-130 Chubbuck Lays 11-4353.140 Tree Trimming 11-4353-150 interagency Services Finance f Accounting 11-4380-822 Wastewater Loan $ 192,5DD.DD $ 347,5MOO $ 155,DDD.DD 8D.52% $ 1,2DD.DD $ 2,000,0o $ 8DD.DD 66.67% $ 1,DDD.DD $ 3,000.00 $ 2,DDD.DD 2DD.DD% $ 500.00 $ 1,oco. o $ 5DD.00 100.DD% $ 5DD.00 $ 3i]{lM $ (2DD.00) -40.00% $ 3,2DD.DD $ 6,3CO.00 $ 3,10C,00 96.88% $ 136,DDD.DD $ 136,000.00 $ 0.00% j 136,DDD.DD $ 136,000.00 $ 0.00% HS&R Capital Equipment Summary Iters FY23 FY24 FY25 FY26 FY27 Snow Ploy Truck $75,004,00 $50,000.00 $75,000.00 r Street Sweeper $0.00 w225, 000.00 ti0,00 $250,004.00 z LU Striping Grinder w0,00 Asphalt Roller $45,000.00 I CL Total 575,000.00 X275.000.00 SO.00 37C1,010.0C, � W Source of Funds Operations Budget ' 75,000.00 Sweeper Grants Total w75,000.00 $4.40 $0.00 S0.1_10 w - Total 50.00 -$275,000:00 $0.00 -5' 1CI oL10,OC� HS&R Personnel Request Summary Position FY23 FY24 FY25 FY26 FY27 Road Maintenance Worker - $ 000 0 } $ 45,000.00 z LLI C W Z ratal- S ,oao.oc� 45r�_�oo,r�e_� s ti Pavement Maintenance (Background) 100 CL a 80 0 60 c 40 0 u 20 E M 0 CL Good Fair Poor Fa Pavement Age Resurface 100 .a a 80 70 60 := 50 U 40 E 30 20 10 Preventive M&R - Less costly Range of Typical "Critical PCI" Values Acceleration of pavement deterioration Major M&R - fere costly 10 20 Pavement Age (Years) 34 Pavement Maintenance (Background) 100 a x 75 c 0 0 50 e �u a 25 Proactive vs. Reactive M&R Original Pavement $1 2 Seal Coat* Thin Overlay Structural Overlay Remaining Service Life = 0 $7 15 Reconstruction Pavement Age Pavement Maintenance (LOS and Need) 100 10610111111 90 85 80 75 WE 65 60 55 50 +— sta rt City of Chubbuck, ID Annual Condition for Various Budget Levels Analysis. Date = 12/30/2021 Fix All Budget = $16.2M Over 5 Years Target PCI = 78, Budget = $1910k/Year — — Maintain Current Backlog: Final PCI = 75, Backlog = 3%, Annual Budget = $1350k/Yi — _ — Recommended Budget: Final PCI = 74, Backlog= 3°°%, Annual Budget = $1390k/Y, Chubbuck Budget: PCI = 69, Backlog = 4%, Annual Budget = $600k/Yr Steady State PCI: Final PCI = 72, Backlog = 300%, Annual Budget = $1100k/Yr Backlog Control Budget: PCI = 75, Backlog = 3% Annual Budget = $1350k/Yr PCI Control Budget: PCI = 75, Backlog = 3°%, Annual Budget = $1390k/Yr Do Nothing 2021 2022 Year 2023 Chubbuck has a RCI controlled network 2024 1U15 Variables • Inflation/Material Costs • Traffic Loadings and Patterns • Weather and Moisture • Related costs, curb and gutter, ADA ramps, etc. • Etc. This Does Not Address: • Growth / New Roads • New Construction • Hawthorne Road Bridge • Intersection Improvements 5 -YR Plan Legend N — 550K/yr �1.1M/yr C S - a Z Z 0 J Z S K 1 A 1 Rd 1 1 • 1 0 1 1 Z 1 1 , 1 •1 1 - 1 W Chubbucl 1 IN • 1- edC/SrP Ra atiste Ro. s V I A 0 0.25 0.5 1 Miles I I I I I I I I �J W Tyhee Rd - - - 1- • • • • • • 1 1 ' 1 1 , ' 1 1 1 , 1 , 1 , 1 - 1 17ft 4481 ft - 1 ' 1 '1 - - • - - - ' - - - - 1 1 - - - - 1 1� / 1 1 tl 11 1 , Gff - 1 , • • - • •1 1- 1 1 1 •1 1 11 1 -11 1 ' - y 1 1 U U Q 1' 1 1 1 • \ _ 11 1 1 _ • 1 1 ------------- 5 � I Portneuf Wellness 1 Complex 1 1 1 1 1 —4483 •1 1 Pine Ridge Mall \ • • 1 Saratoga St O 4648 ft N W Quinn Rd W Quinn Rd Es PHfikEakagnin, SafeGraph, Ca*oTechnologies, Inc, METI/NASA, USGS, Bureau of Land Management, EPAWVPS, r US Census Bureau, USDA Esri, NASA, NGA, USGS, FEMA O m Pavement Maintenance (Chubbuck History) $2,000,000.00 $1,800,000.00 $1,600,000.00 $1,400,000.00 $1,200,000.00 $1,000,000.00 $800,000.00 $600,000.00 $400,000.00 $200,000.00 Pavement Maint. and Repair Costs 2014 2015 2016 2017 ■ Maint. Budget 2018 2019 2020 2021 2022 ■ CDA Contribution • TIF allocation following current split of property taxes would result in an additional $117,000 which could be used for pavement maint. HS&R Capital Projects Request Summary Item FY23 FY24 FY25 FY26 FY27 Pavement Management $ 543,400.00 $ 404,400.00 5 675,000.00 400,000.00 $ 675,000.00 Chubbuck Roundabout - 1-15 Crossing (ITD Funded) Siphon - New Day/ Yellowstone Intersection LU CDA Potenial Projects (Council Agreement) Total $ 547,400,00 $ 404,400.00 $ 675,000.00 $ 400,000.00 $ 675,000.00 Identified Additional Needs 0. W Pavement Management $ 695,600.00 $ 425,000.00 $ 700,000.00 $ 425,000.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 Sanitation Department Budget Highlights • Significant increase in Wages and Related Expenses, compared to FY23 Budget. 10.5% increase compared to actuals. Includes 1 additional driver (potential need). • No major projects planned for yard (included in Administration budget). • Increased Landfill costs based on FY22 actuals. • Planning for one new truck in accordance with Equipment Capital Plan. • Planning to conduct rate study in FY24. Budget Request Summary FY23 Final Budget FY24 Proposed Budget $$$ Change % Change ESTIMATED Revenue $2,139,900.00 $2,191,000.00 $51,100.00 2.4% Wages & Benefits $955,100.00 $1,226,500.00 $271,400.00 28.4% Z Administration $736,500.00 $499,000.00 -$237,500.00 -32.2% 5W I— Operational Expenses (including Capital Equip.) $751,300.00 $1,227,300.00 $476,000.00 63.4% Additional Services $0.00 $0.00 $0.00 a W 0 Total Planned Expenses $2,442,900.00 $2,952,800.00 $509,900.00 20.9% Z O I— H Z a Capital Equipment (included in Operational Expenses above) $0.00 $350,000.00 $350,000.00 (A Capital Projects (included in Operational Expenses above) $0.00 $0.00 $0.00 Expenses Exceeding Revenue $303,000.00 $761,800.00 $458,800.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. Includes 1 additional driver (potential need). • No major projects planned for yard (included in Administration budget). • Increased Landfill costs based on FY22 actuals. • Planning for one new truck in accordance with Equipment Capital Plan. • Planning to conduct rate study in FY24. Sanitation Line Item Budget Summary FY23 Final Budget FY24 Proposed Budget $$$ Change % Change Wages & Benefits $955,100.00 $1,226,500.00 $271,400.00 28% Administration $736,500.00 $499,000.00 -$237,500.00 -32% Residential Service Expenses $230,000.00 $272,000.00 $42,000.00 o 18/ Commercial Service Expenses $123,000.00 $140,000.00 $17,000.00 o 14/ N Roll off Service Expenses $76,000.00 $106,500.00 $30,500.00 o 40% CL W Recycle Service Expenses $32,000.00 $62,500.00 $30,500.00 o 95/ � ° M Additional Service $0.00 $0.00 $0.00 L O Equipment Expenses (including New Equip.) $285,000.00 $641,000.00 $356,000.00 125% Safety $5,300.00 $5,300.00 $0.00 0% Total $2,442,900.00 $2,952,800.00 $509,900.00 21% Equipment Expenses (including New Equip.) 22% Additional Service 0% Recycle Service Expenses 2% Roll off Service Expenses 4% Commercial Service Expenses 5% Residential Service Expenses 9% Safety 0% Wages & Benefits 41% Administration 17% Sanitation Department FY23 Final Budget FY24 Draft Budget $$$ Change Y6Change Wages & Benefits 33-4331-110 Salaries $ 573,90000 $ 785,50000 $ 211,600.00 36.S0A 33-433I-111 Overtime 22,08000 2I/00000 $ [iD0/0. 33-4331-210 FICA 46,50U.00 56,00088 8,500.00 30.436 33-4331-220 Retirement 74,700.00 89,00000 14,300.00 19.196 33-4331-240 VVorkmens[omnpensation 20,900.00 I0,00000 7,100.00 34.0% 33-4331-350 Health Insurance $ 317,180.00 $ 246,000M $ 28,900.00 13.396 33-4331-360 Unemployment $ - $ $ $ 955,100.00 1,236,500,00 $ 271,400.00 28.4296 Support Services 33-4832'100 Engineering $ - $ $ 33-433I-110 Planning/ Development $ - $ - $ 33-4332'120 Fleet Maintenance $ - $ $ 33-435I-130 I.T. $ - $ - $ 33-4332-140 Ub|i\y8i||ing $ - $ $ 33-433I'150 Finance $ - $ $ 33-4332-160 HumamResources $ $ 33-4332-170 Administration $ $ Administration 33-4333-100 Billing Expense 31,00000 $ 31,0OO.00 $ 0.00% 33-4333-110 Certifications /Licensing $ 1,UUOUU 1,000,00 $ 0.0096 33-4333-120 City Hall Lease $ 199,00000 139,00000 $ 0.0096 3]-433]-130 City Ha||Operations 26,00000 I6,00000 $ 0.00% 33-4338-140 Computer/ |.T.Hardware 18,0U000 A 47,00880 $ 31,800.00 193.7596 33-4339-150 [onmputer/|.T. Software 1O,OOO.00 32,00000 $ 12,000,00 120.0096 33-4333-160 Employee [ontunuinDEducation $ 3,00000 5,000.00 $ 0.00Y6 33-4333-170 Employee Phone Stipend $ - $ $ 33-4333-180 Ennp|oyeeRecn8nition $ 2,000.00 $ 2,000.00 $ 0.00Y6 33-4333-190 Equipment Insurance $ $ 33-4333-280 Liability Insurance $ $ Sanitation department 33-4333-210 Mapping/ G15 Systems 33-4333-220 Memberships / Dues 33-4333-230 Office Equipment/ Supplies 33-4333-240 Professional Services 33-4333-250 Shap Facility Lease 33-4333-260 Training / Seminars 33-4333-270 Travel 33-4333-280 Utility -Telephone 33-4333-200 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 $ 3,500.00 $ 5,000.00 $ 4,500.00 128.57�A $ 1,000.00 $ 1,000.{]0 $ - 0.00°/0 $ 2,500.00 $ 4,500.00 $ 2,000.00 80.0011/6 $ - $ 50,000.00 50,000.00 $ 112,000,00 $ 112,000.00 $ - 0.00a� $ 500.00 $ 500.00 $ - 0.00°/6 $ - $ 1,000.00 $ 1,000.00 $ 7,000.00 $ 7,500.00 $ 500.00 7.14°D6 $ 4,000,00 $ 5,500.00 $ 1,500.00 37.50' $ 3,000.00 $ 3,000.00 $ - 0.000/0 $ 15,000.00 $ 5,000,00 $ (10,000.00) -66.67% $ 350,000.00 $ 20,000.00 $ (3.30,000.00) -94.29% $ 10,000.00 $ 10,000.00 $ - 0.00010 736,500.00 $ 499,000.00 $ (237,500.00) -32.25% $ 195,000.00 $ 220,000.00 25,000.00 12.82.4 $ 3.5,000.00 $ 50,000.00 $ 15,000.00 42,86% - $ 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,640.6 $ 5,000.00 $ 10,000.00 $ 2,000.00 25,000 $ 5,000.00 $ 5,000.00 $ - 0.00°, $ 123,000.00 $ 140,000.00 $ 17,000.00 13.82% $ 6.5,000.00 $ 90,000.00 $ 25,000.00 38.46% $ 10,000.00 $ 15,000.00 $ 5,000.00 .50.00°:6 $ 1,000.00 $ 1,500.00 $ 500.00 50.0001/6 $ 76,000.00 $ 105,500.00 $ 30,,500.00 40.13°6 Sanitation Department Recycle Service Expenses 33-4343-100 Recycle waste 33-4343-110 Carts 33-4343-120 Cart Maintenance Additional Service 31,000.00 33-4360-100 Freebie 15 ycl 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 33-4370-100 Fuel & Lubricants 33-4370-110 Small Too[/Equipnient 33-4370-120 Vehicle M & 0 33-4370-130 Capital Planning 33-4370-140 New Collection Vehicle 33-4370-150 Small Vehicle Replacement Safety 33-4371-100 Training 33-4371-110 Clothing 33-4371-120 Equipment 33-4371-130 Testing FY23 Final Budget PY24 Draft Budget $$$ Charge % Change 31,000.00 45,000.00 14,000.00 45.16'/'o 17,000.00 17,000.00 1,000.00 $ 500.00 $ (500.00) -50.00% 32,000.00 62,500.00 30,500.00 95.31% $ $ $ $ 80,000.00 $ 112,000.00 32,000.00 40.00% $ 8,000.00 $ 4,000.00 $ (4,000.00) -50.00%, $ 125,000.00 $ 175,000.00 50,000.00 40.00% 67,000,00 $ - (67,000.00) -100.00% - $ 350,000.00 350,000.00 5,000,00 $ - (5,000.00) -100.00% $ 285,000.00 $ 641,000.00 356,000.00 124.91% $ 1,000.00 $ 1,000.00 - 0.00016 4,000.00 3,000.00 (1,000.00) -25.00% 1,000.00 1,000.00 300.00 $ 300.00 $ - 0.000/0 5,300,00 $ 5,300.00 $ 0.00036 Sanitation Dept. 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 Passenger Truck $0.00 $0.00 $0.00 $40,000.00 CL LU a Total $0.00 $350,000.00 $0.00 $40,000.00 5800,000.00 0 Source of Funds Fund Balance $0.00 $350,000.00 $0.00 $40,000.00 $800,000.00 F— z 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 Sanitation Dept. Capital Projects Request Summary Item FY23 FY24 FY25 FY26 FY27 Uj Yard Improvements 275,000,00 Uj Total 275"000,00 S 0 Source of Funds Fund Balance 275,000.00 z Total $ 275,000.00 Total Sanitation Dept. Personnel Request Summary z Position FY2 3 FY24 FY25 FY26 FY27 Sanitation Driver S CL LU a z 0 z Tc -a Water Department Budget Highlights • Assumes an annual 5% increase in rates in accordance with the recent rate study. • Includes 1 additional employee, split between Water and Wastewater Depts. which was planned for FY23. • Majority of Capital Improvement Plan from FY23 has been moved to FY24 — currently underway with planning study. • Majority of Equipment Capital Planning budget eliminated and will remain in Fund Balance (we're not showing it as an expense to then fall to the fund balance) Budget Request Summary FY23 Final Budget FY24 Proposed Budget $$$ Change % Change ESTIMATED Revenue (Utility Rates) $3,106,500.00 $3,252,300.00 $92,800.00 3.0% Wages & Benefits $1,098,800.00 $1,195,300.00 $96,500.00 8.78% Administration $416,500.00 $489,000.00 $72,500.00 17.41% Operational Expense (including CIP) $2,561,000.00 $2,504,100.00 -$56,900.00 -2.22% Z W Additional Services $0.00 $0.00 $0.00 0% Debt Service $625,000.00 $750,000.00 $125,000.00 20% I— GC aTotal Planned Expenses $4,701,300.00 $4,938,400.00 $237,100.00 5.0% LUD 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 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% wMeter / Service Connections $72,800.00 $74,500.00 $1,700.00 2.34% CLX W 7i 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% Additional Service $0.00 $0.00 $0.00 0% a O Equipment Expenses $202,000.00 $110,000.00 -$92,000.00 -45.54% Safety $7,000.00 $7,800.00 $800.00 11.43% Debt Service $625,000.00 $750,000.00 $125,000.00 20.00% Total $4,701,300.00 $4,938,400.00 $237,100.00 5.04% &De,IISe,vice 15% !Safety Wages & Benefits % 24% Equipment Expenses 2% Additional Service 0% Pressure Irrigation 3% Fire Protections 0% Administration 10% Meter / Service Connections 2% Production & Storage Distribution System and CIP g% 36% Water Department Wages & Benefits 31-4341-110 31-4341-111 31-4341-210 31-4341-220 31-4341-240 31-4341-250 31-4341-259 Administration 31-4353-100 31-4353-1110 31-4353-1210 31-4353-130 31-4353-140 31-4353-1510 31-4353-1610 31-4353-1710 31-4353-180 31-4353-190 31-4353-200 31-43S3-210 31-43S3-220 31-43S3-230 31-4353-240 FY23 Final Budget FY24 Draft Budget $ Change Change Salaries $ 689,9100.00 749,500.00 59,600.00 8.6% Overtime $ 8,8100.00 8,800.00 - 0.0% FICA $ 53,800.00 54,000.100 $ 200.00 0.4% Retirement 87,1100.00 87,000.00 $ (100.00) -0.1% Workmens Compensation $ 20,100.00 25,000.100 $ 4,900.00 24.4% Health Insurance $ 239,1100.00 271,000.00 $ 31,900.00 13.3% Unemployment $ - $ - $ 1,098,8100.00 1,195,300.100 $ 98,5100.00 8.8% Billing Expense $ 31,10100.00 31,000.00 $ - 0.0% Certifications / Licensing $ 9,10100.00 9,000.00 $ - 0.0% City Hall Lease $ 165,000.00 165,000.100 $ - 0.0% City Hall Operations $ 3,10100.[}0 20,000.00 $ 17,10100.00 566.7% Computer / I.T. Hardware 20,0100.00 47,000.00 $ 27,000.00 13S.0% Computer / I.T. Software 17,1000,00 40,000.00 23,000,00 135.3°6 Employee Contunuing Education $ 1,000.00 1,000.100 $ - 0.0% Employee Phone Stipend $ - - $ - Employee Recognition $ 2,5100.00 2,500.100 $ - 0.06 Equipment Insurance - Liability Insurance $ - - $ - Mapping / G IS Systems $ 3,000.00 $ 3,000.00 - 0.0% Memberships / Oues $ 3,10100.00 16,000.00 13,10100.00 433.3% Office Equipment/ Supplies 5,5100.00 5,500.00 $ - 0.0°x6 Professional Services 100,0100.00 100,000.00 - 0.0% Water Department FY23 Final Budget FY24 Draft Budget $ Change % Change 31-4353-25f7 Shop Facility Lease $ 1,000.00 1,000.00 $ - 0.0% 31-43S3-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,nao.00 13.39 31-4353-290 Utiltiy - Electrical $ 5,500.00 10,000.00 $ 4,500.00 81.89 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) -85.7% 31-4353-320 Pard Facility Construction $ 7,000.00 7,000.00 $ - 0.0% 31-4353-330 Yard Facility Operations $ 10, 00.00 10,000.00 $ - 0.0% 31-4360-190 CSC Sampling & testing $ 416,500,00 $ 489,000.70 $ 72,500.00 17.49 Production & Storage 31-4360-100 Well head protection $ - - $ - 31-4360-110 Building Maintenance & operation $ 1,000.00 13,000.00 $ 12,000.00 1200.09 31-4360-120 Sc.ada M&O $ 12,0 70.00 12,000.00 $ - 0.0% 31-4360-130 Electrical motor M&O $ - - $ - 31-4360-140 pump M&O $ 82,900.60 48,000.00 $ (34,900.00) -42.1% 31-4360-150 Well Equipment M&O (Daily well $ 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,(00.00 25,500.00 $ 10,500.00 70.0% 31-4360-180 Treatment Chemical $ 15,(00.00 5,000.00 (10,000.00) -66.7% 31-4360-190 CSC Sampling & testing $ 6,000.00 20,000.00 $ 14,000.00 233.39 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. 70 $ (8,5 70.00) -77,3% 31-4360-229 DEQ Assesment $ 34,000.00 34,000.00 $ - 0.0% $ 353,9{70.00 372,000.00 $ 18,100.00 5.1% Water Department [Distribution System 31-4361-100 31-4361-110 31-4361-120 31-4361-130 31-4361-140 31-4361-150 31-4361-160 Piping M&Q Valve M&O Valve Replacement System Improvements Digline (locates) Capital Planning Line Flushing 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 31-4363-110 31-4363-120 Pressure Irrigation 31-4364-100 31-4364-110 31-4364-120 31-4364-130 31-4364-140 FY23 Final Budget FY24 Draft Budget $$$ Change % Change $ 22,000.00 $ 42,000.00 5 20,000.00 90.9% $ 15,000.00 0.0% 5,000.00 (10,000,00) -66.7% 4,000.00 $ 4,000.00 $ - 0.0% $ 50,000.00 50,000.00 0.0% $ 1,500.00 $ 2,000.00 $ 500,00 33.3% $ 1,669,800.00 $ 1,669,800.00 5 - 0.0% $ 5,000,00 $ - $ (5,000,00-) -100.0¢/. 1,767,300.00 $ 1,772,800.00 5,500.00 0.3% 1,000.00 $ 2,500.00 $ 1,500.00 150.0% 5 1,800.00 12.5% 2,000.00 $ 200.00 11.1a $ 45,000.00 $ 60,000.00 5 15,000.00 33.3% $ 2.5,000.00 $ 10,000.00 $ (15,000,00) -60.0% 72,800.00 $ 74,500.00 $ 1,700.00 2.3% Fire Hydrant M O $ 15,000.00 $ 15,000.00 $ - 0.0% Fire Hydrant Replacement 10,000.00 $ 10,000.00 $ - 0.036 Storz Fittings $ -- $ 2.5,000.00 $ 25,000.00 $ - 0.0% Pump M&O $ 15,000.00 5,000.00 $ (10,000.00} -66,7% Electrical power S 2,000.00 $ 7,500.00 5,500,00 275.0% System M&O $ 80,000,00 $ 90,000.00 $ 10,000.00 12.5% Digline (Locates) $ 1,000.00 $ 1,500.00 $ 500.00 50.0% Fart Nall - Water Rights $ 35,000.00 $ 38,000.00 $ 3,000.00 8.6% 5 133,000.00 $ 142,000.00 9,000.00 6.8% Water Department FY23 Final Budget PY24 Draft Budget $$$ Changes % Change Additional S=ervice 31-4370-100 Meter Can Adjustments $ - � - 31-4370-110 Special burn on-off - $ - 31-4370-12-7 Contractor Testing Assistance $ - $ - 31-4370-130 Interagency Services $ - $ - Equipment Expenses Training 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 Training 31-4381-110 Clothing 31-4381-120 Equipment 31-4381-130 Testing Debt Service 31-4390-812 Bonds and Interest 31-4390-813 dotes and Interest 10,000.00 202,000M 5,000.00 $ -mm 33,000.00 $ 33,000.00 $ - 0.0% 5,000m 0.0% 10,000.00 2,500M 5,000.00 100.0° 125, 00.00 S00.00 25,000.00 $ (100,000.00) -80 O% 24,000..00 $ 25,000.00 $ 1,000.00 4.2% 3,000.00 1,300.00 10,000.00 $ 7,000.00 233.3% 2,000.00 2,000.00 $ - 0.0% 202,000M 110,000.00 (92,000.00) 45.5°6 $ 1,500.00 1,500.00 $ - 0.0% $ 2,500M 3,010.00 $ S00.00 20.0% 2,000.00 2,000.,70 $ - 0.0° 1,000.00 1,300.00 300.00 30.0% $ 7,000M 7,800.00 $ 800.00 11.4% $ 600,000.00 725,000.00 125,000.00 20.8% $ 25,000..00 25,000.00 - 0.0% $ 625,000.00 7SO,000.00 125,000.00 20.0% Water Dept. Capital Equipment Summary Item FY23 FY24 FY25 FY26 FY27 Hydro -Excavator (split w/Wastewater) $75,000.00 Backhoe (split w/Wastewater) $115,000.00 Jet Truck (split w,/Wastewater) $115,000.00 CL Total $75,000.00 $0.00 50.00 5115,000.00 $115,000.00 W Source of Funds W Fund Balance $75,000.00 $115,000.00 $115,000.00 Total $75,000.00 $0.00 $0.00 $115,000.00 $115,000.00 Balance $0.00 50.00 $0.00 $0.00 $0.00 Water Dept. Capital Projects Request Summary Item FY24. FY25 FY26 FY27 FY28 1A - 16" Line New Day to Buffalo $76,900.00 1B -16" Line Buffalo to Tyhee $156,0DO.00 1H -18" Line Tank to Booster (across 1-15) $82,OOD.00 2E - Well 7 Complex $1,157,6DD.00 $2,894,ODD.00 $1,736,4DDAO 2G - Bench Boaster Improvements $47,40D.00 $189,60D.00 ��# G W RR - Repair and Replacement $1,600,ODO.00 $1,6DO,000.00 $1,600,000.00 $1,6D0,000,0c, 2B -16" Line Well 6 to Philbin (Siphon Road) $32,000.00 $128,00D.00 2C - 16" Line Angela to Siphon (Philbin Road) $33,000.DO $132,000.00 CL 1G -16" Line Canal to Siphon in Rio Vista $118,o00.0u W 2D -16" Line Philbin to Rio Vista (Siphon road) $58,400.00 $233,600.00 I.1, Total $1,519,800.00 $4,715,6DD.00 $3,497,4DWDO $1,790,400.00 $1,951,60D.00 Source of Funds Rate Funded Capital $82,OOD.00 $84,000.00 $87,00O.D0 $89,000.DO Fund Balance $120,8DO.00 $1,480,ODO.00 Water Capacity Fees $1,317,ODD.00 $1,224,6DO.00 $765,OOD.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,6DO.00 $3,497,400.00 $1,790,400.00 $1,951,600.00 Balance $0.00 $O.OD $O.OD $0.00 $0.00 Existing water rights are sufficient until a population of ;40.444 unless , per capita water use continues to increase. Cit should oontlnu practice of Y obtaining additional rights with additional annexations. E f � r E. 7....... J - .. 7— Elio IL r5 Yii����e4.a l 5..1.11. Tyhee Rd. ■...............11.Emir 1 i .... IN DARY ; # }WITP OViLMertt�2E •.Y1.11.11 X11.11.11 ■ - 6 a o x v tW F of, 11 W A01 11 LLJ 11 Developer Well �^ _j z (By" t�Developer} W Y °' - i '-.V•1...•�11�11.1 ��.......11.11..1N�ia-. n -_• Jmprovement 3C m ��y!•1.....11�111 - 11.11. 11.11.1........ YF L A 16 d Q Ex E 47 4 CL E PIOURE MO. Water Dept. Personnel Request Summary Position FY23 FY24 FY25 FY26 FY27 z Water Wastewater Technician 1 (0.5 FTE) S 21,500.00 W Water j Wastewater Technician I (4.5 FTE) 24,250.00 W W Total 24,250.00 Wastewater Department 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% a Debt Service $0.00 $0.00 $0.00 W ItY Total Planned Expenses $3,673,000.00 $6,364,000.00 $2,691,000.00 73.3% W Q W NExpenses Capital Equipment (included in Operational above) $0.00 $0.00 $0.00 Capital Projects (included in Operational Expenses above) $0.00 $3,039,000.00 $3,039,000.00 Expenses Exceeding Revenue $167,000.00 $2,643,000.00 $2,476,000.00 Source of Funding for Overage 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 Line Item Budget Summary FY23 Final Budget FY24 Proposed Budget $$$ Change % Change Wages & Benefits $914,400.00 $1,031,700.00 $117,300.00 12.83% Administration $440,500.00 $442,700.00 $2,200.00 0.50% Collection System and CIP $287,500.00 $187,000.00 -$100,500.00 -34.96% a Treatment / Pretreatment $1,600,800.00 $1,600,800.00 $0.00 0.00% a, W Pumping and CIP $363,000.00 $3,000,000.00 $2,662,000.00 733.33% 7i r - Additional Service $15,000.00 $0.00 -$15,000.00 -100.00% M a, CL O Equipment Expenses $47,000.00 $95,000.00 $48,000.00 102.13% Safety $4,800.00 $6,800.00 $2,000.00 41.67% Debt Service $0.00 $0.00 $0.00 Total $3,688,000.00 $6,364,000.00 $2,676,000.00 72.56% Equipment Expenses 2% Additional Service 0% Pumping and CIP 47 Safety -Debt Service 0/ 0% Wages & Benefits 16% Administration 7% Collection System and CIP 3% Treatement / Pretreatment 25% Wastewater Department Wages & Benefits 32-4351-110 32-4351-111 32-4351-210 32-4351-220 32-4351-240 32-4351-250 32-4351-260 Administration 324353-100 32-4153-110 32-4353-120 32-4353-130 32-4353-140 32-4353-150 32-4353-160 32-4353-170 324353-180 32-4353-190 32-4353-200 32-4953-210 32-4353-220 32-4353-230 32-4353-240 32-4353-250 32-4353-260 32-4353-270 32-4353-280 Salaries Overtime FICA Retirement Workmens Compensation Health Insurance U nemploy rnent Billing Expense Certifications / Licensing City Hall Lease City Hall Operations Computer/ I.T. Harda Computer/ I.T. Softwar Employee Contunuing E Employee Rhone Stipen Employee Recognition Equipment Insurance Liability Insurance Mapping / GIS Systems Memberships/ Dues Office Equipment /Supl Professional Services Shop Facility Lease Training/ Seminars Travel Utility - Telephone FY23 Final Budget FY24 Draft Budget $ Change '°iso Change 31,000.00 5g4r200.00 $ 665,500.00 $ 81,300.00 1S.9% $ 6200.00 5 6,200.00 20,000.00 - 0.0 $ 45,500.00 $ 48,000.00 $ 2,500.00 5.5 $. 74,100.00 $ 77,000,00 $ 2,900.00 3.9% $ 17,300.00 $ 22,500.00 5,200.00 80.1% 8,000.00 Iv,100.00 $ 212,500.00 $ 25,400.00 13.6% $ $ $ 1,500.00 $ 914,400.00 $ 1,031,700.00 $ 117,300.00 12.83% 31,000.00 $ 31,000.00 $ 15,000.00 $ 15,000.00 $ 165,000.00 $ 165,000.00 $ $ 3,000.00 $ 20,000.00 $ 20,000.00 $ 47,000.00 $ $ 17,000.00 $ 45,000.00 $ $ 1,500.00 $ 1,500.[10 $ $ 1,500-.00 $ 1,500.00 $ 3500.00 $ 8,000.00 $ 1000.00 $ 1,000.00 $ 2,500.00 $ 3,700.00 125,000.00 50,000.00 $ $ 1,500.00 $ 1,500.00 $ 500.00 $ 1,000.00 $ 6,500.00 $ 7,500.00 - 0.00% - 0.006 - 0.00% 17,000.00 566.67 27,000.00 135.00% 28,000.00 164.71 - 0.00% - 0.00% 4,500.00 1,200.00 (75,000.00) 500.00 1,000.00 128.57% 0.00% 48.01.1°r& -60.00° 0.00% 100.00°/0 15.38% Wastewater Department PY23 Final Budget FY24 Draft Budget Change Change 32-4153-290 Utiltiy - Electrical $ 4,500.00 $ 6,500,00 32-4361-130 2,000,170 44.44% 32-4353-300 Utiltiy - Natural Gas $ 9,500.00 $ 10,500,00 3,500,00 1,000,00 10.53% 32-4353-310 Facility MaintenancefJanito $ 15,000.00 $ 10,000,00 $ (5,000,00) -33,33% 32-4353-320 Pard Facility Construction (101,000,00) -35,94% 7,000.00 $ 7,000,00 187,000.00 - 0.00% 32-4353-330 Yard Facility Operations 10,000.00 $ 10,000,00 - 0.001 $ 440,500.00 5 442,700,00 2,200,00 0.501 Collection System 32-4360-100 32-4360-110 32-4360-120 32-4360-130 32-4360-140 System Maint (lines) System Maint (lift Stations) System improvements Digline (locates) System Capital planning Tre.atement J Pretreatment 32-4361-100 QC sarnplling/'testing 32-4361-110 Treatment (Pocatello) 32-4361-120 Inspections 32-4361-130 ,Applications f Approvals Pumping 324362-100 32-4362-110 324362-120 32-4362-130 324362-140 32-4362-150 $ 500.00 $ 500,00 $ - 0.00% $ 500.00 $ 500.00 Electrical power - 0.00% $ 3,500.00 $ 3,500,00 $ - 0.00% $ 2,000.00 Building and grounds M&O 2,500,00 $ 500,00 25.00% $ 251,000.00 $ 18'0,000,00 $ (101,000,00) -35,94% $ 257,500.00 187,000.00 (100,500,00) -34,96'°1 $ 500.00 $ 500,00 $ 1,600,000.00 15,000,00 1,600,000,00 300.00 $ 300,00 $ 15,000,00 Electrical power $ $ 1,6001500,00 $ 1,500,800,00 Electrical Motor M&O $ 25,000.00 $ 15,000,00 Pumping Equipment M&O 30,000.00 $ 15,000,00 Electrical power $ 20,000.00 $ 28,000,00 Scada $ 10,000.00 $ 10,000,00 $ Building and grounds M&O $ 5,000.00 $ 20,000.017 $ Capital Planning $ 273,000.00 $ 2,912,000,00 $ - 0.001 - 0.1701 5,000,170 15,000,{70 2,639, 000,170 0.001 0.00% 0.00% 0�.'00 01�jj 3DO.00 f0 966.67% $ 3631000.00 $ 3,000,000,017 $ 2,662,000,170 733.33% Wastewater Department FY23 Final Budget FY24 Draft Budget $$$ Change % Change AddiitionaI Service 32437-0-100 Contractor Ass 1stance - - - 324370-110 Interagency Services 15,000.00 $ - $ (15,000.0 ) -100.00% 15,000.00 - (15,DOO.0C7) -100.,00% Equipment ExRenaes 32-4380-100 Pickup Repair and Maint $ 500.00 $ 5,000.00 4,500.00 9DO.00% 32-4380-110 Large truck Repair and Maint $ 500.00 $ 25,000.00 $ 24,500,00 49DO.00% 324380-120 Heavy equipment Repair & Maint $ 1,000.00 $ 1O,DOO.DO 9,D0O.00 9DO.00% 32-4380-130 TRIC & Equipment Capital Planning 25,000.00 $ 25,DOO.DO - 0.00% 3243807-140 Fuel & Lubricants 15,000.00 $ 25,000.00 $ 1O,D0O.O0 66.67% 324380-150 Small Tools & equipment $ 5,000.00 $ 5,000.00 $ - 0.00% 47,000.00 $ 95,000.00 $ 48,000.0707 102.13% Safety 32-4381-100 Training $ 500.00 $ 1,500.00 1,DOO.0-0 2D0.00% 32-4381-110 Clothing $ 2,000.00 $ 2,DOO.DO - 0.00% 32-4381-120 Equipment $ 2,000.00 $ 2,000.00 - 0.00% 32-4381-130 Testing $ 300.00 $ 1,300.00 1,000.007 333..33% $ 4,800.00 $ 6,8OO.DO $ 2,D0O.O07 41.67% Debt Service 31-4390-812 Bonds and Interest - $ - - 31-43907-813 Notes and Interest - $ - $ - Wastewater Dept. Capital Equipment Summary z Item FY23 FY24 FY25 FY26 FY27 W Hydro -Excavator (split w/Water) $ 25,000.00 Backhoe (split w/Water) $ 20,000.00 Jet Truck (split w/Water) $ 225,000.00 Ui Total $ 25,000.00 $ - $ - $ 20,000.00 $ 225,000.00 W Source of Funds Fund Balance$ 25,000.x]0 $ 20,000.00 $ 225,000.00 LU Total $ 25,000.00 $ - $ - $ 20,000.00 $ 225,000.00 Total .$ $ - $ Wastewater Dept. Capital Projects Request Summary Item FY23 FY24 FY25 FY26 FY27 z Valenty Lift Station Upgrade 112,000.00 $ 1,676,000.00 Uj CCTV Evaluation $ 123,000.00 $ 127,000.00 $ 130,000.00 $ 135,000.00 Ellis Lift Station Upgrade $ 61,000.00 913,000.00 Gravity Sewer Rehabilitation - Phase 1 $ 323,000.00 $ 1,064,000.00 $ 1,095,000.00 $ 1,128,000.00 Total 296,000.00 $ 3,039,000.00 $ 1,194,000.00 $ 1,230,000.00 $ 1,128,000.00 Source of Funds Operations Budget $ 296,000.00 W Capacity Fund Balance & Ca p Fees $ - s 3,0 :39 000.00 0 Revenue Bands - New Debt $ 1,194,000.00 $ 1,230,000.00 $ 1,128,000.00 Total $ 296,000.00 $ 3,039,000.00 $ 1,194,000.00 $ 1,230,000.00 $ 1,128,000.00 Total $ - $ $ - $ - $ - Wastewater Dept. Personnel Request Summary Uj Position FY23 FY24 FY25 FY26 FY27 W Water f Wastewater Technician 1 (0.5 FTE) $ 21,500,00 Water j Wastewater Technician 1 (0.5 FTE) $ 24,250.00 CL W W W Total 21,5E?L?.i�i] 24,250.00 .� a� r City of Chubbuck Fiscal Year 2024 Wage, Wage Related, Obligated, Operations Fund 10 GEN General Budget Wage Wage Rel Obligated Operations Total 9,782,813 LG Legislative 0 36,000 83,400 0 0 119,400 EX Executive 0 42,500 26,000 0 0 68,500 CK Clerk 0 0 0 0 0 0 FN Financial 0 0 12,500 0 0 12,500 LL Legal 0 62,000 31,700 0 0 93,700 GV Other General Governmen 0 0 0 0 0 0 LE Law Enforcement 0 2,529,100 1,291,400 0 0 3,820,500 FC Fire Control 0 1,269,000 574,450 0 0 1,843,450 IT Information Technology 0 0 0 0 0 0 HR Human Resource 0 0 57,000 0 0 57,000 SW Storm Water 0 0 0 0 0 0 CS Community Serivices 0 668,000 330,700 0 0 998,700 GA Other General Governmen 0 0 0 0 0 0 9,782,813 4,606,600 2,407,150 0 0 2,769,063 Wage Rel Operations Total Budget Wage Obligated Fund 11 HSR Highway Streets and Roads 535,000 298,600 833,600 Fund 31 WW Water 740,800 441,000 1,181,800 Fund 32 SW Wastewater 626,200 357,200 983,400 Fund 33 SN Sanitation 631,000 397,100 1,028,100 Total Budget 0 7,139,600 3,901,050 0 0 9,782,813 City of Chubbuck Budget Worksheet Page: 1 Periods: 00123.14124 Feb 21, 2023 08:51 AM 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= "1 0411 1 1 1 0""104112694" Account Number Account Title NON -BUSINESS LICENSES LEGISLATIVE 13,825 10-4111-110 LG Salaries 10-4111-111 LG Overtime 10-4111-210 LG FICA 10-4111-220 LG Retirement 10-4111-240 LG Workers' Compensation 10-4111-250 LG Health Insurance 104112-370 LG Travel, Meetings & Other 10-4112-480 LG Dues 104112-490 LG Grant Consulting 10.4112-491 LG Feasability Study 10.4112-693 LG Land Use Compensation 10-4112-694 LG Legal Total LEGISLATIVE: GENERAL FUND Revenue Total: GENERAL FUND Expenditure Total: Net Total NON -BUSINESS LICENSES: Net Grand Totals: 2022-23 2022-23 2023-24 Modification Cur Year Cur Year Fut Year Budget Actual Budget 33,.000 13,825 36,000 .00 .00 .00 2,500 1,058 2,700 4,000 1,651 4,400 250 93 300 67,000 25,433 76,000 5,200 .00 .00 6,500 6,228 .00 .00 ,00 .00 .00 .00 .00 700 170 .00 .00 oo .00 119,150 48,457 119,400 .00 .00 .00 119,150 48,457 119,400 119,150- 48,457- 119,400- City or Chubbuck Budget Worksheet Page: 1 Periods: 00/23-14124 Feb 29, 2023 08:52AM 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= "104131110"-"104133280" Account Number Account Title NONBUSINESS LICENSES EXECUTIVE 2022-23 10-4131-110 EX Salary 10-4131-111 EX Overtime 10-4131-210 EX FICA 10-4131-220 EX Retirement 10-4131-240 EX Workers' Compensation 10-4131-250 EX Health Insurance 10-4131-260 EX Unemployment 10-4131-310 EX Office Equipment/Supplies 10-4131-759 EX Phone Stipend 10-4132-370 EX Travel, Meetings & Other 10-4132.371 EX Crossing Guards 10-4132-372 EX Employee Recognition 10-4133-280 EX Phone Total EXECUTIVE: GENERAL FUND Revenue Total: GENERAL FUND Expenditure Total: Net Total NON -BUSINESS LICENSES: Net Grand Totals: 2022-23 2022-23 2023-24 Cur Year Cur Year Fut Year Budget Actual Budget 40,000 15,156 42,500 .00 .00 .00 3,000 1,207 3,200 5,000 1,925 5,100 .00 .00 .00 15,600 3,823 17,700 .00 .00 .00 500 .00 .00 .00 .00 .00 2,000 63 .00 .00 .00 ,00 .00 ,00 ,00 500 ,00 .00 66,600 22,276 68,500 .00 .00 .00 66,600 22,276 68,500 66,600- 22;278- 68,500 - Modification City of Chubbuck Budget Worksheet Page: 1 Periods: 00123-14124 Feb 21, 2023 08:63AM 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= "104142280""104142761" Account Number Account Title NON -BUSINESS LICENSES CLERK 10-4142-280 CK Phone 10-4142-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: Net Grand Totals: 2022-23 2022.23 2023-24 Cur Year Cur Year Fut Year Budget Actual Budget .00 .00 .00 9,200 .00 .00 .00 .00 .60 .00 .00 .00 .00 216 .00 9,200 216 .00 .00 .00 .00 9,200 216 .00 9,200- 216- .00 9,200- 216- .00 Modification City of Chubbuck Budget Worksheet Page: 1 Periods: 0012 3-1 4124 Feb 21, 2023 08:54AM 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 m "1 04151110%"104155280" Account Number Account Title NON -BUSINESS LICENSES FINANCIAL .00 10-4151-110 FN Salaries 10-4151-111 FN Overtime 10-4151-210 FN FICA 104151-220 FN Retirement 10-4151-240 FN Workers' Compensation 10-4151-250 FN Health Insurance 10-4151-260 FN Unemployment 10-4151-340 FN Office Equip & Maint 10-4152-280 FN Phone 10-4152-310 FN Office Equipment/Supplies 10-4152-345 FN Computers 10.4152.370 FN Travel, Meetings & Other 10.4152-480 FN Dues 10-4152-490 FN Miscellaneous 10-4152-761 FN Clothing 10-4152-860 FN Lease Capital Outlay 10-4152-862 FN Lease Financing Expense 10-4152-864 FN Lease Interest Expense 10-4153-312 FN Elections & Supplies 10-4153-759 FN Phone Stipend 10-4153.800 FN Capital Planning 10-4154-300 FN Human Resource 10-4155-280 UB Phone Total FINANCIAL: GENERAL FUND Revenue Total: GENERAL FUND Expenditure Total: Net Total NON -BUSINESS LICENSES: Net Grand Totals: 2022-23 2022-23 2023-24 Cur Year Cur Year Fut Year Budget Actual Budget .00 .00 .00 .00 A0 .00 .00 .00 .00 .00 ,00 .00 .00 .00 .00 11,000 4,052 12,500 .00 .00 .00 3,000 299 .00 1,000 .00 .00 22,500 2,982 .00 14,945 18,058 .00 3,500 1,607 ,00 600 ,00 ,00 500 2- .00 .00 AO .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 ,00 .00 .00 .00 ,00 .00 .00 .OD .00 .00 57,045 26,995 12,500 .00 .00 .00 57,045 26,995 12,500 57,045- 26,995- 12,500- 57,045- 26,995- 12,500- Modification City of Chubbuck Budget Worksheet Page: 1 Periods: 00123.14/24 Feb 21, 2023 08:55AM 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.Aocount Number = "104160110"-"104160681" Modification 2022-23 2022-23 ,2023-24 Cur Year Cur Year Fut Year Account Number Account Title Budget Actual Budget NON -BUSINESS LICENSES LEGAL 10-4160-110 LL Salaries 50,000 4,223 62,000 10-4160-111 LL Overtime AO .00 .00 10-4160-210 LL FICA 4,500 311 4,700 10-4160-220 LL Retirement 7,000 536 7,500 10-4160-240 LL Workers' Compensation 00 .00 .00 10-4160-250 LL Health Insurance 17,000 2,141 19,500 10-4160-260 LL Unemployment .00 .00 .00 10-4160-310 LL Office Supplies 9,200 ,00 .00 10.4160-320 LL Office Equipment & Malnt .00 .00 .00 10-4180-330 LL Phone .00 432 .00 10-4160-340 LL Computers .00 .00 .00 10-4160-350 LL Travel,Training & Other .00 .00 .00 10-4160-360 LL Dues .00 ,00 .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 ALL Pub., Recording, etc. 6,500 1,110 .00 10-4160-6B0 LL Codification 7,000 5,372 .00 10-4160-681 LLSAUSA 1,500 1,108 .00 Total LEGAL: 135,700 15,234 93,700 GENERAL FUND Revenue Total: .00 .00 .00 GENERAL FUND Expenditure Total: 135,700 15,234 93,700 Net Total NON -BUSINESS LICENSES: 135,700- 15,234- 93,700 - Net Grand Totals: 135,700- 15,234- 93,700 - Modification City of Chubbuck Budget Worksheet Page: 1 Periods: 00123-14124 Feb 21, 2023 08:56AM 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 m "104191210"2104195700" 2022-23 2022-23 2023-24 Modification Cur Year Cur Year Fut Year Account Number Account Title Budget Actual Budget NON -BUSINESS LICENSES 185,000 84,330 .00 OTHER GENERAL GOVERNMENT .00 00 .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.4192450 GV Printing .00 .00 .00 10-4193-240 GV Workers' Compensation .00 .00 .00 10-4193-250 GV Health Insurance .00 ,00 .00 10-4193-415 GV Website M & 0 .00 .00 .00 10-4193-460 GV General insurance 185,000 81,436 .00 10-4194-510 GV Telephone .00 .00 .00 10-4194-520 GV Electric .00 .00 .00 10-4194-521 GV SNMIWISW 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 2,175 .00 10-4195-601 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 10-4195-604 GV 216 Highway Ave .00 .00 .00 10-4195-605 GV 234 Highway Ave .00 .00 .00 10-4195-606 GV 12582 N Ric 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 104195-613 GV 304 Highway Ave .00 .00 .00 10-4195-615 GV 156 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 84,330 .00 GENERAL FUND Revenue Total .00 00 .00 GENERAL FUND Expenditure Total: 165,000 84,330 .00 Net Total NON -BUSINESS LICENSES: 185,000- 84,330- ,00 Net Grand Totals: 185,000- 84,330- .00 City of Chubbuck Budget Worksheet Page: 1 Periods: 00123-14/24 Feb 21, 2023 08:57AM 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" Account Number Account Title NON -BUSINESS LICENSES LAW ENFORCEMENT 10-4211-110 LE Salaries 10.4211-111 LE Overtime 10.4211-210 LE FICA 10-4211-220 LE Retirement 10-4211-230 -LE Incentives 10-4211-240 LE Workers' Compensation 10-4211-250 LE Health Insurance 10-4211-260 LE Unemployment 10-4211-420 LE Legal 10.4215-203 LE Community Police Grant 10-4215-207 LE Juvenile Defferal 10-4215-300 LE Interagency Services 10-4215-310 LE Office supplies 10-4215-311 LE Forms, Citations 10-4215-314 LE Film Purchase 10-4215-315 LE Paper; Copy, etc. 10-4215-316 LE Misc Dues, Fees, Subsoripti 10.4215-317 LE Employment Costs 10.4215-331 LE Firearms 10-4215-333 LE Patrol New Purchases 10-4215-334 LE Patrol Equipment Repair 10-4215-335 LE Detective 10-4215-336 LE Evidence Supplies 10-4215-339 LE Office Equipment 10-4215,340 LE Office Equip Repair 10-4215-341 LE Computer Purchase 10-4215-342 LE Computer Repair 10.4215-343 LE Computer Consult 10-4215-345 LE Computer Contracts 10.4215-370 LE Meetings, School 10-4215-371 LE Training Lodging 10-4215-372 LE Training Per Diem 10-4215-373 LE Training Traver 10-4215-420 LE Legal 10.4215-422 LE Court 10-4215-602 LE Miscellaneous 10-4215-650 LE Animal Shelter Operations 1 Q4215-651 LE Animal Control Donations 10-4215-652 LE Animal Shelter Building 10.4215-653 LE MedicallHospital 10-4215-759 LE Phone Stipend 10-4215-761 LE Clothing Allowance 10-4215-762 LE Clothing Allowance Non -Swot 2022-23 2022-23 2023-24 Modification Cur Year Cur Year Fut Year Budget Actual Budget 2,285,000 793,597 2,422,100 12,785 43,286 107,000 180,000 66,180 189,000 295,000 108,228 355,000 .00 .00 .00 65,000 30,666 92,000 580,000 224,308 655,400 .00 499 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 00 .00 3,500 1,835 ,00 1,500 26 ,00 .00 .00 .00 2,000 791 .00 6,000 5,017 .00 2,500 1,096 .00 10,000 .00 .00 8,450 8,023 .00 4,300 .00 .00 2,750 800 .00 4,500 173 .00 .00 .00 .00 2,500 637 .00 50,000 21,317 .00 .00 .00 ,00 5,000 .00 .00 43,000 32,465 .00 5,000 5,847 .00 13,000 3,248 .00 11,000 341 ,00 13,000 292 .00 82,000 35,000 .00 .00 .00 .00 4,500 1,566 .00 3,000 703 ,00 .00 9o- .00 ,00 .00 .00 .00 .00 .00 .00 .00 .00 12,000 2,090 .00 2,000 2,170 .00 City of Chubbuck Budget Worksheet Periods: 00/23-14124 Modification Page: 2 Feb 21, 2023 08:57AM 2022-23 2022-23 2023-24 Cur Year Cur Year Fut Year Account Number Account Title Budget Actual Budget 1074215-830 LE Building Remodel/Addition .00 206 .00 Total LAW ENFORCEMENT: 3,709,285 1,390,318 3,820,500 LAW ENFORCEMENT 10-4222-510 LE TelephonelRepair 35,000 14,053 .00 10-4222-630 LE RadiolRepair 1,200 300 .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 Bell Grant .00 .00 .00 10.4223-219 LE SpiAman Grant .00 .00 .00 104223-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 21,183 .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 3,567 .00 10-4229-521 LE Carpentry .00 .00 .00 10-4229.522 LE Natural Gas 2,000 7,228 .00 10-4229.523 LE Carpentry .00 .00 .00 10-4229-600 LE Building MainttFumace 10,000 4,370 .00 10.4229-610 LE Vehicle Repair 18,500 5,808 AO 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 CarLeaselPurchase 80,000 .00 .00 Total LAW ENFORCEMENT: 520,215 67,292 :00 GENERAL FUND Revenue Total: .00 .00 .00 GENERAL FUND Expenditure Total: 4,329,500 1,457,610 3,820,500 Net Total NON -BUSINESS LICENSES: 4,329,500- 1,457,610- 3,820,600 - Net Grand Totals: 4,329,500- 1,457,610- 3,820,500 - Modification Page: 2 Feb 21, 2023 08:57AM City of Chubbuck Budget Worksheet Periods: 00/23-14124 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 = "1 0423111 0""104238801" 2022-23 2022-23 2023-24 Modification Cur Year Cur Year Fut Year Account Number Account Title Budget Actual Budget NON -BUSINESS LICENSES FIRE CONTROL & PREVENTION 10-4231-110 FC Salaries 1,025,000 367,157 1,087,000 10-4231-111 FC Salaries OT 101,000 34,875 101,000 10-4231-112 FC Salaries Work Out Of Class .00 .00 .00 10-4231-115 FC Salaries Paycall 81,000 20,095 81,000 10-4231-210 FC FICA 79,000 32,138 68,500 10-4231-215 FC FICA Paycall 6,000 1,637 6,000 10-4231-220 FC Retirement 136,726 52,555 158,000 10-4231-240 FC Workers' Compensation 30,000 12,875 39,000 10-4231-245 FC Workers' Camp Paycall 12,000 5,098 15,300 10-4231-250 FC Health Insurance 231,650 90,846 262,650 10-4231-255 FC Health Insurance Paycall 5,000 1,448 5,000 10.4231-260 FC Unemployment .00 .00 .00 10.4231-265 FC Unemployment Paycall .00 .00 .00 104231-300 FC Interagency Services .00 .00 .00 10-4231-310 FC Office Supplies 5,492 729 .00 10-4231-345 FC Computer Software 69,500 19,991 .00 10-4231-347 FC Dues 4,000 290 .00 10-4231-517 FC Vaccine & Testing 5,000 .00 00 10-4231-519 FC Physical Exams 13,000 4,825 .00 10-4231,520 FC Electrical Power 7,500 2,064 .00 10-4231,522 FC Natural Gas 3,200 2,049 .00 104231-600 FC Building Maintenance 18,500 1,583 .00 10-4231-730 FC Building Remodel/Addition .00 .00 .00 10-4231-740 FC Safety 5,000 .00 .00 10-4231-770 FC Debt Service .00 .00 .00 10-4231-771 FC Interest Expense 00 .00 .00 104231-801 FC EMS Grant .00 .00 .00 10-4231-802 FC Dedicated Grants .00 .00 .00 10-4231-803 FCASPRGrants .00 .00 .00 10-4231-900 FC EMS 5,000 123 .00 10-4231-901 FC EMS Improvements .00 .00 .00 10-4235-510 FC Telephone 7,500 3,074 .00 10-4235-630 FC Communications 3,000 .00 .00 10-4235-632 FC Radio Now .00 .00 .00 10-4236-370 FC Training 14,262 6,303 .00 10.4236,371 FC Continuing Education 738 245- .00 10-4236-375 FC Prevention 5,000 1,696 .00 10-4236-376 FC Prevention Grants .00 .00 .00 10-4236-377 FC Pre -Fire Pians .00 .00 .00 10-4236-379 FC Supplies 7,000 1,773 .00 10-4236-360 FC Fire Meals 3,000 .00 .00 10-4236-759 FC Phone Stipend .00 .00 ,00 10-4236-761 FC Uniforms 9,500 582 .00 Page: 1 Feb 21, 2023 01:50PM City of Chubbuck Budget Worksheet Page: 2 Periods: 00123-14/24 Feb 21, 2023 01;59113M Account Number Account Title 10-4236-763 FC Drug Testing 10-4237-350 FC Fuel 10-4237-610 FC Equipment Maintenance 10-4237-611 FC Vehicle Maintenance 10-4237-661 FC SCBA 10.4237-670 FC Grant Purchase 10-4238-369 FC Equipment 10-4238-392 FC Protection 10-4238-700 FC COVID 19 10-4238-800 FC Capital Planning 10-4238-801 FC Lease Airial Total FIRE CONTROL & PREVENTION: GENERAL FUND Revenue Total: GENERAL FUND Expenditure Total: Net Total NON -BUSINESS LICENSES: Net Grand Totals: 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"2104238801" 2022-23 2022-23 2023-24 Cur Year Our Year Fut Year Budget Actual Budget 1,500 22,000 14,500 16,500 30,000 .00 25,545 25,000 .00 .00 117,000 2,145,613 .00 2,145,613 98 .00 4,214 .00 1,824 .00 5,295 00 .00 .00 X0 '00 818 .00 5,486 .00 .00 .00 .00 .00 .00 .00 681,299 1,843,450 .00 .00 681,299 1,843,450 2,145,613- 681,299- 1,843,450- 2,145,613- 681,299- 1,843,450 - Modification City of Chubbuck Budget Worksheet Page: 1 Periods: 00123-14!24 Feb 21, 2023 02:22PM 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"2104250800" Account Number Account Title NON -BUSINESS LICENSES INFORMATION TECHNOLOGY 10-4250-339 IT Office Equipment 10-4250-340 IT Office Equip Repair 10-4250.341 IT Computer Purchase 10.4250.342 IT Computer Repair r 10-4250-345 IT Computer Contracts 10-4250-346 IT Computer Contracts - Sollus 10-4250-348 IT Software 10-4250-350 IT Fuel 10-4250-360 IT Small ToolslEquipment 10-4250-370 IT Training 10-4250-415 IT Website M & O 10-4250-416 IT Hardware 10-4250-800 IT Capital Planning Total INFORMATION TECHNOLOGY: GENERAL FUND Revenue Total: GENERAL FUND Expenditure Total: Net Total NON -BUSINESS LICENSES: Net Grand Totals: 2022-23 2022-23 2023-24 Cur Year Our Year Fut Year Budget Actual Budget 1,500 .00 - .00 .00 .00 .00 25,000 .00 .00 20,000 .00 .00 6,500 .00 .00 25,000 .00 .00 32,500 .00 .00 .00 .00 .00 .00 .00 .00 6,000 594- .00 .00 2,543 .00 .00 .00 .00 1,500 .00 .00 118,000 1,949 .00 ,00 .00 .00 118,000 1,949 .00 118,000- 1,949- .00 118,000- 1,949- .00 Modification City of Chubbuck Budget Worksheet Periods: 00/23-14124 Report Criterla: 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 = "104260110%"l 04261280" Modification Page: 1 Feb 21, 2023 09:03AM 2022-23 2022-23 2023.24 Cur Year Cur Year Ful Year Account Number Account Title Budget Actual Budget NON -BUSINESS LICENSES HUMAN RESOURSE 10.42604110 HR Salaries .00 .00 D0 10-4260-1111 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 104260-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 .00 .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 HR Travel, .00 .00 .00 10.4260-490 HR Miscellaneous Expense .00 •00 .00 104260-759 HR Phone Stipend .00 .00 .00 10-4260-800 HR Capital Planning .00 Do .00 10-4261-280 HR Phone .00 .00 .00 Total HUMAN RESOURSE: 59,200 2,500 57,000 GENERAL FUND Revenue Total: .00 •00 .00 GENERAL FUND Expenditure Total: 59,200 2,500 57,000 Net Total NON -BUSINESS LICENSES: 59,200- 2,500- 57,000 - Net Grand Totals: 59,200- 2,500- 57,000 - Modification Page: 1 Feb 21, 2023 09:03AM City of Chubbuck Budget Worksheet Page: 1 Periods: 00/23-14124 Feb 21, 2023 09:1 BAM 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.Aocount Number = "104330690" c�� lnla � Scvtilr G�.� 2022-23 2022-23 2023-24 Cur Year Our Year Fut Year Account Number Account Title Budget Actual Budget Net Grand Totals: .00 .00 ,00 //✓ rVOV Modification City of Chubbuck Budget Worksheet Page: 1 Periods: 00/23-14124 Feb 21, 2023 09:05AM Report Criteria: Print Fund Titles Page and Total by Fund Print Source Titles Total by Source Print Department Titles Total by Department Ali Segments Tested for Total Breaks Account.Accaunt Number = "104400110"-"104569130" 2022-23 2022-23 2023-24 Modification Cur Year Cur Year Fut Year Account Number Account Title Budget Actual Budget NON -BUSINESS LICENSES CS PERSONNEL EXPENSE 10-4.400-110 CS Salaries 267,000 68,847 283,000 10-4400-111 CS Overtime 1,000 324 1,000 10-4400-210 CS FICA 20,000 5,085 22,000 10-4400-220 CS Retirement 32,000 6,179 34,000 10-4400-240 CS Workers` Compensation 2,500 895 2,700 10-4400-260 CS Health Insurance 63,500 18,572 72,000 10-4400-280 05 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 101,902 414,700 CS SUPPORT SERVICES 10-4412-101 CS Engineering ,00 .00 .00 10-44112-111 CS Planning & Development .00 .00 .00 10-4412-121 CS Fleet Maintenance .00 .00 .00 10-4412-130 CS IT .00 .00 .00 10-4412-140 CS Utility Billing .00 .00 .00 10-4412-150 CS Finance .00 .00 .00 10-4412-170 C5 Human Resource .00 .00 .00 Total CS SUPPORT SERVICES: .00 ,00 .00 r CS ADMINISTRATION 10-4423-100 CS Billling Expense .00 69 .00 10-4423-111 CS CertificatienlLicensing 500 30 .00 10-4423-120 CS City Hall Lease ,00 .00 ,00 10-4423-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,5.00 1,797 .00 10-4423-100 CS Employee Continuing Educati .00 .00 .00 104423-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 MappinglGIS 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 TraininglSeminars 1,500 464 .00 10-4423-270 - CS Travel 2,000 304 .00 10-4423-280 CS Utility Telephone 1,000 206 .00 City of Chubbuck Budget Worksheet Periods: OO123-14124 2022-23 2022-23 2023-24 Modification 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 104423-320 CS Pocatello Trade Inspections 10,000 13,768 .00 Total CS ADMINISTRATION: 45,886 17,610 ,00 CS EQUIPMENT 10-4434400 CS Fuel & Lubricants 1,500 545 .00 10-4434-110 CS Small Tools/Equipment .00 .00 .00 10-4434-120 CS Vehicle M & O 2,500 .00 .00 10-4434-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 A0 .00 Total CS SAFETY: 1,000 348 .00 CS FINANCE 10-4469-100 CS Transfer from Depreciation .00 .00 .00 10-4469-160 CS Interagency Services .00 .00 .00 Total CS FINANCE: .00 .00 .00 CS PK PERSONNEL EXPENSE 10-4470-110 CS PK Salaries 302,000 97,372 321,000 10-4470-111 CS PK Overtime 13,000 3,464 13,000 104470-112 CS PK Seasonal Temporary 50,000 630 50,000 10-4470,210 CS PK FICA 26,000 7,531 28,000 10-4470-220 CS PK Retirement 42,000 11,951 42,000 10-4470-240 CS PK Workers' Compensation 12,000 4,561 14,000 10-4470-250 CS PK Health Insurance 102,000 26,601 115,000 10-4470-260 CS PK Unemployment .00 .00 .00 10-4470-759 CS PK Phone Stipend 800 120 .00 10-4470-761 CS PK Clothing .00 263 .00 Total CS PK PERSONNEL EXPENSE: 549,800 152,492 584,000 CS PK SUPPORT SERVICES 10-4481-100 CS PK Engineering .00 .00 .00 10-4481-110 CS PK Planning & Development .00 .00 .00 10-4481-120 CS PK Fleet Maintenance 24,000 .00 .00 10-4481-140 CS PK Utility Billing .00 .00 .00 W-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 10-4492-110 CS PK Certifications/Licensing 3,000 101 .00 Page: 2 Feb 21, 2023 09:05AM City of Chubbuck Budget Worksheet Periods: 00/23-14124 Account Number Account Title 2022-23 Cur Year Budget 2022.23 Cur Year Actual 2023-24 Modification Fut Year Budget 10-4492-120 CS PK City Hall Lease .00 .00 .00 10-4492-130 CS PK City Hall Operations 5,500 2,239 .00 10-4492-140 CS PK Computer/IT.Hardware .00 127 .00 10-4492,150 C5 PK Computer/IT Software .00 11,229 .00 10-4492,160 CS PK Employee Continuing Edue .00 .00 .00 10-4492-170 CS PK Employee Phone Stipend .00 .00 .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 oo 10-4492-210 CS PK Mapping GIS System .00 .00 ,00 10-4492-220 CS PK Membership Dues .00 244 .00 10-4492-230 CS PK Office Equipment Supplie 800 248 .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 PKTraining Seminars 2,000 105 .00 10-4492-270 CS PK Travel 3,400 .00 .00 10.4492-280 CS PK Utility Telephone 800 204 .00 10.4492-290 CS PK Utility Electrical 9,000 1,894 .00 10-4492-300 CS PK Utility Natural Gas 1,400 1,024 .00 10-4492-310 CS PK Facility Maintenance Jan 1,000 667 .00 10-4492-320 CS PK Yard Facility Construct! 2,500 1,391 .00 10-4492-330 CS PK Yard Facility Operations .00 4 ,00 Total CS PK ADMINISTRATION: 29,400 22,657 .00 CS PK Maintenance 10.4503-100 CS PK Mowing .00 .00 .00 10-4503-110 CS PK Irrigation 7,500 354 .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 PK Maintenance: 20,700 1,004 .00 CS PK Facility Maintenance 10-4514-100 05 PK Playgrounds .00 2,319 .00 104514-110 CS PK Restroom 9,000 1,232 .00 10-4514-120 CS PK Building 1,500 4,623 .00 10-4514-130 CS PK Walking Path 1,500 1,033 .00 10.4514-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 449 .00 10-4514-190 CS PK Volleyball Court 1,000 .00 .00 10-4514-200 CS PK Ball Fields 2,500 5,659 .00 10-4514-210 CS PK Tennis Court 60,000 .00 ,00 Total CS PK Facility Maintenance: 90,500 15,663 .00 CS PK Shoulder Work 104525-100 CS PK Mowing .00 .00 ,00 10-4525-110 CS PK Weeds .00 .00 .00 10-4525-120 CS PK Trees .00 .00 .00 10-4525-130 CS PK Snow Removal 2,500 95 .00 Page: 3 Feb 21, 2023 09:05AM City of Chubbuck Account Number Account Title Total CS PK Shoulder Work: CS PK Property 10-4536-100 05 PK Mowing 10-4536-110 CS PK Weeds 10-4536.120 CS PK Trees 10.4536.130 CS PK Trash 10-4536-140 CS PK ADA Total CS PK Property: CS PK Additional Services 10-4547-120 CS PK Park Reservations 10-4547-140 CS PK Hanging Flowers 10-4547-150 CS PK Assist Departments 10-4547-160 CS PK Interagency Services Total CS PK Additional Services: CS PK Equipment 10-4558-100 CS PK Fuel & Lubricants 10-4558-110 CS PK Smal[ Tool/Equipment 10-4558-120 CS PK Large Equipment Total CS PK Equipment: CS PK Safety 10-4569-100 CS PK Training 10-4569-110 CS PK Clothing 10-4569-120 CS PK Equipment 10-4569-130 CS PK Testing Total CS PK Safety: GENERAL FUND Revenue Total: GENERAL FUND Expenditure Total: Net Total NON -BUSINESS LICENSES: Net Grand Totals: .00 Budget Worksheet Periods: 00123.14124 2022-23 2022-23 2023-24 Modificalion Our Year Cur Year Fut Year Budget Actual Budget .00 .00 2,500 95 .00 .00 .00 .00 .00 .00 .00 .00 .00 100 .00 3,500 .00 .00 1,500 .00 .00 5,000 100 .00 .00 .00 .00 .00 9,000 .00 .00 .00 .00 .00 .00 .00 .00 9,000 .00 .00 13,500 6,786 .00 3,500 201 .00 10,000 1,105 .00 27,000 8,092 .00 4,000 1,057 00 2,000 337 .00 600 1,965 .00 500 .00 .00 7,100 3,359 .00 .00 .00 .00 1,201,886 323,866 998,700 1,201,886- 323,886- 996,700- 1,201,886- 323,866- 998,700 - Page: 4 Feb 21, 2023 09:05AM City of Chubbuck Budget Worksheet Periods: 00123-141241 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 = "104901430"-"104904822" Modification Page: 1 Feb 21, 2023 01:39PM 2022-23 2022-23 2023-24 Cur Year Cur Year Fut Year Account Number Account Title Budget Actual Budget NON -BUSINESS LICENSES OTHER GEN GOVT ADM. 10.4901-430 GA Audit 30,000 .00 .00 10-4901-500 GATransltBus 43,000 ,00 .00 10.4901-501 GA Ald For Friends 5,000 ,00 ,00 10.4901-502 GA Senior Citizen 7,500 .00 .00 10-4901-503 GA SE ID Council of Government 2,500 .00 .00 10-4901-504 CS Pocatello Free Clinic 7,000 .00 .00 10-4901-505 GA f=amily Services Alliance 5,000 .00 .00 10-4901-506 GA Crossing Gaurds 4,000 .00 .00 10-4902-720 GA Address Change Charge .00 .00 .00 10-4903-550 GA Chubbuck Day's Celebration 5,000 .00 .00 10-4903-551 GA Movies in the Park .00 .00 .00 10.4903-552 GA Christmas in the Park .00 1,714 .00 104903-500 GA Memorial Cost .00 .00 .00 10.4903-570 GA COVID 0o .00 .00 10-4903-571 GA Multi Purpose Room Cleaning .00 .00 .00 10-4903-821 GA Capital Facilities Lease 78,000 .00 .00 10.4903-822 Lease Maintenance Expense .00 .00 .00 10-4904-501 GF COP .00 .00 .00 10-4904-502 LE COP .00 2,203 .00 10-4904-503 LE Animal Control COP .00 .00 00 10-4904-800 GA Capital Planning .00 403,718- .00 10-4904-820 GA City Hall Operations .00 335 .00 10-4904-821 GA Police Remodel .00 749,947 .00 10-4904.822 GA Police Animal Shelter .00 280,670 .00 Total OTHER GEN GOVT ADM.: 187,000 831,151 .00 GENERAL FUND Revenue Total: .00 .00 .00 GENERAL FUND Expenditure Total: 187,000 531,151 .00 Net Total NON -BUSINESS LICENSES: 187,000- 631,151- .00 Net Grand Totals: 187,000- 631,151- .00 Modification Page: 1 Feb 21, 2023 01:39PM City of Chubbuck Budget Worksheet Periods: 00/23-14124 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 Page: 1 Feb 21, 202$ 01:21 PM 2022-23 2022-23 2023-24 Cur Year Cur Year Fut Year Account Number Account Title Budget Actual Budget HIGHWAY, STREETS, AND ROADS MSR PERSONNEL EXPENSES 11-4311-110 HSR Salaries 488,600 178,856 518,000 11.4311-111 HSR Overtime 17,000 10,213 17,000 11-4311-210 HSR FICA 39,400 14,836 40,000 11-4311-220 HSR Retirement 62,800 23,516 63,100 11-4311-240 HSR Workers' Compensation 11,100 4,801 14,500 11-4311-250 HSR Health Insurance 159,800 58,567 181,000 11-4311-260 HSR Unemployment .00 .00 ,00 11-4311-759 HSR Phone Stipend .00 154 .00 11.4311-761 HSR Clothing .00 54 .00 11-4312-100 HSR Engineering .00 .00 .00 11-4312-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 290,995 833,600 HSR ADMINISTRATION 11-4333-100 HSR Billing Expense .00 ,00 .00 11.4333-110 HSR CertificationslLicensing 800 404 .00 11.4333,120 HSR City Hall Lease 78,000 .00 .00 11-4333-130 HSR City Hall Operations 14,000 4,515 .00 11-4333-140 HSR Computer/IT Hardware 20,000 191 .00 11-4333-150 HSR ComputorllT Software 30,000 17,517 .00 11-4333-160 HSR Employee Continuing Educat .00 ,00 ,00 11-4333-170 HSR Employee Phone Stipend 500 .00 .00 11-4333-160 HSR Employee Recongnition 1,300 298 .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 11-4333-230 HSR Office Equipment/Supplies 7,500 155 .00 11-4333-240 HSR Professional Services 10,000 1,083 .00 114333-250 HSR Shop Facility Lease .00 .00 .00 114333-260 HSR Training/Seminars 1,800 277 .00 11.4333-270 HSR Travel .00 39 .00 11-4333-280 HSR Utility Telephone 6,500 2,615 .00 11-4333-290 MSR Utility Electrical 6,500 2,852 .00 11-4333-300 HSR Utility Natural Gas 4,000 1,467 .00 11-4333-310 HSR Facility Maintenanceldanit 10,000 794 .00 Modification Page: 1 Feb 21, 202$ 01:21 PM City of Chubbuck Budget Workshoet Page: 2 Perlods: 00123-14124 Feb 21, 2023 011:211 PM Account Number Account Title 2022-23 Cur Year Budget 2022.23 Cur Year Actual 2023-24 Modification Fut Year Budget 11-4333-320 HSR Yard Facility Construction 7,000 4,076 .00 11.4333-330 HSR Yard Facility Operations 5,000 .00 .00 Total HSR ADMINISTRATION: 276,200 66,083 .00 HSR ASPHALT MAINTENANCE 20,000 .00 .00 11-4340-100 HSR Crack Seal 10,000 .00 .00 11.4340-110 HSR Asphalt Patching 10,000 .00 .00 11-4340-120 HSR Pothole 10,000 .00 .00 11-4340-130 HSR Surface Maintenance 547,400 2,365 .00 11-4340-140 HSR Street Construction 25,000 12,047 .00 11-4341-100 HSR Paint 5,000 .00 .00 11-4341-110 HSR Thermo Plastic 20,000 .00 .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-4344-100 HSR Sall 10,000 16,580 .00 11-4344-110 HSR Sand 5,000 .00 .00 114344-120 HSR Brine 1,000 20 .00 11.4345-100 HSR Maintenance 15,000 .00 .00 11-4345-110 HSR Wood Control 5,000 .00 .00 11-4345-120 HSR Repairs 1,000 .00 .00 11.4345-130 HSR ADA 10,000 .00 .00 11.4346-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 114347-100 HSR Power 85,000 32,821 .00 114347-110 HSR Construction/Installation 500 .00 .00 114347-120 HSR M & O 6,000 2,301 .00 11-4348-100 HSR Power 5,000 1,606 .00 11-4348-110 HSR Constructionlinstallat€on 3,000 .00 .00 11.4348-120 HSR M & O 5,000 845 .00 11-4349-100 NSR Cleaningllnspection 4,000 .00 ,00 11-4349-110 HSR Construction/Installation 75,000 23,066 .00 11-4349-120 HSR M & O 5,000 .00 .00 Total HSR ASPHALT MAINTENANCE: 888,400 100,600 .00 HSR ROADWAY PROJECT 11-4350-100 HSR Siphon Rd .00 3,546- .00 11-4350-110 HSR Hawthorne Rd .00 .00 .00 11A350-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 11,202 .00 11-4351-110 HSR Equipment M & O 45,000 836 .00 11.4351-120 HSR Vehicle M & O 45,000 .00 .00 11-4351-130 HSR Capital Planning .00 .00 .00 11.4351-140 HSR New Equipment Planning 75,000 1,358- 00 11-4351-1150 HSR New Vehicle Planning .00 5,000 ,00 11-4351-160 HSR Small Tools & Equipment 2,500 71 .00 11-4352-100 HSR Training 1,200 2,881 .00 11-4352-110 HSR Clothing 1,000 1,189 .00 11.4352-120 HSR Equipment 500 165 .00 11-4352-130 HSR Testing Soo .00 .00 11.4353-100 HSR Flags .00 .00 .00 11-4353-110 HSR Banners .00 .00 .00 City of Chubbuck Account Number Account Title 11-4353-120 HSR Christmas Decorations 11-4353-130 HSR Chubbuck Days 11-4353-140 HSR Tree Trimming 11-4353-150 HSR Interagency Services Total HSR ROADWAY PROJECT: HSR FINANCE 11.4380.100 HSR Transfer from Depreciation 11-4380-500 HSR City Hall Construction 11-4380-798 HSR Notes Interest Expense 11-4380-800 HSR Capital Planning 11-4380-822 HSR Wastewater Loan Total HSR FINANCE: HIGHWAY, STREETS, AND ROADS Revenue Total: HIGHWAY, STREETS, AND ROADS Expenditure Total: Net Total HIGHWAY, STREETS, AND ROADS: Net Grand Totals: 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" Budget Worksheet Page: 3 Periods: 00/23-14/24 Feb 21, 2023 01:21 PM 2022-23 2022-23 2023-24 Modification Cur Year Cur Year Fut Year Budget Actual Budget .00 .00 .00 ,00 ,00 ,00 ,00 .00 .00 .00 .00 .00 220,700 16,440 .00 M .00 .00 .00 384 .00 .00 .00 ,00 .00 .00 .00 136,000 .00 .00 136,000 384 .00 .00 .00 .00 2,300,000 474,503 833,600 2,300,000- 474,503- 833,600- 2,300,000- 474,603- 833,600 - City of Chubbuck Budget Worksheet Page: 1 Periods: 00123-14124 Feb 21, 2023 01:22PM 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`2314390813" 2022-23 2022-23 2023-24 Modification 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 245,874 732,000 31-4341-111 WW Overtime 8,800 8,570 8,800 31-4341-210 WW FICA 53,800 19,856 66,000 314341-220 WW Retirement 87,100 31,713 89,000 31-4341-221 WW PERSI Pension Expense .00 .00 .00 31-4341-240 WW Workers' Compensation 20,100 8,362 25,000 31-4341-250 WW Health Insurance 239,100 79,598 271,000 31-4341-260 WW Unemployment .00 .00 .00 31-4341-759 WW Phone Stipend .00 133 .00 31-4341-761 WW Clothing .00 10 .00 31-4342-100 WW Engineering .00 .00 .00 31-4342-110 WW 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 394,114 1,181,800 WW ADMINISTRATION 314353-100 WW Billing Expense 31,000 6,448 .00 314363-110 WW Certifications/L€tensing 9,000 562 .00 31-4353-120 WW City Hall Lease 166,000 .00 .00 31-4353-130 WW City Hall Operations 3,000 9,230 .00 31-4353-140 WW Computer/IT Hardware 20,000 286 .00 31-4353-150 WW ComputerAT Software 17,000 28,554 .00 31-4363-160 WW Employee Contunuing Educati 1,000 .00 AO 31-4353-170 WW Employee Phone Stipend .00 .00 .00 31-4353-180 WW Employee Recongnition 2,500 307 .00 31-4353-190 WW Equipment Insurance .00 .00 .00 31-4353,200 WW Liability Insurance .00 00 .00 31-4363-210 WW MappinglGlS Systems 3,000 414 .00 31-4353-220 WW Membership/Dues 3,000 12,761 .00 31-4353-230 WW Office Equipment/Supplies 6,500 789 .00 31-4353-240 WW Professional Services 100,000 4_,523 .00 31.4353,250 WW Shop Facility Lease 1,000 ,00 .00 31-4353-260 WW Training/Seminars 4,000 665 .00 31-4353-270 WW Travel 1,000 39 .00 31-4353-280 WW Utility Telephone 7,500 3,054 .00 31-4353-290 WW Utility Electrical 5,500 3,698 .00 31-4353-300 WW Utility Natural Gas 5,500 2,349 AO City of Chubbuck Budget Worksheet Periods: 00123.14124 Account Number Account Title 2022-23 Cur Year Budget 2022-23 Cur Year Actual 2023.24 Modification Fut Year Budget 31-4353-310 WW Facility MaintenancelJanilo 15,000 206 .00 31-4353-320 WW Yard Facility Construction 7,000 5,684 .00 31-4353-330 WW Yard Facility Operations 10,000 .00 .00 Total WW ADMINISTRATION: 416,500 79,571 .00 WW PRODUCTION AND STORAGE 31-4360-100 WW Well Head Protection .00 .00 .00 31-4360-110 WW Building M & 0 1,000 1,044 .00 31-4360-120 WW Scada M & O 12,000 536 ,00 31.4360-130 WW Electrical Motor M & O .00 .00 .00 31-4360,140 WW Pump M & O 82,900 .00 .00 31-4360,150 WW Well Equipment & O 4,500 .00 .00 31-4360-160 WW Disinfection Equipment M&O 2,000 347 .00 31-4360-170 WW Disinfection Chemical 15,000 ,00 .00 31-4360-180 WW Treatment Chemical 15,000 .00 .00 31.4360-190 WW QC Sampling & Testing 5,000 3,002 ,00 31-4360,200 WW Electrical Power 165,000 55,961 .00 31-4360,210 WW Storage M & O 5,500 413 .00 31-4360-220 WW Water Rights 11,000 12,682 .00 314360-230 WW DEQ Assesment 34,000 .00 .00 314361-100 WW Piping M & O 22,000 3,297 .00 31-4361110 WW Valve M & 0 15,000 .00 .00 31-4361-120 WW Valve Replacement 4,000 .00 .00 $1-4361-130 WW System Improvements 50,000 44 .00 31-4361,140 WW Dlglino 1,600 .00 ,00 31-4361,150 WW Capital Planning 1,669,800 4,393 .00 31-4361,160 WW Line Flushing 5,000. .00 .00 31-4362-100 WW New Connections 1,000 .00 .00 31-4382-110 WW Service Connection M & 0 1,800 got .00 31-4362-120 WW Meters 45,000 25,037 .00 31-4352-130 WW Meter Reading Equipment 25,000 .00 .00 31-4353-100 WW Fire Hydrant M & O 15,000 3,531 .00 31-4363-110 WW Fire Hydrant Replacement 10,000 1,600 .00 31-4363-120 WW Storz Fittings .00 .00 .00 31-4364-100 WW Pump M & 0 15,000 .00 .00 31-4364-110 WW Electrical Power 2,000 1,211 .00 31-4364-120 WW System M & 0 60,000 .00 .00 31-4364-130 WW Digline 1,000 706 .00 31-4364-140 WW Fort Hall Water Rights 35,000 .00 .00 Total WW PRODUCTION AND STORAGE: 2,352,000 114,765 .00 WW ADDITIONAL SERVICES 31-4370-100 WW Meter Can Adjustments .00 .00 .00 31-4370-110 WW Special Turn On1Off .00 .00 .00 31-4370-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 WW Pickup Repair & Maintenance 10,000 326 .00 31-4380-110 WW Large Truck Repair & Mainte 33,000 16,999 .00 31-4360-120 WW Heavy Equipment Repair & Ma 5,000 813 .00 31-4360-130 WW Truck & Equipment Capital P 125,000 .00 .00 Page: 2 Feb 21, 2023 01:22PM City of Chubbuck Account Number Account Title 31-4380-140 WW Fuel & Lubricants 31-4380-150 WW Small Tools[Equipment 31.4380-160 WW Equipment Rental 31-4381-100 WW Training 31-4381-110 WW Clothing 31.4381-120 WW Equipment 31-4381-130 WW Testing Total WW EQUIPMENT EXPENSE: WW FINANCE .00 31-4390-500 WW COP Amortization 31-4390-501 WW City Hall Construction 31-4390-502 WW COP 31-4390-612 WW Bonds & Interest 31-4390-813 WW Notes & Interest Total WW FINANCE: WATER UTILITY Revenue Total: WATER UTILITY Expenditure Total: Net Total WATER UTILITY: Net Grand Totals: 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"-"314390813" 4,701,300- 627,953- 1,181,800- 4,701,300- 627,953- 1,181,800 - Modification Page: 3 Feb 21, 2023 01:22PM Budget Worksheot Periods: 00123-14/24 2022-23 2022-23 2023-24 Cur Year Cur Year Fut Year Budget Actual Budget 24,000 7,753 .00 3,000 4,124 .00 2,000 .00 .00 1,500 2,591 .00 2,500 1;287 .00 2,000 4,385 .00 1,000 418 .00 209,000 38,694 .00 .00 .00 .00 .00 809 .00 .00 .00 .00 600,000 .00 .00 25,000 .00 .00 625,000 809 .00 .00 .00 .00 4,701,300 627,953 1,181,800 4,701,300- 627,953- 1,181,800- 4,701,300- 627,953- 1,181,800 - Modification Page: 3 Feb 21, 2023 01:22PM City of Chubbuck Budget Worksheet Page: 1 Perlods: 00123-14/24 Feb 21, 2023 01:23PM 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 Aocount.Account Number- "324351110"-"324390600'. Account Number Account Title SW WASTEWATER SW PERSONNEL EXPENSE 32.4351-110 SW Salaries 32-4351-111 SW Overtime 32-4351-210 SW FICA 32-4351-220 SW Retirement 32.4351-221 SW PERS] Pension Expense 32-4351-240 SW Workers' Compensation 32-4$51-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 32-4352-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 32-4352-170 SW Administration 32-4353-100 SW Billing Expense 32-4353-110 SW CertificationslLicensing 32.4353-120 SW City Hall Lease 32-4353-130 SW City Hall Operations 32.4353-140 SW ComputerA7 Hardware 32.4353-150 SW Computer/IT 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 32-4353-220 SW MembershipsJDues 32.4353-230 SW Office Equipment/Supplies 32-4353-240 SW Professional Services 32.4353-250 SW Shop Facility Lease 32-4353-260 SW Training/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 MaintenancelJanito 32-4353-320 SW Yard Faciltiy Construction 32-4353-330 SW Yard Facility Operations 2022-23 Cur Year Budget 2022-23 our Year Actual 2023-24 Modification Fut Year Budget 584,200 213,124 620;000 6,200 6,995 6,200 45,500 17,151 47,000 74,100 27,358 75,200 .00 .00 .00 17,300 7,494 22,500 187,1100 66,680 212,500 .00 .00 .00 .00 133 .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 $,448 .00 15,000 753 .00 165,000 .00 .00 3,000 9,264 .00 20,000 286 .00 17,000 28,974 .00 1,500 120 .00 ,00 .00 .00 1,500 307 .00 .00 .00 .00 .00 .00 .00 3,500 414 .00 1,000 277 .00 2,500 803 .00 125,000 2,439 .00 .00 .00 .00 1,500 065 .00 500 39 .00 6,500 2,615 .00 4,500 2,203 ,00 9,500 7,250 .00 15,000 772 .00 7,000 6,435 .00 10,000 .00 .00 City of Chubbuck Account Number Account Title Total SW PERSONNEL EXPENSE: SW COLLECTION SYSTEM 32-4360-100 SW Collection Sys Maint Lines 32-4360,110 SW Collection Sys Maint Lift S 32-4360,120 SW Collection Sys Improvement 32-4360-130 SW Digline Locales 32-4360-140 SW Capital Planning 32-4361-100 SW QC Sampling/testing 32-4361-110 SW Treatment Pocatello 32-4361.120. SW Inspections 32-4361-130 SW Applications/Approvals 32-4362-100 SW Electrical Motor M & O 32-4362-110 SW Pumping Equipment M & 0 32-4362-120 SW Electrical Power 32-4362-130 SW SCADA 32-4362-140 SW Building & Grounds M & O 32-4362-150 SW Capital Planning Total SW COLLECTION SYSTEM: 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 & Ma 32-4380-130 SW Truck & Equipment Capital P 32.4380-140 SW Fuel & Lubricants 32-4380-150 SW Small Tools & .Equipment 32-4381-100 SW Training 32-4381-110 SW Clothing 32-4381-120 SW Equipment 32-4381-130 SW Testing Total SW EQUIPMENT EXPENSE: SW FINANCE .00 32-4390-100 SW Transfer from Depreciation 32-4390-500 SW City Hall Construction Total SW FINANCE: SW WASTEWATER Revenue Total: SW WASTEWATER Expenditure Total Net Total SW WASTEWATER: Net Grand Totals: Budget Worksheet Periods: 00/23-14/24 2022-23 2022-23 2023-24 Modification Cur Year Cur Year Fut Year Budget Actual Budget 1,354,900 409,012 983,400 500 .00 .00 500 177 •00 3,500 .00 .00 2,000 436 .00 281,000 .00 .00 500 .00 .00 1,600,000 420,413 .00 300 .00 .00 .00 .00 .00 25,000 2,746 .00 30,000 5,395 A0 20,000 9,008 .00 10,000 1,345 .00 5,000 3,266 .00 273,000 .00 .00 2,251,300 442,786 .00 .00 .00 .00 15,000 .00 .00 15,000 .00 .00 500 .00 .00 500 16,813 .00 1,000 .00 .00 25,000 .00 .00 15,000 4,048 .00 5,000 190 .00 500 2,223 •00 2,000 796 .00 2,000 4,340 .00 300 685 .00 51,800 29,096 .00 .00 .00 .00 .00 812 .00 •00 812 .00 .00 .00 .00 3,673,000 881,705 983,400 3,673,000- 861,705- 983,400- 3,673,000- 881,705- 983,400 - Page: 2 Feb 21, 2023 01:23PM City of Chubbuck Budget Worksheet Page: 3 Periods: 00123.14124 Feb 21, 2023 01:23PM 2022-23 2022-23 2023-24 Cur Year Cur Year Fut Year Account Number Account Title Budget Actual Budget Report Criterla: 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 Acoount.Account Number = "32435111 0'-"324390500" Modification City of Chubbuck Budget Worksheet Page: 1 Periods: 00123-14/24 Feb 21, 2023 01:24PM 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 = "33433111 0':"334390502" Account Number Account Title SN SANITATION SN OPERATIONS 33-4331-110 SN Salaries 33-4331-111 SN Overtime 33-4331-210 SN FICA 33-4331-220 SN Retirement 33-4331-221 SN PERSI Pension Expense 33-4331-240 SN Workers' Compensation 33-4331-250 SN Health Insurance 33-4331-260 SN Unemployment 33.4331-759 SN Phone Stipend 33-4331-761 SN Clothing 33-4332-100 SN Engineering 33-4332-110 SN Planning & Development 33-4332-120 SN Fleet Maintenance 33-4332-130 SN IT 33-4332-140 SN Utility Billing 33-4332-150 SN Finance 33-4332-160 SN Human Resource 33-4332-170 SN Administration 33-4333-100 SN Billing Expense 33-4333-110 SN Certifications/Licensing 33-4333-120 SN City Hall Lease 33-4333-130 SN City Hall Operations 33-4333-140 SN Computer/11T Hardware 33.4333-150 SN Computer/11T Software 33-4333-160 SN Employee Continuing Educali 33-4333-170 SN Employee Phone Stipend 33-4333-180 SN Employee Recognition 33-4333-190 SN Equipment Insurance $3-4333,200 SN Liability Insurance 33-4333-210 SN Mapping/GIS Systems 33-4333-220 SN Memberships/Dues 33-4333-230 SN Office EquipmenUSupplies 33-4333-240 SN Professional Services 33-4333-250 SN Shap Facility Lease 33-4333-260 SN Training/Seminars. 33-4333-270 SN Travel 33-4333-280 SN Utility Telephone 33-4333-290 SN Utility Electrical 33-4333-300 SN Utility Natural Gas 33-4333-310 SN Facility MaintenancelJanit 33-4333-320 SN Yard Facility Construction 33-4333-330 SN Yard Facility Operations 2022-23 Cur Year Budget 2022-23 Cur Year Actual 2023-24 Modification Fut Year Budget 573,900 231,518 809,000 22,000 10,391 22,000 46,500 19,037 47,100 74,700 30,301 76,000 .00 .00 .00 20,900 9,495 28,000 217,100 80,204 246,000 .00 .00 .00 .00 112 .00 .00 20 .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 6,448 .00 1,000 297 .00 139,000 .00 .00 26,000 7,826 ,00 16,000 302 .00 10,000 20,709 .00 3,000 .00 .00 .00 .00 .00 2,000 304 ,00 .00 .00 .00 .00 .00 .00 3,500 414 AO 1,000 244 .00 2,500 4,260 .00 .00 245 .00 112,000 18,643 .00 500 181- .00 .00 39 .00 7,000 2,615 .00 4,000 1,727 .00 3,000 1,353 .00 15,000 740 .00 350,000 3,861 .00 10,000 .00 .00 City of Chubbuck Budget Worksheet Page: 2 Periods: 0 012 3-1 4124 Feb 21, 2023 01;24PM 2022-23 2022-23 2023-24 Modification Cur Year Cur Year Fut Year Account Number Account Title Budget Actual Budget Total SN OPERATIONS: 1,691,600 450,923 1,028,100 SN RESIDENTIAL SERVICE 33-4340-100 SN Residential Landfill 195,000 62,531 .00 33-4340-110 SN Residential Carts 35,000 .00 ,00 33-4340-120 SN Residential Cart Maintenano .00 .00 .00 33.4341-100 SN Commercial Landfill 110,000 37,390 .00 33-4341-110 SN Commerical Containers 8,000 58,560 .00 33.4341.120 SN Commercial Container Mainte 5,000 443 .00 33.4342-100 SN Rolloff Landfill 65,000 22,638 .00 33-4342-110 SN Rolloff Containers 10,000 14,887 .00 33-4342-120 SN Rolloff Container Maintenan 1,000. .00 .00 33-4343-100 SN Recycle Waste 31,000 17,297 .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 213,747 .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 .00 .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 0o .00 .00 Total SN ADDITIONAL SERVICE: - .00 .00 .00 SN EQUIPMENT EXPENSE 33.4370-100 SN Fuel & Lubricants 60,000 40,832 .00 33-4370-110 SN Small Tool/Equipment 8,000 589 .00 33-4370-120 SN Vehicle M & O 125,000 10,852 .00 334370-130 SN Capital Planning 67,000 199 .00 33-4370-140 SN New Collection Vehicle .00 .00 .00 33-4370-150 SN Small Vehicle Replacement 5,000 .00 .00 334371-100 SN Training 1,000 1,885 .00 33-4371-110 SN Clothing 4,000 951 .00 33-4371-120 SN Equipment .00 304 .00 33-4371-130 SN Testing 300 16a .00 33-4371-140 SN Damage Claims .00 .00 .00 Total SN EQUIPMENT EXPENSE: 290,300 55,779 AO 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 Total SN FINANCE: .00 686 .00 SN SANITATION Revenue Total: .00 .00 .00 City of Chubbuck Budget Worksheet Page: 3 Periods: 00123.14124 Feb 21, 2023 01:24PM 2022-23 2022-23 2023-24 Modification Cur Year Cur Year Fut Year Account Number Account Title Budget Actual Budget SN SANITATION Expenditure Total Net Total SN SANITATION: Net Grand Totals: 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'2334390502" 2,442,900 721,134 9,028,100 2,442,900- 721,134- 1,028,100- 2,442,900- 721,134- 1,02a,100- Joey Bowers Subject: please add to council packets Thanks, Cheri Cheri Johnson Office Administrator CHUBBUCK FIRE DEPARTMENT 4727 Yellowstone Ave. Chubbuck,ID 83202 ciohnson@ci.tyofchubbuck.us Phone: 208-237-3212 Fax: 208-237-1.121 CHUBBUCK FIRE DEPT BUDGET 10/22 - 9/23 MONTHLY EXPENDITURES (updated 2/7/23 starting back to 10/1/22) Columnl Column2 lColumn3 Column4 Column5 Column6 Column? Column8 C0Iumn9 Columnl0 Columnll Column12 Column13 Column14 Column15 Column16 Column17 Colu OCTOBER NOVEMBER DECEMBER JANUARY FEBRUARY MARCH APRIL MAY JUNE JULY AUGUST SEPTEMBER 10-4231-110 REGULAR SALARIES 1,025,000.00 57,161.43 79,195.44 117,352.16 78,854.05 332,563.08 692,436.92 32.5 10-4231-111 OVERTIME SALARIES 101,000.00 2,884.85 8,341.50 12,289.73 6,577.62 30,093.70 70,906.30 29.8 10-4231-115 PAY -CALL SALARIES 81,000.00 3,097.06 3,448 5,751.44 6,151.53 18,447.58 62,552.42 22.8 10-4231-210 REGULAR FICA 79,000.00 6,451.05 6,580.30 9739.40 6,415.45 29,186.20 49,813.80 36.9 10-4231-215 PAY -CALL FICA 6,000.00 336.63 263.74 439.96 470.61 1,510.94 4,489.06 25.2 10-4231-220 RETIREMENT 136,726.00 10,610.16 10,736.78 15,900.87 10,478.24 47,726.05 88,999.95 34.9 10-4231-240 REGULAR WORKMANS COMP 30,000.00 0 2305.7 5,356.20 2,606.58 10,268.48 19,731.52 34.2 10-4231-245 PAY -CALL WORKMANS COMP 12,000.00 0 913.03 2,121.00 1,032.18 4,066.21 7,933.79 33.9 10-4231-250 REGULAR HEALTH INSURANCE 231,650.00 17,246.65 16,830.66 17,987.56 14,790.70 66,855.57 164,794.43 28.9 10-4231-255 PAY -CALL HEALTH INSURANCE 5,000.00 290.07 290.59 583.18 0 1,163.84 3,836.16 23.3 10-4231-260 REGULAR UNEMPLOYMENT 0 0 0 0 0 0 0 0 10-4231-265 PAY -CALL UNEMPLOYMENT 0 0 0 0 0 0 0 0 10-4231-310 OFFICE SUPPLIES 5,492.00 -599.71 761.86 332.55 125.09 619.79 4,872.21 11.3 10-4231-345 COMPUTER SOFTWARE 69,500.00 -149.25 1456.99 9,433.53 5,980.80 16,722.07 52,777.93 24.1 10-4231-347 ANNUAL DUES 4,000.00 0 0 0 0 0 4,000.00 0 10-4231-517 EMS VACCINES & TESTING 5,000.00 0 0 0 0 0 5,000.00 0 10-4231-519 PHYSICAL EXAMS 13,000.00 4,825.00 0 0 0 4,825.00 8,175.00 37.1 10-4231-520 IDAHO POWER 7,500.00 0 463.93 440.2 593.06 1,497.19 6,002.81 20 10-4231-522 INTERMOUNTAIN GAS 3,200.00 0 20.79 250.25 855.5 1,126.54 2,073.46 35.2 10-4231-600 BUILDING REPAIRS/MAINTENAC 18,500.00 89.48 1,245.00 0 230.86 1,565.34 16,934.66 8.5 10-4231-740 FITNESS/SAFETY 5,000.00 0 0 0 0 0 5,000.00 0 10-4231-900 EMS SUPPLIES 5,000.00 -21.21 69.45 61.45 12.98 122.67 4,877.33 2.5 TOTAL OPERATING EXPENSES 1,843,568.00 102,222.21 132,923.31 198,039.48 135,175.25 568,360.25 1,275,207.75 10-4235-510 TELEPHONE 7,500.00 415.32 665.03 665.04 664.07 2,409.46 5,090.54 10-4235-630 COMMUNICATIONS 3,000.00 0 0 0 0 0.00 3,000.00t COMMUNICATIONS EXPENSE 10,500.00 415.32 665.03 2,245.29 664.07 2,409.46 8,090.54 10-4236-370 TRAINING 14,262.00 0 0 0 5,127.28 5,127.28 9,134.72 10-4236-371 CONTINUING EDUCATION 738.00 -264 -264.00 1,002.007 BUDGET OCTOBER NOVEMBER DECEMBER JANUARY FEBUARY MARCH APRIL MAY JUNE JULY AUGUST SEPTEMBER Rmmm�i 10-4236-375 1 PREVENTION 5,000.00 -107.49 107.49 992.94 276.48 1,199.42 3,800.58 24 10-4236-379 ISUPPLIES 7,000.00 -41.94 277.38 555.95 219 1,010.39 5,989.61 14.4 10-4236-379 FIRE MEALS/PR 3,000.00 0 0 0 0 0 3,000.00 0 10-4236-761 UNIFORMS 9,500.00 0 120 54.96 0 174.96 9,325.04 1.8 10-4236-763 DRUG TESTING (PRE -EM) 1,500.00 0 98 0 0 98 1,402.00 6.5 TRAINING & PREVENTION 41,000.00 -149.43 602.87 1,533.85 5,358.76 7,346.05 33,653.95 10-4237-350 FUEL 22,000.00 0 1827.23 1,086.84 1,300.21 4,214.28 17,785.7219.2 10-4237-610 EQUIPMENT REPAIRS/MAINTAIN14,500.00 -123.9 123.9 1,824.10 0 1,824.10 12,675.90 12.6 10-4237-611 VEHICLE REPAIRS/MAINTENCE 16,500.00 1,279.16 0 452 0 1,731.16 14,768.84 10.5 10-4237-661 SCBA 30,000.00 0 0 0 0 1 0 30,000.00 0 VEHICLE & EQUIPMENT EXPENSE 83,000.00 1,155.26 1951.13 3,362.94 1,300.21 7,769.54 75,230.46 10-4238-369 AUX EQUIPMENT 25,545.00 0.00 11.46 0 728.77 740.23 24,804.77 2.9 10-4238-392 PROTECTION 25,000.00 0.00 5486.17 0 0 5,486.17 19,513.831 21.9 TOTAL PROTECTION/MISC AUX. 50,545.00 0.00 5497.63 0 728.77 6,226.40 44,318.60 0 TOTAL FIRE EXPENDITURES 2,028,613.00 103,643.36 141,639.97 203,601.31 143,227.06 592,111.70 1,436,501.30 ****TOTAL FIRE BUDGET 2,028,613.00 103,643.36 141,639.97 203,601.31 143,227.06 582,111.70 1,436,501.30 10-4238-801 Aerial Obligations Lease FY'24 117,500.00 lav"�t\ CHUBBUCK I D R U 0 FY24 Budget Schedule Office of the Treasurer 290 East Linden Avenue, Chubbuck, ID 83202 208.237.2400 — Fax 208.237.2371 www.CityefChubbuck.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 Budget Worksheet Page: 1 Period: 00123 Mar 28, 2023 08:24AM 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" Account Number Account Title NON -BUSINESS LICENSES LEGISLATIVE 2022-23 10-4111-110 LG Salaries 10-0111-111 LG Overtime 10-0111-270 LG FICA 10.4111-220 LG Retirement 10.4111.240 LG Workers` Compensation 104111.250 LG Health Insurance 104112.370 LG Travel, Meetings & Other 104112-480 LG Dues 104112-490 LG Grant Consulting 10-4112-491 LG Feasability Study 104112-693 LG Land Use Compensation 104112-694 LG Legal Total LEGISLATIVE: GENERAL FUND Revenue Total: GENERAL FUND Expenditure Total: Net Total NON -BUSINESS LICENSES: 2022-23 2022-23 2023-24 Modification Cur Year Our Year Fut Year Budget Actual Budget 33,000 16,590 36,000 .00 .00 .00 2,500 1,269 2,700 4,000 1,981 4,400 250 112 300 67,000 30,323 76,000 5,200 .00 .00 6,500 6,228 .DO .00 .00 .00 .00 .00 .00 700 170 .00 .00 .00 .00 119,150 56,673 119,400 .00 .00 .00 119,150 56,673 119,400 119,150- 56,673- 119,400- 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 ACGount.Account Number= "10413111 0"-"104133280" Net Total NON -BUSINESS LICENSES: 66,600- 27,371- 71,600- 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,449 3,400 10.4131-220 EX Retirement 5,000 2,310 5,500 i0-4131-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 EqulpmentlSupplies 500 .00 .00 10-4131-759 PSC 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: 65,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: 66,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 = "104142280""104142761" Account Number Account Title NON -BUSINESS LICENSES CLERK 10-4142-280 CK Phone 10-0142-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: r 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.Account Number = "104151110""104155280" Modification 2022-23 2022-23 2023-24 Cur Year Cur Year Fut Year Account Number Account Title Budget Actual Budget NON -BUSINESS LICENSES FINANCIAL 10-4151-110 FN Salaries .00 .00 .00 10-41151-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 10-4151-260 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-319 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-761 FN Clothing .00 .00 ,00 10-4152-860 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 10-4153-312 FN Elections & Supplies .00 .00 .00 10-4153-759 FN Phone Stipend .00 .00 .00 10-4153-800 FN Capital Planning .00 .00 .00 10-4154-300 FN Human Resource .00 .00 .00 10-4155-280 UB 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 Not Total NON -BUSINESS LICENSES: 57,045- 29,128- 12,500 - Modification City of Chubbuck Budget Worksheet Page: 1 Period: 00/23 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 Aocount.Account 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 .00 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 10-4160-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 Travol,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.4160.420 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-681 LL SAUSA 1,500 1,108 .00 Total LEGAL: 135,700 17,701 35,500 GENERAL FUND Revenue Total: .00 .00 .00 GENERAL FUND Expenditure Total: 135,700 17,701 _ 35,500 Net Total NON -BUSINESS LICENSES: 135,700- 17,7D1- 35,500 - Modification City of Chubbuck Budget Worksheet Page: 1 Period: 00123 Mar 28, 2023 08:33AM Report Criteria: Print Fund TIHes 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 10-0193-250 GV Health Insurance ,00 .00 .00 10-4193-A15 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 SNIWWISW 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-601 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 10-4195-604 GV 216 Highway Ave .00 .00 ,00 10-4195-605 GV 234 Highway Ave .00 .00 ,00 10-4195-606 GV 12582 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 156 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: i 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 Acccunt.Aocount Number = "104211110"2104229850" 2022.23 2022-23 2023-24 Modification 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 1B0,000 79,159 185,000 10-4211-220 LE Retirement 295,000 129,621 322,000 10-4211-230 LE Incentives .00 .00 .00 10-4211-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 10.4211-420 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 10-4215-316 LE Mise 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 50,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 10-4215-602 LE Miscellaneous 4,500 2,116 .00 10-4215-650 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 City of Chubbuck Budget Worksheet Period: 00123 Modification Page: 2 Mar 28, 2023 08:34AM 2022-23 2022-23 2023-24 Cur Year Cur Year Fut Year Account Number Account Title Budget Actual 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 I OA222-510 LE Telephone/Pepair 35,000 17,398 .00 _ 10-4222-630 LE RadiolRepair 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-4223-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 w 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 MainllFurnace 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 - Modification Page: 2 Mar 28, 2023 08:34AM City of Chubbuck Budget Worksheet Page: 3 Period: 00/23 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 f=und 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: 00123 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"-"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' Compensation 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 PC Interagency Services 10-4231-310 PC 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 RemodellAddition 10-4231,740 FC Safety 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 Cur Year Cur Year Fut Year Budget Actual Budget Modification 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 .00 .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 246- .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 Account Number Account Title 10-4236-763 FC Drug Testing 10-4237.350 FC Fuel 10-4237-610 FC Equipment Maintenance 10-4237-911 FC Vehicle Maintenance 10-4237-661 FC SOBA 10-4237-670 FC Grant Purchase 10-4238-369 FC Equipment 10-4238-392 FC Protection 10-4238-700 FC COVID 19 10-4238-800 FC Capital Planning 10-4238-801 FC Lease Airial 10-4238-860 FC Lease Capital Outlay 10-4238-862 FC lease Financing Expense 10-4238-864 FC Lease Interest Expense IGin 1910:101211;To]WIZIOW4421 I�lir.]�; GENERAL FUND Revenue Total: GENERAL FUND Expenditure Total: Net Total NON -BUSINESS LICENSES: Net Grand Totals: 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 = "1 04231110"21104238864" Budget Worksheet Period: 00123 2022.23 2022-23 2023-24 Cur Year Cur Year Fut Year Budget Actual Budget 1,500 98 .00 22,000 5,830 .00 14,500 1,824 ,00 16,500 5,722 ,00 30,000 .00 .00 .00 .00 .00 25,545 2,077 .00 25,000 5,486 .00 .00 .00 .00 .00 .00 .00 117,000 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 2,145,613 879,385 2,967,050 .00 .00 .00 2,145,613 879,385 2,967,050 2,145,613- 679,385- 2,967,050- 2,145,613- 879,385- 2,967,050 - Modification Page: 2 Mar 29, 2023 02:06PM City of Chubbuck Budget Worksheet Page: 1 Period: 00123 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 .00 GENERAL FUND Expenditure Total: 118,000 INFORMATION TECHNOLOGY .00 Net Total NON -BUSINESS LICENSES: 118,000- 10.4250.339 IT Office Equipment 1,500 .00 .00 10.4250-340 IT Office Equip Repair .00 .00 .00 1014250-341 IT Computer Purchase 25,000 .00 .00 10-4260-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,000 .00 .00 10-4250-348 1T Software 32,500 .00 .00 10-4250-350 IT Fuel .00 .00 .00 10-4250-360 IT Small Tools/Equipment .00 .00 .00 10-4250-370 IT Training 6,000 594- .00 104250-415 IT Website M & 0 .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,449 .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.Account Number = "104260110""104261280" Account Number Account Title NON -BUSINESS LICENSES HUMAN RESOURSE 10-4260-110 HR Salaries 10-4260-111 HR Overtime 10-4260-210 HR FICA 10-4260-220 HR Retirement 10-4260-240 HR Workers' Compensation 10-4260-250 HR Health Insurance 10-4260-260 HR Unemployment 10-4260-310 HR Office Supplies 10-4260-315 HR Dues, Fees, Subscriptions 10-4260-340 HR Office Equipment 10-4260-345 HR Computer Purchase 10-4260-346 HR Computer Repair 10-4260-347 HR Computer Software 10-4260-360 HR Small Tools and Equipment 10-4260-370 HRTraining 10-4260-480 HR Travel 10-4260-090 HR Miscellaneous Expense 10-4260-759 HR Phone Stipend 10-4260-600 HR Capital Planning 10-4261-280 HR Phone Total HUMAN RESOURSE: GENERAL FUND Revenue Total: GENERAL FUND Expenditure Total: Net Total NON -BUSINESS LICENSES: 2022-23 2022-23 2023-24 Cur Year Cur Year Fut Year Budget Actual Budget Modification .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 50,000 .00 57,000 .00 .00 .00 .00 .00 .00 2,500 2,500 .00 .00 .00 .00 2,500 .00 .00 .00 .00 .00 2,500 .00 .00 A0 .00 .00 1,700 .00 .00 .00 .00 .00 .00 476 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 59,200 2,976 57,000 .00 .00 .00 59,200 2,976 57,000 5%no- 2,976- 57,000- City of Chubbuck Budget Worksheet Page: Period: 00123 Mar 28, 2023 D8:37AM Report Criteria: Print Fund Titles Page and Total by Fund Print Source Titles Total by Source s4ivMPrint Department Titles Vv Total by Department All Segments Tested for Total Breaks Account.Account Number = "104330690" 2022-23 2022-23 2023-24 Modification Cur Year Cur Year Fut Year Account Number Account Title Budget Actual Budget 4 2-5,000 — City of Chubbuck Budget Worksheot 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" Account Number Account Title 2022-23 Cur Year Budget 2022-23 Cur Year Actual 2023-24 Fut Year Budget NONBUSINESS LICENSES CS PERSONNEL EXPENSE 104400.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 8,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 Milling Expense .00 69 .00 10-4423-111 CS Certification/Licensing 500 30 .00 10-4423-120 CS City Hall Lease .00 .00 .00 104423-130 CS City Hall Operations .00 .00 .00 10.4423-140 CS Computer/IT Hardware 2,000 .00 .00 10-4423-150 CS ComputorllT Software 7,500 1,797 .00 10-4423-160 CS Employee Continuing Eduoati .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/GIS 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 Workshoet Period: 00123 Modification Page: 2 Mar 28, 2023 08:38AM 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 MaintlJanilorial ,00 .00 .00 10-4423-320 CS Pocatello Trade Inspections 10,000 16,543 .00 10-4423-321 CS FC Subdivision Fees remit .00 .Do .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 OD .00 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 10-4469-100 CS Transfer from Depreciation 00 .00 .00 104469-160 CS Interagency Services .00 .00 .00 Total CS FINANCE: .00 .00 .00 CS PK PERSONNEL EXPENSE 10-4470-110 CS PK Salaries 302,000 124,106 356,000 10-4470-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 10-4470-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 .00 .00 10.4481-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 Do 228 .DO Modification Page: 2 Mar 28, 2023 08:38AM City of Chubbuck Budget Worksheet Period: 00123 Account Number Account Title 2022-23 Cur Year Budget 2022-23 Cur Year Actual 2023-24 Fut Year Budget 10-4492-110 CS PK CertificationslLicensing 3,000 1,349 .00 104992-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 ComputedIT Hardware .00 127 .00 10-4492-150 CS PK Computer/IT Software .00 13,389 .00 10-4492-160 CS PK Employee Continuing Educ .00 .00 .00 10-4492-170 CS PK Employee Phone Stipend .00 .00 .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 EquipmentSuppiie 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 .00 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 Constructs 2,500 1,421 AO 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,590 408 .00 104503-120 CS PK Weeds 5,200 .00 .00 104503-130 CS PK Trees 6,000 650 .00 10-4503-140 CS PK Fertilizer 2,000 .00 .00 Total CS PK Maintenance: 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 104514-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 PI(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 10.4525-120 CS PK Trees .00 .00 .00 Modification Page: 3 Mar 28, 2023 08:38AM City of Chubbuck Budget Worksheet Period: 00123 2022-23 2022-23 2023-24 Modification Cur Year Cur Year Fut Year Account Number Account Title Budget Actual Budget 10-4525-130 CS PK Snow Removal 2,500 95 .DO Total CS PK Shoulder Work: 2,500 95 .00 CS PK Property 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 OD 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 10-0547-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-4558410 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 .DO 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-4569-120 CS PK Equipment 600 1,965 .00 10-0569-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" Page: 4 Mar 28, 2023 08:38AM City of Chubbuck Budget Worksheet Period: 00/23 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 Page: 1 Mar 28, 2023 08:22AM 2022.23 2022-23 2023-24 Cur Year Cur Year Fut Year Account Number Account Title Budget Actual Budget HIGHWAY, STREETS, AND ROADS HSR PERSONNEL EXPENSES 11-4311-110 HSR Salaries 485,600 216,867 558,000 11.4311-111 HSR Overtime 17,D00 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 11.4312-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 ComputerllT Hardware 20,000 191 .00 11-4333-160 HSR ComputerllT Software 30,000 20,757 .00 11-4333-160 HSR Employee Continuing Educal .00 .00 .00 11-4333-170 HSR Employee Phone Stipend 500 .00 .00 11-4333-180 HSR Employee Recongnition 1,300 380 .00 11-4333-190 HSR Equipment Insurance .00 .00 .00 11-4333-200 HSR Liability Insurance .DO ,00 .00 11-4333-210 HSR MappinglGIS Systems 3,300 414 .00 11-4333-220 HSR Membership/Dues 70,000 29,388 .00 11.4333.230 HSR Office EquipmenttSupplios 7,500 163 .00 11.4333.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 11-4333-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 MaintenancolJanit 10,000 794 .00 Modification Page: 1 Mar 28, 2023 08:22AM City of Chubbuck Budget Worksheet Period: 90123 Account Number Account Title 2022-23 Cur Year Budget 2022-23 Cur Year Actual 2023-24 Fut Year Budget 11-4333-320 HSR Yard Facility Construction 7,000 4,163 .00 11-4333-330 HSR Yard Facility Operations 5,000 1,038 .00 Total HSR ADMINISTRATION: 276,200 74,416 .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-120 HSR Pothole 10,000 ,00 .00 11-4340-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 5,000 .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 11-4345-100 HSR Maintenance 15,000 .00 ,00 11-4345-110 HSR Weed Control 5,000 .00 ,00 11-4345-120 HSR Repairs 1,000 .00 ,00 11.4345-130 HSRADA 10,000 ,00 .00 11-4346-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 Constructionlinstallation 500 .00 .00 11-4347-120 HSR M & 0 6,000 2,301 .00 11-4348-100 HSR Power 5,000 2,072 .00 11-4348-110 HSR Constructlonllnstallation 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 HSR M & 0 5,000 .00 .00 Total HSR ASPHALT MAINTENANCE: 888,400 112,243 .00 HSR ROADWAY PROJECT 11-4350-100 HSR Siphon Rd .00 .00 .00 11-4350-110 HSR Hawthorne Rd .00 .00 .00 11-4350-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 M & 0 45,000 1,950 .00 11-4351-120 HSR Vehicle M &'0 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 11-4352-100 HSR Training 1,200 3,764 .00 11-4352-110 HSR Clothing 1,000 1,637 .00 11-4352-120 HSR Equipment 500 442 .00 11-4352-130 HSR Testing 500 16 .00 Modification Page: 2 Mar 28, 2023 08:22AM City of Chubbuck Budget Worksheet Period: 00123 2022-23 2022-23 2023-24 Cur Year Cur Year Fut Year Account Number Account Title Budget Actual Budget 11-4353-100 HSR Flags .00 .00 .00 11-4353-110 HSR Banners .00 .00 .00 11-4353-120 HSR Christmas Decorations .00 .00 OD 11-4353-130 HSR Chubbuck Days .00 .00 .00 11-4353-140 HSR Tree Trimming .00 .00 .00 11-4353-150 NSR 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 138,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 Not 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 Page: 3 Mar 28, 2023 08:22AM City of Ghubbuck Budget Worksheet Period: 00123 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 43411 1 0"-"314390904" 2022-23 2022-23 2023-24 Modification 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 87,100 38,145 87,000 31-4341-221 WW PERSI Pension Expense 00 .00 .00 31-4341-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 WW Clothing .00 10 .00 314342-100 WW Engineering .00 .00 .00 31-4342-110 WW 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 Hail Operations 3,000 10,064 .00 31-4353-140 WW Computer/IT Hardware 20,000 288 .00 31-4353-150 WW ComputerllT Software 17,000 33,415 .00 31-4353-160 WW Employee Contunuing Educati 1,000 .00 .00 31-4353-170 WW Employee Phone Stipend .00 .00 .00 31-4353-180 WW Employee Recongnition 2,500 389 .00 31-4353-190 WW Equipment Insurance .00 .00 .00 31-4353-200 WW Liability Insurance ,00 .00 '00 31-4353-210 WW MappinglGIS 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,318 .00 31-4353-250 WW Shop Facility Lease 1,000 .00 .00 31-4353-260 WW TraininglSeminars 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 Page: 1 Mar 28, 2023 08:18AM City of Chubbuck Budget Worksheet Page: 2 Period: 00123 Mar 28, 2023 08:18AM Account Number Account Title 2022-23 Cur Year Budget 2022-23 Cur Year Actual 2023-24 Fut Year Budget 314353-310 WW Facility MaintenancelJanito 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 WW Scada M & 0 12,000 701 .00 31-4360-130 WW Electrical Motor & 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&O 2,000 347 .00 31-4360-170 WW Dlslrifection 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 31-4360-200 WW Electrical Power 165,000 67,909 .00 31-4360-210 WW Storage M & O 5,500 413 .00 31-4360-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 3i-4361A`10,i WW Valve M & O 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 31-4361-160 WW Line Flushing 5,000 .00 .00 31-4362-100 WW Now Connections 1,000 1,607 .00 31-4362-110 WW Service Connection M & O 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 31-4$63-120 WW Storz Fittings .00 .00 .00 31-4364-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 WW Digline 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 31.4370-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 WW Pickup Repair & Maintenance 10,000 393 .00 31-4380-110 WW Large Truck Repair & Mainle 33,000 25,420 .00 31-4380-120 WW Heavy Equipment Repair & Me 5,000 988 .00 31-4380-130 WW Truck & Equipment Capital P 125,000 .00 .00 Modification City of Chubbuck Budget Worksheet Page: 3 Period: 00123 Mar 28, 2023 08:18AM Account Number Account Title 31-4380-140 WW Fuel & Lubricants 31-4380-150 WW Small Tools/Equipment 31-4380-160 WW Equipment Rental 31-4381-100 WW Training 314381-110 WW Clothing 31-4381-120 WW Equipment 31-4381-130 WW Testing Total WW EQUIPMENT EXPENSE: VVW FINANCE 1,500 31-4390-500 WW COP Amortization 31-4390-501 WW City Mall Construction 31-4390-502 WW COP 31-4390-812 WW Bonds & Interest 31-4390-813 WW Notes & Interest 314390-820 WW Lease Financing Expense 314390-821 WW Lease Amortization Expense 31-4390-822 WW Lease Interest Expense 31-4390-900 WW Bad Debt Expense 31-4390-901 WW Transfers Out 31-4390-902 WW Depreciation 31-4390-903 WW Loss on Asset Disposal 31-4390-904 WW Miscellaneous Expense Total WW FINANCE: WATER UTILITY Revenue Total: WATER UTILITY Expenditure Total: Net Total WATER UTILITY: 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" 2022-23 2022-23 2023-24 Cur Year Cur Year Fut Year Budget Actual Budget 24,000 10,450 .00 3,000 4,967 .00 2,000 12 .00 1,500 2,663 .00 2,500 1,539 .00 2,000 4,425 .00 1,000 434 .00 209,000 51,289 .00 .00 .00 .00 .00 809 .00 .00 .00 .00 600,000 .00 .00 25,000 .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 .00 625,000 809 .00 .00 .00 .00 4,701,300 844,528 1,157,800 4,701,300- 844,528- 1,157,800 - Modification City of Chubbuck Budget Worksheet Page: 1 Period: 00123 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 Account.Account Number= "324351110"-"324390904" 2022-23 2022-23 2023-24 Cur Year Cur Year Fut Year Account Number Account Title Budget Actual Budget 5W WASTEWATER SW PERSONNEL EXPENSE 32-4351-110 SW Salaries 584,200 256,804 628,000 32-4351-111 SW Overtime 6,200 9,182 6,200 32-4351-210 SW FICA 45,500 20,537 48,000 324351-220 SW Retirement 74,100 32,877 77,000 324351-221 SW PERSI Pension Expense .00 .00 .00 32-4351-240 SW Workers' Compensation 17,300 9,011 22,500 32-4351-250 SW Health Insurance 187,100 79,578 212,500 32-4351-260 SW Unemployment .00 .00 .00 32-4351-759 SW Phone Stipend .00 163 .00 32-4351-761 SW Clothing .00 12 .00 32-4352-100 SW Engineering .00 .00 .00 32-4352-110 SW Planning & Development .00 .00 .00 32-4352-120 SW Fleet Maintenance .00 .00 .00 32-4352,130 SW IT .00 .00 .00 32-4352-140 SW Utility Billing 00 .00 .00 32-4352-150 SW Finance .00 .00 .00 32-4352-160 SW Human Resource 00 .00 .00 324352-170 SW Administration .00 .00 .00 32-4353-100 SW Billing Expense 31,000 7,370 .00 32-4353-110 SW Certifications/Liconsing 15,000 - 874 .00 32-4353-120 SW City Hall Lease 165,000 .00 .00 32-4353-130 SW City Hall Operations 3,000 10,101 .00 32-4353-140 SW ComputerllT Hardware 20,000 286 .00 32-4353-150 SW ComputedlTSoftware 17,000 33,835 .00 32-4353-160 SW Employee Continuing Educati 1,500 120 ,00 32-4353-170 SW Employee Phone Stipend .00 .00 .00 32.4353.180 SW Employee Recognition 1,500 389 .00 32-4353-190 SW Equipment Insurance .00 .00 .00 32-4353-200 SW Liability Insurance .00 .00 .00 32-4353-210 SW Mapping]GIS System 3,500 414 .00 324353-220 SW Memberships/Dues 1,000 443 .00 324353-230 SW Office Equipment/Supplies 2,500 856 .00 32-4353-240 SW Professional Services 125,000 2,439 .00 32-4353-250 SW Shop Facility Lease .00 .00 .00 32-4353-280 SW TraininglSeminars 9,500 1,066 .00 32-4353-270 SW Travel 500 39 .00 32-4353-280 SW Utility Telephone 6,500 3,080 .00 32-4353-290 SW Utlity Electrical 4,500 3,035 .00 32-4353-300 SW Utility Natural Gas 9,500 10,329 .00 32-4353-310 SW Facility Maintenance/Janito 15,000 772 .00 32-4353-320 SW Yard Faciltiy Construction 7,000 6,573 .00 32-4353-330 SW Yard Facility Operations 10,000 .00 .00 Modification City of Chubbuck Budget Worksheet Page: 2 Period: 00123 Mar 28, 2023 08:19AM 2022-23 2022-23 2023-24 Modification Cur Year Cur Year Fut Year Account Number Account Title Budget Actual Budget Total SW PERSONNEL EXPENSE: 1,354,900 490,186 994,200 SW COLLECTION SYSTEM 32-4360-100 SW Collection Sys Maint Lines 500 .00 .00 32-4360-110 SW Collection Sys Malnt Lift S 500 177 .00 32-4360-120 SW Collection Sys Improvement 3,500 .00 .00 32-4360-130 SW Digline Locates 2,000 491 .00 324360-140 SW Capital Planning 281,000 .00 .00 32-4361-100 SW QC Sampling/Testing 500 .00 .00 32-4361-110 SW Treatment Pocatello 1,600,000 555,842 .00 32-4361-120 SW Inspections 300 .00 .00 32-4361-130 SW Applications/Approvals .00 .00 .00 324362-100 SW Electrical Motor & O 25,000 2,746 ,00 32-4362-110 SW Pumping Equipment M & O 30,000 5,473 ,00 32-4362-120 SW Electrical Power 20,000 11,153 .00 32-4362-130 SW SCADA 10,000 1,345 .00 32-4362-140 SW Building & Grounds M & 0 5,000 3,296 .00 32-4362-150 SW Capital Planning 273,000 .00 .00 Total SW COLLECTION SYSTEM: 2,251,300 580,523 .00 SW ADDITIONAL SERVICES 32-4370-100 SW Contractor Assistance .00 .00 .00 32-4370-110 SW Interagency Services 15,000 .00 .00 Total SW ADDITIONAL SERVICES: 15,000 .00 .00 SW EQUIPMENT EXPENSE 32-4380-100 SW Pickup Repair & Maintenance 500 .00 .00 32-4380-110 SW Large Truck Repair & Mainte 500 24,761 ,00 32-4380-120 SW Heavy Equipment Repair & Me 1,000 245 ,00 32-4380-130 SW Truck & Equipment Capital P 25,000 .00 .00 32-4380-140 5W Fuel & Lubricants 15,000 5,711 .00 32-4380450 SW Small Tools & Equipment 5,000 237 .00 32.4381-100 SW Training 500 2,294 .00 32-4381-110 SW Clothing 2,000 992 .00 32-4381-120 SW Equipment 2,000 4,533 .00 324381-130 SW Testing 300 701 .00 Total SW EQUIPMENT EXPENSE: 51,800 39,474 .00 SW FINANCE 32-4390-100 SW Transfer from Depreciation .00 ,00 .00 32-4390-500 SW City Hall Construction .00 812 .00 32-4390-501 SW COP .00 .00 .00 32.4390-502 SW COP Amortization 00 .00 .00 32-4390-820 SW Lease Financing Expense .00 .00 .00 32-4390-821 SW Lease Amortization Expense .00 .00 .00 32-4390-822 SW Leaselntereset Expense .00 .00 .00 32-4390-900 SW Bad Debt Expense .00 .00 .00 32-4390-902 SW Depreciation .00 .00 .00 32-4390-903 SW Loss on Asset Disposal .00 .00 ,00 32-4390-904 SW Miscellaneous Expense 00 .00 ,00 City of Chubbuck Budget Worksheet Page: 3 Period: 00123 Mar 28, 2023 06:19AM 2022.23 2022.23 2023-24 Modification Cur Year Cur Year Fut Year Account Number Account Title Budget Actual Budget 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 = "324351110""324390904" .00 812 .00 .00 .00 00 3,673,000 1,110,994 994,200 3,673,000- 1,110,994- 994,200 - City of Chubbuck Budget Workshoot 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 33.4332-140 SN Utility Billing .00 .00 .00 33.4332-150 SN Finance .00 .00 .00 3341332.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 CortificationslLiconsing 1,000 310 .00 33-4333-120 SN City Hall Lease 139,000 .00 .DO 33-4333-130 SN City Hall Operations 26,000 8,533 .00 33-4333-140 SN CompulerllT Hardware 16,000 302 .00 33-4333-150 SN CompulerllT 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-4333.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 MombershipslDues 1,000 411 .00 33-4333-230 SN Office EquipmenUSupplles 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,066 .00 33-4333-290 SN Utility Electrical 4,000 2,480 .00 3$.4333-300 SN Utility Natural Gas 3,000 1,852 .00 33-4333-310 SN Facility MaintonanceManit 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:21 AM Account Number Account Title Total SN OPERATIONS: SN RESIDENTIAL SERVICE 33-4340-100 SN Residential Landfill 33-4340-110 SN Residential Carts 33-4340-120 SN Residential Cart Maintenanc 33-4341-100 SN Commercial Landfill 33-4341-110 SN Commerical Containers 33-4341-120 SN Commercial Container Mainte 33-4342-100 SN Rolloff Landfill 33-4342-110 SN Rolloff Containers 33-4342-120 SN Rolloff Container Maintenan 33-4343-100 SN Recycle Waste 33-4343-110 SN Recycle Carts 33-4343-120 SN Recycle Cart Maintenance Total SN RESIDENTIAL SERVICE SN ADDITIONAL SERVICE 33-4360-100 SN Freebie 15YD 33-4360-110 SN Freebie 3YD 33-4360-120 SN Branch Chipping 33-4360-130 SN Leaf Pickup 33-4360-140 SN Christmas Tree Pickup 33-4360-150 SN Extra Christmas Containers 33-4360-160 SN Spring Clean Up 33-4360-170 SN Chubbuck Days 33-4360-180 SN Interagency Services Total SN ADDITIONAL SERVICE: SN EQUIPMENT EXPENSE 33-4370-100 SN Fuel & Lubricants 33.4370-110 SN Small Tool/Equipment 33-4370-120 SN Vehicle M & O 33-4370-130 SN Capital Planning 33-4370-140 SN New Collection Vehicle 33-4370-150 SN Small Vehicle Replacement 33-4371-100 SN Training 33-4371-110 SN Clothing 33-4371-120 SN Equipment 33-4371-130 SN Testing 33-4371-140 SN Damage Claims Total SN EQUIPMENT EXPENSE: SN FINANCE .00 33-4390-100 SN Transfer from Depreciation 334390-300 SN Interest 33-4390-500 SN COP Amortization 33-4390-501 SN COP 33-4390-502 SN City Hall Construction 33-4390-820 SN Lease Financing Expense 33.4390-821 SN Lease Amortization Expense - 33 -4390-822 SN Lease Interest Expense 2022-23 2022-23 2023.24 Cur Year Cur Year Fut Year Budget Actual Budget 1,691,600 539,298 1,159,000 Modification 195,000 73;366 .00 35,000 .00 .00 .00 8,680 .00 110,000 46,028 .00 8,000 58,560 .00 5,000 443 .00 65,000 25,893 .00 10,000 14,887 .00 1,000 .00 .00 31,000 20,379 .00 .00 .00 .00 1,000 .00 .00 461,000 248,235 .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 .00 .00 .00 .00 .00 .00 80,000 55,925 .00 8,000 359 .00 125,000 12,881 .00 67,000 395 .00 .00 .00 .00 5,000 .00 .00 1,000 1,892 .00 4,000 993 .00 .00 304 .00 300 184 .00 .00 .00 .00 290,300 72,934 .00 .00 ,00 ,00 .00 .00 .00 .00 .00 .00 -00 .00 .00 .00 686 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 City of Chubbuck Budget Worksheet Page: 3 Period: 00123 Mar 28, 2023 08:21AM Account Number Account 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 AeGount,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- 861,153- 1,159,000 - Modification Planned Salaries for FY24 -Prepared 03/27/2023 City of Chubbuck FY23 Salary Schedule _,. k1112023 Salary Grade 17 16 15 14 13 12. 11 10 8 5 4 Market Range Point Maxini'An7 Range r.3.,C� Minimum A[-cve `:1a•ke. +�i4 i:ic; 85% 89�c 9 Y 100% 107% 115° irela.icn .c mk. pcin.j Market Range 107x. thru 114%. Proficiency Range 89 thru94 95Y thru106 Hiring Range 564.10 $68.34 Less than 89% 568.35 572.02 $75.99 577.00 582.75 52.76 $56.42 $61.C3 $54.49 $57.23 $61.02 $61.03 $54.30 $68.74 $68.75 $73.88 $73.59 $77.16 $48.65 $51.10 $54.48 554.49 $57.41 $61.37 $61.38 $65.97 $65.98 $68.59 $4.3'1 $45.62 $48.65 $48.56 $51.25 $54.80 $54.81 $58.90 $55.91 $61.51 $38.79 $40.73 $43.43 $43.44 545.77 548.93 $48.44 $52.59 $52,60 554,92 $34.63 $36.37 $38.78 53-8.74 $140.95 $43.68 $43.64 $46.95 $46.36 549.014 $31.48 $33.06 $35.25 535.26 $37.15 $39.71 $34.72 Pr $#2.58 $42.69 544.58 $28.62 $30.06 $32.05 $32.06 $33.77 $35.10 $36.11 $39.80 $35.81 $40.53 $25.02 $27.32 $29.14 529.15 $30.70 $32.82 $32.83 535.28 $35.29 $36.54 $23.65 524.84 $26.49 $2.6.50 $27.41 $29.84 $24.85 $32.07 $32.08 533.49 $21.50 $22.58 $24.08 524.09 525.37 $27.12 $27.13 $29.1529.16 $30.45 $19.55 $20,53 $21.89 $21.90 $23.07 $24.66 $24.67 $26.50122.53 26.51 527.65 $17.77 518.66 $19.90 $19.91 $20.97 $22.42 522.43 $24.0924.16 $25.16 $15.61 517.44 $18.60 $18.61 $19.60 $20.95 $20.96 $22.52 $23.52 $15.52 $15.30 $17.38 517.39 518.32 519.58 $19.59 $21.04 $21.05 $21.95 $14.51 $15.23 $16.24 $16.25 517.12 $18.30 $18.31 $19.67 $13.65 520.54 $13.56 $14.24 $15.18 $15.19 516.00 $17.10 $17.11 $18.38 $15.39 $19.20 $12.67 $13.31 $14.19 $14.20 $14.95 $15.98 $15.99 $17.18 $17.13 517.94 .$11.84 5i2.44 $13.26 $13.27 513.97 $14.94 $14.95 $16.06 $16.07 $16.77 $11.07 $11.62 $12.39 $12.40 $13.06 $13.96 $13.97 $15.00 L$15,01 $15.67 i:ic; 85% 89�c 9 Y 100% 107% 115° irela.icn .c mk. pcin.j Planned Salaries for FY24 -Prepared 03/27/2023 FY24 Salary Distribution: Hiring Flange be I ow 8 Personnel Policy 3.3.2 Annual pay increases are determined using a market-based system. Employees whose salaries are below the market point for their position will receive a higher percentage increase than employees whose salaries are above the market point. The specific amount of each increase will be recommended by Market Flange 95 thru 106 4% Human Resources based on the employee's salary in proximity to the market point. Another factor is the .amount of the budget dedicated Above Market 107 thru 114 3% to salaries as determined by the department head in consultation with Human Resources and the Magor. FY24 Budget is Compiled from Individual Salary Projections (and related allocations): B C D E F G H I J FY23 Salary Adjusted 6.5% for 2022 inflation FY24 FY24 Percent Job Base Wage Grade Level Min Mkt Max Comparatio Base Wage Base Increase Patrol Sergeant $35.22 15 34.63 44.86 49=.04 86.20/a $37.33 6.0% Patrol Officer -First Class $29.39 13 28.62 33.77 46.53 ' 87.0% $31.15 6.4% Communications Officer - First Class $22.55 10 21.50 25.37 30.45 88.9% $23.90 6.0% Communications Officer First Class $22.79 10 21.50 25.37 30.45 89.8% $23.93 5.0% Communications Officer First Class $22.79 10 u 21.54 25.37 30.45 89.8% $23.93 5.0% Maintenance Mechanic 1 $2531 10 21.54 25.37 30.45 101.3% $26.74 4.0% Roadway Maintenance Worker 1 $23.18 8 17.77 20.97 25.16 114.5% $23.88 3.0% Planned Salaries for FY24 —Prepared 03/27/2023 FY24 B.a5e Salarie5 Budget - By Fund 3/27/2023, Exec 10-4131 45pOOG 10-4160 13 r OOD CS 10-4400 299r OD Parks 10-44,70,, 35 Gp 000 HSR 11-431.1, X55 Sr 000 Water 31-4341 712r 000 WW 32-4351, 629r 000 San 33-4331 $719p 000 Felice 2r3r000 Fire 1r 161r 000 Council 10-41.11, 3Gr000 Tata I 6r 99 2r 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 C 115% 2 2 115%+ 2 0 123 122 60 50 40 30 20 10 0 11 11 11 [ 89% 89% to <95% 95% to C 107% ■ FY23 ■ FY24 107% to 115% 115%+ Planned Salaries for FY24 —Prepared 03/27/2023 20 Police FY23 FY24 89% 10 16 89% to <95% 16 12 95% to r• 107% 11 9 107% to C 115% 0 0 115%+ 0 0 37 37 Fire FY23 FY24 E 89% 0 0 89% to <95% 19 25 95% to E 107% 16 9 107% to C 115% 0 0 115%+ 0 0 35 34 15 10 5 0 C 89% 30 25 20 15 10 5 0 C 89% 89% to <95°% 95% to 107% ■ FY23 ■ FY24 11 11 89% to <95% 95% to < 107% ■ FY23 ■ FY24 107% to C 115% 107% to e 115% 115%+ 115%+ Planned Salaries for FY24 —Prepared 03/27/2023 Public Works FY23 FY24 e 89% 3 4 89% to <95% 5 8 95% to E 107% 16 13 107% to E 115% 1 1 115%+ 1 0 26 26 Community Services FY23 FY24 e 89% 2 3 89% to <95% 3 4 95% to < 107% 6 4 107% to E 115% 0 0 115%+ 0 0 11 11 20 15 10 5 0 7 6 5 4 3 2 1 0 ON 11 11 e 89% 89% to e95% 95% to e 107% ■ FY23 ■ FY24 11 11 11 e 89% 89% to e95% 95%a to e 107% 0 FY23 0 FY24 mm m 107%toe 115%+ 115% 107% to e 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 C 115% 1 1 115%+ 1 0 7 7 7 6 5 4 3 2 1 0 6 5 4 3 2 1 0 01 11 C 89% 89% to <95% 95% to C 107% ■ FY23 ■ FY24 c 89% 89% to <95% 95% to ¢ 107% ■ FY23 ■ FY24 107% to [ 115%+ 115% on 1 107% to E 115%+ 115% March Trend. Cases by Type Crealad Las190 Days R—dcount 221 11 Ou=mess F ies: compare mm TacnnoiRgy MedH W_ Repan (SR -cases by TOO February Trend: Cases by Type _reared Lasl - pays Record Caunl 251 lw Buolrress Rules Camps ee wilh TechnWagY Model View Repan (SR -Cases by Type) IT Service Reviews •� Trend. OPENED Last 30 Days •• Ra 57 tmaswnme ■ Appu,suon ■ Business Ruies:: FW—Gena Dser K'Renen[e ■ New Repw(SR- RendOpened Lasl K DaysV 3C Trend: OPENED Last 30 Days %• Ty" 77 Inlaurumurr ■ Appil-don ■ Rosiness Rules Follow trend (hav UpewMnce ■ View Repod {SR -Trend Opened Lasl 30 na Trend OPENED Last 31 to 60 Days 85 Busness Rules. Fmmw Geed Vi Repod (SR - TnM: Opened Last 31 to 60 Day Trend: OPENED Last 31 to 89 Business Rules Follow bend VI-, Report ;SR - Trend Opened Last 31 to Trend. OPENED Last 811090 D_ •• 86 Bus— RW.. Fallmv 1e 0 New Report (SR - 7tand- Oponed Last fit to F Da• Trend: OPENED Last fit to.., =a 95 Business Rules Follow trend ..ew Re",ISR -7reed Opened Last Bi la Trend. Cases by Priority C,aatsd Last 90 Days Record count 210 11 B.S.M Auk' Preaedva vs Real.. New Rem (SR -case by Pway) Trend: Cases 4y Priority erealed Lasi yo nags R --d Cwrd 248 lw Business Rub F—dive vs Reaolive Vbw Raperx (SR - Gases by R•ieriiy) ai,pr,n. 5 -Madam ■ 7-Hph■ 1 - WalCh g ■ 9-UgmR ■ 3A ■ EH pdedry 5 - M.T'— ■ 7-Friyh ■ 3 -Leve t- waladng ■ 9 - psglmt ■ City of Chubbuck General Fund Fiscal Year 2024 Budget FY23.fFY24 Fiscal Year 2023 Fiscal Year 2024 Difference 10-4211-110 LE SALARIES 2,285,000 2,366,000 81,000 0.04 5% Fund Compensation Plan 1D-4211,111 LE OVERTIME 12,785 107,000 94,215 7.37 Adjustment to move CIT from Salaries 10.4211,210 LE FICA 180,000 185,000' 51000 0.03 7.15% 10-4211-220 LE RETIREMENT 295,000 32200 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 855,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-4215311 LE FORMS, CITATION 1,500 1,500 0 0.00 10-4215315 LE PAPER COPY ETC 2,000 2,000 0 0.00 104215-316 LE MISC DUES, FEES, SUBSCRIPTI 6,000 6,000 0 0.00 10-4215,317 LE EMPLOYMENT COST 2,500 2,500 0 0.00 104215.331 LE FIREARMS 10,000 10,000 0 0.00 10-4215333 LE PATROL NEW PURCHASE 8,450 9,000 550 0.07 Increase expense of equipment 10.4215-334 LE PARTOL EQUIP REPAIR 4,300 4,300 0 0.00 10.4215-335 LE DETECTIVE 2,750 2,750 0 0.00 10-4215336 LE EVIDENCE SUPPLIES 4,500 4,500 0 0.00 10-4215,340 LE OFFICE EQUIP REPAIR 2,500 2,500 0 0.00 10-4215-341 LE COMPUTER PURCHASE 50,0110 50,000 0 0.00 10-4215-343 LE COMPUTER CONSULTING 5,000 5,000 0 0.00 10.4215-345 LE COMPUTER CONTRACTS 43,000 45,000 2,000 0.05 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,0011 0 0.00 10.4215-373 LE TRAINING TRAVEL 13,000 13,000 0 0.00 10-4215-420 LE LEGAL 82,000 82,000 0 0.00 10-4215-602 LE MISC, ETC. 4,500 4,500 0 0.00 10-4215-850 LE ANIMAL CONT. SHELTER 3,000 10,000 7,000 2.33 New Building 10-0215.852 LE ANIMAL CONT. BUILDING D 30,000 30,000 New Building 10-4215,761 LE CLOTHING ALLOWANCE 12,000 12,000 0 O.DO 10-4215-762 LE CLOTHING ALLOWANCE NOWSWOR 2,000 2,000 0 0.00 . 10-4222510 LE TELEPHONE) REPAIR 35,000 35,000 0 0.00 10-4222-630 LE RADIOYREPAIR 1,200 1,200 0 0.00 10.4222,633 LE BATTERIES 500 500 0 0.00 1D-4222-634 LE DISPATCH 1,500 1,500 0 0.00 10-4222-635 LETFLETYPF 8,000 17,175 9,175 1.15 10-4223-208 LE DARE 6,500 8,500 0 0.00 10-4229-350 LE FUEL & LUBRICANTS 58,000 58,000 0 0.00 10-4229-520 LE ELECTRICY 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 MAINTI FURNACE 10,000 10,000 0 0.00 10-4229-610 LE VEHICLE REPAIR 18,500 18,500 0 0.00 10-422MOD LE CAP PLNG 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 LEASEIPURCHASE 80,000 80,000 0 0.00 Law Enforcement Total 4,329,500 4,718,325 388,825 0.09 SK 6.4f 4.6K 3.2K 1.6K 513 541 Agency Assists 7,54K 7.42K 11 1 All matures Period Comparison 105 125 Child Protection LI's P1.. 05 -fpr -2421 - 04 -.fpr -2022 451 469 Crash P2. 05 -Apr -2022 - 04 -Apr -2023 900805 - f 845 720 10 540 364 180 WELFARE CHECK 602 519 fff- 513 541 472 4€31 475 448i 451 469 t i & -f-]F- All Natures 444 F 389 351 � 290 258 I ■I jj1 � 1 1 7�--� 291 229 212 193 207 205 173 164206 16 ANIMAL AGENCY CIVIL SUSPICIOUS ACCIDENT DISTURBANCE THEFT PARKING ORDINANCE JUVENILE HARASSMENT VIN PROBLEM ASSIST PROBLEM VIOL PROS INSPECTION P1: 05 -Apr -2{}2.1 - D4 -Apr -2{}22 P2: 05 -Apr -2022 - 4 -Apr -2023 ALARM