| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
1 | ||||||
2 | Optimizely - Modeling the Cost of Parental Leave | |||||
3 | DISCLAIMER: Should you choose to use this model to advocate for increased parental leave policy at your company or organization, be sure to work in concert with your financial and legal teams to ensure the financial implications are accurate for your business. | |||||
4 | Input your company's data in the YELLOW cells > scroll to bottom for est. cost | To edit this spreadsheet, make a copy ("File->Make a copy...") | ||||
5 | ||||||
6 | Headcount | # Employees | ||||
7 | # US employees TODAY | 400 | // exclude non-US countries | |||
8 | # FUTURE employees | 600 | // for scenario analysis | |||
9 | ||||||
10 | Current | Cost (USD) | ||||
11 | Annual emp. cost | $100,000.00 | ||||
12 | Weekly emp. cost | $1,923.08 | ||||
13 | ||||||
14 | Parental Leave Plan | # Weeks | ||||
15 | Maternity | 17 | ||||
16 | Paternity | 17 | ||||
17 | ||||||
18 | # of your company's employees that self-identify gender | Female | Male | Total | ||
19 | <20 years | 0 | 0 | 0 | ||
20 | 20-24 years | 36 | 36 | 72 | ||
21 | 25-29 years | 72 | 72 | 144 | ||
22 | 30-44 years | 72 | 72 | 144 | ||
23 | Total | 180 | 180 | 360 | ||
24 | ||||||
25 | Annual cost of proposed parental leave program | |||||
26 | ||||||
27 | Est. cost of proposed parental leave | |||||
28 | ...per mother | $32,692.31 | // across mothers only; based on avg annual cost per employee per week | |||
29 | ...per father | $32,692.31 | // across fathers only; based on avg annual cost per employee per week | |||
30 | ...per US Employee | $1,634.62 | // across all US employees | |||
31 | ||||||
32 | # of US Employees | Est. total cost | ||||
33 | Today (400) | $653,846.15 | ||||
34 | Future state (600) | $980,769.23 | ||||