Can you answer questions 1-3 please

Problem 1 (25 points) FlexSteal, marketed as a miracle brush-on sealant and baldness cure, is manufactured at three plants that are struggling to keep up with the demand at the four regional centers. The cost to ship a truckload from each of the existing plants to the regional centers is shown in the table. The current plan is to build another plant with a capacity of 400 to allow room for sales growth. The construction cost for the new plant (Plant A) and cost to ship to each of the regional centers is shown here. The optimal demand allocation for each plant is show in this table: 1. Calculate the shipping cost for this Supply Chain configuration which includes Plant A (10pts) 2. What is the total cost of this Supply Chain configuration which includes plant A? (10pts) 3. FlexSteal CFO asks you to run a scenario to close down Plant 3 in order to save transportation cost plus it is not fully utilized. What would be your answer? (5pts) A) Reduce demand fulfill from plant 3 ; B) Shift demand allocated to plant 3 to new Plant A; C) Not enough capacity is available in the other 3 plants to meet demand; D) Allocate the demand fulfilled from plant 3 evenly across the remaining 3 plants. Problem 1 (25 points) FlexSteal, marketed as a miracle brush-on sealant and baldness cure, is manufactured at three plants that are struggling to keep up with the demand at the four regional centers. The cost to ship a truckload from each of the existing plants to the regional centers is shown in the table. The current plan is to build another plant with a capacity of 400 to allow room for sales growth. The construction cost for the new plant (Plant A) and cost to ship to each of the regional centers is shown here. The optimal demand allocation for each plant is show in this table: 1. Calculate the shipping cost for this Supply Chain configuration which includes Plant A (10pts) 2. What is the total cost of this Supply Chain configuration which includes plant A? (10pts) 3. FlexSteal CFO asks you to run a scenario to close down Plant 3 in order to save transportation cost plus it is not fully utilized. What would be your answer? (5pts) A) Reduce demand fulfill from plant 3 ; B) Shift demand allocated to plant 3 to new Plant A; C) Not enough capacity is available in the other 3 plants to meet demand; D) Allocate the demand fulfilled from plant 3 evenly across the remaining 3 plants