Required information

LAB $1-1($LO $1-9)$ Alternate: Descriptive analytics: Determining the most profitable products $($SKU$)$ and customers

Skip to question

$[$The following information applies to the questions displayed below.$]$

Lab Insight: Using the same dataset as Lab $1-1,$ for Alt Lab $1-1$ calculate the gross margin by customer $($instead of SKU profitability as calculated in Lab $1-1)$ using an Excel pivot table.

Required:

Calculate total gross margin by customer for the month. $($Hint: In your pivot table, put customer # in your rows and sum of gross margin in your $\backslash$Sigma Values area$).$

Sort the gross margin by customer from high to low total gross margin.

Data: Lab $1-1$ Data.xlsx

Perform the Analysis: Refer to Lab $1-1$ in the text for detailed instruction steps.

Lab $1-1$ Alternate: Upload Your Files

Upload the Word or PDF document containing your Lab screenshots using the button below.

Note: Please submit your file attachment response in one of the approved file formats; Word file $(.$doc or $.$docx$),$ Excel file $(.$xls or $.$xlsx$),$ or PDF$.$ To submit photo or image files please paste them into Word or PDF$.$ Consult with your instructor as needed on their preferred file attachment format.

Take a screenshot of the first $30$ lines of the final pivot table sorting gross margins by customer from high to low, and paste it into a Word document named $$Alt Lab $1-1$ Excel SS$.$doc$.$