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:

Identify the benefits and potential problems of employee involvement in decision making.

Understand the significance and use of tacit knowledge in the decision-making process.

Identify factors that contribute to escalation of commitment and ways to minimize it.

Describe the stages of the creative process and its role in decision making.

---

Definitions:

Loss On Sale

A financial term representing the situation where the selling price of an asset is less than its purchase price.

Common Shares

Equity securities that represent ownership in a company, giving shareholders voting rights and a share in the company’s profits through dividends.

Par Value

The stated value of a stock or bond as designated by the issuer.

Privately Held Corporation

A corporation owned by private investors, its shares are not traded publicly on stock exchanges.