________________________________________ ________________________________________
MGS 8770
________________________________________
Service Operations Management
________________________________________ ________________________________________
Data Envelopment Analysis
________________________________________ ________________________________________ ________________________________________ ________________________________________ ________________________________________ ________________________________________
Learning Objectives
________________________________________ ________________________________________ ________________________________________
Understanding the basics of data envelopment analysis (DEA) Solve simple DEA problems
________________________________________ ________________________________________ ________________________________________ ________________________________________ ________________________________________ 2
________________________________________ ________________________________________
Data Envelopment Analysis (DEA)
________________________________________ ________________________________________
DEA is a linear programming method for comparing the relative productivity (or efficiency) of multiple service units
________________________________________ ________________________________________ ________________________________________
Difficulties in evaluating the relative performance of organizational units
________________________________________
Service businesses typically have a very large number of facilities or units that perform similar tasks. There are multiple inputs and outputs. Accounting/financial ratios are often not sufficient.
________________________________________ ________________________________________ 3
MGS8770 – Service Operations Management
________________________________________
1
Service Companies with Multi-Site Operations Company Auto-Related AAMCO Transmissions Budget Rent-a-Car Jiffy Lube Meineke Car Care Midas (brake/muffler repair) Novus Auto Glass Repair Banks Bank of America Wachovia Bank
Number of Sites > 700 3,240 2,156 891 2,777 > 2,200
4,495 2,626
Cleaning Coverall Cleaning Concepts Jani-King Mitex Indoor Hygenics
7,085 > 9,500 > 4,000
Desserts Baskin-Robbins (ice cream) Dunkin' Donuts Tim Horton's (doughnuts) TCBY (frozen yogurt) Yogen Fruz Worldwide, Inc.
3,460 4,736 1,893 2,006 > 5,000
Fast Food Burger King Domino's Pizza
Company McDonald's Subway
________________________________________ ________________________________________
Number of Sites 31,129 17,500
Hair Styling Fantastic Sam's Supercuts
________________________________________
1,350 1,778
________________________________________
Lodging Choice Hotels Marriott Super 8 Motels
> 5,000 2,600 > 2,000
________________________________________
Other Carlson Wagonlit Travel Associates Dollar General (discount stores) GNC (nutrition) Heel Quik! (shoe repair) Kumon Math and Reading Centers Kwik Kurb (concrete services) Merle Norman Cosmetics Studios Miracle Ear (hearing aids) Pearl Vision (eyecare) Radio Shack Snap-On (tools) Wal-Mart (discount stores)
1,121 6,700 4,811 732 1,272 > 1,250 2,006 1,103 811 7,113 4,680 4,800
________________________________________ ________________________________________ ________________________________________ ________________________________________ ________________________________________
8,246 5,996
________________________________________ ________________________________________
Issues with Simple Ratios
________________________________________ 1.Accounting ratio: cost per teller transaction
________________________________________
Higher ratio would be inefficient relative to others, but could be explained by: (1) Mix of outputs transactions (selling CD’s vs simple deposits); (2) Mix of inputs (use of ATM’s plus live tellers)
________________________________________ ________________________________________
2.Broad based measure: return on investment
________________________________________
Is not sufficient to evaluate operating efficiency of individual decision making unit (DMU). For example: A profitable branch could be the result of higher-thanaverage proportion of revenue generating transactions rather than cost-efficient use of resources. 5
________________________________________ ________________________________________ ________________________________________ ________________________________________
Advantages of DEA
________________________________________ ________________________________________
DEA can handle multiple inputs and multiple outputs. Inputs and outputs can have very different units. DEA provides a single comprehensive measure of performance. It doesn't assume any specific functional form relating inputs to outputs. DEA provides valuable information for less efficient DMUs on how to improve. For each inefficient DMU, DEA also provides a peer bestpractice group for reference purposes. 6
MGS8770 – Service Operations Management
________________________________________ ________________________________________ ________________________________________ ________________________________________ ________________________________________ ________________________________________ ________________________________________
2
________________________________________
Efficiency Measure in DEA Efficiency =
=
________________________________________ ________________________________________
Re sults Obtained Weighted Sum of Outputs = Resources Used Weighted Sum of Inputs
________________________________________ ________________________________________
u1O1 j + u2O2 j +L
________________________________________
v1 I1 j + v2 I 2 j +L
________________________________________
Where u1 = weight given to output 1, O1j = amount of output 1 from unit j v1= weight given to input 1 I1j = amount of input 1 used by unit j
________________________________________ ________________________________________ 7
________________________________________ ________________________________________
The DEA Model —Fractional Form Objective Function max E e =
________________________________________ ________________________________________
u1O1e + u2 O2 e + L + u M OMe v1 I1e + v2 I 2 e + L + v N I Ne
Constraints u1O1k + u2 O2 k + L + u M OMk ≤ 10 . v1 I1k + v2 I 2 k + L + v N I Nk u
j
≥ 0
vi ≥ 0
________________________________________ ________________________________________
k = 1, 2,K , K
________________________________________
j = 1 , 2 , ..., M
i = 1 , 2 , ..., N
________________________________________
Ek = efficiency ratio of unit k, k=1,2,…,K, K = total # of units uj = weight given to output j, j=1,2,…,M, M = total # of outputs vi = weight given to input i, i=1,2,…,N, N = total # of inputs Ojk = amount of output j from service unit k Iik = amount of input i used by service unit k e = index of the unit being evaluated
8
________________________________________ ________________________________________ ________________________________________ ________________________________________
Scaling inputs to sum to 1.0
________________________________________
DEA in Standard LP Form
________________________________________
Objective Function:
max
________________________________________
E e = u 1O1e + u 2 O 2 e +L + u M O Me
________________________________________
Subject to:
________________________________________
u1O1k + u 2 O 2 k +L+ u M O Mk − v1 I 1k − v 2 I 2 k −L− v N I Nk ≤ 0
________________________________________
k = 1, 2 , K, K
________________________________________
v1 I 1e + v 2 I 2 e +L+ v N I Ne = 1
________________________________________
u j ≥ 0 j = 1, 2 , ..., M vi ≥ 0 i = 1, 2 , ..., N 9
MGS8770 – Service Operations Management
________________________________________
3
________________________________________ Example
________________________________________
Burger Palace
________________________________________
Burger Palace is a drive-in-only chain that has six units. Only standard meal (burger, fries, and drink) is available. The inputs are labor-hours and material dollars and the output is 100 meals sold. Service unit 1 2 3 4 5 6
Meals sold 100 100 100 100 100 100
Labor-hours 2 4 4 6 8 10
________________________________________ ________________________________________ ________________________________________
Material dollars 200 150 100 100 80 50
________________________________________ ________________________________________ ________________________________________ 10
________________________________________ ________________________________________
Burger Palace
________________________________________
Productivity Frontier
________________________________________ ________________________________________ ________________________________________ ________________________________________ ________________________________________ ________________________________________ ________________________________________ 11
________________________________________ ________________________________________
Burger Palace
________________________________________
LP Model for Service Unit 1
________________________________________
Objective Function:
________________________________________
max E ( S1 ) = u1100 Subject to:
________________________________________
u1100 − v1 2 − v2 200 ≤ 0 u1100 − v1 4 − v2 150 ≤ 0
________________________________________
u1100 − v1 4 − v2 100 ≤ 0 u1100 − v1 6 − v2 100 ≤ 0
________________________________________
u1100 − v1 8 − v2 80 ≤ 0
________________________________________
u1100 − v110 − v2 50 ≤ 0 v1 2 + v2 200 = 1
________________________________________
u1 , v1 , v2 ≥ 0 12
MGS8770 – Service Operations Management
________________________________________
4
________________________________________ Burger Palace
________________________________________
LP Model for Service Unit 2
________________________________________
Objective Function:
________________________________________ ________________________________________
Subject to:
________________________________________ ________________________________________ ________________________________________ ________________________________________ 13
________________________________________ ________________________________________
Burger Palace
________________________________________
Excel Formulation for Unit 1 A 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16
B
C
D
V1 1
V2 1
E
F
________________________________________
G
________________________________________
Burger Palace Variables Value
U1 1
Objective Function
100
Constraints Unit 1 Unit 2 Unit 3 Unit 4 Unit 5 Unit 6 Inputs
100 100 100 100 100 100 0
________________________________________ ________________________________________
=100*B4 -2 -4 -4 -6 -8 -10 2
-200 -150 -100 -100 -80 -50 200
LHS -102 -54 -4 -6 12 40 202