You have been hired as the bookkeeper for The Purple Moose; it is a small manufacturing company located in Anytown, New State. The company has a workforce of both hourly and salaried employees. Each employee is paid for hours actually worked during each week, with the time worked being recorded in quarter-hour increments. The standard workweek consists of 40 hours, with all employees being paid time and one-half for any hours worked in excess of 40 hours. Wages are paid every Friday, with one week's pay being held back by the company. Thus, the first payday for The Purple Moose is January 13 (for the workweek ending January 7 (Saturday). Use the information below to prepare the payroll for the period ending January 7: Time card Employee Name Hourly Wage or Salary Filing Status No. of Withholding FORM W-4 No. Allowances 11 C Cadbury $16.50 per hour MFJ 3 Old 12 W Hershey $18.25 per hour MFJ New 13 H Lindt $1710 per hour S New 21 L Dove $16.90 per hour S 0 PO Old 22 L Toblerone $18.75 per hour MFJ New 31 G Godiva $535 per week S 1 Old 22 32 G Guylian $2,800 per month S 2 Old 33 T Sprungli $3,450 per month S New 51 B Ghirardelli $2,550 per month MFJ 2 Old 99 66 C Nestle $53,000 per year MFJ 0 Old The timecard data from the week ended January 7 is as follows: Timecard No. Time Worked Each Day Employee Su M T W R F Sa + 11 C Cadbury 8 8 8 8 12 W Hershey 8 00 8 8 00 00 4 200 8 00 8 13 H Lindt 8 8 8 00 8 00 8 4 L Dove 6 6 6 10 4. 00 8 8 00 21 222 32 31 L Toblerone G Godiva 32 22 G Guylian 33 T Sprungli 51 B Ghirardelli 10 10 99 C Nestle 8 10 10 1 4 00 8 10 10 - - 00 00 4. 00 8 8 8 3 10 10 10 10 - 10 10 10 10 10 10. 10 10 10 10 00 8 00 8 8 8 INSTRUCTIONS: Open the payroll register file and perform the following tasks: 1. Record the regular hours and the overtime hours for each employee 20 points 2. Compute and record the regular earnings and the overtime earnings for each employee 20 points 3. Compute and record the total earnings for each employee 4. In the taxable earnings columns, record the amount of each employee's weekly earnings that is subject to OASDI and HI taxes 10 points 10 points 5. Using the amounts that you just recorded in step 4, compute and record the OASDI and HI taxes for each employee 6. Use the wage-bracket method to record the federal income taxes (FIT) for each employee; for those employees with a "new" version of Form W-4, assume standard withholding; be sure to use the tables provided in BlackBoard 20 points 10 points 7. Compute and record the state income taxes (SIT) for each employee; the rate is 5.0% 10 points 8. Compute and record the city income taxes (CIT) for each employee; the rate is 0.4% 10 points 9. In the taxable earnings columns, record the amount of each employee's weekly earnings that is subject to FUTA and SUTA taxes. (see step 11 for additional SUTA info) 10 points 10. Using the amounts that you just recorded in step 9, compute and record the SUTA taxes that need to be paid by each employee; the rate is 0.06% 11. Using the amounts you recorded in step 9, compute the amounts of FUTA and SUTA that The Purple Moose must pay. The company pays SUTA of 3.5% on the first $8,000 of each employee's earnings, and the company qualifies for the Net FUTA rate. Record these amounts in the spaces provided below 10 points 4 points 12. Compute and record the net pay for each employee. Each 10 points worker is paid by direct deposit 13. Foot all money columns in the payroll register, and prove the accuracy of the column totals 14 points 14. Click on the "General Journal" tab in your excel workbook and prepare the journal entry necessary to record the payroll as of 32 points Jan 13 15. Skip a line in your journal and then prepare the journal entry necessary to record the payroll taxes due as of Jan 13 20 points