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

Download the Skydio Drone dataset.xlsx$.$ The dataset contains sales transactions for the month of October for a company called Skydio that sells drones. SKUs $($stock$-$keeping units$)$ are the internal product codes used by Skydio to uniquely identify its products. You are going to use the data to evaluate the profitability of the company using gross $($profit$)$ margin and gross $($profit$)$ margin percentage.

Because of the way the data is structured $($one item per row$),$ an invoice may appear more than once in the dataset. If a customer purchases one item, the invoice appears once in the dataset. If an invoice includes more than one item, then the invoice appears more than one once in the dataset. For example, invoice $6007$ has two rows in the dataset, one for SK$2-$USB and one for SKY$-$CHG$.$ Invoice $6054$ has three rows in the dataset, two rows for SKY$2-$CIK and one for SKY$0-$CHG$.$

To answer the questions, you must first add two columns in Excel to calculate the gross margin and gross margin percentage.

Column H Gross Margin $=$ Sales Price $$ Cost

Column I Gross Margin Percentage $=$ Gross Margin $-$: Sales Price

Let$$s analyze the sales transactions by SKU. Create a pivot table in Excel showing the average sales price, cost, gross margin, and gross margin percentage for each SKU. For ease of use, format all numbers with two decimals. Use the pivot table to answer the following questions:

Required:

How many SKUs are there?

Which SKU has the highest average selling price? $($Hint: Sort the appropriate column.$)$

Which SKU has the lowest average cost?

Which SKU has the highest average gross margin?

Which SKU has the highest average gross margin percentage?

What is the Grand Total, or overall, average gross margin percentage?

Note: Round your answer to $2$ decimal places.