Scribd
Upload
17 views2 pages

Trace Table

The document is a trace table detailing staff members' job titles, qualifications, and salary information. It includes calculations for increased salaries based on years of service and applicable tax rates. The table covers various positions, including secretaries, teachers, and janitors, with specific salary figures and adjustments listed for each individual.

Uploaded by

Scarlett Hadley
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
17 views2 pages

Trace Table

The document is a trace table detailing staff members' job titles, qualifications, and salary information. It includes calculations for increased salaries based on years of service and applicable tax rates. The table covers various positions, including secretaries, teachers, and janitors, with specific salary figures and adjustments listed for each individual.

Uploaded by

Scarlett Hadley
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
You are on page 1/ 2

Trace Table

Staff Job Title Qualification Code YO NOS Basic Salary Increased Income Net
ID S Salary Tax Salary

DB75 Secretary Associate ASSOC 5 0 $100000 $100000


Degree
FS30 Secretary Associate ASSOC 10 0 $100000 $100000
Degree
KD22 Teacher Bachelor's BACH 15 4 $160000 $160000 +
(0.04*160000)
Degree = $166400 +
(0.05*166400)
=$174720
KJ88 Teacher Bachelor's BACH 13 3 $160000 $174720
Degree
VM15 Teacher Bachelor's BACH 9 4 $160000 $160000 +
(0.04*160000)
Degree =$166400
MO72 Teacher Bachelor's BACH 16 3 $160000 $174720
Degree
MW28 Teacher Bachelor's BACH 15 2 $160000 $160000
Degree
RB04 Deputy- Doctorate DOCT 29 2 $240000 $240000+
(0.05*240000)
Headmistre Degree =$252000
ss
XC53 Teacher Doctorate DOCT 19 2 $240000 $252000
Degree
TJ23 Teacher Doctorate DOCT 16 2 $240000 $252000
Degree
AM01 Headmistre Doctorate DOCT 31 2 $240000 $252000
ss Degree
NP06 Teacher Doctorate DOCT 25 3 $240000 $252000+
(0.04*252000)
Degree =$253008
JW35 Teacher Doctorate DOCT 28 4 $240000 $253008
Degree
SJ62 Janitor High School HIGH 16 0 $80000 $80000+
(0.05*80000)
=$84000
JW60 Janitor High School HIGH 4 0 $80000 $80000
AB09 Teacher Master’s MAST 20 2 $180000 $180000+
(0.05*180000)
Degree =$189000
SC13 Teacher Master’s MAST 7 5 $180000 $189000+
(0.04*189000)
Degree =$196560
JD78 Teacher Master’s MAST 15 2 $180000 $189000
Degree
KD02 Teacher Master’s MAST 21 3 $180000 $196560
Degree
MP36 Teacher Master’s MAST 21 5 $180000 $196560
Degree
LW45 Teacher Master’s MAST 22 3 $180000 $196560
Degree
Trace Table

You might also like