Overview
This topic looks at alternative methods for adjusting basic statistical forecasts of demand to reflect the effects of special factors that may occur during the forecast period.
Adjustment Methods
Several methods exist in IFP for adjusting forecasts:
- Use of graphical editing tools in Statistical Forecasting.
- Manual editing of forecast files using IFP forecast editors.
- Use of forecast adjustment files in IFP.
- Import of forecast adjustments from Excel files.
Graphical Editing Tools
When applying a Statistical Forecast model for any item, a graph of calculated forecasts is displayed together with a toolbar that allows you to adjust forecast values using a set of graphical adjustment buttons. See Graphical Analysis of Results in Statistical Forecasting for details.
This approach to adjusting forecasts is quick and convenient for users, but no record is available for the amount of adjustment made for each period.
Manual Editing of Forecast Files
Forecasts may be adjusted using IFP Forecast Editors. See Demand/Sales Forecast Editing for details.
This approach does allow you to enter comments for each year for each item, but no automatic record is kept of the adjustments that you make to original forecast values.
Forecast Adjustment Files
Forecasts may be adjusted using IFP Forecast Adjustment Files. See Using Forecast Adjustment Files for details.
This approach does allow you to enter comments for each year for each item and a record is kept of the adjustments that you use.
Importing Forecast Adjustments from Excel Files
Forecasts may be adjusted using Forecast Adjustments stored in Excel files. See the attached example template, which contains separate sheets for each forecast year. If necessary, AJB will provide suitable field mappings for importing amounts from such templates.
This approach does allow you to enter comments for each year for each item and a record is kept of the adjustments that you use.
Comments
0 comments
Please sign in to leave a comment.