What Is Sales and Operations Planning (S&OP)? A Guide for Mid-Market Manufacturers

Lennard Kooy

·

8 min read

Sales and operations planning (S&OP) is the monthly cycle that aligns demand forecasts with supply capacity. Most mid-market manufacturers still run it on spreadsheets, creating delays and blind spots. This guide covers the five-step S&OP process, common failure modes, and how an AI layer inside your existing ERP can automate the data work that slows the whole cycle down.

Table of contents
Loading contents...

Sales and operations planning is the process that connects what your customers want to buy with what your factory can actually produce. For mid-market manufacturers, getting this right is the difference between hitting delivery dates and losing accounts.

Yet most mid-market operations teams still run S&OP on a combination of ERP exports, spreadsheets, and monthly meetings where the numbers are already two weeks old. If that sounds familiar, this guide will show you what good looks like, what breaks it, and how to fix it without replacing your ERP or hiring a planning department.

Why Sales and Operations Planning Matters for Mid-Market Manufacturers

Sales and operations planning (S&OP) is a cross-functional process that balances demand, supply, inventory, and financial targets on a rolling planning horizon, typically 12 to 18 months.

For large enterprises, S&OP is a well-resourced discipline with dedicated planning teams and specialised systems. For mid-market manufacturers with EUR 10M to EUR 100M revenue, the reality is different. Planning responsibility often falls to a single operations controller or supply chain manager who also handles procurement, scheduling, and daily firefighting.

The result: S&OP becomes a monthly reporting exercise rather than a decision-making process.

The cost of getting it wrong

A European mid-market manufacturer with 500 SKUs and three production lines typically faces:

  • Excess inventory tying up 15-25% more working capital than necessary

  • Missed delivery windows because production schedules do not reflect the latest demand signals

  • Revenue leakage from expediting costs, overtime, and air freight to cover planning gaps

  • Customer churn when delivery reliability drops below competitor benchmarks

The Five Steps of the S&OP Process

A standard S&OP cycle runs monthly and follows five steps:

Step 1: Data gathering

Collect sales forecasts, open orders, inventory levels, production capacity, and supplier lead times from your ERP and CRM. This is where mid-market teams spend the majority of their time.

Step 2: Demand review

Sales and marketing align on a consensus demand forecast. They adjust for promotions, seasonality, new product launches, and customer-specific commitments.

Step 3: Supply review

Operations assesses whether current production capacity, materials availability, and supplier lead times can meet the demand plan. Gaps are identified. Constraints are documented.

Step 4: Pre-S&OP meeting

A cross-functional team reviews the demand-supply gaps. They evaluate scenarios, assign risks, and prepare recommendations for leadership.

Step 5: Executive S&OP meeting

Leadership approves the plan, resolves trade-offs between competing priorities, and commits resources.

In theory, this entire cycle takes five working days. In practice, most mid-market teams spend two to three weeks because step one, data gathering, consumes 60-70% of the total effort.

How the Industry Tries to Solve S&OP Today

Spreadsheets and email

The operations controller exports data from the ERP, builds a planning workbook in Excel, and emails it around for input. Version control is non-existent. Formulas break. Numbers are out of date by the time the meeting happens.

Dedicated S&OP modules

Enterprise ERP vendors offer planning add-ons with advanced forecasting, constraint modelling, and scenario analysis. These are powerful, but they come with six-figure implementation costs, multi-month deployment timelines, and a dependency on clean master data.

BI dashboards

Power BI or Tableau can visualise the data, but they do not create a planning workflow. Dashboards show you what happened. They do not help you decide what to do next.

How an AI Layer Inside Your ERP Changes the S&OP Process

The shift happens when you stop treating S&OP as a reporting exercise and start treating it as an automated data pipeline with human decision points.

Automated data gathering

Instead of manually exporting and reconciling data from multiple systems, the AI layer pulls sales orders, inventory positions, production schedules, and supplier confirmations directly from the ERP. It normalises the data, applies business rules, and flags exceptions.

This eliminates the export-reconcile-email cycle that currently takes days.

Exception-based demand review

Rather than reviewing every SKU line by line, the AI layer surfaces only the items where the forecast has deviated significantly from the trend, where a customer has changed ordering patterns, or where a new product launch is approaching.

This reduces review time from days to hours.

Scenario modelling with live data

The AI layer can generate supply scenarios based on current constraints: what happens if we add a shift on line 2? What if supplier X delivers two weeks late? What if demand for product family Y increases by 20%?

These scenarios are calculated in minutes, not days, because the AI layer has direct access to the ERP data.

What This Looks Like in Practice

Consider an operations controller at a mid-market manufacturer producing industrial components. On the first Monday of the month, they open their ERP and see a pre-populated S&OP dashboard showing:

  • A consensus demand summary by product family, with exceptions highlighted in amber (deviation > 10%) and red (deviation > 25%)

  • A supply gap report identifying three product families where production capacity falls short of demand in weeks 6 through 8

  • Two pre-calculated supply scenarios: one adding overtime on line 2, another shifting production of a lower-priority family to the following month

  • A supplier risk flag showing that a key raw material supplier has missed the last two delivery windows

The controller reviews the exceptions, adjusts two demand figures based on a conversation with the sales team, and selects a supply scenario. The pre-S&OP pack is ready by Tuesday morning.

Total time spent on data preparation: under two hours, down from two to three days.

Trade-offs and Risks

  • Unreliable ERP data. An AI layer that reads from your ERP will produce bad outputs if the inputs are bad. Fix data quality first.

  • No existing S&OP process. Automating nothing produces nothing. Start with the process before adding automation.

  • Very short planning horizons. S&OP is a tactical-to-strategic process. If your business operates on a weekly order-by-order basis, monthly demand-supply balancing will not add value.

  • Missing stakeholder buy-in. S&OP requires cross-functional participation.

Next Step

If you want to see how an AI layer inside your ERP can automate the data-gathering phase of your S&OP process, we can show you the workflow using your own data.

See it work with your data. Book a demo with Lleverage.

Turn your manual decisions into intelligent operations

See how we capture your decision intelligence and put it to work inside the systems you already have. Start with one workflow. See results in days.

Turn your manual decisions into intelligent operations

See how we capture your decision intelligence and put it to work inside the systems you already have. Start with one workflow. See results in days.