Timesheets are completed in hours not dollars so how many ordinary hours and OT and DT were worked each day and how many hours of leave were used. When you have worked out the hours, then you can work out the money that they are paid. The timesheets should only show hours not dollars. You work out the dollars in Task 3.
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. Malcolm John Hannah Maureen Jodie Maree Edward Leonard Stewart Scofield Stafford Morgan Address 22 Logan Rd 56 Stafford Rd 44 Kirby St 56 Pickering St Marsden QLD Enoggera Old 4132 Everton Park 4053 Arana Hills 4054 4051 Telephone 07 3200 6785 07 3353 4653 07 3851 4532 07 3356 8000 Personal Details Date of Birth 2nd May 1972 10th March 1990 6th October 1984 9th June 1988 Gender Male Female Female Male Ist September Start Date Ist April 2002 11th March 2013 2012 6th October 2006 Permanent Part Time Mon Shrs, Status Full time Full Time Casual Tues-Thu 7.5 hrs Clerical Award Clerical Award Clerical Award Classification Manager Level 1 Year 2 Level 5 Level 4 Wages, Super & Deductions $21.75 phr Salary $75,000 pa Ot 1.5 S32.75 phr $25.18 phr Child Support S95 Car Allowance After Tax Super Meal Allowance per pay 78cents per km S60 As per Award Super Fund Care Super Sunsuper Care Super Sunsuper Membership Number 773876 784426 865189 793341 Entitlements Holiday Pay Yes Yes Yes Personal Leave Yes Yes Yes Taxes TEN 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 North Park Stationery Hourly Rate: $21.75 Time Sheet Employee Name: Hannah Scofield Fortnight Ending: 11th June 2020 Day Start Finish Break Total 8:00 5:00 1:00 8 Leave Annual Leave Type: p - Personale PH Public Holiday Ord X1.5 X2.0 Leave Type Non Tue 8:30 5:00 1:00 7.5 Wed Thu Fri 8:30 5:00 1:00 7-5 Mon 8:00 5:00 1:00 8 Tue 8:30 5:00 1:00 7-5 Wed 8:30 5:00 1:00 7.5 Thu 18:30 5:00 | 1:00 7.5 Fri 8:30 5:00 1:00 7.5 Totals Car Allowance: 65 KMS Employee Certification 1 certify that the above hours are true and correct Meal Allowances: Supervisor Certification 1 certify that the hours shown on this time sheet are true and correct toployee Signature: H Scofield supervisor's Signature. Malcolm Stewart Hannah has decided to take an Early Retirement Scheme This is to be her final pay and you need to calculate the pay she will receive upon termination. She has the following Accrual balances and will qualify for an early retirement scheme incentive payment of $8000 **** Entitlements Balance Hannah Scofield Annual Leave Personal Leave Long Service (hours) (hours) Leave (hours) 0.00 145.00 75.00 The Accountant has advised that this incentive amount is to be taxed at 19% including the Medicare levy. The unused Long Service Leave is to be taxed according to ATO schedule - Taxation of Unused Leave in Termination payments - Post 17th August 1993 rate. North Park Stationery Time Sheet Employee Name: * Jodie Stafford Hourly Rate: $32.75 Leave Annual Leave Type: - Personal Leave PH-Public Holiday Ord X1.5 X2.0 Leave Type Fortnight Ending: 11th June 2020 Day Start Finish Break Total Mon 8:00 5:00 1:00 8 Tue 8:30 5:00 1:00 7.5 Wed Thu|8:30] 5:00 1:00 7-5 Fri 8:30 5:00 1:00 7-5 Mon 8:00 5:00 1:00 8 Tue 8:30 5:00 1:00 7-5 Wed 8:30 5:00 1:00 7-5 Thu Fri Totals Car Allowance: KMS Employee Certification 1 certify that the above hours are true and correct Meal Allowances: Supervisor Certification - certify that the hours shown on this time sheet are true and correct Employee Signature: J. Stafford Supervisor's Signature: Malcolm Stewart North Park Stationery $25.18 Time Sheet Employee Edward Morgan Name: Fortnight June Leave 11th Type: Ending: 2017 Day Start Finish Break Total Ord Mon 8:00 5:00 1:00 8 Hourly Rate: TA - Annual Leave P-Personal Leave PH - Public Holiday X1.5 X2.0 Leave Type Tue 8:30 5:00 1:00 7.5 Wed 8:30 5:00 1:00 7-5 Thu | 8:30 | 5:00 1:00 1:00 7.5 Fri Mon A Tue 8:30 5:00 1:00 7.5 Wed 8:30 6:00 1:00 8.5 Thu 8:30 7:30 1:30 9-5 Fri Totals: Car Allowance: KMS Meal Allowances: Employee Certification: Supervisor Certifications 1 certify that the above hours are true and correcti certify that the hours shown on this time sheet are true and correct Employee Signature: E. Morgan Supervisor's Signature: Malcolm Stewart These are time sheets which record hours worked or taken as leave, not $ values. 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. Malcolm John Hannah Maureen Jodie Maree Edward Leonard Stewart Scofield Stafford Morgan Address 22 Logan Rd 56 Stafford Rd 44 Kirby St 56 Pickering St Marsden QLD Enoggera Old 4132 Everton Park 4053 Arana Hills 4054 4051 Telephone 07 3200 6785 07 3353 4653 07 3851 4532 07 3356 8000 Personal Details Date of Birth 2nd May 1972 10th March 1990 6th October 1984 9th June 1988 Gender Male Female Female Male Ist September Start Date Ist April 2002 11th March 2013 2012 6th October 2006 Permanent Part Time Mon Shrs, Status Full time Full Time Casual Tues-Thu 7.5 hrs Clerical Award Clerical Award Clerical Award Classification Manager Level 1 Year 2 Level 5 Level 4 Wages, Super & Deductions $21.75 phr Salary $75,000 pa Ot 1.5 S32.75 phr $25.18 phr Child Support S95 Car Allowance After Tax Super Meal Allowance per pay 78cents per km S60 As per Award Super Fund Care Super Sunsuper Care Super Sunsuper Membership Number 773876 784426 865189 793341 Entitlements Holiday Pay Yes Yes Yes Personal Leave Yes Yes Yes Taxes TEN 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 North Park Stationery Hourly Rate: $21.75 Time Sheet Employee Name: Hannah Scofield Fortnight Ending: 11th June 2020 Day Start Finish Break Total 8:00 5:00 1:00 8 Leave Annual Leave Type: p - Personale PH Public Holiday Ord X1.5 X2.0 Leave Type Non Tue 8:30 5:00 1:00 7.5 Wed Thu Fri 8:30 5:00 1:00 7-5 Mon 8:00 5:00 1:00 8 Tue 8:30 5:00 1:00 7-5 Wed 8:30 5:00 1:00 7.5 Thu 18:30 5:00 | 1:00 7.5 Fri 8:30 5:00 1:00 7.5 Totals Car Allowance: 65 KMS Employee Certification 1 certify that the above hours are true and correct Meal Allowances: Supervisor Certification 1 certify that the hours shown on this time sheet are true and correct toployee Signature: H Scofield supervisor's Signature. Malcolm Stewart Hannah has decided to take an Early Retirement Scheme This is to be her final pay and you need to calculate the pay she will receive upon termination. She has the following Accrual balances and will qualify for an early retirement scheme incentive payment of $8000 **** Entitlements Balance Hannah Scofield Annual Leave Personal Leave Long Service (hours) (hours) Leave (hours) 0.00 145.00 75.00 The Accountant has advised that this incentive amount is to be taxed at 19% including the Medicare levy. The unused Long Service Leave is to be taxed according to ATO schedule - Taxation of Unused Leave in Termination payments - Post 17th August 1993 rate. North Park Stationery Time Sheet Employee Name: * Jodie Stafford Hourly Rate: $32.75 Leave Annual Leave Type: - Personal Leave PH-Public Holiday Ord X1.5 X2.0 Leave Type Fortnight Ending: 11th June 2020 Day Start Finish Break Total Mon 8:00 5:00 1:00 8 Tue 8:30 5:00 1:00 7.5 Wed Thu|8:30] 5:00 1:00 7-5 Fri 8:30 5:00 1:00 7-5 Mon 8:00 5:00 1:00 8 Tue 8:30 5:00 1:00 7-5 Wed 8:30 5:00 1:00 7-5 Thu Fri Totals Car Allowance: KMS Employee Certification 1 certify that the above hours are true and correct Meal Allowances: Supervisor Certification - certify that the hours shown on this time sheet are true and correct Employee Signature: J. Stafford Supervisor's Signature: Malcolm Stewart North Park Stationery $25.18 Time Sheet Employee Edward Morgan Name: Fortnight June Leave 11th Type: Ending: 2017 Day Start Finish Break Total Ord Mon 8:00 5:00 1:00 8 Hourly Rate: TA - Annual Leave P-Personal Leave PH - Public Holiday X1.5 X2.0 Leave Type Tue 8:30 5:00 1:00 7.5 Wed 8:30 5:00 1:00 7-5 Thu | 8:30 | 5:00 1:00 1:00 7.5 Fri Mon A Tue 8:30 5:00 1:00 7.5 Wed 8:30 6:00 1:00 8.5 Thu 8:30 7:30 1:30 9-5 Fri Totals: Car Allowance: KMS Meal Allowances: Employee Certification: Supervisor Certifications 1 certify that the above hours are true and correcti certify that the hours shown on this time sheet are true and correct Employee Signature: E. Morgan Supervisor's Signature: Malcolm Stewart These are time sheets which record hours worked or taken as leave, not $ values
