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

• 29
• 100% (3) 3 out of 3 people found this document helpful

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