|
Fiscal Year 2021ACTUAL 2016ACTUAL 2017ACTUAL2018ACTUAL2019BUDGET2020EST. ACTUAL2020BUDGET2021GENERAL FUND EXPENDITURES DETAIL101‐4341‐25‐0000 EMS TRAINING, CONF. & MTG. 193 288 970 615 975 ‐ 995 2.00% 2021 PROJECTED RUN RATE101‐4350‐25‐0000 EMS PRINTED FORMS & ENVELOPES‐ ‐ ‐ ‐ 150 75 153 2.00% 2021 PROJECTED RUN RATETOTAL 67,806$ 71,895$ 76,393$ 79,515$ 83,937$ 82,671$ 89,106$ 6.16%PUBLIC WORKS101‐4110‐31‐0000 PW REGULAR EMPLOYEE273,345$ 269,329$ 278,917$ 286,839$ 299,039$ 213,436$ 292,796$ ‐2.09%2021 INCLUDES ESTIMATED 2021 WAGE ADJUSTMENTS AND UNIFORM 2020 EXCLUDES PR COSTS FOR COVID ‐19 ACTIVITY / CARES101‐4110‐31‐0100 PW MECHANIC 33,149 35,525 36,837 37,966 39,423 39,423 40,042 1.57% See dept summaries‐PR excludes other pay codes101‐4111‐31‐0000 PW OVERTIME EMPLOYEE 6,005 2,897 13,518 12,285 17,690 9,500 17,900 1.19% See dept summaries‐PR OT mapping to dept 31101‐4111‐31‐0100 PW OVERTIME MECHANIC 327 300 141 318 471 471 350 ‐25.69% Based on last three years 101‐4112‐31‐0000 PW PART‐TIME EMPLOYEE 27,407 26,592 30,018 30,300 35,812 29,292 36,886 3.00% Inflate 3% / assume extended winter conditions 101‐4121‐31‐0000 PW PERA21,168 20,741 21,775 22,611 23,755 16,720 23,302 ‐1.90% BASED ON CURRENT PERA FUNDING RATE 101‐4121‐31‐0100 PW MECHANIC ALLOC‐ PERA2,594 2,742 2,845 2,948 2,992 2,992 3,029 1.25% BASED ON CURRENT PERA FUNDING RATE 101‐4122‐31‐0000 PW FICA21,821 21,531 22,682 23,654 26,969 19,295 26,590 ‐1.41% BASED ON ER .0765 OF GROSS101‐4122‐31‐0100 PW MECHANIC ALLOC‐ FICA2,778 2,899 3,028 3,157 3,052 3,052 3,090 1.25% BASED ON ER .0765 OF GROSS101‐4131‐31‐0000 PW INSURANCE HEALTH59,897 57,127 60,325 60,641 63,874 65,650 72,179 13.00% SPLIT 9.4% PREMUIM INCREASE IN 2021101‐4131‐31‐0100 PW MECHANIC ALLOC‐ HI2,480 1,310 1,680 1,915 2,016 2,016 2,117 5.01% 56% Tucker101‐4135‐31‐0000 PW INSURANCE WC13,525 14,096 13,436 13,198 13,412 13,412 19,852 48.02% BASED ON 2020/2021 RENEWAL 101‐4140‐31‐0000 PW UNIFORM EXPENSES8,567 9,650 9,137 12,504 9,547 9,547 9,738 2.00% 2021 PROJECTED RUN RATE101‐4140‐31‐0100 PW UNIFORM EXPENSES ‐ MECH704 1,103 727 1,172 817 817 833 2.00% 2021 PROJECTED RUN RATE101‐4212‐31‐0100 PW MOTOR FUELS MISC1,304 976 1,080 3,460 1,406 1,406 1,434 2.00% Other non‐contracted fuel / oil101‐4212‐31‐0200 PW MOTOR FUELS NB 70,612 75,716 88,671 77,009 84,537 65,657 7,059 ‐91.65% NEW BRIGHTON PW ADDED ON SITE RE‐FUELING FEB 2021101‐4212‐31‐0300PW FUEL ‐ MWMO1,124 1,462 1,488 1,164 1,775 1,227 1,410 ‐20.56% 2020 cost per gal $2.13 / 2021 projection $2.28 / 3yr avg usage/ Deisel 2.45/2.57101‐4212‐31‐0400 PW FUEL ‐ SANB #2823,495 3,209 8,710 10,480 11,936 7,474 9,966 ‐16.50% 2020 cost per gal $2.13 / 2021 projection $2.28 / 3yr avg usage/ Deisel 2.45/2.57101‐4212‐31‐0600 PW FUEL ‐ STREET/PARKS10,356 11,362 14,846 14,229 22,203 13,265 16,332 ‐26.44% 2020 cost per gal $2.13 / 2021 projection $2.28 / 3yr avg usage/ Deisel 2.45/2.57101‐4221‐31‐0100 PW VEHICLE REPAIRS/PARTS6,618 8,816 16,540 13,556 14,280 11,515 14,566 2.00% 2021 PROJECTED RUN RATE101‐4223‐31‐0000 PW SMALL TOOLS MECHANIC 22 1,720 750 70 584 584 595 2.00% 2021 PROJECTED RUN RATE101‐4223‐31‐0100 PW SMALL TOOLS 1,314 473 583 447 1,020 597 1,040 2.00% 2021 PROJECTED RUN RATE101‐4224‐31‐0000 PW STREET SIGNS1,522 563 464 2,763 2,388 2,278 2,435 2.00% 2021 PROJECTED RUN RATE101‐4226‐31‐0000 PW GENERAL SUPPLIES6,417 7,485 10,838 6,879 11,674 10,075 8,500 ‐27.19% 2021 PROJECTED RUN RATE101‐4226‐31‐0100 PW SHOP SUPPLIES1,678 1,958 1,499 562 2,208 2,208 3,500 58.50% 2021 PROJECTED RUN RATE More general supplies being recognized as shop supplies101‐4228‐31‐0000 PW STREET REPAIR & MAINTENANCE61,727 15,571 16,621 91,192 73,950 23,500 40,429 ‐45.33% MOVED SEALCOATING COST TO INFRASTRUCTURE FUND101‐4229‐31‐0000 PW STREET CHEMICALS & SAND7,275 23,655 31,281 32,630 32,742 32,742 28,100 ‐14.18% 2021 ‐ 400 tons of salt, price per ton 13.1% less than 2020 101‐4230‐31‐0000 PW STORMWATER MAINTENANCE1,897 4,101 5,817 7,247 ‐ ‐ ‐ 0.00% Moved to Stormwater utility fund101‐4303‐31‐0000 PW CONTRACTED ENGINEER34,172 27,572 33,093 45,932 32,760 31,850 18,415 ‐43.79% SUBSTANTIAL PORTION MOVED TO INFRASTRUCTURE FUND101‐4309‐31‐0000 PW CONTRACTED IT & SFTW SUPPORT6,557 7,423 13,155 13,566 10,360 12,860 13,000 25.48% BASED ON CONTRACTED IT /SW SPREADSHEET101‐4310‐31‐0000 PW MISC. CONTRACTED SERVICES2,153 24,941 43,978 24,399 37,425 37,425 38,174 2.00% SALO PARK CAM AND VARIOUS ‐2021 RATES NOT CURRENTLY AVAILABLE 101‐4325‐31‐0000 PW COMMUNICATIONS 3,526 3,246 2,918 3,425 3,210 710 3,490 8.72% BASED ON COMMUNICATION SPREADSHEET101‐4339‐31‐0000 PW EQUIP REPAIRS & MAINTENANCE 12,639 14,786 6,452 8,701 14,500 10,750 14,790 2.00% 2021 PROJECTED RUN RATE101‐4340‐31‐0000 PW BLDG REPAIRS & MAINTENANCE‐ 348 380 2,882 3,000 ‐ 2,000 ‐33.33% 2021 PROJECTED RUN RATE101‐4341‐31‐0000PW TRAINING, CONF. & MTG.3,756 5,475 3,499 6,835 6,500 750 6,630 2.00% 2021 PROJECTED RUN RATE101‐4342‐31‐0000 PW MEMBERSHIPS & DUES689 1,197 1,143 1,428 1,248 1,248 1,273 2.00% 2021 PROJECTED RUN RATE101‐4344‐31‐0000 PW TRAINING CERT PROGRAMS300 935 46 123 950 950 969 2.00% 2021 PROJECTED RUN RATE101‐4345‐31‐0000PW GRANT REIMB EXPENDITURES12,023 540 14,338 2,832 21,938 ‐ 5,000 ‐77.21% grant exps for opportunity grants projected in revenue section 101‐4381‐31‐0000 PW STREETLIGHTS & SIGNALS70,049 65,478 65,516 61,512 67,548 63,950 67,148 ‐0.59% 2021 based on usage run rates and XCEL and Centerpoint rate increases101‐4435‐31‐0000 PW CLEAN‐UP DAY COSTS775 ‐ 500 ‐ ‐ ‐ ‐ 0.00%101‐4499‐31‐0000 PW MISCELLANEOUS50 990 ‐ 44 157 157 160 2.00%TOTAL 795,817$ 775,842$ 879,273$ 942,872$ 999,168$ 758,802$ 855,121$ ‐14.42%PARKS101‐4110‐51‐0000 PR REGULAR EMPLOYEE100,528$ 101,717$ 109,030$ 112,855$ 114,965$ 111,695$ 113,176$ ‐1.56% INCLUDES ESTIMATED 2020 WAGE ADJUSTMENTS 101‐4110‐51‐0100 TW REGULAR EMPLOYEE27,130 28,145 29,007 29,970 31,158 28,875 31,621 1.49% INCLUDES ESTIMATED 2020 WAGE ADJUSTMENTS 101‐4110‐51‐0200 PR COMMITTEE180 300 180 200 359 465 474 32.14% Parks commission est 3 opt‐in pay‐assume no change for 2020101‐4111‐51‐0000 PR OVERTIME EMPLOYEE2,229 1,944 1,827 2,216 3,307 1,590 2,500 ‐24.40% BASED ON EE MAPPING101‐4111‐51‐0100 TW OVERTIME EMPLOYEE369 305 1,048 1,176 867 600 1,000 15.34% BASED ON EE MAPPING29
|