MGM 315 2-16-16 Classwork - Microsoft Excel 14.0...

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

View Full Document Right Arrow Icon
Microsoft Excel 14.0 Sensitivity Report Worksheet: [MGM 315 - 2-16-16 Classwork.xlsx]Sheet1 Report Created: 2/16/2016 12:59:33 PM Variable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease $E$28 DFR 7 0 3000 0 0 $F$28 DSA 5 0 3000 0 0 $G$28 DSU 3 0 3000 0 0 $H$28 EFR 1 0 4000 200 0 $I$28 ESA 0 0 4000 0 1.00000E+030 $J$28 ESU 0 0 4000 0 1.00000E+030 $K$28 GSU 2 0 75000 1.00000E+030 15000 Constraints Final Shadow Constraint Allowable Allowable Cell Name Value Price R.H. Side Increase Decrease $L$30 S.T. objective 15 0 1 14 1.00000E+030 $L$31 objective 1 -200 1 5 1 $L$32 objective 2 0 1 1 1.00000E+030 $L$33 objective 7 0 10 1.00000E+030 3 $L$34 objective 5 0 10 1.00000E+030 5 $L$35 objective 3 0 10 1.00000E+030 7 $L$36 objective 1 0 6 1.00000E+030 5 $L$37 objective 0 0 6 1.00000E+030 6 $L$38 objective 0 0 6 1.00000E+030 6 $L$39 objective 2 15000 2 0.1578947368 0.0842105263 $L$40 objective 8 0 5 3 1.00000E+030 $L$41 objective 5 0 5 3 1.6 $L$42 objective 5 0 5 3 1.6 $L$43 objective 42000 0 50000 1.00000E+030 8000 $L$44 objective 25000 0 75000 1.00000E+030 50000 $L$45 objective 282000 0.6 282000 8000 15000
Image of page 1

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

View Full Document Right Arrow Icon
Page 209 Problem 5 Individual project due 1 week after midterm Due March 3 Work on problem to study for the exam Exam next Thursday Official Managerial Report Homework Ch 4 1 3 6 11
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