Please write a mathematical model representing this problem.

Build a spreadsheet model for this problem. $($Note: This problem will be graded based on the guidelines for good spreadsheet modeling.$)$

Please explain your spreadsheet model emphasizing what are the target cells, changing cells, and the data cells.

Using Solver, what is the minimum cost for this problem?

Who did you hire?

Replicate the above spreadsheet in a new worksheet entitled Problem C$-6$ and answer the following. What would happen if you could hire multiple people who have the same time schedules? Please explain what your new optimal cost is and how many of each person you would hire.