+ Reply to Thread
Results 1 to 7 of 7

Working out headcount

Hybrid View

  1. #1
    Registered User
    Join Date
    04-20-2014
    Location
    England
    MS-Off Ver
    Excel 2019
    Posts
    25

    Working out headcount

    Hi all,

    I've had a look to see if this has been posted before but it hasn't.

    Most places use erlang to work out headcount for a call centre, but is there a way to do calls and tickets together to work out headcount?

    The way to look at it would be to look at what's possible in a month and how many heads are needed based off both call volume and tickets/emails logged.

    Thanks,

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2406
    Posts
    44,662

    Re: Working out headcount

    Without a sample sheet, your request doesn't make sense to me!! Please read the yellow banner (top of page) and post a sample sheet with some manually calculated results.
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU

  3. #3
    Forum Expert CK76's Avatar
    Join Date
    06-16-2015
    Location
    ONT, Canada
    MS-Off Ver
    MS365 Apps for enterprise
    Posts
    5,973

    Re: Working out headcount

    Most places use erlang to work out headcount for a call centre, but is there a way to do calls and tickets together to work out headcount?
    There's no straight forward way to do it.

    Here's general guide line.
    1. Using Erlang C traffic model, calculate number of staff required to maintain your SL target.
    2. Using same model, calculate average occupancy rate per agent, making sure to account for breaks etc.
    3. Then using average handle time of ticket(s). Calculate how many agents are required to process queue(s), meeting SL agreement.

    EDIT:
    Ex: Lets say to meet 80/20 SL, you need 15 agents, but this puts them at 85% occupancy. This leave little to no room for them to work ticket queue. So you will need to add more agents.
    Let's say that you add more agents to bring occupancy rate down to 75%. Then you have about 10% of agent's time to work on ticket queue. Calculate if this is enough to meet your need to process tickets, using avg ticket handle time.

    This will give you base value to start your model. Then you'll need to adjust according to your specific business and mix of agent skill level.

    It can be bit more complicated, if you mix agent skill sets which are not identical across agents, as well as mixing dedicated agent (working queue) etc.

    As well, most call centre does not have flat call volume every hour, there is hourly peak and valleys, which should be accounted for. So your staffing should have varied start time etc.

    FYI - Never staff agents for over 88% occupancy or more (for entire shift). This will burn out agents and will result in high-turnover rate, which will increase your staffing cost in the end.
    Target is usually between 80% to 87% occupancy to strike balance between keeping agents busy and giving enough breathing time.

    EDIT2: I used to be SL manager, WF manager at mid-size call centre (150 to 200 seats depending on season). That had mix of calls & ticket queue. Let me see if I have any sample from my old job. It's been at least few years since I last used Erlang C model for staffing... so don't hold your breath.
    Last edited by CK76; 11-09-2020 at 11:37 AM.
    "Progress isn't made by early risers. It's made by lazy men trying to find easier ways to do something."
    ― Robert A. Heinlein

  4. #4
    Registered User
    Join Date
    04-20-2014
    Location
    England
    MS-Off Ver
    Excel 2019
    Posts
    25

    Re: Working out headcount

    Yep, this is the problem, the other side of this is that they can resolve tickets while on a call as well, some tickets take a minute to resolve while others could go on, for over a day.

    So what I need to do is figure out a way of showing calls and tickets based on targets, now rather than doing this daily monthly makes more sense, this is because some people work weekends and other work longer shifts at night.

    This really is a tricky one.

  5. #5
    Forum Expert CK76's Avatar
    Join Date
    06-16-2015
    Location
    ONT, Canada
    MS-Off Ver
    MS365 Apps for enterprise
    Posts
    5,973

    Re: Working out headcount

    Tickets can be measured, not in open-close duration. But on actual time spent handling it. Typically speaking, no tickets are worked on constantly for more than few hours (typically less than 15 min, and don't count time spent by IT or other staff outside of front-line).

    Get enough sample to calculate average handle time for tickets. This will give you basis for staffing calculation.

    If you have some support staff (QA, HelpDesk, etc), that can support queue, this will help as well to buffer peak volume.

    Start off by measuring your current staffing vs current volume stats. Check if all the targets are met. Adjust your model accordingly (if meeting all targets, then try reducing # of staff, else increase staff).

    Once you build your model, you'll need to schedule periodic review to validate it. Making adjustments as necessary.

    For interval, I'd recommend using 30min or Hourly level break-down for each day of the week. Then create schedule to fill in staffing requirements for each hour.

  6. #6
    Registered User
    Join Date
    04-20-2014
    Location
    England
    MS-Off Ver
    Excel 2019
    Posts
    25

    Re: Working out headcount

    Quote Originally Posted by CK76 View Post
    Tickets can be measured, not in open-close duration. But on actual time spent handling it. Typically speaking, no tickets are worked on constantly for more than few hours (typically less than 15 min, and don't count time spent by IT or other staff outside of front-line).

    Get enough sample to calculate average handle time for tickets. This will give you basis for staffing calculation.

    If you have some support staff (QA, HelpDesk, etc), that can support queue, this will help as well to buffer peak volume.

    Start off by measuring your current staffing vs current volume stats. Check if all the targets are met. Adjust your model accordingly (if meeting all targets, then try reducing # of staff, else increase staff).

    Once you build your model, you'll need to schedule periodic review to validate it. Making adjustments as necessary.

    For interval, I'd recommend using 30min or Hourly level break-down for each day of the week. Then create schedule to fill in staffing requirements for each hour.
    I don't suppose you have any sample models? building this from scratch is already becoming quite a beast.

  7. #7
    Forum Expert CK76's Avatar
    Join Date
    06-16-2015
    Location
    ONT, Canada
    MS-Off Ver
    MS365 Apps for enterprise
    Posts
    5,973

    Re: Working out headcount

    Sorry, I looked through my archives, but I can't locate the one I used to use.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Headcount per interval
    By sregnov in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-15-2019, 01:12 AM
  2. Replies: 2
    Last Post: 03-05-2018, 03:50 AM
  3. Conducting headcount based on number of employees working a specific shift
    By joannechen101 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-02-2017, 01:47 PM
  4. [SOLVED] Headcount Forecasting
    By Shaun_Chetty in forum Excel General
    Replies: 17
    Last Post: 05-27-2015, 02:45 PM
  5. Headcount Lookup
    By sasha38 in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 02-08-2014, 12:21 PM
  6. Replies: 2
    Last Post: 10-19-2013, 11:31 AM
  7. Replies: 1
    Last Post: 07-17-2013, 11:34 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1