{"id":14484,"date":"2026-04-07T08:55:33","date_gmt":"2026-04-07T06:55:33","guid":{"rendered":"https:\/\/optano.com\/?p=14484"},"modified":"2026-04-07T08:55:35","modified_gmt":"2026-04-07T06:55:35","slug":"insights-scenario-based-replanning","status":"publish","type":"post","link":"https:\/\/optano.com\/en\/media\/insight\/2\/insights-szenariobasierte-neuplanung\/","title":{"rendered":"Insights: Scenario-based replanning"},"content":{"rendered":"
\n\t\t\t\t
\n\t\t
\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t

If the production plan fails<\/h1>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t

Why Pharma and Chemical Re-planning Needs More Than Excel\n<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t
\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t

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.<\/p>

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.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t

\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t

\u201eIf a parameter changes, the logic of the entire plan often needs to be re-examined.\u201c<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t

\n\t\t
\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t

When something changes, it's not just one value that gets shaken up.\n<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t

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.<\/p>

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.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t

\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t

\u201eEven a single failure can shift priorities, quantities, and availability throughout the entire plan.\u201c<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t

\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t

In the pharmaceutical industry, a deviation quickly becomes a supply problem\n<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t

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.<\/p>

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.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t

\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t

\u201eA revised plan is only good if it holds up under utilization, conversion, and costs.\u201c<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t

\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t

In chemistry, redesign often determines both stability and cost-effectiveness.\n<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t

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.<\/p>

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.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t

\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t

\u201eThe difference lies not in computing faster, but in better comparing courses of action.\u201c<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t

\n\t\t
\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t

Good replanning not only replaces numbers but re-evaluates options for action\n<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t

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.<\/p>

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.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t

\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t

From frantic corrections, a comprehensible consideration emerges.\n<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t

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.<\/p>

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.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t

\n\t\t
\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t

Further interesting content<\/p>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t

\n\t\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t