Problem 12-15 (a)
Inventory EOQ Model
Input Data
Demand rate, D 150000
Results
Economic order quantity, Q* 38729.83
Maximum inventory 38729.83
Problem 12-15 (b)
Inventory EOQ Model
Input Data
Demand rate, D 150000
Results
Economic order quantity, Q* 38729.83
Maximum inventory 38729.83
Problem 12-15 (c)
Inventory EOQ Model Inventory EOQ Model
Input Data Input Data
Demand rate, D 150000 Demand rate, D 150000
Ordering cost, Co$30.00 Ordering cost, Co$30.00
Results Results
Economic order quantity, Q* 38729.83 Economic order quantity, Q* 75000.00
(Type in 150,000/2=75,000 in cell F12)
Maximum inventory 38729.83 Maximum inventory 75000.00
Carrying cost, Ch$0.006 (fixed amount) Carrying cost, Ch$0.006 (fixed amount)
Problem 12-15 (d)
Inventory EOQ Model Inventory EOQ Model Inventory EOQ Model
Input Data Input Data Input Data
Demand rate, D 150000 Demand rate, D 150000 Demand rate, D 150000
Results Results Results
Economic order quantity, Q* 44721.36 Economic order quantity, Q* 50000.00 Economic order quantity, Q* 54772.26
Maximum inventory 44721.36 Maximum inventory 50000.00 Maximum inventory 54772.26
Average inventory 22360.68 Average inventory 25000.00 Average inventory 27386.13
Number of orders 3.35 Number of orders 3.00 Number of orders 2.74
Total holding cost $134.16 Total holding cost $150.00 Total holding cost $164.32
Total ordering cost $134.16 Total ordering cost $150.00 Total ordering cost $164.32