Quantitative Models for Performance Evaluation and Benchmarking

Data Envelopment Analysis with Spreadsheets

  • Joe Zhu

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

Table of contents

  1. Front Matter
    Pages i-xvii
  2. Joe Zhu
    Pages 1-9
  3. Joe Zhu
    Pages 11-48
  4. Joe Zhu
    Pages 49-60
  5. Joe Zhu
    Pages 61-92
  6. Joe Zhu
    Pages 93-101
  7. Joe Zhu
    Pages 103-119
  8. Joe Zhu
    Pages 141-151
  9. Joe Zhu
    Pages 175-206
  10. Joe Zhu
    Pages 207-244
  11. Joe Zhu
    Pages 245-276
  12. Joe Zhu
    Pages 277-290
  13. Joe Zhu
    Pages 345-361
  14. Joe Zhu
    Pages 363-381
  15. Joe Zhu
    Pages 383-398
  16. Joe Zhu
    Pages 399-407
  17. Back Matter
    Pages 409-414

About this book


Based upon the author’s years of research and teaching experiences, this 3rd Edition introduces Data Envelopment Analysis (DEA) as a data analysis tool for multiple-measure performance evaluation and benchmarking. 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.

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.

DEA models and approaches are presented to deal with performance evaluation problems in a variety of contexts. For example, a context-dependent DEA measures the relative attractiveness of similar operations/processes/products. Sensitivity analysis techniques can be easily applied, and used to identify critical performance measures. Two-stage network efficiency models can be utilized to study performance of supply chain. DEA benchmarking models extend DEA’s ability in performance evaluation. Various cross efficiency approaches are presented to provide peer evaluation scores.

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. This version of DEAFrontier is for use with Excel 97-2013 under Windows and can solve up to 50 DMUs, subject to the capacity of Excel Solver.


Benchmarking Models DEA Data Envelopment Analysis Multiplier Models OpenSolver Performance Evaluation Super Efficiency

Authors and affiliations

  • Joe Zhu
    • 1
  1. 1.School of BusinessWorcester Polytechnic InstituteWorcesterUSA

Bibliographic information

Industry Sectors
Finance, Business & Banking
Consumer Packaged Goods
Energy, Utilities & Environment