Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

8. 10. 11. B Spreadsheet The Welsh Corporation uses 13 key components in one of its manufacturing plants. The data are provided in the table

8. 10. 11. B 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.20 620 WC008 $2.10 12,300 WC219 $4.60 5,400 WC397 $2.30 4,300 WC419 $1.85 900 WC654 $3.25 650 WC713 $7.35 3,850 WC887 $1.55 6,400 WC916 $2.65 350 WC971 $5.35 5,200 WC532 $0.85 7,800 WC413 $1.10 9,000 WC759 $5.20 850 Consider the ABC classification cutoffs provided in the table below. ABC classification cutoffs A B C 80% 95% 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 Cumulatore Projected Dollar Usage Cumulative Cumulative Dollar Percent SKU Annual Usage of Total % WC713 v % Cumulative Percent of Items % A % A ABC Classification WC219 v WC008 WC219 WC219 % %A % % A % % A % % B WC219 WC219 WC219 WC219 WC654 % % B % % B % % C % % C % % C WC419 v x % % C WC916 v % % C WC007

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Introduction To Financial Reporting With Powerpivot

Authors: Florent Cailly, Thomas Brajcich

1st Edition

1517437563, 978-1517437565

More Books

Students also viewed these Accounting questions

Question

8. Satyam Computer Services Limited

Answered: 1 week ago

Question

2. Explain how the role of training is changing.

Answered: 1 week ago

Question

7. General Mills

Answered: 1 week ago