Course contents
Advanced · Course 5: Returns and Speed Models · Lesson 4 of 4

Building a complete returns and fulfilment-speed worksheet

Level: AdvancedTime: 50 minutesOrder used: A (the T-shirt, reused as Cedar & Co.'s own domestic hybrid style)Tool: Returns and fulfilment-speed worksheet
For a retail buyer or factory-side merchandiser who has completed the first three lessons of this course and now needs to bring the returns cost, the disposition decision, and the fulfilment-speed comparison into one complete worksheet for a single style. Lessons 5.1 through 5.3 are useful preparation, though not required. Figures are teaching figures.
RetailerCedar & Co. (12 shops, domestic, hybrid)
FactoryDelta Garments
ProductCedar & Co.'s own style, equivalent in value to Order A
Quantity12,000 pieces committed, 3,000-piece reorder considered
Business modelHybrid: forecast quantity committed, reorder quantity added once early sales confirm demand
02Opening

This page teaches a retail buyer or factory-side merchandiser how to combine every check from this course into one complete worksheet for a single style

This page teaches how to bring a returned piece's own cost, its disposition decision, and a fulfilment-speed comparison into one complete returns and fulfilment-speed worksheet, for a retail buyer, a factory-side merchandiser at Delta Garments who needs to see how its own cost figures feed a retailer's decisions, or a brand-side contact managing both sides. The first three lessons of this course each taught one separate check; a real decision on a real style needs all three seen together, on one page, before a plan is approved.

A buyer who runs the returns-cost check, the disposition sort, and the fulfilment-speed comparison as three separate, disconnected exercises can approve a reorder plan that looks fine on one check while quietly missing a problem another check would have caught. Without a single combined worksheet, nothing forces all three results to be compared side by side before a decision is made.

03Before you start

You need: the return-cost structure from Lesson 5.1, the disposition rule from Lesson 5.2, and the fulfilment-speed comparison from Lesson 5.3. Lessons 5.1 through 5.3 are useful preparation, though not required.

By the end of this lesson you can:

  • list the three checks a complete returns and fulfilment-speed worksheet combines;
  • build a single style's own complete picture from Cedar & Co.'s own hybrid order;
  • identify which of the three checks a given decision is missing, when only one or two have been run;
  • decide whether a reorder plan should be approved, revised, or checked further, using all three results together.

Not covered here: each of the three checks on its own is covered in Lessons 1 through 3; this lesson only combines them.

04Key terms

Words you will meet in this lesson

TermMeaning
Return rateThe share of pieces sold that customers send back, usually shown as a percentage.
MarkdownA reduction in the shop price of goods that have not sold as forecast, used to clear the remaining stock.
Air freight upgradeMoving some or all of an order by aeroplane instead of by sea to make up lost production days, at a higher freight cost per piece.
Replenishment cycleOne repeating round of Make to Stock production, run against a forecast rather than a single confirmed order.
Average selling priceThe total money taken from a style's sales divided by the number of pieces sold, once full-price and markdown sales are both counted.
05Teaching
The rule

A complete returns and fulfilment-speed decision runs the returns-cost check, the disposition sort, and the fulfilment-speed comparison together, not as three separate exercises

Each of the first three lessons in this course answers one question on its own: what a returned piece costs beyond its refund, what disposition it should get, and whether a fast-fulfilment upgrade is worth its extra cost. A complete worksheet runs all three for the same style, at the same time, because a plan can look sound on one check and still be missing information the other two would supply.

Three checks, run separatelyReturn cost, checked aloneDisposition, checked aloneFulfilment speed, checked aloneOne complete worksheetReturn costDispositionFulfilment speed, together
Three checks run separately can each look fine on their own and still miss a problem the other two would have caught. Running them together, on one style, at one time, is what a complete returns and fulfilment-speed decision actually needs.
What you meet in real life

How a complete worksheet is assembled differs by market, business model, and who owns which part of the underlying figures

What can differThe shapes you meetWhy it matters
Domestic hybrid vs. export MTOA domestic hybrid retailer such as Cedar & Co. can revisit all three checks at reorder, since returns keep arriving and a reorder decision keeps recurring; an export Made to Order retailer usually runs the returns and speed checks once each, tied to a single fixed orderA hybrid retailer's complete worksheet is a repeating habit; an MTO retailer's complete worksheet is closer to a one-time record for a single shipment
Factory-side visibility into the costA factory-side merchandiser at Delta Garments can confirm the buying cost and freight premium figures that feed the worksheet, but does not usually see the retailer's own return rate or disposition resultsA factory-side contact who is asked to help build the worksheet should confirm the cost figures are correct, while leaving the retail-side judgements to the retailer that owns them
A style with very few returnsA style with a very low return rate may find the returns-cost and disposition checks contribute little to its worksheet in a given periodThe complete worksheet still records the returns checks as run, even where the result is small, rather than skipping them because the number looks unimportant
A reorder with no shortfall riskA reorder placed well ahead of the selling season, with no risk of missing the peak weeks, may not need the fulfilment-speed comparison run at allThe fulfilment-speed check is skipped and noted as not applicable only when there is genuinely no shortfall risk to compare, not simply because it seems unlikely
Product familiesThe same three-check structure applies whether the style is apparel, socks and hosiery, or home textilesA retailer new to the complete worksheet can extend the same three-check habit to other product families once it is familiar on one
The case we follow

Mona at Delta Garments confirms the cost figures Cedar & Co. needs to complete its worksheet on a possible 3,000-piece reorder

Cedar & Co. runs its own hybrid style, equivalent to Order A, with 12,000 pieces committed against forecast and a 3,000-piece reorder under consideration once early sales confirm demand. Mona, the merchandiser at Delta Garments, confirms the buying cost of USD 8.00 per piece is unchanged, and that a reorder run inside the normal production schedule carries no extra freight premium, since Cedar & Co.'s reorder moves domestically rather than by international freight.

With the cost confirmed, Omar, the owner of Cedar & Co., brings together this season's returns-cost result, its disposition result, and a check on whether the 3,000-piece reorder needs to be expedited to protect sales during the season's remaining selling weeks.

The worked number

Cedar & Co.'s complete worksheet: a returns cost of USD 3,194 for the season so far, a disposition recovery of USD 1,671.60 on 100 pieces, and a reorder that does not need expediting

Check 1, returns cost (from Lesson 5.1's own worked number):
Refund total: USD 19,900; handling and lost-value cost beyond refund: USD 3,194
True season cost of returns so far: USD 23,094
Check 2, disposition (from Lesson 5.2's own worked number):
100 returned pieces: 60 stock, 30 markdown, 10 written off
Value recovered: USD 1,671.60 of a possible USD 1,990.00
Check 3, fulfilment speed for the 3,000-piece reorder:
Reorder runs inside Delta Garments' normal domestic production schedule
Extra freight premium: USD 0 (no international freight involved)
Conclusion: the reorder does not need an air freight upgrade to reach shops in time

All three checks are now recorded together: the season's true returns cost is USD 23,094, its disposition recovery rate is 84% of full-price potential, and its 3,000-piece reorder needs no fulfilment-speed spending at all, since it moves entirely inside Delta Garments' normal domestic schedule. A style with the same returns and disposition figures but a reorder that risked missing the season's peak weeks would need Check 3 run properly, with a real freight-premium figure, before the reorder could be marked complete.

Check 1: returns cost recorded (USD 23,094)RecordedCheck 2: disposition recovery recorded (84%)RecordedCheck 3: fulfilment speed, not needed this reorderRecorded
All three checks are recorded on Cedar & Co.'s own worksheet, even where Check 3's own answer is "not needed this time." A complete worksheet records every check that was run, not only the ones that changed the outcome.
The method

Four steps to build a complete returns and fulfilment-speed worksheet for a single style

  1. Confirm the cost figures every check depends on, with the factory-side contact if the buying route makes that appropriate.
  2. Run the returns-cost check, totalling the refund, handling cost, and lost resale value across the period.
  3. Run the disposition check, sorting returned pieces into stock, markdown, and write-off, and totalling the value recovered.
  4. Run the fulfilment-speed check on any pending reorder or shipment, comparing extra freight cost against protected margin, and record all three results together before final approval.
The trap

A common mistake is treating a style as fully checked once its returns and disposition figures look acceptable, without also checking whether a pending reorder needs fulfilment-speed spending

A common mistake is stopping at the returns-cost and disposition checks, since they are the two most visible in daily returns handling, and assuming a pending reorder will simply arrive in time without separately checking whether it is at risk of missing the selling season. A style with well-managed returns can still lose sales on an unrelated reorder that was never checked against its own shortfall risk, and that problem does not show up unless the fulfilment-speed check is actually run.

06In plain words

A single style's own returns and speed picture is not properly checked until three separate questions have all been asked and answered together: what returns actually cost beyond the refund, what value is recovered once returns are sorted by condition, and whether any pending reorder needs faster, more expensive fulfilment to protect its own sales. On Cedar & Co.'s own style, the season's returns cost USD 23,094 in total, disposition recovers 84% of full-price potential, and the current 3,000-piece reorder needs no fulfilment-speed spending, since it moves inside Delta Garments' normal domestic schedule. Passing only one or two of these checks is not the same as completing the worksheet.

07Quick check
  • A complete worksheet combines the returns-cost check, the disposition check, and the fulfilment-speed check.
  • A domestic reorder inside a factory's normal schedule can need no fulfilment-speed spending at all, and that result is still recorded, not skipped.
  • A factory-side contact can confirm the cost figures that feed every check, without owning the retail-side judgements built on top of them.
  • Well-managed returns and disposition results do not by themselves confirm a pending reorder is also on track.
  • All three checks recorded together, even where one result is "not needed," is what a complete worksheet actually shows.
  • A hybrid, domestic style revisits all three checks as new returns and reorders arrive, unlike a one-time export order.
08Workplace scenario

Omar must decide whether Cedar & Co.'s reorder plan is ready for approval after only the returns and disposition checks have been reviewed

Cedar & Co.'s planning assistant reports that this season's returns cost and disposition recovery both look acceptable against past seasons, and recommends approving the 3,000-piece reorder plan on that basis, since the two checks reviewed both look fine. The facts in front of Omar:

  • Check 1, returns cost, and Check 2, disposition, have both been reviewed and look acceptable.
  • Check 3, the fulfilment-speed check on the 3,000-piece reorder, has not yet been run.
  • The planning assistant assumes the reorder will arrive in time without checking it separately.

The note from the planning assistant's own file:

Cedar & Co., internal planning note. "Returns cost and disposition recovery both in line with past seasons. Recommend approving the reorder plan on this basis."

Should Omar approve the reorder plan now, on the strength of the returns and disposition checks alone? Decide before you open the decision.

Show decision

No. Omar should not approve the reorder plan until the fulfilment-speed check has also been run on the 3,000-piece reorder.

Two facts decide this. First, this lesson's own rule states a complete worksheet requires all three checks, and this lesson's own trap warns specifically against assuming a pending reorder is on track just because the returns and disposition checks look acceptable. Second, this lesson's own worked number shows the fulfilment-speed check can return either "no spending needed" or a real freight-premium recommendation, and that answer is not known until the check is actually run.

Once run, the fulfilment-speed check happens to confirm this particular reorder needs no extra spending, since it moves domestically inside Delta Garments' normal schedule; but that conclusion has to come from running the check, not from skipping it because the other two checks already looked fine.

09What it costs

Approving the reorder without running Check 3 risks the same kind of shortfall this course's own Lesson 5.3 already showed can cost thousands of dollars

If Check 3 had been skipped and the reorder had, unlike this case, genuinely needed expediting:
Extra freight cost of expediting a 3,000-piece shortfall at the same per-piece premium as Lesson 5.3's own figures: 3,000 x 1.30 = USD 3,900
Margin protected at the same per-piece margin as Lesson 5.3's own figures: 3,000 x 4.30 = USD 12,900
Net benefit that would have been missed by skipping the check entirely: 12,900 - 3,900 = USD 9,000

This is the same structure Lesson 5.3 already worked through in full; it is repeated here to show what skipping Check 3 could have risked, had this particular reorder actually needed expediting rather than moving safely inside the normal domestic schedule. A complete worksheet exists precisely so a shortfall like this is caught and priced before a decision is made, not discovered afterward once shelves are already empty.

10Working template

Returns and fulfilment-speed worksheet: run all three checks for one style on a single page before final approval

Use the T21-C05 Returns and fulfilment-speed worksheet in full. Enter the season's refund, handling cost, and resale outcomes on the first sheet to confirm the returns-cost check, enter each returned piece's condition grade on the second sheet to run the disposition check, and enter any pending reorder's shortfall quantity and freight figures on the third sheet to run the fulfilment-speed check. The fourth sheet draws all three results together into one combined view, so a style's own plan is visible as complete, or as still missing a check, on one page.

[Download the Returns and fulfilment-speed worksheet](../../templates/T21-C05-returns-and-fulfilment-speed-worksheet.xlsx)

Download the Returns and fulfilment-speed worksheet (Excel)

11Check yourself

1. What three checks does a complete returns and fulfilment-speed worksheet combine?

2. Cedar & Co.'s returns and disposition checks both look acceptable. Is its reorder plan ready for approval?

3. A factory-side merchandiser is asked to help a retailer build its complete returns and fulfilment-speed worksheet. What is the merchandiser's own appropriate role?

12Glossary
ENARFRTRMeaning
Return rateمعدل الإرجاعTaux de retourİade oranıThe share of pieces sold that customers send back, usually shown as a percentage.
Markdownتخفيض السعرDémarqueİndirim (markdown)A reduction in the shop price of goods that have not sold as forecast, used to clear the remaining stock.
Air freight upgradeالترقية إلى الشحن الجويSurclassement en fret aérienHava taşımacılığına yükseltmeMoving some or all of an order by aeroplane instead of by sea to make up lost production days, at a higher freight cost per piece.
Replenishment cycleدورة تجديد المخزونCycle de réassortYeniden stoklama döngüsüOne repeating round of Make to Stock production, run against a forecast rather than a single confirmed order.
Average selling priceمتوسط سعر البيعPrix de vente moyenOrtalama satış fiyatıThe total money taken from a style's sales divided by the number of pieces sold, once full-price and markdown sales are both counted.
13Next

Track 22, Course 1: to be confirmed

You now hold a complete returns and fulfilment-speed worksheet, from a single return's own cost through its disposition to a fulfilment-speed comparison. The next track in this academy builds on this same worksheet habit for a different planning decision. Back to the course map

14Ladder

RecognizeName the three checks a complete returns and fulfilment-speed worksheet combines.
ConnectSee how a reorder can need no fulfilment-speed spending, and that this result is still recorded, not skipped.
CompareTell a factory-side contact's role in confirming cost figures apart from a retailer's own returns and reorder judgements.
DecideJudge whether a style's own plan is fully checked, or still missing one of the three required checks.