Explore BrainMass

Cost-Benefit Trade-Off (Linear Programming).

This content was STOLEN from BrainMass.com - View the original, and get the solution, here!

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 September 26, 2018, 11:29 am ad1c9bdddf - https://brainmass.com/business/operations-research/cost-benefit-trade-off-linear-programming-492569


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.