RV Travel Budget Template

	B	C	D	E	F	H	I	J	K	L	N	O	P	Q	R
1
2	RV Travel Budget					RV Travel Budget - Actual Spending					RV Travel Budget - Variance
3	Updated	[INPUT DATE]				Updated	[INPUT DATE]				Updated	[INPUT DATE]
4
5		Budget					Actual					Variance
6		Destination					Destination					Destination
7	Description	Destination 1	Destination 2	Destination 3	Total	Description	Destination 1	Destination 2	Destination 3	Total	Description	Destination 1	Destination 2	Destination 3	Total

8	Travel					Travel					Travel
9	Distance	308	461	496	1265	Distance	308	461	496	1265	Distance
10	Add'l Miles driven touring	0	0	400	400	Add'l Miles driven touring	0	0	400	400	Add'l Miles driven touring
11		308	461	896	1665		308	461	896	5061		0	0	0	0
12	Avg MPG	8	8	8	8	Avg MPG	8	8	8	9.6	Avg MPG
13	Est. Gallons Used	39	58	112	208	Est. Gallons Used	28	54		527.1875	Est. Gallons Used
14	Est. Cost / Gallon	$3.60	$3.30	$3.50	$3.47	Est. Cost / Gallon				$1.80	Est. Cost / Gallon
15	Total Fuel Cost	$140.40	$191.40	$392.00	$723.80	Total Fuel Cost	$115.00	$194.87	$637.02	$946.89	Total Fuel Cost	-$25.40	$3.47	$245.02	$223.09
16
17	Campground Cost					Campground Cost					Campground Cost
18	Nights	1	1	4	6	Nights	1	1	4	6	Nights				0
19	Cost / Night	$45.00	$63.84	$117.87	$226.71	Cost / Night	$40.00	$63.84	$117.87	$221.71	Cost / Night				$0.00
20	Extended Rate	$45.00	$63.84	$471.48	$580.32	Extended Rate	$40.00	$63.84	$471.48	$575.32	Extended Rate	-$5.00	$0.00	$0.00	-$5.00
21	Incendentals				$0.00	Incendentals	6	18.5	18.23	$42.73	Incendentals				$0.00
22	Total Campground	$45.00	$63.84	$471.48	$580.32	Total Campground	$46.00	$82.34	$489.71	$618.05	Total Campground	$1.00	$18.50	$18.23	$37.73
23
24	Food					Food					Food
25	Grocery	$584.45			$584.45	Grocery				$0.00	Grocery				$0.00
26	Liquor	$21.00	$42.36		$63.36	Liquor	$21.00			$21.00	Liquor				$0.00
27	Ice Cream				0	Ice Cream			64	64	Ice Cream				0
28	Out to Eat				0	Out to Eat				0	Out to Eat				0
29	Other				0	Other		3.81		3.81	Other				0
30	Total Food	$605.45	$42.36	$0.00	$647.81	Total Food	$21.00	$3.81	$64.00	$88.81	Total Food	-$584.45	-$38.55	$64.00	-$559.00
31
32	Entertainment					Entertainment					Entertainment
33	Natinoal Park Pass	$80.00			$80.00	Natinoal Park Pass	$80.00			$80.00	Natinoal Park Pass				$0.00
34	Parking Fees			$15.00	$15.00	Parking Fees				$0.00	Parking Fees				$0.00
35	State Park Entry Fee			$20.00	$20.00	State Park Entry Fee				$0.00	State Park Entry Fee				$0.00
36	Rodeo				$0.00	Rodeo				$0.00	Rodeo				$0.00
37	Medora Show				$0.00	Medora Show				$0.00	Medora Show				$0.00
38	Bear Spray	$30.00			$30.00	T-Shirts				$0.00	Insert				$0.00
39	Insert				$0.00	Gifts				$0.00	Insert				$0.00
40	Insert				$0.00	Insert				$0.00	Insert				$0.00
41	Insert				$0.00	Insert				$0.00	Insert				$0.00
42	Insert				$0.00	Insert				$0.00	Insert				$0.00
43	Other			$75.00	$75.00	Other				$0.00	Other				$0.00
44	Total Entertainment	$110.00	$0.00	$110.00	$220.00	Total Entertainment	$80.00	$0.00	$0.00	$80.00	Total Entertainment	-$30.00	$0.00	-$110.00	-$140.00
45
46	Miscellaneous					Miscellaneous					Miscellaneous
47	Wall Drug			$25.00	$25.00	Wall Drug				$0.00	Wall Drug				$0.00
48	T-Shirts			$125.00	$125.00	T-Shirts			$115.00	$115.00	T-Shirts				$0.00
49	Stickers	$5.00	$5.00	$25.00	$35.00	Stickers			$3.00	$3.00	Stickers				$0.00
50	Insert				$0.00	Insert				$0.00	Insert				$0.00
51	Other				$0.00	Other				$0.00	Other				$0.00
52	Total Miscellaneous	$5.00	$5.00	$175.00	$185.00	Total Miscellaneous	$0.00	$0.00	$118.00	$118.00	Total Miscellaneous	-$5.00	-$5.00	-$57.00	-$67.00
53
54	Total Estimate	$905.85	$302.60	$1,148.48	$2,356.93	Total Actual	$262.00	$281.02	$1,308.73	$1,851.75	Total Variance	-$643.85	-$21.58	$160.25	-$505.18
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