ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Chapter Trip Budget Worksheet - For Pre Planning (and testing scenarios)
2
Trip Name:Submit Date2/27/2019
3
Leaders:Start Date7/1/2019
4
Do NOT enter data in the gray shaded cells, they contain formulas.
End Date7/5/2019
5
Enter your trip data into the yellow shaded cells.
Trip days5
6
Calculated Advertised Price for AMC Members
201.58 Trip Nights4
7
Calculated Advertised Price for non-AMC Members
226.58
8
PeopleMinimumMaximum
9
Number of leaders4 4
10
Number of paying participants16 21
11
Total number of persons20 25
12
Per Person Variable Costs - Includes LeadersPer Person $’s
13
Lodging including non-itemized meals10.00 10.00
14
Other meals, group groceries, etc.22.00 22.00
15
Local transportation taxis, bus, etc0.00 0.00
16
Entrance fees0.00 0.00
17
Per person cost of guides or outfitters, etc.0.00 0.00
18
Other0.00 0.00
19
Per Person Variable Costs32.00 32.00
20
Fixed and Semi-Fixed CostsFixed & Semi-Fixed Cost $’s
21
Lodging if Semi-Fixed3,000.00 3,000.00
22
Leaders’ administrative expenses25.00 25.00
23
Transportation: rentals, gas, tolls, parking0.00 0.00
24
Additional leader meals, lodging, transport, other0.00 0.00
25
Committee Fee at X$ PPPD:00.00 0.00
26
Fixed cost of outfitter arrangements0.00 0.00
27
Other0.00
28
Total Fixed Costs3,025.00 3,025.00
29
Total Fixed and Semi-Fixed Costs3,665.00 3,825.00
30
Contingency at Percent: 5%183.25 191.25
31
Total Trip Cost with Contingency
3,848.25 4,016.25
32
Advertised Trip Price Calculations
33
Total Trip Cost3,665.00 3,825.00
34
Total Trip Costs per Person-Includes Leaders
183.25 153.00
35
Maximum for Participants PP to Cover Leaders at %:
10.0%18.33 15.30
36
Members Advertised Trip Price (Total PP Cost plus Leaders Costs PP)
201.58 168.30
37
Additional Fee for Non-AMC Members
25.0025.00 25.00
38
Non-Members Advertised Trip Price (Total PP Cost plus Leaders Costs PP)
226.58 193.30
39
Leaders Cost Contribution Calculations
40
Total of Participant Fees from Above Advertised Member Cost
3,225.20 3,534.30
41
Other Expected Income1
42
Other Expected Income from Non-Member Fees @ #Non-Memb
4100.00 100.00
43
Total Trip Estimated Income3,325.20 3,634.30
44
Total Trip Cost from Above3,665.00 3,825.00
45
Shortage Total that Leaders Must Cover
339.80 190.70
46
Number of Leaders44
47
Shortage that Leaders must Pay per Leader
84.95 47.68
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