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

Commodity Pricing and Replenishment Decision Strategy Based on the Seasonal ARIMA Model

Author

Listed:
  • Jiaying Liu

    (School of Physics and Optoelectronics, Xiangtan University, Xiangtan 411105, China)

  • Bin Liu

    (School of Physics and Optoelectronics, Xiangtan University, Xiangtan 411105, China)

Abstract

As a crucial component of enterprise marketing strategy, commodity pricing and replenishment strategies often play a pivotal role in determining the profit of retailers. In pursuit of profit maximization, this work delved into the realm of fresh food supermarket commodity pricing and replenishment strategies. We classified commodities into six distinct categories and proceeded to examine the relationship between the total quantity sold in these categories and cost-plus pricing through Pearson correlation analysis. Furthermore, a Seasonal ARIMA model was established for the prediction of replenishment quantities and pricing strategies for each of the categories over a seven-day period. To ensure precise data, we extended our forecasting to individual products for a single day, employing 0–1 integer programming. To align the inquiry with real-world scenarios, we took into account various factors, including refunds, waste, discounts, and the requirement that individual products fall within specific selling ranges. The results show that the profit will be maximized when the replenishment of chili is 39.874 kg and the replenishment of edible mushrooms is 43.257 kg in the future week. We assume that the residual of the model is white noise. By testing the white noise of the model, the analysis of the residual Q statistic results shows that it is not significant in level, which can prove that the model meets the requirements and the obtained results are reliable. This research provides valuable insights into the realm of commodity pricing and replenishment strategy, offering practical guidance for implementation.

Suggested Citation

  • Jiaying Liu & Bin Liu, 2023. "Commodity Pricing and Replenishment Decision Strategy Based on the Seasonal ARIMA Model," Mathematics, MDPI, vol. 11(24), pages 1-14, December.
    • Handle: RePEc:gam:jmathe:v:11:y:2023:i:24:p:4921-:d:1297862
    as

    Download full text from publisher

    File URL: https://www.mdpi.com/2227-7390/11/24/4921/pdf
    Download Restriction: no
    File URL: https://www.mdpi.com/2227-7390/11/24/4921/
    Download Restriction: no
    ---><---

    References listed on IDEAS

    as
    1. Lina Guo, 2022. "Cross-border e-commerce platform for commodity automatic pricing model based on deep learning," Electronic Commerce Research, Springer, vol. 22(1), pages 1-20, March.
    2. Yossi Aviv & Amit Pazgal, 2008. "Optimal Pricing of Seasonal Products in the Presence of Forward-Looking Consumers," Manufacturing & Service Operations Management, INFORMS, vol. 10(3), pages 339-359, December.
    3. Shuai Zhao & Wenli Li, 2023. "Blockchain-based traceability system adoption decision in the dual-channel perishable goods market under different pricing policies," International Journal of Production Research, Taylor & Francis Journals, vol. 61(13), pages 4548-4574, July.
    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. Vincent Mak & Amnon Rapoport & Eyran J. Gisches & Jiaojie Han, 2014. "Purchasing Scarce Products Under Dynamic Pricing: An Experimental Investigation," Manufacturing & Service Operations Management, INFORMS, vol. 16(3), pages 425-438, July.
    2. Qingyuan Zhu & Chenghao Yu & Zhiyang SHEN & Malin Song, 2023. "Competition between a manufacturer and a relicensing third party when customers are strategic," Managerial and Decision Economics, John Wiley & Sons, Ltd., vol. 44(4), pages 2021-2040, June.
    3. Namin, Aidin & Soysal, Gonca P. & Ratchford, Brian T., 2022. "Alleviating demand uncertainty for seasonal goods: An analysis of attribute-based markdown policy for fashion retailers," Journal of Business Research, Elsevier, vol. 145(C), pages 671-681.
    4. Yiwei Chen & Nikolaos Trichakis, 2021. "Technical Note—On Revenue Management with Strategic Customers Choosing When and What to Buy," Operations Research, INFORMS, vol. 69(1), pages 175-187, January.
    5. Adam J. Mersereau & Dan Zhang, 2012. "Markdown Pricing with Unknown Fraction of Strategic Customers," Manufacturing & Service Operations Management, INFORMS, vol. 14(3), pages 355-370, July.
    6. Lingxiu Dong & Panos Kouvelis & Zhongjun Tian, 2009. "Dynamic Pricing and Inventory Control of Substitute Products," Manufacturing & Service Operations Management, INFORMS, vol. 11(2), pages 317-339, December.
    7. Gonca P. Soysal & Lakshman Krishnamurthi, 2012. "Demand Dynamics in the Seasonal Goods Industry: An Empirical Analysis," Marketing Science, INFORMS, vol. 31(2), pages 293-316, March.
    8. Hao, Zhaowei & Qi, Wei & Gong, Tianxiao & Chen, Lihua & Shen, Zuo-Jun Max, 2019. "Innovation uncertainty, new product press timing and strategic consumers," Omega, Elsevier, vol. 89(C), pages 122-135.
    9. Selcuk, Cemil & Gokpinar, Bilal, 2017. "Fixed vs. Flexible Pricing in a Competitive Market," Cardiff Economics Working Papers E2017/9, Cardiff University, Cardiff Business School, Economics Section.
    10. J. B. G. Frenk & Canan Pehlivan & Semih O. Sezer, 2019. "Order and exit decisions under non-increasing price curves for products with short life cycles," Mathematical Methods of Operations Research, Springer;Gesellschaft für Operations Research (GOR);Nederlands Genootschap voor Besliskunde (NGB), vol. 90(3), pages 365-397, December.
    11. Alex Gershkov & Benny Moldovanu, 2009. "Dynamic Revenue Maximization with Heterogeneous Objects: A Mechanism Design Approach," American Economic Journal: Microeconomics, American Economic Association, vol. 1(2), pages 168-198, August.
    12. Christian Borgs & Ozan Candogan & Jennifer Chayes & Ilan Lobel & Hamid Nazerzadeh, 2014. "Optimal Multiperiod Pricing with Service Guarantees," Management Science, INFORMS, vol. 60(7), pages 1792-1811, July.
    13. Jun Li & Nelson Granados & Serguei Netessine, 2014. "Are Consumers Strategic? Structural Estimation from the Air-Travel Industry," Management Science, INFORMS, vol. 60(9), pages 2114-2137, September.
    14. Narayan Mishra & Sri Vanamalla Venkataraman, 2022. "Optimal order quantity in the presence of strategic customers," Annals of Operations Research, Springer, vol. 315(2), pages 1871-1894, August.
    15. Rui Zheng & Biying Shou & Yingju Chen, 2023. "Differential pricing in social networks with strategic consumers," Production and Operations Management, Production and Operations Management Society, vol. 32(8), pages 2638-2655, August.
    16. Chen Tian & Tiaojun Xiao, 2017. "Profit of a Supply Chain versus its Decentralization in the Presence of Strategic Customers," International Journal of Information Technology & Decision Making (IJITDM), World Scientific Publishing Co. Pte. Ltd., vol. 16(06), pages 1647-1670, November.
    17. Simon Board & Andrzej Skrzypacz, 2016. "Revenue Management with Forward-Looking Buyers," Journal of Political Economy, University of Chicago Press, vol. 124(4), pages 1046-1087.
    18. Dong, Junfeng & Wu, Desheng Dash, 2019. "Two-period pricing and quick response with strategic customers," International Journal of Production Economics, Elsevier, vol. 215(C), pages 165-173.
    19. Chenxu Ke & Bo Yan & Ruofan Xu, 2017. "A group-buying mechanism for considering strategic consumer behavior," Electronic Commerce Research, Springer, vol. 17(4), pages 721-752, December.
    20. Li Li & Li Jiang, 2022. "How should firms adapt pricing strategies when consumers are time‐inconsistent?," Production and Operations Management, Production and Operations Management Society, vol. 31(9), pages 3457-3473, September.

    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:11:y:2023:i:24:p:4921-:d:1297862. 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.