If the production plan fails
Why Pharma and Chemical Re-planning Needs More Than Excel
Monday morning, 8:15 AM. A line is unavailable as planned, a precursor product is arriving later than announced, and at the same time, demand for a key product is noticeably increasing. The production plan is not worthless because of this. But it becomes uncertain at the very moment quick decisions need to be made. Many companies still react to such situations with spreadsheets, experience-based knowledge, and a series of manual adjustments. This works as long as individual parameters shift in isolation. However, in the reality of production planning, this logic falls short. This is because demand, capacities, material availability, sequences, and priorities don't change one after another, but simultaneously.
This presents a serious planning challenge, especially in the pharmaceutical and chemical industries. One sector is characterized by high regulatory and quality requirements, while the other faces tight economic constraints, volatile costs, and complex production interdependencies. In both cases, reacting to changes only locally means losing valuable time precisely when robust replanning is most critical.
„If a parameter changes, the logic of the entire plan often needs to be re-examined.“
When something changes, it's not just one value that gets shaken up.
A production plan can easily be read as an overview of quantities and deadlines. It becomes more difficult when the underlying conditions change. Then it's no longer just about updating individual numbers. Decisions need to be made again about which orders have priority, how capacities can be used differently, which delays are still acceptable, and what consequences arise elsewhere as a result.
This is precisely where the limits of Excel-based planning become apparent. Spreadsheets can make many things visible, but they cannot reliably handle the consistent reassessment of interconnected decisions under multiple constraints simultaneously. Therefore, manual adjustments often solve a local problem while shifting the next difficulty to the following period, another line, or another product.
„Even a single failure can shift priorities, quantities, and availability throughout the entire plan.“
In the pharmaceutical industry, a deviation quickly becomes a supply problem
In the pharmaceutical industry, this dynamic is particularly pronounced. Production problems, quality deviations, raw material shortages, or surges in demand often have immediate effects on availability and supply. Added to this are release times, material-specific restrictions, predefined process steps, and the need to stay within reliable framework conditions even under time pressure.
This is why replanning here is not simply a matter of higher computing speed. It must produce decisions that are operationally realistic, secure in their prioritization, and actually feasible under the given conditions. If a batch fails or a line is unavailable at short notice, it is not enough to redistribute quantities. The real question is which alternative makes the most sense overall given the remaining restrictions.
„A revised plan is only good if it holds up under utilization, conversion, and costs.“
In chemistry, redesign often determines both stability and cost-effectiveness.
Even in chemistry, the situation is rarely stable enough for rigid planning. Weak demand, high energy costs, economical batch sizes, campaign-dependent production sequences, and limited flexibility of individual plants mean that short-term changes can become expensive. A shift that looks sensible at first glance can cause high conversion costs elsewhere, poorer capacity utilization, or additional inventory risks.
The challenge is therefore different from that in pharmaceuticals, but no less significant. While security of supply and permissible responsiveness are the primary focus there, in chemistry, it is often more about how a changed plan can be economically and operationally viable, without losing production stability. Especially in campaign-driven production, the value of replanning often depends on whether additional changeovers, energy consumption, and utilization can be evaluated together instead of sequentially.
„The difference lies not in computing faster, but in better comparing courses of action.“
Good replanning not only replaces numbers but re-evaluates options for action
The crucial difference lies in the method. Good replanning doesn't simply replace an old number with a new one. When demand, capacity, or material availability change, it's not just quantities that need adjusting. It's necessary to re-decide which orders have priority, how equipment is utilized, and what the consequences are for service, costs, and stability.
This sounds technical at first, but it's very concrete in terms of operations. What's crucial is how a change affects priorities, line allocation, sequences, utilization, and service. Only when these interrelationships are considered together does a plan emerge that is not only quickly adapted but also sustainable.
From frantic corrections, a comprehensible consideration emerges.
This is precisely where the strength of mathematical optimization lies. It doesn't provide arbitrary suggestions but evaluates courses of action based on clear objectives and constraints. This makes it visible which decision creates the best balance between competing requirements.
In production planning, such conflicting objectives are the rule. Serving a prioritized product faster can trigger additional changeovers. A capacity shift can improve service but increase costs. Alternative procurement can stabilize supply, but at the same time burden margins or complexity. Systematic replanning not only makes these conflicting objectives more transparent, but also brings them into a form that is repeatable and traceable.
Further interesting content
Example:
What happens if a bottleneck is not treated in isolation
Suppose a critical active ingredient arrives late, while demand for an important product simultaneously increases. In Excel, this often triggers a chain of local corrections: quantities are shifted, slots are rearranged, and priorities are re-marked. However, the crucial question often remains unanswered: What are the overall consequences of this reaction for the rest of the production plan?
A model that systematically evaluates planning alternatives, instead, examines which combination of shifting, reprioritizing, capacity utilization, and possible alternatives yields the most viable plan under given conditions. This is not a theoretical luxury. It is the difference between frantic adjustments and a resilient decision under time pressure.
„Value is created when changes can be quickly incorporated, alternatives compared, and decisions can be well-justified.“
When replanning becomes part of production control
The benefit of a specialized planning system is not just about faster calculations. Crucially, changes in demand, capacity, or procurement options can be incorporated as new planning prerequisites, alternatives can be consistently compared, and decisions can be justified in a traceable and repeatable manner.
For pharmaceuticals, this is particularly valuable because decisions there often must be made under high time pressure and, at the same time, within tight operational constraints. For chemistry, the advantage is significant where the economic impact of plan changes is not only to become visible afterwards but must also be considered when selecting the alternative. In projects, we have already achieved savings of up to 5 % and more seen when companies restructure their production planning more systematically and consistently under changed conditions.
From Personal Table Logic to Resilient Planning
Another advantage lies in reproducibility. In many companies, planning knowledge is historically grown within individual files, abbreviations, and personal rules of thumb. This can work in day-to-day business. However, it becomes fragile as soon as scenarios need to be quickly compared, decisions justified, or different stakeholders brought to a common understanding.
OPTANO addresses precisely this point: not with the promise of a simple standard answer, but with the ability to evaluate complex production decisions consistently and repeatably. This is especially relevant when the situation is unstable and the quality of the replanning has a decisive impact on delivery capability, economic efficiency, or operational workload.
An initial plan is important. Production planning becomes truly crucial the moment the original plan no longer fits the current conditions. That's when quick reaction separates from resilient decision-making.
Therefore, planning that can quickly simulate and cleanly evaluate various developments is not an extra for exceptional cases. This offers a clear advantage, especially in pharmaceuticals but also in chemistry: moving away from local spreadsheet management towards traceable decisions under real-world constraints.
If you want to examine how your team can make more resilient production decisions more quickly in the face of demand changes, bottlenecks, or capacity failures, it's worth taking a closer look at the rules governing prioritization and rescheduling today. OPTANO supports companies in shaping this very logic in a way that not only makes scenarios visible but also leads to resilient decisions.
Key Takeaways
- Re-planning becomes relevant when production conditions change faster than manual planning can cleanly keep up.
- In pharmaceuticals, the benefit is particularly high because quality, release, and supply risks tightly couple decisions.
- In chemistry, added value is created primarily where changed plans must be economically and operationally viable at the same time.
- Excel can map planning information, but structurally hits limits with coupled decisions.
- Mathematical optimization helps to systematically and reproducibly evaluate conflicting goals under constraints.
- Real progress lies not in faster calculations, but in better decisions under changing conditions.