Question 3 , Please do it on excel.

sourcing for the following levels of demand: 800 , bender, or that 1,000,1,200, and 1,400 . Use this information to set up accident. Develc a payoff table for the decision problem. Decision Strategies Without Outcome Probabilities 2. For the payoff table you developed in Problem 1, determine the decision using the aggressive, conservative, and opportunity-loss strategies. *3. The DoorCo Corporation is a leading manufacturer of garage doors. All doors are manufactured in their plant in Carmel, Indiana, and shipped to distribution centers or major customers. DoorCo recently acquired another manufacturer of garage doors, Wisconsin Door, and is considering moving its wood door operations to the Wisconsin plant. Key considerations in this decision are the transportation, labor, and production costs at the two plants. Complicating matters is the fact that marketing is predicting a decline in the demand for wood doors. The company developed three scenarios: a. Demand falls slightly, with no noticeable effect on production. b. Demand and production decline 20%. c. Demand and production decline 40%. The following table shows the total costs under each decision and scenario. What decision of the followi a. aggressive b. conservati c. opportuni *6. For the Door compute the What decision should DoorCo make using each of each decisior the following strategies? a. aggressive strategy 7. For the car-re b. conservative strategy standard dev c. opportunity-loss strategy What does t decision