Accounting: Employee Cost Calculator

 

For every planned new hire, it’s important to know in advance what the total cost of employing the person will be.  This includes wages, taxes, and employer sponsored benefits expense.  In addition, it is necessary to derive the cost per billable hour (Loaded Hourly Rate) in order to know if this hire will contribute to the company’s profit within its pricing model.

 

This small worksheet identifies the real cost of candidates being considered to fill an open position:

employee-calculator

 

Key to worksheet updates:

  1. Update cells B8 to C12 each year with annual tax rates and limits
  2. For each employee, enter all blue fields including Holiday and PTO days

 

Use of data:

  1. Total cost of the employee (cell E25) is used to measure impact on annual Budget/Fcst
  2. Loaded Hourly Rate allows calculation of contribution margin for setting the billing rate
  3. Payroll Overhead percentage can be used in general to mark up Salary to full cost

 

 

 

Looking For More?

Comments

Silicon Valley Accounting Solutions produces the Solution of the Week in order to share tips and shortcuts that promote process efficiency and highlight software features that may not be in your current toolbox. Please let us know if you have questions on how to accomplish a particular task or if you simply have a comment to share.

Even if you find that you know most of what you see here, it only takes one “Aha” to make regular visits worthwhile. To avoid missing any solutions, you may subscribe and have a new one delivered to your inbox each week.

Contact Us

We want to help you grow
your business, call us
at: (408) 844-4216 or
find out more here.

Controllership

When you need:
  • Clear processes for cash controls
  • Analysis of results
  • Customized reporting

Accounting

When you need:
  • Timely and accurate bookkeeping
  • Reconciliations and monthly closes
  • Familiarity with popular accounting software
Web Analytics