Required Informatlon

Lab $1\mathrm{.}3$ Alternate: Assessing Product $($SKU$)$ Profitability

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

Lab Insight: Apply the same steps in Lab $1\mathrm{.}3$ Excel $($or Lab $1\mathrm{.}3$ Tableau or Lab $1\mathrm{.}3$ Power BI$)$ to the Alt Lab $1\mathrm{.}3$ Data.xlsx data

set using your tool of choice.

Open Excel file Alt Lab $1\mathrm{.}3$ Data.xlsx and follow similar directions to those in Lab $1\mathrm{.}3$ Excel. ThrustMaster is a fictitious

company that sells game controllers, Joystic$$s$,$ and steering wheels for PCs and for Xbox, Nintendo, and PlayStation

consoles. A summary of the price list of its products by SKU is included in the Excel spreadsheet.

Required:

Draw a histogram of the grass margin percentages using bins of $0\mathrm{.}025$ size. Use bins $0\mathrm{.}425,0\mathrm{.}45,0\mathrm{.}475,0\mathrm{.}5.$

Get a list of SKUs in the highest $0\mathrm{.}025$ bin $($from $0\mathrm{.}475$ to $0\mathrm{.}50).$

Data: Alt Lab $1\mathrm{.}3$ 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{.}3$ Alternate: Assessment Questions

Answer the following questions based on the details computed.

Note: Round gross margln to $2$ decimal places and gross margin percentage to $3$ decimal places.