The payroll records of Brownlee Company provided the following information for the weekly pay period ended...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
The payroll records of Brownlee Company provided the following information for the weekly pay period ended March 23, 20¹ Required: 1. Enter the relevant information in the proper columns of a payroll register and complete the register; calculate CPP and El deductions. Charge the wages of Kathy Sousa to Office Wages Expense and the wages of the remaining employees to Service Wages Expense. Calculate income tax deductions at 20% of gross pay. Employees are paid an overtime premium of 50% for all hours in excess of 40 per week. (Round your intermediate calculations and final answers to 2 decimal places. Leave no cells blank.) Payroll Week Ended March 23, 2018 Employees Ray Loran Kathy Sousa Gary Smith Nicole Parton Diana Wood Employee 1 2 3 4 5 No. Employment Insurance 27.56 X 24.57✔ 25.23 27.22 29.28 X ***** 11 12 13 14 15 M 7 8 CPP 8 0 T 8 8 8 8 8 Daily Time T 6 0 39.75 X 42.44 x 20.96 X 31.55 X 35.47 x W 8 8 8 8 6 Income Tax F 8 8 8 332.10 X 296.00 304.00 328.00 352.80 x SS 4 4 0 8 8 4 0 4 0 8 Hospital Insurance 0 *Red text indicates no response was expected in a cell or a formula-based calculation is incorrect; no points deducted. Total Hours 41.00✔ 3 3 3 3 3 40.00✓ 40.00✔ 46.00 46.00 46.00 46.00 46.00 133.86 170.17 1,612.90 230.00 *Red text indicates no response was expected in a cell or a formula-based calculation is incorrect; no points deducted. 40.00✔ 44.00✔ Union Dues 22.00 22.00 20.00 21.00 20.00 105.00 Payroll Register O.T. Hours 1.00 * * * * * 4.00✔ Total Deductions Reg. Pay Rate 2,251.93 41.00 37.00 38.00 41.00 42.00 467.42 x 431.00 x 416.19 X 453.77 x 483.55 X Hospital Insurance 46.00 46.00 46.00 46.00 46.00 230.00 Net Pay 1,193.08 x 1,049.00 X 1,103.81 x 1,186.23 X 1,280.45 x 5,812.57 Union Dues 22.00 22.00 20.00 21.00 20.00 105.00 Office Wages Expense 1,480.00 1,480.00 Earnings to End of Previous Week 43,600 46,600 24,000 35,000 Your disk is almost Save space by optim 39,000 Service Wages Expense Regular Pay 1,640.00 X 1,480.00✔ 1,520.00✔ 1,640.00✔ 1,680.00 x 7,960.00 1,660.50 x 1,520.00 1,640.00 1,764.00 x 6,584.50 The payroll records of Brownlee Company provided the following information for the weekly pay period ended March 23, 20¹ Required: 1. Enter the relevant information in the proper columns of a payroll register and complete the register; calculate CPP and El deductions. Charge the wages of Kathy Sousa to Office Wages Expense and the wages of the remaining employees to Service Wages Expense. Calculate income tax deductions at 20% of gross pay. Employees are paid an overtime premium of 50% for all hours in excess of 40 per week. (Round your intermediate calculations and final answers to 2 decimal places. Leave no cells blank.) Payroll Week Ended March 23, 2018 Employees Ray Loran Kathy Sousa Gary Smith Nicole Parton Diana Wood Employee 1 2 3 4 5 No. Employment Insurance 27.56 X 24.57✔ 25.23 27.22 29.28 X ***** 11 12 13 14 15 M 7 8 CPP 8 0 T 8 8 8 8 8 Daily Time T 6 0 39.75 X 42.44 x 20.96 X 31.55 X 35.47 x W 8 8 8 8 6 Income Tax F 8 8 8 332.10 X 296.00 304.00 328.00 352.80 x SS 4 4 0 8 8 4 0 4 0 8 Hospital Insurance 0 *Red text indicates no response was expected in a cell or a formula-based calculation is incorrect; no points deducted. Total Hours 41.00✔ 3 3 3 3 3 40.00✓ 40.00✔ 46.00 46.00 46.00 46.00 46.00 133.86 170.17 1,612.90 230.00 *Red text indicates no response was expected in a cell or a formula-based calculation is incorrect; no points deducted. 40.00✔ 44.00✔ Union Dues 22.00 22.00 20.00 21.00 20.00 105.00 Payroll Register O.T. Hours 1.00 * * * * * 4.00✔ Total Deductions Reg. Pay Rate 2,251.93 41.00 37.00 38.00 41.00 42.00 467.42 x 431.00 x 416.19 X 453.77 x 483.55 X Hospital Insurance 46.00 46.00 46.00 46.00 46.00 230.00 Net Pay 1,193.08 x 1,049.00 X 1,103.81 x 1,186.23 X 1,280.45 x 5,812.57 Union Dues 22.00 22.00 20.00 21.00 20.00 105.00 Office Wages Expense 1,480.00 1,480.00 Earnings to End of Previous Week 43,600 46,600 24,000 35,000 Your disk is almost Save space by optim 39,000 Service Wages Expense Regular Pay 1,640.00 X 1,480.00✔ 1,520.00✔ 1,640.00✔ 1,680.00 x 7,960.00 1,660.50 x 1,520.00 1,640.00 1,764.00 x 6,584.50
Expert Answer:
Answer rating: 100% (QA)
1 Completion of the Payroll Register for the payroll week ended March 23 2018 Employees Ray Loran Ka... View the full answer
Related Book For
Fundamental Accounting Principles Volume 1
ISBN: 9781259259807
15th Canadian Edition
Authors: Kermit Larson, Tilly Jensen, Heidi Dieckmann
Posted Date:
Students also viewed these accounting questions
-
The payroll records of Brownlee Company provided the following information for the weekly pay period ended March 23, 2015: Required 1. Enter the relevant information in the proper columns of a...
-
The payroll records of Brownlee Company provided the following information for the weekly pay period ended March 23, 2018: Required 1. Enter the relevant information in the proper columns of a...
-
Assume that a trader in HSBS has bought EUR 10,000,000 on Feb 03, 2020. Estimate one day VAR with a 95% confidence interval for the FX position with the Historical Simulation approach. Compose some...
-
An electric switch manufacturing company has to choose one of three different assembly methods. Method A will have a first cost of $40,000, an annual operating cost of $9000, and a service life of 2...
-
What is the difference between a full-service merchant wholesaler and a limited-service merchant wholesaler?
-
The following question concerns auditor's reports other than unqualified reports. Choose the best response. a.If an auditor issues an adverse auditor's report when there is a very material...
-
For each of the following situations, indicate the amount of revenue that the government should recognize in an appropriate governmental fund as well as in its government-wide statement of activities...
-
Using the following accounts and their? balances, prepare thetrial balance for Connor Furniture Repair as of December 31, 2024.All accounts have normal balances. 2 answers
-
1. What is your assessment of the financial performance of Nelson Nurseries? 2. Do you agree with Christine Barton?s accounts-payable policy? 3. What explains the erosion of the cash balance? 4. What...
-
Since 1975, Omega Corporation has produced high quality watches for men and women. Currently, Omega sells a silver watch for $408.00. The unit product cost for this silver watch is $263.00 as shown...
-
Are the actions of the TheDarkOverlord Solutions in this case (hacking into the schools district's servers and stealing data, sending threatening e-mails to students and parents, and demanding money...
-
Javon is in a 22% tax bracket for his federal income tax. If the amount of money that he paid for federal income tax was $16,060, what was his taxable income? Javon's taxable income was $ 5
-
Sheldon saw the same commercial that Leonard saw in Leonard v. Pepsico, Inc. He wanted the Pepsi leather jacket for 1,450 Pepsi pointswhich he could earn by purchasing 1,450 individual Pepsi bottles...
-
In June 1997, Matt decided to rob a store and asked Jeff to be his driver. Knowing that Matt had served time in prison on two-armed robbery convictions, and too afraid of Matt to refuse, Jeff drove...
-
IMF Distribution, Inc had Retained Earnings of $4,925 at the beginning of the year. At the end of the year, the Retained Earnings account balance is $5,498. The Net Income for the year is $938. What...
-
check my solve in part a and i need answer for part b thanks Brook's Window Shields Incorporated is trying to calculate its cost of capital for use in a capital budgeting decision. Mr. Glass, the...
-
During 2012, Cheng Book Store paid $483,000 for land and built a store in Georgetown. Prior to construction, the city of Georgetown charged Cheng $1,300 for a building permit, which Cheng paid. Cheng...
-
As a co-op student, you are working as an accounts receivable clerk at Asian Foods. The controller asks you to record a customer payment from Liu and Li Co. The sales invoice is dated October 1, 2017...
-
Elena Bellisario began a new consulting firm on January 3. The accounting equation showed the follow- ing transactions. Analyze the equation and describe each of the transactions with their amounts....
-
On January 1, 2017, Taco Taqueria, a Mexican restaurant, purchased equipment for $12,000 cash. Taco Taqueria estimates that the equipment will last five years (useful life). The restaurant expects to...
-
Moontan Ltd has an operating profit for the year ended 31 December 2002, before dealing with the following items, of 200,000. Complete the profit and loss account. (a) The standard rate of income tax...
-
Camden Lock Ltd has just finished its second year of trading to 31 December 2007. Balances from Question need to be brought forward into this question. Tax rates are the same as for 2006. The...
-
Corporation tax for the tax years 2007, 2008, and 2009 was 40 per cent and income tax foreach year was 20 per cent. (A) Skim-Ltds draft profit and loss account for the year ended 31 December 2008...
Study smarter with the SolutionInn App