THE LUNCH NOTEBOOK

Catering Food Cost Calculator

Learn how a catering food cost calculator turns recipe costs into a per-serving figure, and what to set up in a spreadsheet before you price a lunch menu.

2 min read9 viewsCatering Food Cost Calculator
— · 0 votes
Contents
  1. Building the ingredient list
  2. Turning recipe totals into per-serving cost
  3. Setting up a cost spreadsheet
  4. Questions about catering food costs
  5. What does a catering food cost calculator do?
  6. Where can I get a catering food cost calculator Excel download?
  7. How is per-serving cost different from the price I charge?
  8. How do I account for waste in recipe costing?

A catering food cost calculator adds up what each ingredient in a recipe costs and divides the total by the number of servings, so you see the food cost of one plate. You enter ingredient prices and quantities, the recipe yield, and any wastage you want to cover. The result is a per-serving cost you can compare against what you charge for the lunch.

Building the ingredient list

Recipe costing starts with a full ingredient list, written in the same units you buy in. Convert packs to usable amounts so a bag of flour or a tray of rolls matches the quantity the recipe calls for. Include garnish, oil for frying and anything else that reaches the plate. An incomplete list understates the cost of the dish.

Turning recipe totals into per-serving cost

Divide the total recipe cost by the number of portions the recipe actually produces. Use the real yield after trimming, draining or portioning, not the raw weight you started with. A per-serving cost only means something when the serving size matches what you put on the plate. Weigh a few finished portions to confirm the number.

Setting up a cost spreadsheet

A catering cost spreadsheet holds one column of ingredient prices and one row per recipe, with a formula that totals and divides by yield. Update the price cells when suppliers change, and every recipe recalculates. Keep a separate sheet for dishes so the lunch menu can be costed side by side. An Excel download gives you that structure ready to fill in.

Questions about catering food costs

What does a catering food cost calculator do?

A catering food cost calculator totals the cost of a recipe's ingredients and divides it by the servings produced. It gives you a per-serving figure rather than a whole-batch figure. You then compare that figure with the price you charge for the lunch.

Where can I get a catering food cost calculator Excel download?

A catering food cost calculator Excel download is a spreadsheet file with ingredient price cells and recipe rows already linked by formulas. Build your own if you prefer, using one sheet for prices and one for recipes. Check that the formulas divide by yield before you rely on the numbers.

How is per-serving cost different from the price I charge?

Per-serving cost covers only the food that goes into one portion of a dish. The price you charge must also cover labor, energy, equipment, packaging and overhead. Food cost is one input into pricing, not the price itself.

How do I account for waste in recipe costing?

Recipe costing handles waste by using the yield you actually get after trimming, peeling and cooking losses. Enter the trimmed weight as the usable quantity and let the price reflect what you paid for the whole item. A wastage allowance added to the total covers smaller losses in service.

Read next

Latest articles