Problem:
Modern Furniture Stores sells modern coffee tables. The expected demand for next 12 months is 1000 coffee tables. Tables are handmade in Scotland. The cost of ordering a set of tables is $800. In addition the average cost of storing a coffee table is 150 dollars. The time between placing an order and receiving it at the store is 5 days. Finally the daily standard deviation for the demand is estimated as 0.5 tables per day. Answer the following questions:
Required:
Question 1) What is the optimal order size?
Question 2) What is the total inventory cost per year?
Question 3) What is the inventory turnover?
Question 4) What is the inventory cycle?
Question 5) Find the reordering point.
Question 6) What would be the safety stock required for a 95% customer service level?
Question 7) What would be the yearly cost of carrying the safety stock during the year?
Question 8) What would be the new reorder point?
The manufacturer offers the following purchasing options:
|
Units
|
Price
|
|
0 - 99
|
1,000
|
|
100 - 299
|
950
|
|
300 - 499
|
900
|
|
500 -999
|
850
|
|
1,000+
|
825
|
Question 1) Find the order quantity that minimizes total cost.
Question 2) Find the new total inventory cost (include safety stock).
Question 3) Find the new inventory turnover.
Question 4) Find the new inventory cycle
Solve the given numerical problem and illustrate step by step calculation.