lnf.cymru stimulus sheet · PSE / Well-being · Year 9
Keep this sheet beside your worksheet all lesson. Compare the two October payslips in Section 1 and Section 2, check the payroll glossary in Section 3, and use the spreadsheet savings model in Section 4.
Important payroll check: Megan’s signed October paper timesheet shows she worked 80.0 basic hours at £10.00/hr and 10.0 overtime hours at £15.00/hr. Compare her signed timesheet with what was printed on her October payslip below:
| Payments (printed on payslip) | Hours | Rate (£/hr) | Amount (£) |
|---|---|---|---|
| Basic Lifeguard Hours | 80.0 | £10.00 | £800.00 |
| Weekend Overtime Hours (1.5 × rate) | 6.5 (check timesheet!) | £15.00 | £97.50 |
| Printed Gross Pay (before fixing the overtime error) | £897.50 | ||
Rhodri’s signed October timesheet shows 140.0 basic hours at £12.00/hr and 5.0 overtime hours at £16.00/hr (his hours match his payslip with no error).
| Payments | Hours | Rate | Amount | Deductions | Amount |
|---|---|---|---|---|---|
| Basic Supervisor Hours | 140.0 | £12.00 | £1,680.00 | Income Tax (PAYE) | £142.00 |
| Evening Overtime Hours | 5.0 | £16.00 | £80.00 | National Insurance (NI) | £57.00 |
| Workplace Pension (5% of Gross Pay) | Calculate in Step 1 | ||||
| Gross Pay | £1,760.00 | Total Deductions & Net Pay | Calculate in Step 1 | ||
| Term | Meaning |
|---|---|
| Gross pay | Total pay earned before any tax, National Insurance, pension or other deductions are taken off. Formula: Basic Pay + Overtime Pay. |
| Income Tax (PAYE) | Pay As You Earn tax collected by HM Revenue & Customs (HMRC) to fund public services such as schools, roads and hospitals. |
| National Insurance (NI) | Contributions collected on earnings above the threshold to qualify for the State Pension and certain state benefits. |
| Workplace Pension | A percentage of gross pay saved for retirement; your employer also adds money into your pension pot on top. |
| Net pay (take-home pay) | The actual money paid into your bank account after all deductions. Formula: Gross Pay − Total Deductions. |
Once Megan’s 3.5 missing overtime hours are added and her deductions are taken off, her Corrected Net Pay is £900.00 per month. She wants to save £600.00 for a block of 15 driving lessons before her birthday in 3 months’ time. She models two monthly budgets in a spreadsheet:
| Cell row | Budget category / item | Col B: Plan A (Standard 50/30/20 Rule on £900 Net Pay) | Col C: Plan B (Trimmed Wants Model on £900 Net Pay) |
|---|---|---|---|
| Row 2 | Corrected Net Pay (£) | £900.00 | £900.00 |
| Row 3 | Needs (50%): bus pass, phone bill, board at home | 50% of £900 = £450.00 | 50% of £900 = £450.00 |
| Row 4 | Wants: takeaways, clothes, cinema | 30% of £900 = £270.00 | Cut Wants by £20/month = £250.00 |
| Row 5 | Savings into £600 Driving Fund | 20% of £900 = £180.00 / month | £900 − (£450 + £250) = £200.00 / month |
| Row 6 | Saved after 3 months (Formula: =B5*3 and =C5*3) |
£180 × 3 = £540.00 (£60 short) | £200 × 3 = £600.00 (Target met!) |
| Row 7 | Months to reach £600 (Formula: =600/B5 and =600/C5) |
600 ÷ 180 = 3.33 months (needs 4th month) | 600 ÷ 200 = 3.0 months (exact) |