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:
Sources Of Financing
Various means through which a business or individual can obtain funds, including loans, equity, grants, and savings.
Comparative Financial Statement
Financial reports that provide a side-by-side comparison of a company's financial position and performance over different periods.
Base Period
A specific time period against which economic or financial data is compared or analyzed.
Analysis Period
The specific span of time over which financial performance is evaluated or investment decisions are analyzed.
Q1: A factor that plays a role in
Q6: Mortgage insurance protects lenders when a borrower
Q12: The following network depicts an assignment/transportation problem
Q16: How much must the objective function coefficient
Q24: A constraint which represents a target value
Q44: The <span class="ql-formula" data-value="\beta"><span class="katex"><span
Q48: The Reduced Gradient is similar to which
Q51: Dan, age 19, may have trouble buying
Q61: Given an objective function value of 150
Q118: Assuming that the marginal utility of wealth