What proportion of sales were for each firm

Assignment Help Marketing Management

Reference no: EM131979560

Question: Please complete the following:

1. 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).

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

3. 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?

4. 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).

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

2. 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?

Reference no: EM131979560

Questions Cloud

Compute the basic eps and diluted eps for ramon inc : Ramon Inc. reported net income of $300,000 for the year ended December 31, 2006. Compute the basic EPS and diluted EPS for Ramon Inc. for 2006

Risky portfolio by investing half of her money in stocks : Ashley wants to form a risky portfolio by investing half of her money in stocks and half in bonds.

Prepare robydek journal entry to record the issuance : In December 2014, Robydek declared its first dividend of $550,000. Prepare Robydek's journal entry to record the issuance of the preferred stock

What is not true about cost-benefit analysis : What is not true about cost-benefit analysis? 1) Sensitivity analysis is only necessary in cost-effectiveness analysis but not in cost-benefit analysis.

What proportion of sales were for each firm : You are given a transaction dataset that is very similar to your term project but smaller - all the variables names have the same meaning.

Expiration of a type of hiv drugs : Morris pharmaceutical company will soon face the patent expiration of a type of HIV drugs, which is considered as no substitute

Prepare journal entries for december funding : Becky Company began a defined benefit pension plan on January 1, 2010. Prepare journal entries for December Funding equaled expense

Cost-effectiveness analysis : Once of the following isn't correct about cost-effectiveness analysis? which one is not correct?

What do you think happens to the money multiplier : What do you think happens to the money multiplier (M) in a financial crisis and what is the likely impact of change in M to the economy?

User Account

All Pages