www.deafrontier.com
                                                                                               
Purchase DEAFrontier
 DEAFrontier Support
Download Free Version
 Visit Software Page

DEAFrontier.com

What is DEA?

Software

Books

Articles

Journal Special Issues

Contact

About Joe Zhu  
      
Click here for Journal of Marketing Research Book Review

   
zhu spreadsheetbook
Joe Zhu, Quantitative Models for Performance Evaluation and Benchmarking: DEA with Spreadsheets and DEA Excel Solver
Springer (Kluwer Academic Publishers), Boston, 2003,
ISBN 1-4020-7082-9

Order the book from amazon.com



Table of Contents Springer online



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.

New DEA models and approaches are presented to deal with performance evaluation problems in a variety of contexts. 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. Value chain efficiency models and DEA benchmarking models can be utilized to study the impact of information technology (IT) investments. These models can help organizations better understand the real impact of their IT investments and integrate technology more efficiently and effectively for the future.

Conventional and new DEA approaches are presented and discussed using 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.

This book also provides an easy-to-use DEA software — DEA Excel Solver. This DEA Excel Solver is an Add-In for Microsoft Excel and provides a custom menu of DEA approaches which include more than 150 different DEA models. 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, e-business, public services and many other industries. The DEA Excel Solver does not set limit on the number of units, inputs or outputs. With the capacity of Excel Solver, the DEA Excel Solver can deal with large sized performance evaluation tasks.

It includes the following DEA models

  • Envelopment Model
  • Multiplier Model
  • Slack-based Model
  • Measure Specific Model (for unontrollable inputs/outputs)
  • Returns to Scale Estimation
  • Returns to Scale Sensitivity Analysis
  • Non-radial Model
  • Preference Structure Model
  • Undesirable Measure Model
  • Context-dependent DEA
  • Benchmarking DEA Model
  • Value Chain Efficiency
  • Congestion
  • Weak Disposability
  • Super Efficiency
  • DEA Sensitivity Analysis
  • FDH
  • Malmquist
  • Cost Efficiency
  • Revenue Efficiency
  • Profit Efficiency
  • Using some combinations of the above models, one can calculate other DEA models, e.g., Malmquist under non-CRS .


The software included in this book works under Excel 97, 2000 and 2003(XP), and does not work under Excel 2007.