Unlock document.
This document is partially blurred.
Unlock all pages and 1 million more documents.
Get Access
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
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
