Inventory Turnover = Cost of goods sale / Average inventory
Current year = Cost of goods sold / (Beginning inventory + Closing Inventory/2)
= 9270000 / (940000 + 1120000/2)
=v 9270000/ 1030000 = 9 times
Previous year = 1080000/ ( 860000+940000/2)
= 1080000/900000
= 12 times
Number of days sales in inventory = Number of days in a year / Inventory turnover
Current year = 365 / 9 = 40.55
previous year = 365/12 = 30.42
The following data were extracted from the income statement of Keever Inc.: Current Year Previous Year...
Inventory Analysis The following data were extracted from the income statement of Keever Inc.: Current Year Previous Year Sales $1,168,000 $1,222,000 Beginning inventories 87,720 86,244 Cost of goods sold 584,000 678,900 Ending inventories 79,320 87,720 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...
Inventory Analysis The following data were extracted from the income statement of Keever Inc. Current Year Previous Year $1,474,600 Sales Beginning inventories Cost of goods sold Ending inventories 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. $1,537,400 103,086 854,100 77,632 77,632 737,300 70,232 Current Year Previous Year 1. Inventory turnover...
Inventory Analysis The following data were extracted from the income statement of Keever Inc.: Inventory Analysis The following data were extracted from the income statement of Keever Inc. Previous Year $841,000 57,336 467,200 45,650 Current Year Sales Beginning inventories Cost of goods sold Ending inventories 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...
Inventory Analysis The following data were extracted from the income statement of Keever Inc.: Current Year Previous Year Sales $890,600 $932,900 Beginning inventories 61,704 47,914 Cost of goods sold 445,300 518,300 Ending inventories 55,904 61,704 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...
Inventory Analysis The following data were extracted from the income statement of Keever Inc.: Current Year Previous Year Sales $1,430,800 $1,498,000 Beginning inventories 108,884 100,868 Cost of goods sold 715,400 832,200 Ending inventories 98,484 108,884 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...
(a) Vertically analyze the financial data (current year only) in Exercise 17-11. (b) Calculate how long it took Keever Inc. to sell its inventory (current year only). Show and briefly explain your work. EX 17-11 nventory analysis The following data were extracted from the income statement of Keever Inc.: OBJ. 3 r, Sales Beginning inventories Cost of goods sold Ending inventories Current Year $18,500,000 940,000 9,270,000 1,120,000 Previous Year $20,000,000 860,000 10,800,000 940,000
Vertically analyze the financial data (current year only) in Exercise 17-11. (b) Calculate how long it took Keever Inc. to sell its inventory (current year only). Show your work The following data were extracted from the income statement of Keever Inc.: Sales Beginning inventories Cost of goods sold Ending inventories Current Year $18,500,000 940,000 9,270,000 120,000 Previous Year $20,000,000 860,000 10,800,000 940,000
Book board - Show Me Calculator Inventory Analysis The following data were extracted from the income statement of Shriver Inc.: Current Year Prior Year Sales $963,600 $1,011,800 Beginning inventories 55,400 46,204 Cost of merchandise sold 481,800 562,100 Ending inventories 50,200 55,400 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...
Connolly - Outlo Course: BU-1152-05 Financial My Home CengageNOWV2 Online teachi.. Cengage Learning Dyeislife Hoodie eBook Show Me How Calculator Print Item Inventory Analysis The following data were extracted from the income statement of Shriver Inc.: Current Year Prior Year Sales $17,900,000 $18,100,000 Beginning inventories 760,000 700,000 Cost of merchandise sold 8,964,000 9,782,000 Ending Inventories 900,000 760,000 a. Determine for each year (1) the inventory turnover and (2) the number of days' sales in Inventory. Round interim calculations to the...
Inventory Turnover and Days' Sales in Inventory The following financial statement data for years ending December 31 for Holland Company are shown below. 20Y4 20Y3 Cost of merchandise sold $1,284,800 $784,385 Inventories: Beginning of year $263,530 $184,690 End of year 378,870 263,530 a. Determine the inventory turnover for 20Y4 and 20Y3. Round to one decimal place. Inventory Turnover 20Y4 20Y3 b. Determine the days' sales in inventory for 20Y4 and 20Y3. Assume 365 days a year. Round interim calculations and...