Latih-4-1.xlsx

Tinggi (Cm)

Nama

Berat (Kg)

Gaji ($)

Gaji (Rp)

Suhu Ruang (0C)

Luas Ruang (m2)

SUKIRNO

150 Cm

60 Kg $

1,000.00 Rp

9,000,000.00

30 oC

16 m2

SAYUTI

166 Cm

55 Kg $

2,500.00 Rp 22,500,000.00

28 oC

21 m2

BADRUN

172 Cm

45 Kg $

1,250.00 Rp 11,250,000.00

27 oC

36 m2

KUNCORO

180 Cm

80 Kg $

1,100.00 Rp

9,900,000.00

25 oC

20 m2

DENNY

158 Cm

72 Kg $

900.00 Rp

8,100,000.00

20 oC

18 m2

KANTI

175 Cm

64 Kg $

950.00 Rp

8,550,000.00

30 oC

25 m2

DESI

163 Cm

65 Kg $

720.00 Rp

6,480,000.00

29 oC

30 m2

YETNO

179 Cm

76 Kg $

750.00 Rp

6,750,000.00

22 oC

25 m2

EFENDI

178 Cm

66 Kg $

890.00 Rp

8,010,000.00

26 oC

36 m2

FAUZAN

155 CM

57 Kg $

900.00 Rp

8,100,000.00

30 oC

28 m2

NO

NAMA PEGAWAI 1 SUPARDI 2 MARZUKI 3 SUSANTI 4 HARYANI 5 KOSASIH 6 MARLINA 7 DODI 8 MUHTAR 9 ZAINAL 10 SAMSUL

LAMA KERJA (JAM) 14 17 20 16 18 9 10 14 13 16

σb = r=

GAJI PER JAM Rp 9,000 Rp 9,000 Rp 9,000 Rp 9,000 Rp 9,000 Rp 9,000 Rp 9,000 Rp 9,000 Rp 9,000 Rp 9,000

3.6380343755 149.046895384

Rp Rp Rp Rp Rp Rp Rp Rp Rp Rp

JUMLAH GAJI 126,000 153,000 180,000 144,000 162,000 81,000 90,000 126,000 117,000 144,000

BONUS Rp Rp Rp Rp Rp Rp Rp Rp Rp Rp

1,000 1,500 1,500 1,500 1,500 1,000 1,000 1,500 1,500 1,500

GAJI + BONUS Rp 127,000 Rp 154,500 Rp 181,500 Rp 145,500 Rp 163,500 Rp 82,000 Rp 91,000 Rp 127,500 Rp 118,500 Rp 145,500

ARISAN Rp Rp Rp Rp Rp Rp Rp Rp Rp Rp

10,000 10,000 10,000 10,000 10,000 10,000 10,000 10,000 10,000 10,000

GAJI YANG DITERIMA Rp 117,000 Rp 144,500 Rp 171,500 Rp 135,500 Rp 153,500 Rp 72,000 Rp 81,000 Rp 117,500 Rp 108,500 Rp 135,500