Problem PR-A (2020) Peppy Company pays its employees on the 15th and last day of each month. Employees gross pay is subject to these taxes: Tax FICA - Social Security FICA - Medicare Federal Unemployment State Unemployment Rate 6.20% 1.45% 0.60% 4.00% Applied to First $137.700 ALL Wages First $7.000 First $7,000 The company is preparing its payroll for the period ending October 31, 2020. Payroll records show the following information for the company's three employees. Current Pay Period Name Gross Pay thru 10/15/20 Gross Pay Federal Tax State Tax Manny $ 6,840$ 360 3% 2% Moe 38,000 2,000 10% 3% Jack 133,000 7,000 20% 5% Required (using an electronic spreadsheet) 1) For the current pay period, compute the following, for each employee: a) Net pay for the current pay period. b) Total cost, to the employer, including wages. 2) In addition to the statutory deductions, each employee must pay one-half of the $200 (per pay period) cost for and dental insurance. Insurance is a pre-tax deduction. For the current pay period, compute net pay for each employee. What is the difference between this net pay and the net pay in (1a)? 3) (Independent of Requirement #2.) Peppy Company offers a 401(k) retirement plan to its employees. The company matches all amounts withheld from the employees up to 3% of each employee's gross pay. All employees contribute the maximum amount. Any amounts contributed currently are FICA taxable but are not taxable for federal or state income tax purposes. For the current pay period, compute net pay for each employee. What is the difference between this net pay and the net pay in (1a)? Sheet1 Sheet2 Sheets Prebom PRA2030 Manny TICA. Social PICA-Med de normes TO 5.22 100 72 H. Man 2.000 7.000 14 LB Gray Fragebot PA RICAM Fede Student Towest temployer E Problem PR. A 2020 Manny M Gray -100 Ty L Drthuters FICAS HCA Fewww Score www 16.13 STT 78 wy 227.01 The cost of the Wang Me Jack 00 2.000 1900 Ducho RICAS PICA Medicine Render F 123 10.40 210 3643 1024