Multi-attribute utility evaluation of alternative office locations
✍️ How to write this paper — guide & tools ▾
¶ … Alternative Properties Using Multi-Attribute Utility Model
David Allen
Charlestown, West Virginia based on great benefits that the agency can obtain in terms of price and land.
Since the agency will only require one location, the model evaluates the four alternatives to select an appropriate location for the agency.
Identify Evaluation Criteria
The memo uses the following attributes for the evaluation:
available space,
room for future expansion,
facility safety and security,
purchase price,
workforce quality of life,
workforce convenience, and
proximity to the Capitol and U.S. Congress and Capitol Hill
Moreover, the purchase prices, distance or nearness of the new office from the government and to other agencies are other criteria used for the evaluation. The outcome of the evaluation is provided in Appendix 1. Some of the criteria used for the evaluation as follows:
Location Available
Acre Price
Acre Distance
a PG County
$2m
12 miles b
NW D.C. 2
$5m
4 miles c
Alexandria, Va.
$4m
8 miles d
Charlestown, W. Va. 100
$500k
60 miles
Recommendation
The memo recommends that the Agency should choose the PG County 5 because of several benefits that the location would deliver to the agency. For example, the location is more cost effective and is the third cheapest property out of all the four alternatives. Moreover, the location will provide safety for the staff of the agency. Moreover, the location will allow the future expansion.
Reference
Rios I, D., Jesus, J., & Banks, D. (2009). Adversarial risk analysis. Journal of the American Statistical Association, 104(486), 841-854.
Thurston, D. L. (2006). "Multi-attribute Utility Analysis of Conflicting Preferences." Decision Making in Engineering Design. Ed. Kemper E. Lewis, et al. New York, New York: ASME Press, 125-133.
Appendix 1
Alternatives, Evaluation Criteria and Rating Values
Location Available
Acre Price
Available Space
Facility Safety and Security
Workforce Quality of Life
Workforce Convenience
Proximity to the U.S. Congress and Capitol Hill.
room for future expansion,
PG County 5
$2,00
12
35
14
27
30
34
NW D.C. 2
$5,00
4
38
15
26
35
36
Alexandria, Va.
$4,00
8
42
20
29
32
40
Charlestown, W. Va. 100
$0,50
60
41
20
28,5
31
40
Best and Worst Criteria Assessments (Using MAX and MIN)
POPCORN
Acre Price
Available Space
Facility Safety and Security
Workforce Quality of Life
Workforce Convenience
Proximity to the U.S. Congress and Capitol Hill.
room for future expansion,
Best Criteria Assessment
$0,50
4
35
14
26
30
34
Worst Criteria Assessment
$5,00
60
42
20
29
35
40
Assigned Ranks and Weights
Totals
Ranks
4
1
3
5
6
7
2
Total
Raw Weights
40,0
55,0
45,0
25,0
20,0
10
50
Unitized Weights
4,0
5,5
4,5
2,5
2,0
1,0
5,0
24,50
Re-Scaled Criteria Values
Location Available
Acre Price
Available Space
Facility Safety and Security
Workforce Quality of Life
Workforce Convenience
Proximity to the U.S. Congress and Capitol Hill.
room for future expansion,
PG County 5
66,67
85,71
100,00
100,00
66,67
100,00
100,00
NW D.C. 2
0,00
100,00
57,14
83,33
100,00
0,00
66,67
Alexandria, Va.
22,22
92,86
0,00
0,00
0,00
60,00
0,00
Charlestown, W. Va. 100
100,00
0,00
14,29
0,00
16,67
80,00
0,00
Weighted Value Scores, Aggregates and Rank
Location Available
Acre Price
Available Space
Facility Safety and Security
Workforce Quality of Life
Workforce Convenience
Proximity to the U.S. Congress and Capitol Hill.
room for future expansion,
Totals
Rank
PG County 5
266,7
471,4
450,0
250,0
133,3
100,0
500,0
4
NW D.C. 2
0,0
550,0
257,1
208,3
200,0
0,0
333,3
3
Alexandria, Va.
88,9
510,7
0,0
0,0
0,0
60,0
0,0
4
Charlestown, W. Va. 100
400,0
0,0
64,3
0,0
33,3
80,0
0,0
1
SENSITIVITY ANALYSIS
Alternatives, Evaluation Criteria and Rating Values
Location Available
Acre Price
Available Space
Facility Safety and Security
Workforce Quality of Life
Workforce Convenience
proximity to the U.S. Congress and Capitol Hill .
room for future expansion,
PG County 5
$2,00
12
35
27
30
34
NW D.C. 2
$5,00
4
38
26
35
36
Alexandria, Va.
$4,00
8
42
2000%
29
32
40
Charlestown, W. Va. 100
$0,50
60
41
2000%
28,5
31
40
Best and Worst Criteria Assessments (Using MAX and MIN)
Location Available
Acre Price
Available Space
Facility Safety and Security
Workforce Quality of Life
Workforce Convenience
proximity to the U.S. Congress and Capitol Hill .
room for future expansion,
Best Criteria Assessment
$0,50
4,0
35,0
14,0
26,0
30,0
34,0
Worst Criteria Assessment
$5,00
60,0
42,0
20,0
29,0
35,0
40,0
Assigned Ranks and Weights
Totals
Ranks
4
1
3
5
6
7
2
Total
Raw Weights
38,0
55,0
43,0
25,0
20,0
10
52
243,0
Unitized Weights
3,8
5,5
4,3
2,5
2,0
1,0
5,2
24,3
Re-Scaled Criteria Values
Location Available
Acre Price
Available Space
Facility Safety and Security
Workforce Quality of Life
Workforce Convenience
proximity to the U.S. Congress and Capitol Hill .
room for future expansion,
Newman's Own
66,67
85,71
100,00
100,00
66,67
100,00
100,00
Betty Croker Pop Secret
0,00
100,00
57,14
83,33
100,00
0,00
66,67
Orville Red's Gourmet
22,22
92,86
0,00
0,00
0,00
60,00
0,00
Charlestown, W. Va. 100
100,00
0,00
14,29
0,00
16,67
80,00
0,00
Weighted Value Scores, Aggregates and Rank
Location Available
Acre Price
Available Space
Facility Safety and Security
Workforce Quality of Life
Workforce Convenience
proximity to the U.S. Congress and Capitol Hill .
room for future expansion,
Total
Rank
Newman's Own
253,33
471,43
430,00
250,00
133,33
100,00
520,00
2158,10
1
Betty Croker Pop Secret
0,00
550,00
245,71
208,33
200,00
0,00
346,67
1550,71
2
Orville Red's Gourmet
84,44
510,71
0,00
0,00
0,00
60,00
0,00
655,16
3
Charlestown, W. Va. 100
Create your account
Always verify citation format against your institution’s current style guide requirements.