MGMT101 Quiz 2.xlsx - Microsoft Excel 15.27 Answer Report Worksheet[MGMT101 Quiz 2]Sheet1 Report Created 2:09:46 PM Result Solver found a solution All

# MGMT101 Quiz 2.xlsx - Microsoft Excel 15.27 Answer Report...

• Homework Help
• 5

This preview shows page 1 - 5 out of 5 pages.

Microsoft Excel 15.27 Answer Report Worksheet: [MGMT101 Quiz 2.xlsx]Sheet1 Report Created: 10/14/18 2:09:46 PM Result: Solver found a solution. All constraints and optimality conditions are satisfied. Solver Engine Engine: Simplex LP Solution Time: 0.947506 Seconds. Iterations: 2 Subproblems: 0 Solver Options Max Time Unlimited, Iterations Unlimited, Precision 1E-06, Use Automatic Scaling Max Subproblems Unlimited, Max Integer Sols Unlimited, Integer Tolerance 1%, Assume Objective Cell (Max) Cell Name Original Value Final Value \$D\$11Objective Function 0 8000 Variable Cells Cell Name Original Value Final Value Integer \$B\$2 x 0 4.6666666667 Contin \$C\$2 y 0 3.3333333333 Contin Constraints Cell Name Cell Value Formula Status Slack \$D\$5 Plastic 27.3333333333 \$D\$5<=\$F\$5 Not Binding 8.6666666667 \$D\$6 Ink Assembly 40 \$D\$6<=\$F\$6 Binding 0 \$D\$7 Molding Time 30 \$D\$7<=\$F\$7 Binding 0
e NonNegative
Microsoft Excel 15.27 Answer Report Worksheet: [MGMT101 Quiz 2.xlsx]Sheet1 Report Created: 10/14/18 2:15:30 PM Result: Solver found a solution.