Calculation guide
Wastage is a fraction of purchased food. Labour hours cover the whole event. Target margin applies to net sales before tax.
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
| Input | Value |
|---|---|
| Guests | 100 |
| Edible food cost per guest | 5 |
| Purchased food lost | 10% |
| Service labour hours | 20 |
| Labour cost per hour | 20 |
| Other event costs | 100 |
| Target margin | 25% |
| Result | Value |
|---|---|
| Event quote before tax | 1,407.407407 |
| Quote per guest | 14.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.
| Input | Original input | New input | Affected result | Original result | New result |
|---|---|---|---|---|---|
| Guests | 100 | 110 | Event quote before tax | 1,407.407407 | 1,481.481481 |
| Edible food cost per guest | 5 | 6 | Event quote before tax | 1,407.407407 | 1,555.555556 |
| Purchased food lost | 10% | 11% | Event quote before tax | 1,407.407407 | 1,415.730337 |
| Service labour hours | 20 | 22 | Event quote before tax | 1,407.407407 | 1,460.740741 |
| Labour cost per hour | 20 | 22 | Event quote before tax | 1,407.407407 | 1,460.740741 |
| Other event costs | 100 | 110 | Event quote before tax | 1,407.407407 | 1,420.740741 |
| Target margin | 25% | 28% | Event quote before tax | 1,407.407407 | 1,466.049383 |
