7 Signs Your Factory Has Outgrown Spreadsheets

Let's be fair to the spreadsheet: it probably ran your company for years, and it cost you nothing. Most of the manufacturers we consult for got surprisingly far on Excel, a shared drive, and one person who "knows the sheet."

That last part is the problem. Here are the seven signals we look for on a first plant visit — if three or more feel familiar, the spreadsheet era is ending whether you plan for it or not.

1. Stock counts are a ritual, not a number

If knowing your raw material position requires a phone call and a walk to the store, you don't have inventory data — you have inventory folklore. Purchasing on folklore means you buy early (cash sits in stock) or late (machines sit idle).

2. One person is the system

Every plant has them: the planner or accountant whose personal workbook holds the company together. When they're on leave, quoting slows down. When they resign, you're in real trouble. That's not a people problem — it's an architecture problem.

3. Your order status lives in someone's head

A customer calls asking where their order is. Watch what happens next. If the answer involves calling the floor supervisor, who checks with two operators, you're paying a coordination tax on every single order.

4. Month-end takes a week

Sales in one sheet, purchases in another, production in a third — and finance reconciling all of them by hand every month. The numbers arrive late and nobody fully trusts them, so decisions get made on gut feel anyway.

5. The same data is typed more than once

An order gets written in the order book, typed into the invoice, entered again in the dispatch register. Every re-entry is a chance for an error, and errors found at dispatch are the expensive kind.

6. Quotes take days, not hours

If costing a new part means hunting for the last similar job and guessing what changed, you're losing work to whoever quotes faster. Speed of quoting is a sales weapon, and it's a data problem underneath.

7. You can't answer "which product actually makes us money?"

Revenue you know. Margin by product, by customer, by machine — that's where pricing and capacity decisions come from, and spreadsheets almost never get you there.

What to do about it

Not "buy software" — at least not first. Our advice, and the way we run our own deployments: map how orders, material, and money actually move through your plant, fix the process where it's obviously broken, and then put a system around it. An ERP configured around a messy process just makes the mess faster.

That mapping exercise is exactly how every i.e tech engagement starts. If you'd like us to walk your floor and give you a straight answer about what you need — and what you don't — get in touch.