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:
Reversing Entries
Journal entries made at the beginning of an accounting period to reverse or cancel out adjusting entries made at the end of the previous accounting period.
Debit Balance
Refers to the balance that remains in a financial account when the total debits exceed the total credits.
Credit Balance
An accounting balance where the sum of credits exceeds the sum of debits in an account, often indicating money owed to the account holder.
Salaries Payable
A liability account that represents the amount owed to employees for work performed but not yet paid.
Q13: A hospital needs to determine how many
Q23: Which of the constraints are binding at
Q43: Consider the following linear programming model and
Q46: Pure IP formulation requires that:<br>A) all decision
Q55: In MOLP, a decision alternative is dominated
Q62: The following ILP is being solved by
Q64: Marginal costs exist because:<br>A) the decision to
Q159: Refer to the above table. A total
Q176: The production possibilities curve represents which of
Q231: Refer to the diagram below. This production