Your task is to prepare/calculate monthly payroll, based on the data provided. The attached excel sheet has
Fantastic news! We've Found the answer you've been seeking!
Question:
- Your task is to prepare/calculate monthly payroll, based on the data provided. The attached excel sheet has a data for 6 months (January – June 2019). To prepare payroll for the next 6 months (July to December), increase 10% salary/hourly rate and 15% in the monthly hours (only for the employee paid on hourly rates) Calculate Payroll including Federal Tax, Provincial Tax, EI and CPP.
Personal Information | Pay Information | Hours Worked | ||||||||
Employee No. | Status | Employee's Name | City | Province | Postel Code | Claim Code | Pay Type (S = Salary / H = Hourly) | Hourly Rate | Salary Per Pay (Annual salary divided by # of pays) | From Jul-19 to Dec-19) |
001 | Active | Francoise Rautenstrauch | Toronto | ON | M4C 3Y1 | 5 | S | $ - | $ 4,166.67 | NA |
002 | Active | Kendra Loud | Toronto | ON | M6P 2V5 | 1 | H | $ 15.00 | $ - | 160, 150, 130, 120, 150, 120 |
003 | Active | Hannah Edmison | Noth York | ON | M2J 3W5 | 1 | S | $ - | $ 3,333.33 | NA |
004 | Active | Queenie Kramarczyk | Burlington | ON | L7R 3Y8 | 5 | H | $ 20.00 | $ - | 123, 147, 187, 125, 160, 130 |
005 | Active | Lea Steinhaus | Mississauga | ON | L5C 1L3 | 5 | H | $ 18.00 | $ - | 145, 155, 132, 123, 151, 125 |
Related Book For
Management Science The Art of Modeling with Spreadsheets
ISBN: 978-1118582695
4th edition
Authors: Stephen G. Powell, Kenneth R. Baker
Posted Date: