Follow

How to Change Pareto Forecast Distribution Percentage by Uploading

The forecast distribution percentage is an important value in DemandCaster. It sets the distribution percentage from an aggregate level down to the item and vice versa when forecasting and editing demand plan values.

It is of particular importance when forecasting items that are size based such as apparel.

Click on Excel

Two options are available:

  1. Current Level: Downloads only the current level
  2. All Levels Below: Downloads all the way to the item level
Click on Excel

Edit Values

In the example below, we will be editing the user defined pareto values.

Edit Values

Update the File

  1. Delete the column System Percentage (column H)
  2. Enter "1" in the "Is User Defined" column for all the rows to be changed to a user defined value.
  3. If you wish to zero out certain rows or set a specific percentage, enter the percentage in column F. This will set the Forecast Distribution to the value entered. All other values will be auto calculated so that the entire cumulative percentage is 100.
  4. You may also delete all the rows that will not be changed and change the remainder to 1 in column G.

NOTE: For values that were previously updated with a user defined value, you may revert to the statistical value by changing the previously entered 1 in the last column to 0.

Update the File

Save the File and Compress

  1. Once the values are entered, save as a tab delimited text file named sopparetodistribution.txt
  2. Compress the file.
Save the File and Compress

Upload

  1. Go to Data Upload page and click on Select
  2. Select the zipped file.
Upload

Click Upload to Upload

Click Upload to Upload

Values are Updated

  1. Once the upload completes, the Forecast Distribution values are updated and change to red to reflect the requirements set in the spreadsheet.
  2. The values set to 0 in the spreadsheet are also 0 in the Forecast Distribution on the page.
  3. You may manually tweak the values on the page by clicking on the edit button in the Forecast Distribution column header.
Values are Updated
Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments

Powered by Zendesk