Lesson 17 of 30 intermediate

Inventory Management & Warehousing

Too Much Stock Kills, Too Little Loses Sales

Open interactive version (quiz + challenge)

Real-world analogy

Inventory management is like managing a refrigerator. Buy too many groceries and food spoils before you eat it — wasted money. Buy too little and you're constantly running to the store, missing meals, and your family complains. The goal is always having the right amount of the right items at the right time. In fashion, 'spoiled groceries' means unsold inventory eating your profits.

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

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 it

Line-by-line walkthrough

  1. 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. 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. 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. 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. 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. 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. 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.
Need a hint?
Check the order volume against projected sales, and consider if 180 SKUs is manageable for a first collection.
Show answer
Multiple critical errors: (1) 180 SKUs for a first collection is way too many — start with 3-5 styles x 3-4 colors x 6 sizes (54-120 SKUs max). (2) 9,000 units with 500/month projected sales = 18 months of inventory. At 4x target turnover, you should only stock ~3 months (1,500 units). (3) $135,000 initial investment is extremely risky for a brand with zero sales history. (4) Personally fulfilling 500 orders/month (25/day) will take 3-4 hours daily — unsustainable. (5) Equal 50 units per SKU ignores size distribution — you'll have too many XS and XXL, not enough M and L. Better approach: 3 styles x 4 colors x 6 sizes (72 SKUs), 1,500 total units with size-weighted distribution, $22,500 investment.

Explain like I'm 5

Imagine you sell seashells at the beach. You bring 100 seashells every morning. If you sell 80 — great! But 20 are left over, and tomorrow you bring 100 more. After 5 days, you have 100 leftover shells piling up. Now you're tripping over shells! That's like a clothing brand with too much inventory. But if you only bring 50 and sell out by noon, people come in the afternoon wanting shells but you're empty — that's lost sales. The trick is counting how many you sell each day and bringing just the right number, plus a few extras just in case.

Fun fact

Costco's famous Kirkland brand applies the same lean inventory principles that clothing brands should follow — they carry only about 3,700 SKUs compared to Walmart's 120,000+. By carrying fewer items and buying in massive bulk, they turn inventory about 12 times per year (almost once a month). In fashion, Zara achieves a remarkable 80-85% sell-through rate at full price, compared to the industry average of 60-70%. Their secret? Small initial orders with rapid replenishment for winners, plus the artificial scarcity that makes customers buy immediately because they know the item won't be restocked.

Hands-on challenge

Create a complete inventory plan for a 5-style, 4-color, 6-size clothing line. (1) Calculate the total number of SKUs. (2) Using the size distribution percentages from this lesson, fill in a size-color matrix for a total order of 300 units per style. (3) Calculate the reorder point for your projected bestselling SKU, assuming 3 units/day average sales and a 45-day total lead time. (4) Using $18 COGS per unit, calculate the total capital locked up in your initial inventory order. (5) Determine your minimum monthly sales to achieve a 4x annual inventory turnover.

More resources

Open interactive version (quiz + challenge) ← Back to course: Clothing Business Masterclass