Prerendered snapshot. Every figure below was computed at build time from the synthetic dataset. Open the live app for filter combinations outside the presets, the returns workflow, and admin — it runs on a free instance and can take ~20s to wake.
Prerendered snapshot · no server request
Inventory command center

Inventory Analysis

Balance service, replenishment, and working capital with one SKU-level view of cover, turns, backorders, ABC class, SVSI, aging, and carrying cost.

Oct 1, 2025 – Jul 5, 2026Latest observed SKU inventory fields inside the active filtered sales window
Open planning
Replenishment120 SKUs need cover review

Highest priority: Game Console Northgate Select Value Bundle (0 days of supply).

Working capital63 SKUs carry excess cover

Largest exposure: Tablet Everyday Basics 2-Pack at 87 days.

Carrying cost11% annual planning rate

Capital, service, storage, and risk are shown separately so the assumption is visible and auditable.

Inventory value$674,460Latest observed value
Units on hand5,115Portfolio stock quantity
Weeks on hand2.5 wksOn hand ÷ average weekly usage
Annual turns2152 ÷ weeks on hand
Needs replenishment120Critical + reorder SKUs
Excess cover63Above the category guardrail
Backorder units29Open unit exposure
Annual holding cost$74,19111% planning assumption
GMROI4Gross margin $ ÷ average inventory cost
Sell-through94%Units sold ÷ units available
Shrink1%(Book − physical) ÷ book
Stock posture

Work the lanes from left to right

Critical and Reorder protect service. Healthy protects flow. Excess releases cash.

12CriticalBelow safety stock or stocked out · $977
108ReorderAt reorder point or below cover · $56,182
137HealthyInside the category cover band · $173,877
63ExcessAbove the cover guardrail · $443,424
Concentration and distribution

Where the value sits, and how cover is spread

The bar lists above total each class. These show the shape behind those totals.

ABC concentration

The top 12% of SKUs (class A) hold 80% of inventory value. The curve's steepness is the concentration.

Cumulative share of inventory value against share of SKUs

Cover distribution

78 SKUs sit under the 14-day perishable target; 48 carry more than the 45-day ambient target. The middle is working stock.

Distribution of days of supply across SKUs with cover targets

Movement: usage against value

Each point is a SKU: weekly usage against inventory value, split at the portfolio medians. 68 SKUs in "slow / cash tied" hold $166,322 — high value, low movement.

Weekly usage against inventory value for every SKU, coloured by movement quadrant
Buy plan

Replenishment priorities

15 SKUs

Suggested units close the gap to the category cover target. Validate supplier lead time before ordering.

Game Console Northgate Select Value BundleP10297 · Critical · $28,576
38 unitsHarborview Supply Co
Streaming Stick Premium Label MultipackP10308 · Critical · $15,950
44 unitsElkhorn Partners
Bed Sheet Set Premium Label Club PackP10214 · Critical · $9,112
40 unitsSilverbrook Manufacturing
Activewear Legging Premium Label Value BundleP10281 · Critical · $6,151
42 unitsBayfield Foods
String Lights Everyday Basics Club PackP10290 · Critical · $4,927
28 unitsGrayrock Supply Co
Womens Denim Northgate Select Value BundleP10046 · Critical · $4,114
38 unitsBrightwater Partners
Pain Relief Northgate Value SingleP10106 · Critical · $2,516
46 unitsFairmont Brands
Shredded Cheese National Brand Club PackP10087 · Critical · $676
11 unitsFairmont Industries
Rebalance

Excess and cash-release candidates

15 SKUs

High cover or excess-weighted SVSI suggests transfer, markdown, supplier restraint, or assortment review.

Tablet Everyday Basics 2-PackP10034 · Excess-weighted · SVSI 145.6
87.2 daysRedstone Brands
Streaming Stick Premium Label MultipackP10151 · Excess-weighted · SVSI 11.3
42.4 daysSilverbrook Manufacturing
Bed Sheet Set Northgate Select Value BundleP10135 · Excess-weighted · SVSI 10.9
102.9 daysNorthwind Home Goods
Streaming Stick National Brand 2-PackP10088 · Excess-weighted · SVSI 7.5
31.3 daysElkhorn Partners
First Aid Northgate Value Family SizeP10191 · Excess-weighted · SVSI 7.5
129.7 daysStonebridge Brands
Cookware Set Northgate Value 2-PackP10231 · Excess-weighted · SVSI 4.2
44.6 daysElkhorn Partners
Tablet Everyday Basics Value BundleP10101 · Excess-weighted · SVSI 4.3
32.3 daysAlderwood Consumer Products
Tablet Premium Label SingleP10063 · Excess-weighted · SVSI 3.8
43.9 daysRedstone Industries
Portfolio diagnostics

Value, movement, aging, and supplier exposure

Each diagnostic uses the same active scope and one SKU-level calculation set.

ABC by inventory value

A$539,255 · 38 SKUs
B$100,977 · 84 SKUs
C$34,228 · 198 SKUs

Movement quadrant

Core / protect$490,505 · 92 SKUs
Fast / lean$7,782 · 68 SKUs
Slow / cash tied$166,322 · 68 SKUs
Tail / monitor$9,851 · 92 SKUs

Inventory aging

0 SKUs older than 90 days hold $0 (0.0% of inventory value).

Inventory value and SKU count by aging bucket

Annual holding-cost model

$74,191 a year under the explicit 11% planning assumption; capital and risk explain $53,957.

Annual holding cost split by cost componentPlanning assumption: capital 5% · service 1% · storage 2% · risk 3%.
Demand versus stock

SVSI and cover matrix

SVSI compares each SKU’s share of inventory value with its share of unit usage. Near 1.0 is balanced.

Tablet Everyday Basics 2-PackExcess-weighted · SVSI 145.687.2 days · 2.3 turns
Streaming Stick Premium Label MultipackExcess-weighted · SVSI 11.342.4 days · 18.3 turns
Bed Sheet Set Northgate Select Value BundleExcess-weighted · SVSI 10.9102.9 days · 3.9 turns
Streaming Stick National Brand 2-PackExcess-weighted · SVSI 7.531.3 days · 19 turns
First Aid Northgate Value Family SizeExcess-weighted · SVSI 7.5129.7 days · 2.6 turns
Cookware Set Northgate Value 2-PackExcess-weighted · SVSI 4.244.6 days · 6.9 turns
Tablet Everyday Basics Value BundleExcess-weighted · SVSI 4.332.3 days · 35.1 turns
Tablet Premium Label SingleExcess-weighted · SVSI 3.843.9 days · 17.4 turns
First Aid Exclusive Brand Club PackExcess-weighted · SVSI 5131.2 days · 3.1 turns
Coffee Premium Label Family SizeExcess-weighted · SVSI 3128.1 days · 2.3 turns
Snack Crackers Exclusive Brand MultipackExcess-weighted · SVSI 3.246.7 days · 1.6 turns
Bluetooth Headphones Northgate Value 2-PackExcess-weighted · SVSI 2.928.3 days · 80.8 turns
Kids Hoodie Exclusive Brand Travel SizeExcess-weighted · SVSI 2.641.2 days · 9.6 turns
Cooking Oil National Brand Club PackExcess-weighted · SVSI 2.485.3 days · 4.1 turns
Ribeye Steak National Brand SingleExcess-weighted · SVSI 2.541 days · 3.9 turns
Shampoo National Brand Travel SizeExcess-weighted · SVSI 2.431.4 days · 6.7 turns
Sleepwear Set Northgate Value Travel SizeExcess-weighted · SVSI 1.737.2 days · 9.6 turns
Vitamins National Brand Club PackBalanced · SVSI 1.339.2 days · 15.3 turns
Bed Sheet Set Northgate Value Family SizeBalanced · SVSI 1.327 days · 22.6 turns
Skin Care Northgate Value 2-PackBalanced · SVSI 1.4150.5 days · 8.3 turns
Supplier lens

Inventory exposure by supplier

Use replenishment count and backorders beside value exposure before escalating a supplier.

SupplierSKUsInventory valueNeeds reorderBackorders
Redstone Brands13$352,55010
Elkhorn Partners24$39,87451
Silverbrook Manufacturing9$30,97532
Northwind Home Goods16$30,58351
Grayrock Manufacturing19$21,42481
Northwind Consumer Products15$18,54550
Stonebridge Brands14$17,68271
Alderwood Distribution18$17,10153
SKU workspace

Inventory detail

320 SKUs in the current view

SKU / ProductPostureABCOn handDaysTurnsGMROISell-throughShrinkSVSIInventory valueRecommended action
Activewear Legging Premium Label Value BundleP10281 · Bayfield Foods
CriticalC28.4179.41199.3%0%0.1$290Expedite or substitute; confirm the stockout and backorder.
Womens Denim Northgate Select Value BundleP10046 · Brightwater Partners
CriticalC24.1161.712.399.2%0%0.1$217Expedite or substitute; confirm the stockout and backorder.
Frozen Vegetables National Brand Club PackP10260 · Sandhill Manufacturing
CriticalC84.4424.396.9%0%0.1$207Expedite or substitute; confirm the stockout and backorder.
String Lights Everyday Basics Club PackP10290 · Grayrock Supply Co
CriticalC11.72326.599.4%0%0.1$178Expedite or substitute; confirm the stockout and backorder.
Pain Relief Northgate Value SingleP10106 · Fairmont Brands
CriticalC12.3376.28.299.6%0%0$55Expedite or substitute; confirm the stockout and backorder.
Fresh Herbs Premium Label Value BundleP10044 · Alderwood Distribution
CriticalC23151.3699.1%0%0$30Expedite or substitute; confirm the stockout and backorder.
Game Console Northgate Select Value BundleP10297 · Harborview Supply Co
CriticalC00.40.3100%0$0Expedite or substitute; confirm the stockout and backorder.
Streaming Stick Premium Label MultipackP10308 · Elkhorn Partners
CriticalC00.22.8100%0$0Expedite or substitute; confirm the stockout and backorder.
Bed Sheet Set Premium Label Club PackP10214 · Silverbrook Manufacturing
CriticalC00.35100%0$0Expedite or substitute; confirm the stockout and backorder.
Shredded Cheese National Brand Club PackP10087 · Fairmont Industries
CriticalC014.3100%0$0Expedite or substitute; confirm the stockout and backorder.
Fresh Herbs Northgate Value SingleP10186 · Northwind Home Goods
CriticalC00.6279.7100%0$0Expedite or substitute; confirm the stockout and backorder.
Avocados Northgate Select Club PackP10056 · Stonebridge Brands
CriticalC00.4308.8100%0$0Expedite or substitute; confirm the stockout and backorder.
Bluetooth Headphones Northgate Value 2-PackP10277 · Grayrock Manufacturing
ReorderA428.380.80.698.4%0%2.9$5,934Review a buy of 36 units to reach 45 days.
Bed Sheet Set Northgate Value Family SizeP10082 · Grayrock Manufacturing
ReorderA192722.68.194.2%0%1.3$3,494Review a buy of 34 units to reach 45 days.
Tablet Everyday Basics Club PackP10139 · Elkhorn Foods
ReorderA828.738.41.796.6%0%1.7$3,299Review a buy of 30 units to reach 45 days.
Shampoo Premium Label Club PackP10178 · Fairmont Brands
ReorderA2423.614.74.591.8%4.2%1.2$2,740Review a buy of 20 units to reach 45 days.
Allergy Relief National Brand Value BundleP10103 · Northwind Home Goods
ReorderA2821.515.98.592.3%7.1%1$2,723Review a buy of 27 units to reach 45 days.
Cold & Flu Exclusive Brand SingleP10060 · Brightwater Partners
ReorderA1627.918.53.493.3%0%1.3$2,387Review a buy of 21 units to reach 45 days.
Vitamins Exclusive Brand Family SizeP10194 · Brightwater Distribution
ReorderB1318.524.38.894.8%0%1$2,067Review a buy of 26 units to reach 45 days.
Skin Care Everyday Basics MultipackP10141 · Silverbrook Foods
ReorderB1125.437.19.796.5%0%0.7$1,726Review a buy of 39 units to reach 45 days.
Baking Mix Northgate Value Family SizeP10229 · Alderwood Distribution
ReorderB40288.64.386.7%2.5%0.8$1,714Review a buy of 3 units to reach 45 days.
Canned Soup Northgate Value SingleP10202 · Grayrock Manufacturing
ReorderB232314.82.591.5%0%0.8$1,664Review a buy of 19 units to reach 45 days.
Laundry Detergent Premium Label Family SizeP10156 · Silverbrook Foods
ReorderB252916.24.492.1%4%0.6$1,564Review a buy of 25 units to reach 45 days.
Laundry Detergent Northgate Value MultipackP10074 · Fairmont Industries
ReorderB41269.9-2.187.8%2.4%0.6$1,559Review a buy of 9 units to reach 45 days.
Coffee Exclusive Brand 2-PackP10121 · Grayrock Partners
ReorderB4229.28.1685.9%0%0.7$1,503Review a buy of 0 units to reach 45 days.
Page 1 of 13
How to use this pageBalance service and working capitalStart with stock posture, then separate replenishment needs from excess and slow inventory.
1
Check exposureReview inventory value, weeks on hand, stockouts, backorders, and annual holding cost.
2
Work the lanesReplenish Critical and Reorder items; review Excess items for transfer, markdown, or buying restraint.
3
Validate the SKUUse ABC class, SVSI, turns, aging, and supplier context before acting on the recommendation.