Consider a cost-benefit-trade-off problem having the following data.

a. Formulate a linear programming model for this problem on a spreadsheet.
b. Make five guesses of your own choosing for the optimal solution. Use the spreadsheet to check each one for feasibility and, if feasible, for the value of the objective function. Which feasible guess has the best objective function value?
c. Use Solver to find an optimal solution.

Transcribed Image Text:

Benefit Contribution per Unit of Each Activity Minimum Acceptable Level Benefit 2 4 - 1 4 80 60 4 -1 2 4 110 -1 Unit cost $400 $600 $500 $300 3.