Marketing Research Utilizing the Homework2.xls attached at the bottom, answer and perform the following questions and summarizations. Within the excel file, label each request (1a, 1b, etc.) as a separate worksheet within the excel file. 1.The Makeup worksheet gives sales data for a small makeup company. Each row lists the salesperson, product sold, location of the sale, units sold, and revenue generated. Use this data to perform the following exercises:a.Summarize the total revenue and units sold by each person for each product. How many lipsticks did Betsy sell? What is the total amount of revenue for Jen?b.Summarize the percentage of each person’s revenue sales that came from each location. Create a PivotChart to summarize this information. What area is Cristina’s strongest?c.Summarize each girl’s unit sales (not revenue) by location and use the Report Filter to include the subsets of products. What location has the most number units sold? What location has the most unit sales of eyeliner? 2.The Tape worksheet contains data for the unit sales of 3M tape, price charged, whether an ad campaign was run that week (1 = ad campaign), and whether the product was displayed on the end of the aisle (1 = end cap). Use this date to perform the following exercises:a.Analyze the nature of the monthly of tape sales. Use average monthly sales for your table and chart. Is there a season where tape sales is high? Low?b.What are the total unit sales using an ad vs. no ad? What are the average unit sales using an ad vs. no ad? Does an ad campaign appear to increase sales? How many weeks was an ad used? c.What are the total unit sales using an end cap vs. no end cap? What are the average unit sales using an end cap vs. no end cap? Does placing items on the end cap appear to increase sales?
Are you looking for a similar paper or any other quality academic essay? Then look no further. Our research paper writing service is what you require. Our team of experienced writers is on standby to deliver to you an original paper as per your specified instructions with zero plagiarism guaranteed. This is the perfect way you can prepare your own unique academic paper and score the grades you deserve.
Use the order calculator below and get started! Contact our live support team for any assistance or inquiry.
[order_calculator]