Question: In Example 12.6, we discussed the equivalence between the model with shortage costs and the model with a service level constraint. We also showed how
In Example 12.6, we discussed the equivalence between the model with shortage costs and the model with a service level constraint. We also showed how to illustrate this equivalence with SolverTable. Extend the SolverTable in the R,Q Policy 1.xlsx file, with the unit shortage cost as the single input varied from $1 to $15 in increments of $1. As outputs, keep track of the order quantity, the safety stock, the reorder point, the fraction of demand met with existing inventory, and the expected annual setup, holding, and shortage costs. Discuss whether these go in the direction you would expect. Also, discuss how these results relate the two models, one with shortage costs and the other with a service level constraint. (What is equivalent to what?)
Step by Step Solution
3.52 Rating (169 Votes )
There are 3 Steps involved in it
Model Camera ordering Inputs Setup cost per order 125 Holding cost per unit per year 17 Expected ann... View full answer
Get step-by-step solutions from verified subject matter experts
Document Format (1 attachment)
1497_604883ff42840_695285.xlsx
300 KBs Excel File
