Inventory Management & Warehousing
Too Much Stock Kills, Too Little Loses Sales
Open interactive version (quiz + challenge)Real-world analogy
What is it?
Inventory management is the system of ordering, storing, tracking, and selling your product stock to minimize costs while maximizing product availability. For clothing brands, this means creating smart SKU systems, calculating proper order quantities using the size-color matrix, setting reorder points, managing dead stock, choosing between self-fulfillment and third-party logistics, and planning around fashion's inherent seasonality.
Real-world relevance
SHEIN, the ultra-fast-fashion giant, revolutionized inventory management by producing extremely small initial batches (50-100 units per style) and using real-time sales data to reorder only what sells. They test over 6,000 new styles per day with minimal inventory risk. If a design sells well in the first 3 days, they ramp production rapidly. If it doesn't, they lose very little — maybe $500 per style. This 'test and react' model means they carry almost zero dead stock. While their approach raises serious sustainability concerns, the inventory management lesson is powerful: start small, let data guide reorders, and never commit big until demand is proven.
Key points
- The Inventory Balancing Act — Too much inventory ties up cash, increases storage costs, and risks becoming unsellable dead stock. Too little inventory means stockouts, lost sales, and frustrated customers who buy from competitors. The sweet spot for fashion brands is maintaining 60-90 days of inventory based on sales velocity — enough to fulfill orders without over-committing capital.
- SKU Architecture — SKU (Stock Keeping Unit) is a unique code for each product variant. A structured SKU system is critical: STYLE-COLOR-SIZE format (e.g., TEE01-BLK-M = Basic Tee, Black, Medium). With 5 styles x 5 colors x 6 sizes, you already have 150 SKUs. Every SKU needs tracking. Start with fewer variants and add based on demand data — complexity grows exponentially.
- The Size-Color Matrix — A size-color matrix maps your order quantities across every variant. Not all sizes sell equally: typically 5% XS, 15% S, 30% M, 30% L, 15% XL, 5% XXL for a standard distribution. Colors vary too — your core colors (black, white, navy) might sell 3x more than trendy colors. Your matrix must reflect real demand patterns, not equal distribution.
- Reorder Points and Safety Stock — Reorder point = (Average daily sales x Lead time in days) + Safety stock. If you sell 5 units/day of a bestseller and your reorder lead time is 45 days, your reorder point is (5 x 45) + 50 safety stock = 275 units. When stock hits 275, place a new order. Safety stock protects against demand spikes and supply delays.
- Dead Stock: The Profit Killer — Dead stock is inventory that hasn't sold in 6+ months with no realistic prospect of selling at full price. In fashion, dead stock can consume 20-30% of a brand's inventory. Options: discount (60-70% off to clear), sell to off-price retailers (like TJ Maxx at 70-80% discount), donate for tax write-off, or repurpose the fabric. Prevention: order conservatively and reorder fast sellers.
- Inventory Tracking Systems — Spreadsheets work until you hit 50-100 SKUs, then you need software. Options range from free (Google Sheets with formulas) to affordable (Stocky by Shopify, Cin7 Lite, inFlow) to enterprise (NetSuite, TradeGecko/QuickBooks Commerce). Your system must track: on-hand quantity, incoming orders, committed/reserved stock, and sales velocity per SKU.
- Warehousing: Self-Fulfillment vs 3PL — Self-fulfillment (your garage, rented space) works for <100 orders/month: low cost ($200-$500/month for small space), full control, but time-intensive. 3PL (third-party logistics like ShipBob, Deliverr, or ShipMonk) handles storage and shipping for you: costs $3-$8 per order plus storage fees, but saves massive time. Switch to 3PL when fulfillment takes more than 15 hours/week.
- Inventory Turnover Ratio — Inventory turnover = Annual COGS / Average inventory value. A healthy fashion brand turns inventory 4-6 times per year (every 60-90 days). Below 3x means you're sitting on too much stock. Above 8x means you might be understocked and losing sales. Track this quarterly and use it to adjust your buying strategy.
- Seasonal Inventory Planning — Fashion has natural peaks and valleys. Plan production 4-6 months before peak seasons (spring/summer, fall/winter, holiday). Build up inventory before peaks, liquidate slow movers before season end. Key: pre-order data (customer orders placed before production) reduces risk by revealing real demand before you commit to large orders.
Code example
=== INVENTORY PLANNING WORKSHEET ===
--- SKU SIZE-COLOR MATRIX ---
Style: Basic Crew Tee (TEE01)
XS(5%) S(15%) M(30%) L(30%) XL(15%) XXL(5%) TOTAL
Black: ___ ___ ___ ___ ___ ___ ___
White: ___ ___ ___ ___ ___ ___ ___
Navy: ___ ___ ___ ___ ___ ___ ___
Gray: ___ ___ ___ ___ ___ ___ ___
Olive: ___ ___ ___ ___ ___ ___ ___
TOTAL: === === === === === === ===
--- REORDER CALCULATOR ---
For each top-selling SKU:
SKU: _________________
Average daily sales: ___ units
Production lead time: ___ days
Shipping lead time: ___ days
Total lead time: ___ days
Safety stock (2 weeks): ___ units
Reorder Point: ___ units
(daily sales x total lead time + safety stock)
Economic Order Quantity: ___ units
(balance ordering costs vs holding costs)
--- INVENTORY HEALTH SCORECARD ---
Metric Current Target Status
Inventory turnover: ___x 4-6x [ ]OK [ ]FIX
Days of inventory: ___ days 60-90 [ ]OK [ ]FIX
Dead stock %: ___% <10% [ ]OK [ ]FIX
Stockout rate: ___% <5% [ ]OK [ ]FIX
Fill rate: ___% >95% [ ]OK [ ]FIX
Storage cost/unit/mo: $___ <$0.50 [ ]OK [ ]FIX
--- DEAD STOCK ACTION PLAN ---
If unsold > 90 days:
[ ] Markdown 30% and promote
If unsold > 180 days:
[ ] Markdown 50-70% or bundle
If unsold > 365 days:
[ ] Sell to off-price at 80% discount
[ ] Donate (get tax deduction receipt)
[ ] Write off and learn from itLine-by-line walkthrough
- 1. The size-color matrix is your ordering blueprint. The percentage distribution (5/15/30/30/15/5) prevents the common mistake of ordering equal quantities per size, which always results in excess XS and XXL and stockouts in M and L.
- 2. Each row represents a color and each column a size. For a 300-unit order, Black-M would be 300 x 30% = 90 units if Black is the only color. With 5 colors, you'd split 300 across them based on expected color demand.
- 3. The reorder calculator ensures you never run out of your best sellers. The formula (daily sales x lead time + safety stock) accounts for both normal demand during the wait for new inventory AND unexpected demand spikes.
- 4. Safety stock set at 2 weeks of sales is a starting point — increase it for your bestsellers and decrease for slow movers. The cost of stocking out on a bestseller far exceeds the holding cost.
- 5. The Inventory Health Scorecard gives you 6 key metrics to check monthly. Like a medical checkup — if all are in range, your inventory is healthy. Any one metric in 'FIX' range needs immediate attention.
- 6. Dead Stock Action Plan creates time-based triggers for markdowns. The longer you wait to act on slow-moving inventory, the less it's worth. The 90/180/365-day thresholds prevent emotional attachment to products that aren't selling.
- 7. The final option — 'write off and learn from it' — is important psychologically. Sometimes the best decision is to take the loss and free up cash and warehouse space for products that actually sell.
Spot the bug
INVENTORY ORDER FOR NEW COLLECTION:
5 styles x 6 colors x 6 sizes = 180 SKUs
Ordering 50 units per SKU = 9,000 total units
COGS: $15/unit
Total inventory investment: $135,000
Warehouse: renting a small storage unit for $400/month
Fulfillment: owner will pack and ship all orders personally
Projected monthly sales: 500 units
This is the brand's first collection ever.