Time Off Total Hours Normal Hours Overtime Hours Monday 800 600 1 9 76 14

# Time off total hours normal hours overtime hours

This preview shows page 25 - 30 out of 32 pages.

Time Off Total Hours Normal Hours Overtime Hours Monday 8:00 6:00 1 9 7.6 1.4 Tuesday 8:30 5:30 1 8 7.6 0.4 Wednesd ay 8:30 7:30 1 10 7.6 2.4 Thursday 9:00 5:10 0.5 7.6(7 hours 40 minutes) 7.6 - Friday 8:30 5:30 0.5 8.5 7.6 0.9 Saturday - - - - - - Sunday - - - - - - @NIET Version 1.0 Page 25 of 32
Assessment Employee Name: Staff A Week Number: 5 Employee Number: 1 Week Ending: 26/02/20XX Day Startin g Time Finishing Time Time Off Total Hours Normal Hours Overtime Hours Monday 8:30 6:30 1 9 7.6 1.4 Total 43.1 38 5.1 Total Hours works during the week: 43.1 Gross Payment: [(38*16)+(5.1*24)] = 608+122.4 = 730.4 \$ Overtime payment = 16*1.5 = 24 \$ per hour Employee Name: Staff c Week Number: 5 Employee Number: 3 Week Ending: 26/02/20XX Day Starting Time Finishin g Time Time Off Total Hours Normal Hours Overtime Hours Monday 9:30 6:30 1 8 7.6 0.4 Tuesday 8:30 5:30 1 8 7.6 0.4 Wednesd ay 7:30 5:00 1 8.5 7.6 0.9 Thursday 8:00 5:00 1 8 7.6 0.4 Friday9 8:30 5:30 1 8 7.6 0.4 Saturday - - - - - - Sunday 9:00 1:00 - 4 4 - Total 44.5 42 2.5 Total Hours works during the week: 44.5 Gross Payment: [(42*18)+(2.5*27)+(4*18)] = 756+67.5+72 = 895.5 \$ Overtime Payment = 18*1.5 = 27\$ per hour Sunday is double pay, So Added extra payment of 4*18 = 72 Once added in total hour and once added afterwards. @NIET Version 1.0 Page 26 of 32
Assessment 9.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 question 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 insurance Superannuation \$22 per week \$25 per week \$12 per week Nil Nil Nil ABC Company Payroll register for week ending: Employee Name Totals Staff A Staff B Staff C HOURS WORKED Normal hours 38 38 38 114 Overtime hours (x 1.5) 9.5 5.25 3 17.75 Overtime hours (x 2) 4 4 ENTITLEMENTS Normal pay (\$) 912 608 684 2,204 Overtime hours x 1.5 x normal pay rate (\$) 342 126 81 549 Overtime hours x 2 x normal pay rate (\$) 144 144 @NIET Version 1.0 Page 27 of 32
Assessment GROSS PAY (\$) 1,254 734 879 2,867 DEDUCTIONS (\$) Income tax (\$) 271 74 151 496 Medical association (\$) 22 12 34 Superannuation (\$) 25 25 TOTAL DEDUCTIONS (\$) 318 86 151 555 NET PAY (\$) 936 648 728 2,312 Employee earnings card for year ending: 26.02.20XX Name: staff a Employee no: 1 Address: 1 Sample St, Sunnyplace Pay period ending Gross pay Deductions Net pay \$ Accumulated totals Date Norma l \$ 1.5 \$ 2.0 \$ Gross pay \$ PAY G tax \$ Medic al ass’n \$ Supe r \$ Total \$ Gross pay \$ Tax withhe ld \$ Balances 10,000.0 0 3300.0 0 26.02.X X 912 342 1,254 271 22 25 318 936 1,254 271 ABC Company @NIET Version 1.0 Page 28 of 32