Question
Given the following list of items, Item Annual Demand Ordering Cost ($) Holding Cost (%) Unit Price ($) 101 700 10 20 0.50 102 1,810
Given the following list of items,
Item | Annual Demand | Ordering Cost ($) | Holding Cost (%) | Unit Price ($) | ||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|
101 | 700 | 10 | 20 | 0.50 | ||||||||
102 | 1,810 | 10 | 30 | 0.20 | ||||||||
103 | 5,210 | 25 | 30 | 1.00 | ||||||||
104 | 360 | 15 | 25 | 4.50 | ||||||||
105 | 1,710 | 35 | 35 | 1.20 | ||||||||
201 | 10,210 | 25 | 15 | 0.75 | ||||||||
202 | 1,210 | 10 | 20 | 1.35 | ||||||||
203 | 1,810 | 20 | 25 | 0.20 | ||||||||
204 | 710 | 40 | 25 | 0.80 | ||||||||
205 | 120 | 10 | 15 | 2.50 |
(a) Calculate the annual usage cost of each item. (b) Classify the items as A, B, or C.
Item | Annual Usage ($) | Item Classification |
---|---|---|
101 | enter a dollar amount | select an item classification ABC |
102 | enter a dollar amount | select an item classification ABC |
103 | enter a dollar amount | select an item classification ABC |
104 | enter a dollar amount | select an item classification ABC |
105 | enter a dollar amount | select an item classification ABC |
201 | enter a dollar amount | select an item classification ABC |
202 | enter a dollar amount | select an item classification ABC |
203 | enter a dollar amount | select an item classification ABC |
204 | enter a dollar amount | select an item classification ABC |
205 | enter a dollar amount | select an item classification ABC |
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