Assessment 2 - Case Studies 1 & 2 1. You work as a payroll ofcer for ABC Company and you have extracted the information below from the company history cards: Name Employee number Address Date of Birth Employment status Occupation Date Commenced Current wage or rate annual sahry Staff A 1 1 Sample Street, Sunnyplace 14/ 12/1985 Full-time Supervisor 1/01/2004 $24/ hour Staff B 2 2 Sample Street, Sunnyplace 9/12/1984 Casual Reception 2/02/2012 $16/ hour Staff C 3 3 Sample Street, Sunnyplace 12/06/1980 Full-time Team leader 3/03/2000 $18/ hour Note that employees are paid under an award that requires 38 hours per week of work (for 7.60 hours per day, for 5 days). Any employees who work over 7.60 hours per day will receive overtime payment at 1.5 times the normal rate on Monday to Friday and any work on Saturday is paid at 1.5 times. Sunday is double time. This is week 5 and the ending work date is 26/02/20XX. You are required to complete the timesheets and calculate the total gross payment amount for all 3 staff members. The 3 staff members working hours are: Day Monday Tuesday Wednesday Thursday Friday \\kmanO Staff A Staff B Staff C 8.30am to 6.30 pm 8.00am to 6.00 pm 9.30am to 6.30pm with lhour with l-hour with l-hour break break break 9.00am to 5.30 pm 8.30am to 5.30 pm 8.00am to 5.30pm with 0.5 hours with l-hour with l-hour break break break 8.30am to 6.00 pm 8.30am to 7.30pm 7.30am to 5.00pm with 1-hour with 1-hour with 1-hour break break break 9.00am to 7.00pm 9.00am to 5.10 pm 8.00am to 5.00pm with lhour with 0.5 hours with l-hour break break break 8.30am to 5.30pm 8.30am to 5.30pm 8.30am to 5.30pm with 0.5 hours with 0.5 hours with l-hour break break break RTO: 41422 CRICOS: 035900 17|Page Saturday 9.00am to 2.00 pm with 0.5 hours break Sunday 9.00am to 1.00pm Sample timesheet: Employee name: Staff A Employee Number: Week Number: Week Ending: Day Starti Finishi Time Total Norma Overti ng ng off/ hou me tim time me rs/ tim hour e als min e S utes hou rs Monday 8.30 6.30 1 9 182.4 50.4 Tuesday 9.00 5.30 0.5 8 182.4 14.4 Wednesday 8.30 6.00 1 8.5 182.4 32.4 Thursday 9.00 7.00 1 9 182.4 50.4 Friday 8.30 5.30 0.5 8.5 182.4 32.4 Saturday 9.00 2.00 0.5 4.5 0 162 Sunday 0 0 0 0 0 0 Totals Total hours worked during the week: 47.5 Total gross payment: 1254 Sample timesheet: Employee name: Staff B Employee Number: Week Number: Week Ending: Day Starti Finishi Time Total Norma Overti ng ng off/ hou me tim time me rs/ tim hour e als min e S utes hou rs Monday 8.00 6.00 1 9 121.6 33.6 Tuesday 8.30 5.30 HI 8 121.6 9.6 Wednesday 8.30 7.30 1 10 121.6 57.6 Thursday 9.00 5.10 0.5 7.6 121.6 0 Friday 8.30 5.30 0.5 8.5 121.6 21.6 Saturday 0 0 0 0 o 0 O Sunday 0 O O 0 Totals Total hours worked during the week: 43.1 Total gross payment: 730.4 Sample timesheet: Employee name: Staff C Employee Number: Week Number: Week Ending: Day Starti Finishi Time Total Norma Overti ng ng off/ hou me tim time me rs/ tim hour Version 1.0 RTO: 41422 CRICOS: 03590D 18 | PageD als min e S utes hou rs Monday 9.30 6.30 8 136.8 10.8 Tuesday 8.00 5.30 8.5 136.8 24.3 Wednesday 7.30 5.00 8.5 136.8 24.3 Thursday 8.00 5.00 OOHHHHH 8 136.8 10.8 Friday 8.30 5.30 136.8 10.8 Saturday 0 0 o 0 9.00 1.00 O Sunday 144 Totals Total hours worked during the week: 45 Total gross payment: 1053 Version 1.0 RTO: 41422 CRICOS: 03590D 19 |Page2. The following tax and superannuation details have been extracted from the employee's history card. You are required to prepare payroll and in accordance with organisation policy and procedures. Please use information from both Case Studies 1 and 2 to prepare staff A's employee earnings card, cash analysis sheet and Staff A's employee pay advice slip. The relevant templates have been provided. Name Staff A Staff B Staff C Deductions: Health $22 per week $12 per week Nil insurance $25 per week Nil Nil Superannuation Employee Name HOURS WORKED Normal hours Overtime hours (x 1.5) Overtime hours (x 2) ENTITLEMENTS Normal pay ($) Overtime hours x 1.5 x normal pay rate ($) Overtime hours x 2 x normal pay rate ($) GROSS PAY ($) Version 1.0 RTO: 41422 CRICOS: 03590D 20 I P a g e DEDUCTIONS ($) Income tax ($) Medical association ($) Superannuation ($) TOTAL DEDUCTIONS ($) Employee earnings card for year ending: 26.02.20XX Name: Employee no: Address: Deductions Version 1.0 RTO: 41422 CRICOS: 03590D 21 I P a g e ABC Company Cash analysis sheet for week ending: 26.02.XX ABC Company pay slip advice slip Employee no: Pay period ending: Employee name: Wages, overtime and allowances Hours Rate Amount Wages 7.6 58 9392 Overtime 7.6 more 1.5 & 2 2758 Allowances N/A N/A N/A Payment summary This pay Wages 9392 Gross pay 12148 PAYG tax 1984 Deductions 236 Net pay 9928 Deductions Amount PAYG tax 1984 Superannuation 100 Health insurance 136 Total deductions 2220 Assessor needs to use the below checklist to assess the 2 Case Studies. Items Yes/ No Comments Version 1.0 RTO: 41422 CRICOS: 035900 22 I P a g e