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.

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 If you are presente 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 would you rent it and why? month, would you consider renting it? If yes, which month(s) obtained in part (b) and withou are expected to answer this part by using the LP solution you