3. ADM 2302 Solutions Assignment 1 S17 Excel.xlsx - Microsoft Excel 16.0 Sensitivity Report Worksheet[Book1]Problem 3 validation Report Created 10:33:08

3. ADM 2302 Solutions Assignment 1 S17 Excel.xlsx -...

This preview shows page 1 out of 7 pages.

You've reached the end of your free preview.

Want to read all 7 pages?

Unformatted text preview: Microsoft Excel 16.0 Sensitivity Report Worksheet: [Book1]Problem 3 - validation Report Created: 1/22/2017 10:33:08 AM Variable Cells Final Reduced Objective Cell Name Value Cost Coefficient $B$3 solution x1 10 0 3000 $C$3 solution x2 30 0 1000 Allowable Increase 0 2000 Allowable Decrease 2000 0 Constraints Cell Name $D$8 #1 lhs $D$9 #2 lhs $D$10 #3 lhs Final Shadow Constraint Allowable Allowable Value Price R.H. Side Increase Decrease 1200 50 1200 933.33333333 400 400 0 400 200 127.27272727 5200 0 2400 2800 1.00000E+030 solution min constraints #1 #2 #3 x1 10 3000 60 10 40 x2 30 1000 min 60000 20 10 160 lhs 1200 400 5200 sign >= >= >= rhs 1200 400 2400 multiple solutions Microsoft Excel 14.0 Answer Report Worksheet: [Assignment 1 Solution 3rd problem.xlsx]Cambie Surgery Centre Report Created: 9/13/2015 10:49:21 AM Result: Solver found a solution. All Constraints and optimality conditions are satisfied. Solver Engine Engine: Simplex LP Solution Time: 0.016 Seconds. Iterations: 2 Subproblems: 0 Solver Options Max Time 100 sec, Iterations 100, Precision 0.000001 Max Subproblems 5000, Max Integer Sols 5000, Integer Tolerance 0.05%, Assume NonNegative Objective Cell (Max) Cell Name $D$7 Profit Profit Total Original Value $8,986,657.61 Final Value $8,986,657.61 Variable Cells Cell Name $B$5 Solution (# patients) M $C$5 Solution (# patients) S Original Value 2794.57 1468.48 Final Value Integer 2794.57 Contin 1468.48 Contin Constraints Cell Name $D$10 Patient-days LHS $D$11 Lab tests LHS $D$12 x-rays LHS $D$13 Oper/Surgeries LHS Cell Value Formula 31025.00 $D$10<=$F$10 13040.11 $D$11<=$F$11 7200.00 $D$12<=$F$12 1468.48 $D$13<=$F$13 Status Slack Binding 0 Not Binding 459.89130435 Binding 0 Not Binding 1281.5217391 Microsoft Excel 14.0 Sensitivity Report Worksheet: [Assignment 1 Solution 3rd problem.xlsx]Cambie Surgery Centre Report Created: 9/13/2015 10:49:22 AM Variable Cells Cell Name $B$5 Solution (# patients) M $C$5 Solution (# patients) S Final Value 2794.5652174 1468.4782609 Reduced Cost Objective Coefficient 0 2375 0 1600 Allowable Allowable Increase Decrease 1225 1841.6666667 5525 544.44444444 Constraints Cell $D$10 $D$11 $D$12 $D$13 Name Patient-days LHS Lab tests LHS x-rays LHS Oper/Surgeries LHS Final Shadow Constraint Allowable Allowable Value Price R.H. Side Increase Decrease 31025 240.2173913 31025 1448.9726027 21425 13040.108696 0 13500 1.0000E+030 459.89130435 7200 213.04347826 7200 1037.0098039 3752.7777778 1468.4782609 0 2750 1.0000E+030 1281.5217391 Cambie Surgery Centre Solution (# patients) Medical M Surgical S 2794.57 1468.48 Profit Total Profit Constraints: Patient-days Lab tests x-rays Oper/Surgeries # Medical beds used in a year # Surgical beds used in a year Med beds Surg beds $ 2,375 $ 9 3.3 1 1,600 4 2.6 3 1 $8,986,658 LHS 31025.00 13040.11 7200.00 1468.48 Sign £ £ £ £ RHS 31025 13500 7200 2750 25151.09 5873.91 68.907087552 16.092912448 Prob 4 Cambie Surgery Centre Page 7 ...
View Full Document

  • Fall '05
  • EL
  • LHS, Cambie Surgery Centre

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture