Refer to the data given.

$($Click the icon to view the data$)$

Read the requirements.

Requirement $1.$ Compute all ratio values to answer the following questions:

Which company has the highest and which company has the lowest gross profit percentage?

Which company has the highest and which has the lowest rate of inventory turnover? tenth percent, $xx\%.$ Do not enter the $\%$ sign in the gross profit percentage input fields.$)$

$\backslash$table$[[$Company$,\backslash$table$[[$Gross Profit$],[$Percentage$]],,\backslash$table$[[$Inventory$],[$Turnover$]]],[$Crane$,,\%,],[$Evans$,,\%,],[$Liard$,,\%,],[$Thomas$,,\%,]]$

Reference

$\backslash$table$[[$Company$,,$t Sales,$\backslash$table$[[$Beginning$],[$Inventory$]],\backslash$table$[[$Net$],[$Purchases$]],\backslash$table$[[$Ending$],[$Inventory$]],\backslash$table$[[$Cost of Goods$],[$sold$]],\backslash$table$[[$Gross$],[$Profit$]]],[$Crane$,$$$,105,000$$$,17,000$$$,59,000,$$$,16,000,60,000$$$,45,000],[$Evans$,,139,000,32,000,89,000,28,000,93,000,46,000],[$Liard$,,91,000,41,000,53,000,26,000,68,000,23,000],[$Thomas$,,81,000,13,000,26,000,2,000,37,000,44,000]]$