Profit & Loss
Waterside Community Trust
For the month ended
31
August
2020
Aug-20
YTD
Income
Beach Lifeguard Net income/(cost)
(705)
(2,233)
Courses
-
2,464
Individual entry
5,305
22,763
Memberships
5,330
32,001
Other Income
-
540
Pool Hire
1,242
6,991
Pool Parties
-
2,902
Shop and Food Contributions
291
1,068
Splashpark - Net income (cost)
-
(462)
Swimming Lessons
-
47,919
Waterworkout
-
2,272
Total Income
11,463
116,224
Less Cost of Sales
Cleaning
511
3,708
Cost of Badges and certificates (2320)
-
663
Course costs
-
1,451
Pool Chemicals
-
3,473
Repairs
593
11,811
Staffing costs
8,689
97,113
Utilities
3,475
26,346
Total Cost of Sales
13,268
144,564
Gross Profit
(1,806)
(28,340)
Plus Other Income
Cafe Income and recharges
1,291
9,144
Fundraising and Donations
162
7,513
Grants
1,667
25,000
Other income and interest
588
1,956
Total Other Income
3,708
43,613
Less Operating Expenses
Advertising and Marketing
-
776
Communications and IT
506
3,420
Insurance
710
6,388
Interest and bank charges
27
1,786
Licences, legal and HR
418
5,392
Office and administration costs
1,292
3,524
Travel and sundry expenses
112
5,643
Facility management
Facility management
1,603
14,427
Total Facility management
1,603
14,427
Total Operating Expenses
4,667
41,356
Profit & Loss | Waterside Community Trust | 10 September 2020
Page 1 of 2
Profit & Loss
Aug-20
YTD
Net Profit
(2,765)
(26,083)
Profit & Loss | Waterside Community Trust | 10 September 2020
Page 2 of 2
Income and Expenditure Report
Waterside Community Trust
For the 9 months ended
31
August 2020
REMAINING
BUDGET FOR
YEAR TO DATE
FORECAST
VARIANCE
BUDGET
YEAR
Income
Membership
Adult 1 year membership
9,792
2,166
11,958
-
11,958
Adult 6 month membership
6,658
3,357
10,015
-
10,015
Adult one month membership
13,462
6,867
20,329
-
20,329
Membership card
1,708
922
2,630
-
2,630
Junior memberships
381
71
452
-
452
Total Membership
32,001
13,383
45,384
-
45,384
Individual entry
Adult swim
11,321
5,948
17,269
-
17,269
Adult concessionary swim
1,200
641
1,841
-
1,841
Shower and sauna
387
205
592
-
592
Child fun swim
1,408
-
1,408
-
1,408
Child swim
2,077
-
2,077
-
2,077
Family swim
5,558
-
5,558
-
5,558
Island Resident swim
813
640
1,453
-
1,453
Total Individual entry
22,763
7,434
30,197
-
30,197
Swimming Lessons
Adult swimming lessons
1,123
473
1,596
-
1,596
Group child swimming lessons
35,692
20,973
56,665
-
56,665
Private swimming lessons
3,965
1,746
5,711
-
5,711
School swimming lessons
7,140
3,175
10,315
-
10,315
Badges and certificates (1630)
540
453
993
-
993
Cost of Badges and certificates (2320)
(663)
(537)
(1,200)
-
(1,200)
Total Swimming Lessons
47,797
26,283
74,080
-
74,080
Courses
Lifeguarding Courses
2,464
1,166
3,630
-
3,630
Swimming Teacher Courses
-
6
6
-
6
Lifeguard course costs
(1,451)
(534)
(1,985)
-
(1,985)
Swim teacher course
-
(249)
(249)
-
(249)
Profit on courses
1,013
389
1,402
-
1,402
Pool hire
Pool hire for private lessons
186
160
346
-
346
Ryde Cormorants
-
128
128
-
128
Ryde Swimming Club - Pool hire and coaching
2,042
1,305
3,347
-
3,347
Blind society pool hire
878
-
878
-
878
Casual pool hire
1,313
-
1,313
-
1,313
Large inflatable hire
720
1,411
2,131
-
2,131
Pool parties
2,902
496
3,398
-
3,398
Octopush pool hire
1,853
731
2,584
-
2,584
Forecast for the Year to 30th Nov 2020 ( AugCV) Waterside Community Trust
Income and Expenditure Report
REMAINING
BUDGET FOR
YEAR TO DATE
FORECAST
VARIANCE
BUDGET
YEAR
Water workout
2,272
1,466
3,738
-
3,738
Total Pool hire
12,164
5,697
17,861
-
17,861
Beach lifeguards
RTC - Beach Lifeguards
17,000
4,500
21,500
-
21,500
Beach lifeguard course
-
(99)
(99)
-
(99)
Beach lifeguard equipment, rib fuel and
(5,882)
(283)
(6,165)
-
(6,165)
depreciation
Beach lifeguard uniform
(95)
(117)
(212)
-
(212)
Beach lifeguards wages
(13,256)
(656)
(13,912)
-
(13,912)
Total Beach lifeguards
(2,233)
3,345
1,112
-
1,112
Splash Park
Splashpark electricity
(462)
-
(462)
-
(462)
Total Splash Park
(462)
-
(462)
-
(462)
Food and beverage
Food and beverage (1610)
1,753
857
2,610
-
2,610
Cost of sales - Food and beverage
(1,871)
(825)
(2,696)
-
(2,696)
Profit on Food and beverage
(118)
32
(86)
-
(86)
Shop sales
Zoggs products
3,801
1,580
5,381
-
5,381
COS - Shop
(2,615)
(1,188)
(3,803)
-
(3,803)
Profit on shop sales
1,186
392
1,578
-
1,578
Facility Income
114,110
56,955
171,065
-
171,065
Direct costs
Staffing costs
General manager (operational)
13,540
5,877
19,417
-
19,417
Accounts/adminstration
8,446
2,814
11,260
-
11,260
Aquafit instructors
1,703
-
1,703
-
1,703
Duty manager
19,105
10,620
29,725
-
29,725
Lifeguards
26,084
9,411
35,495
-
35,495
Pool helper
803
1,332
2,135
-
2,135
Receptionist
1,560
1,548
3,108
-
3,108
Swim teacher Grp
13,424
7,371
20,795
-
20,795
Swim teacher Pte
310
-
310
-
310
DBS checks
-
24
24
-
24
Maternity Pay
3,271
2,229
5,500
-
5,500
Nest pension contribution
3,237
1,533
4,770
-
4,770
Staff training
2,147
1,749
3,896
-
3,896
Staff uniforms
250
375
625
-
625
ER's NI
3,234
2,070
5,304
-
5,304
Total Staffing costs
97,113
46,953
144,066
-
144,066
Utilities and chemicals
Electricity
14,798
7,500
22,298
-
22,298
Gas
14,399
7,920
22,319
-
22,319
Water
(2,851)
2,400
(451)
-
(451)
Water testing
536
513
1,049
-
1,049
Forecast for the Year to 30th Nov 2020 ( AugCV) Waterside Community Trust
Income and Expenditure Report
REMAINING
BUDGET FOR
YEAR TO DATE
FORECAST
VARIANCE
BUDGET
YEAR
Pool chemicals
3,473
1,125
4,598
-
4,598
Total Utilities and chemicals
30,355
19,458
49,813
-
49,813
Repairs
Repairs - building
6,156
1,773
7,929
-
7,929
Repairs - changing room and poolside
4,132
3,000
7,132
-
7,132
Repairs - other
139
1,251
1,390
-
1,390
Repairs - plant room
847
2,001
2,848
-
2,848
Total Repairs
11,274
8,025
19,299
-
19,299
Cleaning and waste
Waste and recycling
2,025
1,188
3,213
-
3,213
Cleaning consumables and equipment
1,683
1,233
2,916
-
2,916
Contract cleaning
-
411
411
-
411
Total Cleaning and waste
3,708
2,832
6,540
-
6,540
Total Direct costs
142,450
77,268
219,718
-
219,718
Gross contribution
(28,340)
(20,313)
(48,653)
-
(48,653)
Administrative Costs
Facility mangement
Facility management
14,427
4,809
19,236
-
19,236
Total Facility mangement
14,427
4,809
19,236
-
19,236
Advertising and stationery
Advertising and marketing
776
300
1,076
-
1,076
Printing and stationery
1,354
150
1,504
-
1,504
Total Advertising and stationery
2,130
450
2,580
-
2,580
Insurance
Building and public liability insurance
6,388
2,115
8,503
-
8,503
Other insurance
-
30
30
-
30
Total Insurance
6,388
2,145
8,533
-
8,533
Communications and IT
Telephone and radio
293
75
368
-
368
Internet
623
60
683
-
683
Software and IT
2,505
876
3,381
-
3,381
Total Communications and IT
3,420
1,011
4,431
-
4,431
Legal professional and licenses
Legal and professional fees
-
150
150
-
150
HR and compliance costs
3,111
1,071
4,182
-
4,182
Licences and permits
2,281
-
2,281
-
2,281
Total Legal professional and licenses
5,392
1,221
6,613
-
6,613
Non pool repairs and maintenance
Non-pool repairs etc
-
42
42
-
42
Small equipment
1,315
300
1,615
-
1,615
Office equipment
855
150
1,005
-
1,005
Total Non pool repairs and maintenance
2,170
492
2,662
-
2,662
Forecast for the Year to 30th Nov 2020 ( AugCV) Waterside Community Trust
Income and Expenditure Report
REMAINING
BUDGET FOR
YEAR TO DATE
FORECAST
VARIANCE
BUDGET
YEAR
Bank charges
Bank charges
1,786
300
2,086
-
2,086
Banking and cash errors
(1,187)
(51)
(1,238)
-
(1,238)
Total Bank charges
599
249
848
-
848
Miscellaneous and travel
Miscellaneous expenses
5,562
474
6,036
-
6,036
Travel and subsistence
81
150
231
-
231
Total Miscellaneous and travel
5,643
624
6,267
-
6,267
Total Administrative Costs
40,169
11,001
51,170
-
51,170
Other Operating Income
Other Income
Cafe
Cafe - Rent
8,937
3,876
12,813
-
12,813
Cafe - recharged insurance
-
6
6
-
6
Cafe - recharged water
207
324
531
-
531
Total Cafe
9,144
4,206
13,350
-
13,350
Fundraising and donations
Donations
4,865
750
5,615
-
5,615
Gift aid
837
249
1,086
-
1,086
General Fundraising
-
249
249
-
249
Specific fundraising events
1,810
849
2,659
-
2,659
Midnight swim
-
126
126
-
126
Total Fundraising and donations
7,513
2,223
9,736
-
9,736
Grants
Other grants
10,000
426
10,426
-
10,426
RTC - Support Grant
15,000
5,001
20,001
-
20,001
Total Grants
25,000
5,427
30,427
-
30,427
Other income
Other income
545
750
1,295
-
1,295
Interest received
224
126
350
-
350
Total Other income
769
876
1,645
-
1,645
Total Other Income
42,426
12,732
55,158
-
55,158
Total Other Operating Income
42,426
12,732
55,158
-
55,158
Operating surplus/deficit
(26,083)
(18,582)
(44,665)
-
(44,665)
Surplus/deficit before taxation
(26,083)
(18,582)
(44,665)
-
(44,665)
Net surplus/deficit
(26,083)
(18,582)
(44,665)
-
(44,665)
Forecast for the Year to 30th Nov 2020 ( AugCV) Waterside Community Trust
Balance Sheet
Waterside Community Trust
As at 31
August
2020
31
Aug 2020
31 Aug 2019
Assets
Bank
Business Premium ME
139,202
150,346
Waterside Community Trust
1,069
9,248
Waterside Community Trust 3292
-
-
Total Bank
140,271
159,594
Current Assets
Accounts Receivable (6100)
8,992
11,270
Less Provision for Doubtful Debts (6110)
(1,384)
(1,384)
Direct Debits due
2,000
-
Float
630
275
Furlough Control Account
4,028
-
Prepayments (6200)
2,526
5,161
Stock - Badges
2,501
917
Stock - food and beverage
640
561
Stock - shop
1,639
1,039
Stock- Chemicals and cleaning mats.
1,747
4,078
Unbanked cash
916
4,458
Total Current Assets
24,235
26,375
Fixed Assets
Land and buildings - additions
17,674
16,524
Land and buildings - depreciation charge for year
(3,389)
(2,589)
Land and buildings b/fwd
7,508
7,508
Land and buildings depreciation - b/fwd
(7,508)
(7,508)
Plant and machinery - additions
55,956
32,021
Plant and machinery - depreciation charge for year
(13,472)
(5,799)
Plant and machinery b/fwd
6,776
6,776
Plant and machinery depreciation - b/fwd
(6,776)
(6,776)
Total Fixed Assets
56,769
40,157
Total Assets
221,276
226,126
Liabilities
Current Liabilities
Accounts Payable
9,520
28,570
Accruals
19,499
25,489
Barclaycard Control Account
825
309
Grants in advance
16,167
18,167
Grants received in advance
7,452
4,500
Memberships paid in advance
12,782
12,291
Nest pension control
1,309
200
Parking fees due to IWCC
2,030
-
Balance Sheet | Waterside Community Trust | 10 September 2020
Page 1 of 2
Balance Sheet
31 Aug 2020
31 Aug 2019
PAYE and NI payable
2,077
3,505
Payroll Control Account
62
7
Ryde Swimming Club - Control Account
8,538
8,610
Total Current Liabilities
80,261
101,647
Total Liabilities
80,261
101,647
Net Assets
141,015
124,479
Equity
Current Year Earnings
(26,083)
(11,873)
Donation Ryde Pool Limited
89,923
89,701
Replacement reserve
40,000
40,000
Restricted Funds
17,463
-
Retained Earnings
19,713
6,652
Total Equity
141,015
124,479
Balance Sheet | Waterside Community Trust | 10 September 2020
Page 2 of 2
Waterside Community Trust
Summary Cash Flow forecast 2020 - Apl 21
September October November December January
February
March
April
Total
Ryde Town Council - Balance Beach Lifeguard and Annual Running
20000
20000
August furlough claim
4164
4164
0
Budgetted loss/profit
5010
8658
7698
16827
6327
7327
7327
5327
64501
Cash flow
846
8658
7698
16827
6327
7327
7327
14673
40337
Bank balance b/fwd
140271
139425
130767
123069
106242
99915
92588
85261
171696
Bank balance c/fwd
139425
130767
123069
106242
99915
92588
85261
99934
131359
