Forecast Performance
See how you can compare sales projections to actuals across all your channels and product lines.
Last updated
Was this helpful?
See how you can compare sales projections to actuals across all your channels and product lines.
Last updated
Was this helpful?
To access your forecast performance report, click on the "Reports" tab and select "Forecast Performance."
In this report, you can compare your sales projections to your actuals. View how they compare from the bar graph and the pivot table below it.
At the top of the report, you can select a variety of settings to change the outlook of your forecast performance report. Select the date filter dropdown to change the date range of your report.
You can also switch between "Units Sold" and "Gross Sales" from the second drop-down menu to change the outlook of your graph.
The third dropdown lets you choose between the scenario plans that you have created. This will change the outlook of your report depending on the forecast you have uploaded to that scenario plan.
The channel drop-down allows you to compare your channels in Moselle and view them side by side. Analyze how each channel performs against one another between your actual and projected sales.
The acronym APE stands for Absolute Percentage Errorβa straightforward metric that reflects the accuracy of your projections for forecast vs actuals accuracy for a single month
The acronym MAPE stands for Mean Absolute Percentage Error - which is the forecast vs actuals accuracy over multiple of months.
A good projection should have a performance of 20% or lower, indicating high accuracy in forecasting. The lower the number, the greater the accuracy.
A fair projection demonstrates a performance between 21% and 50%, signifying reasonable forecasting accuracy.
A poor projection has a performance of 51% or higher, indicating the need for an updated forecast to enhance its accuracy. We are constantly recalculating the current month based on what you projected and apply a proration calculation based on the days remaining.
Example:
Let's say February you actually sold 100 units but you projected 1000 and it's February 15th.
We'll show a ending balance of of inventory less 464 from current inventory on Feb 15th
1000 / 28 days = 35.7 units per day
35.7 * 13 days remaining in Feb = 464
Current inventory on Feb 15th minus 464 = ending inventory for Feb
As the days get closer and closer to end of Feb the prorated amount gets smaller and smaller until it is all actuals. But if you only sold let's says 200 versus the 1000 you projected the APE will be high and we should make a new forecast with a lower revenue target.