New-Product Demand Forecasting for Long-Lived Products

45 Pages Posted: 1 Aug 2022

See all articles by Shanshan Huang

Shanshan Huang

National University of Singapore (NUS) - Institute of Operations Research and Analytics

Andrew Lim

National University of Singapore (NUS) - Department of Decision Sciences; National University of Singapore (NUS) - Department of Finance; National University of Singapore (NUS) - Institute for Operations Research and Analytics

Date Written: July 13, 2022

Abstract

We consider the problem of demand forecasting for long-lived products when a new product is introduced. This problem is challenging in part because sales data is limited or non-existant for the new product. In addition, a new product can change the demand for the existing products through cannibalization, so forecasts for existing products also need to be adjusted to take this into account. We propose a joint forecasting model for the demand of the new and existing products that combines a linear model, and a choice model over clusters of similar products. Clustering reduces the dimension of the choice model, which makes it easier to calibrate, and allows us to estimate cannibalization by the new product by quantifying the impact on demand when similar products were introduced in the past. Market shares are further adjusted by the linear model to account for potentially time-varying factors and product-level features that are lost in the clustering. The resulting model is easy to calibrate using an extension of the method by Theil (1969). In
out-of-sample tests using data from The Body Shop, methods like linear regression and random forest, which do not explicitly account for cannibalization, overestimate demand for existing products when a new product is introduced, while our proposed model is able to eliminate this bias.

Keywords: demand forecasting, new products, limited data, cannibalization

Suggested Citation

Huang, Shanshan and Lim, Andrew E. B., New-Product Demand Forecasting for Long-Lived Products (July 13, 2022). Available at SSRN: https://ssrn.com/abstract=4161405 or http://dx.doi.org/10.2139/ssrn.4161405

Shanshan Huang (Contact Author)

National University of Singapore (NUS) - Institute of Operations Research and Analytics ( email )

Innovation 4.0, #04-01, 3 Research Link
117602
Singapore

Andrew E. B. Lim

National University of Singapore (NUS) - Department of Decision Sciences ( email )

NUS Business School
Mochtar Riady Building, 15 Kent Ridge
Singapore, 119245
Singapore

National University of Singapore (NUS) - Department of Finance ( email )

Mochtar Riady Building
15 Kent Ridge Drive
Singapore, 119245
Singapore

National University of Singapore (NUS) - Institute for Operations Research and Analytics ( email )

Singapore

Do you have a job opening that you would like to promote on SSRN?

Paper statistics

Downloads
267
Abstract Views
849
Rank
244,131
PlumX Metrics