Over the past two months, our specialists have spoken with plant managers, operations leads and production planners from companies across several manufacturing sectors. All of them had different products, factory setups, and ERP environments, but we often saw the same frustrations appearing, conversation after conversation.

The situation below is stitched together from those discussions. Many operations managers may find the following scenario uncomfortably familiar:

When production depends on a single person

It’s Thursday, early morning, and two operators have called in sick for the early shift. A supplier's delivery is delayed. A rush order came in overnight, and sales had already promised the customer a date. The shift leader walks the floor with a printed run sheet in one hand and yesterday’s Excel export in the other, trying to decide which jobs can still run and which ones have to move.

The ERP shows the orders, and the machine schedule shows capacity. HR has the absences somewhere else. Nobody sees the whole picture at the same time, and now that the plant is down two operators, a scheduled delivery and a rush order to fulfil. Everyone is doing their job to the best of their individual ability, and it’s still becoming clear that some orders won’t be fulfilled on time.

The moral of the story is that when the production plan still lives mostly in one person’s head, the factory is at risk whenever that person stops being able to track and coordinate the whole shop floor.

The domino effect

Plant managers know this situation well. Not because their systems are outdated or because the teams are doing something wrong. It is because production planning changes by the hour. One machine stop, one missing operator or one delayed delivery is enough to shift everything behind it.

One operations manager in specialty chemicals described it this way during the research interviews: “One domino falls and 25 others have to be reset before the chain stands again.”

That description stuck because everyone immediately understood it, not as an exception, but as normal production life.

Excels and “better Excels”

The tools already in place usually solve part of the problem. ERP systems know the orders and materials. APS add-ons sequence machines. Excel fills the gaps because it is fast, flexible and familiar to everybody involved.

But the same hole keeps showing up between all of them: people.

A machine may technically be free at 08:00 and appear as such in the schedule. But if two qualified operators are absent, the line cannot run the way the system says it can. Most planning tools still treat personnel availability as a separate topic rather than as part of production scheduling itself.

That gap appeared in every interview behind this research.

One plant manager called his current planning software “a better Excel.” Another said the system could schedule machines but not personnel, which he described as “a huge disadvantage.”

The phrasing is revealing because it reflects how these systems are felt on the floor. Nobody we spoke to was asking for a “smart factory” vision or a fully autonomous planning engine. Most were trying to get through the week without having to rebuild the production plan three times a day. What they wanted was visibility, an answer to too-common questions like:

• If one order moves, what else moves with it?

• Which workstation groups are affected by a supplier delay?

• Does the available shift actually match the workload scheduled for today?

• And who besides the senior planner can see all of this clearly enough to react fast?

That last point came up repeatedly. In one plant, a long-time planning lead had effectively memorised the production schedule for weeks ahead. People called him at night because he was the only person who fully understood how everything connected. When he retired, a large part of the planning logic retired with him.

That kind of dependency is more common than most companies admit.

Many production plant SMEs still rely on experienced people to compensate for fragmented systems every day. The schedule becomes a negotiation between ERP data, spreadsheets, staffing realities and customer pressure. Which is also why Excel refuses to disappear.

None of the people interviewed treated Excel as the enemy. Most spoke about it pragmatically. It’s the shadow system that keeps planning flexible when changes appear faster than the official software can keep up. That creates a difficult position for new planning software.

Factories are not looking for another massive transformation program. Most do not have spare implementation teams sitting around. Some have a single internal IT person supporting the entire site. Others are still trying to finish ERP projects that started years ago.

The pressure is elsewhere. The production managers we consulted with talked far more about replanning stress than digital transformation.

One operations manager described stress as “the be-all and end-all in production.” Another said scheduling had become a daily firefighting effort. The hard part was never creating the original production plan, but rather rebuilding it after reality interfered with it.

Traditional APS tools are often built around relatively stable assumptions. Real factories are rarely stable for long. People call in sick; materials arrive late; customers change priorities; machines stop unexpectedly. Each one of these unexpected problems can cause the planning process to start from scratch. And planners end up coordinating changes manually across systems that never fully connect.

That is the problem that the Production Planning Dashboard is built around.

The Production Planning Dashboard, a tool for shared scheduling and visibility

The Production Planning Dashboard is a production scheduler for production plant SMEs that need to plan machines, people and orders together rather than separately.

It sits on top of existing systems and creates one shared schedule that the whole production team can work from. When disruptions happen, the system proposes adjustments while keeping the planner in control of the final decision.

The problem is a lack of visibility and coordination, whether it’s due to siloed information, cascading problems due to inflexibility, or tools that offer only fragments of the whole picture. The solution is one schedule that considers machines, people and orders.