Payroll | Mathematics homework help

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:  

Our writing company helps you enjoy campus life. We have committed and experienced tutors and academic writers who have a keen eye in writing papers related to Business, Management, Marketing, History, English, Media studies, Literature, nursing, Finance, Medicine, Archaeology, Accounting, Statistics, Technology, Arts, Religion, Economics, Law, Psychology, Biology, Philosophy, Sociology, Political science, Mathematics, Engineering, Ecology etc.

Need Custom Written Paper?

-Plagiarism free

-Timely delivery