|
Fiscal Year 202212/31/2020 $14.00ACTUAL 2017ACTUAL2018ACTUAL2019ACTUAL2020BUDGET2021EST. ACTUAL2021BUDGET2022GENERAL FUND EXPENDITURES DETAILPUBLIC WORKS101‐4110‐31‐0000 PW REGULAR EMPLOYEE 269,329$ 278,917$ 286,839$ 296,772$ 292,796$ 276,705$ 306,681$ 4.74% INCLUDES ESTIMATED 2022 WAGE ADJUSTMENTS 101‐4110‐31‐0100 PW MECHANIC 35,525 36,837 37,966 36,354 40,042 40,042 41,811 4.42% INCLUDES ESTIMATED 2022 WAGE ADJUSTMENTS 101‐4111‐31‐0000 PW OVERTIME EMPLOYEE 2,897 13,518 12,285 6,382 17,900 15,400 15,939 ‐10.96% INCLUDES ESTIMATED 2022 WAGE ADJUSTMENTS 101‐4111‐31‐0100 PW OVERTIME MECHANIC 300 141 318 41 350 350 362 3.50% Based on last three years 101‐4112‐31‐0000 PW PART‐TIME EMPLOYEE 26,592 30,018 30,300 28,292 36,886 20,500 41,312 12.00% PT WAGE INCREASED TO HIRE SEASONAL EE'S/RINKS NOT OPEN IN JAN‐MAR 21101‐4121‐31‐0000 PW PERA 20,741 21,775 22,611 23,523 23,302 21,908 24,197 3.84% BASED ON CURRENT PERA FUNDING RATE 101‐4121‐31‐0100 PW MECHANIC ALLOC‐ PERA 2,742 2,845 2,948 3,022 3,029 3,029 3,163 4.41% BASED ON CURRENT PERA FUNDING RATE 101‐4122‐31‐0000 PW FICA 21,531 22,682 23,654 24,209 26,590 23,914 27,841 4.70% BASED ON ER .0765 OF GROSS101‐4122‐31‐0100 PW MECHANIC ALLOC‐ FICA 2,899 3,028 3,157 3,243 3,090 3,090 3,226 4.41% BASED ON ER .0765 OF GROSS101‐4131‐31‐0000 PW INSURANCE HEALTH 57,127 60,325 60,641 69,346 72,179 68,809 69,544 ‐3.65% SPLIT 3.2% PREMUIM DECREASE IN 2022101‐4131‐31‐0100 PW MECHANIC ALLOC‐ HI 1,310 1,680 1,915 1,203 2,117 2,117 2,117 0.00% 56% Tucker101‐4135‐31‐0000 PW INSURANCE WC 14,096 13,436 13,198 14,354 19,852 18,536 19,880 0.14% 2021/2022 RENEWAL101‐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 RATE101‐4140‐31‐0100 PW UNIFORM EXPENSES ‐ MECH 1,103 727 1,172 396 833 833 833 0.00% 2022 PROJECTED RUN RATE101‐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 gas101‐4212‐31‐0200 PW MOTOR FUELS NB 75,716 88,671 77,009 73,048 7,059 7,059 ‐ ‐100.00% NEW BRIGHTON PW ADDED ON SITE RE‐FUELING FEB 2021101‐4212‐31‐0300 PW FUEL ‐ MWMO 1,462 1,488 1,164 1,373 1,410 1,481 1,515 7.45% 2021 contracted cost per gal $1.98 / 2022 projection $2.41 / 3yr avg usage101‐4212‐31‐0400 PW FUEL ‐ SANB #282 3,209 8,710 10,480 6,295 9,966 6,882 9,210 ‐7.59% 2021 contracted cost per gal $1.98 / 2022 projection $2.41 / 3yr avg usage101‐4212‐31‐0600 PW FUEL ‐ STREET/PARKS 11,362 14,846 14,229 13,133 16,332 21,908 23,900 46.34% 2021 contracted cost per gal $1.98 / 2022 projection $2.41 / 3yr avg usage101‐4221‐31‐0100 PW VEHICLE REPAIRS/PARTS 8,816 16,540 13,556 11,523 14,566 14,566 15,003 3.00% 2022 PROJECTED RUN RATE101‐4223‐31‐0000 PW SMALL TOOLS MECHANIC 1,720 750 70 ‐ 595 375 600 0.78% 2022 PROJECTED RUN RATE101‐4223‐31‐0100 PW SMALL TOOLS 473 583 447 397 1,040 500 500 ‐51.94% 2022 PROJECTED RUN RATE101‐4224‐31‐0000 PW STREET SIGNS 563 464 2,763 2,758 2,435 1,450 2,550 4.70% 2022 PROJECTED RUN RATE101‐4226‐31‐0000 PW GENERAL SUPPLIES 7,485 10,838 6,879 10,833 8,500 10,133 10,437 22.79% 2022 PROJECTED RUN RATE101‐4226‐31‐0100 PW SHOP SUPPLIES 1,958 1,499 562 2,622 3,500 2,550 2,753 ‐21.34% 2022 PROJECTED RUN RATE101‐4228‐31‐0000 PW STREET REPAIR & MAINTENANCE 15,571 16,621 91,192 19,956 40,429 20,555 26,500 ‐34.45% MOVED SEALCOATING COST TO INFRASTRUCTURE FUND101‐4229‐31‐0000 PW STREET CHEMICALS & SAND 23,655 31,281 32,630 23,415 28,100 18,922 24,366 ‐13.29% 2022 ‐ 350 tons of salt ‐ 350 in 20/21101‐4230‐31‐0000 PW STORMWATER MAINTENANCE 4,101 5,817 7,247 720 ‐ ‐ ‐ 0.00% Moved to Stormwater utility fund101‐4303‐31‐0000 PW CONTRACTED ENGINEER 27,572 33,093 45,932 27,986 18,415 30,000 22,500 22.18% 2021 HIGHER LEVEL OF ACTIVITY & AUGEMENTING LOSS OF PWD101‐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 SPREADSHEET101‐4310‐31‐0000 PW MISC. CONTRACTED SERVICES 24,941 43,978 24,399 35,856 38,174 35,050 36,100 ‐5.43% SALO PARK CAM AND VARIOUS RELATED COSTS101‐4325‐31‐0000 PW COMMUNICATIONS 3,246 2,918 3,425 448 3,490 3,916 4,337 24.27% BASED ON COMMUNICATION SPREADSHEET101‐4339‐31‐0000 PW EQUIP REPAIRS & MAINTENANCE 14,786 6,452 8,701 6,383 14,790 11,500 12,500 ‐15.48% 2022 PROJECTED RUN RATE101‐4340‐31‐0000 PW BLDG REPAIRS & MAINTENANCE 348 380 2,882 ‐ 2,000 500 2,000 0.00% 2022 PROJECTED RUN RATE101‐4341‐31‐0000 PW TRAINING, CONF. & MTG. 5,475 3,499 6,835 731 6,630 3,500 6,630 0.00% 2022 RETURNING TO PRE COVID ACTIVITY LEVEL 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 101‐4344‐31‐0000 PW TRAINING CERT PROGRAMS 935 46 123 23 969 550 600 ‐38.08% 2022 PROJECTED RUN RATE101‐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 101‐4381‐31‐0000 PW STREETLIGHTS & SIGNALS 65,478 65,516 61,512 60,087 67,148 65,103 71,614 6.65% 2022 based on usage run rates and XCEL and CenterPoint rate increases101‐4435‐31‐0000 PW STORM CLEAN‐UP COSTS‐ 500 ‐ 3,450 ‐ ‐ ‐ 0.00%101‐4499‐31‐0000 PW MISCELLANEOUS 990 ‐ 44 60 160 ‐ 160 0.00%TOTAL 775,842$ 879,273$ 942,872$ 837,648$ 855,121$ 778,398$ 864,219$ 1.06%
|