Requlred Information

Lab $1\mathrm{.}2$ Alternate: Assessing Customer Profitability

$[$The following information applles to the questions displayed below.$]$

Lab Insight: Apply the same steps from Lab $1\mathrm{.}2($Excel$,$ Tableau, or Power BI$)$ to the Alt Lab $1\mathrm{.}2$ Data.xisx data set using

Excel, Tableau, or Power BI$.$

Open Excel File Alt Lab $1\mathrm{.}2$ Data.xlsx and follow similar directions to those in Lab $1\mathrm{.}2$ using Excel, Tableau, or Power BI$.$

ThrustMaster is a fictitious company that sells game controllers, Joysticks, and steering wheels for PCs and for Xbox,

Nintendo, and PlayStation consoles. A summary of the company's sales is included in the data set.

Required:

Calculate gross margin by customer to identify the most profitable customer.

Data: Alt Lab $1\mathrm{.}2$ Data.xlsx

Analyze the Data: Alternate Labs don't have step$-$by$-$step instruction or video support. Apply your experience from the

original lab. If needed, reference the text or eBook for instructions and steps from the original lab.

Lab $1\mathrm{.}2$ Alternate: Assessment Questions

Answer the following questions based on the details computed.

Note: Round the dollar amounts to $2$ decimal places..