Group & MICE Sales Toolkit for Hotels: Group Sales Workbook and Templates

Full description

This toolkit is for group sales managers, MICE sales executives and banquet sales teams who need one consistent way to price, contract and manage group business. It suits hotels, conference venues and event spaces. A new salesperson can use it from day one. An experienced one can replace scattered spreadsheets and old Word files.

Save with a bundle: this template is also in the Hotel Sales, Marketing & Revenue Bundle, 14 templates for $39 instead of $100. All 141 templates are in the All-Access Hospitality Template Library for $79.

The workbook prices a group from rooms, food and beverage, meeting rooms and AV, tests the quote against the transient business it displaces, then tracks the group from contract to final bill. The playbook gives the wording and the method: how to answer an RFP, write a proposal, run a site inspection, negotiate and check a contract. The forms are ready to print.

What is inside

Group_Sales_Workbook.xlsx (11 tabs, 1,973 formulas, 3 charts, 17 data validation rules)

• Start Here: tab guide, five steps, colour legend
• Settings: hotel inputs, pace curve, cancellation fee scale, drop-down lists
• Quote Calculator: rooms by night and type, F&B, meeting rooms, AV, comps, service charge, tax, deposits, profit check
• Displacement: night-by-night transient displacement and break-even group rate
• Contracts: 25 rows with cut-off dates, deposit status and attrition guarantee
• Rooming List: 150 rows with date checks that feed pickup
• Pickup Tracker: 12 groups, 6 checkpoints, target pace, projected final, attrition exposure
• Event Pipeline: 40 rows with stage probability and next-action flags
• Attrition: 9 pickup scenarios and a cancellation fee calculator
• Post-Event Review: 20 rows comparing actual with quoted revenue
• Dashboard: 12 key figures and 3 charts

Group_Sales_Playbook.docx (27 pages when rendered, 10 chapters and 3 appendices)

• Group sales terms and a qualification scoring grid
• RFP response template with cover letter and section text
• 3 proposal templates: corporate meeting, residential conference, social event
• Pricing and displacement guide with a worked example
• Site inspection guide with a 90-minute plan
• Negotiation guide with a concession ladder and authority levels
• Contract clause checklist with 40 clauses (generic, verify with counsel)
• Dated group lifecycle plan and 8 email templates

Forms.pdf and Forms.docx (8 pages): site inspection checklist, group handover form to operations, post-event review.

Also included: README.txt and the license terms.

How it works

1. Enter your hotel inputs in Settings: inventory, costs, tax, deposit and cut-off defaults.
2. Price an enquiry in Quote Calculator and check Displacement. Read the decision flag.
3. Send the RFP response or proposal from the playbook templates.
4. Record signed groups in Contracts. Update Pickup Tracker at each checkpoint.
5. Hand over to operations with Form 2, then log results in Post-Event Review.

Details

• Formats: XLSX, DOCX, PDF (forms), TXT.
• Language: English. A4 layout. Currency is an editable input.
• Software: Excel 2010 or later, or LibreOffice Calc, for the workbook. Word or a compatible editor for the documents.
• Delivery: digital download. Nothing is shipped.

Good to know

• All sample names, rates and figures are illustrative. They are not benchmarks or quotes. Replace them with your own.
• Tax, service charge, deposits, attrition and cancellation terms are inputs. Verify local requirements.
• The contract checklist is a general aid, not legal advice. Have counsel review your contracts.
• Single-user license. Do not redistribute.

FAQ

What software do I need? Excel 2010 or later, or LibreOffice Calc, plus Word or a compatible editor. The forms also come as a PDF for printing.

Does it work in Google Sheets? You can import the workbook into Google Sheets. Check the drop-down lists and charts after import. Excel gives the most reliable result.

Can I edit everything? Yes. Blue cells are inputs, formulas are visible, and the documents are fully editable. Add your own rates, terms and branding.

Is this a physical product or a refundable item? It is a digital download. Nothing is shipped. Refunds follow the store policy for digital products.

Who is it for? Group and MICE sales managers, banquet sales, conference services and sales directors who set up a group sales process.

Does it replace my reservation system? No. It prices, tracks and plans group business. You still book rooms in your own system.