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:

African American

Individuals in the United States with ancestry from the black racial groups of Africa, often reflecting a shared historical, cultural, and social experience.

Painter

An artist who creates art pieces using mediums such as oils, acrylics, watercolors, or pastels on surfaces like canvas, wood, or paper.

National Fame

National fame refers to the state of being widely recognized, admired, or honored by a significant portion of a country's population for one's achievements or contributions.

Militant Lectures

Talks or presentations delivered with a vigorous, sometimes confrontational style, often associated with activism or radical movements.