S uppliers of consumer packaged goods are facing an increasingly challenging situation as they work to fulfill orders from their retail partners' distribution facilities. Traditionally these suppliers have generated forecasts of a given retailer's orders using records of that retailer's past orders. However, it is becoming increasingly common for retail firms to collect and share large volumes of point-of-sale (POS) data, thus presenting an alternative data signal for suppliers to use in generating forecasts. A question then arises as to which data produce the most accurate forecasts. Compounding this question is the fact that forecasters often temporally aggregate data for consolidation or to produce forecasts in larger time buckets. Extant literature prescribes two countervailing statistical effects, information loss and variance reduction, that could play significant roles in determining the impact of temporal aggregation on forecast accuracy. Utilizing a large set of paired order and POS data, this study examines these relationships.Keywords: retail; forecasting; temporal aggregation; S&OP
INTRODUCTIONDemand planning is increasingly recognized as fundamental to efficient supply chain operations and overall firm profitability. This is particularly true for manufacturers of consumer packaged goods (CPG) in retail supply chains. CPG manufacturers are faced with the challenge of forecasting how much inventory their retailer customers will order. Since most large retailers maintain a network of distribution centers (DCs) to fulfill stores, and those DCs place orders directly to suppliers, "it is the orders placed by the retail DC (DC orders) which suppliers find difficult to forecast accurately" (Williams and Waller 2010, 231). This is because the variance of DC orders is typically much more erratic than that of consumer demand (Lee et al. 1997).To assist with this task, many retailers now share end sales, or point-of-sale (POS) data, with suppliers, so that suppliers have access to a less variable demand signal than order history from which to generate their order forecasts (Williams and Waller 2010). Suppliers without access to POS data, or the necessary capabilities to effectively utilize POS data, frequently employ other variance reduction strategies in their demand planning processes, such as cross-sectional (e.g., geographic locations, products) demand aggregation. This results in a smoother customer demand signal, and therefore, potentially more accurate demand forecasts (Williams and Waller 2011).Recently, the notion of temporal aggregation as a variance reduction strategy for forecasting has emerged in the supply chain management (SCM) literature (Rostami-Tabar et al. 2013). Temporal aggregation refers to the aggregation of higher frequency demand data (e.g., weekly) to lower frequency data (e.g., monthly). Intuitively, it seems that the lower frequency data will reduce demand variance and subsequently lead to lower forecast error. However, in this research, we contend that this intuition may be based on ...