Question: In solving the preemptive situation using Excel, the model is generally run n times, where n is the number of goals. Which statement is true?
In solving the preemptive situation using Excel, the model is generally run n times, where n is the number of goals. Which statement is true?
A) At each iteration we need to alter the formula for the objective function cell, and in the Solver we need to modify the constraints.
B) At each iteration in the Solver we need to change the cell reference for the objective, and the constraints.
C) The objective never changes, but we need to modify the constraints in the Solver.
D) The constraints never change, but we need to alter the formula in the objective function cell.
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
