1.What is the total revenue generated by the salesperson? 2. What is the gross profit for the dealer (total revenue – dealer cost): The gross profit is $11,500. 3. What is the net commission for the dealer: Gross profit of $11,500 - $2,875 (commission) = $8,625 Net Dealer’s contribution 4.What would the sales person have earned in commission if the base price was lowered from $30,000 to $29,000? (3) Do marketing metrics exercise on page 463, and offer a technical conclusion from the solution. 1. Analyze the columns and state your observations: After entering all the data into the Excel spreadsheet, I noticed that the Baby Boomer group of participants rated the 3 questions regarding their financial outlook, brand preference and online banking to be very low and similar. On the contrary, the Generation Y participants rated the same questions very high (4-5s) and the responses to all the questions were very similar too. When I compared columns C-G and D-H, I noticed that there were differences since we were combining one column of the opposite group. This is due to the way the Baby Boomers and the Generation Y participants think differently. The older generation is much more “old school” and not very responsive to technology and innovations (even if it would be easier for them). On the other hand, the younger Generation Y are willing to explore different options while facing challenges and obstacles in the future.
2. Standard deviation observation between columns B-D and F-H: When observing columns B-D and columns F-H from the data from the excel spreadsheet, I notice that there is not much deviation from the 3 columns from each of the cohorts. This is because of the way each group thinks. Even though there the ratings are very similar in range, the way of thinking and acting is much more similar within each of the distinctive groups, therefore, both of these groups measure up very small in difference within each other, but opposites to either groups. 3.Why cohort appears to be more optimistic about their financial outlook?
You've reached the end of your free preview.
Want to read all 3 pages?
- Spring '11