Roadrunner Yr 8 Summary Expenses v0.1.xlsx
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
View only
 
 
Still loading...
ACDEFGHIJKLMNOPQSTUWYZ
1
2
3
4
2016-2017BudgetYear8 Actual ExpensesAverages
5
MonthlyJun-17Jul-17Aug-17Sep-17Oct-17Nov-17Dec-17Jan-17Feb-17Mar-17Apr-17May-17Monthly Actual to Budget
Actual Totals
Budget to Actuals Monthly AvgMonthly Avg to Budget
6
RV Insurance125.00 $ 123.25 $ 123.25 $ 123.25 $ 123.25 $ 123.25 $ 123.25 $ 123.25 $ 123.25 $ 123.25 $ 141.55 $ 141.55 $ 141.55 $ (41.55) $ 1,533.90 $ (658.90) $ 127.83 $ (2.82) $ 61.63
7
Car Insurance50.00 $ 47.60 $ 47.60 $ 47.60 $ 47.60 $ 67.47 $ 67.47 $ 67.47 $ 67.47 $ 71.26 $ 71.26 $ 71.26 $ 71.26 $ (21.26) $ 745.34 $ (395.34) $ 62.11 $ (12.11) $ 54.22
8
Diesel (RV & Generator)
435.00 $ 358.50 $ 717.84 $ 874.60 $ 365.34 $- $ 684.99 $ 959.86 $- $- $- $- $ 160.63 $ 439.37 $ 4,121.76 $ (1,076.76) $ 343.48 $ 91.52 $ 500.21
9
Gas - Car200.00 $ 181.61 $ 222.04 $ 66.19 $ 158.66 $ 178.36 $ 111.23 $ 111.23 $ 223.68 $ 143.26 $ 152.98 $ 167.31 $ 195.09 $ 4.91 $ 1,911.64 $ (511.64) $ 159.30 $ 40.70 $ 153.02
10
Misc (Tolls, etc)5.00 $ 1.00 $ 16.00 $ 12.00 $- $ 35.49 $ 119.10 $ 74.62 $ 73.90 $- $ 184.15 $ 1.10 $ 4.00 $ 21.00 $ 521.36 $ (486.36) $ 43.45 $ (38.45) $ 30.60
11
Propane10.00 $- $- $- $- $- $- $ 44.49 $- $ 75.34 $- $- $- $ 10.00 $ 119.83 $ (49.83) $ 9.99 $ 0.01 $ -
12
RV & Car Maintenance
475.00 $- $ 1,565.58 $ 1,111.44 $ 4,076.91 $ 874.49 $ 647.25 $ 1,659.30 $ 608.09 $ 1,048.43 $ 9.00 $ 121.30 $ 463.00 $ 87.00 $ 12,184.79 $ (8,859.79) $ 1,015.40 $ (540.40) $ 1,379.28
13
Campgrounds705.00 $ 976.58 $ 1,022.01 $ 1,134.79 $ 259.26 $ 562.08 $ 723.74 $ 705.65 $ 527.00 $ 476.00 $ 527.00 $ 519.00 $ 579.00 $ 21.00 $ 8,012.11 $ (3,077.11) $ 667.68 $ 37.32 $ 738.89
14
TV100.00 $ 85.56 $ 85.56 $ 85.56 $ 85.56 $ 85.56 $ 85.56 $ 85.56 $ 85.52 $ 92.38 $- $ 179.68 $ 72.38 $ 152.62 $ 1,028.88 $ (328.88) $ 85.74 $ 14.26 $ 85.56
15
Comp Accessories
100.00 $ 5.07 $ 5.07 $ 38.02 $ 17.54 $ 5.07 $ 22.01 $ 53.91 $ 85.86 $ 39.51 $ 59.77 $ 46.98 $ 35.88 $ (15.88) $ 414.69 $ 285.31 $ 34.56 $ 65.44 $ 15.46
16
Cell Phones/internet
300.00 $ 200.90 $ 223.80 $ 223.80 $ 338.14 $ 269.46 $ 296.46 $ 229.46 $ 209.90 $ 209.90 $ 209.96 $ 209.96 $ 209.96 $ (59.96) $ 2,831.70 $ (731.70) $ 235.98 $ 64.03 $ 258.76
17
Groceries400.00 $ 366.91 $ 404.91 $ 310.67 $ 279.21 $ 675.92 $ 427.51 $ 663.07 $ 765.16 $ 648.30 $ 489.67 $ 648.34 $ 516.66 $ (116.66) $ 6,196.33 $ (3,396.33) $ 516.36 $ (116.36) $ 410.86
18
Eating Out 350.00 $ 122.80 $ 213.81 $ 424.24 $ 169.25 $ 309.50 $ 482.54 $ 295.91 $ 274.81 $ 431.99 $ 422.97 $ 488.74 $ 297.17 $ (57.17) $ 3,444.99 $ (994.99) $ 287.08 $ 62.92 $ 287.02
19
Mail30.00 $ 11.99 $ 96.15 $ 68.79 $ 11.99 $ 22.24 $ 11.99 $ 47.23 $ 47.24 $ 24.74 $ 14.83 $ 11.99 $ 11.99 $ 28.01 $ 381.17 $ (171.17) $ 31.76 $ (1.76) $ 37.19
20
Laundry20.00 $ 7.00 $- $ 64.39 $- $- $- $ 23.58 $ 10.00 $- $- $- $- $ 15.00 $ 104.97 $ 35.03 $ 8.75 $ 11.25 $ 11.90
21
Medical (Tricare & Dentist)
20.00 $ 41.25 $ 52.69 $ 256.88 $ 1,221.79 $ 2,134.00 $ 30.00 $- $ 21.15 $ 319.59 $ 200.09 $- $ 30.36 $ 119.64 $ 4,307.80 $ (4,167.80) $ 358.98 $ (338.98) $ 622.77
22
Misc (Entertainment/Clothes/Gifts)
300.00 $ 223.22 $ 304.97 $ 171.91 $ 361.73 $ 287.02 $ 453.26 $ 827.23 $ 605.76 $ 27.45 $ 316.25 $ 482.41 $ 359.91 $ (9.91) $ 4,421.12 $ (2,321.12) $ 368.43 $ (68.43) $ 300.35
23
Household Items 300.00 $ 19.46 $ 83.59 $ 288.99 $ 160.84 $ 50.15 $ 48.73 $ 368.77 $ 175.31 $ 107.45 $ 230.62 $ 438.25 $ 182.91 $ 17.09 $ 2,155.07 $ (55.07) $ 179.59 $ 120.41 $ 108.63
24
Memberships 125.00 $- $- $- $- $- $- $ 3.15 $- $- $ 69.00 $ 110.00 $- $ 30.00 $ 182.15 $ 692.85 $ 15.18 $ 109.82 $ -
25
1 Time Costs 50.00 $ 1,222.96 $ 118.34 $- $- $- $- $- $ 217.13 $ 423.43 $- $- $- $ 30.00 $ 1,981.86 $ (1,631.86) $ 165.16 $ (115.16) $ 223.55
26
Total$4,100.00 $ 3,995.66 $ 5,303.21 $ 5,303.12 $ 7,677.07 $ 5,680.06 $ 4,335.09 $ 6,343.74 $ 4,121.23 $ 4,262.28 $ 3,099.10 $ 3,637.87 $ 3,628.92 $ 371.08 $ 56,898.63 $ (28,198.63) $ 4,741.55 $ (641.55) $ 5,382.37
27
Cumulative Totals
$ 3,995.66 $ 9,298.87 $ 14,601.99 $ 22,279.06 $ 27,959.13 $ 32,294.22 $ 38,637.96 $ 42,759.19 $ 47,021.48 $ 50,120.58 $ 53,758.45 $ 57,387.37 $ 24,975.49 $ 342,237.84
28
Monthly Avg
$ 3,995.66 $ 4,649.43 $ 4,867.33 $ 5,569.77 $ 5,591.83 $ 5,382.37 $ 5,519.71 $ 5,344.90 $ 5,224.61 $ 5,012.06 $ 4,887.13 $ 4,782.28 $ 59,967.01
29
$4,100.00 $8,200.00$12,300.00$16,400.00 $20,500.00 $24,600.00$28,700.00$32,800.00$36,900.00$41,000.00$45,100.00$49,200.00
30
Cumulative Budget vs Actual$104.34-$1,098.87-$2,301.99-$5,879.06-$7,459.13-$7,694.22-$9,937.96-$9,959.19-$10,121.48-$9,120.58-$8,169.71-$7,698.63
31
32
33
34
35
36
37
38
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
Loading...
 
 
 
Sheet1
Sheet2