Unit 6 Assignment - Weighted Decision Model

profilebrandon282011
WeightedMatrixExample.xlsx
Home>Business & Finance homework help>Unit 6 Assignment - Weighted Decision Model

Unworked

Buying a House
Criteria Age Location Cost
Age 20% < 10 Years 3 Excellent Area 3 Below Budget 3
Location 40% < 20 Years 2 Great area 2 At Budget 2
Cost 40% > 20 Years 1 Good area 1 Over Budget 1
Property Age Location Cost Sum
123 Main St 3 3 1
2506 Pearl Dr 2 3 2
455 Washington Ave 2 2 2
3451 Harmony Ln 1 1 3

Worked

Buying a House
Criteria Age Location Cost
Age 20% < 10 Years 3 Excellent Area 3 Below Budget 3
Location 40% < 20 Years 2 Great area 2 At Budget 2
Cost 40% > 20 Years 1 Good area 1 Over Budget 1
Property Age Location Cost Sum
20% 40% 40%
123 Main St 3 0.6 3 1.2 1 0.4 2.2
2506 Pearl Dr 2 0.4 3 1.2 2 0.8 2.4
455 Washington Ave 2 0.4 2 0.8 2 0.8 2
3451 Harmony Ln 1 0.2 1 0.4 3 1.2 1.8