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...
-
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...
-
Two phenotypically normal parents produce a phenotypically abnormal child in which chromosome 5 is missing part of its long arm but has a piece of chromosome 7 attached to it. The child also has one...
-
The General Social Survey reported that in a sample of 68 men aged 1825, the mean number of hours of television watched per day was 2.76 with a standard deviation of 2.21. In a sample of 72 women...
-
On January 1, 2014, Plains Power Company overhauled four turbine engines that generate power for customers. The overhaul resulted in a slight increase in the capacity of the engines to produce power....
-
An epicyclic gear train shown in Fig. 15.29, consists of two sun wheels A and D with 28 and 24 teeth respectively, engaged with a compound planet wheels B and C with 22 and 26 teeth. The sun wheel D...
-
Obtain v(t) and i(t) for t > 0 in the circuit in Fig. 16.54 . 5 H ll i(t) 24 V (+ 10u(t) v(t) 200 mF
-
Develop the following of the new OHL expansion team . 1) Ticket marketing of OHL expansion team 2) Determine key targets of OHL expansion team : Demographic information Geo-market information...
-
Distinguish between flow of an ideal gas and inviscid flow of a fluid.
-
An airplane flies at \(150 \mathrm{~km} / \mathrm{hr}\). (a) The airplane is towing a banner that is \(b=0.8 \mathrm{~m}\) tall and \(\ell=25 \mathrm{~m}\) long. If the drag coefficient based on area...
-
Outline the effects on the market rate of interest and the welfare implications for borrowers and savers of (a) an increase in desired savings and (b) an increase in desired investment.
-
An ideal gas flows with velocity \(V\), pressure \(p\), temperature \(T\), and density \(ho\). Determine a set of equations for stagnation properties, including entropy, if the stagnation process is...
-
Commercial airliners normally cruise at relatively high altitudes \((30,000\) to \(35,000 \mathrm{ft}\) ). Discuss how flying at this high altitude (rather than 10,000 ft, for example) can save fuel...
-
3% corporate tax rate total tax rate 12% income generated is 140000.00 personal tax credit of 7842 and requires 75000.00 before tax for living expenses and wants to maximize cpp contributions. salary...
-
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...
-
The adjusted trial balance of Marshall Ltd. at December 31, 2020. Requirements 1. Prepare Marshall Ltd.'s 2020 income statement, statement of retained earnings, and balance sheet. List expenses...
-
Fred's Catering Ltd. had the following selected transactions during May 2020: Requirements 1. Show how each transaction would be handled using the cash basis and the accrual basis, Under each column,...
-
The balance sheet at December 31, 2018, 2019) and 2020 and income statement for the years ended December 31, 2018, 2019, and 2020 for Ojibway Inc. include the following data: Requirements Use the...
Study smarter with the SolutionInn App