Skip to main content

How can I adjust forecasts up or down for many items at once?

Updated

Whenever demand changes happen for large groups of your products, such as during the current COVID-19 pandemic, you need to adjust forecasts to account for this, to ensure your purchase suggestions are in line with the sudden changes in demand.

There are two methods you can use to adjust your forecasts up or down for large groups of items.   One way is relatively manual, the other way is more automated within the application.

Method 1: (Automated Adjustments) Edit Customer Forecasts 

The Edit Customer Forecasts dialog will allow you to make similar changes across a wide selection of items, such as reducing all forecasts for certain groups of items by 25%, only matching certain filters, without implementing a top-down forecasting approach.

For more information, see the Edit Customer Forecasts help topic.

 

Method 2: (Manual Adjustments)Forecast Analysis & Forecast Import

You can combine the Forecast Analysis tool and the Import Forecasts tool to make broad adjustments to your forecasts:

  1. Load the Forecast Analysis by going to Forecast --> Forecast Analysis
  2. Select the Item-Site-Forecast Group tab
  3. Use the filters button to filter down based on criteria for items you want to change:
    1. Example: as only items with order policies that use forecast in their replenishment (e.g. Lot for Lot, Order Point),
    2. Example: A/B/C items only, etc.  This will be business-dependent. 
    3. Example: Filter dates to only the next six months
    4. Click Apply when you are done setting your filters.
  4. Use the Export icon to export the results from your grid.
  5. Further modify the spreadsheet according to your wishes, e.g. reduce all forecasts by 25%
  6. Adjust columns in the export to match those required by the Import Forecast template and save
  7. Open the Import Forecasts screen
  8. Set your forecast import options:
    1. Upload at the Forecast Group Level
    2. Set the Auto Forecast to "Restart On Last Date Found" in your spreadsheet so that auto-forecasting will resume.
    3. Select the "Enable Statistical Forecast After Auto-Start Date" option
  9. Upload your forecasts.  Correct any errors in your document.  The forecasts will be available immediately in StockIQ, and will immediately adjust your replenishment plans

Related articles