data envelopment analysis with spreadsheets and dea excel solver

His research interests are in the areas of operations and business analytics, productivity modeling, and performance evaluation and benchmarking. Professor Joe Zhu is one of the prominent researchers in the field of Data Envelopment Analysis (DEA). 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. 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. This DEAFrontier is an Add-In for Microsoft(R) Excel and provides a custom menu of DEA approaches. This book also provides an easy-to-use DEA software - DEAFrontier. Various cross efficiency approaches are presented to provide peer evaluation scores. DEA benchmarking models extend DEA's ability in performance evaluation.

Two-stage network efficiency models can be utilized to study performance of supply chain. Sensitivity analysis techniques can be easily applied, and used to identify critical performance measures. For example, a context-dependent DEA measures the relative attractiveness of similar operations/processes/products. The user can easily develop and customize new DEA models based upon these spreadsheets.ĭEA models and approaches are presented to deal with performance evaluation problems in a variety of contexts. 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.Ĭonventional and new DEA approaches are presented and discussed using Excel spreadsheets - one of the most effective ways to analyze and evaluate decision alternatives. This book introduces Data Envelopment Analysis (DEA) as a multiple-measure performance evaluation and benchmarking tool. The difficulties are further enhanced when the relationships among the performance metrics are complex and involve unknown tradeoffs.

It is difficult to evaluate an organization's performance when multiple performance metrics are present. This book is based upon the author's years of research and teaching experiences. 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.

Data envelopment analysis with spreadsheets and dea excel solver