ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
2021 Tech Club Quiz Night
EstimateEstimateEstimateFinalFinalFinal
2
Expense Type
Expense NameUnit Cost
Number of Units
Total CostUnit Cost
Number of Units
Total CostExpense Paid
Receipt Archived
Additional Details
3
VenueTavern Hire $ 440.00 1 $ 440.00 $ 440.00 1 $ 440.00 Yes No To be paid by PCS by 12th Nov
4
VenueSecurity $ 220.00 1 $ 220.00
5
FeeEventbrite Fee $ 3.57 1 $ 3.57
6
PrizesPrizes $ 200.00 1 $ 200.00 $ 200.00 1 $ 200.00 Yes No
7
EXPENSE TOTAL
Estimated Total $ 860.00 Final Total $ 643.57 Yes No
8
EstimateEstimateEstimateFinalFinalFinal
9
Income TypeIncome Name
 Unit Income
Number of Units
Total Income
Unit Income
Number of Units
Total Income
Income Received
Location of Funds
Additional Details
10
TicketsTable Tickets (Early Bird) $ 87.48 4 $ 349.92 $ 87.48 6 $ 524.88 Yes
11
TicketsSingle Tickets (Early Bird) $ 12.17 4 $ 48.68 $ 12.17 1 $ 12.17 Yes
12
TicketsTable Tickets $ 97.26 3 $ 291.78 $ 97.26 2 $ 194.52 Yes
13
TicketsSingle Tickets $ 14.13 12 $ 169.56 $ 14.13 16 $ 226.08 Yes
14
TicketsDoor Tickets $ 14.13 4 $ 56.52 $ 15.00 3 $ 45.00 Yes
15
INCOME TOTAL
Estimated Total $ 916.46 Final Total $ 1,002.65 Yes
16
PROFIT/LOSSEstimated Total $ 56.46 Final Total $ 359.08
17
18
Breakeven Point Calculator
w/o security
w/ security
19
Total Fixed Expense $ 640.00 $ 860.00
20
Total Fixed Income $ - $ -
21
Fixed Total $ (640.00) $ (860.00)
22
23
Total Variable Expense (Per Table)
$ - $ -
24
Total Variable Income (Per Table)
$ 87.48 $ 87.48
25
Variable Total (Per Table) $ 87.48 $ 87.48
26
Variable Total (Per Person) $ 10.94 $ 10.94
27
Attendees required to break even5979
28
29
ESTIMATES
30
# of attendees (w/o security) profit/loss
split between 5 clubs
31
64 $ 59.84 $ 11.97
32
72 $ 147.32 $ 29.46
33
80 $ 234.80 $ 46.96
34
# of attendees (w/ security) profit/loss
split between 5 clubs
35
64 $ (160.16) $ (32.03)
36
72 $ (72.68) $ (14.54)
37
80 $ 14.80 $ 2.96
38
88 $ 102.28 $ 20.46
39
96 $ 189.76 $ 37.95
40
41
42
43
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