Assessment Task
Question 1
On 10 May 2018 Fran was terminated from work, with her termination being classified as a genuine redundancy.
At that date she had 120 hours of unused annual leave and 130 hours of unused personal leave. Fran also had 450 hours of unused long service leave of which 50 hours were for the 16 August 1981 to 17 August 1996 period.
Fran's current pay rate is $35 per hour and normal hours are 38 per week. She claims the tax free threshold and no rebates. Fran has supplied her TFN and is entitled to leave loading.
Required: Determine Fran's Final Pay.
|
Gross Pay
|
|
|
|
Wages to 10 May Unused Annual Leave
Loading on Unused Annual Leave Unused Personal Leave
Unused Long Service Leave: 16/8/1981 to 17/8/1996 Unused Long Service Leave: post 17 August 1996
Total Gross Pay 
|
|
|
|
|
PAYG Withheld
|
|
|
|
Wages to 10 May Unused Annual Leave
Loading on Unused Annual Leave
Unused Long Service Leave: 16/8/1981 to 17/8/1996 Unused Long Service Leave: post 17 August 1996 Total PAYG Withheld
Net Final Pay
|
|
|
|
Question 2
Calculate the Superannuation Guarantee payable by Crazy Pete's for the August 5, 2018 Payroll. Assume the Payroll is for a month.
|
|
Gross ($)
|
Annual
Leave ($)
|
Overtime ($)
|
Allowance ($)
|
Superannuation Expense
|
|
Colin
|
620
|
-
|
120
|
80 (Dry
Cleaning)
|
|
|
Glen
|
680
|
-
|
65
|
50 (First
Aid)
|
|
|
Andrea
|
590
|
600
|
-
|
-
|
|
|
Jason
|
400
|
|
|
|
|
|
Linda
|
940
|
200
|
30
|
250 (Car
Allowance for Business Travel)
|
|
|
|
Total
|
The General Journal entry to record the Superannuation expense would be:
|
General Journal of Crazy Pete's
|
|
Date
|
Particulars
|
Debit
|
Credit
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Question 3
As payroll clerk for ABC Pty Ltd you are required to update the employment history records for the following staff as at 31 January 2018.
The company works 35 hours per week (5 days at 7 hours).The employees are entitled to 4 weeks annual leave and 2 weeks personal leave per year commencing on 1 January each year.
The following leave was taken in 2017:
K Trung: 3rd March: 1 day Personal Leave
20th May to 3rd June: 2 weeks Annual Leave 6th to 8th June: 3 days Personal Leave
20th November: 1 day Personal Leave
23rd December 2017 to 7th January 2018: 2 weeks Annual Leave
J White 6th to 7th August: 2 days Personal Leave 1st to 7th September: 1 week Annual Leave
18th to 22nd October: 4 days Personal Leave
23rd December 2017 to 7th January 2018: 2 weeks Annual Leave
Question 4
You work for ASP Pty Ltd. You are required to process the monthly payroll for the month ending 30 September, 2017.
Required:
(a) Complete pay slips.
(b) Complete direct debit payment figures to be approved by your manager.
ASP's policy and procedures:
- All of these employees are paid monthly on a full-time basis.
- Commission is paid at the rate of 2.5% for the first $20,000 monthly sales per month.
- Commission is paid at the rate of 5% for monthly sales over $20,000 per month.
Employee's details
|
Employee Name
|
Annual Salary
|
PAYG details
|
HELP/PAYG
offset
|
Sales figures for the Month of September
|
|
J Gray
|
$53 000
|
TFN provided
PAYG free threshold with leave loading
|
HELP
|
$22 000
|
|
A Kelly
|
$40 000
|
TFN provided No PAYG
free threshold claimed
|
|
$26 000
|
|
Z Yang
|
$62 000
|
TFN provided
PAYG free threshold with leave loading
|
|
$15 000
|
|
P Osborne
|
$42 000
|
TFN provided
PAYG free threshold with leave loading
|
PAYG Offset
$1350
|
$35 000
|
Question 5
Prepare a payroll Journal (Including totals) for the following:
1. B Smith grossed $950.00 (Production) and paid $171.00 PAYG.
2. R Brown grossed $550.00 (Production), $400.00 (Maintenance), and paid $171.00 PAYG.
3. P Green grossed $550.00 (Production) and $61.00 PAYG.
4. M White grossed $250.00 (Administration), $400.00 (Sundry) and paid $104.00 PAYG.
5. T Green grossed $650.00 (Administration) and paid $104.00 PAYG.
6. R Jones grossed $950.00 (Production) and paid $171.00 PAYG.
7. The employees were paid cash. The cash was obtained using cheque 235693.
Payroll Journal
|
May - 2018
|
Payroll distribution to General Ledger Accounts
|
|
Employee
|
Date
|
6011 -
Production Wages (DR)
|
6012 -
Administration Wages (DR)
|
6013 -Sundry Wages (DR)
|
6014-
Maintenance Wages (DR)
|
2030 -PAYG
holding Wages (CR)
|
1000- Cash at bank (CR)
|
Cheque
|
|
|
26
|
|
|
|
|
|
|
|
|
|
26
|
|
|
|
|
|
|
|
|
|
26
|
|
|
|
|
|
|
|
|
|
26
|
|
|
|
|
|
|
|
|
|
26
|
|
|
|
|
|
|
|
|
|
26
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Question 6
(a) How should payroll records be stored? Discuss in 100 - 120 words.
(b) How are reports generated from computerised payroll systems? Discuss in 50 - 80 words.
(c) Conduct the appropriate research and explain the ATO's requirement in relation to:
(i) Australian Business Number (ABN)
(ii) Employment declaration
(d) Conduct the appropriate research and explain the TPB's requirement in relation to:
(i) Registration and scope of services documentation requirements for BAS agents
(ii) Fringe Benefit Tax (FBT)