PyCon 2009 Budget
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
View only
 
 
Still loading...
ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACAD
1
PyCon 2009 BudgetTo be approved by the PSF Board.
2
Chicago ILIf you want to play with the numbers, please make a copy first (File -> Create a Copy...).
3
2006200720082009200920092009
4
ActualActualActualCurrentProbableBudgetAttendance Speculation
5
Total Attendance420586989650120012001600140012001000900800
6
Room-Nights, Crowne945141220500700700933817700583525467assumes 70% guest room usage
7
Room-Nights, Hyatt0192019202,6672,3332,0001,6671,5001,333
8
Comp'd Room-Nights1828330141418161411109
9
Free registrations291320150150150150150150150150
10
11
Per-Attendee Revenue
12
Registration (average, paid)$185.48$209.69$301.55$0.00$357.14$355.65
13
14
Revenue
15
Registration$77,900$116,795$258,425$0$375,000$373,433$515,693$444,563$373,433$302,303$266,738$231,173
16
Room Commission$0$0$20,295$0$33,270$33,270$45,800$40,075$34,350$28,625$25,763$22,900
17
Sponsors$29,500$39,300$151,100$124,000$124,000$150,000$124,000$124,000$124,000$124,000$124,000$124,000
18
Tutorial Revenue$17,300$28,070$95,600$0$88,000$88,000$117,333$102,667$88,000$73,333$66,000$58,667estimates proportional to attendance
19
20
Total Revenue$124,700$184,165$525,420$124,000$620,270$644,703$802,826$711,304$619,783$528,261$482,500$436,739
21
22
Per-Attendee Costs
23
Catering (3 day total)$144$165$164$225$225$225$225$225$225$225$225$225
24
Swag$11$13$24$46$25$25$25$25$25$25$25$25
25
26
Expenses
27
Fixed Costs (see sheet)$37,092$46,589$103,957$80,000$258,000$258,000$258,000$258,000$258,000$258,000$258,000$258,000
28
Tutorial Expenses$16,404$24,028$62,662$48,000$82,000$82,000$109,333$95,667$82,000$68,333$61,500$54,667
29
Conference Catering$60,480$74,240$162,034$146,250$270,000$270,000$360,000$315,000$270,000$225,000$202,500$180,000$265K catering minimum (Hyatt + Crowne)
30
Catering Penalty$47,500$0$0$0$0$0$16,000$25,000$34,00040% penalty for the difference
31
Sprint Catering$22,756$25,000$25,000$33,333$29,167$25,000$20,833$18,750$16,667
32
Credit Card Fees$15,763$3,720$18,608$19,341$24,085$21,339$18,593$15,848$14,475$13,102estimate: 3% of revenue
33
Vendor Booths$15,110$12,400$12,400$15,000$12,400$12,400$12,400$12,400$12,400$12,400estimate: 10% of sponsorship reveneue
34
Room-Night Obligation$0$2,055$0$363,548$0$0$0$0$0$48,131$79,673$111,215includes 10% hotel tax
35
Swag$4,620$7,490$24,000$30,000$30,000$30,000$40,000$35,000$30,000$25,000$22,500$20,000
36
37
Total Expenses$118,596$154,402$406,282$731,418$696,008$699,341$837,151$766,572$695,993$689,546$694,798$700,050
38
39
Profit/Loss$6,104$29,763$119,138-$607,418-$75,738-$54,639-$34,326-$55,268-$76,211-$161,285-$212,298-$263,311
40
41
yellow represents input variables
42
gray represents calculated values; do not edit
43
44
Our room-night obligation is 90% of 760 room-nights (684 room-nights), plus 10% hotel tax, = $75,240.
45
Our total catering (food) obligation is $65,000 for the Crowne Plaza, and $200,000 for the Hyatt Regency.
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
Loading...
 
 
 
Summary
Registrations
Fixed Costs
Per-Person Costs
Tutorials
Invoices