Explore BrainMass

Cost-Benefit Trade-Off (Linear Programming).

Consider a cost-benefit-trade-off problem having the following data:
Benefit Contribution
Per Unit of
Each Activity
Benefit 1 2 Level
1 5 3 60
2 2 2 30
3 7 9 126
Unit Cost $60 $50

a. Formulate a linear programming model for this problem on a spreadsheet.
b. Use Solver to find the optimal solution.
c. Express the model in algebraic form.
d. Use the graphical method to solve the problem.


Solution Summary

The solution illustrates the solution of a linear programming problem using Excel solver and graphical method. Response includes a Word and Excel attachment.