praktikum tik hizkia glorius (recovered)

Praktikum 1Laporan Gaji Karyawan

Pada PT. FRAME Bekasi

NO. NAMA PEGAWAIMASUKAN PENGELUARAN

TERIMA BERSIHGAJI TUNJANGAN KOPERASI SOSIAL

1 A Rp 450,000 Rp 45,000 Rp 10,000 Rp 5,000 Rp 480,000

2 B Rp 250,000 Rp 25,000 Rp 10,000 Rp 5,000 Rp 260,000

3 C Rp 400,000 Rp 40,000 Rp 10,000 Rp 5,000 Rp 425,000

4 D Rp 350,000 Rp 35,000 Rp 10,000 Rp 5,000 Rp 370,000

5 E Rp 500,000 Rp 50,000 Rp 10,000 Rp 5,000 Rp 535,000

6 F Rp 450,000 Rp 45,000 Rp 10,000 Rp 5,000 Rp 480,000

7 G Rp 600,000 Rp 60,000 Rp 10,000 Rp 5,000 Rp 645,000

8 H Rp 550,000 Rp 55,000 Rp 10,000 Rp 5,000 Rp 590,000

9 I Rp 460,000 Rp 46,000 Rp 10,000 Rp 5,000 Rp 491,000

10 J Rp 600,000 Rp 60,000 Rp 10,000 Rp 5,000 Rp 645,000

11 K Rp 580,000 Rp 58,000 Rp 10,000 Rp 5,000 Rp 623,000

12 L Rp 500,000 Rp 50,000 Rp 10,000 Rp 5,000 Rp 535,000

JUMLAH Rp 5,690,000 Rp 569,000 Rp 120,000 Rp 60,000 Rp 6,079,000

RATA-RATA Rp 474,167 Rp 47,417 Rp 10,000 Rp 5,000 Rp 506,583

Rumus :Tunjangan : =C9*10%Terima Bersih : =C9+D9-E9-F9Jumlah Gaji,Tunjangan,Koperasi, Sosial, Terima Bersih : =SUM (C9:C20), =SUM (D9:D20), =SUM (E9:E20), =SUM (F9:F20).

Rata-Rata Gaji,Tunjangan,Koperasi, Sosial, Terima Bersih : =AVERAGE(C9:C20), =AVERAGE(D9:D20), =AVERAGE(E9:E20), =AVERAGE(E9:E20), =AVERAGE(G9:G20)

=SUM(G9:G20)

Rata-Rata Gaji,Tunjangan,Koperasi, Sosial, Terima Bersih : =AVERAGE(C9:C20), =AVERAGE(D9:D20), =AVERAGE(E9:E20), =AVERAGE(E9:E20), =AVERAGE(G9:G20)

PRAKTIKUM 2

FUNGSI LOGIKA = AND FUNGSI LOGIKA = OR

A B A AND B A B A OR B1 1 TRUE 1 1 TRUE

0 1 FALSE 0 1 TRUE

1 0 FALSE 1 0 TRUE

0 0 FALSE 0 0 FALSE

Nama N. Teori N. Praktik Fungsi = and Fungsi = or

a 90 90 1 TRUEb 67 80 FALSE TRUEc 65 70 FALSE TRUEd 70 55 FALSE TRUEe 80 56 FALSE TRUEf 70 79 TRUE TRUEg 55 60 FALSE FALSEh 45 70 FALSE TRUEi 90 71 TRUE TRUEj 81 72 TRUE TRUEk 78 65 0 TRUE

Rumus :Fungsi Logika A AND B : =AND(B4;A4).Fungsi Logika A OR B : =OR(F5;E5).Fungsi = AND : =AND(B10>=70;C10>=70).Fungsi = OR : =OR(B10>=70;C10>=70)

PRATIKUM 3

DAFTAR NAMA PENUMPANG KERETA API JAKARTA BANDUNG

NO. NAMA PENUMPANG KODE KERETA JENIS KELAS HARGA KELAS CATATAN

1 A e EKONOMI 25000 TIDAK ADA

2 B K EKSKLUSIF 55000 +MAKANAN

3 C E EKONOMI 25000 TIDAK ADA

4 D K EKSKLUSIF 55000 +MAKANAN

5 E E EKONOMI 25000 TIDAK ADA

6 F K EKSKLUSIF 55000 +MAKANAN

7 G E EKONOMI 25000 TIDAK ADA

8 H K EKSKLUSIF 55000 +MAKANAN

9 I E EKONOMI 25000 TIDAK ADA

10 J K EKSKLUSIF 55000 +MAKANAN

11 K E EKONOMI 25000 TIDAK ADA

12 L K EKSKLUSIF 55000 +MAKANAN

Rumus :Jenis Kelas Ekonomi dan Eksklusif : =IF(D5="E";"EKONOMI";IF(D5="k";"EKSKLUSIF"))Harga Kelas Ekonomi dan Eksklusif : =IF(D5="E";"25000";IF(D5="K";"55000"))Catatan Tidak Ada dan +Makanan : =IF(D5="E";"TIDAK ADA";IF(D5="k";"+MAKANAN"))

INPUT

Persediaan kursi

no. kode kereta Jenis harga jumlah kursi

1 e EKONOMI 25000 200

2 k EKSKLUSIF 55000 200

output

sisa kursi

no kode kereta jenis harga sisa kursi

1 e EKONOMI 25000 200

2 k EKSKLUSIF 55000 200

output

sisa kursi

kursi sementara

ekonomi eksklusif

37 37

kursi sementara

proses (nota)

no kode kereta `jenis harga

1 e EKONOMI 25000

2 k EKSKLUSIF 55000

proses (nota)


1 e EKONOMI 25000

2 k EKSKLUSIF 55000

proses (nota)


1 e EKONOMI 25000

2 k EKSKLUSIF 55000

proses (nota)


1 e EKONOMI 25000

2 k EKSKLUSIF 55000

tanggal: 22/02/2012 no : 00 01

nama : Hizkia Glorius

proses (nota)

jumlah kursi jumlah

80 Rp 2,000,000.00

90 Rp 4,950,000.00

total Rp 6,950,000.00

bayar Rp 6,990,000.00

kembalian Rp 40,000.00

tanggal: 22/02/2012 no : 00 02

nama : NURFAJRIN

proses (nota)

jumlah kursi jumlah

12 Rp 300,000.00

12 Rp 660,000.00

total Rp 960,000.00

bayar Rp 1,000,000.00


tanggal: 22/02/2012 no : 00 03

nama : NURUL HILDA

proses (nota)

jumlah kursi jumlah

15 Rp 375,000.00

16 Rp 880,000.00

total Rp 1,255,000.00

bayar Rp 1,300,000.00


tanggal: 22/02/2012 no : 00 03

nama : NURUL HILDA

proses (nota)

jumlah kursi jumlah

56 Rp 1,400,000.00

45 Rp 2,475,000.00

total Rp 3,875,000.00

bayar Rp 3,900,000.00


Ekonomi Eksklusif

pesanan 1 80 pesanan 1 90




JUMLAH 163 JUMLAH 163

pratikum 4

daftar nama penumpang kereta api jakarta bandung

no. nama penumpang kode kereta jenis keLas Harga kereta catatan

1 a k ekslusif 55000 +makanan2 b k ekslusif 55000 +makanan3 c b bisnis 150000 makan & minum4 d k ekslusif 55000 +makanan5 e b bisnis 150000 makan & minum6 f e ekonomi 25000 tidak ada

7 g e ekonomi 25000 tidak ada

8 h k ekslusif 55000 +makanan9 i b bisnis 150000 makan & minum

10 j k ekslusif 55000 +makanan

11 k b bisnis 150000 makan & minum12 l e ekonomi 25000 tidak ada

Rumus :Jenis Kelas Ekslusif, Bisnis, dan Ekonomi : =IF(D4="e";"ekonomi";IF(D4="k";"ekslusif";IF(D4="b";"bisnis")))

Harga Kereta Ekslusif, Bisnis, dan Ekonomi : =IF(D4="e";"25000";IF(D4="k";"55000";IF(D4="b";"150000")))

Catatan : =IF(D4="e";"tidak ada";IF(D4="k";"+makanan";IF(D4="b";"makan & minum")))

pratikum 4

daftar nama penumpang kereta api jakarta bandung

praktikum 5Daftar nama penumpang kereta api jakarta bandung

no. nama penumpang kode kereta jenis keLAS harga kereta catatan

1 a E ekonomi 25000 tidak ada2 b k ekslusif 55000 +makanan3 c b bisnis 150000 makan & minum4 d r reguler 45000 softdrink

5 e p FALSE 125000 makan + minum6 f b bisnis 150000 makan & minum7 g k ekslusif 55000 +makanan8 h p FALSE 125000 makan + minum9 i r reguler 45000 softdrink10 j e ekonomi 25000 tidak ada11 k k ekslusif 55000 +makanan12 l b bisnis 150000 makan & minum

Rumus :

Jenis Kelas Ekonomi, Ekslusif, Bisnis, dan Reguler : =IF(D4="e";"ekonomi";IF(D4="k";"ekslusif";IF(D4="b";"bisnis";IF(D4="R";"reguler"))))

Harga Kereta : =IF(D4="e";"25000";IF(D4="k";"55000";IF(D4="b";"150000";IF(D4="R";"45000";IF(D4="p";"125000")))))Catatan : =IF(D4="e";"tidak ada";IF(D4="k";"+makanan";IF(D4="b";"makan & minum";IF(D4="r";"softdrink";IF(D4="p";"makan + minum")))))

praktikum 5Daftar nama penumpang kereta api jakarta bandung

PRAKTIKUM 6LAPORAN SEWA MOBIL PADA PT. MOBIL TIMOR

no jumlah (unit) lama sewa (hari) total diskon bayar

1 a 1 4 Rp 600,000 Rp - Rp 600,000.00 2 b 2 8 Rp 2,400,000 Rp - Rp 2,400,000.00 3 c 5 11 Rp 8,250,000 Rp 412,500.00 Rp 7,837,500.00 4 d 6 12 Rp 10,800,000 Rp 540,000.00 Rp 10,260,000.00 5 e 8 3 Rp 3,600,000 Rp 180,000.00 Rp 3,420,000.00 6 f 9 5 Rp 6,750,000 Rp 337,500.00 Rp 6,412,500.00 7 g 12 6 Rp 10,800,000 Rp 1,080,000.00 Rp 9,720,000.00 8 h 1 7 Rp 1,050,000 Rp - Rp 1,050,000.00 9 i 2 9 Rp 2,700,000 Rp - Rp 2,700,000.00 10 j 9 10 Rp 13,500,000 Rp 675,000.00 Rp 12,825,000.00 11 k 4 4 Rp 2,400,000 Rp - Rp 2,400,000.00 12 l 6 3 Rp 2,700,000 Rp 135,000.00 Rp 2,565,000.00 13 m 7 6 Rp 6,300,000 Rp 315,000.00 Rp 5,985,000.00 14 n 4 14 Rp 8,400,000 Rp - Rp 8,400,000.00 15 o 5 15 Rp 11,250,000 Rp 562,500.00 Rp 10,687,500.00

JUMLAH 81 117 Rp 91,500,000.00 Rp 4,237,500.00 Rp 87,262,500.00

Rumus : Total : =D4*E4*150000

Diskon : =IF(D4<5;F4*0%;IF(D4<10;F4*5%;F4*10%)) Bayar : =F4-G4

Jumlah Unit, Hari, Total, Diskon, Bayar : =SUM(D4:D18), =SUM(E4:E18), =SUM(F4:F18), =SUM(G4:G18), =F19-G19

nama penyewa

Rumus :Total : =D4*E4*150000

PRAKTIKUM 7Laporan sewa mobil pada pt. Mobil timor

no TOTAL DISKON BAYAR

1 A 1 4 Rp 600,000.00 Rp - Rp 600,000.00 2 B 2 5 Rp 1,500,000.00 Rp - Rp 1,500,000.00 3 C 7 7 Rp 7,350,000.00 Rp 367,500.00 Rp 6,982,500.00 4 D 12 8 Rp 14,400,000.00 Rp 1,440,000.00 Rp 12,960,000.00 5 E 25 10 Rp 37,500,000.00 Rp 7,500,000.00 Rp 30,000,000.00 6 F 34 11 Rp 56,100,000.00 Rp 19,635,000.00 Rp 36,465,000.00 7 G 45 12 Rp 81,000,000.00 Rp 40,500,000.00 Rp 40,500,000.00 8 H 21 14 Rp 44,100,000.00 Rp 8,820,000.00 Rp 35,280,000.00 9 I 3 15 Rp 6,750,000.00 Rp - Rp 6,750,000.00 10 J 10 6 Rp 9,000,000.00 Rp 450,000.00 Rp 8,550,000.00 11 K 15 7 Rp 15,750,000.00 Rp 1,575,000.00 Rp 14,175,000.00 12 L 25 8 Rp 30,000,000.00 Rp 6,000,000.00 Rp 24,000,000.00 13 M 37 9 Rp 49,950,000.00 Rp 17,482,500.00 Rp 32,467,500.00 14 N 1 3 Rp 450,000.00 Rp - Rp 450,000.00 15 O 5 4 Rp 3,000,000.00 Rp - Rp 3,000,000.00

JUMLAH 243 123 Rp 357,450,000.00 Rp 103,770,000.00 Rp 253,680,000.00

Rumus :Total : =D4*E4*150000

Diskon : =IF(D4<=5;F4*0%;IF(D4<=10;F4*5%;IF(D4<=20;F4*10%;IF(D4<=30;F4*20%;IF(D4<=40;F4*35%;F4*50%)))))

Bayar : =F4-G4

Jumlah Unit, Hari, Total, Diskon, Bayar : =SUM(D4:D18), =SUM(E4:E18), =SUM(F4:F18), =SUM(G4:G18), =SUM(H4:H18)

NAMA PENYEWA

JUMLAH (UNIT)

LAMA SEWA (HARI)

No Nama Barang Stok Harga Satuan

1 NIKE 50 Rp 200,000.00

2 ADIDAS 30 Rp 350,000.00

3 AND1 90 Rp 750,000.00

4 YONEX 60 Rp 250,000.00

5 PUMA 70 Rp 150,000.00

6 EIGER 50 Rp 300,000.00

7 SPEED 66 Rp 500,000.00

8 CRESSIDA 90 Rp 150,000.00

9 IBANEZ 99 Rp 3,500,000.00

10 KOPI ABC 99 Rp 1,000.00

11 KOPI TORABIKA 98 Rp 1,200.00

12 KOPI LUWAK 50 Rp 1,000,000.00

13 DANCOW 100 Rp 50,000.00

14 KICKERS 500 Rp 50,000.00

15 FRISIAN FLAG 600 Rp 50,000.00

16 MACBETH 96 Rp 350,000.00

17 MILO 45 Rp 50,000.00

18 SUSU INDOMILK 40 Rp 50,000.00

19 YAMAHA 10 Rp 500,000.00

20 SENSEN 30 Rp 250,000.00

jumlah

Rp 10,000,000.00

Rp 10,500,000.00

Rp 67,500,000.00

Rp 15,000,000.00

Rp 10,500,000.00

Rp 15,000,000.00

Rp 33,000,000.00

Rp 13,500,000.00

Rp 346,500,000.00

Rp 99,000.00

Rp 117,600.00

Rp 50,000,000.00

Rp 5,000,000.00

Rp 25,000,000.00

Rp 30,000,000.00

Rp 33,600,000.00

Rp 2,250,000.00

Rp 2,000,000.00

Rp 5,000,000.00

Rp 7,500,000.00

No banyaknya barang Jenis Barang Harga1 7 NIKE Rp 200,000.00

2 10 ADIDAS Rp 350,000.00

3 8 AND1 Rp 750,000.00

4 7 YONEX Rp 250,000.00

5 6 PUMA Rp 150,000.00

6 48 EIGER Rp 300,000.00

7 9 SPEED Rp 500,000.00

8 8 CRESSIDA Rp 150,000.00

9 7 IBANEZ Rp 3,500,000.00

10 9 KOPI ABC Rp 1,000.00

11 7 KOPI TORABIKA Rp 1,200.00

12 5 KOPI LUWAK Rp 1,000,000.00

13 6 DANCOW Rp 50,000.00

14 4 KICKERS Rp 50,000.00

15 5 FRISIAN FLAG Rp 50,000.00

16 6 MACBETH Rp 350,000.00

17 7 MILO Rp 50,000.00

18 8 SUSU INDOMILK Rp 50,000.00

19 9 YAMAHA Rp 500,000.00

20 1 SENSEN Rp 250,000.00

21 2 0 Rp -

TOTAL

BAYAR

UANG KEMBALI

Jumlah Rp 1,400,000.00

Rp 3,500,000.00

Rp 6,000,000.00

Rp 1,750,000.00

Rp 900,000.00

Rp 14,400,000.00

Rp 4,500,000.00

Rp 1,200,000.00

Rp 24,500,000.00

Rp 9,000.00

Rp 8,400.00

Rp 5,000,000.00

Rp 300,000.00

Rp 200,000.00

Rp 250,000.00

Rp 2,100,000.00

Rp 350,000.00

Rp 400,000.00

Rp 4,500,000.00

Rp 250,000.00

Rp -

Rp 71,517,400.00

Rp 85,000,000.00

Rp 13,482,600.00

NO Nama barang Sisa Stok Harga

1 NIKE Rp 200,000.00

2 ADIDAS 20 Rp 350,000.00

3 AND1 82 Rp 750,000.00

4 YONEX 53 Rp 250,000.00

5 PUMA 64 Rp 150,000.00

6 EIGER 2 Rp 300,000.00

7 SPEED 57 Rp 500,000.00

8 CRESSIDA 82 Rp 150,000.00

9 IBANEZ 92 Rp 3,500,000.00

10 KOPI ABC 90 Rp 1,000.00

11 KOPI TORABIKA 91 Rp 1,200.00

12 KOPI LUWAK 45 Rp 1,000,000.00

13 DANCOW 94 Rp 50,000.00

14 KICKERS 496 Rp 50,000.00

15 FRISIAN FLAG 595 Rp 50,000.00

16 MACBETH 90 Rp 350,000.00

17 MILO 38 Rp 50,000.00

18 SUSU INDOMILK 32 Rp 50,000.00

19 YAMAHA 1 Rp 500,000.00

20 SENSEN 29 Rp 250,000.00

Jumlah

Rp 10,000,000.00

Rp 10,500,000.00

Rp 67,500,000.00

Rp 15,000,000.00

Rp 10,500,000.00

Rp 15,000,000.00

Rp 33,000,000.00

Rp 13,500,000.00

Rp 346,500,000.00

Rp 99,000.00

Rp 117,600.00

Rp 50,000,000.00

Rp 5,000,000.00

Rp 25,000,000.00

Rp 30,000,000.00

Rp 33,600,000.00

Rp 2,250,000.00

Rp 2,000,000.00

Rp 5,000,000.00

Rp 7,500,000.00

Praktikum 8laporan gaji bulanan pada pt.air minum asera di jakarta

no status ANAK GOL KELAMIN STATUS GAPOK T. ISTRI TOTAL

1 MENIKAH I A iii L M 7000000 Rp 700,000.00 Rp 7,700,000.00 2 BELUM II B III L M 7000000 Rp 700,000.00 Rp 7,700,000.00 3 MENIKAH III C III L M 7000000 Rp 700,000.00 Rp 7,700,000.00 4 MENIKAH IV D IV P S 1000000 Rp 50,000.00 Rp 1,050,000.00

5 MENIKAH 0 E I L M 5000000 Rp 1,000,000.00 Rp 6,000,000.00

6 MENIKAH I F II P S 6000000 Rp 900,000.00 Rp 6,900,000.00 7 MENIKAH II G III L M 7000000 Rp 700,000.00 Rp 7,700,000.00 8 MENIKAH III H IV P S 1000000 Rp 50,000.00 Rp 1,050,000.00

9 MENIKAH IV I I L M 5000000 Rp 1,000,000.00 Rp 6,000,000.00 10 MENIKAH 0 J II L M 6000000 Rp 900,000.00 Rp 6,900,000.00

11 MENIKAH I K III L M 7000000 Rp 700,000.00 Rp 7,700,000.00 12 MENIKAH II L IV P S 1000000 Rp 50,000.00 Rp 1,050,000.00

Rumus :Gapok : =IF(F4="I"; "5000000";IF(F4="II";"6000000";IF(F4="III";"7000000";IF(F4="IV";"1000000"))))

T. Istri : =IF(F4="i";I4*20%;IF(F4="ii";I4*15%;IF(F4="iii";I4*10%;IF(F4="iv";I4*5%))))Total : =I4+J4

NAMA KARYAWAN

Praktikum 9Laporan Penjualan buku pada toko wahana gramedia di bandung

NO. JUDUL BUKU Jumlah BUKU HARGA SATUAN HARGA TOTAL DISKON PAJAK HARGA DIBAYAR

1 VISUAL BASIC 12 Rp 30,000 Rp 360,000 15% 2.50% Rp 315,000 2 PASCAL 11 Rp 32,000 Rp 352,000 20% 2.50% Rp 290,400 3 MS-WORD 7 Rp 27,000 Rp 189,000 5% 2.50% Rp 184,275 4 MS-EXCEL 13 Rp 28,000 Rp 364,000 15% 2.50% Rp 318,500 5 MS-ACCESS 21 Rp 29,000 Rp 609,000 15% 2.50% Rp 532,875 6 C++ 14 Rp 30,000 Rp 420,000 15% 2.50% Rp 367,500 7 POWER POINT 9 Rp 31,000 Rp 279,000 15% 2.50% Rp 244,125 8 WINDOWS 13 Rp 55,000 Rp 715,000 15% 2.50% Rp 625,625 9 FOTRAN 11 Rp 31,000 Rp 341,000 15% 2.50% Rp 298,375

10 AUTOCAD 12 Rp 45,000 Rp 540,000 15% 2.50% Rp 472,500 11 CORELDRAW 4 Rp 34,000 Rp 136,000 10% 2.50% Rp 125,800 12 MERAKIT KOM. 19 Rp 46,000 Rp 874,000 5% 2.50% Rp 852,150 13 WINDOWS XP 21 Rp 50,000 Rp 1,050,000 5% 2.50% Rp 1,023,750 14 WINDOWS VISTA 20 Rp 50,000 Rp 1,000,000 5% 2.50% Rp 975,000 15 CORELDRAW 11 15 Rp 50,000 Rp 750,000 5% 2.50% Rp 731,250 16 STRUKTUR DATA 14 Rp 52,000 Rp 728,000 5% 2.50% Rp 709,800 17 ARSITEKTUR 12 Rp 62,000 Rp 744,000 5% 2.50% Rp 725,400 18 JAVA 11 Rp 46,000 Rp 506,000 7% 2.50% Rp 483,230 19 WINDOWS NT 5 Rp 50,000 Rp 250,000 7% 2.50% Rp 238,750 20 NOVEL 6 Rp 42,000 Rp 252,000 7% 2.50% Rp 240,660

JUMLAH 250 Rp 820,000 Rp 10,459,000 206% 50.00% Rp 9,754,965

Rumus :Harga Total : =D4*E4Harga Dibayar : =F4-(F4*G4)+(F4*H4)Jumlah Buku, Harga Satuan, Harga Total, Diskon, Pajak, Harga Dibayar : =SUM(D4:D23), =SUM(E4:E23), =SUM(F4:F23), =SUM(G4:G23) =SUM(H4:H23), =SUM(I4:I23)

Praktikum 10

daftar upah lepas pada pt. Gajah tunggal di tangerang jawa barat

NO KODE NAMA LENGKAP KUALIFIKASIJAM JML. JAM Kerja

UPAH(Rp)MASUK PULANG

1 S A Senior 8:00 AM 4:30 PM 08:30:00 AM Rp 1,948 2 Y B Yunior 8:15 AM 3:30 PM 7:15 Rp 1,208 3 S C Senior 7:30 AM 3:45 PM 8:15 Rp 1,891 4 Y D Yunior 7:45 AM 2:45 PM 7:00 Rp 1,167 5 S E Senior 8:00 AM 4:30 PM 8:30 Rp 1,948 6 Y F Yunior 8:15 AM 3:30 PM 7:15 Rp 1,208 7 S G Senior 7:30 AM 3:45 PM 8:15 Rp 1,891 8 Y H Yunior 7:45 AM 2:45 PM 7:00 Rp 1,167 9 S I Senior 8:00 AM 4:30 PM 8:30 Rp 1,948

10 Y J Yunior 8:15 AM 3:30 PM 7:15 Rp 1,208 11 S K Senior 7:30 AM 3:45 PM 8:15 Rp 1,891 12 Y L Yunior 7:45 AM 2:45 PM 7:00 Rp 1,167 13 S M Senior 8:00 AM 4:30 PM 8:30 Rp 1,948 14 Y N Yunior 8:15 AM 3:30 PM 7:15 Rp 1,208 15 S O Senior 7:30 AM 3:45 PM 8:15 Rp 1,891 16 Y P Yunior 7:45 AM 2:45 PM 7:00 Rp 1,167 17 S Q Senior 8:00 AM 4:30 PM 8:30 Rp 1,948 18 Y R Yunior 8:15 AM 3:30 PM 7:15 Rp 1,208 19 S S Senior 7:30 AM 3:45 PM 8:15 Rp 1,891 20 Y T Yunior 7:45 AM 2:45 PM 7:00 Rp 1,167

TOTAL UPAH Rp 31,068 UPAH TERBESAR Rp 1,948 UPAH TERKECIL Rp 1,167

UPAH RATA-RATA Rp 1,553

Rumus :Kualifikasi : =IF(C5="S";"Senior";"Yunior")Jumlah Jam Keja : =G5-F5Upah (Rp) : =IF(C5="S";H5*5500;H5*4000)Total upah : =SUM(I5:I24)

Upah Terbesar, Terkecil, Rata-Rata : =MAX(I5:I24), =MIN(I5:I24), =AVERAGE(I5:I24)

PRAKTIKUM 11REKAPITULASI PENDAPATAN PENJUALAN OBAT APOTIK "SEHAT SELALU"

Nama Obat Nama Obat Harga Obat Bonus Gaji Pokok Total Terima

A1250 A NEOZEP KALBE 250 Rp 1,000 Rp - Rp 150,000 Rp 150,000 C2275 B SANAFLU BAYER 275 Rp 500 Rp - Rp 150,000 Rp 150,000 B3550 C PROCOLD KONIMEX 550 Rp 750 Rp 15,000 Rp 150,000 Rp 165,000 A4400 D DECOLGEN KALBE 400 Rp 1,500 Rp - Rp 150,000 Rp 150,000 B2175 E SANAFLU KONIMEX 175 Rp 500 Rp - Rp 150,000 Rp 150,000 C4300 F DECOLGEN BAYER 300 Rp 1,500 Rp - Rp 150,000 Rp 150,000 A1350 G NEOZEP KALBE 350 Rp 1,000 Rp - Rp 150,000 Rp 150,000 A3600 H PROCOLD KALBE 600 Rp 750 Rp 30,000 Rp 150,000 Rp 180,000 C1525 I NEOZEP BAYER 525 Rp 1,000 Rp 7,500 Rp 150,000 Rp 157,500 C2225 J SANAFLU BAYER 225 Rp 500 Rp - Rp 150,000 Rp 150,000 B4700 K DECOLGEN KONIMEX 700 Rp 1,500 Rp 60,000 Rp 150,000 Rp 210,000 B1375 L NEOZEP KONIMEX 375 Rp 1,000 Rp - Rp 150,000 Rp 150,000 C4650 M DECOLGEN BAYER 650 Rp 1,500 Rp 45,000 Rp 150,000 Rp 195,000 C3200 N PROCOLD BAYER 200 Rp 750 Rp - Rp 150,000 Rp 150,000 C2515 O SANAFLU BAYER 515 Rp 500 Rp 4,500 Rp 150,000 Rp 154,500 B1475 P NEOZEP KONIMEX 475 Rp 1,000 Rp - Rp 150,000 Rp 150,000 B3500 Q PROCOLD KONIMEX 500 Rp 750 Rp - Rp 150,000 Rp 150,000 A3501 R PROCOLD KALBE 501 Rp 750 Rp 300 Rp 150,000 Rp 150,300 A2445 S SANAFLU KALBE 445 Rp 500 Rp - Rp 150,000 Rp 150,000

TOTAL 8011 Rp 17,250 Rp 162,300 Rp 2,850,000 Rp 3,012,300 RATA-RATA 801 Rp 908 Rp 8,542 Rp 150,000 Rp 158,542

NILAI TERTINGGI 700 Rp 1,500 Rp 60,000 Rp 150,000 Rp 210,000 NILAI TERENDAH 175 Rp 500 Rp - Rp 150,000 Rp 150,000

TABEL HARGA TABEL KODE PRODUKSIKODE OBAT NAMA OBAT HARGA OBAT KODE PRODUKSI A B C

1 NEOZEP Rp 1,000 PRODUKSI KALBE KONIMEX BAYER2 SANAFLU Rp 500 3 PROCOLD Rp 750 4 DECOLGEN Rp 1,500

Rumus :Nama Obat, Jumlah Terjual, Produksi, Harga Obat, Bonus, Total Terima : =VLOOKUP(VALUE(MID(B4;2;1)); HARGA; 2), =VALUE(RIGHT(B4;3)) =HLOOKUP(LEFT(B4;1);PRODUKSI;2), =VLOOKUP(VALUE(MID(B4;2;1));HARGA;3), =IF(F4-500>=1; (F4-500)*300;0), =I4+H4

Total Terjual, Harga Obat, Bonus, Gapok, Total Terima : =SUM(F4:F22), =SUM(G4:G22), =SUM(H4:H22), =SUM(I4:I22), =SUM(J4:J22)

Rata-rata Terjual, Harga , Bonus, Gapok, Terima : =AVERAGE(F4:F23), =AVERAGE(G4:G22), =AVERAGE(H4:H22), =AVERAGE(I4:I22), =AVERAGE(J4:J22

Nilai Tertinggi Terjual, Harga , Bonus, Gapok, Terima : =MAX(F4:F22), =MAX(G4:G22), =MAX(H4:H22), =MAX(I4:I22), =MAX(J4:J22)

Nilai Terendah Terjual, Harga , Bonus, Gapok, Terima : =MIN(F4:F22), =MIN(G4:G22), =MIN(H4:H22), =MIN(I4:I22), =MIN(J4:J22)

Nama Salesman

Produksi Oleh

Jumlah Terjual

Praktikum 12nilai akhir ujian semester kelas x.a

No NAMA SISWANILAI

RATA-RATA Nilai NR RANGKING KETERANGANSMT GANJIL SMT GENAP

1 A 77 75 76 D 23 Lulus2 B 76 79 77.5 D 16 Lulus3 C 77 80 78.5 D 12 Lulus4 D 80 71 75.5 D 25 Lulus5 E 65 89 77 D 20 Lulus6 F 78 68 73 E 26 TidakLulus7 G 90 78 84 C 3 Lulus8 H 54 86 70 E 27 TidakLulus9 I 89 75 82 C 8 Lulus

10 J 74 80 77 D 20 Lulus11 K 72 85 78.5 D 12 Lulus12 L 76 79 77.5 D 16 Lulus13 M 71 69 70 E 27 TidakLulus14 N 76 89 82.5 C 6 Lulus15 O 88 79 83.5 C 4 Lulus16 P 78 77 77.5 D 16 Lulus17 Q 79 80 79.5 D 11 Lulus18 R 73 81 77 D 20 Lulus19 S 67 85 76 D 23 Lulus20 T 66 89 77.5 D 16 Lulus21 U 63 70 66.5 E 29 TidakLulus22 V 75 89 82 C 8 Lulus23 W 76 87 81.5 C 10 Lulus24 X 77 88 82.5 C 6 Lulus25 Y 78 79 78.5 D 12 Lulus26 Z 74 82 78 D 15 Lulus27 AA 87 84 85.5 B 1 Lulus28 AB 86 85 85.5 B 1 Lulus29 AC 82 84 83 C 5 Lulus30 AD 69 85 77 D 20 Lulus

Rumus :Rata-rata : =AVERAGE(D5:E5)Nilai NR : =IF(F5>90;"A";IF(F5>85;"B";IF(F5>80;"C";IF(F5>75;"D";"E"))))

Rangking : =RANK(F5;$F$4:$F$33;0)Keterangan : =IF(F5>=75;"Lulus";"TidakLulus")

LEMBAR KERJA SISWA PRAKTIKUM MICROSOFT EXCEL

MATA PELAJARAN TEKNOLOGI INFORMASI DAN KOMUNIKASI

KELAS XISEMESTER II

OLEH :

HIZKIA GLORIUS SOMAXI IPA C

SMA NEGERI 3 PALOPOTAHUN 2011/2012

praktikum tik hizkia glorius (recovered)

Documents