Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Formatting Table Styles - Font Alignment Number 15 Styles fx C B D E F G The following information is taken from publicly traded retailers.

image text in transcribed
image text in transcribed
image text in transcribed
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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Essential Audit And Assurance 2022

Authors: Nick Blackwell, Emile Woolf International

1st Edition

1848439326, 978-1848439320

More Books

Students also viewed these Accounting questions

Question

Who are normally included as the stakeholders of a business?

Answered: 1 week ago