Procurement Scorecard for Excel

"A great way to control the performance of Delivery"

The process of Procurement essentially revolves around ‘ensuring that the inputs moving into the organizational processes’ that conform to certain quality standards in a timely manner. Pulling together these aspects creates enough ‘dilemmatic’ situations for the management group to get caught. However, one can come out from this network of ‘cross-roads’ by opting for a ‘KPI (Key Performance Indicators) based approach. The various aspects that can be of use are- Financial Perspective, Process Perspective, Internal Operations and Performance Perspective.
The metrics for Financial Perspective are- ‘Procurement Expense: Sales’; ‘Percentage increase in revenue on ‘per customer basis’’; ‘average discount size availed’ and ‘rise in cost savings level’.
Process perspective can be evaluated using parameters such as- Number of Alliances with Suppliers, Logistics’ system Grading, Inventory Control Increase and Manufacturing Cycle Improvement.
Internal Operations can be had with indicators like ‘average procurement time overruns’, ‘Procurement Policy Compliance’, ‘Degree of merging with other systems’ and ‘Technological Stand’.
Performance Perspective can be calculated with metrics like- ‘Wastage Drop’, ‘Timelines Deviation’, ‘‘Below Benchmark Quality’ Decline Ratio’ and ‘Stock-out instances Dilution’.