An Excel workbook game for the newsvendor problem. The players have to decide each simulated day how many donuts to buy. If they buy too many, they lose money. If they buy too few they lose profit. The game has two game boards (worksheets) that have different cost parameters.
An Excel workbook that implements the EOQ model for teaching purposes. This Excel workbook can also be used to estimate the setup cost over carrying charge ratio from historical data. The papers “Lotsizing Methods” and “Inventory Management” consider many of the same issues.
An Excel workbook game for inventory management. This game requires that the player decide how much to order and when to order. Both the demand the replenishment leadtimes are random. The game has several variants and gives the player some feedback from the “boss” each period. This game teaches students about the buying function and about how to set reorder points, lotsizes, and target inventories.
An Excel workbook for the gravity model for competitive retail store location. This workbook helps locate a new retail facility given the demographics of the region and the location of competing retailers. The “pull” of a retailer on one customer region is directly proportional to the size of the store and inversely proportional to the distance (or travel time) squared. See the companion paper entitled “Location Theory.”
An Excel workbook that finds the optimal solution to the newsvendor problem. The workbook includes separate worksheets for the triangular, normal, and Poisson distributions for demand. Each worksheet allows for user-input parameters and shows (1) graphs for the demand distribution, (2) graph for the expected profit versus order quantity, and (3) optimal values (order quantity, expected profit, etc.). The user can also experiment with various order quantities and immediately see how the results and the graphs change. See the companion paper entitled “The Newsvendor Problem.”