Enhancement of Brake Pads Production Planning with Time Management and Process Condition Using VBA on Microsoft Excel
Issued Date
2023-01-01
Resource Type
eISSN
27304175
Scopus ID
2-s2.0-85189320981
Journal Title
Engineering Access
Volume
9
Issue
1
Start Page
62
End Page
69
Rights Holder(s)
SCOPUS
Bibliographic Citation
Engineering Access Vol.9 No.1 (2023) , 62-69
Suggested Citation
Phalawan C., Satthaphon T., Unhapipat S., Horbanluekit B., Amornsamankul S. Enhancement of Brake Pads Production Planning with Time Management and Process Condition Using VBA on Microsoft Excel. Engineering Access Vol.9 No.1 (2023) , 62-69. 69. doi:10.14456/mijet.2023.7 Retrieved from: https://repository.li.mahidol.ac.th/handle/20.500.14594/97912
Title
Enhancement of Brake Pads Production Planning with Time Management and Process Condition Using VBA on Microsoft Excel
Corresponding Author(s)
Other Contributor(s)
Abstract
This research aims to increase the efficiency of work management in the production planning process. This research uses an industrial engineering method based on a time and motion study to record operational data and create a standard planning process in the production process. It also uses the VBA on Microsoft Excel to analyze data and facilitate the work of the operators. The results of time data recording can be used to calculate the standard time as part of setting work sequence standards. The trials for two sessions (session 1 is a daytime production and session 2 is a nighttime production) with different production process results showed that the program could be used to plan the two sessions’ production with no difference. The usability test revealed that programmed planning results were greater in percentage mean accuracy compared to actual production than existing planning. There was a 72.17% increase in efficiency in session 1 and a 73.48% increase in efficiency in session 2. This was a statistically significant increase in efficiency. Therefore, it can be concluded that using the above principles and methods can improve the production planning process to be able to plan production more accurately.