EC Papers September 2017
Hotel Sales 2015-2017
180,000.00
160,000.00
140,000.00
120,000.00
100,000.00
2015
2016
80,000.00
2017
60,000.00
40,000.00
20,000.00
-
January
February
March
April
May
June
July
August
September
October
November
December
January
February
March
April
May
June
July
August
September 142,373.92 122,170.00
October
November 98,422.34 107,437.55
December 123,528.38 128,105.29
Total
2015 2016 2017
71,507.97 65,457.00 69,680.00 4,223.00
83,912.22 78,246.12 88,225.00 9,978.88
101,136.75 104,533.56 86,334.00 18,199.56
90,479.69 87,556.48 130,695.90 43,139.42
144,564.76 112,411.00 128,433.00 16,022.00
125,722.33 104,985.00 130,683.21 25,698.21
93,968.18 124,536.00 155,762.51 31,226.51
148,952.40 115,397.00
116,747.35 93,994.20
1,341,316.29 1,244,829.20 789,813.62 455,015.58
Variance
-
-
115,397.00
122,170.00 -
93,994.20 -
107,437.55 -
128,105.29 -
-
Hotel Budget V Actual Net Profit by Month January
February (32,308)
March
April
May
June
July
August
September
October
November
December
Total
2017 Actual Net Profit
(51,566)
(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 133,219
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
2017 Hotel Budget vs Actual Net Profit/(Loss)
20,000
10,000
0
January
February
March
April
May
June
July
August
September
October
November
December
(10,000)
2017 Actual Net Profit
(20,000)
2017 Budget Net Profit
(30,000)
(40,000)
(50,000)
(60,000)
Budget v ACTUAL Sales
January
February
March
April
May
June
July
August
September
October
November
December
Total
2017 Budget 2017 Sales
81,373 69,680
87,894 88,225
122,601 86,334 (36,267)
121,190 130,696
133,652 128,433 (5,219)
113,444 130,683 17,239
140,385 155,763 15,378
148,043
143,034
118,166
104,256
117,069
1,431,107 789,814 (641,293)
0
0
0
0
0
Variance
(11,693)
331
9,506
(148,043)
(143,034)
(118,166)
(104,256)
(117,069)
2017 Hotel Sales vs Budget
180,000
160,000
0 0 789,814 (641,293)
140,000
120,000
100,000
2017 Budget
80,000
2017 Sales
60,000
40,000
20,000
0
January
February
March
April
May
June
July
August
September
October
November
December
Made with FlippingBook Learn more on our blog