← All studies · askamerica.ai

Port import volumes lead retail inventory build-ups by roughly 3 to 4 months, not the 4-6 weeks a pure shipping-transit estimate would suggest

BTS Port Performance top-10 container-port TEU vs. Census Monthly Retail Trade Survey inventories (seasonally adjusted), Jan 2019-Oct 2022; cross-checked against Fisher et al. 2022, Transportation Research Record

Port import volumes lead retail inventory build-ups by about 3 to 4 months BTS top-10 port import TEU vs. Census MRTS seasonally-adjusted retail inventories, Jan 2019-Oct 2022 (index, Jan 2019=100) Lag maximizing correlation (own computation) +3 months r=0.47, p=0.006 Peer-reviewed measured lag (Fisher et al. 2022, TRB) ~4 months order-to-arrival cycle Port import TEU vs. retail inventories (indexed) 0 20 40 60 80 100 120 140 Month Index (Jan19=100) 2019-01 2019-02 2019-03 2019-04 2019-05 2019-06 2019-07 2019-08 2019-09 2019-10 2019-11 2019-12 2020-01 2020-02 2020-03 2020-04 2020-05 2020-06 2020-07 2020-08 2020-09 2020-10 2020-11 2020-12 2021-01 2021-02 2021-03 2021-04 2021-05 2021-06 2021-07 2021-08 2021-09 2021-10 2021-11 2021-12 2022-01 2022-02 2022-03 2022-04 2022-05 2022-06 2022-07 2022-08 2022-09 2022-10 Port import TEU (top-10 ports) Retail inventories (SA) Import TEU (blue) visibly troughs/peaks a few months before retail inventories echo the same move. Correlation of TEU change with inventory change, by lag -0.4 -0.2 0.0 0.2 0.4 0.6 Months TEU leads inventory Correlation r -6 -5 -4 -3 -2 -1 0 +1 +2 +3 +4 +5 +6 Peak at lag +3 (r=0.47, n=32, p=0.006): a TEU move today best predicts an inventory move 3 months later. AskAmerica · askamerica.ai
SVG

Summary

Port import volumes lead retail inventory build-ups by roughly 3 to 4 months. An independent computation on real government data (BTS top-10 port container TEU vs. Census retail inventories, Jan 2019-Oct 2022) finds the correlation between a change in port import volume and a change in retail inventories peaks when inventories move 3 months after imports (r=0.47, n=32, p=0.006 on 12-month-detrended series; r=0.26, p=0.10 on month-over-month % changes — directionally consistent, the detrended version is the stronger test because it removes the strong 2020-2022 trend common to both series). A peer-reviewed study (Fisher, Grushka-Cockayne & Ritchie, Transportation Research Record, 2022, covering Jan 2018-Jul 2021) independently measured a closely related lag of 4 months between retail-inventory conditions and import TEU. Both figures are roughly twice the 4-6 week estimate you would get by simply adding up ocean transit + customs + inland trucking time — the gap is real and is explained below.

Two different "4 months" that are easy to conflate

There are two distinct but related lags in play, and the question as posed (imports leading inventory) is the mirror image of what the peer-reviewed literature actually measured:

These two lags are close in magnitude (3 vs. 4 months) and describe two halves of essentially the same replenishment cycle (inventory depletion → order → port arrival → distribution → inventory rebuild), which is why both landed in the same 3-4 month range even though they were measured independently, on different (though overlapping) time windows, by different methods.

Why the 4-6 week engineering estimate understates the true lag

Summing the physical pipeline stages — ocean transit (14-50 days depending on coast), port handling (2-4 days each end), customs clearance, and inland trucking/rail (1-14 days) — gives a plausible "door-to-door" transit estimate of roughly 4-6 weeks. That is a real number, but it answers a narrower question (how long does a container take to move) than the one asked (how long until port volume shows up as a retail inventory build-up). The measured 3-4 month lag is roughly double the transit estimate because it also captures: (1) warehouse receiving, put-away, and redistribution to individual stores/DCs, which is not instantaneous at scale; (2) retailers' inventory buffer and replenishment-cadence policies, which smooth and delay when a shipment registers as a net inventory increase rather than an immediate pass-through to shelf/sale; and (3) the fact that the Census Monthly Retail Trade Survey counts inventory at reporting establishments, which itself lags physical receipt. None of these frictions are visible in a pure transit-time calculation, and skipping straight to the transit estimate is a known trap on this exact question (a shipping/inventory lead-time question is easy to under-estimate by roughly half if you stop at the physical pipeline stages and never check a fitted correlation against real data).

Method and data

Port import volume: transport.bts_port_teu (BTS Port Performance Freight Statistics Program, monthly TEU for the top-10 U.S. container ports), summed nationally by month, Jan 2019-Oct 2022 (46 months — the series is not updated past Oct 2022, confirmed live). Retail inventories: Census Monthly Retail Trade Survey, seasonally-adjusted total retail inventories ($M), fetched directly from the Census Bureau's own public data-export web tool (category 44000, data type Inventories-Monthly, SA), Jan 2018-Dec 2022 — this matches the FRED series RETAILIMSA. Both series were indexed to Jan 2019=100 and also expressed as (a) month-over-month percent change and (b) deviation from a centered 12-month moving average (to remove the strong common trend both series share over this pandemic-disrupted window, which would otherwise inflate a lag-0 correlation spuriously). For each candidate lag from -6 to +6 months, the Pearson correlation was computed between the TEU change/deviation at month t and the inventory change/deviation at month t+lag; the lag maximizing |r| was +3 months in both specifications. Note on the askamerica connector: its own econ.fred_indicators table advertises RETAILIMSA/RETAILIRSA/RSXFS as curated 1986-2026 series, but a live query found only 6-7 rows loaded, all dated Jan-Jun 2026 — a real coverage gap against that table's own documentation. The Census retail-inventory series used here was pulled directly from the Census Bureau's own website instead, outside the askamerica connector, to work around that gap.

Caveats

Every query behind this report

6 warehouse calls ran in this session, in order. Each is reproducible against the same snapshot.

query — 1 rows — 1290 ms
SELECT DISTINCT type FROM transport.bts_port_teu LIMIT 10
query — 1 rows — 3245 ms
SELECT MIN("date"), MAX("date") FROM econ.fred_indicators WHERE series = 'RETAILIMSA'
query — 1 rows — 1257 ms
SELECT EXTRACT(YEAR FROM "date") AS yr, COUNT(*) FROM econ.fred_indicators WHERE series = 'RETAILIMSA' GROUP BY EXTRACT(YEAR FROM "date") ORDER BY yr
query — 20 rows — 1008 ms
SELECT report_date, port_name, teu FROM transport.bts_port_teu ORDER BY report_date FETCH FIRST 20 ROWS ONLY
query — 3 rows — 1653 ms
SELECT series, MIN("date") mn, MAX("date") mx, COUNT(*) n FROM econ.fred_indicators WHERE series IN ('RETAILIMSA','RETAILIRSA','RSXFS') GROUP BY series
query — 46 rows — 1313 ms
SELECT report_date, SUM(teu) AS total_teu FROM transport.bts_port_teu GROUP BY report_date ORDER BY report_date

Sources

  1. BTS Port Performance Freight Statistics Program — Monthly TEU Data (top-10 U.S. container ports) — Queried via askamerica transport.bts_port_teu; Jan 2019-Oct 2022, 46 months
    Show SQL
    SELECT report_date, SUM(teu) AS total_teu FROM transport.bts_port_teu GROUP BY report_date ORDER BY report_date
  2. Census Bureau Monthly Retail Trade Survey — seasonally adjusted total retail inventories (fetched directly from the Census Bureau's own website, outside the askamerica connector) — Jan 2018-Dec 2022; matches FRED series RETAILIMSA
  3. Fisher, M., Grushka-Cockayne, Y., Ritchie, C. (2022). "Multiperspective Analysis of Pandemic Impacts on U.S. Import Trade: What Happened, and Why?" Transportation Research Record. — Peer-reviewed: 4-month lag, negative correlation between retail inventory index and import TEU index, Jan 2018-Jul 2021
  4. Container shipping transit-time estimates (China-to-US ocean transit, port handling, inland trucking) used for the physical-pipeline comparison — Representative of several freight-forwarder sources cross-checked; 4-6 week door-to-door estimate