Increasing Efficiency in Data Management Processes: A Case Study of Insecticide Company
Article Sidebar
Main Article Content
Abstract
Data is importance in running business nowadays. One of the convenient types of storing data is keeping it in spreadsheet. However, if there are large amount of data, a manager still takes a large amount of time to manage it. The aim of this research is to study how to increase efficiency in data management process of a case study of insecticide company. In other words, its purpose is to reduce the time that is considered as non-value added time. At present, a case study company uses Microsoft Excel as a database in storing the data and searching for a data by manual method. This results in large amount of searching time. This study, therefore, applies Vlookup and Filter function in Microsoft Excel to search for a data such as transaction time to match with ordering code. The result shows that the manual method takes 44.5 minutes. However, Vlookup method uses only 7 minutes or the reduction time is 37.50 minutes and Filter method takes 6 minutes or the reduction time is 38.50 minutes which can be considered as a reduction time 84.27% and 86.52%, respectively.
Article Details
This work is licensed under a Creative Commons Attribution-NonCommercial-NoDerivatives 4.0 International License.
Articles published in Journal of Industrial Technology Ubon Ratchathani Rajabhat University both hard copy and electronically are belonged to the Journal.
References
Kittisak Kerdprasop. An automated approach to pre-data mining. Institute of Research and Development: Suraneree of University of Technology; 2009. (in Thai)
Sirikanjana Pilabutr. Database trigger creation with data mining. Master Thesis of Engineering; Suranaree University of Technology; 2008. (in Thai)
Suwanna Ponpakdee. The Application of Lean Thinking ang Supply Chain Management: A Case Study of Concentrated Latex Factory. Master Thesis of Engineering; Prince of Songkla University. 2014. (in Thai)
Patchana Hengboriboonpong Jaidee. Lean Management System: Concept and Practice in Public Health for community Engagement. The Public Health Journal of Burapha University. 2017; 12(2): 133-43. (in Thai)
Jantana W, Sapsanguanboon W. Productivity Improvement in Ceramic Production Process: A Case Study of Factory in Samut Prakan Province. Songklanakarin Journal of Management Sciences. 2020; 37(2): 58-83. (in Thai)
Attaporn Ketcare. Bank Service Improvement Using Lean Techniques. Master Thesis of Engineering; Chiang Mai University. 2012. (in Thai)
Uraiwan Wanasiri. Implementation of Lean Concept in Healthcare Service Sector for Reducing Waste System: A Case Study of Radiotherapy Department Tertiary Hospital. Naresuan University Journal: Science and Technology. 2016; 24(3): 75-85. (in Thai)
Dachochai Sapim. Improvement of Production Process of Car Accessories. Journal of Scienceand Technology, Sukhothai Thammathirat Open University. 2021; 1(1): 9-18. (in Thai)
Suwannee limchitsomboon. Production Scheduling and Production Process Improvement for a Mobile Pile Driver Crane Manufacturer. Master Thesis of Science; Dhurakij Pundit University. 2011. (in Thai)
Wateekul M, Chaovalitwongse P. Analysis of Front-axle Line Layout Alternatives. Journal of Engineering. 2012; 3(3): 19-33. (in Thai)
Katesarapong S, Sangeium K. Failure Mode and Effect Analysis in Sock Process. The Conference of Industrial Engineering Network; 24-26 Oct 2007; Sripatum University. 2007. (in Thai)
Preangprom S, Pasasuk N. Waste Reduction in the Operation of the Product Shipping Process: A Case Study of the Beverage Industry Company Limited. The Journal of Industrial Technology. 2021; 17(2): 69-86. (in Thai)
Kongkiat Weeraarchakul. Determining Order Quantity for Small Traditional Wholesale Company by Considering Business Environment Through a Simulation. KKU Engineering Journal October-December 2014; 41(4): 507-16. (in Thai)
Ponpakdee S, Leenatham N. An Application of Monte Carlo Simulation Techniques to Spare Parts managing Maintenance in petroleum Industry. Naresuan University Engineering Journal 2020; 15(1): 66-80. (in Thai)
