Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

( 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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Formal SQL Tuning For Oracle Databases Practical Efficiency Efficient Practice

Authors: Leonid Nossov ,Hanno Ernst ,Victor Chupis

1st Edition

3662570564, 978-3662570562

Students also viewed these Databases questions