Almost every manufacturer runs part of its operation on spreadsheets. The production schedule, the stock list, the costing, the order tracker. Spreadsheets feel free, flexible, and familiar. But for a manufacturer, running a factory on them is not free at all. The cost is real; it is just not on an invoice. Here is what it actually is.
Why spreadsheets feel right
It is worth being fair to the spreadsheet. It is free, everyone knows how to use one, and it can be shaped to fit exactly how a particular business thinks. In the early life of a manufacturing business, spreadsheets genuinely work, because the operation is small enough for one or two people to hold in their heads, and the spreadsheet is just a memory aid. The trouble starts when the business grows past that point, and the spreadsheets quietly stop being a help and start being a cost.
The cost of stock that is wrong
A spreadsheet stock list is correct at the moment someone updates it and slowly wrong afterward. Between updates, material is consumed and received and the spreadsheet does not know. So the manufacturer plans against stock figures that are not real. The cost of that arrives as stock-outs, a component is out when production needs it and the line stops, and as excess, too much is bought because the spreadsheet understated what was there. Both tie up money. Neither shows up labelled as the cost of a spreadsheet, but that is what it is.
The cost of not knowing what things cost
Costing a product on a spreadsheet means gathering materials, labour, machine time, and overhead by hand, and it is done rarely because it is laborious. So the costed figures a manufacturer prices and quotes against are old and approximate. The cost of that is invisible and large: jobs quoted too low and won at a loss, jobs quoted too high and lost, a product range where nobody can say with confidence which lines actually make money. A manufacturer running costing on spreadsheets is making its most important commercial decisions on numbers it half-trusts.
The cost of knowledge that lives in people
A spreadsheet-run factory does not really run on spreadsheets. It runs on the few people who understand the spreadsheets and hold the rest in their heads. That person knows which figures are reliable, which workaround is in play this week, how the planning really gets done. The cost of that is risk. When that person is on holiday, the operation gets shakier. If they leave, a part of how the business runs walks out with them. Knowledge that lives in people and spreadsheets instead of in a system is a fragile foundation, and the fragility is a cost even on the days nothing goes wrong.
The cost of slow, stale information
A spreadsheet shows the situation as of the last time someone updated it. In a growing factory, that is always behind. Decisions get made on last week's picture: what to produce, what to buy, what to promise a customer. Some of those decisions are wrong because the picture was stale, and the cost is the rework, the missed delivery, the scramble. A factory moving at any real pace cannot be steered well from information that is always a few days old.
The cost of time spent feeding the spreadsheets
And then there is the plainest cost of all: the hours. The hours spent updating spreadsheets, copying numbers between them, reconciling one against another, rebuilding a schedule by hand because something changed. That is skilled people spending their time on data entry and reconciliation instead of on running and improving the operation. It is a cost every single week.
Adding it up
Put it together: money tied up in wrong stock, commercial decisions made on shaky costs, the operation depending on a few people, decisions made on stale numbers, and skilled hours spent feeding spreadsheets. None of it is invoiced, so it is easy to not see. But it is the real cost of running a factory on spreadsheets, and for a growing manufacturer it is usually far larger than the cost of the system that would replace them.
The takeaway
Spreadsheets feel free because their cost is hidden, paid in stock-outs, mispriced work, fragile dependence on a few people, stale decisions, and wasted hours. For a manufacturer that has outgrown them, that hidden cost is real and recurring. Seeing it clearly is the first step to deciding whether it is still worth paying. For how we approach this, see our ERP practice.