Solve the following LP model. a. Develop a spreadsheet model and find the optimal solution using Excel Solver. b. What is the optimal solution? What is the optimal objective function value?   Maximize P = 2x1 + 9x2 Subject to   2x1 + 3x2 <= 30   2x1 + x2 <= 16   x1 - x2 <= 0   x1 ≥ 0, x2 ≥ 0

College Algebra
7th Edition
ISBN:9781305115545
Author:James Stewart, Lothar Redlin, Saleem Watson
Publisher:James Stewart, Lothar Redlin, Saleem Watson
Chapter5: Systems Of Equations And Inequalities
Section: Chapter Questions
Problem 1P
icon
Related questions
Question

Solve the following LP model.

a. Develop a spreadsheet model and find the optimal solution using Excel Solver.
b. What is the optimal solution? What is the optimal objective function value?

 

Maximize P = 2x1 + 9x2
Subject to
  2x1 + 3x2 <= 30
  2x1 + x2 <= 16
  x1 - x2 <= 0
  x1 ≥ 0, x2 ≥ 0 

Expert Solution
steps

Step by step

Solved in 5 steps with 6 images

Blurred answer
Recommended textbooks for you
College Algebra
College Algebra
Algebra
ISBN:
9781305115545
Author:
James Stewart, Lothar Redlin, Saleem Watson
Publisher:
Cengage Learning