Explanation Calculation: Use Excel spreadsheet to solve the following linear programming problem, Minimize: c = 5.45 x + y + 1.5 z + w With subject to: 5.12 x − y + w ≤ 1000 z + w ≥ 2000 1.12 x + y ≤ 500 x ≥ 0 , y ≥ 0 , z ≥ 0 , w ≥ 0. First open an excel spreadsheet, Then follow the following steps: Step 1: Enter the text in the cells as, Step 2: Enter the formula in the cell B2 as “ =5.45*B11+B12+1.5B13+B14 ”. Step 3: Enter the formula in the cell B6 as “ =5.12*B11-B12+B14”. Step 4: Enter the formula in the cell B7 as “ =B13+B14 ”. Step 5: Enter the formula in the cell B8 as “ =1.12*B11+B12 ”. Step 6: Now go to the Data tab and click on Solver and a dialogue box named as Solver Parameters will appear, select “Mi n ”

Finite Mathematics and Application Calculus (Looseleaf) - Text Only

7th Edition

ISBN: 9781337291484

Author: Waner

Publisher: Cengage

See similar textbooks

Videos

Question

Chapter 6.4, Problem 24E

To determine

To calculate: The minimum value of c=5.45x+y+1.5z+w

With subject to:

5.12x−y+w≤1000z+w≥20001.12x+y≤500x≥0,y≥0,z≥0,w≥0.

Expert Solution & Answer

Want to see the full answer?

Check out a sample textbook solution

See solution

Chapter 6.4, Problem 23E

Chapter 6.4, Problem 25E

Students have asked these similar questions

Consider the function f(x) = x²-1. (a) Find the instantaneous rate of change of f(x) at x=1 using the definition of the derivative. Show all your steps clearly. (b) Sketch the graph of f(x) around x = 1. Draw the secant line passing through the points on the graph where x 1 and x-> 1+h (for a small positive value of h, illustrate conceptually). Then, draw the tangent line to the graph at x=1. Explain how the slope of the tangent line relates to the value you found in part (a). (c) In a few sentences, explain what the instantaneous rate of change of f(x) at x = 1 represents in the context of the graph of f(x). How does the rate of change of this function vary at different points?

1. The graph of ƒ is given. Use the graph to evaluate each of the following values. If a value does not exist, state that fact. и (a) f'(-5) (b) f'(-3) (c) f'(0) (d) f'(5) 2. Find an equation of the tangent line to the graph of y = g(x) at x = 5 if g(5) = −3 and g'(5) = 4. - 3. If an equation of the tangent line to the graph of y = f(x) at the point where x 2 is y = 4x — 5, find ƒ(2) and f'(2).

Does the series converge or diverge

Chapter 6 Solutions

Finite Mathematics and Application Calculus (Looseleaf) - Text Only

Ch. 6.1 - In Exercises 1-26, sketch the region that...Ch. 6.1 - In Exercises 1-26, sketch the region that...Ch. 6.1 - Prob. 3E Ch. 6.1 - Prob. 4E Ch. 6.1 - Prob. 5E Ch. 6.1 - Prob. 6E Ch. 6.1 - Prob. 7E Ch. 6.1 - In Exercises 1-26, sketch the region that...Ch. 6.1 - Prob. 9E Ch. 6.1 - Prob. 10E

Knowledge Booster

$Calculus$

Learn more about

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

The minimum value of c = 5.45 x + y + 1.5 z + w With subject to: 5.12 x − y + w ≤ 1000 z + w ≥ 2000 1.12 x + y ≤ 500 x ≥ 0 , y ≥ 0 , z ≥ 0 , w ≥ 0.

Solution Summary: The author calculates the minimum value of c=5.45x+y+1.5z+w with subject to: c5.12x-y-wle 1000

Videos

To calculate: The minimum value of c=5.45x+y+1.5z+w

With subject to:

5.12x−y+w≤1000z+w≥20001.12x+y≤500x≥0,y≥0,z≥0,w≥0.

Want to see the full answer?

Chapter 6 Solutions

The minimum value of c = 5.45 x + y + 1.5 z + w With subject to: 5.12 x − y + w ≤ 1000 z + w ≥ 2000 1.12 x + y ≤ 500 x ≥ 0 , y ≥ 0 , z ≥ 0 , w ≥ 0.

Solution Summary: The author calculates the minimum value of c=5.45x+y+1.5z+w with subject to: c5.12x-y-wle 1000

Videos

To calculate: The minimum value of c=5.45x+y+1.5z+w With subject to: 5.12x−y+w≤1000z+w≥20001.12x+y≤500x≥0,y≥0,z≥0,w≥0.

Want to see the full answer?

Chapter 6 Solutions

To calculate: The minimum value of c=5.45x+y+1.5z+w

With subject to:

5.12x−y+w≤1000z+w≥20001.12x+y≤500x≥0,y≥0,z≥0,w≥0.