(b) Consider the following 5 production alternatives at the $500 price. Construct a Decision Table with...

Transcribed Image Text:

(b) Consider the following 5 production alternatives at the $500 price. Construct a Decision Table with Excel without using Data Table. Which Alternative has the biggest profit? - Alternative 1 produce 0% of Q at Plant 1 (and, therefore, 100% at Plant 2) Alternative 2 - produce 25% of Q at Plant 1 (and, therefore, 75% at Plant 2) Alternative 3 - produce 50% of Q at Plant 1 (and, therefore, 50% at Plant 2) Alternative 4 - produce 75% of Q at Plant 1 (and, therefore, 25% at Plant 2) Alternative 5 - produce 100% of Q at Plant 1 (and, therefore, 0% at Plant 2) (Submit via Canvas, 5 points) (b) Consider the following 5 production alternatives at the $500 price. Construct a Decision Table with Excel without using Data Table. Which Alternative has the biggest profit? - Alternative 1 produce 0% of Q at Plant 1 (and, therefore, 100% at Plant 2) Alternative 2 - produce 25% of Q at Plant 1 (and, therefore, 75% at Plant 2) Alternative 3 - produce 50% of Q at Plant 1 (and, therefore, 50% at Plant 2) Alternative 4 - produce 75% of Q at Plant 1 (and, therefore, 25% at Plant 2) Alternative 5 - produce 100% of Q at Plant 1 (and, therefore, 0% at Plant 2) (Submit via Canvas, 5 points)