MGM 315 2-2-16 classwork - Decrease $B$4 Max pro 12.5 2.5...

Info icon This preview shows pages 1–7. Sign up to view the full content.

View Full Document Right Arrow Icon
Microsoft Excel 14.0 Sensitivity Report Worksheet: [Book1]Sheet1 Report Created: 2/2/2016 12:20:30 PM Variable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease $B$1 5 0 5 2 0.3333333333 $C$1 3 0 7 0.5 2 ^ range of optimatlity Constraints Final Shadow Constraint Allowable Allowable Cell Name Value Price R.H. Side Increase Decrease $D$5 Objective 5 0 6 1.00000E+030 1 $D$6 Objective 19 2 19 5 1 $D$7 Objective 8 1 8 0.3333333333 1.6666666667 ^ Shadow price When you increase the RHS it's how much the objective will increase
Image of page 1

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

View Full Document Right Arrow Icon
5 3 Max 5 7 Objective 46 s.T. 1 0 5 <= 6 < since 5 is less than 6 th 2 3 19 <= 19 < since 19 is 1 1 8 <= 8 < ^ In this example 19 When the LHS is equal that is called a binding
Image of page 2
hat means that there is a slack in this restraint equal to 19 this is called a binding constraint 9 and 8 are binding constrants to the RHS g constraint Binding constraints are limitations
Image of page 3

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

View Full Document Right Arrow Icon
Microsoft Excel 14.0 Sensitivity Report Worksheet: [MGM 315 - 2-2-16 classwork.xlsx]Sheet2 Report Created: 2/2/2016 1:09:45 PM Variable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase
Image of page 4
Image of page 5

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

View Full Document Right Arrow Icon
Image of page 6
Image of page 7
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Decrease $B$4 Max professional 15 10 12.5 2.5 $C$4 Max 17.5 15 5 8.3333333333 Constraints Final Shadow ConsTrainT Allowable Allowable Cell Name Value Price R.H. Side Increase Decrease $D$8 objecTve 100 3.125 100 60 46.666666667 $D$9 objecTve 80 1.25 80 70 30 X deluxe 10 Y professional 15 Max 15 17.5 10 15 objectve 412.5 S.T. Aluminum 2 4 100 <= 100 S±eel 3 2 80 <= 80 Microsof Excel 14.0 SensitviTy ReporT WorksheeT: [MGM 315 - 2-2-16 classwork.xlsx]SheeT3 ReporT CreaTed: 2/2/2016 1:17:56 PM Variable Cells Final Reduced Objectve Allowable Allowable Cell Name Value CosT Coe±cienT Increase Decrease $B$1 1.5 6 6 6 $C$1 2 9 1.000E+030 4.5 Constraints Final Shadow ConsTrainT Allowable Allowable Cell Name Value Price R.H. Side Increase Decrease $D$4 S.T. objec±ve 5.5 8 1.000E+030 2.5 $D$5 objec±ve 30 0.6 30 25 15 $D$6 objec±ve 2 4.5 2 2 2 1.5 2 Min 6 9 objectve 27 S.T. 1 2 5.5 <= 8 10 7.5 30 >= 30 1 2 >= 2...
View Full 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