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 1 Create the calculated fields for gross margin and gross margin percentage 2 Create a histogram of the gross margin percentages 3 Change the default bin size to 0 025 4 Get a list of SKUs in the highest 0 025 bin Ask the Question Which products are the most profitable Master the Data Open Excel File Lab 2 6 Alt Data xlsx, and follow similar directions to those provided in the preceding discussion Thrustmaster sells game controllers, joysticks, and steering wheels for PC, XBox, Nintendo, and Playstation consoles A summary of the price list of its products by SKU is included in the Excel spreadsheet Software needed Tableau Screen capture tool (Windows Snipping Tool Mac Cmd Shift 4) Data Lab 2 6 Alt Data xlsx Perform the Analysis Refer to Lab 2 6 Alternative in the text for instructions and Lab 2 6 steps for each of the lab parts Share the Story We can share the story by reporting our findings to the sales staff and company management to promote those inventory items (fruit) that are most profitable Potentially, we could send additional advertising emails to our customers promoting these items Required 1 Which SKU has the highest gross margin percentage in the third bin multiple choice 1 FLI USB FLI STX PCG HOW PED T80 2 What is the gross margin percentage for PCG HOW Hotas Warthog PC multiple choice 2 0 42973 0 42714 0 44647 0 42516 3 Which product has the highest gross margin percentage, overall multiple choice 3 PED T3A T3PA Add On WHL TGT T GT Racing Wheel FLI HO1 T Flight Hotas One COM FCS T17000M FCS Flight Pack 4 How many SKUs are in the lowest gross margin percentage bin multiple choice 4 7 8 5 3 5 Which bin has the fewest SKUs multiple choice 5 Second bin Third bin Fourth bin First bin 52 53 87 3 20 53 19 76 23 36 30 17 89 15 41 18 147 62 52 58 SKU FLI 16H FLI TMX FLI HOX FLI H04 PED FCS FLI H01 COM FCS PED TFR WHL TMX PED T80 PED T3P PCG HOW PED FER PED T3A FLI 16M WHL T30 FLI USB PED TPR WHL T3S FLI THR FLI STX WHL TGT WHL T3P Description Sales Price Cost T1600M FCS Hotas 97 3 TMX Force Feedback Racing 159 84 T Flight Hotas X Flight Stick 39 99 T Flight Hotas 4 Flight Stick 34 65 T16000M FCS 39 19 T Flight Hotas One 59 99 T16000M FCS Flight Pack 172 35 TFRP Rudder 69 99 TMX Pro Racing Wheel 249 99 T80 Ferrari 488 GTB Edition 94 99 FB T3PA Pro 3 Pedal Add On 129 99 Hotas Warthog PC 462 81 Ferrari Racing Wheel Red Le 79 99 T3PA Add On 69 99 T 16000M Space SIM Duo St 117 83 T300RS Officially Licensed PS 319 99 USB Joystick 21 99 TPR Pedals Windows 497 38 VG T300RS Racing Wheel Sel 159 99 TWCS Throttle 59 99 T Flight Stick X PS3 39 99 T GT Racing Wheel (PS4 PC) 614 91 T300RS Racing Wheel 426 41 66 14 266 04 43 51 36 4 69 36 170 61 12 06 284 93 92 63 35 18 21 04 354 66 231 54 52 53 87 3 20 53 19 76 23 36 30 17 89 15 41 18 147 62 52 58 SKU FLI 16H FLI TMX FLI HOX FLI H04 PED FCS FLI H01 COM FCS PED TFR WHL TMX PED T80 PED T3P PCG HOW PED FER PED T3A FLI 16M WHL T30 FLI USB PED TPR WHL T3S FLI THR FLI STX WHL TGT WHL T3P Description Sales Price Cost T1600M FCS Hotas 97 3 TMX Force Feedback Racing 159 84 T Flight Hotas X Flight Stick 39 99 T Flight Hotas 4 Flight Stick 34 65 T16000M FCS 39 19 T Flight Hotas One 59 99 T16000M FCS Flight Pack 172 35 TFRP Rudder 69 99 TMX Pro Racing Wheel 249 99 T80 Ferrari 488 GTB Edition 94 99 FB T3PA Pro 3 Pedal Add On 129 99 Hotas Warthog PC 462 81 Ferrari Racing Wheel Red Le 79 99 T3PA Add On 69 99 T 16000M Space SIM Duo St 117 83 T300RS Officially Licensed PS 319 99 USB Joystick 21 99 TPR Pedals Windows 497 38 VG T300RS Racing Wheel Sel 159 99 TWCS Throttle 59 99 T Flight Stick X PS3 39 99 T GT Racing Wheel (PS4 PC) 614 91 T300RS Racing Wheel 426 41 66 14 266 04 43 51 36 4 69 36 170 61 12 06 284 93 92 63 35 18 21 04 354 66 231 54

The Answer is in the image, click to view ...

Answered step by step

Verified Expert Solution

Link Copied!

Question

1 Approved Answer

Posted on Oct 05, 2024

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

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:

1. Create the calculated fields for gross margin and gross margin percentage.

2. Create a histogram of the gross margin percentages.

3. Change the default bin size to 0.025.

4. Get a list of SKUs in the highest 0.025 bin.

Ask the Question: Which products are the most profitable?

Master the Data: Open Excel File Lab 2-6 Alt Data.xlsx, and follow similar directions to those provided in the preceding discussion. Thrustmaster sells game controllers, joysticks, and steering wheels for PC, XBox, Nintendo, and Playstation consoles. A summary of the price list of its products by SKU is included in the Excel spreadsheet.

Software needed

Tableau
Screen capture tool (Windows: Snipping Tool; Mac: Cmd+Shift+4)

Data: Lab 2-6 Alt Data.xlsx.

Perform the Analysis: Refer to Lab 2-6 Alternative in the text for instructions and Lab 2-6 steps for each of the lab parts.

Share the Story: We can share the story by reporting our findings to the sales staff and company management to promote those inventory items (fruit) that are most profitable. Potentially, we could send additional advertising emails to our customers promoting these items.

image text in transcribed

Required:

1. Which SKU has the highest gross margin percentage in the third bin?

multiple choice 1

FLI-USB
FLI-STX
PCG-HOW
PED-T80

2. What is the gross margin percentage for PCG-HOW Hotas Warthog PC?

multiple choice 2

0.42973
0.42714
0.44647
0.42516

3. Which product has the highest gross margin percentage, overall?

multiple choice 3

PED-T3A T3PA Add-On
WHL-TGT T-GT Racing Wheel
FLI-HO1 T-Flight Hotas One
COM-FCS T17000M FCS Flight Pack

4. How many SKUs are in the lowest gross margin percentage bin?

multiple choice 4

5. Which bin has the fewest SKUs?

multiple choice 5

Second bin
Third bin
Fourth bin
First bin

52.53 87.3 20.53 19.76 23.36 30.17 89.15 41.18 147.62 52.58 SKU FLI-16H FLI-TMX FLI-HOX FLI-H04 PED-FCS FLI-H01 COM-FCS PED-TFR WHL-TMX PED-T80 PED-T3P PCG-HOW PED-FER PED-T3A FLI-16M WHL-T30 FLI-USB PED-TPR WHL-T3S FLI-THR FLI-STX WHL-TGT WHL-T3P Description Sales Price Cost T1600M FCS Hotas 97.3 TMX Force Feedback Racing 159.84 T-Flight Hotas X Flight Stick 39.99 T-Flight Hotas 4 Flight Stick 34.65 T16000M FCS 39.19 T-Flight Hotas One 59.99 T16000M FCS Flight Pack 172.35 TFRP Rudder 69.99 TMX Pro Racing Wheel 249.99 T80 Ferrari 488 GTB Edition | 94.99 FB T3PA-Pro 3-Pedal Add-On 129.99 Hotas Warthog PC 462.81 Ferrari Racing Wheel Red Le 79.99 T3PA Add-On 69.99 T 16000M Space SIM Duo St 117.83 T300RS Officially Licensed PS 319.99 USB Joystick 21.99 TPR Pedals - Windows 497.38 VG T300RS Racing Wheel Sel 159.99 TWCS Throttle 59.99 T-Flight Stick X PS3 39.99 T-GT Racing Wheel (PS4/PC) 614.91 T300RS Racing Wheel 426.41 66.14 266.04 43.51 36.4 69.36 170.61 12.06 284.93 92.63 35.18 21.04 354.66 231.54 52.53 87.3 20.53 19.76 23.36 30.17 89.15 41.18 147.62 52.58 SKU FLI-16H FLI-TMX FLI-HOX FLI-H04 PED-FCS FLI-H01 COM-FCS PED-TFR WHL-TMX PED-T80 PED-T3P PCG-HOW PED-FER PED-T3A FLI-16M WHL-T30 FLI-USB PED-TPR WHL-T3S FLI-THR FLI-STX WHL-TGT WHL-T3P Description Sales Price Cost T1600M FCS Hotas 97.3 TMX Force Feedback Racing 159.84 T-Flight Hotas X Flight Stick 39.99 T-Flight Hotas 4 Flight Stick 34.65 T16000M FCS 39.19 T-Flight Hotas One 59.99 T16000M FCS Flight Pack 172.35 TFRP Rudder 69.99 TMX Pro Racing Wheel 249.99 T80 Ferrari 488 GTB Edition | 94.99 FB T3PA-Pro 3-Pedal Add-On 129.99 Hotas Warthog PC 462.81 Ferrari Racing Wheel Red Le 79.99 T3PA Add-On 69.99 T 16000M Space SIM Duo St 117.83 T300RS Officially Licensed PS 319.99 USB Joystick 21.99 TPR Pedals - Windows 497.38 VG T300RS Racing Wheel Sel 159.99 TWCS Throttle 59.99 T-Flight Stick X PS3 39.99 T-GT Racing Wheel (PS4/PC) 614.91 T300RS Racing Wheel 426.41 66.14 266.04 43.51 36.4 69.36 170.61 12.06 284.93 92.63 35.18 21.04 354.66 231.54