Explanation Given Information: The given linear programming problem is g = 480 x 1 + 460 x 2 + 440 x 3 + 420 x 4 + 530 y 1 + 510 y 2 + 490 y 3 + 470 y 4 − 9500 Subject to x 1 + y 1 ≥ 30 x 1 + x 2 + y 1 + y 2 ≥ 90 x 1 + x 2 + x 3 + y 1 + y 2 + y 3 ≥ 165 x 1 + x 2 + x 3 + x 4 + y 1 + y 2 + y 3 + y 4 ≥ 190 And, x 1 ≤ 40 x 2 ≤ 40 x 3 ≤ 40 x 4 ≤ 40 Calculation: Consider the statement, Use Excel spreadsheet to solve the following linear programing problem, Then the objective function is Minimize g = 480 x 1 + 460 x 2 + 440 x 3 + 420 x 4 + 530 y 1 + 510 y 2 + 490 y 3 + 470 y 4 − 9500 Subject to x 1 + y 1 ≥ 30 x 1 + x 2 + y 1 + y 2 ≥ 90 x 1 + x 2 + x 3 + y 1 + y 2 + y 3 ≥ 165 x 1 + x 2 + x 3 + x 4 + y 1 + y 2 + y 3 + y 4 ≥ 190 And, x 1 ≤ 40 x 2 ≤ 40 x 3 ≤ 40 x 4 ≤ 40 First open an excel spreadsheet, Then following steps: Step: 1 Enter the text in the following cells

Mathematical Applications for the Management, Life, and Social Sciences

12th Edition

ISBN: 9781337625340

Author: Ronald J. Harshbarger, James J. Reynolds

Publisher: Cengage Learning

See similar textbooks

Videos

Question

Chapter 4.5, Problem 26E

To determine

To calculate: Minimization of the linear programming problem.

g=480x1+460x2+440x3+420x4+530y1+510y2+490y3+470y4−9500

Subject to

x1+y1≥30x1+x2+y1+y2≥90x1+x2+x3+y1+y2+y3≥165x1+x2+x3+x4+y1+y2+y3+y4≥190

And,

x1≤40x2≤40x3≤40x4≤40

Expert Solution & Answer

Want to see the full answer?

Check out a sample textbook solution

See solution

Chapter 4.5, Problem 25E

Chapter 4.5, Problem 27E

Students have asked these similar questions

The times it takes to complete a statistics exam have a normal distribution with a mean of 40 minutes and standard deviation of 6 minutes. Deshawn's time falls at the 42nd percentile. How long does Deshawn take to finish her exam? bad boy wod abbed a le signe ne tolgikiwo (ezonipuo brit of heen ugy shies von no rep on ud af vt to into Or festes e a (92) 00

Jimmy walks a mile, and his previous times have a normal distribution with a mean of 8 minutes and standard deviation of 1 minute. What time does he have to make to get into his own top 10 percent of his fastest times?

Chapter 4 Solutions

Mathematical Applications for the Management, Life, and Social Sciences

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, subject and related others by exploring similar questions and additional content below.

Solution Summary: The author explains the optimal solution to the linear programming problem.

Videos

To calculate: Minimization of the linear programming problem. g=480x1+460x2+440x3+420x4+530y1+510y2+490y3+470y4−9500 Subject to x1+y1≥30x1+x2+y1+y2≥90x1+x2+x3+y1+y2+y3≥165x1+x2+x3+x4+y1+y2+y3+y4≥190 And, x1≤40x2≤40x3≤40x4≤40

Want to see the full answer?

Chapter 4 Solutions

To calculate: Minimization of the linear programming problem.

g=480x1+460x2+440x3+420x4+530y1+510y2+490y3+470y4−9500

Subject to

x1+y1≥30x1+x2+y1+y2≥90x1+x2+x3+y1+y2+y3≥165x1+x2+x3+x4+y1+y2+y3+y4≥190

And,

x1≤40x2≤40x3≤40x4≤40