Production Planning in Excel: Seven Signs the Spreadsheet Has Stopped Working

Every factory's planning software starts as one person's spreadsheet. Someone gets tired of the whiteboard, opens Excel, puts orders in rows and days in columns, and within a month the whole plant depends on that file. That's not a failure. It's usually the best planning tool the plant has ever had. Until it isn't.

Production planning in Excel means using a spreadsheet to decide which orders run on which lines, in what sequence and in which week, usually with some formulas for hours and material. For a small plant it's often the right choice. For a growing one, there's a point where the spreadsheet starts costing more than it saves. This article is about finding that point.

What Excel does well

Let's be fair first. Spreadsheets win on things planning software often gets wrong:

• Speed of change. A new column, a new rule, a color for rush orders: five minutes, no IT ticket.
• Everybody knows it. No training, no licenses, no login problems.
• What-if thinking. Copy the tab, try a different sequence, compare. Planners do this naturally.
• Analysis. Pivot tables and charts on production data are still the fastest way to answer a one-off question.

If you have one planner, a few dozen orders a week and one real bottleneck, a well-built production schedule template can carry you a long way.

Think of it like a paper map. It's accurate on the day it's printed, easy to read and never needs a signal. It just doesn't know about today's road construction.

Seven signs production planning in Excel has stopped working

1. It has one owner. When the planner goes on vacation, planning stops or goes back to the whiteboard. Nobody else dares to touch the formulas.

2. Copy-paste Mondays. Every week starts with exporting orders and stock from the ERP and pasting them into the file. If that takes half a day, the plan is always half a day old before it starts.

3. There's no capacity check. The file lists orders per week, but nothing compares hours to available hours. (Worked example below.)

4. Versions multiply. Plan_v7_final_JM_new.xlsx sits in an email next to Plan_v7_final2.xlsx. Production runs from one, sales quotes from the other.

5. Shortages are found at the machine. The spreadsheet shows the order but doesn't explode the bill of materials, so the missing component turns up when the operator reaches for it. That's the job of MRP, and a spreadsheet does it badly past one BOM level.

6. Sales can't get a date without calling the planner. Every delivery promise is a phone call, so either promises are slow or they're guesses.

7. A rush order takes an hour to insert. Moving one order means shifting thirty rows by hand and checking that no formula broke on the way.

Two or three of these are normal. Five or more, and the file is running your plant instead of the other way around.

A worked example: the capacity check that isn't there

Line 2 runs two shifts, six days a week: 2 × 8 × 6 = 96 hours. The spreadsheet lists next week's orders for Line 2 with hours per order: 22, 18, 31, 27 and 20. Total: 118 hours.

That's 22 hours over, almost three full shifts. If nobody wrote a formula comparing 118 to 96, the plan looks fine all week. The late orders show up on Saturday.

Now the time cost. Say the planner spends 3 hours every Monday reconciling exports and 30 minutes on each of the other four days fixing changes: 3 + 4 × 0.5 = 5 hours a week. Over 48 working weeks that's 240 hours, six full 40-hour weeks a year. At $45 an hour, about $10,800 of skilled time spent copying data.

Myth: "The spreadsheet is free"

The license is free. The planner's Mondays, the missed shortages and the orders that ship late because nobody checked hours are not. None of it shows up on an invoice, which is exactly why it lasts so long.

What to move first

Don't try to replace the whole file at once. Move the parts that hurt most, in this order:

1. Orders and stock from one source. Stop copy-paste Mondays by planning directly on ERP data. The gap between ERP and planning is usually where the spreadsheet was born.
2. The capacity check. Hours against available hours per resource, every time an order is added.
3. Material explosion. Let MRP find shortages before the machine does.
4. Sequencing. Only then move day-to-day production scheduling onto a finite-capacity Gantt.

Keep Excel for what it's great at: analysis and one-off questions. Manufacturing planning software describes the stages most plants go through after the spreadsheet.

How this looks in factory.online

In factory.online, the Line 2 week above would show 118 hours against 96 on the capacity view the moment the fifth order is added, and the Gantt would push the last orders into the following week so the planner sees which ones slip. Orders and stock come from the ERP through integrations instead of Monday exports, and MRP links each shortage to its order. Power BI can sit on top for the pivot-table questions planners still like to ask.

If your plan lives in a spreadsheet that only one person understands, book a demo and bring a copy of it.