MGM 315 3-17-16 Classwork - Microsoft Excel 15.0...

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

View Full Document Right Arrow Icon
Microsoft Excel 15.0 Sensitivity Report Worksheet: [MGM 315 3-17-16 Classwork.xlsx]Shortest Route Report Created: 3/17/2016 12:47:01 PM Variable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease $B$12 0 979 999 1.00E+030 979 $C$12 0 8 15 1.00E+030 8 $D$12 1 0 10 8 1.00E+030 $E$12 0 989 999 1.00E+030 989 $F$12 0 985 999 1.00E+030 985 $G$12 0 983 999 1.00E+030 983 $H$12 0 989 999 1.00E+030 989 $B$13 0 2 15 1.00E+030 2 $C$13 0 999 999 1.00E+030 999 $D$13 0 0 3 2 6 $E$13 0 3 6 1.00E+030 3 $F$13 0 992 999 1.00E+030 992 $G$13 0 990 999 1.00E+030 990 $H$13 0 14 17 1.00E+030 14 $B$14 0 0 10 2 8 $C$14 0 6 3 1.00E+030 6 $D$14 0 999 999 1.00E+030 999 $E$14 0 999 999 1.00E+030 999 $F$14 1 0 4 3 8 $G$14 0 993 999 1.00E+030 993 $H$14 0 999 999 1.00E+030 999 $B$15 0 989 999 1.00E+030 989 $C$15 0 9 6 1.00E+030 9 $D$15 0 999 999 1.00E+030 999 $E$15 0 999 999 1.00E+030 999 $F$15 0 0 4 5 3 $G$15 0 993 999 1.00E+030 993 $H$15 0 5 5 1.00E+030 5 $B$16 0 993 999 1.00E+030 993 $C$16 0 1006 999 1.00E+030 1006 $D$16 0 8 4 1.00E+030 8 $E$16 0 8 4 1.00E+030 8 $F$16 0 999 999 1.00E+030 999 $G$16 1 0 2 4 20 $H$16 0 4 0 1.00E+030 4 $B$17 0 999 999 1.00E+030 999 $C$17 0 1012 999 1.00E+030 1012 $D$17 0 1009 999 1.00E+030 1009 $E$17 0 15 5 1.00E+030 15 $F$17 0 8 2 1.00E+030 8 $G$17 0 1003 999 1.00E+030 1003 $H$17 0 16 6 1.00E+030 16 $B$18 0 989 999 1.00E+030 989 $C$18 0 20 17 1.00E+030 20 $D$18 0 999 999 1.00E+030 999 $E$18 0 999 999 1.00E+030 999 $F$18 0 995 999 1.00E+030 995 $G$18 0 0 6 20 4 $H$18 0 999 999 1.00E+030 999
Image of page 1

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

View Full Document Right Arrow Icon
Constraints Final Shadow Constraint Allowable Allowable Cell
Image of page 2
Image of page 3
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