e Using the Spreadsheet to do Sensitivity analysis D E F Doors Windows Unit Profit s500 s500 345678901 Hours ours Hours Used Per Unit Produced Used Available Plant 1 022 4 Plant 2 03 12 12 Plant 3 18 < 18 Doors Windows Total Profit 12 Units Produced 2 6 s4.000 The profit per door has been revised from S300 to $500. No change occurs in the optimal solution..(每扇门的收益从300美金 变成500美金,最优解并未因此发生变化) Copyright2007c深圳大学管理学院运筹学1l
Copyright 2007 © 深圳大学管理学院 运筹学 11 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. (每扇门的收益从300美金 变成500美金，最优解并未因此发生变化) 3 4 5 6 7 8 9 10 11 12 B C D E F G Doors Windows Unit Profit $500 $500 Hours Hours Used Available Plant 1 1 0 2 <= 4 Plant 2 0 2 12 <= 12 Plant 3 3 2 18 <= 18 Doors Windows Total Profit Units Produced 2 6 $4,000 Hours Used Per Unit Produced
e Using the Spreadsheet to do Sensitivity analysis B D E Doors Windows Unit Profit 1,000 s500 345678911 Hours Hours Used Per Unit Produced Available Plant 1 022 4 4 Plant 2 0 6 12 Plant 3 3 18 18 Doors Windows Total Profit 12 Units Produced 3 s5500 The profit per door has been revised from S300 to S1000. No change occurs in the optimal solution.(每扇门的收益从300美金 变成1000美金,最优解发生了变化) Copyright2007c深圳大学管理学院运筹学12
Copyright 2007 © 深圳大学管理学院 运筹学 12 Using the Spreadsheet to do Sensitivity Analysis The profit per door has been revised from $300 to $1000. No change occurs in the optimal solution. (每扇门的收益从300美金 变成1000美金，最优解发生了变化) 3 4 5 6 7 8 9 10 11 12 B C D E F G Doors Windows Unit Profit $1,000 $500 Hours Hours Used Available Plant 1 1 0 4 <= 4 Plant 2 0 2 6 <= 12 Plant 3 3 2 18 <= 18 Doors Windows Total Profit Units Produced 4 3 $5,500 Hours Used Per Unit Produced
e Using Solver Table to do sensitivity analysis D E「F Windows S300 s500 Hou Hours Hours Used Per Unit ProducedUsed Available Plant 1 10 Windows Total Profit 12 Units Produced 2 6 S3600 13 15 timal Units Produced Total these cells 17 for Doors Doors Windows Profit (B18:E28) 18 s3.600 choosing 20 the solver s600 25 $700 “5玩 s800 434444 27 s900 s1,000 D E 16 Optimal Units Produced Total Doors Windows Profit 33详图区:织的E 2“Mh: 18=Doors Produced=Windows Produced=TotalProfit 32 Copyright2007@深圳大学管理学院运筹学13
Copyright 2007 © 深圳大学管理学院 运筹学 13 Using Solver Table to do Sensitivity Analysis 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 B C D E F G Doors Windows Unit Profit $300 $500 Hours Hours Used Available Plant 1 1 0 2 <= 4 Plant 2 0 2 12 <= 12 Plant 3 3 2 18 <= 18 Doors Windows Total Profit Units Produced 2 6 $3,600 Unit Profit Total for Doors Doors Windows Profit 2 6 $3,600 $100 $200 $300 $400 $500 $600 $700 $800 $900 $1,000 Hours Used Per Unit Produced Optimal Units Produced Select these cells (B18:E28), before choosing the Solver Table. 16 17 18 C D E Total Doors Windows Profit =DoorsProduced =WindowsProduced =TotalProfit Optimal Units Produced
e Using Solver Table to do sensitivity analysis B C D E 16 Unit Profit Optimal Units ProducedTotal 17 for doors Doors Windows Profit 18 6 3,600 19 $100 6 $3,200 $200 6 3,400 042345278 300 6 3600 400 6 $3800 3500 6 4,000 s600 6 4,200 $700 6 4,400 800 22222222444 3 s4,700 27900 3 5,100 81000 3 5,500 Copyright2007@深圳大学管理学院运筹学14
Copyright 2007 © 深圳大学管理学院 运筹学 14 Using Solver Table to do Sensitivity Analysis 16 17 18 19 20 21 22 23 24 25 26 27 28 B C D E Unit Profit Total for Doors Doors Windows Profit 2 6 $3,600 $100 2 6 $3,200 $200 2 6 $3,400 $300 2 6 $3,600 $400 2 6 $3,800 $500 2 6 $4,000 $600 2 6 $4,200 $700 2 6 $4,400 $800 4 3 $4,700 $900 4 3 $5,100 $1,000 4 3 $5,500 Optimal Units Produced