Question: In both (R,Q) models, the one with a shortage cost and the one with a service level constraint, we set up Solver so that the
In both (R,Q) models, the one with a shortage cost and the one with a service level constraint, we set up Solver so that the multiple k is constrained to be nonnegative. The effect is that the reorder point R will be no less than the mean demand during lead time, and the expected safety stock will be nonnegative. This seems reasonable, but is it always optimal? Experiment with the service level in the file R,Q Policy 2.xlsx. Change the Solver settings to allow the multiple k to be negative; that is, don’t constrain it to be nonnegative. For lower service levels, is it ever optimal to have k negative? Comment briefly why this might or might not be the case and explain the implications for the company.
Step by Step Solution
3.44 Rating (167 Votes )
There are 3 Steps involved in it
Optimal RQ ordering policy for model 2 Inputs Range names used Setup cost per order 125 Actualfillra... View full answer
Get step-by-step solutions from verified subject matter experts
Document Format (3 attachments)
1497_60b741230457d_695286.pdf
180 KBs PDF File
1497_6048830f55ade_695286.xlsx
300 KBs Excel File
1497_60b741230457d_695286.docx
120 KBs Word File
