Question: Please help with this question, I tried for hours and looked at a similar post, but I cannot figure it out. Thank you The Welsh

Please help with this question, I tried for hours and looked at a similar post, but I cannot figure it out. Thank you

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.70 300
WC008 $1.50 16,000
WC219 $0.60 10,200
WC397 $5.60 14,500
WC419 $1.10 5,000
WC654 $3.20 620
WC713 $7.65 1,400
WC887 $1.20 5,500
WC916 $3.60 700
WC971 $6.90 3,000
WC532 $2.30 5,200
WC413 $0.75 17,800
WC759 $7.65 400

Consider the ABC classification cutoffs provided in the table below.

ABC classification cutoffs
A 70%
B 90%
C 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.

$ $ % % -Select-ABCItem 54
-Select- $ $ % % -Select-ABCItem 60
-Select $ $ % % -Select-ABCItem 66
-Select- $ $ % % -Select-ABCItem 72
-Select- $ $

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!