Answered step by step
Verified Expert Solution
Question
1 Approved Answer
9.18. Analyze the following data to produce an ABC classification based on annual dollar usage. Part Number Annual Unit Usage Unit Cost $ Annual $
9.18. Analyze the following data to produce an ABC classification based on annual dollar usage. | ||||||||||||
Part Number | Annual Unit Usage | Unit Cost $ | Annual $ Usage | Part Number | Annual $ Usage | Cumulative $ Usage | Cumulative % $ Usage | Cumulative # of Items | Cumulative % of Items | Class | ||
1 | 200 | 10 | $60,000.00 | 3 | $6,000.00 | |||||||
2 | 17,000 | 4 | $15,000.00 | 4 | $15,000.00 | |||||||
3 | 60,000 | 6 | $17,000.00 | 2 | $17,000.00 | |||||||
4 | 15,000 | 15 | $25,000.00 | 7 | $25,000.00 | |||||||
5 | 1,500 | 10 | $25,000.00 | 9 | $25,000.00 | |||||||
6 | 120 | 50 | $1,500.00 | 5 | $1,500.00 | |||||||
7 | 25,000 | 2 | $7,500.00 | 10 | $7,500.00 | |||||||
8 | 700 | 3 | $120.00 | 6 | $120.00 | |||||||
9 | 25,000 | 1 | $700.00 | 8 | $700.00 | |||||||
10 | 7,500 | 1 | $200.00 | 1 | $200.00 | |||||||
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started