Procurement Process - What is the definition of change rate and rework rate?


#1

Hi there, what is the exact calcuation of Change rate and rework rate in the process Cockpit? Thanks, Daniela


#3

Hi Daniela,

Change KPI
All Changes of Original Process Document Information. Updates in Status or Meta Information are no Changes.

Impact: Changes can be necessary, but should be minimized in the process.

Business Case: Minimize Changes. Calculation by FTE Reduction.

PQL Example:

100.0*AVG(
CASE WHEN PU_COUNT(
        "purchase_order_lines","_CEL_COUPA_P2P_ACTIVITIES"."ACTIVITY_<%= language %>",
        "_CEL_COUPA_P2P_ACTIVITIES"."CHANGED_FIELD" IN (<%=ChangedFields%>)
         ) > 0
THEN
    1.0
ELSE
    0.0
END)

Rework KPI
All Activities in a process which are executed more than once.

Impact: All Rework should be avoided in general

Business Case: Duration for each activity done beyond the first.

Hint: If a change is executed more than once it also counts as rework.

PQL Example
100.0*AVG(

CASE WHEN PU_COUNT("EKPO","_CEL_P2P_ACTIVITIES"."ACTIVITY_<%= language %>" ) - PU_COUNT_DISTINCT("EKPO","_CEL_P2P_ACTIVITIES"."ACTIVITY_<%= language %>" ) > 0
    THEN
        1.0
    ELSE
        0.0
END
 
)

Best,
Hugo


#4

Great Thanks :smile: