Question

In: Accounting

E6-35. Evaluating Grocery Stores Using Efficiency Ratios Below are data for three publicly traded grocery stores...

E6-35. Evaluating Grocery Stores Using Efficiency Ratios

Below are data for three publicly traded grocery stores that range in size from local (Village Super Markets) to regional (Publix) to national (Kroger). Use the ratios below to answer the requirements. Assume

that the companies sell roughly the same mix of products and face about the same inventory costs.

Fiscal 2018 Publix Kroger Village Super Market

Gross profit margin %. . . . . . . . . . . . . . . . . . . 29.6% 21.7% 27.2%

Number of stores at year-end. . . . . . . . . . . . . 1,211 2,764 30

Sales ($ per square foot) . . . . . . . . . . . . . . . . $639 $677 $1,165

Sales per store ($ millions). . . . . . . . . . . . . . . $ 30 $ 44 $ 54

Average store size (thousand square feet). . . 47 65 46

COGS (per square foot) . . . . . . . . . . . . . . . . . $450 $530 $ 848

Days inventory outstanding . . . . . . . . . . . . . . 26.5 25.7 12.6

Required

a. On average, which company has the freshest food?

b. Which company is least efficient with its space?

c. Which company has the lowest prices?

d. Which company is busiest?

e. Which company has the smallest stores

Solutions

Expert Solution

Ratio Publix Kroger   Village Super Market
Ans a.
Days Inventory Outstanding                    26.50              25.70                  12.60
Village SuperMarket holds the inventory for
the least no of days .
So Village Super Market has the freshest
products.
Ans b
Sales $ per Sq feet $             639.00 $       677.00 $         1,165.00
Publix has the least sales $ per Sq ft store space.
So Publix is least efficient with its spaces.
Ans c.
Gross Profit Margin % 29.60% 21.70% 27.20%
As the sales mix are same and the inventory
costs also the same, the company's have
similar COGS. So the company with least Gross
Margin will have the least sales price.
As Kroger has the lowest Gross Margin, Kroger
has the least Sales Price.
Ans d.
Sales Per Store ($ M) $               30.00 $         44.00 $              54.00
As Village SuperMarket has the highest sales
per store and also highest sales $ per Sq fr,
Village SuperMarket is the busiest.
Ans e
Average Store Size('000 Sq Ft)                         47                   65 46
Village Super Market has the smallest
store size

Related Solutions

Evaluating Turnover and Nontraditional Efficiency Ratios Across Industries The following information is taken from publicly traded...
Evaluating Turnover and Nontraditional Efficiency Ratios Across Industries The following information is taken from publicly traded retailers. The data come from the balance sheet, income statement, and Item 2 on the companies’ Form 10‑K filings. Use the information to answer the requirements. Average Retail SQ # of $ millions Revenue COGS Inventory Footage (000s) Stores Autozone $10,660 $4,902 $3,717 41,066 6,202 Costco 134,497 121,715 9,915 110,700 762 Home Depot 102,793 71,043 12,670 237,700 2,287 Lowe’s 67,744 48,396 11,378 209,000 2,015...
Financial ratios are essential to provide an accurate valuation of a firm. Select a publicly traded...
Financial ratios are essential to provide an accurate valuation of a firm. Select a publicly traded firm of your choice. Select one ratio each in the areas of (a) performance, (b) activity, (c) financing, and (d) liquidity warnings. Provide an evaluation of the selected firm's strengths and weaknesses. Based on the ratios you selected, how well does your chosen firm perform? Explain.
Financial ratios are essential to provide an accurate valuation of a firm. Select a publicly traded...
Financial ratios are essential to provide an accurate valuation of a firm. Select a publicly traded firm of your choice. Select one ratio each in the areas of (a) performance, (b) activity, (c) financing, and (d) liquidity warnings. Provide an evaluation of the selected firm's strengths and weaknesses. Based on the ratios you selected, how well does your chosen firm perform? Explain.
Financial ratios are essential to provide an accurate valuation of a firm. Select a publicly traded...
Financial ratios are essential to provide an accurate valuation of a firm. Select a publicly traded firm of your choice. You may use the firm you have elected to profile for the course-long Financial Analysis and Proposal assignment or a completely different organization altogether. Select one ratio each in the areas of (a) performance, (b) activity, (c) financing, and (d) liquidity warnings. Provide an evaluation of the selected firm's strengths and weaknesses. Based on the ratios you selected, how well...
Financial ratios are essential to provide an accurate valuation of a firm. Select a publicly traded...
Financial ratios are essential to provide an accurate valuation of a firm. Select a publicly traded firm of your choice. Select one ratio each in the areas of (a) performance, (b) activity, (c) financing, and (d) liquidity warnings. Provide an evaluation of the selected firm's strengths and weaknesses. Based on the ratios you selected, how well does your chosen firm perform? Explain. I would like to learn about Verizon Wireless
Financial ratios are essential to provide an accurate valuation of a firm. Select a publicly traded...
Financial ratios are essential to provide an accurate valuation of a firm. Select a publicly traded firm of your choice. Select one ratio each in the areas of (a) performance, (b) activity, (c) financing, and (d) liquidity warnings. Provide an evaluation of the selected firm's strengths and weaknesses. Based on the ratios you selected, how well does your chosen firm perform? Explain. yes list the company . any fortune 500 company will work
Financial ratios are essential to provide an accurate valuation of a firm. Select a publicly traded...
Financial ratios are essential to provide an accurate valuation of a firm. Select a publicly traded firm of your choice. Select one ratio each in the areas of (a) performance, (b) activity, (c) financing, and (d) liquidity warnings. Provide an evaluation of the selected firm's strengths and weaknesses. Based on the ratios you selected, how well does your chosen firm perform? Explain.
Choose a publicly traded company and analyze the financial statements based on the various ratios discussed...
Choose a publicly traded company and analyze the financial statements based on the various ratios discussed in concept 5 (leverage, debt to equity, liquidity ratios, etc.). Provide an overview of how financially healthy the company is and predictions for the future of the company.
You found that three grocery stores having the following market shares: A=.35, B=.50, C=.15. You survey...
You found that three grocery stores having the following market shares: A=.35, B=.50, C=.15. You survey 500 people to see if the market shares have changed and you find the data below. Use the Chi-squared goodness of fit test and ?=.05. A—150 B—250 C—100.
Explain how the below ratio could be affected if there was an increase in Publicly traded...
Explain how the below ratio could be affected if there was an increase in Publicly traded hospital costs or supply chain disruptions occurred for materials including equipment, medications and other supplies? And explain how these ratio can affect the Publicly traded hospital financial statement Increase in costs a. Debt service coverage ratio (Net Income/Debt Service) b. Profit Margin Ratio (Net Income/Net Sales) c. Return on Assets (Net Income/ total assets) Supply chain disruptions a. Current Ratio (Current Assets/Current Liabilities) b....
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT