Required information

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

Required:

Create a histogram $($showing relatively frequency in the dataset$)$ of the gross margin percentages using bins of $0\mathrm{.}025$ size.

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

Ask the Question: Which products $($SKUs$)$ are the most profitable to sell?

Master the Data: Fruitopia sells exotic fruit from throughout the world to U$.$S$.$ customers by mail order. The company keeps a price list for each product. We will work from that price list to find those items that are most profitable per dollar of sales.

Software needed

Excel

Screen capture tool $($Windows: Snipping Tool; Mac: Cmd$+$Shift$+4)$

Data: Excel File Lab $2-5$ Data.xIsx.

Perform the Analysis: Refer to Lab $2-5$ in the text for instructions and 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.

Required:

Which product has the highest gross margin percentage?

Pear

Purple Mangos

Jabuticaba

Jambul

How many products $($SKUs$)$ have gross margin percentages in the $0\mathrm{.}325-0\mathrm{.}35$ range?