Event Planner Workbook: Excel Sheet for Catering Events
The event planner is a one-sheet Excel workbook for catering events. You enter the guests, menu and costs, and it works out the portions, food cost and the price per guest.
What is inside
- Event name, date and guest count
- Menu items with portions per guest and cost per portion
- Calculated portions to prepare, total food cost, service staff needed and price per guest It is an Excel file: yellow cells with blue text are inputs, and the example rows are there to delete.
It suits caterers, hotels and restaurants that host events. It covers food cost only: add labour, hire, transport and overheads before you quote.
Download
Use it with a tool
Use it with: Event and Catering Planner is the web version if you want a quick calculation.
Frequently asked questions
Is the price per guest the final quote?
No. Add labour, equipment hire, transport, service charge and overheads.
How do I keep a record of each event?
Save a copy of the workbook for each event, named with the event and date.
How to use this form
- Open the workbook and delete the example event.
- Enter the event name, date and guest count.
- List each menu item with portions per guest and cost per portion.
- Read the portions, total food cost and price per guest.
- Add labour, hire, transport and overheads to build your quote.
- Save the file under the event’s name and date.
