Task 2: Complete Preparations for Payroll System The following individuals are employed by North Park Stationery Supplies. Below are excerpts from their individual employee records as kept in the HR files. Use the information provided below to develop your category plan in Task PR2.1 Refer to the 2010 Clerk Awards for the employees' hourly rates. Address Malcolm John Hannah Maureen Jodie Maree Edward Leonard Stewart Scofield Stafford Morgan 22 Logan Rd 56 Stafford Rd 44 Kirby St 56 Pickering St Marsden QLD Enoggera Old 4132 Everton Park 4053 Arana Hills 4054 4051 07 3200 6785 07 3353 4653 07 3851 4532 07 3356 8000 Telephone Personal Details Date of Birth Gender 9th June 1988 Male 2nd May 1972 10th March 1990 6th October 1984 Male Female Female Ist September Ist April 2002 11th March 2013 2012 Start Date 6th October 2006 Permanent Part Time Mon 8hrs, Tues-Thu 7.5 hrs Clerical Award Level 4 Status Full time Full Time Clerical Award Level 1 Year 2 Casual Clerical Award Level 5 Classification Manager Wages, Super & Deductions Salary $75,000 pa Child Support 595 per pay Care Super $21.75 phr Ot 1.5 Car Allowance .78cents per km Sunsuper S32.75 phr After Tax Super S60 Care Super S25.18 phr Meal Allowance As per Award Sunsuper 773876 784426 865189 793341 Super Fund Membership Number Entitlements Holiday Pay Personal Leave Taxes TEN Yes Yes Yes Yes Yes Yes 678 234 145 781 442 621 965 872 568 782 456 556 Tax Free Threshold + HECS or HELP Tax Free Threshold No Tax Free Threshold Tax Free Threshold Tax Scale IN IN PR2.3 The manager, Malcolm Stewart, has instructed you to process the pay run and manually calculate the pays using the below information. The following is information for the first fortnight's pay run from the business's employee scheduling system: Full Time Casual Permanent PT Scofield Stafford Morgan Monday, 29 May IN IN Tuesday, 30 May IN IN Wednesday, 31 May PERSONAL Thursday, 1 June PERSONAL Friday, 2 June Saturday, 3 June Sunday, 4 June Monday, 5 June IN ANNUAL LEAVE Tuesday, 6 June IN Wednesday, 7 June IN OT-1 hr Thursday, 8 June IN OT-2 hrs Friday, 9 June IN Saturday, 10 June Sunday, 11 June IN IN IN IN IN IN IN IN IN IN IN Steps to take: a. Locate the timesheets on the following pages. b. Complete the timesheets for the first fortnight's pay run from 29th May 11th June by manually recording the information from the employee scheduling system in the business's timesheets. Guidance: Please enter any meal allowance as a count number (not dollars, ie entitled to one meal allowance so enter 1, two meals allowances enter 2) Into the Type column please use the abbreviations (A)nnual Leave, (Personal Leave. (PH) Public Holiday. Hannah Scofield travelled 65 kms for business purposes for the fortnight and Edward Morgan was entitled to one meal allowance when he worked overtime on Thursday Super (Y or JODIE STAFFORD No Tax-Free Threshold Rate $ per Qty Category hour Tax (Y or N) 35.5 Hours Ordinary Time 32.75 @ N) Value $ Y 1752.125 o Hours Overtime x1.5 |Y N o Hours Overtime x2.0 Y N Hours Personal Leave @ Hours Annual Leave Y Y Meal Allowance IN IN Kms Car Allowance IN TOTAL GROSS: Check maths PAYG Withholding: $464 Super Payable after tax $60 Superannuation on Wages: NET WAGE: $1062 Need to recalculate Jodie's pay, tax & super Task 2: Complete Preparations for Payroll System The following individuals are employed by North Park Stationery Supplies. Below are excerpts from their individual employee records as kept in the HR files. Use the information provided below to develop your category plan in Task PR2.1 Refer to the 2010 Clerk Awards for the employees' hourly rates. Address Malcolm John Hannah Maureen Jodie Maree Edward Leonard Stewart Scofield Stafford Morgan 22 Logan Rd 56 Stafford Rd 44 Kirby St 56 Pickering St Marsden QLD Enoggera Old 4132 Everton Park 4053 Arana Hills 4054 4051 07 3200 6785 07 3353 4653 07 3851 4532 07 3356 8000 Telephone Personal Details Date of Birth Gender 9th June 1988 Male 2nd May 1972 10th March 1990 6th October 1984 Male Female Female Ist September Ist April 2002 11th March 2013 2012 Start Date 6th October 2006 Permanent Part Time Mon 8hrs, Tues-Thu 7.5 hrs Clerical Award Level 4 Status Full time Full Time Clerical Award Level 1 Year 2 Casual Clerical Award Level 5 Classification Manager Wages, Super & Deductions Salary $75,000 pa Child Support 595 per pay Care Super $21.75 phr Ot 1.5 Car Allowance .78cents per km Sunsuper S32.75 phr After Tax Super S60 Care Super S25.18 phr Meal Allowance As per Award Sunsuper 773876 784426 865189 793341 Super Fund Membership Number Entitlements Holiday Pay Personal Leave Taxes TEN Yes Yes Yes Yes Yes Yes 678 234 145 781 442 621 965 872 568 782 456 556 Tax Free Threshold + HECS or HELP Tax Free Threshold No Tax Free Threshold Tax Free Threshold Tax Scale IN IN PR2.3 The manager, Malcolm Stewart, has instructed you to process the pay run and manually calculate the pays using the below information. The following is information for the first fortnight's pay run from the business's employee scheduling system: Full Time Casual Permanent PT Scofield Stafford Morgan Monday, 29 May IN IN Tuesday, 30 May IN IN Wednesday, 31 May PERSONAL Thursday, 1 June PERSONAL Friday, 2 June Saturday, 3 June Sunday, 4 June Monday, 5 June IN ANNUAL LEAVE Tuesday, 6 June IN Wednesday, 7 June IN OT-1 hr Thursday, 8 June IN OT-2 hrs Friday, 9 June IN Saturday, 10 June Sunday, 11 June IN IN IN IN IN IN IN IN IN IN IN Steps to take: a. Locate the timesheets on the following pages. b. Complete the timesheets for the first fortnight's pay run from 29th May 11th June by manually recording the information from the employee scheduling system in the business's timesheets. Guidance: Please enter any meal allowance as a count number (not dollars, ie entitled to one meal allowance so enter 1, two meals allowances enter 2) Into the Type column please use the abbreviations (A)nnual Leave, (Personal Leave. (PH) Public Holiday. Hannah Scofield travelled 65 kms for business purposes for the fortnight and Edward Morgan was entitled to one meal allowance when he worked overtime on Thursday Super (Y or JODIE STAFFORD No Tax-Free Threshold Rate $ per Qty Category hour Tax (Y or N) 35.5 Hours Ordinary Time 32.75 @ N) Value $ Y 1752.125 o Hours Overtime x1.5 |Y N o Hours Overtime x2.0 Y N Hours Personal Leave @ Hours Annual Leave Y Y Meal Allowance IN IN Kms Car Allowance IN TOTAL GROSS: Check maths PAYG Withholding: $464 Super Payable after tax $60 Superannuation on Wages: NET WAGE: $1062 Need to recalculate Jodie's pay, tax & super