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

Chrome File Edit View History Bookmarks TC MyTCC: Studer × ALTI Launch ✓ Profiles Tab Window Help O Tue Mar 25 12:42 AM Pearson MyLak × P Course Home ✓ MasteringChen X Use the orbital × | My Uploads | b x Phosphorus El x + session.chemistry-mastering.pearson.com/myct/itemView?assignmentProblemID=234894331 A New Chrome available : (? Help

Draw the image of the following figure after a dilation centered at the origin with a scale factor of 14 退 14 12- 10 5- + Z 6 的 A X 10 12 14 16 18 G min 3 5

Obtain the voltage across the capacitor for the following input: (a) 5Volts; (b) 3sin(t); (c) 2 cos(t). Use Laplace transform and Cramer's rule.

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