Suppose this information (in millions) is available for the Automotive and Other Operations Divisions of General Motors Corporation for a recent year. General Motors uses the LIFO inventory method.Beginning inventory$15,860Ending inventory18,300Current assets73,444Current liabilities85,400Cost of goods sold203,252Sales revenue217,160(a)Calculate the inventory turnover and days in inventory. (Round answers to 1 decimal place, e.g. 52.7. Use 365 days for calculation.)Inventory Turnoverenter a number of times rounded to 1 decimal place timesDays in Inventoryenter a number of days rounded to 1 decimal place days
Question
Suppose this information (in millions) is available for the Automotive and Other Operations Divisions of General Motors Corporation for a recent year. General Motors uses the LIFO inventory method.Beginning inventory$15,860Ending inventory18,300Current assets73,444Current liabilities85,400Cost of goods sold203,252Sales revenue217,160(a)Calculate the inventory turnover and days in inventory. (Round answers to 1 decimal place, e.g. 52.7. Use 365 days for calculation.)Inventory Turnoverenter a number of times rounded to 1 decimal place timesDays in Inventoryenter a number of days rounded to 1 decimal place days
Solution
Para calcular a rotatividade do estoque, podemos usar a fórmula: Custo dos produtos vendidos dividido pelo estoque médio. O estoque médio pode ser calculado somando o estoque inicial e o estoque final e dividindo por 2.
Custo dos produtos vendidos = 15,860 Estoque final = $18,300
Estoque médio = (15,860 + 18,300) / 2 = $17,080
Rotatividade do estoque = Custo dos produtos vendidos / Estoque médio Rotatividade do estoque = 203,252 / 17,080 = 11.9 vezes (arredondado para 1 casa decimal)
Para calcular os dias em estoque, podemos usar a fórmula: 365 dias dividido pela rotatividade do estoque.
Dias em estoque = 365 / Rotatividade do estoque Dias em estoque = 365 / 11.9 = 30.7 dias (arredondado para 1 casa decimal)
Portanto, a rotatividade do estoque é de 11.9 vezes e os dias em estoque são de 30.7 dias.
Similar Questions
Rifle Co. had the following inventory information available: Date Transactions Purchases Sales Units Unit Cost Units 1 Sep Beginning inventory 300 $100 3 Sep Purchases 100 $84 5 Sep Sales 250 10 Sep Purchases 250 $80 15 Sep Sales 200 20 Sep Purchases 250 $76 28 Sep Sales 150 Assume that the company uses LIFO method under the periodic inventory system to estimate cost of goods sold, please calculate the amount of ending inventory at the end of September
If a company carries 13 weeks of supply, what is the inventory turnover?a.0.077b.676c.7.77d.4e.0.25
Consider the following financial statement information for XYZ Marketing Inc. Calculate the operating and cash cycle. Assume that year has 365 days. When you are done with your calculations, please fill in the blanks below. Round your answers based on math rules to two decimals and days to whole number (whole days).Inventory turnover is 5.71 times. Inventory period is 365 days.Receivables turnover is Blank 3 times.Receivables period is 365 days. Operating cycle is 365 days. Payables turnover is Blank 6 times.Payables period is Blank 7 days.
A company just starting business made the following four inventory purchases in June: June 1 150 Units $780 June 10 200 units $1 170 June 15 200 units $1 260 June 28 150 units $990 TOTAL $4 200 A physical count of inventory on June 30 reveals that there are 250 units on hand. Using the LIFO inventory method, the value of the ending inventory on June 30 is: Group of answer choices $2 835. $1,620. $2,580. $1,365.
The GMA corporation shows the following data related to an item of InventoryInventory, January 1 100 units @P50 Purchases, January 9 300 units @ P54 Purchases, January 19 90 units @ P60 Sales, January 20 340 units What will be the ending inventory in units using FIFO?
Upgrade your grade with Knowee
Get personalized homework help. Review tough concepts in more detail, or go deeper into your topic by exploring other relevant questions.