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:
Not the answer you're looking for?
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...
ADVERTISEMENT
Need Online Homework Help?
Get Answers For Free
Most questions answered within 1 hours.
ADVERTISEMENT
Active Questions
asked 28 minutes ago
asked 42 minutes ago
asked 55 minutes ago
asked 59 minutes ago
asked 1 hour ago
asked 1 hour ago
asked 1 hour ago
asked 1 hour ago
asked 2 hours ago
asked 2 hours ago
asked 2 hours ago
asked 2 hours ago