数据、模型与决策6e(希利尔)英文版教学课件Hillier_Chapter05

Graphical Insight into the Allowable
Range W Production rate for windows
8 6 Line B
(2, 6) is optimal for 0 < PD < 750 PD = 0 (Profit = 0 D + 500 W)
4
Feasible region 2
Using the Sensitivity Report to Find the Allowable Range
Variabe
$C$12 Units Produced Doors
$D$12 Units Produced Windows
Final Value
2 6
Reduced Cost 0 0
The Parameter Analysis Report
5.8
Copyright © 2019 McGraw-Hill Education. All rights reserved. No reproduction or distribution without the prior written consent of McGraw-Hill Education.
Setting up a Parameter Analysis Report
Select D4 and choose Optimization under the Parameters menu.
5.6
Copyright © 2019 McGraw-Hill Education. All rights reserved. No reproduction or distribution without the prior written consent of McGraw-Hill Education.
Using the Spreadsheet to do Sensitivity Analysis
The profit per door has been revised from $300 to $450. The profit per window has been revised from $500 to $400. No change occurs in the optimal solution.
Using the Spreadsheet to do Sensitivity Analysis
The profit per door has been revised from $300 to $600. The profit per window has been revised from $500 to $300. The optimal solution changes.
Setting up a Parameter Analysis Report
Under the Reports menu on the Analytic Solver tab, choose Optimization>Parameter Analysis. Specify which parameters to vary and which results to show.
Line C
PD = 300 (Profit = 300 D + 500 W)
PD = 750 (Profit = 750 D + 500 W)
Line A
0
2
4
6
D
Production rate for doors
The two dashed lines that pass through the solid constraint boundary lines are the objective function lines when PD (the unit profit for doors) is at an endpoint 5.10 of its allowable range, 0 ≤ PD ≤ 750.
Using the Spreadsheet to do Sensitivity Analysis
The profit per door has been revised from $300 to $1,000. The optimal solution changes.
5.5
Copyright © 2019 McGraw-Hill Education. All rights reserved. No reproduction or distribution without the prior written consent of McGraw-Hill Education.
5.12
Copyright © 2019 McGraw-Hill Education. All rights reserved. No reproduction or distribution without the prior written consent of McGraw-Hill Education.
Setting up a Two-Way Parameter Analysis Report
Select C4 and choose Optimization under the Parameters menu. (Unit Profit per Door to be varied from $300 to $600)
5.7
Copyright © 2019 McGraw-Hill Education. All rights reserved. No reproduction or distribution without the prior written consent of McGraw-Hill Education.
Table of Contents Chapter 5 (What-If Analysis for Linear Programming)
Continuing the Wyndor Case Study (Section 5.2) Changes in One Objective Function Coefficient (Section 5.3) Simultaneous Changes in Objective Function Coefficients (Section 5.4) Single Changes in a Constraint (Section 5.5) Simultaneous Changes in the Constraints (Section 5.6) Robust Optimization (Section 5.7) Chance Constraints with Analytic Solver (Section 5.8)
Objective Coefficient
300 500
Allowable Increase
450 1E+30
Allowable Decrease
300 300
5.9
Copyright © 2019 McGraw-Hill Education. All rights reserved. No reproduction or distribution without the prior written consent of McGraw-Hill Education.
Wyndor (Before What-If Analysis)
5.2
Copyright © 2019 McGraw-Hill Education. All rights reserved. No reproduction or distribution without the prior written consent of McGraw-Hill Education.
Select D4 and choose Optimization under the Parameters menu. (Unit Profit per Window to be varied from $100 to $500)
5.13
Copyright © 2019 McGraw-Hill Education. All rights reserved. No reproduction or distribution without the prior written consent of McGraw-Hill Education.
Setting up a Two-Way Parameter Analysis Report
Copyright © 2019 McGraw-Hill Education. All rights reserved. No reproduction or distribution without the prior written consent of McGraw-Hill Education.
5.2 5.3–5.10 5.11–5.18 5.19–5.24 5.25–5.28 5.29–5.33 5.34–5.41
5.1
Copyright © 2019 McGraw-Hill Education. All rights reserved. No reproduction or distribution without the prior written consent of McGraw-Hill Education.
Using the Spreadsheet to do Sensitivity Analysis
The profit per door has been revised from $300 to $500. No change occurs in the optimal solution.
5.4
Copyright © 2019 McGraw-Hill Education. All rights reserved. No reproduction or distribution without the prior written consent of McGraw-Hill Education.
Using the Spreadsheet to do Sensitivity Analysis
The profit per door has been revised from $300 to $200. No change occurs in the optimal solution.
5.3
Copyright © 2019 McGraw-Hill Education. All rights reserved. No reproduction or distribution without the prior written consent of McGraw-Hill Education.
5.14
Two-Way Parameter Analysis Reports
Total Profit:
Doors Produced:
Windows Produced:
Copyright © 2019 McGraw-Hill Education. All rights reserved. No reproduction or distribution without the prior written consent of McGraw-Hill Education.
5.11
Copyright © 2019 McGraw-Hill Education. All rights reserved. No reproduction or distribution without the prior written consent of McGraw-Hill Education.
Copyright © 2019 McGraw-Hill Education. All rights reserved. No reproduction or distribution without the prior written consent of McGraw-Hill Education.