To allow detailed equipment management and flexible reporting in ROCK, the equipment planning data used in the system needs to be stored at the finest granularity. When new data is introduced in ROCK (e.g. a new manual forecast input is received), it is not always specified at the finest granularity. To correctly store the data, we calculate and use Split Ratios as a compromise instead.
Depending on the specific type of data, values are split automatically when they are introduced in the system. For geographies the finest granularity is the site code (e.g. NLROTTM), for equipment it is the equipment type code (e.g. 20PLWD) and for export/imports numbers the lowest granularity is the number associated to a specific operator code.
The split ratios are recalculated weekly to reflect the most-recent export behavior.
Split Ratios Usage In Forecasting
The auto forecast (see Auto Forecast) is produced on aggregated level for geography, period and equipment. To allow flexible planning, the data must be split from pool to site (NLROT→NLROTTM) and from equipment group to equipment type (20DRY*→20DRY). In some cases where the forecasting at operator level has too low accuracy, ROCK receives an operator total number that needs to be split (100→50MSK,50SEA).
Week To Site Split Ratios - based on past 16 weeks distribution of either export pick-ups or import returns
Pool To Site Split Ratios - based on past 16 weeks distribution of export pick-ups or import returns
Total To Operator Split Ratios - based on past 16 weeks distribution of export pick-ups or import returns
Split Ratios Usage In Target Stock Levels
Using the Auto Forecast to calculate Target Stock Levels, the relevant formulas are applied on pool level data from the auto forecast (see Target Stock Levels). In order to allow target stock levels on lowest granularity, the values are split from from pool to site (NLROT→NLROTTM) and from equipment group to equipment type (20DRY*→20DRY).
Pool To Site Split Ratios - based on past 16 weeks distribution of export pick-ups
Split EquGroup To EquType - based on past 16 weeks distribution of export pick-ups
Split Ratios Usage In Stock Projection
Stock projection is required to manage the daily operations by determining how many export pick-ups and import returns will happen on a week-day (see Projected Stock). This requires the projected stock to a week to be shown to a daily level. To allow flexible planning, we capture the past behavior as split ratios from weekly events to day for each local level (NLROT03, on week 40, 10 exports → 5 exports tuesday, 5 exports friday).
Week To Site Split Ratios - based on past 16 weeks distribution of either export pick-ups or import returns