Sales Forecasting

The Sales forecasting functionality allows you to plan demand for products over a defined future period. It combines AI-assisted forecast generation with manual input, providing a flexible tool for demand planning.

The functionality allows:

  • Creating AI-assisted demand forecasts for products based on historical customer order data.
  • Reviewing forecast data grouped by configurable time periods.
  • Comparing forecasted quantities with previous periods and previous year values.
  • Linking forecasts to the Master Production Schedule (MPS) for production and procurement planning.

User Manual: https://www.mrpeasy.com/resources/user-manual/crm/sales-forecasting/

See more videos

Transcript:

Hello and welcome to MRPeasy!

Let’s take a few minutes to explore how a manufacturing company plans product demand using sales forecasting.

Based on your sales history, MRPeasy will help you forecast your future sales.

To create a new forecast, we go to the CRM module and open the Sales Forecasting tab.

Here, we can see all existing forecasts. We can open one, or create a new one.

Let’s create a new forecast. It only takes two steps.

First, we give it a name, choose the starting month, and set the forecast horizon.

Next, we select the product we want to forecast.

Now we’re in the forecast view.

The AI forecast starts running automatically.

Once it’s ready, the system fills in the predicted values.

At the top, we can see key details like the forecast number, name, period, and when it was created and last updated.

The overview section helps us quickly understand trends by showing aggregated data.

The chart gives us a clear visual of both historical sales and forecasted demand. For our product — ice cream – we can already see a strong seasonal pattern, with demand rising in summer and dropping in winter.

We can always add more products to the forecast. Any new items are automatically included in the AI forecasting.

We can also switch between products using the dropdown in the overview section.

Sometimes, AI predictions need a human touch.

Here, we’re looking at a forecast for school backpacks. The AI has identified general demand fluctuations, but the pattern is too broad.

In reality, we know that sales are highly seasonal, with a sharp peak in July and August, just before the school year starts.

So, we step in and adjust the forecast manually to reflect this real-world behavior.

The forecast input table makes this easy, allowing us to quickly fine-tune values and ensure the forecast matches business expectations.

To enable Sales Forecasting, go to Settings → System Settings → Enterprise Functions and activate the Sales Forecasting feature.

If Master Production Scheduling is enabled, you can link the sales forecast to it. This ensures that production and procurement are aligned with expected demand.

For a better understanding of how Master Production Scheduling works, please refer to our dedicated video.

Sales forecasting is based on historical sales data in your MRPeasy account, which means it has some limitations.

If your data covers less than two years, the AI can identify the overall trend, but may not fully capture seasonal patterns, neither is it aware of industry trends or any other events.

In this case, you can adjust the forecast manually to reflect known demand cycles.

If the available history is less than three months, automatic forecasting is not possible. However, you can still enter forecast values manually.

In this video, we explored how sales forecasting combines AI-driven predictions with manual adjustments. This provides a powerful and flexible way to plan demand and support production decisions.

Thanks for watching!

We use cookies to enhance your experience on our website. If you continue using this website, we assume that you agree with these. Agree Learn more Ok