Production Scheduling: Moving Beyond the Spreadsheet

On the shop floor, the spreadsheet is rarely a planning tool in any meaningful sense. It is a record of what was decided in a meeting and a place to note what has since gone wrong. Planners rebuild it three times a week, supervisors work from a printout that is already out of date, and the real schedule lives in the head of one experienced person who is a fortnight away from retirement.

## Why spreadsheets survive so long They survive because they are fast to change and nobody has to approve them. A production scheduler facing an urgent order, a late material delivery or an absent operator needs to answer the question immediately, and a spreadsheet lets them. The problem is that the answer is not recorded anywhere, so the same disruption is rediscovered by everyone downstream. The spreadsheet is not the cause of the chaos; it is how the chaos is currently managed.

## What a scheduler actually has to balance A credible schedule is a compromise between constraints that pull in opposite directions:

• Capacity, by work centre, by shift and by skill, not just by machine hours
• Material availability, including the components that arrive late even when the parent item is in stock
• Changeover time, which may depend on the sequence rather than the quantity
• Customer promise dates, with some orders genuinely inflexible and others negotiable
• Labour, tooling and packaging, which are consumed in different patterns
• Shelf life, where the output decays from the moment it is made

## The cost of a static schedule A schedule built once and executed unchanged is a plan that assumes nothing will move. In practice, a machine goes down, a delivery is short, a customer brings an order forward. Because the schedule cannot evaluate the consequences, the response is local: this order is squeezed in, that job is pushed back, and the knock-on effects surface two days later as overtime, a missed promise, or a changeover that should have been avoided. The cost is invisible in the moment and visible at month end.

## Finite capacity, not wishful thinking The single most important step beyond a spreadsheet is moving to finite capacity. Infinite capacity planning says the work fits as long as no one checks; finite capacity says it does not fit, here is where it breaks, and here are the three levers available. That is a harder conversation, and it is the one that prevents the surprise.

## Sequencing and sequence-dependent changeovers Where changeover time depends on the order of jobs, the schedule is a sequencing problem rather than a loading problem. Running the same family together may look efficient while it starves a customer who needed a different variant this week. A scheduling tool that models sequence-dependent setup lets the planner see that trade explicitly instead of discovering it after the fact.

## What to look for A useful scheduling capability shows the constraint, re-plans the finite horizon in seconds, and makes the consequence of a change visible before it is accepted. It also has to be usable by the person on shift at six in the morning. sofco's production scheduling works directly from the supply plan so the schedule and the plan never disagree, and you can book a demo to see a disruption re-planned live.