The customer service cell operated on a 24-hour, 7-day week schedule. The day is divided into three eight-hour shifts. Day-shift is one of these three shifts. The total number of persons required...

The customer service cell operated on a 24-hour, 7-day week schedule. The day is divided into three eight-hour shifts. Day-shift is one of these three shifts. The total number of persons required during the day-shift has been estimated for next six months as given below:

The Vice President (CRM) is interested in developing a workforce schedule that will minimize the number of staff members required to staff the customer service cell.

Work Norms: An employee works 5 days a week and is entitled to 2 consecutive days off each week. Shift assigned to a person remains same.

For scheduling of day-shift activities with optimum workforce for next six months, what is the optimum workforce size? Suggest the scheduling also to achieve the minimum manpower required on each day. You are required to show all the steps.

Send the excel with formula at [email protected]