1.
Compute inventory turnover for each company for the most recent years shown.
1.
Explanation of Solution
Inventory turnover:
This is the ratio which analyzes the number of times inventory is sold during the period. This ratio gauges the efficacy of inventory management. Larger the ratio, more efficient the inventory management.
Calculate inventory ratio for Company A’s current year as follows:
Calculate inventory ratio for Company A’s one year prior as follows:
Calculate inventory turnover ratio for Company G’s current year as follows:
Calculate inventory turnover ratio for Company G’s one year prior as follows:
2.
Compute days’ sales inventory for each company for three years shown.
2.
Explanation of Solution
Days’ sales Inventory:
Days’ sales in inventory are used to determine number of days a particular company takes to make sales of the inventory available with them.
Calculate days’ sales inventory for the Company A’s current year as follows:
Calculate days’ sales inventory for the company A’s one year prior as follows:
Calculate days’ sales inventory for the Company A’s two year prior as follows:
Calculate days’ sales inventory for the Company G’s current year as follows:
Calculate days’ sales inventory for the Company G’s one year prior as follows:
Calculate days’ sales inventory for the Company G’s two year prior as follows:
3.
a)
Determine whether the inventory turnover of Company A would underperform or outperform.
3.
a)
Explanation of Solution
Company A’s inventory turnover ratio is more than the industry average of 15 for inventory turnover for both the current year and prior year. Hence, Company A is outperformed.
b)
Determine whether the inventory turnover of Company G would underperform or outperform.
b)
Explanation of Solution
Company G’s inventory turnover ratio is more than the industry average of 15 for inventory turnover for both the current year and prior year. Hence, Company G is outperformed.
Want to see more full solutions like this?
Chapter 6 Solutions
Principles of Financial Accounting.
- Last year, Nikkola Company had net sales of 2,299,500,000 and cost of goods sold of 1,755,000,000. Nikkola had the following balances: Refer to the information for Nikkola Company above. Required: Note: Round answers to one decimal place. 1. Calculate the average inventory. 2. Calculate the inventory turnover ratio. 3. Calculate the inventory turnover in days. 4. CONCEPTUAL CONNECTION Based on these ratios, does Nikkola appear to be performing well or poorly?arrow_forwardFinancial statement data for years ending December 31 for Tango Company follow: a. Determine the inventory turnover for 20Y7 and 20Y6. b. Determine the days sales in inventory for 20Y7 and 20Y6. Use 365 days and round to one decimal place. c. Does the change in inventory turnover and the days sales in inventory from 20Y6 to 20Y7 indicate a favorable or an unfavorable trend?arrow_forwardFinancial statement data for years ending December 31 for Holland Company follow: a. Determine the inventory turnover for 20Y4 and 20Y3. b. Determine the days sales in inventory for 20Y4 and 20Y3. Use 365 days and round to one decimal place. c. Does the change in inventory turnover and the days sales in inventory from 20Y3 to 20Y4 indicate a favorable or an unfavorable trend?arrow_forward
- The following selected information is taken from the financial statements of Arnn Company for its most recent year of operations: During the year, Arnn had net sales of 2.45 million. The cost of goods sold was 1.3 million. Required: Note: Round all answers to two decimal places. 1. Compute the current ratio. 2. Compute the quick or acid-test ratio. 3. Compute the accounts receivable turnover ratio. 4. Compute the accounts receivable turnover in days. 5. Compute the inventory turnover ratio. 6. Compute the inventory turnover in days.arrow_forwardAnalyzing Inventory The recent financial statements of McLelland Clothing Inc. include the following data: Required: 1. Calculate McLellands gross profit ratio (rounded to two decimal places), inventory turnover ratio (rounded to three decimal places), and the average days to sell inventory (assume a 365-day year and round to two decimal places) using the FIFO inventory costing method. Be sure to explain what each ratio means. 2. Calculate McLellands gross profit ratio (rounded to two decimal places), inventory turnover ratio (rounded to three decimal places), and the average days to sell inventory (assume a 365-day year and round to two decimal places) using the LIFO inventory costing method. Be sure to explain what each ratio means. 3. CONCEPTUAL CONNECTION Which ratios-the ones computed using FIFO or LIFO inventory values-provide the better indicator of how successful McLelland was at managing and controlling its inventory?arrow_forwardInventory Analysis Singleton Inc. reported the following information for the current year: Required: Compute Singletons (a) gross profit ratio, (b) inventory turnover ratio, and (c) average days to sell inventory. (Note: Round all answers to two decimal places.)arrow_forward
- Use the following hypothetical data for Walgreens in Years 11 and 12 to project revenues, cost of goods sold, and inventory for Year +1. Assume that Walgreenss Year +1 revenue growth rate, gross profit margin, and inventory turnover will be identical to Year 12. Project the average inventory balance in Year +1 and use it to compute the implied ending inventory balance.arrow_forwardInventory Analysis Callahan Company reported the following information for the current year. Required: 1. Compute Callahans (a) gross profit ratio, (b) inventory turnover ratio, and (c) average days to sell inventory. (Round all answers to two decimal places.) 2. Explain the meaning of each number.arrow_forwardUse the following information relating to Medinas Company to calculate the inventory turnover ratio, gross margin, and the number of days sales in inventory ratio, for years 2022 and 2023.arrow_forward
- Inventory Analysis The following account balances are taken from the records of Lewis Inc., a wholesaler of fresh fruits and vegetables: Required Compute Lewiss inventory turnover ratio for 2016 and 2015. Compute the number of days sales in inventory for 2016 and 2015. Assume 360 days in a year. Comment on your answers in parts (1) and (2) relative to the companys management of inventory over the two years. What problems do you see in its inventory management?arrow_forwardAccounts Debit Credit Cash $24,300 Accounts Receivable 42,500 Allowance for Uncollectible Accounts $2,700 Inventory 42,000 Land 79,600 Accounts Payable 29,200 Notes Payable (8%, due in 3 years) 42,000 Common Stock 68,000 Retained Earnings 46,500 Totals $188,400 $188,400 The $42,000 beginning balance of inventory consists of 420 units, each costing $100. During January 2024, Big Blast Fireworks had the following inventory transactions: January 3 Purchase 1,050 units for $115,500 on account ($110 each). January 8 Purchase 1,150 units for $132,250 on account ($115 each). January 12 Purchase 1,250 units for $150,000 on account ($120 each). January 15 Return 160 of the units purchased on January 12 because of defects. January 19 Sell 3,600 units on account for $576,000. The cost of the units sold is determined using a FIFO perpetual inventory system. January 22 Receive $529,000 from customers on accounts receivable. January 24 Pay $359,000 to inventory suppliers on accounts payable. January…arrow_forwardThe following data were extracted from the income statement of Keever Inc.: Current Year Previous Year Sales $788,400 $827,800 Beginning inventories 57,564 39,692 Cost of goods sold 394,200 459,900 Ending inventories 52,164 57,564 a. Determine for each year (1) the inventory turnover and (2) the number of days' sales in inventory. Round interim calculations to the nearest dollar and the final answers to one decimal place. Assume 365 days a year. Current Year Previous Year 1. Inventory turnover fill in the blank 1 fill in the blank 2 2. Number of days' sales in inventory fill in the blank 3 days fill in the blank 4 days b. The inventory position of the business has improveddeteriorated . The inventory turnover has increaseddecreased , while the number of days' sales in inventory has increaseddecreased .arrow_forward
- Financial AccountingAccountingISBN:9781337272124Author:Carl Warren, James M. Reeve, Jonathan DuchacPublisher:Cengage LearningManagerial Accounting: The Cornerstone of Busines...AccountingISBN:9781337115773Author:Maryanne M. Mowen, Don R. Hansen, Dan L. HeitgerPublisher:Cengage LearningPrinciples of Accounting Volume 1AccountingISBN:9781947172685Author:OpenStaxPublisher:OpenStax College
- Managerial AccountingAccountingISBN:9781337912020Author:Carl Warren, Ph.d. Cma William B. TaylerPublisher:South-Western College PubFinancial And Managerial AccountingAccountingISBN:9781337902663Author:WARREN, Carl S.Publisher:Cengage Learning,