Kamis, 12 Januari 2012

belajar excel sama pak rahmad

Diposting oleh Kadek Puspitasari di 16.47 0 komentar
Laporan Penjualan PT.Anugrah
Periode Maret-April 2009
Jl.Ahmad Nurdin No.555 Kayuangung Sumatra Selatan 
Telp. 0712-5681223 Fax. 0712-568121
             







No Nama Barang Unit harga satuan Total Diskon Bayar
1 mouse 25  Rp 45,000.00  Rp       1,125,000.00  Rp        56,250.00  Rp1,068,750.00
2 keyboard 15  Rp 55,000.00  Rp         825,000.00  Rp        41,250.00  Rp   783,750.00
3 speaker 10  Rp 85,000.00  Rp         850,000.00  Rp        42,500.00  Rp   807,500.00
4 mouse pad 35  Rp   4,500.00  Rp         157,500.00  Rp          7,875.00  Rp   149,625.00
5 fdisk 1 GB 20  Rp 65,000.00  Rp       1,300,000.00  Rp        65,000.00  Rp1,235,000.00







TOTAL PENDAPATAN  Rp4,044,625.00














keterangan




Total = Unit*Harga Satuan



Diskon, diberikan





sebesar 5%* total



Bayar= Total-diskon



 

coret coretan si perawat dekpus Copyright © 2010 Design by Ipietoon Blogger Template Graphic from Enakei