Pro package
Catering Event Quote Workbook
Menu cost per guest, staff and rentals with markup, service charge, tax, deposit and a margin check.
Excel · SheetsMenu cost per guest, staff and rentals with markup, service charge, tax, deposit and a margin check.
What's included:
- Menu: cost per portion × portions per guest, total portions
- Menu price per guest at your food-cost target
- Staff, rentals, travel and disposables with markup
- Service charge, tax, deposit and balance
- Gross profit and margin per event
- Excel, Google Sheets and LibreOffice
Preview: what's inside
Settings Settings
| Setting | Value |
|---|---|
| Guest count | 80 |
| Target food-cost % (food cost ÷ menu price) | 32% |
| Service charge | 18% |
| Sales tax | 7% |
| Deposit to confirm the date | 30% |
| Round per-guest price up to | 0.50 |
Summary Quote
- Food cost per guest
- Menu price per guest (at target food cost)
- Food total
- Staff, rentals & other charges
- Subtotal
- Service charge
- Tax
- Quote total
Sheet Menu — One row per dish.
| Dish | Course | Cost per portion | Portions per guest | Food cost per guest | Total portions | Total food cost | Allergens / notes |
|---|---|---|---|---|---|---|---|
| Smoked salmon blini | Canapés | 0.85 | 2 | auto | auto | auto | Fish, gluten |
| Caprese skewers | Canapés | 0.55 | 2 | auto | auto | auto | Dairy; vegetarian |
| Herb roast chicken | Main | 3.40 | 1 | auto | auto | auto |
Sheet Event costs — Everything that isn't food.
| Item | Cost type | Qty / hours | Unit cost | Markup % | Cost | Charge |
|---|---|---|---|---|---|---|
| Servers (4 × 6 h) | Staff | 24 | 22.00 | 25% | auto | auto |
| Chef on site | Staff | 7 | 30.00 | 25% | auto | auto |
| Linen & chafing dishes | Rentals | 1 | 180.00 | 15% | auto | auto |
Preview generated from the actual file: sample rows are example data you replace with your own; formulas fill the calculated columns.
Good to know
- Instant digital download. Nothing physical is shipped.
- Licensed for personal and single-business use.
- 30-day fix-or-refund if a file doesn't work as described (terms).
- Support: eclipsekingdom.support@gmail.com