In a small suburban town, firefighters work 8-hour shifts. Assume there are 6 shifts each day that a

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.