Part Forecast Analysis - Advanced
This dashboard is designed to help you analyze things like:
• The over or under forecasting of critical parts
• The forecast error for parts by understanding the tracking signal trend and accuracy trend over time
• The trend of the forecast method counts and forecast adjustments for parts
The information on this dashboard is grouped into the following mini-dashboards:
Forecast Error Analysis - Part
This mini-dashboard helps you analyze the over or under forecasting of critical segments, parts, and locations.
Widget | Description |
|---|---|
Tracking Signal (Over forecast, -ve | A chart of the Tracking Signal (lead time) of only over-forecasted Parts, used to calculate a system level tracking signal by using History Average as the weight. T.S. (Over) = [Σ( T.S. * HAvg) of all the Parts that are over-forecasted] / [Σ(HAvg) of all the Parts that are over-forecasted] |
Tracking Signal (Under forecast, +ve) | A chart of the Tracking Signal (lead time) of only under-forecasted Parts, used to calculate tracking signals at the system level by using History Average as the weight. T.S. (Under) = [Σ( T.S. * HAvg) of all the Parts that are under-forecasted] / [Σ(HAvg) of all the Parts that are under-forecasted] |
Forecast Accuracy | A chart of the Forecast Accuracy (lead time) at the system level, calculated by using Forecast Accuracy of all the Parts and their History Average as the weight. Forecast Accuracy = [Σ(Forecast Accuracy *HAvg) of all the Parts] / [Σ(HAvg) of all the Parts] |
Part Summary | A listing of the forecast metrics for all the Parts or a selected Part Type and their demand forecast data that was used to calculate the metrics. |
SKU Summary | A listing of the forecast metrics for all the SKUs of the Parts or selected Part Type, and their demand forecast data that was used to calculate the metrics. |
Demand Forecast Analysis- Part
This mini-dashboard helps you analyze the over or under forecasting of critical segments, parts, and locations.
Widget | Description |
|---|---|
Demand and Forecast (Units) | A comparison of the Total Demand and Forecast Units for the system or selected Part Type or Part Number. |
Demand and Forecast ($ Values) | A comparison of the Total Demand and Forecast $ Values for the system or selected Part Type or Part Number. |
Forecast Method Count | A time-series view of Forecast Methods used for forecasting. |
Forecast Adjustment | A time-series plot of Total Forecast and Adjustment %. [Forecast Adjustment / Total Forecast * 100] |
SKU Summary
TBD
Widget | Description |
|---|---|
SKU Summary | A listing of forecast metrics for all the SKUs of all the Part Type or Part Number and their Demand Forecast data that was used to calculate the forecast metrics. |
MAPE vs COV - SKU Stream
TBD
Widget | Description |
|---|---|
MAPE (LT) vs COV | A scatter plot using MAPE(Lead Time) and COV of all the SKU-Streams. The size of the bubble is proportionate to $ Annual Forecast. COV = HistorySD / History Average |