You are given the following data for a linear programming problem where the objective is to maximize the profit from allocating three resources to two nonnegative activities.

Contribution per unit = profit per unit of the activity.
(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₂) = (2, 2), (3, 3), (2, 4), (4, 2), (3, 4), (4, 3). Which of these solutions are feasible? Which of these feasible solutions has the best value of the objective function?

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

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

Transcribed Image Text:

Resource Usage per Unit of Each Activity Amount of Resource Available Resource Activity 1 Activity 2 10 20 20 4 Contribution $20 per unit $30