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.

How much influence can the employee requirements for one, two, or three

\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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!