A$.$ Continue with the Bank$24$ scheduling problem described in the earlier question to provide the labor demands.

As you know, we can alter the 'contract' by paying variable wages to employees, depending on the timing of the shift. For this problem, assume that Bank $24$ wishes to minimize the total wage cost per week. All employees work a fiveday$-$per$-$week shift, such that they begin their shift and work $3-$days$-$on$,$ one$-$day$-$off, two$-$days$-$on$.$ Further, employees who work a shift that includes working on Friday, Saturday, and Sunday $($when all three are in the shift$),$ receive $$565$ per week. Employees working all other shifts receive $$515$ per week.

Further, we can alter the 'contract', such that management can require a worker to work a single day of overtime, the day directly following the worker's standard shift. An employee who works an overtime day that falls on Sunday receives an extra $$170$; and all other overtime days are paid an extra $$145.$

Work the problem, minimizing total wage cost.

In a new Word document $($eRaiderUsername$\_$bank$24\_$overtime.docx$),$ use the data to construct and write out the mathematical model.

Construct and solve the model in a workbook $($eRaiderUsername$\_$bank$24\_$overtime.xlsx$).$

In the document, interpret the solution values of the decision variables, the objective, and the constraint levels.