official lutg-budget-sheet.xlsx

	A	B	C	E	F	G	H	J	K	L	M
1	BUDGET AND BREAKDOWN
2	Name of show			BREAK EVEN SCENARIO	TOTAL	Capacity (%)	#DIV/0!	WORST SCENARIO	TOTAL	Capacity (%)	10%
3				INCOME		Tickets to sell	0	INCOME		Tickets to sell	0
4	Director			Ticket sales	£ -			Ticket sales	£ -
5	Producer			Programmes	£ -	Member	0	Programmes	£ -	Member	0
6	Stage Managers			Other	£ -			Other	£ -	£6.00	£ -
7						£ 6.00	£ -		£ -	Concession	0
8				TOTAL INCOME	£ -					£7.00	£ -
9						Concession	0	TOTAL EXPENDITURE	£ -	Non-Concession	0
10	Venue			EXPENDITURE		£ 7.00	£ -			£8.00	£ -
11	Performance dates			Venue Hire	£ -	Non-Concession	0	PROFIT / LOSS	£ -
12	No. of cast			Rights	£ -	£ 8.00	£ -
13				Scripts	£ -
14	No. of performances			Set	£ -			BEST SCENARIO	TOTAL	Capacity (%)	80%
15	Venue capacity			Lights & Sound	£ -
16	Total no. of tickets			Publicity	£ -
17	Venue Hire Takings	0%		Props	£ -			INCOME		Tickets to sell	0
18	Rights Takings	0%		Costume	£ -			Ticket sales	£ -
19		Income from Tickets	Selling Price	Misc	£ -			Programmes	£ -	Member	0
20	Member Price	£ 6.00	£ 6.00					Other	£ -	£6.00	£ -
21	Concession Price	£ 7.00	£ 7.00	TOTAL EXPENDITURE	0.00				£ -	Concession	0
22	Non-Concession Price	£ 8.00	£ 8.00							£7.00	£ -
23	Member Split	50%		PROFIT / LOSS	0.00			TOTAL EXPENDITURE	£ -	Non-Concession	0
24	Concession Split	20%								£8.00	£ -
25	Non-Concession Split	30%						PROFIT / LOSS	£ -
26	Programme Cost
27	Audience Buying Programmes	10%
28
29
30
31
32
33
34
35
36
37
38
39
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