Contract Variables — Per Employee
In short
The big table — every one of the 37 staff in scope, their template, their addendums, their pay, hours, and what data we're still missing for them. Use the filter at the top of the page to find specific people.
Source data: Employee Contract Info - Wild.csv (BrightHR export, run 14-May-26).
Purpose: confirm which contract template + addendums each person needs, and flag missing data that must be collected before drafts can be generated.
Note on pay figures. All "Pay (BrightHR)" values below are taken verbatim from BrightHR's Salary + Rate columns. They are not estimated or computed. If a figure looks wrong, the source record in BrightHR is what needs updating. The "Pay (contract phrasing)" column shows how that figure should appear in the contract itself, following UK convention for the relevant contract type.
How pay is normally stated by contract type
| Contract type |
UK convention |
What appears in the contract |
| Template A — Salaried employee (BrightHR Rate = "Monthly" or "Annually") |
Stated as annual gross salary, with the monthly payment date noted separately |
"£37,285 per annum, paid in 12 equal monthly instalments by BACS on the last working day of each month, less PAYE and NI" |
| Template A — Hourly employee (BrightHR Rate = "Hourly") |
Stated as hourly rate, with hours per week noted in the Hours clause |
"£14.39 per hour, paid monthly by BACS in arrears, less PAYE and NI" |
| Template B — Casual / zero-hours |
Always hourly rate + holiday pay accrual at 12.07% |
"£13.44 per hour, plus accrued holiday pay at 12.07% of hours worked" |
| Template C — Consultant |
Day rate, fixed fee per engagement, or monthly retainer — never an annual figure (would imply employment) |
"£175 per calendar month as a retainer for the services described in Schedule 1" |
For salaried staff in BrightHR's "Monthly" basis, the annual figure shown below is monthly × 12. For "Hourly" basis, the rate is shown as-is.
Classification + data completeness — 37 individuals
Placeholder slots excluded (rows 13 "Visiting Baker", 14 "Stage Baker", 35 "Temporary Driver" — these are role slots in BrightHR, not real people).
Bravo Nyamudoka excluded at user's request — his own contract is out of scope of this generation pass.
Legend:
- Tmpl — A (Employment) / B (Casual) / C (Consultancy)
- Tier — Std (standard) / Snr (senior, 2-month notice) / Dir (director, 6-month) / N/A (casual/consultant)
- Add'n — 1 Drivers / 2 Bakers / 3 Young Workers
- Pay (BrightHR) — verbatim from CSV
- Pay (contract phrasing) — how it should appear in the contract
- Missing — fields blank in BrightHR that need collecting before contract generation
Template A — Employment (FT + PT) — 24 complete records
| # |
Name |
Role |
Tmpl |
Tier |
Add'n |
Hours |
Pay (BrightHR) |
Pay (contract phrasing) |
Missing |
| 1 |
Julian Brown |
Delivery Driver |
A |
Std |
1 |
24 |
£1,626.79/m |
£19,521 pa |
— |
| 2 |
Lorna Chapman |
Administrator |
A |
Std |
— |
15 |
£1,016.74/m |
£12,201 pa |
— |
| 3 |
Caroline Rogers |
Shop Manager |
A |
Snr |
— |
8.5 |
£1,047.50/m |
£12,570 pa |
— |
| 4 |
John Castley |
Director |
A |
Dir |
+ Director's letter |
19.8 |
£1,047.50/m |
£12,570 pa |
Hours reduced from BrightHR's 60 to 19.8 to remain NMW-compliant at this pay rate (£1,047.50 ÷ £12.21 NMW ÷ 4.33 weeks). Any duties beyond 19.8h/week are office-holder/director duties, not paid employment. |
| 5 |
Kevin Moore |
Head Baker |
A |
Snr |
2 |
40 |
£17.71/h |
£17.71 per hour |
— |
| 6 |
Roy Grant |
Delivery Driver |
A |
Std |
1 |
32 |
£2,169.05/m |
£26,029 pa |
— |
| 7 |
Lily McCarthy |
Ops Administrator |
A |
Std |
— |
22 |
£1,491.23/m |
£17,895 pa |
— |
| 8 |
James Todd |
Head Driver |
A |
Snr |
1 |
35 |
£2,477.60/m |
£29,731 pa |
— |
| 9 |
Donald Kerr |
Baker |
A |
Std |
— |
40 |
£14.39/h |
£14.39 per hour |
— |
| 10 |
Timothy Brown |
Asst Ops Manager |
A |
Snr |
— |
40 |
£3,107.10/m |
£37,285 pa |
— |
| 11 |
Maya Rahajeng |
Baker |
A |
Std |
— |
40 |
£14.39/h |
£14.39 per hour |
Contract Type blank (FT assumed) |
| 12 |
Megan Tavendale |
Shop Assistant |
A |
Std |
— |
20 |
£13.44/h |
£13.44 per hour |
— |
| 13 |
Kenza Akil |
Baker |
A |
Std |
— |
40 |
£14.64/h |
£14.64 per hour |
— |
| 14 |
Elspeth Emmerson |
Asst Ops Manager |
A |
Snr |
— |
40 |
£2,866.68/m |
£34,400 pa |
— |
| 15 |
Jana Hajdova |
Shop Assistant |
A |
Std |
— |
11 |
£13.44/h |
£13.44 per hour |
— |
| 16 |
Heather Goodfellow |
Senior Baker |
A |
Snr |
2 |
32 |
£15.12/h |
£15.12 per hour |
— |
| 17 |
Timothy Forge |
Driver |
A |
Std |
1 |
30 |
£1,879.80/m |
£22,558 pa |
Contract Type blank (PT assumed) |
| 18 |
Reuben Chesney |
Senior Baker |
A |
Snr |
2 |
40 |
£15.12/h |
£15.12 per hour |
— |
| 19 |
Rowan Cook |
Baker |
A |
Std |
— |
40 |
£14.39/h |
£14.39 per hour |
— |
| 20 |
Sean Mackenzie |
Asst Ops Manager |
A |
Snr |
— |
40 |
£2,773.33/m |
£33,280 pa |
Confirm if he drives (might need Addendum 1) |
| 21 |
Connor Linklater |
Delivery Driver |
A |
Std |
1 |
40 |
£30,072.37/yr |
£30,072 pa |
— |
| 22 |
Rui Barbosa |
Delivery Driver |
A |
Std |
1 |
24 |
£1,503.84/m |
£18,046 pa |
Tax Code blank |
| 23 |
Rianne Nairn |
Delivery Driver |
A |
Std |
1 |
40 |
£30,072.37/yr |
£30,072 pa |
Contract Type blank (FT assumed) |
| 24 |
Poppie Cadell |
Trainee Baker |
A |
Std |
— |
40 |
£13.45/h |
£13.45 per hour |
Personal email + mobile blank |
Template A — Incomplete records needing data collection — 2 people
| # |
Name |
Role |
Tmpl |
Tier |
Add'n |
Hours |
Pay (BrightHR) |
Pay (contract phrasing) |
Missing |
| 25 |
Michael Hansen |
Visiting Baker |
A? |
Std? |
2? |
40 |
(blank) |
(blank — to be confirmed) |
DOB, address, NI, pay rate, holiday entitlement — confirm if permanent or short-term |
| 26 |
Harry Reith |
Shop Assistant |
A or B? |
Std/N/A |
— |
0 |
(blank) |
(blank — to be confirmed) |
Hours, pay rate, pay basis — 0 hours suggests casual not PT; confirm intended pattern |
Template B — Casual / Zero-hours — 8 people
| # |
Name |
Role |
Tmpl |
Tier |
Add'n |
Hours |
Pay (BrightHR) |
Pay (contract phrasing) |
Missing |
| 27 |
Ronin Walker |
Evening Packer |
B |
N/A |
— |
2.5 |
£13.44/h |
£13.44 per hour + 12.07% holiday |
— |
| 28 |
Marc Riddel |
Evening Packer |
B |
N/A |
— |
6 |
£10.88/h |
£10.88 per hour + 12.07% holiday |
— |
| 29 |
Blue Brown |
Evening Packer |
B |
N/A |
— |
8 |
£13.44/h |
£13.44 per hour + 12.07% holiday |
— |
| 30 |
Cameron Simpson |
Weekend Cleaner |
B |
N/A |
— |
4 |
£14.94/h |
£14.94 per hour + 12.07% holiday |
— |
| 31 |
Rebekah France |
Weekend Cleaner |
B |
N/A |
— |
4 |
£14.94/h |
£14.94 per hour + 12.07% holiday |
— |
| 32 |
Caledonia Jeffrey |
Evening Packer |
B |
N/A |
— |
9 |
£13.44/h |
£13.44 per hour + 12.07% holiday |
— |
| 33 |
Stephen Calder |
Evening Packer |
B |
N/A |
— |
9 |
£13.44/h |
£13.44 per hour + 12.07% holiday |
Tax Code blank |
| 34 |
Henry Chalmers |
Evening Packer |
B |
N/A |
— |
9 |
£13.44/h |
£13.44 per hour + 12.07% holiday |
County blank; personal email = work email |
Template B + Addendum 3 — Casual + Young Worker — 2 people
| # |
Name |
Age |
Tmpl |
Tier |
Add'n |
Hours |
Pay (BrightHR) |
Pay (contract phrasing) |
Missing |
| 35 |
Miles Spaul |
16 (turns 17 on 26-May-26) |
B |
N/A |
3 |
3 |
£10.88/h |
£10.88 per hour + 12.07% holiday |
Parental consent |
| 36 |
Alick Spurway |
17 (turns 18 on 19-Apr-27) |
B |
N/A |
3 |
6 |
£10.88/h |
£10.88 per hour + 12.07% holiday |
Parental consent |
Template C — Consultancy — 1 person
| # |
Name |
Role |
Tmpl |
Pay (BrightHR) |
Pay (contract phrasing) |
Missing |
| 37 |
David Johnson |
Consultant |
C |
£175/m |
£175 per calendar month retainer |
Trading name, services description, confirm whether £175/m is a flat retainer or a placeholder for a different fee structure, IR35 working-practice confirmation |
Summary of data we still need to collect
Must-fix before any contract is generated
- Michael Hansen — DOB, address, NI, pay rate, holiday — and confirmation of whether he's permanent FT or short-term Visiting Baker (decides A vs short letter of engagement).
- Harry Reith — 0 hours and no pay rate suggests his contract type isn't really PT; confirm intended pattern.
- David Johnson — confirm whether £175/month is a flat retainer or a placeholder; services description; trading name; IR35 working-practice confirmation.
Must-collect outside the CSV
- Parental consent forms for Miles Spaul and Alick Spurway (Addendum 3 co-signature).
Postcode for Cultybraggan Camp Unit 15a — Resolved 2026-05-17: PH6 2AB. Address is now 15A Cultybraggan Camp, Comrie, Crieff PH6 2AB across all docs.
- Confirm Sean Mackenzie's driving duties — if he drives, add Addendum 1; if not, skip.
Minor / can be cleaned up later
- Contract Type blanks for Maya Rahajeng, Tim Forge, Rianne Nairn — assumed from hours, but worth confirming.
- Tax Code blanks for Rui Barbosa, Stephen Calder — payroll concern, not contract-blocking.
- Personal contact details missing for Poppie Cadell, Henry Chalmers — useful for HR but not strictly required for a contract.
Edge cases / decisions
- Caledonia Jeffrey is recorded as PT in BrightHR but is on the Evening Packing team at variable hours — should she be on Template A (committed PT) or Template B (casual)? Default: B, consistent with the rest of Evening Packing.
- Cameron Simpson and Rebekah France are weekend cleaners on PT contracts with regular 4h — could justify Template A (committed PT) instead of B. Default: B because cleaning hours are typically irregular and offered shift-by-shift.
Totals
| Bucket |
Count |
| Template A (full + part-time permanent) — complete |
24 |
| Template A — incomplete records (Michael, Harry) |
2 |
| Template B (casual) |
8 |
| Template B + Addendum 3 (young workers) |
2 |
| Template C (consultancy) |
1 |
| Total real people in scope |
37 |
| Bravo Nyamudoka (excluded from this pass) |
1 |
| Placeholder slots (Visiting Baker, Stage Baker, Temp Driver) |
3 |
| Total BrightHR records |
41 |