MGMT 430 MANAGEMENT SCIENCE
MGMT 430 Week 2 – Discussion 3
|
|
A |
B |
C |
D |
E |
F |
|
1 |
|
|
|
|
|
|
|
2 |
Input Information |
|
|
|
|
|
|
3 |
|
Variable 1 |
Variable 2 |
Used |
(type) |
Available |
|
4 |
Constraint 1 |
2 |
5 |
40.0 |
<= |
40 |
|
5 |
Constraint 2 |
3 |
1 |
30.0 |
<= |
30 |
|
6 |
Constraint 3 |
1 |
1 |
13.1 |
>= |
12 |
|
7 |
|
|
|
|
|
|
|
8 |
Profit per Unit |
5 |
4 |
|
|
|
|
9 |
|
|
|
|
|
|
|
10 |
Output Information |
|
|
|
|
|
|
11 |
Variables |
8.5 |
4.6 |
|
|
|
|
12 |
Total Profit |
42.3 |
18.5 |
Total Profit = |
60.8 |
|
What does the value of cell B5 represent in the Excel model?
ABCDEFG
1
Microsoft Excel Sensitivity Report
2
4
Adjustable Cells
5
FinalReducedObjectiveAllowableAllowable
6
CellNameValueCostCoefficientIncreaseDecrease
7
$B$11 Variables Variable 18.50.0573.4
8
$C$11 Variables Variable 24.60.048.52.333333333
9
10
Constraints
11
FinalShadowConstraintAllowableAllowable
12
CellNameValuePriceR.H. SideIncreaseDecrease
13
$D$4Constraint 1 Used40.00.5401107
14
$D$5Constraint 2 Used30.01.330304.666666667
15
$D$6Constraint 3 Used13.10.0121.0769230771E+30