© 2009

Quantitative Models for Performance Evaluation and Benchmarking

Data Envelopment Analysis with Spreadsheets


Part of the International Series in Operations Research & Management Science book series (ISOR, volume 126)

Table of contents

  1. Front Matter
    Pages 1-12
  2. Joe Zhu
    Pages 1-42
  3. Joe Zhu
    Pages 1-14
  4. Joe Zhu
    Pages 1-11
  5. Joe Zhu
    Pages 1-30
  6. Joe Zhu
    Pages 1-17
  7. Joe Zhu
    Pages 1-21
  8. Joe Zhu
    Pages 1-41
  9. Joe Zhu
    Pages 1-15
  10. Back Matter
    Pages 1-14

About this book


It is difficult to evaluate an organization’s performance when there are multiple inputs and multiple outputs to the system. The difficulties are further enhanced when the relationships between the inputs and the outputs are complex and involve unknown tradeoffs. This book introduces DEA as a multiple-measure performance evaluation and benchmarking tool. The focus of performance evaluation and benchmarking is shifted from characterizing performance in terms of single measures to evaluating performance as a multidimensional systems perspective.

This second edition improves a number of DEA spreadsheet models and provides a DEAFrontier software for use with Excel 2007. Several new DEA models and approaches are added. For example, a new DEA-based supply chain model (chapter 8) and DEA models for two-stage processes (Chapter 14) are new additions to the book. Models with restricted multipliers are also discussed and added into the DEAFrontier software. A detailed use of sensitivity analysis in identifying critical measures under DEA is provided. A demonstration of how to use the DEAFrontier software is provided at the end of related chapters.

Conventional and new DEA approaches are presented and discussed using Excel spreadsheets — one of the most effective ways to analyze and evaluate decision alternatives. The user can easily develop and customize new DEA models based upon these spreadsheets. Spreadsheets are updated and modified for use with Excel 2007.

This book also provides an easy-to-use DEA software — DEAFrontier. This DEAFrontier is an Add-In for Microsoft® Excel and provides a custom menu of DEA approaches which include more than 150 different DEA models. DEAFrontier softwares are provided for both Excel 97-2003 and Excel 2007 and can solve up to 100 DMUs. It is an extremely powerful tool that can assist decision-makers in benchmarking and analyzing complex operational efficiency issues in manufacturing organizations as well as evaluating processes in banking, retail, franchising, health care, public services and many other industries.

For a free version of DEAFrontier, please visit



DEA (data envelopment analysis) Data Envelopment Analysis Data-Envelopment-Analysis benchmarking data envelopment efficiency evaluation health care modeling organization performance sensitivity analysis service

Authors and affiliations

  1. 1.Dept. ManagementWorcester Polytechnic InstituteWorcesterU.S.A.

About the authors

Joe Zhu is Associated Professor of Operations, Department of Management at Worcester Polytechnic Institute, Worcester, MA. His research interests include issues of performance evaluation and benchmarking, supply chain design and efficiency, and Data Envelopment Analysis. He has published over 70 articles in journals such as Management Science, Operations Research, IIE Transactions, Annals of Operations Research, Journal of Operational Research Society, European Journal of Operational Research, Information Technology and Management Journal, Computer and Operations Research, OMEGA, Socio-Economic Planning Sciences, Journal of Productivity Analysis, INFOR, Journal of Alternative Investment and others. He is the author of Quantitative Models for Evaluating Business Operations: Data Envelopment Analysis with Spreadsheets (Kluwer Academic Publishers, 2003). He developed the DEAFrontier software which is a DEA add-in for Microsoft Excel. Professor Zhu has also co-authored two books on modeling performance measurement and evaluating hedge funds. He is a co-editor of the DEA handbook. He is an Associate Editor of OMEGA and The Asia-Pacific Journal of Operational Research. He is also a member of Computers & Operations Research Editorial Board. For more information on his research, please visit

Bibliographic information