In: Finance
5.Beakman, Inc. has ending inventory of $400,000, and a cost of goods sold for the year ended $3,800,000. What is the inventory turnover? The days’ sales in inventory? (10 Points)
(Use Excel and Excel Formulas)
Ending Inventory | 400,000 | |
Cost of goods sold | 3,800,000 | |
Inventory Turnover = Cost of goods sold/Inventory | 9.50 | times |
Days sales in Inventory = 365/Inventory Turnover | 38.42 | days |