Forecasting New Product Life Cycle Curves: Practical Approach and Empirical Analysis

Abstract

We present an approach to forecast customer orders of ready-to-launch new products that are similar to past products. The approach fits product life cycle (PLC) curves to historical customer order data, clusters the curves of similar products, and uses the representative curve of the new product’s cluster to generate its forecast. We propose three families of curves to fit the PLC: bass diffusion curves, polynomial curves, and simple piecewise-linear curves (triangles and trapezoids). Using a large data set of customer orders for 4,037,826 units of 170 Dell computer products sold over three and a half years, we compare goodness of fit and complexity for these families of curves. Fourth-order polynomial curves provide the best in-sample fit with piecewise-linear curves a close second. Using a trapezoidal fit, we find that the PLCs in our data have very short maturity stages; more than 20% have no maturity stage and are best fit by a triangle. The fitted PLC curves of similar products are clustered either by known product characteristics or by data-driven clustering. Our key empirical finding is that, for our large data set, data-driven clustering of simple triangles and trapezoids, which are simple to estimate and explain, perform best for forecasting. Our conservative out-of-sample forecast evaluation, using data-driven clustering of triangles and trapezoids, results in mean absolute errors approximately 2%–3% below Dell’s forecasts. We also apply our method to a second data set of a smaller company and find consistent results. The online appendix is available at https://doi.org/10.1287/msom.2017.0691 .

Cross‐item learning for volatile demand forecasting: An intervention with predictive analytics

“…The aggregate approach has proven successful for product demand forecasting in various consumer (Ban et al, 2019;Ren et al, 2017;Spiliotis et al, 2021) and industrial markets (Gonçalves et al, 2021). Hu, Acimovic, Erize, Thomas, and Van Mieghem (2019) show that, even by just clustering items based on similarities, fitting common curves without input features improves demand forecast accuracy. Our results in the electronics distribution sector justify the utility of cross-individual learning for demand forecasting in industrial markets.…”

Demystifying data and AI for manufacturing: case studies from a major computer maker

“…For the future, we would like to investigate ways to tackle the forecast of new commodities that have a smaller number of historical sales data compared to older commodities, such as using data from products with similar sales patterns [18]. Another exciting direction is to forecast the raw materials by using hierarchical constraints [19], where many finished goods may use the same raw materials.…”

Context-Based Dynamic Pricing with Online Clustering

“…Compared with these literature, besides a totally different problem setting, our paper is also different in the approach. First, we consider an online clustering approach with provable performance instead of an offline setting as in Baardman et al (2017), Ban et al (2018), Hu et al (2018), Jagabathula et al (2018. Second, we know neither the number of clusters (in contrast to Baardman et al 2017, Bernstein et al 2018 that assume known number of clusters), nor the set of products in each cluster (as compared with Ban et al 2018 who assume known products in each cluster).…”

“…For instance,Baardman et al (2017) assume a demand function which is a weighted sum of unknown functions (each representing a cluster) of product features. While inBan et al (2018), similar products are predefined such that common demand parameters are estimated using sales data of old products Hu et al (2018). investigate the effectiveness of clustering based on product category, features, or time series of demand respectively.…”