Where Inventory Waste Comes From in Distribution and Trading
Distributors and trading companies live on volume and thin margins. Every carton that expires on the shelf, every item that has not moved for a year, every pallet damaged in handling comes straight out of a margin that may only be a few percent of sales. Reducing inventory waste is often the quickest way for a trading business to improve profit without selling a single extra unit.
Inventory waste is any stock that loses value before it earns revenue, plus the cost of holding stock you did not need. It rarely comes from one big mistake. It builds up from many small decisions: an order rounded up "to be safe", a promotion bought for but not executed, a slow item no one reviewed, a new batch put in front of an old one.
This guide breaks inventory waste into its types, shows how to measure your own baseline, and walks through the planning practices that prevent it: forecasting, classification, reorder points and safety stock, expiry control, multi-warehouse balancing and clearance of slow movers, with worked numbers and the Saudi requirements that apply.
The Six Types of Inventory Waste
| Type | What it looks like | Main cause |
|---|---|---|
| Expiry | Food, beverages, cosmetics or medicines passing their date | Overbuying, poor rotation, weak visibility of dates |
| Dead and slow stock | Items with no or very low movement for months | Wrong range decisions, forecast errors, end of product life |
| Obsolescence | Old models, discontinued packaging, superseded parts | No lifecycle planning for products being replaced |
| Damage | Crushed cartons, broken glass, heat damage | Handling, stacking, storage conditions |
| Shrinkage and discrepancies | System stock higher than physical stock | Theft, picking errors, unrecorded movements |
| Excess carrying cost | Stock that will sell, but far later than needed | Large order quantities, inflated safety stock |
Measure Your Own Baseline First
Published "average waste" figures for the sector vary widely and are rarely comparable. Your own numbers are what matter. Run these reports for the last twelve months before changing anything:
- Write-offs by reason: expired, damaged, obsolete, count adjustments. If reasons are not recorded today, start recording them now.
- Stock ageing: value of stock by days since last receipt and days since last sale, by item and warehouse.
- Days of cover: current stock divided by average daily sales, item by item. Anything above 180 days deserves a question.
- Near-expiry exposure: value of stock expiring in the next 30, 60 and 90 days compared with expected sales in those windows.
- Count accuracy: percentage of counted lines where system and physical stock matched.
This baseline tells you which waste type is biggest for your business. A beverage distributor may find expiry dominates; a building materials trader may find dead stock and damage are the main problems.
Forecast Demand at Item Level
Waste starts with buying more than will sell in time. A forecast does not need to be sophisticated to beat gut feel; it needs to be at item level, updated regularly and measured.
A simple seasonal forecast
Take a hypothetical juice SKU that averages 1,000 cartons a month outside peak periods. Looking at the last two years, sales in the Ramadan month ran at about 1.8 times the normal level, and the month after at about 0.7 times as households used up stock. A forecast that applies these seasonal indices to the base level gives 1,800 cartons for Ramadan and 700 for the following month. Ramadan moves about 11 days earlier each year in the Gregorian calendar, so seasonal indices should be tied to the Hijri period, not to a fixed Gregorian month.
Measure forecast error
Track forecast against actual sales every month using mean absolute percentage error (MAPE) or a similar measure, by item group. The aim is not perfection but improvement, and knowing which items are predictable and which are not. Unpredictable items need a different policy, not a better forecast.
Bring in sales and suppliers
Sales teams know about a new chain listing, a lost customer or a planned promotion before it appears in the data. A simple monthly step where sales adjust the statistical forecast, with a reason recorded, catches much of this. Sharing the forecast with key suppliers helps them plan too.
Classify Items and Set Policies by Class
Not every item deserves the same attention. ABC analysis ranks items by annual consumption value: typically a small share of items (A) accounts for most of the value, and a long tail (C) for very little. Our guide to ABC analysis explains the method. Adding XYZ, a classification by demand variability, gives a matrix that drives policy:
| X: stable demand | Y: variable demand | Z: irregular demand | |
|---|---|---|---|
| A: high value | Frequent replenishment, low safety stock, close review | Moderate safety stock, frequent forecast review | Order against confirmed demand where possible |
| B: medium value | Standard reorder point | Reorder point with higher safety stock | Min-max with periodic review |
| C: low value | Larger, less frequent orders, light monitoring | Periodic review | Stock only if strategic; otherwise order on request |
Recalculate the classes every quarter. Items move between classes as customers and markets change, and a policy set for last year's demand pattern creates waste this year.
Reorder Points and Safety Stock With Real Numbers
A reorder point tells the system when to buy: the stock level that covers demand during the supplier's lead time plus a safety buffer. The common formula is:
Reorder point = average daily demand × lead time in days + safety stock
Safety stock protects against demand variability during the lead time. One standard approach is safety stock = z × standard deviation of daily demand × √lead time, where z reflects the service level you want.
Hypothetical example: an item sells on average 40 units a day with a daily standard deviation of 12 units. The supplier's lead time is 9 days. For a 95% service level, z is about 1.65.
- Safety stock = 1.65 × 12 × √9 = 1.65 × 12 × 3 ≈ 60 units
- Reorder point = 40 × 9 + 60 = 420 units
If a buyer instead set safety stock at "two weeks' sales" to be safe, that would be 560 units, more than nine times the calculated buffer, and that extra stock would sit in the warehouse permanently. Multiply that across hundreds of items and the cost is large. Equally, if lead time becomes unreliable, for example during shipping disruption, the formula should use the longer, more variable lead time rather than the supplier's promise. Our article on safety stock covers more methods.
Use a higher service level for A items that customers expect always to find, and a lower one for C items where an occasional stockout costs little. Review reorder points automatically from recent demand, for example monthly from the last 90 days, adjusted ahead of known seasons.
Control Expiry With FEFO and Date Visibility
For anything with a shelf life, the single most effective control is first expired, first out (FEFO): always pick the batch with the nearest expiry date that still meets the customer's requirement. That requires the system to know the batch and expiry date of every unit in stock and to direct pickers accordingly.
- Capture dates at receipt: batch number and expiry date recorded when goods are received, ideally by scanning.
- Enforce FEFO in picking: the system suggests the batch to pick, and overriding it requires a reason.
- Customer shelf-life rules: many retailers refuse deliveries below a minimum remaining shelf life. Store that rule per customer so the system only allocates batches that will be accepted.
- Tiered alerts: for example at 90 days to plan promotions, 60 days to offer to discount channels, 30 days to clear or arrange approved disposal, and a block on sale once expired.
In Saudi Arabia, SFDA standard SFDA.FD 150-1 sets mandatory expiration dates for certain food products, with a second part covering voluntary dates. Food establishments, including warehouses and distribution centres, must have a food traceability guide, keep traceability records for at least 180 days, and be able to recall or withdraw products when required. Batch-level stock records serve both expiry control and these obligations.
Balance Stock Across Warehouses and Branches
A distributor with branches in Riyadh, Jeddah and Dammam often has an item overstocked in one city and short in another. Without a single view, the short branch places a new purchase order while the surplus in the other branch ages. A unified stock view with days of cover by location lets planners transfer before buying. A simple rule helps: before approving a purchase for one warehouse, check whether another holds more than, say, 90 days of cover for the same item.
Storage conditions matter too. Heat damage is a real risk in Saudi summers for chocolate, cosmetics, some medicines and beverages. Assign temperature-sensitive items to suitable zones in the warehouse system, and record damage by cause so you can see whether it comes from storage, handling or transport.
Clear Slow Movers Before They Become Dead Stock
Every item should have a "next action" once it crosses an ageing threshold. A graduated approach works well:
- Stop buying: block replenishment for items over the threshold until reviewed.
- Move it: transfer to the branch or channel where it sells.
- Bundle or promote: pair with fast movers or include in targeted offers.
- Return or exchange: negotiate with the supplier where agreements allow.
- Liquidate: sell through clearance channels at reduced margin.
- Dispose properly: where nothing else works, write off and dispose in line with the rules for that product category.
Our article on dead stock covers prevention and clearance in more depth.
The accounting side
Under IAS 2, inventory is measured at the lower of cost and net realisable value. When expected selling price less costs to sell falls below cost, because an item is near expiry, damaged or obsolete, the write-down should be recognised in that period, not when the stock is finally thrown away. If circumstances later improve, the write-down is reversed, limited to the original amount. A monthly ageing and near-expiry review in the ERP gives finance the evidence it needs for these provisions.
Know What Holding Stock Really Costs
The cost of carrying inventory is more than the warehouse rent. It includes the financing cost of the cash tied up, storage space and utilities, handling labour, insurance, shrinkage and the risk of expiry or obsolescence. Many companies estimate the total as a percentage of average inventory value per year. As a hypothetical illustration, if your own estimate is 20% a year, then SAR 2 million of stock above what you need costs about SAR 400,000 a year to hold, money that disappears without ever appearing as a single "waste" line. Calculate the percentage from your own cost of finance and warehouse costs rather than borrowing someone else's figure.
Measures to Track Every Month
| Measure | Calculation |
|---|---|
| Expiry write-off rate | Value written off for expiry ÷ cost of goods sold |
| Slow stock ratio | Value of stock with no sale in 180 days ÷ total stock value |
| Inventory turnover | Cost of goods sold ÷ average inventory |
| Forecast error | MAPE by item group |
| Fill rate | Order lines delivered in full ÷ total order lines |
| Count accuracy | Lines matching on count ÷ lines counted |
Watch fill rate alongside the waste measures. Cutting stock aggressively reduces waste but can cause stockouts, which cost sales and customers. The goal is the right stock, not the least stock.
How Tranquil Helps
Tranquil is a cloud ERP whose inventory management supports central inventory, multiple units of measure, pre-assemblies and assembly, connected to purchasing, sales and distribution, POS and financial accounting. That gives planners and finance a single record of stock, purchases and sales across branches, with customisable reports and approvals to fit each company's controls.
Frequently Asked Questions
What is the fastest way to reduce inventory waste?
Start by measuring write-offs by reason and stock ageing, then stop replenishing slow items and enforce FEFO for dated products. These steps usually show results within a few months.
How do we plan for Ramadan and other seasonal peaks?
Build seasonal indices from your own history, tied to the Hijri calendar, and raise reorder points and orders several weeks before the peak, then lower them promptly after it to avoid post-season excess.
Should every item have safety stock?
No. Items with irregular demand and low value can often be ordered against confirmed demand. Safety stock should be calculated for items you have decided must be available.
When should near-expiry stock be written down?
As soon as its expected selling price less costs to sell falls below cost, under IAS 2, rather than waiting until it is destroyed.
Can an ERP replace a dedicated forecasting tool?
For many distributors, statistical forecasting and reorder logic in the ERP is enough, especially when sales adjust it monthly. Contact the Tranquil team to discuss your inventory planning.