Methodology
Catering Event Profitability Planner methodology
Set an event quote and price per guest that cover the entered menu and delivery plan while protecting margin and minimum contribution. Quote a catering event from guest count, menu portions, ingredient waste, kitchen and service labour, venue, equipment, logistics, contingency and a minimum contribution.
Educational only: Business decision support, not accounting, tax or legal advice.
Privacy: Calculations run locally; Margin101 does not receive your commercial inputs.
Update policy: Reviewed when formulas or official dependencies change.
Scope: Market-neutral small-business planning using your own assumptions.
1. Formulas and units
quotedRevenueExTax = guest count * quoted price per guestWhere
- guestCount
- Event guest count (whole guests/event)Source: Business record
- quotedPricePerGuestExTax
- Quoted price per guest (currency units/guest, ex tax)Source: Business record
- quotedRevenueExTax
- Quoted event revenue (currency units, ex tax)Source: Calculated output
foodCostExTax = sum(guests * portions per guest * portion cost / (1 - waste rate))Where
- foodCostExTax
- Waste-adjusted food cost (currency units, ex tax)Source: Calculated output
labourCostExTax = sum(labour hours * loaded hourly cost)Where
- labourCostExTax
- Event labour cost (currency units, ex tax)Source: Calculated output
eventBaseCostExTax = food + labour + venue/equipment + logisticsWhere
- venueAndEquipmentCostExTax
- Venue and equipment cost (currency units/event, ex tax)Source: Business record
- logisticsCostExTax
- Event logistics cost (currency units/event, ex tax)Source: Business record
- foodCostExTax
- Waste-adjusted food cost (currency units, ex tax)Source: Calculated output
- labourCostExTax
- Event labour cost (currency units, ex tax)Source: Calculated output
- eventBaseCostExTax
- Event base cost (currency units, ex tax)Source: Calculated output
contingencyExTax = event base cost * contingency rateWhere
- contingencyRate
- Event contingency rate (decimal fraction of event base cost)Source: Business record
- eventBaseCostExTax
- Event base cost (currency units, ex tax)Source: Calculated output
- contingencyExTax
- Event contingency (currency units, ex tax)Source: Calculated output
protectedEventCostExTax = event base cost + contingencyWhere
- eventBaseCostExTax
- Event base cost (currency units, ex tax)Source: Calculated output
- contingencyExTax
- Event contingency (currency units, ex tax)Source: Calculated output
- protectedEventCostExTax
- Protected event cost (currency units, ex tax)Source: Calculated output
contributionExTax = quoted revenue - protected event costWhere
- quotedRevenueExTax
- Quoted event revenue (currency units, ex tax)Source: Calculated output
- protectedEventCostExTax
- Protected event cost (currency units, ex tax)Source: Calculated output
- contributionExTax
- Quoted event contribution (currency units, ex tax)Source: Calculated output
contributionMargin = contribution / quoted revenueWhere
- quotedRevenueExTax
- Quoted event revenue (currency units, ex tax)Source: Calculated output
- contributionExTax
- Quoted event contribution (currency units, ex tax)Source: Calculated output
- contributionMargin
- Quoted event margin (decimal rate)Source: Calculated output
requiredEventQuoteExTax = maximum of target-margin quote and minimum-contribution quoteWhere
- targetMargin
- Target event margin (decimal fraction of quoted event revenue)Source: Business record
- minimumEventContributionExTax
- Minimum event contribution (currency units/event, ex tax)Source: Business record
- contributionExTax
- Quoted event contribution (currency units, ex tax)Source: Calculated output
- contributionMargin
- Quoted event margin (decimal rate)Source: Calculated output
- requiredEventQuoteExTax
- Required event quote (currency units, ex tax)Source: Calculated output
requiredPricePerGuestExTax = required event quote / guest countWhere
- guestCount
- Event guest count (whole guests/event)Source: Business record
- requiredEventQuoteExTax
- Required event quote (currency units, ex tax)Source: Calculated output
- requiredPricePerGuestExTax
- Required price per guest (currency units, ex tax)Source: Calculated output
quoteGapExTax = quoted revenue - required event quoteWhere
- quotedRevenueExTax
- Quoted event revenue (currency units, ex tax)Source: Calculated output
- requiredEventQuoteExTax
- Required event quote (currency units, ex tax)Source: Calculated output
- quoteGapExTax
- Quote gap (currency units, ex tax)Source: Calculated output
Money inputs and outputs use the currency selected in the scenario without changing the canonical methodology. Rates, margins, utilisation and buffers are entered as percentages and converted to decimal values for calculation.
2. Worked example
Input assumptions
The worked rows below are evaluated at render time by the same shared engine and visible default fixture as the interactive workflow.
- Event guest count
- 100 whole guests/event
- Quoted price per guest
- 50 currency units/guest, ex tax
- Main portions per guest
- 1 portions/guest
- Main cost per portion
- 10 currency units/main portion, ex tax
- Main ingredient waste rate
- 0.05 decimal fraction of main ingredient requirement lost
- Side portions per guest
- 1 portions/guest
- Side cost per portion
- 3 currency units/side portion, ex tax
- Side ingredient waste rate
- 0.04 decimal fraction of side ingredient requirement lost
- Kitchen labour hours
- 10 hours/event
- Kitchen loaded cost per hour
- 50 currency units/hour, ex tax
- Service labour hours
- 20 hours/event
- Service loaded cost per hour
- 30 currency units/hour, ex tax
- Venue and equipment cost
- 500 currency units/event, ex tax
- Event logistics cost
- 200 currency units/event, ex tax
- Event contingency rate
- 0.1 decimal fraction of event base cost
- Target event margin
- 0.3 decimal fraction of quoted event revenue
- Minimum event contribution
- 1,000 currency units/event, ex tax
Calculation and outputs
Quoted event revenue
quotedRevenueExTax = guest count * quoted price per guest- Event guest count
- 100 whole guests/event
- Quoted price per guest
- 50 currency units/guest, ex tax
- Main portions per guest
- 1 portions/guest
- Side portions per guest
- 1 portions/guest
- Quoted event contribution
- 1,518.355263 money
- Quoted event margin
- 0.303671 percent
- Required price per guest
- 49.737782 money
Engine result: 5,000 money
Waste-adjusted food cost
foodCostExTax = sum(guests * portions per guest * portion cost / (1 - waste rate))- Event guest count
- 100 whole guests/event
- Quoted price per guest
- 50 currency units/guest, ex tax
- Main portions per guest
- 1 portions/guest
- Main cost per portion
- 10 currency units/main portion, ex tax
- Main ingredient waste rate
- 0.05 decimal fraction of main ingredient requirement lost
- Side portions per guest
- 1 portions/guest
- Side cost per portion
- 3 currency units/side portion, ex tax
- Side ingredient waste rate
- 0.04 decimal fraction of side ingredient requirement lost
- Kitchen loaded cost per hour
- 50 currency units/hour, ex tax
- Service loaded cost per hour
- 30 currency units/hour, ex tax
- Venue and equipment cost
- 500 currency units/event, ex tax
- Event logistics cost
- 200 currency units/event, ex tax
- Event contingency rate
- 0.1 decimal fraction of event base cost
- Event labour cost
- 1,100 money
- Event base cost
- 3,165.131579 money
- Protected event cost
- 3,481.644737 money
- Required price per guest
- 49.737782 money
Engine result: 1,365.131579 money
Event labour cost
labourCostExTax = sum(labour hours * loaded hourly cost)- Main cost per portion
- 10 currency units/main portion, ex tax
- Side cost per portion
- 3 currency units/side portion, ex tax
- Kitchen labour hours
- 10 hours/event
- Kitchen loaded cost per hour
- 50 currency units/hour, ex tax
- Service labour hours
- 20 hours/event
- Service loaded cost per hour
- 30 currency units/hour, ex tax
- Venue and equipment cost
- 500 currency units/event, ex tax
- Event logistics cost
- 200 currency units/event, ex tax
- Waste-adjusted food cost
- 1,365.131579 money
- Event base cost
- 3,165.131579 money
- Protected event cost
- 3,481.644737 money
Engine result: 1,100 money
Event base cost
eventBaseCostExTax = food + labour + venue/equipment + logistics- Kitchen labour hours
- 10 hours/event
- Service labour hours
- 20 hours/event
- Venue and equipment cost
- 500 currency units/event, ex tax
- Event logistics cost
- 200 currency units/event, ex tax
- Waste-adjusted food cost
- 1,365.131579 money
- Event labour cost
- 1,100 money
Engine result: 3,165.131579 money
Event contingency
contingencyExTax = event base cost * contingency rate- Event guest count
- 100 whole guests/event
- Main cost per portion
- 10 currency units/main portion, ex tax
- Main ingredient waste rate
- 0.05 decimal fraction of main ingredient requirement lost
- Side cost per portion
- 3 currency units/side portion, ex tax
- Side ingredient waste rate
- 0.04 decimal fraction of side ingredient requirement lost
- Kitchen loaded cost per hour
- 50 currency units/hour, ex tax
- Service loaded cost per hour
- 30 currency units/hour, ex tax
- Venue and equipment cost
- 500 currency units/event, ex tax
- Event logistics cost
- 200 currency units/event, ex tax
- Event contingency rate
- 0.1 decimal fraction of event base cost
- Target event margin
- 0.3 decimal fraction of quoted event revenue
- Minimum event contribution
- 1,000 currency units/event, ex tax
- Quoted event revenue
- 5,000 money
- Waste-adjusted food cost
- 1,365.131579 money
- Event labour cost
- 1,100 money
- Event base cost
- 3,165.131579 money
- Protected event cost
- 3,481.644737 money
- Quoted event contribution
- 1,518.355263 money
- Quoted event margin
- 0.303671 percent
- Required event quote
- 4,973.778195 money
Engine result: 316.513158 money
Protected event cost
protectedEventCostExTax = event base cost + contingency- Event guest count
- 100 whole guests/event
- Main cost per portion
- 10 currency units/main portion, ex tax
- Side cost per portion
- 3 currency units/side portion, ex tax
- Kitchen loaded cost per hour
- 50 currency units/hour, ex tax
- Service loaded cost per hour
- 30 currency units/hour, ex tax
- Venue and equipment cost
- 500 currency units/event, ex tax
- Event logistics cost
- 200 currency units/event, ex tax
- Event contingency rate
- 0.1 decimal fraction of event base cost
- Target event margin
- 0.3 decimal fraction of quoted event revenue
- Minimum event contribution
- 1,000 currency units/event, ex tax
- Quoted event revenue
- 5,000 money
- Waste-adjusted food cost
- 1,365.131579 money
- Event labour cost
- 1,100 money
- Event base cost
- 3,165.131579 money
- Event contingency
- 316.513158 money
- Quoted event contribution
- 1,518.355263 money
- Quoted event margin
- 0.303671 percent
- Required event quote
- 4,973.778195 money
Engine result: 3,481.644737 money
Quoted event contribution
contributionExTax = quoted revenue - protected event cost- Event guest count
- 100 whole guests/event
- Quoted price per guest
- 50 currency units/guest, ex tax
- Main cost per portion
- 10 currency units/main portion, ex tax
- Side cost per portion
- 3 currency units/side portion, ex tax
- Kitchen loaded cost per hour
- 50 currency units/hour, ex tax
- Service loaded cost per hour
- 30 currency units/hour, ex tax
- Venue and equipment cost
- 500 currency units/event, ex tax
- Event logistics cost
- 200 currency units/event, ex tax
- Event contingency rate
- 0.1 decimal fraction of event base cost
- Target event margin
- 0.3 decimal fraction of quoted event revenue
- Minimum event contribution
- 1,000 currency units/event, ex tax
- Quoted event revenue
- 5,000 money
- Waste-adjusted food cost
- 1,365.131579 money
- Event labour cost
- 1,100 money
- Event base cost
- 3,165.131579 money
- Event contingency
- 316.513158 money
- Protected event cost
- 3,481.644737 money
- Quoted event margin
- 0.303671 percent
- Required event quote
- 4,973.778195 money
Engine result: 1,518.355263 money
Quoted event margin
contributionMargin = contribution / quoted revenue- Quoted price per guest
- 50 currency units/guest, ex tax
- Minimum event contribution
- 1,000 currency units/event, ex tax
- Quoted event revenue
- 5,000 money
- Quoted event contribution
- 1,518.355263 money
Engine result: 0.303671 percent
Required event quote
requiredEventQuoteExTax = maximum of target-margin quote and minimum-contribution quote- Target event margin
- 0.3 decimal fraction of quoted event revenue
- Minimum event contribution
- 1,000 currency units/event, ex tax
- Quoted event contribution
- 1,518.355263 money
- Quoted event margin
- 0.303671 percent
- Quote gap
- 26.221805 money
Engine result: 4,973.778195 money
Required price per guest
requiredPricePerGuestExTax = required event quote / guest count- Event guest count
- 100 whole guests/event
- Quoted price per guest
- 50 currency units/guest, ex tax
- Main portions per guest
- 1 portions/guest
- Side portions per guest
- 1 portions/guest
- Event logistics cost
- 200 currency units/event, ex tax
- Event contingency rate
- 0.1 decimal fraction of event base cost
- Target event margin
- 0.3 decimal fraction of quoted event revenue
- Minimum event contribution
- 1,000 currency units/event, ex tax
- Quoted event revenue
- 5,000 money
- Event labour cost
- 1,100 money
- Event base cost
- 3,165.131579 money
- Event contingency
- 316.513158 money
- Protected event cost
- 3,481.644737 money
- Quoted event contribution
- 1,518.355263 money
- Quoted event margin
- 0.303671 percent
- Required event quote
- 4,973.778195 money
- Quote gap
- 26.221805 money
Engine result: 49.737782 money
Quote gap
quoteGapExTax = quoted revenue - required event quote- Event guest count
- 100 whole guests/event
- Quoted price per guest
- 50 currency units/guest, ex tax
- Event logistics cost
- 200 currency units/event, ex tax
- Event contingency rate
- 0.1 decimal fraction of event base cost
- Target event margin
- 0.3 decimal fraction of quoted event revenue
- Minimum event contribution
- 1,000 currency units/event, ex tax
- Quoted event revenue
- 5,000 money
- Event labour cost
- 1,100 money
- Event base cost
- 3,165.131579 money
- Event contingency
- 316.513158 money
- Protected event cost
- 3,481.644737 money
- Quoted event contribution
- 1,518.355263 money
- Quoted event margin
- 0.303671 percent
- Required event quote
- 4,973.778195 money
- Required price per guest
- 49.737782 money
Engine result: 26.221805 money
Example
The worked rows below are evaluated at render time by the same shared engine and visible default fixture as the interactive workflow.
- Quoted event revenue
- 5,000 currency units
- Waste-adjusted food cost
- 1,365.13 currency units
- Event labour cost
- 1,100 currency units
- Event base cost
- 3,165.13 currency units
- Event contingency
- 316.51 currency units
- Protected event cost
- 3,481.64 currency units
- Quoted event contribution
- 1,518.36 currency units
- Quoted event margin
- 30.4%
- Required event quote
- 4,973.78 currency units
- Required price per guest
- 49.74 currency units
- Quote gap
- 26.22 currency units
The exact engine-derived outputs are shown in the labelled rows below.
Interpretation
Event contribution depends on the complete event-specific food, labour and logistics scope.
Scenario study: event threshold and capacity
Event break-even must use one capacity unit
Guests, paid tickets, tables and minimum-spend revenue are not interchangeable. Convert revenue and variable cost to the same event unit before dividing fixed cost.
Input basis
- Revenue: 75 CU per attendee; variable cost: 45 CU per attendee.
- Event fixed cost: 3,900 CU; declared capacity: 120 attendees.
- All amounts are fictional and before indirect tax.
| Row | Intermediate calculation | Result |
|---|---|---|
| Contribution per attendee | 75 − 45 | 30 CU |
| Exact threshold | 3,900 ÷ 30 | 130 attendees |
| Capacity gap | 120 − 130 | −10 attendees |
| Feasibility | 130 required > 120 capacity | Infeasible on stated capacity |
Interpretation
The arithmetic is valid, but the event cannot reach break-even within the entered attendee capacity. A different commercial unit must be translated completely before recalculation.
Boundaries and next step
- No attendance forecast, venue benchmark, fee preset or recommended minimum spend is supplied.
- Changing from attendees to tables requires per-table revenue, variable cost and capacity.
Continue with Catering Event Profitability Planner or catering quote checklist.
3. Validation and boundary checks
- All inputs must be finite and inside the visible validation boundaries.
- Rates are retained as decimal values and shown as percentages only at the presentation boundary.
- The worked fixture must expose every declared result: quotedRevenueExTax, foodCostExTax, labourCostExTax, eventBaseCostExTax, contingencyExTax, protectedEventCostExTax, contributionExTax, contributionMargin, requiredEventQuoteExTax, requiredPricePerGuestExTax, quoteGapExTax.
- Scenario comparison changes one declared driver while holding the remaining industry records constant.
- Event guest count minimum
guestCount ≥ 0 whole guests/event— A lower value is rejected before calculation.- Event guest count maximum
guestCount ≤ 100,000,000 whole guests/event— A higher value is rejected before calculation.- Quoted price per guest minimum
quotedPricePerGuestExTax ≥ 0 currency units/guest, ex tax— A lower value is rejected before calculation.- Quoted price per guest maximum
quotedPricePerGuestExTax ≤ 10,000,000 currency units/guest, ex tax— A higher value is rejected before calculation.- Main portions per guest minimum
mainPortionsPerGuest ≥ 0 portions/guest— A lower value is rejected before calculation.- Main portions per guest maximum
mainPortionsPerGuest ≤ 1,000 portions/guest— A higher value is rejected before calculation.- Main cost per portion minimum
mainCostPerPortionExTax ≥ 0 currency units/main portion, ex tax— A lower value is rejected before calculation.- Main cost per portion maximum
mainCostPerPortionExTax ≤ 10,000,000 currency units/main portion, ex tax— A higher value is rejected before calculation.- Main ingredient waste rate minimum
mainWasteRate ≥ 0 decimal fraction of main ingredient requirement lost— A lower value is rejected before calculation.- Main ingredient waste rate maximum
mainWasteRate ≤ 1 decimal fraction of main ingredient requirement lost— A higher value is rejected before calculation.- Side portions per guest minimum
sidePortionsPerGuest ≥ 0 portions/guest— A lower value is rejected before calculation.- Side portions per guest maximum
sidePortionsPerGuest ≤ 1,000 portions/guest— A higher value is rejected before calculation.- Side cost per portion minimum
sideCostPerPortionExTax ≥ 0 currency units/side portion, ex tax— A lower value is rejected before calculation.- Side cost per portion maximum
sideCostPerPortionExTax ≤ 10,000,000 currency units/side portion, ex tax— A higher value is rejected before calculation.- Side ingredient waste rate minimum
sideWasteRate ≥ 0 decimal fraction of side ingredient requirement lost— A lower value is rejected before calculation.- Side ingredient waste rate maximum
sideWasteRate ≤ 1 decimal fraction of side ingredient requirement lost— A higher value is rejected before calculation.- Kitchen labour hours minimum
kitchenHours ≥ 0 hours/event— A lower value is rejected before calculation.- Kitchen labour hours maximum
kitchenHours ≤ 100,000 hours/event— A higher value is rejected before calculation.- Kitchen loaded cost per hour minimum
kitchenLoadedCostPerHourExTax ≥ 0 currency units/hour, ex tax— A lower value is rejected before calculation.- Kitchen loaded cost per hour maximum
kitchenLoadedCostPerHourExTax ≤ 10,000,000 currency units/hour, ex tax— A higher value is rejected before calculation.- Service labour hours minimum
serviceHours ≥ 0 hours/event— A lower value is rejected before calculation.- Service labour hours maximum
serviceHours ≤ 100,000 hours/event— A higher value is rejected before calculation.- Service loaded cost per hour minimum
serviceLoadedCostPerHourExTax ≥ 0 currency units/hour, ex tax— A lower value is rejected before calculation.- Service loaded cost per hour maximum
serviceLoadedCostPerHourExTax ≤ 10,000,000 currency units/hour, ex tax— A higher value is rejected before calculation.- Venue and equipment cost minimum
venueAndEquipmentCostExTax ≥ 0 currency units/event, ex tax— A lower value is rejected before calculation.- Venue and equipment cost maximum
venueAndEquipmentCostExTax ≤ 10,000,000 currency units/event, ex tax— A higher value is rejected before calculation.- Event logistics cost minimum
logisticsCostExTax ≥ 0 currency units/event, ex tax— A lower value is rejected before calculation.- Event logistics cost maximum
logisticsCostExTax ≤ 10,000,000 currency units/event, ex tax— A higher value is rejected before calculation.- Event contingency rate minimum
contingencyRate ≥ 0 decimal fraction of event base cost— A lower value is rejected before calculation.- Event contingency rate maximum
contingencyRate ≤ 1 decimal fraction of event base cost— A higher value is rejected before calculation.- Target event margin minimum
targetMargin ≥ 0 decimal fraction of quoted event revenue— A lower value is rejected before calculation.- Target event margin maximum
targetMargin ≤ 0.99 decimal fraction of quoted event revenue— A higher value is rejected before calculation.- Minimum event contribution minimum
minimumEventContributionExTax ≥ 0 currency units/event, ex tax— A lower value is rejected before calculation.- Minimum event contribution maximum
minimumEventContributionExTax ≤ 10,000,000 currency units/event, ex tax— A higher value is rejected before calculation.
4. Assumptions and source classification
- Costs, capacity, contract terms, tax rates and targets are supplied by the user.
- No provider default, jurisdictional rule or industry benchmark is embedded.
- The shared engine retains full precision and display formatting never feeds calculation.
This planner has no current policy-data dependency. Its commercial assumptions are user supplied. Registered family-level regression suites exercise the shared business-logic engine and worked-result reconciliation.
5. Limitations
- Results are only as reliable as the timing, scope and basis of the entered records.
- The workflow does not predict demand or establish accounting, tax, contractual or legal treatment.
- Labour rates, waste, contingency and minimum contribution are editable event assumptions; no wage rule, service charge, tax rate or hospitality benchmark is embedded.
- Food-safety, licensing, venue, staffing and contract obligations remain outside this commercial quote model.
This is educational decision support, not tax, accounting, legal or financial advice. Check the treatment of your actual transactions under the rules that apply to your business and seek qualified advice where appropriate.
6. Update and evidence policy
Registered family-level suites test formula invariants and example reconciliation; the release ledger records that coverage without claiming a separate oracle for every line of public copy. There is no official threshold or benchmark to refresh for this planner. Commercial inputs remain user-supplied because they vary by business and contract.
Change history
- : Initial public release of the planner and methodology after pre-launch calculation, content, source and interaction review.
Related reading
Guides to interpret the decision and its assumptions.
- Catering Economics: Price, Guests and Capacity
Connect price per head, guest count, event-specific cost and constrained capacity before accepting an event.
Read guide - Minimum Guest Count and Minimum Spend
Derive a bounded event floor from contribution and committed cost without presenting it as a market benchmark.
Read guide - Buffet, Plated or Drop-Off: Compare the Cost Model
Compare service formats on aligned food, labour, equipment, transport and capacity assumptions.
Read guide