Last week, I visited two businesses that couldn’t have been more different.
One operates eight factories and two distribution centres, yet still relies heavily on spreadsheets.
The other operates from a single warehouse and wants to go digital from day one.
So, which one has the right approach?
I think both do, and here’s why.
The first is a longstanding customer who has successfully managed a substantial operation with spreadsheets playing a significant role. They’re now ready to move towards a fully integrated digital system, and we’re pleased to be helping them make that transition.
The second is a prospective customer in the food industry. Although much smaller, they want accurate stock information, traceability and real-time visibility from the outset, rather than having to change systems as the business grows.
Two very different businesses, at very different stages of their journeys.
It got me thinking about when businesses should move beyond spreadsheets.
Spreadsheets are familiar, flexible and inexpensive. And I’ve seen them work remarkably well, even in complex operations.
But there comes a point when they start working against you.
A few warning signs I’ve noticed:
- Different versions of the truth, with people working from different files.
- Too much time spent capturing and reconciling information.
- Reports arriving too late to make a difference.
- Difficulty tracing products, batches or stock movements.
- An unhealthy dependence on the one person who understands all the formulas and workarounds.
And it’s not necessarily the size of the business that matters. It’s the complexity of the operation and the information needed to manage it.
For me, the tipping point comes when the effort and risk involved in maintaining manual processes begin to outweigh the cost and complexity of moving to an integrated system.
Particularly when the business can no longer rely on its information being accurate, complete and available when decisions need to be made.
There’s a difference between using spreadsheets to support an operation and relying on them to run the operation.
And perhaps that’s the real test. When spreadsheets become the backbone of your operational processes rather than a tool to support them, it’s time to seriously consider a more structured system.
I’d be interested to hear how others have approached this decision.