Forecast Performance Report

Measure how accurate your projections are by comparing forecasts with actual sales results. Spot where you're on track and where adjustments are needed.

Demand Forecast Performance Report

Measure how accurate your projections are by comparing forecasts with actual sales results. Spot where you're on track and where adjustments are needed.

Access the Report

1. Click Reports from the menu

2. Select Forecast Performance

The report displays a bar graph comparing projections to actuals, with a detailed pivot table below.

Set Report Parameters

Configure the report view using filters at the top:

Date Filter Select your date range with preset options (Next 30 Days, Next 3 Months) or choose custom start and end dates from the calendar. Click Apply to update the report.

Units Sold / Gross Sales Toggle between:

• Units Sold - View sales in units

• Gross Sales - View sales in dollars

Forecast Plan Select a forecast plan from the dropdown to view performance specific to that plan.

Performance Graph

The bar graph displays monthly actuals vs projections:

• Orange Bars - Actual sales

• Green Bars - Projected sales

Compare performance at a glance across the selected time period.

Performance Table

Below the graph, the detailed table shows all metrics with customizable columns and filters.

Customize Table View

Columns

Click Columns on the far right of the table to customize your view.

Toggle columns on or off:

Column	Description
Archived	Show archived products
Category	Product category
Channel	Sales channel
Gross Sales	Total revenue (actual)
Gross Revenue (Projected)	Projected revenue
Month	Time period
Name	Product name
% of Total	Percentage of total sales
Product Line	Product line grouping
Product Type	Type of product
SKU	Product SKU
Units Sold	Number of units sold
APE	Absolute Percentage Error for forecast accuracy

Row Groups: Drag and drop columns to reorder table grouping. Click the X button to remove a column from grouping.

Filters

Click Filters on the far right to refine table data.

Filter by:

• Archived

• Category

• Channel

• Month

• Name

• Product Line

• Product Type

• SKU

Click the chevron arrow beside any filter option to expand and select specific values. Use the search bar above each list to quickly find items.

Understanding APE and MAPE

APE (Absolute Percentage Error) Measures forecast accuracy for a single month. Shows the difference between projected and actual sales as a percentage.

MAPE (Mean Absolute Percentage Error) Measures forecast accuracy over multiple months. Provides an average accuracy score across the selected time period.

Accuracy Guidelines

Performance Level	MAPE Range	Interpretation
Good	20% or lower	High accuracy - forecast is reliable
Fair	21% - 50%	Reasonable accuracy - minor adjustments needed
Poor	51% or higher	Low accuracy - forecast needs significant revision

Lower percentages indicate better forecast accuracy.

Current Month Calculation

Moselle recalculates the current month based on projections and applies proration for remaining days.

Example:

• February projection: 1,000 units

• Actual sales by Feb 15: 100 units

• Days remaining: 13 days

Calculation:

1. 1,000 ÷ 28 days = 35.7 units per day

2. 35.7 × 13 remaining days = 464 units projected

3. Current inventory - 464 = ending inventory for February

As the month progresses, the prorated amount decreases until only actuals remain.

If actual sales significantly underperform (e.g., 200 units vs 1,000 projected), the APE will be high, indicating the need for a revised forecast with adjusted targets.