Spreadsheet: 571031d1524535235-formula-for-calculating-cpp-canada-pension-plan-deductions-book1
Sheet: 4.1 Headcount

 | Proposed Staff [NAME]
 |  |  |  |  |  |  |  |  | September | October | November | December | January | February | March | April | May | June | July | August
 |  |  |  | Period | Period | Daily |  |  | Budget | Budget | Budget | Budget | Budget | Budget | Budget | Budget | Budget | Budget | Budget | Budget |  | Total
 | Name | Annual Salary |  | Start | End | Rate |  |  | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 |  | Total |  | FTE |  | Notes:
 | Employee 1 | 150000 |  | 2018-09-01 00:00:00 | 2019-08-31 00:00:00
 | Employee 2 | 75000 |  | 2018-09-01 00:00:00 | 2019-08-31 00:00:00
 | Employee 3 | 75000 |  | 2018-11-15 00:00:00 | 2019-06-15 00:00:00
 | Employee 4 | 50000 |  | 2018-09-01 00:00:00 | 2018-12-31 00:00:00
 | Employee 5 | 50000 |  | 2018-09-01 00:00:00 | 2019-08-31 00:00:00
 | Employee 6 | 160000 |  | 2018-10-06 00:00:00 | 2019-02-20 00:00:00
 | Employee 7 | 50000 |  | 2018-09-01 00:00:00 | 2019-08-31 00:00:00
 | Employee 8 | 40000 |  | 2018-09-01 00:00:00 | 2019-08-31 00:00:00
 | Employee 9 | 40000 |  | 2018-09-01 00:00:00 | 2019-08-31 00:00:00
 |  | 40000 |  | 2018-09-01 00:00:00 | 2019-08-31 00:00:00
 | Salary Increase Pool |  |  | 2018-09-01 00:00:00 | 2019-08-31 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | % Increase | 0.03
 | Total Permanent Staff [NAME]
 | CPP
 | EI
 | Benefits
 | Health Tax (No Health Tax in Alberta) | 0.0215
 | RRSP
 | Bonuses
 |  |  |  |  |  |  |  |  | September | October | November | December | January | February | March | April | May | June | July | August
 |  |  |  |  |  |  |  |  | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 |  | Total |  |  |  | Notes:
 | Bonus
 |  | 0.2
 |  | 0.1
 |  | 0.1
 |  | 0.1
 |  | 0.1
 |  | 0.1
 |  | 0.1
 |  | 0.1
 |  | 0.1
 |  | 0.1
 |  | 0.1
 |  | 0.1
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0.1
 | Total Bonuses
 | CPP Calculations
 |  |  |  |  |  |  |  |  | September | October | November | December | January | February | March | April | May | June | July | August
 |  |  |  |  |  |  |  |  | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 |  | Total |  |  |  | Notes:
 | Total Employer CPP
 | CPP Information:
 | [NAME] | 55900
 | Base Exemptions | 3500
 | [NAME] | 2593.8
 | Rate | 0.0495
 | EI Calculations
 |  |  |  |  |  |  |  |  | September | October | November | December | January | February | March | April | May | June | July | August
 |  |  |  |  |  |  |  |  | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 |  | Total |  |  |  | Notes:
 | Total Employee EI
 | Employer EI
 | Total EI
 | EI Information:
 | [NAME] Annual Insurable Earnings | 51700
 | Rate
 | Employer Rate (1.66 *1.4)
 | [NAME] Annual Employee Premium | 858.22
 | Benefit Calculation
 |  |  |  |  |  |  |  |  | September | October | November | December | January | February | March | April | May | June | July | August
 |  |  |  |  |  |  |  |  | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 |  | Total |  |  |  | Notes:
 | Total Employee Benefits
 | Benefits Information:
 | Benefits Estimate per Person | 3841