Question 5: P& \& supplies cases of cleaning materials nationwide and anticipates the demand to be 1800,1200,1500,800 and 2000 cases in regions R1 through R5 respectively. It is possible for P \& G Supplies to build small or large capacity plants in the Northern, Eastern, Southern, and Western regions of the country. The variable cost of producing one case in each plant, the monthly production capacity and costs of each large and small plant at each location, and the cost of shipping one case from each plant to each region is shown in the table below. (27 points) a) Solve this problem under each of the three scenarios as described below: Scenario 1 -.. We can have (None, or one Low cap, or one High cap, or both) plants in any of the four regions Scenario 2 -.- We can have (none, or only one plant which may be high cap or low cap) in any of the four regions Scenario 3 -.- We must have system-wide (combined for all open plants) excess capacity of at least 2000 cases b) Specify the shipping schedule and cost summary as shown below for each of the three scenarios Monthly Cost of Shipping: Monthly Fixed cost of plants: Monthly Variable Cost of Product: Total Monthly Cost: Question 5: P& \& supplies cases of cleaning materials nationwide and anticipates the demand to be 1800,1200,1500,800 and 2000 cases in regions R1 through R5 respectively. It is possible for P \& G Supplies to build small or large capacity plants in the Northern, Eastern, Southern, and Western regions of the country. The variable cost of producing one case in each plant, the monthly production capacity and costs of each large and small plant at each location, and the cost of shipping one case from each plant to each region is shown in the table below. (27 points) a) Solve this problem under each of the three scenarios as described below: Scenario 1 -.. We can have (None, or one Low cap, or one High cap, or both) plants in any of the four regions Scenario 2 -.- We can have (none, or only one plant which may be high cap or low cap) in any of the four regions Scenario 3 -.- We must have system-wide (combined for all open plants) excess capacity of at least 2000 cases b) Specify the shipping schedule and cost summary as shown below for each of the three scenarios Monthly Cost of Shipping: Monthly Fixed cost of plants: Monthly Variable Cost of Product: Total Monthly Cost