Vendor analysis data
You can determine which vendor to use for an item. Information about vendors is calculated from the past performance of the vendor for the selected item. When you review vendor analysis data, you can select a primary vendor for an item. You can also choose the storerooms that use the primary vendor when ordering an item.
The following table provides a description of the values in the fields. All values are for a selected item, for a selected vendor, and where the manufacturer, model number, and catalog numbers are the same.
Field | Data calculation |
---|---|
Promised Lead Time (Days) | The promised delivery time (lead time) for this item from the vendor. |
Last Delivery Time | The amount of elapsed time, in days, between the purchase order date and the date of receipt for the most recent order of this item and vendor combination. |
Average Delivery Time | The average amount of elapsed time between the order dates and the dates of receipt. This value is calculated by dividing the total of all the delivery times by the total number of purchase order lines for this item and vendor combination. |
Percent on Time | The percentage of receipts, where the date of receipt was on or before the delivery date for the vendor. This value is calculated by dividing the number of on-time receipts by the total number of receipts for this item and vendor combination. |
Total # of Complete POs | The number of completed purchase orders where item, vendor, manufacturer, model number, and catalog number match this record. |
Quantity Received | The total number of order units received for this item and vendor combination. |
Quantity Received YTD | The total number of order units received since the beginning of the current calendar year for this item and vendor combination. |
Quantity Rejected | The total number of order units rejected for this item and vendor combination. |
Quantity Rejected YTD | The total number of order units rejected since the beginning of the current calendar year for this item and vendor combination. |
Percent Rejected | The percentage of order units rejected for this item and vendor combination. This value is calculated by dividing the amount rejected by the total of all received and rejected order units for this item and vendor combination. |
Percent Rejected YTD | The percentage of order units rejected since the beginning of the current calendar year for this item and vendor combination. This value is calculated by dividing the amount rejected by the total of all received and rejected order units for this item and vendor combination since the beginning of the calendar year. |