Sales and Operations Planning (S&OP) with ERP Data: One Plan for Sales, Stock, and Finance

In many distribution and manufacturing companies, the sales, purchasing, production, and finance teams work with different numbers. Sales targets twenty percent growth, the warehouse plans stock from last year's sales, production schedules machines around orders already received, and finance builds a budget on its own assumptions. The result is predictable: stock piles up for items that do not sell, runs out for items customers want, and monthly meetings are spent assigning blame.

Sales and Operations Planning, or S&OP, is a regular process for bringing all of those plans together into one agreed plan. This article explains what S&OP is, its monthly cycle, the ERP data it needs, the role of technology including AI, and how to start in a mid-sized company without waiting for a perfect system.

Summary

• S&OP is a monthly process that aligns demand, supply, and financial plans into one agreed number
• The cycle consists of a data review, a demand plan, a supply plan, reconciliation, and an executive decision
• The ERP provides the core data: sales history, stock, capacity, supplier lead times, and costs
• S&OP success depends more on meeting discipline and ownership of numbers than on software
• Start with a small scope, such as the main product groups, then expand once the process is running

What is S&OP and why does it matter?

S&OP is where the demand side and the supply side of a company meet, on a regular basis, usually monthly, with a planning horizon of several months up to eighteen months ahead. The output is not just a report but decisions: how much to produce or buy, how much stock to hold, whether to add shifts or capacity, and what that means for revenue, margin, and cash flow.

Without this process, important decisions are made separately by each department. Purchasing orders raw materials in bulk for fear of running out, while finance is trying to hold back spending. Sales promises fast delivery for a big promotion that production knows nothing about. S&OP forces all these assumptions onto one table before they turn into problems.

The monthly S&OP cycle

A typical cycle has five stages that run in sequence every month. Each stage has a clear owner and an output that feeds the next stage.

1. 01Data preparation: closing last month's data, updating actual sales, stock, open orders, and the accuracy of the previous forecast
2. 02Demand plan: sales and marketing review the statistical forecast, then add market information, promotions, new customers, and new products
3. 03Supply plan: operations checks whether that demand can be met with existing production capacity, stock, and suppliers
4. 04Reconciliation: finance translates the plan into revenue, margin, and cash needs, and prepares options where there are gaps
5. 05Executive meeting: leadership chooses among the options, approves one plan, and assigns the actions to be taken

What sets a working S&OP apart is the fifth stage. If the executive meeting only reads reports without deciding anything, the process will soon be seen as a formality. The meeting should focus on exceptions and decisions, for example which products have demand exceeding capacity or which suppliers are at risk of delay.

The ERP data you need

S&OP cannot work well if every department brings numbers from its own spreadsheet. The ERP acts as the single source of data. The most important data includes the following.

• Sales history by product, customer, region, and channel, ideally at least two years
• Open orders and orders scheduled by customers
• Stock position per warehouse, including goods in transit and stock close to expiry
• Production capacity per line or machine, and recipes or bills of materials
• Supplier lead times and delivery performance
• Standard costs, selling prices, and margin per product

The quality of this data depends heavily on clean ERP master data. Duplicate item codes, inconsistent units, or shifting product categories make aggregation wrong. Before starting S&OP, take time to clean up the product and customer hierarchies, because S&OP usually works at the product group level, not per item code.

The right level of aggregation

A common mistake is trying to plan thousands of item codes in the S&OP meeting. The executive meeting only needs to discuss product groups or families, for example ten to thirty groups. Item-level detail is still handled in stock planning and reordering and production scheduling, following the agreed totals.

The role of demand forecasting and AI

A demand plan usually starts from a statistical forecast based on sales history. AI demand forecasting models can capture seasonal patterns, promotion effects, holidays, and outside factors such as weather, giving the discussion a better starting point. But a machine forecast still needs to be enriched with knowledge that is not yet in the data, such as a large customer about to come on board, a competitor cutting prices, or a product being discontinued.

The measures you must track are forecast accuracy and forecast bias. Accuracy shows how close the forecast was to reality. Bias shows whether the forecast tends to be consistently too high or too low. A sales team that is always optimistic will cause stock to pile up, while one that is overly cautious leaves customers disappointed by stockouts. By measuring bias per person or per region, improvement becomes objective rather than a debate.

Balancing demand and supply

When demand exceeds supply capability, or the other way around, S&OP prepares options along with their consequences. Options when demand exceeds capacity include adding overtime, buying from a second supplier, prioritizing the highest margin customers, or postponing a promotion. When demand is lower, the options may be reducing purchases, moving stock between warehouses, or accelerating sales programs.

Each option needs to be translated into financial numbers. This is where S&OP connects with budget planning and financial forecasting. Adding safety stock may protect service levels, but it ties up cash. With ERP data, the impact on working capital and cash flow can be calculated before the decision is made, not after supplier invoices fall due.

Indicators of success

• Forecast accuracy and bias per product group
• Service level, for example the percentage of orders shipped complete and on time
• Stock value and age, including slow-moving stock
• Adherence to production and purchasing plans
• The gap between the financial plan and actual revenue and margin

These indicators should be available automatically from the ERP in a business dashboard, not assembled by hand every month. The team's time should go into analysis and decisions, not copying data.

Common mistakes when implementing S&OP

• Treating S&OP as a project for the planning team only, without leadership attending and deciding
• Discussing thousands of item codes in the executive meeting so the time is lost in detail
• Mixing sales targets with demand forecasts, when a target is an ambition and a forecast is a realistic estimate
• Looking only at next month, so decisions about capacity and long lead time suppliers are always too late
• Not recording the assumptions behind the numbers, so next month nobody can explain why the plan missed

The third mistake causes the most conflict. Targets can be high to motivate the sales team, but purchasing and production plans must follow a realistic forecast. If the two are treated as the same, stock will pile up every time the target is missed. A healthy S&OP shows the target, the forecast, and the gap between them openly, then discusses actions to close that gap.

How to start in a mid-sized company

1. 01Appoint one process owner, usually from supply chain or planning, and make sure leadership attends the final meeting
2. 02Choose an initial scope: five to ten product groups with the greatest influence on revenue or stock
3. 03Prepare standard ERP reports for sales, stock, and orders per product group
4. 04Run the first cycle simply, even if the data is not perfect, and note the data problems you find
5. 05Measure forecast accuracy from the first month so there is a baseline for comparison
6. 06After three to six cycles, broaden the scope and automate the most used reports

Companies with many branches or warehouses need to make sure stock data across locations is consolidated. This ties in with multi-branch report consolidation and warehouse systems that record stock accurately.

Frequently asked questions

Is S&OP only for large companies? No. Mid-sized companies often feel the benefits fastest, because stock or capacity mistakes have a big impact on their cash. A simple version with a monthly meeting and ERP reports already delivers results.

Do you need dedicated S&OP software? Not necessarily. Many companies start with ERP reports and dashboards. Dedicated software becomes useful when the number of products, locations, and scenarios is too large to manage with ordinary reports.

How is S&OP different from the annual budget? The budget is prepared once a year and rarely changed. S&OP is updated every month based on the latest conditions, so the company can adapt faster while still comparing against the budget.

How long until S&OP delivers results? The first improvements are usually visible within three to six months, especially in excess stock and stockouts. A mature process usually takes around a year.

Conclusion

S&OP turns planning from a collection of departmental guesses into one agreed plan updated every month. The ERP provides the same data to everyone, AI helps create a better forecasting starting point, but the real value comes from meeting discipline and executive decisions. Start with a small scope, measure forecast accuracy and bias, and let the process mature from cycle to cycle. The result is healthier stock, fewer disappointed customers, and better controlled cash.