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...
-
1. Review the definitions of earnings management by Schipper, Healy and Whalen, Dechow and Skinner, and McKee that are discussed in this chapter. How would you characterize the proposed accrual for...
-
For each blank select one entry from the corresponding column of choices. Fill all blanks in the way that best completes the text. The ____(i)____ of medieval papal power was the pontificate of...
-
Use technology and the data in RestaurantTips to construct a graph of the relationship between Server and Credit for the situation in Exercise 2.38. Data From Exercise 2.38: Credit Card by Server The...
-
Suresh Co. expects its five departments to yield the following income for next year. Recompute and prepare the departmental income statements (including a combined total column) for the company under...
-
Assume you are considering buying a Food truck to sell food at local events. The equipped truck costs $24,000.00, and has an expected salvage value of $5,000.00 at the end of an expected 10 year...
-
Janice Morgan, age 24, is single and has no dependents. She is a freelance writer. In January 2021, Janice opened her own office located at 2751 Waldham Road, Pleasant Hill, NM 88135. She called her...
-
Question Three: The following income statement was prepared for RAT Co. for the year ended 31/12/2015. Sales (640,000) Cost of goods old 500,000 Selling expenses 36000 Administrative expenses 30000...
-
Where must revenue legislation originate?
-
Fill in the blanks to make the following statements correct. Answer these questions in the sequence given. a. Suppose the Bank of Canada purchases a \(\$ 100 0\) bond from Bob's Financial Firm, and...
-
Explain the relationship between a probability distribution and a sampling distribution.
-
Redo Exercise 11.44, this time assuming Et = 100 + 1.5Yt + 0.2Yt1. Exercise 11.44 Consider this income-expenditure model: where Y is aggregate income and E is aggregate spending. Is this model...
-
Define strategic compensation.
-
Consider the example of ''marketing gone wrong" and answer the following questions: How can learning about the target market before making any marketing plans help to avoid these kind of failures? Be...
-
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...
-
Show that the Fourier transform of a conjugate antisymmetric sequence is imaginary.
-
Solve Exercise 1.22 using the concept of the transfer function. Exercise 1.22 Compute the inverse Fourier transform of \[X\left(\mathrm{e}^{\mathrm{j} \omega} ight)=\frac{1}{1-\mathrm{e}^{-\mathrm{j}...
-
We define the even and odd parts of a complex sequence \(x(n)\) as \[\mathcal{E}\{x(n)\}=\frac{x(n)+x^{*}(-n)}{2} \quad \text { and } \quad \mathcal{O}\{x(n)\}=\frac{x(n)-x^{*}(-n)}{2}\]...
Study smarter with the SolutionInn App