Unit 6.xlsx - Microsoft Excel 16.0 Answer Report...

This preview shows page 1 - 4 out of 29 pages.

Microsoft Excel 16.0 Answer Report Worksheet: [Unit 6.xlsx]Sheet1 Report Created: 2018-11-27 2:07:38 PM Result: Solver found a solution. All Constraints and optimality conditions are satisfied. Solver Engine Engine: Simplex LP Solution Time: 0.016 Seconds. Iterations: 10 Subproblems: 0 Solver Options Max Time Unlimited, Iterations Unlimited, Precision 0.000001, Use Automatic Scaling Max Subproblems Unlimited, Max Integer Sols Unlimited, Integer Tolerance 1%, Assume NonNegative Objective Cell (Min) Cell Name Original Value Final Value $F$214 Part Time 525 525 Variable Cells Cell Name Original Value Final Value Integer $C$202 9am - 10am Full Time 5 5 Contin $D$203 10am - 11am Product 2 0 0 Contin $E$204 11am - 12pm Cost 0 0 Contin $F$202 9am - 10am Part Time 0 0 Contin $G$203 10am - 11am Labour Constraint 0 0 Contin $H$204 11am - 12pm 0 0 Contin $I$205 12pm-1pm 0 0 Contin $J$206 1pm-2pm 0 0 Contin $K$207 2pm-3pm 0 0 Contin $L$208 3pm-4pm 0 0 Contin Constraints Cell Name Cell Value Formula Status Slack $M$185 9am - 10am 6 $M$185>=$B$185 Binding 0 $M$186 10am - 11am 6 $M$186>=$B$186 Not Binding 2 $M$187 11am - 12pm 12 $M$187>=$B$187 Not Binding 4 $M$188 12pm-1pm 15 $M$188>=$B$188 Not Binding 5 $M$189 1pm-2pm 9 $M$189>=$B$189 Binding 0 $M$190 2pm-3pm 10 $M$190>=$B$190 Not Binding 4 $M$191 3pm-4pm 4 $M$191>=$B$191 Binding 0 $M$192 4pm-5pm 7 $M$192>=$B$192 Binding 0 $M$193 5pm-6pm 7 $M$193>=$B$193 Not Binding 1 $M$194 6pm-7pm 6 $M$194>=$B$194 Binding 0 $N$202 9am - 10am x 5 $N$202>=$P$202 Not Binding 4 $N$203 10am - 11am x 5 $N$203>=$P$203 Not Binding 4 $N$204 11am - 12pm x 5 $N$204>=$P$204 Binding 0 $N$205 12pm-1pm x 5 $N$205>=$P$205 Binding 0
$N$206 1pm-2pm x 5 $N$206>=$P$206 Not Binding 4 $N$207 2pm-3pm x 5 $N$207>=$P$207 Not Binding 4 $N$208 3pm-4pm x 5 $N$208>=$P$208 Not Binding 4 $N$209 4pm-5pm x 5 $N$209>=$P$209 Not Binding 4 $N$210 5pm-6pm x 5 $N$210>=$P$210 Not Binding 4 $N$211 6pm-7pm x 5 $N$211>=$P$211 Not Binding 4
Microsoft Excel 16.0 Sensitivity Report Worksheet: [Unit 6.xlsx]Sheet1 Report Created: 2018-11-27 2:07:38 PM Variable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease $C$202 9am - 10am Full Time 5 0 105 0 105 $D$203 10am - 11am Product 2 0 0 105 1.000E+030 0 $E$204 11am - 12pm Cost 0 0 105 1.000E+030 0 $F$202 9am - 10am Part Time 0 32 32 1.000E+030 32 $G$203 10am - 11am Labour Constraint 0 32 32 1.000E+030 32 $H$204 11am - 12pm 0 32 32 1.000E+030 32 $I$205 12pm-1pm 0 32 32 1.000E+030 32 $J$206 1pm-2pm 0 32 32 1.000E+030 32 $K$207 2pm-3pm 0 32 32 1.000E+030 32 $L$208 3pm-4pm 0 32 32 1.000E+030 32 Constraints Final Shadow Constraint Allowable Allowable Cell Name Value Price R.H. Side Increase Decrease $M$185 9am - 10am 6 0 6 0 1.000E+030 $M$186 10am - 11am 6 0 4 2 1.000E+030 $M$187 11am - 12pm 12 0 8 4 1.000E+030 $M$188 12pm-1pm 15 0 10 5 1.000E+030 $M$189 1pm-2pm 9 0 9 0 1.000E+030 $M$190 2pm-3pm 10 0 6 4 1.000E+030 $M$191 3pm-4pm 4 0 4 0 1.000E+030 $M$192 4pm-5pm 7 0 7 0 1.000E+030 $M$193 5pm-6pm 7 0 6 1 1.000E+030 $M$194 6pm-7pm 6 0 6 0 1.000E+030 $N$202 9am - 10am x 5 0 1 4 1.000E+030 $N$203 10am - 11am x 5 0 1 4 1.000E+030 $N$204 11am - 12pm x 5 105 5 1.000E+030 0 $N$205 12pm-1pm x 5 0 5 0 1.000E+030 $N$206 1pm-2pm x 5 0 1 4 1.000E+030 $N$207 2pm-3pm x 5 0 1 4 1.000E+030 $N$208 3pm-4pm x 5 0 1 4 1.000E+030 $N$209 4pm-5pm x 5 0 1 4 1.000E+030 $N$210 5pm-6pm x 5 0 1

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture