You are given the following data for a linear programming problem where the objective is to minimize the cost of conducting two nonnegative activities so as to achieve three benefits that do not fall below their minimum levels.

(a) Formulate a linear programming model for this problem.
(b) Use the graphical method to solve this model.
(c) Display the model on an Excel spreadsheet.

(d) Use the spreadsheet to check the following solutions: (x₁, x₂) = (7, 7), (7, 8), (8, 7), (8, 8), (8, 9), (9, 8). Which of these solutions are feasible? Which of these feasible solutions has the best value of the objective function?

(e) Use Solver to solve this model by the simplex method.

(f) Use ASPE and its Solver to solve the model by the simplex method.

Transcribed Image Text:

Benefit Contribution per Unit of Each Activity Minimum Acceptable Level Benefit Activity 1 Activity 2 60 30 126 2 9 Unit cost $60 $50