Marketing Strategy: Multiattribute Table

In Excel, use spreadsheets to calculate each segment’s attitude towards the brand across the sevenfeatures. Print out three separate charts (one for each segment) that show the calculations and overallattitudinal score for each brand.Questions:

1. An individual from segment A is currently considering purchasing from one of the ten brands.According to the data, which two brands would s/he likely have the strongest attitude towards?Which brand does s/he have the lowest attitude towards?

2. What are the multiattribute scores for Tesla for segments A, B and C?

3. How do the three segments differ in terms of the relative importance of the various productfeatures when evaluating brands?

4. For segment B, which has a higher evaluation – Tesla or Mercedes Benz? How about forsegment C? What explains the difference?

5. For segment C, what is Tesla’s main competitive advantage? Explain.

6. For segment B, what would be a false advantage for Mercedes Benz? Explain.

7. Based on the data from the multiattribute table, what would you recommend that Tesla changeto attract more consumers from segment B away from Mercedes Benz? (ie. Where do they needto improve their scores?)