Comments on: Can Forecasting Help Me Staff a Specific Hewlett-Packard Call Center at 10:30 am on a Friday? https://demand-planning.com/2010/03/18/can-forecasting-help-me-staff-a-specific-hewlett-packard-call-center-at-1030-am-on-a-friday/ S&OP/ IBP, Demand Planning, Supply Chain Planning, Business Forecasting Blog Thu, 09 Dec 2010 17:46:46 +0000 hourly 1 https://wordpress.org/?v=6.6.4 By: Tom Reilly https://demand-planning.com/2010/03/18/can-forecasting-help-me-staff-a-specific-hewlett-packard-call-center-at-1030-am-on-a-friday/#comment-141 Thu, 09 Dec 2010 17:46:46 +0000 https://demand-planning.com/?p=721#comment-141 David,

We agree that there is another half of this pie that you describe very well as that is what you do. What we do is the first half of the pie.

Where you say “Unknown and unknowable events have a large impact on your staffing”, our response is: Detecting when these events have occurred in the past and isolating their effect allows you to model in a more robust manner. Identifying these events leads naturally to heretofore unknown causal variables which might then aid modeling efforts. At a minimum, the distortion introduced by these is alleviated.

As for models failing, yes they do. Things change no doubt and how to model these “interventions” is key to being able to model these disruptions automatically so that the model will still predictably forecast the week AFTER the interruption is paramount.

The Monday hourly pattern is different than a Friday. The question is can you model them separately while taking into account the MACRO effects like holidays, etc. and level shifts and interventions. That’s where it gets a little a hairy and where our expertise comes into play.

Our analytic approach does not assume any prespecified weighting schemes but rather constructs a model based on the data: 1)optimal memory weighting (ie weekly/daily dummies) 2)lead/contemporaneous/lag structures around known holidays/events 3)4 Intervention variables which represent unspecified determinstic series (ie level shift, seasonal pulse, time trends and outliers)

The best way to evaluate alternative strategies like ours is to do so with a case study. We welcome the opportunity to do this.

]]>
By: David Wienecke https://demand-planning.com/2010/03/18/can-forecasting-help-me-staff-a-specific-hewlett-packard-call-center-at-1030-am-on-a-friday/#comment-140 Wed, 08 Dec 2010 21:09:40 +0000 https://demand-planning.com/?p=721#comment-140 I think to be the most successful, you can look at ways to predict your number of calls and the time each call takes more accurately. I also believe that attacking the problem this way is only half the solution. The truth is that you can only get a prediction so close before the model fails. Unknown and unknowable events have a large impact on your staffing that can make the difference between doing well and poorly. Instead look at ways to manage your business to take up the slack between the accuracy of your model and the actual call volume. Create a base staffing model that can take say 40% of your average call volume with full time 40 hours schedules. Fill in the dips and mountains with part time flex employees who work schedules in the 25-30 hour range. If your volume peaks on a given day beyond your prediction, you can offer to your flex staff up to 10-15 hours each without paying overtime. Have a few of your flex staff call in each day as on call employees. If you need them have them come in for the necessary hours. If your call volume flags, offer voluntary time off to both your full time and flex staff. Set parameters on utilization, occupancy and answer rate (service level) and have your management team work their staffing between the upper and lower specification level for each metric. It is all about working the numbers and having the tools to make changes in the environment to account for the micro changes in the staffing, volume and call duration areas.

]]>