Reference no: EM132078810

Which team are you selecting as your team (please select one):

A B C D E F G H

Using the data on D2L, please create a series of PivotCharts to answer the following below.

To submit, answer each question by creating a PivotChart in Microsoft Excel (reminder, this must be a Microsoft Windows computer) and copying that PivotChart below.

You will submit this Word Document.

1) Your team's sales revenue, per month per product. (One bar per product, per month.)

2) Your team's unit sales, per month per product. (One bar per product, per month.)

3) Your team's daily unit sales of a product that had an interesting sales history for the most recent month.

4) Your team's unit sales per area (i.e. region of the country) per product per month.

5) Which team (Sales Organization) sold the largest number of units of 1kg Raisin Muesli?

6) Create a chart comparing your team's revenue (value) versus cost on a daily basis (**hint: you will need to filter Sales Organization to your team).

7) Create a chart comparing your team's revenue versus cost across for each product (**hint: Material Description does not go in the Legend).

8) Create a chart showing the daily unit sales of 1kg Blueberry Muesli for the entire German Muesli market.