Required:

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

2. Create 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.