Based on the provided excel file, answer the attached questions in paragraph format and include all required graphs and formulas please.
1. Using Microsoft Excel, use the pivot table function to answer the following questions?
a. What were the total sales ($) in all regions for 2016?
b. What were the top two regions in total sales dollars for
2016?
c. What region sold the most units in 2016?
2. Using Microsoft Excel, use the pivot table function to answer the following questions?
a. What were the total sales ($) in all regions for 2017?
b. What were the top two regions in total sales dollars for
2017?
c. What region sold the most units in 2017?
3. Who are the top 3 sales representatives by $ for 2015, 2016 and 2017 combined?
4. Who are the bottom 3 sales representatives by $ for 2015, 2016 and 2017 combined?
5. Best-selling item of 2015 by units sold
6. Best-selling item of 2015 by ($)
7. Best selling item of 2016 by units sold
8. Best selling item of 2016 by ($)
9. Best selling item of 2017 by units sold
10. Best selling item of 2017 by ($)
11. Using a Line Graph, Plot Sales in ($) by month for 2015, 2016 and
2017.
12. Using a Line Graph, Plot Sales in units by month for 2015, 2016 and
2017.
a. Explain the overall sales trends from 2015 to 2017?
b. What items sold more?
c. What items sold less?
d. How do the 2017 sales compare to 2016 sales ($)?
e. How do the 2017 sales compare to 2015 sales ($)?
13. Based on Q1 of sales data Is 2018 on track to be better or worse
year, compared to year X in terms of:
a) Units sold for each year 2015, 2016 and 2017
b) Revenue for each year 2015, 2016 and 2017
14. Provide a forecast for total sales ($) for 2018. What is the basis for this forecast? Explain?
