Abstract
Pricing strategy is vital in the retail sector as prices play an important role in driving revenues and profits. However, few studies have been conducted on retail promotion optimization, particularly amid the COVID-19 situation. This study aims to leverage statistical models to examine the effects of price promotion and other factors on sales during the COVID-19 period. In addition, an optimization model is proposed to maximize the profitability of a retail store through strategies for optimal promotional pricing. In this study, monthly sales data in four product categories with 245 stock keeping units from July 2020 to June 2022 from a case study convenience store chain were retrieved and preprocessed. Subsequently, statistical models, such as the autoregressive distributed lag model OWN and the autoregressive distributed lag model CROSS, were implemented to examine the effects of price, promotion and other factors on sales. In addition, factors such as price elasticity and cannibalization were extracted and analyzed from the demand models. An optimization model was built in accordance with the demand model to maximize the total profit of the retailer over a certain period by determining the strategy for optimal promotional pricing. Finally, sensitivity analyses were performed to explain the dynamics of the parameters involved in the optimization model. The methodology, results and insights from this research provide a preliminary framework to facilitate Thai retailers in optimizing their pricing strategies and achieving key business objectives.
Similar content being viewed by others
References
Ailawadi, K.L., K. Gedenk, C. Lutzky, and S.A. Neslin. 2007. Decomposition of the sales impact of promotion-induced stockpiling. Journal of Marketing Research 44 (3): 450–467.
Box, G.E., G.M. Jenkins, G.C. Reinsel, and G.M. Ljung. 2015. Time series analysis: Forecasting and control. Hoboken: Wiley.
Cohen, M.C., N.H.Z. Leung, K. Panchamgam, G. Perakis, and A. Smith. 2017. The impact of linear optimization on promotion. Planning 65 (2): 446–468. https://doi.org/10.1287/OPRE.2016.1573.
DBD DataWarehouse+. (2022). https://datawarehouse.dbd.go.th/business/47113. Accessed 1 Dec 2022.
Euromonitor Beauty and Personal Care in Thailand, Market Research Report. 2022. https://www.euromonitor.com/beauty-and-personal-care-in-thailand/report. Accessed 30 Nov 2022.
Fader, P.S., and B.G.S. Hardie. 2005. The value of simple models in new product forecasting and customer-base analysis. Applied Stochastic Models in Business and Industry. 21 (4–5): 461–473.
Fernandes, N. 2020. Economic effects of coronavirus outbreak (COVID-19) on the World economy. SSRN Electronic Journal. https://doi.org/10.2139/SSRN.3557504.
Greenlaw, Steven A., D. Shapiro, and T. Taylor. 2018. Principles of Economics. Houston: OpenStax.
Hübner, A., H. Kuhn, and S. Kühn. 2016. An efficient algorithm for capacitated assortment planning with stochastic demand and substitution. European Journal of Operational Research 250 (2): 505–520.
Krungsri Research. 2022. https://www.krungsri.com/th/research/industry/industry-outlook/wholesale-retail/moderntrade/io/io-modern-trade-21. Accessed 1 Dec 2022.
Ma, S., and R. Fildes. 2017. A retail store SKU promotions optimization model for category multi-period profit maximization. European Journal of Operational Research 260 (2): 680–692.
Ma, S., R. Fildes, and T. Huang. 2016. Demand forecasting with high dimensional data: The case of SKU retail sales forecasting with intra-and inter-category promotional information. European Journal of Operational Research 249 (1): 245–257.
Mela, C.F., K. Jedidi, and D. Bowman. 1998. The long-term impact of promotions on consumer stockpiling behavior. Journal of Marketing Research 35 (2): 250–262.
Natter, M., T. Reutterer, A. Mild, and A. Taudes. 2007. Practice prize report—An assortment wide decision-support system for dynamic pricing and promotion planning in DIY retailing. Marketing Science 26 (4): 576–583. https://doi.org/10.1287/MKSC.1060.0217.
Pantano, E., G. Pizzi, D. Scarpi, and C. Dennis. 2020. Competing during a pandemic? Retailers’ ups and downs during the COVID-19 outbreak. Journal of Business Research 116: 209–213.
Phumchusri, N., W. Kosawanitchakarn, S. Chawanapranee, and S. Srimook. 2022. Evaluating promotional pricing effectiveness using convenience store daily sales data. Journal of Revenue and Pricing Management. https://doi.org/10.1057/s41272-022-00415-5.
Sun, B. 2005. Promotion effects on endogenous consumption. Marketing Science 24 (3): 430–443.
Tellis, G.J., and F. Zufryden. 1995. Tackling the retailer decision maze: Which brand to discount, how much, when and why? Marketing Science 14 (3): 271–299.
Thailand Board of Investment. 2022. COVID fuels e-commerce. In search of future opportunities. Thailand Board of Investment 4 (1): 1–3.
Tibshirani, R. 1996. Regression shrinkage and selection via the Lasso. Journal of the Royal Statistical Society: Series B (methodological) 58 (1): 267–288.
Tunpaiboon, Narin. 2021. Industry outlook 2021–2023 modern trade. Krungsri Research, https://www.krungsri.com/en/research/industry/industryoutlook/wholesale-retail/moderntrade/io/io-modern-trade-21. Accessed 21 Nov 2022.
Van Heerde, H., P.S.H. Leeflang, and D.R. Wittink. 2004. Decomposing the sales promotion bump with store data. Marketing Science 23 (3): 317–334.
Winters, P.R. 1960. Forecasting sales by exponentially weighted moving averages. Management Science 6 (3): 324–342.
Funding
Data are available upon request.
Author information
Authors and Affiliations
Corresponding author
Additional information
Publisher's Note
Springer Nature remains neutral with regard to jurisdictional claims in published maps and institutional affiliations.
Rights and permissions
Springer Nature or its licensor (e.g. a society or other partner) holds exclusive rights to this article under a publishing agreement with the author(s) or other rightsholder(s); author self-archiving of the accepted manuscript version of this article is solely governed by the terms of such publishing agreement and applicable law.
About this article
Cite this article
Phumchusri, N., Chewcharat, T. & Kanokpongsakorn, S. Price promotion optimization model for multiperiod planning: a case study of beauty category products sold in a convenience store chain. J Revenue Pricing Manag 23, 164–178 (2024). https://doi.org/10.1057/s41272-023-00438-6
Received:
Accepted:
Published:
Issue Date:
DOI: https://doi.org/10.1057/s41272-023-00438-6