Question: Perform an ABC analysis for the data provided in the table below. Item Annual Usage Unit value 1 1 $86.45 $57.40 2 3 4 $2.35



Perform an ABC analysis for the data provided in the table below. Item Annual Usage Unit value 1 1 $86.45 $57.40 2 3 4 $2.35 $13.56 $58.45 5 6 3,250 18,540 55,000 69,000 48,500 154,000 29,000 456,000 75,650 20,000 11,000 13,000 7 $8.50 $56.45 $2.65 000 10 $0.35 $10.35 $65.10 $14.05 11 12 Consider the ABC classification cutoffs provided in the table below. Consider the ABC classification cutoffs provided in the table below. ABC classification cutoffs A 70% B 87% 100% of Items Complete the table below. Do not round intermediate calculations. Round your answers to two decimal places. Projected Cumulative Cumulative Cumulative Dollar Usage Dollar Percent Percent ABC Item Annual Usage of Total Classification -Select- $ $ % % -Select- -Select- $ $ % % -Select- -Select- $ % % -Select- -Select- $ % -Select- -Select- $ $ % % -Select- -Select- $ $ % % -Select- -Select- $ $ % % -Select- Type here to search $ $ 96 O Complete the table below. Do not round intermediate calculations. Round your answers to two decimal places. Projected Cumulative Cumulative Cumulative Dollar Usage Dollar Percent Percent ABC Item Annual Usage of Total of Items Classification -Select- $ $ % % -Select- Select- $ $ 9 9% -Select- -Select- 5 $ % 9 Select- -Select $ $ % % Select Select $ $ % 96 Select -Select 5 $ % % Select- Select v $ $ % % Select Select $ $ % % Select Select $ $ % 96 Select 7 -Select- $ $ % % -Select- Select $ $ % 96 Select Select- $ $ % 96 Select
Step 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
