Forecast Analysis
The Forecast Analysis dashboard is designed to help you analyze the following:
• The over or under forecasting of critical Segments, Parts, and Locations
• The forecast error by understanding the tracking signal trend and accuracy trend over time
• The trend of the Forecast Method counts and Forecast adjustments
This dashboard can help you answer business questions such as:
• What is the count and % of under and over forecasted SKU Streams?
• What are the top-most over or under forecasted Locations or Part Types?
• Which Forecast Method or Parameter contributed to over and under forecasting?
• What is the comparison of overall trend of demand and forecast?
• What is the Forecast Method trend that depicts the type of demand pattern?
• What is the trend of Planner overrides on the Forecast Adjustment?
The information on this dashboard is grouped into the following mini-dashboards:
Forecast Analysis Summary
This mini-dashboard helps you analyze the over or under forecasting of critical segments, parts, and locations.
Widget | Description |
|---|---|
# SKU-Streams | The count of SKU-Streams that are planned in the system, with External Indicator = yes and Use In Total = yes |
# Over | The count of SKU-Streams that are flagged as over-forecasted using Tracking Signal < -0.5 |
% Over | The percentage of over-forecasted SKU-Streams, calculated as (# Over / # SKU-Streams) * 100 |
# Under | The count of SKU-Streams that are flagged as under-forecasted using Tracking Signal > 0.5 |
% Under | The percentage of under-forecasted SKU-Streams., calculated as (# Under / # SKU-Streams) * 100 |
# Outliers | The count of demand outliers adjusted in the system |
Forecasting Categories by Tracking Signal | A pie chart of the count of SKU-Streams in the following groupings: • Over (Tracking Signal < -0.5) • Under (Tracking Signal >0.5) • Accurate (Tracking Signal between -0.5 and 0.5 • Not Calculated |
Forecast Error Analysis
This mini-dashboard helps you understand the forecast error by showing the tracking signal trend and accuracy trend over time.
 | To return to the Forecast Analysis dashboard after clicking a hyperlink, click Forecast Analysis on the Servigistics breadcrumb trail. |
Widget | Description |
|---|---|
Location (Over Forecast) | The average Tracking Signal at the Location level, calculated using the Tracking Signal and History Average of all the over-forecasted SKU-Streams of that Location. Σ(Tracking Signal * History Average) / Σ(History Average) Click a Location hyperlink to open the Forecast Review page in Servigistics, populated with the selected location for all part numbers. |
Location (Under Forecast) | The average Tracking Signal at the Location level, calculated using the Tracking Signal and History Average of all the under-forecasted SKU-Streams of that Location. Σ(Tracking Signal * History Average) / Σ(History Average) Click a Location hyperlink to open the Forecast Review page in Servigistics, populated with the selected location for all part numbers. |
Location (MAPE) | The average MAPE at the Location level, calculated using the MAPE and History Average of all the SKU-Streams of that Location. Σ(MAPE * History Average) / Σ(History Average) Click a Location hyperlink to open the Forecast Review page in Servigistics, populated with the selected location for all part numbers. |
Part Type (Over Forecast) | The average Tracking Signal at the Part Number level, calculated using the Tracking Signal and History Average of all the over-forecasted SKU-Streams of that Part Type. Σ(Tracking Signal * History Average) / Σ(History Average) Do the following to view more details: • Click  to display the Part Numbers associated with the Part Type.• Click a Part Type hyperlink to refresh the widget with the data specific to that part type. • Click a Part Number hyperlink to open the Forecast Review page in Servigistics, populated with the selected part number for all locations. |
Part Type (Under Forecast) | The average Tracking Signal at the Part Number level, calculated using the Tracking Signal and History Average of all the under-forecasted SKU-Streams of that Part Type. Σ(Tracking Signal * History Average) / Σ(History Average) Do the following to view more details: • Click to display the Part Numbers associated with the Part Type.• Click a Part Type hyperlink to refresh the widget with the data specific to that part type. • Click a Part Number hyperlink to open the Forecast Review page in Servigistics, populated with the selected part number for all locations. |
Part Type (MAPE) | The average MAPE at the Part Number level, calculated using the MAPE and History Average of all the SKU-Streams of that Part Type. Σ(MAPE * History Average) / Σ(History Average) Do the following to view more details: • Click to display the Part Numbers associated with the Part Type.• Click a Part Type hyperlink to refresh the widget with the data specific to that part type. • Click a Part Number hyperlink to open the Forecast Review page in Servigistics, populated with the selected part number for all locations. |
Forecast Method (Over Forecast) | The average Tracking Signal at the Forecast Method level, calculated using the Tracking Signal and History Average of all the over-forecasted SKU-Streams of that Forecast Method. Σ(Tracking Signal * History Average) / Σ(History Average) |
Forecast Method (Under Forecast) | The average Tracking Signal at the Forecast Method level, calculated using the Tracking Signal and History Average of all the under-forecasted SKU-Streams of that Forecast Method. Σ(Tracking Signal x History Average) / Σ(History Average) |
Forecast Method (MAPE) | The average MAPE at the Forecast Method level, calculated using the MAPE and History Average of all the SKU-Streams of that Forecast Method. Σ(MAPE * History Average) / Σ(History Average) |
MAPE vs COV | A scatter plot using the MAPE and COV of all the SKU-Streams. COV = HistorySD / History Average Click a bubble on the Part Type to open the pop-up menu and select HyperLink. Then select one of the following options: • Part Number, to open the Forecast Review page in Servigistics, populated with all locations for the selected part number. • Location, to open the Forecast Review page in Servigistics, populated with all part numbers for the selected location. |
Demand Forecast Analysis
This mini-dashboard helps you understand the trend of the forecast method counts and forecast adjustments.
Widget | Description |
|---|---|
Demand and Forecast (Units) | A chart that compares Total Demand and Forecast Units for the selected Location, Part Number or for the system. |
Demand and Forecast ($ Values) | A chart that compares The Total Demand and Forecast Values ($) for the selected Location, Part Number or for the system. |
Forecast Method Count | A chart that shows a time-series view of Forecast Methods used for forecasting. |
Forecast Adjustment | A chart that shows a time-series count of Total SKU-Streams and the % of SKU-Streams that have forecast adjustments. |