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. 
Enter the numbers in the appropriate cells of ranges B6:G11 and B13:G13 in the Excel spreadsheet to solve this problem based on the following formulation.
Definitions:
Hypersexuality
An excessive preoccupation with sexual fantasies, urges, or behaviors that is distressing or interferes with normal functioning.
Hypoactive Sexual Desire
A reduction in sexual desire or interest, which can significantly impact one’s quality of life and interpersonal relationships.
Patriarchal Societies
Societies that are structured with males as the primary authority figures, central to social organization, and where fathers hold authority over women, children, and property.
Procreation
The biological process of reproducing offspring; the act of bringing new life into existence.
Q9: A company needs to ship 100 units
Q13: A financial planner wants to design a
Q18: Explain the concept of adverse selection. Give
Q32: Based on the following regression output,
Q36: Buying insurance is similar to<br>A) selling risk.<br>B)
Q44: Refer to Exhibit 10.4. What formulas should
Q58: Refer to Exhibit 3.2. What formula should
Q66: R<sup>2</sup> is calculated as<br>A)ESS/TSS<br>B)1 - (RSS/TSS)<br>C)RSS/ESS<br>D)RSS/TSS
Q136: Pirates have been intensely attacking ships off
Q324: If one person has all the income