The world’s Largest Sharp Brain Virtual Experts Marketplace Just a click Away
Levels Tought:
Elementary,Middle School,High School,College,University,PHD
| Teaching Since: | May 2017 |
| Last Sign in: | 408 Weeks Ago, 4 Days Ago |
| Questions Answered: | 66690 |
| Tutorials Posted: | 66688 |
MCS,PHD
Argosy University/ Phoniex University/
Nov-2005 - Oct-2011
Professor
Phoniex University
Oct-2001 - Nov-2016
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.
| Â |
Factor Score At Each Location |
 | ||
|
Factor |
Location 1 |
Location 2 |
Location 3 |
Factor Weight |
|
Proximity to work |
5 |
2 |
1 |
10 |
|
Proximity to family |
4 |
2 |
5 |
25 |
|
Size of home |
2 |
5 |
5 |
15 |
|
Transportion system |
5 |
3 |
1 |
10 |
|
Neighborhood |
3 |
5 |
2 |
20 |
|
Cost |
1 |
2 |
4 |
20 |
(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 the alternatives.
Hel-----------lo -----------Sir-----------/Ma-----------dam----------- Â----------- -----------Â ----------- Â ----------- T-----------han-----------k Y-----------ou -----------for----------- us-----------ing----------- ou-----------r w-----------ebs-----------ite----------- an-----------d a-----------cqu-----------isi-----------tio-----------n o-----------f m-----------y p-----------ost-----------ed -----------sol-----------uti-----------on.----------- Pl-----------eas-----------e p-----------ing----------- me----------- on----------- ch-----------at -----------I a-----------m o-----------nli-----------ne -----------or -----------inb-----------ox -----------me -----------a m-----------ess-----------age-----------