summarize the units sold by each salesperson.

SOLUTION AT Australian Expert Writers

The data needed is uploaded below as well. Here are the questions.
Question 1: The Beauty Company
The Beauty Company is a small makeup company. The datafile Beauty Company Sales_Raw Data.xls gives the monthly sales data. Each row lists the salesperson, date of sales, product type, units sold, and revenue generated, and location of the sale.
Question 1.1: Please complete the codebook using the template on Canvas.
Question 1.2: Evaluating salesperson performance
· Create a PivotTable to summarize the units sold by each salesperson.
· Create a PivotTable to summarize the revenue generated by each salesperson.
· Which one of the salespersons had the best performance?
· Does the Pareto Principle apply to this scenario?
Question 1.3: Store location
· Create a PivotTable to summarize the units sold by location of the sale.
· Create a PivotTable to summarize the revenue generated by location of the sale.
· The Beauty Company plans to increase inventory in one of the locations, which location will you recommend to the management?
Question 1.4: The best seller.
· Create a PivotTable to show the unit sold by product type?
· Please use “Slicer” to find out revenue generated by “lip gloss” sold by “Colleen” in the “Midwest” region?
Question 2: Station Wagon
The State Wagon_Raw Data.elsx file contains data for each family including the family size (large or small), income (high or low), and whether the family bought a station wagon. Use this file to perform the following exercise.
Question 2.1: Please complete the codebook using the template on Canvas.
Question 2.2: Does it appear that family size or income is a more important determinant of station wagon purchases (please use PivotTable function).
Question 2.3: Compute the percentage of station wagon purchasers that are high or low income.
Question 2.4: Compute the fraction of station wagon purchasers that come from each of the following four categories:
· High income and large family;
· High income and small family;
· Low income and large family;
· Low income and small family.
Question 3: The ESPN Subscription
The ESPN Subscription_Raw Data.elsx file contains data for each subscriber of ESPN: The Magazine including the age, gender, income, and location. Use this file to perform the following exercise.
Question 3.1: Please complete the codebook using the template on Canvas.
Question 3.2: Which income group showed the largest number of subscriptions?
Question 3.3: Which gender group showed the largest number of subscriptions?
Question 3.4: Create a profile for the target market of ESPN: The Magazine using the four variables.

Order from Australian Expert Writers
Best Australian Academic Writers

QUALITY: 100% ORIGINAL PAPERNO PLAGIARISM – CUSTOM PAPER