Create a Forecast

The next step is to create a forecast in Moselle to help plan our your inventory into the future

Create a Scenario Plan

Click on the Forecast selection from the left side menu. On this page, you can 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. Moselle's Lightning Forecast will help guide you into generating a bottoms-up or top-down forecast. Follow along and complete each step to generate your first forecast.

Create a Scenario Plan

Generate projections for your Scenario Plan

You have three options when it comes to generating projections for your scenario plan:

  1. Upload a plan of your own.

  2. Generate a Bottom-Up Forecast using one of our machine learning models.

  3. 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.

Upload a Plan

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.

Generate a Bottom-Up Forecast

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 forecast 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.

Generate Machine Learning Models

Learn more about what each machine learning models mean.

Generate a Top-Down Model

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.

Top Down Forecast

Last updated

Was this helpful?