The dataset includes SKUs and sales data for $2$ years at $5$ different stores. SKUs are Stock Keeping Units, unique codes used by retailers that identify characteristics about each product, such as manufacturer, brand, style, color, and size. Assume that 'Price' is the selling retail price. Assume that the store profits $50\%$ of the selling retail price. Part $1$ Fill in the following answers. In the answer column, you should provide a cell reference to your answer, so that I can follow your calculations. Question Hint Answer How many unique SKUs are there? Use a pivot table or try using $=$UNIQUE$()3$ points Which store was most profitable in Year $1?$ You will need to calculate profit based on price, profit $\%,$ and unit sales. $3$ points Which store sold the most units in Year $2?$ None $3$ points Which SKU sold the most units over $2$ years? Use a pivot table or $=$COUNTIF$()3$ points Which SKU contributed the most profit over $2$ years? You will need to calculate profit based on price, profit $\%,$ and unit sales. $3$ points PART $2$ Summarize $2$ year profitability by store in an appropriate visualization. You will need to rearrange your data and calculate profit at different time intervals. I recommend using weeks or quarters $(13$ weeks$).$ Locate your chart in its own sheet and format the sheet so that the tab is green $($so I can easily find your answer$).5$ points for graph accuracy and type, $5$ points for polished format Part $3$ Recommend $5$ SKUs to discontinue next year and why. Answer: $5$ points