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 poste 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 Dota: 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 23 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. Part 1: Upload Your Files Part 2: Assessment Prov 2 of 2 NE Required information 2 Part 2 of 2 Customer 3013 O Customer 3083 Customer 3055 Customer 3036 5 points 2. Which customer bought the least in total sales for Thrustmaster? 8 002134 eBook O Customer 3008 O Customer 3054 O Customer 3090 Customer 3097 References 3. Which customer bought the most in total sales for Thrustmaster? O Customer 3013 Customer 3083 Customer 3055 Customer 3036 4. Which invoice number had the highest gross margin for Thrustmaster? O Customer 3055 O Customer 3036 Which invoice number had the highest gross margin for Thrustmaster? Invoice 8151 O Invoice 8133 O Invoice 8098 O Invoice 8110 Which of the following invoice numbers had the lowest total sales for Thrustmaster? Invoice 8079 O Invoice 8012 O Invoice 8136 O Invoice 8051