Introduction
Stock Projection takes not only OTTs into consideration, but also the forecasted import returns and export pick-ups. Since the forecast is specified per week, ROCK uses a logic to split it from week to week days. To do this, each week ROCK calculates week to day split, specifying how imports and exports have been distributed across weekdays (see more in Split Ratios).
Applied example
Using the split patterns, the weekly forecast (238) is split to day. The effective number (Column Exp) is set to
- Past: actual value
- Today: max(ForecastDay - Actuals; 0) – this effectively sets forecast to 0, if more actuals were seen for the day, than expected
- Future: ForecastDay
To prevent any rounding issues from the week to day split, any units are corrected by adding/subtracting 1 from the weekday with the highest split ratio.
| SiteCode | EquipmentType | YYYYWW | Type | Date | ForecastWeek | SplitRatio | ForecastDay | Actuals | Forecast | |
|---|---|---|---|---|---|---|---|---|---|---|
| ESALRTM | 40HIGH | 202013 | Export | 2020-03-23 | -3 | 238 | 18.81 | 45 | 89 | 89 |
| ESALRTM | 40HIGH | 202013 | Export | 2020-03-24 | -2 | 238 | 20.31 | 48 | 53 | 53 |
| ESALRTM | 40HIGH | 202013 | Export | 2020-03-25 | -1 | 238 | 21 | 50 | 71 | 71 |
| ESALRTM | 40HIGH | 202013 | Export | 2020-03-26 | Today | 238 | 19.69 | 47 | 15 | 32 |
| ESALRTM | 40HIGH | 202013 | Export | 2020-03-27 | +1 | 238 | 14.38 | 34 | 34 | |
| ESALRTM | 40HIGH | 202013 | Export | 2020-03-28 | +2 | 238 | 3.05 | 7 | 7 | |
| ESALRTM | 40HIGH | 202013 | 2020-03-29 | +3 | 238 | 2.76 | 7 | 7 |