|
PRODUCTION (HOURLY) EMPLOYEE COST CALCULATION |
||||||||||||
|
Employee: |
||||||||||||
|
Enter your actual numbers in green-shaded cells to calculate |
||||||||||||
|
Direct Employee Costs: |
Maximum Employer Contributions to: |
Billable Hours: |
||||||||||
|
Per Month |
Per Year |
Days |
Hours |
% of Available |
||||||||
|
Hourly wage |
Health Insurance |
Annual Available |
||||||||||
|
Social Security % |
Dental/Vision |
Less: |
Holidays |
|||||||||
|
Medicare% |
Retirement plan |
Vacation |
||||||||||
|
SUI% |
Cell phone |
Sick |
||||||||||
|
FUTA% |
Supplies/Tools |
Personal |
||||||||||
|
Worker's Comp% |
Vehicle or Reimbursement |
Non-productive hrs/day |
||||||||||
|
Other |
(in office, travel, set-up, break-down, etc.) |
|||||||||||
|
Direct Hourly Cost |
Adjusted Billable Hours |
|||||||||||
|
Annual Wage |
Monthly Related Costs |
Billable rate at wage of |
per hour |
|||||||||
|
(This is the billable rate before profit and overhead are added) |
||||||||||||
|
Annual Direct Costs |
Annual Related Costs |
Employee Total Annual Cost |
||||||||||
|
(Annual = 52 weeks x 40 hours) |
||||||||||||
|
Minimum Hourly Bill Rate Calculation |
||||||||||||
|
Allocated Overhead MARGIN%: |
Bill Rate (before profit) |
|||||||||||
|
(rounded up to nearest dollar) |
||||||||||||
|
Desired Profit MARGIN%: |
Bill Rate (including profit) |
|||||||||||
|
(rounded up to nearest dollar) |
||||||||||||