1please help

2

Calculate Payroll K. Mello Company has three employees a consultant, a computer programmer, and an administrator. The following payroll information is available for each employees Consultant Computer Programmer Administrator Regular earnings rate $2,610 per week $34 per hour 542 per hour Overtime camingsrate Not applicable 2 times hourly rate 1.5 times hourly rate Federal income tax withheld $920 $240 $515 For hourly employees, overtime as paid for hours worked in excess of 40 hours per week for the current pay period, the computer programmer worked 51 hours and the administrator worked 6 hours, Musume further that the social security tax rate was 67, and the Medicare tax rate was 1.5% 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. It required, round your answers to two decimal places Consultant Computer Programmer Administrator Gross pay 2,610 2,176 x Accounting numenched Net py Fodbad Ou My Won Gross pay represents the total earnings of an employee for a specific pay period, prior to taxes and deductions. Net pay is also known as take home pay Lung Objective Wage and Tax Statement Data on Employer FICA TAX Ehrlich Co, began business on January 2, Salaries were paid to employees on the last day of each month, and social security tax, Medicare tax, and federal income tax were withheld in the required amounts. An employee who is hired in the middle of the month receives hall the monthly satory for that month. All required payroll tax reports were filed, and the correct amount of payroll taxes was remitted by the company for the calendar year Early in the following year before the Wage and Tax Statements (Form W2) could be prepared for distribution to employees and for filing with the Social Security Administration, the employees canings records were inadvertently destroyed. None of the employees resigned or were discharged during the year, and there were no changes in salary rates. The social security tax was withheld at the rate of 6.0% and Medicare tax at the rate of 1.5% on salary. Data on dates of employment, salary rates, and employees' income taxes withheld, which are summarized as follows, were obtained from personnel records and payroll records: Employee Arnett Date First Employed Nov. 16 Jan 2 Monthly Income Tax Withheld 5944 CHU 833 Edwards Oct. 1 Monthly Salary $5,500 4,800 3,000 6,000 10,000 11,600 5,220 Dec. 1 Feb. 1 Nicks 1,592 1,070 2,350 7,600 176 Mar 1 Shiancoe Ward Novo Required: 1. Compute the amounts to be reported for the year on each employee's Wage and Tax Statement (Form W 2). Enter amounts to the nearest cent if required. Enteral amounts as positive numbers 1. Compute the amounts to be reported for the year on each employee's Wage and Tax Statement (Form W2) Enter amounts to the nearest centif regured. Enter all amounts as positive numbers Employee Gross Earnings Federal Income Tax Withheld Social Security Tax Withheld Medicare Pax Withheld Arnett Cruz Edwards Harvin Nicks Shioncoe Ward > Compute the following employer payroll taxes for the year (A) social security (6) Medicare. (C) state unemployment compensation at 5.4% on the front 510,000 of each employee's earnings, CO) federal unemployment compensation at 0,6% on the first 510,000 of each employee earrings (e) total. Hound your answers to two decimal places, (a) (6) (0) (0) Check My Work Previous