| | | | | | | | | | | | | | . | Room-Night Usage | 945 | 1412 | 2050 | 2000 | 1800 | 2250 | 2025 | 1800 | 1575 | 1350 | 1125 | assumes 75% guest room usage | . | Comp'd Room-Nights | 18 | 28 | 33 | 40 | 36 | 45 | 40 | 36 | 31 | 27 | 22 | | . | Free registrations | | 29 | 132 | 125 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | | . | | | | | | | | | | | | | | . | Per-Attendee Revenue | | | | | | | | | | | | | . | Registration (average, paid) | $185.48 | $209.69 | $301.55 | $300.57 | $259.17 | | | | | | | | . | | | | | | | | | | | | | | . | Revenue | | | | | | | | | | | | | . | Registration | $77,900 | $116,795 | $258,425 | $263,000 | $196,972 | $248,807 | $222,889 | $196,972 | $171,055 | $145,137 | $119,220 | | . | Room Commission | $0 | $0 | $20,295 | $19,800 | $17,820 | $22,275 | $20,048 | $17,820 | $15,593 | $13,365 | $11,138 | upper limit on room-nights? per night? | . | Sponsors | $29,500 | $39,300 | $151,100 | $151,100 | $50,000 | $62,500 | $56,250 | $50,000 | $43,750 | $37,500 | $31,250 | estimates proportional to attendance | . | Tutorial Revenue | $17,300 | $28,070 | $95,600 | $90,880 | $33,000 | $41,250 | $37,125 | $33,000 | $28,875 | $24,750 | $20,625 | estimates proportional to attendance | . | | | | | | | | | | | | | | . | Total Revenue | $124,700 | $184,165 | $525,420 | $524,780 | $297,792 | $374,832 | $336,312 | $297,792 | $259,272 | $220,752 | $182,232 | | . | | | | | | | | | | | | | | . | Per-Attendee Costs | | | | | | | | | | | | | . | Catering (3 day total) | $144 | $165 | $164 | $201 | $201 | $201 | $201 | $201 | $201 | $201 | $201 | | . | Swag | $11 | $13 | $24 | $24 | $20 | $20 | $20 | $20 | $20 | $20 | $20 | | . | | | | | | | | | | | | | | . | Expenses | | | | | | | | | | | | |
|
| | | | | | | | | | | | | | . | Fixed Costs | $37,092 | $46,589 | $103,957 | $128,900 | $85,300 | $85,300 | $85,300 | $85,300 | $85,300 | $85,300 | $85,300 | | . | Tutorial Expenses | $16,404 | $24,028 | $62,662 | $65,050 | $31,500 | $39,375 | $35,438 | $31,500 | $27,563 | $23,625 | $19,688 | | . | Conference Catering | $60,480 | $74,240 | $162,034 | $201,000 | $160,800 | $201,000 | $180,900 | $160,800 | $140,700 | $120,600 | $100,500 | $65,000 catering minimum | . | Sprint Catering | | | $22,756 | $20,000 | | | | | | | | | . | Credit Card Fees | | | $15,763 | $15,743 | $4,824 | $6,030 | $5,427 | $4,824 | $4,221 | $3,618 | $3,015 | estimate: 3% of revenue | . | Vendor Booths | | | $15,110 | $15,110 | $5,000 | $6,250 | $5,625 | $5,000 | $4,375 | $3,750 | $3,125 | estimate: 10% of sponsorship reveneue | . | Room-Night Obligation | $0 | $2,055 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | includes 10% hotel tax | . | Swag | $4,620 | $7,490 | $24,000 | $24,000 | $16,000 | $20,000 | $18,000 | $16,000 | $14,000 | $12,000 | $10,000 | | . | | | | | | | | | | | | | | . | Total Expenses | $118,596 | $154,402 | $406,282 | $469,803 | $303,424 | $357,955 | $330,690 | $303,424 | $276,159 | $248,893 | $221,628 | | . | | | | | | | | | | | | | | . | Profit/Loss | $6,104 | $29,763 | $119,138 | $54,977 | -$5,632 | $16,877 | $5,622 | -$5,632 | -$16,886 | -$28,141 | -$39,395 | | . | | | | | | | | | | | | | | . | | | | | | yellow represents input variables | | | | | | | | . | | | | | | gray represents calculated values; do not edit | | | | | | | | . | | | | | | | | | | | | | | . | | Our room-night obligation is 90% of 760 room-nights (684 room-nights), plus 10% hotel tax, = $75,240. | | | | | | | | | | | | . | | Our total catering (food) obligation is $65,000. | | | | | | | | | | | |
|
|