Inventory Management Fundamentals for Malaysian SMEs

Stock is cash sitting on a shelf. Hold too much and the money is locked up while expiry dates creep closer; hold too little and you lose the sale, and often the customer. Most small retailers and F&B outlets in Malaysia manage this by feel, when a few basic numbers and routines do a better job without an accountant. This article covers stock turns, days of stock, reorder points, ABC analysis and counting routines, with a worked example for a café and a hardware shop.

The four numbers every owner should know

Stock on hand at cost. What you paid for everything on the shelf and in the store room today. Not the selling price.

Stock turns. How many times a year you sell through your average stock. The formula is cost of goods sold divided by average inventory, where average inventory is opening stock plus closing stock, divided by two. Higher turns mean cash comes back faster. A low figure points to excess stock, weak sales or loose inventory control.

Days of stock. How many days your stock would last at the current rate of sale: 365 divided by stock turns. This is the number to put on the wall, because everyone understands days.

Reorder point. The stock level at which you must place the next order. ACCA’s study material defines the reorder level as the demand you expect during the supplier’s lead time, with buffer inventory added when that demand is uncertain. Most owners call the buffer “safety stock”.

Worked example: a café and a hardware shop

The figures below are illustrative and chosen to show the method.

A café in Petaling Jaya has a cost of goods sold of RM24,000 a month. Stock at cost was RM7,000 at the start of the month and RM9,000 at the end, so average stock is RM8,000.

• Monthly turns: RM24,000 ÷ RM8,000 = 3
• Annual turns: 3 × 12 = 36
• Days of stock: 365 ÷ 36 = about 10 days

Ten days is sensible for fresh food. If that café drifted to 25 days of stock, the first place to look would be the chiller, for items bought in bulk “because it was cheaper”.

A hardware shop in Klang sells RM300,000 of goods at cost a year and holds an average of RM100,000 of stock.

• Annual turns: RM300,000 ÷ RM100,000 = 3
• Days of stock: 365 ÷ 3 = about 122 days

If the owner trims slow lines and brings average stock down to RM75,000 on the same sales, turns rise to 4, days fall to about 91, and RM25,000 of cash comes off the shelves. That is often more than the shop’s bank balance.

Setting reorder points

Reorder point = daily usage × supplier lead time in days + safety stock.

Back at the café, three everyday items might look like this:

When beans fall to 10 kg, the order goes in. The order quantity is a separate decision: if the supplier delivers weekly, order a week’s usage, which is 14 kg. Keep more safety stock for items with unreliable suppliers or long weekends, and less for items you can buy at the nearest cash-and-carry in an emergency.

Write reorder points on the shelf edge or the store room door. The person who notices the level, usually whoever does the evening count, should be able to act without asking.

ABC analysis: control the few items that matter

Not every item deserves the same attention. ABC analysis classifies stock by consumption value, the total value of each item used over a period such as a year, and rests on the Pareto principle: a small share of items accounts for most of the value, and those are the A items. B items sit in the middle and C items are the long tail of low-value lines. There is no fixed cut-off; the shape of the list is what matters.

To do it in a spreadsheet:

1. List every item with its unit cost and the quantity used or sold in the last twelve months.
2. Multiply the two to get annual consumption value, and sort from highest to lowest.
3. Add a running total as a percentage of the grand total.
4. Choose your own cut-offs. The café in our example marks items up to 70% of the running total as A, up to 95% as B, and the rest as C.

For the café, class A is probably meat, seafood, coffee beans and cooking oil. Class C is straws, napkins and sauce sachets. Count and review A items weekly and set their reorder points carefully. Review B items monthly. Order C items in bulk a few times a year and stop thinking about them.

Counting routines that stick

A full stocktake once a year is for the accounts. The routine that keeps stock accurate is the cycle count: a small count, done often, by rotation.

• Daily: A items in the kitchen or on the main shelf, five minutes at closing.
• Weekly: all A items in the store room.
• Monthly: B items. Quarterly: C items.
• Blind counts: the counter writes down what is there without seeing what the system says. Comparing afterwards exposes real errors.
• Separate the roles: the person who orders stock should not be the only person who counts it.
• Investigate variances rather than just correcting them. A recurring shortfall in one item usually has a story: a recipe nobody follows, a supplier who short-delivers, or theft.

Basic tools

Start with a spreadsheet: item, unit, cost, reorder point, counts by date. It will show you whether the discipline exists before you pay for software.

When the count routine is working, a cloud POS with built-in inventory removes the retyping. Loyverse offers a free plan that includes essential inventory management, real-time stock levels and automatic low-stock alerts. StoreHub is a Malaysian point-of-sale system built for F&B, retail and service businesses, with stock management for retail. Whichever you choose, two habits decide whether it works: receive deliveries into the system the day they arrive, and for F&B, link each menu item to its recipe so that selling a plate deducts the ingredients.

Common mistakes

• Valuing stock at selling price, which hides how much cash is tied up.
• Buying in bulk for a discount without working out the extra days of stock.
• Letting one person order, receive and count with nobody checking.
• Counting everything once a year and nothing in between.
• Carrying C items in large quantities “just in case” while A items run out.

Key takeaways

• Value stock at cost, and track days of stock (365 divided by stock turns) as the one number everyone understands.
• In the hardware shop example, cutting average stock from RM100,000 to RM75,000 on the same sales releases RM25,000 of cash.
• Set a reorder point for each item as daily usage × lead time + safety stock, and write it on the shelf edge.
• Rank items by annual consumption value, then count A items weekly, B items monthly and C items quarterly.
• Prove the counting routine in a spreadsheet before paying for a POS, then receive every delivery into the system the day it arrives.

How Gusto Style can help

If you are unsure whether stock, cash or something else is your biggest problem, our Business Health Check is a fixed-price, two-hour session that reviews your sales, costs, cash flow, team and systems and gives you a five-page report with your top five priorities. For many retailers and F&B outlets, the stock numbers above are where that conversation starts.