SKU Forecast Analysis - Advanced
This dashboard is designed to help you analyze things like:
• The over or under forecasting of critical SKUs
• The forecast error for SKUs by understanding the tracking signal trend and accuracy trend over time
• The trend of the forecast method counts and forecast adjustments for SKUs
The information on this dashboard is grouped into the following mini-dashboards:
Forecast Error Analysis - SKU
TBD
Widget | Description |
|---|---|
Tracking Signal (Over forecast, -ve | A chart of the Tracking Signal (lead time) of only over-forecasted SKUs, used to calculate a system level tracking signal by using History Average as the weight. T.S. (Over) = [Σ( T.S. * HAvg) of all the SKUs that are over-forecasted] / [Σ(HAvg) of all the SKUs that are over-forecasted] |
Tracking Signal (Under forecast, +ve) | A chart of the Tracking Signal (lead time) of only under-forecasted SKUs, 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 SKUs that are under-forecasted] / [Σ(HAvg) of all the SKUs 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 SKUs and their History Average as the weight. Forecast Accuracy = [Σ(Forecast Accuracy *HAvg) of all the SKUs] / [Σ(HAvg) of all the SKUs] |
SKU Summary | A listing of the forecast metrics for all the SKUs of system or selected Part Number or Location, and their demand forecast data that was used to calculate the metrics. |
Demand Forecast Analysis- SKU
TBD
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-Stream Summary
TBD
Widget | Description |
|---|---|
SKU Summary | A listing of forecast metrics for all the SKUs of all the Part Number or Location 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 |