Hey, i recently tried TryCelonis and I was wondering what the percentage (KPI) related to the activities in accordance to on-time-delivery actually means. In the Talk Track, Celonis says, it effects the OTD-Rate by 62% e.g. How do they know?

Dear Tom,

The Text Story explains it:

"One activity that stands out is “Vehicle Blocked”. The impact of this activity becomes clear when looking at the chart “Impact on OTD”: Blocked vehicles result in a lower OTD of 62%. This happens for 2.721 vehicles."

Your first thoughts are right on this. This means that the OTD rate in those cases that flows through "Vehicles Blocked" activity is 62%. They look at 2.721 cases that flow through the activity "Vehicles Blocked" and only 62% of those cases are "on-time". This has an impact because you know that the overall OTD rate is 72%, so they flag this activity as a negative impact on OTD rate.

Calculation-wise it is something like this:

• Flag those cases that contains "Vehicles Blocked" activity (this is the base pool, 100%)
• Compare the actual delivery date with the expected delivery date (based on contracts or policy). If the actual date of delivery is sooner than the expected delivery date, it is on-time. Flag it with 1. If actual delivery date is later than the expected, it is flagged an not on-time, so flag it with 0.
• Count the cases that are flagged as "1" and divide it by the total cases that flows through "Vehicles Blocked".

In this case, 62% of the 2.721 cases are on-time delivered. In 38% of those cases with "Vehicles Blocked", they deliver late.

Hope this explains it, or if you have a more specific question, feel free to ask.

Yours,

Zsolt Borbély

Merci Zsolt,

as you mentioned I figured so as well. I am still a bit confused by the wording, because "Impact" or his they called. But with your explanation it becomes more clear. Thanks a lot!