Decision software for grocery chains

How to calculate shrinkage rate and what an acceptable level is

Last updated: 5 October 20269 min read

Who it is forGrocery chain fresh and department managers, store managers, loss prevention teams

Shrinkage is the easiest line in retail to measure and the least managed. Easy, because the formula is one line; unmanaged, because in most businesses it sits as a single total with no recorded cause. A 2 per cent shrinkage rate in a grocery business running at a 25 per cent margin takes an eighth of the profit — a line the same size as rent. This guide covers the calculation, coding by cause and the acceptable ranges.

How shrinkage rate is calculated

Shrinkage is the cost of goods that leave stock without being sold. Spoilage, breakage, expiry, preparation loss and theft all sit under this heading.

There are two core calculations. The value-based rate divides the cost of shrinkage by net sales and is the right measure for management reporting; it makes different categories comparable. The unit-based rate is for operational tracking: the department manager knows how many items went in the bin.

A third calculation is used in produce trimming and at the delicatessen and butchery counters: preparation yield. How many grams remain from a kilogram of spinach after trimming is a direct input to the recipe cost of packed and in-store prepared products, and the ratio varies between 5 and 45 per cent depending on the ingredient.

Shrinkage rate (value)
Cost of shrinkage ÷ Net sales × 100
Shrinkage rate (units)
Shrinkage units ÷ Total units issued × 100
Preparation loss
(Gross weight − Net weight) ÷ Gross weight × 100
Yield
100 − Preparation lossRecipe cost is corrected by this yield.

Do not calculate shrinkage on retail price. Shrinkage is a cost loss, not a revenue loss; a rate calculated at retail inflates by the margin.

Known and unknown shrinkage

Shrinkage divides in two and the two are managed in completely different ways. Known shrinkage is recorded as it happens: the spoiled item is weighed, entered as shrinkage, and the reason is written down. Unknown shrinkage only appears at the count — goods in the record are not on the shelf.

Unknown shrinkage comes from one of three places: theft, recording error, or shrinkage that was never entered. All three have different fixes, which is why leaving it as a single "count variance" line destroys the information.

In a healthy operation at least 70 per cent of total shrinkage should be known shrinkage. As the unknown share rises, the problem is not in stock but in process: either shrinkage is not being recorded, or goods are disappearing.

Shrinkage types, causes and where to intervene
TypeHow it is detectedTypical causeIntervention
Spoilage / expiryShrinkage recordOver-ordering, poor rotationOrder quantity and FEFO discipline
Breakage / damageShrinkage recordHandling, shelf layoutWarehouse and display training
Preparation lossRecipe yieldNon-standard preparationRecipe standards and weighing
TheftCount varianceDisplay position, weak controlsHigh-risk SKU list, repositioning
Recording errorCount varianceWrong barcode, incomplete receivingGoods receipt control, barcode discipline
Unrecorded shrinkageCount varianceProcess not being followedDaily shrinkage entry at department level

What an acceptable shrinkage rate is

A zero-shrinkage target is wrong. In fresh, zero shrinkage means the shelf was empty at the end of the day; that is an unrecorded lost sale and it costs more than the shrinkage would have.

The right approach is a target band per category. Falling below the band is not success in shrinkage management; it probably means you ran out of stock. Rising above it is an ordering or rotation problem.

The ranges below are typical values observed in Turkish grocery chains. Build your own target from the last twelve months' distribution and from the performance of your best-performing store at department level.

Typical shrinkage band by category (approximate bands from industry practice, not research data)
CategoryTypical bandIf below the bandBinding constraint
Fruit and vegetables3% - 6%The shelf is probably running emptyShelf life of 2-5 days
Meat and delicatessen1.5% - 3%Assortment may have been cutCold chain, expiry dates
Bakery and patisserie4% - 8%End-of-day range is too thinDaily production
Dairy0.8% - 2%Rotation is working wellExpiry, FEFO
Ambient grocery0.2% - 0.8%NormalBreakage, theft
Personal care and cleaning0.5% - 1.5%NormalMostly theft

Be careful about tying a store manager's bonus to the shrinkage rate. Set as a one-way target, shrinkage simply stops being recorded and the loss migrates into the count variance. Bonuses should be tied to total loss, not to recorded shrinkage.

Making shrinkage recording work

All shrinkage management rests on recording discipline. Shrinkage without a recorded cause is shrinkage that cannot be reduced.

  1. Fix the reason codesA short list of no more than eight: expiry, spoilage, breakage, preparation, non-returnable, display, sample, other. Long lists do not get used; short ones do.
  2. Move recording to where the work happensShrinkage is entered on a handheld at the shelf, not from a PC in the office. Scan the item, pick the reason, done. Any process with a form in the middle will not be followed.
  3. Set a daily threshold alertWhen a SKU's daily shrinkage exceeds twice the four-week average, an alert is raised and lands on the department manager as a task.
  4. Link approaching expiry to markdownItems reaching the remaining shelf life threshold go onto the markdown list automatically. An item sold at 30 per cent off always beats one binned at a 100 per cent loss.
  5. Feed shrinkage data back into orderingThe order coefficient is reduced for SKUs with high shrinkage. Until the shrinkage report is connected to the ordering system, the same shrinkage repeats every week.

Frequently asked questions

How is shrinkage rate calculated?
The cost of shrinkage is divided by net sales and multiplied by a hundred. A store with ₺1,000,000 net sales and ₺18,000 of shrinkage at cost has a rate of 1.8 per cent. For operational tracking, shrinkage units are divided by total units issued.
What is an acceptable shrinkage rate?
It varies by category: 3-6 per cent in fruit and vegetables, 1.5-3 per cent in meat, 0.2-0.8 per cent in ambient grocery. A zero target is wrong: zero shrinkage in fresh means the shelf ran empty and sales were missed.
Is shrinkage calculated at cost or at retail?
At cost. Shrinkage is a cost loss, not a revenue loss; calculated at retail the rate inflates by the margin and cross-category comparison breaks down.
What is unknown shrinkage?
Stock that shows in the record but is not on the shelf, discovered during a count. It comes from three sources: theft, recording error and shrinkage that was never entered. At least 70 per cent of total shrinkage should be known shrinkage.
How is preparation yield calculated?
Net weight is subtracted from gross weight and divided by gross weight. If 1,000 grams of gross spinach yields 620 grams of usable product, preparation loss is 38 per cent and yield is 62 per cent. Recipe cost is corrected using that yield.
How much does shrinkage affect margin?
Directly and disproportionately. In a grocery business running a 25 per cent gross margin, a 2 per cent shrinkage rate removes 8 per cent of gross profit. Unless shrinkage sits on its own line beside gross margin, the reason for a margin decline stays invisible.

Let us build this calculation on your data

Knowing the formula is not enough; the data has to sit at the right grain. Our team does the installation. We will go through your current setup together in 30 minutes.