Please see below for additional instructions as you navigate the document.
Need help with this assignment?Get an original answer from a qualified tutor — from $10/page.
Get it written →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.)
Get a plagiarism-free answer to this question
Send us your instructions and we’ll match you with the best writer in your subject.
- 100% human-written, zero AI
- Turnitin report included
- Confidential — we never share your data
- Free revisions & refunds