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

question 41

Essay

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.