Consider a resource-allocation problem having the following data. Contribution per unit = profit per unit of the

Question:

Consider a resource-allocation problem having the following data.

Resource Usage per Unit of Each Activity Amount of Resource Available Resource 1 2 з 4 4 400 -2 -1 2 300 2 -1 400 300 -

Contribution per unit = profit per unit of the activity.
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?