Download the Exercise sheet. For an AHT of three minutes and an 80/20 service level, calculate the required number of agents without rounding for each interval. Sum these numbers over all intervals.
1) Calculate the required number of agents without rounding for each interval, then sum these numbers over all the intervals. 2) How many agent hours are required in total? 3) Do the same as question 1, but this time for the number of agents rounded up to the next integer (use an appropriate Excel function for rounding). 4) How many agent hours are required in total if we round agents in each interval? 5) What is the overall SL using the rounded number of agents? Please note that when you submit the excel, paste your results in another sheet with "value only", so that the trainer can check both the results and the formulas.