Browse > Article

A Simplified MES Implementation for Small-sized Manufacturing Industries with EXCEL VBA  

Park, Jeong-Hyeon (Department of Mechanical Engineering, College of Engineering, Sunmoon University)
Yoshida, Atsunori (Department of Mechanical and Control Engineering, Graduate School of Sunmoon University)
Publication Information
IE interfaces / v.22, no.4, 2009 , pp. 302-311 More about this Journal
Abstract
It's very important to make an effective and optimized production schedule for the small-to-medium-sized factory which have high-variety low-volume manufacturing properties. And now people say that MES is very useful to make scheduling more effectively. But for small-to-medium-sized factory, it is very difficult to build MES system because of fewer infrastructures in the factory, and more to keep it's continuous maintenance and improvement. Therefore it is more important to systematize the production scheduling generation using simpler and easier tools like EXCEL sheet. And it will be needed a new method to make simple MES construction for more efficient production scheduling. This paper proposes the method which can build simple MES easily using a tool of EXCEL VBA for a small-to-medium-sized factory, and introduces an applied case by the proposed method and EXCEL VBA.
Keywords
EXCEL VBA; scheduling; MES; small-sized manufacturing; simulation;
Citations & Related Records
Times Cited By KSCI : 1  (Citation Analysis)
연도 인용수 순위
1 Lee, S. K. and Lee, Y. H. (1999), Production Scheduling employing ERP in the make-to-order manufacturing system, IE Interfaces, 12(3), 424-436
2 Ock, Y. S. and Park, C. H. (2006), Development of the DBR Scheduling system using UML and Visual Basic, The Korea Contents Association, 2(2), 31-36   과학기술학회마을
3 MKE, (2004), A report of IT'ization status of 30,000 small and medium Companies, Ministry of Knowledge Economy, 2
4 MESA (1995), International White Paper, MESA, 6, 15.
5 Won, D. I., Baek, J. K., and Kim, S. S. (2003), A Study of Master Production Scheduling Scheme in TFT-LCD factory Considering Line Balancing, IE Interface, 16(4), 463-472
6 NIA, (2005), 2005 Assessment for level of industry Information System, National Information Society Agency, vi
7 Choi, S. H. (2007), MES Benchmarking Report, Doosan IT BU Consulting Team, 2-11
8 Hsieh, J. C., Chang, P. C., and Hsu, L. C. (2003), Scheduling of drilling operations in printed circuit board factory, Computer & Industrial Engineering, 44, 461-473   DOI   ScienceOn