The lab supervisor needs to establish a weekly schedule for the morning shift. Based on distributions of arrival times and service times, she has conducted a queuing analysis and found that the minimal number of lab technicians for each day is the following:

Each technician is allowed to take 2 days off per week. Technicians prefer to have 2 consecutive days off. There are, therefore, 7 possible schedules (Monday and Tuesday off, Tuesday and Wednesday off, Wednesday and Thursday off, etc.). Using Excel, formulate and solve an integer linear programming model that will determine the number of technicians for each one of the 7 schedules while minimizing weekly cost and providing the necessary capacity, and giving each lab technician 2 days off. Hint: Define the decision variables as the number of technicians in schedule 1, 2, 3

\begin{tabular}{l|l|c|cc|} \hline \multicolumn{1}{|c|}{ A } & \multicolumn{2}{c|}{ B } & \multicolumn{2}{c|}{C} \\ \cline { 2 - 5 } 1 & Day & Number of Technicians needed & Pay per technician/day \\ \hline 2 & Monday & 6 & $ & 180.00 \\ \hline 3 & Tuesday & 5 & $ & 180.00 \\ \hline 4 & Wednesday & 6 & $ & 180.00 \\ \hline 5 & Thursday & 4 & $ & 180.00 \\ \hline 6 & Friday & 5 & $ & 180.00 \\ \hline 7 & Saturday & 6 & $ & 260.00 \\ \hline 8 & Sunday & 5 & $ & 260.00 \end{tabular}