Office Catering Budget Template.xlsx

	B	C	D	E	F	G	H
1
2	Annual Office Catering Budget Template
3	TOTAL EXPENSES	Year	Annual Budget	Actual	Difference	Total Attendees	Avg Cost Per Person
4	TOTAL EXPENSES	2025	£ 10,000.00	£ 4,450.00	£ 5,550.00	123	£ 36.18
5
6	Event Name	Date	Planned Budget	Actual	Difference	Attendees	Cost/Person
7	January Town Hall	15/01/2025	£ 1,000.00	£ 700.00	£ 300.00	25	£ 28.00
8	January Sales Training	19/01/2025	£ 1,500.00	£ 2,000.00	-£ 500.00	40	£ 50.00
9	January Monthly Party	27/01/2025	£ 1,000.00	£ 850.00	£ 150.00	30	£ 28.33
10	Februrary Town Hall	15/02/2025	£ 1,000.00	£ 900.00	£ 100.00	28	£ 32.14
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31	Total		£ 4,500.00	£ 4,450.00	£ 50.00	123	£ 36.18
32
33
34	Instructions
35
36	Enter your annual budget in C4.					Website: https://www.masterscatering.co.uk/
37	Add your events from B7, populate your planned and actual budget.					Call us: 07824 190092
38	Difference will be auto calculated.					Email: info@masterscatering.co.uk
39	Enter your attendees in F7 and your cost per person will be auto calculated.
40	To add additional events from row 11, simply drag the contents from row 10 down.
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