21.03.16 (1)

# 21.03.16 (1) - Microsoft Excel 15.0 Answer Report...

• Lab Report
• 15

This preview shows pages 1–5. Sign up to view the full content.

Microsoft Excel 15.0 Answer Report Worksheet: [21.03.16.xlsx]Sheet1 Report Created: 21-03-2016 18:17:55 Result: Solver found a solution. All Constraints and optimality conditions are satisfied. Solver Engine Engine: Simplex LP Solution Time: 0.047 Seconds. Iterations: 2 Subproblems: 0 Solver Options Max Time Unlimited, Iterations Unlimited, Precision 0.000001, Use Automatic Scaling Max Subproblems Unlimited, Max Integer Sols Unlimited, Integer Tolerance 1%, Assume NonNegative Objective Cell (Max) Cell Name Original Value Final Value \$G\$7 Objective 0 1000 Variable Cells Cell Name Original Value Final Value Integer \$E\$11 Values x1 0 18 Contin \$F\$11 Values x2 0 8 Contin Constraints Cell Name Cell Value Formula Status Slack \$G\$8 Constraint-1 60 \$G\$8<=\$I\$8 Binding 0 \$G\$9 Constraint-2 96 \$G\$9<=\$I\$9 Binding 0 \$E\$11 Values x1 18 \$E\$11>=0 Not Binding 18 \$F\$11 Values x2 8 \$F\$11>=0 Not Binding 8

This preview has intentionally blurred sections. Sign up to view the full version.

Microsoft Excel 15.0 Sensitivity Report Worksheet: [21.03.16.xlsx]Sheet1 Report Created: 21-03-2016 18:17:55 Variable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease \$E\$11 Values x1 18 0 40 6.6666666667 16.666666667 \$F\$11 Values x2 8 0 35 25 5 Constraints Final Shadow Constraint Allowable Allowable Cell Name Value Price R.H. Side Increase Decrease \$G\$8 Constraint-1 60 3.3333333333 60 36 12 \$G\$9 Constraint-2 96 8.3333333333 96 24 36
Q1 x1 x2 Relation Objective 40 35 1000 Constraint-1 2 3 60 <= 60 Constraint-2 4 3 96 <= 96 Values 18 8

This preview has intentionally blurred sections. Sign up to view the full version.

Microsoft Excel 15.0 Answer Report Worksheet: [21.03.16.xlsx]Sheet2 Report Created: 21-03-2016 18:40:26 Result: Solver found a solution. All Constraints and optimality conditions are satisfied. Solver Engine Engine: Simplex LP Solution Time: 0 Seconds. Iterations: 1 Subproblems: 0 Solver Options Max Time Unlimited, Iterations Unlimited, Precision 0.000001, Use Automatic Scaling Max Subproblems Unlimited, Max Integer Sols Unlimited, Integer Tolerance 1%, Assume NonNegative Objective Cell (Max) Cell Name Original Value Final Value \$E\$3 Objective 0 14 Variable Cells Cell Name Original Value Final Value Integer \$C\$10 Values x1 0 0 Contin \$D\$10 Values x2 0 7 Contin
This is the end of the preview. Sign up to access the rest of the document.
• Spring '14

{[ snackBarMessage ]}

### What students are saying

• As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

Kiran Temple University Fox School of Business ‘17, Course Hero Intern

• I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

Dana University of Pennsylvania ‘17, Course Hero Intern

• The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

Jill Tulane University ‘16, Course Hero Intern