Question: Please show me how to do this in excel. The Welsh Corporation uses 13 key components in one of its manufacturing plants. The data are


Please show me how to do this in excel.
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 300 WC007 WC008 $0.70 $1.50 WC219 WC397 16,000 10,200 14,500 5,000 620 WC419 $0.60 $5.60 $1.10 $3.20 $7.65 $ 1.20 $3.60 WC654 WC713 1,400 5,500 WC887 WC916 700 $6.90 3,000 WC971 WC532 WC413 WC759 $2.30 $0.75 $7.65 5,200 17,800 400 Consider the ABC classification cutoffs provided in the table below. ABC classification cutoffs A 70% 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 Dollar Usage Annual Cumulative Dollar Usage Cumulative Percent of Total Cumulative Percent ABC SKU of Items Classification -Select- $ $ % % -Select- -Select- $ $ % % -Select- -Select- $ $ % % -Select- 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 Dollar Usage Cumulative Percent of Total Percent of Items ABC Classification SKU -Select- $ $ % % -Select- -Select- $ $ % % -Select- -Select- $ $ % % -Select- -Select- v $ % % -Select- -Select- % % -Select- -Select- $ $ % % -Select- -Select- $ $ % % -Select- -Select- $ $ % % % -Select- -Select- $ $ % % -Select- -Select- v $ $ % % -Select- -Select- $ % % -Select- -Select- $ $ % % -Select- -Select- $ $ % % -SelectStep by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
