Quantitative Models for Performance Evaluation and by Joe Zhu

By Joe Zhu

The writer is without doubt one of the widespread researchers within the box of information Envelopment research (DEA), a strong info research device that may be utilized in functionality evaluate and benchmarking. This e-book is predicated upon the author’s years of analysis and instructing experiences.

It is hard to guage an organization’s functionality whilst a number of functionality metrics are current. The problems are extra more desirable whilst the relationships one of the functionality metrics are complicated and contain unknown tradeoffs. This ebook introduces info Envelopment research (DEA) as a multiple-measure functionality evaluate and benchmarking instrument. the point of interest of functionality assessment and benchmarking is shifted from characterizing functionality when it comes to unmarried measures to comparing functionality as a multidimensional platforms perspective.

Conventional and new DEA ways are awarded and mentioned utilizing Excel spreadsheets — essentially the most powerful how you can study and overview selection choices. The consumer can simply strengthen and customise new DEA types established upon those spreadsheets.

DEA versions and methods are awarded to house functionality assessment difficulties in quite a few contexts. for instance, a context-dependent DEA measures the relative recognition of comparable operations/processes/products. Sensitivity research options might be simply utilized, and used to spot serious functionality measures. Two-stage community potency types can be used to review functionality of provide chain. DEA benchmarking types expand DEA’s skill in functionality evaluate. numerous go potency techniques are awarded to supply peer evaluate scores.

This ebook additionally presents an easy-to-use DEA software program — DEAFrontier. This DEAFrontier is an Add-In for Microsoft® Excel and gives a customized menu of DEA ways. This model of DEAFrontier is to be used with Excel 97-2013 below home windows and will remedy as much as 50 DMUs, topic to the capability of Excel Solver. it really is a really strong software which can help decision-makers in benchmarking and studying complicated operational functionality matters in production firms in addition to comparing approaches in banking, retail, franchising, overall healthiness care, public companies and lots of different industries.

Show description

Read or Download Quantitative Models for Performance Evaluation and Benchmarking: Data Envelopment Analysis with Spreadsheets PDF

Similar econometrics books

A Guide to Modern Econometrics (2nd Edition)

This hugely profitable textual content makes a speciality of exploring replacement innovations, mixed with a pragmatic emphasis, A consultant to replacement thoughts with the emphasis at the instinct in the back of the ways and their useful reference, this new version builds at the strengths of the second one variation and brings the textual content thoroughly up–to–date.

Contemporary Bayesian Econometrics and Statistics (Wiley Series in Probability and Statistics)

Instruments to enhance selection making in a less than perfect international This book presents readers with a radical realizing of Bayesian research that's grounded within the thought of inference and optimum selection making. modern Bayesian Econometrics and facts presents readers with cutting-edge simulation equipment and types which are used to resolve complicated real-world difficulties.

Handbook of Financial Econometrics, Vol. 1: Tools and Techniques

This choice of unique articles-8 years within the making-shines a shiny mild on fresh advances in monetary econometrics. From a survey of mathematical and statistical instruments for realizing nonlinear Markov tactics to an exploration of the time-series evolution of the risk-return tradeoff for inventory industry funding, famous students Yacine AГЇt-Sahalia and Lars Peter Hansen benchmark the present nation of data whereas members construct a framework for its development.

Extra resources for Quantitative Models for Performance Evaluation and Benchmarking: Data Envelopment Analysis with Spreadsheets

Example text

Because cell E18 contains the current value of 1, the INDEX function in cell D23 returns the value in first row and first column of the Revenue array F2:F16 (or the value in cell F2, the Revenue output for DMU1). When the value in cell E18 changes from 1 to 15, the INDEX functions in cells D20:D24 return the input and output values for a specific DMU under evaluation. This feature becomes obvious and useful when we provide the Visual Basic for Applications (VBA) code to automate the DEA computation.

In the Options dialog box, choose the Customize Ribbon button 3. In the list of main tabs, select the Developer check box 4. Choose the OK button to close the Options dialog box Open the Tools/References menu in the VB Editor. This brings up a list of references. 17). To add the reference, simply check its box. 18. 19). , Module1) into the Excel file. ) Now, we can insert the VBA code into the Module1. Type “Sub DEA()” in the code window. 21). 20 shows the VBA code for automating the DEA calculation.

We assign a range name of “DMU” to cell E18, the cell representing the DMU under evaluation. The formulas for the DMU under evaluation then can be expressed as Cell D20 =INDEX(InputUsed,DMU,1) Cell D21 =INDEX(InputUsed,DMU,2) Cell D22 =INDEX(InputUsed,DMU,3) Cell D23 = Efficiency*INDEX(OutputProduced,DMU,1) Cell D24 = Efficiency*INDEX(OutputProduced,DMU,2) The cells “B20:B22”, “B23:B24”, “B25”, “D20:D22”, “D23:D24” are named as “ReferenceSetInput”, “ReferenceSetOutput”, “SumLambda”, “DMUInput”, and “DMUOutput”, respectively.

Download PDF sample

Rated 4.55 of 5 – based on 23 votes