Raw Material Purchasing Lead Time Reduction for Reducing Inventory Carrying Cost
DOI: 10.14416/j.ind.tech.2021.03.001
Keywords:
Purchasing lead time, Inventory, ECRS, Microsoft power BIAbstract
The case study company was impacted by often late receive raw materials, especially imported raw materials that has long and high variability purchasing lead time. The company had decided to increase safety stock level to prevent a raw material shortage, which caused high raw material holding cost and storage area. After researched, found the most variable part is the company's internal approval process. The approval process affected 82.4% late behind the standard procedure. The main reason is complicated working steps, lack of information sharing and linkage between departments. Therefore, ECRS and management information systems; i.e. Microsoft power BI program were applied to simplify working activities and share important information for reducing purchasing lead time. As a result, the purchasing lead time of raw materials was decreased by 7.04 days from the original lead time of 95.35 days, the raw materials storage area was decreased by 34.8 m2 from 136 m2, and carrying cost was decreased by 3.4 million baht from 11.5 million baht.
References
[2] R. Kanjanapanyakom, Industrial work study, Top Publishing Co.,Ltd, Bangkok, 2009. (in Thai)
[3] L. Nantajinda, Application of ECRS with milk run transport company: A case study of the ABC transport company, Master Thesis, Burapa University, 2016. (in Thai)
[4] https://powerbi.microsoft.com/en-us/. (Accessed on 8 March 2020)
[5] H. Wangchoei and N. Nanthajirapong, Management information system for hotel operation reports with Power BI, Huachiew Chalermprakiet Science and Technology Journal, 2018, 4(1), 69-86. (in Thai)
[6] P. Tiangsombun, Business intelligence system to support executive forecasting and decision making; Case study: Healthcare, Master Thesis, Sripatum University, 2018. (in Thai)
[7] P. Lalitaphon, Inventory management, Technology Promotion Association (Thailand-Japan) Press, Bangkok, 2009. (in Thai)
[8] A. Lerdchayantee, Statistical for research, Silsanong Press, Bangkok, 1996. (in Thai)
[9] S. Jantaravinid, Statistics for educational research, Silpakorn University Press, Nakhon Pathom, 2013. (in Thai)
[10] W. Lorjirachunkul, Theory of Inventory, National Institute of Development Administration, National Institute of Development Administration (NIDA) Press, Bangkok, 1996. (in Thai)
[11] https://inventorymanagementmetrics.blogspot.com/2011/12/reorder-point.html. (Accessed on 20 April 2020)
[12] I. Boonyuen, Adsorption of lignin and tannin by wasted activated carbon used as ballasting agent from activated sludge process, Master Thesis, Chulalongkorn University, Thailand. 2009. (in Thai)
