e Using the Spreadsheet to do Sensitivity analysis B C D EFG Doors Windows Unit Profit 200 s500 3456789012 Hours Hours Hours Used Per Unit Produced Used Available Plant 1 2 4 Plant 2 0 022 12 12 Plant 3 18 18 Doors Window Total Profit Units Produce 2 S3400 The profit per door has been revised from S300 to 200. No change occurs in the optimal solution.(每扇门的收益从30美金变 成200美金,最优解并未因此发生变化) Copyright2007c深圳大学管理学院运筹学10Copyright 2007 © 深圳大学管理学院 运筹学 10 Using the Spreadsheet to do Sensitivity Analysis 3 4 5 6 7 8 9 10 11 12 B C D E F G Doors Windows Unit Profit $200 $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,400 Hours Used Per Unit Produced The profit per door has been revised from $300 to $200. No change occurs in the optimal solution. (每扇门的收益从300美金变 成200美金，最优解并未因此发生变化)