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 components in one of its manufacturing plants. The data are provided in the table below. SKU Item Cost Annual Demand WC007 $1.25 650 WC008 $0.45 WC219 $4.05 $0.15 WC397 WC419 WC654 $7.10 $5.45 $1.30 WC713 10,200 4,600 3,200 650 1,500 1,450 5,600 350 1,850 3,600 250 WC887 $0.85 WC916 $1.60 WC971 WC532 $0.25 $8.65 $2.20 $3.20 WC413 WC759 680 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. Cumulative Cumulative Projected Dollar Usage Annual Cumulative Percent Dollar Percent of Total ABC Classification SKU Usage of Items -Select- $ $ % % -Select- -Select- $ $ % % -Select- -Select- $ $ % % -Select- -Select- $ $ % % -Select- -Select- $ $ % % -Select- -Select- $ $ % % -Select- -Select- $ $ % % -Select- -Select- $ $ % % -Select- -Select- $ $ % % -Select- -Select- $ $ % % -Select- OU -Select- $ $ % % -Select- -Select- $ $ % % -Select- -Select- $ $ % % -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!