Question: Be sure to always round inventory quantities (Q, R, SS, I max ) values up to the next integer for the final answers. All other
Be sure to always round inventory quantities (Q, R, SS, Imax) values up to the next integer for the final answers. All other values should be calculated based on the standard formulas without rounding them to integers and should be entered with one decimal place (e.g. average inventory, average number of orders, etc.).
Cavendish Convenience Stores purchases 1000 U.S. Road Maps a year for its inventory from its supplier, who offers pricing at quantity discounts. The cost for Cavendish to place an order is $42, and the annual carrying cost is 15%/year. What quantity should Cavendish order? The quantities and pricing from this supplier are shown in the following table:
| ORDER QUANTITY | UNIT PRICE |
| 0-149 | $12.00 |
| 150-349 | $11.70 |
| 350-999 | $11.50 |
| 1000 or more | $11.20 |
- What is the EOQ when the unit price is $12?
- What is the total cost (holding + purchase+ ordering) when purchasing from the supplier where the unit price is $11.70?
- What is the total cost (holding + purchase+ ordering) when purchasing from the supplier where the unit price is $11.50?
- What is the total cost (holding + purchase+ ordering) when purchasing from the supplier where the unit price is $11.20?
- Based on the total costs, what quantity should be ordered from the supplier?
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
