Create a Forecast
The next step is to create a forecast in Moselle to help plan our your inventory into the future
Last updated
The next step is to create a forecast in Moselle to help plan our your inventory into the future
Last updated
On the planning page, create a new scenario plan to begin your forecast. Scenario plans are independent forecast files that allow you to build different scenarios and automate your replenishment accordingly.
Click on the Create Plan button at the top right corner to begin the flow process. Enter a name for your planning page, then select a start date for your production plan from the date selector, and input a number for the number of months you want to plan ahead.
You have three options when it comes to generating projections for your scenario plan:
Upload a plan of your own.
Generate a Bottom-Up Forecast using one of our machine learning models.
Generate a Top-Down Forecast that converts your revenue forecast to a unit forecast.
A common approach in Moselle is to select one of our machine learning models to forecast the next 12 months, export it, make edits, and then upload it back. This allows you to build a 12-month forecast in a matter of minutes instead of days or weeks.
Choosing the Upload your Plan option will prompt you the following two steps:
Download a template of your sales data
Upload the file
Once you download the template, it will display all your items across your channels, along with the number of months you've included for forecasting.
In the template, input your projections for the forecasted months across all items and channels. Once finished, upload the completed file during the second step of the scenario plan creation process. Once uploaded, click on Next for view your planning page table with the projections you have uploaded.
On the scenario plan flow, select the Use AI Forecast Models button to reveal options for both Top down and Bottom up approaches. Select the Bottom up approach and the flow will list four forecase models that you can choose. Select one of the forecast models and click "Generate Forecast" to incorporate machine learning projections into the planning page table.
Under the View drop-down menu, you can select any of the available models to prefill a forecast in your scenario plan. You can always change and update your model to customize your forecast.
Once a model has been selected and you want to save this forecast into your scenario plan, select the Automate drop-down menu, and click Generate a Bottom-Up Forecast button. This will allow you to overwrite and save that forecast to your plan.
Only select "Generate a Bottom-Up Forecast" if you want to overwrite all projections on the scenario plan using the AI model, as this will remove any previous forecasts that were uploaded.
On the scenario plan flow, select the "Use AI Forecast Models" button to reveal options for both Top down and Bottom up approaches. Select the Top down approach and you will then be redirected to enter your sales goals.
Within your sales goals table, data will be organized by channel and the number of forecasted months you’ve entered. Input your sales goals directly into each cell, or copy and paste an entire row of gross sales into the table. After completing this step, click the "Generate Forecast" button to transform your gross sales into unit sales projections. The planning page table will automatically update to display the converted data.
Under the Automate drop-down menu, choose "Edit Top Down Targets" to enter your revenue forecast. You can enter your revenue forecast by clicking into a cell, or copying and pasting your revenue forecast from a spreadsheet into all the cells.
After entering your revenue forecast, click on the Automate drop-down menu and select the "Generate Top Down Unit Forecast" button to begin converting your revenue forecast into a unit forecast. Once the conversion is completed, click on "Go Back" to return to the planning page table and view your new unit forecast.
