|
Fiscal Year 2022 12/31/2020 $14.00
<br />ACTUAL
<br />2017
<br />ACTUAL
<br />2018
<br />ACTUAL
<br />2019
<br />ACTUAL
<br />2020
<br />BUDGET
<br />2021
<br />EST. ACTUAL
<br />2021
<br />BUDGET
<br />2022
<br />GENERAL FUND EXPENDITURES DETAIL
<br />PUBLIC WORKS
<br />101-4110-31-0000 PW REGULAR EMPLOYEE 269,329$ 278,917$ 286,839$ 296,772$ 292,796$ 267,565$ 307,706$ 5.09% INCLUDES ESTIMATED 2022 WAGE ADJUSTMENTS
<br />101-4110-31-0100 PW MECHANIC 35,525 36,837 37,966 36,354 40,042 39,577 42,811 6.92% INCLUDES ESTIMATED 2022 WAGE ADJUSTMENTS
<br />101-4111-31-0000 PW OVERTIME EMPLOYEE 2,897 13,518 12,285 6,382 17,900 12,400 15,939 -10.96% INCLUDES ESTIMATED 2022 WAGE ADJUSTMENTS
<br />101-4111-31-0100 PW OVERTIME MECHANIC 300 141 318 41 350 350 362 3.50% Based on last three years
<br />101-4112-31-0000 PW PART-TIME EMPLOYEE 26,592 30,018 30,300 28,292 36,886 10,500 41,312 12.00% PT WAGE INCREASED TO HIRE SEASONAL EE'S/RINKS NOT OPEN IN JAN-MAR 21
<br />101-4121-31-0000 PW PERA 20,741 21,775 22,611 23,523 23,302 20,997 24,273 4.17% BASED ON CURRENT PERA FUNDING RATE
<br />101-4121-31-0100 PW MECHANIC ALLOC- PERA 2,742 2,845 2,948 3,022 3,029 2,995 3,238 6.89% BASED ON CURRENT PERA FUNDING RATE
<br />101-4122-31-0000 PW FICA 21,531 22,682 23,654 24,209 26,590 22,221 27,919 5.00% BASED ON ER .0765 OF GROSS
<br />101-4122-31-0100 PW MECHANIC ALLOC- FICA 2,899 3,028 3,157 3,243 3,090 3,054 3,303 6.89% BASED ON ER .0765 OF GROSS
<br />101-4131-31-0000 PW INSURANCE HEALTH 57,127 60,325 60,641 69,346 72,179 66,796 72,064 -0.16% SPLIT 3.2% PREMUIM DECREASE IN 2022
<br />101-4131-31-0100 PW MECHANIC ALLOC- HI 1,310 1,680 1,915 1,203 2,117 2,117 2,117 0.00% 56% Tucker
<br />101-4135-31-0000 PW INSURANCE WC 14,096 13,436 13,198 14,354 19,852 18,536 18,085 -8.90% BASED ON 2021/2022 RENEWAL and 22/23 LMC rate information
<br />101-4140-31-0000 PW UNIFORM EXPENSES 9,650 9,137 12,504 13,734 9,738 11,341 12,715 30.57% 2022 PROJECTED RUN RATE
<br />101-4140-31-0100 PW UNIFORM EXPENSES - MECH 1,103 727 1,172 396 833 833 900 7.95% 2022 PROJECTED RUN RATE
<br />101-4212-31-0100 PW MOTOR FUELS MISC 976 1,080 3,460 1,790 1,434 1,434 1,550 8.06% Other non-contracted motor oil and gas
<br />101-4212-31-0200 PW MOTOR FUELS NB 75,716 88,671 77,009 73,048 7,059 6,583 - -100.00% NEW BRIGHTON PW ADDED ON SITE RE-FUELING FEB 2021
<br />101-4212-31-0300 PW FUEL - MWMO 1,462 1,488 1,164 1,373 1,410 1,546 1,765 25.18% 2021 contracted cost per gal $1.98 / 2022 projection $2.73 / 3yr avg usage
<br />101-4212-31-0400 PW FUEL - SANB #282 3,209 8,710 10,480 6,295 9,966 6,426 10,300 3.35% 2021 contracted cost per gal $1.98 / 2022 projection $2.73 / 3yr avg usage
<br />101-4212-31-0600 PW FUEL - STREET/PARKS 11,362 14,846 14,229 13,133 16,332 19,363 26,145 60.08% 2021 contracted cost per gal $1.98 / 2022 projection $2.73 / 3yr avg usage
<br />101-4221-31-0100 PW VEHICLE REPAIRS/PARTS 8,816 16,540 13,556 11,523 14,566 12,500 15,003 3.00% 2022 PROJECTED RUN RATE
<br />101-4223-31-0000 PW SMALL TOOLS MECHANIC 1,720 750 70 - 595 375 600 0.78% 2022 PROJECTED RUN RATE
<br />101-4223-31-0100 PW SMALL TOOLS 473 583 447 397 1,040 300 500 -51.94% 2022 PROJECTED RUN RATE
<br />101-4224-31-0000 PW STREET SIGNS 563 464 2,763 2,758 2,435 850 2,550 4.70% 2022 PROJECTED RUN RATE
<br />101-4226-31-0000 PW GENERAL SUPPLIES 7,485 10,838 6,879 10,833 8,500 8,750 9,625 13.24% 2022 PROJECTED RUN RATE
<br />101-4226-31-0100 PW SHOP SUPPLIES 1,958 1,499 562 2,622 3,500 2,550 2,753 -21.34% 2022 PROJECTED RUN RATE
<br />101-4228-31-0000 PW STREET REPAIR & MAINTENANCE 15,571 16,621 91,192 19,956 40,429 25,812 26,500 -34.45% MOVED SEALCOATING COST TO INFRASTRUCTURE FUND
<br />101-4229-31-0000 PW STREET CHEMICALS & SAND 23,655 31,281 32,630 23,415 28,100 22,228 24,451 -12.99% 2022 - 250 tons of salt - 300 in 20/21
<br />101-4230-31-0000 PW STORMWATER MAINTENANCE 4,101 5,817 7,247 720 - - - 0.00% Moved to Stormwater utility fund
<br />101-4303-31-0000 PW CONTRACTED ENGINEER 27,572 33,093 45,932 27,986 18,415 30,000 32,500 76.48% 2021 HIGHER LEVEL OF ACTIVITY & AUGEMENTING LOSS OF PWD
<br />101-4309-31-0000 PW CONTRACTED IT & SFTW SUPPORT 7,423 13,155 13,566 12,724 13,000 12,139 13,000 0.00% BASED ON CONTRACTED IT /SW SPREADSHEET
<br />101-4310-31-0000 PW MISC. CONTRACTED SERVICES 24,941 43,978 24,399 35,856 38,174 37,050 36,100 -5.43% SALO PARK CAM AND VARIOUS RELATED COSTS
<br />101-4325-31-0000 PW COMMUNICATIONS 3,246 2,918 3,425 448 3,490 3,916 4,337 24.27% BASED ON COMMUNICATION SPREADSHEET
<br />101-4339-31-0000 PW EQUIP REPAIRS & MAINTENANCE 14,786 6,452 8,701 6,383 14,790 5,900 7,500 -49.29% 2022 PROJECTED RUN RATE
<br />101-4340-31-0000 PW BLDG REPAIRS & MAINTENANCE 348 380 2,882 - 2,000 - - -100.00% now included in city buiding repairs
<br />101-4341-31-0000 PW TRAINING, CONF. & MTG.5,475 3,499 6,835 731 6,630 1,250 4,250 -35.90% 2022 RETURNING TO PRE COVID ACTIVITY LEVEL
<br />101-4342-31-0000 PW MEMBERSHIPS & DUES 1,197 1,143 1,428 1,166 1,273 750 1,273 0.00% 2022 RETURNING TO PRE COVID ACTIVITY LEVEL
<br />101-4344-31-0000 PW TRAINING CERT PROGRAMS 935 46 123 23 969 550 600 -38.08% 2022 PROJECTED RUN RATE
<br />101-4345-31-0000 PW GRANT REIMB EXPENDITURES 540 14,338 2,832 - 5,000 1,000 5,000 0.00% grant exps for opportunity grants projected in revenue section
<br />101-4381-31-0000 PW STREETLIGHTS & SIGNALS 65,478 65,516 61,512 60,087 67,148 65,800 73,038 8.77% 2022 based on usage run rates and XCEL and CenterPoint rate increases
<br />101-4435-31-0000 PW STORM CLEAN-UP COSTS - 500 - 3,450 - - - 0.00%
<br />101-4499-31-0000 PW MISCELLANEOUS 990 - 44 60 160 - 160 0.00%
<br />TOTAL 775,842$ 879,273$ 942,872$ 837,648$ 855,121$ 746,354$ 872,244$ 2.00%
<br />110
|