Procurement
- 21 Jun 2022
- 1 Minute to read
- Contributors
- Print
- DarkLight
Procurement
- Updated on 21 Jun 2022
- 1 Minute to read
- Contributors
- Print
- DarkLight
Article summary
Did you find this summary helpful?
Thank you for your feedback
The Procurement dashboard helps identify the performance of suppliers and product sourcing. It helps monitor purchasing spend, cost trends and suppliers delivery performance.
Video Demonstration
The following metrics are aimed at evaluating procurement and can be obtained from Owl platform.
| Metrics | Definition | Calculation |
|---|---|---|
| Cost Received (CAD) | Total cost received (CAD) | = [Total_Usr_Recd_Qty] * [Unit_Price] * [Sell_Rate]) |
| # Suppliers | Number of vendors/suppliers that have issued a purchase order | = COUNT [Suppliers] |
| # Parts | Number of materials purchased | = COUNT [Part_Id] |
| # PO | Number of purchase orders | = COUNT [Purcahse_Order_Id] |
| # POLines | Number of purchase orders lines | = COUNT [POLine_Key] |
| % Avg InFull | Average percentage of purchase orders lines delivered in full compared with total purchase orders lines | = DIVIDE ([# POLines InFull] , [# POLines]) |
| % Avg OTIF | Average percentage of purchase orders lines delivered on time in full compared with total purchase orders lines. | = DIVIDE ([# POLines OTIF] , [# POLines]) |
| % MTD InFull | Average percentage of purchase orders in full last month. | = CALCULATE ([% Avg InFull] , DATESMTD( [Last_Received_Date])) |
| % MTD OTIF | Average percentage of purchase orders on time in full last month | = CALCULATE ([% Avg OTIF] , DATESMTD( [Last_Received_Date])) |
