Predicting the Right Drinking Water Purchase for Inventory Case Study Store

Authors

  • Nattaporn Tungcharoenchai Logistics and Management Engineering Technology, Faculty of Industrial Technology, Pibulsongkram Rajabhat University
  • Jeerawat Sawetbunyasit Logistics and Management Engineering Technology, Faculty of Industrial Technology, Pibulsongkram Rajabhat University
  • Samawee Muksuwan Logistics and Management Engineering Technology, Faculty of Industrial Technology, Pibulsongkram Rajabhat University
  • Samawee Muksuwan Logistics and Management Engineering Technology, Faculty of Industrial Technology, Pibulsongkram Rajabhat University

Keywords:

Forecasting, Drinking Water, Inventory

Abstract

The purpose of this research is to compare methods for forecasting demand for purchasing appropriate drinking water products. of store case studies Located in Mueang Subdistrict, Mueang District, Phitsanulok Province. The results of the research found that 350 mL of drinking water is suitable for estimating the demand for drinking water using the exponential forecasting method. This is because louder methods provide the lowest tolerances. When compared to actual sales, the accuracy percentage is 95.20. 600 ml. drinking water and 1,500 ml. drinking water was appropriate to determine the demand for drinking water using the regression forecasting method. This is because louder methods provide the lowest tolerances. When compared with actual sales, the percentage accuracy was 99.60 and 99.11, respectively. The results from comparing inventory management costs found that the new inventory management resulted in reduced costs. This can reduce the amount of inventory management costs for 350 ml. of drinking water. Inventory management costs can be reduced by 1,244.17 baht or 23.96 percent. For 600 ml. drinking water, inventory management costs can be reduced by 15,028.13 baht. calculated as 34.82 percent and 1,500 ml of drinking water can reduce inventory management costs by 6,542.51 baht, calculated as 30.68 percent. From the above information, it can reduce inventory management costs in total by 22,814.81 baht, calculated as 32.75 percent.

References

S. Nimrat, A. Jitaree, and V. Vuthiphandchai, "Physical, Chemical and Microbiological Quality of Opaque-Plastic Bottled Drinking Water Distributed in Chon Buri Province Thailand," Journal of Applied Research on Science and Technology (JARST), vol. 20, no. 2, pp. 102-113, Apr. - Jun., 2020.

J. Urupongsanon, "Factors Affecting the Decision on Purchasing Bottled Drinking Water of Consumers in Minburi District, Bangkok," Journal of Administration and Social Science Review, vol. 4, no. 3, pp. 31-44, Sep. - Oct., 2021.

Krungsri Bank, "Industry Outlook 2022-2024: Beverage Industry," [Online]. Available: https://www.krungsri.com/th/ research/industry/industry-outlook/ Food-Beverage/Beverage/IO/io-beverage- 2022. Accessed on Mar. 17, 2023.

V. Limlawan, S. Jangruxsakul, and K. Wiwattanakornwong, "Comparison of Forecasting Technique for Improving the Accuracy of Sale Forecast: A Case Study of Plastic Bottle Manufacturing In Thailand," Journal of Suthiparithat, vol. 36, no. 2, pp. 18-34, Apr. - Jun., 2022.

C. Kuisrikul, S. Saengpetch, and J. Hirunlabh, "Development of Inventory Management Process for Retail Store," Journal of Energy and Environment Technology, vol. 6, no. 1, pp. 1-14, Jan. - Jun., 2019.

T. Rattanakool, K. Sukkrajang, W. Sangchay, and T. Chaichuchok, "Forecasting Modeling of Motorbike Spare Parts Sales A Case Study: Retailer XYZ with Exponential Smoothing Method," Journal of Thepsatri Academic I-TECH, vol. 14, no. 1, pp. 1-9, Jan. - Jun., 2019.

M. Siangwong, S. Phetlai, N. Phookpanich, and D. Thavorn, "Inventory management improvement: A case study Don-Zak construction materials shop," Journal of Interdisciplinary Journal, vol. 19, no. 1, pp. 50-82, Jan. - Jun., 2019.

P. Lalitaporn, Bangkok: Promotion Association Technology (Thai-Japan), 1998.

Busaba, Plant Species. Bangkok: Top Publishing Company Limited, 2009.

C. Singmuang and T. Supapakorn, "Forecasting Model for the Export Value of Rubber of Thailand," Journal of Science and Technology Nakhon Sawan Rajabhat University, vol. 15, no. 21, pp. 58-82, Jan. - Jun., 2020.

R. Tangphukhiew and N. Issarapong, "Analysis of Comparing Forecasting Methods for Production Planning: Case Study of Beef Companies, Nakhon Phanom Province," Journal of Eau Heritage Science and Technology, vol. 13, no. 3, pp. 222-232, Jul. - Sep., 2019.

P. Kittitulakanon, "Forecasting Demand for Chemical Fertilizer: A Case Study of Ta Bong Chum Agricultural Cooperative, Nakhon Sawan Province," Journal of Rajamangala University of Technology Lanna (Technology Innovation), vol. 10, no. 1, pp. 89-100, Jan. - Apr., 2017.

C. KuisriKul, N. Punthanakoraphat, and W. Jariyatontivait, "Forecasting Ordering Purchase for Traditional Trade Case Study AAA Shop," Journal of Advanced Science, vol. 18, no. 2, pp. 26-34, Jul. - Dec., 2018.

W. Khangphukhieo, P. Busababadhin, and B. Kumphon, "Forecasting Volatility of Gold Price with Artificial Neural Networks," Journal of Borapha Science, vol. 22, no. 1, pp. 125-134, Jan. - Apr., 2017.

T. Youcharoen and T. Wasusri, "The Development of Pharmaceuticals and Medical Supplies Inventory Replenishment System: A Case Study of Community Hospital," Journal of Youcharoen T. et al., vol. 14, no. 3, pp. 92-106, Jul. - Sep., 2018.

M. Kasakit, N. Lokkhananurak, and K. Hengpraphrom, "An Efficiency Comparison of Forecasting Techniques for Oil Price Data with Data Mining Techniques," Conference of the 11th NPRU National Academic Conference, vol. 11, pp. 334-340, 11 - 12 Jul., 2019.

K. Wiwattanakornwong, S. Butrsai, C. Vannangkura, and K. Ngamdee, "Demand Forecasting in Beverage Industry: A Case Study of Business Simulation Game," Journal of Suthiparithat, vol. 37, no. 1, pp. 17-31, Jan. - Mar., 2023.

A. Thooltham, N. Techabunmas, and K. Pinsamran, "Demand Forecasting for Raw Materials in the Biscuit Industry," Journal of Science and Technology Thonburi University, vol. 5, no. 2, pp. 30-38, Jan. - Jun., 2021.

S. Rit-im and O. Sangsawang, "Inventory Control Policy by Using the Blanket Purchase Orders: Case Study," Journal of Industrial Technology, vol. 9, no. 3, pp. 105-117, Sep. - Dec., 2013.

P. Phansangwan, N. Suthikarnnarunai, and S. Janpong, "Inventory Management Efficiency Improvement: A Case Study of Retail Company," Journal of Nakhonratchasima College (Humanities and Social Sciences), vol. 15, pp. 391-405, Sep. - Dec., 2021.

Downloads

Published

2023-12-27

How to Cite

Tungcharoenchai, N. ., Sawetbunyasit, J. ., Muksuwan, S. ., & Muksuwan, S. . (2023). Predicting the Right Drinking Water Purchase for Inventory Case Study Store. Journal of Industrial Technology : Suan Sunandha Rajabhat University, 11(2), 39–51. retrieved from https://ph01.tci-thaijo.org/index.php/fit-ssru/article/view/253625

Issue

Section

Research Articles