MGM 315 3-1-16 Classwork - Microsoft Excel 14.0 Sensitivity...

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

Microsoft Excel 14.0 Sensitivity Report Worksheet: [MGM 315 3-1-16 Classwork.xlsx]DEA example Report Created: 3/1/2016 12:44:18 PM Variable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease $C$27 E 0.7647058824 0 1 1.00000E+030 1 $D$27 W1 0 0.2352941176 0 1.00000E+030 0.2352941176 $E$27 W2 0.5 0 0 0.4705882353 0.1176470588 $F$27 W3 0.5 0 0 0.1176470588 1.00000E+030 Constraints Final Shadow Constraint Allowable Allowable Cell Name Value Price R.H. Side Increase Decrease $G$29 OBJECTIVE 1 0.2352941176 1 0.0221238938 0.0550847458 $G$30 OBJECTIVE 865 0 800 65 1.00000E+030 $G$31 OBJECTIVE 450 0.0011764706 450 50 9.7402597403 $G$32 OBJECTIVE 310 0 140 170 1.00000E+030 $G$33 OBJECTIVE -4.2941176471 0 0 1.00000E+030 4.2941176471 $G$34 OBJECTIVE -0.0441176471 0 0 1.00000E+030 0.0441176471 $G$35 OBJECTIVE 1.136868E-013 -0.0011764706 0 5.859375 7.20576E+016
Image of page 1

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

Outputs Inputs SAT seniors finishing going to college teachers teaching seniors Budget ($100,000) Roosevelt 800 450 140 37 6.4 Lincon 830 500 250 25 5 Washington 900 400 370 23 4.7 E = fraction of roosevelt's nput resources required by the composite high school W1 = weight applied to Roosevelt's input/output W2 = weight applied to Lincon's input/output W3 = Weight applied to Washington's input/output Minimize E Minimize the fraction of Roosevelt high school's input resources required by the composite high school MINIMIZE E S.T. W1+W2+W3 = 1 RHS = Roosevelts performance 800W1+830W2+900W3>=800 Outputs SAT 450SW+500W2+400W3>=450 Seniors graduating 140W1+250W2+370W3>=140 Going to college 37W1+25W2+23W3<=37E Inputs teachers 6.4W1+5.0W2+4.7W3<=6.4E Budget 850W1+700W2+600W3<=850E # of senior students E,W1,W2,W3>=0 <<< don’t forget the nonnegative constraint First School E W1 W2 W3 Miminize 0.7647058824 0 0.5 0.5 1 0 0 0 S.T 1 1 1 800 830 900 450 500 400 140 250 370 -37 37 25 23 -6.4 6.4 5 4.7 -850 850 700 600 ^ Move the E to the LHS and make it a nagative Second School E W1 W2 W3 Miminize 1 0 1 0 1 0 0 0 S.T 1 1 1 800 830 900
Image of page 2
450 500 400 140 250 370 -25 37 25 23 -5 6.4 5 4.7 -700 850 700 600 Third School E W1 W2 W3 Miminize 1 0 0 1 1 0 0 0 S.T 1 1 1 800 830 900 450 500 400 140 250 370 -23 37 25 23 -4.7 6.4 5 4.7 -600 850 700 600 ^^^ For each school you have to change this column
Image of page 3

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

Image of page 4
This is the end of the preview. Sign up to access the rest of the document.
  • Spring '16
  • Dr. Chao
  • Harshad number, Hebrew numerals, fare class

{[ 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