A Hospital Needs to Determine How Many Nurses to Hire

question 61

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}{cc}\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}$

What values would you enter in the Risk Solver Platform RSP)task pane for the following cells for this Excel spreadsheet implementation of the formulation for this problem?
Objective Cell: Variables Cells: Constraints Cells:

---

Definitions:

Opt-In

A policy where individuals explicitly agree to receive marketing materials or other information by signing up or selecting a specific option.

Customer Authorizes

The process whereby a customer gives permission or consent for a business to proceed with a specific action, often related to payments or data processing.

Aadhaar's Information

Pertains to personal and biometric data linked to Aadhaar, a 12-digit unique identity number issued to Indian residents based on their biometric and demographic data.

Social Mobility

The movement of individuals, families, or groups through a system of social hierarchy or stratification.