Guided project · 5 steps Cellwise Plus
Compare catering quotes in Excel
Price four catering quotes for your real headcount, including minimums, and pick the one that fits.
You will use: MAX, ROUND, MIN, XLOOKUP, COUNTIF
Starting data
| A | B | C | D | E | F | G | H | I | |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Caterer | Per person | Service fee | Minimum guests | Total | Per guest | Guests | 85 | |
| 2 | Option A: buffet | 38 | 650 | 75 | Catering budget | 4200 | |||
| 3 | Option B: plated | 52 | 400 | 100 | Cheapest | ||||
| 4 | Option C: food trucks | 24 | 1200 | 60 | Options within budget | ||||
| 5 | Option D: family style | 45 | 0 | 80 | Saving vs priciest |
Build it step by step
Step 1
Caterers charge for at least their minimum number of guests. Work out each total in E2: the larger of your guests (I1) and the minimum, times the price per person, plus the service fee. Fill to E5.
Step 2
What does each option cost per guest who actually comes? Round to cents in F2 and fill to F5.
Step 3
Which option is cheapest? Put its name in I3.
Step 4
How many options fit the catering budget in I2? Put the count in I4.
Step 5
How much do you save by choosing the cheapest option over the most expensive one? Put it in I5.