Vendor Fill Rate Summary Dashboard

Use the fill rate summary dashboard to view overall summary of the supplier performance, focusing on order fulfilment and delivery timelines.

The dashboard is used to improve decision-making, reduce operational overhead, and provide transparency into supplier compliance, enabling proactive management of procurement risks.

These are the filters in this dashboard:

  • Entity
  • Site
  • Warehouse
  • Year
  • Year/Month
  • Vendor
  • Buyer
  • Buyer Name
  • Purchase Order
  • Purchase Order Date
  • Product Code
  • Purchase Order Status
  • Purchase Order Type

The data in the vendor fill rate summary dashboard is grouped using two selectors. You can select a value in the PO Group By 1 option to define the first level grouping and then select a value in the PO Group By 2 option to perform a second level grouping within each group of the first level.

These are the possible values for the PO Group By 1option:

  • Site
  • Warehouse
  • Buyer
  • Vendor
  • Status
  • Product Code
  • Vendor Category

These are the possible values for the PO Group By 2 option:

  • Site
  • Warehouse
  • Buyer
  • Vendor
  • Status
  • Product Code
  • Vendor Category
  • Purchase Order
  • Purchase Order Line

These columns are displayed in the fill rate summary dashboard:

Number of Orders
The number of purchase orders created in the selected time period.
The value is calculated using this formula: Count (Purchase Orders)
Number of Ship Complete Orders
The number of purchase orders where the quantity of items are received for each lines of purchase order.
The value is calculated using this formula: Count (Purchase Orders where qty received >= qty ordered)
Fill Rate Order
The percentage of purchase orders for which all the ordered items are received.
The value is calculated using this formula: Count (Purchase Order lines fully received for a purchase order)
Number of On Time Orders
The Number of purchase orders delivered on or before the due date.
The value is calculated using this formula: Count (Purchase Orders where receipt date <= due date)
Number of On Time Orders Two Days
The Number of purchase orders delivered within two days after the due date.
The value is calculated using this formula: Count (Purchase Orders where receipt date <= due date + two days)
Number of On Time Orders Five Days
The Number of purchase orders delivered within five days after the due date.The value is calculated using this formula: Count (Purchase Orders where receipt date <= due date + five days)
Percentage of On Time Orders
The percentage of purchase orders delivered on or before the due date.
The value is calculated using this formula: (Number of purchase orders where receipt date <= due date / Total purchase order lines) * 100
Percentage of On Time Orders Two Days
The percentage of purchase orders delivered within two days after the due date.
The value is calculated using this formula: (Number of purchase orders where receipt date <= due date + two days / Total purchase order lines) * 100
Percentage of On Time Orders Five Days
The percentage of purchase orders delivered within five days after the due date.
The value is calculated using this formula: (Number of purchase orders where receipt date <= due date + five days / Total purchase order lines) * 100