Business Solutions Archives

S&OP : Streamlining Business Operations with Sales and Operations Planning

Posted on June 28, 2023April 3, 2024 by Makrand Jadhav

In the fast-paced and competitive world of business, effective Sales & Operations (S&OP) management is the key to success. It is the backbone that ensures smooth and efficient functioning of all aspects of an organization from demand to supply-chain to customer deliveries. From optimizing processes to streamlining resources, effective S&OP management has a profound impact on productivity, customer satisfaction, and overall profitability.

There are 3 broad aspects of S&OP processes:

Demand planning: By analyzing and forecasting demand patterns, organizations can align their resources, such as inventory, workforce, and equipment, with the actual needs. This prevents overstocking or shortages, reduces waste, and improves cost-effectiveness.

Supply planning: By implementing robust contingency plans, diversifying suppliers, and developing efficient supply chain management strategies, businesses can reduce the impact of disruptions such as natural disasters, market fluctuations, or supplier issues.

Operations planning: Effective operations management plays a vital role in delivering exceptional customer experiences. By ensuring timely delivery, accurate order fulfillment, and seamless service, businesses can meet and exceed customer expectations. This results in improved customer satisfaction, loyalty, and positive word-of-mouth, which can drive sustainable growth and success.

Understanding Sales and Operations Planning (S&OP)

Sales and Operations Planning (S&OP) is a collaborative process that integrates sales, demand planning, and supply-chain planning functions within an organization. It serves as a bridge between these departments, aligning their activities to achieve a unified and synchronized approach to business planning and execution.

The primary role of S&OP is to establish a cohesive framework that enables effective decision-making, resource allocation, and demand-supply balancing. It brings together sales forecasts, production plans, inventory management, and financial projections to create an integrated plan that meets customer demand while optimizing operational efficiency and financial performance. Through S&OP, organizations can anticipate demand fluctuations, optimize production and inventory levels, and align resources and capacity to meet customer needs effectively. It enables proactive management of supply chain risks and helps organizations respond quickly to market changes or unforeseen events.

S&OP provides a structured framework that encourages collaboration and alignment across various departments, such as sales, operations, finance, and supply chain. It enables these teams to collectively assess and evaluate the impact of their decisions on the entire organization. By considering multiple perspectives and analyzing the interdependencies between functions, S&OP helps avoid siloed decision-making and fosters a more comprehensive and integrated approach.

S&OP integrates sales forecasts, production plans, and demand data to create an accurate and reliable forecast. By leveraging historical data, market insights, and input from different departments, organizations can develop a more accurate understanding of future demand patterns. This enables proactive planning and resource allocation, helping businesses avoid inventory shortages, minimize excess inventory, and optimize production capacity.

Moreover, S&OP allows organizations to evaluate different scenarios and conduct what-if analyses. By simulating the impact of various factors, such as changes in demand, pricing, or capacity, organizations can assess the potential outcomes of different decisions. This helps in making informed decisions and developing contingency plans to mitigate risks or capitalize on opportunities

The ultimate goal of Sales and Operations Planning (S&OP) is to achieve a balance between demand and supply within an organization. This equilibrium ensures that customer demand is met without excessive inventory or resource shortages. By aligning sales forecasts, production plans, and inventory management, S&OP aims to optimize operational efficiency while fulfilling customer needs. The process involves assessing demand patterns, analyzing capacity and resources, and making data-driven decisions to achieve the right balance. A harmonious balance between demand and supply enables organizations to enhance customer satisfaction, minimize costs, maximize profitability, and maintain a competitive edge in the market.

Key Components of an Effective S&OP Process

Forecasting

Forecasting is part art part science. The science part involves looking at historical data by month, by product, adding seasonality and arriving at a forecast. Organizations can also use statistical techniques to help them automatically forecast on similar lines.

The art part lies with the sales team and their judgement in determining by when they expect their customers to actually place the orders. They will consider the time required to develop BOMs, share proposals, negotiations, and finally customer purchase order process.

An organization needs to take into consideration both these aspects in arriving at their final rolling forecast.

Demand Planning

Demand Planning is the science of determining how much goods should an organization manufacture given the market demand, available inventory, and the production capacity such that no buyer goes unsold, and they are left with minimum or nil inventory on hand.

So it’s the Demand Planning team’s job to take forecasts from the sales team apply their judgement, use insights/ trends, and market information to finalize the supply plan. The higher their accuracy in forecasting “how much to produce”, the higher the chances of lower inventories and that the company is not leaving money on the table (missed sales).

Forecasting is one of the inputs into the demand plan. The demand planner will take into account the budget, the previous purchase patterns by territory, customer, volume and adjust for the existing inventories to arrive at his final monthly demand plan. The challenge lies in bringing together all this data in a plan-able structure while at the same time being able to analyze on various parameters in order to be able to ascertain the final demand. Apart from analyzing historical trends the demand planning team also brings together external market research data to aid their decision-making. This plan can act as a sound overlay over the historical analysis. This is the starting point of the S&OP process and organizations need to balance the forecast with production such that they are minimizing slow moving stock and demurrage but at the same time delivering the goods on time as required by the customer. These 3 along with the forecast accuracy determine the impact of the Demand planners have on the organization’s top line and bottom line.

Supply Planning

Once the supply planner receives the demand plan he/she needs to take into account the constraints before finalizing the supply plan. Constrains with respect to production capacity, supplier capacity, and raw material lead times. While the capacity can be augmented by adding suppliers it cannot come at the cost of quality. In industries where the raw material is a natural resource like crude, minerals one needs to take into account sudden shortages by stocking adequate reserves.
This s the crucial stage of the S&OP process as this plan will then be rolled out for the production plan and will have a direct bearing on customer deliveries.

The last step in the S&OP process is to finalize the monthly plan. Once the demand plan and the supply plan is determined all the relevant teams including sales, demand planning, supply planning, productions, procurements, and operations come together to finalize the monthly plan. Multiple informal deliberations later, each team offers its final best possible scenarios. Given the accuracy of the forecasts it will be rare to ensure that everyone gets what they want. Some customer deliverables may be impacted, production may have to ramp up slow-moving lines, supply teams may have need to look for new suppliers. All these options and variables are given due weightages begore agreeing on the final plan which is usually called the consensus pls. This is also the stage where system generated, statistical-modelling generated plan are also taken into consideration.

Benefits and Advantages of S&OP Implementation

As seen above, Sales and Operations Planning (S&OP) is a strategic business process that helps organizations align their sales and operations functions to achieve a balanced and integrated approach to decision-making. The implementation of S&OP offers several benefits and advantages, including:

Improved Forecast Accuracy: S&OP facilitates better demand planning by integrating inputs from various departments, resulting in improved forecast accuracy. This helps organizations optimize inventory levels, reduce stockouts, and enhance customer satisfaction.

Enhanced Supply Chain Visibility: S&OP provides a holistic view of the entire supply chain, enabling organizations to identify potential bottlenecks, risks, and opportunities. This visibility allows proactive decision-making and better coordination between different functional areas, such as sales, operations, procurement, and logistics.

Efficient Resource Utilization: S&OP enables organizations to align their resources, including labor, equipment, and materials, with anticipated demand. By optimizing resource allocation and utilization, organizations can improve productivity, reduce costs, and minimize waste.

Better Inventory Management: S&OP helps organizations achieve optimal inventory levels by aligning production plans with anticipated demand. This prevents overstocking or understocking situations, reduces carrying costs, and improves cash flow.

Enhanced Customer Satisfaction: With S&OP, organizations can ensure that they meet customer demands consistently and on time. By aligning sales forecasts, production plans, and inventory levels, companies can fulfill customer orders promptly, improve order fill rates, and strengthen customer relationships.

Agility and Responsiveness: S&OP facilitates a more agile and responsive organization. It helps break down silos and fosters a culture of collaboration and shared accountability. By regularly reviewing and updating plans, organizations can adapt to changing market conditions, customer preferences, and unforeseen events, enabling them to seize opportunities and mitigate risks effectively.

Strategic Decision Support: S&OP provides a platform for strategic decision-making by bringing together key stakeholders to discuss and evaluate various scenarios and options. This supports informed decision-making regarding capacity expansion, product portfolio changes, market entry or exit, and other strategic initiatives.

Financial Performance Improvement: Through better demand planning, inventory management, resource utilization, and decision-making, S&OP contributes to improved financial performance. It helps reduce costs, increase revenue through improved customer service, and optimize investment in resources and capacity.

Overall, the implementation of S&OP provides organizations with a definitive competitive advantage in the market leading to improved efficiency, customer satisfaction, and financial performance.

Common Challenges in S&OP Implementation

The primary challenges in Implementing Sales and Operations Planning (S&OP) are organizational in nature. Some common challenges include:

Organizational Silos: S&OP requires collaboration and integration across different functional areas, such as sales, operations, finance, and supply chain. However, organizational silos and conflicting objectives can hinder effective communication, information sharing, and alignment. Breaking down silos and fostering a cross-functional mindset may require changes in organizational culture and structures.

Planning Horizon and Time Horizons Mismatch: S&OP aims to align short-term operational plans with long-term strategic goals. However, organizations often face challenges in striking the right balance between short-term operational efficiency and long-term strategic objectives. This requires defining appropriate planning horizons and ensuring that decisions made in S&OP meetings consider both short-term and long-term implications.

Implementation approach: As is proven, organizations should take a phased approach to implanting a S&OP solution. S&OP cuts through multiple functions thus impacts them all. So, while the planning may be unified the rollout should be in phases. This will ensure the organization can adapt and apply their learnings to refine and fine-tune the solution tot their processes and vice-versa.

Data Accuracy and Availability: S&OP relies on accurate and timely data from various sources, including sales, production, inventory, and finance. Inaccurate or incomplete data can lead to poor forecasting, unreliable plans, and inefficient decision-making. Ensuring data integrity and establishing data-sharing mechanisms can be a significant challenge.

System Integration and Technology: S&OP relies on accurate and integrated data from various systems, such as Enterprise Resource Planning (ERP), Customer Relationship Management (CRM), and Supply Chain Management (SCM) systems. Integrating these systems and ensuring data consistency and compatibility can be challenging. Organizations may need to invest in appropriate technology solutions or customization to support S&OP processes effectively.

Overcoming these challenges requires a comprehensive approach that involves strong leadership, effective change management, robust data management, cross-functional collaboration, and ongoing monitoring and improvement. By addressing these challenges, organizations can successfully implement S&OP and reap the associated benefits.

Points to consider when evaluating S&OP software

When organizations are looking to evaluate S&OP software they should consider the following points:

The foundational block of S&OP planning is multi-function collaboration. Organizations need to ask how the S&OP software enables connected planning across functions. The software should also have the ability to communicate – capture observations, notify stake holders and those responsible to take actions, maintain the history so that teams can relate to and comment on the tasks/status.

The next important capability is the ability to forecast. At the end of the day the desired outcome of any S&OP project is the improvement in the organization’s demand accuracy. Thus statistical modelling algorithms will have a key role in determining this outcome. The types of algos, their applicability to use cases, their richness and accuracy are key points to look for.

Lastly as different functions are going to participate in the S&OP process it is obvious that the software will need to provide respectable response time to all of them, especially during peak times. Having a robust multi-dimensional engine capable of processing billions of cells becomes a necessity. This means the software having the power to scale to manage the multiple users, their requests and analysis.

S&OP can be a strategic competitive differentiator for organizations them in the market place. The processes have been in place and refined over time. Technology has made it possible to easily manage the scale and complexity presented by S&OP processes. Organization which are able to support their processes by a connected planning software will benefit immensely through lower inventory holding, product availability, and timely deliveries. Deflytics has executed multiple S&OP projects including one for speciality chemicals, another for agriculture producer, and one of a media broadcaster. We can help marry your objectives and processes to the right solution and deliver real-world business outcomes.

FAQs

What is the difference between S&OP and IBP?

S&OP primarily focuses on integrating sales and operations functions for short- to medium-term planning. It aims to balance demand and supply. On the other hand, IBP takes a broader perspective by integrating multiple functions, including finance, marketing, and supply chain, to align overall business plans and drive performance across a longer time horizon. IBP emphasizes financial integration, strategic planning, and cross-functional collaboration to achieve holistic and integrated decision-making.

How long does it take to implement S&OP?

A S&OP project implementation can take 3-8 months depending upon the scale of the organization, complexity of their processes, and the sub-processes involved.

What are the key success factors for S&OP?

While the key factors have been enumerated above, in short – collaborative processes scalable planning platform, and reliable data are 3 key success factors for S&OP.

Can S&OP help improve customer satisfaction?

Customer Delivery Index measures the on-time delivery of the agreed products to customers. By integrating all the relevant functions responsible for this KPI the S&OP process contributes directly to improving customer satisfaction.

FP&A – A Comprehensive Guide to Financial Planning and Analysis

Posted on May 30, 2023April 3, 2024 by Makrand Jadhav

As per Gartner only 13% of organizations identify performance issues before they hit financials. And 81% of organizations take too long to remediate performance issues. This happens because most organizations attempt to operate their financial decision making without proper systems and tools. Financial Planning & Analysis (FP&A) software is the software platform which enables enterprises to model, visualize, analyze, and predict their business and financial plans.

In this blog we will detail the Financial Planning & Analysis (FP&A) process and how organizations can benefit by deploying FP&A systems.

Understanding Financial Planning and Analysis & FPA Process

Financial planning for an organization starts with its business plan. Visualize it as a sum of planned investments and expected returns for a given period. Investments mean the cost the company will incur for people, machinery, operations, etc. And returns in the form of income, revenue and profits. The period is normally a year broken into quarters and months, usually called the annual operating plan or AOP. The period could also be 3 or 5 years when the organization is conducting this for the long term (called long range planning or LRP).

Step-1 in the process is budgeting i.e. detailing the amounts available for each of the functions to carry out their responsibilities and deliver the business results. E.g. the sales department will be provided a budget of X Mn rupees which they can use to onboard new sales team members, invest for marketing, or deploy a CRM software. Similarly the production department will be given a budget which they can use for their operations, across people, processes and technology. HR, IT, Finance each will be provided their respective budgets. These are normally further divided by territories (State, city) or segments (B2B, B2C, etc.).

The other side of the AOP will detail the expected revenues – by products, territories, segments etc. This becomes the organizational goal or target to be achieved in the given period. Obviously the two – investments (also called expenditure) and returns (revenue) are aligned such that they generate the expected profits. This budget thus lays down the numbers that the organization will spend during the given period in order to achieve the business results.

Once the budget is set the next step is to track the progress. This includes capturing the actual earning and expenses. The YTD actual performance data (sales, expenses, headcount, etc.) is captured from the core transaction systems (ERP, CRM, etc.). The objective is to capture the differences (also called variances) and compare it with the AOP plan. This gives the management a good view of how the business is trending for the year and what is the direction it is headed towards.

The next step is Forecasting. This process is also called the Rolling forecast i.e. forecasting the performance for the remainder of the year such that the organization stays on course to meet or exceed the AOP.

The rolling forecast is usually done for a period of 1+3 months i.e. the immediate next month and the following 3 months. The sales organization is expected to share their estimate of what will be the revenue performance in the coming period. Is it expected to be in line with the AOP plan or any different. Similarly on the expense side the expected spend is detailed and compared to the plan. If the sales numbers are expected to be lower, then the analysis will revolve around the key reasons of the shortfall and what interventions need to be brought in to go back to the plan-levels. The cost of these interventions will then flow back into the expense plan and the annual margin and profit target will be altered to reflect the new plan. This process is carried out at the lowest grain (product, customer, SKU) and across dimensions (territory, segment, sales person) to identify which areas of the business are lagging and where are the tailwinds.

The final step of the process is this monthly analysis pack which is reviewed by the management to understand the trends, suggest remedies, and approve the interventions to bring the rolling forecast in alignment with the AOP.

Benefits and Importance of Effective FP&A

The accuracy, frequency, and detail-level of the rolling forecast is the key to analyzing the performance and identifying the challenges or the growth areas within the business. The accuracy is compromised when the source data is unreliable. This usually happens when the organization is not following proper systems and processes. And instead relying on people and point solutions to source, collate, analyze and predict the business results and forecasts. Frequency of the process is also happened due to lack of enabling systems. This actually forces the organization to run the process at lesser frequency compared to the velocity of the business. E.g. many organizations still do quarterly forecasting even though the market dynamics are moving at a faster pace. If they had a system this could be done much faster as the input-output process would have been automated and reliable. Similarly, when attempting to do the analysis using legacy methods (viz. spreadsheets) analysts tend to forego details leading to poor decisions. Having FP&A systems enable superior decision making as they bring-in accuracy, reliability, and speed in the process so that analysts can spend more time taking business impacting decisions.

In addition, FP&A tools augment decision making through their functionalities of visibility and collaboration. Business leaders and management get a real-time, honest view of the business. Everyone if referring to the same version of truth. They can analyze the data by different cuts/ parameters to determine the exact nature/occurrence of the business issue and by connecting it to other areas identify remedial solution. The analysis can be instantly shared to the respective teams for further analysis and action. This can be tracked for updated and closure in the next review/cycle. As per Gartner, high-quality financial planning and analysis (FP&A) can improve decision outcomes by up to 1% of sales. Where as per Forrester, FP&A can result in inventory value balance reduction of 10% to 20%, and SG&A cost ratio improvements of 0.5% to 1.5% through better visibility into real-time forecast and budget data.

Roles & responsibilities of FP&A analysts

We can broadly classify the FP&A roles into analyst and a manager. The analyst is someone with a Finance background, sound understanding of business financials, and in absence of a tool, spreadsheet expert. His role is to develop the analysis required for decision-making by integrating data points, managing templates, co-ordinating with other stakeholders.

The manager’s role is to guide the analyst in the right direction in order to identify revenue, and cost saving opportunities. He also works with the business stakeholders in communicating and sharing the business trends and insights and identifying new strategies and tactics to meet the financial objectives.

Most FP&A teams are aligned by the business units or territories they are supporting e.g. men’s category, India West, Mid-market, etc.

Today most of the analysts spend 50-75% of their time in non-productive tasks such as data gathering/updating, version management, follow-up with other teams, updating macros, developing chart & dashboards, etc. Majority of these tasks can be easily automated allowing the analysts to focus on analysis and fact-finding.

Key features & What to look for in FP&A Software

While FP&A solutions come in different shape and form some of its key capabilities include:

Spreadsheet like user interface – Spreadsheets is the default tool organizations use for developing their financial plan. It has some very intuitive and useful features which aid business planning. Thus, from an end user perspective FP&A systems having spreadsheet like interface helps in faster adoptions, ease of use, and short learning curve.
Multi-dimensional scenario modelling – While spreadsheets have some useful features one of their fundamental drawback is the inability to do multi-dimensional analysis i.e. you can have sales on X-axis and year on Y-axis, but if you want to see a third axis-Z e.g. Product, one can’t do it on the same sheet. Users then end up developing multiple sheets for each of the third dimension. This not only takes more time and effort but it’s also non-intuitive for analysis. Most FP&A solutions have muti-dimension engine at the heart of their capability which enables organizations to model and analyze financial data across multiple dimensions.
Business logic implementation through non-code mathematical expressions – Most users fear adopting new systems because it involves new learning which is technical in nature. They are not trained for this neither is it their core competency. Thus leading FP&A solutions make it easy for non-technical users to define the business rules and assumptions through non-technical English-like programming syntax. This shortens the learning curve and more important quickly gets the users on board.
Ability to define business assumptions and drivers – All financial plans are based on certain assumptions which apply to the overall business plan. Similarly there are important drivers which enable the expected performance. The plan will continue to evolve, and the FP&A team will need the ability to define and change the core assumptions and drivers on an ongoing basis to be able to align the plan with the new scenarios e.g. economic headwinds, RM costs, etc. Thus the FP&A solution must have an easy to use functionality which lets the FP&A analysts capture the assumptions and drivers.
Data processing capability – “Oh .. my spreadsheet has hanged!”. How often have we heard this. And especially when there is a stringent deadline to meet. Leading to re-work, information loss, and long nights at work. To overcome the data volume and processing challenge FP&A solutions have a data processing capability which ensure that even if someone is analyzing historical data, across three dimensions, involving millions of cells, multiple versions, the systems works and provides the analysis in a matter of seconds. Thus users do not have to worry about data processing speed and output.
Self-service reporting – What’s the point of having all the data if users can’t analyze them for making business decisions. While FP&A systems bring together all finance data at one place they also provide built-in reporting, analysis, and dashboarding tools for users. So that the users – do not need to go ask for data every time, can do the analysis independently, and analyse the data in the shape and form they need, and when they need it. The right FP&A solution will enable the business teams to execute all of their business analysis and decision making by bringing together the necessary data and tools, without any dependency or reliance on other teams/functions.

Conclusion

With a FP&A solution one can expect the following outcomes – faster planning, reduced errors, significantly reduced efforts in data collation, clear visibility of the plan and the status to all stakeholders, and collaborative decision making across the organization.

Given the velocity of the business environment today, the speed in decision making is paramount. With FP&A solutions you can expect to get all the required data and analysis to make tactical and strategic decision at your finger tips. This dovetails into a core competitive differentiator in the market place.

Deflytics has more than 10 years’ experience in the domain of F&A and has implemented more than 55 projects across industries. The two FP&A solutions we partner are Anaplan and Workday Adaptive Planning. Once is the pioneer of the connected planning (xPA) paradigm where as the other was built grounds-up for the CFO office. Both together have more than 8000 customers globally including many Fortune 500 customers.

FAQ

How can FP&A help my business make better financial decisions?

FP&A solutions allow you to model, analyze, and predict your financial plan in the minutest grain across (customer, SKU, project, etc) across various parameters (product, territory, segment, etc.). By including actuals and forecast information and leveraging the self-service analysis functionality the FP&A tools organizations can proactively track business performance such as variances, cash-flow, and P&L and take important strategic decisions (reduce margins, expand to new markets, introduce new products, etc.)

How can FP&A support strategic planning and goal setting?

FP&A solutions are fundamentally equipped to model your financial plans. Thus, allowing you to develop goals and targets for every business unit in the organization. The multi-dimensional “what-if” scenario modelling capability of FP&A solutions enable organization to predict future scenario before actually taking the decision e.g. what if we reduce the margin on product-B by 2%? What will be the cost and benefit of expanding to a foreign territory? If we set-up a new plant by investing Rs 100 Cr, when will we start seeing the returns?

What kind of insights can I expect to gain from implementing FP&A systems?

Through a FP&A solution, an organization will be able to proactively manage the health of its business. Some of the key analysis include real-time P&L at SKU, account, project level, Variance analysis, Revenue forecasting, and “what-if” scenario modelling.

How do you tailor FP&A solutions to meet the specific needs of each client?

By studying the current processes and templates and understanding the future-state requirements, we design the FP&A solution to meet individual client requirements. Deflytics has implemented more than 55 FP&A projects and we pull in that rich experience to establish best practices and analytical frameworks which help customers improve the process efficiency and analytics insights for strategic and tactical decision making.

How do you measure the success and effectiveness of your FP&A consulting services?

Our consulting services along with the FP&A solutions we implement have helped organizations – reduce their monthly close process by 10-20%, improve the speed of the FP&A cycle by 20-25%, reduce forecasting errors by 30-40%, reduce the time for financial analysis by 40-50%, and deliver productivity improvements for the FP&A analyst team by 50-70%.

Demand Planning : Your Guide to Demand Planning & Process

Posted on May 11, 2023April 3, 2024 by Makrand Jadhav

Whether you are manufacturing electronics or garments, or whether you are providing financial services or catering services. The starting point for all business is market demand – how many people will buy my products/service in the coming period?

Demand planning is the science of determining how much goods should an organization manufacture given the market demand, available inventory, and the production capacity such that no buyer goes unsold and they are left with minimum or nil inventory on hand. Fluctuating demand, supplier bandwidth, and production constraints- the three core factors that determine how much will be delivered to the customer by when. Demand planning is a system which brings together these 3 elements in a collaborative and transparent manner, overlays it by advancements in predictive modelling to improve their demand accuracy on an ongoing basis.

What Is Demand Planning & Its Importance?

If one does not do demand planning, there are two consequences – either they manufacture less and lose potential business or they manufacture more and are left with excess inventory. Both are not the outcomes any organization would want. While it’s not possible to be 100% accurate, the goal of demand planning is to come as close as possible to the market condition based on customer demand, market dynamics, historical data, stock in hand, and manufacturing constraints. So while the sales teams will be close to the customer and provide their view of how much they expect their customers to buy, Demand Planning role takes a deeper view of the expected demand and adjusts it for the factors mentioned above and develop the final plan. This final plan becomes the basis for supply-chain and production plan.

Demand planning sits in between sales and supply planning and plays a key role in ensuring organization is balancing its objectives between meeting demand and minimizing inventory.

Benefits of implementing demand planning in your business

Demand planning is probably the most challenging business objective to meet. But when done right it provides the best leverage an organization can have. The direct benefits include – Revenues or no business loss, and lower inventory holding costs. You are producing exactly what the market wants, nothing less .. nothing more. Indirect benefits include – customer satisfaction and repeat business. Because you are able to provide the customers what they want, and when they want it they will be satisfied and happy. This will lead to more repeat business which is generally serviced at a lower operational cost. Plus new business with other customers. Downstream impact – improved cash flow, reduced working capital requirement, and better utilization of plant capacity.

Conversely, if you are running your planning on spread sheets today, chances are that the demand planning team is wasting 60-75% of their time in activities such as data collation, version synchronization, macro manipulation, scenario creation, and cross-functional follow-ups. Impact – lengthy cycles, plan errors, static plans and most importantly stale analysis. Not to mention long working hours. Demand planning systems take away these mundane tasks and enable accelerated planning cycles, instantaneous P&Ls, reduced forecast errors, real-time visibility, and multi-dimensional analysis. And more.

Components, Steps, Common Challenges in demand planning

To accurately predict the demand for the forthcoming period – this is the objective of the demand planning team. And a complex one. To begin with, there are at least 4-5 different functions involved in this process – sales, demand plannings, supply planning, production, and delivery. Imagine if sales teams promise deliveries without knowing the stock and order status. Or the demand team creating the plan without knowledge of upcoming orders. Or the manufacturing team producing based on their available capacity alone. All the above scenarios will lead to unintended consequences – non-availability of goods for sale or over production of stocks not in demand.

Thus the planning process entails all the relevant teams collaborating to come up with a consensus plan. The process starts with the sales teams providing their sales forecasts for their territory/ customer. However they may not be able to give it at the grain and accuracy that is required. Plus they may not have knowledge about other factors which matter e.g. historical trend, seasonality, current inventory, and production schedule. E.g. salesperson A has the habit on over-estimating, territory-B is always shows slower offtake in Q2, or RM101 has a lead time of 6 weeks which will impact 8 SKUs. The demand planning team will look at these and many such variables in detail to come up with their demand plan.

A key component is the ability to develop multiple “what-if” scenarios in order to arrive at the final plan e.g. what if we increase the demand for SKU-145 by 1.5%, how will it impact other SKUs. Or what if we reduce the available capacity by 5%, how will it impact the quantities for other customers. Demand planning systems make this super easy for demand planners to visualize multiple scenarios and their impact on other parameters in order to arrive at the best decision.

The key challenges in this process are lack of visibility and collaboration across different stake holders, unavailability of timely historical data, and the time wasted by the demand planning team in collating the required data for analysis. Many a time the plan takes weeks to be frozen across teams, leading to poorer planning and forecast plans.

Apart from predicting the demand at the SKU level, the demand planning team is also the custodian of 3 other KPIs viz. SMS (slow moving stock), DND (detention and demurrage), and last CDI (customer delivery index). They need to balance the demand plan with these 3 objectives i.e. minimize SMS, DND and maximize CDI.

Tools and Software for Demand Planning

Understandably, spreadsheets are the first tools anyone uses for demand planning. While they support the early days, spreadsheets are not designed to handle the complexity, scale, collaboration and analytical capabilities required by the demand planning teams.
Demand planning needs to be executed in sync with the other related planning processes e.g. sales forecast, supply-chain plan, and production plan. Thus the planning solution should be able to support multiple use cases for the organization to be able to have all of their plans connected to one another.

Because Demand planning is essentially a prediction function the system should provide various forecasting models such as linear regression, additive decomposition, triple exponential smoothing, etc. It should have the ability to suggest the best fit model and provide sales forecast prediction. The system should have the ability to do forecast at aggregation level and then disaggregating at SKU level.

Apart from this the common expected capabilities include features such as spread sheet interface, multi-dimensional engine, analytics & dashboarding, and collaboration.

Best practices for demand planning

While the demand planning objectives remain consistent across organizations, they vary based on whether you are in B2B or B2C, whether you are in a MTO or MTS business. Some of the best practices include:

A defined and accepted process – Well understood roles and responsibilities, a shared consensus about the role and importance of the demand planning process, having a clear monthly schedule for all the teams to provide their respective rolling forecast numbers, a consistent template which all the stake holders can adhere to,
SKU/ account level planning – As they say the devil is in the detail. It’s always possible to get summary data from the detailed data but not the other way round. So wherever possible do the demand planning at a SKU/account level. At least of major products/customers. This will enable to organization to decipher the trends better and reason the factors attributing to the demand.
3 demand plans – While this may seem a lot of effort a practice of developing multiple scenarios is easily enabled by a planning tool. One could be your best-case plan, second one as the more realistic case, and the third one as the worst-case plan. All together culminating into an overall agreed consensus plan.
Cross-functional collaboration – This is key to a successful plan. Every department will have its priorities and constrains – the sales team wants to sale more, the production teams wants to utilize its capacity to the fullest and the finance team wants to ensure that the organization is not missing its financial KPIs. When you offer visibility into the assumptions and drivers to everyone concerned there is a likely output which is in the best interest of the organization., and lastly bring together all the stakeholder and jointly develop the final consensus plan.

Conclusion
What is your monthly demand forecast accuracy? If you are able to answer this question and monitor it month-on-month you will be able to find newer ways of improving it. Every single percentage point improvement can mean a revenue impact of millions. A Demand planning solution will ensure that you are capturing more market share and optimizing your costs and inventory.

FAQ

Q. What is demand planning, and why is it important?

Ans. Imagine a customer walks into your store but you do not have what he wants OR you have lots of quantities of another product which no one is asking for. Demand planning helps you solve this problem and that’s why its so crucial to any business.

Q. What are some of the components of demand planning?

Ans. Sales forecast, current inventory, production capacity, seasonality, and historical trends are some of the components that go into making the demand plan.

Q. What are the key steps involved in demand planning?

Ans. Capturing the sales forecast, normalizing it using past data and predictive techniques, comparing with trends/seasonality, and considering inventory and production capacity are the key steps involved in demand planning.

Q. How does demand planning differ from sales forecasting?

Ans. Sales forecasting is done by the sales team listing the orders they expect from their customers in the coming months. The demand planning team will use the sales forecast as a starting point for their process and develop the final demand plan taking into account other factors such as trends, seasonality, inventory, capacity, etc.

Q. What are some demand forecasting techniques that businesses can use?

Ans. Liner regression, triple exponential smoothing, additive decomposition, and winter’s multiplicative are some of the statistical techniques used for forecasting.

Q. What are some challenges that businesses may face in demand planning?

Ans. Not having proper sales forecasts, inability to analyze past data, inability to bring together all the data required for planning purposes, providing trustworthy visibility to relevant stake holders are some of the challenges in the demand planning process.

Q. What role do technology and software tools play in demand planning?

Ans. Doing demand planning without software tools is akin to traveling to a destination without using navigation maps – you will get to your destination but it will cost you more time and money.