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