Compare the sales trend-pricing patterns


Complete the following:

You are given a transaction dataset that is very similar to your term project but smaller - all the variables names have the same meaning.

Please complete the industry analysis (on industry level sales trend across 3 years, seasonality, pricing pattern, and channel use).

Please identify the top 3 companies and compare their sales trend, pricing patterns, channel uses on a monthly level.

Please add zipcode level median income information to this dataset (with a vlookup function), and then describe each of the top 3 companies' customer base. Which of them are selling to more affluent neighborhood?

Please use each of the top 3 companies' 2005 data to label their top, medium and bottom group of customers (you need to do this one by one for each company).

For the 2006-07 period, what proportion of sales were from old vs. new customers for each firm?

For the 2006-07 period, where did each firm's top group of customers go? Did they leave the industry? Or they were still buying but just buying from others?

Request for Solution File

Ask an Expert for Answer!!
Marketing Management: Compare the sales trend-pricing patterns
Reference No:- TGS02065497

Expected delivery within 24 Hours