potential analysis
blogStart potential analysis
Sales and Operations Planning

S&OP process:
From planning
to impact

80% of all manufacturing companies plan sales and capacity in separate systems. The result: excess inventory, delivery bottlenecks, and decisions based on gut feeling. S&OP closes this gap.

Start potential analysis
5
steps
S&OP / SIOP

Nico Röpnack · March 2026 · 12 min read

80% of all manufacturing companies plan sales and capacity in separate systems. The result: excess inventory alongside supply bottlenecks, forecast meetings without consequences, gut feelings instead of control. S&OP is the process that closes this gap.

80%

plan in separate systems

disambiguation

Three acronyms, one goal:
Combining planning and implementation

S&OP, SIOP, and S&OE describe different levels of maturity of the same basic concept. Here is the distinction.

Classic

S&OP

Sales & Operations Planning
Monthly comparison of sales, production, and inventory. Strategically aligned with a horizon of 6 to 18 months. Decisions are made at the management level.

expansion

SIOP

Sales, Inventory & Operations Planning
Inventory optimization as a separate adjustment factor. Particularly relevant for companies with a wide variety of products or seasonal fluctuations.

Operational

S&OE

Sales & Operations Execution
Weekly or daily fine-tuning to ensure that the S&OP plan does not end in the meeting, but reaches production.

core principle

A uniform data set across all departments instead of silo planning in separate Excel files, ERP modules, and individual solutions.

Horizon: 6-18 months (S&OP) + 1-3 months (S&OE) = continuous planning flow

The challenge

Five symptoms of a lack of S&OP:
Do you recognize your company?

We see these patterns in almost every initial consultation. Not individually, but in combination.

Symptom 01

Separate planning worlds

Sales plans in Excel, production in ERP, purchasing by email. No one sees the same picture. Each department optimizes for itself, not for the company.

Symptom 02

Excess stocks alongside shortages

Slow movers pile up in the warehouse, while A-items are missing. Inventory management is based on safety margins rather than actual demand data.

Symptom 03

Gut feeling instead of data

Decisions are made in meetings without a structured basis for decision-making. Whoever argues the loudest determines the plan.

Symptom 04

Monthly fire department management

Instead of proactively managing, the team reacts to escalations. Every month begins with the same surprises that needn't have been there.

Symptom 05

Missed delivery dates

Sales makes unrealistic promises, production cannot deliver, and the customer loses confidence. The cause lies not in manufacturing, but in a lack of coordination.

The cost of inaction

What the lack of coordinationreally costs

15-25%

of sales tied up in excess inventory

10-20%

Inventory reduction after S&OP implementation

6-18

Months of forward-looking planning horizon

The hidden costs of a lack of coordination go far beyond inventory levels: missed delivery dates cost customers money, rush orders increase manufacturing costs, and each department optimizes for itself rather than for the overall result. Use our project profitability calculator to evaluate the financial benefits of capacity investments

The cycle

Five steps, one rhythm:
The S&OP cycle in practice

Each step builds on the previous one. A cycle typically lasts one month. Click on a step for details.

1
Statistical forecast

Objective baseline: historical data, seasonality, trends.

The basis of every S&OP cycle: a data-driven forecast based on historical sales data, seasonal patterns, and statistical trend models. No gut feelings, no sales wishes, just mathematics as a starting point.
  • Time series analysis (ARIMA, Holt-Winters)
  • Seasonal adjustment and trend extrapolation
  • Outlier adjustment (removing special effects)
2
Qualitative enrichment

Sales, marketing, and competitive intelligence validate the forecast.

The statistical forecast is enriched with market intelligence. Sales contributes customer developments, marketing adds campaign effects, and product management reports launches and discontinued models.
  • Campaign planning and promotions
  • Customer developments and tenders
  • Product launches, phase-out management
  • competitive movements
3
Capacity and material testing

Check production and purchasing: Can we deliver what the market demands?

Demand meets supply: production capacities, material availability, and supplier lead times are compared with the demand plan. Bottlenecks become visible and scenarios are calculated.
  • Capacity balancing per plant and line
  • Material availability and supplier status
  • Scenario planning: best case, worst case, most likely
  • Identification of critical bottlenecks
4
S&OP meeting

Cross-functional decision: Sales, Production, Purchasing, Finance, Management.

The decision forum: All relevant functions at the table. Gaps are presented, scenarios discussed, responsibilities assigned. Every decision is assigned an owner and a deadline.
  • Deviation analysis: demand vs. supply
  • Scenario decision by management
  • Investment approvals (CAPEX connection)
  • Responsibilities and deadlines
5
Implementation & KPI tracking

Implementation with continuous monitoring of results.

The plan is implemented operationally: production orders, purchase orders, inventory adjustments. This is where it becomes clear whether S&OP was just a meeting or a real management tool. KPIs measure success.
  • Forecast Accuracy: How close was the forecast to reality?
  • OTIF (On Time In Full): Delivery reliability towards the customer
  • Inventory range: days Inventory coverage by category
  • Capacity utilization: Degree of utilization of production capacity

Practical reality

What no textbook explains:
The constraints of reality

In theory, S&OP is a clean cycle. In practice, three constraints overturn the plan before the month is halfway over.

Constraint 01

Frozen zones

Orders are frozen 4 to 12 weeks before production. Changes during this period incur additional costs, delay other orders, or are simply impossible. Depending on the industry: automotive 8-12 weeks, consumer goods 4-6 weeks, chemicals up to 16 weeks.

Constraint 02

Minimum and maximum quantities (MOQ)

Suppliers require minimum order quantities that exceed current demand. At the same time, storage capacities limit maximum quantities. The result: order cycles that do not match sales rhythms.

Constraint 03

capacity cascade

Every change in customer demand triggers a chain reaction that rolls through five stages: customer response, production adjustment, material planning, supplier order, inventory correction.

The Cascade

Five steps, one chain reaction:
From customer to inventory

Those who do not understand this cascade are steering blindly. Each stage has its own lead times, its own constraints, and its own decision-makers.

customer response
Change in demand, order cancellation, rush order, specification change
production
Capacity adjustment, rescheduling, shift change, tool change
Material
Order quantities, minimum purchase quantities, lead times, alternative materials
supplier
Capacity limits, fixation horizons, alternative sources, transport times
inventory
Safety stock, capital commitment, obsolescence, storage capacity

The solution

Digital implementation:S&OP with Smartsheet, n8n, and KNIME (
)

An S&OP process is only as good as the tools that support it. We rely on a combination that combines flexibility with structure.

Smartsheet

Central planning cockpit

Dashboards, automated deviation alerts, structured meeting preparation, and integrated resource planning in one platform.

More on this →

n8n

system integration

Automated data synchronization between ERP, CRM, and Smartsheet. No manual exports, no outdated data, no Excel bridges.

More on this →

KNIME

ML-supported forecasting

Machine learning models for improved sales forecasts. Pattern recognition in historical data that surpasses standard statistical methods.

More on this →

Related topics

S&OP does not stand alone:
These topics are part of it

planning

scenario planning

Best case, worst case, most likely: calculate scenarios before reality decides.

More on this →

Resources

resource management

Manage capacity across teams and locations, identify bottlenecks early on.

More on this →

portfolio

Project and portfolio management

Prioritize projects, reveal dependencies, manage investments.

More on this →

investment

CAPEX assessment

Make data-driven investment decisions. S&OP provides the basis for capacity investments.

More on this →

quality

Gate Review System

Structured approval processes in 5 stages: from the idea to the start of series production.

More on this →

automation

process automation

Automate recurring processes so that the team can focus on decisions.

More on this →

The result

FEW Automotive Group:
From Excel chaos to integrated control

As a Tier 1 supplier in the automotive industry, FEW Automotive requires an S&OP process that leaves no gaps. This is how we implemented it.

5

Gate review stages for production projects

100 %

Digitized planning processes

1

Central platform for all departments

"The standardized user interface was the key. The last 20 percent makes all the difference: a uniform UI, standardized processes, and a team that really uses the platform."

Konstantin, Project Management, Automotive Supplier · Read reference →

implementation

Integrated sales planning

Sales planning, production control, and capacity management in a Smartsheet environment. No Excel bridges, no manual transfers.

standardization

Uniform UI

All departments work with the same interface. Consistent naming, uniform dashboards, standardized workflows.

monitoring

Real-time KPI dashboards

Forecast accuracy, OTIF, inventory range, and capacity utilization at a glance. Deviations automatically trigger alerts.

self-check

Five questions for your
S&OP maturity

Answer honestly: How many of these questions can you answer "yes" to?

1

Do you have a single, coordinated sales plan that all departments consider binding?

2

Do you know your forecast accuracy for the last 6 months, and is it above 70%?

3

Are capacity bottlenecks identified at least 4 weeks before they occur?

4

Is there a monthly S&OP meeting with binding decisions and responsibilities?

5

Can you make a reliable statement within 24 hours if a major customer changes their requirements by 30%?

Less than 3x Yes? Then you are wasting control potential. Talk to us about a potential analysis.

Frequently asked questions

FAQ:
What companies want to know

How long does it take to implement an S&OP process?
The initial implementation takes 3 to 6 months: process design, system setup, first cycles. Most companies reach full maturity (consistent KPI improvement, established routine) after 12 to 18 months. The decisive factor is not the technology, but the discipline of those involved.
Do we need an ERP system as a prerequisite?
No. An ERP system is helpful, but not a prerequisite. Smartsheet as a central planning platform with automated data integration via n8n also works without an ERP system or as a supplement to an existing system. Many of our customers use SAP, ABAS, or proALPHA in parallel.
At what company size does S&OP become worthwhile?
As a rule of thumb: from around 50 employees in production, or as soon as departments are no longer located in the same room. Where sales, production, and purchasing do not communicate with each other on a daily basis, a structured coordination process is required.
How is S&OP related to investment planning?
S&OP provides the data basis for CAPEX decisions. If the sales plan shows that capacities will be insufficient in 12 months, investments must be approved today. Without S&OP, these decisions are based on assumptions rather than validated planning figures.
What is the cost of not having an S&OP process?
Typically, 15 to 25% of working capital is tied up in excess inventory, plus missed delivery dates, lost orders, and rush freight costs. Added to this are indirect costs: management time spent on escalations, frustration within the team, and loss of customer trust.

Your expert

Nico Röpnack

Nico Röpnack

Founder, Lighthouse Consultings. 20+ years of operations and S&OP in the manufacturing industry. Smartsheet ENGAGE 2025 speaker, Forbes Business Council, DHBW lecturer on digital transformation.

Smartsheet Gold Partner ENGAGE 2025 Speaker Forbes Business Council DHBW Lecturer

self-check

Where does your company really stand?

10 questions · 2 minutes · Instant results with specific recommendations for action

Start potential analysis →

Next step

Ready for an S&OP process that really controls?

Find out in 15 minutes where your company stands, what quick wins are possible, and where the greatest leverage lies.

Start free potential analysis Or: Read FEW Automotive reference →
Sources: APICS/ASCM S&OP Body of Knowledge · Gartner S&OP Maturity Model · LHC practical experience (FEW Automotive, 15+ implementations)
Smartsheet Gold Partner – Lighthouse Consultings in the Smartsheet Marketplace