Question $7$: $15$ Points

A rush order just came in and the operations team is ramping up the workforce. This is going to require additional staffing in the assembly area and extending the usual workday by adding additional shifts. Due to the cyclical nature of this staffing, management wants to bring in temporary workers to fill out the demand.

They are creating two daily shifts, a morning and afternoon shift. Each shift works $10$ hours per day. The part$-$time employees only work $20$ hours per week and the full$-$time employees work $40$ per week. This means that there are full$-$time shifts that can work the morning or the afternoon $($For example, a possible full$-$time shift only works in the morning for $4$ consecutive days$).$ The part$-$time have possible shifts for each morning and

each afternoon $($a worker on a part$-$time shift does not work in the morning and afternoon$).$ Each part$-$time employee makes $$15\mathrm{.}40$ per hour, each full$-$time is paid $$20\mathrm{.}40$ per hour. Both types of workers get an additional $20\%$ for hours worked on Friday.

Management wants to make sure that there at least as many full$-$time employees working on a given $10$ hour portion of the day $($Monday morning for example$)$ as part$-$time employees. Based on the planned workload you need the following number of employees on the following days and time of day.

$\backslash$table$[[$Required$,$Monday,Tuesday,Wednesday,Thursday,Friday$],[$Moming$,5,10,7,7,8],[$Aftemoon$,9,11,11,11,7]]$

Create an Excel model to determine the optimum staffing to minimize total staffing costs.

PLEASE CREATE THE EXCEL MODEL