Sue and Joe are a young married couple who are considering purchasing a new home. Their search has been reduced to three homes that they both like, at different locations. They have identified the factors they consider important and assigned a factor score to each location based on a 5-point scale. The information is shown in the table.

(a) Construct a spreadsheet model to help Sue and Joe make their decision. What is your recommendation?
(b) Construct a stacked column chart to illustrate thealternatives.

Transcribed Image Text:

Factor Score at Each Location Location Location Location Factor Factor Proximity to work Proximity to family Size of home Transportation system Neighborhood Cost 3 Weight 10 25 15 4 2 4 10 20 20