Formatting Table Styles - Font Alignment Number 15 Styles fx C B D E F G The following information is taken from publicly traded retailers. The data comes from the balance sheet, income statement, and Item 2 on the companies' Form 10-K filings. Use the information to answer the requirements. Retail SQ footage (000) Number of Stores COGS Average Inventory Revenue (Millions) Company Autozone (AZO) Costco (COST) Home Depot (HD) Lowe's (LOW) O'Reilly (ORLY Walmart (WMT) $ $ $ $ S S 11,221 $ 151,576 S 108,203 $ 71,309 $ 9,536 $ 511,729 $ 4,902 $ 121,715 S 71,043 S 48,396 $ 4,237 $ 374,623 S 3,913 S 10,437 S 13,337 S 11,977 $ 3,102 $ 44,026 S 41,066 $ 110,700 $ 237,700 $ 209,000 $ 38,455 5 1, 129,000 $ 6,202 762 2,287 2,015 5,219 11,361 a. Compute the days inventory outstanding (DIO) for each company b. Compute the gross profit margin for each company c. Compare the DIO and gross profit margin for each of the three combinations of competitors. What do we observe? How are the two ratios related? d. Compute the following two nontraditional efficiency metrics: Revenue per square foot and Revenue per store. What do we observe? Clipboard = Merge & Center - Font $ % 5 115 Alignment x 7 Numb A B 17 C D E F G Company COGS Average Inventory Inventory Turnover DO THIS 18 19 20 21 22 23 24 25 26 27 a Autozone (AZ) Costco (COST) Home Depot (HD) Lowe's (LOW) O'Reilly (ORLY) Walmart (WMT) Company Revenue Millions) COGS Gross Profit Gross Profit Margin TE 28 29 30 31 32 33 34 35 36 37 b Autozone (AZ) Costco (COST) Home Depot (HDI Lowe's (LOW O'Reilly ORLY Walmart (WMT) Gross Proht Margin Company DIO 38 39 40 41 Autozone (AZ) Costco ICOST) Home Depot (HO) Lowe's LOW O'Reilly (ORLY WalmaWMT Sheet en IURLY Imart (WMT) Company Revenue (Millions) Retail SQ footage Sales per SQ (000s) Foot ($) Number of Stores Sales per Store ($ millions! Autozone (AZO) Costco (COST) Home Depot (HD) Lowe's (LOW) O'Reilly (ORLY) Walmart (WMT) Define the following terms, and give a brief explanation for each, such as, what it describes in an organization 4. DIO 5. Gross Profit 1. Sales per Square Foot 2. Average Inventory 7. COGS 3. Inventory Turnover 8. Sales per 9. COGS 6. Gross Profit Margin tersed ande, answer in a word document and submit with this Excel Spreadsheet. Hand written, emailed or invalid format ments will not be accepted or graded