Question: Question 3: PART NUMBER ANNUAL UNIT USAGE UNIT COST $ 1 200 10 2 15,000 4 3 60,000 6 4 15,000 15 5 1,400 10
Question 3:
| PART NUMBER | ANNUAL UNIT USAGE | UNIT COST $ |
| 1 | 200 | 10 |
| 2 | 15,000 | 4 |
| 3 | 60,000 | 6 |
| 4 | 15,000 | 15 |
| 5 | 1,400 | 10 |
| 6 | 100 | 50 |
| 7 | 25,000 | 2 |
| 8 | 700 | 3 |
| 9 | 25,000 | 1 |
| 10 | 7,500 | 1 |
Analyze the above dataset to produce an ABC classification following these steps:
- Calculate the annual dollar usage for each item.
- List the items according to their annual dollar usage
- Calculate the cumulative annual dollar usage and the cumulative percentage of items.
- Group items into an A, B, C classification.
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
