Inventory Simulation Using Excel Solver (linear programming approach)

This technique offers an Excel solver solution on the previous inventory simulation problem I posted.

This exercise can serve as a bridging topic between the inventory planning and the optimization technique. The inventory planning chapter from the textbook our university is using (Jacob, the core, 5th edition), does not introduce the idea of optimization before it jumps into the Newsvendor modeling. It introduces the idea of the optimization in the logistics management chapter where it uses a network optimization problem to introduce the distribution problem.

Leave a Reply