A call center operates $24$ hours a day. The call volume varies by hour, and hence the number of agents required for each hour differs, which is presented in column $$G$$ of the Excel file provided. The company can hire either part$-$time or full$-$time agents. A part$-$time agent works four hours straight and gets paid for $$15$ per hour. A full$-$time agent works eight hours straight, and the hourly rate is the same. Given the above information, determine an employee schedule that minimizes the total daily compensation for the call center. In your model, consider all $24$ possible part$-$time schedules, e$.$g$.,0-4,1-5,...,23-3.$

Additionally, consider six possible full$-$time schedules, i$.$e$.,0-8,6-14,8-16,10-18,12-20,$ and $16-24.$

Fill up column $$H$$ using the correct formula.

Determine the total daily compensation $($D$28)$ using the correct formula.

Apply Excel Solver to determine the optimal work schedule $($specify objective, decision variables, and constraints$).**$Hint: to specify multiple blocks of decision variables, you can simply type a $,$ before adding the next one.

Upload your solution in an Excel file.