PyCon 2008 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...
ABCDEFGHIJKLMNOPQRSTUVWXYZAAABAC
1
PyCon 2008 BudgetApproved by the PSF Board 2007-10-08.
2
Chicago ILIf you want to play with the numbers, please make a copy first (File -> Copy spreadsheet...).
3
200620072008200820082008
4
ActualActualActualProbableBudgetAttendance Speculation
5
Total Attendance42058698910008001000900800700600500
6
Room-Night Usage9451412205020001800225020251800157513501125assumes 75% guest room usage
7
Comp'd Room-Nights1828334036454036312722
8
Free registrations2913212540404040404040
9
10
Per-Attendee Revenue
11
Registration (average, paid)$185.48$209.69$301.55$300.57$259.17
12
13
Revenue
14
Registration$77,900$116,795$258,425$263,000$196,972$248,807$222,889$196,972$171,055$145,137$119,220
15
Room Commission$0$0$20,295$19,800$17,820$22,275$20,048$17,820$15,593$13,365$11,138upper limit on room-nights? per night?
16
Sponsors$29,500$39,300$151,100$151,100$50,000$62,500$56,250$50,000$43,750$37,500$31,250estimates proportional to attendance
17
Tutorial Revenue$17,300$28,070$95,600$90,880$33,000$41,250$37,125$33,000$28,875$24,750$20,625estimates proportional to attendance
18
19
Total Revenue$124,700$184,165$525,420$524,780$297,792$374,832$336,312$297,792$259,272$220,752$182,232
20
21
Per-Attendee Costs
22
Catering (3 day total)$144$165$164$201$201$201$201$201$201$201$201
23
Swag$11$13$24$24$20$20$20$20$20$20$20
24
25
Expenses
26
Fixed Costs$37,092$46,589$103,957$128,900$85,300$85,300$85,300$85,300$85,300$85,300$85,300
27
Tutorial Expenses$16,404$24,028$62,662$65,050$31,500$39,375$35,438$31,500$27,563$23,625$19,688
28
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
29
Sprint Catering$22,756$20,000
30
Credit Card Fees$15,763$15,743$4,824$6,030$5,427$4,824$4,221$3,618$3,015estimate: 3% of revenue
31
Vendor Booths$15,110$15,110$5,000$6,250$5,625$5,000$4,375$3,750$3,125estimate: 10% of sponsorship reveneue
32
Room-Night Obligation$0$2,055$0$0$0$0$0$0$0$0$0includes 10% hotel tax
33
Swag$4,620$7,490$24,000$24,000$16,000$20,000$18,000$16,000$14,000$12,000$10,000
34
35
Total Expenses$118,596$154,402$406,282$469,803$303,424$357,955$330,690$303,424$276,159$248,893$221,628
36
37
Profit/Loss$6,104$29,763$119,138$54,977-$5,632$16,877$5,622-$5,632-$16,886-$28,141-$39,395
38
39
yellow represents input variables
40
gray represents calculated values; do not edit
41
42
Our room-night obligation is 90% of 760 room-nights (684 room-nights), plus 10% hotel tax, = $75,240.
43
Our total catering (food) obligation is $65,000.
44
45
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