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