Affiliation:
1. School of Sciences, RMIT University, Melbourne 3000, Australia
2. Rutgers Business School, Rutgers University, Newark, NJ 07102, USA
Abstract
Determining the optimal price of products is essential, as it plays a critical role in improving a company’s profitability and market competitiveness. This requires the ability to calculate customers’ demand in the Fast Moving Consumer Goods (FMCG) industry as various effects exist between multiple products within a product category. The substitution effect is one of the challenging effects at retail stores, as it requires investigating an exponential number of combinations of price changes and the availability of other products. This paper suggests a systematic price decision support tool for demand prediction and price optimise in online and stationary retailers considering the substitution effect. Two procedures reflecting the product price changes and the demand correlation structure are introduced for demand prediction and price optimisation models. First, the developed demand prediction procedure is carried out considering the combination of price changes of all products reflecting the effect of substitution. Time series and different well-known machine learning approaches with hyperparameter tuning and rolling forecasting methods are utilised to select each product’s best demand forecast. Demand forecast results are used as input in the price optimisation model. Second, the developed price optimisation procedure is a constraint programming problem based on a week time frame and a product category level aggregation and is capable of maximising profit out of the many price combinations. The results using real-world transaction data with 12 products and 4 discount rates demonstrate that including some business rules as constraints in the proposed price optimisation model reduces the number of price combinations from 11,274,924 to 19,440 and execution time from 129.59 to 25.831 min. The utilisation of the presented price optimisation support tool enables the supply chain managers to identify the optimal discount rate for individual products in a timely manner, resulting in a net profit increase.
Subject
General Mathematics,Engineering (miscellaneous),Computer Science (miscellaneous)
Reference50 articles.
1. Nagle, T.T., and Müller, G. (2018). The Strategy and Tactics of Pricing: A Guide to Growing More Profitably, Routledge. [6th ed.].
2. Cressman, G.E. (2012). Handbook of Business-to-Business Marketing, Edward Elgar Publishing.
3. The Impact of Linear Optimization on Promotion Planning;Cohen;Oper. Res.,2017
4. Talluri, K.T., and Van Ryzin, G. (2004). The Theory and Practice of Revenue Management, Kluwer Academic Publishers. [1st ed.].
5. Analytics for an Online Retailer: Demand Forecasting and Price Optimization;Ferreira;Manuf. Serv. Oper. Manag.,2016
Cited by
3 articles.
订阅此论文施引文献
订阅此论文施引文献,注册后可以免费订阅5篇论文的施引文献,订阅后可以查看论文全部施引文献