Introduction

To compare stock+SIT against target stock+ average SIT, ROCK is using the following set of logics

• Calculating Historical Stock In Transit
• Calculating Future Stock In Transit Future
• Calculating Average Stock In Transit (AvgSIT)

Calculating Historical Stock In Transit

ROCK has a logic (stored procedure: dbo.GetHistoricSit) that identifies all loaded and discharged moves from RKEM (delta list), to a given geo level. The delta list, which includes information on when the empty equipment was loaded and discharged, can be translated into a list of currently gated out equipment at any given days at midnight (UTC).

Calculating Current and Future Stock In Transit

ROCK has a logic to determine stock in transit for current and future days. The calculations are done as part of the stock projection logic, which is calculated on the fly. The formulas takes OTT data as input and determines how many additional units are expected to be gated out at a particular date at midnight (UTC).

Calculating Average Stock In Transit

ROCK calculates an AvgSIT value every week (sunday) to each aggregated geo level (e.g. Pool, Country, Region) and for all equipment type. The value is calculated based on the historical SIT of the relevant geos, in the period from 10 to 100 days, prior to current day. The AverageSIT value for the week is stored as a rolling average in the database, to be used on-the-fly in ROCK reports

The AverageSIT is used dynamically in ROCK stock management screens, and ROCK will always use the most-recent AvgSIT value, relevant to the stock. This also which also means that the latest AverageSIT is used in all future weeks of projected stock, when "Include SIT" is enabled.