Required information

Skip to question

[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 companys 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.

rev: 09_21_2020_QC_CS-228676

Upload the Word or PDF document containing your Lab screenshots using the button below.

Take a screenshot of your PivotTable, and label it Lab 2-3 Alt Submission

Required:

1. Which customer number made the highest gross margin for Thrustmaster?

multiple choice 1

• Customer 3055

• Customer 3036

• Customer 3013

• Customer 3083

2. Which customer bought the least in total sales for Thrustmaster?

multiple choice 2

• Customer 3090

• Customer 3008

• Customer 3097

• Customer 3054

3. Which customer bought the most in total sales for Thrustmaster?

multiple choice 3

• Customer 3036

• Customer 3013

• Customer 3083

• Customer 3055

4. Which invoice number had the highest gross margin for Thrustmaster?

multiple choice 4

• Invoice 8098

• Invoice 8133

• Invoice 8110

• Invoice 8151

5. Which of the following invoice numbers had the lowest total sales for Thrustmaster?

multiple choice 5

• Invoice 8136

• Invoice 8051

• Invoice 8012

• Invoice 8079

2 3 4 5 9 10 11 12 Date Invoice # Customer # SKU 10/1/2023 8001 3006 PED-TPR 10/2/2023 8002 3022 WHL-T3S 10/2/2023 8002 3022 WHL-TGT 10/3/2023 8003 3096 FLI-TMX 10/3/2023 8004 3080 FLI-USB 10/3/2023 8005 3055 WHL-T30 10/3/2023 8006 3076 WHL-TMX 10/3/2023 8007 3066 FLI-16H 10/3/2023 8007 3066 FLI-HOX 10/3/2023 8008 3095 FLI-16M 10/3/2023 8009 3051 WHL-TGT 10/3/2023 8009 3051 PED-FCS 10/3/2023 8010 3066 FLI-H01 10/3/2023 8011 3053 WHL-TGT 10/3/2023 8012 3008 FLI-HO4 10/4/2023 8013 3013 PED-TPR 10/4/2023 8013 3013 FLI-16H 10/4/2023 8013 3013 WHL-TMX 10/4/2023 8014 3014 FLI-TMX 10/5/2023 8015 3029 FLI-16M 10/5/2023 8015 3029 PED-FCS 10/5/2023 8016 3054 FLI-STX 10/5/2023 8017 3027 PED-FER Description Sales Price Cost TPR Pedals - 497.38 VG T300RS Ri 159.99 T-GT Racing 614.91 TMX Force Fe 159.84 USB Joystick 21.99 T300RS Offici 319.99 TMX Pro Raci 249.99 T1600M FCS 97.3 T-Flight Hota 39.99 T 16000M Sp 117.83 T-GT Racing 614.91 T16000M FCS 39.19 T-Flight Hota 59.99 T-GT Racing! 614.91 T-Flight Hota 34.65 TPR Pedals - 497.38 T1600M FCS 97.3 TMX Pro Raci 249.99 TMX Force Fe 159.84 T 16000M Sp 117.83 T16000M FCS 39.19 T-Flight Stick 39.99 Ferrari Racing 79.99 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 13 14 15 16 17 18 19 20 21 69.36 22 23 24 23.36 21.04 43.51 8018 25 26 59.99 614.91 8019 94.99 27 28 29 30 8019 8019 8020 8021 8021 8021 8021 8021 31 32 33 34 8021 35 36 37 10/5/2023 10/6/2023 10/6/2023 10/6/2023 10/6/2023 10/7/2023 10/7/2023 10/7/2023 10/7/2023 10/7/2023 10/7/2023 10/7/2023 10/7/2023 10/7/2023 10/7/2023 10/7/2023 10/7/2023 10/7/2023 10/7/2023 10/8/2023 10/8/2023 10/8/2023 10/8/2023 10/8/2023 8022 8023 8024 3075 FLI-THR 3074 WHL-TGT 3074 PED-T80 3074 PED-T80 3081 PED-TER 3026 FLI-16H 3026 FLI-HO1 3026 FLI-H01 3026 COM-FCS 3026 FLI-STX 3026 PED-T3P 3083 PCG-HOW 3077 PED-FCS 3046 COM-FCS 3046 WHL-TMX 3098 PED-TPR 3098 FLI-HO4 3066 WHL-T3S 3013 WHL-TGT 3062 FLI-H01 3056 FLI-16H 3049 WHL-T3S 3049 FLI-HO4 3049 FLI-USB TWCS Throttl T-GT Racing T80 Ferrari 48 T80 Ferrari 48 TFRP Rudder T1600M FCS T-Flight Hota T-Flight Hota T16000M FCS T-Flight Stick FB T3PA-Pro Hotas Warth T16000M FCS T16000M FCS TMX Pro Raci TPR Pedals - T-Flight Hota VG T300RS R T-GT Racing T-Flight Hota T1600M FCS VG T300RS RE T-Flight Hota USB Joystick 35.18 354.66 52.58 52.58 41.18 52.53 30.17 30.17 89.15 21.04 66.14 232.13 23.36 89.15 147.62 284.93 19.76 92.63 354.66 30.17 52.53 92.63 19.76 12.06 94.99 69.99 97.3 59.99 59.99 172.35 39.99 129.99 462.81 39.19 172.35 249.99 497.38 34.65 159.99 614.91 59.99 97.3 159.99 34.65 21.99 38 39 40 8024 8025 8025 8026 41 42 43 44 45 46 47 48 8027 8028 8029 8030 8030 8030 8031 49 50 8032 8033 51 52 8033 53 54 55 56 8034 8035 8035 8036 8037 8038 8039 57 58 59 60 10/8/2023 10/8/2023 10/8/2023 10/8/2023 10/8/2023 10/8/2023 10/8/2023 10/8/2023 10/8/2023 10/8/2023 10/8/2023 10/8/2023 10/8/2023 10/8/2023 10/8/2023 10/9/2023 10/9/2023 10/9/2023 10/9/2023 10/9/2023 10/9/2023 10/9/2023 10/9/2023 10/9/2023 8039 3022 FLI-STX 3035 WHL-TGT 3021 WHL-T3S 3021 FLI-H01 3000 PED-T3A 3071 PED-TFR 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 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 T-Flight Stick T-GT Racing VG T300RS Ri T-Flight Hota T3PA Add-On TFRP Rudder T-Flight Hota T-Flight Stick FB T3PA-Pro T300RS Racin USB Joystick T16000M FCS TWCS Throttl T-Flight Hota Ferrari Racing T 16000M SP T16000M FCS USB Joystick TPR Pedals - T-Flight Stick FB T3PA-Pro 3 VG T300RS RC TWCS Throtti TWCS Throttl 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 61 62 63 64 65 8039 8040 8041 8042 8043 8044 8045 8045 8046 66 67 68 69 70 71 8046 8047 8048 59.99 59.99 72 35.18 8049 8050 8051 8052 8053 8053 8053 8054 8054 8054 8055 8056 73 10/9/2023 74 10/10/2023 75 10/11/2023 76 10/11/2023 77 10/11/2023 78 10/11/2023 79 10/11/2023 80 10/11/2023 81 10/11/2023 82 10/11/2023 83 10/11/2023 84 10/11/2023 85 10/11/2023 86 10/11/2023 87 10/11/2023 88 10/11/2023 89 10/11/2023 90 10/11/2023 91 10/11/2023 92 10/11/2023 93 10/11/2023 94 10/11/2023 95 10/11/2023 96 10/11/2023 3003 FLI-THR 3063 PED-T80 3088 PED-FCS 3010 WHL-T3S 3044 COM-FCS 3044 FLI-TMX 3044 FLI-HOX 3082 FLI-16H 3082 FLI-H01 3082 PED-T3A 3091 PED-TFR 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 TWCS Throtti T80 Ferrari 48 T16000M FCS VG T300RS R T16000M FCS TMX Force Fe T-Flight Hota T1600M FCS T-Flight Hota T3PA Add-On TFRP Rudder T16000M FCS T-GT Racing T16000M FCS T16000M FCS T 16000M SP TMX Pro Raci T-GT Racing T16000M FCS T3PA Add-On T1600M FCS T1600M FCS T-Flight Stick T300RS Offici 59.99 94.99 39.19 159.99 172.35 159.84 39.99 97.3 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 35.18 52.58 23.36 92.63 89.15 87.3 20.53 52.53 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 8057 8058 8059 8059 8059 8060 8061 8061 8062 8063 8063 8063 8064 8065 8065 8066 172.35 497.38 319.99 159.84 614.91 97 10/11/2023 98 10/12/2023 99 10/12/2023 100 10/12/2023 101 10/12/2023 102 10/12/2023 103 10/12/2023 104 10/12/2023 105 10/12/2023 106 10/12/2023 107 10/12/2023 108 10/13/2023 109 10/13/2023 110 10/13/2023 111 10/13/2023 112 10/13/2023 113 10/14/2023 114 10/14/2023 115 10/14/2023 116 10/14/2023 117 10/14/2023 118 10/14/2023 119 10/14/2023 120 10/14/2023 8067 8068 8068 8068 8069 8070 8071 8072 8072 8072 8073 8074 8075 8075 8075 8076 8077 8078 8078 3025 COM-FCS 3081 PED-TPR 3081 WHL-T30 3093 FLI-TMX 3037 WHL-TGT 3087 FLI-STX 3087 FLI-HO4 3087 PCG-HOW 3090 FLI-H01 3025 PED-TFR 3096 WHL-T3P 3095 PED-T3A 3095 FLI-TMX 3095 WHL-T30 3060 PCG-HOW 3027 FLI-H04 3095 PED-FER 3095 FLI-THR 3095 FLI-HO4 3065 COM-FCS 3043 FLI-16M 3080 FLI-H01 3080 FLI-16M 3063 FLI-USB T16000M FCS TPR Pedals - T300RS Offici TMX Force Fe T-GT Racing T-Flight Stick T-Flight Hota Hotas Warth T-Flight Hota TFRP Rudder T300RS Racin T3PA Add-On TMX Force Fe T300RS Offici Hotas Warth T-Flight Hota Ferrari Racing TWCS Throttl T-Flight Hota T16000M FCS T 16000M SP T-Flight Hota T 16000M SP USB Joystick 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 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 8079 36.4 232.13 43.51 12.06 8080 8080 8081 8081 8081 8082 8083 8084 8085 8086 121 10/14/2023 122 10/14/2023 123 10/14/2023 124 10/14/2023 125 10/14/2023 126 10/14/2023 127 10/14/2023 128 10/14/2023 129 10/14/2023 130 10/14/2023 131 10/14/2023 132 10/15/2023 133 10/15/2023 134 10/15/2023 135 10/15/2023 136 10/15/2023 137 10/15/2023 138 10/15/2023 139 10/15/2023 140 10/15/2023 141 10/15/2023 142 10/15/2023 143 10/16/2023 144 10/16/2023 8087 8088 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-H04 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 T3PA Add-On Hotas Warth Ferrari Racing USB Joystick T1600M FCS Ferrari Racing USB Joystick Ferrari Racing Ferrari Racing T-Flight Hota VG T300RS R TMX Force Fe TMX Pro Raci TFRP Rudder TMX Force Fe TMX Force Fe TWCS Throtti T300RS Racin T3PA Add-On T300RS Offici TPR Pedals - T-Flight Hota T-Flight Hota T80 Ferrari 48 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 52.53 43.51 12.06 43.51 43.51 19.76 92.63 87.3 147.62 41.18 87.3 8089 8089 8089 8090 87.3 8090 35.18 8091 8092 8093 8094 8094 8095 8095 231.54 36.4 170.61 284.93 19.76 19.76 52.58 8095 8095 8096 8097 319.99 172.35 97.3 79.99 614.91 614.91 8098 8098 8099 8100 8101 8101 8101 8102 145 10/16/2023 146 10/16/2023 147 10/16/2023 148 10/16/2023 149 10/17/2023 150 10/17/2023 151 10/17/2023 152 10/17/2023 153 10/17/2023 154 10/17/2023 155 10/17/2023 156 10/18/2023 157 10/19/2023 158 10/20/2023 159 10/21/2023 160 10/21/2023 161 10/21/2023 162 10/21/2023 163 10/21/2023 164 10/21/2023 165 10/21/2023 166 10/21/2023 167 10/21/2023 168 10/21/2023 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-H04 3000 PED-T80 3022 PED-T3P 3086 FLI-THR 3076 PCG-HOW 3096 WHL-T30 3096 PED-T80 3063 FLI-HOX 3091 WHL-T3S 3046 PED-T3A 3046 PED-T3P 3036 WHL-TGT 3036 PCG-HOW 3044 PCG-HOW T300RS Offici T16000M FCS T1600M FCS Ferrari Racing T-GT Racing T-GT Racing TPR Pedals - FB T3PA-Pro T80 Ferrari 48 TMX Pro Raci T-Flight Hota T80 Ferrari 48 FB T3PA-Pro TWCS Throttl Hotas Warth T300RS Offici T80 Ferrari 48 T-Flight Hota VG T300RS R T3PA Add-On FB T3PA-Pro T-GT Racing Hotas Warth Hotas Warth 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 52.58 20.53 92.63 36.4 66.14 354.66 232.13 232.13 8103 8104 497.38 129.99 94.99 249.99 34.65 94.99 129.99 59.99 462.81 319.99 94.99 39.99 159.99 69.99 129.99 614.91 462.81 462.81 8105 8106 8106 8107 8108 8109 8109 8110 8110 8111 8112 8112 35.18 20.53 169 10/21/2023 170 10/21/2023 171 10/21/2023 172 10/21/2023 173 10/21/2023 174 10/21/2023 175 10/21/2023 176 10/21/2023 177 10/21/2023 178 10/21/2023 179 10/21/2023 180 10/21/2023 181 10/21/2023 182 10/21/2023 183 10/21/2023 184 10/21/2023 185 10/21/2023 186 10/22/2023 187 10/22/2023 188 10/22/2023 189 10/22/2023 190 10/22/2023 191 10/22/2023 192 10/22/2023 8113 8114 8115 8116 8117 8118 8119 8120 8121 8122 8123 8123 8123 8123 8124 8125 8126 8127 3045 FLI-THR 3045 FLI-HOX 3043 WHL-T30 3009 PED-TPR 3016 WHL-TGT 3068 PED-FER 3027 PED-TPR 3061 PED-TFR 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 TWCS Throttl T-Flight Hota T300RS Offici TPR Pedals - T-GT Racing Ferrari Racing TPR Pedals - TFRP Rudder T3PA Add-On T16000M FCS T300RS Racin TPR Pedals - T 16000M Sp VG T300RS R. T300RS Racin T300RS Offici T16000M FCS TMX Force Fe Ferrari Racing T300RS Racin T3PA Add-On T-Flight Hota T300RS Offici Hotas Warth 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 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 8128 8128 39.99 20.53 8128 8129 319.99 462.81 170.61 232.13 8130 8131 8132 8133 497.38 59.99 59.99 462.81 614.91 117.83 249.99 8133 8133 193 10/22/2023 194 10/22/2023 195 10/23/2023 196 10/23/2023 197 10/23/2023 198 10/23/2023 199 10/23/2023 200 10/24/2023 201 10/24/2023 202 10/24/2023 203 10/24/2023 204 10/24/2023 205 10/24/2023 206 10/25/2023 207 10/25/2023 208 10/25/2023 209 10/26/2023 210 10/26/2023 211 10/26/2023 212 10/27/2023 213 10/27/2023 214 10/28/2023 215 10/29/2023 216 10/29/2023 8134 8135 8136 8137 8138 8138 8139 3013 PED-TPR 3094 FLI-H01 3056 FLI-THR 3083 PCG-HOW 3083 WHL-TGT 3083 FLI-16M 3081 WHL-TMX 3075 FLI-16M 3083 FLI-HO4 3032 PED-T3A 3029 FLI-HO4 3029 WHL-TGT 3061 WHL-T3P 3053 PED-TPR 3043 FLI-H01 3046 FLI-THR 3080 FLI-16M 3016 WHL-T3S 3056 FLI-HO1 3015 PED-T80 3064 COM-FCS 3076 FLI-H01 3051 PED-FCS 3051 WHL-T30 TPR Pedals - T-Flight Hota TWCS Throtti Hotas Warth T-GT Racing T 16000M Sp TMX Pro Raci T 16000M SP T-Flight Hota T3PA Add-On T-Flight Hota T-GT Racing T300RS Racin TPR Pedals - T-Flight Hota TWCS Throttl T 16000M Sp VG T300RS RC T-Flight Hota T80 Ferrari 48 T16000M FCS T-Flight Hota T16000M FCS T300RS Offici 284.93 30.17 35.18 232.13 354.66 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 8140 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 8141 8142 8143 8144 8145 8146 8147 8148 8149 8149 217 10/30/2023 218 10/30/2023 219 10/30/2023 220 10/30/2023 221 10/30/2023 222 10/30/2023 223 10/31/2023 224 10/31/2023 225 10/31/2023 226 10/31/2023 227 10/31/2023 228 10/31/2023 229 10/31/2023 230 10/31/2023 8150 8150 8151 8151 8151 8151 8152 8153 8153 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 T1600M FCS Hotas Warth TMX Pro Raci TPR Pedals - T-Flight Hota T-GT Racing T3PA Add-On T-GT Racing T 16000M Sp Ferrari Racing T1600M FCS T-Flight Hota TPR Pedals - T1600M FCS 97.3 462.81 249.99 497.38 34.65 614.91 69.99 614.91 117.83 79.99 97.3 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 8154 8155 8156 8157 8158 34.65 497.38 97.3 21