| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
1 | Make a copy of this spreadsheet and play with it as you want! | |||||||
2 | ||||||||
3 | PREMISES | COST PER UNIT | ||||||
4 | Unit Price | Total Price | ||||||
5 | 10 | Units | Prefab Units | 25,000 € | 250,000 € | |||
6 | 2 | Pax | Number of Guest per Unit | 450 € | 900 € | |||
7 | 30 | Square Meters | Unit Area | 90 € | 2,700 € | |||
8 | 300 | Units | Operating Licences | 10 € | 3,000 € | |||
9 | 150 | Square Meters | Surounding Area per Unit * | 35 € | 5,250 € | |||
10 | 1000 | Square Meters | Land Area total | 3 € | 3,000 € | |||
11 | 100 | Square Meters | Walking Paths * | 15 € | 1,500 € | |||
12 | * Area development and preparation | TOTAL | 266,350 € | |||||
13 | ||||||||
14 | ||||||||
15 | REVENUE | |||||||
16 | ||||||||
17 | Occupation | Rates per night (in Euros) | Days | Incomes (per Cabin) | Incomes (per Group) | |||
18 | Low Season | 50% | 80 € | 185 | 7,400 € | 74,000.00 € | ||
19 | Medium Season | 75% | 115 € | 120 | 10,350 € | 103,500.00 € | ||
20 | High Season | 90% | 145 € | 60 | 7,830 € | 78,300.00 € | ||
21 | AVERAGE | 64.79% | 108 € | 365 | 25,580 € | 255,800.00 € | ||
22 | ||||||||
23 | ||||||||
24 | FIXED COSTS | |||||||
25 | ||||||||
26 | Staff costs | 365 | 3,181 € | 38,700 € | ||||
27 | General Manager | 280 | 1,800 € | 16,800 € | ||||
28 | Maintenance | 365 | 1,800 € | 21,900 € | ||||
29 | Administration and legal costs | 365 | 150 € | 1,825 € | ||||
30 | Marketing | 365 | 300 € | 3,650 € | ||||
31 | Depreciation and Amortization | 10% | 2,220 € | 26,635 € | ||||
32 | TOTAL FIXED COSTS | 9,450 € | 109,510 € | |||||
33 | ||||||||
34 | ||||||||
35 | VARIABLE COSTS | |||||||
36 | ||||||||
37 | Staff costs | 365 | 1,971 € | 23,650 € | ||||
38 | House keeping | 10 € | 1,971 € | 23,650 € | ||||
39 | Marketing and booking commissions | 12% | 2,558 € | 30,696 € | ||||
40 | Supplies and third parties works | 6 € | 1,183 € | 14,190 € | ||||
41 | Materials for conservation | 3 € | 591 € | 7,095 € | ||||
42 | TOTAL VARIABLE COSTS | 6,303 € | 75,631 € | |||||
43 | ||||||||
44 | ||||||||
45 | ||||||||
46 | PROFIT OR LOSS | 70,659 € | ||||||
47 | ||||||||
48 | ||||||||