A factory operates 7 days a week.Due to labor union regulations,employees are allowed to work a maximum of 5 consecutive days.The minimum number of employees that are needed on a given day is provided as follows:
$$\begin{array} { l c }
\text { Day } & \text { Number of Employees Needed } \
\hline \text { Sunday } & 20 \
\text { Monday } & 30 \
\text { Tuesday } & 35 \
\text { Wednesday } & 40 \
\text { Thursday } & 37 \
\text { Friday } & 30 \
\text { Saturday } & 25
\end{array}$$
Use Excel to formulate and solve this labor planning problem to determine the minimum number of employees needed each day.

Question

A factory operates 7 days a week.Due to labor union regulations,employees are allowed to work a maximum of 5 consecutive days.The minimum number of employees that are needed on a given day is provided as follows:
 $$\begin{array} { l c } 
\text { Day } & \text { Number of Employees Needed } \
\hline \text { Sunday } & 20 \
\text { Monday } & 30 \
\text { Tuesday } & 35 \
\text { Wednesday } & 40 \
\text { Thursday } & 37 \
\text { Friday } & 30 \
\text { Saturday } & 25
\end{array}$$ 
Use Excel to formulate and solve this labor planning problem to determine the minimum number of employees needed each day.

Quizplus · Accepted Answer

The Answer of A factory operates 7 days a week.Due to labor union regulations,employees are allowed to work a maximum of 5 consecutive days.The minimum number of employees that are needed on a given day is provided as follows:
 $$\begin{array} { l c } 
\text { Day } & \text { Number of Employees Needed } \
\hline \text { Sunday } & 20 \
\text { Monday } & 30 \
\text { Tuesday } & 35 \
\text { Wednesday } & 40 \
\text { Thursday } & 37 \
\text { Friday } & 30 \
\text { Saturday } & 25
\end{array}$$ 
Use Excel to formulate and solve this labor planning problem to determine the minimum number of employees needed each day.

A Factory Operates 7 Days a Week Use Excel to Formulate and Solve This Labor Planning Problem