jagomart
digital resources
picture1_Spreadsheet Calculator 46214 | On Cost Calculator 2021


 168x       Filetype XLSX       File size 0.10 MB       Source: intranet.ecu.edu.au


File: Spreadsheet Calculator 46214 | On Cost Calculator 2021
sheet 1 fixed term amp ongoing oncost calculator salary rates effective 01 july 2021 to calculate the total employment cost of a staff appointment please complete the required details in ...

icon picture XLSX Filetype Excel XLSX | Posted on 17 Aug 2022 | 3 years ago
Partial file snippet.
Sheet 1: Fixed Term & On-Going
On-Cost Calculator - Salary Rates Effective 01 July 2021
To calculate the total employment cost of a staff appointment please complete the required details in the shaded cells below. Drop down menus appear in the blue cells, the pink cell is free text.
If you require any assistance with this calculator, please contact Payroll Services on 6304 2235
On-Cost Calculator - Fixed Term & Ongoing Employees






Classification






Employment Status
Fixed Term

ALevel
Step
Hrly rate $0.00 FTE %



Yearly Rate $0

Does the employee receive Full Super (17%)?




Yes
Will the employee be entitled to a severence payout on termination?










Rate Comments
Superannuation Component

$0.00 17.00% of salary

Payroll Tax Component

$0.00 5.79% of salary+super+leave loading

Workers' Compensation Component

$0.00 0.82% of salary+super+leave loading

Long Service Leave Component

$0.00 5.00% of salary

Annual Leave Provision

$0.00 9.60% of salary

Annual Leave Loading

$0.00 1.34185% of salary Max: $1,537.30
Parental Leave

$0.00 0.80% of salary

Severance Oncost (2.5%)

$0.00 0.00% of salary

A) TOTAL EMPLOYMENT COST

$0.00



% salary on-cost

#DIV/0!



B) TOTAL EMPLOYMENT COST (Excluding AL Provision)


$0.00


% salary on-cost

#DIV/0!



*NB: If the employee takes their full leave entitlement within the year the total cost is as per B.














On-Cost Calculator - Fixed Term & Ongoing Employees AGREED RATE






Classification






Employment Status
On-Going




Agreed Rate
FTE %
Does the employee receive Full Super (17%)?




Yes
Will the employee be entitled to a severence payout on termination?










Rate Comments
Superannuation Component

$0.00 17.00% of salary

Payroll Tax Component

$0.00 5.79% of salary+super+leave loading

Workers' Compensation Component

$0.00 0.82% of salary+super+leave loading

Long Service Leave Component

$0.00 5.00% of salary

Annual Leave Provision

$0.00 9.60% of salary

Annual Leave Loading

$0.00 1.34185% of salary Max: $1,555.30
Parental Leave

$0.00 0.80% of salary

Severance Oncost (2.5%)

$0.00 0.00% of salary

A) TOTAL EMPLOYMENT COST

$0.00



% salary on-cost

#DIV/0!



B) TOTAL EMPLOYMENT COST (Excluding AL Provision)


$0.00


% salary on-cost

#DIV/0!



*NB: If the employee takes their full leave entitlement within the year the total cost is as per B.







The words contained in this file might help you see if this file matches what you are looking for:

...Sheet fixed term amp ongoing oncost calculator salary rates effective july to calculate the total employment cost of a staff appointment please complete required details in shaded cells below drop down menus appear blue pink cell is free text if you require any assistance with this contact payroll services on employees classification status alevel step hrly rate fte yearly does employee receive full super yes will be entitled severence payout termination comments superannuation component tax salarysuperleave loading workers compensation long service leave annual provision max parental severance div b excluding al nb takes their entitlement within year as per agreed...

no reviews yet
Please Login to review.