sales analysis you have been hired as a marketing analyst and your first assignment 2920637

Sales Analysis You have been hired as a marketing analyst and your first assignment is to submit a short memo to the marketing manager. In your memo, make sure to answer the following questions. 1. What’s sales growth been like over the three years? 2. What are revenues for each of our top three countries? 3. What revenues for each of our top three products categories? 4. What are the profits for each of our top three product categories? 5. What are our most profitable products? 6. How much have each of our top three customers bought from us? 7. Should we drop our smallest (by revenue) countries? 8. Where and why would you invest sales resources? You have been provided with records detailing each sale over the last three years. You will need to download the Excel table to access the data. You may have some familiarity with Excel but if you are not up to speed on its data analysis capabilities there are a lot of videos on YouTube. The filter, sort, pivot table and sum tools are your friends. Here is how you will be marked Proper memo format – 2 points Answer all questions accurately – 16 points No spelling or punctuation errors – 2 points Two to three charts – 5 points.

Submit a Comment