SBS KPIs Dashboard - Purchasing

Process Effectiveness

YTD only

Using ponderation as 75% for payment on time and late posting as 25%.

YTD Average based on monthly index

Exemple for Jan 2019 to Sep 2019: 1.81

Index for Sep 2019 : 2.25

Payment on Time (Volume) Sep 2019 : 90%

Late Posting Sep 2019 : 4.7%

We can see that :

90% Payment on Time will fall under the score of 2

4.7% late posting will have score of 3

With that, the result will be (2 x 75%) + (3 x 25%) = 1.5 + 0.75 = 2.25

Process Conformity

YTD only

Using ponderation as 40% for buying channel, 30% invoicing (3 ways match), 15% late invoices and 15% non conform PReq.

YTD Average based on monthly index

Exemple for Jan 2019 to Sep 2019: 3.58

Index for Sep 2019 : 3.85

Buying Channel - 66%

Invoicing (3 ways match) - 65%

Late invoices - 13%

Non conform PReq - 2.7%

We can see that :

66% Buying Channel falls under the score of 4

64.5% Invoicing (3 ways match) have score of 4

13% Late invoices have score of 2

2.7% Non conform PReq have score of 5

With that, the result will be (4 x 40%) + (4 x 30%) + (2 x 15%) + (5 x 15%) = 1.6 + 1.2 + 0.3 + 0.75 = 3.85

Process Productivity

YTD only

Using ponderation as 60% for invoice per FTE and 40% PO per FTE.

YTD Average based on monthly index

Exemple for Jan 2019 to Sep 2019: 2.91

Index for Sep 2019 : 2.6

Invoice/FTE - 884

PO/FTE - 332

We can see that

• number of invoice/FTE 884 falls under the score of 3

Figures for 1 month :

• number of PO/FTE 332 has score of 2

Figures for 1 month :

With that, the result will be (3 x 60%) + (2 x 40%) =1.8 + 0.8 =2.6