Skip to content

Decision Analysis Quantitative Models for Performance Evaluation and Benchmakring Data Development Analysis with Spreadsheets and DEA Excel Solver

ISBN-10: 1402070829

ISBN-13: 9781402070822

Edition: 2003

Authors: Joe Zhu

List price: $215.00
Blue ribbon 30 day, 100% satisfaction guarantee!
what's this?
Rush Rewards U
Members Receive:
Carrot Coin icon
XP icon
You have reached 400 XP and carrot coins. That is the daily max!


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 easy-to-use DEA software - DEA Excel Solver. This DEA Excel Solver is an Add-In for Microsoft(r) 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. For a free version of DEA Excel Solver, please visit
Customers also bought

Book details

List price: $215.00
Copyright year: 2003
Publisher: Springer
Publication date: 10/31/2002
Binding: Hardcover
Pages: 328
Size: 6.25" wide x 9.25" long x 1.00" tall
Weight: 1.496
Language: English

List of Tables
List of Figures
Basic DEA Models
Performance Evaluation, Tradeoffs, and DEA
Envelopment Model
Envelopment Models with Variable Returns to Scale
Other Envelopment Models
Envelopment Models in Spreadsheets
Input-oriented VRS Envelopment Spreadsheet Model
Using Solver
Specifying the Target Cell
Specifying Changing Cells
Adding Constraints
Non-Negativity and Linear Model
Solving the Model
Automating the DEA Calculation
Calculating Slacks
Other Input-oriented Envelopment Spreadsheet Models
Output-oriented Envelopment Spreadsheet Models
Multiplier Model
Multiplier Models in Spreadsheets
Slack-based Model
Slack-based Models in Spreadsheets
Measure-specific DEA Models
Measure-specific Models
Measure-specific Models in Spreadsheets
Performance Evaluation of Fortune 500 Companies
Identification of Best Practice Frontier
Measure-specific Performance
Benchmark Share
RTS Regions
RTS Estimation
VRS and CRS RTS Methods
Improved RTS Method
Spreadsheets for RTS Estimation
Scale Efficient Targets
RTS Classification Stability
Input-oriented RTS Classification Stability
Output-oriented RTS Classification Stability
Spreadsheets for RTS Sensitivity Analysis
Use of RTS Sensitivity Analysis
DEA with Preference
Non-radial DEA Models
DEA with Preference Structure
DEA/Preference Structure Models in Spreadsheets
DEA and Multiple Objective Linear Programming
Output-oriented DEA
Input-oriented DEA
Non-Orientation DEA
Modeling Undesirable Measures
Undesirable Outputs
Undesirable Inputs
Context-dependent Data Envelopment Analysis
Stratification DEA Method
Input-oriented Context-dependent DEA
Output-oriented Context-dependent DEA
Benchmarking Models
Variable-benchmark Model
Fixed-benchmark Model
Fixed-benchmark Model and Efficiency Ratio
Minimum Efficiency Model
Buyer-seller Efficiency Model
Models for Evaluating Value Chains
Value Chain Efficiency
Measuring Information Technology's Indirect Impact
IT Performance Model
Efficiency of IT Utilization
Supply Chain Efficiency
Supply Chain as an Input-Output System
Supply Chain Efficiency Model
Measuring Supply Chain Performance
Congestion Measure
Congestion and Slacks
Slack-based Congestion Measure
Super Efficiency
Super-efficiency DEA Models
Infeasibility of Super-efficiency DEA Models
Output-oriented VRS Super-efficiency Model
Other Output-oriented Super-efficiency Models
Input-oriented VRS Super-efficiency Model
Other Input-oriented Super-efficiency Models
Sensitivity Analysis and Its Uses
Efficiency Sensitivity Analysis
Stability Region
Input Stability Region
Output Stability Region
Geometrical Presentation of Input Stability Region
Infeasibility and Stability
Simultaneous Data Change
Sensitivity Analysis Under CRS
Sensitivity Analysis under VRS
Spreadsheet Models for Sensitivity Analysis
Identifying Critical Performance Measures
Identifying Critical Output Measures
Identifying Critical Input Measures
DEA Excel Solver
DEA Excel Solver
Data Sheet Format
Envelopment Models
Multiplier Models
Slack-based Models
Measure-specific Models
Non-radial Models
Preference Structure Models
Undesirable Measure Models
Context-dependent DEA
Variable-benchmark Models
Fixed-benchmark Models
Minimum Efficiency Models
Value Chain Efficiency
Weak Disposability Models
Super Efficiency Models
Sensitivity Analysis
Free Disposal Hull (FDH) Models
Malmquist Index
Cost Efficiency, Revenue Efficiency and Profit Efficiency
Author Index
Topic Index