| A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | Make a copy of this spreadsheet if you want to edit it! | |||||||||||||||||||||
2 | ||||||||||||||||||||||
3 | Board (per person expenses) | 6 nights | 5 nights | 2 nights | ||||||||||||||||||
4 | accom (tent) | €10 | €60 | €50 | €20 | |||||||||||||||||
5 | kitchen | €5 | €30 | €25 | €10 | |||||||||||||||||
6 | coworking (tea, snacks, internet) | €6 | €36 | €30 | €12 | |||||||||||||||||
7 | food | €15 | €90 | €75 | €30 | |||||||||||||||||
8 | €216 | €180 | €72 | |||||||||||||||||||
9 | ||||||||||||||||||||||
10 | Fixed costs (shared expenses) | |||||||||||||||||||||
11 | Jonas train | €200 | ||||||||||||||||||||
12 | Dan flights | €360 | ||||||||||||||||||||
13 | Hosting team board | €1,080 | ||||||||||||||||||||
14 | Insurance | €200 | ||||||||||||||||||||
15 | €1,840 | |||||||||||||||||||||
16 | ||||||||||||||||||||||
17 | Scenario planning | Projected Income | Projected Profit / loss | Breakeven calcs | ||||||||||||||||||
18 | Week guests | Weekend guests | Hosts | Board | Fixed costs | Seminar rooms | Fees | Contingency | Total costs | Min | Med | Max | Min | Med | Max | Guest-nights | Week | Weekend | ||||
19 | Small | 10 | 5 | 5 | €2,160 | €1,840 | €1,600 | €336 | €594 | €5,936 | €3,750 | €5,000 | €6,500 | -€2,186 | -€936 | €564 | 60 | €495 | €198 | |||
20 | Medium | 20 | 10 | 5 | €4,320 | €1,840 | €1,900 | €484 | €854 | €8,544 | €7,500 | €10,000 | €13,000 | -€1,044 | €1,456 | €4,456 | 120 | €356 | €142 | |||
21 | Large | 30 | 15 | 5 | €6,480 | €1,840 | €2,200 | €631 | €1,115 | €11,151 | €11,250 | €15,000 | €19,500 | €99 | €3,849 | €8,349 | 180 | €310 | €124 | |||
22 | Huge | 40 | 20 | 5 | €8,640 | €1,840 | €2,500 | €779 | €1,376 | €13,759 | €15,000 | €20,000 | €26,000 | €1,241 | €6,241 | €12,241 | 240 | €287 | €115 | |||
23 | ||||||||||||||||||||||
24 | Ticket prices | |||||||||||||||||||||
25 | Week (S) | €300 | ||||||||||||||||||||
26 | Week (M) | €400 | ||||||||||||||||||||
27 | Week (L) | €500 | ||||||||||||||||||||
28 | Weekend (S) | €150 | ||||||||||||||||||||
29 | Weekend (M) | €200 | ||||||||||||||||||||
30 | Weekend (L) | €300 | ||||||||||||||||||||
31 | ||||||||||||||||||||||
32 | ||||||||||||||||||||||
33 | ||||||||||||||||||||||
34 | Notes | |||||||||||||||||||||
35 | - make an accurate model of the main income & expense categories, understand what are your main levers | |||||||||||||||||||||
36 | - distinguish categories of costs: per-person, fixed, hybrid | |||||||||||||||||||||
37 | - make conservative estimates and enjoy a happy surprise at the end (surplus = better food, scholarships, hire a sound system) | |||||||||||||||||||||
38 | - estimate a range of scenarios from low to high turnout, pick a price that is affordable to participants while making an acceptable maximum downside for you | |||||||||||||||||||||
39 | - if you're using a sliding scale ticket scheme, choose the midpoint price based on your estimated breakeven | |||||||||||||||||||||
40 | - get someone to check your work! talking through it helps you spot logical errors | |||||||||||||||||||||
41 | ||||||||||||||||||||||
42 | ||||||||||||||||||||||
43 | ||||||||||||||||||||||
44 | ||||||||||||||||||||||
45 |