Eagle Corp. is a small business that is located at 10 Sheboygan Lane, Springfield, OH45504. Its federal Employer Identification Number is 99-9999999. The company president is Jihyo Park (telephone; 937-555-0073) and she signs all forms. The company does not name a third-party designee on any form. During 2022, five individuals are employed by Eagle Corp. These employees are as follows: Note that the following: - Mateo Lopez was hired in July 2022, and his first day of work was Friday, July 1. On his W-4, Mateo Lopez checked box 2c and left sections 3 and 4 blank. Mateo is a salaried employee that is exempt. - Due to unethical actions, Edith Smith was terminated. Her last day of work was on Monday, December 5. - To replace Edith Smith, Kiara Murphy was hired and began working on Monday, December 18. On her W-4 form Kiara Murphy checked box 2 cand left sections 3 and 4 blank. - All employees of Eagle Corp. work a regular 40-hour workweek (thus hours worked over 40 in a given week are overtime hours) and receive overtime pay at a rate of 1.5 times the regular wage rate. - All salaried employees are exempt employees from overtime. - All employees are paid weekly on Friday for the previous week (which runs from Sunday through Saturday). Employees never work on weekends. - The SUTA tax rate applicable to Eagle Corp. is 0.6% and the SUTA wage base in Ohio is $7,000. - The income tax withholding for the State of Ohio is 3% of each employee's taxable pay (which is the is the same as taxable pay for federal withholding). - All tax payments and filings are made on the due date. - When calculating federal income tax withholding, use the withholding tables where possible, and refer to the percentage method only when necessary. Use tax tables found on pages T-1 to T-34 found at the back of your textbook. - The income tax withholding for City of Springfield is 2.3% of each employee's gross pay before deductions (which is the same as Medicare wages). - The company is closed for the holidays from December 26 through December 31. - All charitable contributions are deemed to be made on the final day of each pay period. - Everyone is paid using a direct deposit. There is no need for issuing a check number. Earnings and voluntary deduction information for each of the four employees is as follows: The first 11 months of the year have passed. Payroll data for each of the five employees for the first three quarters of the year, as well as for the months of October and November, are as follows: Whun Park MAntan I Anas Ahan Ahano Fdith Smith Based on the data provided, you will complete the following: 1) Using the excel file labeled "Employee Earnings Records," complete the employee earnings records for December for each of the five employees. The top portion of each record is completed for you. Please remember that payroll is cash basis and not accrual basis. Also, it is based upon pay date. 2) Using the MS Excel file labeled "Payroll Registers," complete the payroll register for each weekly pay period during December. The following information will be required for the completion of these records for the three employees who are compensated via an hourly wage: WARNING! Keep in mind that tax liability and payment inounts are determined based on the weeldy pay dates: Eagle Corp. is a small business that is located at 10 Sheboygan Lane, Springfield, OH45504. Its federal Employer Identification Number is 99-9999999. The company president is Jihyo Park (telephone; 937-555-0073) and she signs all forms. The company does not name a third-party designee on any form. During 2022, five individuals are employed by Eagle Corp. These employees are as follows: Note that the following: - Mateo Lopez was hired in July 2022, and his first day of work was Friday, July 1. On his W-4, Mateo Lopez checked box 2c and left sections 3 and 4 blank. Mateo is a salaried employee that is exempt. - Due to unethical actions, Edith Smith was terminated. Her last day of work was on Monday, December 5. - To replace Edith Smith, Kiara Murphy was hired and began working on Monday, December 18. On her W-4 form Kiara Murphy checked box 2 cand left sections 3 and 4 blank. - All employees of Eagle Corp. work a regular 40-hour workweek (thus hours worked over 40 in a given week are overtime hours) and receive overtime pay at a rate of 1.5 times the regular wage rate. - All salaried employees are exempt employees from overtime. - All employees are paid weekly on Friday for the previous week (which runs from Sunday through Saturday). Employees never work on weekends. - The SUTA tax rate applicable to Eagle Corp. is 0.6% and the SUTA wage base in Ohio is $7,000. - The income tax withholding for the State of Ohio is 3% of each employee's taxable pay (which is the is the same as taxable pay for federal withholding). - All tax payments and filings are made on the due date. - When calculating federal income tax withholding, use the withholding tables where possible, and refer to the percentage method only when necessary. Use tax tables found on pages T-1 to T-34 found at the back of your textbook. - The income tax withholding for City of Springfield is 2.3% of each employee's gross pay before deductions (which is the same as Medicare wages). - The company is closed for the holidays from December 26 through December 31. - All charitable contributions are deemed to be made on the final day of each pay period. - Everyone is paid using a direct deposit. There is no need for issuing a check number. Earnings and voluntary deduction information for each of the four employees is as follows: The first 11 months of the year have passed. Payroll data for each of the five employees for the first three quarters of the year, as well as for the months of October and November, are as follows: Whun Park MAntan I Anas Ahan Ahano Fdith Smith Based on the data provided, you will complete the following: 1) Using the excel file labeled "Employee Earnings Records," complete the employee earnings records for December for each of the five employees. The top portion of each record is completed for you. Please remember that payroll is cash basis and not accrual basis. Also, it is based upon pay date. 2) Using the MS Excel file labeled "Payroll Registers," complete the payroll register for each weekly pay period during December. The following information will be required for the completion of these records for the three employees who are compensated via an hourly wage: WARNING! Keep in mind that tax liability and payment inounts are determined based on the weeldy pay dates