Volume 5 Number 5 (May 2010)
Home > Archive > 2010 > Volume 5 Number 5 (May 2010) >
JSW 2010 Vol.5(5): 498-505 ISSN: 1796-217X
doi: 10.4304/jsw.5.5.498-505

Integrating the Use of Spreadsheet Software and VBA in Inventory Simulation

Changbing Jiang

College of Information Management, Zhejiang Gongshang University, Hangzhou, China

Abstract—This article reviews the advantages and disadvantages of computer programming and spreadsheet modeling in logistics education and inventory control, and describes using Microsoft Excel and VBA in the classroom. One of these approaches, integrating the use of spreadsheet software and VBA, has been used in recent years in a logistics systems management course with a large enrolment at a major university. The article illustrates how, under the integrated paradigm, various computer software packages are integrated in the course to form a unique learning environment. At the last of the article, we give an illustration of the use of Microsoft Excel and VBA in inventory control.

Index Terms—inventory simulation, spreadsheet software, VBA programming, logistics education.

[PDF]

Cite: Changbing Jiang, "Integrating the Use of Spreadsheet Software and VBA in Inventory Simulation," Journal of Software vol. 5, no. 5, pp. 498-505, 2010.

General Information

  • ISSN: 1796-217X (Online)
  • Frequency:  Quarterly
  • Editor-in-Chief: Prof. Antanas Verikas
  • Executive Editor: Ms. Yoyo Y. Zhou
  • Abstracting/ Indexing: DBLP, EBSCO, CNKIGoogle Scholar, ProQuest, INSPEC(IET), ULRICH's Periodicals Directory, WorldCat, etc
  • E-mail: jsweditorialoffice@gmail.com
  • APC: 500USD
  • Jun 12, 2024 News!

    Vol 19, No 2 has been published with online version   [Click]

  • Jan 04, 2024 News!

    JSW will adopt Article-by-Article Work Flow

  • Apr 01, 2024 News!

    Vol 14, No 4- Vol 14, No 12 has been indexed by IET-(Inspec)     [Click]

  • Apr 01, 2024 News!

    Papers published in JSW Vol 18, No 1- Vol 18, No 6 have been indexed by DBLP   [Click]

  • Mar 01, 2024 News!

    Vol 19, No 1 has been published with online version    [Click]