CallCentreVoice Topic Forecasting: What tools do you use?

Created by:
Statistics:
Forum:
Quick links:

Wil Joseph on 19/10/2009 16:07:51.
Topic has 11 posts; viewed 3119 times.
Planning, Strategy and Management   [This topic is read only]
Forum List | Unified View | Latest Posts
Popular Topics | Editor's Choice | Voices WebLog

Advertisement
WFM Wisdom

Author

Comments

Wil Joseph
Workforce analyst
Telephone

4 posts
0 friends welcomed

Forecasting: What tools do you use?  [19/10/2009 16:07:51]

Short end of it, company purchased a WFM tool that has forecasting capabilities. I prefer to use my excel built models for most of my clients though.

What are the pros and cons to using excel sheets to using a WFM tool, and what do you use???

You don't have the priviledges to view this user's post history

 

Dave Appleby
Resource Analyst
Healthcare Insurance

1530 posts
0 friends welcomed

Wil  [20/10/2009 08:07:12]

It's one of those questions that if you ask
20 people, you will get 20 different answers.

It's down to accuracy a lot of the time, Excel models
tend to work for one or two queues then start to break down
as the averages it's working with on AHT etc start to become
problematic.

I suspect you will be getting a decree that WFM shall be used
as I suspect this is now a selling point, regardless of accuracy,
even if proven, there's a little nagging doubt in peoples minds that
anything hand written can be as good as something you've paid for, sad
but true. Add in the fact that manual forecasting is still seen by some
as something just short of Witchcraft and I suspect you'll not have a
choice in the near future.

Keep at it though, manual forecasting has the advantages of being able
to back stop and quality control the WFM app, as you can't see what it's
doing to your data to produce said forecast the Excel model can act as a
sanity check. It's also useful for modelling newe contracts quickly rather
than setting up a full WFM simulation.

Just my 2p's worth.

Regards

DaveA



Gold Level MemberYou don't have the priviledges to view this user's post history

 

Wil Joseph
Workforce analyst
Telephone

4 posts
0 friends welcomed

Call Distribution Variance  [2/11/2009 17:32:26]

thank you for your insight, personally I feel I have more control using a manual process for forecasting and it seems to cut down the tediousness that the WFM tool adds.

Another question: what measure do you use to show call distribution variance to forecast in a day? I was using a correlation coefficient, any other method that works just as well?

thank you

You don't have the priviledges to view this user's post history

 

Kevin Hartley
Call Centre Director
Alterna Savings

3 posts
0 friends welcomed

RE: Forecasting: What tools do you use?  [5/11/2009 19:08:36]

Wil:

I understand your frustration. WFM solutions can in many cases set up a fully automated process that iteratively pulls your forecast into patterns that your own insights tell you are off the mark. For this very reason, we stayed with Excel based forecasting and scheduling for years.

The problem is that most WFM solutions take a pretty superficial and unrealistic view of historical demand. For example, I know that when we are building towards our peak period there is just no-way we should be staffing as if the call demand is random. It is not random, its is accelerating upwards. If we use an Erlang formula then it tells us to staff for relatively flat call volume. If I take the advice, my service levels tank, abandons take off and complaints start pouring in.

Also, if you look at the majority of WFM solutions out there, they will collect past service levels but make no use of them for forecasting purposes. So 300 calls with 5-minute AHT give you the exact same demand for agents whether the historical service levels were fantastic or terrible. Common sense tells us we need to staff-up or staff earlier to improve on poor service levels the next time around. So why invest the time expense and energy in a system that automates really bad decisions that a more thoughtful process would avoid.

I think the senior managers who bought your WFM solution are going to give you a really hard time about not using it for forecasting so you may want to educate yourself on how to defend your position.

What we ultimately did was to wait for a WFM solution that created more thoughtful forecasts. Eventually we found it and its been just fantastic for the past three years. This system uses a more modern approach to forecasting that intricately interprets the real distribution of past events.

Unlike most WFM solutions which only collect call counts and average durations, this one pull in the complete details of each call and evaluates historical demand with precision. This system gives an appropriate staffing level during periods that build towards peak demand. During other periods when calls really are arriving relatively flat the system staff much lower than an Erlang calculation. This works out well because flat call volume is easy to absorb into a service level without the overstaffing buffer introduced by an Erlang calculation. If we had poor service levels, high abandons or long wait times then the system automatically determines how to shift future forecasts and schedules to improve performance. The transformation of our forecast curve was very noticeable when we first implemented the system. Today the adjustments are more subtle. The company has a few different names for their technology but essentially this is “transaction based forecasting” not “interval based forecasting”.

Better forecasts gave us the confidence to fully automate our forecasting and scheduling process. Naturally that has reduced administrative effort but this is just one of many improvements that we have recognized. Agent have benefitted from a broad cross-section of web based tools for shift trading, vacation bidding, time-off requests and of course schedules on-line. As a result, our absenteeism has dropped significantly, especially during the unpopular weekend and evening shifts. The agents also see their own adherence in real time. Equipping the agents to manage their own compliance has made it easy to achieve great service levels consistently.

The entire system is fully web based so it is accessible to agents and supervisors from both home and office.

According to our experience your reluctance to use WFM for forecasting is warranted. As long as you don’t fall victim to the forecasting caveats, the process automation benefits of WFM are definitely worth exploring. However, don’t underestimate the damage that fundamentally flawed forecasts can do. If your staffing patterns get corrupted then the potential benefits of WFM/WFO will most likely slip through your fingers.

Cheers,
Kevin

You don't have the priviledges to view this user's post history

 

Scott Wilton
Strategic Panning Manager
N/a

140 posts
0 friends welcomed

Kevin???  [6/11/2009 08:51:31]

Hi Kevin,
It sounds like your system is quite comprehensive, but I can't find the name of it in your post

Can you post for reference please

Gold Level MemberYou don't have the priviledges to view this user's post history

 

Kevin Hartley
Call Centre Director
Alterna Savings

3 posts
0 friends welcomed

WFM Software  [9/11/2009 18:21:37]

No Problem Scott, Our workforce management system is called WFM Wisdom here is a link to the website www.wfmwisdom.com.

Cheers,

Kevin A. Hartley

You don't have the priviledges to view this user's post history

 

kelly john
marketing executive
TCI

8 posts
0 friends welcomed

New to this forum  [7/4/2010 12:37:06]

Hi,


I am kelly John new to this forum.After reading through the writing a question came to my mind what measure do you use to show call distribution variance to forecast in a day?



Thanks,
Kelly John.

You don't have the priviledges to view this user's post history

 

Dave Appleby
Resource Analyst
Healthcare Insurance

1530 posts
0 friends welcomed

Kelly  [8/4/2010 08:33:06]

Can you be a little more specific?

I'm assuming you're afte a little more than
'percentage drift'

Personally I use percentage with warning flags
at StDev -10%.

Hope it helps (a bit)

Regards

DaveA

Gold Level MemberYou don't have the priviledges to view this user's post history

 

Pamposh Raina
Sr.Manager -Workforce management
American Express

25 posts
0 friends welcomed

RE: Forecasting: What tools do you use  [9/4/2010 14:41:26]

Forecasting modules such IEX, BP, e-WFM more or less work on rules set my user themselves. Now those also depends on each individual product such as seasonality, trendings, business changes etc. So eventually even though you have lots of applications you end up doing half of the work yourself.

Please note that even if you want to work on these applications for providing you with data/information, you should be well versed with the product charecteristics and relates nuances.

I work on excel and create long term monthly forecast, weekly forecast and interval level forecast and can also do multiple skill forecast along with staffing.

Eventually your forecast is as good as what you end up achieveing on real time.

You don't have the priviledges to view this user's post history

 

Pamposh Raina
Sr.Manager -Workforce management
American Express

25 posts
0 friends welcomed

@ kelly john  [9/4/2010 14:43:25]

I use WAPE ( weighted average percentage error ) to determine accuracy.

You don't have the priviledges to view this user's post history

 

kelly john
marketing executive
TCI

8 posts
0 friends welcomed

reply  [12/4/2010 12:06:24]

Hi,

Thanks for all who answered my question.


Thanks,
Kelly.

You don't have the priviledges to view this user's post history

 
  

In Read Only View, you cannot reply to any topic