Estimate Benefits for an Employee

Issue/Question

How do I estimate or calculate benefits for an employee?

Environment

• Excel
• USD Portal
• Benefits
• Employee

Cause

A department or supervisor needs to calculate or estimate the cost of benefits based upon an employee’s salary.

Resolution

1. Login to the myUSD portal 
2. Within the Financial Affairs channel, click Budget
3. Click FY#### Benefits Calculator (the fiscal year will be updated each year)
4. This will open the benefits calculator within an excel file
   1. You may need to click download to download and open the file outside of the browser

To use the Benefits Calculator

1. Enter a new salary amount next to the cell labeled base salary
2. Upon entering the new salary figure, the benefit calculations below will automatically update:
   1. Worker’s Compensation
   2. Social Security
   3. Medicare
   4. Reemployment Assistance
   5. SDRS
   6. Health
   7. Employer Paid Benefit Total (this is the total of the benefits above)
   8. Benefit Packet approx. value of base salary (this calculation is the employer paid benefits divided by the employee’s salary amount)
   9. Total Compensation (employer paid benefit total plus employee’s base salary)