e between the small and large compressor limited by the amount wer bound

# E between the small and large compressor limited by

This preview shows page 3 - 8 out of 9 pages.

Scenario Summary Current Values: Max profit part b Max Profit Part A Changing Cells: \$B\$6 16,157 117,000 16,157 \$C\$6 6,200 234,000 6,200 \$D\$6 2,600 - 234,000 2,600 Result Cells: \$F\$14 12,882.9 23,400.0 12,882.9 \$F\$15 19,014.3 23,400.0 19,014.3 \$F\$16 46,800.0 46,800.0 46,800.0 \$F\$9 \$ 651,221.43 \$ 526,500.00 \$ 651,221.43 Notes: Current Values column represents values of changing cells at time Scenario Summary Report was created. Changing cells for each scenario are highlighted in gray.
Microsoft Excel 15.16 Answer Report Worksheet: [BUSN625_WK7_C.Estrada.xlsx]Klein Industries Model Report Created: 10/23/2016 5:33:32 PM Result: Solver found a solution. All constraints and optimality conditions are satisfied. Solver Engine Solver Options Objective Cell (Max) Cell Name Original Value Final Value \$F\$9 Profit per unit Max Profit \$ 651,221.43 \$ 651,221.43 Variable Cells Cell Name Original Value Final Value Integer \$B\$6:\$D\$6 Constraints Cell Name Cell Value Formula Status \$B\$7:\$D\$7 <= \$B\$5:\$D\$5 \$B\$7:\$D\$7 >= \$B\$4:\$D\$4 \$F\$14 Bending/Forming Used Time (Mins) 12,882.9 \$F\$14<=23400 Not Binding \$F\$15 Welding Used Time (Mins) 19,014.3 \$F\$15<=23400 Not Binding \$F\$16 Painting Used Time (Mins) 46,800.0 \$F\$16<=46800 Binding \$B\$6 Order Producted SM 16,157 \$B\$6<=21000 Not Binding \$B\$6 Order Producted SM 16,157 \$B\$6>=14000 Not Binding \$C\$6 Order Producted MD 6,200 \$C\$6<=12500 Not Binding \$C\$6 Order Producted MD 6,200 \$C\$6>=6200 Binding \$D\$6 Order Producted LG 2,600 \$D\$6<=4200 Not Binding \$D\$6 Order Producted LG 2,600 \$D\$6>=2600 Binding
Slack 10517.142857 4385.7142857 0 4842.8571429 2,157 6300 - 1600 -
Microsoft Excel 15.16 Sensitivity Report

#### You've reached the end of your free preview.

Want to read all 9 pages?