Question: Based on the Answer and Sensitivity reports, what is the objective function? Objective Cell ( Min ) Cell Name Original Value SB$ 1 8 Cost

Based on the Answer and Sensitivity reports, what is the objective function?
Objective Cell (Min)
Cell Name Original Value
SB$18 Cost=
2693333.33
Variable Cells
Cell
$B$15 x1
SB$16 x2
SB$17 x3
Name Original Value
70.00
120.00
53.33
Constraints
Variable Cells
Final Value
Cell
Name
$B$15 x1
SB$16 x2
SB$17 x3
70
120
53.33333333
Constraints
Final Value
2693333.33
Final Value
Integer
70.00 Contin
120.00 Contin
53.33 Contin
Cell
Name
Cell Value
Formula
Status
Slack
SHS10<= Usage
70 SHS10<=$G$10 Not Binding
50
SHS11<= Usage
120 SHS11<=SG$11 Binding
0
SHS12<= Usage
53.33 SHS12<=SG$12 Not Binding
66.6666667
SGS6'#NAME?
2,500,000 SGS6=SHS6
Binding
0
SHS7>= Usage
70 SHS7>=SG$7
Binding
0
SH$8>= Usage
120 SHS8>=$G$8
Not Binding
70
SHS9>= Usage
53.33 SHS9>=$G$9
Not Binding
3.33
Reduced
Cost
Objective Allowable Allowable
Coefficient
Increase
Decrease
12000
1E+301259.259259
9000666.6666667
1E+30
14500
1700
1000
Final
Shadow
Constraint Allowable Allowable
Cell Name
Value
Price
R.H. Side
Increase
Decrease
SH$10<= Usage
1E+30
50
SH$11<= Usage
120-6666666667
5
70
SHS12<= Usage 53.33333333
1E+3066.66666667
SG56'#NAME?
2500000-1.074074074
0L0
45000
900000
SHS7>= Usage
70
1259.259259
4.5
70
SHS8>= Usage
120
50
70
1E+30
SH$9>= Usage 53.33333333
503.333333333
1E+30
Max 2693333.33 X1
O Max 2693333.33 X1+70X2
Min 70X1+120x2
O Min 70X1+120x2+53.33X3

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!