Why Factories Outgrow Spreadsheets at 20 Employees

After watching enough small factories scale, you notice a number: 20. It's around the 20-employee mark — give or take five — that a factory's spreadsheet-based operating system starts to actively cost more than it saves. The breaking point isn't about file size or formula complexity. It's about how human coordination scales.

The Math of Coordination

A five-person team has 10 pairs of people who might need to coordinate (5 × 4 / 2). At 20 people, that number jumps to 190. The amount of information that has to flow between humans grows quadratically, not linearly. Spreadsheets were never designed to be a coordination layer for 190 communication paths — they were designed to be a calculation tool for one person at a time.

What Breaks First

It's almost always inventory. With 5 people, one person knows what's in stock because they personally touched most of it this week. At 20 people, nobody has that full picture, and the spreadsheet meant to provide it is now being updated by three people who all disagree on what "received" means. Stock counts drift. Reorders get missed. Production stops waiting for material that the sheet said was there.

What Breaks Second

Work order status. With 5 people, the owner can walk the floor and see everything. At 20 people, there are two shifts, three departments, and a hundred batches a month. The status spreadsheet that was supposed to fix this becomes a bottleneck — somebody has to update it, and that somebody is always behind.

What Breaks Third

Client-facing commitments. When a customer asks "when will my order ship?", the answer used to be a confident "Thursday." Now it's "let me check and get back to you," followed by three internal messages and a 30-minute delay. Every one of those delays is a small erosion of trust.

What to Do Before You Hit It

If you're at 15 employees and growing, start moving the core operational data — work orders, inventory, dispatch — off spreadsheets now, before the breaking point arrives. The transition is dramatically easier when you're not also dealing with the chaos that comes from waiting too long. The factories that scale smoothly through 50 and 100 employees are almost always the ones that made this shift around the 20-person mark, deliberately, before they were forced to.