PR $1-7($LO $1\mathrm{.}3)$ Download the SkyDio Drone Sales Journal dataset...

Download the SkyDio Drone Sales Journal dataset in Excel. Note the sales price and cost of each sale.

Required:

In Excel, calculate the gross margin $($Sales Price $-$ Cost$)$ for each line of the invoice. Use a pivot table to determine the following. It may be helpful to perform this project after completing Lab $1\mathrm{.}3$ Excel, Lab $1\mathrm{.}3$ Tableau, or Lab $1\mathrm{.}3$ Power BI$.$

$\backslash$begin$\{$tabular$\}\{|$l$|$l$|\}$

$\backslash$hline $\backslash$multicolumn$\{1\}\{|$c$|\}\{$ Question $\}$ & $\backslash$multicolumn$\{1\}\{$c$|\}\{$ Answer $\}\backslash \backslash$

$\backslash$hline a$.$ What is the total gross margin earned from customer $3022?$ & $\backslash \backslash$

$\backslash$hline b$.$ What are the total sales for customer $3000?$ & $\backslash \backslash$

$\backslash$hline c$.$ What is the total cost of sales for customer $3039?$ & Customer $3013\backslash \backslash$

$\backslash$hline d$.$ Which customer bought the most during the month? & Customer $3008\backslash \backslash$

$\backslash$hline e$.$ Which customer bought the least during the month? & $\backslash \backslash$

$\backslash$hline $\backslash$begin$\{$tabular$\}\{$l$\}$

f$.$ What was the total amount of customer sales for the month for the company? $\backslash \backslash$

Note: Round to $2$ decimal places.

$\backslash$end$\{$tabular$\}$ & $\backslash \backslash$

$\backslash$hline

$\backslash$end$\{$tabular$\}$