A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | INITIAL APPROVED (150 cap) | With approved adjustments (200 projected) | PROJECTED (200 scenario) - for discussion | PROJECTED (250 scenario) - for discussion | ACTUAL | ||||||||||||||
2 | Group | Item | Unit cost | # | Amount | Unit cost | # | Amount | Unit cost | # | Amount | Unit cost | # | Amount | Unit cost | # | Amount | Comments | |
3 | Expenses | Venue | Venue hire | - | - | $1,000 | - | - | $1,000 | - | - | $1,000 | - | - | $1,000 | - | - | $357 | cleaning (357) |
4 | Catering | Workshop food | $40 | 110 | $4,400 | $40 | 113 | $4,533 | $48 | 129 | $6,176 | $48 | 153 | $7,360 | $39 | 157 | $6,123 | ||
5 | Catering | Workshop coffee/tea/water | - | - | - | - | - | - | - | - | - | - | - | - | - | - | $1,832 | ||
6 | Catering | Pre-conf social event | $30 | 100 | $3,000 | $30 | 133 | $3,996 | $30 | 125 | $3,750 | $30 | 150 | $4,500 | - | - | $4,112 | ||
7 | Catering | Conference food | $80 | 150 | $12,000 | $80 | 212 | $16,960 | $80 | 213 | $17,000 | $80 | 260 | $20,800 | $78 | 261 | $20,358 | ||
8 | Catering | Conference coffee/tea/juice | - | - | - | - | - | - | $12 | 213 | $2,550 | $12 | 260 | $3,120 | - | - | $4,280 | ||
9 | Catering | Community day food | $40 | 100 | $4,000 | $40 | 100 | $4,000 | $20 | 100 | $2,000 | $20 | 150 | $3,000 | - | - | $3,820 | ||
10 | Catering | Dinner food & drinks (bar tab) | $80 | 140 | $11,700 | $80 | 125 | $10,500 | $80 | 106 | $8,980 | $80 | 133 | $11,140 | $82 | 129 | $11,114 | ||
11 | Admin | Printing | - | - | $1,200 | - | - | $1,200 | - | - | $1,075 | - | - | $1,075 | - | - | $930 | program, badges, banner stand, dinner tix | |
12 | Admin | Office supplies | - | - | - | - | - | - | - | - | - | - | - | - | - | - | $687 | printer, ink, paper, pens, power cords, etc | |
13 | Admin | Staff costs | - | - | $2,000 | - | - | $4,000 | - | - | $4,000 | - | - | $4,000 | - | - | $0 | Fee was donated to Good Mojo (4000) | |
14 | Admin | Services | - | - | - | - | - | - | - | - | - | - | - | - | - | - | $167 | Google Apps (83), Zoom (*4 months = 84) | |
15 | Marketing | Web hosting & domain | - | - | $200 | - | - | $200 | - | - | $20 | - | - | $20 | - | - | $33 | ||
16 | Marketing | T shirts | $30 | 75 | $2,250 | $30 | 80 | $2,400 | $33 | 62 | $2,046 | $33 | 80 | $2,640 | $25 | 66 | $1,669 | Final amount, including t-shirts ordered and shipped after the event. | |
17 | Marketing | Other swag | - | - | - | - | - | $5,000 | - | - | $5,000 | - | - | $5,000 | - | - | $3,052 | mugs (2107), stickers (505), program design (440) | |
18 | Speaker Costs | International invited keynote travel | $3,000 | 2 | $6,000 | - | - | $6,000 | - | - | $6,036 | - | - | $6,036 | - | - | $6,137 | ||
19 | Speaker Costs | Regional invited keynote travel | $700 | 3 | $2,100 | - | - | $2,100 | - | - | $1,760 | - | - | $1,760 | - | - | $1,754 | ||
20 | Speaker Costs | Speaker gifts | $25 | 50 | $1,250 | $25 | 50 | $1,250 | - | - | $1,289 | - | - | $1,289 | - | - | $1,289 | tea towels (1289) | |
21 | On site | Volunteer appreciation | - | - | $2,000 | - | - | $2,000 | - | - | $2,000 | - | - | $2,000 | - | - | $1,040 | committee dinner (361) & breakfast(127); vouchers (350); chocs (49); book (153) | |
22 | On site | Registration badges | $5 | 150 | $750 | $5 | 250 | $1,250 | - | - | $568 | - | - | $568 | - | - | $568 | lanyards & sleeves | |
23 | On site | Display services for exhibition | - | - | $1,000 | - | - | $1,000 | - | - | $1,000 | - | - | $1,000 | - | - | $808 | pinboard & whiteboard rental | |
24 | On site | Audio visual equipment & labour | - | - | $1,000 | - | - | $7,600 | - | - | $7,166 | - | - | $7,166 | - | - | $8,016 | video recording (6600), uni A/V staff (1416) | |
25 | On site | Miscellaneous | - | - | - | - | - | - | - | - | - | - | - | - | - | - | $269 | drink tix (65), airtasker (68), rubbish bags (11), parking (13); PollEV (112) | |
26 | On site | Signage | - | - | $500 | - | - | $500 | - | - | $500 | - | - | $500 | - | - | $0 | ||
27 | Miscellaneous | Miscellaneous expenses | - | - | $2,000 | - | - | $2,000 | - | - | $2,000 | - | - | $2,000 | - | - | $255 | shipping (95), USB drives & shipping (109), ship maps to keynotes (51) | |
28 | Miscellaneous | Good Mojo expenses | - | - | - | - | - | $8,125 | - | - | $8,125 | - | - | $8,125 | - | - | $5,346 | Women's breakfast (519), TGP (4650), TGP breakfast (177) | |
29 | Miscellaneous | Outgoing sponsorship | - | - | - | - | - | $750 | - | - | $750 | - | - | $750 | - | - | $750 | Sponsor Georabble | |
30 | Total expenses | $58,350 | $86,364 | $84,790 | $94,848 | $84,766 | |||||||||||||
31 | |||||||||||||||||||
32 | Registration costs | Paypal/credit card costs/registration | - | - | -$1,737 | - | - | -$2,067 | - | - | -$2,339 | - | - | -$3,021 | - | - | -$2,872 | Stripe + Tito fees | |
33 | Income | Registration | Complimentary - keynote speakers | $0 | 5 | $0 | $0 | 5 | $0 | $0 | 4 | $0 | $0 | 4 | $0 | $0 | 4 | $0 | |
34 | Registration | Complimentary - Travel Grant Program | - | - | - | $0 | 8 | $0 | $0 | 7 | $0 | $0 | 7 | $0 | $0 | 7 | $0 | ||
35 | Registration | Complimentary - sponsors | $0 | 15 | $0 | $0 | 27 | $0 | $0 | 24 | $0 | $0 | 26 | $0 | $0 | 24 | $0 | ||
36 | Registration | Complimentary - staff | - | - | - | - | - | - | $0 | 1 | $0 | $0 | 1 | $0 | $0 | 1 | $0 | ||
37 | Registration | Discounted - Community Contributor | $150 | 30 | $4,500 | $150 | 45 | $6,750 | $150 | 24 | $3,600 | $150 | 29 | $4,350 | $150 | 29 | $4,350 | ||
38 | Registration | Discounted - Volunteer | $200 | 15 | $3,000 | - | - | - | - | - | - | - | - | - | - | - | - | ||
39 | Registration | Discounted - Student | - | - | - | $250 | 10 | $2,500 | $250 | 4 | $1,000 | $250 | 7 | $1,750 | $250 | 7 | $1,750 | ||
40 | Registration | Discounted - Early Bird | $300 | 30 | $9,000 | $300 | 30 | $9,000 | $300 | 29 | $8,700 | $300 | 29 | $8,700 | $300 | 29 | $8,700 | ||
41 | Registration | Discounted - Workshop presenter | $300 | 10 | $3,000 | $300 | 3 | $900 | $300 | 0 | $0 | $300 | 0 | $0 | $300 | 0 | $0 | ||
42 | Registration | One day | - | - | - | - | - | - | $200 | 1 | $200 | $200 | 2 | $400 | $200 | 4 | $800 | ||
43 | Registration | Full price | $400 | 45 | $18,000 | $400 | 72 | $28,800 | $400 | 107 | $42,800 | $400 | 144 | $57,600 | $400 | 147 | $58,800 | ||
44 | Total # of conf registrations | 150 | 200 | 201 | 248 | 250 | |||||||||||||
45 | Registration | Complimentary - Travel Grant Program | - | - | - | $0 | 16 | $0 | $0 | 11 | $0 | $0 | 11 | $0 | $0 | 12 | $0 | ||
46 | Registration | Complimentary - sponsors | - | - | - | $0 | 12 | $0 | $0 | 7 | $0 | $0 | 7 | $0 | $0 | 7 | $0 | ||
47 | Registration | Discounted - Student | - | - | - | $50 | 20 | $1,000 | $50 | 2 | $100 | $50 | 3 | $150 | $50 | 3 | $150 | ||
48 | Registration | Full price | $100 | 90 | $9,000 | $100 | 112 | $11,200 | $100 | 145 | $14,500 | $100 | 182 | $18,200 | $100 | 184 | $18,400 | ||
49 | Total # of workshop registrations | 90 | 160 | 165 | 203 | 206 | |||||||||||||
50 | Registration | Complimentary - keynote speakers | $0 | 5 | $0 | $0 | 5 | $0 | $0 | 4 | $0 | $0 | 4 | $0 | $0 | 4 | $0 | ||
51 | Registration | Complimentary - Travel Grant Program | - | - | - | $0 | 8 | $0 | $0 | 7 | $0 | $0 | 7 | $0 | $0 | 7 | $0 | ||
52 | Registration | Complimentary - sponsors | $0 | 15 | $0 | $0 | 27 | $0 | $0 | 24 | $0 | $0 | 27 | $0 | $0 | 24 | $0 | ||
53 | Registration | Full price | $80 | 120 | $9,600 | $80 | 85 | $6,800 | $80 | 71 | $5,680 | $80 | 95 | $7,600 | $80 | 94 | $7,520 | ||
54 | Total # of dinner tickets | 140 | 125 | 106 | 133 | 129 | |||||||||||||
55 | Registration | Good Mojo - ticket sales | - | - | - | - | - | $440 | - | - | $440 | - | - | $440 | - | - | $465 | ||
56 | Registration | T shirts | $30 | 60 | $1,800 | $30 | 50 | $1,500 | $30 | 32 | $960 | $30 | 50 | $1,500 | $30 | 42 | $1,360 | ||
57 | Sponsorship | Platinum | $5,000 | 2 | $10,000 | - | - | $19,844 | - | - | $19,844 | - | - | $19,844 | - | - | $19,844 | ||
58 | Sponsorship | Gold | $2,500 | 2 | $5,000 | - | - | $9,975 | - | - | $9,975 | - | - | $9,975 | - | - | $9,975 | ||
59 | Sponsorship | Silver | $1,500 | 3 | $4,500 | - | - | $9,000 | - | - | $9,000 | - | - | $9,000 | - | - | $9,000 | ||
60 | Sponsorship | Bronze | $750 | 3 | $2,250 | - | - | $1,500 | - | - | $1,500 | - | - | $1,500 | - | - | $1,500 | ||
61 | Sponsorship | Good Mojo - direct sponsor funding | - | - | - | - | - | $0 | - | - | $0 | - | - | $0 | - | - | $0 | ||
62 | Sponsorship | OSGeo Travel Grant funding | - | - | - | - | - | $2,688 | - | - | $2,688 | - | - | $2,688 | - | - | $2,688 | ||
63 | Sponsorship | OSGeo Community Day funding | - | - | $2,500 | - | - | $2,000 | - | - | $2,000 | - | - | $2,000 | - | - | $2,000 | ||
64 | Total income | $80,413 | $111,830 | $120,648 | $142,676 | $144,430 | |||||||||||||
65 | Surplus/deficit | $22,063 | $25,466 | $35,858 | $47,828 | $59,664 | |||||||||||||
66 | |||||||||||||||||||
67 | cost | pp | |||||||||||||||||
68 | attendees cost model (includes most conf & CD expenses) | $65,188 | $261 | ||||||||||||||||
69 |