A | B | C | D | E | F | G | H | I | J | K | L | M |
NO | Pembeli | Kode | Nama | Jumlah | Harga | Kode | Nama | Jumlah | Harga | Pembayaran | Pajak | Pembayaran |
Baju | Baju | Pembelian | Satuan Baju (Rp) | Celana | Celana | Pembelian | Satuan Celana | 10% | Akhir |
1 | Sulis | WRN1 | NEVADA | 3 | 30,000 | HA | HASENDA | 2 | 150,000 | 390,000 | 39,000 | 429,000 |
2 | Hadad | WRN2 | GUESS | 4 | 35,000 | LO | LOUIS | 3 | 175,000 | 665,000 | 66,500 | 731,500 |
3 | Abinsa | WRN3 | ZARA | 2 | 50,000 | LE | LEA | 1 | 200,000 | 300,000 | 30,000 | 330,000 |
4 | Romeo | WRN2 | GUESS | 6 | 35,000 | LE | LEA | 4 | 200,000 | 1,010,000 | 101,000 | 1,111,000 |
5 | Dani | WRN1 | NEVADA | 4 | 30,000 | LO | LOUIS | 5 | 175,000 | 995,000 | 99,500 | 1,094,500 |
6 | Joko | WRN3 | ZARA | 7 | 50,000 | HA | HASENDA | 2 | 150,000 | 650,000 | 65,000 | 715,000 |
7 | Zahra | WRN3 | ZARA | 8 | 50,000 | LE | LEA | 3 | 200,000 | 1,000,000 | 100,000 | 1,100,000 |
8 | David | WRN2 | GUESS | 9 | 35,000 | LE | LEA | 4 | 200,000 | 1,115,000 | 111,500 | 1,226,500 |
9 | Hanif | WRN1 | NEVADA | 10 | 30,000 | LO | LOUIS | 7 | 175,000 | 1,525,000 | 152,500 | 1,677,500 |
10 | Ana | WRN1 | NEVADA | 2 | 30,000 | LO | LOUIS | 3 | 175,000 | 585,000 | 58,500 | 643,500 |
| | | | | | | | | | | | |
KODE | WRN1 | WRN2 | WRN3 | HA | LO | LE | | | | | | |
NAMA | NEVADA | GUESS | ZARA | HASENDA | LOUIS | LEA | | Total pembayaran akhir | | Rp. | 8,629,500 |
SATUAN | 30000 | 35000 | 50000 | 150000 | 175000 | 200000 | | Jumlah pembeli pakaian terbanyak | | 10 |
| | | | | | | | Pajak terkecil | | Rp. | 30,000 |
| | | | | | | | Rata-rata pembayaran | | Rp. | 871,667 |
| | | | | | | | Banyaknya pembeli hari ini | | | 10 |
| | | | | | | | Banyaknya transaksi hari ini | | | 10 |
| | | | | | | | Jumlah pembelian baju | | | 55 |
| | | | | | | | Jumlah pembelian celana | | | 34 |
mas....
BalasHapusklw daftar harga herbal, ada ga mas...???