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. 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.
    3. 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.
    4. 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.
    5. 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.
    6. 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.
    7. 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.
    8. 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.
    9. 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.
    10. 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.
    11. 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.
    12. Rini & Priyamvada & Chandra K. Jaggi, 2021. "Sustainable and flexible production system for a deteriorating item with quality consideration," International Journal of System Assurance Engineering and Management, Springer;The Society for Reliability, Engineering Quality and Operations Management (SREQOM),India, and Division of Operation and Maintenance, Lulea University of Technology, Sweden, vol. 12(5), pages 951-960, October.
    13. Taiyang Zhong & Zhenzhong Si & Jonathan Crush & Zhiying Xu & Xianjin Huang & Steffanie Scott & Shuangshuang Tang & Xiang Zhang, 2018. "The Impact of Proximity to Wet Markets and Supermarkets on Household Dietary Diversity in Nanjing City, China," Sustainability, MDPI, vol. 10(5), pages 1-18, May.
    14. Jwaher Haji Alhaji & Ghareeb O. Alshuwaier & Nouf Sahal Alharbi & Abdulrahman I. Alaqil & Nora Majed BinSultan & Wadi B. Alonazi, 2021. "Translation and Validation of the Arabic Version of the Capability Assessment for Diet and Activity (CADA) Questionnaire in Saudi University Employed Women," IJERPH, MDPI, vol. 18(12), pages 1-9, June.
    15. Kim, Gwang & Moon, Ilkyeong, 2021. "Integrated planning for product selection, shelf-space allocation, and replenishment decision with elasticity and positioning effects," Journal of Retailing and Consumer Services, Elsevier, vol. 58(C).
    16. Everitt, Haley & van der Werf, Paul & Seabrook, Jamie A. & Wray, Alexander & Gilliland, Jason A., 2022. "The quantity and composition of household food waste during the COVID-19 pandemic: A direct measurement study in Canada," Socio-Economic Planning Sciences, Elsevier, vol. 82(PA).
    17. Jaehong Yu & Hua Zhong & Seoung Bum Kim, 2020. "An Ensemble Feature Ranking Algorithm for Clustering Analysis," Journal of Classification, Springer;The Classification Society, vol. 37(2), pages 462-489, July.
    18. Zhao, Yan & Li, Yanhui & Yao, Qi & Guan, Xu, 2023. "Dual-channel retailing strategy vs. omni-channel buy-online-and-pick-up-in-store behaviors with reference freshness effect," International Journal of Production Economics, Elsevier, vol. 263(C).
    19. Cui, Ligang & Deng, Jie & Liu, Rui & Xu, Dongyang & Zhang, Yajun & Xu, Maozeng, 2020. "A stochastic multi-item replenishment and delivery problem with lead-time reduction initiatives and the solving methodologies," Applied Mathematics and Computation, Elsevier, vol. 374(C).
    20. Dogan Gursoy & Anna Maria Parroco & Raffaele Scuderi, 2013. "An Examination of Tourist Arrivals Dynamics Using Short-Term Time Series Data: A Space—Time Cluster Approach," Tourism Economics, , vol. 19(4), pages 761-777, August.

    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.