Office Warehouse Inc. currently makes four products. The Sales Director has asked you to run a...

Transcribed Image Text:

Office Warehouse Inc. currently makes four products. The Sales Director has asked you to run a preliminary analysis on last year's sales data, which has been cleaned and is given on the Original Data tab. The products made by the company and sales price per unit are listed below. Use the different data visualization methods recommended in each requirement to analyze the company's sales data. Products Available Paper Pens Sticky Notes Envelopes Units Ordered Total Sales Required Create a PivotTable to answer each question below while analyzing the data. Which product had the highest total units ordered and highest total sales? East Midwest South West Region Price per Unit 23.00 per case per box 7.00 10.50 per package 3.50 per box Which rep has the highest total sales for each region? Region Rep Name East Midwest South West $ $ $ $ What is the total annual sales for each region? Region Product East Midwest South West Total Sales Total Using the data above, create a pie chart to determine the sales percentage for each region. Sales Percentage Total Sales Office Warehouse Inc. currently makes four products. The Sales Director has asked you to run a preliminary analysis on last year's sales data, which has been cleaned and is given on the Original Data tab. The products made by the company and sales price per unit are listed below. Use the different data visualization methods recommended in each requirement to analyze the company's sales data. Products Available Paper Pens Sticky Notes Envelopes Units Ordered Total Sales Required Create a PivotTable to answer each question below while analyzing the data. Which product had the highest total units ordered and highest total sales? East Midwest South West Region Price per Unit 23.00 per case per box 7.00 10.50 per package 3.50 per box Which rep has the highest total sales for each region? Region Rep Name East Midwest South West $ $ $ $ What is the total annual sales for each region? Region Product East Midwest South West Total Sales Total Using the data above, create a pie chart to determine the sales percentage for each region. Sales Percentage Total Sales