ROCK Documentation : Global Stock Chart

Introduction

While SPM Port View is designed to give granular details in relation to stock development for one specific geo, Global Stock Chart allows the user to have a quick glance of stock vs target for current+7 weeks ahead for multiple geos and plan empty flows accordingly. This screen gives a visual indication of stock vs target situation with a more refined logic than other stock development screens which just simply highlight the stock red if below MinTSL and blue if above MaxTSL. Instead, Global Stock Chart displays a different indication depending where the stock specifically falls within MinTSL-MaxTSL range on the day with the lowest stock level during the week. With these features, Global Stock Chart is the starting point for day-to-day stock management, where the user can drill down to specific geos after. On top of stock level analysis, the user can access past current and past stock/import/export/imbalance levels and view/export the list of containers for longstanding container management. 

Contents

Page Access

The user can access the screen under Stock Development category in ROCK menu:

Overview


FeatureDescription
1Geo SelectorThe user can select one or more geographies at a time on this screen. Standard geo selector features available, plus the ability to combine multiple geos. See section Using the Global Filter for more details.
2Equ SelectorThe user can select one or more equipment types or TEU groups. Standard equipment selector features available. See section Using the Global Filter for more details.
3Include SIT

The user can choose to view stock figures and TSL including SIT detail or not. If the user selects a site, this flag is disabled as one site cannot have stock in transit. Read more on SIT in Current Stock. Note that, when Include SIT = Yes, the system adds average daily SIT level to MinTSL and MaxTSL to ensure a fair comparison (i.e. Stock including SIT vs Target including SIT) See Design Notes section on SPM Port View for more details.


4Total

Displays current stock. The system displays the number as a hyperlink. When the user clicks on it, the system displays a pop up with historical stock data. The user can see past 8 weeks of stock data with Sound vs Damaged condition

5SoundDisplays the current Sound stock level. Opens the same pop up as Total cell above
6DamagedDisplays the current Damaged stock level. Opens the same pop up as Total cell above
7SITDisplays current SIT level
8ImportThe total amount of actual Import Return during Today since 00:00
9ExportThe total amount of actual Export Pick up during Today since 00:00
10BoT

Balance of Trade = Import Return - Export Pick Up (aka Imbalance)

11Today

Displays a visual which represents the minTSL-maxTSL range for each geo/equ combination for today, and the current stock number and an indication of how the stock is doing against TSL:


CaseIcon
1

If Today’s stock is below the MinTSL by 1% or more

2

If Today’s stock is between MinTSL and MinTSL+0.2*(MaxTSL-MinTSL)

3

If Today’s stock is between MinTSL+0.21*(MaxTSL-MinTSL) and MinTSL+0.6*(MaxTSL-MinTSL)

OR there is no TSL available

4

If Today’s stock is between MinTSL+0.61*(MaxTSL-MinTSL) and MaxTSL


5

If Today’s stock is above MaxTSL by 1% or more


12Future Weeks

After Today column, the system displays 8 columns, representing projected stock for development this week and 7 future weeks. The stock projection indicator on these columns, is based on the lowest level that the stock will reach during the focal week. The reason to use minimum stock during the week instead of e.g. average stock: Many sites have one vessel call per week, which is the only chance to evacuate surplus containers or receive more containers for export needs. If the site can reach a desired stock level at their lowest during the week, then it has desired level of stock in general for that week. E.g. It is normal and acceptable for a surplus site to keep building stock all week, as there is no way to evacuate the surplus until the vessel arrives. This site is expected to hit a desired stock level once a week, right after the loading on the vessel. The fact that the site is above TSL for the other days of the week is actually insignificant. Similarly, for a deficit site, the stock level right before discharge from the vessel (i.e. lowest stock) determines whether the site has enough containers to cover exports or not.

The future week cells display and indication of how projected stock will do against TSL. The user can hover mouse to see the projected stock level for that day.


CaseIcon
1

If the lowest stock level, during the focal week, is below the MinTSL by 1% or more,

2

If the lowest stock level, during the focal week, is between MinTSL and MinTSL+0.2*(MaxTSL-MinTSL)

3

If the lowest stock level during the focal week is between MinTSL+0.21*(MaxTSL-MinTSL) and MinTSL+0.6*(MaxTSL-MinTSL)

4

If the lowest stock level during the focal week is between MinTSL+0.61*(MaxTSL-MinTSL) and MaxTSL,

5

If the lowest stock level, during the focal week is above MaxTSL by 1% or more

6No TSL availableBlank

Note that the deviation in Case 3 is the same for Today stock and future stock, but the icon is different. If the stock ended up at this level for Today, it is acceptable. Though for the future, seeing the same range in projected stock might mean potential build up of stock above target, so the design is more alarming for the future weeks for the same deviation range.

13Longstanding Ranges

The number of longstanding containers that has been in empty at location for 0-7, 8-14, 31-60, 61-180 and 180+ day ranges. When the user clicks on it, the system displays a pop up with the list of containers for the selected range displaying the list of containers with Container ID, days in stock, condition and site code. When the user exports to excel on this pop up, excel output includes the full list of containers from all longstanding ranges.


14View in SPM Port View

When the user right-clicks on any row on Stock Chart grid, a command appears: 'View in SPM Port View'. When the user clicks on this command, the system opens SPM Port View screen in a new tab, automatically populating Global Filter selections with the geo/equ row on Global Stock Chart and fetching data:

15ExportExports the contents of the grid to excel