IDEAS home Printed from https://ideas.repec.org/a/gam/jmathe/v12y2024i7p1054-d1368059.html
   My bibliography  Save this article

Optimization of Vegetable Restocking and Pricing Strategies for Innovating Supermarket Operations Utilizing a Combination of ARIMA, LSTM, and FP-Growth Algorithms

Author

Listed:
  • Haoyang Ping

    (School of Future Science and Engineering, Soochow University, Suzhou 215299, China)

  • Zhuocheng Li

    (School of Future Science and Engineering, Soochow University, Suzhou 215299, China)

  • Xizhu Shen

    (School of Future Science and Engineering, Soochow University, Suzhou 215299, China)

  • Haizhen Sun

    (School of Mechanical and Electric Engineering, Soochow University, Suzhou 215299, China
    Jiangsu Provincial Key Laboratory of Advanced Robotics, School of Mechanical and Electric Engineering, Soochow University, Suzhou 215123, China)

Abstract

In the dynamic environment of fresh food supermarkets, managing the short shelf life and varying quality of vegetable products presents significant challenges. This study focuses on optimizing restocking and pricing strategies to maximize profits while accommodating the diverse and time-sensitive nature of vegetable sales. We analyze historical sales, pricing data, and loss rates of six vegetable categories in Supermarket A from 1 July 2020 to 30 June 2023. Using advanced data analysis techniques like K-means++ clustering, non-normal distribution assessments, Spearman correlation coefficients, and heat maps, we uncover significant correlations between vegetable categories and their sales patterns. The research further explores the implications of cost-plus pricing, revealing a notable relationship between pricing strategies and sales volumes. By employing Autoregressive Integrated Moving Average (ARIMA) and Long Short-Term Memory (LSTM) models, we forecast sales and determine optimal restocking volumes. Additionally, we use price elasticity theories and a comprehensive model to predict net profit changes, aiming to enhance profit margins by 47%. The study also addresses space constraints in supermarkets by proposing an effective assortment of salable items and individual product restocking plans, based on FP-Growth algorithm analysis and market demand. Our findings offer insightful strategies for sustainable and economic growth in the supermarket industry, demonstrating the impact of data-driven decision-making on operational efficiency and profitability.

Suggested Citation

  • Haoyang Ping & Zhuocheng Li & Xizhu Shen & Haizhen Sun, 2024. "Optimization of Vegetable Restocking and Pricing Strategies for Innovating Supermarket Operations Utilizing a Combination of ARIMA, LSTM, and FP-Growth Algorithms," Mathematics, MDPI, vol. 12(7), pages 1-17, March.
  • Handle: RePEc:gam:jmathe:v:12:y:2024:i:7:p:1054-:d:1368059
    as

    Download full text from publisher

    File URL: https://www.mdpi.com/2227-7390/12/7/1054/pdf
    Download Restriction: no

    File URL: https://www.mdpi.com/2227-7390/12/7/1054/
    Download Restriction: no
    ---><---

    References listed on IDEAS

    as
    1. Aggarwal, A. & Cook, A.J. & Jiao, J. & Seguin, R.A. & Moudon, A.V. & Hurvitz, P.M. & Drewnowski, A., 2014. "Access to supermarkets and fruit and vegetable consumption," American Journal of Public Health, American Public Health Association, vol. 104(5), pages 917-923.
    2. Mark Chiang & Boris Mirkin, 2010. "Intelligent Choice of the Number of Clusters in K-Means Clustering: An Experimental Study with Different Cluster Spreads," Journal of Classification, Springer;The Classification Society, vol. 27(1), pages 3-40, March.
    3. Rabbani, Masoud & Pourmohammad Zia, Nadia & Rafiei, Hamed, 2016. "Joint optimal dynamic pricing and replenishment policies for items with simultaneous quality and physical quantity deterioration," Applied Mathematics and Computation, Elsevier, vol. 287, pages 149-160.
    4. Li Jia & Jing Zhang & Guanghua Qiao, 2022. "Scale and Environmental Impacts of Food Loss and Waste in China—A Material Flow Analysis," IJERPH, MDPI, vol. 20(1), pages 1-21, December.
    5. Tamíris Pacheco da Costa & James Gillespie & Xavier Cama-Moncunill & Shane Ward & Joan Condell & Ramakrishnan Ramanathan & Fionnuala Murphy, 2022. "A Systematic Review of Real-Time Monitoring Technologies and Its Potential Application to Reduce Food Loss and Waste: Key Elements of Food Supply Chains and IoT Technologies," Sustainability, MDPI, vol. 15(1), pages 1-27, December.
    Full references (including those not matched with items on IDEAS)

    Most related items

    These are the items that most often cite the same works as this one and are cited by the same works as this one.
    1. Qi Chen & Qi Xu & Wenjie Wang, 2019. "Optimal Policies for the Pricing and Replenishment of Fashion Apparel considering the Effect of Fashion Level," Complexity, Hindawi, vol. 2019, pages 1-12, February.
    2. Shouxiang Wang & Pengfei Dong & Yingjie Tian, 2017. "A Novel Method of Statistical Line Loss Estimation for Distribution Feeders Based on Feeder Cluster and Modified XGBoost," Energies, MDPI, vol. 10(12), pages 1-17, December.
    3. Pawel Dlotko & Wanling Qiu & Simon Rudkin, 2022. "Topological Data Analysis Ball Mapper for Finance," Papers 2206.03622, arXiv.org.
    4. Buisman, M.E. & Haijema, R. & Bloemhof-Ruwaard, J.M., 2019. "Discounting and dynamic shelf life to reduce fresh food waste at retailers," International Journal of Production Economics, Elsevier, vol. 209(C), pages 274-284.
    5. Antonella Pireddu & Angelico Bedini & Mara Lombardi & Angelo L. C. Ciribini & Davide Berardi, 2024. "A Review of Data Mining Strategies by Data Type, with a Focus on Construction Processes and Health and Safety Management," IJERPH, MDPI, vol. 21(7), pages 1-26, June.
    6. J. Fernando Vera & Rodrigo Macías, 2021. "On the Behaviour of K-Means Clustering of a Dissimilarity Matrix by Means of Full Multidimensional Scaling," Psychometrika, Springer;The Psychometric Society, vol. 86(2), pages 489-513, June.
    7. Catalina Cruz-Piedrahita & Francisco-Javier Martinez-Carranza & Maria Mar Delgado-Serrano, 2024. "A Multidimensional Approach to Understanding Food Deserts in Vulnerable Contexts," Sustainability, MDPI, vol. 16(3), pages 1-19, January.
    8. Rudkin, Simon, 2015. "Supermarket Interventions and Diet in areas of Limited Retail Access: Policy Suggestions from the Seacroft Intervention Study," MPRA Paper 62434, University Library of Munich, Germany.
    9. Pemjean, Isabel & Hernández, Paula & Mediano, Fernanda & Corvalán, Camila, 2024. "How are intra-household dynamics, gender roles and time availability related to food access and children's diet quality during the Covid-19 lockdown?," Social Science & Medicine, Elsevier, vol. 345(C).
    10. Jinrong Liu & Qi Xu, 2020. "Joint Decision on Pricing and Ordering for Omnichannel BOPS Retailers: Considering Online Returns," Sustainability, MDPI, vol. 12(4), pages 1-18, February.
    11. Katarzyna Mazur-Włodarczyk & Agnieszka Gruszecka-Kosowska, 2022. "Conventional or Organic? Motives and Trends in Polish Vegetable Consumption," IJERPH, MDPI, vol. 19(8), pages 1-20, April.
    12. David Frisvold & Joseph Price, 2019. "The Contribution of the School Environment to the Overall Food Environment Experienced by Children," Southern Economic Journal, John Wiley & Sons, vol. 86(1), pages 106-123, July.
    13. Miwa Yamaguchi & Katsuya Takahashi & Masamichi Hanazato & Norimichi Suzuki & Katsunori Kondo & Naoki Kondo, 2019. "Comparison of Objective and Perceived Access to Food Stores Associated with Intake Frequencies of Vegetables/Fruits and Meat/Fish among Community-Dwelling Older Japanese," IJERPH, MDPI, vol. 16(5), pages 1-13, March.
    14. Gregory S. Macfarlane & Emma Stucki & Alisha H. Redelfs & Lori Andersen Spruance, 2022. "Beyond Proximity: Utility-Based Access from Location-Based Services Data," IJERPH, MDPI, vol. 19(19), pages 1-16, September.
    15. Sara Dolnicar & Friedrich Leisch, 2017. "Using segment level stability to select target segments in data-driven market segmentation studies," Marketing Letters, Springer, vol. 28(3), pages 423-436, September.
    16. Muhamad Rizki & Muhammad Zudhy Irawan & Puspita Dirgahayani & Prawira Fajarindra Belgiawan & Retno Wihanesta, 2022. "Low Emission Zone (LEZ) Expansion in Jakarta: Acceptability and Restriction Preference," Sustainability, MDPI, vol. 14(19), pages 1-22, September.
    17. Kristen Cooksey Stowers & Qianxia Jiang & Abiodun T. Atoloye & Sean Lucan & Kim Gans, 2020. "Racial Differences in Perceived Food Swamp and Food Desert Exposure and Disparities in Self-Reported Dietary Habits," IJERPH, MDPI, vol. 17(19), pages 1-14, September.
    18. Aslani, Mehrdad & Faraji, Jamal & Hashemi-Dezaki, Hamed & Ketabi, Abbas, 2022. "A novel clustering-based method for reliability assessment of cyber-physical microgrids considering cyber interdependencies and information transmission errors," Applied Energy, Elsevier, vol. 315(C).
    19. Xiaowei Cai & Richard Volpe & Christiane Schroeter & Lisa Mancino, 2018. "Food retail market structure and produce purchases in the United States," Agribusiness, John Wiley & Sons, Ltd., vol. 34(4), pages 756-770, October.
    20. Yasamin Shaker & Sara E. Grineski & Timothy W. Collins & Aaron B. Flores, 2023. "Redlining, racism and food access in US urban cores," Agriculture and Human Values, Springer;The Agriculture, Food, & Human Values Society (AFHVS), vol. 40(1), pages 101-112, March.

    Corrections

    All material on this site has been provided by the respective publishers and authors. You can help correct errors and omissions. When requesting a correction, please mention this item's handle: RePEc:gam:jmathe:v:12:y:2024:i:7:p:1054-:d:1368059. See general information about how to correct material in RePEc.

    If you have authored this item and are not yet registered with RePEc, we encourage you to do it here. This allows to link your profile to this item. It also allows you to accept potential citations to this item that we are uncertain about.

    If CitEc recognized a bibliographic reference but did not link an item in RePEc to it, you can help with this form .

    If you know of missing items citing this one, you can help us creating those links by adding the relevant references in the same way as above, for each refering item. If you are a registered author of this item, you may also want to check the "citations" tab in your RePEc Author Service profile, as there may be some citations waiting for confirmation.

    For technical questions regarding this item, or to correct its authors, title, abstract, bibliographic or download information, contact: MDPI Indexing Manager (email available below). General contact details of provider: https://www.mdpi.com .

    Please note that corrections may take a couple of weeks to filter through the various RePEc services.

    IDEAS is a RePEc service. RePEc uses bibliographic data supplied by the respective publishers.