Question: Consider the SOP data given in the attached Excel file. Read the given information carefully and use the demand forecast given in the table to
Consider the SOP data given in the attached Excel file. Read the given information carefully and use the demand forecast given in the table to answer the following questions. a) Propose a chase SOP plan and a level workforce SOP plan for the next 6 months. Discuss the main characteristics of these two plans in contrast with each other. Between these two plans, which plan would you recommend the company to choose? Justify your recommendation. b) Use a mathematical model to find an optimal SOP plan. In your model also consider that the existing warehouse space is limited and can hold no more than 500 units at any given time. c) If you are presented with an option to rent additional warehouse space for 150 units, on a monthly basis, for $1000 per month, would you consider renting it? If yes, which month(s) would you rent it and why? You are expected to answer this part by using the LP solution you obtained in part (b) and without having to solve the model again.

Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
