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
Get step-by-step solutions from verified subject matter experts
