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.

© BrainMass Inc. brainmass.com July 15, 2018, 7:25 pm ad1c9bdddf


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.