40-41 / 99
January
February
March
April
May
June
July
August
September
October
November
December
Total
2015
71,507.97
83,912.22
101,136.75
90,479.69
144,564.76
125,722.33
93,968.18
148,952.40
142,373.92
116,747.35
98,422.34
123,528.38
1,341,316.29
2016
65,457.00
78,246.12
104,533.56
87,556.48
112,411.00
104,985.00
124,536.00
115,397.00
122,170.00
93,994.20
107,437.55
128,105.29
1,244,829.20
2017
69,680.00
88,225.00
86,334.00
130,695.90
128,433.00
130,683.21
155,762.51
789,813.62
Variance
4,223.00
9,978.88
18,199.56
-
43,139.42
16,022.00
25,698.21
31,226.51
115,397.00
-
122,170.00
-
93,994.20
-
107,437.55
-
128,105.29
-
455,015.58
-
Hotel Budget V Actual Net Profit by Month
January
February
March
April
May
June
July
August
September
October
November
December
Total
2017 Actual Net Profit
(51,566)
(32,308)
(25,000)
(2,221)
(2,054)
(6,215)
(1,786)
0
0
0
0
0
(121,150)
2017 Budget Net
Profit
(22,552)
(14,339)
8,465
3,863
6,874
3,631
6,079
6,953
5,183
3,686
(2,874)
7,099
12,069
Variance
29,014
17,969
33,465
6,084
8,928
9,846
7,865
6,953
5,183
3,686
(2,874)
7,099
133,219
Budget v ACTUAL Sales
January
February
March
April
May
June
July
August
September
October
November
December
Total
2017 Budget
81,373
87,894
122,601
121,190
133,652
113,444
140,385
148,043
143,034
118,166
104,256
117,069
1,431,107
2017 Sales
69,680
88,225
86,334
130,696
128,433
130,683
155,763
0
0
0
0
0
789,814
Variance
(11,693)
331
(36,267)
9,506
(5,219)
17,239
15,378
(148,043)
(143,034)
(118,166)
(104,256)
(117,069)
(641,293)
0
0
789,814 (641,293)
(60,000)
(50,000)
(40,000)
(30,000)
(20,000)
(10,000)
0
10,000
20,000
January
February
March
April
May
June
July
August
September
October
November
December
2017 Hotel Budget vs Actual Net Profit/(Loss)
2017 Actual Net Profit
2017 Budget Net Profit
0
20,000
40,000
60,000
80,000
100,000
120,000
140,000
160,000
180,000
January
February
March
April
May
June
July
August
September
October
November
December
2017 Hotel Sales vs Budget
2017 Budget
2017 Sales
-
20,000.00
40,000.00
60,000.00
80,000.00
100,000.00
120,000.00
140,000.00
160,000.00
180,000.00
January
February
March
April
May
June
July
August
September
October
November
December
Hotel Sales 2015-2017
2015
2016
2017