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 PR 2.2 Complete the table below. a. Look up the weekly rate in the Clerical Awards, then calculate the hourly. Note that one of the employees is a casual staff member. b. Calculate the accrual rates for employee entitlements on a fixed number of hours per pay period for salaried staff or on a percentage basis for the Part-time employees. All accrual rate calculations should be recorded with four (4) decimal places. Use 52 weeks in a year, 38 working hours a week, and assume that the employees are paid fortnightly (26 pays per year). Refer to the business's policies and procedures and the excerpts of employee records above in PR2.1 to complete the table. Stewart Scofield Stafford Morgan i. Hourly rate n/a $ 21.75 $32.75 $ 25.18 ii. Annual leave at four (4) weeks in a year Accrual Accrual rates in rates as a hours per percentage pay of hours Accrual rates as a percentage of hours iii. Personal leave at 10 days a year 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 PR 2.2 Complete the table below. a. Look up the weekly rate in the Clerical Awards, then calculate the hourly. Note that one of the employees is a casual staff member. b. Calculate the accrual rates for employee entitlements on a fixed number of hours per pay period for salaried staff or on a percentage basis for the Part-time employees. All accrual rate calculations should be recorded with four (4) decimal places. Use 52 weeks in a year, 38 working hours a week, and assume that the employees are paid fortnightly (26 pays per year). Refer to the business's policies and procedures and the excerpts of employee records above in PR2.1 to complete the table. Stewart Scofield Stafford Morgan i. Hourly rate n/a $ 21.75 $32.75 $ 25.18 ii. Annual leave at four (4) weeks in a year Accrual Accrual rates in rates as a hours per percentage pay of hours Accrual rates as a percentage of hours iii. Personal leave at 10 days a year
