Accuracy in book papers' sales forecasting

The main objective of this thesis was to study if the quantitative sales forecasting methods will enhance the accuracy of the sales forecast in comparison to qualitative sales forecasting method. A literature review in the field of forecasting was conducted, including general sales forecasting process, forecasting methods and techniques and forecasting accuracy measurement. In the empirical part of the study the accuracy of the forecasts provided by both qualitative and quantitative methods is being studied and compared in the case of short, medium and long term forecasts. The SAS® Forecast Server –tool was used in creating the quantitative forecasts.

Defining Sales and Operations Planning Process in an Environmental Management Company

Sales and operations research publications have increased significantly in the last decades. The concept of sales and operations planning (S&OP) has gained increased recognition and has been put forward as the area within Supply Chain Management (SCM). Development of S&OP is based on the need for determining future actions, both for sales and operations, since off-shoring, outsourcing, complex supply chains and extended lead times make challenges for responding to changes in the marketplace when they occur. Order intake of the case company has grown rapidly during the last years. Along with the growth, new challenges considering data management and information flow have arisen due to increasing customer orders. To manage these challenges, case company has implemented S&OP process, though initial process is in early stage and due to this, the process is not managing the increased customer orders adequately. Thesis objective is to explore extensively the S&OP process content of the case company and give further recommendations. Objectives are categorized into six different groups, to clarify the purpose of this thesis. Qualitative research methods used are active participant observation, qualitative interviews, enquiry, education, and a workshop. It is notable that demand planning was felt as cumbersome, so it is typically the biggest challenge in S&OP process. More proactive the sales forecasting can be, more expanded the time horizon of operational planning will turn out. S&OP process is 60 percent change management, 30 percent process development and 10 percent technology. The change management and continuous improvement can sometimes be arduous and set as secondary. It is important that different people are required to improve the process and the process is constantly evaluated. As well as, process governance is substantially in a central role and it has to be managed consciously. Generally, S&OP process was seen important and all the stakeholders were committed to the process. Particular sections were experienced more important than others, depending on the stakeholders’ point of views. Recommendations to objective groups are evaluated by the achievable benefit and resource requirement. The urgent and easily implemented improvement recommendations should be executed firstly. Next steps are to develop more coherent process structure and refine cost awareness. Afterwards demand planning, supply planning, and reporting should be developed more profoundly. For last, information technology system should be implemented to support the process phases.

Rullaavan ennustamisen kehittäminen CASE: ABB Oy Service

Tutkimuksen tavoitteena oli kehittää rullaavan ennustamisen toimintaa, jotta se tuottaisi relevanttia informaatiota tapausyrityksen ohjaukselle. Tutkimuksessa sovellettiin konstruktiivista tutkimusotetta, joka on ratkaisumenetelmä liikkeenjohdollisiin ongelmiin. Tutkimustulos eli ratkaisukonstruktio innovoitiin tutkijan luoman viitekehyksen ja empiirisen tutkimuksen havaintojen avulla. Tutkimustuloksien perusteella analyyttisen rullaavan ennustamisen tarkoituksena on tyydyttää eri ohjaustasojen informaatiotarpeita ja tukea asiakaslähtöisen tapausyrityksen liiketoimintaympäristöön sopeutumista. Tutkimuksen mukaan rullaava ennustaminen on suunnittelua, joka pyrkii organisatoriseen oppimiseen. Kehittämiseen liittyviä näkökulmia, organisatorisia ja järjestelmällisiä tekijöitä löydettiin useita. Nämä eivät rajoittuneet ainoastaan johdon laskentatoimen alueelle.

Use of Statistical Methods in Demand Planning

In a very volatile industry of high technology it is of utmost importance to accurately forecast customers’ demand. However, statistical forecasting of sales, especially in heavily competitive electronics product business, has always been a challenging task due to very high variation in demand and very short product life cycles of products. The purpose of this thesis is to validate if statistical methods can be applied to forecasting sales of short life cycle electronics products and provide a feasible framework for implementing statistical forecasting in the environment of the case company. Two different approaches have been developed for forecasting on short and medium term and long term horizons. Both models are based on decomposition models, but differ in interpretation of the model residuals. For long term horizons residuals are assumed to represent white noise, whereas for short and medium term forecasting horizon residuals are modeled using statistical forecasting methods. Implementation of both approaches is performed in Matlab. Modeling results have shown that different markets exhibit different demand patterns and therefore different analytical approaches are appropriate for modeling demand in these markets. Moreover, the outcomes of modeling imply that statistical forecasting can not be handled separately from judgmental forecasting, but should be perceived only as a basis for judgmental forecasting activities. Based on modeling results recommendations for further deployment of statistical methods in sales forecasting of the case company are developed.

Researching Manufacturing Planning and Control system and Master Scheduling in a manufacturing firm.

The objective of this thesis is to research Manufacturing Planning and Control (MPC) system and Master Scheduling (MS) in a manufacturing firm. The study is conducted at Ensto Finland Corporation, which operates on a field of electrical systems and supplies. The paper consists of theoretical and empirical parts. The empirical part is based on weekly operating at Ensto and includes inter-firm material analysis, learning and meetings. Master Scheduling is an important module of an MPC system, since it is beneficial on transforming strategic production plans based on demand forecasting into operational schedules. Furthermore, capacity planning tools can remarkably contribute to production planning: by Rough-Cut Capacity Planning (RCCP) tool, a MS plan can be critically analyzed in terms of available key resources in real manufacturing environment. Currently, there are remarkable inefficiencies when it comes to Ensto’s practices: the system is not able to take into consideration seasonal demand and react on market changes on time; This can cause significant lost sales. However, these inefficiencies could be eliminated through the appropriate utilization of MS and RCCP tools. To utilize MS and RCCP tools in Ensto’s production environment, further testing in real production environment is required. Moreover, data accuracy, appropriate commitment to adapting and learning the new tools, and continuous developing of functions closely related to MS, such as sales forecasting, need to be ensured.

Kysynnän ennusteprosessi elintarvikealan pk-yrityksissä

Kysynnän ennustaminen on aina ollut suuri ongelma toimitusketjun hallinnassa. Useat päätösprosessit, kuten varastonhallinta, tuotekehitys, tuotanto ja toimitusketjun suunnittelu vaativat ennustamista, jonka tarkka määrittäminen on kuitenkin erittäin hankalaa. Kysynnän ennustaminen on kirjallisuudessa laajasti tutkittu aihealue, mutta sen tutkimukset rajoittuvat suuressa määriin erilaisten ennustemenetelmien vertailemiseen ja ennustevirheiden tutkimiseen. (Chase 1997; Kahn 1998; Makridakis ja Wheelwright 1998; Goodwin ja Fildes 1999) Ennustemenetelmien käyttö ja mahdolliset ennustevirheet ovat kuitenkin seurausta sarjasta peräkkäisiä toimenpiteitä eli prosessista. Siksi onkin paljon mielenkiintoisempaa tutkia kokonaisvaltaisesti koko sitä prosessia, joka ennustamiseen yhdistetään, kuin pelkkiä ennustemenetelmiä tai niiden käytön seurauksena havaittuja virheitä. Tässä tutkimuksessa kartoitetaan viiden elintarvikealalle erikoistuneen pk-yrityksen ennusteprosesseja, joita verrataan keskenään sekä Mentzerin, Bienstockin ja Kahnin (1999) tekemään tutkimukseen ”Benchmarking Sales Forecasting Management”. Tutkimusongelman voidaan katsoa olevan ”millainen on pk-yritysten ennusteprosessi ja mitkä asiat selittävät mahdollisia eroja kohdeyritysten ennusteprosesseissa?”. Tämä tutkimus hyödyntää laadullista tutkimusotetta ja on tarkoitukseltaan kartoittava. Empiirinen aineisto kerättiin teemahaastatteluiden avulla ja haastateltavina toimivat viiden kohdeyritysten toimitusjohtajat. Tämän tutkimuksen aineiston analyysissä on hyödynnetty aineiston ryhmittelyä teemoiksi ja pyritty löytämään samankaltaisuuksia ja eroavaisuuksia kohdeyritysten välille. Tutkimuksen tuloksena havaittiin, että elintarvikealan pk-yritysten ennusteprosessi on hyvin yksinkertainen. Tämän voidaan nähdä selittyvän kohdeyritysten tyytyväisyydellä omaa ennusteprosessia kohtaan, mikä estää prosessin kriittisen tarkastelun ja sitä kautta kehittämisen. Voidaan myös nähdä, että tietämättömyys, inertia ja resurssien rajallisuus estävät ennusteprosessien kehittämisen kohdeyrityksissä. Kohdeyritysten ennusteprosessit olivat hyvin samanlaisia keskenään ja merkittävimmät erot selittyvät, kun tarkastellaan toimialojen luonteiden eroja.

Factors Affecting the Forecasting Accuracy of Diffusion Models

Tutkielman tavoitteena oli tarkastella innovaatioiden leviämismallien ennustetarkkuuteen vaikuttavia tekijöitä. Tutkielmassa ennustettiin logistisella mallilla matkapuhelinliittymien leviämistä kolmessa Euroopan maassa: Suomessa, Ranskassa ja Kreikassa. Teoriaosa keskittyi innovaatioiden leviämisen ennustamiseen leviämismallien avulla. Erityisesti painotettiin mallien ennustuskykyä ja niiden käytettävyyttä eri tilanteissa. Empiirisessä osassa keskityttiin ennustamiseen logistisella leviämismallilla, joka kalibroitiin eri tavoin koostetuilla aikasarjoilla. Näin tehtyjä ennusteita tarkasteltiin tiedon kokoamistasojen vaikutusten selvittämiseksi. Tutkimusasetelma oli empiirinen, mikä sisälsi logistisen leviämismallin ennustetarkkuuden tutkimista otosdatan kokoamistasoa muunnellen. Leviämismalliin syötettävä data voidaan kerätä kuukausittain ja operaattorikohtaisesti vaikuttamatta ennustetarkkuuteen. Dataan on sisällytettävä leviämiskäyrän käännöskohta, eli pitkän aikavälin huippukysyntäpiste.

Quantitative market and sales forecast accuracy analysis

The main objective of this master’s thesis was to quantitatively study the reliability of market and sales forecasts of a certain company by measuring bias, precision and accuracy of these forecasts by comparing forecasts against actual values. Secondly, the differences of bias, precision and accuracy between markets were explained by various macroeconomic variables and market characteristics. Accuracy and precision of the forecasts seems to vary significantly depending on the market that is being forecasted, the variable that is being forecasted, the estimation period, the length of the estimated period, the forecast horizon and the granularity of the data. High inflation, low income level and high year-on-year market volatility seems to be related with higher annual market forecast uncertainty and high year-on-year sales volatility with higher sales forecast uncertainty. When quarterly market size is forecasted, correlation between macroeconomic variables and forecast errors reduces. Uncertainty of the sales forecasts cannot be explained with macroeconomic variables. Longer forecasts are more uncertain, shorter estimated period leads to higher uncertainty, and usually more recent market forecasts are less uncertain. Sales forecasts seem to be more uncertain than market forecasts, because they incorporate both market size and market share risks. When lead time is more than one year, forecast risk seems to grow as a function of root forecast horizon. When lead time is less than year, sequential error terms are typically correlated, and therefore forecast errors are trending or mean-reverting. The bias of forecasts seems to change in cycles, and therefore the future forecasts cannot be systematically adjusted with it. The MASE cannot be used to measure whether the forecast can anticipate year-on-year volatility. Instead, we constructed a new relative accuracy measure to cope with this particular situation.

Sales and Operations Planning Implementation

The master’s thesis focused on implementing a sales and operations planning process. The main objectives were to create planning methods and tools for the implementation. The ultimate goal of the process, beyond this master’s thesis, is to balance the supply of products with customer demand, with optimized profitability. The theoretical part focused on giving a thorough view on the sales and operations planning process. The basis for a monthly planning cycle was identified. Methods, tools, and metrics for demand forecasting and operations planning were also introduced. Based on the theoretical part, a method for forecasting, a forecast spreadsheet, and a forecast accuracy metric were designed. A spreadsheet tool and methods were also designed for the monthly planning of production volumes, capacity, and inventory. The implementation progress was reviewed for two product families for three months. The sales and operations planning process was able to successfully identify a demand peak for the product families. Suggestions for the future of sales and operations planning were also made.

Designing a Demand Forecasting Process in the Fast Moving Consumer Goods Context

The purpose of this thesis was to study the design of demand forecasting processes. A literature review in the field of forecasting was conducted, including general forecasting process design, forecasting methods and techniques, the role of human judgment in forecasting and forecasting performance measurement. The purpose of the literature review was to identify the important design choices that an organization aiming to design or re-design their demand forecasting process would have to make. In the empirical part of the study, these choices and the existing knowledge behind them was assessed in a case study where a demand forecasting process was re-designed for a company in the fast moving consumer goods business. The new target process is described, as well as the reasoning behind the design choices made during the re-design process. As a result, the most important design choices are highlighted, as well as their immediate effect on other processes directly tied to the demand forecasting process. Additionally, some new insights on the organizational aspects of demand forecasting processes are explored. The preliminary results indicate that in this case the new process did improve forecasting accuracy, although organizational issues related to the process proved to be more challenging than anticipated.

Demand forecasting process design and methods in medium sized enterprise

The purpose of this thesis was to study the design of demand forecasting processes and management of demand. In literature review were different processes found and forecasting methods and techniques interviewed. Also role of bullwhip effect in supply chain was identified and how to manage it with information sharing operations. In the empirical part of study is at first described current situation and challenges in case company. After that will new way to handle demand introduced with target budget creation and how information sharing with 5 products and a few customers would bring benefits to company. Also the new S&OP process created within this study and organization for it.

Management of Soft Information in Sales and Operations Planning

With a Sales and Operations Planning (S&OP) process, a company aims to manage the demand and supply by planning and forecasting. The studied company uses an integrated S&OP process to improve the company's operations. The aim of this thesis is to develop this business process by finding the best possible way to manage the soft information in S&OP, whilst also understanding the importance and types (assumptions, risks and opportunities) of soft information in S&OP. The soft information in S&OP helps to refine future S&OP planning, taking into account the uncertainties that affect the balance of the long-term demand and supply (typically 12-18 months). The literature review was used to create a framework for soft information management process in S&OP. There were not found a concrete way how to manage soft information in the existing literature. In consequence of the poor literature available the Knowledge Management literature was used as the base for the framework creation, which was seen in the very same type of information management like the soft information management is. The framework created a four-stage process to manage soft information in S&OP that included also the required support systems. First phase is collecting and acquiring soft information in S&OP, which include also categorization. The categorization was the cornerstone to identify different requirements that needs to be taken into consideration when managing soft information in S&OP process. The next phase focus on storing data, which purpose is to ensure the soft information is managed in a common system (support system) in a way that the following phase makes it available to users in S&OP who need by help of sharing and applications process. The last phase target is to use the soft information to understand assumptions and thoughts of users behind the numbers in S&OP plans. With this soft management process the support system will have a key role. The support system, like S&OP tool, ensures that soft information is stored in the right places, kept up-to-date and relevancy. The soft information management process in S&OP strives to improve the relevant soft information documenting behind the S&OP plans into the S&OP support system. The process offers an opportunity to individuals to review, comment and evaluate soft information in S&OP made by their own or others. In the case company it was noticed that without a properly documented and distributed soft information in S&OP it was seen to cause mistrust towards the planning.

A Project Portfolio Tool for Forecasting Small Projects Profitability

The case company in this study is a large industrial engineering company whose business is largely based on delivering a wide-range of engineering projects. The aim of this study is to create and develop a fairly simple Excel-based tool for the sales department. The tool’s main function is to estimate and visualize the profitability of various small projects. The study also aims to find out other possible and more long-term solutions for tackling the problem in the future. The study is highly constructive and descriptive as it focuses on the development task and in the creation of a new operating model. The developed tool focuses on estimating the profitability of the small orders of the selected project portfolio currently on the bidding-phase (prospects) and will help the case company in the monthly reporting of sales figures. The tool will analyse the profitability of a certain project by calculating its fixed and variable costs, then further the gross margin and operating profit. The bidding phase of small project is a phase that has not been covered fully by the existing tools within the case company. The project portfolio tool can be taken into use immediately within the case company and it will provide fairly accurate estimate of the profitability figures of the recently sold small projects.

A Dynamic forecasting model for the Finnish pulp export price

Summary