Modify staff scheduling problem that we worked in the class by considering the following information.

Employees can work for 8 hours per day. They are paid $12 per hour on weekdays and $15 per hour on weekends. Using excel solver, find the optimal solution to minimize the weekly payroll.

Use excel file Staff scheduling for Assignment 3.

Hint: change objective function to calculate total payment for employees available on weekdays and weekends working 8 hours per day.

Submit the excel file of the solution for both questions.

Office Update To keep up-to-date with security updates, fixes, and improvements, choose Check for Updates. G21vfx Employee scheduling model Objective: To develop an optimization model that relates five-day shift schedules to daily numbers of employees available, workforce requirements. and to use Solver on this model to find a schedule that minimize the weekly payroll The number of full-time employees required each day is given in the table below. Decision variables: number of employees starting their five-day shift on various days \begin{tabular}{|l|l|l|l|l|l|l|} \hline Mon & Tue & Wed & Thu & Fri & Sat & Sun \\ \hline \end{tabular} Constriant Integer constrain non negativity Employees available >= Employees Required Check for Updates Objective to maximize Total employees Staff Scheduling + Ready Accessibility: Investigate - +25%