Average Retail SQ # of $ millions Revenue COGS Inventory Footage (000s) Stores Autozone $11,221 $4,902 $3,913 41,066 6,202 Costco 141,576 121,715 10,437 110,700 762 Home Depot 108,203 71,043 13,337 237,700 2,287 Lowe’s 71,309 48,396 11,977 209,000 2,015 O’Reilly 9,536 4,237 3,102 38,455 5,219 Walmart 511,729 374,623 44,026 1,129,000 11,361 Required a. Compute the days inventory outstanding (DIO) for each company. Note: Do not round until your final answer; round your final answer to the nearest whole day. DIO AUTOZONE Answer days COSTCO Answer days HOME DEPOT Answer days LOWE'S Answer days O'REILLY Answer days WALMART Answer days b. Compute the gross profit margin for each company. Note: Round percentage to one decimal place (for example, enter 6.7% for 6.6555%). DIO AUTOZONE Answer COSTCO Answer HOME DEPOT Answer LOWE'S Answer O'REILLY Answer WALMART Answer c. Compute the following two nontraditional efficiency metrics: Revenue per square foot and Revenue per store. Note: Round your answers to two decimal places (for example, enter 6.78 for 6.77555). Revenue per SF Revenue per store AUTOZONE Answer Answer COSTCO Answer Answer HOME DEPOT Answer Answer LOWE'S Answer Answer O'REILLY Answer Answer WALMART Answer Answer
Evaluating Turnover and Nontraditional Efficiency Ratios Across Industries
The following information is taken from publicly traded retailers. The data come from the
Average | Retail SQ | # of | |||
---|---|---|---|---|---|
$ millions | Revenue | COGS | Inventory | Footage (000s) | Stores |
Autozone | $11,221 | $4,902 | $3,913 | 41,066 | 6,202 |
Costco | 141,576 | 121,715 | 10,437 | 110,700 | 762 |
Home Depot | 108,203 | 71,043 | 13,337 | 237,700 | 2,287 |
Lowe’s | 71,309 | 48,396 | 11,977 | 209,000 | 2,015 |
O’Reilly | 9,536 | 4,237 | 3,102 | 38,455 | 5,219 |
Walmart | 511,729 | 374,623 | 44,026 | 1,129,000 | 11,361 |
Required
a. Compute the days inventory outstanding (DIO) for each company.
Note: Do not round until your final answer; round your final answer to the nearest whole day.
DIO | ||
---|---|---|
AUTOZONE | Answer | days |
COSTCO | Answer | days |
HOME DEPOT | Answer | days |
LOWE'S | Answer | days |
O'REILLY | Answer | days |
WALMART | Answer | days |
b. Compute the gross profit margin for each company.
Note: Round percentage to one decimal place (for example, enter 6.7% for 6.6555%).
DIO | |
---|---|
AUTOZONE | Answer |
COSTCO | Answer |
HOME DEPOT | Answer |
LOWE'S | Answer |
O'REILLY | Answer |
WALMART | Answer |
c. Compute the following two nontraditional efficiency metrics: Revenue per square foot and Revenue per store.
Note: Round your answers to two decimal places (for example, enter 6.78 for 6.77555).
Revenue per SF | Revenue per store | |
---|---|---|
AUTOZONE | Answer | Answer |
COSTCO | Answer | Answer |
HOME DEPOT | Answer | Answer |
LOWE'S | Answer | Answer |
O'REILLY | Answer | Answer |
WALMART | Answer | Answer |

Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 4 images









