How much influence can the employee requirements for one, two, or three days have on the weekly
Question:
How much influence can the employee requirements for one, two, or three days have on the weekly schedule in the employee scheduling example? You are asked to explore this in the following questions.
a. Let Monday's requirements change from 17 to 25 in increments of 1. Use SolverTable to see how the total number of employees changes.
b. Suppose the Monday and Tuesday requirements can each, independently of one another, increase from 1‑to 8 in increments of 1. Use a two-way SolverTable to see how the total number of employees changes.
c. Suppose the Monday, Tuesday, and Wednesday requirements each increase by the same amount, where this increase can be from 1 to 8 in increments of 1. Use a one-way SolverTable to investigate how the total number of employees changes.
Step by Step Answer:
Business Analytics Data Analysis and Decision Making
ISBN: 978-1305947542
6th edition
Authors: S. Christian Albright, Wayne L. Winston