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

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)   (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

RELATED QUESTIONS
Minimize c=2x+3y+4z subject to minimize the problem: 4x+2y+z=10 x+y-z=5... (answered by Edwin McCravy)

Minimize c=2x+3y+4z subject to minimize the problem: 4x+2y+z≥10 x+y-z≥5... (answered by ikleyn)

Minimize C=2x+3y+4z subject to minimize the problem: 4x+2y+z=10 x+y-z=5... (answered by ikleyn)

Minimize C=2x+3y +4z subject to minimize the problem: 4x+2y+z=10 x+y-z=5... (answered by ikleyn)

maximize the objective function 4x + 7y subject to these constraints: x+2y ≤ 1000... (answered by greenestamps)

Maximize the objective function 4x + 7y subject to these constraints- x+2y ≤ 1000 (answered by ikleyn)

Maximize the objective function 4x + 7y subject to these constraints: x+2y ≤ 1000... (answered by ikleyn)

Maximize the objective function 4x+7y subject to these constraints: x+2y ≤ 1000... (answered by ikleyn)

Minimize z=4x+7y subject to... (answered by ikleyn)