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 weeks 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 No. Employee Name Hourly Wage or Salary Filing Status No. of Withholding Allowances FORM W-4 11 C Cadbury $17.50 per hour MFJ -- New 12 W Hershey $17.25 per hour MFJ 2 Old 13 H Lindt $18.10 per hour S 1 Old 21 L Dove $17.90 per hour S -- New 22 L Toblerone $19.75 per hour MFJ 3 Old 31 G Godiva $515 per week S -- New 32 G Guylian $2,700 per month HOH -- New 33 T Sprungli $3,350 per month S 0 Old 51 B Ghirardelli $2,510 per month MFJ -- New 99 C Nestle $52,000 per year HOH -- New The timecard data from the week ended January 7 is as follows: Timecard No. Employee Time Worked Each Day Su M T W R F Sa 11 C Cadbury -- 8 8 8 8 8 8 12 W Hershey -- 8 8 8 8 4 -- 13 H Lindt -- 8 8 8 8 8 8 21 L Dove 6 6 6 10 10 4 -- 22 L Toblerone -- 8 8 8 8 8 4 31 G Godiva -- 8 8 8 8 8 -- 32 G Guylian -- 10 10 10 10 -- -- 33 T Sprungli -- -- -- 10 10 10 10 51 B Ghirardelli 10 -- -- -- 10 10 10 99 C Nestle -- 8 8 8 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 10 points

4. In the taxable earnings columns, record the amount of each employees weekly earnings that is subject to OASDI and HI taxes 10 points

5. Using the amounts that you just recorded in step 4, compute and record the OASDI and HI taxes for each employee 20 points

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 10 points

7. Compute and record the state income taxes (SIT) for each employee; the rate is 5.25% 10 points

8. Compute and record the city income taxes (CIT) for each employee; the rate is 0.6% 10 points

9. In the taxable earnings columns, record the amount of each employees 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.05% 10 points

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.25% on the first $7,000 of each employees earnings, and the company qualifies for the Net FUTA rate. Record these amounts in the spaces provided below the payroll register 4 points

12. Compute and record the net pay for each employee. Each worker is paid by direct deposit 10 points

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 Jan 13 32 points

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 point