Employee Cost Analysis Worksheet Template (Sample)

ADVERTISEMENT

07/2012
Form T-2
Employee Cost Analysis Worksheet
Upper Columbia Conference of Seventh-day Adventists
MONTHLY PAYROLL COST ESTIMATE FOR: ___________________________________________
(Print Employee Name)
Hourly pay rate
$_________ per hour x __________ # of hours/month = monthly cost
____________
OR
Volunteer
$_________ /month reimbursement (ie Track 1 Bible Worker Coordinator)____________
Reimbursement
AND
$_________ Value of all other compensation (gifts, stipend, housing, etc.) ____________
(If this worker is a volunteer- stop here.) TOTAL BEFORE TAXES/BENEFITS: ______________
TAXES –
Social Security (7.65% of gross wages)
____________
Workers Comp (See payroll cost sheet)
____________
BENEFITS – (check the benefits the worker receives and calculate the cost)
Retirement (
) ____________
5% of gross wages and up to 3% match of employee contribution
Vacation (1 to 4yrs = 2 wks; 5-9 yrs = 3 wks;10+yrs = 4wks)
____________
Sick Leave (accrues at .03855 per hour worked)
____________
Medical ($630.00 or $755.00 or $1180.00 – See payroll cost sheet)
____________
Life Insurance ($16.95 per month)
____________
Disability Insurance (monthly wage x .00383 p/month)
____________
Holidays (
) ____________
Max of 76 hrs / yr for FT thus—hrly wage x 76 / 12 = Holiday pay
TOTAL MONTHLY EMPLOYEE COST WITH BENEFITS
_______________
X 12 FOR THE TOTAL AMOUNT BUDGETED YEARLY FOR EMPLOYEE
_______________
__________________________________________
_______________________________________
Prepared by
(please print)
Title
__________________________________________
Date
Page 1 of 1

ADVERTISEMENT

00 votes

Related Articles

Related forms

Related Categories

Parent category: Business
Go