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@深圳大学管理学院运筹学13Copyright 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