A Hospital Needs to Determine How Many Nurses to Hire

question 49

Essay

A hospital needs to determine how many nurses to hire to cover a 24 hour period.The nurses must work 8 consecutive hours but can start work at the start of 6 different shifts.They are paid different wages depending on
when they start their shifts.The number of nurses required per 4-hour time period and their wages are shown in the following table.
$\begin{array}{lll}\text { Time period }&\text { Required \# of Nurses }&\text { Wage } \$ / h r)\\\hline12 \mathrm{am}-4 \mathrm{am} & 20 & 15 \\4 \mathrm{am}-8 \mathrm{am} & 30 & 16 \\8 \mathrm{am}-12 \mathrm{pm} & 40 & 13 \\12 \mathrm{pm}-4 \mathrm{pm} & 50 & 13 \\4 \mathrm{pm}-8 \mathrm{pm} & 40 & 14 \\8 \mathrm{pm}-12 \mathrm{am} & 30 & 15\end{array}$
Enter the numbers in the appropriate cells of ranges B6:G11 and B13:G13 in the Excel spreadsheet to solve this problem based on the following formulation.
Let ^X_i ^{= number of nurses working in time period i;i = 1,6} MIN: ^1X₁ ^{+ 1X}₂ ^{+ 1X}₃ ^{+ 1X}₄ ^{+ 1X}₅ ^{+ 1X}₆
Subject to: ^1X₁ ^{+ 1X}₂ ^{? 30}
1X₂ + 1X₃ ? 40
1X₃ + 1X₄ ? 50
1X₄ + 1X₅ ? 40
1X₅ + 1X₆ ? 30
1X₁ + 1X₆ ? 20
X_i ? 0

---

Definitions:

Organisational Designs

The process of shaping an organization’s structure, roles, and networks to effectively manage and coordinate activities towards achieving its objectives.

Flexibility

The ability to adapt to changing circumstances, adjust to new instructions or conditions, and remain effective in a variety of situations.

Customers

Individuals or entities that purchase goods or services produced by a business.

Consumer Groups

Organizations or collectives that advocate for the rights and interests of consumers, often focusing on issues like product safety, quality, and fair pricing.