Problem 10.3A Computing gross earnings, determining deductions, preparing payroll register, journalizing payroll transactions. LO 10-2, 10-3, 10-4, 10-5 Alexander Wilson operates Metroplex Courier and Delivery Service. He has four employees who are paid on an hourly basis. During the workweek beginning December 15 and ending December 21, 2019, his employees worked the number of hours shown below. Information about their hourly rates, marital status, and withholding allowances also appears below, along with their cumulative earnings for the year prior to the December 1521 payroll period. Consider any hours worked beyond 40 in the week as overtime hours and overtime pay at one and one-half times their regular hourly rate. Employee Gloria Bahamon Alex Garcia Ron Price Sara Russell Hours Regular Marital Withholding Cumulative Worked Hourly Rate Status Allowances Earnings 47 $16.70 $32,860 43 28.50 57,300 49 26.90 M 53,972 40 13.70 S 26,620 Required: 2. Compute the regular, overtime, and gross earnings for each employee. Enter the figures in the payroll register. 3. Compute the amount of social security tax to be withheld from each employee's gross earnings. Assume a 6.2 percent social security rate on the first $122,700 earned by the employee during the year. Enter the figures in the payroll register. 4. Compute the amount of Medicare tax to be withheld from each employee's gross earnings. Assume a 1.45 percent Medicare tax rate on all salaries and wages earned by the employee during the year. Enter the figures in the payroll register. 5. Determine the amount of federal income tax to be withheld from each employee's total earnings. Use the tax tables in Figure 10.2a & Figure 10.2b to determine the withholding for Russell. Withholdings are $112.00 for Bahamon, $323.00 for Garcia, and $258 for Price. Enter the figures in the payroll register. 6. Compute the net amount due each employee and enter the figures in the payroll register. 7. Total and prove the payroll register. Bahamon and Russell are office workers. Garcia and Price are delivery workers. 8. Prepare a general journal entry to record the payroll for the week ended December 21, 2019. 9. Prepare a general journal entry on December 23 to summarize payment of wages for the week. Analyze: What percentage of total taxable wages was delivery wages? Answer is not complete. Complete this question by entering your answers in the tabs below. Payroll Register General Journal Analyze Compute the regular, overtime, gross earnings; social security tax and Medicare tax to be withheld from each employee's earnings. Assume a 6.2 percent social security rate on the first $122,700 earned by the employee during the year. Assume a 1.45 percent Medicare tax rate on all salaries and wages earned by the employee during the year. Determine the amount of federal income tax to be withheld from each employee's total earnings. (Use the table shown in Figure 10.2A & Figure 10.2B whichever is applicable) to determine the withholding for Russell. Withholdings for Bahamon is $112.00, $323.00 for Garcia, and $258 for Price. Finally compute the net amount due of each employee. (Bahamon and Russell are office workers. Garcia and Price are delivery workers.) (Round your intermediate calculations and final answers to 2 decimal places.) Show less Payroll Register Paid: December 23, 2019 Distribution And ending: December 21, 2019 Taxable wages Deductions Social Social Medicare Medicare security security Cumulative earnings Employee Income tax Net amount Office wages Delivery wages Gloria Week Beginning: December 15, 2019 Earnings Regular Overtime Gross time earnings earnings earnings $ 668.00 $ 175.35 $ 843.35 1,140.00 128.25 1,268.25 1,076.00 363.15 1,439.15 548.00 0.00 548.00 $3,432.00 $ 666.75 $ 4,098.75 $ $ $ $ 843.35 Bahamon Alex Garcia Ron Price Sara Russell $ 32,860.00 57,300.00 53,972,00 26,620.00 $ 170,752.00 $ 843.35 1,268,25 1,439.15 548.00 $ 4,098.75 $ 843.35 1,268.25 1,439.15 548.00 $ 4,098.75 52.29 78.63 89.23 33.98 254.13 12.23 18.39 20.87 .95 59.44 $ 112.00 323.00 258.00 67.00 $ 760.00 666.83 848.23 1,071.05 439.07 3,025.18 1,268.25 1,439.15 7 548.00 20424 $ $ $ $2,707.40 Payroll Register General Journal > Journal entry worksheet Record the company's payroll to be paid at a later date. Note: Enter debits before credits. General Journal Debit Credit Date Dec 21, 2019 Record entry Clear entry View general journal Journal entry worksheet Problem 10.3A Computing gross earnings, determining deductions, preparing payroll register, journalizing payroll transactions. LO 10-2, 10-3, 10-4, 10-5 Alexander Wilson operates Metroplex Courier and Delivery Service. He has four employees who are paid on an hourly basis. During the workweek beginning December 15 and ending December 21, 2019, his employees worked the number of hours shown below. Information about their hourly rates, marital status, and withholding allowances also appears below, along with their cumulative earnings for the year prior to the December 1521 payroll period. Consider any hours worked beyond 40 in the week as overtime hours and overtime pay at one and one-half times their regular hourly rate. Employee Gloria Bahamon Alex Garcia Ron Price Sara Russell Hours Regular Marital Withholding Cumulative Worked Hourly Rate Status Allowances Earnings 47 $16.70 $32,860 43 28.50 57,300 49 26.90 M 53,972 40 13.70 S 26,620 Required: 2. Compute the regular, overtime, and gross earnings for each employee. Enter the figures in the payroll register. 3. Compute the amount of social security tax to be withheld from each employee's gross earnings. Assume a 6.2 percent social security rate on the first $122,700 earned by the employee during the year. Enter the figures in the payroll register. 4. Compute the amount of Medicare tax to be withheld from each employee's gross earnings. Assume a 1.45 percent Medicare tax rate on all salaries and wages earned by the employee during the year. Enter the figures in the payroll register. 5. Determine the amount of federal income tax to be withheld from each employee's total earnings. Use the tax tables in Figure 10.2a & Figure 10.2b to determine the withholding for Russell. Withholdings are $112.00 for Bahamon, $323.00 for Garcia, and $258 for Price. Enter the figures in the payroll register. 6. Compute the net amount due each employee and enter the figures in the payroll register. 7. Total and prove the payroll register. Bahamon and Russell are office workers. Garcia and Price are delivery workers. 8. Prepare a general journal entry to record the payroll for the week ended December 21, 2019. 9. Prepare a general journal entry on December 23 to summarize payment of wages for the week. Analyze: What percentage of total taxable wages was delivery wages? Answer is not complete. Complete this question by entering your answers in the tabs below. Payroll Register General Journal Analyze Compute the regular, overtime, gross earnings; social security tax and Medicare tax to be withheld from each employee's earnings. Assume a 6.2 percent social security rate on the first $122,700 earned by the employee during the year. Assume a 1.45 percent Medicare tax rate on all salaries and wages earned by the employee during the year. Determine the amount of federal income tax to be withheld from each employee's total earnings. (Use the table shown in Figure 10.2A & Figure 10.2B whichever is applicable) to determine the withholding for Russell. Withholdings for Bahamon is $112.00, $323.00 for Garcia, and $258 for Price. Finally compute the net amount due of each employee. (Bahamon and Russell are office workers. Garcia and Price are delivery workers.) (Round your intermediate calculations and final answers to 2 decimal places.) Show less Payroll Register Paid: December 23, 2019 Distribution And ending: December 21, 2019 Taxable wages Deductions Social Social Medicare Medicare security security Cumulative earnings Employee Income tax Net amount Office wages Delivery wages Gloria Week Beginning: December 15, 2019 Earnings Regular Overtime Gross time earnings earnings earnings $ 668.00 $ 175.35 $ 843.35 1,140.00 128.25 1,268.25 1,076.00 363.15 1,439.15 548.00 0.00 548.00 $3,432.00 $ 666.75 $ 4,098.75 $ $ $ $ 843.35 Bahamon Alex Garcia Ron Price Sara Russell $ 32,860.00 57,300.00 53,972,00 26,620.00 $ 170,752.00 $ 843.35 1,268,25 1,439.15 548.00 $ 4,098.75 $ 843.35 1,268.25 1,439.15 548.00 $ 4,098.75 52.29 78.63 89.23 33.98 254.13 12.23 18.39 20.87 .95 59.44 $ 112.00 323.00 258.00 67.00 $ 760.00 666.83 848.23 1,071.05 439.07 3,025.18 1,268.25 1,439.15 7 548.00 20424 $ $ $ $2,707.40 Payroll Register General Journal > Journal entry worksheet Record the company's payroll to be paid at a later date. Note: Enter debits before credits. General Journal Debit Credit Date Dec 21, 2019 Record entry Clear entry View general journal Journal entry worksheet