In this section, we present our spreadsheet simulation
model developed to mimic the pharmacy inventory
ordering process, followed by optimization using
the Excel Solver to find “optimal” inventory policies.
This material is well suited for simulation, inventory
management, and optimization courses designed for
upper-level undergraduate or graduate engineering
students.