Running a Wedding & Event Venue: Date Pricing, Packages, Minimum Spends, Capacity Layouts, Booking Lead Times & Profit per Event
Run a venue that hosts weddings, parties and corporate days. You will price dates by weekday and season, build packages and minimum spends, fit guest numbers to room layouts, track the booking pipeline and lead times, plan deposits and staffing per event and see which dates and event types really make money, with every cell checked as you go.
One-time payment · lifetime access · lessons, labs, exam and certificate included · no subscription.
About this course
This course runs a small fictional wedding and event venue in a spreadsheet. You price dates from a rate card by weekday and season with WEEKDAY, XLOOKUP and INDEX/MATCH, apply a last-minute discount, and compare hire-only with all-inclusive packages by contribution and margin. You charge shortfalls on minimum spends, turn floor areas into capacities and tables with INT and ROUNDUP, and measure the enquiry funnel, lead times and open Saturdays. Then you date deposits with EDATE, apply a fictional cancellation scale, add up cash by month with SUMIFS, staff each event and finish with contribution by event type, season profit, a loss flag and a chart.
Lessons
- Date Pricing: A Rate Card by Weekday and Season Pro
- Packages: Hire Only vs All-Inclusive and the Margin on Add-Ons Pro
- Minimum Spends: Room Hire vs a Food & Drink Minimum and Shortfall Charges Pro
- Layouts and Capacity: Guests per Layout, Tables Needed and Split Rooms Pro
- The Booking Pipeline: Enquiries, Viewings, Bookings and Lead Times Pro
- Deposits and Cancellations: Payment Schedules, a Cancellation Scale and Cash by Month Pro
- Staffing per Event: Ratios, Guest Bands, Set-Up Hours and Labour Cost Pro
- Profit per Event and Season: Contribution by Type, Loss-Making Dates and a P&L Pro