A | B | C | D | E | F | G | H | I | J | K | L | |
---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | Travel Budget | by Vertex42.com | ||||||||||
2 | My Budget & Expenses | Where are my total expenses going? | Travel Budget Worksheet | |||||||||
3 | Total Budget | © 2014-2019 Vertex42 LLC | ||||||||||
4 | $2,750.00 | Transportation | 42% | $1,068 | ◄ Enter your Total Budget in B4 | |||||||
5 | Total Expenses | Lodging | 24% | $600 | ||||||||
6 | $2,552.70 | Food | 21% | $525 | To Print: Hide this column first. | |||||||
7 | Difference | Entertainment | 4% | $110 | ||||||||
8 | $197.30 | Other | 10% | $250 | ◄ Other includes everything that is not one of | |||||||
9 | the other 4 categories | |||||||||||
10 | [42] | |||||||||||
11 | What are my expenses? | |||||||||||
12 | description | type | quantity | unit cost | amount | |||||||
13 | Flights | Transportation | 2 | 400.00 | 800.00 | ◄ Enter all your travel expenses | ||||||
14 | Taxi & Bus | Transportation | 5 | 30.00 | 150.00 | ◄ Quantity is assumed to be 1 if left blank | ||||||
15 | Driving (miles, cost/mile) | Transportation | 50 | 0.56 | 28.00 | |||||||
16 | Parking (days, cost/day) | Transportation | 6 | 14.95 | 89.70 | |||||||
17 | Hotel (nights, cost/night) | Lodging | 5 | 120.00 | 600.00 | |||||||
18 | Breakfast & Lunch | Food | 5 | 45.00 | 225.00 | Additional Templates | ||||||
19 | Dinners | Food | 5 | 50.00 | 250.00 | ► Travel Itinerary Template | ||||||
20 | Snacks and Drinks | Food | 5 | 10.00 | 50.00 | ► Budget Templates | ||||||
21 | Museum Tickets | Entertainment | 2 | 20.00 | 40.00 | ► Money Manager Template | ||||||
22 | Live Show Tickets | Entertainment | 2 | 35.00 | 70.00 | |||||||
23 | Maps and Guidebooks | Other | 50.00 | 50.00 | ||||||||
24 | Souvenirs and Gifts | Other | 200.00 | 200.00 | ||||||||
25 | - | |||||||||||
26 | - | |||||||||||
27 | - | |||||||||||
28 | - | |||||||||||
29 | - | |||||||||||
30 | - | |||||||||||
31 | - | |||||||||||
32 | - | |||||||||||
33 | - | ◄ Insert new rows ABOVE this line | ||||||||||
34 | Total Expenses | $ 2,552.70 |