This page explains assembling a complete replenishment worksheet: bringing the separate checks and calculations already taught in this course together into one connected tool used every cycle. It is for a domestic buyer or planner, such as one at Cedar & Co., managing a hybrid style sold through more than one channel.
At work, each of the replenishment steps taught so far, checking whether a style is a candidate, setting its reorder point, calculating its quantity, and checking its current sales rate, is genuinely useful on its own, but running them as separate, disconnected checks each cycle is slow and easy to get out of step. A complete worksheet links the four steps so that a change flagged in one, such as a rate change, automatically feeds the ones that depend on it. This lesson gives you the method for assembling that complete worksheet and reading it as one connected tool.
You need: lessons 2.1 to 2.4's individual methods are useful background but not required, since each is restated here.
By the end of this lesson you can:
Not covered here: allocating a style's first shipment across stores, covered in Track 21 Course 1; store-level detail below the combined worksheet total.
| Term | Meaning |
|---|---|
| Replenishment | Ordering more of a style that is already selling, based on how it is performing, rather than a first, unsold shipment. |
| Reorder point | The quantity of stock remaining at which a Make to Stock buyer places its next production order against the standing forecast. |
| Weekly sales rate | The average number of pieces of a style sold in one week, found by dividing total pieces sold by the number of weeks elapsed. |
| Replenishment cycle | One repeating round of Make to Stock production, run against a forecast rather than a single confirmed order. |
| Opening stock | The stock a retailer holds at the very start of a given week, before that week's own intake or sales are counted. |
| Hybrid selling model | A brand that sells through more than one route to market at once, for example wholesale and its own direct retail, often at different prices. |
Run separately, each replenishment step this course has taught, the candidate check, the reorder point, the replenishment quantity, and the sales-rate check, is correct on its own but disconnected from the others. A complete worksheet links them in one row per style, so that a weekly sales rate confirmed in the rate check automatically feeds the reorder point and replenishment quantity calculations that depend on it, instead of each being updated separately and possibly falling out of step.
| What can differ | The shapes you will meet | Why it matters |
|---|---|---|
| Domestic, hybrid, buyer-managed | Cedar & Co. combines its own 12 shops' sales with its small wholesale account's sell-through into one worksheet row per style. | A hybrid domestic buyer runs every step itself, so the same person must keep all four steps in step with each other. |
| Export, single-channel, factory-managed | Delta Garments manages a worksheet row for a Northline Apparel style sold through one export channel only. | A single-channel style's combined rate is simply that channel's own rate, slightly simplifying the rate-check step. |
| A newly confirmed candidate | A style that has just passed lesson 2.1's three-condition candidate check for the first time this cycle. | A first-time candidate needs its reorder point and quantity calculated fresh, with no previous cycle's figures to carry forward. |
| An established style already mid-cycle | A style already several replenishment cycles into its life, with historical rates from previous cycles available. | An established style's rate check can compare against several previous cycles, not only the immediately preceding one. |
Cedar & Co.'s T-shirt style, sold through its own 12 shops and a small wholesale account, is checked at the start of a new replenishment cycle. Cedar & Co.'s buyer works through the complete worksheet row: confirming the style is still a candidate, checking its current combined rate against the last cycle's rate, then recalculating the reorder point and replenishment quantity from whichever rate is now correct.
| Question | Running each step as a separate, disconnected check | Using one linked worksheet row |
|---|---|---|
| Does a rate change carry into the reorder point? | Only if someone remembers to update it separately | Yes, the linked row carries it through automatically |
| Can the buyer see the whole picture for one style at once? | Only by gathering four separate records | Yes, one row shows candidate status, rate, reorder point, and quantity together |
| What happens if the candidate check now fails? | The other three steps might still be run regardless | The row correctly stops before calculating a reorder point or quantity |
Cedar & Co.'s buyer works the linked row through all four steps for the current cycle.
A common mistake is noticing a rate change and updating only the rate column, leaving the reorder point and replenishment quantity columns showing figures calculated from the old rate. If Cedar & Co.'s buyer had updated the combined rate to 322 pieces per week but left the reorder point and quantity at figures calculated from an earlier, lower rate, the worksheet would display an internally inconsistent row: a rate figure suggesting one order size, and a quantity column still showing another, undermining the whole point of linking the steps together.
A complete replenishment worksheet brings four separate checks, whether a style is still a candidate, what its current combined sales rate is, what its reorder point should be, and how much to order, into one connected row run every cycle. The value of linking them is that a change confirmed in one step, most often a sales rate change, correctly carries into every later step that depends on it, instead of being recorded in isolation while the rest of the row quietly falls out of date. Running all four steps in order, every cycle, and updating every column a change actually affects, keeps the worksheet a reliable single source for a replenishment decision.
Cedar & Co.'s buyer opens the replenishment worksheet to place this cycle's order and finds an inconsistency in the T-shirt style's row.
Should Cedar & Co.'s buyer place the order using the existing, outdated quantity figure to meet today's deadline, or recalculate the reorder point and quantity from the updated 322-piece rate first? Decide before you open the answer.
Recalculate the reorder point and quantity from the updated 322-piece rate before placing the order. The rate column has already been correctly updated; leaving the reorder point and quantity columns on the old 280-piece rate would place an order sized to demand the style no longer has, which is exactly the inconsistency this lesson's trap describes.
First, why the deadline does not justify skipping the recalculation. Recalculating a reorder point and quantity from an already-known rate takes only a few minutes, well within the time remaining before today's deadline, and is far faster than correcting an undersized order once it is already placed.
Second, why placing the outdated quantity would defeat the purpose of updating the rate at all. Updating the rate column only matters if the figures that depend on it are recalculated from it; otherwise the update is recorded but never actually used.
Cedar & Co.'s buyer should recalculate the reorder point and replenishment quantity from the current 322-piece rate, then place the freshly calculated order before today's deadline, rather than submitting the outdated 280-piece-based figure. This closes the course: every replenishment step, from candidate check to final quantity, now runs as one connected worksheet.
Framed in lost sales rather than a single penalty figure: the outdated rate understates real combined demand across the whole 4-week cycle.
Placing an order still based on the outdated 280-piece rate, once the combined rate has already been confirmed at 322 pieces, risks a 168-piece shortfall across the cycle, worth approximately USD 3,343.20 in lost sales that a fully linked worksheet, recalculated in the same pass as the rate update, would have avoided.
The workbook's four sheets, "Candidate check," "Rate check," "Reorder point," and "Replenishment quantity," are linked so that the confirmed rate on one sheet feeds the reorder point and quantity calculations on the others automatically for the same style row.
Cedar & Co.'s own row runs all four linked sheets for its T-shirt style: a confirmed candidate, a 322-piece combined rate, a 1,481-piece reorder point, and a 966-piece replenishment quantity, each recalculated from the one before it.
1. What is the main advantage of linking the four replenishment steps into one worksheet row instead of running them as separate checks?
2. A worksheet row shows an updated combined rate of 350 pieces per week, but the reorder point column still reflects an old 300-piece rate. What should happen before the order is placed?
3. In a complete replenishment worksheet, which step must be run first, before the reorder point or replenishment quantity are calculated?
| EN | AR | FR | TR | Meaning |
|---|---|---|---|---|
| Replenishment | تجديد المخزون | Réapprovisionnement | Stok yenileme (replenishment) | Ordering more of a style that is already selling, based on how it is performing, rather than a first, unsold shipment. |
| Reorder point | نقطة إعادة الطلب | Point de recommande | Yeniden sipariş noktası | The quantity of stock remaining at which a Make to Stock buyer places its next production order against the standing forecast. |
| Weekly sales rate | معدل المبيعات الأسبوعي | Taux de vente hebdomadaire | Haftalı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. |
| Replenishment cycle | دورة تجديد المخزون | Cycle de réassort | Yeniden stoklama döngüsü | One repeating round of Make to Stock production, run against a forecast rather than a single confirmed order. |
| Opening stock | المخزون الافتتاحي | Stock d'ouverture | Açılış stoku | The stock a retailer holds at the very start of a given week, before that week's own intake or sales are counted. |
| Hybrid selling model | نموذج بيع مختلط | Modèle de vente hybride | Karma satış modeli | A brand that sells through more than one route to market at once, for example wholesale and its own direct retail, often at different prices. |
You now know how to build a complete replenishment worksheet. The next course turns to inventory accuracy, starting with why a stock system's own recorded count and the real shelf count can differ. Back to the course map