Brand & Consumer Purchase Dynamics Analysis The base spreadsheet for your version of
Question:
Brand & Consumer Purchase Dynamics Analysis
The base spreadsheet for your version of the exam contains information on the brand and consumer dynamics for the four major companies that participate in the Gallifrean Beer market. Information is provided for each brand showing the consumer purchase dynamics when only the named brand is purchased by its consumers and for all beer purchases by each brand's consumer base.
1. From your review of the market information and consumer dynamics in contained in your completed excel spreadsheet, provide four (4) insights about the Gallifrean beer market, its average consumer and its level of competitiveness. Remember that this question is about the overall market and the consumer NOT about individual brands.
2. Using the information contained in the entire "Gallifrean Beer - Base" spreadsheet for your version of the exam, what can you learn about Cyberman's Ale customers from analyzing their purchase behaviour for their TOTAL beer purchases and comparing them to the other three brands and the overall market? Please provide a minimum of four (4) insights and remember that to be relevant, metrics need to be compared to other metrics.
3. What can you learn about Cyberman's Ale customers from analyzing their purchase behaviour when they ONLY buy Cyberman's Ale and comparing it their buying behaviour for their TOTAL beer purchases and the buying behavior of consumers of the other three brands (for their brand and/or their total beer purchases) and buying behavior for the overall market? Please provide a minimum of four (4) insights and remember that to be relevant, metrics need to be compared to other metrics.
4. Based on the information in the spreadsheet and your analysis, what do you believe are the TWO biggest opportunities for Cyberman's Ale to improve their sales performance and why? Remember to appropriately justify your recommendation with relevant metrics and facts and to limit yourself to only two opportunities.
5. Quantify the annual increase in sales for each of the TWO biggest opportunities forCyberman's Ale that you identified. Ensure that you provide justification for the new objective for each of the two metrics that you have identified. Please show your calculations in this word document.
Introductory Econometrics A Modern Approach
ISBN: 978-0324660548
4th edition
Authors: Jeffrey M. Wooldridge