Channel Investigate

Integrating the Use of Spreadsheet Software and VBA in Inventory Simulation

Download now Free registration required

Executive Summary

This paper 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 enrollment at a major university. The paper 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 paper, the authors give an illustration of the use of Microsoft Excel and VBA in inventory control.

  • Format: PDF
  • Size: 615.03 KB