EC Papers September 2018

Quorn Grange Hotel

Date: 16/08/2018 Time: 10:11:25

Page: 1

Profit and Loss (Monthly Breakdown)

From: Month 1, January 2018 To: Month 7, July 2018 Chart of Accounts:

Detailed Layout of Accounts

Jan

Feb

Mar

Apr

May

Jun

Jul

Totals

Sales Food & Beverages

25,243.74

29,049.64

27,525.78

37,809.35 44,664.64 56,899.17 49,730.87 270,923.19

Miscellaneous Sales

0.00

248.10

178.55

174.00

92.98

156.88

77.41

927.92

Accomodation

42,412.55

47,839.18

46,899.81

46,269.53 77,765.04 71,392.20 69,119.64 401,697.95

Conferences

2,879.16

4,639.36

3,703.39

1,577.53 2,593.97 3,901.65 2,560.85 21,855.91

Weddings

6,930.18

19,361.57

24,816.91

25,821.78 13,110.01 21,333.76 18,112.05 129,486.26

Hotel Events

0.00

331.67

361.66

293.33

299.17

88.33

307.51 1,681.67

Breakfast Sales

5,188.54

4,586.58

3,516.50

5,232.50 6,689.62 3,682.34 7,097.80 35,993.88

Nursery Meals

1,862.80

1,557.59

507.40

141.60

0.00

0.00

0.00 4,069.39

Gym Membership

424.12

378.43

311.63

565.00

242.65

91.42

112.25 2,125.50

Bank Interest

1.27 19.34 84,943.26 107,994.10 107,822.90 117,886.37 145,461.87 157,549.62 147,122.89 868,781.01 1.98 2.17 1.75 3.79 3.87 4.51

Purchases Lodge Expenses

0.00

0.00

1,855.41

0.00

0.00

0.00

0.00 1,855.41

Food & Beverages Purchases Out Sourced Accommodation Miscellaneous Purchases Function Purchases

12,601.16

18,232.71

21,416.65

16,022.87 22,933.01 24,330.95 22,020.33 137,557.68

0.00

118.21

0.00

0.00

0.00

0.00

0.00

118.21

170.80

168.80

1.25

162.25

254.76 1,616.89 1,132.49 3,507.24

1,913.81

1,852.28

2,614.20

550.00

875.00 2,133.33

827.92 10,766.54

Hotel Room Consumables

769.69

589.89

643.63

290.53

841.54

246.47

291.24 3,672.99

Movement in Stock

988.56 1,932.49 (2,017.38) (1,674.05) 16,051.47 21,056.30 27,519.70 15,779.46 22,882.36 30,260.13 22,254.60 155,804.02 94.41 596.01 (1,246.19) (2,021.95)