AutoSave Off Comments Case Study | Excel Template-1 - Read-Only - Excel Search Nicola Turner NT Formulas Data Review View Help Share ab Wrap Text 4 v Merge & Center $ % 9 80 Conditional Format as Formatting Table Cell Styles Insert Delete Format Sort & Find & Filter Select Analyze Data Alignment Number Styles Cells Editing Analysis File Home Insert Draw Page Layout Calibri 11 x Paste BIU H x ' ' A Clipboard F Font D32 fx A B C D E F G H 1 0 Score 2 3 4 5 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. 6 Company Revenue (Millions) COGS Average Inventory Retail SQ footage (000s) Number of Stores 7 8 Autozone (AZO) $ 11,221 $ 4,902 $ 3,913 $ 41,066 $ 6,202 9 Costco (COST) $ 151,576 $ 121,715 $ 10,437 $ 110,700 $ 762 10 Home Depot (HD) $ 108,203 $ 71,043 $ 13,337 $ 237,700 $ 2,287 11 Lowe's (LOW) $ 71,309 $ 48,396 $ 11,977 $ 209,000 $ 2,015 12 O'Reilly (ORLY) 9,536 $ 4,237 $ 3,102 $ 38,455 $ 5,219 13 Walmart (WMT) $ 511,729 $ 374,623 $ 44,026 $ 1,129,000 $ 11,361 14 15 a. Compute the days inventory outstanding (DIO) for each company 16 b. Compute the gross profit margin for each company 17 18 19 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? 20 Company Sheet1 H Type here to search COGS Average Inventory Inventory Turnover DIO hp PDF J K L M N P B + 90% 5:43 PM 2/3/2021