The Development Of How To Set Plant Layout Using Craft Methods With Vba On Microsoft Excel
The purpose of this research is to develop methods for plant layout design. It is well know that layout design, when there are more departments, the probability of the schemes plant layout and number of time calculate cost will be greater too. Such as in this paper, the possible pattern equals 190 patterns (duplicate pattern not included). So in this paper, the researchers develop Visual Basic for Application (VBA) coding on Microsoft Excel programs can help find patterns of plant layout with transport cost as low as possible and also reduces repetitive calculation errors.
Index terms - Plant Layout Design, CRAFT Methods, VBA, Transportation Cost.