Question: Using a spreadsheet (e. g., Excel), design a decision aid to help you complete the following task. You are looking for a new apartment and

Using a spreadsheet (e. g., Excel), design a decision aid to help you complete the following task. You are looking for a new apartment and decided to go through a realtor instead of shopping for the apartment through advertisements. Cain Realty provided you with the following list of seven available apartments in the area you specified. The apartments have been evaluated by Cain Realty using 12 different criteria (listed as 2– 13 on the spreadsheet in Figure). Here are some suggestions on how to set up your decision aid: (1) Decide which of the 12 factors you want to include in your decision model. (2) For each factor selected in step (1), decide how much decision weight you want to assign it relative to the other factors. Suggestion: You may want to distribute the decision weights so that they add up to 100 (i. e., 100%). Be prepared to discuss and justify your decisions about factors and weights, especially in comparison to the factors and weights used by other students.


Step by Step Solution

3.38 Rating (154 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

The simplest decision model would be to assign all twelve factors equal decision w... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Document Format (1 attachment)

Word file Icon

353-B-A-I-S (4478).docx

120 KBs Word File

Students Have Also Explored These Related Accounting Questions!