Summarize percentage of each person sales

Assignment Help Business Management

Reference no: EM132786140

1. The Makeup2007 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 file 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.

Attachment:- Exercise.rar

Reference no: EM132786140

Questions Cloud

Identify any new strategies that you think will fit better : Balancing School and Life - My Quality of Life Self-Care Plan. The purpose of developing this Plan is to set a framework and a plan to maintain wellness.

How understand through the strongest drivers : Think of one challenge, past or present (personally or professionally), and diagnose your ability to resolve the challenge through the drivers.

Calculate the cash flow from operations for year : Perfect Office Products provided the following balance sheets and income statement: Calculate the cash flow from operations for Year 2

Why does society view physical health more important : Why does society view physical health as more important than psychological health? Why do you think society views emotional health differently than physical.

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

Why is important to quickly understand contract expectations : Why is it important to quickly understand the contract expectations from the company, supervisor and employee standpoints? What happens when the contract broken

Explain how issue or event within globalization : Select an issue or event to analyze through the four general education lenses stated above. explain how an issue or event within globalization

Prepare the journal entry to record the depreciation : Assuming the fiscal year end was December 31, 2018, prepare the journal entry to record the depreciation of the new equipment

Explain the delegation issues with examples : Below are some common delegation issues with examples. Give your own examples of over-delegation, under-delegation, and refusal to accept a legitimate.

User Account

All Pages