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