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...
-
Lymbo Company, Inc., must install safety devices throughout its plant or it will lose its insurance coverage. Two alternatives are acceptable to the insurer. The first costs $100,000 to install and...
-
Check each data set for outliers. a. 46, 28, 32, 21, 25, 29, 34, 19 b. 82, 100, 97, 93, 89, 90, 65, 94, 101 c. 527, 1007, 489, 371, 175
-
Akur and Aifiti share profits on a 45:55 basis respectively. On 1 July 2025 the equity accounts were as follows. The partners were entitled to 8% interest on capital. Aifiti ran the business and...
-
Use the information for Prosperous Bank in Exercise 25 to compute the total cost for each revenue-generating area using the algebraic method.
-
17. Moment of inertia (M.I) of four bodies, having same mass and radius, and reported as: I1 = M.I. of thin circular ring about its diameter 18. 12 = M.I. of circular disc about an axis perpendicular...
-
On December 1, Year 1, John and Patty Driver formed a corporation called Susquehanna Equipment Rentals. The new corporation was able to begin operations immediately by purchasing the assets and...
-
0 es A retailer pays $170,000 rent each year for its two-story building. Space in this building is occupied by five departments as shown here. Department Jewelry Cosmetics Department Housewares Tools...
-
For locations that have no electric service, companies are designing bicycle-powered generators that are nearly 100% efficient that can be used to charge cell phones or power lights. If you are the...
-
If you leave a fan running, it actually warms up the air in the room, a fact that surprises many people. Explain why a fan would be expected to warm the air that passes through it.
-
When you grind wheat to make flour, the flour comes out very warmyou can actually scorch the flour if you grind too quickly. Explain how this temperature rise comes about.
-
When you skid to a stop on your bike, you can significantly heat the small patch of tire that rubs against the road surface. Suppose a person skids to a stop by hitting the brake on his back tire,...
-
Living creatures generally have a higher temperature than their environment. Explain why this makes sense.
-
Apex Inc. started their first month of operation on January1st, 2022 and the trial balance at end of January is shown below. Required: Make adjustments through journal entries of the above as of...
-
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...
-
Eliza Perry obtained registration to practice as an aesthetic nurse, and spent the month of July 2024 setting up her business E. Perry, Naturals. Eliza prepared a new statement of financial position...
-
Financial balances for the car hire business of Terry's Wedding Cars on 31 March 2024 are provided below in a table in accounting equation form similar to the chapter illustrations. During April, the...
-
Trans Clothing Alterations began operations on 1 August 2024 and completed the following transactions during the first month. 1. Tran deposited \($18\) 000 of her personal funds in a current account...
Study smarter with the SolutionInn App