Problem 1: The Moore View police force requires the following number of on-duty police officers: four from midnight to 4AM; five from 4AM to 8AM; seven from 8AM to noon; seven from noon to 4PM; eight from 4PM to 8PM; and ten from 8PM to midnight. Each police officer has to work eight hours, i.e., two consecutive four-hour time blocks. Assume officers are paid $25 per hour for working "daytime" between 8AM and 8PM and $30 per hour for working "nighttime" between 8PM and 8AM. (a) Formulate a model that determines how many officers should work at various times in order to meed the requirements while minimizing the total payroll. (b) Find the optimal schedule using Excel Solver. How many police officers are needed? How much will be the total payroll