The verdict in three sentences
For a chain of 18 pharmacies in Singapore, running sales and stock from monthly Excel exports means discovering stock-outs and margin gaps 3 weeks late. A data warehouse fed by connectors to the 2 pharmacy systems in the network, presented in Power BI or Metabase and refreshed every hour, costs about USD 25,000 to 55,000 depending on scope (250,000 to 550,000 MAD for the same project in Morocco). Realistic timeline: 3 to 5 months, for 10 to 15% fewer stock-outs and margin tracked store by store.
What the CEO cannot see today
In a network that grew through successive acquisitions, stores often run on two different systems with inconsistent product codes: barcode, supplier code, internal code. Purchases from wholesalers are entered locally, returns and expired stock rarely, and back-end rebates arrive at quarter end. The result: revenue is known, but real margin is rebuilt late, and stock-outs on fast movers (diabetes and blood pressure drugs, infant formula) are noticed by patients before head office.
| Indicator | Monthly exports | Dashboard refreshed every hour |
|---|---|---|
| Time to detect a stock-out | 2 to 3 weeks | under 2 hours |
| Stock-out rate on top 300 items | 6 to 9% | 5 to 7.5% (10 to 15% fewer) |
| Gross margin per store | quarterly, estimated | daily, actual |
| Dead stock older than 180 days | unknown | listed per store |
| Stock transfers between stores | by phone | suggested automatically |
| Monthly reporting preparation | 4 to 6 days | under 1 hour |
What the project costs in 2026
The budget splits into four blocks: connectors to the pharmacy systems (database read or vendor API), the data warehouse (PostgreSQL, BigQuery or SQL Server), the product code mapping table, and the dashboards. The most underestimated item is code mapping: across 18 stores you often need to reconcile 12,000 to 20,000 items.
| Item (2026 order of magnitude) | Essential scope | Full scope |
|---|---|---|
| Connectors to 2 pharmacy systems | USD 7,000 | USD 14,000 |
| Data warehouse and modelling | USD 6,000 | USD 13,000 |
| Unified product master | USD 4,000 | USD 9,000 |
| Dashboards (sales, stock, margin, purchasing) | USD 5,000 | USD 12,000 |
| Stock-out alerts and transfer suggestions | USD 3,000 | USD 7,000 |
| Total project | USD 25,000 | USD 55,000 |
| Monthly running cost (hosting, licences) | USD 250 to 600 | USD 600 to 1,500 |
On licences, self-hosted open source Metabase costs nothing beyond the server, while Power BI Pro is billed at about USD 14 per user per month in 2026. For 25 users, the gap is about USD 350 a month. Our method and architecture are detailed on the custom web applications and business tools page, and smart alerts on the automation and AI page.
Pharmacy-specific watch points
Pharmacy sales data can contain health information if prescriptions are linked to a patient. The warehouse should only receive data aggregated by product, with no patient identity, which simplifies compliance with Singapore's PDPA. You also need to handle stores with unstable connections: connectors buffer data locally and send it as soon as the line is back.
Finally, success depends on usage. A dashboard viewed only by head office does little for stock-outs; an alert sent to the store pharmacist at 9 am with the 10 items to reorder really changes practice.
Mini case study
Need a professional website?
Kolonell builds websites that attract clients, optimized for the Sénégalese market. Free quote in 2 minutes.
Dr Tan, CEO of an 18-store pharmacy chain in Singapore, estimates sales lost to stock-outs at 2.5% of annual revenue of USD 9 million, so USD 225,000. With a USD 42,000 project that cuts stock-outs by 12%, he recovers about USD 27,000 of sales a year, close to USD 8,000 of gross margin at 30%. Add lower dead stock, estimated at USD 30,000 of cash released, and 5 days of monthly reporting saved. The project pays back in 18 to 24 months on margin alone, and much faster when released cash is counted.
FAQ
Do we need to replace the pharmacy system to get a shared dashboard?
No. Connectors read both existing systems and normalise the data. A software migration would cost 3 to 5 times more and disrupt staff.
Is an hourly refresh enough?
For sales and stock-outs, yes in 95% of cases. A 15-minute refresh is possible, with about 20% higher server cost.
Power BI or Metabase: which one?
Power BI fits if the chain already uses Microsoft 365 and wants advanced analysis. Metabase is simpler and licence-free, suited to fewer than 30 users.
How long does it take to unify product codes?
Count 4 to 8 weeks for 12,000 to 20,000 items, combining automatic barcode matching with review by a pharmacist.
Can the dashboard help negotiate with wholesalers?
Yes, it consolidates purchase volumes by manufacturer and wholesaler across the 18 stores. Gaining 0.5 point of rebate on USD 6 million of purchases is worth USD 30,000 a year.
Let's scope your project. Tell us the number of stores, your systems and priority indicators: we will scope the work, an indicative budget and a 3 to 5 month plan. Detailed quote within 48 h. WhatsApp +221 77 596 93 33.
Mohamed Bah
Fondateur, Kolonell
Passionate about digital and entrepreneurship in Africa, Mohamed has been helping Sénégalese businesses with their digital transformation since 2020. Founder of Kolonell, he believes every SME deserves a professional and accessible online présence.
