EC Papers September 2017

Quorn Grange Hotel

Date: 21/08/2017 Time: 10:20:02

Page: 1

Profit and Loss (Monthly Breakdown)

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

Detailed Layout of Accounts

Jan

Feb

Mar

Apr

May

Jun

Jul

Totals

Sales Food & Beverages

19,738.87

18,779.84

24,294.95

32,537.80 38,018.57 31,014.25 31,924.46 196,308.74

Miscellaneous Sales

252.62

504.39

432.51

584.03

525.73 1,001.49

431.05 3,731.82

Accomodation

40,579.07

51,358.77

48,868.89

52,478.92 57,778.40 59,065.38 57,313.27 367,442.70

Conferences

4,510.12

6,284.03

3,785.87

3,793.46 3,173.99 3,519.76 4,913.12 29,980.35

Weddings

0.00

6,444.71

2,957.08

35,320.27 21,291.82 28,572.49 49,876.59 144,462.96

Hotel Events

0.00

116.66

91.67

0.00

0.00

0.00

0.00

208.33

Breakfast Sales

2,530.67

2,703.75

3,025.84

3,565.41 3,926.25 5,462.92 5,306.04 26,520.88

Nursery Fees

0.00

0.00

0.00

0.00

0.00

0.00

617.53

617.53

Nursery Meals

1,548.75

1,630.00

2,356.07

2,092.59 3,187.52 1,711.00 1,764.83 14,290.76

Gym Membership

515.76

399.30

519.96

320.35

528.29

332.79

411.88 3,028.33

Bank Interest

4.60

4.24

1.16

3.07

3.09

3.13

3.64

22.93

Kurdish Event

0.00 0.00 3,200.10 3,200.10 69,680.46 88,225.69 86,334.00 130,695.90 128,433.66 130,683.21 155,762.51 789,815.43 0.00 0.00 0.00 0.00

Purchases

Food & Beverages Purchases Miscellaneous Purchases Function Purchases

13,763.23

14,297.21

14,082.47

21,773.77 23,188.89 26,044.77 28,705.11 141,855.45

180.40

0.00

167.10

0.00

868.50

20.83

275.30 1,512.13

3,215.33

295.30

1,245.00

2,002.58 2,111.00 1,278.00 3,248.00 13,395.21

Hotel Room Consumables

179.51

603.28

704.66

715.28

473.98

892.06

920.72 4,489.49

Movement in Stock

695.61 102.31 (1,734.79) 17,676.91 16,007.25 16,894.84 25,871.04 25,787.48 24,028.53 33,251.44 159,517.49 811.46 338.44 1,379.41 (854.89) (4,207.13)