How To Calculate Food Cost In Excel. Keep in mind that this is the ideal food cost percentage and doesn’t account for things like spillage, theft, and inconsistent portion sizes. Figure out the recipe costs of menu item with our free spreadsheet template.
Menu & recipe cost template: Free & easy to use food cost calculator for excel. Any words or terms you’re not sure on?
Table of Contents
Calculate The Cost Of Each Dish.
Calculate your total cost of goods sold (cogs). Therefore, the production cost of the company add up to $1.39 million for the period. Total food cost percentage = (total cost of goods sold / total revenue) x 100.
Keep Reading To Find Out What The Causes For High Food Cost Are And What You Can Do To Reduce Food Cost Percentage.
Free excel food cost calculator. How to calculate food cost? Find out if you’re spending too much with our excel food cost template.
This Free Food Cost Calculator Works Out Food Cost Per Dish And Helps You Calculate Food Cost Percentage.
3,000 / 9,000 = 0,33 = 33%. To calculate ideal food cost percentage, divide total food costs into total food sales. Click and drag to the bottom of your table.
Calculate The Actual Food Costs For The Week Using The Formula Above.
Free & easy to use food cost calculator for excel. Check out the example below to see this food cost percentage formula in action: Download now for free and watch the video tutorial.
The 2 Nd Column Is Used To Write The Budget Allocation Of The Expense Category.
Hover over the bottom right of the box until a cross appears. 200 x 3 = $600. Figure out the recipe costs of menu item with our free spreadsheet template.