Fiscal Year 2021
<br />ACTUAL
<br />2016
<br />ACTUAL
<br />2017
<br />ACTUAL
<br />2018
<br />ACTUAL
<br />2019
<br />BUDGET
<br />2020
<br />BUDGET
<br />2021
<br />GENERAL FUND EXPENDITURES DETAIL
<br />101-4135-25-0000 EMS INSURANCE WC 2,894 2,948 3,741 4,123 3,770 4,441 17.80%BASED ON 2020/2021 RENEWAL
<br />101-4221-25-0000 EMS SUPPLIES- EQUIPMENT - 239 301 - 510 520 2.00%
<br />101-4227-25-0000 EMS MEDICAL SUPPLIES 150 - 48 - 49 50 2.00% Haz Mat medical supplies
<br />101-4323-25-0000 EMS PAGERS, SIREN 1,251 1,237 1,289 1,233 1,500 1,530 2.00%2021 PROJECTED RUN RATE
<br />101-4339-25-0000 EMS REPAIRS AND MAINTENANCE 221 - - 287 100 102 2.00%2021 PROJECTED RUN RATE
<br />101-4341-25-0000 EMS TRAINING, CONF. & MTG.193 288 970 615 975 995 2.00%2021 PROJECTED RUN RATE
<br />101-4350-25-0000 EMS PRINTED FORMS & ENVELOPES - - - - 150 153 2.00%2021 PROJECTED RUN RATE
<br />TOTAL 67,806$ 71,895$ 76,393$ 79,515$ 83,937$ 86,198$ 2.69%
<br />PUBLIC WORKS
<br />101-4110-31-0000 PW REGULAR EMPLOYEE 273,345$ 269,329$ 278,917$ 286,839$ 299,039$ 303,715$ 1.56%See dept summaries-PR excludes other pay codes
<br />101-4110-31-0100 PW MECHANIC 33,149 35,525 36,837 37,966 39,423 40,042 1.57%See dept summaries-PR excludes other pay codes
<br />101-4111-31-0000 PW OVERTIME EMPLOYEE 6,005 2,897 13,518 12,285 17,690 17,900 1.19%See dept summaries-PR OT mapping to dept 31
<br />101-4111-31-0100 PW OVERTIME MECHANIC 327 300 141 318 471 350 -25.69%Based on last three years
<br />101-4112-31-0000 PW PART-TIME EMPLOYEE 27,407 26,592 30,018 30,300 35,812 36,886 3.00%Inflate 3% / assume extended winter conditions
<br />101-4121-31-0000 PW PERA 21,168 20,741 21,775 22,611 23,755 24,121 1.54%BASED ON CURRENT PERA FUNDING RATE
<br />101-4121-31-0100 PW MECHANIC ALLOC- PERA 2,594 2,742 2,845 2,948 2,992 3,029 1.25%BASED ON CURRENT PERA FUNDING RATE
<br />101-4122-31-0000 PW FICA 21,821 21,531 22,682 23,654 26,969 27,425 1.69%BASED ON ER .0765 OF GROSS
<br />101-4122-31-0100 PW MECHANIC ALLOC- FICA 2,778 2,899 3,028 3,157 3,052 3,090 1.25%BASED ON ER .0765 OF GROSS
<br />101-4131-31-0000 PW INSURANCE HEALTH 59,897 57,127 60,325 60,641 63,874 71,473 11.90%SPLIT 9.4% PREMUIM INCREASE IN 2021
<br />101-4131-31-0100 PW MECHANIC ALLOC- HI 2,480 1,310 1,680 1,915 2,016 2,117 5.01%56% Tucker
<br />101-4135-31-0000 PW INSURANCE WC 13,525 14,096 13,436 13,198 13,412 19,285 43.79%BASED ON 2020/2021 RENEWAL
<br />101-4140-31-0000 PW UNIFORM EXPENSES 8,567 9,650 9,137 12,504 9,547 9,738 2.00%2021 PROJECTED RUN RATE
<br />101-4140-31-0100 PW UNIFORM EXPENSES - MECH 704 1,103 727 1,172 817 833 2.00%2021 PROJECTED RUN RATE
<br />101-4212-31-0100 PW MOTOR FUELS MISC 1,304 976 1,080 3,460 1,406 1,434 2.00%Other non-contracted fuel / oil
<br />101-4212-31-0200 PW MOTOR FUELS NB 70,612 75,716 88,671 77,009 84,537 7,059 -91.65%NEW BRIGHTON PW ADDED ON SITE RE-FUELING FEB 2021
<br />101-4212-31-0300 PW FUEL - MWMO 1,124 1,462 1,488 1,164 1,775 1,405 -20.86%2020 contracted cost per gal $2.13 / 2021 projection $2.23 / 3yr avg usage
<br />101-4212-31-0400 PW FUEL - SANB #282 3,495 3,209 8,710 10,480 11,936 10,654 -10.74%2020 contracted cost per gal $2.13 / 2021 projection $2.23 / 3yr avg usage
<br />101-4212-31-0600 PW FUEL - STREET/PARKS 10,356 11,362 14,846 14,229 22,203 25,304 13.97%2020 contracted cost per gal $2.13 / 2021 projection $2.23 / 3yr avg usage
<br />101-4221-31-0100 PW VEHICLE REPAIRS/PARTS 6,618 8,816 16,540 13,556 14,280 14,566 2.00%2021 PROJECTED RUN RATE
<br />101-4223-31-0000 PW SMALL TOOLS MECHANIC 22 1,720 750 70 584 595 2.00%2021 PROJECTED RUN RATE
<br />101-4223-31-0100 PW SMALL TOOLS 1,314 473 583 447 1,020 1,040 2.00%2021 PROJECTED RUN RATE
<br />101-4224-31-0000 PW STREET SIGNS 1,522 563 464 2,763 2,388 2,435 2.00%2021 PROJECTED RUN RATE
<br />101-4226-31-0000 PW GENERAL SUPPLIES 6,417 7,485 10,838 6,879 11,674 8,500 -27.19%2021 PROJECTED RUN RATE
<br />101-4226-31-0100 PW SHOP SUPPLIES 1,678 1,958 1,499 562 2,208 3,500 58.50%2021 PROJECTED RUN RATE More general supplies being recognized as shop supplies
<br />101-4228-31-0000 PW STREET REPAIR & MAINTENANCE 61,727 15,571 16,621 91,192 73,950 40,429 -45.33%MOVED SEALCOATING COST TO INFRASTRUCTURE FUND
<br />101-4229-31-0000 PW STREET CHEMICALS & SAND 7,275 23,655 31,281 32,630 32,742 28,100 -14.18%2021 - 400 tons of salt, price per ton 13.1% less than 2020
<br />101-4230-31-0000 PW STORMWATER MAINTENANCE 1,897 4,101 5,817 7,247 - - 0.00%Moved to Stormwater utility fund
<br />101-4303-31-0000 PW CONTRACTED ENGINEER 34,172 27,572 33,093 45,932 32,760 8,415 -74.31%SUBSTANTIAL PORTION MOVED TO INFRASTRUCTURE FUND
<br />101-4309-31-0000 PW CONTRACTED IT & SFTW SUPPORT 6,557 7,423 13,155 13,566 10,360 13,000 25.48%BASED ON CONTRACTED IT /SW SPREADSHEET
<br />101-4310-31-0000 PW MISC. CONTRACTED SERVICES 2,153 24,941 43,978 24,399 37,425 38,174 2.00%SALO PARK CAM AND VARIOUS -2021 RATES NOT CURRENTLY AVAILABLE
<br />101-4325-31-0000 PW COMMUNICATIONS 3,526 3,246 2,918 3,425 3,210 3,490 8.72%BASED ON COMMUNICATION SPREADSHEET
<br />101-4339-31-0000 PW EQUIP REPAIRS & MAINTENANCE 12,639 14,786 6,452 8,701 14,500 14,790 2.00%2021 PROJECTED RUN RATE
<br />101-4340-31-0000 PW BLDG REPAIRS & MAINTENANCE - 348 380 2,882 3,000 3,060 2.00%2021 PROJECTED RUN RATE
<br />101-4341-31-0000 PW TRAINING, CONF. & MTG.3,756 5,475 3,499 6,835 6,500 6,630 2.00%2021 PROJECTED RUN RATE
<br />101-4342-31-0000 PW MEMBERSHIPS & DUES 689 1,197 1,143 1,428 1,248 1,273 2.00%2021 PROJECTED RUN RATE
<br />101-4344-31-0000 PW TRAINING CERT PROGRAMS 300 935 46 123 950 969 2.00%2021 PROJECTED RUN RATE
<br />101-4345-31-0000 PW GRANT REIMB EXPENDITURES 12,023 540 14,338 2,832 21,938 10,969 -50.00%grant exps for opportunity grants projected in revenue section
<br />101-4381-31-0000 PW STREETLIGHTS & SIGNALS 70,049 65,478 65,516 61,512 67,548 67,817 0.40%2021 based on usage run rates and XCEL and Centerpoint rate increases
<br />101-4435-31-0000 PW CLEAN-UP DAY COSTS 775 - 500 - - - 0.00%
<br />101-4499-31-0000 PW MISCELLANEOUS 50 990 - 44 157 160 2.00%
<br />TOTAL 795,817$ 775,842$ 879,273$ 942,872$ 999,168$ 873,774$ -12.55%
<br />10
|