|
Enhancement of Brake Pads Production Planning with Time Management and Process Condition Using VBA on Microsoft Excel |
|---|---|
| รหัสดีโอไอ | |
| Creator | Chanitsara Phalawan |
| Title | Enhancement of Brake Pads Production Planning with Time Management and Process Condition Using VBA on Microsoft Excel |
| Contributor | Tongjai Satthaphon, Suntaree Unhapipat, Banpot Horbanluekit, Somkid Amornsamannkul |
| Publisher | Faculty of Engineering Mahasasakham University |
| Publication Year | 2566 |
| Journal Title | Engineering Access |
| Journal Vol. | 9 |
| Journal No. | 1 |
| Page no. | 62-69 |
| Keyword | Production improvement, Production management, Production planning, VBA, Brake pads production planning |
| URL Website | https://ph02.tci-thaijo.org/index.php/mijet/index |
| Website title | THAIJO Engineering Access |
| ISSN | 2730-4175 |
| 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. |
