Course contents
Practitioner · Course 3: Inventory Accuracy and Shrinkage · Lesson 4 of 5

Calculating the real cost of inventory inaccuracy on an order's own margin

Level: PractitionerTime: 45 minutesOrder used: A (the T-shirt)Tool: Inventory accuracy and shrinkage tracker
For sourcing agents and buyers who need to turn a confirmed inventory shortfall into a number that shows exactly what it takes off an order's own margin, not just a units-lost count. Lesson 3.3 is useful preparation, not required. The figures are teaching figures built on Order A.
AgentMeridian Sourcing (5% commission)
FactoryDelta Garments
OrderA — 15,000 T-shirts
Agreed FOBUSD 3.20 per piece
Units affected60 units, one European DC
Planned margin per unitUSD 0.26 (FOB profit component)
02Opening

This page teaches how to turn a confirmed inventory shortfall into a number that shows exactly what it costs an order's own planned margin, not just how many units are missing

A units-lost count tells a factory or a buyer that something went wrong; it does not tell anyone whether that loss is a rounding error against the order's total value or a serious dent in the profit the order was supposed to deliver. An agent representing a buyer needs the second kind of number, because the agent's own job is to protect the buyer's commercial interest across the whole order, and "60 units are missing" means something very different on a 15,000-piece order than it would on a 500-piece one.

This lesson gives you the calculation that turns a confirmed shortfall, already sorted into its cause in Lesson 3.3, into a share of an order's own planned margin. You will apply it to Meridian Sourcing, the agent representing two European buyers on a mixed Make to Order and Make to Stock account, using Order A's own fixed FOB and margin figures as the reference.

03Before you start

What you need, and what this lesson does not cover

You need: how to sort a confirmed variance into theft, damage or administrative error (Lesson 3.3), and Order A's own fixed cost breakdown (docs/02 section 7).

By the end of this lesson you can:

  • separate an order's total value from its planned margin;
  • calculate the margin lost to a confirmed number of missing units;
  • express that loss as a share of the order's own total planned margin;
  • compare the scale of a shortfall against the order's margin rather than against its total value alone;
  • decide when a shortfall's cost justifies further investigation or a security response.

Not covered here: identifying the cause of a shortfall (Lesson 3.3), or building the full tracker workbook (Lesson 3.5). This lesson only teaches the margin-cost calculation.

04Key terms

Words you will meet in this lesson

TermMeaning
Cost of inventory inaccuracyThe share of an order's own planned margin lost to units the book stock claims exist but that are not actually there to sell.
Planned margin per unitThe profit component built into a piece's agreed price, before any inventory loss is applied against it.
Total planned marginThe planned margin per unit multiplied by the order's full confirmed quantity, the profit the whole order was designed to deliver.
Share of margin lostThe margin lost to a confirmed shortfall, divided by the order's total planned margin, shown as a percentage.
MarginProfit divided by the selling price, shown as a percentage of what a company sells for.
Hybrid accountA buyer relationship that combines Make to Order and Make to Stock business with the same factory.
05Teaching
The rule

A shortfall's real cost is measured against the order's own planned margin, not against its total value, because margin is what the loss actually erodes

An order's total value and its planned margin are two different numbers built from the same price. Order A's agreed FOB of USD 3.20 per piece already contains fabric, trims, making, overhead and profit as separate components (docs/02 section 7); when a unit goes missing, the factory and the buyer do not simply lose USD 3.20 of activity, they lose the profit component that unit was supposed to contribute, because the fabric, trims and making cost for that unit were typically already spent before it disappeared. Measuring a shortfall against total order value understates how much of the loss actually falls on profit; measuring it against planned margin shows the real damage.

Order A's own FOB price, USD 3.20 per piece, by componentFabric 1.15TrimsMaking 1.10OverheadProfit 0.26A missing unit erodes mainly this last, smallest slice
Profit is the smallest slice of Order A's own FOB price. A missing unit's real cost falls mainly on that slice, not on the full USD 3.20.
What you meet in real life

What counts as the "margin at risk" changes with who is measuring the loss and what business model the order runs under

What can differThe shapes you meetWhy it matters to you
Who bears the lossOn an FOB order like Order A, the factory has usually already been paid or is close to payment once goods ship, so a shortfall discovered downstream, at a distribution centre or a shop, falls on the buyer's or the agent's own commercial result, not the factory's.The party asking "what does this cost me" needs the margin figure relevant to their own position in the chain, not a generic total.
Business modelA Make to Order shipment's margin is fixed at the point the order was priced; a Make to Stock or hybrid account's margin can shift with markdowns taken later in the season, so the same unit lost early in the season costs more margin than one lost after a markdown.The timing of a loss inside a hybrid account's own selling season changes how much margin that loss actually erodes.
Agent's own commissionMeridian Sourcing earns a 5% commission on the orders it represents (docs/02 section 6); a shortfall that reduces the buyer's realised sales also reduces the commission base the agent earns from, giving the agent its own direct reason to track the cost of inaccuracy.An agent's incentive to investigate a shortfall is not only the buyer's interest; the agent's own commission is tied to the same number.
MarketAn export order's margin is usually calculated in a single agreed currency, such as Order A's USD price; a domestic Make to Stock chain may also need to account for a local currency's own movement against a foreign-currency cost base.The currency the margin is measured in should match the currency the business actually plans and reports in.
Scale of the orderThe same 60-unit shortfall is a small share of a 15,000-piece order like Order A but a much larger share of a smaller repeat order.The share of margin lost, not the raw unit count, is what tells you whether a shortfall is minor or serious.
The case we follow

Meridian Sourcing tracks a 60-unit shortfall of Order A's T-shirt found at a European distribution centre against the order's own total planned margin

Meridian Sourcing represents two European buyers on a hybrid account with Delta Garments, earning a 5% commission on the business it places (docs/02 section 6). One of those buyers takes delivery of Order A's T-shirt, 15,000 pieces at the agreed FOB of USD 3.20 per piece, which already includes a profit component of USD 0.26 per piece (docs/02 section 7). A shortfall of 60 units is confirmed at the buyer's own European distribution centre, already sorted in Lesson 3.3's method into a mix of administrative error and unknown shrinkage.

Meridian's own commercial interest in this number is direct: a smaller realised sale from the affected units also means a smaller commission base for Meridian itself, on top of the buyer's own lost margin.

The worked number

The 60-unit shortfall's cost is measured against Order A's own total planned margin, not against its total FOB value

Order A's planned margin per unit: USD 0.26
Units affected by the shortfall: 60 units
Margin lost: 60 × USD 0.26 = USD 15.60
Order A's total planned margin: 15,000 × USD 0.26 = USD 3,900
Share of the order's own margin lost: USD 15.60 ÷ USD 3,900 = 0.4%

Measured against Order A's total FOB value of USD 48,000 (15,000 × USD 3.20), the 60 missing units at USD 3.20 each would look like USD 192, already a small figure. Measured correctly against the order's own USD 3,900 total planned margin, the real cost is USD 15.60, or 0.4% of the margin the whole order was built to deliver. Both figures are small here, which is itself the useful finding: this particular shortfall does not justify a large investigation, but the method is what lets Meridian say that with confidence instead of guessing.

Measured against total FOB valueMeasured against total planned marginUSD 192of USD 48,000 (0.4%)USD 15.60of USD 3,900 (0.4%)
Both views happen to give the same 0.4% share here, because the shortfall's units are priced at the full FOB rate. The margin-based view is still the correct one to use, since a real order's cost mix, or a later markdown, can make the two percentages diverge sharply.
The method

Calculate a shortfall's cost against an order's own margin in four steps

  1. Identify the order's own planned margin per unit, from its fixed cost breakdown (docs/02 section 7, covering Order A and Order B's own jeans figures), not its full selling price.
  2. Multiply the planned margin per unit by the confirmed number of units affected by the shortfall to get the margin lost.
  3. Calculate the order's total planned margin by multiplying the planned margin per unit by the order's full confirmed quantity.
  4. Divide the margin lost by the total planned margin to get the share of the order's own margin the shortfall represents, and use that share, not the raw unit count, to judge how serious the shortfall is.
The trap

A common mistake is reporting a shortfall's cost as units lost multiplied by the full selling price, rather than by the planned margin per unit

Multiplying missing units by the full FOB or retail price overstates the loss, because much of that price was already spent on fabric, trims, making and overhead before the unit disappeared; that cost is already gone whether the unit is sold or not. Reporting the inflated, full-price figure can trigger a disproportionate response, such as an expensive security overhaul, for a loss that a correctly calculated margin figure would show as minor, or it can understate a genuinely serious loss on an order with a very thin margin, where even a small unit count represents a large share of the profit at stake.

06In plain words

When stock goes missing, do not simply multiply the missing units by the full price to say what it costs. Most of that price was already spent making the piece before it disappeared. What is actually lost is the profit slice built into the price, so multiply the missing units by that profit slice instead, then compare the result to the total profit the whole order was supposed to earn. That comparison tells you, as a clear percentage, whether a shortfall is a rounding error or a real dent in the order's own result.

07Quick check
  • A shortfall's real cost is the planned margin per unit, not the full selling price, multiplied by the units affected.
  • Total planned margin is the planned margin per unit multiplied by the order's full quantity.
  • The share of margin lost is the margin lost divided by the total planned margin, shown as a percentage.
  • The same unit count can represent a tiny share of margin on a large order and a large share on a small one.
  • An agent's own commission is tied to the same sales figure a shortfall reduces, giving the agent a direct stake in tracking this cost.
08Workplace scenario

Meridian Sourcing must decide whether a second, larger shortfall at the same distribution centre justifies a formal request for a security review

Three months after the 60-unit shortfall, the same European distribution centre confirms a second shortfall of 900 units on a later, smaller repeat order of the same T-shirt style, 3,000 pieces at the same USD 0.26 planned margin per unit.

  • The 900 units is far larger in raw count than the earlier 60-unit shortfall.
  • The repeat order's own total quantity, 3,000 pieces, is much smaller than Order A's 15,000.
  • The distribution centre has not yet confirmed a specific cause for the new shortfall.

Should Meridian judge the new shortfall as roughly the same seriousness as the first one, since both involve the same style and the same margin per unit? Decide before opening the answer.

Show decision

No. Meridian should calculate the new shortfall's share of its own order's margin, which shows it as far more serious than the first, and this justifies raising a formal request for a security review.

1. The new shortfall's margin lost is 900 × USD 0.26 = USD 234, against a total planned margin for the smaller order of 3,000 × USD 0.26 = USD 780, a share of 30%. 2. The first shortfall's share was 0.4% of Order A's own margin; the new share of 30% is roughly 75 times larger, even though the unit count only grew about 15 times, because the smaller order has far less total margin to absorb the same kind of loss. 3. A 30% share of an order's own planned margin is large enough to justify formally requesting a security review at the distribution centre, rather than logging it as routine shrinkage.

Comparing raw unit counts across two different order sizes would have hidden how much worse the second shortfall actually is; comparing the share of each order's own margin makes the difference in seriousness immediately clear.

09What it costs

Meridian's own commission is exposed to the same shortfall, on top of the buyer's lost margin

Meridian Sourcing earns a 5% commission on the business it represents (docs/02 section 6). Applied to the value of the units actually lost from Order A's shortfall:

60 units × USD 3.20 FOB = USD 192 in sales value affected by the shortfall
5% commission × USD 192 = USD 9.60 in commission Meridian does not earn on those units

USD 9.60 is a small figure on its own, consistent with this shortfall's overall minor scale, but it illustrates why an agent's interest in tracking the cost of inventory inaccuracy is not purely on the buyer's behalf: every unit lost to shrinkage anywhere in the chain also reduces the commission base the agent's own income depends on.

10Working template

Inventory accuracy and shrinkage tracker: calculate the cost of inaccuracy against an order's own margin

Use the T21-C03 Inventory accuracy and shrinkage tracker workbook, "Cost of inaccuracy on margin" sheet. For each confirmed shortfall, record the order reference, the units affected, the planned margin per unit, the order's own total planned margin, and let the sheet calculate the margin lost and its share. Start with Meridian's Order A example above, then add a shortfall of your own.

[Download the Inventory accuracy and shrinkage tracker workbook](../../templates/T21-C03-inventory-accuracy-shrinkage-tracker.xlsx)

Download the Inventory accuracy and shrinkage tracker (Excel)

11Check yourself

1. Why is a shortfall's cost measured against an order's planned margin rather than its full selling price?

2. 60 units of Order A are missing, each with a planned margin of USD 0.26, on a 15,000-piece order with a total planned margin of USD 3,900. What share of margin is lost?

3. A repeat order of 3,000 pieces loses 900 units at the same USD 0.26 planned margin per unit. What share of that order's own margin is lost?

12Glossary
ENARFRTRMeaning
Cost of inventory inaccuracyتكلفة عدم دقة المخزونCoût de l'imprécision des stocksEnvanter hatasının maliyetiThe share of an order's own planned margin lost to units the book stock claims exist but that are not actually there to sell.
Planned margin per unitالهامش المخطط للوحدةMarge prévue par unitéPlanlanan birim marjThe profit component built into a piece's agreed price, before any inventory loss is applied against it.
Total planned marginإجمالي الهامش المخططMarge totale prévueToplam planlanan marjThe planned margin per unit multiplied by the order's full confirmed quantity, the profit the whole order was designed to deliver.
Share of margin lostنسبة الهامش المفقودPart de la marge perdueKaybedilen marj payıThe margin lost to a confirmed shortfall, divided by the order's total planned margin, shown as a percentage.
MarginالهامشMargeMarjProfit divided by the selling price, shown as a percentage of what a company sells for.
Hybrid accountحساب مختلطCompte hybrideHibrit hesapA buyer relationship that combines Make to Order and Make to Stock business with the same factory.
13Next

Lesson 3.5: Building a complete inventory accuracy and shrinkage tracker

Next you will bring book-versus-physical checks, cycle counts, shrinkage causes and margin cost together into one complete working tool you can run on any order the business handles. Back to the course map

14Ladder

RecognizeTell an order's total value apart from its own planned margin.
ConnectSee why a missing unit erodes mainly the profit slice of its price, not the full price.
CompareJudge a shortfall's seriousness by its share of margin, not by its raw unit count.
DecideChoose when a calculated share of margin lost justifies escalating to a formal security response.