KSI — In-Stock Rate & Inventory Turns by POD

In-stock counts

Pipeline = InTransit (NE) · OnDock + InTransit (SE / Great Lakes) · the extract's pipeline column (FL / TX). Turns stay on-hand-only either way.

In-stock rate by velocity Revenue-weighted, on velocity-coded items (A–E; code P excluded). Bars scale 0–100%. The ranking basis is not the same everywhere — Florida and Texas rank per POD, Northeast ranks companywide, SE / Great Lakes ranks per district — so compare a POD against itself down a column, not across PODs along a row. Southeast is split into its two districts, each carrying its own local A–E ranking.

POD	All velocity-coded	A	B	C	D	E
Northeastcompanywide velocity (excl. P)	96.8%99.4%	98%100%7,637 SKU	97%100%7,110 SKU	94%99%9,866 SKU	89%95%12,535 SKU	83%94%14,251 SKU
FloridaPOD velocity (FinalVelocity)	79.2%97.2%	79%98%7,650 SKU	82%97%7,034 SKU	77%96%10,293 SKU	67%89%9,259 SKU	83%93%799 SKU
Great Lakesdistrict velocity (excl. P)	92.3%98.5%	95%100%7,098 SKU	89%97%6,862 SKU	86%96%7,559 SKU	86%95%4,846 SKU	68%88%4,019 SKU
TexasPOD velocity (FinalVelocity)	80.7%96.4%	83%97%7,389 SKU	76%96%6,935 SKU	73%94%9,815 SKU	77%91%8,188 SKU	68%84%255 SKU
Southeastdistrict velocity, ranked per district (excl. P)	70.4%93.1%	71%94%13,910 SKU	68%91%13,491 SKU	71%91%13,709 SKU	86%95%10,165 SKU	47%79%4,552 SKU
Atlanta	61.6%90.8%	61%92%	61%85%	72%94%	79%95%	51%78%
Richmond	73.9%94.1%	75%95%	71%93%	71%91%	87%95%	45%79%

POD

All velocity-coded

Northeastcompanywide velocity (excl. P)

96.8%99.4%

98%100%7,637 SKU

97%100%7,110 SKU

94%99%9,866 SKU

89%95%12,535 SKU

83%94%14,251 SKU

FloridaPOD velocity (FinalVelocity)

79.2%97.2%

79%98%7,650 SKU

82%97%7,034 SKU

77%96%10,293 SKU

67%89%9,259 SKU

83%93%799 SKU

Great Lakesdistrict velocity (excl. P)

92.3%98.5%

95%100%7,098 SKU

89%97%6,862 SKU

86%96%7,559 SKU

86%95%4,846 SKU

68%88%4,019 SKU

TexasPOD velocity (FinalVelocity)

80.7%96.4%

83%97%7,389 SKU

76%96%6,935 SKU

73%94%9,815 SKU

77%91%8,188 SKU

68%84%255 SKU

Southeastdistrict velocity, ranked per district (excl. P)

70.4%93.1%

71%94%13,910 SKU

68%91%13,491 SKU

71%91%13,709 SKU

86%95%10,165 SKU

47%79%4,552 SKU

Atlanta

61.6%90.8%

61%92%

61%85%

72%94%

79%95%

51%78%

Richmond

73.9%94.1%

75%95%

71%93%

71%91%

87%95%

45%79%

Inventory turns and days of supply Unit turns = ADU × 261 selling days ÷ on-hand units. Days of supply = on-hand units ÷ ADU, in selling days. On-hand only — pipeline units are listed but excluded from both.

POD	On-hand units	Pipeline units	YTD ADU			ADU L14			ADU L35
POD	On-hand units	Pipeline units	ADU	Turns	Days	ADU	Turns	Days	ADU	Turns	Days
Northeast	518,897	194,997	5,605	2.82×	93	5,510	2.77×	94	3,630	1.83×	143
Florida	272,482	115,656	1,793	1.72×	152	1,497	1.43×	182	1,495	1.43×	182
Great Lakes	224,641	67,957	1,670	1.94×	135	1,857	2.16×	121	1,904	2.21×	118
Texas	134,496	134,571	1,426	2.77×	94	1,631	3.16×	82	1,617	3.14×	83
Southeast	166,682	118,163	3,710	5.81×	45	3,750	5.87×	44	3,831	6.00×	44
All PODs	1,322,211	631,358	14,215	2.81×	93	14,251	2.81×	93	12,486	2.46×	106

Method and caveats

In-stock = share of YTD revenue sitting on SKUs that are available. The toggle switches what counts as available: on hand only (on-hand qty > 0, the strict read) or on hand + pipeline (on-hand + pipeline qty > 0, crediting stock already on the way). Pipeline is InTransit_Combined for the Northeast, OnDock Qty + InTransit Qty for SE / Great Lakes, and the extract's own pipeline column (Qty_InPipeLine / POD_Pipeline) for Florida and Texas. A SKU-count version of each is on the map cards; both cover velocity-coded items only.
The toggle does not affect turns or days of supply — those stay on on-hand units, since pipeline stock is not yet available to sell.
Every POD is now velocity-filtered, but not on the same basis. Florida and Texas carry a POD-level FinalVelocity (the two disagree on ~90% of shared items). Northeast carries companywide velocity. SE / Great Lakes carries a district-level Velocity — the same item is ranked differently in Richmond than in Atlanta on 44% of the 19,513 items the two districts share. Codes are therefore never joined across extracts, and a letter is only comparable within its own POD. Code P is not a velocity rank and is excluded everywhere it appears.
Southeast rows are district × item. Richmond and Atlanta are separate rows for the same item, which is the right grain for in-stock — each district has to have it on hand — but it means Southeast SKU counts are district-SKU pairs, not distinct items.
The SE / Great Lakes extract is pre-filtered to Total Inventory Value > $0, unblocked and not-closed items, excluding warehouses 87FL / 88FL. The other extracts carry their own filters, so universes are not identical POD to POD.
Turns are unit-based, not dollar-weighted: the extracts carry YTD revenue but no unit cost, so a dollar turn cannot be computed from them without assuming a price.
ADU columns are per selling day, verified against the raw values: YTD ADU is units ÷ 155, ADU L14 is units ÷ 10, ADU L35 is units ÷ 25. Annualizing uses 261 selling days, which matches the L14 and L35 basis.
These rates are computed fresh from Instock/Dashboard/ and will not tie to Pod_instock_07222026/RegionOverall.xlsx, which is a separate earlier pull with its own universe.
Rebuild with python build.py after dropping new raw extracts in Instock/Dashboard/.