establish & maintain payroll ,
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 S: Marsden QLD Enoggera Old 4132 Everton Park 4053 Arana Hills 4054 07 3200 6785 073353 4653 07 3851 4532 07 3356 8000 4051 Telephone Personal Details Date of Birth Gender 2nd May 1972 Male 9th June 1988 Male 10th March 1990 6th October 1984 Female Female Ist September 11th March 2013 2012 Start Date 1st April 2002 Status Full time Full Time Clerical Award Level 1 Year 2 6th October 2006 Permanent Part Time Mon Shrs, Tues-Thu 7.5 hrs Clerical Award Level 4 Casual Clerical Award Level 5 Classification Manager Wages, Super & Deductions Salary $75.000 pa Child Support $95 per pay Super Fund Care Super Membership Number 773876 Entitlements Holiday Pay Yes Personal Leave Yes Taxes TFN 678 234 145 $21.75 phr O 1.5 Car Allowance .78cents per km Sunsuper $32.75 p/ht $25.18 p/hr After Tax Super Meal Allowance $60 As per Award Care Super Sunsuper 784426 865189 793341 Yes Yes Yes 781 442 621 965 872 568 782 456 556 Tax Scale Tax Free Threshold + HECS or HELP Tax Free Threshold No Tax Free Threshold Tax Free Threshold PR2.1 At the centre of a payroll system are payroll categories, which need to be carefully planned to ensure that employees are paid correctly. Using the employee data provided, the Clerk Awards Private Sector Pay Guide and the requirements in Section 2.1.4 Wages and Salaries of the policies and procedures, create a category plan you can use as a quick checklist guide in your payroll data. Category Malcolm John Stewart. Manager (PF) Hannah Edward Maureen Jodie Maree Leonard Scofield, Stafford, Morgan, Clerical Clerical Clerical Award Level Level 5 (C) Level 4 1 Year 2 (PF) (PP) WAGES 17-5% Leave Loading Base Hourly Base Salary Car Allowance at 0.78c per km Meal Allowance Holiday Leave Personal Leave bevertime x2.0 overtime Superannuation Super Guarantee (Sunsuper) Super Guarantee (CARE) Super Additional $60 (CARE) ENTITLEMENTS Holiday Leave Accrual Personal Leave Accrual DEDUCTIONS Child Support TAXES PAYG Withholding 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 2.692 2.346 2.057 2.099 iii. Personal leave at 10 days a year 1,660 1.173 1.029 1.020 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 S: Marsden QLD Enoggera Old 4132 Everton Park 4053 Arana Hills 4054 07 3200 6785 073353 4653 07 3851 4532 07 3356 8000 4051 Telephone Personal Details Date of Birth Gender 2nd May 1972 Male 9th June 1988 Male 10th March 1990 6th October 1984 Female Female Ist September 11th March 2013 2012 Start Date 1st April 2002 Status Full time Full Time Clerical Award Level 1 Year 2 6th October 2006 Permanent Part Time Mon Shrs, Tues-Thu 7.5 hrs Clerical Award Level 4 Casual Clerical Award Level 5 Classification Manager Wages, Super & Deductions Salary $75.000 pa Child Support $95 per pay Super Fund Care Super Membership Number 773876 Entitlements Holiday Pay Yes Personal Leave Yes Taxes TFN 678 234 145 $21.75 phr O 1.5 Car Allowance .78cents per km Sunsuper $32.75 p/ht $25.18 p/hr After Tax Super Meal Allowance $60 As per Award Care Super Sunsuper 784426 865189 793341 Yes Yes Yes 781 442 621 965 872 568 782 456 556 Tax Scale Tax Free Threshold + HECS or HELP Tax Free Threshold No Tax Free Threshold Tax Free Threshold PR2.1 At the centre of a payroll system are payroll categories, which need to be carefully planned to ensure that employees are paid correctly. Using the employee data provided, the Clerk Awards Private Sector Pay Guide and the requirements in Section 2.1.4 Wages and Salaries of the policies and procedures, create a category plan you can use as a quick checklist guide in your payroll data. Category Malcolm John Stewart. Manager (PF) Hannah Edward Maureen Jodie Maree Leonard Scofield, Stafford, Morgan, Clerical Clerical Clerical Award Level Level 5 (C) Level 4 1 Year 2 (PF) (PP) WAGES 17-5% Leave Loading Base Hourly Base Salary Car Allowance at 0.78c per km Meal Allowance Holiday Leave Personal Leave bevertime x2.0 overtime Superannuation Super Guarantee (Sunsuper) Super Guarantee (CARE) Super Additional $60 (CARE) ENTITLEMENTS Holiday Leave Accrual Personal Leave Accrual DEDUCTIONS Child Support TAXES PAYG Withholding 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 2.692 2.346 2.057 2.099 iii. Personal leave at 10 days a year 1,660 1.173 1.029 1.020
