# Demand Forecast Performance

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


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://learn.moselle.io/analytics/reporting/moselle-reports/performance-reports/demand-forecast-performance.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.