I will build an excel catering food cost and portion calculator
Recipe Costing and Kitchen Tools by a Professional Chef
About this Gig
Plan your catering portions and food costs before production. I am a professional chef building an editable Excel planner around your event menu and recipe data. Basic: one event, up to 3 dishes, portion targets, recipe batches and food cost. Standard: up to 8 dishes, ingredient quantity summary and guide. Premium: up to 15 dishes, shopping summary, cost dashboard and guide. Each dish includes up to 15 ingredient lines; separately costed sub-recipes count as dishes. Supply guest counts, portions per guest, extra-portion allowance, recipe yields, ingredient quantities and supplier pack sizes/prices. Whole-batch rounding shows extra production. Includes 10 core formula types for scaling, batch rounding and costing, repeated across your menu; editable formulas included, no macros. One-day delivery with complete inputs. Basic includes 1 revision; Standard/Premium include 2 within scope. Ingredient costs exclude labor, transport, equipment, overhead, taxes and service charges. This planning tool is not a final event quote or demand guarantee. Message first for multiple events or complex menus.
Platform:
Excel
Development technology:
Excel
Expertise:
Formatting
•
Formulas
•
Functions
•
Dashboard
•
Data validation
My Portfolio
FAQ
Can I change the guest count?
Yes. The editable workbook scales planned portions and rounds recipe batches using your supplied yields. You choose and review the extra-portion allowance and production quantities.
Does the total include staffing and delivery?
No. These packages calculate ingredient food costs. Labor, transport, equipment, overhead, taxes and service charges are excluded. The result is not a final customer quote.
What do I need to send before you start?
Send your guest count, event menu, portions per guest, recipe yields and ingredient quantities, plus supplier pack sizes and prices. Include your preferred units and extra-portion allowance. I will flag missing inputs before building the planner.

