Thursday, March 26, 2009

Service Standards and Year End Reporting

Let’s assume we are in April 2009 and take the following example of some applications:

Receive DateProcessing Finish DateNumber of Days to Process
February 1, 2009February 15, 200914
February 15, 2009February 28, 200913
February 15, 2009March 1, 200914
February 15, 2009March 15, 200928
March 1, 2009March 15, 200914
March 15, 2009March 31, 200916
March 31, 2009TBD


Now, let’s assume that no applications were received in January and that the service standard for this type of application is 15 days (applications are processed in 15 days).

There are two ways of looking at this. The typical view is to measure from the receive date. That would measure the number of days it took to process an application from the day on which it is received. The other possibility is to measure based on the date on which the application’s processing was finished. This method is less common.

Here is a tricky question: “What was the average processing time for applications in February?” The question is tricky because it doesn’t give you a reference for which date to use as a base, are we talking about the applications received in February, or the applications processed (finished) in February? Here are the options:

Average Processing Time of Applications by Received Date
February17.25
MarchTBD


Average Processing Time of Applications by Processing Finish Date
February13.5
March18


According to the received date base, 75% of applications received in February were processed within the service standard (15 days). But of the applications processed in February, 100% were processed within the service standard (if we consider that no applications were received in January, which we do in this example).

Normally, I expect most organizations to use the first method, based on the date on which the application is received.

So the fiscal year is over (ends March 31), and it’s now April 7, 2009. Can you produce accurate statements on your performance against the service standard for applications received in March, using the first method (based on the date the application is received)? The answer is no, because your service standard is 15 days, and only 7 days have passed since the last day of March. April 15 is the last day for which the applications received March 31 will still be processed within the service standard, so you would only be able to know how many of the applications received in March were processed within the service standard at the end of the business day on April 15. That’s assuming you have instant access to up-to-date information, which is not always the case. If there is a delay between the time an application is processed (processing finish) and when you know about it, then you also need to take that into account. This is often the case for electronic systems, there is often a delay between the data entry into the application, and the availability of the data in data marts or cubes used for reporting.

In conclusion, be aware of your service standards, of how your performance is calculated, and of the delays in the availability of data when you are doing your year end reporting, or you could end up with inaccurate performance statements.

No comments: