EC PAPERS NOVEMBER 2017

EC PAPERS NOVEMBER 2017

How to find us

Easily reached by either road or rail (or by air from East Midlands airport just 30 minutes away), Quorn Grange Hotel is a useful base for guests wishing to visit the attractions in the area. In addition, the cities of Leicester and Nottingham are only a short distance away.

BY ROAD From the North : Leave the M1 at junction 23 (Loughborough) following signs for the A6 south (Leicester). Shortly after leaving Loughborough, turn off the A6 dual carriageway into Quorn. Go straight through Quorn. Wood Lane is a right turn, at the far end of the village, at the third mini roundabout. Quorn Grange Hotel is about a quarter of a mile further on, on the left. From the South : Leave the M1 at junction 21a and take the A46 Leicester western bypass (Newark). Turn left from the A46 onto the A6 dual carriageway, turning left at a small roundabout signposted Quorn/Mountsorrel. At the next roundabout, turn right towards Quorn. After about one mile, turn left into Wood Lane at a mini roundabout. Quorn Grange Hotel is about a quarter of a mile further on, on the left.

BY RAIL There are Midland Mainline services from London St Pancras to Sheffield which stop at Loughborough and Leicester.

BUS

The number 2 kinchbus, 126 and 127 bus runs from Leicester bus station to Quorn. The number 2 kinchbus, 126 and 127 bus runs from Loughborough town centre to Quorn.

Number 2 bus information

Number 126 / 127 bus information

Quorn Grange Hotel 88 Wood Lane Quorn Leicestershire LE12 8DB

Tel: 01509 412167 Fax: 01509 415621

GFTU Executive Committee

November 17 th , 2017

AGENDA

1

Apologies

2

Declaration of Any Other Business

3

Minutes of the Previous Meeting

4

Corrections, Approval of the Minutes

5

Matters Arising from the Minutes

6

Financial Position, Overall Strategy, GFTU, ET, Hotel, Nursery

7

Proposal on Affiliation Fees 2018

8

Budgets 2018

9

Issues from affiliates

10

Certification Officer levy

11

New Build Project

12

Finance and General Purposes Committee, membership and next meeting.

13

Education Officer’s Report

14

Next Education Programme

15

General Secretary’s Report

16

Any Other Business

EC Minutes September 20 2017

General Federation of Trade Unions

Executive Committee Minutes

September 20 th 2017

Quorn Grange Hotel, Leicestershire

In attendance: Bro. Doug Nicholls, (Gen Sec), Sis. Claire Ryan, (Minute Taker).

Bro. Brian Linn, Bro. Roy Rickhuss, Bro. Robert Mooney, Sis. Yvonne Pattison, Sis. Christine Miller, Bro. Freddie Seale, Bro. Brian Linn , Bro. Ronnie Draper, Sis. Angela Pratten, Bro. Robert Mooney, Bro. Colin Kirkham, Bro. John McGowan, Sis. Sarah Woolley, Bro. Garry Elliott, Bro. Ian Lawrence, Sis. Theresa Easton.

Apologies:

Bro. Nick McCarthy, Sis. Bindu Paul, Sis. Claire Jones, Bro, Sis. Janie Nicholl, Bro. Neil Crew, Bro. Steve Gillan, Sis. Keeley Lipscombe, Bro. John Smith, Bro. Osher Williams, Bro. John Toner, Sis. Maddy Radcliffe, Bro. Manuel Cortes, Bro. Charlie Sarrell.

Paperwork circulated for the meeting: Minutes of previous meeting, Financial and Accounts Information, New build plans, new promotional leaflets, General Secretary’s Report, Education Officers Report, EC Expenses Claim Form.

1.

Any other Business

Bro. Nicholls asked for EC members approval to chair the meeting today due to emergency meetings being attended by the intended chairs. This was agreed.

EC members agreed

Bro. Nicholls and EC members welcomed the two new EC Young Members, Bro. Seale and Sister Miller. EC members introduced themselves individually.

Bro. Draper to report on McDonalds strike action under Youth Festival.

2.

Minutes of the previous meeting.

Matters arising from the Minutes.

No matters arising declared.

1

EC Minutes September 20 2017

3.

Corrections to the minutes.

These were agreed as a true and accurate record.

No Corrections declared.

Bro. Nicholls brought attention to the Pension scheme decision for the benefit of the new EC members. The would be proposed at the October meeting of the Pensions Trustees.

4.

Finances: GFTU, ET, Hotel, Nursery.

4.1 Bro. Nicholls gave new EC members a brief financial overview and structure of hotel, nursery, ET and GFTU accounts. Bro. Nicholls reported EC members are legally responsible for GFTU accounts, Pensions Trustees for the Pension scheme, but this can have a big impact on the GFTU as he main employer, the Education Trust Trustees are responsible for the Trust account and the Hotel Directors currently for the nursery and hotel.

4.2

Sis. Cheung, GFTU Finance Manager reported on GFTU and ET finances iin detail.

4.3 Bro. Linn questioned the surplus amounts and Sis. Cheung explained this was due to preparing for the new build development funding.

4.4 Bro. Nicholls reported that £4000 is given to the ET from nursery and hotel each month in gift aid as well as a contribution towards salary. 4.5 Sis. Dave, GFTU Senior Finance Manager reported on Nursery and hotel finances. In summary both performing well. Sis. Dave reported that the hotel had held 80 weddings this year and already had 52 weddings booked for 2018. Hotel had suffered costs of boiler, I.T and dishwasher.

4.6 Bro. Lawrence asked if we could appeal against the high rateable value.

4.7

Sis Cheung explained appeals had taken place and they would continue, Nikki Sharpe, Solicitor, was assisting.

4.8 Bro. Nicholls reported the target profit figure for the new hotel is £200k, for the rental income from houses £85k and from the nursery £70k and the business modelling for the new build was all dependent on these.

5.

New Build. See General Secretary’s report.

5.1 Bro. Nicholls gave an overview of the history of the new build development for the benefit of the new EC members. Bro. Nicholls

2

EC Minutes September 20 2017

reported on architect plans for the new build and confirmed that the contractors would be approved in November.

5.2 Bro. Nicholls discussed additional costs of approx. £100k for agreed classrooms and approx. £160k to extend the Goodacre suite.

5.3 EC members discussed contractors and tender process that would be involved in the development.

5.4 Sis Woolley raised that agencies should not be used for contractual work due to umbrella companies and zero hour contracts used. Bro Nicholls clarified that there was a pre qualifcation tender document to all potential tenders that would rule any bad practitioiners out.

5.5 EC members agreed that EC members would see final tender documents by email.

5.6

Bro. Nicholls discussed financial options for the new build development and it was agreed that the majority of the new build costs would be drawn from GFTU reserves with the balance coming from loans.

5.7

Sis. Cheung discussed the potential for loans and the current exploration of ownership issues..

5.8 Bro. Linn proposed and it was agreed that the Head of Finance would investigate the possibility of loans from the Funding Circle.

5.9 EC members were given a hardcopy of recent architect plan showing access to site. EC members discussed possible access options. Bro. Nicholls asked for EC approval to further discussions being held with local farmer, owner of the land and the possibility of further costs involved with this.

5.10 EC Members agreed to further discussions with land owner.

6.

General Secretary’s report.

6.1 Bro. Nicholls promoted the books that were available for purchase today at £5 each. These were produced by the new publishing house the GFTU had established withNew Internationalist – Workable

Books. The new books covered trade union education and a collection of 7 plays relating to the trade union movement.

6.2

Bro. Nicholls reported on his recent meeting with VOICE. EC members discussed the history behind the union and their constitution forbidding strike action. EC members agreed to keep dialogue open.

6.3 Sis. Pratten asked for clarification of the confidentiality of minutes and General Secretary's report.

6.4

Bro. Nicholls confirmed that minutes of EC meetings are not confidential unless otherwise required by the EC to EC members nad to affiliates. The General Secretary’s report was if it stated private

3

EC Minutes September 20 2017

and confidential or if involved any staff or staffing issues. Other papers should be considered confidential to EC members.

6.5 General Secretary’s report was discussed by Bro. Nicholls and approved by the EC.

7.

Education officers report.

7.1 Bro. Linn would like to be involved with Vietnamese finance union and be part of the exchange..

7.2 The EC discussed recent webinars that had taken place and were successful.

7.3 Sis. Woolley discussed core courses and expectations that places on courses should be full.

7.4 Bro. Callow reported that work needs to be done with the branding and promotion of courses. Bro. Nicholls reported that regular promotion of courses is planned.

7.5 Education Officers’ report was discussed by Education Officer, Dr John Callow and agreed by the EC.

8.

Kurdish Festival.

8.1 Bro. Nicholls reported on the successful Kurdish Festival that took place at Quorn. Sis. Easton and Bro. Williams attended for the EC. A full written evaluation had been done by all concerned and over 650 people mainly from the Kurdish communities had been present and it had meant a lot to them. Bro Nicholls reminded the meeting that in some parts of Turkey speaking Kurdish and celebrating their music and dance was forbidden. Many harrowing stories of the lives of the Jurds had been heard during the day. Abdullah Ocalan's niece, herself and MP had also been in attendance along with another leading HDP MP and other academics and supporters from over Europe.

8.2 Bro. Nicholls explained there were 300+ photos on display via the projector during todays’ meetings.

8.3 Bro. Nicholls reported that financial loss of event was due to security costs which it had been agreed were essential to take.

8.4 Sis. Easton reported that she agreed the event was a great success.

9.

Liberating Arts Festival.

9.1 Bro. Nicholls reported that promotion of liberating Arts Festival was needed to avoid the event being cancelled.

4

EC Minutes September 20 2017

10.

Youth Festival.

10.1 Sis. Woolley reported that the next meeting would be taking place October 4 th at Quorn Grange Hotel and that all new EC members would be invited and involved in the event.

10.2 Sis. Woolley asked for affiliated unions to assist in the promotion of the event.

10.3 Sis. Pattison raised disappointment that not all four members of the new EC members had attended today’s meeting for their first EC meeting after election.

10.4 Bro. Nicholls agreed to investigate the rule book for the provisions covering meeting attendance of EC members.

10.5 Bro. Draper reported on the recent very successful McDonald strike and the importance of McDonalds workers’ rights.

10.6 Bro. Draper reported that funding was needed for the campaign. Bro. Draper reported that donations had been received from several unions, including RMT and ASLEF.

10.7 EC members discussed the strike action and fully supported the campaign.

10.8 Bro. Linn proposed a £5000 contribution to the camaign, this was seconded by Bro. Lawrence.

10.9 EC members agreed to contribute £5000 from GFTU fund.

11.

Union Building Conference.

11.1 Bro. Nicholls discussed the upcoming Union Building Conference taking place at Yarnfield February 2018 and suggested that Committee members should arrange a meeting to discuss theme/ideas. 80 -100 attendee’s would be needed to make the event a success.

11.2 Sis. Pattison suggested the involvement of the new EC younger members.

12.

Any other Business.

12.1 Bro. Nicholls reported that Bro. Linn had arranged a trainer to provide a course on New Data Protection legislation which is to be held in Quorn March/April 2018. There will be a small fee for affiliated unions.

12.2 Bro. Lawrence reported that the Birmingham bin workers court battle had been won by Unite in the High Court’s yesterday.

12.3 EC members agreed to send a message of support.

12.4 Bro. Lawrence also reported that social workers and probation officers workers had received threats in the Northern Ireland region.

5

EC Minutes September 20 2017

12.5 EC members agreed to send message of support.

12.6 Bro. Elliott discussed shared services and shared premises issues that had been previously discussed in EC meetings.

12.7 Bro. Nicholls agreed to add both items to the Union Building Conference agenda.

Meeting closed 2.30pm

6

EXECUTIVE COMMITTEE EXPENSES CLAIM FORM

Payments will be made upon submission of receipts

Meeting Attended:__________________________________________

Name: ______________ Date: ________________ EXPENSES

AMOUNTS(£.p)

Overnight Accommodation (max £130.00)

Rail Fare (Members are encouraged to book in advance. No first class travel can be authorised)

Other Expenses (please give details)

Mileage (personal car usage at 45p per mile)

Total Miles From_Worcester To Stone To_Worcester_From_Stone Fixed Expense Allowances (for attendance at the EC for its duration)

£35.00

TOTAL CLAIM

£

Claimant Signature :

Date :__________________

General Secretary’s Authorisation :___________________________ Date :___________

Please complete and submit to the General Secretary with all receipts during the meeting attended or post to the GFTU, 84 Wood Lane, Leicestershire, LE12 8DB

Claims must be submitted with the financial year (January – December) of the meeting attended and ideally within 30 days of the meeting. Doug Nicholls, General Secretary.

For first time claimant please provide bank details for bac payment or address for cheque. For Bank transfer and Bac payment For Cheque payment Account holder name: Cheque made payable to:

Account number:

Address:

Sort code:

Contact email:

_

_

*Payment will be processed in the next end of the month payment run as soon as it is authorised.

1

Page:

Date: 18/10/2017

Quorn Grange Hotel

Time: 10:46

Profit & Loss by Department (Advanced Budget and Variance)

All

Period From:

2017 Month 9, September Year:

Department:

Period To:

Month 9, September

Chart of Accounts: Detailed Layout of Accounts

Actual

Budget

Variance

Sales Food & Beverages Miscellaneous Sales

34,086.85 1,518.32 62,533.38 3,638.33 37,401.50

11,104.45 1,018.32 5,077.38 (1,861.67) (7,598.50) (2,500.00)

22,982.40

500.00

Accomodation Conferences

57,456.00 5,500.00 45,000.00 2,500.00 5,745.60 2,600.00

Weddings

Hotel Events

0.00

Breakfast Sales Nursery Meals Gym Membership

5,919.51 1,752.85

173.91

(847.15) (329.87) (37.88)

370.13

700.00

Bank Interest Kurdish Event

12.12 33.33

50.00

33.33

0.00

147,266.32

143,034.00

4,232.32

Purchases Food & Beverages Purchases Miscellaneous Purchases

20,000.91

5,187.33

25,188.24

0.00

100.00

100.00

Function Purchases

2,347.48 1,234.42 6,023.02

(2,347.48) (1,234.42) (6,023.02)

0.00 0.00 0.00

Hotel Room Consumables

Movement in Stock

29,605.83

25,288.24

(4,317.59)

Direct Expenses Operating Gross Wages

38,839.49

18,374.11

57,213.60 1,430.34

Operating Employer Pension

511.18

919.16

Admin Gross Wages

16,804.69

(16,804.69)

0.00 0.00 0.00

Agency Staff

766.72 269.29

(766.72) (269.29)

Admin Employers Pension

57,191.37

58,643.94

1,452.57

Gross Profit (Loss):

60,469.12

59,101.82

1,367.30

Overheads Bar & Restaurant Consumables Cleaning & Laundry

163.40

(163.40)

0.00

6,198.01 (6,531.46) 3,294.17

696.71

6,894.72

Events

7,246.63 2,427.19

715.17

Marketing

5,721.36

Recruitment Advertising

0.00

60.00

60.00

IT Expenses

4,508.45 2,376.95

(3,508.45) (1,726.95)

1,000.00

Printing & Stationery

650.00

Postage

118.00

(83.00) (935.23)

35.00

Garden Expenditure Gym Expenditure Repairs & Maintenance

4,007.23

3,072.00

70.10

79.90

150.00

4,094.63 2,550.59 (40.76)

(2,083.67)

2,010.96 2,298.24

Kitchen Repairs & Maintenance Uniforms

(252.35)

240.76

200.00 350.00

Licences

266.10

83.90

Commissions

3,606.77

(1,308.53)

2,298.24

2

Page:

Date: 18/10/2017

Quorn Grange Hotel

Time: 10:46

Profit & Loss by Department (Advanced Budget and Variance)

All

Period From:

2017 Month 9, September Year:

Department:

Period To:

Month 9, September

Chart of Accounts: Detailed Layout of Accounts

Actual

Budget 6,436.53 8,582.04

Variance

Rates and Insurance Heat, Light and Power

5,874.53 5,050.66

562.00

3,531.38

Unpaid Bills Staff Drinks

0.00

30.00 22.50

30.00 75.00 50.00

52.50

Travel Expenses

329.80 222.12

(279.80)

Management Allowances Hotels & Subsistence Telephone & Internet

177.88

400.00

0.00

50.00

50.00

(1,135.17)

1,735.17

600.00 750.00 250.00 600.00

Professional Fees

225.00 170.77 519.45

525.00

Flowers & Xmas Decorations

79.23 80.55 85.00

Waste Management

Pest Control

0.00

85.00

Card Processing Charges

1,165.39 6,485.51

(165.39) (485.51)

1,000.00 6,000.00

Depreciation

Staff Training & Support

0.00

175.00

175.00 550.00

TV Subscriptions

716.93

(166.93)

Gifts

0.00

10.00

10.00

Donations

4,000.00 2,211.33

(4,000.00)

0.00

GFTU Salary Contribution

138.67 390.15

2,350.00

Directors Expenses

59.85

450.00

Bank Charges Till Variances

233.33

(233.33) (65.87)

0.00

85.87

20.00

50,950.05

53,919.26

2,969.21

Net Profit (Loss):

5,182.56

4,336.51

9,519.07

1

Page:

Date: 18/10/2017

Quorn Grange Hotel

Time: 10:46

Profit & Loss by Department (Advanced Budget and Variance)

All

Period From:

2017 Month 9, September Year:

Department:

Period To:

Month 9, September

Chart of Accounts: Detailed Layout of Accounts

Actual

Budget

Variance

Sales Food & Beverages Miscellaneous Sales

34,086.85 1,518.32 62,533.38 3,638.33 37,401.50

11,104.45 1,018.32 5,077.38 (1,861.67) (7,598.50) (2,500.00)

22,982.40

500.00

Accomodation Conferences

57,456.00 5,500.00 45,000.00 2,500.00 5,745.60 2,600.00

Weddings

Hotel Events

0.00

Breakfast Sales Nursery Meals Gym Membership

5,919.51 1,752.85

173.91

(847.15) (329.87) (37.88)

370.13

700.00

Bank Interest Kurdish Event

12.12 33.33

50.00

33.33

0.00

147,266.32

143,034.00

4,232.32

Purchases Food & Beverages Purchases Miscellaneous Purchases

20,000.91

5,187.33

25,188.24

0.00

100.00

100.00

Function Purchases

2,347.48 1,234.42 6,023.02

(2,347.48) (1,234.42) (6,023.02)

0.00 0.00 0.00

Hotel Room Consumables

Movement in Stock

29,605.83

25,288.24

(4,317.59)

Direct Expenses Operating Gross Wages

38,839.49

18,374.11

57,213.60 1,430.34

Operating Employer Pension

511.18

919.16

Admin Gross Wages

16,804.69

(16,804.69)

0.00 0.00 0.00

Agency Staff

766.72 269.29

(766.72) (269.29)

Admin Employers Pension

57,191.37

58,643.94

1,452.57

Gross Profit (Loss):

60,469.12

59,101.82

1,367.30

Overheads Bar & Restaurant Consumables Cleaning & Laundry

163.40

(163.40)

0.00

6,198.01 (6,531.46) 3,294.17

696.71

6,894.72

Events

7,246.63 2,427.19

715.17

Marketing

5,721.36

Recruitment Advertising

0.00

60.00

60.00

IT Expenses

4,508.45 2,376.95

(3,508.45) (1,726.95)

1,000.00

Printing & Stationery

650.00

Postage

118.00

(83.00) (935.23)

35.00

Garden Expenditure Gym Expenditure Repairs & Maintenance

4,007.23

3,072.00

70.10

79.90

150.00

4,094.63 2,550.59 (40.76)

(2,083.67)

2,010.96 2,298.24

Kitchen Repairs & Maintenance Uniforms

(252.35)

240.76

200.00 350.00

Licences

266.10

83.90

Commissions

3,606.77

(1,308.53)

2,298.24

2

Page:

Date: 18/10/2017

Quorn Grange Hotel

Time: 10:46

Profit & Loss by Department (Advanced Budget and Variance)

All

Period From:

2017 Month 9, September Year:

Department:

Period To:

Month 9, September

Chart of Accounts: Detailed Layout of Accounts

Actual

Budget 6,436.53 8,582.04

Variance

Rates and Insurance Heat, Light and Power

5,874.53 5,050.66

562.00

3,531.38

Unpaid Bills Staff Drinks

0.00

30.00 22.50

30.00 75.00 50.00

52.50

Travel Expenses

329.80 222.12

(279.80)

Management Allowances Hotels & Subsistence Telephone & Internet

177.88

400.00

0.00

50.00

50.00

(1,135.17)

1,735.17

600.00 750.00 250.00 600.00

Professional Fees

225.00 170.77 519.45

525.00

Flowers & Xmas Decorations

79.23 80.55 85.00

Waste Management

Pest Control

0.00

85.00

Card Processing Charges

1,165.39 6,485.51

(165.39) (485.51)

1,000.00 6,000.00

Depreciation

Staff Training & Support

0.00

175.00

175.00 550.00

TV Subscriptions

716.93

(166.93)

Gifts

0.00

10.00

10.00

Donations

4,000.00 2,211.33

(4,000.00)

0.00

GFTU Salary Contribution

138.67 390.15

2,350.00

Directors Expenses

59.85

450.00

Bank Charges Till Variances

233.33

(233.33) (65.87)

0.00

85.87

20.00

50,950.05

53,919.26

2,969.21

Net Profit (Loss):

5,182.56

4,336.51

9,519.07

QUORN GRANGE HOTEL FINANCIAL OVERVIEW (Jan 17 to Dec 17)

HOTEL SALES 2014-2017

January 75,891 71,508 65,457 69,680

February

March 99,170 101,137 104,534 86,334

April

May

June

July August September

Totals

2014 2015 2016 2017

75,521 83,912 78,246 88,225

92,463 90,480 87,556 130,696

117,353 112,281 127,392 116,905 87,970 904,946 144,565 125,722 93,968 148,952 142,374 1,002,618 112,411 104,985 124,536 115,457 122,170 915,352 128,433 130,683 155,763 146,436 147,266 1,083,516

HOTEL NET PROFIT/(LOSS) PRIOR YEAR COMPARISONS 2014-17 January February March

April 6,875

May

June

July August September

Totals 70,330 67,484

2014 2015 2016 2017

(7,522) (20,621) (50,664) (51,566)

(13,452) (7,539) (27,882) (32,308)

2,999 7,896

22,940 19,123 23,347 18,510

(2,490)

(3,918) (23,395) (2,221)

37,149 18,504

(14,559)

30,546 20,027

(14,172) (25,000)

(6,470) (2,149)

(14,549) (16,489) (6,215) (3,286)

11,036

(6,698)

(149,282) (111,159)

2,066

9,519

HOTEL BUDGET v ACTUAL NET PROFIT/(LOSS) 2017 January February

March 8,465

April 3,863

May

June

July August September

Totals 4,157

2017 BUDGET 2017 ACTUAL

(22,552) (51,566) (29,014)

(14,339) (32,308) (17,969)

6,874

3,631 6,079 6,953

5,183 9,519 4,337

(25,000) (33,465)

(2,221) (6,084)

(2,149) (9,023)

(6,215) (9,846)

(3,286) (9,365)

2,066

(111,160) (115,317)

(4,887)

Variance

YTD OVERALL PRIOR YEAR ANALYSIS HOTEL NET PROFIT/(LOSS) 2014 2015 2016

2017

Hotel

70,329.70

67,484.26

(149,281.76)

(111,159.42)

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

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

1,341,316.29 1,244,829.20 1,083,516.26 161,312.94

Variance

-

25,096.32

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,149)

(6,215)

(3,286)

2,066

9,519

0

0

0

(111,160)

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 123,229

Variance

29,014

17,969

33,465

6,084

9,023

9,846

9,365

4,887

(4,337)

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 146,436 (1,607)

143,034 147,266

118,166

104,256

117,069

1,431,107 1,083,516 (347,591)

0

0

0

Variance

(11,693)

331

9,506

4,232 (118,166)

(104,256)

(117,069)

2017 Hotel Sales vs Budget

180,000

160,000

0 0 1,083,516 (347,591)

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

Quorn Grange Day Nursery Ltd

Date: 08/11/2017 Time: 13:42:42

Page: 1

Profit and Loss (Monthly Breakdown)

From: Month 1, January 2017 To: Month 10, October 2017 Chart of Accounts:

Detailed Accounts

Jan

Feb

Mar

Apr

May

Jun

Jul

Aug

Sep

Oct

Totals

Sales Nursery Fee Income

20,624.11

20,621.33

20,617.97

22,889.55 25,463.47 25,174.00 26,305.23 29,283.79 22,140.45 23,165.11 236,285.01

Event Income

0.00

0.00

0.00

0.00

0.00

0.00

0.00

362.69

0.00

0.00

362.69

Other Income

0.00 30.67 20,624.11 20,621.33 20,617.97 22,889.55 25,463.47 25,174.00 26,305.23 29,653.15 22,140.45 23,189.11 236,678.37 0.00 0.00 0.00 0.00 0.00 0.00 6.67 0.00 24.00

Purchases

Interco-Nursery Meals Food Purchases third party Food Supplies

1,548.75

1,630.00

2,356.07

2,092.59 3,187.52 1,711.00 2,382.36 2,206.70 1,752.85 2,143.84 21,011.68

375.04

255.96

392.57

483.13

411.18

303.85

397.03

297.09

411.85

424.18 3,751.88

29.65 305.87 2,027.28 1,951.73 2,778.29 2,682.68 3,598.70 2,014.85 2,779.39 2,503.79 2,164.70 2,568.02 25,069.43 65.77 103.49 106.96 0.00 0.00 0.00 0.00 0.00 0.00

Direct Expenses Wages & Salaries

14,760.23

14,614.86

13,150.94

15,362.44 14,354.64 14,361.25 14,486.13 12,482.63 13,062.74 13,935.98 140,571.84

Employers Pension

331.42

283.10

247.06

255.93

225.87

227.77

227.77

224.06

227.77

222.82 2,473.57

Uniforms

0.00

0.00

0.00

46.27

0.00

134.46

0.00

0.00

0.00

0.00

180.73

Sessional Pay

0.00 39.65 15,091.65 14,897.96 13,398.00 15,704.29 14,580.51 14,723.48 14,713.90 12,706.69 13,290.51 14,158.80 143,265.79 3,505.18 3,771.64 4,441.68 4,502.58 7,284.26 8,435.67 8,811.94 14,442.67 6,685.24 6,462.29 68,343.15 0.00 0.00 39.65 0.00 0.00 0.00 0.00 0.00 0.00

Gross Profit/(Loss) Overheads Cleaning & Laundry

0.00

126.10

114.63

121.18

103.44

287.78

233.70

0.00

205.44

0.00 1,192.27

Advertising & Marketing Stationery

0.00

22.00

17.60

13.20

0.00

30.00

13.80

13.80

241.80

13.80

366.00

440.81

392.46

908.57

387.22

489.96

383.25

287.92

222.03

224.27

287.91 4,024.40

Quorn Grange Day Nursery Ltd

Date: 08/11/2017 Time: 13:42:42

Page: 2

Profit and Loss (Monthly Breakdown)

From: Month 1, January 2017 To: Month 10, October 2017 Chart of Accounts:

Detailed Accounts

Jan

Feb

Mar

Apr

May

Jun

Jul

Aug

Sep

Oct

Totals

Postage

0.00

0.00

3.84

8.34

8.34

0.00

8.34

8.34

0.00

8.34

45.54

Repairs & Maintenance Water Rates

0.00

111.92

22.38

0.00

174.58

403.24

65.00

68.58

30.66

221.50 1,097.86

0.00

149.66

50.00

50.00

50.00

332.87

50.00

50.00

162.20

50.00

944.73

Rates & Insurance

400.00

400.00

400.00

400.00

400.00

400.00

400.00

400.00

400.00 (740.09)

2,859.91

Creative Supplies

(84.09)

16.67

1,075.86

104.53

0.00

22.75

274.74

0.00

162.47

48.01 1,620.94

Electricity & Gas

350.00

(230.08)

350.00

350.00

350.00

350.00

350.00

350.00

350.00

350.00 2,919.92

Professional Fees

0.00

0.00

595.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

595.00

Waste Management

198.51

189.54

391.97

280.26

488.10

333.36

228.13

249.49

260.40

256.86 2,876.62

Pest Control

38.00

(45.60)

7.60

45.60

0.00

0.00

45.60

0.00

0.00

45.60

136.80

Staff Training

0.00

0.00

0.00

0.00

265.80 1,200.00

0.00

0.00

0.00

0.00 1,465.80

Garden Expenses

0.00

0.00

0.00

0.00

0.00

0.00

0.00

144.00

0.00

0.00

144.00

Travel Expenses

0.00

0.00

12.40

29.75

27.60

0.00

0.00

0.00

0.00

10.00

79.75

IT Charges

0.00

0.00

0.00

0.00

0.00

234.92

392.70

595.56

446.47

131.78 1,801.43

GFTU Salary contribution Depreciation

0.00

0.00

5,400.00

1,800.00 1,800.00 1,800.00 1,800.00 1,800.00 1,800.00 1,800.00 18,000.00

179.40

179.40

179.40

179.40

179.40

179.40

179.40

179.40

179.40

179.40 1,794.00

Subscriptions & Donations Suspense account

0.00

0.00

12,000.00

4,000.00 4,000.00 4,000.00 4,082.00 4,000.00 4,000.00 4,000.00 40,082.00

151.80

447.63

(203.33)

(77.00)

95.00

233.50

420.30 (1,067.90)

0.00

0.00

0.00

Miscellaneous Expenses

244.80

114.60

103.89

131.41

0.00

0.00

0.00

14.19

15.01

177.00

800.90

Internet & Software Support

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

421.34

0.00

421.34

Quorn Grange Day Nursery Ltd

Date: 08/11/2017 Time: 13:42:42

Page: 3

Profit and Loss (Monthly Breakdown)

From: Month 1, January 2017 To: Month 10, October 2017 Chart of Accounts:

Detailed Accounts

Jan

Feb

Mar

Apr

May

Jun

Jul

Aug

Sep

Oct

Totals

Softwear Subscriptions

0.00 756.00 1,919.23 1,874.30 21,429.81 7,823.89 8,432.22 10,515.07 8,939.63 7,135.49 9,007.46 6,948.11 84,025.21 0.00 0.00 0.00 0.00 324.00 108.00 108.00 108.00 108.00

Net Profit/(Loss)

1,585.95 1,897.34 (16,988.13 (3,321.31) (1,147.96) (2,079.40) (127.69) 7,307.18 (2,322.22) (485.82) (15,682.06

1

Page:

Date: 08/11/2017

Quorn Grange Day Nursery Ltd

Time: 13:41

Profit & Loss by Department (Advanced Budget and Variance)

All

Period From:

Month 10, October Month 10, October

Year:

2017

Department:

Period To:

Chart of Accounts: Detailed Accounts

Actual

Budget

Variance

Sales Nursery Fee Income

23,165.11

2,787.61

20,377.50

Other Income

24.00

24.00

0.00

23,189.11

20,377.50

2,811.61

Purchases Interco-Nursery Meals

2,143.84

430.16

2,574.00

Food Purchases third party

424.18

(424.18)

0.00

2,568.02

2,574.00

5.98

Direct Expenses Wages & Salaries Employers Pension

13,935.98

(180.98) (222.82)

13,755.00

222.82

0.00

14,158.80

13,755.00

(403.80)

Gross Profit (Loss):

6,462.29

4,048.50

2,413.79

Overheads Advertising & Marketing

13.80

436.20

450.00

Stationery

287.91

(287.91)

0.00

Postage

8.34

341.66

350.00

Repairs & Maintenance

221.50

(221.50)

0.00

Water Rates

50.00

0.00

50.00

Rates & Insurance Creative Supplies Electricity & Gas Waste Management

(740.09)

1,240.09 (48.01) 150.00 343.14 104.40 200.00 (10.00) 218.22 200.00

500.00

48.01

0.00

350.00 256.86

500.00 600.00 150.00 200.00

Pest Control Staff Training Travel Expenses

45.60

0.00

10.00

0.00

IT Charges Audit Fees

131.78

350.00 200.00

0.00

GFTU Salary contribution

1,800.00

(1,800.00)

0.00

Depreciation

179.40

(29.40)

150.00 100.00

Subscriptions & Donations Miscellaneous Expenses Softwear Subscriptions

4,000.00

(3,900.00)

177.00 108.00

(177.00) (58.00)

0.00

50.00

6,948.11

3,650.00

(3,298.11)

Net Profit (Loss):

398.50

(884.32)

(485.82)

1

Page:

Date: 08/11/2017

Quorn Grange Day Nursery Ltd

Time: 13:40

Profit & Loss by Department (Advanced Budget and Variance)

All

Period From:

Month 1, January Month 10, October

Year:

2017

Department:

Period To:

Chart of Accounts: Detailed Accounts

Actual

Budget

Variance

Sales Nursery Fee Income

236,285.01

15,861.01

220,424.00

Event Income Other Income

362.69

362.69

0.00 0.00

30.67

30.67

236,678.37

220,424.00

16,254.37

Purchases Interco-Nursery Meals

21,011.68 3,751.88

6,987.32

27,999.00

Food Purchases third party

(3,751.88)

0.00 0.00

Food Supplies

305.87

(305.87)

25,069.43

27,999.00

2,929.57

Direct Expenses Wages & Salaries Employers Pension

140,571.84

(3,021.84) (2,473.57)

137,550.00

2,473.57

0.00 0.00 0.00

Uniforms

180.73

(180.73) (39.65)

Sessional Pay

39.65

143,265.79

137,550.00

(5,715.79)

Gross Profit (Loss):

68,343.15

54,875.00

13,468.15

Overheads Cleaning & Laundry

1,192.27

(1,192.27)

0.00

Advertising & Marketing

366.00

4,134.00

4,500.00

Stationery

4,024.40

(4,024.40)

0.00

Postage

45.54

3,454.46

3,500.00

Repairs & Maintenance

1,097.86

(1,097.86) (444.73) 2,140.09 (1,620.94) 2,080.08 (595.00) 3,123.38 1,363.20 (144.00) (79.75) 1,698.57 2,000.00 (18,000.00) 534.20

0.00

Water Rates

944.73

500.00

Rates & Insurance Creative Supplies Electricity & Gas Professional Fees Waste Management

2,859.91 1,620.94 2,919.92

5,000.00

0.00

5,000.00

595.00

0.00

2,876.62

6,000.00 1,500.00 2,000.00

Pest Control Staff Training

136.80

1,465.80

Garden Expenses Travel Expenses

144.00

0.00 0.00

79.75

IT Charges Audit Fees

1,801.43

3,500.00 2,000.00

0.00

GFTU Salary contribution

18,000.00 1,794.00 40,082.00

0.00

Depreciation

(294.00)

1,500.00 1,000.00

Subscriptions & Donations Miscellaneous Expenses Internet & Software Support

(39,082.00)

800.90 421.34 756.00

(800.90) (421.34) (256.00)

0.00 0.00

Softwear Subscriptions

500.00

84,025.21

36,500.00

(47,525.21)

2

Page:

Date: 08/11/2017

Quorn Grange Day Nursery Ltd

Time: 13:40

Profit & Loss by Department (Advanced Budget and Variance)

All

Period From:

Month 1, January Month 10, October

Year:

2017

Department:

Period To:

Chart of Accounts: Detailed Accounts

Actual

Budget

Variance

Net Profit (Loss):

18,375.00

(34,057.06)

(15,682.06)

QUORN GRANGE DAY NURSERY SUMMARY

Oct-17 Nursery

YTD Oct 17

YTD Sep 17

Nursery

Nursery

£

£

£

Net Profit/(loss)

(486)

(15,682)

(15,196)

Adjust for Expenses not budgeted: Gift Aid GFTU

4,000 1,800 5,314

40,000 18,000 42,318 18,375

36,000 16,200 36,948

GFTU Salary Contribution Trading Profit/(Loss) Budgeted Profit/(loss)

399

17,977

QUORN GRANGE DAY NURSERY MANAGEMENT ACCOUNTS BALANCE SIEET REVIEW

Nursery

Nursery

Nursery

Nursery

Nursery

Nursery Nursery Nursery Nursery Nursery

BALANCE SIEET

As at

As at

As at

As at

As at

As at

As at

As at

As at

As at

31-Oct-17 30-Sep-17 31-Aug-17 31-Jul-17

30-Jun-17 31-May-17 30-Apr-17 31-Mar-17 28-Feb-17 31-Jan-17

Fixed Assets Furniture and Fixtures

9,135 9,135

9,315 9,315

9,494 9,494

9,674 9,674

9,853 10,032 9,853 10,032

10,212 10,391 10,751 10,750 10,212 10,391 10,751 10,750

Total Fixed Assets

Current Assets Debtors

21,072

28,045

35,506

31,676

32,424 33,517

30,974 30,613 32,640 28,539

Other Debtors GFTU

5,000 1,385

5,000

5,000

5,000

5,000

5,000

5,000

5,000

5,000

5,000

Prepayments & Accrued Income LCC

(9,303) 90,038 13,090

(18,605)

(27,908)

(8,876)

(8,739)

(17,721)

0 (5,117)

(10,235)

Due to/ from Hotel & Nursery

81,313 18,976

98,613

92,339 17,628

89,673 87,466

96,483 79,271 94,392 101,310

Bank

1,471 1,676

0 0

0 0

0 0

0 0

0 0

0 0

Cash at Bank

0

0

0

Petty Cash

150

150

150

150

150

150

150

150

150

150

Total Current Assets

127,896

127,021

123,810

118,885

118,371 117,394 114,886 115,034 127,065 124,764

Current Liabilities Trade Creditors

7,030 1,250

2,725 1,250

937

5,151 1,250

7,669 1,250 9,000 3,329

7,042 1,250 7,500 2,652

5,173 1,250 6,000 2,919

3,896 1,250 4,500 2,475

3,515 1,250

3,463 1,250

Accruals

1,250

Other Creditors due to GFTU gift Aid

12,000

16,000

12,000

10,500

0

0

PAYE, NIC & Pension Payable

5,624

4,804

4,807

4,917

2,947

2,407

Total Current Liabilities

(25,904)

(24,779)

(18,994)

(21,818)

(21,247) (18,444)

(15,341)

(12,121)

(7,712)

(7,119)

Creditors due > 1 Year Intercompany Loans

0

0

0

0

0

0

0

0

0

0

Net Assets

111,127

111,557

114,310

106,741

106,976 108,982 109,756 113,303 130,291 128,394

Capital & Reserves Reserves b/fwd Charge for period

126,809 (15,682) 111,127

126,809 (15,252) 111,557

126,809 (12,499) 114,310

126,809 (20,068) 106,741

126,809 126,809 126,809 126,809 126,809 126,809

(19,833)

(17,827)

(17,052)

(13,505)

3,483

1,586

106,976 108,982 109,757 113,304 130,292 128,395

Nursery Budget 2017

Jan

Feb

Mar

Apr

Income Fees- including grant

20,000.00

20,000.00

21,000.00

21,000.00

Total

20,000.00

20,000.00

21,000.00

21,000.00

Expenses Staffing

15,000.00 1,500.00

15,000.00 1,500.00

15,000.00 1,500.00

15,000.00 1,200.00

Meals Food

150.00 150.00 250.00 250.00

150.00 150.00 250.00 250.00

150.00 150.00 250.00 250.00

150.00 150.00 250.00 250.00

Petty cash

Utilities: Gas

Utilities: Electricity

Utilities: Water

50.00 50.00

50.00 50.00

50.00 50.00

50.00 50.00

Telephone

Maintenance

100.00 100.00 100.00

100.00 100.00 100.00

Printing

Stationery Art supplies

50.00 80.00

50.00 50.00

50.00

Technology: Softwear Marketing: New Brochure

50.00 38.00

Pest control

38.00 50.00

38.00 50.00

Cleaning Supplies Waste Management

100.00 200.00 150.00 500.00 200.00 150.00 250.00 100.00 200.00

100.00 200.00 150.00 500.00 200.00 150.00 250.00 100.00 200.00

200.00 150.00 500.00 200.00 150.00 250.00 100.00 200.00

200.00 150.00 500.00 200.00 150.00 250.00 100.00 200.00

IT expenses

Business Rates & Insurance

Professional Fees

Depreciation

Technology: Nursery Management Software Marketing: Website

Health and Safety / First Aid

Staff Training GFTU Gift Aid

4,000.00 1,800.00

4,000.00 1,800.00

4,000.00 1,800.00

4,000.00 1,800.00

GFTU salary contribution

Total

25,488.00

25,168.00

25,350.00

24,838.00

Net profit/loss

-

5,488.00

5,168.00 -

4,350.00 -

3,838.00 -

May

Jun

Jul

Aug

Sept

Oct

Nov

21,000.00

21,000.00

19,000.00

18,000.00

19,000.00

19,000.00

20,000.00

21,000.00

21,000.00

19,000.00

18,000.00

19,000.00

19,000.00

20,000.00

15,000.00 1,500.00

15,000.00 1,500.00

15,000.00 1,200.00

15,000.00

15,000.00

15,000.00 1,000.00

15,000.00 1,100.00

900.00 150.00 150.00 250.00 250.00

900.00 150.00 150.00 250.00 250.00

150.00 150.00 250.00 250.00

150.00 150.00 250.00 250.00

150.00 150.00 250.00 250.00

150.00 150.00 250.00 250.00

150.00 150.00 250.00 250.00

50.00 50.00

50.00 50.00

50.00 50.00

50.00 50.00

50.00 50.00

50.00 50.00

50.00 50.00

100.00 100.00 100.00

100.00 100.00 100.00

100.00 100.00 100.00

100.00 100.00 100.00 100.00

50.00 80.00

50.00

50.00

50.00

800.00

100.00

100.00

50.00 38.00

38.00 50.00

38.00

38.00

38.00 50.00

100.00 200.00 150.00 500.00 200.00 150.00 100.00 250.00 100.00 200.00

100.00 200.00 150.00 500.00 200.00 150.00 100.00 250.00 100.00 200.00

50.00

100.00 200.00 150.00 500.00 200.00 150.00 100.00 250.00 100.00 200.00

100.00 200.00 150.00 500.00 200.00 150.00 100.00 250.00 100.00 200.00

200.00 150.00 500.00 200.00 150.00 100.00 250.00 100.00 200.00

200.00 150.00 500.00 200.00 150.00 100.00 250.00 100.00 200.00

200.00 150.00 500.00 200.00 150.00 100.00 250.00 100.00 200.00

4,000.00 1,800.00

4,000.00 1,800.00

4,000.00 1,800.00

4,000.00 1,800.00

4,000.00 1,800.00

4,000.00 1,800.00

4,000.00 1,800.00

25,450.00

26,068.00

25,288.00

24,650.00

24,938.00

24,688.00

25,238.00

4,450.00 -

5,068.00 -

6,288.00 -

6,650.00 -

5,938.00 -

5,688.00 -

5,238.00 -

Made with FlippingBook - Online Brochure Maker