NCO Trip Expense Planning Workbook 010116 Rev 5, Issued 010116.xlsx
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
View only
 
 
ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
2
Nicaraguan Christian Outreach
3
Mission Trip Expense Planning Worksheet
4
Worksheet Password to Unlock = NCO
5
Team Planning Section:
6
Arrival Date in Nicaragua:1/2/2016Enter your Arrival Date in Nicaragua here.
7
Departure Date from Nicaragua:1/9/2016Enter your Departure Date from Nicaragua here.
8
Total Number of Team Members:15Enter the Total Number of Team Members here.
9
Total Number of Days using Materials Truck4Enter the Total Number of days the Materials Truck will be needed during the trip.
10
Miscellaneous Team Expenses ( per person ):
$0.00 Enter the Amount (per person) for Miscellaneous Team Expenses here.
11
Results of Team Planning Expenses:$297.67 Total Estimated per person Team Expenses based upon entries above.
12
13
Personal Planning Section:
14
Personal Expenses ( per person/per day)$0.00 Enter the amount (for each day) you would plan on spending for your expenses.
15
Airline round trip ticket price ( per person )$500.00 Enter the amount you expect to spend for a single round trip airline ticket.
16
Results of Estimated Personal Expenses:
$500.00 Total estimated ( per person ) Personal Expenses.
17
18
Totals:
19
Total per person charges ( length of stay ):
$297.67 Total Estimated per person Team Expenses based upon entries above.
20
Total per person for Personal Expenses
$500.00 Total estimated ( per person ) Personal Expenses.
21
Total per person Expenses:$797.67 Estimated per person Total Expenses based upon information entered for, length of stay and total number of Team Members from Arrival to Departure.
22
23
Detail Categories of ExpensesArrival Plan DateDeparture Plan DateNumber of DaysDaily Plan AmountSubtotalUnit of MeasureCategory TotalTotals
24
Housing and Meals Planning
25
Housing for the Team
Total Number of Team Members
26
House Charges1/2/20161/9/20161/6/1900$12.00 $84.00 15$1,260.00 $1,260.00
27
28
Meals Planning for the Team
Total Number of Team Members
29
Meals Planning1/3/20161/8/20161/5/1900$13.00 $78.00 15$1,170.00 $1,170.00
30
31
Transportation Services
32
Airport Pickup on ArrivalVan/Driver
33
Van Airport Pickup on Arrival1/2/20161/2/201612/31/1899$35.00 $35.00 2$70.00 $70.00
34
Van Driver - Arrival1/2/20161/2/201612/31/1899$5.00 $5.00 2$10.00 $10.00
35
36
Luggage Transport on Arrival
Truck/Driver
37
Luggage Truck Pickup on Arrival1/2/20161/2/201612/31/1899$45.00 $45.00 1$45.00 $45.00
38
Truck Driver - Arrival1/2/20161/2/201612/31/1899$10.00 $10.00 1$10.00 $10.00
39
40
Transportation for the Team
Van/Driver/Fuel
41
Van1/3/20161/8/20161/5/1900$70.00 $420.00 2$840.00 $840.00
42
Driver1/3/20161/8/20161/5/1900$10.00 $60.00 2$120.00 $120.00
43
Van Fuel1/3/20161/8/20161/5/1900$25.00 $150.00 2$300.00 $300.00
44
45
Airport Dropoff at DepartureVan/Driver
46
Van Airport Dropoff at Departure1/9/20161/9/201612/31/1899$35.00 $35.00 2$70.00 $70.00
47
Van Driver - Departure1/9/20161/9/201612/31/1899$5.00 $5.00 2$10.00 $10.00
48
49
Translator Services
Number of Translator(s)
50
Translator Services for the Team1/3/20161/8/20161/5/1900$25.00 $150.00 2$300.00 $300.00
51
52
Miscellaneous Expenses
Total Number of Team Members
53
Miscellaneous Team Expenses1/3/20161/8/20161/5/1900$0.00 $0.00 15$0.00 $0.00
54
55
Materials Truck Services for the Team
56
Materials Truck4$45.00 $180.00 $180.00 $180.00
57
Driver Services4$10.00 $40.00 $40.00 $40.00
58
Truck Fuel4$10.00 $40.00 $40.00 $40.00
59
60
Team Expense Totals
61
Total Expenses ( listed above )$4,465.00
62
Total Number of Team Members 15
63
Total per person charges ( length of stay ):
$297.67
64
65
Personal Expenses - Planning
66
Personal Expense1/3/20161/8/20161/5/1900$0.00 $0.00 $0.00
67
Airline Round Trip ( per person estimate )$500.00
68
Total per person for Personal Expenses
$500.00
69
70
Totals:
71
Total per person charges ( length of stay ):
$297.67
72
Total per person for Personal Expenses
$500.00
73
Total per person Expenses:$797.67
74
75
9/1/15, Rev. 4, Re-Issue: 01/01/16
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
Loading...
Main menu