Download - 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)
no kode kereta `jenis harga
1 e EKONOMI 25000
2 k EKSKLUSIF 55000
proses (nota)
no kode kereta `jenis harga
1 e EKONOMI 25000
2 k EKSKLUSIF 55000
proses (nota)
no kode kereta `jenis harga
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
kembalian Rp 40,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
kembalian Rp 45,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
kembalian Rp 25,000.00
Ekonomi Eksklusif
pesanan 1 80 pesanan 1 90
pesanan 2 12 pesanan 2 12
pesanan 3 15 pesanan 3 16
pesanan 4 56 pesanan 4 45
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