Excel Canada Severance Calculator
Budget: $250 – $750 CAD
I need a fully-functional severance calculator built directly in Microsoft Excel so our HR team can run it on Windows machines without additional software. The worksheet should allow users to enter the following variables in clearly labelled input cells:
• Years of service
• Age of employee
• Job position
• Job grade
• Short-term incentive eligibility
Province
Based on these inputs the file must return the correct statutory and common-law severance entitlements for Canadian employees, following current federal and provincial guidelines. All formulas should be transparent, with assumptions documented in a hidden but unlockable sheet so we can update rates later.
Deliverables
• Unlocked Excel workbook with user-friendly input area and results dashboard
• Table or chart showing calculation logic (service caps, age multipliers, position/grade adjustments, incentive percentages)
• Brief PDF or in-sheet notes explaining how to maintain or modify the model
I will test the file against several sample scenarios; accuracy within two decimal places is the acceptance criterion.
• Years of service
• Age of employee
• Job position
• Job grade
• Short-term incentive eligibility
Province
Based on these inputs the file must return the correct statutory and common-law severance entitlements for Canadian employees, following current federal and provincial guidelines. All formulas should be transparent, with assumptions documented in a hidden but unlockable sheet so we can update rates later.
Deliverables
• Unlocked Excel workbook with user-friendly input area and results dashboard
• Table or chart showing calculation logic (service caps, age multipliers, position/grade adjustments, incentive percentages)
• Brief PDF or in-sheet notes explaining how to maintain or modify the model
I will test the file against several sample scenarios; accuracy within two decimal places is the acceptance criterion.