Scheduling Spreadsheets Become Obsolete in the Cloud
“Is it in the budget?”
Some variation of that question is always asked when any changes to contact center procedures are proposed. And it’s a valid question. Economic realities have forced businesses of all kinds to do more with less, and contact centers are no exception.
But there comes a point when inaction can be more costly than a beneficial investment. And when it comes to the use of spreadsheets vs. workforce management software, that time has come.
Yet many small and midsized contact centers still rely on spreadsheets for daily forecasting and scheduling. Even larger contact centers, those with 100 agents or more, are still making due with an inefficient system that lowers customer service, and can actually increase costs.
When an increase as low as 1% in productivity can significantly impact the contact center budget, it is imperative to identify areas where efficiency can be improved. Ditching spreadsheets should be at the top of that list.
Spending Money to Save Money
The limitations of a spreadsheet result in fixed schedules that can produce higher shrinkage and overstaffing, or understaffing and a low service level. But with WFM it is easier to manage start times, end times and breaks with an ease of flexibility that dramatically improves service levels.
Managers can also consult more detailed and accurate call histories with WFM, resulting in better forecasts. Scheduling is also faster – some managers can save as much as 25% of the time once devoted to filling in spreadsheets – time that can now be used for additional agent training or to attend to other matters.
Is increased efficiency worth the investment? One of our clients, the Texas credit union GECU, found out first-hand. Their call center, staffed by 85 agents, selected Monet’s cloud-based WFM Live as a way to improve customer service. Affordability was a key component in the decision, as WFM Live provides such benefits as reduced IT investment, low implementation service fees and a more cost-effective per-user license model.
Just a few months after implementation, GECU was able to save money by reducing its number of agents by 14, while delivering better customer service. With the more accurate scheduling made possible by WFM Live, there was a 30% reduction in unscheduled breaks. Costly overtime scheduling was reduced, while call volume spikes were managed more easily.
“In terms of ROI, Monet has already paid for itself after a few months. The cost of the 3 year subscription I’ve already saved in salaries, overtime and administrative costs.”
Joshua Gomez, GECU Assistant Vice-President, Call Center
Today, the quality and service levels at GECU are solidly placed in the top 97% tier.
The Better Solution for Managers, Agents and Your Customers
A spreadsheet can be used to calculate workforce percentages, but precise forecasting requires more in-depth analysis. And when forecasts are wrong, stressed agents cannot deliver the service level you and your customers expect – or, they’re sitting in their cubicles with nothing to do, and earning money for it.
One of the reasons we hear most often from companies reluctant to change is, “But this is the way we’ve been doing it for 10 years.” Change can indeed be intimidating. What we tell them is they are not really changing the things they do – they are just going to be able to do them more easily and efficiently.
Forecasts rely heavily on historical data – daily, weekly, monthly, seasonal – to determine call volume. Contact center managers may start with monthly and weekly stats, and then delve deeper into daily and hourly numbers, perhaps even examining work periods as short as 15 minutes.
This can be done with spreadsheets, theoretically, but with WFM it is significantly easier to analyze call types, call volume and call patterns, and then to note past variations, determine their cause, and forecast accordingly. With WFM it is also much easier to forecast special days or other events that impact call volume. “Special day” provisions can be created for any factor, from marketing campaigns or events to weather patterns.
Scheduling is yet another area where WFM offers enhanced capabilities. Spreadsheets can handle fixed schedules, but in 2015 how often do contact center schedules stay fixed?
With a WFM system managers have the flexibility to automatically manage start times, end times and break times. Now, agents can work the hours that work best for them, and happier agents are far more likely to excel at customer service. They are also more likely to stay with the company longer, a consideration that should not be minimized considering the average employee turnover rate in this industry.
Intra-day adherence tracking is another significant component of a best practices approach that is practically impossible with just a spreadsheet. WFM also provides insight, through dashboards and real-time alerts, into which agents are meeting their schedule obligations, and which may require additional guidance or training.
The annual budgeting process presents a familiar challenge – cut costs where necessary while maintaining (or improving) the customer experience. Since labor forces rank among the highest cost items, it is essential that they be managed properly. With WFM, a manager can always be confident that he or she is scheduling the right agents with the right skills at the right time.
Those still using spreadsheets for these functions are missing out on the convenience, efficiency, flexibility and functionality of workforce management.
The calculations necessary for optimal forecasts and schedules are very difficult to do with Excel. WFM has sophisticated simulation processes that tell a call center how many people it will need and when it will need them.
“But we can’t afford it.” That might have true ten years ago, but today with cloud-based WFM, even smaller and medium-sized contact centers can reap the benefits of automated workforce management at an affordable cost. A lower investment also means a more rapid return on that investment.
When call volume changes, spreadsheets are insufficient. With WFM, managers can get back to managing people, instead of spending hours on Excel planning forecasts and schedules. To learn more about this, download our whitepaper “The Real Cost of Spreadsheet-based Scheduling“
The Operational Advantages of WFM
Still considering whether to add a workforce management solution to your contact center? There are many reasons doing so is
Abandon Rate: What It Is, Why It Goes Up, What You Can Do
Abandon: (verb): To leave completely and finally; forsake utterly; desert: Sounds pretty grim, doesn’t it? “Abandon Rate” is one of