Introduction

The Flow Contribution Calculation on the Stock Projection represents the number at current time, of expected containers to depart from origin and arrive at destination. In simple terms, if a future OTT of 100 x 40HIGH containers are planned from BEANT01 on 1/1/22 to DEBRVTM 2/1/22, then we will expect 100 units will be loaded/gate-out and 100 units will be discharged/gate-in the day later. While this is the most common calculation, there are several important refinements to be applied, in order to have a meaningful flow contribution. These refinement are explained on this page.

Flow Considerations

Projection Cut-Off

When OTTs are executed, the load/discharge moves will be reconciled to the OTT (see Reconciliation) in the same pace as the moves are inserted in RKEM. Sometimes if will take a while before operations are complete and all moves are completely inserted into RKEM and received in ROCK. During the period where load operations are happening ROCK must still assume the planned number on the OTT will reach the destination, and (Planned - Loaded) containers will still be loaded from the origin. To simplify these calculations, ROCK uses an Origin LoadCutOff and a Destination DischargeCutOff timestamp for each OTT. The rules to identify these discharge cut-offs are described below.

The following checks are also included in the rules to determine the CutOffs.

Origin and Destination CutOff Formulas

Origin and Destination CutOff Examples

Unplanned Subtype Volume

In many cases, the equipment planner wants to move containers of a certain group (e.g. 40REEF* or 40HIGH*). In these cases, loading any of the subtypes under the group is an acceptable substitute. To prevent "over" projecting flows, the flow contribution logic will identify the unplanned subtypes that have been loaded and subtract it from the maintype of the equipment group (i.e. 40HIGH is maintype of 40HIGH* group).

In the example below, the plan is to move 250x40HCRF* regardless of which subtype, where 228 units of the maintype is loaded (40HCRF), with an additional 16 unplanned 40MGRF are also loaded. The USV associated to 40HCRF* is set to 16 using logic described in the business rules. Consequently as load operations are ongoing we can subtract the USV from the maintype (40HCRF) when projecting how many additional 40HCRF are expected to be loaded: COALESCE(A,S,) - L - USV = 250 - 228 - 16 = 6.

Flow Contribution Formulas

Flow Contribution is calculated as two numbers: OriginEvacProjection which is the projection of units yet to be evacuated from the origin, and DestSupplyProjection which is the projection of units yet to be supplied to the destination. The code is straightforward is run for each equipment type on each OTT using the below code in SQL, which is fairly self-explanatory.

The formulas are simplified to allow negative numbers. As a last step, each projection will be capped to 0 to prevent negative projections (we shouldn't expect negative numbers to be loaded or discharged).

Origin Evacution Formulas

[OriginEvacProjection] = 
CASE 
	WHEN OTTStatus = 'C' OR IsGSISmatched=0 THEN 0					-- Cancelled and mismatched OTTs will project 0 units
	WHEN OTTStatus IN ('S', 'A') AND OriginOmit=1 THEN 0			-- Planned OTTs with Origin OMIT will project 0 units
	WHEN OTTStatus IN ('L', 'D') AND DestinationOmit=1 THEN 0		-- OTTs in progress with Dest OMIT will project 0
	WHEN IsLoadCutOffPassed = 0 THEN
		CASE 
			WHEN COALESCE([A],[S],0) < ISNULL([L],0) THEN 0				-- Planned-L
			ELSE COALESCE([A],[S],0) - ISNULL([L],0) - ISNULL([USV],0)	-- Planned-L-USV
		END
	ELSE 0 -- after cut-off, we expect 0 more to be loaded
END 

Destination Supply Formulas

[DestSupplyProjection] = 
CASE
	WHEN OTTStatus = 'C' OR IsGSISmatched=0 THEN 0
	WHEN OTTStatus IN ('S', 'A') AND OriginOmit=1 THEN 0
	WHEN OTTStatus IN ('L', 'D') AND DestinationOmit=1 THEN 0
	WHEN IsLoadCutOffPassed = 0 THEN
		CASE
			WHEN COALESCE([A],[S],0) < ISNULL([L],0) THEN
			COALESCE([L],0) - ISNULL([D],0) - ISNULL([USV],0)				-- loaded more than planned L-D-USV
			ELSE COALESCE([A],[S],0) - ISNULL([D],0) - ISNULL([USV],0)	-- loaded less than planned (Planned-D-USV)
		END
	WHEN IsDischargeCutOffPassed = 0 THEN
		ISNULL([L],0) - ISNULL([D],0) - ISNULL([USV],0)
	ELSE 0
END