← All templates

Hotel Banquet Event Costing & Profit

Know if a banquet makes money before you sign it. Per-guest and flat cost lines, labor by role, service charge, event profit, margin %, food and beverage cost % and profit per guest calculate per event. Preview backgrounds are AI-generated; the spreadsheet shown is the real file.

Buy now · $27 Instant download (.xlsx) · Excel & Google Sheets

So easy it explains itself

The first tab is a one-page Instructions sheet. Read it once, then just fill in the light-colored cells.

Why it's easy to use

• Open it and start typing in the light-colored cells. Every total calculates for you.
• Instructions tab in English and Spanish, with a short step-by-step on the first sheet.
• Sample data shows how it works. Clear it and add your own.
• Logo box on the first sheet: drop in your company logo.
• Works in Microsoft Excel and Google Sheets. No macros, no add-ins.

Bilingual: English & Spanish

Instructions are written side by side in English and Spanish, so your whole team can use it. Sepa si un banquete deja ganancia antes de firmarlo. Costos por invitado y fijos, personal por puesto, cargo por servicio, ganancia, % de margen, % de costo y ganancia por invitado por evento.

What's inside

• Events
• Cost Lines
• Labor

Previews