Data Visualization 6-1 Gross profit ratio You have recently been hired as an analyst and asked to compare companies in the retail industry. Based on total sales, you select three small companies (1, 2, and 3), four medium-sized companies (4,5,6, and 7), and three large companies (8, 9, and 10). For each of these companies, you gather data on their gross profit and net sales revenue. Your task is to determine which of these companies might make a good investment based on the gross profit ratio. The bar chart below shows each company's gross profit and net sales, along with a line that graphs the gross profit ratio Answer the following questions. Gross Profit, Net Sales, and Gross Profit Ratio $300,000,000 80.00% $200,000,000 Net Sales CH 40.00% Gross Profit Ratio $100,000,000 so 8 0.00% Company 6 Company Compally Company 9 of Aueduos Company 8 Gross Profit Net Sales -Gross Profit Ratio Company 1 Company2 Company 3 Company Click here to open the graph(s) in a new tab. Required: Required: 1. Which company has the lowest net sales? 2. Which company has the highest dollar amount of gross profit? 3. Which company has the highest gross profit ratio? 4. Which company has the lowest gross profit ratio? 5. Company 7 has gross profit of $70 million and net sales of $150 million. What is the gross profit ratio for that company? (Round your answer to 1 decimal place.) Gross Profit Ratio % 6. Based only on the gross profit ratio, which company would you select for your investment