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 for this Excel spreadsheet implementation of the following formulation?
Definitions:
Tuition Increase
The rise in the cost of attending classes and receiving education services at institutions such as colleges and universities.
Opinion
A personal view, attitude, or appraisal formed in the mind about a particular matter.
Chi-square Test
A statistical test used to determine if there's a significant difference between the expected frequencies and the observed frequencies in one or more categories.
Economic Concerns
Issues or problems relating to the economy, including unemployment, inflation, and economic policy.
Q48: Refer to Exhibit 7.2. Which cell(s) is(are)
Q48: Suppose that the income tax in the
Q52: A common objective in the product mix
Q61: Given an objective function value of 150
Q64: The term <span class="ql-formula" data-value="\varepsilon"><span
Q70: An investor has $500,000 to invest and
Q72: A city wants to locate 2 new
Q172: One of the ways the market for
Q190: Steve owns a motorcycle valued at $5,000
Q198: Warranties in the used car market _