Australia Payroll 1.You work as a payroll officer for ABC Company and you have e
ID: 2330944 • Letter: A
Question
Australia Payroll
1.You work as a payroll officer for ABC Company and you have extracted the below information from the company history cards:
Name
Staff A
Staff B
Staff C
Employee number
1
2
3
Address
1 Sample Street, Sunnyplace
2 Sample Street, Sunnyplace
3 Sample Street, Sunnyplace
Date of Birth
14/ 12/1985
9/12/1984
12/06/1980
Employment status
Full-time
Casual
Full-time
Occupation
Supervisor
Reception
Team leader
Date Commenced
1/01/2004
2/02/2012
3/03/2000
Current wage rate or annual salary
$24/ hour
$16/ hour
$18/ hour
Note that employees are paid under an award that requires 38 hours per week of work (for 7.60 hours per day). Any employees who work over 7.60 hours per day will receive overtime payment at 1.5 times the normal rate on Monday to Saturday. Sunday is double pay. 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:
Staff A
Staff B
Staff C
Monday
8.30am to 6.30 pm with 1 hour break
8.00am to 6.00 pm with 1 hour break
9.30am to 6.30pm with 1 hour break
Tuesday
9.00am to 5.30 pm with 0.5 hours break
8.30am to 5.30 pm with 1 hour break
8.00am to 5.30pm with 1 hour break
Wednesday
8.30am to 6.00 pm with 1 hour break
8.30am to 7.30pm with 1 hour break
7.30am to 5.00pm with 1 hour break
Thursday
9.00am to 7.00pm with 1 hour break
9.00am to 5.10 pm with 0.5 hours break
8.00am to 5.00pm with 1 hour break
Friday
8.30am to 5.30pm with 0.5 hours break
8.30am to 5.30pm with 0.5 hours break
8.30am to 5.30pm with 1 hour break
Saturday
9.00am to 2.00 pm with o.5 hours break
Sunday
9.00am to 1.00pm
Timesheet:
Employee name: Staff A
Week Number: 5
Employee Number: 1
Week Ending: 26/02/20XX
Day
Starting time
Finishing time
Time off/ meals
Total hours/ minutes
Normal time hours
Overtime hours
Monday
Tuesday
Wednesday
Thursday
Friday
Saturday
Sunday
Totals
Total hours worked during the week:
Total gross payment:
Employee name: Staff B
Week Number: 5
Employee Number: 2
Week Ending: 26/02/20XX
Day
Starting time
Finishing time
Time off/ meals
Total hours/ minutes
Normal time hours
Overtime hours
Monday
Tuesday
Wednesday
Thursday
Friday
Saturday
Sunday
Totals
Total hours worked during the week:
Total gross payment:
Employee name: Staff C
Week Number: 5
Employee Number: 3
Week Ending: 26/02/20XX
Day
Starting time
Finishing time
Time off/ meals
Total hours/ minutes
Normal time hours
Overtime hours
Monday
Tuesday
Wednesday
Thursday
Friday
Saturday
Sunday
Totals
Total hours worked during the week:
Total gross payment:
2.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
3.Explain how and the procedures to reconcile total wages for pay period, check and correct irregularities and refer to designated persons for resolution.
4.Explain at least 2 difference methods that can be used to pay employees. You are also required to describe where to find information about payments in an organisation and the records that correspond to different payment methods.
5.If you work as the payroll officer for ABC Company and you are a part-time staff member. At the end of each week you prepare the payroll register using the time sheets provided by the management and information can be found on each employee’s history card. After the payroll register is reconciled, you also prepare the pay advice slips are prepared and you write up and sign the cheque. Please explain the faults in this payroll procedure.
6.Identify the key provisions of relevant legislation standards and codes that may affect payroll operations.
7.List and explain at least 2 different types of payroll systems
Name
Staff A
Staff B
Staff C
Employee number
1
2
3
Address
1 Sample Street, Sunnyplace
2 Sample Street, Sunnyplace
3 Sample Street, Sunnyplace
Date of Birth
14/ 12/1985
9/12/1984
12/06/1980
Employment status
Full-time
Casual
Full-time
Occupation
Supervisor
Reception
Team leader
Date Commenced
1/01/2004
2/02/2012
3/03/2000
Current wage rate or annual salary
$24/ hour
$16/ hour
$18/ hour
Explanation / Answer
Employee Name: Staff A
Week Number: 5
Employee Number: 1
Week Ending: 26/02/20XX
Gross Payment: [(42.5*24)+(5*36)] = 1,020+180
= 1,200$
Employee Name: Staff B
Week Number: 5
Employee Number: 2
Week Ending: 26/02/20XX
Gross Payment: [(38*16)+(5.1*24)] = 608+122.4
= 730.4 $
Employee Name: Staff c
Week Number: 5
Employee Number: 3
Week Ending: 26/02/20XX
Gross Payment: [(42*18)+(2.5*27)+(4*18)] = 756+67.5+72
= 895.5 $
As per Chegg policy, can only provide answer to first full question.
Provide Feedback...............................
Employee Name: Staff A
Week Number: 5
Employee Number: 1
Week Ending: 26/02/20XX
Day Starting Time Finishing Time Time Off Total Hours Normal Hours Overtime Hours Monday 8:30 6:30 1 9 7.6 1.4 Tuesday 9:00 5:30 0.5 8 7.6 0.4 Wednesday 8:30 6:00 1 8.5 7.6 0.9 Thursday 9:00 7:00 1 9 7.6 1.4 Friday 8:30 5:30 0.5 8.5 7.6 0.9 Saturday 9:00 2:00 0.5 4.5 4.5 Sunday - - - - - - Total 47.5 42.5 5 Total Hours works during the week: 47.5Gross Payment: [(42.5*24)+(5*36)] = 1,020+180
= 1,200$
- 24 * 1.5 = 36 overtime payment per hour
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.