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
- 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.
- Please sort the pivot by descending TY WTD sales $.
- Please answer the question in Row 6: What is the % increase for Cruise 2019 OH units TY vs LY?
- Which classification has shown the biggest % growth over LY (in $)?
Classification Recap tab
- Please fill in the chart.
- Ensure numbers are formatted and round to the nearest whole number.
- 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.)