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