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深圳大学管理学院运筹学1lCopyright 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