Assignment Week 7 - Final.xlsx - Klein Industries Sales QUANTITY MINIMUM MAXIMUM 16157.14 14000 21000 6200.00 6200 12500 2600.00 2600 4200 PRODUCT Small

Assignment Week 7 - Final.xlsx - Klein Industries Sales...

This preview shows page 1 - 3 out of 4 pages.

Klein Industries Sales PRODUCT QUANTITY MINIMUM MAXIMUM Small 16157.14 14000 21000 Medium 6200.00 6200 12500 Large 2600.00 2600 4200 OBJECTIVE FUNCTION TOTAL PROFIT 651221.42857 BENDING 12882.86 <= 23400 WELDING 19014.29 <= 23400 PAINTING 46800.00 <= 46800 AUXILIARY 2600 CONSTRAINTS (Time Allocation)
Image of page 1
Microsoft Excel 16.0 Answer Report Worksheet: [Assignment Week 7-Robinson, C..xlsx]Sheet3 Report Created: 8/14/2019 9:54:26 PM Result: Solver found a solution. All Constraints and optimality conditions are satisfied. Solver Engine Engine: Simplex LP Solution Time: 0.125 Seconds. Iterations: 2 Subproblems: 0 Solver Options Max Time Unlimited, Iterations Unlimited, Precision 0.000001 Max Subproblems Unlimited, Max Integer Sols Unlimited, Integer Tolerance 1%, Assume NonNegative Objective Cell (Max) Cell Name Original Value Final Value $B$7 TOTAL PROFIT QUANTITY 1031900 651221.428571 Variable Cells Cell Name Original Value Final Value Integer $B$2 S QUANTITY 21000 16157.1428571 Contin $B$3 M QUANTITY 12500 6200 Contin $B$4 L QUANTITY 4200 2600 Contin Constraints Cell Name Cell Value Formula Status Slack $B$10 BENDING QUANTITY 12882.8571429 $B$10<=$D$10 Not Binding 10517.142857 $B$11 WELDING QUANTITY 19014.2857143 $B$11<=$D$11
Image of page 2
Image of page 3

You've reached the end of your free preview.

Want to read all 4 pages?

  • Fall '13
  • Gerald
  • Limit superior and limit inferior, Max Subproblems Unlimited

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture