Journal of the Korea Safety Management & Science (대한안전경영과학회지)

Korea Safety Management & Science (대한안전경영과학회)
권호 표지
DOI QR코드

DOI QR Code

A Case Study for application of WMS which is made of Excel VBA for SMB logistics companies

Excel VBA를 활용한 중소 물류기업 창고 관리 시스템 적용 사례 연구

  • Kim, Jung-Hyun (Department of Industrial Engineering Graduate School, University of Myongji) ;
  • Lee, Seog-Hyeon (Department of Industrial Engineering Graduate School, University of Myongji) ;
  • Jung, Jae-Jung (Department of Industrial Engineering Graduate School, University of Myongji) ;
  • Kwon, Young-Jin (Department of Industrial Engineering Graduate School, University of Myongji) ;
  • Lee, Kye-Chung (Department of Industrial Engineering Graduate School, University of Myongji) ;
  • Hwang, Dae-Sung (Department of Industrial Engineering Graduate School, University of Myongji)
  • 김정현 (명지대학교 산업경영공학과) ;
  • 이석현 (명지대학교 산업경영공학과) ;
  • 정재정 (명지대학교 산업경영공학과) ;
  • 권영진 (명지대학교 산업경영공학과) ;
  • 이계정 (명지대학교 산업경영공학과) ;
  • 황대성 (명지대학교 산업경영공학과)
  • Received : 2012.04.20
  • Accepted : 2012.06.13
  • Published : 2012.06.30
Download PDF
⟨ Previous Next ⟩

Abstract

This research studies the present status of utilization of IT in SMB, Small & Medium Business, logistics companies, and analyzes the examples of utilizing Excel VBA for building and operating IT system in SMB logistics companies. Through the study, this research suggests main issues of building and operating logistic systems and the effective way of utilizing the systems in SMB logistics companies.

Keywords

References

  1. Survey on the Information Level of Korea small and Medium Enterprises, Korea Technology and Information Promotion Agency for SMEs, 2011.7.21
  2. Kim T-H, A study on Methodology for Building Information System for Small Size Organization by Using Excel VBA, Dept. of Information System Engineering, Graduate School, Dongseo University, Korea, 2007.
  3. Park S-M, Design and Effectuation for Stevedoring Information System for the Bulk Freight Terminal, Korea Safety Management & Science, 12(2):173-181, 2010.6
  4. Park, J-H, A Simplefied MES Implementation for Small-sized Manufacturing Companies with EXCEL VBA, IE Interfaces, 12(4):82-89, 2009.12
  5. Yang J-H, Development of Structural Analysis Program for Education using Excel VBA, The Korea Institute of Building Construction,11(6):126-126, 2011.12
  6. Lee D-H, A Empirical Study on Informatization of Logistics Industry in Incheon, Terminal, Korea Safety Management & Science, 13(3) 79-85, 2011.9
  7. Choi I. Y, An Empirical Study on Risk Factors for Information System Development Projects of SMEs, Dept. of Management Information System Graduate School, Dong-A University, Korea, 2008.6
  8. John Walkenbach, Excel 2007 Power Programming with VBA, John Wiley &Sons, 2007.4.16