Question: Please show work using Excel. JMA Manufacturing is considering expanding manufacturing capacity at its New Bern facility. Engineering has developed estimates for three expansion plans.

Please show work using Excel.
JMA Manufacturing is considering expanding manufacturing capacity at its New Bern facility. Engineering has developed estimates for three expansion plans. The payoff that results from these expansions depends on the demand for JMA's new product, Fido Glide (running shoes for active dogs). The marketing department has developed estimates for the next year's potential profits associated with each of these expansions based on low demand and high demand. Small expansion: 1) The small expansion will cost $1.25 million to build. 2) The revenues are estimated to be $2 million if demand is low and $3.5 million if demand is high. Medium expansion: 1) The medium expansion will cost $2.5 million to build. 2) The revenues are estimated at $3.5 million and $4.25 million, respectively. Large expansion: 1) The large expansion will cost $5.5 million to build. 2) The revenues are estimated at $4.5 million and $7 million. Create a payoff table and calculate: 1) Maximax 2) Maximin 3) Minimax Regret What is your recommendation and why
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
