Chat with us, powered by LiveChat Please see below for additional instructions as you navigate the document. - Tutorie

Please see below for additional instructions as you navigate the document.

Please see below for additional instructions as you navigate the document.

 

 

*Please ensure you are not pasting over the formulas*

 

Instructions:

 

Using the information in the DATA tab, please complete the following:

 

Seasonal Pivot tab

  1. Please create a pivot table which shows TY and LY: WTD, MTD, and STD units and $ sales and On Hand (OH) by season. Please ensure numbers are formatted.
  2. Please sort the pivot by descending TY WTD sales $.
  3. Please answer the question in Row 6: What is the % increase for Cruise 2019 OH units TY vs LY?
  4. Which classification has shown the biggest % growth over LY (in $)?

 

Classification Recap tab

  1. Please fill in the chart.
  2. Ensure numbers are formatted and round to the nearest whole number.
  3. Please answer the question in Row 28: What is the #1 $ selling classification TY?

 

Note: Please do not hard key over formulas (eg. sum, vlookup, sumif, etc.)

Are you struggling with this assignment?

Our team of qualified writers will write an original paper for you. Good grades guaranteed! Complete paper delivered straight to your email.

Place Order Now