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?

Question

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?  ​

Quizplus · Accepted Answer

The Answer of 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?  ​

A Hospital Needs to Determine How Many Nurses to Hire