Question: ( Please read carefully! Enter the number with digits, not in letters. For example: enter 1 0 , not Ten. If there is a fraction

(Please read carefully!
Enter the number with digits, not in letters. For example: enter 10, not Ten.
If there is a fraction to the number, do not enter unnecessary zeros. For example: enter 12.5, not 12.50.
Do not enter commas. For example: enter 3850, not 3,850.
Do not enter any extra spaces or other characters.
Questions are graded automatically. If you do not follow the formatting, then your answer will be graded wrong. If your answer is correct, I will be able to manually change your grade for those questions later, but you will lose 25% of the points. NO EXCEPTIONS, in order to be fair to everyone in the class.)
Suppose the solver provides you the following sensitivity report for each of the following SUBSTITUTE resources, in order to maximize energy production in a power plant.
Final
Shadow
Constraint
Allowable
Allowable
Cell
Name
Value
Price
R.H. Side
Increase
Decrease
$C$4
Wind
50
2
50
10
10
$C$5
Solar
10
5
10
4
2
$C$6
Coal
16
0
20
1E+30
4
$C$7
Nuclear
45
1
45
15
5
The current optimal object value, corresponding to the energy produced, is 200. Remember: the resources are SUBSTITUTE.
In the following questions if your answer is "exactly", then enter the same number. In other words, instead of "exactly 1000" enter "at least 1000 and at most 1000".
If we increase the capacity of Solar from 10 to 15, the optimal solution will be at least
and at most
.
If we decrease the capacity of Coal from 20 to 15, the optimal solution will be at least
and at most
.
If we simultaneously increase the capacities of Wind, Solar, Coal, and Nuclear from (50,10,20,45) to (55,12,23,50), then the objective will be at least
and at most
.
(Enter B or N for binding or non-binding.)
Coal:
Nuclear:

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 Databases Questions!