Summarize the percentage of each persons sales

Assignment Help Business Management

Reference no: EM131380322

The Makeup2007.xlsx fi le (available for download on the companion website) 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 fi le to perform the following exercises:

a. Summarize the total revenue and units sold by each person of each product.

b. Summarize the percentage of each person's sales that came from each location. Create a PivotChart to summarize this information.

c. Summarize each girl's sales by location and use the Report Filter to change the calculations to include any subset of products.

Reference no: EM131380322

Questions Cloud

Improvement framework and problem solving framework : Compare and contrast the fundamental differences between process improvement framework and problem solving framework. Provide one (1) example of business management applying each framework to support your response.

How developing new procedural and declarative memories : While their existence remains disputed, how might the existence of memory traces bear on developing new procedural and declarative memories? Why is this significant for understanding human cognition

Compute the percentage of station wagon purchasers : Does it appear that family size or income is a more important determinant of station wagon purchases?- Compute the percentage of station wagon purchasers that are high or low income.

Analyze the significance of the growing support for assange : Analyze the significance of the growing support for Assange and then examine the degree to which the support he receives is likely a result of his actions of committing a victimless and costless crime. Next, give your opinion as to whether Assange..

Summarize the percentage of each persons sales : Summarize the percentage of each person's sales that came from each location. Create a PivotChart to summarize this information.

Redeploy workers when they install self-checkout systems : For years, fast, friendly, personal service has been the hallmark of successful businesses. But as an increasing number of businesses (and even entire industries) have invested in self-service technology, a growing number of consumers have gotten use..

Discuss the option for beginning the change reorganization : Discuss the option for beginning the change reorganization using a series of specific steps or interventions - Determine the first 5 interventions you would recommend to begin the change-management reorganization and your rationale for why you woul..

Evaluate the actions of shell management in given case : Use ethical reasoning to evaluate the actions of Shell management in this case with respect to accounting for and disclosing information about proved reserves.

Describe support and confidence : Describe the two main methods of representing market basket data. What are the benefits and drawbacks of each?

User Account

All Pages