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.

Image of page 3
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.
Image of page 4
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
Image of page 5
Slack 10517.142857 4385.7142857 0 4842.8571429 2,157 6300 - 1600 -
Image of page 6
Microsoft Excel 15.16 Sensitivity Report
Image of page 7
Image of page 8

You've reached the end of your free preview.

Want to read all 9 pages?

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture