doi: 10.4304/jsw.5.5.498-505
Integrating the Use of Spreadsheet Software and VBA in Inventory Simulation
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)
Abbreviated Title: J. Softw.
Frequency: Biannually
APC: 500USD
DOI: 10.17706/JSW
Editor-in-Chief: Prof. Antanas Verikas
Executive Editor: Ms. Cecilia Xie
Google Scholar, ProQuest,
INSPEC(IET), ULRICH's Periodicals
Directory, WorldCat, etcE-mail: jsweditorialoffice@gmail.com
-
Mar 07, 2025 News!
Vol 19, No 4 has been published with online version [Click]
-
Mar 07, 2025 News!
JSW had implemented online submission system [Click]
-
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]
-
Oct 22, 2024 News!
Vol 19, No 3 has been published with online version [Click]