Question

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

Homework Answers

Answer #1

Solution:

The Excel solution is:

The Excel formulas are:

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Transform the model into standard form and solve by using the computer. Given the following linear...
Transform the model into standard form and solve by using the computer. Given the following linear programming model: Maximize Z = 140x + 205y + 190z Subject to: 10x + 15y + 8z <= 610 x/y <=3 x>=.4(x+y+z) y>=z
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.
The following constraints of a linear programming model have been graphed on the graph paper provided...
The following constraints of a linear programming model have been graphed on the graph paper provided (same constraints found in problem #3) to form a feasible region: 2X    + 6Y     >=    120 10X + 2Y     > =   200 X      +     Y     <=    120 X                     <=    100                  Y    <=      80 X,Y                  >=        0 Using the graphical method, determine the optional solution and the objective function value for the following objective functions. Graph the objective function as a dashed line on...
a. Solve the following linear programming model by using the graphical method: graph the constraints and...
a. Solve the following linear programming model by using the graphical method: graph the constraints and identify the feasible region then determine the optimal solution (s) (show your work). Minimize Z = 3x1 + 7x2 Subject to 9x1 + 3x2 ≥ 36 4x1 + 5x2 ≥ 40 x1 – x2 ≤ 0 2x1 ≤ 13 x1, x2 ≥ 0 b. Are any constraints binding? If so, which one (s)?
The following constraints of a linear programming model have been graphed on the graph paper provided...
The following constraints of a linear programming model have been graphed on the graph paper provided to form a feasible region: 2X    + 6Y     >=    120 10X + 2Y     > =   200 X      +     Y     <=    120 X                     <=    100                  Y    <=      80 X,Y                  >=        0 Using the graphical method, determine the optional solution and the objective function value for the following objective functions. Graph the objective function as a dashed line on the feasible region described by the...
Solve the following linear programming model by using the graphical method: graph the constraints and identify...
Solve the following linear programming model by using the graphical method: graph the constraints and identify the feasible region. Using the corner points method, determine the optimal solution (s) (show your work). Maximize Z = 6.5x1 + 10x2 Subject to x1 + x2 ≤ 15 2x1 + 4x2 ≤ 40 x1 ≥ 8 x1, x2 ≥ 0 b. If the constraint x1 ≥ 8 is changed to x1 ≤ 8, what effect does this have on the optimal solution? Are...
A&F Hardware Inc. manufactures hammers and shovels from steel and wood using both skilled and unskilled...
A&F Hardware Inc. manufactures hammers and shovels from steel and wood using both skilled and unskilled labor. The following table gives the profit generated per unit, as well as the amount of wood, steel, skilled labor and unskilled labor required, per unit of each product along with their maximum monthly limits in terms of availability. Hammers Shovels Max Monthly Limit Profit $9.59 per unit $12.6 per unit Wood Required $1.55 ft. per unit $3.15 ft per unit 2000 feet Steel...
Need to see step by step solutions Please: Solve Problem and Applications: ch 13- prob 7...
Need to see step by step solutions Please: Solve Problem and Applications: ch 13- prob 7 [Klein Industries manufactures three types of portable air compressors] in page 451 at the end of chapter 13 in your textbook, USA 5th edition. The data is given as part of the question. There is no external data set provided. Use what is given by the problem. You need to submit a formal APA paper to explain all your findings together with your Excel...
Many forecasting models use parameters that are estimated using nonlinear optimization. For instance, the basic exponential...
Many forecasting models use parameters that are estimated using nonlinear optimization. For instance, the basic exponential smoothing model for forecasting sales is      ŷ(t + 1) = αyt + (1 - α) ŷt      where      ŷt + 1 = forecast of sales for period t + 1      yt = actual sales for period t      ŷt = forecast of sales for period t      α = smoothing constant, 0 ≤ α ≤ 1 Click on the datafile logo to reference the data. This model...
Part 3 – Steelcase Production Steelcase Corporation manufactures 3 basic products: chairs, desks, and tables. Below...
Part 3 – Steelcase Production Steelcase Corporation manufactures 3 basic products: chairs, desks, and tables. Below is chart which summarizes the number of labor hours spent for each product in each division. Chairs Desks Tables Process Carpentry 2 3 6 Finishing 1 1 1 Assembly 4 6 2 In a given week, Steelcase has 250 hours available for carpentry, 100 hours available for finishing, and 400 hours available for assembly. Steelcase makes a profit of $66 on each chair, $75...