Accounting Scenario 2 Bart Consulting Firm has the following payroll information for the week ended March 20th: Name Earnings at the end of the previous week Sun. Mon. Tues. Wed. Thurs. Fri. Sat. Pay Rate Federal Income Tax 14,400 8 8 8 8 30.00 222.52 Lauren, F Baylor, M Lims, T 8 8 8 8 8 8 25.00 178.55 12,000 7,200 8 8 00 8 8 15.00 78.00 Tate, 6,000 8 8 8 8 8 15.00 62.00 Musker, 4,320 8 8 15.00 15.00 8 8 Mako. W 3,888 8 8 13.50 11.00 Additional Information: Taxable earnings for Social Security are based on the first $132,900. Taxable earnings for Medicare are based on all earnings. Taxable earnings for federal and state unemployment are based on the first $7,000. Employees are paid time-and-a-half for work in excess of 40 hours per week. Round amounts to the nearest penny. What vou must do: What you must do: Complete the attached Payroll Register (Excel Spreadsheet). Use the following information to help: The Social Security tax rate is 6.2 percent. The Medicare tax rate is 1.45 percent. Begin payroll checks with No. 1050. Submission Format Use the attached fillable payroll register (Excel Spreadsheet) to complete this assignment. Submit your completed Excel spreadsheet in D2L. DO NOT email your work to your instructor. B D E F 3 N G . Formula Bar O EARNINGS PAID Employee Name Total Hours Medicare Tax DEDUCTIONS Federal Retirement Income Savings Tax Social Security Tax Regular Overtime Total Ck. No. Net Pay Total