This article will describe the steps to upload a demand plan as opposed to editing directly in DemandCaster. This method is only applicable in the S&OP Platform.
This article focus specifically on the upload process and not the approach described in the article Downloading, Editing, and Re-Uploading a Demand Plan.
Please note that DemandCaster will not process the user defined forecast file if the demand plan or pricing columns are not correctly configured and when there are nodes which are not assigned to a parent node. In theses cases, the errors need to be addressed and file re-uploaded for the changes to be applied.
Prepare the demand plan upload (item level demand plan)
- Only upload the context item demand plans that you would like to change.
- If you wish to not change a period, leave the period blank in the file. Making the value 0 in a period will change the demand plan or price to 0.
- Cell A2 can be named whatever "customer" name is assigned in the field.
- Cell A1 will determine the level the forecast will be uploaded which in the example below is the item.
- The customer code and item code followed by the unit plan by weeks or months and then unit price by weeks or months will follow.
- The unit upload date header must be the date period followed by "-unit" i.e. 8/1/2017-unit. The date format will follow your companies date format (U.S. or European)
- The price upload date header must be the date period followed by "-price" i.e. 8/1/2017-price. The date format will follow your companies date format (U.S. or European)
- Pricing may be uploaded above the item level as an average price.
- Whatever your planning bucket is set at is the bucket you upload. Upload months, if your demand planning process is in months, weeks if your demand planning process is weeks. If in weeks make sure it follows your week start day i.e. Sunday or Monday.
- Make sure there are no empty columns being saved in your excel. At times excel may add invisible columns and rows that are saved in the text file. These will cause errors in the upload. If you run into this issue, we recommend moving the data to a clean spreadsheet prior to saving as a text file particularly when using a downloaded files as the basis of your data.
- You may also enter new customer/item demand plans that do not currently exist. These will be automatically created as part of the upload.
The upload file at the item level should look like the image below.
Upload the zipped file
Uploading to a Level Between Customers and Items (i.e. product category)
As stated in the Upload Planning Hierarchy article, the hierarchy is a top down build. As a result, the upload above the item level follows a top down approach as well.
In the example above, we are loading a demand plan to a level named "style" to a customer. In this case, the style is in column A and Customer is in column B.. Cell A-1 will call out the level in which the forecast is being applied - which, in this example, is Style.
Please remember that the uploaded file must be a zipped tab delimited text file named userdefinedsopforecast.txt
Uploading to Customer Level
When uploading to the customer level, there is a minor change.
- When uploading to customer level, cell A-1 will have to be filled with “customer” (regardless if the customer level is renamed).
- The the first column is the customer code, and the other columns contain the forecast of the customer. There is no lower level in this case.
- Levels above the customer are named the level name in both cell A-1 and A-2.
- When uploading to levels above the item level, the pricing should be removed from the upload file since pricing is only applied at the item level.
- Follow steps above to save and upload.
- Please remember that the uploaded file must be a zipped tab delimited text file named userdefinedsopforecast.txt
Uploading total demand forecasts
In some cases, a user may wish to plan demand based on items total demand as opposed to be customer. If this is the case, the customer needs to be grouped as "other" per the article S&OP Pareto Process. Thereafter, when uploading a demand plan, replace the customer number with the word "other" per the image below and follow the steps to upload the file as defined above.
DemandCaster flags the periods that are overwritten with a user defined value and the change log makes an entry named 'UDF Change Uploaded'. The upload also logs an error if the upload tries to edit a forecast with forecast flag disabled.