3. SOLUTIONS ADM2302 Assignment2 S18 Excel P1 & P2.xls - Microsoft Excel 15.0 Answer Report Worksheet[ADM 2302 Assignment 2 Problem 2]Problem 2

3. SOLUTIONS ADM2302 Assignment2 S18 Excel P1 & P2.xls -...

This preview shows page 1 - 2 out of 8 pages.

Microsoft Excel 15.0 Answer Report Worksheet: [ADM 2302 Assignment 2 Problem 2.xls]Problem 2 Report Created: 13/10/2016 6:47:22 PM Result: Solver found a solution. All Constraints and optimality conditions are satisfied. Solver Engine Engine: Simplex LP Solution Time: 0.016 Seconds. Iterations: 14 Subproblems: 0 Solver Options Max Time 100 sec, Iterations 100, Precision 0.000001 Max Subproblems Unlimited, Max Integer Sols Unlimited, Integer Tolerance 5%, Solve Without Integer Con Objective Cell (Min) Cell Name Original Value Final Value $P$5 Cost Totals $0.00 $6,558,000.00 Variable Cells Cell Name Original Value Final Value Integer $C$3 Solution Regular 0 3000 Contin $D$3 Solution Overtime 0 500 Contin $E$3 Solution Regular 0 2000 Contin $F$3 Solution Overtime 0 400 Contin $G$3 Solution Regular 0 3000 Contin $H$3 Solution Overtime 0 500 Contin $I$3 Solution Regular 0 3200 Contin $J$3 Solution Overtime 0 0 Contin $K$3 Solution January 0 700 Contin $L$3 Solution February 0 100 Contin $M$3 Solution March 0 100 Contin $N$3 Solution April 0 300 Contin Constraints Cell Name Cell Value Formula Status Slack $O$8
Image of page 1
Image of page 2

You've reached the end of your free preview.

Want to read all 8 pages?

  • Fall '05
  • EL
  • Addition, Assignment 2, LHS, ADM 2302, Summer 2018

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture