A Hospital Needs to Determine How Many Nurses to Hire

question 4

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 in cells I12 and B12 for this Excel spreadsheet implementation of the following formulation? ​

---

Definitions:

LMX

Leader-Member Exchange, a theory describing the dyadic relationship quality between leaders and followers in an organization.

LMX

Leader-Member Exchange; a theory proposing that leaders develop different kinds of relationships with various members of their team, which can affect the team's dynamics and performance.

Cultures

The cumulative deposit of knowledge, experience, beliefs, values, attitudes, meanings, hierarchies, religion, notions of time, roles, spatial relations, concepts of the universe, and material objects and possessions acquired by a group of people in the course of generations through individual and group striving.

Transactional Leadership

A leadership style focused on routine, structure, and rewards to manage followers, emphasizing clear transactions between the leader and the followers.