Posts

Example of an automated statistical forecast

At the core of every business strategy for products and services is to provide optimal management of the supply chain. A leak or inefficiency in the supply chain eats away at the organization’s bottom line. Supply chains are becoming more complex with more variations in products, distribution channels, and material planning. Accurate supply and demand planning are essential for optimal productivity and profitability. 

How does a business obtain an optimal supply chain? It comes down to how well an organization can develop a demand plan. Demand is never linear and rarely easy to predict. A planning team needs to have the right historical data that can be used to create a statistical forecast, achieve consensus from the stakeholders, and be quick to pivot on changing internal or external market trends. In this article, we seek to define and discuss the elements of demand planning, analyze the cost of failure, and outline the steps to success.

What is Demand Planning?

Demand planning is a multi-step process to forecast demand, improve accuracy of forecasts, and align inventory with peaks and troughs of demand. In other words, demand planning is the process of forecasting demand for a product or service. 

Successful demand planning is defined by having the right balance of inventory levels to meet customer needs while minimizing inventory surplus or deficiency. 

Here are the four crucial aspects of demand planning in order of importance: 

  • Product Portfolio Management – Product portfolio management oversees the entire product lifecycle. It starts with the introduction of a new product to the eventual end of its product life cycle. Upkeep and maintenance of product data is key to statistical forecasting.
  • Statistical Forecasting – Build a forecast with past inventory data, sales data, and appropriate product history to predict future data or trends.
  • Trends (Internal and External) – Build into your forecast an estimate of casual influences from internal and external trends. Internal trends include seasonality of your products and hiring talent to scale. External trends include unexpected economic crisis, competition, socio-cultural, legal, and political forces. 
  • Events and Promotions – Once a forecast is generated with the above factors in mind, events and promos can be used to help hit your S&OP targets.

The aspects of demand planning go beyond the statistical components of a demand forecast. Demand planning leverages accurate demand forecasts to create action plans for the organization while being privy to internal and external factors that affect supply at all steps of the chain and consumer demand. 

Implementation of demand planning is using analytics of product data and trade promotions to hit sales and inventory targets. Organizations must be quick to pivot and adapt to changing market conditions even after starting a demand plan. 

Demand planning is an ongoing effort to ensure peak profitability management. 

Importance of Automated Demand Planning

Failure to adopt an automated statistical forecasting and demand planning approach can lead to a wide range of issues such as missed deadlines, unhappy customers, Inventory surplus or deficiency or delayed response to market dynamics. 

Delayed response means your business can lose a competitive edge or fall behind competitors. Inability to act quickly on supply chain disruptions has material impact on both top-line and bottom-line numbers and you can end up losing market share to competitors. Below is a list of some of the business impacts of not utilizing automated planning strategies: 

Lost credibility

Losing credibility means lost business. Inability to fulfill customer orders due to bad inventory planning will lead to permanent damage to trust that customers have with your company. This will impact future orders and leave your brand with a significant damage to reputation. 

Wasted Resources

Overestimating customer demand for products leads to significant waste in time, money, and personnel. If turning over inventory fast enough becomes difficult, your business’s cash flow will be impacted. Having high levels of excess or obsolete inventory can lead to significant financial losses. 

To mitigate high costs of failure, businesses now more than ever need to trust the numbers and adopt a sophisticated demand planning strategy that leverages data and market insights. Adopting automated demand planning strategies will lead to actionable forecasts.

Aspects of Demand Planning

Understanding the work required within each element of demand planning will allow you to create the most accurate, up-to-date forecasts that will better inform your Sales and Operations Planning (S&OP).  

1. Product Portfolio Management 

Many times, past sales performance can be used to forecast future sales performance. It is important to regularly upkeep and cleanse product data. Relevant data might include inventory, stockouts as they occur, seasonality, sales, and consumer demand through peaks and troughs. The difficulty here usually is the number of systems keeping these data sets as isolated transactions. 

 

2. Statistical forecast 

Forecasts need a reference point, historical data in sales, inventory, and demand. Basically, what was actualized in the past can be a good indication of future sales. But not all data is useful, old data is typically not as useful as more current data as it might not correlate with future demand. The same bad situation happens when you do not use enough data to create a forecast. The right amount is typically trailing 24 months of most recent data. 

 

 

Example of an automated statistical forecast

Example of an Automated Statistical Forecast

 

Example of demand planning of weekly sales by item

Example of Demand Planning of Weekly Sales by Item

3. Internal Trends 

Internal trends relate to staffing issues at a level in the supply chain, seasonal demand due to product type, frozen capital, slow turnover, stockouts and general unpredictable sales volatility. Internal trends affect even the best steered businesses which makes it imperative to factor these causal influences into the forecast.  

 

4. External trends

External trends are another form of causal influence, but less predictable and usually harder to build into the demand planning forecast. External trends usually force a business to reforecast whereas internal trends are less likely to lead to a new forecast. Businesses that do reforecast and act on changing external trends like an economic recession or changing political climate are best positioned to succeed.  

 

COVID-19 has disrupted the majority of supply chains around the world in unprecedented scale. Amazon is probably one of the most recognizable organizations that has put tremendous effort in shifting their supply chain to prioritize shipping of essential items.

 

In light of COVID19, Amazon quickly refocused shipping priorities and product fulfillment to consumer essential goods. They have been quick to scale, pulling personnel and distribution resources from nonessential consumer goods and hiring 175k new workers in two months. 

 

Demand planners must be quick to identify factors that can impact demand such as natural disasters, news events, internal and external unanticipated issues. To do so, an organization needs to be armed with a central repository of all their information to generate an accurate forecast and adapt to changing market conditions to meet customer demand. 

 

5. Events and promotions

A time bound product promotion might lead to more sales in that time interval at a lesser margin. Holidays like Black Friday and Christmas can generate more sales in those few days than a whole month. 

Once a forecast is set, there needs to be a consensus on the actionable plan that comes out of the forecast. Part of this actionable plan is using events and promotions to hit sales and inventory targets. You want the right balance of inventory turnover, sales, while reducing COGS, and reducing waste in resources. Promos and external sales initiatives can help you get there. 

The Future of Demand Planning

Demand planning is becoming increasingly digital with advances in technology and machine learning. Demand planning software is being developed to better position businesses to adapt and update forecasts real time. Increasing number of businesses are now using CPM tools integrated with their ERP system to create multi version forecasts that are constantly updated and refined to estimate future sales. 

A successful demand planning action will lead to countless benefits including: 

  • Lower inventory costs
  • Decrease in stockouts
  • Waste reduction (obsolete inventory)
  • Increase in on-time, in full deliveries
  • Decrease in expedited shipping costs
  • Better pricing negotiation with suppliers

Contact Solver to Learn More about Demand Planning Software

Solver offers a flexible planning solution where powerful input forms are designed in Excel and deployed in the cloud. Solver can fit any business needs from a manufacturing company trying to forecast sales by month to a  retail business looking to forecast SKU based on historical data. 

Solver’s cloud  CPM solution is fully customizable to fit your demand planning needs. Contact our team today or request a demo for more information about our corporate performance management tool.

This article will focus on key benefits of a data warehouse (DW) when associated with your cloud- and on-premise data sources.

Image taken from Shutterstock.

Image taken from Shutterstock.


Have you watched a Tasty food video on Buzzfeed? The videos always start with a default still of the finished dish, then gives the viewers a tutorial of the ingredients and measurements that go into the recipe. In the same way, a data warehouse (DW), a platform where all of your important data sits, can be seen as the final meal and the ingredients can be interpreted as the different data sources that make up the recipe, in this case, the analysis. Just as ingredients come from different origins, data sources come from different places. This article focuses on the benefits of data warehousing while being on-premise and the cloud.
Read more

This article will focus on the benefits of Business Intelligence (BI) for the sales, marketing, human resources, and information technology departments using Dynamics GP.

Photo taken from Shutterstock.

Photo taken from Shutterstock.


Each department has an important role in a company. As a department leader, you may know what your team needs to achieve department-specific goals. BI solutions that cover budgeting, forecasting, reporting, and analyses can help you meet those goals in an efficient and quicker way. For example, at my own company, the current team of department heads includes Nils Rasmussen for Sales, Gina Louie for Human Resources, IT Manager Allan Bacero, and Marketing Director Vanessa Sierra. I will cover four general departments that you would typically find in an organization and explore how a BI tool would help each department.
Read more

Photo taken from Shutterstock

In this article, we will explore the perspectives of some key leaders in regard to BI software that reports on, plans with, showcases, or manages Microsoft Dynamics GP data.

Oftentimes, the executive team tasks an employee, usually in the finance and/or IT department(s), with finding financial reporting, budgeting, dashboards, or data management solutions for the organization.  You might clearly understand what your team needs to achieve department-specific goals, especially with the muscle memory of processes as they heretofore have gone.  But you might not exactly understand what is important to your team of decision makers, whether that is strictly the executive team or a larger group of stakeholders.  In this article, we will explore the perspectives of some key leaders in regard to BI software that reports on, plans with, showcases, or manages Microsoft Dynamics GP data.
Read more

This article will discuss how Business Intelligence and Corporate Performance Management systems differ – and how they overlap.

Many find the word ‘Business Intelligence’ (BI) often ambiguous and confusing. It can simply mean that you know something about the business, but Gartner, the world’s leading IT research company, defines BI as “an umbrella term that include the applications, infrastructure and tools, and best practices that enable access to and analysis of information to improve and optimize decisions and performance.” The objective is to provide the right knowledge to the right people at the right time to make informed decisions.
Read more

This article is an introduction: I’ll tell you a little bit about myself and my entry into the Business Intelligence realm, as well as my plans to blog about management solutions.

Image taken from Shutterstock.


My name is Hanna Kim, and I’m an Angeleno. If you live in Los Angeles, you will notice that the city is not full of natives, but it is rather a melting pot of people with interesting stories, and I absolutely admire that about this city. As a story lover, I love traveling. I enjoy learning about different cultures and history, but the most fascinating part of traveling is finding layers about myself that I never knew about. It is always a humbling experience.
Read more

This article will discuss the year ahead of us, specifically in terms of what 2016 holds for Business Intelligence and Corporate Performance Management for modern businesses.

Another year has come and gone, seemingly faster than ever – and we’re already into the second month of 2016.  At the end of 2015 or in early January, some people were writing about Business Intelligence (BI) and Corporate Performance Management (CPM) trends they predicted we would see manifest this year.  However, much like my current approach to New Year’s resolutions, I felt it was important to let the dust settle, work through the workload hangover of the holidays, and have the New Year function as a soft opening.  This way, we can approach 2016 with a rolling start that doesn’t set us up for failure.  This article will discuss some key trends and trajectories that data management and analytics will take in 2016.
Read more

This article is going to tackle OLAP cubes as a solution concept for Business Intelligence processes, within the context of other BI data store options.

Let’s do it – let’s talk about OLAP cubes.  With the amount of data only growing, exponentially for some, Business Intelligence (BI) data stores are becoming more and more prevalent – and are sensible ways for modern organizations, companies, and corporations to access, store, and organize company data for financial reports, budgets, and dashboards, as well as financial consolidations.  Whether you’re relying on a data mart, data warehouse, or an OLAP cube, your data queries won’t slow down the Enterprise Resource Planning (ERP) system, and you can grab multiple types of data to enrich and broaden your analyses.  But this article will specifically zoom in on OLAP cubes.  Who manages them?  What are they? When do OLAP cubes come into play?  Where are they staged? Why would you choose an OLAP cube over another BI data store?
Read more

This article will discuss what is trending in terms of Business Intelligence, specifically what you should know about for the rest of 2015 and beyond, so you can continue to make strong, data-driven decisions.

July 1 has come and gone, and we’re flying at full speed in the second half of 2015.  Conferences, summits, business deals, partnerships, and other organizational happenings fill up our days, months, and years, but we have to stay focused on so many things directly related to the success of our company.  One of those things has to be how we access, manage, and analyze our data for stronger, more informed decision-making.  In this article, I’ll discuss what you need to focus on in terms of Business Intelligence (BI) trends for software solutions and how we conduct our analytical processes.
Read more

How you access your data can determine the speed and efficacy you can achieve in your financial reporting processes.  This article will discuss data warehouse and OLAP cube based reporting.

Data is driving decision-making at all levels because data continues to grow in size and significance.  Logging, storing, and evaluating data has become a big part of the business culture today.  In order to produce rich, helpful financial reports for an analysis of a company’s opportunities and challenges, you will have to routinely store, access, and manage your data.  Because of this reality, you might feel overwhelmed your technology options for storing your data.  You have a few options, but they vary in functionality, and one might be better for your company than another, depending on what analysis goals you are trying to achieve.  This article will explore data warehouse and OLAP cube based reporting.
Read more