Fill in the missing formulas on the template. Note that the columns are in a different order than the template we used previously. Classify all the parts as either A, B, or C.

PART ANNUAL USAGE UNIT COST ANNUAL DOLLAR Percent of Total Dollars ABC Accumulati Accumulati ve ve Peroent Percentage Percentage of Usage of Total of Usage Dollars increasing) (increasing) A N. Accumulati Accumulati ve ve Percentage of Total Percentage of Usage Dollars (Decreasin Decreasin RC RC 2 10 18 36 9 4 5 6 7 8 $80 $288 $1,080 $11,070 $3,040 $2.430 $7.980 $1.960 $1,785 $9,450 19 10 11 12 56 105 27 19 12 7 10 13 14 15 6 18 8 16 30 1230 760 810 420 35 17 350 36 $115 $2,300 245 665 28 $23 $18 $610 $935 $270 1400 900 $67 $160 $45 $12 $16 42 705 $37 $26 16 17 18 19 20 21 22 23 24 25 26 27 Manually Adjust To Refect Current Problem % USAGE X DOLLAR A 0.00% 0.00% B 100.00% 100.00% C 0.00% 0.00% $1,380 $16,100 $2,450 $3.990 $504 $2.530 $1,332 $4.880 $9,350 $1,890 $7,000 $4,500 $3,082 $5,120 $4,545 $99 $854 $588 $6,345 $255 $41 TOTAL 100.00% 110 74 8 10 7 5 5 46 32 101 83 54 14 9 7 16 100.00 29 31 32 Total 940 $117.968 0% 0%