Below tables show the Answer Report and the Sensitivity Report of the optimization Based on these two tables, answer the following questions. Write the objective What is the z value (objective function’s value) Identify the sensitivity ranges for the objective
Below tables show the Answer Report and the Sensitivity Report of the optimization Based on these two tables, answer the following questions. Write the objective What is the z value (objective function’s value) Identify the sensitivity ranges for the objective
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...
Related questions
Question
Below tables show the Answer Report and the Sensitivity Report of the optimization Based on these two tables, answer the following questions.
- Write the objective
- What is the z value (objective function’s value)
- Identify the sensitivity ranges for the objective
Transcribed Image Text:Variable Cells
Reduced
Objective Allowable
Coefficient Increase
Final
Allowable
Cell Name
Value
Cost
Decrease
$CS11 x1
SCS12 x2
$C$13 x3
SC$14 x4
12 0.628571429 6.444444444
8 8.546583851 0.75862069
10 6.691561939
6 6.444444444 0.628571429
2.560143627
3.364452424
0 -6.691561939
1E+30
15.43985637
Constraints
Final
Shadow
Constraint Allowable Allowable
Cell Name
Value
Price
R.H. Side
Increase
Decrease
SH$6 Used
SH$7 Used 21.40125673
SH$8 Used
74 0.078994614
74 20.37142857 26.08108108
1E+30 2.598743268
24
36
36 7.170278638 25.67164179
$H$9 Used
480 0.208258528
480 79.31506849 79.22222222
Transcribed Image Text:Objective Cell (Max)
Cell Name Original Value Final Value
SCS15 Profit
150.3
150.3
Variable Cells
Cell Name Original Value Final Value
SCS11 x1
SCS12 x2
SCS13 x3
SCS14 x4
Integer
2.6 Contin
2.6
3.4
3.4 Contin
0.0 Contin
15.4 Contin
0.0
15.4
Constraints
Cell Name
Cell Value
Formula
Status
Slack
SH$6 Used
SH$7 Used
SH$8 Used
SH$9 Used
74 SHS6<=SG$6 Binding
21.4 SHS7<=SGS7 Not Binding 2.598743268
36 SH$8<=$G$8 Binding
480 SH$9<=$G$9 Binding
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 2 steps
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.Recommended textbooks for you
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education
Purchasing and Supply Chain Management
Operations Management
ISBN:
9781285869681
Author:
Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
Publisher:
Cengage Learning
Production and Operations Analysis, Seventh Editi…
Operations Management
ISBN:
9781478623069
Author:
Steven Nahmias, Tava Lennon Olsen
Publisher:
Waveland Press, Inc.