📌 A Quick Note Before We Begin: The following scenario is a fictionalized simulation designed to illustrate common workflow bottlenecks in the industry. Names, characters, and events are purely illustrative to demonstrate how digital tools can help.
If you distribute medical products, devices, or pharmaceuticals to hospitals across Sarawak, you already know the stakes are incredibly high. You aren’t just selling widgets; you are supplying tools that doctors rely on to save lives.
And in this industry, there is one silent killer of profitability and reputation: The Expiry Date.
Let’s look at a scenario that happens all too often behind the scenes of a traditional medical distribution firm based right here in Kuching.
The 9:00 AM Urgent Call
It’s Tuesday morning. The office is bustling, and the sales manager, Aaron, is sipping his morning coffee. Suddenly, his desk phone rings. It’s the head of procurement from a major private hospital in Bintulu.
The tone on the other end isn’t friendly.
“Aaron, your team delivered a batch of orthopedic surgical mesh to our theater yesterday. Our nurse just checked the box during prep—the batch expires in exactly two weeks. We can’t use this. The surgery is scheduled for tomorrow. What is your team doing?”
Aaron’s morning coffee instantly goes cold.
He frantically drops the phone and rushes to the warehouse section. He pulls up the “Master Inventory” Excel file saved on the desktop computer of their veteran warehouse supervisor, Uncle Tan.
Aaron frantically scrolls through thousands of rows of data. The file shows they have 150 boxes of that surgical mesh in stock. But here’s the catch: the Excel sheet only tracks the quantity, not the batch numbers or expiry dates.
To find out how many other expired boxes are sitting on the shelves, Uncle Tan and his team have to drop everything. They spend the next four hours freezing in the cold-room warehouse, manually flipping over every single box to read the tiny printed expiry dates.
By the time they sort it out, Aaron has missed the deadline to rush a replacement batch to Bintulu via the next available flight. The hospital is furious, the competitor from Miri steps in to fill the order, and Aaron is left holding thousands of Ringgit worth of expired, unsellable stock.
The Turning Point: Entering the Shared Workspace
Now, let’s replay that exact same scenario, but with one small “shift” using Google Workspace.
Six months earlier, the company decided to move its inventory tracking off Uncle Tan’s single desktop computer and onto a Google Sheet inside a secure Shared Drive.
Now, when a new shipment arrives at the Pending or Kuching port, the warehouse team doesn’t just write down the quantity. Using a tablet or phone right on the warehouse floor, they log into the shared Google Sheet and type:
- Item Name
- Quantity
- Batch Number
- Expiry Date
Because it’s Google Sheets, Aaron set up a simple trick called Conditional Formatting. He set a rule: If an item is within 90 days of expiring, turn the entire row bright yellow. If it’s within 60 days, turn it bright red.
Two months before that Bintulu hospital ever placed an order, Aaron opened his laptop, saw three rows glowing bright red, and realized they had surgical mesh expiring soon.
Instead of waiting for an emergency, Aaron calmly picked up the phone, called a few clinics across Sarawak, and offered them a “Clearance Bundle” discount to move the stock safely and legally while it was still perfectly valid.
No frantic phone calls. No wasted hours in the cold room. Zero expired stock written off.
The Shift Tip: You Don’t Need an Expensive ERP System
Many medical distributors assume that to fix inventory chaos, they need to invest RM50,000 to RM100,000 into a massive Enterprise Resource Planning (ERP) or Warehouse Management software.
But for most local SMEs, that is like buying a semi-truck when a standard pickup van does the job perfectly.
Before you spend a fortune on complex software that your staff might find too difficult to use, look at the tools you already have. A simple, securely shared Google Sheet gives your sales team, your warehouse team, and your management a single, live view of your inventory in real-time.
When everyone looks at the same data, the nightmares disappear.
