ABCDEFGHIJPQ
1
2
Open-source//Parental Leave Costing
3
This tool is designed to help companies estimate costs of enhancing Parental Leave policies in Great Britain. The tool offsets Statutory pay offered by the UK Government in the Est. Total Cost (B36).
4
The "ONS Births//Processed Data" tab enables the model to predict how many employees are likely to go on Leave on an Annual Basis, based on gender and age group.
5
TO USE, PLEASE MAKE A COPY. [input your company data in the yellow fields]
6
7
8
Headcount# EmployeesCurrentCost (GBP, pre-tax)
9
# employees TODAY (UK)0Annual emp. cost£0.00
//Enter average employee cost. To view estimate per employee, see B31 & B32
10
Weekly emp. cost£0.00
11
12
Maternity LeavePaternity Leave
13
Pay type# WeeksPay type# Weeks
14
Full pay0Full pay0
//Use this table to test different leave duration scenarios
15
90% pay690% pay0
16
Statutory minimum33Statutory minimum2
17
Unpaid13Unpaid3
18
19
# of your company's employees that self-identify genderFemaleMaleTotal
20
<20 years000
//Complete the full table to view a full company estimate.
21
20-24 years000
//To test certain age groups, enter number of employees per group, and adjust F8 average for a more accurate estimate.
22
25-29 years000
23
30-34 years000
24
35-39 years000
25
40-44 years000
26
45+000
27
Total000
//field will turn red if not equal to B8
28
29
Annual cost of proposed parental leave program
30
31
Est. cost of proposed parental leaveCompare your policyTotal paid under statutory policyTotal paid under enhanced policyTotal # WeeksTotal # Paid Weeks
32
...per mother£0.00Maternity Leave £0.00£0.005239
33
...per father£0.00Paternity Leave303.94£302.4052
34
35
# of UK EmployeesEst. total cost
36
Today (0)£0.00
37
38