Calendar Hospitality Convention/Meeting Planning Details Identify the components of a meeting/event budget. Construct an excel template with formulas. Use the example in the book to get started. And you have to use your own formulas. There are templates out there to see how it is done. You can use the example from OTY AMT INCOME Registration Income Member Early Member. Late Nonmember - Early Nonmember - Late Students - Early Students - Late Speakers Emeritus Honorary Guest - Early Guest Late Exhibitor Press Miscellaneous Registration Gross Registration Revenue Credits/Cancellations Net Registration Revenue 300 35 150 40 75 6 85 4 10 3 45 10 12 755 -5 750 $495 5595 $695 $695 $225 $325 $0 $50 $175 $275 $0 SO $0 $14.500 $20.25 $89,260 $27.000 $16.875 $1.950 $0 $200 $1,750 5825 $0 50 SO $307.975 $2.225 $305,750 . 53 15 2 3 73 Exhibits Income Commercial Non-profit Comos Nonprofit Literature Displays Subtotal Exhibits $1200 $800 $0 $63,600 $12.000 $0 $1,500 $77,100 $500 Sponsorships & Grants Sponsored Sessions Sponsored Breaks Sponsored Lunches Sponsored Receptions Unrestricted Educational Grants Tote Bags Miscellaneous Subtotal Sponsorship 2 2 1 1 1 1 $10,000 $5,000 $25,000 $50,000 $10,000 $8,000 $2,225 $20.000 $10,000 $25.000 $50.000 $1,000 $8,000 $2.225 $116,225 60 $175 40 $275 Miscellaneous Income CME & CEU Income Exhibitor Reception Tickets Advertising List Orders Interest & Investment Miscellaneous Subtotal Miscellaneous $24,000 $10.500 $21,000 $11,000 $500 $1,000 $68,000 5567075 TOTAL INCOME FIGURE 3.2 Calendar Hospitality Convention/Meeting Planning Details Identify the components of a meeting/event budget. Construct an excel template with formulas. Use the example in the book to get started. And you have to use your own formulas. There are templates out there to see how it is done. You can use the example from OTY AMT INCOME Registration Income Member Early Member. Late Nonmember - Early Nonmember - Late Students - Early Students - Late Speakers Emeritus Honorary Guest - Early Guest Late Exhibitor Press Miscellaneous Registration Gross Registration Revenue Credits/Cancellations Net Registration Revenue 300 35 150 40 75 6 85 4 10 3 45 10 12 755 -5 750 $495 5595 $695 $695 $225 $325 $0 $50 $175 $275 $0 SO $0 $14.500 $20.25 $89,260 $27.000 $16.875 $1.950 $0 $200 $1,750 5825 $0 50 SO $307.975 $2.225 $305,750 . 53 15 2 3 73 Exhibits Income Commercial Non-profit Comos Nonprofit Literature Displays Subtotal Exhibits $1200 $800 $0 $63,600 $12.000 $0 $1,500 $77,100 $500 Sponsorships & Grants Sponsored Sessions Sponsored Breaks Sponsored Lunches Sponsored Receptions Unrestricted Educational Grants Tote Bags Miscellaneous Subtotal Sponsorship 2 2 1 1 1 1 $10,000 $5,000 $25,000 $50,000 $10,000 $8,000 $2,225 $20.000 $10,000 $25.000 $50.000 $1,000 $8,000 $2.225 $116,225 60 $175 40 $275 Miscellaneous Income CME & CEU Income Exhibitor Reception Tickets Advertising List Orders Interest & Investment Miscellaneous Subtotal Miscellaneous $24,000 $10.500 $21,000 $11,000 $500 $1,000 $68,000 5567075 TOTAL INCOME FIGURE 3.2