Skip to main content
  • Book
  • © 2014

Quantitative Models for Performance Evaluation and Benchmarking

Data Envelopment Analysis with Spreadsheets

Authors:

  • Joe Zhu is one of the most prominent and published researchers in the field
  • New Material on using Open Solver in Excel 2013
  • Includes online version of DEA Frontier software in Springer Extras
  • Includes supplementary material: sn.pub/extras

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

Buy it now

Buying options

eBook USD 99.00
Price excludes VAT (USA)
  • Available as EPUB and PDF
  • Read on any device
  • Instant download
  • Own it forever
Hardcover Book USD 129.99
Price excludes VAT (USA)
  • Durable hardcover edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Other ways to access

This is a preview of subscription content, log in via an institution to check for access.

Table of contents (19 chapters)

  1. Front Matter

    Pages i-xvii
  2. Data Envelopment Analysis

    • Joe Zhu
    Pages 1-9
  3. Envelopment DEA Models

    • Joe Zhu
    Pages 11-48
  4. Multiplier DEA Model

    • Joe Zhu
    Pages 49-60
  5. DEA Cross Efficiency

    • Joe Zhu
    Pages 61-92
  6. Slack-Based DEA Models

    • Joe Zhu
    Pages 93-101
  7. Measure-Specific DEA Models

    • Joe Zhu
    Pages 103-119
  8. Modeling Undesirable Measures

    • Joe Zhu
    Pages 141-151
  9. Super Efficiency

    • Joe Zhu
    Pages 175-206
  10. Sensitivity Analysis

    • Joe Zhu
    Pages 207-244
  11. Benchmarking Models

    • Joe Zhu
    Pages 245-276
  12. Returns-to-Scale

    • Joe Zhu
    Pages 277-290
  13. Congestion

    • Joe Zhu
    Pages 345-361
  14. Identifying Critical Measures in DEA

    • Joe Zhu
    Pages 363-381
  15. Interval and Ordinal Data in DEA

    • Joe Zhu
    Pages 383-398
  16. DEAFrontier Software

    • Joe Zhu
    Pages 399-407

About this book

The author is one of the prominent researchers in the field of Data Envelopment Analysis (DEA), a powerful data analysis tool that can be used in performance evaluation and benchmarking. This book is based upon the author’s years of research and teaching experiences.

It is difficult to evaluate an organization’s performance when multiple performance metrics are present. The difficulties are further enhanced when the relationships among the performance metrics are complex and involve unknown tradeoffs. This book introduces Data Envelopment Analysis (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.

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 tothe capacity of Excel Solver. It is an extremely powerful tool that can assist decision-makers in benchmarking and analyzing complex operational performance issues in manufacturing organizations as well as evaluating processes in banking, retail, franchising, health care, public services and many other industries.

Authors and Affiliations

  • School of Business, Worcester Polytechnic Institute, Worcester, USA

    Joe Zhu

About the author

Professor Joe Zhu is one of the prominent researchers in the field of Data Envelopment Analysis (DEA). His research interests are in the areas of operations and business analytics, productivity modeling, and performance evaluation and benchmarking. He has published over 100 articles in peer-reviewed journals including Operations Research, Sloan Management Review, European Journal of Operational Research, Journal of the Operational Research Society, Naval Research Logistics, IIE Transactions, Journal of Banking and Finance, OMEGA, and others. He is an Area Editor of OMEGA, an Associate Editor of INFOR, and the Associate Series Editor of Springer’s International Series in Operations Research and Management Science.

He is a Japan Society for Promotion of Science (JSPS) fellow and a William Evans Visiting Fellow  of University of Otago, New Zealand. His research has been supported by KPMG Foundation, National Institute of Health, and Department of Veterans Affairs.

Bibliographic Information

Buy it now

Buying options

eBook USD 99.00
Price excludes VAT (USA)
  • Available as EPUB and PDF
  • Read on any device
  • Instant download
  • Own it forever
Hardcover Book USD 129.99
Price excludes VAT (USA)
  • Durable hardcover edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Other ways to access