NAF Budget Template - Your Show!

	A	B	C	D	E	F	G	H
1	NAF BUDGET CALCULATOR
2	This budget calculator is here to give you a better idea of the expenses that are involved with taking a show to NAF 2019. If you have any questions, please pop an email to taranotcutt@gmail.com and she'll spreadsheet wizard it for you.
3	1. PLEASE COPY THIS SPREADSHEET TO A NEW PAGE THEN EDIT
4	2. Fill in your items below
5	3. Not all sections will apply to you - if you don't need something, just make the Unit Cost 0 (zero)
6	4. If something is missing that would be helpful to your show, let us know and we can adjust for you!
7
8	ITEM	NOTES	QUANTITY	UNIT COST	TOTAL
9	Production
10	Set	If needed	1	R 0.00	R 0.00
11	Costume	If needed	1	R 0.00	R 0.00
12	Props	If needed	1	R 0.00	R 0.00
13	Microphones	Hire cost per day	1	R 0.00	R 0.00
14	Cables	Hire cost per day	1	R 0.00	R 0.00
15	Other items needed	Hire cost per day	1	R 0.00	R 0.00
16
17				subtotal	R 0.00
18	Publicity and Marketing			UNIT COST
19	Poster and flyer design	Your design is your responsibility. Printing is part of the CTE fee.	1	R 500.00	R 500.00
20	Advert design	If you're doing a separate advert	1	R 0.00	R 0.00
21	Advert in the programme	If you're doing a separate advert	1	R 0.00	R 0.00
22	Photographs		1	R 0.00	R 0.00
23				subtotal	R 500.00
24	Accommodation, Transport, Per Diems		NIGHTS	UNIT COST
25	1 Accomm		12	R 400.00	R 4,800.00
26	1 Per diem		12	R 150.00	R 1,800.00
27	2 Accomm		12	R 400.00	R 4,800.00
28	2 per diem		12	R 150.00	R 1,800.00
29	3 Accomm		12	R 400.00	R 4,800.00
30	3 Per diem		12	R 150.00	R 1,800.00
31	4 Accomm		12	R 400.00	R 4,800.00
32	4 Per diem		12	R 150.00	R 1,800.00
33	5 Accomm		12	R 400.00	R 4,800.00
34	5 Per diem		12	R 150.00	R 1,800.00
35	Petrol	Return on one car	2	R 1,500.00	R 3,000.00
36	Set transport	Return, if applicable	2	R 0.00	R 0.00
37				subtotal	R 36,000.00
38	ADMINISTRATION			UNIT COST
39	CTE fee		1	R 4,500.00	R 4,500.00
40	NAF registration		1	R 3,000.00	R 3,000.00
41	Venue hire	Per show	10	R 600.00	R 6,000.00
42	Publicist	Included with CTE	1	R 0.00	R 0.00
43	Programme advert	Collective ad included with CTE	1	R 0.00	R 0.00
44	Rights	Per performance - if applicable	10	R 0.00	R 0.00
45				subtotal	R 13,500.00
46	Overall expenditure				R 50,000.00
47
48
49	Projected income
50	170 seats - the number of seats in our venue, Princess Alice
51	10 shows - the number of shows we like to assign each production in The Edge
52	1700 total seats - the total potential seats that can be sold over the run
53	R80 average ticket price - our recommended ticket price
54	R60 - THE AVERAGE YOU TAKE IN ON A TICKET AFTER NAF DEDUCTIONS, TAX, BOOKING FEES, AND SO ON
55
56	Percentage = % of tickets sold over the run	No. of seats = number of seats over the run that make up that %	Ave. Ticket = average ticket price	Seats sold per show	Gross income = average ticket price X number of seats sold	Expenses = your show expenses	Profit = Gross income MINUS expenses
57
58	Percentage	No. of seats	Ave. Ticket	Seats per show	Gross income	Expenses	Profit
59	10%	170	60	17	R 10,200.00	R 50,000.00	-R 39,800.00	LOSS
60	20%	340	60	34	R 20,400.00	R 50,000.00	-R 29,600.00	LOSS
61	30%	510	60	51	R 30,600.00	R 50,000.00	-R 19,400.00	LOSS
62	40%	680	60	68	R 40,800.00	R 50,000.00	-R 9,200.00	LOSS
63	50%	850	60	85	R 51,000.00	R 50,000.00	R 1,000.00	PROFIT
64	60%	1020	60	102	R 61,200.00	R 50,000.00	R 11,200.00	PROFIT
65	70%	1190	60	119	R 71,400.00	R 50,000.00	R 21,400.00	PROFIT
66	80%	1360	60	136	R 81,600.00	R 50,000.00	R 31,600.00	PROFIT
67	90%	1530	60	153	R 91,800.00	R 50,000.00	R 41,800.00	PROFIT
68	100%	1700	60	170	R 102,000.00	R 50,000.00	R 52,000.00	PROFIT
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