A Hospital Needs to Determine How Many Nurses to Hire

question 89

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 are the key formulas for this Excel spreadsheet implementation of the following formulation?

---

Definitions:

Status Quo

Status Quo refers to the existing state of affairs or conditions, particularly in a social, political, or organizational context, often resistant to change.

Kurt Lewin

A prominent psychologist known for his pioneering work in social, organizational, and applied psychology, including the development of force field analysis and change theory.

Force Field Analysis

A tool developed by Kurt Lewin, used to analyze the forces for and against a change, helping in the identification of factors that could be strengthened or reduced to support the achievement of a goal.

Force Field Model

A framework proposed by Kurt Lewin to analyze the factors (forces) that influence the change process, with forces aiding change termed as driving forces and those opposing as restraining forces.