| LAPORAN PENGHASILAN KURSUS KOMPUTER | |||||||
|---|---|---|---|---|---|---|---|
| No. | Nama | Kode | Kelas | Tgl. Mendaftar | Biaya | Diskon | Jumlah Biaya |
| 1 | Hilman | A | Yunior Programmer | 1-Sep-04 | Rp1,000,000 | Rp300,000 | Rp700,000 |
| 2 | Anton | C | Ms. Office | 5-Sep-04 | Rp1,200,000 | Rp- | Rp1,200,000 |
| 3 | George | C | Ms. Office | 2-Sep-04 | Rp1,200,000 | Rp360,000 | Rp840,000 |
| 4 | Joshua | B | Programmer | 17-Sep-04 | Rp2,000,000 | Rp- | Rp2,000,000 |
| 5 | Fakhrudin | C | Ms. Office | 1-Sep-04 | Rp1,200,000 | Rp360,000 | Rp840,000 |
| 6 | Agung | B | Programmer | 11-Sep-04 | Rp2,000,000 | Rp- | Rp2,000,000 |
| 7 | Antono | C | Ms. Office | 19-Sep-04 | Rp1,200,000 | Rp- | Rp1,200,000 |
| 8 | Rafles | C | Ms. Office | 10-Sep-04 | Rp1,200,000 | Rp- | Rp1,200,000 |
| 9 | Annabel | B | Programmer | 5-Sep-04 | Rp2,000,000 | Rp- | Rp2,000,000 |
| 10 | Erwin | B | Programmer | 30-Sep-04 | Rp2,000,000 | Rp- | Rp2,000,000 |
| 11 | Pasha | A | Yunior Programmer | 11-Sep-04 | Rp1,000,000 | Rp- | Rp1,000,000 |
| 12 | Diah | A | Yunior Programmer | 5-Sep-04 | Rp1,000,000 | Rp- | Rp1,000,000 |
| Kode | Kelas | Biaya | |||||
| A | Yunior Programmer | 1000000 | |||||
| B | Programmer | 2000000 | |||||
| C | Ms. Office | 1200000 | |||||
| *** Jika mendaftar kurang dari tanggal 5 September 2004 mendapat diskon 30% dari biaya yang dibayar | |||||||
Sabtu, 27 April 2013
Kasus 8a
Kasus 8b
| LAPORAN PENJUALAN BARANG | |||||||||
|---|---|---|---|---|---|---|---|---|---|
| No. | Nama | Kode | Jumlah | Jenis Barang | Jenis Musik | Harga Dasar | Tarip Tambahan | Jumlah CD | Harga Barang |
| 1 | Firdaus | CPIN | 2 | CD | Pop Indonesia | Rp20,000 | Rp20,000 | ||
| 2 | Fira | CRIN | 5 | CD | Rock Indonesia | Rp20,000 | Rp24,000 | ||
| 3 | Ita Rosit a | KPBA | 2 | Kaset | Pop Barat | Rp18,000 | Rp25,200 | ||
| 4 | Evie | DCBA | 1 | DVD | Classic Barat | Rp40,000 | Rp70,000 | ||
| 5 | Amien | CRIN | 6 | CD | Rock Indonesia | Rp20,000 | Rp24,000 | ||
| 6 | Emmie | CPIN | 1 | CD | Pop Indonesia | Rp20,000 | Rp20,000 | ||
| 7 | Ayu | MRBA | 4 | MP3 | Rock Barat | Rp15,000 | Rp22,500 | ||
| 8 | Dirman | VIND | 3 | VCD | India | Rp25,000 | Rp27,500 | ||
| 9 | Etika | DMAN | 3 | DVD | Mandarin | Rp40,000 | Rp42,000 | ||
| 10 | Ani Sofia | MRBA | 4 | MP3 | Rock Barat | Rp15,000 | Rp22,500 | ||
| 11 | Dian | CMAN | 7 | CD | Mandarin | Rp20,000 | Rp21,000 | ||
| 12 | Irfan | VCBA | 1 | VCD | Classic Barat | Rp25,000 | Rp43,750 | ||
| Kode | Jenis Barang | Harga Dasar | |||||||
| C | CD | 20000 | |||||||
| D | DVD | 40000 | |||||||
| K | Kaset | 18000 | |||||||
| M | MP3 | 15000 | |||||||
| V | VCD | 25000 | |||||||
| *** Jika beli CD lebih 3 mendapat bonus 1 CD dan berlaku kelipatannya | |||||||||
| Kode2 | Jenis Musik | Tarip Tambahan | |||||||
| CBA | Classic Barat | 75% | |||||||
| IND | India | 10% | |||||||
| MAN | Mandarin | 5% | |||||||
| MIN | Melayu Indonesia | 0% | |||||||
| PBA | Pop Barat | 40% | |||||||
| PIN | Pop Indonesia | 0% | |||||||
| QIN | Qasidah Indonesia | 0% | |||||||
| RBA | Rock Barat | 50% | |||||||
| RIN | Rock Indonesia | 20% |
Kasus 7b
| LAPORAN PENJUALAN MEUBEL | |||||||||
|---|---|---|---|---|---|---|---|---|---|
| No. | Nama | Kode | MEREK | JNS BARANG | SALES | HARGA | JML BRG | JML HARGA | HRG. DIBAYAR |
| 1 | Daniel | LAL350-A | Lutino | Almari | ANDI | 2 | |||
| 2 | David | GRB250-B | Gabriele | Rak Buku | BONDAN | 1 | |||
| 3 | Herry Kiswanto | OMB475-A | Olympus | Meja Belajar | ANDI | 3 | |||
| 4 | Iswadi | LMK760-C | Lutino | Meja Kerja | CITRA | 4 | |||
| 5 | Michael | GRB250-B | Gabriele | Rak Buku | BONDAN | 2 | |||
| 6 | Pavel Nedved | LMB475-C | Lutino | Meja Belajar | CITRA | 3 | |||
| 7 | Roberto | LMB475-A | Lutino | Meja Belajar | ANDI | 4 | |||
| 8 | Romario | OMK760-D | Olympus | Meja Kerja | DARSONO | 3 | |||
| 9 | Ronald | LRB250-B | Lutino | Rak Buku | BONDAN | 2 | |||
| 10 | Ronney | ORB250-B | Olympus | Rak Buku | BONDAN | 1 | |||
| 11 | Ruddy | LMB475-C | Lutino | Meja Belajar | CITRA | 4 | |||
| 12 | Zinedine | GMB475-A | Gabriele | Meja Belajar | ANDI | 4 | |||
| KODE (dijit ke-2 & 3) | AL | MB | MK | RB | |||||
| JENIS BARANG | Almari | Meja Belajar | Meja Kerja | Rak Buku | |||||
| HARGA DASAR | 4750000 | 1250000 | 2500000 | 1850000 | |||||
| KODE | MEREK | HARGA UP | |||||||
| G | Gabriele | 15% | |||||||
| L | Lutino | 20% | |||||||
| O | Olympus | 25% |
Kasus 7a
| LAPORAN PENJUALAN TIKET BUS | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|
| No. | Nama | Kode | Nama Bus | Jurusan | Kelas | Tarip Dasar | Tarip Tambahan | Jumlah Tiket | Harga Tiket | Jam Berangkat |
| 1 | Ade Nuraeli | LO-SE01 | Lorena | Jakarta-Denpasar | Super Eksekutif | 220000 | 165000 | 1 | ||
| 2 | Nurzaman | LO-SE03 | Lorena | Jakarta-Denpasar | Super Eksekutif | 220000 | 165000 | 1 | ||
| 3 | Maurizka | SN-BS02 | Setia Negara | Jakarta-Semarang | Bisnis | 120000 | 30000 | 2 | ||
| 4 | Maulita | LU-EK02 | Luragung Jaya | Jakarta-Cirebon | Ekonomi | 40000 | 0 | 2 | ||
| 5 | Sesha | SH-SE01 | Sahabat | Jakarta-Kuningan | Super Eksekutif | 60000 | 45000 | 1 | ||
| 6 | Iyop Ropika | SJ-EX03 | Sami Jaya | Jakarta-Surabaya | Eksekutif | 190000 | 95000 | 2 | ||
| 7 | Yully | SN-BS02 | Setia Negara | Jakarta-Semarang | Bisnis | 120000 | 30000 | 2 | ||
| 8 | Agus | LU-EK02 | Luragung Jaya | Jakarta-Cirebon | Ekonomi | 40000 | 0 | 4 | ||
| 9 | Annabel | LO-SE03 | Lorena | Jakarta-Denpasar | Super Eksekutif | 220000 | 165000 | 1 | ||
| 10 | Arief | SN-EX02 | Setia Negara | Jakarta-Semarang | Eksekutif | 120000 | 60000 | 2 | ||
| 11 | Fajar | LU-EK01 | Luragung Jaya | Jakarta-Cirebon | Ekonomi | 40000 | 0 | 4 | ||
| 12 | Nugroho | SH-SE03 | Sahabat | Jakarta-Kuningan | Super Eksekutif | 60000 | 45000 | 2 | ||
| NOTE : | ||||||||||
| Jika pembelian tiket lebih dari 2 mendapatkan diskon sebesar 15% dan jika beli 2 tiket mendapat diskon 10% | ||||||||||
| Kode | Nama Bus | Jurusan | Tarip Dasar | |||||||
| LO | Lorena | Jakarta-Denpasar | 220000 | |||||||
| LU | Luragung Jaya | Jakarta-Cirebon | 40000 | |||||||
| SH | Sahabat | Jakarta-Kuningan | 60000 | |||||||
| SJ | Sami Jaya | Jakarta-Surabaya | 190000 | |||||||
| SN | Setia Negara | Jakarta-Semarang | 120000 | |||||||
| Kode2 | Kelas | Tarip Tambahan | ||||||||
| BS | Bisnis | 25% | ||||||||
| EK | Ekonomi | 0% | ||||||||
| EX | Eksekutif | 50% | ||||||||
| SE | Super Eksekutif | 75% | ||||||||
| Kode3 | Jam Berangkat | |||||||||
| 01 | 5:45 | |||||||||
| 02 | 8:35 | |||||||||
| 03 | 15:10 |
Kasus 6b
| MEMBUAT REKAP NILAI MAHASISWA | ||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| No. | Nama | Nip | Nilai | UTS | UAS | Tugas | Presensi | Total Nilai | Nilai huruf | Keterangan | ||
| UTS | UAS | Tugas | 30% | 35% | 20% | 15% | ||||||
| 1 | Nia Devianti | 2004001 | 50 | 70 | 60 | 15.0 | 24.5 | 12.0 | ||||
| 2 | Effendi | 2004002 | 80 | 90 | 89 | 24.0 | 31.5 | 17.8 | ||||
| 3 | Micky | 2004003 | 70 | 60 | 78 | 21.0 | 21.0 | 15.6 | ||||
| 4 | Rocky | 2004004 | 90 | 78 | 75 | 27.0 | 27.3 | 15.0 | ||||
| 5 | Raisa | 2004005 | 89 | 80 | 70 | 26.7 | 28.0 | 14.0 | ||||
| 6 | Neney | 2004006 | 60 | 60 | 70 | 18.0 | 21.0 | 14.0 | ||||
| 7 | Rosita | 2004007 | 40 | 40 | 60 | 12.0 | 14.0 | 12.0 | ||||
| 8 | Donald | 2004008 | 99 | 97 | 90 | 29.7 | 34.0 | 18.0 | ||||
| 9 | Reza | 2004009 | 90 | 89 | 90 | 27.0 | 31.2 | 18.0 | ||||
| 10 | Ronney | 2004010 | 50 | 0 | 60 | 15.0 | 0.0 | 12.0 | ||||
| 11 | Ruddy | 2004011 | 96 | 98 | 97 | 28.8 | 34.3 | 19.4 | ||||
| 12 | Ari Aryanti | 2004012 | 85 | 70 | 70 | 25.5 | 24.5 | 14.0 | ||||
| Note : | ||||||||||||
| Jika nilai huruf = "C" atau "D", maka dinyatakan Remidi | ||||||||||||
| Jika nilai huruf = "E", maka dinyatakan Ujian Ulang | ||||||||||||
| Jika nilai huruf = "B", maka dinyatakan Lulus | ||||||||||||
| Jika nilai huruf = "A", maka mendapatkan Bea Siswa |
Kasus 6a
| PROGRAM STUDI ADMINISTRASI NIAGA | |||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Th. AKADEMIK 2011/2012 | |||||||||||||||||||||||
| PROGRAM DIPLOMA III - SEMESTER - 2 | |||||||||||||||||||||||
| Komputer Bisnis 2 | |||||||||||||||||||||||
| No. | N.I.M | Nama | Jumlah Pertemuan | ABSENSI | |||||||||||||||||||
| 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | S | I | A | JH | TP | |||
| 1 | 2004001 | Nia Devianti | ü | ü | ü | ü | ü | ü | ü | ü | ü | ü | ü | ü | ü | ü | ü | ü | 0 | 0 | 0 | ||
| 2 | 2004002 | Effendi | ü | ü | S | ü | ü | ü | ü | ü | ü | ü | ü | ü | ü | S | ü | ü | 2 | 0 | 0 | ||
| 3 | 2004003 | Micky | ü | ü | ü | ü | ü | ü | ü | S | ü | ü | ü | ü | ü | ü | ü | ü | 1 | 0 | 0 | ||
| 4 | 2004004 | Rocky | ü | ü | ü | ü | ü | ü | ü | ü | ü | ü | A | ü | ü | ü | ü | ü | 0 | 0 | 1 | ||
| 5 | 2004005 | Raisa | ü | ü | A | ü | A | ü | ü | ü | ü | ü | ü | ü | ü | ü | ü | ü | 0 | 0 | 2 | ||
| 6 | 2004006 | Nency | ü | ü | A | A | A | ü | ü | ü | ü | ü | ü | ü | ü | ü | S | ü | 1 | 0 | 3 | ||
| 7 | 2004007 | Rosita | ü | ü | I | ü | ü | ü | I | I | I | ü | ü | ü | ü | ü | ü | A | 0 | 4 | 1 | ||
| 8 | 2004008 | Donald | ü | ü | S | A | A | ü | ü | ü | ü | ü | ü | ü | ü | ü | ü | ü | 1 | 0 | 2 | ||
| 9 | 2004009 | Reza | ü | ü | ü | ü | ü | ü | ü | ü | ü | ü | ü | ü | ü | ü | ü | ü | 0 | 0 | 0 | ||
| 10 | 2004010 | Ronney | ü | ü | ü | A | A | A | ü | ü | A | A | A | A | ü | ü | A | ü | 0 | 0 | 8 | ||
| 11 | 2004011 | Ruddy | ü | ü | ü | ü | ü | ü | ü | ü | ü | ü | ü | ü | ü | ü | ü | ü | 0 | 0 | 0 | ||
| 12 | 2004012 | Ari Aryanti | ü | ü | ü | ü | ü | ü | ü | ü | ü | ü | ü | ü | ü | ü | ü | ü | 0 | 0 | 0 | ||
| Range/Konversi Nilai | |||||||||||||||||||||||
| 81-100 ==> A | S = Sakit | ||||||||||||||||||||||
| 66-80 ==> B | I = Ijin | ||||||||||||||||||||||
| 56-65 ==> C | A = Alpa | ||||||||||||||||||||||
| 46-55 ==> D | JH = Jumlah Hadir | ||||||||||||||||||||||
| 0-45 ==> E | TP = Total Pertemuan |
Kasus 5b
| MEMBUAT REKAP UPAH LEMBUR KARYAWAN | |||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|
| No. | Nama | Nip | Tgl. Masuk Kerja | Gol | Gaji Pokok | Jml. Jam Lembur | Upah Lembur | Upah Makan | Gaji Kotor | Gaji Bersih | |
| 1 | Zulham | 10110 | 1-Jun-80 | 1 | 7,000,000 | 50 | - | - | |||
| 2 | Iswadi | 10112 | 12-Nov-83 | 3 | 2,500,000 | - | 20,000 | 75,000.00 | |||
| 3 | Ronald | 10114 | 3-Jan-86 | 3 | 2,500,000 | 45 | 20,000 | 75,000.00 | |||
| 4 | Herry Kiswanto | 10116 | 4-Jul-03 | 2 | 4,500,000 | 30 | 25,000 | 100,000.00 | |||
| 5 | Daniel | 10118 | 5-Dec-88 | 3 | 2,500,000 | 15 | 20,000 | 75,000.00 | |||
| 6 | Roberto | 10120 | 6-Jan-81 | 2 | 4,500,000 | 12 | 25,000 | 100,000.00 | |||
| 7 | David | 10122 | 7-Jan-04 | 3 | 2,500,000 | 24 | 20,000 | 75,000.00 | |||
| 8 | Zinedine | 10124 | 28-Dec-94 | 1 | 7,000,000 | 8 | - | - | |||
| 9 | Pavel Nedved | 10126 | 8-Feb-94 | 3 | 2,500,000 | 47 | 20,000 | 75,000.00 | |||
| 10 | Ronney | 10128 | 18-Jan-97 | 2 | 4,500,000 | 65 | 25,000 | 100,000.00 | |||
| 11 | Michel | 10130 | 8-Nov-94 | 4 | 1,500,000 | 55 | 15,000 | 50,000.00 | |||
| 12 | Romario | 10132 | 8-Oct-95 | 4 | 1,500,000 | - | 15,000 | 50,000.00 | |||
| 13 | Ruddy | 10134 | 18-Jan-90 | 4 | 1,500,000 | 3 | 15,000 | 50,000.00 | |||
| GOL | GAJI POKOK | Upah lembur/ jam | Upah Lembur Per | Uang Makan | |||||||
| jam (>60 jam) | (Lembur> | ||||||||||
| 30 jam) | |||||||||||
| 1 | 7000000 | - | - | - | |||||||
| 2 | 4500000 | 25000 | 75000 | 100000 | |||||||
| 3 | 2500000 | 20000 | 50000 | 75000 | |||||||
| 4 | 1500000 | 15000 | 40000 | 50000 | |||||||
| Catatan : | Pajak 12% hanya dikenakan pada karyawan dengan gaji kotor minimal 2500000 |
Kasus 5a
| LAPORAN PENGHASILAN HOTEL | |||||||||
|---|---|---|---|---|---|---|---|---|---|
| NO. | NAMA | CHECK IN | CHECK OUT | TIPE | HARGA KAMAR | LAMA MENGINAP | JML.BIAYA | DISCOUNT | TOTAL BIAYA |
| KAMAR | |||||||||
| 1 | Ani sofia | 17-Sep-04 | 19-Sep-04 | Standart | Rp1,000,000 | 2 hari | Rp2,000,000 | - | Rp2,200,000 |
| 2 | Dewi | 29-Sep-04 | 2-Oct-04 | Deluxe | Rp1,750,000 | 3 hari | Rp5,250,000 | 367,500 | Rp5,407,500 |
| 3 | Evelina | 19-Sep-04 | 30-Sep-04 | Deluxe | Rp1,750,000 | 11 hari | Rp19,250,000 | 2,887,500 | Rp18,287,500 |
| 4 | Irene | 30-Sep-04 | 19-Oct-04 | Standart | Rp1,000,000 | 19 hari | Rp19,000,000 | 2,850,000 | Rp18,050,000 |
| 5 | Ratih | 25-Sep-04 | 29-Sep-04 | Standart | Rp1,000,000 | 4 hari | Rp4,000,000 | 280,000 | Rp4,120,000 |
| 6 | Risdianto | 19-Sep-04 | 20-Sep-04 | Superior | Rp1,225,000 | 1 hari | Rp1,225,000 | - | Rp1,347,500 |
| 7 | Sari | 29-Sep-04 | 19-Oct-04 | Standart | Rp1,000,000 | 20 hari | Rp20,000,000 | 3,000,000 | Rp19,000,000 |
| 8 | Taufan | 30-Sep-04 | 5-Oct-04 | Superior | Rp1,225,000 | 5 hari | Rp6,125,000 | 612,500 | Rp6,125,000 |
| 9 | Ursula | 30-Sep-04 | 3-Oct-04 | Deluxe | Rp1,750,000 | 3 hari | Rp5,250,000 | 367,500 | Rp5,407,500 |
| TIPE KAMAR | HARGA KAMAR | ||||||||
| Proses : | "Semua pembayaran dikenakan pajak 10%" | ||||||||
| Deluxe | 1,750,000 | -Jika customer menginap lebih dari 3 (tiga) hari maka mendapat discount 7% | |||||||
| Standart | 1,000,000 | -Jika customer menginap lebih dari 5(lima) hari maka mendapat discount 10% | |||||||
| Superior | 1,225,000 | - Jika customer menginap lebih dari 10(sepuluh) hari maka mendapat discount 15% |
Langganan:
Postingan
(
Atom
)