IA ac6c42c1-b80d-4d79-a94b-f9fd8344c26a - Word Monday 8.30am to 6.30 pm with 8.00am to 6.00 pm with 9.30am to 6.30pm with Assessment 2 - Case Studies 1 & 2 1-hour break 1-hour break 1-hour break Tuesday 9.00am to 5.30 pm with 8.30am to 5.30 pm with 8.00am to 5.30pm with 1. You work as a payroll officer for ABC Company and you have extracted the information 0.5 hours break 1-hour break 1-hour break below from the company history cards: Wednesday 8.30am to 6.00 pm with 8.30am to 7.30pm with 7.30am to 5.00pm with 1-hour break 1-hour break 1-hour break Thursday 9.00am to 7.00pm with 1- 9.00am to 5.10 pm with 8.00am to 5.00pm with Name Staff A Staff B Staff C hour break 0.5 hours break I-hour break 8.30am to 5.30pm with 8.30am to 5.30pm with 8.30am to 5.30pm with Employee number Friday w N 0.5 hours break 1-hour break Address 1 Sample Street, 2 Sample S Street, 3 Sample Street, 0.5 hours break Saturday 9.00am to 2.00 pm with Sunnyplace Sunnyplace Sunnyplace 0.5 hours break 12/06/1980 Sunday 9.00am to 1.00pm Date of Birth 14/ 12/1985 9/12/1984 Employment status Full-time Casual Full-time Sample timesheet: Occupation Supervisor Reception Team leader Employee name: Staff A Employee Number: 1 Week Number. 5 Week Ending: 26/02/20XX Date Commenced 1/01/2004 2/02/2012 3/03/2000 Day Starting Finishing Time Total Normal Overtime Current wage rate or $24/ hour $16/ hour $18/ hour time ime hours/ time hours annual salary meals minutes hours Monday 7.6 8:30 6:30 1.4 CO V Note that employees are paid under an award that requires 38 hours per week of work (for Tuesday 9:00 5:30 7.6 0.4 8.5 7.6 7.60 hours per day, for 5 days). Any employees who work over 7.60 hours per day will Wednesday 8:30 6:00 1 0.9 Thursday 9:00 7:00 1 9 7.6 1.4 receive overtime payment at 1.5 times the normal rate on Monday to Friday and any work Friday 8:30 5:30 0.5 8.5 7.6 0.9 on Saturday is paid at 1.5 times. Sunday is double time. This is week 5 and the ending work Saturday 9:00 2:00 05 15 0 4.5 Sunday Day off date is 26/02/20XX. Totals Total hours worked during the week:47.5hr You are required to complete the timesheets and calculate the total gross payment amount Total gross payment: $1254 $24x38hr=$912(normal hours$) for all 3 staff members. $36x9.5hr=342(OT&Sat) Review and revise - 22 Sep 2021 - RL The 3 staff members working hours are: Employee name: Employee Number. Staff A 1 Day Staff A Staff B Staff C 140% BB 24-25 . # 37 086ac6c42c1-b80d-4d79-a94b-f9fd8344c26a - Word X 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 insurance $22 per week $12 per week Nil Superannuateon $25 per week Nil Nil ABC Company Payroll register for week ending Employee Name Totals Staff A Staff B Staff C HOURS WORKED 47.5 43.1 45 135.6 Normal hours 182.4 121.6 136.8 440.8 Overtime hours (x 1.5) 342 122.4 81 545.4 Overtime hours (x 2) 0 144 144 ENTITLEMENTS Normal pay ($) 912 608 828 2348 Overtime hours x 1.5 x 342 122.4 81 545.4 normal pay rate ($) 2. The following tax and superannuateon details have been extracted from the employee's history card. You are required to prepare payroll and in accordance with organisation Overtime hours x 2 x 0 144 144 normal pay rate ($) policy and procedures. Please use information from both Case Studies 1 and 2 to prepare GROSS PAY ($) 1254 730.4 1053 3037.4 30-31 . # 37 026 140%IA ac6c42c1-b80d-4d79-a94b-f9fd8344c26a - Word DEDUCTIONS ($) Income tax ($) 271 74 151 496 Review and revise - 17 Feb 2022 - RL Medical association ($) 27 12 34 ABC Company Superannuateon ($) 25 0 25 Cash analysis sheet for week ending: 26.02.Xx TOTAL DEDUCTIONS ($) 318 86 151 555 Notes Coins Employee Net NET PAY ($) 936 644.4 902 2482.4 name pay $100 $50 $20 $10 $5 $2 $1 504 204 10 54 Review and revise - 22 Sep 2021 - RL Staff A 936 Review and revise - 17 Feb 2022 1 - RL Staff B 646 2 Employee earnings card for year ending: 26.02.20XX Staff C 657 6 1 Name: Staff A 1 3 1 3 1 2 0 Employee no: 1 Totals Address: 1 Sample Street, Sunnyplace 2439 21 0 O Pay Review and revise - 22 Sep 2021 - RL Net pay period Gross pay Deductions Accumulated totals Review and revise - 20 Dec 2021 - RL ending Review and revise - 17 Feb 2022 - RL Date Normal 15 $ 2.0 $ Gross PAYG Medical Super Total Gross Tax withheld $ ABC Company pay slip advice slip pay tax ass'n pay Employee no: Pay period ending: 26/02/20XX Employee name: Staff A Balances 10000 3300 26.02.XX |912 342 10 1254 271 22 25 318 936 11254 3618 Wages, overtime and allowances Hours Rate Amount Wages 38 $24/hr $912 Review and revise - 22 Sep 2021 - RL Overtime 9.5 24 $342 Allowances N/A N/A N/A Review and revise - 20 Dec 2021 - RL Acceptable answers, main points covered - 22 Sep 2021 - RL BB 32-33 . # 37 086 140%IA ac6c42c1-b80d-4d79-a94b-f9fd8344c26a - Word Case Study 1- Timesheet Staff A Payment summary This pay 912 Case Study 1 - Timesheet Staff B Wages Gross pay 1254 Case Study 1- Timesheet Staff C PAYG tax 271 Deductions 47 Case Study 2 - Payroll Register Net pay 936 Review and revise - 22 Sep 2021 - RL Case Study 2 - Employee Earnings Card - Staff A Review and revise - 20 Dec 2021 - RL Case Study 2 - Cash Analysis Sheet Review and revise - 17 Feb 2022 - RL Case Study 2 - Company Pay Slip Advice Slip - Staff A Deductions Amount PAYG tax 271 Superannuateon 22 Assessed by Health insurance 25 Total deductions 318 Date Review and revise - 22 Sep 2021 - RL Assessor Signature_ Review and revise - 20 Dec 2021 - RL Acceptable answers, main points covered - 17 Feb 2022 - RL Assessor needs to use the below checklist to assess the 2 Case Studies. Items Yes/ No Comments 34-35 . # 37 08 6 - -H 1406