|
Fiscal Year 2023 12/31/2020
<br />ACTUAL
<br />2018
<br />ACTUAL
<br />2019
<br />ACTUAL
<br />2020
<br />ACTUAL
<br />2021
<br />BUDGET
<br />2022
<br />EST. ACTUAL
<br />2022
<br />BUDGET
<br />2023
<br />GENERAL FUND EXPENDITURES DETAIL
<br />PUBLIC WORKS
<br />101-4110-31-0000 PW REGULAR EMPLOYEE 278,917$ 286,839$ 296,772$ 269,133$ 307,706$ 295,823$ 326,120$ 5.98% INCLUDES ESTIMATED WAGE ADJUSTMENTS
<br />101-4110-31-0100 PW MECHANIC 36,837 37,966 36,354 39,933 42,811 42,141 45,772 6.92% INCLUDES ESTIMATED WAGE ADJUSTMENTS
<br />101-4111-31-0000 PW OVERTIME EMPLOYEE 13,518 12,285 6,382 8,932 15,939 14,313 15,100 -5.26% INCLUDES ESTIMATED WAGE ADJUSTMENTS
<br />101-4111-31-0100 PW OVERTIME MECHANIC 141 318 41 56 362 362 373 3.00% INFLATE 2022 BUDGET 3 PERC
<br />101-4112-31-0000 PW PART-TIME EMPLOYEE 30,018 30,300 28,292 5,055 41,312 29,000 40,750 -1.36% 2023 PROJECTED RUN RATE
<br />101-4121-31-0000 PW PERA 21,775 22,611 23,523 20,756 24,273 23,260 25,592 5.43% BASED ON CURRENT PERA FUNDING RATE
<br />101-4121-31-0100 PW MECHANIC ALLOC- PERA 2,845 2,948 3,022 3,088 3,238 3,188 3,461 6.88% BASED ON CURRENT PERA FUNDING RATE
<br />101-4122-31-0000 PW FICA 22,682 23,654 24,209 18,175 27,919 23,894 26,909 -3.62% BASED ON ER .0765 OF GROSS
<br />101-4122-31-0100 PW MECHANIC ALLOC- FICA 3,028 3,157 3,243 3,318 3,303 3,251 3,530 6.88% BASED ON ER .0765 OF GROSS
<br />101-4131-31-0000 PW INSURANCE HEALTH 60,325 60,641 69,346 67,073 72,064 65,253 68,201 -5.36% SPLIT 10.85% PREMUIM INCREASE 2023/STAFF ELECTIONS
<br />101-4131-31-0100 PW MECHANIC ALLOC- HI 1,680 1,915 1,203 2,170 2,117 2,102 2,150 1.56% 56% Tucker
<br />101-4135-31-0000 PW INSURANCE WC 13,436 13,198 14,354 16,239 18,085 15,690 15,248 -15.69% 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 12,715 12,708 13,725 7.94% 2023 PROJECTED RUN RATE
<br />101-4140-31-0100 PW UNIFORM EXPENSES - MECH 727 1,172 396 187 900 300 350 -61.10% 2023 PROJECTED RUN RATE
<br />101-4212-31-0100 PW MOTOR FUELS MISC 1,080 3,460 1,790 571 1,550 750 1,250 -19.35% Other non-contracted motor oil and gas
<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 1,765 2,145 2,855 61.76% 2022 contracted cost per gal $2.94 / 2023 projection $3.82 / 2% increase gallons used
<br />101-4212-31-0400 PW FUEL - SANB #282 8,710 10,480 6,295 6,449 10,300 11,211 14,866 44.33% 2022 contracted cost per gal $2.94 / 2023 projection $3.82 / 2% increase gallons used
<br />101-4212-31-0600 PW FUEL - STREET/PARKS 14,846 14,229 13,133 11,695 26,145 15,450 23,947 -8.41% 2022 contracted cost per gal $2.94 / 2023 projection $3.82 / 2% increase gallons used
<br />101-4221-31-0100 PW VEHICLE REPAIRS/PARTS 16,540 13,556 11,523 14,520 15,003 21,889 18,500 23.31% 2023 PROJECTED RUNRATE
<br />101-4223-31-0000 PW SMALL TOOLS MECHANIC 750 70 - 375 600 475 600 0.00% KEPT FLAT
<br />101-4223-31-0100 PW SMALL TOOLS 583 447 397 260 500 500 500 0.00% KEPT FLAT
<br />101-4224-31-0000 PW STREET SIGNS 464 2,763 2,758 785 2,550 1,150 2,550 0.00% KEPT FLAT
<br />101-4226-31-0000 PW GENERAL SUPPLIES 10,838 6,879 10,833 8,805 9,625 8,750 10,525 9.35% 2023 PROJECTED RUNRATE
<br />101-4226-31-0100 PW SHOP SUPPLIES 1,499 562 2,622 1,331 2,753 2,753 3,000 8.97% 2023 PROJECTED RUNRATE
<br />101-4228-31-0000 PW STREET REPAIR & MAINTENANCE 16,621 91,192 19,956 25,857 26,500 26,757 28,362 7.03% 2023 PROJECTED RUNRATE
<br />101-4229-31-0000 PW STREET CHEMICALS & SAND 31,281 32,630 23,415 18,913 24,451 19,581 24,450 0.00% 2023 - 250 tons of salt
<br />101-4230-31-0000 PW STORMWATER MAINTENANCE 5,817 7,247 720 - - - - 0.00% Moved to Stormwater utility fund
<br />101-4303-31-0000 PW CONTRACTED ENGINEER 33,093 45,932 27,986 27,623 32,500 35,258 37,444 15.21% 2022-23 INFLATION IMPACT ON RATES
<br />101-4309-31-0000 PW CONTRACTED IT & SFTW SUPPORT 13,155 13,566 12,724 12,242 13,000 12,931 14,870 14.38% BASED ON CONTRACTED IT /SW SPREADSHEET
<br />101-4310-31-0000 PW MISC. CONTRACTED SERVICES 43,978 24,399 35,856 36,376 36,100 36,100 17,000 -52.91% SALO PARK CAM AND VARIOUS RELATED COSTS
<br />101-4325-31-0000 PW COMMUNICATIONS 2,918 3,425 448 4,583 4,337 5,887 6,175 42.38% BASED ON COMMUNICATION SPREADSHEET, CENTURYLINK 2022 FOR PW
<br />101-4339-31-0000 PW EQUIP REPAIRS & MAINTENANCE 6,452 8,701 6,383 5,630 7,500 9,632 8,750 16.67% 2023 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 4,250 5,170 5,450 28.24% 2023 PROJECTED RUNRATE
<br />101-4342-31-0000 PW MEMBERSHIPS & DUES 1,143 1,428 1,166 879 1,273 950 1,050 -17.55% 2023 PROJECTED RUNRATE
<br />101-4344-31-0000 PW TRAINING CERT PROGRAMS 46 123 23 450 600 600 625 4.17% 2023 PROJECTED RUNRATE
<br />101-4345-31-0000 PW GRANT REIMB EXPENDITURES 14,338 2,832 - 5,000 5,000 19,250 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 73,038 78,165 83,637 14.51% 2023 PROJECTED RUNRATE
<br />101-4435-31-0000 PW STORM CLEAN-UP COSTS 500 - 3,450 2,150 - - - 0.00%
<br />101-4499-31-0000 PW MISCELLANEOUS - 44 60 738 160 5,014 165 3.00% 2022 purchased 3 spare decorative street pole /lamps
<br />TOTAL 879,273$ 942,872$ 837,648$ 731,698$ 872,244$ 851,654$ 898,851$ 3.05%
<br />50
|