1 Invoice # Customer # SKU Description Sales Price Cost Gross Margin 2 8001 3006 PED-TPR TPR Pedals - 497.38 284.93 -212.45 3 8002 3022 WHL-T3S VG T300RS R 159.99 92.63 -67.36 4 8002 3022 WHL-TGT T-GT Racing 614.91 354.66 -260.25 5 8003 3096 FLI-TMX TMX Force Fe 159.84 87.3 -72.54 6 8004 3080 FLI-USB USB Joystick 21.99 12.06 -9.93 7 8005 3055 WHL-T30 T300RS Offici 319.99 170.61 -149.38 8 8006 3076 WHL-TMX TMX Pro Raci 249.99 147.62 -102.37 9 8007 3066 FLI-16H T1600M FCS 97.3 52.53 -44.77 10 8007 3066 FLI-HOX T-Flight Hota 39.99 20.53 -19.46 11 8008 3095 FLI-16M T 16000M SP 117.83 69.36 -48.47 12 8009 3051 WHL-TGT T-GT Racing 614.91 354.66 -260.25 13 8009 3051 PED-FCS T16000M FCS 39.19 23.36 -15.83 14 8010 3066 FLI-H01 T-Flight Hota 59.99 30.17 -29.82 15 8011 3053 WHL-TGT T-GT Racing 614.91 354.66 -260.25 16 8012 3008 FLI-HO4 T-Flight Hota 34.65 19.76 -14.89 17 8013 3013 PED-TPR TPR Pedals - 497.38 284.93 -212.45 18 8013 3013 FLI-16H T1600M FCS 97.3 52.53 -44.77 19 8013 3013 WHL-TMX TMX Pro Raci 249.99 147.62 -102.37 20 8014 3014 FLI-TMX TMX Force Fe 159.84 87.3 -72.54 21 8015 3029 FLI-16M T 16000M SP 117.83 69.36 -48.47 22 8015 3029 PED-FCS T16000M FC 39.19 23.36 -15.83 23 8016 3054 FLI-STX T-Flight Stick 39.99 21.04 -18.95 24 8017 3027 PED-FER Ferrari Racini 79.99 43.51 -36.48 25 8018 3075 FLI-THR TWCS Thrott 59.99 35.18 -24.81 26 8019 3074 WHL-TGT T-GT Racing 614.91 354.66 -260.25 27 8019 3074 PED-T80 T80 Ferrari 4 94.99 52.58 -42.41 28 8019 3074 PED-T80 T80 Ferrari 4 94.99 52.58 -42.41 29 8020 3081 PED-TER TERP Rudder 69.99 41.18 -28.81 30 8021 3026 FLI-16H T1600M FCS 97.3 52.53 -44.77 31 8021 3026 FLI-HO1 T-Flight Hota 59.99 30.17 -29.82 32 8021 3026 FLI-H01 T-Flight Hota 59.99 30.17 -29.82 33 8021 3026 COM-FCS T16000M FC 172.35 89.15 -83.2 34 8021 3026 FLI-STX T-Flight Stick 39.99 21.04 -18.95 35 8021 3026 PED-T3P FB T3PA-Pro 129.99 66.14 -63.85 36 8022 3083 PCG-HOW Hotas Warth 462.81 232.13 -230.68 37 8023 3077 PED-FCS T16000M FC 39.19 23.36 -15.83 38 8024 3046 COM-FCS T16000M FC 172.35 89.15 -83.2 39 8024 3046 WHL-TMX TMX Pro Raci 249.99 147.62 -102.37 40 8025 3098 PED-TPR TPR Pedals - 497.38 284.93 -212.45 Sheet1 Sheet2 CERERE 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 8025 8026 8027 8028 8029 8030 8030 8030 8031 8032 8033 8033 8034 8035 8035 8036 8037 8038 8039 8039 8039 8040 8041 8042 8043 8044 8045 8045 8046 8046 8047 8048 8049 8050 8051 8052 8053 8053 8053 8054 3098 FLI-HO4 3066 WHL-T3S 3013 WHL-TGT 3062 FLI-HO1 3056 FLI-16H 3049 WHL-T3S 3049 FLI-HO4 3049 FLI-USB 3022 FLI-STX 3035 WHL-TGT 3021 WHL-T3S 3021 FLI-H01 3000 PED-T3A 3071 PED-TER 3071 FLI-HO1 3045 FLI-STX 3061 PED-T3P 3074 WHL-T3P 3037 FLI-USB 3037 PED-FCS 3037 FLI-THR 3038 FLI-HOX 3011 PED-FER 3077 FLI-16M 3097 COM-FCS 3061 FLI-USB 3079 PED-TPR 3079 FLI-STX 3075 PED-T3P 3075 WHL-T3S 3098 FLI-THR 3026 FLI-THR 3003 FLI-THR 3063 PED-T80 3088 PED-FCS 3010 WHL-T3S 3044 COM-FCS 3044 FLI-TMX 3044 FLI-HOX 3082 FLI-16H """""""" T-Flight Hota VG T300RS R T-GT Racing T-Flight Hota T1600M FCS VG T300RS R T-Flight Hota USB Joystick T-Flight Stick T-GT Racing VG T300RS R T-Flight Hota T3PA Add-Or TFRP Rudder T-Flight Hota T-Flight Stick FB T3PA-Pro T300RS Racir USB Joystick T16000M FC TWCS Thrott T-Flight Hota Ferrari Racin T 16000M Sp T16000M FC USB Joystick TPR Pedals - T-Flight Stick FB T3PA-Pro VG T300RSR TWCS Thrott TWCS Thrott TWCS Thrott T80 Ferrari 4 T16000M FC VG T300RS R T16000M FC TMX Force Fe T-Flight Hota T1600M FCS 34.65 159.99 614.91 59.99 97.3 159.99 34.65 21.99 39.99 614.91 159.99 59.99 69.99 69.99 59.99 39.99 129.99 426.41 21.99 39.19 59.99 39.99 79.99 117.83 172.35 21.99 497.38 39.99 129.99 159.99 59.99 59.99 59.99 94.99 39.19 159.99 172.35 159.84 39.99 97.3 19.76 92.63 354.66 30.17 52.53 92.63 19.76 12.06 21.04 354.66 92.63 30.17 36.4 41.18 30.17 21.04 66.14 231.54 12.06 23.36 35.18 20.53 43.51 69.36 89.15 12.06 284.93 21.04 66.14 92.63 35.18 35.18 35.18 52.58 23.36 92.63 89.15 87.3 20.53 52.53 -14.89 -67.36 -260.25 -29.82 -44.77 -67.36 -14.89 -9.93 -18.95 -260.25 -67.36 -29.82 -33.59 -28.81 -29.82 -18.95 -63.85 -194.87 -9.93 -15.83 -24.81 -19.46 -36.48 -48.47 -83.2 -9.93 -212.45 -18.95 -63.85 -67.36 -24.81 -24.81 -24.81 -42.41 -15.83 -67.36 -83.2 -72.54 -19.46 -44.77 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 10/11/23 10/11/23 10/11/23 10/11/23 10/11/23 10/11/23 10/11/23 10/11/23 10/11/23 10/11/23 10/11/23 10/11/23 10/11/23 10/11/23 10/11/23 10/11/23 10/11/23 10/12/23 10/12/23 10/12/23 10/12/23 10/12/23 10/12/23 10/12/23 10/12/23 10/12/23 10/12/23 10/13/23 10/13/23 10/13/23 10/13/23 10/13/23 10/14/23 10/14/23 10/14/23 10/14/23 10/14/23 10/14/23 10/14/23 10/14/23 8054 8054 8055 8056 8057 8058 8059 8059 8059 8060 8061 8061 8062 8063 8063 8063 8064 8065 8065 8066 8067 3082 FLI-H01 3082 PED-T3A 3091 PED-TER 3034 PED-FCS 3020 WHL-TGT 3041 COM-FCS 3015 PED-FCS 3015 FLI-16M 3015 WHL-TMX 3049 WHL-TGT 3050 COM-FCS 3050 PED-T3A 3076 FLI-16H 3036 FLI-16H 3036 FLI-STX 3036 WHL-T30 3025 COM-FCS 3081 PED-TPR 3081 WHL-T30 3093 FLI-TMX 3037 WHL-TGT 3087 FLI-STX 3087 FLI-H04 3087 PCG-HOW 3090 FLI-H01 3025 PED-TER 3096 WHL-T3P 3095 PED-T3A 3095 FLI-TMX 3095 WHL-T30 3060 PCG-HOW 3027 FLI-HO4 3095 PED-FER 3095 FLI-THR 3095 FLI-H04 3065 COM-FCS 3043 FLI-16M 3080 FLI-H01 3080 FLI-16M 3063 FLI-USB T-Flight Hota T3PA Add-Or TFRP Rudder T16000M FC T-GT Racing T16000M FC T16000M FC T 16000M Sp TMX Pro Raci T-GT Racing T16000M FC T3PA Add-Or T1600M FCS T1600M FCS T-Flight Stick T300RS Offic T16000M FC TPR Pedals - T300RS Offici TMX Force Fe T-GT Racing T-Flight Stick T-Flight Hota Hotas Warth T-Flight Hota TFRP Rudder T300RS Racir T3PA Add-Or TMX Force Fe T300RS Offici Hotas Warth T-Flight Hota Ferrari Racing TWCS Thrott T-Flight Hota T16000M FC T 16000M SP T-Flight Hota T 16000M Sp USB Jovstick 59.99 69.99 69.99 39.19 614.91 172.35 39.19 117.83 249.99 614.91 172.35 69.99 97.3 97.3 39.99 319.99 172.35 497.38 319.99 159.84 614.91 39.99 34.65 462.81 59.99 69.99 426.41 69.99 159.84 319.99 462.81 34.65 79.99 59.99 34.65 172.35 117.83 59.99 117.83 21.99 30.17 36.4 41.18 23.36 354.66 89.15 23.36 69.36 147.62 354.66 89.15 36.4 52.53 52.53 21.04 170.61 89.15 284.93 170.61 87.3 354.66 21.04 19.76 232.13 30.17 41.18 231.54 36.4 87.3 170.61 232.13 19.76 43.51 35.18 19.76 89.15 69.36 30.17 69.36 12.06 -29.82 -33.59 -28.81 -15.83 -260.25 -83.2 -15.83 -48.47 -102.37 -260.25 -83.2 -33.59 -44.77 -44.77 -18.95 -149.38 -83.2 -212.45 -149.38 -72.54 -260.25 -18.95 -14.89 -230.68 -29.82 -28.81 -194.87 -33.59 -72.54 -149.38 -230.68 -14.89 -36.48 -24.81 -14.89 -83.2 -48.47 -29.82 -48.47 -9.93 8068 8068 8068 8069 8070 8071 8072 8072 8072 8073 8074 8075 8075 8075 8076 8077 8078 8078 8079 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 10/14/23 10/14/23 10/14/23 10/14/23 10/14/23 10/14/23 10/14/23 10/14/23 10/14/23 10/14/23 10/14/23 10/15/23 10/15/23 10/15/23 10/15/23 10/15/23 10/15/23 10/15/23 10/15/23 10/15/23 10/15/23 10/15/23 10/16/23 10/16/23 10/16/23 10/16/23 10/16/23 10/16/23 10/17/23 10/17/23 10/17/23 10/17/23 10/17/23 10/17/23 10/17/23 10/18/23 10/19/23 10/20/23 10/21/23 10/21/23 8080 8080 8081 8081 8081 8082 8083 8084 8085 8086 8087 8088 8089 8089 8089 8090 8090 8091 8092 8093 8094 8094 8095 8095 8095 8095 8096 8097 8098 8098 8099 8100 8101 8101 8101 8102 8103 8104 8105 8106 Sheet1 3031 PED-T3A 3031 PCG-HOW 3014 PED-FER 3014 FLI-USB 3014 FLI-16H 3039 PED-FER 3071 FLI-USB 3064 PED-FER 3015 PED-FER 3097 FLI-HO4 3093 WHL-T3S 3064 FLI-TMX 3070 WHL-TMX 3070 PED-TFR 3070 FLI-TMX 3010 FLI-TMX 3010 FLI-THR 3040 WHL-T3P 3058 PED-T3A 3088 WHL-T30 3034 PED-TPR 3034 FLI-HO4 3079 FLI-H04 3079 PED-T80 3079 WHL-T30 3079 COM-FCS 3086 FLI-16H 3013 PED-FER 3073 WHL-TGT 3073 WHL-TGT 3038 PED-TPR 3039 PED-T3P 3047 PED-T80 3047 WHL-TMX 3047 FLI-HO4 3000 PED-T80 3022 PED-T3P 3086 FLI-THR 3076 PCG-HOW 3096 WHL-T30 Sheet2 T3PA Add-Or Hotas Warth Ferrari Racin USB Joystick T1600M FCS Ferrari Racin USB Joystick Ferrari Racini Ferrari Racin T-Flight Hota VG T300RS R TMX Force Fe TMX Pro Raci TFRP Rudder TMX Force Fe TMX Force Fe TWCS Thrott T300RS Racir T3PA Add-Or T300RS Offici TPR Pedals - T-Flight Hota T-Flight Hota T80 Ferrari 4 T300RS Offici T16000M FC T1600M FCS Ferrari Racini T-GT Racing T-GT Racing TPR Pedals - FB T3PA-Pro T80 Ferrari 4 TMX Pro Raci T-Flight Hota T80 Ferrari 4 FB T3PA-Pro TWCS Thrott Hotas Warth T300RS Offici 69.99 462.81 79.99 21.99 97.3 79.99 21.99 79.99 79.99 34.65 159.99 159.84 249.99 69.99 159.84 159.84 59.99 426.41 69.99 319.99 497.38 34.65 34.65 94.99 319.99 172.35 97.3 79.99 614.91 614.91 497.38 129.99 94.99 249.99 34.65 94.99 129.99 59.99 462.81 319.99 36.4 232.13 43.51 12.06 52.53 43.51 12.06 43.51 43.51 19.76 92.63 87.3 147.62 41.18 87.3 87.3 35.18 231.54 36.4 170.61 284.93 19.76 19.76 52.58 170.61 89.15 52.53 43.51 354.66 354.66 284.93 66.14 52.58 147.62 19.76 52.58 66.14 35.18 232.13 170.61 -33.59 -230.68 -36.48 -9.93 -44.77 -36.48 -9.93 -36.48 -36.48 -14.89 -67.36 -72.54 -102.37 -28.81 -72.54 -72.54 -24.81 -194.87 -33.59 -149.38 -212.45 -14.89 -14.89 -42.41 -149.38 -83.2 -44.77 -36.48 -260.25 -260.25 -212.45 -63.85 -42.41 -102.37 -14.89 -42.41 -63.85 -24.81 -230.68 -149.38 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 10/21/23 10/21/23 10/21/23 10/21/23 10/21/23 10/21/23 10/21/23 10/21/23 10/21/23 10/21/23 10/21/23 10/21/23 10/21/23 10/21/23 10/21/23 10/21/23 10/21/23 10/21/23 10/21/23 10/21/23 10/21/23 10/21/23 10/21/23 10/21/23 10/21/23 10/22/23 10/22/23 10/22/23 10/22/23 10/22/23 10/22/23 10/22/23 10/22/23 10/22/23 10/23/23 10/23/23 10/23/23 10/23/23 10/23/23 10/24/23 8106 8107 8108 8109 8109 8110 8110 8111 8112 8112 8113 8114 8115 8116 8117 8118 8119 8120 8121 8122 8123 8123 8123 8123 8124 8125 8126 8127 8128 8128 8128 8129 8130 8131 8132 8133 8133 8133 8134 8135 Sheet1 3096 PED-T80 3063 FLI-HOX 3091 WHL-T3S 3046 PED-T3A 3046 PED-T3P 3036 WHL-TGT 3036 PCG-HOW 3044 PCG-HOW 3045 FLI-THR 3045 FLI-HOX 3043 WHL-T30 3009 PED-TPR 3016 WHL-TGT 3068 PED-FER 3027 PED-TPR 3061 PED-TER 3077 PED-T3A 3009 COM-FCS 3013 WHL-T3P 3009 PED-TPR 3094 FLI-16M 3094 WHL-T3S 3094 WHL-T3P 3094 WHL-T30 3064 PED-FCS 3048 FLI-TMX 3086 PED-FER 3029 WHL-T3P 3018 PED-T3A 3018 FLI-HOX 3018 WHL-T30 3065 PCG-HOW 3013 PED-TPR 3094 FLI-H01 3056 FLI-THR 3083 PCG-HOW 3083 WHL-TGT 3083 FLI-16M 3081 WHL-TMX 3075 FLI-16M Sheet2 + T80 Ferrari 4 T-Flight Hota VG T300RSR T3PA Add-Or FB T3PA-Pro T-GT Racing Hotas Warth Hotas Warth TWCS Thrott T-Flight Hota T300RS Offici TPR Pedals - T-GT Racing Ferrari Racin TPR Pedals - TFRP Rudder T3PA Add-Or T16000M FC T300RS Racir TPR Pedals - T 16000M SP VG T300RSR T300RS Racir T300RS Offici T16000M FC: TMX Force FE Ferrari Racin T300RS Racir T3PA Add-Or T-Flight Hota T300RS Offici Hotas Warth TPR Pedals T-Flight Hota TWCS Thrott Hotas Warth T-GT Racing T 16000M Sp TMX Pro Raci T 16000M Sp 94.99 39.99 159.99 69.99 129.99 614.91 462.81 462.81 59.99 39.99 319.99 497.38 614.91 79.99 497.38 69.99 69.99 172.35 426.41 497.38 117.83 159.99 426.41 319.99 39.19 159.84 79.99 426.41 69.99 39.99 319.99 462.81 497.38 59.99 59.99 462.81 614.91 117.83 249.99 117.83 52.58 20.53 92.63 36.4 66.14 354.66 232.13 232.13 35.18 20.53 170.61 284.93 354.66 43.51 284.93 41.18 36.4 89.15 231.54 284.93 69.36 92.63 231.54 170.61 23.36 87.3 43.51 231.54 36.4 20.53 170.61 232.13 284.93 30.17 35.18 232.13 354.66 69.36 147.62 69.36 -42.41 -19.46 -67.36 -33.59 -63.85 -260.25 -230.68 -230.68 -24.81 -19.46 -149.38 -212.45 -260.25 -36.48 -212.45 -28.81 -33.59 -83.2 -194.87 -212.45 -48.47 -67.36 -194.87 -149.38 -15.83 -72.54 -36.48 -194.87 -33.59 -19.46 -149.38 -230.68 -212.45 -29.82 -24.81 -230.68 -260.25 -48.47 -102.37 -48.47 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 198 199 200 201 202 203 204 205 206 207 208 209 210 211 212 213 214 215 216 217 218 219 220 221 222 223 224 225 226 227 228 229 230 10/23/23 10/23/23 10/24/23 10/24/23 10/24/23 10/24/23 10/24/23 10/24/23 10/25/23 10/25/23 10/25/23 10/26/23 10/26/23 10/26/23 10/27/23 10/27/23 10/28/23 10/29/23 10/29/23 10/30/23 10/30/23 10/30/23 10/30/23 10/30/23 10/30/23 10/31/23 10/31/23 10/31/23 10/31/23 10/31/23 10/31/23 10/31/23 10/31/23 B 8133 8134 8135 8136 8137 8138 8138 8139 8140 8141 8142 8143 8144 8145 8146 8147 8148 8149 8149 8150 8150 8151 8151 8151 8151 8152 8153 8153 8154 8155 8156 8157 8158 D 3083 FLI-16M 3081 WHL-TMX 3075 FLI-16M 3083 FLI-HO4 3032 PED-T3A 3029 FLI-H04 3029 WHL-TGT 3061 WHL-T3P 3053 PED-TPR 3043 FLI-H01 3046 FLI-THR 3080 FLI-16M 3016 WHL-T3S 3056 FLI-H01 3015 PED-T80 3064 COM-FCS 3076 FLI-H01 3051 PED-FCS 3051 WHL-T30 3067 FLI-16H 3067 PCG-HOW 3055 WHL-TMX 3055 PED-TPR 3055 FLI-HO4 3055 WHL-TGT 3052 PED-T3A 3075 WHL-TGT 3075 FLI-16M 3013 PED-FER 3002 FLI-16H 3076 FLI-HO4 3001 PED-TPR 3067 FLI-16H T 16000M Sp TMX Pro Raci T 16000M SP T-Flight Hota T3PA Add-Or T-Flight Hota T-GT Racing T300RS Racir TPR Pedals - T-Flight Hota TWCS Throttl T 16000M SP VG T300RS R T-Flight Hota T80 Ferrari 4 T16000M FCS T-Flight Hota T16000M FC T300RS Offici T1600M FCS Hotas Warth TMX Pro Raci TPR Pedals - T-Flight Hota T-GT Racing T3PA Add-Or T-GT Racing T 16000M Sp Ferrari Racini T1600M FCS T-Flight Hota TPR Pedals - T1600M FCS F 117.83 249.99 117.83 34.65 69.99 34.65 614.91 426.41 497.38 59.99 59.99 117.83 159.99 59.99 94.99 172.35 59.99 39.19 319.99 97.3 462.81 249.99 497.38 34.65 614.91 69.99 614.91 117.83 79.99 97.3 34.65 497.38 97.3 69.36 147.62 69.36 19.76 36.4 19.76 354.66 231.54 284.93 30.17 35.18 69.36 92.63 30.17 52.58 89.15 30.17 23.36 170.61 52.53 232.13 147.62 284.93 19.76 354.66 36.4 354.66 69.36 43.51 52.53 19.76 284.93 52.53 H -48.47 -102.37 -48.47 -14.89 -33.59 -14.89 -260.25 -194.87 -212.45 -29.82 -24.81 -48.47 -67.36 -29.82 -42.41 -83.2 -29.82 -15.83 -149.38 -44.77 -230.68 -102.37 -212.45 -14.89 -260.25 -33.59 -260.25 -48.47 -36.48 -44.77 -14.89 -212.45 -44.77 Required information (The following information applies to the questions displayed below.) NOTE: Throughout this lab, every time a screenshot is requested, use your computer's screenshot tool, and paste each screenshot to the same Word document. Label each screenshot in accordance to what is noted in the lab. This document with all of the screenshots included should be uploaded through Connect as a Word or PDF document when you have reached the final step of the lab. In this lab, you will: Required: Calculate gross margin (revenues less cost of goods/products sold) by customer. Ask the Question: Which customers are the most profitable? Master the Data: Thrustmaster sells game controllers, joysticks, and steering wheels for PC, XBox, Nintendo, and Playstation consoles. A summary of the company's sales is included in the dataset. Software needed Excel Screen capture tool (Windows: Snipping Tool; Mac: Cmd+Shift+4) Data: Excel File Lab 2-3 Alt Data.xlsx. Perform the Analysis: Refer to Lab 2-3 Alternative in the text for instructions and Lab 2-3 steps for each of the lab parts. Share the Story: We can share the story by reporting our findings of our most profitable customers to the sales department and to management. Potentially, we could send additional advertising emails to them, enhance the customer service toward them, or give them discounts on future purchases. Required: 1. Which customer number made the highest gross margin for Thrustmaster? O Customer 3083 O Customer 3036 Customer 3013 Customer 3055 2. Which customer bought the least in total sales for Thrustmaster? O Customer 3097 Customer 3090 O Customer 3008 O Customer 3054 3. Which customer bought the most in total sales for Thrustmaster? Customer 3013 O Customer 3036 O Customer 3055 Customer 3083 4. Which invoice number had the highest gross margin for Thrustmaster? O Invoice 8151 Invoice 8133 O Invoice 8098 O Invoice 8110 5. Which of the following invoice numbers had the lowest total sales for Thrustmaster? O Invoice 8012 Invoice 8051 O Invoice 8079 O Invoice 8136