Excel Workbooks

Product Name Price
The Donut Shop Game (xls) $5.00 Buy Now
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.

More...

The Economic Order Quantity (xls) $25.00 Buy Now
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.

More...

The GatorDrink Game (xls) $5.00 Buy Now
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.

More...

The Gravity Model (xls) $25.00 Buy Now
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.”

More...

The Newsvendor Model (xls) $25.00 Buy Now
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.”

More...

The Runs Test (xls) $25.00 Buy Now
This Excel workbook implements the runs test using the normal distribution for large sample sizes and the exact distribution of runs for smaller sample sizes.

More...


Result Pages: [<< Prev]   1  2  3  Displaying 41 to 46 (of 46 products)