Course contents
Practitioner · Course 1: Allocation Fundamentals · Lesson 4 of 5

Reading sell-through by store to decide where the next shipment goes

Level: PractitionerTime: 50 minutesOrder used: A (the T-shirt, Fairway Stores' own first shipment tracked by Meridian Sourcing after two weeks of trading)Tool: Store allocation worksheet
For an agent tracking a retailer's own store-level sell-through to recommend where a second shipment should go. You need lesson T21-C01-L02. Figures are teaching examples in US dollars.
RetailerFairway Stores, four representative stores from the first shipment
AgentMeridian Sourcing, reading sell-through after 2 weeks of trading
First shipment allocated400, 300, 200 and 100 pieces by selling potential
ModelHybrid: estimated first batch, sell-through-based second shipment
Second shipment size500 pieces, ready to allocate by real results
What this lesson measuresWhether real sell-through still matches the first shipment's own estimate
02Opening

This page explains how to read each store's own sell-through rate to decide where a second shipment should go

This page is for an agent who tracks a retailer's own store-level sales after a first shipment has been trading for a few weeks, and must recommend how a second shipment should be allocated. At work, an agent who simply repeats the first shipment's own allocation ratios for every later shipment ignores real evidence that may already show some stores selling faster or slower than their own original estimate predicted. This lesson mainly teaches the information flow: it shows how sell-through rate, not the original selling-potential estimate, becomes the basis for a later shipment once real sales data exists.

Meridian Sourcing represents two European buyers and tracks Fairway Stores' own performance on Order A. Two weeks after the first 1,000-piece shipment reached Fairway Stores' four representative stores, split 400, 300, 200 and 100 pieces by estimated selling potential, real sales data now exists. Meridian Sourcing's own job is to check whether that original estimate still holds, or whether a 500-piece second shipment should be allocated differently because real store-level results have already moved away from the first shipment's own assumptions.

03Before you start

What you need, and what this lesson does not cover

You need: lesson T21-C01-L02, which shows how to allocate a shipment across stores by their own selling potential.

By the end of this lesson you can:

  • calculate a store's own sell-through rate from pieces sold against pieces allocated;
  • compare a store's own real sell-through against its own original selling-potential estimate;
  • identify a store trading faster or slower than its own first-shipment allocation assumed;
  • recommend a second shipment's own allocation based on real sell-through rather than the original estimate;
  • explain why a hybrid model uses estimated potential first and real results afterward.

Not covered here: building a complete allocation worksheet that combines every method from this course, covered in lesson T21-C01-L05.

04Key terms

Words you will meet in this lesson

TermMeaning
Sell-through rateThe share of stock actually sold within a planned period, used to judge whether a forecast was right.
Selling potentialAn estimate of how much a specific store is likely to sell, usually built from that store's own past weekly sales rate for a similar style.
Store allocationSplitting a confirmed shipment quantity across a retailer's own stores or shops, rather than shipping it all to one central point.
Weekly sales rateThe average number of pieces of a style sold in one week, found by dividing total pieces sold by the number of weeks elapsed.
Allocation ratioEach store's own selling potential expressed as a share of the total selling potential across all stores receiving the shipment.
Sell-through-based reallocationAdjusting a later shipment's own store-by-store split to match real sell-through, rather than repeating an earlier estimate unchanged.
05Teaching
The rule

Real sell-through, once it exists, replaces the original selling-potential estimate as the basis for the next shipment's own allocation

A first shipment is allocated by estimated selling potential because no real sales data exists yet for the new style. Once that shipment has traded for a few weeks, each store's own real sell-through rate becomes available, and it is more reliable than the original estimate because it reflects what customers in that specific store are actually buying rather than what a comparable style suggested they might buy. A hybrid allocation model uses the estimate for the first batch and switches to real sell-through for every shipment after it.

Fairway Stores' flagship store's own sell-through after 2 weeks: 220 / 400 = 55%
What you meet in real life

A store's own real sell-through can confirm, exceed, or fall short of its own original estimate

What can differThe shapes you will meetWhy it matters
A store trading exactly to its own original estimateThe flagship store's own real sell-through after two weeks roughly matches the pace its own selling-potential ratio predicted.When real results confirm the estimate, the second shipment can keep the same allocation ratio with confidence.
A store trading faster than its own original estimateA store allocated a smaller share, based on limited history, sells through faster than expected once real customers respond to the style.A second shipment allocated on the old ratio alone would under-supply a store now proving it can sell more.
A store trading slower than its own original estimateA store allocated a larger share, based on a comparable style, sells more slowly than that comparable style suggested it would.Continuing to send that store the same large share on the next shipment risks building up unsold stock it cannot clear.
Domestic Make to Stock reorder cycleA domestic retailer such as Cedar & Co. reviews real sell-through every week rather than only at fixed shipment milestones, adjusting reorders continuously.An export hybrid model like Fairway Stores' own reviews sell-through at shipment milestones; a domestic Make to Stock model can review it far more often.
The case we follow

Meridian Sourcing compares each of Fairway Stores' four stores' own real sell-through against its own first-shipment allocation

Two weeks after the first shipment, Fairway Stores reports pieces sold at each of its four representative stores. Meridian Sourcing divides pieces sold by pieces allocated to find each store's own sell-through rate, then compares that rate across the four stores to see which ones are trading faster or slower than their own original estimate predicted.

Sell-through after 2 weeks, by store, against original allocationFlagship (400 allocated): 220 sold, 55% sell-throughLarge (300 allocated): 90 sold, 30% sell-throughMid-size (200 allocated): 140 sold, 70% sell-throughSmall (100 allocated): 45 sold, 45% sell-through
The mid-size store's own sell-through of 70% is the fastest of the four, while the large store's own 30% is the slowest. The first shipment's own allocation ratios, based on estimated selling potential, no longer match what real sales are actually showing.
The worked number

The mid-size store's own 70% sell-through rate signals it deserves a larger share of the second shipment than its first allocation gave it

Mid-size store's own pieces sold: 140 pieces
Mid-size store's own pieces allocated in the first shipment: 200 pieces
Mid-size store's own sell-through rate: 140 / 200 = 70%

At 70% sell-through after two weeks, the mid-size store is clearing stock far faster than the large store, which sold only 90 of its own 300 allocated pieces for a 30% sell-through rate. If Meridian Sourcing simply repeated the first shipment's own ratios, 20% to the mid-size store and 30% to the large store, the second shipment would under-supply the store proving the strongest real demand and over-supply the one proving the weakest.

The method

Four steps to turn real sell-through into a recommendation for the next shipment

  1. Divide each store's own pieces sold by its own pieces allocated to find its own sell-through rate.
  2. Compare each store's own sell-through rate against the others, not against the original allocation ratio alone.
  3. Flag any store trading noticeably faster or slower than its own original estimate predicted.
  4. Recommend a second shipment's own allocation that shifts share toward stores with the highest real sell-through and away from those with the lowest.
  5. Repeat this same check before every later shipment, since a store's own sell-through rate can keep changing as the season goes on.
The trap

A common mistake is repeating the first shipment's own allocation ratios for every later shipment without checking real sell-through

A common mistake is an agent or buyer assuming that because a selling-potential estimate was reasonable for a first shipment with no sales history, that same ratio should carry forward automatically to every shipment after it, without ever checking whether real sell-through still supports it. Order A's own first shipment relied on a comparable style precisely because no better information existed yet; once two weeks of real sales exist, continuing to allocate by the old estimate throws away exactly the better information the first shipment was always meant to eventually produce. This is not a small technical slip: it means every later shipment repeats the same guess indefinitely, even after the guess has already been proven wrong by real customers walking into real stores and either buying or not buying the style in front of them. An agent's own value in this hybrid model comes precisely from making that switch at the right moment, not from mechanically re-running the first calculation forever.

Second shipment to the mid-size store, two allocation approachesOld ratio repeated: 20% of 500 = 100 piecesUnder-supplies fastest sellerBased on real sell-through: 30% of 500 = 150 piecesMatches real demand
Repeating the outdated first-shipment ratio sends the mid-size store only 100 of the second shipment's 500 pieces. Allocating by real sell-through instead recognizes its stronger performance and sends 150.
06In plain words

Once a style has been on sale for a while, the shops themselves tell you which of them are selling it fastest, far better than any earlier guess could. Divide what a shop has sold by what it was given to find how fast it is clearing stock. A shop clearing stock quickly deserves more of the next delivery; a shop with stock still sitting on the rail deserves less, whatever the very first estimate assumed. Keep checking real sales every time a new shipment is due, rather than trusting one early guess for the whole season.

07Quick check
  • A store's own sell-through rate is pieces sold divided by pieces allocated.
  • Real sell-through, once available, is more reliable than the original selling-potential estimate.
  • A store trading faster than expected deserves a larger share of the next shipment.
  • A store trading slower than expected deserves a smaller share, to avoid building up unsold stock.
  • A hybrid model uses an estimate for the first batch and real results for every shipment after.
  • Repeating an outdated ratio ignores exactly the better information a first shipment was meant to produce.
08Workplace scenario

Meridian Sourcing must recommend how Fairway Stores' second 500-piece shipment should be allocated across the same four stores

Two weeks of real sales data are now in. Meridian Sourcing has calculated each store's own sell-through rate: flagship 55%, large 30%, mid-size 70%, small 45%. Fairway Stores is waiting for a recommendation before its second shipment leaves Delta Garments' factory.

Sell-through report, week 2. Flagship: 220 of 400 sold, 55%. Large: 90 of 300 sold, 30%. Mid-size: 140 of 200 sold, 70%. Small: 45 of 100 sold, 45%.

Should the large store, which received the second-biggest first-shipment share, receive a similarly large share of the second shipment? Decide before opening the answer.

Show decision

No, not on this evidence. The large store's own 30% sell-through is the slowest of the four stores, well below the average pace the first shipment's own estimate assumed.

First, the large store still holds 210 of its own original 300 pieces unsold after two weeks, more unsold stock than any other store in absolute terms.

Second, the mid-size store's own 70% sell-through shows real demand the original estimate did not fully capture, making it a stronger candidate for a larger share of the second shipment.

Meridian Sourcing recommends shifting the large store's own second-shipment share down and the mid-size store's own share up, reflecting what real sell-through now shows rather than repeating the first shipment's own ratios unchanged.

09What it costs

What continuing to allocate by the outdated first-shipment ratio would cost Fairway Stores

Using this lesson's own illustrative figures:

Mid-size store's own second shipment under the old ratio: 100 pieces
Mid-size store's own second shipment based on real sell-through: 150 pieces
Pieces the old ratio would under-supply this store by: 150 - 100 = 50 pieces

At Fairway Stores' own shop price of USD 19.90 per piece, under-supplying the mid-size store by 50 pieces risks USD 995 of sales it is well placed to make but cannot, because stock never arrived, while the large store, already sitting on 210 unsold pieces, would receive even more stock it has already shown it cannot sell through at the same pace.

10Working template

Store allocation worksheet: calculate sell-through rate and recommend a second shipment's own allocation

Open the course workbook's "Sell-through tracker" sheet. Enter each store's own pieces sold and pieces allocated; the sheet then calculates each store's own sell-through rate and suggests a revised allocation ratio for the next shipment, ranked clearly from the fastest-selling store down to the slowest.

[Download the Store allocation worksheet](../../templates/T21-C01-store-allocation-worksheet.xlsx)

Download the Store allocation worksheet (Excel)

11Check yourself

1. Why does real sell-through replace the original selling-potential estimate once it becomes available?

2. A store was allocated 250 pieces and has sold 200 of them. Another store was allocated 250 pieces and has sold 50. What does this tell an agent recommending the next shipment?

12Glossary
ENARFRTRMeaning
Sell-through rateمعدل البيع الفعليTaux d'écoulementSatış oranıThe share of stock actually sold within a planned period, used to judge whether a forecast was right.
Selling potentialإمكانية البيعPotentiel de venteSatış potansiyeliAn estimate of how much a specific store is likely to sell, usually built from that store's own past weekly sales rate for a similar style.
Store allocationتوزيع المحلاتRépartition entre magasinsMağaza tahsisiSplitting a confirmed shipment quantity across a retailer's own stores or shops, rather than shipping it all to one central point.
Weekly sales rateمعدل المبيعات الأسبوعيTaux de vente hebdomadaireHaftalık satış oranıThe average number of pieces of a style sold in one week, found by dividing total pieces sold by the number of weeks elapsed.
Allocation ratioنسبة التوزيعRatio de répartitionTahsis oranıEach store's own selling potential expressed as a share of the total selling potential across all stores receiving the shipment.
Sell-through-based reallocationإعادة توزيع مبنية على معدل البيع الفعليRéaffectation par taux d'écoulementSatış oranına dayalı yeniden tahsisAdjusting a later shipment's own store-by-store split to match real sell-through, rather than repeating an earlier estimate unchanged.
13Next

Lesson 1.5: Building a complete store allocation worksheet

You now know how to read sell-through to decide where a second shipment goes. The next lesson brings every method in this course together into one complete allocation worksheet. Back to the course map

14Ladder

RecognizeTell a store's own real sell-through rate apart from its own original selling-potential estimate.
ConnectSee how pieces sold divided by pieces allocated becomes a signal for the next shipment's own allocation.
CompareWeigh a store trading faster than expected against one trading slower.
DecideJudge how a second shipment's own allocation should shift based on real sell-through evidence.