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.


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: Monthly
Editor-in-Chief: Prof. Antanas Verikas
Executive Editor: Ms. Yoyo Y. Zhou
Abstracting/ Indexing: DBLP, EBSCO, ProQuest, INSPEC, ULRICH's Periodicals Directory, WorldCat, etc
E-mail: jsw@iap.org
  • Aug 21, 2019 News!

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

  • Jun 25, 2019 News!

    Vol.13, No.9 has been indexed by EI (Inspec).   [Click]

  • Aug 01, 2018 News!

    [CFP] 2019 the annual meeting of JSW Editorial Board, ICCSM 2019, will be held in Barcelona, Spain, July 14-16, 2019.   [Click]

  • Jul 10, 2019 News!

    Vol 14, No.8 has been published with online version 4 original aritcles from 2 countries are published in this issue.    [Click]

  • Jul 22, 2019 News!

    Welcome Prof Ferhat Khendek from Canada to join the Editorial board of JSW    [Click]