ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
2
Don't be afraid to price high. People equate higher price with value. If you are giving a quality experience you should charge accordinginly.
3
4
5
6
7
8
Trip Details
9
Min Pax:4
10
Max Pax:12
11
Projected Pax (75% fill rate)8
12
13
Retail Price: $85per person
14
grey highlighting = dependent variable / auto-calculates = do not edit
15
Costs
16
Rate TypeItem23456789101112
17
Per Person (Main Program)Partner Rate$5,400$4,850$4,300$3,900$3,700$4,050$3,900$3,800$3,700$3,700$3,700
18
Per Person (Main Program)Fee, eg transport pass$10$10$10$10$10$10$10$10$10$10$10
19
Per Person (Main Program)Donation to org/non-prof$100$100$100$100$100$100$100$100$100$100$100
20
Per Person (Main Program)Credit Card Fees$15$15$15$15$15$15$15$15$15$15$15
21
Per Person (Main Program)Carbon Offset$50$50$50$50$50$50$50$50$50$50$50
22
Per Person (Main Program)Emergency Fund$60$60$60$60$60$60$60$60$60$60$60
23
Group Subtotal: $11,270$15,255$18,140$20,675$23,610$29,995$33,080$36,315$39,350$43,285$47,220
24
25
Per Group (Main Program)Guide Cost$200$200$200$200$200$200$200$200$200$200$200
26
Group Subtotal: $200$200$200$200$200$200$200$200$200$200$200
27
28
Per Person (SS)
Single Supplement
$500$500$500$500$500$500$500$500$500$500$500
29
Singles Subtotal: $1,000$1,500$2,000$2,500$3,000$3,500$4,000$4,500$5,000$5,500$6,000
30
31
32
Projected Revenue & Profit
33
Main Program23456789101112
34
Revenue:$170$255$340$425$510$595$680$765$850$935$1,020
35
Costs:$11,470$15,455$18,340$20,875$23,810$30,195$33,280$36,515$39,550$43,485$47,420
36
Gross Profit: -$11,300-$15,200-$18,000-$20,450-$23,300-$29,600-$32,600-$35,750-$38,700-$42,550-$46,400
37
Gross Profit PP: -$5,650-$5,067-$4,500-$4,090-$3,883-$4,229-$4,075-$3,972-$3,870-$3,868-$3,867
38
Gross Margin: -6647.06%-5960.78%-5294.12%-4811.76%-4568.63%-4974.79%-4794.12%-4673.20%-4552.94%-4550.80%-4549.02%
39
40
41
Single Supplement23456789101112
42
Revenue:#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!
43
Costs:$1,000$1,500$2,000$2,500$3,000$3,500$4,000$4,500$5,000$5,500$6,000
44
Gross Profit: #REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!
45
Gross Profit PP: #REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!
46
Gross Margin: #REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!
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