payroll
Payroll
This week Clint and Zack have fallen behind on their bookkeeping. To help them, please calculate the salaries for this week for all the employees. Use the tables in this document to send your answers. Fill in the information as needed. You may save this document, including your answers, and send it to your instructor.
- Take into account whether or not the employee should have social security tax withheld based on cumulated earnings.
- You also need to calculate how much the business needs to send in for SUTA (.9%) and FUTA (6.3%). Remember base salaries amounts where that applies. Check cumulated earnings for each employee.
- Use the percentage method for calculating FIT, and use the tables in the textbook, not the Handbook/Study Guide. The tables are different for the Handbook and for the textbook.
- Overtime is time and a half.
Disclaimer: The cumulated earnings (maybe the salaries also) are not reasonable. Just take it all at face value and work with it.
This is a list of TurfScapes ’ employees and their hours for one week beginning June 1, 2008.
|
Name |
Position |
Hours Worked |
Rate of Pay |
Martial Status
|
Cumulated earnings as of May 31, 2008 |
|
Nancy |
Office Assistant |
40 |
12.00 |
Married/ 4 exempt |
$ 15,269 |
|
Christie |
Designer |
70 |
$2500/wk |
Married/ 2 exempt |
107,600 |
|
Paul |
Laborer |
25 |
5.75 |
Single/ 1 exempt |
5,800 |
|
Robbie |
Landscaper |
55.5 |
10.90 |
Single/ 2 exempt |
39,460 |
|
Mary |
Bookkeeper |
45.75 |
15.00 |
Married/ 1 exempt |
32,500 |
John gets paid a little differently. He is paid for each hole he digs for fencing. Below is his schedule of pay.
He is married and claims 3 exemptions. His cumulated earnings are $15,469. John dug 350 holes this week.
0-100 holes $5 per hole
100-500 Holes $8 per hole
500 and over $10 per hole
Fill in the payroll register.
Payroll Register – TurfScapes
|
Employee Name |
Allow& MarSt |
Cum earn (May 31) |
Weekly Wage |
Earnings |
Cum Earn |
||
|
Regular time |
Overtime |
Gross |
|||||
|
Nancy |
M4 |
$ 15,269 |
|
$ 480.00 |
$ |
$ 480.00 |
$ 15,749 |
|
Christie |
|
107,600 |
$2,500.00 |
|
|
2,500.00 |
110,100.00 |
|
Paul |
|
|
|
|
|
|
|
|
Robbie |
|
|
|
|
|
|
|
|
Mary |
|
|
|
|
|
|
|
|
John |
M3 |
|
|
|
|
|
|
|
Totals this pay period |
|
|
|||||
|
Employee |
FICA Earnings |
FICA tax |
FIT |
Net Pay |
||
|
Name |
SS |
Med |
SS |
Med |
|
|
|
Nancy |
$ 480.00 |
$ 480.00 |
|
|
|
|
|
Christie |
|
|
|
|
|
|
|
Paul |
143.75 |
143.75 |
|
|
|
|
|
Robbie |
|
|
42.74 |
|
|
|
|
Mary |
|
729.38 |
|
10.58 |
|
|
|
John |
2500.00 |
|
|
|
388.41 |
|
|
Totals this pay period |
|
|
|
|
||
Fill in each cell as needed. Every cell may not be filled; just be sure to include the necessary information. Fill in the shaded cells in the totals line.
Use this form as the worksheet for writing the payroll checks:
Use these tables as a double check of your calculations in the payroll Register.
|
Employee Name: |
Nancy |
|
Gross Salary for pay period: |
|
|
Total Deductions for this pay period: |
|
|
Amount check of this pay period: |
|
|
Employee Name: |
Christie |
|
Gross Salary for pay period: |
|
|
Total Deductions for this pay period:. |
|
|
Amount check of this pay period: |
|
|
Employee Name: |
Paul |
|
Gross Salary for pay period: |
|
|
Total Deductions for this pay period: |
|
|
Amount check of this pay period: |
|
|
Employee Name: |
Robbie |
|
Gross Salary for pay period: |
|
|
Total Deductions for this pay period: |
|
|
Amount check of this pay period: |
|
|
Employee Name: |
Mary |
|
Gross Salary for pay period: |
|
|
Total Deductions for this pay period: |
|
|
Amount check of this pay period: |
|
|
Employee Name: |
John |
|
Gross Salary for pay period: |
|
|
Total Deductions for this pay period: |
|
|
Amount check of this pay period: |
|
Show your calculations for the two items below. Assume the taxes have been paid through the ending of the last pay period.
FUTA tax required for current payroll:
SUTA tax required for current payroll:
Leave a Reply
Want to join the discussion?Feel free to contribute!