Automotive Market Share and Ratio Analysis Please refer to the Base Spreadsheet, under the tab labelled "Automotive Market". This sheet contains the most current information on the dollar and unit sales as well as average Gross Margins for each of the companies that participate in the Automotive market. This data is a complete listing of all the companies participating in this industry. Please fill in each of the highlighted cells to calculate for the following metrics for 2021 for each company: i. Dollar market share ji. Unit market share iii. Average selling price per unit iv. Average Cost of Goods Sold dollars per unit v. Average Gross Margin dollars per unit 1. What is Bord Motor Company's dollar market share? 2. What is Admiral Motor's unit market share? 3. What is Mesla Motor's average selling price? 4. What is Yolkswagen's average cost of goods sold dollars per unit? 5. What is Toybota's average gross margin dollars per unit? 6. What is Herrari's average cost of goods sold dollars per unit? 7. What is Liat's average selling price per unit? 8. What is Hongda's unit market share?