Question: Spreadsheet The Welsh Corporation uses 13 key components in one of its manufacturing plants. The data are provided in the table below. SKU Item Cost

Spreadsheet The Welsh Corporation uses 13 key
Spreadsheet The Welsh Corporation uses 13 key
Spreadsheet The Welsh Corporation uses 13 key components in one of its manufacturing plants. The data are provided in the table below. SKU Item Cost Annual Demand WC007 $0.80 850 WC008 $1,40 16,500 WC219 $3.10 7,600 WC397 $4.60 5,200 WC419 $2.90 1,400 WC654 $5.55 850 WC713 $6.85 3,500 WC887 $0.95 6,700 WC916 $3.80 750 WC971 $4.95 2,700 WC532 $2.65 6,400 WC413 $6.30 10,200 WC759 $8.50 1,200 Consider the ABC classification cutoffs provided in the table below. ABC classification cutoffs 70% A B 90% 100% Use the ABC Excel template in MindTap to perform an ABC analysis. Do not round intermediate calculations. Round your answers to two decimal places Projected Cumulative Cumulative Cumulative Dollar Usage Dollar Percent Percent ARC SKU Annual Usage of Total of Items Classification WC413 $ 64250.00 20713.00 95.32 92.00 WC 23975.00 104013.00 47.71 96 544.00 9A 9 X S 3 3 3 x * * * WCY 23920,00 $ 71260.00 32.69 4 31.00 GA v we 23560,00 $ 47340.00 21.71 23.00 A 3 WOOD > 10.91 15.00 WC) 3 16960 $ 143553.00 65.35 $5,00 w 5 13365.00 126593.00 $ S 58.07 77.00 WE 5 10200.00 21801300 100.00 100.00 WO 5 6365.00 EX 83 * * 5 110378.00 50.63 62.00 WC 4717.50 S & S $ 80038 00 36.71 8 3 3 3 3 3 3 16.00 W410 5 4060,00 3 75320.00 14.55

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!