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