Procurement Analysis

The Procurement Analysis model analyzes a broad set of data for purchase order processing and the company’s suppliers. The data needed to analyze procurement performance are 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

Various insights about the procurement process can be gained by adding different types of dimensions, suppliers, purchased items, and the buying organization. The facts in this model can be analyzed by these dates: invoice date, confirmed delivery date, order date, requested delivery date, and actual delivery date.

Source information

The main source for the model is the Purchase Statistics table (MPURST). It contains all the basic statistics for measuring purchasing performance. Additional measures are fetched from the purchase order line table (MPLINE).

If the order line is quality inspected, it updates the approved and rejected quantities.

Note: An order line is not automatically regarded as approved unless the quality-inspection routine is used.