# Excel Workbooks

Product Name | Price |

ABC Classification Analysis (xls) | $25.00 | Buy Now |

An Excel workbook that implements numerical methods in VBA to find the optimal alpha parameter to fit a distribution-by-value curve to empirical data.
More... | ||

Aggregate Inventory Analysis (xls) | $25.00 | Buy Now |

An Excel workbook that finds the optimal lotsizes for a set of inventory items and compares the current inventory to optimal cycle inventory for each item and also for the aggregate inventory.
More... | ||

AL - The Adaptive Location/Allocation Optimization Tool (xls) | $25.00 | Buy Now |

An Excel workbook that implements an advanced version of the numeric-analytic allocation location model for finding the optimal solution for a single facility and near-optimal solutions for multiple warehouses using an infinite set location approach. The workbook extends the traditional approach by implementing a great circle distance option with latitudes and longitudes.
More... | ||

Audit Sampling (xls) | $25.00 | Buy Now |

This is a sophisticated Excel workbook that implements a stop and go sampling plan for an audit based on the hypergeometric distribution. This distribution is the most precise approach for auditing and results in the lowest recommended sample size. Much of the VBA code needed for this process is included in the companion paper by the same title.
More... | ||

Bass Model (xls) | $25.00 | Buy Now |

This Excel workbook implements the Bass model for product diffusion in order to predict the sales of a new product. The workbook provides an extensive explanation for how the model works and finds the optimal (least squares) fit given a few points on the product life cycle.
More... | ||

Check Digit (xls) | $25.00 | Buy Now |

The last digit of many account numbers, identification numbers, and part numbers. The check digit is a useful for determining if the number is valid. This Excel workbook implements a popular check digit algorithm to verify that an account number such as a credit card number is clearly invalid. This procedure will work on nearly all credit card numbers.
More... | ||

Commonality (xls) | $25.00 | Buy Now |

An Excel workbook that estimates the savings from replacing two similar components with a single robust (universal) component.
More... | ||

Confidence Intervals (xls) | $25.00 | Buy Now |

An Excel workbook that helps the user to determine required sample sizes to achieve user-specified confidence intervals for a variety of problem types and assumptions. See the companion paper entitled “Estimating Confidence Intervals and Required Sample Sizes.”
More... | ||

Correlation Significance Test (xls) | $25.00 | Buy Now |

This workbook helps the user conduct a statistical test to determine if the correlation between two continuous variables is large enough to conclude that the correlation is significantly different from zero. This Excel workbook is a companion to the paper by the same name.
More... | ||

Distributions (xls) | $25.00 | Buy Now |

An Excel workbook that includes many important probability distributions including the uniform, normal, lognormal, exponential, Erlang, gamma, beta, Weibull, triangular, Poisson, binomial, and hypergeometric distributions, with statistics, Excel formulas, VBA code, tables, and graphs. An additional worksheet includes the partial expectation function and its inverse for the normal distribution. All of the graphs for probability distributions in the Encyclopedia of Operations Management are from this Excel workbook.
More... | ||

Dollar Unit Sampling (xls) | $25.00 | Buy Now |

This Excel workbook provides a practical tool that can be used in an auditing context where financial misstatements are important. The workbook computes the required sample size for a dollar unit sampling plan (DUS) and then provides guidance as samples are collected on how the sample size must change to achieve the desired objectives. The companion paper entitled “Dollar Unit Sampling” provides the concepts behind this Excel workbook.
More... | ||

DuPont Analysis (xls) | $25.00 | Buy Now |

An Excel workbook that implements the DuPont model to show the sensitivity of Return on Net Assets (RONA) to changes in inventory investment.
More... | ||

Economic Lot Scheduling Problem (xls) | $25.00 | Buy Now |

An Excel workbook that solves the economic lot scheduling problem. This workbook uses VBA to implement a Newton search to find the shadow price needed to satisfy the capacity constraint. See the companion workbook entitled “The Economic Lot Scheduling Problem.”
More... | ||

Empirical Probability Distributions with Theoretical Tails (xls) | $25.00 | Buy Now |

This Excel workbook presents examples of how to use the VBA code for generating values from (1) a continuous empirical distribution with the right tail replaced with a theoretical exponential distribution and (2) a discrete empirical distribution with the right tail replaced with a theoretical Poisson distribution. This is a support workbook for the paper with the same name.
More... | ||

Failure Modes and Effects Analysis (xls) | $25.00 | Buy Now |

An Excel workbook “template” that supports a Failure Mode and Effects Analysis (FMEA).
More... | ||

Forecasting with Exponential Smoothing (xls) | $25.00 | Buy Now |

This Excel workbook implements the Winters’ model for forecasting with exponential smoothing. This model finds the least squares fit for the alpha and beta parameters for the Winters’ model. It also helps estimate the seasonal factors using a centered moving average approach. The model allows users to modify the parameters and view the statistical and graphical results. See the companion paper “Forecasting with Exponential Smoothing.”
More... | ||

Kepner-Tregoe (xls) | $25.00 | Buy Now |

This worksheet implements the Kepner-Tregoe model for determining weighted scores for alternatives. (This is often called a scoring matrix.) This workbook uses a paired comparisons method to determine the weights.
More... | ||

Learning Models (xls) | $25.00 | Buy Now |

An Excel workbook for both the half-life and the learning curve. Finds the optimal learning parameters to minimize the sum of the squared errors. See the companion paper entitled “Learning Models.”
More... | ||

LIDA -- Lifetime Inventory Demand Analysis (xls) | $25.00 | Buy Now |

This Excel workbook forecasts the remaining lifetime demand using both a finite and an infinite geometric series model. Regression is used to estimate the parameters. Extensive graphs support the analysis. The companion paper entitled “Forecasting Lifetime Demand” explains the models implemented in this Excel workbook. The name “LIDA” stands for “Lifetime Inventory Demand Analysis.”
More... | ||

Lotsizing (xls) | $25.00 | Buy Now |

An Excel workbook that implements several methods for lotsizing for time varying demand, including an efficient implementation of the Wagner-Whitin algorithm. See the companion paper entitled “Lotsizing Methods.”
More... | ||