Ch 11 5 Perform an ABC analysis for the data provided Clearly explain why you classified items as A, B, or C Use the 80 , 15 , 5 ABC schema to do this problem SKU Usage Cost 1 2400 $19 51 2 6200 $32 60 3 8500 $10 20 4 3200 $6 80 5 6000 $4 50 6 750 $55 70 7 8200 $3 60 8 9000 $44 90 9 5800 $35 62 10 820 $82 60 11 500 $40 50 12 2000 $15 40 13 2400 $14 60 14 6300 $35 80 15 4750 $17 30 16 2700 $51 75 17 1600 $42 90 18 1350 $25 30 19 5000 $67 00 20 1000 $125 00 Show calculations in excel please ) Thanks

The Answer is in the image, click to view ...

Question: ] Ch 11 #5 Perform an ABC analysis for the data provided. Clearly explain why you classified items as A, B, or C. Use the

] Ch 11 #5 Perform an ABC analysis for the data provided. Clearly explain why you classified items as A, B, or C. Use the 80%, 15%, 5% ABC schema to do this problem.

SKU	Usage	Cost
1	2400	$19.51
2	6200	$32.60
3	8500	$10.20
4	3200	$6.80
5	6000	$4.50
6	750	$55.70
7	8200	$3.60
8	9000	$44.90
9	5800	$35.62
10	820	$82.60
11	500	$40.50
12	2000	$15.40
13	2400	$14.60
14	6300	$35.80
15	4750	$17.30
16	2700	$51.75
17	1600	$42.90
18	1350	$25.30
19	5000	$67.00
20	1000	$125.00

Show calculations in excel please! :) Thanks

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!

Ch 1 1 # 5 Perform an ABC analysis for the data provided. Clearly explain why you classified items as A , B , or C . Use the 8 0 % , 1 5 % , 5 % ABC schema to do this problem.

[l] Prob #10 Ch7. An express checkout line at a grocery store takes an average of 4 minutes to ring-up a customer's order. On average 5 customers are in the checkout line. What is the average number...

Prob #10 Ch7. An express checkout line at a grocery store takes an average of 4 minutes to ring-up a customer's order. On average 5 customers are in the checkout line. What is the average number of...

[2] Prob #11 Ch 7. An accounts receivable manager processes 200 checks per day with an average processing time of 15 working days. What is the average number of accounts receivable checks being...

AutoSave C 90 Little's Law and Inventory Model Problems 11-1-20 - Word Scarch File Home Insert Design Layout References Mailings Review View Help Table Design Layout Restore Move Size - Minimize...

[4] Ch 11 #5 Perform an ABC analysis for the data provided. Clearly explain why you classified items as A, B, or C. Use the 80%, 15%, 5% ABC schema to do this problem. SKU Usage Cost 1 2400 $19.51 2...

Perform an ABC analysis for the data provided. Clearly explain why you classified items as A, B, or C. Annual Unit Item Usage Cost 1 2400 $19.51 2 6200 $32.60 3 8500 $10.20 3200 $6.80 4 5 5 6000...

Perform an ABC analysis for the data provided. Clearly explain why you classified items as A, B, or C. Annual Unit Item Usage Cost 1 2400 $19.51 2 6200 $32.60 3 8500 $10.20 4 3200 $6.80 5 6000 $4.50...

2. Perform an ABC analysis for the data provided. Clearly explain why you classified items as A, B, or C. AN Item 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 I Annual Usage 2400 6200 8500 3200...

Now that GlaxoSmithKline has decided not to pay its salespeople based on number of prescriptions written, how do you propose they motivate their salespeople? What motivational approaches do you...

Consider the following four-switch circuit: If all switches operate independently and P(Switch closes)= p, what is the probability the circuit is completed? A1 In Out

Brittary is asked to extend trade credit to a restaurant she hasn't serviced before. She asks to see its balance sheet to determine if it could pay its bills. She divides its current assets by...

atch the compensation objectives with their meanings. Efficiency Efficiency drop zone empty. Fairness Fairness drop zone empty. Compliance Compliance drop zone empty. Improving performance and...