|
Fiscal Year 2023 12/31/2020
<br />ACTUAL
<br />2018
<br />ACTUAL
<br />2019
<br />ACTUAL
<br />2020
<br />ACTUAL
<br />2021
<br />ACTUAL
<br />2022
<br />BUDGET
<br />2023 EST. ACTUAL 2023
<br />BUDGET
<br />2024
<br />GENERAL FUND EXPENDITURES DETAIL
<br />PUBLIC WORKS
<br />101-4110-31-0000 PW REGULAR EMPLOYEE 278,917$ 286,839$ 296,772$ 269,133$ 293,003 326,120$ 301,102$ 323,264$ -0.88% INCLUDES ESTIMATED 3.5 % WAGE ADJUSTMENTS
<br />101-4110-31-0100 PW MECHANIC 36,837 37,966 36,354 39,933 42,756 45,772 41,938 47,339 3.42% INCLUDES ESTIMATED 3.5 % WAGE ADJUSTMENTS
<br />101-4111-31-0000 PW OVERTIME EMPLOYEE 13,518 12,285 6,382 8,932 18,168 15,100 18,300 17,000 12.58% INCLUDES ESTIMATED 3.5 % WAGE ADJUSTMENTS
<br />101-4111-31-0100 PW OVERTIME MECHANIC 141 318 41 56 180 373 442 400 7.20% 2024 PROJECTED RUNRATE
<br />101-4112-31-0000 PW PART-TIME EMPLOYEE 30,018 30,300 28,292 5,055 25,580 40,750 33,776 34,750 -14.72% 2024 PROJECTED RUNRATE
<br />101-4121-31-0000 PW PERA 21,775 22,611 23,523 20,756 23,547 25,591 22,305 25,520 -0.28% BASED ON CURRENT PERA FUNDING RATE
<br />101-4121-31-0100 PW MECHANIC ALLOC- PERA 2,845 2,948 3,022 3,088 3,354 3,461 3,441 3,550 2.59% BASED ON CURRENT PERA FUNDING RATE
<br />101-4122-31-0000 PW FICA 22,682 23,654 24,209 18,175 23,084 26,909 22,585 28,689 6.61% BASED ON ER .0765 OF GROSS
<br />101-4122-31-0100 PW MECHANIC ALLOC- FICA 3,028 3,157 3,243 3,318 3,555 3,530 3,652 3,652 3.45% BASED ON ER .0765 OF GROSS
<br />101-4131-31-0000 PW INSURANCE HEALTH 60,325 60,641 69,346 67,073 64,589 68,201 51,574 68,734 0.78% SPLIT 4.2% PREMUIM INCREASE 2024
<br />101-4131-31-0100 PW MECHANIC ALLOC- HI 1,680 1,915 1,203 2,170 2,117 2,150 2,152 2,285 6.28% 56% Tucker
<br />101-4135-31-0000 PW INSURANCE WC 13,436 13,198 14,354 16,239 15,689 15,248 15,131 21,466 40.78% BASED ON 2022/2023 RENEWAL and 23/24 LMC rate information
<br />101-4140-31-0000 PW UNIFORM EXPENSES 9,137 12,504 13,734 12,824 13,239 13,725 15,727 16,513 20.31% 2023 EST ACTUAL + 5%
<br />101-4140-31-0100 PW UNIFORM EXPENSES - MECH 727 1,172 396 187 168 350 200 200 -42.86% 2024 PROJECTED RUNRATE
<br />101-4212-31-0100 PW MOTOR FUELS MISC 1,080 3,460 1,790 571 596 1,250 544 600 -52.00% 2024 PROJECTED RUNRATE
<br />101-4212-31-0200 PW MOTOR FUELS NB 88,671 77,009 73,048 7,164 - - - - 0.00% NEW BRIGHTON PW ADDED ON SITE RE-FUELING FEB 2021
<br />101-4212-31-0300 PW FUEL - MWMO 1,488 1,164 1,373 1,676 2,092 2,855 2,855 3,150 10.33% From 2024 Fuel Usage Spreadsheet
<br />101-4212-31-0400 PW FUEL - SANB #282 8,710 10,480 6,295 6,449 10,100 14,866 13,993 15,536 4.51% From 2024 Fuel Usage Spreadsheet
<br />101-4212-31-0600 PW FUEL - STREET/PARKS 14,846 14,229 13,133 11,695 16,721 23,947 23,223 21,415 -10.57% From 2024 Fuel Usage Spreadsheet
<br />101-4221-31-0100 PW VEHICLE REPAIRS/PARTS 16,540 13,556 11,523 14,520 22,303 18,500 16,985 18,000 -2.70% 2024 PROJECTED RUNRATE
<br />101-4223-31-0000 PW SMALL TOOLS MECHANIC 750 70 - 375 487 600 425 600 0.00% KEPT FLAT
<br />101-4223-31-0100 PW SMALL TOOLS 583 447 397 260 310 500 368 500 0.00% KEPT FLAT
<br />101-4224-31-0000 PW STREET SIGNS 464 2,763 2,758 785 933 2,550 1,000 2,550 0.00% KEPT FLAT
<br />101-4226-31-0000 PW GENERAL SUPPLIES 10,838 6,879 10,833 8,805 7,840 10,525 7,844 9,000 -14.49% 2024 PROJECTED RUNRATE
<br />101-4226-31-0100 PW SHOP SUPPLIES 1,499 562 2,622 1,331 2,676 3,000 2,854 3,000 0.00% KEPT FLAT
<br />101-4228-31-0000 PW STREET REPAIR & MAINTENANCE 16,621 91,192 19,956 25,857 30,338 28,362 26,518 27,000 -4.80% 2024 PROJECTED RUNRATE
<br />101-4229-31-0000 PW STREET CHEMICALS & SAND 31,281 32,630 23,415 18,913 29,976 24,450 24,990 29,640 21.23% 2024 - 300 tons of salt 150 x $96.38 (2023/24 rate) 150 x 101.20 (est 5% 24/25)
<br />101-4230-31-0000 PW STORMWATER MAINTENANCE 5,817 7,247 720 - 1,440 - 0.00% Moved to Stormwater utility fund
<br />101-4303-31-0000 PW CONTRACTED ENGINEER 33,093 45,932 27,986 27,623 33,386 37,444 36,019 37,820 1.00% 2023 EST ACTUAL + 5%
<br />101-4309-31-0000 PW CONTRACTED IT & SFTW SUPPORT 13,155 13,566 12,724 12,242 11,342 14,870 14,417 15,500 4.24% BASED ON CONTRACTED IT /SW SPREADSHEET
<br />101-4310-31-0000 PW MISC. CONTRACTED SERVICES 43,978 24,399 35,856 36,376 27,959 17,000 34,834 51,800 204.71% BASED ON MISC CONTRACTED SERVICES SPREADSHEET
<br />101-4325-31-0000 PW COMMUNICATIONS 2,918 3,425 448 4,583 6,117 6,175 5,472 4,680 -24.21% KEPT FLAT
<br />101-4339-31-0000 PW EQUIP REPAIRS & MAINTENANCE 6,452 8,701 6,383 5,630 11,639 8,750 10,418 12,000 37.14% 2024 PROJECTED RUNRATE
<br />101-4340-31-0000 PW BLDG REPAIRS & MAINTENANCE 380 2,882 - 255 - - - - 0.00% now included in city buiding repairs
<br />101-4341-31-0000 PW TRAINING, CONF. & MTG. 3,499 6,835 731 1,886 6,469 5,450 6,820 6,500 19.27% 2024 PROJECTED RUNRATE
<br />101-4342-31-0000 PW MEMBERSHIPS & DUES 1,143 1,428 1,166 879 594 1,050 632 800 -23.81% 2024 PROJECTED RUNRATE
<br />101-4344-31-0000 PW TRAINING CERT PROGRAMS 46 123 23 450 - 625 560 625 0.00% KEPT FLAT
<br />101-4345-31-0000 PW GRANT REIMB EXPENDITURES 14,338 2,832 - 5,000 28,898 5,000 5,004 5,000 0.00% grant exps for opportunity grants projected in revenue section
<br />101-4381-31-0000 PW STREETLIGHTS & SIGNALS 65,516 61,512 60,087 68,549 80,755 83,637 82,227 85,728 2.50% 2024 PROJECTED RUNRATE
<br />101-4435-31-0000 PW STORM CLEAN-UP COSTS 500 - 3,450 2,150 1,359 - - 0.00%
<br />101-4499-31-0000 PW MISCELLANEOUS - 44 60 738 7,224 165 150 165 -0.02% KEPT FLAT
<br />TOTAL 879,273$ 942,872$ 837,648$ 731,698$ 870,585$ 898,851$ 850,477$ 944,971$ 5.13%
|