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