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.

---

Definitions:

Interest Expense

The expenditure associated with acquiring funds on loan across a designated duration.

Interest Income

Earnings received from investments in various forms of debt, such as savings accounts, certificates of deposit, and bonds.

Periodic Method

A method of inventory accounting in which the cost of goods sold is determined at the end of an accounting period.