(LO 2-7) Download the “Skydio Drone Sales Journal” dataset in Excel. Note the sales price and cost of each sale. In Excel, calculate the gross margin (Sales Price – Cost) for each line of the invoice. Use a PivotTable to determine the following. It may be helpful to perform this project after completing Lab 2-1 Excel, Lab 2-2 Excel, or Lab 2-3 Excel.

Required:

1. What are the total sales for SKU SK2-CIK?

2. What is the total cost for all sales of SKU SKY-BAT?

3. What is the total gross margin for SKU SK2-BEA?

4. Which product (SKU) had the highest sales during the month?

5. Which product (SKU) had the lowest cost of sales during the month?

6. Which product (SKU) had the highest gross margin during the month?