| All KPIs are to adapt regarding the forecast cycle lenght and the forecast axis (product, geography...) of your own company, regarding sales levels considered as low, averages or high and regarding the reliability objectives commitments, |
| By Forecast group, we mean the level of item agregation allowing the most reliable forecast (See Spec Sheet Sales Forecast ) |
| | | |
|
| |
| Description | Key Data | Detailed calculation |
| | Ratio % of reliability (progress) | Number of reliabilized forecasts groups / Number of to be reliabilizedd forecasts groups |
| | Ratio Global forecast difference/ Actual Sales | Sum of forecast/actual differences in absolute value /Sum of actual sales |
| Weekly operational follow-up | Ratio forecast difference / Actual Sales for high sales volume | Sum of actual sales of items with more than y % between forecast and actual > x untis (high sales) / Sum of sales of item with sales > x units (high sales) |
| Reliability at item level | Ratio forecast difference of high sales items / Actual Sales of items with at least one sale | Sum of actual sales of items with more than y % between forecast and actual > x untis (high sales) / Sum of actual sales of items with at least one sale |
| By product or geographycal hierarchy | Ratio Qty of items with at least 1 sale / Total Qty of items | Qty of items with at least 1 sale / Total Qty of items |
| | Ratio Sales of high sales items / Total Sales of items with at least 1 sale | Sum of sales of items with > x units sold (high sales) / Sum of actual sales of items with at least one sale |
| | Ratio Qty of high difference and high sales items / Total Qty of items | Qty of items with more than y % between forecast and actual > x untis (high sales) / Total Qty of items |
| | Ratio Actual sales of high difference and high sales items / Total actual sales | Sum of actual sales of items with more than y % between forecast and actual > x untis (high sales) / Total actual sales |
| | Qty of forecast groups | |
| | Sales with forecast OK / Total sales of week W-1 | |
| | Sales with forecast OK / Total sales of week W | |
| Weekly Dashboard | Difference between one week and another | |
| By product or geographycal hierarchy | Weekly history of over forecast (difference + z %) | |
| | Weekly history of lower forecast (difference - z %) | |
| | Weekly history of OK forecast (difference within +/- z %) | |
| Monthly Dashboard | Monthly evolution of forecast reliability at the end of forecast horizon | |
| By product or geographycal hierarchy | (comparizon of forecast done in the past within the horizon and actual of the corresponding periode in the horizon) | |
Spec Sheets 
