We use cookies to give you a better experience. Carry on browsing if you're happy with this, or read our cookies policy for more information.

Skip main navigation

Forecasting and collaborative forecasting

Forecasting and Collaborative Forecasting
Scheme analysis strategy & planning Demand & supply management Execution
© University of Twente
You have seen that ERP systems can support many activities in the supply chain. Also, for key activities collaboration between actors in the supply chain is needed that is not always fully supported by the ERP systems. In these cases special purpose systems are acquired or developed and human expertise is needed.
In this article we look at the forecasting process as an example. We use the overview of Pennings and van Dalen on collaborative forecasting and the work of the the GS1 Collaborative Planning, Forecasting & Replenishment Workgroup (CPFR®) Workgroup (both references are stated below).
Retailers use a forecast as input for sales, inventory and order decisions, suppliers for production and procurement decisions, and distributors for capacity allocation decisions. The forecast horizons and units are different for these forecasts: retailers have to forecast consumer demand for short-term stocking decisions, whereas manufacturers have to forecast the actual orders placed by the retailer for long-term production decisions. Errors in a forecast can propagate upstream, distorting the basis on which decisions are made. Even if no errors are made, demand variability increases upwards in the chain – the bullwhip effect.
If all parties in the supply chain develop their forecasts in isolation, they do not make use of the knowledge their supply chain partners have. Sharing information such as sales information, market conditions, stock levels and lead times can make plans more accurate. In addition to sharing information, supply chain parties can also share knowledge and capabilities in working together. However trust is needed between supply chain partners which is not always the case in highly competitive markets.
Sales promotions may have a huge impact on demand. Many other factors may play a role such as product reviews, consumer opinion, regulation, product launches or price setting by the competition etc. As many of these factors can be tacit it is often not feasible to build fully automated forecasting models. Human expert judgement plays a role in such cases.
A typical ‘modern’ forecast process uses Industry information, Historical Information and Sales information. It combines these data sources with information from Sales Directors, product planners and operation managers. The information is used to create various kinds of forecasts using judgmental and statistical techniques also taking promotion plans into account. Based on consensus an ultimate forecast is developed to use as input for planning. Popular techniques to calculate forecasts include regression analysis and simple exponential smoothing (SES). Forecast errors can be intentional or unintentional. Intentional errors can be a result of company politics or competitive forces.
CPFR was setup as a reference model to combine the intelligence of multiple trading partners in the planning and fulfilment of customer demand. CPFR links sales and marketing best practices, such as category management, to supply chain planning and execution processes to increase availability while reducing inventory, transportation and logistics costs. It provides a framework for supply chain partners to collaborate. Key area’s to share information and knowledge and work together are shown in the figure above: Joint planning includes the exchange of strategic goals and plans. In the forecasting process sales data and market analysis are shared. Production and distribution are jointly setup in the execution phase. Finally, exceptions are jointly managed and performance is evaluated together.


© University of Twente
This article is from the free online

Supply Chain Innovation: How Technology Can Create a Sustainable Future

Created by
FutureLearn - Learning For Life

Our purpose is to transform access to education.

We offer a diverse selection of courses from leading universities and cultural institutions from around the world. These are delivered one step at a time, and are accessible on mobile, tablet and desktop, so you can fit learning around your life.

We believe learning should be an enjoyable, social experience, so our courses offer the opportunity to discuss what you’re learning with others as you go, helping you make fresh discoveries and form new ideas.
You can unlock new opportunities with unlimited access to hundreds of online short courses for a year by subscribing to our Unlimited package. Build your knowledge with top universities and organisations.

Learn more about how FutureLearn is transforming access to education