Using the Grouping and Shrinkage Approaches to Forecasting Subaggregate Level Seasonal Demand

Lead Research Organisation: University of Salford
Department Name: Unlisted

Abstract

Forecasts are needed at different levels. At the SKU level, short-term demand forecasts for each item are needed as a part of production and inventory systems. In most situations, demand is stochastic and that is when accurate demand forecasting is crucial. Forecasts and forecasting errors are used as inputs to various inventory control systems to either attain a target service-level at minimum cost or to minimise overall costs including components such as stock holding costs, stock out costs and transportation costs. These forecasts can also provide useful information for aggregate-level forecasting and planning, and impact marketing and financial plans of the organisations.Seasonality is a pertinent issue at the SKU level. Traditionally, seasonality is estimated from an item's own data history. This approach is not always satisfactory if the data is noisy and the length of data history is short. Two alternatives have been proposed in the literature: grouping and shrinkage. Previous research indicated that the grouping and shrinkage approaches are promising in terms of improving forecasting accuracy. In research conducted with John Boylan we developed theoretical rules to choose the best method from the individual approach and the grouping approach. However, a very important issue is yet to be addressed: how to put items into seasonally homogenous groups. Previous researchers either relied on company definition or statistical clustering. These methods are reasonable but are not optimal. Miller and Williams (2003) compared the individual approach with two shrinkage methods. They also established a set of rules to choose the best out of the three. We compared the two sets of rules empirically and found they were competitive to each other. A further step would be to combine the strengths of the two approaches to achieve more improvements.Although a very important research area, this is still generally under researched due to its complexity. This proposed research aims to narrow the gap by developing theoretically coherent and applicable rules to combine the individual, grouping and shrinkage approaches. The need for such a research project can be justified from both an academic and practitioner perspective.In this research, we aim to establish a grouping mechanism to divide series into seasonally homogeneous groups, develop a theortical rule to compare the individual, grouping and shrinkage approaches together, and to analyse the implication of forecasting improvement on stock control.Our methodology is deductive in the sense that universally applicable rules are sought to be developed. However, due to the complex nature of the problem under investigation, the research strategy cannot be purely deductive. Established theory is to be applied to both theoretically generated and empirical data with the objective of identifying issues that will be subsequently incorporated and reflected back to the theory. This will go through several loops before the final conclusions/recommendations will be reached. In these respects, the research strategy can be best characterised as semi-deductive or a very well-framed simulation-intensive exploratory investigation.This research problem is complex by nature. However, a good theoretical understanding, linked with fully operational rules will have a significant academic contribution and commercial benefit. Two companies have agreed to collaborate on this project by providing data and relevant information. We expect to see such solutions improve forecasting accuracy. We also strive to examine the implications on inventory control policies, as in reality forecasting and inventory control are well interacted. Therefore, for both forecasting and inventory control purposes, this is a timely and novel project.

Publications

10 25 50
publication icon
Boylan J (2017) Formation of seasonal groups and application of seasonal indices in Journal of the Operational Research Society

publication icon
Boylan J (2015) Reproducibility in forecasting research in International Journal of Forecasting

publication icon
Zied Babai M (2014) Intermittent demand forecasting: An empirical study on accuracy and the risk of obsolescence in International Journal of Production Economics

 
Description Forecasting seasonal demand at an individual product level is an extremely important task in Operations and Production Management. Forecasting such demands is very difficult when demand histories are short or when the data is very noisy. We have found that utilising infornation at an aggregate product group level for the purpose of forecasting at the individual level accounts for considerable benefits in forecast accuracy. We have also suggested how to form the product groups in the first place.
Exploitation Route By amending current specialised software packages (or the relevant modules of more generic ERP and supply chain software) and in house developed solutions in demand forecasting. Companies can follow our methodology in order to form homogeneous seasonal groups (unless such groupings are already available) and then estimate seasonal indices at the group level (which is something feasible even in the absence of much data and / or in the presence of extreme variability) which can be applied at the individual product level.
Sectors Digital/Communication/Information Technologies (including Software),Electronics,Manufacturing, including Industrial Biotechology,Retail

 
Description Our findings have been picked up by forecasting software manufacturers; we know that because of discussions we have had with them through various conferences. We are still not sure though about the extent to which our work has been hard coded in the forecasting software offered by these companies.
Sector Digital/Communication/Information Technologies (including Software),Manufacturing, including Industrial Biotechology
Impact Types Economic