A Hospital Needs to Determine How Many Nurses to Hire

question 52

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. What values would you enter in the Analytic Solver Platform (ASP) task pane for the following cells for this Excel spreadsheet implementation of the formulation for this problem?
Objective Cell:
Variables Cells:
Constraints Cells: ​

---

Definitions:

Chronic Disease

A long-lasting condition that can be controlled but not cured.

Procedural Knowledge

What a person knows but cannot really talk about; sometimes called knowing how.

Cognitive Psychology

The branch of psychology that studies mental processes including how people think, perceive, remember, and learn.

Explicitly Told

Information or instructions communicated in a direct, clear, and unambiguous manner.