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? 
Definitions:
Viewpoint
A particular attitude or way of considering a matter, influenced by one's experiences, beliefs, or information.
True To
Remaining faithful or loyal to a cause, idea, or mission; upholding certain values or standards without deviation.
Self-Image
How a person sees him- or herself.
Highly Technical
Relating to or requiring specialized knowledge or skills in a field, especially in science or engineering.
Q6: A railroad needs to move the maximum
Q18: The best way of solving LP problems
Q47: How many local maximum solutions are there
Q53: The demand nodes in the graphical representation
Q72: Consumers might leave a fast-food restaurant without
Q74: Refer to the above diagram. Which line(s)
Q77: A company needs to ship 100 units
Q85: How are binary variables specified in the
Q88: A financial planner wants to design a
Q115: Refer to the budget line shown in