A catering quote that says a rate per plate is not the full cost. Put each caterer's per-plate rate, fixed extras and service charge into a small grid, run it against three guest counts, and you can see the real total for each scenario and what every extra fifty guests adds. All rates below are placeholders for you to replace.
How do I lay out the sheet?
Put the guest-count scenarios in a row and the caterers in rows. Keep service charge as its own column and do not fold it into the plate rate, because it is applied to different things by different caterers.
| Caterer | Per plate (₹) | Fixed extras (₹) | Service charge |
|---|---|---|---|
| Caterer A | 850 | 30,000 | 5% |
| Caterer B | 780 | 45,000 | 10% |
| Caterer C | 950 | 15,000 | 0% |
Fixed extras are things charged once, such as a live counter, extra staff or crockery. Enter them as one line each if the quote lists them separately.
What formula gives the total for a guest count?
Suppose the guest counts 300, 400 and 500 sit in F1, G1 and H1, and Caterer A's per-plate rate is in B2, extras in C2 and service charge in D2. In F2 enter the following and copy it across and down:
=($B2*F$1+$C2)*(1+$D2)
It multiplies the per-plate rate by guests, adds fixed extras, then adds the service charge on top. Check with your caterer whether service charge applies to extras as well as food, and whether taxes are already in the rate; adjust the formula to suit.
What do the three scenarios come to?
| Guests | Caterer A (₹) | Caterer B (₹) | Caterer C (₹) |
|---|---|---|---|
| 300 | 2,99,250 | 3,06,900 | 3,00,000 |
| 400 | 3,88,500 | 3,92,700 | 3,95,000 |
| 500 | 4,77,750 | 4,78,500 | 4,90,000 |
Caterer B has the lowest rate per plate yet is the dearest at 300 guests, because its extras and service charge are the highest. Caterer C looks costly per plate, but with no service charge it is close. The order changes with guest count, which a plain rate comparison would never show.
What does each extra fifty guests cost?
In a cell below the grid use =$B2*50*(1+$D2). For the three placeholders that gives ₹44,625 for A, ₹42,900 for B and ₹47,500 for C. Check A: the step from 400 to 500 guests costs ₹89,250, and half of that is ₹44,625. Use this to decide quickly whether an uncertain invitation list is worth a bigger buffer.
What else should be in the quote comparison?
- Menu items per plate: number of starters, mains, desserts and live counters.
- Whether staff, crockery, water, ice and cleaning are included.
- Overtime charges if the function runs late.
- Whether the rate includes taxes.
- Payment schedule: advance amount, balance date, and refund terms.
Write down the date of each quote and how long it stays valid, since rates for a peak wedding date can move. Ask how the final count is fixed, for example three days before the function, and what happens to the bill if more guests arrive on the day than you told them.
Before you decide
Tell each caterer the same guest count and menu, so the quotes compare like with like. Visit or taste if you can, and ask for the final quote in writing with each line separate. Add the winning total to your wedding budget sheet as a fixed line, and a separate line for the buffer. Finally, if you pay in instalments from your bank account, SpendixAI can keep each payment, with its receipt attached, next to the rest of your records.
Keep the grid in the same file as your wedding budget so the chosen total flows into it, and update the guest-count row as invitations are confirmed. The scenario that matches your final list becomes your budget line.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


