Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please calculate pay for the following situations. Please show your work (ie/ if you're calculating pay, list the steps in how you got there or

image text in transcribed

Please calculate pay for the following situations. Please show your work (ie/ if you're calculating pay, list the steps in how you got there or show formulas in excel) and explain your reasoning for each situation. Please assume all employees work in Ontario. Marks assigned in brackets (10 total). 1. An hourly employee, employed with the company for 2 months, worked 6 hours on Canada Day. They make $18/hour and are paid out vacation at the ESA minimum. The last 6 weeks hours worked are as follows: Week Hours Worked Sunday, June 23 - Saturday, June 29 22.5 Sunday, June 16 - Saturday, June 22 Sunday, June 9 - Saturday, June 15 Sunday, June 2 - Saturday, June 8 Sunday, May 26 - Saturday, June 1 Sunday, May 19 - Saturday, May 25 (a) Calculate the amount of Statutory Holiday Pay (2) (b) Calculate the amount of Statutory Holiday Pay for Hours worked (1) (c) If the employee worked 25 hours for the week of Sunday, June 30 - Friday, July 6, inclusive of the hours worked on Canada Day, what would their gross pay be for the week? (2) (d) If the employee had been with the organization for 7 years, what would their gross pay be for the week of Sunday, June 30 - Friday, July 6? (1) 2. A salaried employee is hired mid payroll period at an organization that does payroll biweekly. They are hired at a compensation of $70,005 per annum with paid vacation. They work 7.5-hour days, 5 days a week. (a) How many biweekly pay periods are there in a year? (1) (b) What would the employee's biweekly salary be? (1) (c) If the employee was hired with only 3 days left of the pay period, what would their gross pay be for the biweekly pay period? (2) Note: I recommend this to be submitted as an excel file, many HR practitioners will use excel frequently, and this would be good practice to use excel to work on calculations

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Survey Of Accounting

Authors: Carl S. Warren

1st Edition

0538870850, 9780538870856

More Books

Students also viewed these Accounting questions