ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
City SC Utah Coaches Travel CalculatorRev. 04/15/26
2
To be used for coaches travel, when travelingData entry is required for ALL cells
3
more than 120 miles from 12600 S Bangerter HighwayOutput calculation
4
and requiring an overnight stayOutput values
5
Club defined values
6
7
8
Tournament (or Event) Name:President's Cup
9
Location (City, State):Mesquite, NV
10
Hotel Name:Eureka
11
Hotel Location (City, State):Mesquite, NV
12
Tournmament Dates:February 9-10, 2018
13
14
15
Tournament days:4
16
Travel days:2
17
18
19
AFood and daily need calculation $ 480.00 $ 480.00
20
Number of tournament and travel days6
21
Daily per diem (M&IE gsa.gov) $ 80.00
22
23
24
BHotel cost calculation $ 405.00 $ 405.00
25
Number of Hotel nights booked3
26
If TM books and pays for room, enter 0 here3
27
Daily room rate (single occupancy) $ 135.00
28
Rate must include local taxes (contact hotel)
29
Recommended that coaches share a room or rental
30
31
32
33
CTransportation cost calculation $ 530.56 $ 530.56
34
Data entry is required for ALL cells to determine
35
lowest transportation cost defined by USA policy.
36
37
1Drive personal car
38
Trip miles (one way from 12600 S Bangerter Highway to HOTEL)
400
39
Game day miles (20-60 miles/day, game days only)60
40
Mileage rate (in policy and specificed by the IRS gsa.gov) $ 0.760
41
Total Mileage cost $ 790.40
42
43
44
2Drive rental car
45
Midsize car daily rate (Kayak.com) $ 72.00
46
Rate MUST include ALL local taxes and fees (contact agency)
47
Fuel cost per gallon $ 4.10
48
Total Rental cost $ 530.56 Lowest Cost
49
50
51
3Flying and drive rental car
52
Airfare, 30 day advance, round trip (google flights) $ 425.00
53
Fare MUST include ALL taxes and fees (contact agent/airline)
54
Baggage fees ($50/bag/each way) $ 100.00
55
Midsize car daily rate @ flight destination (Kayak.com) $ 72.00
56
Trip miles (one way from airport to HOTEL)75
57
Fuel cost per gallon @ flight destination $ 4.10
58
Total Flying/driving cost $ 948.96
59
60
61
Total to be collected from team: $ 1,415.56
62
63
64
Total payment due to coach: $ 1,415.56
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