#Days sales in inventory formula how to

Therefore, the days in inventory for Pet Food Solutions equals 521.95 days. Use the result of dividing the average inventory by the cost of goods sold to find the days in inventory by multiplying it by the number of days in the period you're examining.īecause the period for the Pet Food Solutions example is one year, you can multiply 365 by the result from the previous step, which is 1.43.

Multiply the results by the number of days in the period This results in a figure of 1.43, rounded to the nearest hundredth.

Take the value of average inventory and divide it by the cost of goods sold to complete the first part of the two-step formula for days in inventory.Ĭonsidering Pet Food Solutions as an example, this part of the calculation should divide $10,000, the average inventory, by $7,000, the cost of goods sold. Divide the average inventory by the cost of goods sold For example, if you want to consider a period of two months from March through April, your period length would be 61.įor the example of Pet Food Solutions, the period length is one year, so you'll represent this value as 365. Whichever period you decide to evaluate, you should represent the period length as a number of days. Determine the period lengthĬhoose the length of the period you want to find the days in inventory for.

#Days sales in inventory formula how to

Related: Cost of Goods Sold: Definition, Uses and How To Calculate 3. Therefore, the cost of goods sold is $7,000. In the example with Pet Food Solutions, if the company has a cost of goods of $3,000, the calculation can read ($12,000 + $3,000) - $8,000. Then, subtract the value of inventory held at the end of the period you're measuring. This can include the cost of materials, labor and anything else that the company pays for in order to manufacture their goods. To determine the cost of goods sold, add the value of inventory held at the beginning of the period to the cost of goods. Then, divide that number by two to find the average.įor example, if Pet Food Solutions begins the year with $12,000 of inventory and ends the year with $8,000 of inventory, their average inventory is $10,000. To find the average inventory, add the value for the number of inventory units a company has at the beginning of the period to the value of inventory units at the end of the period. Find the average inventoryĭetermine the average inventory for the company you want to calculate days in inventory for. Here are five steps for calculating days in inventory: 1. Related: How To Calculate Inventory Turnover Ratio (With Tips) 5 steps to calculate days in inventory Inventory Turnover Ratio = Cost of Goods Sold / Inventory To calculate inventory ratio, you can divide the cost of goods sold by the average inventory for the same period using this formula A high inventory turnover indicates that a company is selling its inventory at a fast pace and that there's a market demand for its product. The turnover ratio measures how efficiently a company sells its inventory. Inventory turnover describes any products that a company sells and then replaces. Related: How To Track Inventory What is inventory turnover ratio? This number is often 365 for the number of days in one year.Īverage inventory : Average inventory is the number of units a company typically holds in inventory.Ĭost of goods sold : Cost of goods sold is the money required to produce the products in a company's inventory. Period length: Period length refers to the amount of time you want to calculate the days in inventory for.

To calculate days in inventory, you need these details: You can calculate days in inventory with this formula:ĭays in Inventory = (Average Inventory / Cost of Goods Sold) x Period Length Related: Days Sales in Inventory (DSI) Definition and Example How to calculate days in inventory If a company finds that its conversion through sales is slow, this can show which areas might need additional help, such as building or revising a brand image or adapting to changes in the industry. Finding a company's days in inventory can tell you about its efficiency in terms of operations and finances, as it shows how rapidly a company can sell its inventory.Ī low days in inventory figure can indicate that the company is exchanging its products for cash quickly and that they're operating efficiently. Some organizations call it days inventory outstanding or inventory days of supply. Days in inventory is the average time a company keeps its inventory before they sell it.