Question

In this assignment you will be fulfilling three separate roles. Shipping clerk Jessica Rogers his immediate supervisor Mark Johnson and payroll clerk Larry Fiske. Arnold industries pays employees time and one half for any time worked in a day in excess of eight hours. The first eight hdurs of each day are paid at the employee's normal pay rate. Employees are paid for the entire time at work including breaks. Jessica earns $12 per hour and worked the following days/Hours: Monday, 2/3/20. 8am to noon Tuesday, 2/4/20. 8am to 7pm Wednesday, 2/5/20. 9am to noon 2. Assume Mark Johnson confirms Jessica's reported hours and documents his approval as shown on the form 3. Larry calculates net pay and withholdings in the employee sub ledger spreadsheet Required Complete the above steps using the flowchart as guidance Turn in the approved timesheet Print the completed employee earnings sub ledger of course containing Jessica's pay this week. Assume Fed Withholding is $29.89 Nothing to do with Jessica - pretend Roger Jacobs stopped working at Arnold on January 31, 2020. Download one copy of a Form W-2 online and complete boxes 1-6 for Roger. He won't be working any more at Arnold

Answer 1

Note - 1	Monday and Wednesday she worked in normal hours
Note - 2	On Tuesday she worked 8 am to 7 am, Means 11 hours. 3 hours overtime
Note - 3	Normal Hour - 8 Hr
Note - 4	above Normal Hour Consider Overtime
Note - 5	Rate per hour 12/-
Note - 6	Overtime Rate is one half of normal rate, Means 12 x 1.5 = 18/-
Day	Date	Regular Hour	Overtime Hour	Sick	Vacation	Total
Monday	03-02-2020	8				8
Tuesday	04-02-2020	8	3			11
Wednesday	05-02-2020	8				8
Thursday	06-02-2020					0
Friday	07-02-2020					0
Saturday	08-02-2020					0
Sunday	09-02-2020					0
	Total Hour	24	3	0	0	27
Employee Earnings Subsidiary Ledger
Jessica Rogers
Period Ending	Regular Hour	Overtime Hour	Sick	Vacation	Gross Pay	Federal Withholding	Social Security	Medicare	Net Pay
03.02.20 to 09.02.20	24	3	0	0	342.00	29.89	21.20	4.96	285.95
Calculation Part -
Federal Withholding	29.89	given in question
Social Security	=161.82/2610 x 100	calculate on the basis of Roger Jacobs
	= 6.2%
	=5.95/96 x 100	calculate on the basis of Jessica Rogers
	= 6.2%
	Social Security is 6.20 % of Gross Amount
Medicare	=37.85/2610 x 100	calculate on the basis of Roger Jacobs
	= 1.45%
	=1.39/96 x 100	calculate on the basis of Jessica Rogers
	= 6.2%
	Medicare is 1.45 % of Gross Amount