Question 1: Complete the 2 two columns in the excel sheet with the following information provided

For Weck Ended Novem ber 21, 20 Fed. Inc Soc Sec Medkcare State Inc WaA 1:Bizs, A 40 11721,536.00 Coo 3Dell Don 12 21,180.00 4Evans, PdioMamied 34 127 280.00 1819.00 25.3872.76 1,8182 22 1OS6,096.00 5,327.00 31.00 6:Grayson,Nik Maed 11 21040.00 21480.00 Ro.ohn 8:Wayne, DaMaed 18 1086,855.00 251,645.00 25735240 Payroll Arcade Mania has the following payroll information for the week ending November 21: Earnings at End of Previous Week Hours Pay Filing Number of Status Withholdings Name Worked Rate Biggs, Al Cool, Ray Dell, Don Evans, Pedro Frey, Belle Grayson, Nic Roberts, John Wayne, David 40 $11.65 $21,536.00 Single 40 $%11.50 $21,988.00 Single 40 $%11.95 $21,160.00 Married 49 $34.00 $127,280.00 Married 22 $10.50 40 45 $14.25 $25,690.00 Single 18 $10.75 4 arrie 11.00 $21,040.00 Married 6,855.00 Married Employees are paid weekly and are paid time-and-a-half for work in excess of forty hours per week. Taxable earnings for Social Security are based on the first $128,700. Taxable earnings for Medicare are based on all earnings. Taxable earnings for federal and state unemployment are based on the first $7,000. State unemployment tax rate is 5.4% and federal unemployment tax rate is .6%. Instructions 1. Complete the payroll register, page 37, The Social Security tax rate is 6.2% for employees and employers and the Medicare tax rate is 1.45%