Week 3 Case Analysis Template
Consequence Table
The consequence table for the stated objectives of this case is as follows:
'
Conference City Airfare
Hotel Room Rate Conference Cost
New Orleans 300-400
149
16000
Chicago
200-300
149
25000
New York
300-400
349
20000
Las Vegas
200-300
169
15000
The impact matrix of each element on the overall budget in respect to allocated cost is:
Conference City Airfare
Hotel Room Rate Conference Cost
New Orleans 0.02
0.01
0.97
Chicago
0.01
0.01
0.98
New York
0.02
0.02
0.96
Las Vegas
0.02
0.01
0.97
Consequence impact has been derived from evaluating impact of each cost element on total cost.
Scoring Model (Include Legend)
Cost Element
Scoring
Airfare
100%
Hotel Room Rate
100%
Conference Cost
200%
Survey Rank
100%
Since, conference cost is twice as important as other costs, double weightage is given to it in comparison with others.
Weighted Scoring Model (Include Legend)
Conference City Airfare
Hotel Room Rate
Conference Cost
Weighted Scores
New Orleans
0.0242
0.0090
1.9337
1.9668
Chicago
0.0118
0.0059
1.9647
1.9824
New York
0.0193
0.0168
1.9278
1.9639
Las Vegas
0.0194
0.0109
1.9394
1.9697
The weighted scoring is based on Consequence*scoring for each of factor
Recommendation:
After analyzing the weightage scoring model, the given total weightage for each city are:
New Orleans (take only from comparison stand point) – 1.966
Chicago - 1.982
New York - 1.963
Las Vegas - 1.969
Considering all the given weightage, the New York weightage is 1.963 which is the lowest and comparatively closure to New Orleans hence can be considered to conduct conference from cost stand point.
The dominated alternative is Las Vegas which is closure to other two alternatives with weightage value of 1.969