[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 a histogram of the gross margin percentages using bins of 0.025 size. Use bins 0.425, 0.45, 0.475, 0.5. 2. Get a list of SKUs in the highest 0.025 bin (from 0.475 to 0.50). Ask the Question: Which products (SKUs) are the most profitable to sell? Master the Data: Open Excel File Lab 2-5 Alt Data.xlsx and follow similar directions to that above. Thrustmaster sells game controllers, joysticks, steering wheels for PC's, XBOX, Nintendo and Playstation consoles. A summary of the price list of the company's products by SKU is included in the Excel spreadsheet. Software needed Excel Screen capture tool (Windows: Snipping Tool; Mac: Cmd+Shift+4) Data: Excel File Lab 2-5 Alt Data.xlsx Perform the Analysis: Refer to Lab 2-5 Alternative in the text for instructions and Lab 2-5 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. 1. Take a screenshot of the bins for your histogram, and label it Lab 2-5 Alt Submission 1 2. Take a screenshot of your detailed listing of fruit products sold from the 0.475 to 0.50 gross margin percentage range, and label it Lab 2-5 Alt Submission 2" A B C D E F G H 1 J K 1 SKU 2 FLI-16H 3 FLI-TMX 4 FLI-HOX 5 FLI-H04 6 PED-FCS 7 FLI-H01 8 COM-FCS 9 PED-TER 10 WHL-TMX 11 PED-T80 12 PED-T3P 13 PCG-HOW 14 PED-FER 15 PED-T3A 16 FLI-16M 17 WHL-T30 18 FLI-USB 19 PED-TPR 20 WHL-T3S 21 FLI-THR 22 FLI-STX 23 WHL-TGT 24 WHL-T3P 25 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 TERP Rudder 69.99 TMX Pro Racing Wheel 249.99 T80 Ferrari 488 GTB Edition 94.99 FB T3PA-Pro 3-Pedal Add-OI 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 P 319.99 USB Joystick 21.99 TPR Pedals - Windows 497.38 VG T300RS Racing Wheel Sa 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 52.53 87.3 20.53 19.76 23.36 30.17 89.15 41.18 147.62 52.58 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 26 27 [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 a histogram of the gross margin percentages using bins of 0.025 size. Use bins 0.425, 0.45, 0.475, 0.5. 2. Get a list of SKUs in the highest 0.025 bin (from 0.475 to 0.50). Ask the Question: Which products (SKUs) are the most profitable to sell? Master the Data: Open Excel File Lab 2-5 Alt Data.xlsx and follow similar directions to that above. Thrustmaster sells game controllers, joysticks, steering wheels for PC's, XBOX, Nintendo and Playstation consoles. A summary of the price list of the company's products by SKU is included in the Excel spreadsheet. Software needed Excel Screen capture tool (Windows: Snipping Tool; Mac: Cmd+Shift+4) Data: Excel File Lab 2-5 Alt Data.xlsx Perform the Analysis: Refer to Lab 2-5 Alternative in the text for instructions and Lab 2-5 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. 1. Take a screenshot of the bins for your histogram, and label it Lab 2-5 Alt Submission 1 2. Take a screenshot of your detailed listing of fruit products sold from the 0.475 to 0.50 gross margin percentage range, and label it Lab 2-5 Alt Submission 2" A B C D E F G H 1 J K 1 SKU 2 FLI-16H 3 FLI-TMX 4 FLI-HOX 5 FLI-H04 6 PED-FCS 7 FLI-H01 8 COM-FCS 9 PED-TER 10 WHL-TMX 11 PED-T80 12 PED-T3P 13 PCG-HOW 14 PED-FER 15 PED-T3A 16 FLI-16M 17 WHL-T30 18 FLI-USB 19 PED-TPR 20 WHL-T3S 21 FLI-THR 22 FLI-STX 23 WHL-TGT 24 WHL-T3P 25 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 TERP Rudder 69.99 TMX Pro Racing Wheel 249.99 T80 Ferrari 488 GTB Edition 94.99 FB T3PA-Pro 3-Pedal Add-OI 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 P 319.99 USB Joystick 21.99 TPR Pedals - Windows 497.38 VG T300RS Racing Wheel Sa 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 52.53 87.3 20.53 19.76 23.36 30.17 89.15 41.18 147.62 52.58 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 26 27