In a small suburban town, firefighters work 8-hour shifts. Assume there are 6 shifts each day that are divided into six 4-hour periods. The minimum number of firefighters needed on each shift is illustrated below.
Shift Number of Firefighters Needed
MidnightAc€?o4 a.m. 5
4 a.m.Ac€?o8 a.m. 6
8 a.m.Ac€?oNoon 10
NoonAc€?o4 p.m. 12
4 p.m.Ac€?o8 p.m. 8
8 p.m.Ac€?oMidnight 5
Firefighters must report to work at the beginning of the above time periods and must work eight consecutive hours.
Solve the given problem scenario to determine the minimum number of firefighters needed on each shift by formulating and setting up the problem in Excel Solver.