Food Cost Calculator Formula
3 000 x 100 8 000 37 5.
Food cost calculator formula. Food cost calculation tool. Then multiply the cost of each menu item by the number of times it was sold in a given period of time. If you are looking for the formula to calculate your month end inventory food cost click on this link to go there. Food sales 10 000.
Check out the example below to see this food cost percentage formula in action. Calculate actual food cost for the week using the following food cost formula. To calculate the ideal food cost first determine the food cost of each menu item. Beginning inventory 15 000.
Food cost percentage beginning inventory purchases ending inventory food sales. Then ask yourself whether your menu prices are comparable to the true cost of the item or whether you need to make some adjustments to both the ingredients and the price. Recipe cost cost of ingredients in recipe. Divide your recipe cost by the sale price of the recipe to get your ideal food cost.
In our example we would complete the following equation. Cost of ingredients in recipe. Food cost calculation formula. Find out your potential food cost.
In other words you multiply by the sales mix. To calculate your potential food cost multiply the total cost by 100 then divide that number by your total sales. Let s break that formula down into parts. Food cost percentage formula.
This page details the excel food cost calculation tool for tracking your monthly inventory and is available to premium members for download. Ending inventory 16 000. Our potential food cost is 37 5 of our budget. To calculate the food cost percentage of an individual portion or menu item you simply add up the cost of the ingredient s and divide that result by the menu price.
In case you re not familiar with the manual method for determining food cost percentage let s first take a look at the formula.