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...

Full description

Bibliographic Details
Main Author: Pornrat Thumrongvut
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