Microsoft Excel 16.0 Sensitivity Report Worksheet: [Book1]Sheet7 Report Created: 9/26/2020 10:43:05 AM Engine: Standard LP/Quadratic Objective Cell (Min) Cell Name Final Value $B$13 Obj Func AN 4135000 Decision Variable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease $B$11 variables AN 55000 0 33 7.0000001 41.0000001 $C$11 variables AO 0 7 48 1E+30 7 $D$11 variables BN 25000 0 27 8.0000001 7.0000001 $E$11 variables BO 47000 0 35 7.0000001 8.0000001 Constraints Final Shadow Constraint Allowable Allowable Cell Name Value Price R.H. Side Increase Decrease $B$16 LHS 55000 41 55000 10500 47000 $B$17 LHS 72000 35 72000 10500 47000 $B$18 LHS 80000 -8 80000 47000 10500 $B$19 LHS 47000 0 57500 1E+30 10500 The answers to the questions are found in this sensitivity report. Questions: Write your responses in the space provided 1. What is the range of optimality for the BN and BO variables? write your answers in this format: Lower limit <= Coefficient of BN <= Upper limit. Example 22 <= C of BN <= 40 2. What is the range of feasibility for the constraints located on B17 and B18? 3. If the right-hand side of the constraint located on B17 is decreased by 200, what is the effect on the value of the objective function?

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

Question

Microsoft Excel 16.0 Sensitivity Report
Worksheet: [Book1]Sheet7
Report Created: 9/26/2020 10:43:05 AM
Engine: Standard LP/Quadratic

Objective Cell (Min)
	Cell	Name	Final Value
	$B$13	Obj Func AN	4135000

Decision Variable Cells
			Final	Reduced	Objective	Allowable	Allowable
	Cell	Name	Value	Cost	Coefficient	Increase	Decrease
	$B$11	variables AN	55000	0	33	7.0000001	41.0000001
	$C$11	variables AO	0	7	48	1E+30	7
	$D$11	variables BN	25000	0	27	8.0000001	7.0000001
	$E$11	variables BO	47000	0	35	7.0000001	8.0000001

Constraints
			Final	Shadow	Constraint	Allowable	Allowable
	Cell	Name	Value	Price	R.H. Side	Increase	Decrease
	$B$16	LHS	55000	41	55000	10500	47000
	$B$17	LHS	72000	35	72000	10500	47000
	$B$18	LHS	80000	-8	80000	47000	10500
	$B$19	LHS	47000	0	57500	1E+30	10500

The answers to the questions are found in this sensitivity report.

Questions: Write your responses in the space provided

1. What is the range of optimality for the BN and BO variables?

write your answers in this format: Lower limit <= Coefficient of BN <= Upper limit. Example 22 <= C of BN <= 40

2. What is the range of feasibility for the constraints located on B17 and B18?

3. If the right-hand side of the constraint located on B17 is decreased by 200, what is the effect on the value of the objective function?

AI-Generated Solution

AI-generated content may present inaccurate or offensive content that does not represent bartleby’s views.

Unlock instant AI solutions

Tap the button
to generate a solution

Click the button to generate
a solution

SEE SOLUTION

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