Please use attached template to find the solution.

Question: 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 Smalltowns 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.

23456 Q19 A 1 Police force scheduling 5 Number starting 789 mnnHLDS-HRB45678 Number available 7 each 4-hour period 9 Number required 10 11 Total employed 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 for Mac 27 281 29 30 31 32 33 34 35 36 37 38 4 About SolverTable Unload SolverTable: for Mac for Mac X Vfx 8 Ready 900 000 P4-46 M-4A P4-48 C $ D E Starting 4 hours of 8-hour shift 8A-N N-4P 4A-8A P4-50 MacBook Pro P4-50 part B F 4P-8P 8P-M P4-50 part C P4-50