4x-2y
4
-2
14.00
<=
14
x-3y
1
-3
-4.50
<=
1
4x-2y
4
-2
14.00
>=
0
corner pts as computed by
(1.429,2.857)
(4.333,3.583)
(5.1,3.2)
(4,1)
(1,0)
(0,0)

Microsoft Excel 15.20 Answer Report
Worksheet: [HW Chapt7.xlsx]C7 HW4
Report Created: 4/1/2016 11:36:28 AM
Result: Solver found a solution.
All constraints and optimality conditions are satisfied.
Solver Engine
Engine: Simplex LP
Solution Time: 0.330771 Seconds.
Iterations: 4 Subproblems: 0
Solver Options
Max Time Unlimited, Iterations Unlimited, Precision 1E-06, Use Automatic Scaling
Max Subproblems Unlimited, Max Integer Sols Unlimited, Integer Tolerance 1%, Assume
Objective Cell (Max)
Cell
Name
Original Value
Final Value
$D$5
Z Max Z
0.00
419.50
Variable Cells
Cell
Name
Original Value
Final Value
Integer
$B$4
Solution x1
0.00
5.10 Contin
$C$4
Solution x2
0.00
3.20 Contin
Constraints
Cell
Name
Cell Value
Formula
Status
Slack
$D$12
4x-2y LHS
14.00 $D$12>=$F$12
Not Binding
14.00
$D$8
2x+4y LHS
23.00 $D$8<=$F$8
Binding
0
$D$9
-x+4y LHS
7.70 $D$9<=$F$9
Not Binding
2.3
$D$10
4x-2y LHS
14.00 $D$10<=$F$10 Binding
0
$D$11
x-3y LHS
-4.50 $D$11<=$F$11
Not Binding
5.5

e NonNegative

HW5 from handout
Varible
x1
x2
Solution
18.75
18.75
Max Z
Z
4
4
150.00
st
LHS
RHS
3x+5y
3
5
150.00
<=
150
x-2y
1
-2
-18.75
<=
10
5x+3y
5
3
150.00
<=
150
corner pts as computed by
(0,0)
10,0)
(25.385,7.692)
(18.75, 18.75)
(0,30)
Below info can be found on Answer portion
Slack Varibles are 3 and no surplus varibles
s1 = 0
s2 = 28.75
s3 = 0
Binding Varibles are
3x+5y and 5x +3y
Non Binding Varible is
x-2y

Microsoft Excel 15.20 Answer Report
Worksheet: [HW Chapt7.xlsx]C7 HW5
Report Created: 4/1/2016 12:31:19 PM
Result: Solver found a solution.
All constraints and optimality conditions are satisfied.
Solver Engine
Engine: Simplex LP
Solution Time: 0.304872 Seconds.
Iterations: 3 Subproblems: 0
Solver Options
Max Time Unlimited, Iterations Unlimited, Precision 1E-06, Use Automatic Scaling
Max Subproblems Unlimited, Max Integer Sols Unlimited, Integer Tolerance 1%, Assume
Objective Cell (Max)
Cell
Name
Original Value
Final Value
$D$5
Z Max Z
0.00
150.00
Variable Cells
Cell
Name
Original Value
Final Value
Integer
$B$4
Solution x1
0.00
18.75 Contin
$C$4
Solution x2
0.00
18.75 Contin
Constraints
Cell
Name
Cell Value
Formula
Status
Slack
$D$8
3x+5y LHS
150.00 $D$8<=$F$8
Binding
0
$D$9
x-2y LHS
-18.75 $D$9<=$F$9
Not Binding
28.75
$D$10
5x+3y LHS
150.00 $D$10<=$F$10 Binding
0

NonNegative

7-23 (pg282)
Varible
x1
x2
Solution
Max Z
Z
2
0.00
st
LHS
RHS
x+3y
1
3
0.00
>=
90
8x+2y
8
2
0.00
>=
160
3x+2y
3
2
0.00
>=
120
y
1
0.00
<=
70
corner pts as computed by
(0,70)
(2.5,70)
(0,60)
(8,48)

7-33 (pg282)
Varible
x1
x2
Solution
30.00
60.00
Max Z
Z
5
6
510.00
st
LHS
RHS
2x+y
2
1
120.00
<=
120
2x+3y
2
3
240.00
<=
240
corner pts as computed by

#### You've reached the end of your free preview.

Want to read all 41 pages?

- Fall '15
- LHS, Max Z