Question: Perform an ABC analysis for the data provided in in the table below. Item Unit Cost 1 Annual Usage 1,250 3,120 $26.32 2 $46.20 $34.20

Perform an ABC analysis for the data provided inPerform an ABC analysis for the data provided in

Perform an ABC analysis for the data provided in in the table below. Item Unit Cost 1 Annual Usage 1,250 3,120 $26.32 2 $46.20 $34.20 3 940 4 $95.30 $10.36 5 6 $6.52 7 2,350 3,500 1,000 2,600 1,350 5,420 3,650 2,860 8 $76.25 $1.32 $23.12 9 10 $32.11 11 $43.20 12 $0.98 13 4,630 2,000 3,950 $5.50 14 $13.20 15 680 $6.40 16 $10.65 17 $24.30 18 2,580 3,900 4,500 3,650 2,400 $7.95 19 $19.65 20 $29.20 Consider the ABC classification cutoffs provided in the table below. ABC classification cutoffs 75% B 95% 100% Cumulative Cumulative Projected Dollar Usage Annual Cumulative Percent Dollar ABC Percent of Total Item Usage of Items Classification 1 32,900.00 $ X $ 32900 8 2 % 5 % A 2 $ 3120 $ 177044 13 % 10 % A 3 940 X $ 209192 15 % 15 % A A to X 4 $ 223955 $ 433147 31 % 20 % A 5 $ 36260 $ 469407 33 % 25 % A 6 $ 6520 $ 475927 34 % 30 % A $ 7 198250 $ X 674177 48 % 35 % A 8 $ 1782 $ 675959 48 % 40 % A B 9 $ 125310.40 $ 801269.40 57 % 45 % A 10 $ 117201.50 $ 918470.90 65 % 50 % A 11 $ 123552 $ 1042022.90 74 % 55 % A $ 12 4537.40 X $ 1046560.30 74 % 60 % B X $ 13 11000 X 1057560.30 $ 75 % 65 %B 14 $ 52140 $ 1109700.30 78 % 70 % B $ 15 X 4352 $ 1114052.30 79 % 75 % B 16 X $ 27477 X $ 1141529.30 81 % 80 %B 17 $ 94770 $ 1236299.30 87 % 85 % B 18 $ 35775 $ 1272074.30 90 % 90 % c X 19 $ 71722.50 $ 1343796.80 95 % % 95 % c 8 20 $ 70080 $ 1413876.80 100 % 100 % c

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!