Optimal Production Scheduling using VBA on Microsoft Excel
The objectives of this research were to develop the sequence production for multiple machine-multiple job, and to reduce schedule production time in a case study problem using Visual Basic for Application (VBA) on Microsoft Excel. Generally, sequencing problems occur frequently and are important iss...
Main Author: | |
---|---|
Format: | Article |
Language: | Thai |
Published: |
Mahasarakham University
2019-02-01
|
Series: | Warasan Witthayasat Lae Theknoloyi Mahawitthayalai Mahasarakham |
Subjects: | |
Online Access: | http://journal.msu.ac.th/upload/articles/article2431_92493.pdf |
_version_ | 1818212442855964672 |
---|---|
author | Pornrat Thumrongvut |
author_facet | Pornrat Thumrongvut |
author_sort | Pornrat Thumrongvut |
collection | DOAJ |
description | The objectives of this research were to develop the sequence production for multiple machine-multiple job, and to reduce schedule production time in a case study problem using Visual Basic for Application (VBA) on Microsoft Excel. Generally, sequencing problems occur frequently and are important issues for manufacturing processes in industrial processes It is difficult to find the best method to solve these problems, since there are many variables that affect the manufacturing processes, such as processing time, queue time and idle time. This research studied especially manufacturing on machine including five jobs and four machines flow shop. The operating system for this analysis assumes that each machine can handle one job at a time, all machines are ready to perform and a machine will be available for the next job only when the previous job has been completed. Based on the information used in the study and results of analytical algorithm by using VBA on Microsoft Excel, it was found the best method to solve problems in sequence production with case studies, and presented the minimize makespan of 34 minutes. Finally, the results
obtained from the VBA program are accurate and can be evaluated quickly in about 12 minutes of processing time. |
first_indexed | 2024-12-12T05:48:28Z |
format | Article |
id | doaj.art-87a8973b9bd04c0685b10db6bc469c56 |
institution | Directory Open Access Journal |
issn | 1686-9664 |
language | Thai |
last_indexed | 2024-12-12T05:48:28Z |
publishDate | 2019-02-01 |
publisher | Mahasarakham University |
record_format | Article |
series | Warasan Witthayasat Lae Theknoloyi Mahawitthayalai Mahasarakham |
spelling | doaj.art-87a8973b9bd04c0685b10db6bc469c562022-12-22T00:35:44ZthaMahasarakham UniversityWarasan Witthayasat Lae Theknoloyi Mahawitthayalai Mahasarakham1686-96642019-02-013813139Optimal Production Scheduling using VBA on Microsoft ExcelPornrat Thumrongvut0 Master degree student, School of Industrial Engineering, Institute of Engineering, Suranaree University of Technology, Muang, Nakhon Ratchasima 30000, Thailand. The objectives of this research were to develop the sequence production for multiple machine-multiple job, and to reduce schedule production time in a case study problem using Visual Basic for Application (VBA) on Microsoft Excel. Generally, sequencing problems occur frequently and are important issues for manufacturing processes in industrial processes It is difficult to find the best method to solve these problems, since there are many variables that affect the manufacturing processes, such as processing time, queue time and idle time. This research studied especially manufacturing on machine including five jobs and four machines flow shop. The operating system for this analysis assumes that each machine can handle one job at a time, all machines are ready to perform and a machine will be available for the next job only when the previous job has been completed. Based on the information used in the study and results of analytical algorithm by using VBA on Microsoft Excel, it was found the best method to solve problems in sequence production with case studies, and presented the minimize makespan of 34 minutes. Finally, the results obtained from the VBA program are accurate and can be evaluated quickly in about 12 minutes of processing time.http://journal.msu.ac.th/upload/articles/article2431_92493.pdfvbamicrosoft excelsequence productionschedule production |
spellingShingle | Pornrat Thumrongvut Optimal Production Scheduling using VBA on Microsoft Excel Warasan Witthayasat Lae Theknoloyi Mahawitthayalai Mahasarakham vba microsoft excel sequence production schedule production |
title | Optimal Production Scheduling using VBA on Microsoft Excel |
title_full | Optimal Production Scheduling using VBA on Microsoft Excel |
title_fullStr | Optimal Production Scheduling using VBA on Microsoft Excel |
title_full_unstemmed | Optimal Production Scheduling using VBA on Microsoft Excel |
title_short | Optimal Production Scheduling using VBA on Microsoft Excel |
title_sort | optimal production scheduling using vba on microsoft excel |
topic | vba microsoft excel sequence production schedule production |
url | http://journal.msu.ac.th/upload/articles/article2431_92493.pdf |
work_keys_str_mv | AT pornratthumrongvut optimalproductionschedulingusingvbaonmicrosoftexcel |