Question: How much influence can the employee requirements for one, two, or three days have on the weekly schedule in the employee scheduling example? Explore this
How much influence can the employee requirements for one, two, or three days have on the weekly schedule in the employee scheduling example? Explore this in the following questions:
a. Let Monday's Requirements change from 17 to 25 in increments of 1. Use SolverTble to see how the total number of employees changes.

\begin{tabular}{|c|c|c|c|c|c|c|c|c|c|c|c|} \hline & A & B & C & D & E & F & G & H & 1 & J & K \\ \hline 1 & \multicolumn{2}{|c|}{ Employee scheduling model } & & & & & & & Range names used & & \\ \hline 2 & & & & & & & & & Employees_available & \multicolumn{2}{|c|}{= Model!\$B\$23:\$H\$23 } \\ \hline 3 & \multicolumn{6}{|c|}{ Decision variables: number of employees starting their five-day shift on various days } & & & Employees_required & \multicolumn{2}{|c|}{= Model!\$B\$25:\$H\$25 } \\ \hline 4 & Mon & 2.000 & & & & & & & Employees_Starting & \multicolumn{2}{|c|}{= Model! $ B $4:$B$10} \\ \hline 5 & Tue & 3.000 & & & & & & & Total_employees & \multicolumn{2}{|c|}{= Model!\$B\$28 } \\ \hline 6 & Wed & 3.000 & & & & & & & & & \\ \hline 7 & Thu & 7.000 & & & & & & & & & \\ \hline 8 & Fri & 0.000 & & & & & & & & & \\ \hline 9 & Sat & 4.000 & & & & & & & & & \\ \hline 10 & Sun & 4.000 & & & & & & & & & \\ \hline \multicolumn{12}{|l|}{11} \\ \hline 12 & \multicolumn{9}{|c|}{ Result of decisions: number of employees working on various days (along top) who started their shift on various days (along side) } & & \\ \hline 13 & & Mon & Tue & Wed & Thu & Fri & Sat & Sun & & & \\ \hline 14 & Mon & 2 & 2 & 2 & 2 & 2 & & & & & \\ \hline 15 & Tue & & 3 & 3 & 3 & 3 & 3 & & & & \\ \hline 16 & Wed & & & 3 & 3 & 3 & 3 & 3 & & & \\ \hline 17 & Thu & 7 & & & 7 & 7 & 7 & 7 & & & \\ \hline 18 & Fri & 0 & 0 & & & 0 & 0 & 0 & & & \\ \hline 19 & Sat & 4 & 4 & 4 & & & 4 & 4 & & & \\ \hline 20 & Sun & 4 & 4 & 4 & 4 & & & 4 & & & \\ \hline 21 & & & & & & & & & & & \\ \hline 22 & \multicolumn{2}{|c|}{ Constraint on employee availabilities } & & & & & & & & & \\ \hline 23 & Employees available & 17 & 13 & 16 & 19 & 15 & 17 & 18 & & & \\ \hline 24 & & >= & >= & >= & >= & >= & >= & >= & & & \\ \hline 25 & Employees required & 17 & 13 & 15 & 19 & 14 & 16 & 11 & & & \\ \hline 26 & & & & & & & & & & & \\ \hline 27 & Objective to maximize & & & & & & & & & & \\ \hline 28 & Total employees & 23.00 & & & & & & & & & \\ \hline 29 & & & & & & & & & & & \\ \hline \end{tabular}
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
