Running a Wedding & Event Venue: Date Pricing, Packages, Minimum Spends, Capacity Layouts, Booking Lead Times & Profit per Event

What you'll build

What you will be able to do

Each lab ends with a concrete result that you build yourself and the checker confirms, cell by cell.

• Turn each event date into a day type and a season, look up the price on a two-way rate card and apply a fictional last-minute discount, the way a venue prices every quote.
• Price one 110-guest wedding as hire only and as two all-inclusive packages, compare contribution in dollars with margin in percent, and add up what last season's add-ons really earned.
• Look up the minimum spend for each room and day, charge the shortfall when a small group spends less, and work out how many guests or how much spend per guest would reach the minimum.
• Turn floor areas and fictional space-per-guest assumptions into a capacity grid, count the tables an event needs, test whether a group fits a room and find the largest wedding when the ceremony and the dinner use different rooms.
• Measure the enquiry funnel by source with pooled conversion rates, count the lead time from booking to event with DAYS, and find how many Saturdays of next year are still for sale.
• Date a payment plan with EDATE, apply a fictional cancellation scale with an approximate XLOOKUP, work out a refund and add up the cash due in each month.
• Staff each event from a fictional service plan: servers from a guests-per-server ratio, bar staff from guest bands, total hours including set-up and turn-around, and the labour cost per guest.
• Add up the contribution per event type with SUMIFS, compute the season profit after fixed costs, flag the events that lost money and chart where the money really comes from.