EC Meeting Papers January 2018
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 147,266.32
October
November 98,422.34 107,437.55 101,783.25
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 146,436.32 31,039.32
116,747.35 93,994.20 120,711.68 26,717.48
1,341,316.29 1,244,829.20 1,306,011.19
Variance
-
25,096.32
-
5,654.30
128,105.29 -
61,181.99
Hotel Budget V Actual Net Profit by Month
January (51,566)
February (32,308)
March
April
May
June
July
August
September
October (10,961)
November
December
Total
2017 Actual Net Profit
(25,000)
(2,221)
(2,149)
(6,215)
(3,286)
2,066
9,519
(24,021)
0
(146,142)
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 158,211
Variance
29,014
17,969
33,465
6,084
9,023
9,846
9,365
4,887
(4,337)
14,647
21,147
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 146,436 (1,607)
143,034 147,266
118,166 120,712
104,256 101,783 (2,473)
117,069
1,431,107 1,306,011 (125,096)
0
Variance
(11,693)
331
9,506
4,232
2,546
(117,069)
2017 Hotel Sales vs Budget
180,000
160,000
0
0
140,000
1,306,011
(125,096)
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 flipbook maker