Homework answers / question archive / Required information 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

Required information 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

Accounting

Share With

Required information
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.

Upload one Word or PDF document containing all of your screenshots for this Lab using the button below.

Take a screenshot of your Tableau histogram, and label it “Lab 2-6 Alt Submission 1 Tableau”.
Take a screenshot of your Tableau dashboard, and label it “Lab 2-6 Alt Submission 2 Tableau”.