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

1 Expert Approved Answer
Step: 1 Unlock

Optimal RQ ordering policy for model 2 Inputs Range names used Setup cost per order 125 Actualfillra... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Document Format (3 attachments)

PDF file Icon

1497_60b741230457d_695286.pdf

180 KBs PDF File

Excel file Icon

1497_6048830f55ade_695286.xlsx

300 KBs Excel File

Word file Icon

1497_60b741230457d_695286.docx

120 KBs Word File

Students Have Also Explored These Related Practical Management Science Questions!