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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!