For the following employer prepare an appropriate register and Journal entries using an Excel spreadsheet. Ralph's...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
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 Toronto, as follows: Basis Annual Department Sales Office Pay Rate $120,000 $2,500 $18.00 $15.00 $17.50 TD1 Fed TD1 ON Hours 1 Lavare Imran 1 Month Office 3 4 Hour Hour Hour 90 80 89 Bilal Elda Yue Sales Sales The payroll is processed for all employees on a bi-weekly basis and this payroll is for the two weeks ending January 11, 2020. There will be 26 regular pays in the year. Note that the hours are a total for the two week period and include 8 hours at straight time rate for the New Year's Day holiday. The business records Statutory Holiday in a separate account than Wages and Salaries expense. Ralph's Enterprise pays overtime at the minimum Ontario standard. 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 employer is not exempt for Ontario Health Tax and estimates current year W.S.I.B. premiums 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. 223 The payroll is processed for all employees on a bi-weekly basis and this payroll is for the two weeks ending January 11, 2020. There will be 26 regular pays in the year. Note that the hours are a total for the two week period and include 8 hours at straight time rate for the New Year's Day holiday. The business records Statutory Holiday in a separate account than Wages and Salaries expense. Ralph's Enterprise pays overtime at the minimum Ontario standard. 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 employer is not exempt for Ontario Health Tax and estimates current year W.S.I.B. premiums 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. 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 Toronto, as follows: Basis Annual Department Sales Office Pay Rate $120,000 $2,500 $18.00 $15.00 $17.50 TD1 Fed TD1 ON Hours 1 Lavare Imran 1 Month Office 3 4 Hour Hour Hour 90 80 89 Bilal Elda Yue Sales Sales The payroll is processed for all employees on a bi-weekly basis and this payroll is for the two weeks ending January 11, 2020. There will be 26 regular pays in the year. Note that the hours are a total for the two week period and include 8 hours at straight time rate for the New Year's Day holiday. The business records Statutory Holiday in a separate account than Wages and Salaries expense. Ralph's Enterprise pays overtime at the minimum Ontario standard. 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 employer is not exempt for Ontario Health Tax and estimates current year W.S.I.B. premiums 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. 223 The payroll is processed for all employees on a bi-weekly basis and this payroll is for the two weeks ending January 11, 2020. There will be 26 regular pays in the year. Note that the hours are a total for the two week period and include 8 hours at straight time rate for the New Year's Day holiday. The business records Statutory Holiday in a separate account than Wages and Salaries expense. Ralph's Enterprise pays overtime at the minimum Ontario standard. 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 employer is not exempt for Ontario Health Tax and estimates current year W.S.I.B. premiums 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:
Answer rating: 100% (QA)
Payroll register as at January 11th Sl No Employee Name Hours and earnings Deductions Others Net pay ... View the full answer
Related Book For
Financial Accounting
ISBN: 978-1118978085
IFRS 3rd edition
Authors: Jerry J. Weygandt, Paul D. Kimmel, Donald E. Kieso
Posted Date:
Students also viewed these accounting questions
-
A business issued a 90-day, 15% note for $91,000 to a creditor on account. Journalize the entries to record (a) the issuance of the note and (b) the payment of the note at maturity, including...
-
At year end an entity has 120 day note payable outstanding. The entity has followed the policy of replacing the note rather than repaying it over the last three years. The entity's treasurer says...
-
You are the newly appointed negotiator by Belmont Sutton Company to lead the negotiations which entail a deal of several million of turnover in favour of the organisation. You are provided with some...
-
Air temperature usually decreases with increasing altitude. However, during the winter, thanks to a phenomenon called thermal inversion, the temperature of air warmed by the sun in mountains above a...
-
College Students Weekly Earnings in Dollars (n = 5) (a) Make an Excel scatter plot. What does it suggest about the population correlation between X and Y? (b) Make an Excel worksheet to calculate...
-
Explain how the accounting for bad debts can be used for earnings management.
-
Many sample motions can be found using a basic web search. Search for an actual motion to continue a trial or hearing date pertaining to a civil case in California. The party moving to continue must...
-
I can get Mickey to download any data I need from the Web or our server to my PC, DeWitt Miwaye, an upper-level manager for Yumtime Foods (a Midwest food wholesaler), tells you. Getting data is no...
-
QUESTION 19 Titou Co.'s contribution format income statement for the most recent month is shown below: Total Per Unit Sales (42,000 units) $ Variable expenses Contribution margin Fixed expenses...
-
The Ploughman family owns and operates a 640-acre farm that has been in the family for several generations. The Ploughmans always have had to work hard to make a decent living from the farm and have...
-
Create a detailed synthesis on Human Behavior in Organizations ? and Impact of Transactional, Transformational and Laissez-Faire Leadership Styles on Motivation?
-
Determine the missing amount in each of the following cases: Stockholders' Assets Liabilities Equity $150,000 $92,000 $ 21,000 42,000 87,000 61,000
-
The speed of a car, s , can be estimated after a crash by using the formula s =30 df where d is the distance that the car skidded until a collision and f is the coefficient for friction which depends...
-
Annuity Payment $7,500.00 Discount Rate 5.50% Years 30 Calculate how much money Jessica will need to give to an insurance company for an annuity if she would like to receive $7,500 a year from the...
-
In the event of liquidation, HPI preferred stockholders are entitled to $ 3 0 . 5 0 plus accrued dividends. Does this mean that preferred stockholders will receive that amount? Discuss.
-
Solve for the missing item in the following. Principal Interest rate Time Simple interest EA $ 530 6% years $ 159
-
What educational tools did you like the most in Introduction to Hospitality course? what has been the most interesting topic and knowledge you learned and why? Explain and support your answer.
-
If |62x|>9, which of the following is a possible value of x? A. 2 B. 1 C. 0 D. 4 E. 7
-
Which of the following is false? (a) Under GAAP, companies cannot record gains on transactions involving their own shares. (b) Under IFRS, companies cannot record gains on transactions involving...
-
Huan Lee is reviewing the principle of segregation of duties. What are the two common applications of this principle?
-
Nestlé's financial statements are presented in Appendix B. Financial statements of Petra Foods are presented in Appendix C. Instructions (a) Based on the information contained in these...
-
The United States and the Commonwealth of Australia have long been strong and mutually supportive allies.1 However, the two countries close relationship was threatened recently by an international...
-
Explain why the Auditor General of Canada performs value-for-money audits rather than simply performing financial audits of the various government departments.
-
Jerome Kerviel was born and raised in Pont-lAbbe, a small coastal village in the Brittany region of northwestern France. His father was a blacksmith, while his mother worked as a hairdresser....
Study smarter with the SolutionInn App