(LO 2-7) Download the “DJI Mavic 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 sale. 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 DJI-AIR?

2. What is the total gross margin for sales of SKU DJI-MMC?

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

4. Which product (SKU) had the lowest gross margin during the month?