Consider the Answer and Sensitivity Reports at the end of the questionnaire to answer the following questionsObjective Function : Max Z = 3x1 +2x2Sensitivity Ranges :C1 (3)Upper limit 3 +∞ = ∞Lower limit 3-2 = 1C2 (2)Upper limit 4+2 = 6Lower limit 2-3.5 = -1.5 What are the constraint quantity values?Identify the sensitivity ranges for the constraint quantityAre there any unused resources? If so, which ones and what are the amount of unused resources? ANSWER REPORTObjective Cell (Max)Final ValueCell$B$4NameOriginal Value21Variable CellsCellNameOriginal ValueFinal ValueInteger$B$2$B$3х15Continx2ContinConstraintsCellNameCell ValueFormulaStatusSlack$D$8R1 usageSD$8<=$E$822Binding$D$9$D$9<=$E$9$D$10<=$E$10SD$11<=$E$11Not BindingBindingNot BindingR2 usage73$D$10$D$11R3 usage14R4 usage-4SENSITIVITY REPORTVariable CellsFinalReducedObjectiveAllowableAllowableCell$B$2SB$3NameValueCostCoefficientIncreaseDecreaseх11E+302х23243.5ConstraintsFinalShadowConstraintAllowableAllowableCell$D$8$D$9NameValuePriceR.H. SideIncreaseDecreaseR1 usage220.7224.28571428610R2 usage7101E+30$D$10R3 usage140.414105SD$11R4 usage-411E+305Note: 1E+30 = 00

What are the constraint quantity values? Referring the constraints table in the sensitivity report:…

Answered: Consider the Answer and Sensitivity…

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Related questions

Concept explainers

Question

100%

Consider the Answer and Sensitivity Reports at the end of the questionnaire to answer the following questions

Objective Function : Max Z = 3x₁+2x₂

Sensitivity Ranges :

C₁(3)
- Upper limit 3 +∞ = ∞
- Lower limit 3-2 = 1
C₂(2)
- Upper limit 4+2 = 6
- Lower limit 2-3.5 = -1.5

What are the constraint quantity values?
Identify the sensitivity ranges for the constraint quantity
Are there any unused resources? If so, which ones and what are the amount of unused resources?

ANSWER REPORT
Objective Cell (Max)
Final Value
Cell
$B$4
Name
Original Value
21
Variable Cells
Cell
Name
Original Value
Final Value
Integer
$B$2
$B$3
х1
5
Contin
x2
Contin
Constraints
Cell
Name
Cell Value
Formula
Status
Slack
$D$8
R1 usage
SD$8<=$E$8
22
Binding
$D$9
$D$9<=$E$9
$D$10<=$E$10
SD$11<=$E$11
Not Binding
Binding
Not Binding
R2 usage
7
3
$D$10
$D$11
R3 usage
14
R4 usage
-4
SENSITIVITY REPORT
Variable Cells
Final
Reduced
Objective
Allowable
Allowable
Cell
$B$2
SB$3
Name
Value
Cost
Coefficient
Increase
Decrease
х1
1E+30
2
х2
3
2
4
3.5
Constraints
Final
Shadow
Constraint
Allowable
Allowable
Cell
$D$8
$D$9
Name
Value
Price
R.H. Side
Increase
Decrease
R1 usage
22
0.7
22
4.285714286
10
R2 usage
7
10
1E+30
$D$10
R3 usage
14
0.4
14
10
5
SD$11
R4 usage
-4
1
1E+30
5
Note: 1E+30 = 00

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 3 steps

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, operations-management and related others by exploring similar questions and additional content below.

Similar questions