Enter your Cost of Goods Sold (COGS), beginning inventory, and ending inventory to calculate your food inventory turnover ratio and days in inventory. See how quickly your restaurant or food business sells and replenishes stock — a higher ratio means fresher product and less waste.
Inventory Turnover Ratio
--
Days in Inventory (DII)
--
Average Inventory Value
--
Performance Rating
--
Divide your Cost of Goods Sold (COGS) by your average inventory value. Average inventory is calculated as (Beginning Inventory + Ending Inventory) ÷ 2. For example, if your COGS is $120,000 and your average inventory is $13,500, your turnover ratio is 8.89x.
Divide the number of days in your period by the inventory turnover ratio. This tells you on average how many days it takes to sell through your entire food inventory. For instance, a turnover ratio of 8.89 over a year means you turn inventory roughly every 41 days.
Food businesses typically aim for a ratio between 4 and 12 per year, though restaurants and perishable-heavy operations often target 12 or higher. Higher turnover indicates fresher product, less spoilage, and better cash flow — but extremely high turnover can signal stockout risks.
Food inventory is highly perishable, making turnover a critical metric. A low turnover ratio can indicate overstocking, spoilage, or poor sales — all of which hurt profitability. Tracking this ratio helps you reduce waste, improve ordering efficiency, and maintain fresh product quality.
Common strategies include implementing a FIFO (first in, first out) stock rotation system, refining purchase order quantities based on sales data, negotiating more frequent smaller deliveries from suppliers, and removing or discounting slow-moving menu items or products.
A low ratio suggests you are holding more inventory than you are selling within a given period. In food service, this often leads to spoilage, increased waste costs, and tied-up working capital. It may also signal menu items that aren't selling, over-purchasing, or inaccurate demand forecasting.
Average inventory smooths out fluctuations by averaging the value at the start and end of a period. Using average inventory instead of a single snapshot gives a more accurate picture of typical stock levels, making the turnover ratio more meaningful across seasonal food businesses.
Quick-service restaurants and grocery stores typically have very high turnover (15–30+) due to perishable daily stock. Full-service restaurants may range from 10–20. Food manufacturers or distributors carrying shelf-stable goods often see ratios of 4–10. Comparing against your specific segment is key.