The Scenario: You work for Metroid Insurance Co at the front desk and are responsible for creating the pay cheques for all employees. This company pays its employees bi-weekly, and the staff provide you with their time sheets at the end of the week on Sundays for the following Friday payment. All cheques are signed by the president of your company Elizabeth Edwards. Each of the following employees are paid by direct deposit: Evan Elliott - This employee receives a salary of $60,000 a year for a 41.25-hour work week. This pay includes 7 hours overtime paid out at a rate of time and a half Emma Ellis - Worked 24 hours and fifteen minutes in week 1, and 24 hours and forty-five minutes in week 2 and is paid a rate of $13.75 per hour The following employee is paid by commission: Easton Earnhardt (paid by cheque) - sold a total of $60,000 in life insurance policies during the period and earns 1.93% in commission. Each employee (hourly or commission) has the following deductions: CPP-5.70% EI - 1.58% Taxes -15% 2 MATH1034 - EXCEL PROJECT - PART 2 1400 AILL The Scenario: You work for Metroid Insurance Co at the front desk and are responsible for creating the pay cheques for all employees. This company pays its employees bi-weekly, and the staff provide you with their time sheets at the end of the week on Sundays for the following Friday payment. All cheques are signed by the president of your company Elizabeth Edwards. Each of the following employees are paid by direct deposit: Evan Elliott - This employee receives a salary of $60,000 a year for a 41.25-hour work week. This pay includes 7 hours overtime paid out at a rate of time and a half Emma Ellis - Worked 24 hours and fifteen minutes in week 1, and 24 hours and forty-five minutes in week 2 and is paid a rate of $13.75 per hour The following employee is paid by commission: Easton Earnhardt (paid by cheque) - sold a total of $60,000 in life insurance policies during the period and earns 1.93% in commission. Each employee (hourly or commission) has the following deductions: CPP-5.70% EI - 1.58% Taxes -15% 2 MATH1034 - EXCEL PROJECT - PART 2 1400 AILL