Step 1: Calculate the gross margin for each invoice.

Step 2: Our objective is to know the profitability of each customer. To have the necessary information to assess this, we need to compute the gross margin for each customer. To do so, we will use a pivot table. Using the instructions and information in the instructional sheet,

In menu, select Insert> Pivot Table. This dialog box will open:

On a Mac, select Insert> Tables>Pivot Table

Original Data to use to calculate the Gros margin...

Step 3: Create a pivot table that will look like this: Our last step is to sort Gross Margin from highest to lowest to find the most profitable customer. To do, we select one of the numbers in column B and select Data > Sort. Select descending, to get the most profitable customers on top. The pivot table will now look as follows: B 1 2 3 Customer Number 4 2047 5 2088 6 2072 7 2081 8 2100 9 2060 10 2064 11 2087 12 2046 13 2086 14 2024 15 2063 16 2031 17 2018 18 2051 19 2032 20 2021 21 2079 22 2099 Sum of Gross Margin 357.7 212.23 139.01 137.78 135.47 118.74 115.33 114.85 114.29 107.41 104.78 96.45 81.81 76.79 69.83 66.62 64.64 64 58.56 Date 10/1/2023 10/2/2023 10/2/2023 10/3/2023 10/3/2023 10/3/2023 10/3/2023 10/3/2023 10/3/2023 10/3/2023 10/3/2023 10/3/2023 10/3/2023 10/3/2023 10/3/2023 10/4/2023 10/4/2023 10/4/2023 10/4/2023 10/5/2023 10/5/2023 10/5/2023 10/5/2023 10/5/2023 10/6/2023 10/6/2023 10/6/2023 Invoice # Customer # 8001 3006 8002 3022 8002 3022 8003 3096 8004 3080 8005 3055 8006 3076 8007 3066 8007 3066 8008 3095 8009 3051 8009 3051 8010 3066 8011 3053 8012 3008 8013 3013 8013 3013 8013 3013 8014 3014 8015 3029 8015 3029 8016 3054 8017 3027 8018 3075 8019 3074 8019 3074 8019 3074 SKU PED-TPR WHL-T3S WHL-TGT FLI-TMX FLI-USB WHL-T30 WHL-TMX FLI-16H FLI-HOX FLI-16M WHL-TGT PED-FCS FLI-H01 WHL-TGT FLI-H04 PED-TPR FLI-16H WHL-TMX FLI-TMX FLI-16M PED-FCS FLI-STX PED-FER FLI-THR WHL-TGT PED-T80 PED-T80 Description TPR Pedals - Windows VG T300RS Racing Wheel Servo Base for PS4 and PS3 T-GT Racing Wheel (PS4/PC) TMX Force Feedback Racing Wheel USB Joystick T300RS Officially Licensed PS4/PS3 Force Feedback Racing Wheel TMX Pro Racing Wheel T1600M FCS Hotas T-Flight Hotas x Flight Stick T 16000M Space SIM Duo Stick T-GT Racing Wheel (PS4/PC) T16000M FCS T-Flight Hotas One T-GT Racing Wheel (PS4/PC) T-Flight Hotas 4 Flight Stick TPR Pedals - Windows T1600M FCS Hotas TMX Pro Racing Wheel TMX Force Feedback Racing Wheel T 16000M Space SIM Duo Stick T16000M FCS T-Flight Stick X PS3 Ferrari Racing Wheel Red Legend Edition TWCS Throttle T-GT Racing Wheel (PS4/PC) T80 Ferrari 488 GTB Edition Racing Wheel PS4 T80 Ferrari 488 GTB Edition Racing Wheel PS4 Sales Price 497.38 159.99 614.91 159.84 21.99 319.99 249.99 97.3 39.99 117.83 614.91 39.19 59.99 614.91 34.65 497.38 97.3 249.99 159.84 117.83 39.19 39.99 79.99 59.99 614.91 94.99 94.99 Cost 284.93 92.63 354.66 87.3 12.06 170.61 147.62 52.53 20.53 69.36 354.66 23.36 30.17 354.66 19.76 284.93 52.53 147.62 87.3 69.36 23.36 21.04 43.51 35.18 354.66 52.58 52.58