Spring $2024$ Information Technology $($MIS$-304...$

i

Help

Save & Exit

$0\mathrm{.}475,0\mathrm{.}5.$

$2.$ 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.xIsx

Analyze the Data: Refer to lab $1\mathrm{.}3$ in your text for additional instructions and steps.

Answer the following questions based on the details computed.

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

$\backslash$table$[[$Question$,$Answer$],[1.$ What is the gross margin $($dollars$)$ for SKU FLI$-16$H$?,44\mathrm{.}77],[2.$ What is the gross margin percentage for SKU WHL$-$T$3$P$?,0\mathrm{.}497],[3.$ What was the highest gross margin percentage among all the SKU's?,$23],[4.$ How many total SKU's are there?,$4],[5.$ How many SKU's are in the $0\mathrm{.}5-0\mathrm{.}525$ bin?,$]]$