NEED ANSWER ASAP PLEASE!

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.

Spreadsheet:

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: 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 secunity tax rate was 6.0%, and the Medicare tax rate was 1.5\%. This information nas been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input your answers in the questions below. Compute payroll K. Melio Company has three employees-a consultant, a computor programmer, and an administrator. The following payrol information is available for each employe0: REQUIRED: Determine the gross pay and the net pay for esch of the three employees for the current pay period Using fornulas and cell relerences from the problem data, pertorm the reguiced analysia. Formulas entered in the green cefs show in ite orange cels. Transler amounts to CloWvi2 for grading Welyg fommulas and coll references from the problem data, pertorm the required analysis. Formulas entered in the groon cels showe in the erarge cels, Tranufec amcunte CNOWve for grading