Question

Exercise 6-49 (Algorithmic) Analyzing Inventory Examining the recent financial statements of McLelland Clothing, Inc., you note...

Exercise 6-49 (Algorithmic)
Analyzing Inventory

Examining the recent financial statements of McLelland Clothing, Inc., you note the following:

Sales $754,693
Cost of goods sold 506,700
Average inventory 76,900

Required:

Calculate McLelland's gross profit ratio, inventory turnover ratio, and assuming a 365-day year, the average days to sell inventory. (Use two decimal places for gross profit ratio and average days to sell inventory, three decimal places for inventory turnover ratio.)

Gross profit ratio   %
Inventory turnover ratio
Average days to sell inventory   days

Homework Answers

Answer #1

The correct answer is :

Gross profit ratio 32.86 %
Inventory turnover ratio 6.589
Average days to sell inventory   55.39 days

Note:

Gross profit = Sales - Cost of goods sold

= $ 754,693 - $ 506,700

= $ 247,993

Gross Profit Ratio =Gross profit / Sales *100

= $ 247,993 / $ 754,693 *100

= 32.86%

Inventory turnover ratio = Cost of goods sold / Average inventory

= 506,700 / 76,900

= 6.589076723

= 6.589

Average days to sell inventory = 365 Days /Inventory turnover ratio

= 365 / 6.589076723

= 55.39471087

= 55.39 days

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
E7-13 Analyzing and Interpreting the Inventory Turnover Ratio [LO 7-5] Aegis Industries Inc. is the biggest...
E7-13 Analyzing and Interpreting the Inventory Turnover Ratio [LO 7-5] Aegis Industries Inc. is the biggest snowmobile manufacturer in the world. It reported the following amounts in its financial statements (in millions):       2012    2011    2010   2009   Net Sales Revenue $ 4,700 $ 4,160 $ 3,490 $ 3,070   Cost of Goods Sold 4,020 3,550 3,050 2,670   Average Inventory 470 420 360 350    Required: 1-a. Calculate the inventory turnover ratio for 2012, 2011, and 2010. (Round your answers to 1...
Accounts Receivable and Inventory Turnover The following data (in millions) were adapted from recent financial statements...
Accounts Receivable and Inventory Turnover The following data (in millions) were adapted from recent financial statements of Apple Inc (AAPL). Year 2 Year 1 Sales $233,715 $182,795 Cost of goods sold 140,089 112,258 Operating income 71,230 52,503 Average accounts receivable 33,713 27,816 Average inventory 2,230 1,938 1. Compute the accounts receivable turnover for Years 1 and 2. Round to one decimal place. Accounts Receivable Turnover Year 2 Year 1 2. Compute the number of days' sales in receivables for Years...
Ivanhoe Inc. has sales of $2,700,000, a gross profit margin of 35.0 percent, and inventory of...
Ivanhoe Inc. has sales of $2,700,000, a gross profit margin of 35.0 percent, and inventory of $1,000,000. What are the company’s inventory turnover ratio and days’ sales in inventory? (Round inventory turnover ratio to 3 decimal places, e.g. 12.555 and days' sales in inventory to 1 decimal place, e.g. 12.5. Use 365 days for calculation.) Inventory turnover ratio times Days’ sales in inventory days
Recent financial statements of Larkspur Ship Builders, Inc. report net sales of $668,500,000. Accounts receivable are...
Recent financial statements of Larkspur Ship Builders, Inc. report net sales of $668,500,000. Accounts receivable are $64,400,000 at the beginning of the year and $90,500,000 at the end of the year. (Round answers to 2 decimal places, e.g. 50.27. Use 365 days for calculation.) Compute Larkspur’s accounts receivable turnover. Accounts receivable turnover    times Compute Larkspur’s average collection period for accounts receivable in days. Average collection period for accounts receivable    days
Brief Exercise 6-16 Calculate inventory ratios (LO6-7) Use the following information: Net sales $ 175,000 Cost...
Brief Exercise 6-16 Calculate inventory ratios (LO6-7) Use the following information: Net sales $ 175,000 Cost of goods sold 120,000 Beginning inventory 40,000 Ending inventory 30,000 a. Calculate the inventory turnover ratio. (Round your answer to 1 decimal place.) b. Calculate the average days in inventory. (Assume 365 days in a year. Round your intermediate calculations and final answer to 1 decimal place.) c. Calculate the gross profit ratio. (Round your answer to 2 decimal place.)
The following information is available for Splish Brothers Inc. for three recent fiscal years. 2022 2021...
The following information is available for Splish Brothers Inc. for three recent fiscal years. 2022 2021 2020 Inventory $580,000 $590,000 $320,000 Net sales 1,950,000 1,750,000 1,350,000 Cost of goods sold 1,462,500 1,228,500 938,000 (a) Calculate the inventory turnover, days in inventory, and gross profit rate for 2022 and 2021. (Round inventory turnover to 1 decimal place, e.g. 5.2, days in inventory to 0 decimal places, e.g. 125 and gross profit rate to 1 decimal place, e.g. 5.2%.) 2022 2021 Inventory...
The following information is available for Tamarisk, Inc. for three recent fiscal years. 2022 2021 2020...
The following information is available for Tamarisk, Inc. for three recent fiscal years. 2022 2021 2020 Inventory $568,000 $578,000 $345,000 Net sales 1,910,000 1,775,000 1,370,000 Cost of goods sold 1,661,700 1,384,500 954,000 (a) Calculate the inventory turnover, days in inventory, and gross profit rate for 2022 and 2021. (Round inventory turnover to 1 decimal place, e.g. 5.2, days in inventory to 0 decimal places, e.g. 125 and gross profit rate to 1 decimal place, e.g. 5.2%.) 2022 2021 Inventory Turnover...
Exercise 9-23 The financial statements of ConAgra Foods, Inc.’s 2014 annual report disclose the following information....
Exercise 9-23 The financial statements of ConAgra Foods, Inc.’s 2014 annual report disclose the following information. (in millions) 2014 2013 2012 Year-end inventories $2,201 $2,077 $2,341 Fiscal Year 2014 2013 Net sales $17,703 $15,427 Cost of goods sold 13,980 11,864 Net income 315 786 Compute ConAgra’s (a) inventory turnover and (b) the average days to sell inventory for 2014 and 2013.
question 24 The following data were taken from Castle, Inc. Cost of goods sold $894,000 Inventory,...
question 24 The following data were taken from Castle, Inc. Cost of goods sold $894,000 Inventory, end of year 78,000 Inventory, beginning of the year 92,000 Determine the inventory turnover ratio and the number of days' sales in inventory for Castle Inc. Round to two decimal places. Use a 365-day year. Inventory turnover fill in the blank 1 Number of days' sales in inventory fill in the blank 2 days
Exercise 6-11 a-c Suppose this information is available for PepsiCo, Inc. for 2020, 2021, and 2022....
Exercise 6-11 a-c Suppose this information is available for PepsiCo, Inc. for 2020, 2021, and 2022. (in millions) 2020 2021 2022 Beginning inventory $2,100 $2,600 $2,900 Ending inventory 2,600 2,900 3,000 Cost of goods sold 22,795 26,400 26,255 Sales revenue 41,000 44,000 43,980 Calculate the inventory turnover for 2020, 2021, and 2022. (Round inventory turnover to 1 decimal place, e.g. 5.1.) 2020 2021 2022 Inventory turnover enter an inventory turnover times enter an inventory turnover times enter an inventory turnover...