Customer/Supplier Scheduled Order Comparisons
You can use a new Use Supplier Schedule Comparative Extract (.NET UI only) to view multiple supplier schedule releases simultaneously and analyze supplier schedule release fluctuations. Likewise, you can use Schedule Comparison Extract to view multiple releases simultaneously and analyze customer schedule release fluctuations.
Supplier Schedule Comparison Extract
When you run Supplier Schedule Comparison Extract, you can use the data to compare schedule releases for all items on supplier scheduled orders, including:
• Standard supplier schedule releases (type 4)
• Supplier shipping schedule releases (type 6)
• Supplier planning schedule releases (type 5)
When you extract supplier release information, the system compares multiple supplier schedule order releases. The system calculates the following per date:
• Average requirement quantity (the sum of quantity per date / number of releases)
• Maximum requirement quantity
• Minimum requirement quantity
• Variance % between minimum quantity and maximum quantity
• Actual receipt quantity
The comparison provides visibility to multiple release data as well as spreadsheet or Web documentation for supplier interaction when examining, for example, additional expenses.
The system displays the data in:
• Daily buckets for shipping schedules (type 6)
• Weekly buckets for planning schedule (type 5)
Schedule bucketing parameters—schedule days, weeks, or months—from the scheduled order line (type 4) for planning and shipping output reports.
You can set various reporting criteria to gain visibility over widespread or specific information sent from suppliers. For example, you can set the number of supplier plan or ship schedule releases to be compared and set the variance percentage that displays between the first and last supplier schedule release.
Schedule Comparison Extract
When you run Schedule Comparison Extract, you can extract customer release information. The system compares multiple customer schedule order releases. The system calculates the following per date:
• Average requirement quantity (sum of quantity per date/ number of releases)
• Minimum requirement quantity
• Maximum requirement quantity
• Variance % between minimum requirement and maximum requirement
• Actual shipped quantity
The comparison provides visibility to multiple release data as well as spreadsheet or Web documentation for customer interaction when examining, for example, additional expenses.
The system displays the data in
• Daily buckets for shipping schedules
• Weekly buckets for planning schedules
You can set various reporting criteria to gain visibility over widespread or specific information received from the customer. For example, you can set the number of customer plan or ship schedule releases to be compared and set the variance percentage that displays between the first and last customer schedule release. The report displays the:
• Total ship quantity by item/date
• Requirement averages per date
• Minimum/maximum requirement per date
• Total variance % between the minimum and maximum schedule release for the same day
Note: You can modify settings to display only rows of the data that are of interest to you.