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: Quarterly
APC: 500USD
DOI: 10.17706/JSW
Editor-in-Chief: Prof. Antanas Verikas
Executive Editor: Ms. Cecilia Xie
Abstracting/ Indexing: DBLP, EBSCO,
CNKI, Google Scholar, ProQuest,
INSPEC(IET), ULRICH's Periodicals
Directory, WorldCat, etcE-mail: jsweditorialoffice@gmail.com
-
Oct 22, 2024 News!
Vol 19, No 3 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]
-
Jun 12, 2024 News!
Vol 19, No 2 has been published with online version [Click]