IE interfaces (산업공학)

Korean Institute of Industrial Engineers (대한산업공학회)
권호 표지

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

EXCEL VBA를 이용한 중소제조업체용 간이형 MES 구축

  • 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)
  • Received : 2009.04.27
  • Accepted : 2009.09.21
  • Published : 2009.12.01
Download PDF
⟨ Previous Next ⟩

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

References

  1. Choi, S. H. (2007), MES Benchmarking Report, Doosan IT BU Consulting Team, 2-11
  2. 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 https://doi.org/10.1016/S0360-8352(02)00231-0
  3. 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
  4. MESA (1995), International White Paper, MESA, 6, 15.
  5. MKE, (2004), A report of IT'ization status of 30,000 small and medium Companies, Ministry of Knowledge Economy, 2
  6. NIA, (2005), 2005 Assessment for level of industry Information System, National Information Society Agency, vi
  7. 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
  8. 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