|
Fiscal Year 2020 12/31/2015
<br />ACTUAL
<br />2015
<br />ACTUAL
<br />2016
<br />ACTUAL
<br />2017
<br />ACTUAL
<br />2018
<br />BUDGET
<br />2019
<br />EST. ACTUAL
<br />2019
<br />BUDGET
<br />2020
<br />GENERAL FUND EXPENDITURES DETAIL
<br />101-4131-31-0000 PW INSURANCE HEALTH 55,860 59,897 57,127 60,325 62,610 62,610 63,874 2.02% SPLIT 8.3% PREMUIM INCREASE IN 2020
<br />101-4131-31-0100 PW MECHANIC ALLOC- HI 6,170 2,480 1,310 1,680 1,915 1,915 2,016 5.27% 56% Qtucker
<br />101-4135-31-0000 PW INSURANCE WC 12,484 13,525 14,096 13,436 14,046 13,157 13,412 -4.51% BASED ON 2019/2020 RENEWAL
<br />101-4140-31-0000 PW UNIFORM EXPENSES 6,377 8,567 9,650 9,137 5,250 9,360 9,547 81.85% Inflate 2019 RUNRATE BY 2%
<br />101-4140-31-0100 PW UNIFORM EXPENSES - MECH 63 704 1,103 727 271 801 817 201.92% Inflate 2019 RUNRATE BY 2%
<br />101-4212-31-0100 PW MOTOR FUELS MISC 227 1,304 976 1,080 1,313 1,125 1,406 7.14% Other non-contracted fuel / oil
<br />101-4212-31-0200 PW MOTOR FUELS NB 100,434 70,612 75,716 88,671 104,435 67,532 84,537 -19.05% 2019 contracted cost per gallon $2.10 / 2020 projection $2.88 / 3yr avg usage +1%
<br />101-4212-31-0300 PW FUEL - MWMO 1,888 1,124 1,462 1,488 1,935 1,132 1,775 -8.27% 2019 contracted cost per gallon $2.10 / 2020 projection $2.88 / 3yr avg usage +1%
<br />101-4212-31-0400 PW FUEL - SANB #282 4,866 3,495 3,209 8,710 5,260 9,336 11,936 126.92% Increased gasoline usage as added School vans 2018/2019
<br />101-4212-31-0600 PW FUEL - STREET/PARKS 15,277 10,356 11,362 14,846 27,160 20,666 22,203 -18.25% 2019 contracted cost per gallon $2.10 / 2020 projection $2.88 / 3yr avg usage +1%
<br />101-4221-31-0100 PW VEHICLE REPAIRS/PARTS 5,850 6,618 8,816 16,540 14,000 12,500 14,280 2.00% 2020 PROJECTED RUN RATE
<br />101-4223-31-0000 PW SMALL TOOLS MECHANIC 3,973 22 1,720 750 572 572 584 2.00% 2020 PROJECTED RUN RATE
<br />101-4223-31-0100 PW SMALL TOOLS 124 1,314 473 583 1,000 850 1,020 2.00% 2020 PROJECTED RUN RATE
<br />101-4224-31-0000 PW STREET SIGNS 444 1,522 563 464 2,341 2,341 2,388 2.00% past years puchases low, needs filled in 2019/20
<br />101-4226-31-0000 PW GENERAL SUPPLIES 7,906 6,417 7,485 10,838 11,445 11,445 11,674 2.00% 2020 PROJECTED RUN RATE
<br />101-4226-31-0100 PW SHOP SUPPLIES 1,529 1,678 1,958 1,499 2,165 2,165 2,208 2.00% 2020 PROJECTED RUN RATE
<br />101-4228-31-0000 PW STREET REPAIR & MAINTENANCE 70,074 61,727 15,571 16,621 72,500 73,500 73,950 2.00% For street repairs/striping/crack filling
<br />101-4229-31-0000 PW STREET CHEMICALS & SAND 34,029 7,275 23,655 31,281 35,090 25,617 31,730 -9.58% 2020 assumed 390 tons of salt and price per ton 3% greater than 2019
<br />101-4230-31-0000 PW STORMWATER MAINTENANCE 1,852 1,897 4,101 5,817 - - - 0.00% Moved to Stormwater utility fund
<br />101-4303-31-0000 PW CONTRACTED ENGINEER 26,802 34,172 27,572 33,093 30,000 31,500 32,000 6.67% 2020 PROJECTED RUN RATE
<br />101-4309-31-0000 PW CONTRACTED IT & SFTW SUPPORT 5,091 6,557 7,423 13,155 9,459 9,459 10,360 9.53% BASED ON CONTRACTED IT /SW SPREADSHEET
<br />101-4310-31-0000 PW MISC. CONTRACTED SERVICES 5,745 2,153 24,941 43,978 36,200 36,200 37,425 3.38% SALO PARK CAM AND VARIOUS
<br />101-4325-31-0000 PW COMMUNICATIONS 3,878 3,526 3,246 2,918 3,350 3,250 3,210 -4.18% BASED ON COMMUNICATION SPREADSHEET
<br />101-4339-31-0000 PW EQUIP REPAIRS & MAINTENANCE 18,809 12,639 14,786 6,452 22,013 18,711 22,453 2.00% 2020 PROJECTED RUN RATE
<br />101-4340-31-0000 PW BLDG REPAIRS & MAINTENANCE 120 - 348 380 1,623 1,450 1,655 2.00% 2020 PROJECTED RUN RATE
<br />101-4341-31-0000 PW TRAINING, CONF. & MTG.2,931 3,756 5,475 3,499 6,018 7,300 6,500 8.01% national conference in 2019
<br />101-4342-31-0000 PW MEMBERSHIPS & DUES 849 689 1,197 1,143 1,224 1,224 1,248 2.00% 2020 PROJECTED RUN RATE
<br />101-4344-31-0000 PW TRAINING CERT PROGRAMS 3,009 300 935 46 1,900 1,900 950 -50.00% 2yr licenses paid in 2019
<br />101-4345-31-0000 PW GRANT REIMB EXPENDITURES 14,714 12,023 540 14,338 - 2,832 21,938 0.00% grant exps for opportunity grants projected in revenue section
<br />101-4381-31-0000 PW STREETLIGHTS & SIGNALS 60,447 70,049 65,478 65,516 66,920 64,950 66,249 -1.00% 2020 budget based on usage run rates and XCEL and Centerpoint rate increases
<br />101-4435-31-0000 PW CLEAN-UP DAY COSTS 9 775 - 500 - - - 0.00%
<br />101-4499-31-0000 PW MISCELLANEOUS - 50 990 - 154 154 157 2.00%
<br />TOTAL 859,315$ 795,817$ 775,842$ 879,273$ 967,277$ 922,575$ 1,002,705$ 3.66%
<br />PARKS
<br />101-4110-51-0000 PR REGULAR EMPLOYEE 111,130$ 100,528$ 101,717$ 109,030$ 110,962$ 112,500$ 114,965$ 3.61% CURRENT PR ALLOCATION
<br />101-4110-51-0100 TW REGULAR EMPLOYEE 26,678 27,130 28,145 29,007 30,073 30,073 31,158 3.61% CURRENT TW ALLOCATION
<br />101-4110-51-0200 PR COMMITTEE 240 180 300 180 352 186 359 2.00% Parks commission est 3 opt-in pay-assume no change for 2020
<br />101-4111-51-0000 PR OVERTIME EMPLOYEE 1,790 2,229 1,944 1,827 3,500 2,650 3,307 -5.51%
<br />101-4111-51-0100 TW OVERTIME EMPLOYEE 454 369 305 1,048 850 852 867 2.00%
<br />101-4121-51-0000 PR PERA 8,032 7,921 7,994 8,606 8,585 8,636 8,870 3.33% PERA FUNDING RATE 7.5% no change 2019
<br />101-4121-51-0100 TW PERA 1,877 2,132 2,189 2,343 2,319 2,319 2,402 3.56% PERA FUNDING RATE 7.5% no change 2019
<br />101-4122-51-0000 PR FICA/MEDICARE 8,470 7,791 8,115 8,767 8,756 8,809 9,075 3.64% 7.65%
<br />101-4122-51-0100 TW FICA/MEDICARE 2,132 2,186 2,258 2,357 2,366 2,366 2,450 3.56% 7.65%
<br />101-4131-51-0000 PR INSURANCE HEALTH 27,720 24,223 20,085 21,306 21,955 21,955 23,223 5.78% SPLIT 8.3% PREMUIM INCREASE IN 2020
<br />101-4131-51-0100 TW INSURANCE HEALTH 4,399 4,767 5,169 5,004 5,277 5,277 5,614 6.39% SPLIT 8.3% PREMUIM INCREASE IN 2020
<br />101-4135-51-0000 PR INSURANCE WC 2,933 3,258 3,520 3,286 3,474 3,629 3,976 14.45% SPLIT 8.3% PREMUIM INCREASE IN 2020
<br />101-4135-51-0100 TW INSURANCE WC 2,390 2,116 2,339 2,191 2,316 2,440 2,651 14.46% BASED ON 2019/2020 RENEWAL
<br />101-4212-51-0000 PW FUEL - STREET/PARKS - - - - - - - 0.00% PW FUELS USE CONSOLIDATED UNDER STREETS DEPT
<br />101-4226-51-0000 PR GENERAL SUPPLIES 16,188 11,193 19,832 14,357 13,750 13,750 14,025 2.00% inflate 2%
<br />101-4310-51-0100 TW MISC. CONTRACTED SERVICES - 1,060 - - - - - 0.00% coded to 4338
<br />101-4325-51-0000 PR COMMUNICATIONS 1,369 1,285 1,370 1,622 1,484 1,484 1,760 18.60% BASED ON COMMUNICATION SPREADSHEET
<br />101-4325-51-0100 TW COMMUNICATIONS 155 155 171 197 198 198 220 11.11% BASED ON COMMUNICATION SPREADSHEET
<br />101-4337-51-0000 PR STRUCTURES REPAIRS & MAINT.8,336 6,687 8,108 12,365 7,500 10,250 10,500 40.00% Adjust run rate to maintain service level
<br />101-4338-51-0100 TW TREE REPLACEMENT 3,439 4,561 3,542 583 3,750 3,750 3,825 2.00% Adjust run rate to maintain # of trees replaced
<br />101-4339-51-0000 PR EQUIP REPAIRS & MAINTENANCE 2,343 8,554 8,327 7,857 8,930 9,400 9,588 7.37% Adjust run rate to maintain service level
<br />101-4339-51-0100 TW EQUIP REPAIRS & MAINTENANCE - - 52 - 271 271 276 2.00%
<br />9
|