Inventory Is an Asset and a Leak at the Same Time
For trading, distribution and manufacturing companies in the Gulf, inventory is usually one of the largest current assets on the balance sheet. It is cash turned into goods, waiting to turn back into cash. Every day stock sits still, the business pays for it: warehouse space, insurance, financing, and the risk of damage, obsolescence or loss.
Running lean is not automatically the answer either. A stockout on a popular item is a lost sale and sometimes a lost customer. Smart inventory management means finding the balance between those two risks with data instead of instinct. This guide defines the forms inventory waste takes, puts a number on what holding stock costs, and then works through the practical tools: classification, reorder points, safety stock, economic order quantity, expiry-based picking, cycle counting, KPIs, and how an ERP system connects them.
What "Smart" Actually Means
It is not a buzzword for expensive technology. It means that buying, storing and issuing decisions are based on current, accurate data about stock levels, demand and supplier lead times, rather than on the storekeeper's memory or the habit of ordering the same quantity every month.
| Area | Traditional | Smart |
|---|---|---|
| Stock visibility | Occasional full counts; balances in between are guesses | Live balances from recorded transactions, verified by cycle counts |
| When to buy | Experience, or when someone notices a gap | A calculated reorder point per item |
| How much to buy | The usual quantity or whatever the supplier offers | Quantity based on demand, ordering cost and holding cost |
| Slow movers | Found at the annual count | Regular report of items with no movement |
| Expiry | Whatever is at the front ships first | Earliest expiry ships first |
| Management attention | Spread evenly across all items | Concentrated on high-value, high-impact items |
The Five Forms of Inventory Waste
- Overstock: buying more than needed, usually to capture a volume discount or out of fear of running short. The discount disappears if the goods sit for months accumulating holding cost.
- Slow-moving and obsolete stock: items whose demand has dried up, superseded models, or materials bought for a cancelled project. They take space and lose value over time.
- Expired and damaged goods: in food, pharmaceuticals, cosmetics and chemicals, every day brings stock closer to expiry, and summer heat raises spoilage risk for some products if storage conditions are not right.
- Shrinkage: the gap between book and physical stock caused by theft, receiving and picking errors, or unrecorded damage.
- Stockouts: waste that shows up in sales rather than the warehouse: unfilled orders, partial shipments and expedited freight to cover gaps.
What Holding Inventory Really Costs
Holding cost includes the cost of capital tied up in stock, space, insurance, labor, and losses from damage and obsolescence. The rate varies a lot by business, so calculate your own. A hypothetical distributor carrying SAR 4 million of average inventory:
| Cost element | Basis | Annual SAR |
|---|---|---|
| Financing | Bank facility at 7% on SAR 4M | 280,000 |
| Warehouse rent | Share of rent attributable to stock | 240,000 |
| Insurance | Goods-in-store policy | 30,000 |
| Warehouse labor | Storekeepers and handlers | 210,000 |
| Damage, obsolescence, shrinkage | Last year's write-offs | 120,000 |
| Total | 880,000 |
That is a holding cost of 22% of inventory value per year. If the company cut average stock by SAR 800,000 without increasing stockouts, by stopping replenishment of slow movers and right-sizing order quantities, it would save roughly SAR 176,000 a year and release SAR 800,000 of cash once.
Tool 1: ABC and XYZ Classification
Items are not equal. ABC ranks them by annual consumption value: a small number of A items carry most of the value, a long tail of C items carries little, and B sits between. XYZ ranks them by demand stability: X items sell predictably, Z items are erratic.
| Class | Profile | Suggested policy |
|---|---|---|
| AX | High value, stable demand | Low stock, frequent orders, weekly review |
| AZ | High value, erratic demand | Manual review of orders, coordination with sales, considered safety stock |
| CX | Low value, stable demand | Larger, less frequent orders, automated replenishment |
| CZ | Low value, erratic demand | Question whether to stock it at all, or buy to order |
The full method is in our guide to ABC analysis.
Tool 2: Reorder Points and Safety Stock
The reorder point is the stock level at which a new purchase order should go out. The basic formula is average daily demand × lead time in days + safety stock.
Hypothetical example: an item sells 40 units a day on average with a daily standard deviation of 12 units, and the supplier's lead time is 15 days. For a service level of about 95% we use a factor of 1.65:
- Demand over the lead time = 40 × 15 = 600 units.
- Safety stock = 1.65 × 12 × √15 ≈ 1.65 × 12 × 3.87 ≈ 77 units.
- Reorder point ≈ 677 units.
When stock reaches 677, order. Review these numbers regularly, because demand and lead times move. Import lead times in particular can stretch suddenly, as they did when major carriers rerouted around the Cape of Good Hope from late 2023 after attacks on shipping in the Red Sea. More in our article on safety stock.
Tool 3: Economic Order Quantity
The economic order quantity model, first published by Ford W. Harris in 1913, is still a useful starting point. It balances the cost of placing orders against the cost of holding stock: EOQ = √(2 × annual demand × cost per order ÷ annual holding cost per unit).
Hypothetically: annual demand of 12,000 units, SAR 300 to place and receive each order, a unit price of SAR 50 and a holding rate of 20%, so SAR 10 per unit per year.
EOQ = √(2 × 12,000 × 300 ÷ 10) = √720,000 ≈ 849 units, or about 14 orders a year.
The model assumes steady demand and fixed prices, which reality rarely provides, but it quickly shows when current order sizes are far from sensible. See our article on economic order quantity for variations.
Tool 4: Batch and Expiry Control
For items with a shelf life, issue the earliest expiry first, which is not always the earliest received. That requires capturing batch number and expiry date at receipt and having the system suggest the right batch at picking. Early warnings on approaching expiry let you move stock through promotions or transfer it to a branch with stronger demand while there is still time.
Tool 5: Cycle Counting
Instead of closing the warehouse for two days once a year, count a slice of items every week: A items monthly, B quarterly, C twice a year, for example. Differences surface early, when their causes are still easy to trace. A year-end count is still needed; Saudi Arabia's Commercial Books Law requires year-end inventory to be recorded in the inventory book.
Tool 6: Dealing With Slow Movers Early
- Run a report of items with no movement in 90 or 180 days.
- Decide for each: discount sale, return to supplier, transfer, internal use, or write-off.
- Block automatic replenishment so the mistake does not repeat.
- Find the cause: an optimistic forecast, a substitute product, or a one-off customer request.
On the accounting side, IAS 2 measures inventory at the lower of cost and net realizable value. If a slow mover will only sell below cost, it must be written down; the write-down can be reversed later if circumstances improve, limited to the original amount. Our article on dead stock covers the options in more depth.
Clean Item Master Data First
Every calculation above collapses if the item data underneath is messy. Problems we see often:
- Duplicate items: one product under three codes with slightly different names, so one shows out of stock while another has plenty.
- Unit-of-measure confusion: buying by the carton and selling by the piece without a correct conversion factor.
- No barcodes: searching by name at receipt and picking invites wrong-item errors.
- Missing supplier data: no lead time recorded, so no reorder point can be calculated.
- Arbitrary item groups: categories that do not match how the products are managed, making reports useless.
Cleaning item data is tedious, and it pays back more than any forecasting algorithm. Start with high-value items, merge duplicates, set a base unit and clear conversions for each item, and record lead times per supplier.
Worked Case: A Distributor Before and After
A hypothetical consumer goods distributor carries 2,400 items across warehouses in Riyadh and Jeddah. A data review shows that about 300 items account for most consumption value, 450 items have not moved in six months, and every item is reordered in fixed monthly quantities. Over six months it applies ABC classification, reorder points for A and B items, inter-warehouse transfers before new purchases, and a plan to clear slow movers.
| Measure | Before | After six months |
|---|---|---|
| Average inventory value | SAR 6.0M | SAR 4.8M |
| Days of inventory | 91 | 73 |
| Order fill rate | 88% | 94% |
| Slow-moving stock value | SAR 900K | SAR 350K |
| Count accuracy | 82% | 96% |
These figures are illustrative, not promised results, but the pattern is a familiar one: less stock and better service at the same time, because the real problem was distribution, not volume. The company carried too much of what nobody wanted and too little of what customers ordered. At a 22% holding cost, SAR 1.2 million less average stock is worth about SAR 264,000 a year.
Mistakes That Keep Inventory Bloated
- Buying the discount without the math: 5% off a six-month supply can be eaten by holding cost before the last carton sells.
- Reorder points frozen for years: while demand and lead times have moved on.
- One policy for every item: the same attention for screws and for expensive equipment.
- Postponing slow-mover decisions: every month of delay adds cost and lowers recovery value.
- Late transaction recording: goods issued without a document and entered days later, which turns "live" balances into fiction.
- Jumping to advanced forecasting too early: a sophisticated model fed wrong balances produces wrong orders with more confidence. Get accurate stock, barcodes and basic reorder rules in place first.
Ownership matters too. In many companies nobody really owns inventory: purchasing buys against requests, sales wants everything available, finance complains about the total, and the warehouse just executes. Give one planner ownership of reorder points and quantities, have sales share forecasts and planned promotions in advance, let finance set value limits by class, hold the warehouse accountable for accuracy, and review one system report together every month.
KPIs That Show Progress
| KPI | Calculation | What it tells you |
|---|---|---|
| Inventory turnover | Cost of goods sold ÷ average inventory | How many times stock turns over a year |
| Days of inventory | 365 ÷ turnover | How many days current stock covers |
| Fill rate | Orders shipped complete ÷ total orders | Customer service level |
| Inventory accuracy | Items matching at count ÷ items counted | How far you can trust system numbers |
| Slow-moving ratio | Value with no movement ÷ total inventory value | Cash frozen for no return |
Local Factors in Planning
- Seasons: Ramadan, the two Eids, back to school, and Hajj and Umrah seasons shift demand in many sectors. A simple annual average fails in these periods; compare each season with the same season in prior years, remembering the Hijri calendar moves earlier each Gregorian year.
- Imports: many items are imported with long and variable lead times affected by conformity and clearance procedures. Safety stock for them should reflect lead time variability, not just the average.
- Multiple branches: a company with stores in Riyadh, Jeddah and Dammam may find an item dead in one and out of stock in another. Visibility across locations makes transfers possible before buying more.
Where ERP Brings It Together
Every tool here depends on accurate, current data, with each receipt, issue and transfer recorded when it happens. An integrated system connects purchasing, sales, warehousing and accounting on one database, so live balances are real, purchase suggestions come from reorder points, and turnover and slow-moving reports appear without manual work.
In Tranquil, inventory management supports central inventory across warehouses, multiple units of measure, assemblies and pre-assemblies, and links to purchasing, sales and financial accounting. Reports and multi-level approvals can be customized around your purchasing policy.
A 90-Day Improvement Plan
- Month one: clean item data, count A items, and classify everything ABC.
- Month two: calculate reorder points and safety stock for A and B items, and start clearing slow movers.
- Month three: run cycle counting, track KPIs monthly and compare against your starting point.
Frequently Asked Questions
How is smart inventory management different from the traditional approach?
It runs on live balances and calculated rules per item for reordering, quantities and picking, rather than experience and infrequent counts.
How do I calculate inventory holding cost?
Add up the year's financing, space, insurance, labor, damage and obsolescence costs and divide by average inventory value.
How often should reorder points be reviewed?
At least quarterly for important items, and immediately when a supplier's lead time or demand changes noticeably.
How is slow-moving stock treated in the accounts?
Under IAS 2, if net realizable value falls below cost, the inventory is written down to it; the write-down may be reversed later up to the original amount.
Does Tranquil handle multiple warehouses?
Yes. It supports central inventory across warehouses and multiple units of measure. Contact the Tranquil team to discuss your setup.