Question: Perform an ABC analysis for the data provided in the table below. Item Annual Usage Unit value 1 35,000 $35.35 2 13,260 $5.45 3 25,000
Perform an ABC analysis for the data provided in the table below.
| Item | Annual Usage | Unit value |
| 1 | 35,000 | $35.35 |
| 2 | 13,260 | $5.45 |
| 3 | 25,000 | $56.45 |
| 4 | 4,500 | $71.58 |
| 5 | 35,000 | $15.75 |
| 6 | 76,000 | $5.16 |
| 7 | 65,450 | $75.69 |
| 8 | 136,200 | $31.40 |
| 9 | 52,000 | $2.36 |
| 10 | 21,300 | $8.65 |
| 11 | 5,600 | $75.30 |
| 12 | 7,500 | $45.20 |
Consider the ABC classification cutoffs provided in the table below.
| ABC classification cutoffs | ||
| A | 65% | |
| B | 95% | |
| C | 100% | |
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-123456789101112Item 1 | $ | $ | % | % | -Select-ABCItem 6 |
| -Select-123456789101112Item 7 | $ | $ | % | % | -Select-ABCItem 12 |
| -Select-123456789101112Item 13 | $ | $ | % | % | -Select-ABCItem 18 |
| -Select-123456789101112Item 19 | $ | $ | % | % | -Select-ABCItem 24 |
| -Select-123456789101112Item 25 | $ | $ | % | % | -Select-ABCItem 30 |
| -Select-123456789101112Item 31 | $ | $ | % | % | -Select-ABCItem 36 |
| -Select-123456789101112Item 37 | $ | $ | % | % | -Select-ABCItem 42 |
| -Select-123456789101112Item 43 | $ | $ | % | % | -Select-ABCItem 48 |
| -Select-123456789101112Item 49 | $ | $ | % | % | -Select-ABCItem 54 |
| -Select-123456789101112Item 55 | $ | $ | % | % | -Select-ABCItem 60 |
| -Select-123456789101112Item 61 | $ | $ | % | % | -Select-ABCItem 66 |
| -Select-123456789101112Item 67 | $ | $ | % | % | -Select-ABCItem 72 |
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
