Generic selectors
Exact matches only
Search in title
Search in content
Search in posts
Search in pages

Using Excel to Calc Forecasted SLA

Tagged: 

Viewing 3 posts - 1 through 3 (of 3 total)
  • Author
    Posts
  • #17155 Reply
    Jamie
    Guest

    Hello,
    New to the board.

    I have recently taken over scheduling for an inbound call center with >4k employees world wide.

    My challenges include migrating two seperate scheduling functions and teams onto one scheduling platform, along with merging schedules of two previously seperate call centers

    With that, I have inherited several “tools” used by prior managers of the group that I have found to be providing incorrect informaiton to the business. One are our IDP’s (intra day performance reports) The majority of the IDP is constructed in TCS 6.3 but is then exported to Excel where they continue to tweak the numbers. One such tweak is an attempt to forecast SLA per interval (30 min). The math just doesn’t add up. I’ve tried some of the Excel Erlang calcs out there, but they seem to error out given the number of calls and advisors we have.

    Do any of you have any suggestions for a tool for excel that will allow me to calculate service level by interval if I know AHT, scheduled Staff, Call volume?

    Example of my interval volumes:
    Calls 1076, AHT 215, Staff 149,

    Thanks so much. I’m looking forward to learning a lot from this site.

    #17157 Reply
    Magnus
    Guest

    Hi Jamie,

    I would say that your SLA on that specific interval should be >99.00%.

    Unfortunately i don’t have any excel addons for this one.

    #72893 Reply
    Tom Howard
    Keymaster

    Hi Jamie, Magnus is right that the SLA is extremely high with your example – pretty much perfect performance. That’s no surprise because you have 149 staff ready to answer only 1076 (fairly short) calls in an hour. To answer your more general question, our company offers an Excel add-in for call center analysis called CC-Excel. This adds several functions to Excel that you can use to estimate call center performance.

    I’ve highlighted CC-Excel‘s SLA formulae below, in red:

    CC-Excel

    Function name Description
    CCXLAgents() Estimates the number of agents you need to handle incoming calls within specified service level parameters.
    CCXLCalls() Estimates the number of calls that your inbound call center can handle within specified service level targets.
    CCXLDuration() Estimates the average length call that your call center can handle.
    CCXLASA() Estimates the average speed in which your center’s calls will be answered.
    CCXLQueue() Estimates the average number of your inbound calls that will be queued and waiting for presentation to an agent.
    CCXLOccupancy() Estimates the percentage of their time that your call center’s agents will be busy handling inbound calls.
    CCXLAllBusy() Estimates the percentage of calls that will arrive while all your agents are occupied, and will therefore enter a queue.
    CCXLService() Estimates the percentage of calls that will be answered within a specified service time.
    CCXLLines() Estimates the number of telephone lines that are required to handle the inbound calls into your call center.

    CC-Excel’s strength is the flexibility and freedom it gives you to design workbooks that meet your exact requirements, rather than being tied to the formats and assumptions of Windows workforce management applications. With some knowledge of Excel, you can use its more advanced features such as lookup tables, conditional formatting and charting to build complex modelling tools.

     

    All the best,
    Tom Howard,
    Westbay Engineers Ltd.

Viewing 3 posts - 1 through 3 (of 3 total)
Reply To: Using Excel to Calc Forecasted SLA
Your information:




<a href="" title="" rel="" target=""> <blockquote cite=""> <code> <pre class=""> <em> <strong> <del datetime="" cite=""> <ins datetime="" cite=""> <ul> <ol start=""> <li> <img src="" border="" alt="" height="" width="">