Compute payroll

K. Mello Company has three employees-a consultant, a computer programmer, and an administrator. The following payroll information is available for each employee:

Consultant

Computer Programmer

Administrator

Regular earnings rate

$2,310 per week

$28 per hour

$40 per hour

Overtime earnings rate

Not applicable

2 times hourly rate 1.5 times hourly rate

Federal income tax withheld

$920

$239

$510

For hourly employees, overtime is paid for hours worked in excess of 40 hours per week.

For the current pay period, the computer programmer worked 54 hours and the administrator worked 63 hours. Assume that the social security tax rate was 6.0%, and the Medicare tax rate was 1.5%.

This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input your answers in the questions below.

A

Open spreadsheet

Determine the gross pay and the net pay for each of the three employees for the current pay period. Assume the normal working hours in a week are 40 hours. When required round intermediate calculations and final answers to two decimal places.

Consultant

Administrator

Computer Programmer

$

Gross pay

Net pay

Check My Work

Previous

Spreadsheet

Compute payroll K. Mero Company has three employees a consulant, a computer programmer, and an administrator. The following parrol information is avalable for each employee. For noury empleyees, owertime is pild for hours worked in exsess of 40 hours per week. This irformation has been cellected in the Microsoft Excel Onine file. Open the spreadsheet, perform the required analysis, and input your anseces in the quections below. Ocen xpreadsheet Compute payrol K. Mello Company has three employees-a consultant, a compuler programeser, and an administrator. The following paxpol intomiation is avatable for eash employno? REQURED: Detemine the gross pay and the net pay for each of the three empleyees for teve eurtent pay period to CNOWv2 for greden Delermine the gross pay and the net pay for each of the three employees for the curront pay period. Using formulas and cell relerences trom the problem data, perform the reguired analysis, Formulas enker ed in the green cels show in the orange celh Transfor amount? to CNOWve for grading