Presenting Performance Data

Problem Solving and Decision Making Problem Solving and Decision Making Creatively
5 minutes
Share the link to this page
Copied
  Completed
You need to have access to the item to view this lesson.
One-time Fee
$49.99
List Price:  $69.99
You save:  $20
€46.74
List Price:  €65.44
You save:  €18.70
£40.02
List Price:  £56.04
You save:  £16.01
CA$68.38
List Price:  CA$95.74
You save:  CA$27.36
A$76.50
List Price:  A$107.11
You save:  A$30.60
S$68.11
List Price:  S$95.36
You save:  S$27.25
HK$391.33
List Price:  HK$547.90
You save:  HK$156.56
CHF 45.73
List Price:  CHF 64.03
You save:  CHF 18.29
NOK kr551.82
List Price:  NOK kr772.60
You save:  NOK kr220.77
DKK kr348.47
List Price:  DKK kr487.88
You save:  DKK kr139.41
NZ$84.17
List Price:  NZ$117.84
You save:  NZ$33.67
د.إ183.60
List Price:  د.إ257.06
You save:  د.إ73.45
৳5,499.99
List Price:  ৳7,700.43
You save:  ৳2,200.43
₹4,169.28
List Price:  ₹5,837.33
You save:  ₹1,668.04
RM238.42
List Price:  RM333.81
You save:  RM95.39
₦66,060.50
List Price:  ₦92,489.99
You save:  ₦26,429.48
₨13,909.47
List Price:  ₨19,474.37
You save:  ₨5,564.90
฿1,848.90
List Price:  ฿2,588.61
You save:  ฿739.70
₺1,625.07
List Price:  ₺2,275.23
You save:  ₺650.15
B$255.76
List Price:  B$358.08
You save:  B$102.32
R937.79
List Price:  R1,312.98
You save:  R375.19
Лв91.35
List Price:  Лв127.91
You save:  Лв36.55
₩68,890.62
List Price:  ₩96,452.39
You save:  ₩27,561.76
₪191.22
List Price:  ₪267.73
You save:  ₪76.50
₱2,881.72
List Price:  ₱4,034.64
You save:  ₱1,152.92
¥7,903.16
List Price:  ¥11,065.06
You save:  ¥3,161.90
MX$857.83
List Price:  MX$1,201.03
You save:  MX$343.20
QR182.17
List Price:  QR255.05
You save:  QR72.88
P689.81
List Price:  P965.79
You save:  P275.98
KSh6,639.79
List Price:  KSh9,296.24
You save:  KSh2,656.45
E£2,392.59
List Price:  E£3,349.82
You save:  E£957.23
ብር2,846.33
List Price:  ብር3,985.10
You save:  ብር1,138.76
Kz41,694.65
List Price:  Kz58,375.85
You save:  Kz16,681.20
CLP$47,408.51
List Price:  CLP$66,375.71
You save:  CLP$18,967.20
CN¥362.20
List Price:  CN¥507.11
You save:  CN¥144.91
RD$2,937.78
List Price:  RD$4,113.13
You save:  RD$1,175.34
DA6,708.56
List Price:  DA9,392.53
You save:  DA2,683.96
FJ$113.10
List Price:  FJ$158.35
You save:  FJ$45.25
Q388.59
List Price:  Q544.06
You save:  Q155.47
GY$10,484.28
List Price:  GY$14,678.83
You save:  GY$4,194.55
ISK kr7,026.59
List Price:  ISK kr9,837.79
You save:  ISK kr2,811.20
DH506.20
List Price:  DH708.72
You save:  DH202.52
L890.49
List Price:  L1,246.75
You save:  L356.26
ден2,874.95
List Price:  ден4,025.16
You save:  ден1,150.21
MOP$404.09
List Price:  MOP$565.76
You save:  MOP$161.67
N$957.24
List Price:  N$1,340.22
You save:  N$382.97
C$1,844.23
List Price:  C$2,582.07
You save:  C$737.84
रु6,681.04
List Price:  रु9,353.99
You save:  रु2,672.95
S/188.25
List Price:  S/263.57
You save:  S/75.31
K193.43
List Price:  K270.82
You save:  K77.39
SAR187.48
List Price:  SAR262.50
You save:  SAR75.01
ZK1,328
List Price:  ZK1,859.31
You save:  ZK531.30
L232.80
List Price:  L325.94
You save:  L93.14
Kč1,174.50
List Price:  Kč1,644.39
You save:  Kč469.89
Ft18,370.82
List Price:  Ft25,720.62
You save:  Ft7,349.80
SEK kr544.35
List Price:  SEK kr762.14
You save:  SEK kr217.78
ARS$43,693.47
List Price:  ARS$61,174.36
You save:  ARS$17,480.88
Bs347.54
List Price:  Bs486.59
You save:  Bs139.04
COP$198,223.63
List Price:  COP$277,528.94
You save:  COP$79,305.31
₡25,122.12
List Price:  ₡35,172.98
You save:  ₡10,050.86
L1,237.47
List Price:  L1,732.56
You save:  L495.08
₲372,019.98
List Price:  ₲520,857.74
You save:  ₲148,837.76
$U1,930.85
List Price:  $U2,703.34
You save:  $U772.49
zł201.68
List Price:  zł282.38
You save:  zł80.69
Already have an account? Log In

Transcript

The second part of analyzing the problem is to review performance data about the process or activity. And I want to say a few words about that I often management reports are just single point comparisons, comparing one data point, this period, say, with one other data points, either last period or last year or with some budget or target. The trouble with these single point comparisons is that they ignore the fact that variation exists within all processes. So comparing a small number of data items with some target or budget, or with this time last year actually tells us very little, the difference between them could be just random variation. What we actually need to do is review the data over time. By presenting our business data as a time series, we can begin to filter out the random variation and actually start to highlight the signals of change in the process.

So Let's look at how we do that. And here on the next slide, we see some performance data, an on time delivery performance mapped out over about 10 weeks there. And this method of presenting performance data allows a much more informed analysis than other approaches. For example, we can see from this chart that the average on time delivery performance is around about 89%. And with this current process, there's no way that management can consistently achieve their on time delivery target, which is 95%. So the process needs to change in order to achieve this target.

In the second example, here, we have the number of days from order entry to delivery for a process. And again, the time series presentation reveals some interesting facts about performance. For example, the range of performance from order entry to delivery is quite wide and this reflects very Variable performance in the process. And clearly we see here that there's a problem around weeks sort of 27 to 29. When the number of days from order entry to delivery increased quite dramatically. Also, we see that from week 31 onwards, the number of days is reduced.

And we wonder if this is an improving trend if some improvement activity has taken place here, and I'll share a few performance measures here, which are useful when analyzing data and the performance of the process. So some of the indicators include flow, which is the end to end elapsed time from the start of a process to the end of the process. So from ordering tree to delivery as we saw in the previous graph there and the flow time of a process and the amount of variation in it shows us how stable the process is, and shows us how that is performing against customer expectations. flow time is also sometimes called lead time. The next indicator is quality, which will be the right first time Or first time through indicator, meaning what percentage of parts are of work is done correctly the first time. As an alternative, we could use the number of scrap items at a processing step, or the amount of rework.

Customer satisfaction is another good performance measure, we might use customer scores, or you might identify pain points in the process from the point of view of the customer. And also the people work in the process. And working process into country is another good measure, which would be the level of inventory at each stage. Because this helps identify the bottlenecks where work in progress inventory is high, then we potentially have a bottleneck in front of that point on time delivery is a good performance measure. And we would present that as a time series as we've seen in the previous example, to show the peaks and troughs and the range of performance. And finally, safety.

We might want to identify the points in the process, where risk is the highest key points then for analyze Using the data? Well, the time series chart gives us a way of understanding and improving business processes. And the spread of data, ie the range tells us how stable are processes. The wider the range, the less consistent the process. And the only way to reduce the range is to reconfigure the process. And interestingly, the cost of running a process is related to the spread of performance.

So the wider the range, the more inconsistent the cost of running the process will be. Because there's much more fluctuation, the closer together the range of data, that means the much more stable processes and therefore the more stable the cost of running the process will be. Where we see anomalies in the performance data, we may need to do some further analysis in order to identify the root cause of problems. For example, we may want to look at it by day of the week by shift and any other factors or characteristics that we can identify a pattern If data points also tells us stuff, for example, it can indicate any changes in the process itself. We should investigate any sudden troughs or peaks. See what was different, what occurred when those peaks or troughs happened so that we can start to isolate what's causing the issues.

Brian joiners quote from his book fourth generation management is the opposite here. Our ability to produce a rapid sustained improvement is tied directly to our ability to understand and interpret variation. And the key point here is that the wider the range of data, the less consistent the performance of the process and an inconsistent and variable process is much more likely to cause problems and also causes cost fluctuations. As I mentioned,

Sign Up

Share

Share with friends, get 20% off
Invite your friends to LearnDesk learning marketplace. For each purchase they make, you get 20% off (upto $10) on your next purchase.