Average inventory turnover = Cost of goods sold / Average inventory
Average invenory = (Opening balance + Ending balance) /2
= (200000 + 230000) /2
= 215000
Average inventory turnover = 1600000 / 215000
= 7.44 Times
The company's current inventory turnover is higher than the industry average which means that the inventory is efficiently managed by the Livingston Lumber co. when compared with the industry
Q.S. 17-11 . • Livingston Lumber Company begins the year with $200,000 of goods in inventory....
Endor Company begins the year with $110,000 of goods in inventory. At year-end, the amount in inventory has increased to $118,000. Cost of goods sold for the year is $1,300,000. Compute Endor's inventory turnover and days' sales in inventory. Assume that there are 365 days in the year. Choose Numerator: Inventory Turnover Choose Denominator: = Inventory Turnover = Inventory Turnover times Days' Sales in Inventory Choose Denominator: x Days = Days' Sales in Inventory x 365 = Days' sales in...
Save Help Endor Company begins the year with $90,000 of goods in inventory. At year-end, the amount in inventory has increased to $103,000. Cost of goods sold for the year is $600,000. Compute Endor's inventory turnover and days' sales in inventory. Assume that there are 365 days in the year. Inventory Turnover Choose Numerator: Choose Denominator: Inventory Turnover Inventory Turnover times Days' Sales in Inventory Days Days' Sales in Inventory Choose Denominator Choose Numerator: 365 Days'sales in inventory x days...
A company begins the year with inventory of $46,000 and ends the year with inventory of $60,000. During the year, the following amounts are recorded: Purchases $ 230,000 Purchase returns 23,000 Purchase discounts 12,000 Freight-in 33,000 Calculate cost of goods sold for the year. Cost of goods sold:
Steve's Auto Shop began the year with an inventory of $12,050. Purchases during the year totaled $70,600. The inventory at the end of the year was $13,530. a. What was the cost of goods sold? $ b. What was the average inventory? $ c. What was the turnover? Round your answer to two decimal places.
A7X Corporation has ending inventory of $698,973 and cost of goods sold for the year just ended was $4,054,513. a. What is the inventory turnover? (Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.) b. What is the days' sales in inventory? (Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.) c. How long on average did a unit of inventory sit on the shelf before it was...
The King Corporation has ending inventory of $386,735, and cost of goods sold for the year just ended was $4,981,315. a.What is the inventory turnover? (Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.)b.What is the days' sales in inventory? (Use 365 days a year. Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.)c.How long on average did a unit of inventory sit on the shelf before it...
Net Sales Cost of goods sold Average accounts receivable for the year Accounts receivable at year-end Average inventory for the year Inventory at year-end $1,095,000 657,000 44,250 18,000 226,000 158,400 Required: a. Calculate the inventory turnover for 2019. (Round your answer to 2 decimal places.) b. Calculate the number of days' sales in inventory for 2019, using year-end inventories. (Use 365 days a year. Round your answer to 1 decimal place.) c. Calculate the accounts receivable turnover for 2019. (Round...
Skiller Company has the following information regarding its inventory for the second year of operations. Transactions Units Sales in units Unit Cost Beginning Inventory, January 1 35,000 $3.50 Purchases February 8 45,500 3.60 March 15 100,250 3.80 April 10 62,000 4.10 Units sold – April 22 at $12 155,000 Purchases May 9 81,000 4.35 June 19 28,000 4.56 Units sold – August 11 at $14 115,500 Purchases September 20 15,000 4.75 October 30...
A7X Corporation has ending inventory of $625,817, and cost of goods sold for the year just ended was $9,758,345 a. What is the inventory turnover? (Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.) b. What is the days' sales in inventory? (Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.) c. How long on average did a unit of inventory sit on the shelf before it was...
Problem 13-17 The U.S. Airfilter company has hired you as a supply chain consultant. The company makes air filters for residential heating and air-conditioning systems. These filters are made in a single plant located in Louisville, Kentucky, in the United States. They are distributed to retailers through wholesale centers in 100 locations in the United States, Canada, and Europe. You have collected the following data relating to the value of inventory in the U.S. Airfilter supply chain: QUARTER 1 (JANUARY...