Page 203 -

DATA ENVELOPMENT ANALYSIS 183

Figure 4.11 The Excel Solution for the Leisure Air Revenue Management Problem

TARGET CELL (MAX)
Name Original Value Final Value
----------------- ------------- ----------
Objective function 0 103103
ADJUSTABLE CELLS
Name Original Value Final Value
--- ------------- ----------
GAQ 0 33
GSQ 0 44
GVQ 0 22
GAY 0 16
GSY 0 6
GVY 0 11
EAQ 0 26
ESQ 0 36
EVQ 0 39
EAY 0 15
ESY 0 7
EVY 0 9
ASQ 0 31
ASY 0 8
AVQ 0 41
AVY 0 10

CONSTRAINTS
Name Cell Value Status Slack
--- --------- ---------- ----
1 132 Binding 0
2 132 Binding 0
3 132 Binding 0
4 132 Binding 0
5 33 Binding 0
6 44 Binding 0
7 22 Not Binding 23
8 16 Binding 0
9 6 Binding 0
10 11 Binding 0
11 26 Binding 0
12 36 Not Binding 20
13 39 Binding 0
14 15 Binding 0
15 7 Binding 0
16 9 Binding 0
17 31 Not Binding 33
18 8 Binding 0
19 41 Not Binding 5
20 10 Binding 0

Copyright 2014 Cengage Learning. All Rights Reserved. May not be copied, scanned, or duplicated, in whole or in part. Due to electronic rights, some third party content may be suppressed from the eBook and/or eChapter(s). Editorial review has
deemed that any suppressed content does not materially affect the overall learning experience. Cengage Learning reserves the right to remove additional content at any time if subsequent rights restrictions require it.