Procurement Analysis
The purpose of the Procurement Analysis model is to analyze a broad set of data for purchase order processing and the company’s suppliers. The data that is needed to analyze procurement performance is captured throughout the procurement process. The process steps include purchase order entry, purchase order confirmation, goods receipt, quality inspection, and invoice matching.
The analysis covers these topics:
- Delivery time accuracy
- Order-line and quantity-based fill rate
- Quality of delivered products
- Monetary measures, for example, ordered values and prices versus invoiced prices and values
You can gain various insights about the procurement process by adding different types of dimensions, suppliers, purchased items, and the buying organization. The facts in this model can be analyzed by these dates:
- Order Date
- Requested Delivery Date
- Confirmed Delivery Date
- Actual Delivery Date
- Invoice Date
Source information
The main source for the model is the Purchase Statistics table (MPURST). It contains the basic statistics for measuring purchasing and supplier performance. Additional date, time, and price information are fetched from the purchase order line table (MPLINE). Actual delivery date and time are retrieved from the Stock Transactions table (MITTRA). The model is populated by several scripted sources, combining details from MPURST and delivered/invoiced purchase order lines from MPLINE, and delivery date and time information from MITTRA.