Editing Forecast ASPs

Overview

Maintenance of forecast ASPs may be achieved by any of the following methods:

• Copying previous forecast ASPs for any year into the relevant target file via Data File manager or
• Importing ASPs from external databases (e.g. Excel files)
• Applying pricing models that use assumptions on gross prices, discounts, taxes, etc
• Editing ASPs manually

Editing ASPs Manually

To edit ASPs in one or more target files, select Forecasting > Standard Actual/Forecast Editor. It is important to select Data to be Amended = ASP and Data to be Entered = ASP

Since ASPs may vary from one item code to another, it is important to edit ASPs at item code level. Sub-totals usually have little practical value for ASPs, hence you are advised to avoid sub-totals by selecting levels of detail Item Code + Grand Total.

Editor

Forecast ASPs are normally constant over several months. Hence the easiest way to enter ASPs is to select a range of cells that should have the same ASP, type the ASP required and press enter. This avoids having to enter the same ASP many times.

Applying Price Increases

Forecast price increases are normally of a percentage nature, hence the easiest way to apply price increases is to select the relevant period for all relevant items and use Data > Apply Calculations > Apply Percentage Change.

Using YTD Average ASPs

When forecast ASPs for the current year it is often useful to set initial ASPs for the forecast period by rolling forward the average YTD actual ASP. This is achieved by selecting the forecast period only and using Data > Apply Calculations > Apply Roll Forward Average Percentage with a percentage increase value of zero.