Question: Perform an ABC analysis for the data provided in in the table below. Item Annual Usage Unit Cost 1 3,200 $13.25 2 1,650 $43.10 3
Perform an ABC analysis for the data provided in in the table below.
| Item | Annual Usage | Unit Cost |
| 1 | 3,200 | $13.25 |
| 2 | 1,650 | $43.10 |
| 3 | 560 | $53.21 |
| 4 | 8,650 | $86.35 |
| 5 | 7,360 | $19.55 |
| 6 | 500 | $42.30 |
| 7 | 3,100 | $74.12 |
| 8 | 2,950 | $2.35 |
| 9 | 6,870 | $62.30 |
| 10 | 4,000 | $24.30 |
| 11 | 5,500 | $41.30 |
| 12 | 8,630 | $0.94 |
| 13 | 4,230 | $5.68 |
| 14 | 8,650 | $14.23 |
| 15 | 860 | $6.42 |
| 16 | 1,000 | $14.35 |
| 17 | 2,900 | $16.24 |
| 18 | 1,500 | $8.65 |
| 19 | 3,650 | $21.23 |
| 20 | 8,300 | $17.25 |
Consider the ABC classification cutoffs provided in the table below.
| ABC classification cutoffs | ||
| A | 75% | |
| B | 90% | |
| 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-1234567891011121314151617181920Item 1 | $ | $ | % | % | -Select-ABCItem 6 |
| -Select-1234567891011121314151617181920Item 7 | $ | $ | % | % | -Select-ABCItem 12 |
| -Select-1234567891011121314151617181920Item 13 | $ | $ | % | % | -Select-ABCItem 18 |
| -Select-1234567891011121314151617181920Item 19 | $ | $ | % | % | -Select-ABCItem 24 |
| -Select-1234567891011121314151617181920Item 25 | $ | $ | % | % | -Select-ABCItem 30 |
| -Select-1234567891011121314151617181920Item 31 | $ | $ | % | % | -Select-ABCItem 36 |
| -Select-1234567891011121314151617181920Item 37 | $ | $ | % | % | -Select-ABCItem 42 |
| -Select-1234567891011121314151617181920Item 43 | $ | $ | % | % | -Select-ABCItem 48 |
| -Select-1234567891011121314151617181920Item 49 | $ | $ | % | % | -Select-ABCItem 54 |
| -Select-1234567891011121314151617181920Item 55 | $ | $ | % | % | -Select-ABCItem 60 |
| -Select-1234567891011121314151617181920Item 61 | $ | $ | % | % | -Select-ABCItem 66 |
| -Select-1234567891011121314151617181920Item 67 | $ | $ | % | % | -Select-ABCItem 72 |
| -Select-1234567891011121314151617181920Item 73 | $ | $ | % | % | -Select-ABCItem 78 |
| -Select-1234567891011121314151617181920Item 79 | $ | $ | % | % | -Select-ABCItem 84 |
| -Select-1234567891011121314151617181920Item 85 | $ | $ | % | % | -Select-ABCItem 90 |
| -Select-1234567891011121314151617181920Item 91 | $ | $ | % | % | -Select-ABCItem 96 |
| -Select-1234567891011121314151617181920Item 97 | $ | $ | % | % | -Select-ABCItem 102 |
| -Select-1234567891011121314151617181920Item 103 | $ | $ | % | % | -Select-ABCItem 108 |
| -Select-1234567891011121314151617181920Item 109 | $ | $ | % | % | -Select-ABCItem 114 |
| -Select-1234567891011121314151617181920Item 115 | $ | $ | % | % | -Select-ABCItem 120 |
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
