Salary Scale & Structure - Vworksheet

Download as xlsx, pdf, or txt
Download as xlsx, pdf, or txt
You are on page 1of 14

1 Metode Ranking Sederhana

Skala Tunggal Skala Ganda - Berurutan


Jabatan Golongan
Upah Upah Terkecil Upah Terbesar
(Job Position) (Job Grade)
Waiter 1 1,500,000 1,500,000 2,000,000
Administration 2,000,000
2 2,000,000 3,000,000
Cashier 2,000,000
Accounting 3 3,000,000 3,000,000 4,000,000
HR & GA 4 6,000,000 4,000,000 8,000,000
Skala Ganda - Tumpang Tindih Skala Campuran
Upah Terkecil Upah Terbesar Upah Terkecil Upah Terbesar
1,500,000 2,250,000 1,500,000 1,500,000
2,000,000 3,200,000 2,000,000 3,200,000
3,000,000 4,250,000 3,000,000 4,000,000
4,000,000 6,000,000 6,000,000 8,000,000
2 Metode Dua Titik

Skenario No. 6 (Spread & Mid Diketahui)


Golongan Posisi Rentang Upah Terkecil Upah Tengah
(Job Grade) (Job Position) (Spread) (Min) (Midpoint)
1 Staff 40% 4,000,000
2 Senior Staff 40% 6,000,000
3 Supervisor 50% 8,000,000
4 Senior Supervisor 50% 10,000,000
5 Manager 90% 15,000,000
6 Senior Manager 90% 20,000,000
7 Director 100% 30,000,000
8 President Director 100% 40,000,000

Posisi
Rentang
(Job Position)
Staff 20% s.d. 50%
Supervisory 50% s.d. 90%
Managerial 90% atau lebih
read & Mid Diketahui) Skenario No. 2 (Spread & Min Diketahui) Skenario No. 4 (Spread & Max Diketah
Upah Terbesar Upah Terkecil Upah Tengah Upah Terbesar Upah Terkecil
(Max) (Min) (Midpoint) (Max) (Min)
3,333,333
5,000,000
6,400,000
8,000,000
10,344,828
13,793,103
20,000,000
26,666,667
Skenario No. 4 (Spread & Max Diketahui) Skenario No. 3 (Min & Mid Diketahui)
Upah Tengah Upah Terbesar Upah Terkecil Upah Tengah Upah Terbesar
(Midpoint) (Max) (Min) (Midpoint) (Max)
4,666,667 3,333,333 4,000,000
7,000,000 5,000,000 6,000,000
9,600,000 6,400,000 8,000,000
12,000,000 8,000,000 10,000,000
19,655,172 10,344,828 15,000,000
26,206,897 13,793,103 20,000,000
40,000,000 20,000,000 30,000,000
53,333,333 26,666,667 40,000,000
d Diketahui) Skenario No. 5 (Mid & Max Diketahui)
Rentang Upah Terkecil Upah Tengah Upah Terbesar Rentang
(Spread) (Min) (Midpoint) (Max) (Spread)
1,575,000 1,837,500
3,812,500 4,447,917
6,050,000 7,058,333
8,287,500 9,668,750
10,525,000 13,253,704
12,762,500 17,016,667
15,000,000 20,000,000
15,000,000 20,000,000
Skenario No. 1 (Min & Max Diketahui)
Upah Terkecil Upah Tengah Upah Terbesar Rentang
(Min) (Midpoint) (Max) (Spread)
1,312,500 1,837,500
3,177,083 4,447,917
5,041,667 7,058,333
6,906,250 9,668,750
7,796,296 13,253,704
8,508,333 17,016,667
10,000,000 20,000,000
10,000,000 20,000,000
3 Metode Point Factor: Struktur dan Skala Upah

Terkecil Terbesar
Jabatan (Job Title) Waiter President Director
Nilai Jabatan 104 889
Rentang Nilai Jabatan 100 1000

Jumlah Layer 4 Local Company

Masuk Kerja 19 tahun


Pensiun 57 tahun
Masa Kerja 38 tahun = Pensiun - Masuk Kerja
Lama di 1 Golongan (Job Grade) 5 tahun = Jumlah Sub Grade
Jumlah Golongan (Job Grade) 8
Interval Nilai Jabatan 112.5 poin

Golongan Posisi Nilai Jabatan Nilai Jabatan


Layer
(Job Grade) (Job Position) Terendah Tertinggi
1 Staff 100.0 212.5
Operative
2 Senior Staff 212.5 325.0
3 Supervisor 325.0 437.5
Section
4 Senior Supervisor 437.5 550.0
5 Manager 550.0 662.5
Department
6 Senior Manager 662.5 775.0
7 Director 775.0 887.5
Board of Director
8 President Director 887.5 1000.0
4 Metode Midpoint to Midpoint Progression

Midpoint to
Golongan Posisi Rentang Upah Terkecil Upah Tengah
Midpoint
(Job Grade) (Job Position) (Spread) (Min) (Mid)
Progression
1 Staff 40% - -
2 Senior Staff 40% 50% - -
3 Supervisor 50% 50% - -
4 Senior Supervisor 50% 50% - -
5 Manager 90% 50% - -
6 Senior Manager 90% 50% - -
7 Director 100% 50% - -
8 President Director 100% 50% - -
Upah Terbesar
(Max)

-
-
-
-
-
-
-
-
5 Penerapan Struktur dan Skala Upah

Golongan Posisi Rentang Upah Terkecil Upah Tengah


(Job Grade) (Job Position) (Spread) (Min) (Mid)
1 Staff 40% - -
2 Senior Staff 40% - -
3 Supervisor 50% - -
4 Senior Supervisor 50% - -
5 Manager 90% - -
6 Senior Manager 90% - -
7 Director 100% - -
8 President Director 100% - -

Jabatan Golongan Upah Terkecil


Nama Upah
(Job Title) (Job Grade) (Min)
Amir Sales 1 3,500,000 -
Badu Customer Relation 1 3,650,000 -
Charlie Marketing 1 4,000,000 -
Diana Product Development 1 4,500,000 -
Edward Cashier 2 6,000,000 -
Fiona Waiter 1 4,350,000 -
Gunawan Bariesta 1 5,000,000 -
Hamdi Treasury 1 3,500,000 -
Isabella Budget & Accounting 2 3,900,000 -
Jonathan Recruitment & Training 2 6,250,000 -
Kurniawan Employee Admin & Payroll 2 5,350,000 -
Laksmi Finance Controller 1 2,500,000 -
Miranti Analyst 2 8,250,000 -
Nia Sales & Customer Relation 2 5,000,000 -
Oskar Marketing & Product Dev 2 6,000,000 -
Prabu Finance 2 5,250,000 -
Qomariah General Affairs 2 5,500,000 -
Rosita IT Operations 2 7,750,000 -
Setyawati Administration 2 3,950,000 -
Teguh Cashier 2 3,750,000 -
Umar Cashier 2 5,750,000 -
Vincent Administration 2 6,250,000 -
Wati HR & GA 4 15,000,000 -
Xandra Information Technology 4 14,150,000 -
Yunita Sales & Marketing 5 20,000,000 -
Zahra Finance & Accounting 5 25,000,000 -
Astuti Branch Operations 6 26,000,000 -
Bonardo Branch Operations 6 27,000,000 -
Chandra Branch Operations 6 28,000,000 -
Doni Branch Operations 6 29,000,000 -
Esti Operations Director 7 35,000,000 -
Upah Terbesar
Overlap
(Max)
- n/a
- #DIV/0!
- #DIV/0!
- #DIV/0!
- #DIV/0!
- #DIV/0!
- #DIV/0!
- #DIV/0!

Upah Terbesar Green/Red


% Posisi
(Max) Circle
- #DIV/0! #DIV/0!
- #DIV/0! #DIV/0!
- #DIV/0! #DIV/0!
- #DIV/0! #DIV/0!
- #DIV/0! #DIV/0!
- #DIV/0! #DIV/0!
- #DIV/0! #DIV/0!
- #DIV/0! #DIV/0!
- #DIV/0! #DIV/0!
- #DIV/0! #DIV/0!
- #DIV/0! #DIV/0!
- #DIV/0! #DIV/0!
- #DIV/0! #DIV/0!
- #DIV/0! #DIV/0!
- #DIV/0! #DIV/0!
- #DIV/0! #DIV/0!
- #DIV/0! #DIV/0!
- #DIV/0! #DIV/0!
- #DIV/0! #DIV/0!
- #DIV/0! #DIV/0!
- #DIV/0! #DIV/0!
- #DIV/0! #DIV/0!
- #DIV/0! #DIV/0!
- #DIV/0! #DIV/0!
- #DIV/0! #DIV/0!
- #DIV/0! #DIV/0!
- #DIV/0! #DIV/0!
- #DIV/0! #DIV/0!
- #DIV/0! #DIV/0!
- #DIV/0! #DIV/0!
- #DIV/0! #DIV/0!

You might also like