The cost of direct sales

	B	C	D	E	F	I
1	DOWNLOAD AS EXCEL OR CREATE A COPY OF THIS FILE TO USE IT (File >> Create a copy)					Comment and share your result in:
2						The cost of direct sales. Part 1: Calculation
3	The cost of my hotel direct sale in a specific period					HELP Choose a period and fill in the yellow blanks with the data from that period only. Taxes: do not mix net and gross amounts.
4
5		INCOME:	Amount of direct bookings (figure after cancellations)			Income: allocate the amount from bookings RECEIVED (pick-up) during the period -not the one from stays during that period- and subtract cancelled bookings or their estimate.
6
7
8						Do you have PERCENTAGE expenses? Note down the amount of that percentage. For example, if you are paying 2% of 200,000€, the amount is 4,000€. Do you have a single-payment FIXED COST? Estimate its amortisation period and note down the amount corresponding to the period you are analysing. For example, if you paid 20,000€ and you want to amortise it in three years, analysing one year would mean a cost of 6,666€.
9		EXPENSES:	Total amount including branding (If it is fixed, just allocate the part corresponding to that period)	% attributable to direct sale:
10		Hotel/chain website: Design, contents, texts, translations...		30%	€0
11		Hotel/chain app		30%	€0
12		Booking engine		100%	€0
13		Support/boosting technologies (Triptease, Flip.to, etc.)		100%	€0
14		SEO		30%	€0
15		SEM		80%	€0
16		Email marketing		80%	€0
17		Metasearch: Investment in their CPC-CPA programmes		100%	€0
18		Tripadvisor Business Advantage, Trivago Manager Plus...		50%	€0
19		Call centre, booking department, chatbots...		10%	€0
20		Customer loyalty programme		50%	€0
21		Others			€0
22
23				Total expenses:	€0
24
25		RESULT:			0,0%
26
27
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