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

Info icon 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
Image of page 1

Info icon 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
Image of page 2
Q1 x1 x2 Relation Objective 40 35 1000 Constraint-1 2 3 60 <= 60 Constraint-2 4 3 96 <= 96 Values 18 8
Image of page 3

Info icon 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
Image of page 4
Image of page 5
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

What students are saying

  • Left Quote Icon

    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.

    Student Picture

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

  • Left Quote Icon

    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.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    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.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern