SOLUTION: Minimize cost = $4X + $7Y Subject to the constraints 2X + 3Y >= 60 4X + 2Y >= 80

Algebra ->  Test -> SOLUTION: Minimize cost = $4X + $7Y Subject to the constraints 2X + 3Y >= 60 4X + 2Y >= 80       Log On


   

Question 1185135: Minimize cost = $4X + $7Y
Subject to the constraints
2X + 3Y >= 60
4X + 2Y >= 80
X <= 24
X, Y >= 0
Use Excel to solve the original LP and use the sensitivity reports to answer the following questions. Each question is independent of the others. Determine if (and how) the following changes would affect the optimal solution values and/or cost.
a. The cost per unit of Y increases to $9.
b. The first constraint changes to 2X + 3Y >= 90.
c. The third constraint changes to X <= 15.
Answer by ikleyn(52754) About Me  (Show Source):
You can put this solution on YOUR website!
.

On using Excel technology for solving Linear Programming problems,   see and learn the subject from these  Internet sources


Video-lesson   Excel - Linear Programming   (Two variables)   YouTube
https://www.youtube.com/watch?v=lMP4KPKIn1A


Video-lesson   Solving linear programming problems with Excel Solver   (Three variables)   YouTube
https://www.youtube.com/watch?v=ByxUKKtZqFU


Text version   (guide,  instructions,  desription)
https://www.fm-magazine.com/issues/2019/feb/linear-programming-microsoft-excel.html


Text version   (guide,  instructions,  desription)   (Two variable)
http://faculty.sfasu.edu/fisherwarre/lp_solver.html


Text version   (guide,  instructions,  desription)   (Three variable)
https://www.msubillings.edu/asc/writingcenter/resources/math/tutorials/finitemathhelps/Lin%20Prog%20with%20Excel.pdf