ulanganus cindy natalia

Download Ulanganus Cindy Natalia

If you can't read please download the document

Upload: ravenilia29

Post on 20-Feb-2016

214 views

Category:

Documents


2 download

DESCRIPTION

Excel

TRANSCRIPT

Sheet1

Laporan Penjualan

Toko Elektronik "GELORA"

No.Nama PembeliJumlah BeliKode BarangJenis BarangHarga SatuanJumlah BayarDiskonJumlah BersihBonus

Urut

1Iwan2101AC90Komputer AcerRp2,000,000.00Rp4,000,000.00Rp200,000.00Rp3,800,000.00

2Susi3202BK90TV LGRp750,000.00Rp2,250,000.00Rp112,500.00Rp2,137,500.00

3Setiawan4203CT90Kulkas SharpRp650,000.00Rp2,600,000.00Rp130,000.00Rp2,470,000.00

4Budi3104DV90Video LGRp700,000.00Rp2,100,000.00Rp105,000.00Rp1,995,000.00

5Dadan2105ER90Radio SanyoRp250,000.00Rp500,000.00Rp25,000.00Rp475,000.00

6Bambang2203BK90Kulkas SharpRp650,000.00Rp1,300,000.00Rp65,000.00Rp1,235,000.00

7Sari1101AC90Komputer AcerRp2,000,000.00Rp2,000,000.00Rp0.00Rp2,000,000.00

8Eka2104CV90Video LGRp700,000.00Rp1,400,000.00Rp70,000.00Rp1,330,000.00

TotalRp15,442,500.00

MaksimumRp3,800,000.00

MinimumRp475,000.00

Rata-rataRp1,930,312.50