ACCT 2200 Assignment Payroll Register and Journal Entries For the following employer prepare an appropriate register...
Fantastic news! We've Found the answer you've been seeking!
Question:
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/05/664899292785c_8326648992880939.jpg)
Transcribed Image Text:
ACCT 2200 Assignment Payroll Register and Journal Entries For the following employer prepare an appropriate register and journal entries using an Excel spreadsheet. Ralph's Enterprise has two salaried and three hourly employees in Halifax, as follows: TD1 Fed TD1 NS Pay Rate Basis Hours Department Lavern 1 1 $120,000 Annual Sales Imanuel 2 2 $2,500 Month Office Bill 3 3 $18.00 Hour 90 Office Elda 4 4 $15.00 Hour 80 Sales Jian 5 5 $17.50 Hour 89 Sales The payroll is processed for all employees on a bi-weekly basis and this payroll is for the two weeks ending January 8, 2023. There will be 26 regular pays in the year. Note that the hours are a total for the two-week period and include 8 non-worked hours at straight time rate for the New Year's Day holiday. The business records Statutory Holiday in a separate expense account than Wages and Salaries expense. Ralph's Enterprise pays overtime at hours greater than 40 hours. Assume that the hours shown above were spread equally over each of the weeks. The employer pays 4% vacation to hourly employees with each pay and accrues 6% for salaried employees. The current year Workers' Compensation premiums are at $2.50 per $100 of assessable earnings. Hourly paid employees are members of a Union with dues per week equal to one hour's regular rate of pay. All employees contribute $2.00 per pay to the "Sunshine Club" through payroll deduction. All employees are between the ages of 20 and 60. The calculation of statutory deductions should be done by using the CRA tables. Your printed report should be formatted for single page printing, ensure that your name and student number is shown on the report. ACCT 2200 Assignment Payroll Register and Journal Entries For the following employer prepare an appropriate register and journal entries using an Excel spreadsheet. Ralph's Enterprise has two salaried and three hourly employees in Halifax, as follows: TD1 Fed TD1 NS Pay Rate Basis Hours Department Lavern 1 1 $120,000 Annual Sales Imanuel 2 2 $2,500 Month Office Bill 3 3 $18.00 Hour 90 Office Elda 4 4 $15.00 Hour 80 Sales Jian 5 5 $17.50 Hour 89 Sales The payroll is processed for all employees on a bi-weekly basis and this payroll is for the two weeks ending January 8, 2023. There will be 26 regular pays in the year. Note that the hours are a total for the two-week period and include 8 non-worked hours at straight time rate for the New Year's Day holiday. The business records Statutory Holiday in a separate expense account than Wages and Salaries expense. Ralph's Enterprise pays overtime at hours greater than 40 hours. Assume that the hours shown above were spread equally over each of the weeks. The employer pays 4% vacation to hourly employees with each pay and accrues 6% for salaried employees. The current year Workers' Compensation premiums are at $2.50 per $100 of assessable earnings. Hourly paid employees are members of a Union with dues per week equal to one hour's regular rate of pay. All employees contribute $2.00 per pay to the "Sunshine Club" through payroll deduction. All employees are between the ages of 20 and 60. The calculation of statutory deductions should be done by using the CRA tables. Your printed report should be formatted for single page printing, ensure that your name and student number is shown on the report.
Expert Answer:
Posted Date:
Students also viewed these accounting questions
-
Is astrology scientific? The University of Chicago's General Social Survey (GSS) is the nation's most important social science sample survey. The GSS asked a random sample of adults their opinion...
-
Why would the number of shares issued be different from the number of shares outstanding?
-
How does loan portfolio risk differ from individual loan risk?
-
We want to solve Example 13-6 with a multicomponent computer program similar to absorption and stripping programs. Set up the tridiagonal matrix for the mass balances assuming there are six stages in...
-
1. What personality and behavior characteristics does Henry Rankin exhibit? Do you think these traits contribute to a good personjob fit for him? If you were an executive coach hired to help Rankin...
-
Tina buys a put option on Tesla stock with a price of 4 , a strike price of $ 4 0 , and expiration date in December. The breakeven stock price is closet to the - share profit is closet to 1 minity 2...
-
This week as part of your lab you were asked to update the text on the template website to meet your needs. Describe your experience with writing that text. Was it easy, difficult, or somewhere in...
-
Managers of multi-unit properties within the same chain can compare operating results across the units they manage. What do you think are some reasons financial performance and profitability could...
-
Why did you not include the benefits in the cost per hour calculation, why is that separated out? Also, were any of the overhead costs fixed in nature? For example the utilities, were they 100% tied...
-
A business paid a $ 7 2 0 subscription to a trade magazine on 3 0 June 2 0 0 0 , for the two years to 1 July 2 0 0 2 . The business's financial year ends on 3 0 November 2 0 0 0 . What relevant...
-
Where are control accounts located in the WBS? Major Deliverables WBS Dictionary Planning Packages One level above work packages Level 1
-
In details, explain how contract accounting can be used to solve a number of problems related to different sectors of a business entity.
-
In this assignment, you are to estimate a security market line. You have current information about beta and expected annual return on 5 assets, as given in the following table: Beta Expected return...
-
10m solution. If Ka(HA) = 10 then pOH of solution will be [Given : log4=0.6] (A) 6.7 (B) Greater than 6.7 & less than 7.0 (C) Greater 7.0 & less than 7.3 (D) Greater than 7.3
-
Rough Trails Bicycle Company manufactures mountain bikes. The following data for March of the current year are available: Determine the direct labor rate and time variances.. Quantity of direct labor...
-
Curtis Container Company (CCC) manufactures plastic 2-liter bottles for the beverage industry. The cost standards per 100 2-liter bottles are as follows: At the beginning of May, CCC management...
-
Cherokee Wood Products Company prepared the following factory overhead cost budget for the Press Department for August of the current year, during which it expected to require 6,000 hours of...
![Mobile App Logo](https://dsd5zvtm8ll6.cloudfront.net/includes/images/mobile/finalLogo.png)
Study smarter with the SolutionInn App