Please use the same format in Excel and answer using Solver and SolverTable. Thank you!

6. During each four-hour period, the Smalltown police force requires the following number of on-duty police officers: four from midnight to 4 A.M.; four from 4 A.M. to 8 A.M.; seven from 8 A.M. to noon; seven from noon to 4 P.M.; eight from 4 P.M. to 8 P.M.; and ten from 8 P.M. to midnight. Each police officer works two consecutive four-hour shifts. a. Determine how to minimize the number of police officers needed to meet Smalltown's daily requirements. b. Use SolverTable to see how the number of police officers changes as the number of officers needed from 8 A.M. to noon varies from 4 to 10 . A B C D EF G Police force scheduling Starting 4 hours of 8-hour shift M4A4A8A8ANN4P4P8P8PM 5 Number starting Number available 7 each 4-hour period Number required Total employed