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

Call Center Staffing Calculator

Tagged: 

Viewing 7 posts - 1 through 7 (of 7 total)
  • Author
    Posts
  • #70030 Reply
    Mark Rollag
    Guest

    My name is Mark Rollag, I have owned a call center for 16 years and worked in the industry for 10 years prior to that.

    I am in Omaha, we eat sleep and breathe call centers.

    We successfully manage traditional call center agents all over the world that are handling Inbound Calls, WebChat, Email, Web Contact Us forms, and QA for other companies as well as Outbound.

    We use the Erlang Excel addon and it works great.

    If you have questions, feel free to ask me!

    Thanks, Mark

    #70031 Reply
    pix
    Guest

    hi Mark, thanks for sharing,

    Cheers 🙂

    pix

    #71436 Reply
    Bill White
    Guest

    I bought the excel addon and when inputting values into the Ansaphone tab, I think the required staffing I am seeing is far too low. What adjustments should I make to have a more realistic result?

    I’ve set my answer SLAs at 70% within 90 seconds
    Call duration of 600 seconds, after call work of 140 seconds

    Loaded up last months hourly volume averages

    The number of agents the spreadsheet said I needed was below the number of agents I actually had last month, and our average answer times were nowhere near as good as 70% within 90 seconds.

    I was already understaffed and Ansaphone computed I needed even less staff. Something is definitely not right with what I’ve done.

    #71441 Reply
    Tom Howard
    Keymaster

    Hello,

    The Erlang C traffic model makes some assumptions about the nature of the traffic into a call center (see https://www.erlang.com/support/cc-excel-faq/). They include

    – Call arrivals are random
    – Service times are exponential
    – Callers are answered in the order of arrival

    If call arrivals are not random, then Erlang C can tend to underestimate the agents needed. For example, if you have a sudden peak of calls, you’ll need more agents than normal to handle that peak.

    If you’d like to send me some example figures, I can check them against our tools and make sure CC-Excel is giving you the expected results. My email address is service@erlang.com.

    All the best,
    Tom Howard,
    Westbay Engineers Ltd.

    #72138 Reply
    Jill
    Guest

    I use erlangc to calculate my staffing needs based on an AHT and volume and ASA goal. I would like to do the reverse. I have my volume and AHT and staffing and I want to know the expected ASA is this possible?

    Thank you

    #72139 Reply
    Tom Howard
    Keymaster

    Hello Jill,

    Yes, it’s possible with two of the products we sell at this site.

    We have a Windows product called Westbay Traffic Calculators. It has an Erlang C calculator that allows you to make these calculations (ASA from the number of agents, number of calls and call duration).

    Here’s  screenshot of Westbay Traffic Calculators in action:

    If you prefer Excel workbooks, we made an add-in for Microsoft Excel called CC-Excel. It adds nine call center related functions to Excel. One of them is =CCXLASA() and it performs this calculation and, in line with all Excel functions, lets you reference other worksheet cells. In this case, references would be to cells that hold the number of agents, number of calls and call duration. The function result is the estimated ASA.

    Here is an Excel screenshot showing the same calculation as before, but using CC-Excel:

    CC-Excel

    More information on these products is available at:

    Westbay Traffic Calculators: https://www.erlang.com/products/westbay-traffic-calculators/
    CC-Excel: https://www.erlang.com/products/cc-excel/

    If you have any questions about these products, please reply to this post or email our support team directly: service@erlang.com

    Kind regards,
    Tom Howard,
    Westbay Engineers Ltd.

    #72167 Reply
    adam watson
    Guest

    hi there. I am adam. I have a website and this website call center related. I need some help who can help me please visit my website and contact me then help me

    • This reply was modified 1 month, 3 weeks ago by Tom Howard.
Viewing 7 posts - 1 through 7 (of 7 total)
Reply To: Call Center Staffing Calculator
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="">