Question: Please answer only the wrong part The Welsh Corporation uses 13 key components in one of its manufacturing plants. The data are provided in the

Please answer only the wrong part The WelshPlease answer only the wrong part The Welsh

Please answer only the wrong part

The Welsh Corporation uses 13 key components in one of its manufacturing plants. The data are provided in the table below. SKU WC007 WC008 WC219 WC397 WC419 WC654 Item Cost Annual Demand $1.30 600 $0.50 10,500 $1.40 13,000 $4.60 9,500 $2.50 3,700 $3.80 650 $6.90 3,800 $0.90 6,800 $1.70 540 $5.60 3,700 $2.60 6,300 $4.20 12,500 $7.20 850 WC713 WC887 WC916 WC971 WC532 WC413 WC759 Consider the ABC classification cutoffs provided in the table below. ABC classification cutoffs 75% 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. Use the ABC Excel template in MindTap to perform an ABC analysis. Do not round intermediate calculations. Round your answers to two decimal places. Cumulative Cumulative Projected Dollar Usage Annual Cumulative Percent Dollar Usage Percent of Total SKU ABC Classification of Items WC413 $ 52500 $ 52500 25.16 % 0.83 X % A WC397 v 43700 $ $ 96200 46.11 % 14.49 X % A WC713 v $ 26220 $ 122420 58.68 9% 12.57 % A WC971 $ 20720 $ 143140 68.61 % % A WC219 $ 18200 S $ 161340 77.33 % * %B WC532 $ 16380 $ 177720 85.19 % % %B WC419 $ oooooooooo 9250 $ 186970 89.62 % %B G WC887 $ 6120 $ 193090 92.55 % %c WC759 $ 6120 199210 95.49 % %c WCOo8 v $ 5250 $ 204460 98.00 % %c >> WC654 v $ 2470 $ 206930 9 5 5 5 5 99.19 % %c WC916 $ 918 207848 99.63 % % C WC007 $ 780 $ 208628 100.00 % 3.7 %c

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!