Why Planning Still Runs on Spreadsheets at 50 Lines and 2,000 Orders

The plan nobody can hold in their head

Walk into the planning office of a large garment factory in Sri Lanka, Bangladesh, Vietnam or India and you will usually find one of two things: a spreadsheet with dozens of tabs, or a planning board where every order was placed by hand. Often both, because the board is exported to a spreadsheet so the rest of the factory can read it.

Neither is a criticism of the planner. Both work at ten lines and a few dozen orders. The trouble is that apparel manufacturing stopped looking like that a long time ago. A single plant runs fifty lines and two thousand orders. A group runs twenty or forty plants across several countries. Past about twenty lines, no person can hold the whole plan in their head, and the plan quietly becomes a series of local decisions: this order on this line because there was a gap, that order there because the buyer called.

Where the hand-built plan breaks

Only the near horizon gets planned. Placing orders by hand is slow, so the next few weeks are placed and the rest of the book sits unplanned, with no line and no date. Weeks later those orders are squeezed in around everything already there.

Every change knocks on. A buyer moves a date. To make room, three other orders move, and each of those moves something else. After a few changes nobody wants to replan, so the plan is touched weekly and the week is spent reacting.

Each plant plans its own way. In a group, each plant has its own file, its own efficiency assumptions and its own idea of what "on time" means. Head office sees a consolidated report that was out of date before it was finished, built from numbers that were never measured the same way.

The plan carries assumptions instead of facts. Lines are loaded at the efficiency the plant wants, not the one it achieves. The fabric date is the one the mill was asked for, not the one it can hit. The plan looks fine on Monday and is fiction by Wednesday.

Why it has lasted

Spreadsheets and hand-built boards last because the planner stays in control and everyone can read them. Earlier planning software often made things worse: months of implementation, consultants to configure it, and in the end a board where the planner still drags every order. If the tool does not take the placement work off the planner, there is no reason to change.

What changes when the plan is built for you

The shift is not from one board to another. It is from the planner building the plan to the planner running it.

LoadIt takes the order book as it is and plans every order on the factory's own rules: on the line that runs it best, on the efficiency that line actually achieves, with nothing started before its fabric and approvals are in, and no capacity left idle between orders. The whole book is planned, near and far horizon, in minutes. The same order book gives the same plan every time. An order that cannot ship on time is shown late on the day it is uploaded, with the reason. What to do about it stays with the planner.

Because it takes minutes, the plan can be rebuilt every morning after the day's production update. One factory or forty, the same rules apply in every plant, so a group reads one number from the board to the boardroom.

How to move without the risk

Run it in parallel. Keep the current process, upload the same order book, and compare the two plans: which orders ship on time, how full the lines are, how much of the book is planned at all. If the new plan is not better on your own book, you have lost a morning. If it is, you will see it in the first week.

The bottom line

The spreadsheet got the industry this far. But at fifty lines, or twenty plants, the plan has outgrown what a person can build by hand. The question is no longer which tool lets the planner place orders fastest. It is whether the planner should be placing them at all.