Given the following linear optimization model, transform this model into the required form and solve using...

Given the following linear optimization model, transform this model into the required form and solve using Solver.

Objective function: 8.2? + 7.0? + 6.5? + 9.0? = ??????? ????

Constraints: 6? + 2? + 5? + 7? ≥ 820

?/? + ? + ? + ? ≥ 0.3

? + ? ? + ? ≥ 0.2

? ≥ ? + D

Please Use Excel

Solutions

Expert Solution

The Excel solution is:

The Excel formulas are:

orchestra answered 1 year ago

Next > < Previous

Related Solutions

1. Solve the following integer optimization model by using Excel Solver: Maximize Z = 5x1 +...

1. Solve the following integer optimization model by using Excel Solver: Maximize Z = 5x1 + 6x2 Subject to 3x1 + 4x2 < 10 4x1 + 2x2 < 15 x1, x2 > 0 and integer Please show how to use the excel solver as well as steps. :)

QUESTION 1: Solve the linear programming model given below using the simplex method. Write the primal...

QUESTION 1: Solve the linear programming model given below using the simplex method. Write the primal and dual results from the optimal table you obtained. MAX Z = 10?1 + 20?2 + 5?3 6?1 + 7?2 + 12?3 ≥ 560 5?1 − 3?2 + x3 ≤ 100 2000?1 + 1000?2 + 1000?3 ≤ 62298 ?1,?2,?3 ≥ 0 IMPORTANT REMINDER ABOUT THE QUESTION SOLUTION: NEW ORDER CALCULATIONS SHOULD BE WRITTEN DETAILED WHEN CREATING THE SYMPLEX TABLES. WHEN THE CALCULATIONS ARE SHOWED AND...

Write the following linear optimization problem in standard form. Maximize 2x + y Subject to ...

Write the following linear optimization problem in standard form. Maximize 2x + y Subject to x + y > 2 3x + 4y < 12 x, y > 0

Solve the following constant coefficient linear differential equations using Laplace Transform (LT), Partial Fraction Expansion (PFE),...

Solve the following constant coefficient linear differential equations using Laplace Transform (LT), Partial Fraction Expansion (PFE), and Inverse Laplace Transform (ILT). You must check answers in the t-domain using the initial conditions. Note: Complex conjugate roots y ̈ (t) + 6 ̇y (t) + 13y (t) = 2 use the initial conditions y(0) = 3, ̇y(0) = 2.

Write a function to solve a system of linear equations of the form Ax= b using...

Write a function to solve a system of linear equations of the form Ax= b using the iterative Gauss-Seidel method. You are free to use any basic MATLAB operation to implement the algorithm (i.e. you may use any combination of loops, indexing, math, etc.), but avoid “built-in” solution methods — you would not be allowed to use the GaussSeidel function if such a function existed. The function must also test for a number of possible issues. If an issue is...

Given the following linear optimization problem Maximize 10x + 20y Subject to x + y <...

Given the following linear optimization problem Maximize 10x + 20y Subject to x + y < 50 2x + 3y < 120 x > 10 x, y > 0 (a) Graph the constraints and determine the feasible region. (b) Find the coordinates of each corner point of the feasible region. (c) Determine the optimal solution and optimal objective function value.

Solve the following optimization problem (Be sure to include the statement of the optimization problem and...

Solve the following optimization problem (Be sure to include the statement of the optimization problem and a graph of the feasible in your solution): Jamie has joined a building contest. A dog shape requires 3 small blocks and one large block to build. A robot shape requires 5 small bricks and 5 large bricks to build. Jamie has a supply of 240 small bricks and 100 large bricks. If a dog is worth 2 points and a robot is worth...

Consider the following linear optimization model. Z = 3x1+ 6x2+ 2x3 st 3x1 +4x2 + x3...

Consider the following linear optimization model. Z = 3x1+ 6x2+ 2x3 st 3x1 +4x2 + x3 ≤2 x1+ 3x2+ 2x3 ≤ 1 X1, x2, x3 ≥0 (10) Write the optimization problem in standard form with the consideration of slack variables. (30) Solve the problem using simplex tableau method. (10) State the optimal solution for all variables.

Developing a workforce schedule (using Linear Programming to model and solve this problem) A local bank...

Developing a workforce schedule (using Linear Programming to model and solve this problem) A local bank needs the minimum number of employees needed for each day of the week listed in the following table. If a staff is hired, his/her schedule will be working 5 consecutive days and take two days off. The bank operates seven days a week. Day of the Week M T W TH F Sa Su Number of staff needed 4 5 5 3 5 2...

Consider the following transportation problem. Formulate this problem as a linear programming model and solve it...

Consider the following transportation problem. Formulate this problem as a linear programming model and solve it using the MS Excel Solver tool. Shipment Costs ($), Supply, and Demand: Destinations Sources 1 2 3 Supply A 6 9 100 130 B 12 3 5 70 C 4 8 11 100 Demand 80 110 60 (4 points) Volume Shipped from Source A __________ (4 points) Volume Shipped from Source B __________ (4 points) Volume Shipped from Source C __________ (3 points) Minimum...

Subjects