Open calculator ↗

Catering quote with wastage and service labour · Calculation guide

Estimate event quote before tax using your figures.

Calculation guide

Wastage is a fraction of purchased food. Labour hours cover the whole event. Target margin applies to net sales before tax.

quote = (guests*food/(1-waste/100)+hours*rate+fixed)/(1-margin/100); per = quote/guests

Inputs

Guests

Example entry 100. Use whole numbers.

Edible food cost per guest

Example entry 5 (in the selected currency).

Purchased food lost

Example entry 10 %. Allowed range 0 to 100.

Service labour hours

Example entry 20.

Labour cost per hour

Example entry 20 (in the selected currency).

Other event costs

Example entry 100 (in the selected currency).

Target margin

Example entry 25 %. Allowed range 0 to 100.

Worked example

InputValue
Guests100
Edible food cost per guest5
Purchased food lost10%
Service labour hours20
Labour cost per hour20
Other event costs100
Target margin25%
ResultValue
Event quote before tax1,407.407407
Quote per guest14.074074

Calculation steps

Event quote before tax = (((((Guests × Edible food cost per guest) ÷ (1 − (Purchased food lost ÷ 100))) + (Service labour hours × Labour cost per hour)) + Other event costs) ÷ (1 − (Target margin ÷ 100)))

(((((100 × 5) ÷ (1 − (10 ÷ 100))) + (20 × 20)) + 100) ÷ (1 − (25 ÷ 100))) = 1,407.407407

Quote per guest = (Event quote before tax ÷ Guests)

(1,407.407407 ÷ 100) = 14.074074

How each input affects this example

Each row starts from the worked example and changes one input.

InputOriginal inputNew inputAffected resultOriginal resultNew result
Guests100110Event quote before tax1,407.4074071,481.481481
Edible food cost per guest56Event quote before tax1,407.4074071,555.555556
Purchased food lost10%11%Event quote before tax1,407.4074071,415.730337
Service labour hours2022Event quote before tax1,407.4074071,460.740741
Labour cost per hour2022Event quote before tax1,407.4074071,460.740741
Other event costs100110Event quote before tax1,407.4074071,420.740741
Target margin25%28%Event quote before tax1,407.4074071,466.049383
Catering quote with wastage and service labour →

Sources