Travel Expenses and Budget Spreadsheet- Johnnyafrica.com

	A	B	C	E	F	G	H	I	J
1	Travel Expenses and Budgeting Spreadsheet
2
3		My Budget & Expenses		Breakdown of Expenses
4			Total Budget
5			$2,750.00		Transportation	41%	1,068
6			Total Expenses		Lodging	23%	600	$2,613
7			$2,612.70		Food and Drinks	22%	585	$2,613
8			Difference		Activities	4%	110
9			$137.30		Other	10%	250
10
11
12
13			What are my expenses?
14		description			category		quantity	unit cost	amount
15			Flights		Transportation		2	400.00	800.00
16			Taxi & Bus		Transportation		5	30.00	150.00
17			Driving (miles, cost/mile)		Transportation		50	0.56	28.00
18			Parking (days, cost/day)		Transportation		6	14.95	89.70
19			Hotel (nights, cost/night)		Lodging		5	120.00	600.00
20			Breakfast		Food and Drinks		5	12.00	60.00
21			Lunch		Food and Drinks		5	45.00	225.00
22			Dinners		Food and Drinks		5	50.00	250.00
23			Snacks and Drinks		Food and Drinks		5	10.00	50.00
24			Museum Tickets		Activities		2	20.00	40.00
25			Live Show Tickets		Activities		2	35.00	70.00
26			Maps and Guidebooks		Other		1	50.00	50.00
27			Souvenirs and Gifts		Other		1	200.00	200.00
28									-
29									-
30									-
31									-
32									-
33									-
34									-
35									-
36									-
37									-
38								Total Expenses	$ 2,612.70
39
40
41
42
43
44
45
46
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