Selection and prioritization of projects--a Data Envelopment Analysis (DEA) approach.
Lall, Vinod ; Lumb, Ruth ; Moreno, Abel 等
Table 1
Inputs and Outputs for Different Applications of DEA
Source Application Inputs
Cheng Provides banks with a * Concession period
et al. (2007) methodology to evaluate
concessionaires * Financial risk to
borrower
El-Mashaleh Firm performance of * Expenses
et al., (2007) construction
contractors. ** Project
management
** Safety
Vinter Evaluating the * Cost
et al. (2006) performance of
several projects * Work content
* Level of
** Monitoring
** Uncertainty
McCabe Pre-qualification of * Safety record
et al. (2005) construction
contractors * Current capacity
* Related work
experience
Athanassopoulos UK electricity * Capital
et al. generating expenditures
(1999)
* Controllable costs
* Fuel (quantity)
Al-Shammari Jordanian manufacturing * Number of
(1999) firms employees
* Paid in capital
* Fixed assets
Peck et al. US aircraft * Labor expenses
(1998) maintenance
** Airframes/total
aircraft operating
expenses
** Aircraft engines/
total aircraft
operating expenses
* Expenditures
** Airframe repairs/
total aircraft
operating expenses
** Engine repairs /
total aircraft
operating expenses
* Material expenditures
** Airframes/total
aircraft operating
expenses
** Engines/total
aircraft operating
expenses
Kozmetsky Global semiconductor * Cost of goods sold
(1998) companies
* Selling, general,
and administrative
expenses
* Total assets
Kirjavainen Finnish secondary * Hours per week *
and schools
Loikkanen ** Teaching
(1998)
** Non-teaching *
* Teachers
** Experience
** Education
* Admission level
* Education level of
students' parents
Goto and US and Japanese * Total number of *
Tsutsui electric utilities employees
(1998)
* Generation capacity
(mega watt)
* Quantity of
** Fuel used
(kilo calories)
** Power purchases
(giga watt hours)
Chu and Singapore * Shareholders fund *
Lim (1998) banks
* Interest expenses
* Operating expenses
Chandra Canadian textiles * Number of
et al. (1998) companies employees
* Average annual
investment
Ahuja and Indian manufacturing * Number of
Majumdar enterprises employees
(1998)
* Net fixed assets
Rouse et al. New Zealand * Total expenditures
(1997) highway on reseals,
maintenance rehabilitation and
general
maintenance
(contractor costs)
Baker and Technology selection * Cost
Talluri (1997) (robots)
Thore et al. US computer industry * Repeatability (mm)
(1996)
* Costs
** Raw material
** Labor
* R&D expenditures
* Capital investment
Russel et al. US oil * Total costs incurred
(1996) companies
* Quantity
** Proved crude oil
** Proved gas
Ozcan and US hospitals * 1 (scalar or
McCue (1996) dummy variable)
Odeck (1996) Rock blasting in * Cost
Norway
** Labor
** Capital
** Commodity
Hjalmarsson Trucks in road * Make and model
and Odeck construction and year
(1996) maintenance in
Norway * Region of operation
* Capacity of the
truck in tons
* Costs
** Wage of driver
per year
** Fuel per year
** Rubber
accessories
** Maintenance
Thanassoulis Police forces in * Number of
(1995) England and Wales
** Violent crimes
** Burglaries
** Other crimes
** Officers
Ray and US steel industry * Labor hours
Kim (1995)
* Cost of material
Lovell et al. Macroeconomic * 1 (scalar or dummy
(1995) performance of variable)
European countries
El-Maghary Finnish * Total expenditure
and Lahdelma universities
(1995) * Admission
(acceptance rate)
Athanassopoulos UK grocery industry * Capital employed
and Ball (1995)
* Fixed assets
* Number of
employees
* Number of outlets
* Sales area
([m.sup.2])
McCarty, US school * Number of staff
Yaisawarng districts per pupil
(1993)
* Percentage of staff
on M.S. Or PHD
* Expenditure
per pupil
Lee and Share tenancy * Fertilizers
Somwaru in US
* Pesticides
(1993) agriculture
* Seeds
* Hired labor
* Capital
consumption
Eeckaut Belgian municipalities * Total operating
et al. (1993) expenses
Burgess and US veterans hospitals * Number of
Wilson (1993)
** Acute care
hospital beds
** Long term
hospital bids
* Clinical labor
* Non-clinical labor
* Physician hours
Charnes Chinese cities * Number of staff
et al. (1988) and labor
* Working fund
* Investments in
construction and
acquisitions of
machinery
Grosskopf and US hospitals * Number of
Valdmanis physicians
(1987)
* Non-physician labor
* Admissions
* Net plant asset
Bowlin (1987) US Air Force * Supply costs
real-property
maintenance * Available direct
labor hrs
* Available passenger
carrying vehicle
(vehicles)
Source Outputs
Cheng * Toll setting up and
et al. (2007) adjusting mechanism
* Total investment
schedule
* Attractiveness of main
loan
** Financial
** Analysis
* Strength of other
participants
* Net present value
* Internal rate of return
El-Mashaleh * Performance
et al., (2007)
** Schedule
** Cost
** Safety
* Customer satisfaction
* Profit
Vinter * Performance
et al. (2006)
** Schedule
** Cost
** Design
* Documentation
McCabe * Sales history
et al. (2005)
* Employee experience
Athanassopoulos * Electricity produced
et al. (megawatt-hour)
(1999)
* Plant availability (%)
* l/ Number of accidents
incurred
* 1/ Generated pollution
Al-Shammari * Market value per share
(1999)
* Net sales
* Net income after taxes
* Percentage of all
Peck et al. scheduled flight arrivals
(1998) not delayed for
mechanical reasons
Kozmetsky * Net sales
(1998)
Kirjavainen * Number of students who
and passed their grade
Loikkanen
(1998) * Number of graduates
* Score of students in
compulsory subjects in
matriculation
examination
* Score of students in
additional subjects in
matriculation
examination
Goto and * Quantity of electricity
Tsutsui
(1998) * Sold to residential
customers (giga watt
hours)
Sold to non-residential
customers (commercial,
industrial, others)
Chu and * Annual increase in
Lim (1998) average assets
* Total income
* Profits
Chandra * Annual sales
et al. (1998)
Ahuja and * Net value added
Majumdar
(1998)
Rouse et al. * Kilometers of
(1997)
** Highway resealed
** Highway rehabilitated
* General maintenance as
measured by an index of
highway surface defects
* Level of service as
measured by annual
vehicle kilometers
* Roughness measures
combined for urban and
rural highways
* Categorical variable
(an assessment of
environmental difficulty
faced; geology and
climate)
Baker and * Load capacity (kg)
Talluri (1997)
Thore et al. * Velocity (m/s)
(1996)
* Sales revenues
* Profits
* Market capitalization
(number of shares
outstanding multiplied
by the stock price)
Russel et al. * Quantity
(1996)
** Crude oil
** Gas
Ozcan and * Return on assets
McCue (1996)
* Operating cash flow per
bed
* Operating margin
* Total asset turnover
Odeck (1996) * Blasted rock volume
(m.sup.3])
Hjalmarsson * Transportation work
and Odeck in kilometers per year
(1996)
* Volume transported in
cubic per year
* Effective hours in
production per year
Thanassoulis * Number of
(1995)
** Violent crime clear
ups
** Burglary crime clear
ups
** Other crime clear ups
Ray and * Quantity (weighted
Kim (1995) index of quantities
shipped of 80 different
steel products)
Lovell et al. * GPD per capita
(1995)
* 1/ inflation
* Employment rate
* Trade balance
(Exports/Imports)
* 1/ (carbon emissions
in millions of tons per
capita)
* 1/ (nitrogen emissions in
millions of tons per
capita)
El-Maghary * Number of graduates
and Lahdelma
(1995) * Number of post
graduates
* Graduation speed
(1/years)
* Completion
Athanassopoulos * Total sales
and Ball (1995)
McCarty, * Percentage of students
Yaisawarng
(1993) ** Who pass HSPT test
** Who pass MPCT test
** Who pass RPCT test
Lee and * Revenues
Somwaru
(1993)
Eeckaut * Total population
et al. (1993)
* Length of roads to be
maintained
* Number of
** Senior citizens
** Crimes registered in
the municipality
** Students enrolled in
primary schools
Burgess and * Inpatient days
Wilson (1993)
* Number of
** Inpatient discharges
** Outpatient visits
** Ambulatory surgical
procedures
** Inpatient surgical
procedures
Charnes * Gross industrial output
et al. (1988) value
* Profit and taxes
* Retail sales
Grosskopf and * Acute care (inpatient
Valdmanis days)
(1987)
* Intensive care (inpatient
days)
* Surgeries (in-patient
and out-patient
surgeries)
* Ambulatory and
emergency care
(number of visits)
Bowlin (1987) * Completed work orders
* Completed job orders
* Completed recurring
work actions
* Delinquent job orders
Table 2
Project Selection Data (Modified from data set in McCain (2011)
Project ROI (%) Alignment Implementation Cost
to Strategy Time (Hrs) ('000)
1 20 4 6000 2000
2 15 5 8000 1800
3 30 4 6500 1500
4 20 3 5000 2200
5 25 3 6500 1000
6 10 5 4000 900
7 35 3 7000 3000
8 10 4 6000 1700
9 40 4 10000 3500
10 30 3 5500 1200
Table 3
Project Efficiency Ratios
Project Number Efficiency Ratios Reference Set
1 0.792 Projects 6,10
2 0.581 Projects 6,10
3 0.929 Projects 6,10
4 0.842 Projects 6,10
5 1.000 --
6 1.000 --
7 0.917 Project 10
8 0.576 Projects 6,10
9 0.733 Project 10
10 1.000 --