Calculation guide
The minimum applies only to food and drink. Add the separate fixed hire fee once. Enter comparable tax-inclusive quotes.
Inputs
Guests
Example entry 80. Allowed range 0.0 to 100000.0. Use whole numbers.
Venue A cost per guest
Example entry 60 (in the selected currency).
Venue A minimum spend
Example entry 5000 (in the selected currency).
Venue A fixed hire
Example entry 300 (in the selected currency).
Venue B cost per guest
Example entry 65 (in the selected currency).
Venue B minimum spend
Example entry 4000 (in the selected currency).
Venue B fixed hire
Example entry 200 (in the selected currency).
Worked example
| Input | Value |
|---|---|
| Guests | 80 |
| Venue A cost per guest | 60 |
| Venue A minimum spend | 5,000 |
| Venue A fixed hire | 300 |
| Venue B cost per guest | 65 |
| Venue B minimum spend | 4,000 |
| Venue B fixed hire | 200 |
| Result | Value |
|---|---|
| Venue A total | 5,300 |
| Venue B total | 5,400 |
| Venue A cost above B | -100 |
Calculation steps
Venue A total = (max(Venue A minimum spend, (Guests × Venue A cost per guest)) + Venue A fixed hire)
(max(5,000, (80 × 60)) + 300) = 5,300
Venue B total = (max(Venue B minimum spend, (Guests × Venue B cost per guest)) + Venue B fixed hire)
(max(4,000, (80 × 65)) + 200) = 5,400
Venue A cost above B = (Venue A total − Venue B total)
(5,300 − 5,400) = -100
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 | 80 | 88 | Venue A total | 5,300 | 5,580 |
| Venue A cost per guest | 60 | 66 | Venue A total | 5,300 | 5,580 |
| Venue A minimum spend | 5,000 | 5,500 | Venue A total | 5,300 | 5,800 |
| Venue A fixed hire | 300 | 330 | Venue A total | 5,300 | 5,330 |
| Venue B cost per guest | 65 | 72 | Venue B total | 5,400 | 5,960 |
| Venue B fixed hire | 200 | 220 | Venue B total | 5,400 | 5,420 |
