You use this program to compare current forecasts with draft forecasts, enabling you to check the reasonableness of newly-generated draft forecasts.
| Field | Value | Description |
|---|---|---|
| Selection set | ||
| Use selection set | Select this to use a pre-defined set of parameters that
were created using the Selection Set Maintenance
program. When you use a selection set, no other Report Options or Selections can be indicated, because these options will already have been indicated against the selection set (see Selection Set Maintenance). |
|
| Set to use | Indicate the name of the pre-defined set of forecast options you want to use for the report. | |
| Include part type | Indicate the part types (as defined against each stock item) to include in the report. | |
| Include manually forecast items | Indicate how manually forecasted items must be treated for the report. | |
| Include replenishment items | Indicate how replenishment items must be treated for the report. | |
| Include Pareto Classification | This enables you to include/exclude items based on their
Pareto classification. You use the Pareto Analysis
program to analyse and classify inventory items. At least one of these options must be selected. |
|
| Analysis type |
Indicate what the Pareto classification, for the inclusion of stock items, must be based on. This can be Sales, Current forecasts or Draft forecasts. Once you have selected an analysis type, you can select the Pareto level at which the analysis must be performed. For example, if you select Sales and Stock code, then the Pareto classification of items used for inclusion purposes will be retrieved based on sales at the stock code level. |
|
| Sales | Select this to perform the analysis based on sales. | |
| Current forecasts | Select this to perform the analysis based on current forecasts. | |
| Draft forecasts | Select this to perform the analysis based on draft forecasts. | |
| Pareto level |
Indicate the level at which the Pareto analysis must be performed. |
|
| Include MPS items | Indicate how master production schedule items must be treated for the report. | |
| Include MTO items | Indicate how made to order items must be treated for the report. | |
| Calendar to use for comparison | ||
| Calendar | Indicate the forecast calendar to use for the report. This defaults to the calendar defined in the Inventory Optimization Setup program. |
| Field | Description |
|---|---|
| Warehouse selection | Indicate the warehouse(s) to include in the report. |
| Stock code selection |
Indicate a selective range of stock codes that you want to include for the list of forecasts. Stock items defined as Notional parts (Stock Code Maintenance - Stock Code Details) are ignored by the Forecast Comparison program. |
| Supplier selection | Indicate the supplier(s) to include in the report. |
| Product class selection | Indicate the product class(es) to include in the report. |
| Planner selection | Indicate the planner(s) to include in the report. |
| Buyer selection | Indicate the buyer(s) to include in the report. |
These options enable you to apply a theme to the report and to define multiple output destinations for the report once it has been compiled (SRS Output Options).
The report is summarized by Pareto class and outputs forecast information (depending on classes selected for inclusion) for: Classification A, B, C, D, E, Unclassified and All class totals.
All figures are accumulated into the forecast periods (as defined by the selected calendar) within the classes.
The following columns are listed:
| Column | Description |
|---|---|
| Period | This indicates the forecasting period. |
| Current | |
| Cost | This indicates the cost value of current forecasts, calculated using current inventory costs. |
| Selling | This indicates the selling value of current forecasts, calculated using list prices. |
| Gross Profit | This indicates the gross profit based on the calculated cost and selling values. |
| Draft | |
| Cost | This indicates the cost value of draft forecasts, calculated using current inventory costs. |
| Selling | This indicates the selling value of draft forecasts, calculated using list prices. |
| Gross Profit | This indicates the gross profit based on the calculated cost and selling values. |
| Difference | |
| Cost | This indicates the difference between the cost value of draft forecasts and the cost value of current forecasts. |
| Selling | This indicates the difference between the selling value of draft forecast and the selling value of current forecasts. |
| Gross Profit | This indicates the difference between the gross profit of draft forecasts and the gross profit of current forecasts. |