Teaching data‐driven decision making for inventory analysis with Monte Carlo simulation

Inventory management and the ability to make data‐driven decisions under uncertainty are two critical components of supply chain management. This brief describes how an Excel‐based Monte Carlo simulation of fuel and lottery purchases can be used to teach students to analyze a system with randomness....

Full description

Saved in:
Bibliographic Details
Published inDecision sciences journal of innovative education
Main Authors Pritchard, Alan, Taylor, Daniel, Belford, Matthew
Format Journal Article
LanguageEnglish
Published 08.10.2024
Online AccessGet full text

Cover

Loading…
More Information
Summary:Inventory management and the ability to make data‐driven decisions under uncertainty are two critical components of supply chain management. This brief describes how an Excel‐based Monte Carlo simulation of fuel and lottery purchases can be used to teach students to analyze a system with randomness. This exercise can serve as a group or individual assignment to demonstrate the ability of Monte Carlo simulation to estimate solutions involving uncertainty and to teach undergraduate business students how to implement a basic multiperiod fixed‐interval inventory policy with order‐up‐to‐levels. The important concepts of cycle service levels and confidence intervals are emphasized as are the proper implementation of one‐tailed and two‐tailed critical values. Students are encouraged to compare algebraic solutions to their simulation results.
ISSN:1540-4595
1540-4609
DOI:10.1111/dsji.12328