Excel is the most widely deployed planning system in manufacturing, and often rightly so. Here is an honest account of where it genuinely works, the twelve symptoms that mark its limit, and what actually fixes each one.
Quick answer: Excel planning breaks when the plan must react to reality faster than a human can retype it. The symptoms cluster into three families: staleness (the plan describes yesterday), fragility (one planner, one file, one vacation from chaos), and blindness (no connection to what lines are actually doing). If your plan is rebuilt more than once a day from phone calls, you are past the limit.
Fairness first, because it is also the truth: a stable plant with few products, long runs, one planner and modest change pressure can run for years on a well-built spreadsheet, and buying software for it would be procurement theater. Excel is free, infinitely flexible, and understood by everyone. The question is never whether Excel is good; it is whether your operation still fits inside what Excel can honestly do.
Staleness. 1. The plan is updated from shift-end reports, so it always describes the past. 2. Expediting meetings exist because the plan and the floor diverge daily. 3. Promise dates are negotiated by phone because nobody trusts the sheet's answer. 4. The same order appears in two versions of the file with two dates.
Fragility. 5. One person understands the macros, and holidays are scheduled around them. 6. Planning stops when that person is ill. 7. The file has a name like plan_v7_FINAL_new2.xlsx. 8. A formula error once shipped the wrong sequence and nobody noticed for a week.
Blindness. 9. Capacity in the sheet is nameplate, not demonstrated, so every week is optimistic by the same percentage. 10. Changeovers are a constant, though the real matrix varies fourfold between transitions. 11. Maintenance windows are in a different calendar, discovered at collision time. 12. When a line goes down, the replan takes hours, so the floor improvises and the plan becomes decoration until Monday.
Staleness is fixed by connection, not by better spreadsheets: the plan must see actual line status and order progress without human retyping. Fragility is fixed by moving logic out of one person's macros into a shared system with permissions and history. Blindness is fixed by measurement: demonstrated rates, real changeover durations and maintenance windows feeding the plan automatically.
It is worth saying who pays for symptom 12 today: the crews. When the plan becomes decoration, operators absorb the improvisation as expedited changeovers, split batches and shift-end surprises, and they learn to trust the grapevine over the plan, which makes every future plan weaker.
Note what none of these require: a two-year APS program. The step after Excel is a connected planning board on honest data, which preserves the drag-and-drop control planners love about spreadsheets while removing the retyping and the fiction.
Should a small manufacturer move off Excel planning?
Only if the symptoms above are present. Few products, long runs and low change pressure can live on Excel indefinitely; frequent changeovers, multi-line dependencies and daily replanning cannot.
What replaces Excel planning?
A planning board connected to live line data: orders sequenced against demonstrated capacity, changeovers from the real matrix, maintenance windows visible. The interaction model can stay as familiar as a spreadsheet; the data underneath stops lying.
Is APS software the next step after Excel?
Usually not the first step. Most plants get the majority of the value from connecting honest measured data to a visual sequencing board; algorithmic optimization earns its place later, on the bottleneck, if mix complexity demands it.
Fabrico's planning board keeps the planner in control and replaces the retyping with live machine data. Read next: finite vs infinite capacity planning.
Zakažite sastanak KSNUMKS-to-KSNUMKS sa našim stručnjacima ili se direktno upišite u naš besplatni plan.
Nije potrebna kreditna kartica!
Login
Blog