Highest priority: Game Console Northgate Select Value Bundle (0 days of supply).
Inventory Analysis
Balance service, replenishment, and working capital with one SKU-level view of cover, turns, backorders, ABC class, SVSI, aging, and carrying cost.
Largest exposure: Tablet Everyday Basics 2-Pack at 87 days.
Capital, service, storage, and risk are shown separately so the assumption is visible and auditable.
Work the lanes from left to right
Critical and Reorder protect service. Healthy protects flow. Excess releases cash.
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.
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.
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.
Replenishment priorities
Suggested units close the gap to the category cover target. Validate supplier lead time before ordering.
Excess and cash-release candidates
High cover or excess-weighted SVSI suggests transfer, markdown, supplier restraint, or assortment review.
Value, movement, aging, and supplier exposure
Each diagnostic uses the same active scope and one SKU-level calculation set.
ABC by inventory value
Movement quadrant
Inventory aging
0 SKUs older than 90 days hold $0 (0.0% of inventory value).
Annual holding-cost model
$74,191 a year under the explicit 11% planning assumption; capital and risk explain $53,957.
SVSI and cover matrix
SVSI compares each SKU’s share of inventory value with its share of unit usage. Near 1.0 is balanced.
Inventory exposure by supplier
Use replenishment count and backorders beside value exposure before escalating a supplier.
| Supplier | SKUs | Inventory value | Needs reorder | Backorders |
|---|---|---|---|---|
| Redstone Brands | 13 | $352,550 | 1 | 0 |
| Elkhorn Partners | 24 | $39,874 | 5 | 1 |
| Silverbrook Manufacturing | 9 | $30,975 | 3 | 2 |
| Northwind Home Goods | 16 | $30,583 | 5 | 1 |
| Grayrock Manufacturing | 19 | $21,424 | 8 | 1 |
| Northwind Consumer Products | 15 | $18,545 | 5 | 0 |
| Stonebridge Brands | 14 | $17,682 | 7 | 1 |
| Alderwood Distribution | 18 | $17,101 | 5 | 3 |
Inventory detail
320 SKUs in the current view
| SKU / Product | Posture | ABC | On hand | Days | Turns | GMROI | Sell-through | Shrink | SVSI | Inventory value | Recommended action |
|---|---|---|---|---|---|---|---|---|---|---|---|
Activewear Legging Premium Label Value BundleP10281 · Bayfield Foods | Critical | C | 2 | 8.4 | 179.4 | 11 | 99.3% | 0% | 0.1 | $290 | Expedite or substitute; confirm the stockout and backorder. |
Womens Denim Northgate Select Value BundleP10046 · Brightwater Partners | Critical | C | 2 | 4.1 | 161.7 | 12.3 | 99.2% | 0% | 0.1 | $217 | Expedite or substitute; confirm the stockout and backorder. |
Frozen Vegetables National Brand Club PackP10260 · Sandhill Manufacturing | Critical | C | 8 | 4.4 | 42 | 4.3 | 96.9% | 0% | 0.1 | $207 | Expedite or substitute; confirm the stockout and backorder. |
String Lights Everyday Basics Club PackP10290 · Grayrock Supply Co | Critical | C | 1 | 1.7 | 232 | 6.5 | 99.4% | 0% | 0.1 | $178 | Expedite or substitute; confirm the stockout and backorder. |
Pain Relief Northgate Value SingleP10106 · Fairmont Brands | Critical | C | 1 | 2.3 | 376.2 | 8.2 | 99.6% | 0% | 0 | $55 | Expedite or substitute; confirm the stockout and backorder. |
Fresh Herbs Premium Label Value BundleP10044 · Alderwood Distribution | Critical | C | 2 | 3 | 151.3 | 6 | 99.1% | 0% | 0 | $30 | Expedite or substitute; confirm the stockout and backorder. |
Game Console Northgate Select Value BundleP10297 · Harborview Supply Co | Critical | C | 0 | 0.4 | — | 0.3 | 100% | — | 0 | $0 | Expedite or substitute; confirm the stockout and backorder. |
Streaming Stick Premium Label MultipackP10308 · Elkhorn Partners | Critical | C | 0 | 0.2 | — | 2.8 | 100% | — | 0 | $0 | Expedite or substitute; confirm the stockout and backorder. |
Bed Sheet Set Premium Label Club PackP10214 · Silverbrook Manufacturing | Critical | C | 0 | 0.3 | — | 5 | 100% | — | 0 | $0 | Expedite or substitute; confirm the stockout and backorder. |
Shredded Cheese National Brand Club PackP10087 · Fairmont Industries | Critical | C | 0 | 1 | — | 4.3 | 100% | — | 0 | $0 | Expedite or substitute; confirm the stockout and backorder. |
Fresh Herbs Northgate Value SingleP10186 · Northwind Home Goods | Critical | C | 0 | 0.6 | — | 279.7 | 100% | — | 0 | $0 | Expedite or substitute; confirm the stockout and backorder. |
Avocados Northgate Select Club PackP10056 · Stonebridge Brands | Critical | C | 0 | 0.4 | — | 308.8 | 100% | — | 0 | $0 | Expedite or substitute; confirm the stockout and backorder. |
Bluetooth Headphones Northgate Value 2-PackP10277 · Grayrock Manufacturing | Reorder | A | 4 | 28.3 | 80.8 | 0.6 | 98.4% | 0% | 2.9 | $5,934 | Review a buy of 36 units to reach 45 days. |
Bed Sheet Set Northgate Value Family SizeP10082 · Grayrock Manufacturing | Reorder | A | 19 | 27 | 22.6 | 8.1 | 94.2% | 0% | 1.3 | $3,494 | Review a buy of 34 units to reach 45 days. |
Tablet Everyday Basics Club PackP10139 · Elkhorn Foods | Reorder | A | 8 | 28.7 | 38.4 | 1.7 | 96.6% | 0% | 1.7 | $3,299 | Review a buy of 30 units to reach 45 days. |
Shampoo Premium Label Club PackP10178 · Fairmont Brands | Reorder | A | 24 | 23.6 | 14.7 | 4.5 | 91.8% | 4.2% | 1.2 | $2,740 | Review a buy of 20 units to reach 45 days. |
Allergy Relief National Brand Value BundleP10103 · Northwind Home Goods | Reorder | A | 28 | 21.5 | 15.9 | 8.5 | 92.3% | 7.1% | 1 | $2,723 | Review a buy of 27 units to reach 45 days. |
Cold & Flu Exclusive Brand SingleP10060 · Brightwater Partners | Reorder | A | 16 | 27.9 | 18.5 | 3.4 | 93.3% | 0% | 1.3 | $2,387 | Review a buy of 21 units to reach 45 days. |
Vitamins Exclusive Brand Family SizeP10194 · Brightwater Distribution | Reorder | B | 13 | 18.5 | 24.3 | 8.8 | 94.8% | 0% | 1 | $2,067 | Review a buy of 26 units to reach 45 days. |
Skin Care Everyday Basics MultipackP10141 · Silverbrook Foods | Reorder | B | 11 | 25.4 | 37.1 | 9.7 | 96.5% | 0% | 0.7 | $1,726 | Review a buy of 39 units to reach 45 days. |
Baking Mix Northgate Value Family SizeP10229 · Alderwood Distribution | Reorder | B | 40 | 28 | 8.6 | 4.3 | 86.7% | 2.5% | 0.8 | $1,714 | Review a buy of 3 units to reach 45 days. |
Canned Soup Northgate Value SingleP10202 · Grayrock Manufacturing | Reorder | B | 23 | 23 | 14.8 | 2.5 | 91.5% | 0% | 0.8 | $1,664 | Review a buy of 19 units to reach 45 days. |
Laundry Detergent Premium Label Family SizeP10156 · Silverbrook Foods | Reorder | B | 25 | 29 | 16.2 | 4.4 | 92.1% | 4% | 0.6 | $1,564 | Review a buy of 25 units to reach 45 days. |
Laundry Detergent Northgate Value MultipackP10074 · Fairmont Industries | Reorder | B | 41 | 26 | 9.9 | -2.1 | 87.8% | 2.4% | 0.6 | $1,559 | Review a buy of 9 units to reach 45 days. |
Coffee Exclusive Brand 2-PackP10121 · Grayrock Partners | Reorder | B | 42 | 29.2 | 8.1 | 6 | 85.9% | 0% | 0.7 | $1,503 | Review a buy of 0 units to reach 45 days. |