Laporan Penjualan dan Gaji.xlsx

	B	C	D	E	F	G	H	I	J	K	L	M
1
2	LAPORAN PENJUALAN BARANG ELEKTRONIK
3	PT. JIRSA ELECTRIC
4
5	No	Nama Barang	Harga Beli	Biaya Ongkos	Harga Satuan	Jumlah Terjual	Jumlah Harga	Diskon 20%	Bonus 1%	Total Harga	PPN 5%	Laba Bersih
6	1	Televisi Toshiba 20	1600000	20000	1620000	5	8100000	1620000	81000	6561000	328050	6232950
7	2	Genset Eiji Gold Star	1600000	250000	1850000	4	7400000	1480000	74000	5994000	299700	5694300
8	3	VCD Compo Sony	3200000	150000	3350000	3	10050000	2010000	100500	8140500	407025	7733475
9	4	Tape Deck Kenwood	850000	100000	950000	2	1900000	380000	19000	1539000	76950	1462050
10	5	Mini Compo Polytron	1750000	200000	1950000	6	11700000	2340000	117000	9477000	473850	9003150
11	6	Speaker Active Altair	750000	150000	900000	12	10800000	2160000	108000	8748000	437400	8310600
12	7	Microwave Sharp	1500000	180000	1680000	1	1680000	336000	16800	1360800	68040	1292760
13	8	AC Split National	3500000	300000	3800000	2	7600000	1520000	76000	6156000	307800	5848200
14	9	Mesin Cuci Samsung	2300000	150000	2450000	10	24500000	4900000	245000	19845000	992250	18852750
15	10	Kompor Listrik Maspion	500000	100000	600000	15	9000000	1800000	90000	7290000	364500	6925500
16
17
18
19
20
21	LAPORAN GAJI PEGAWAI
22	PT. SELARAS MAKMUR
23
24	No	Nama Pegawai	Jabatan Posisi	Gaji Pokok	UANG Trans	UANG Makan	Tunjangan	Gaji Kotor	Potongan Askes	PPh	Potongan Astek	Gaji Bersih
25	1	Marselina	PRD	8500000	2550000	1275000	425000	12750000	956250	318750	637500	10837500
26	2	Jaquelin	Finance	6000000	1800000	900000	300000	9000000	675000	225000	450000	7650000
27	3	Aldy Zahran	Accounting	7500000	2250000	1125000	375000	11250000	843750	281250	562500	9562500
28	4	Ryan Munthar	Purchaser	5000000	1500000	750000	250000	7500000	562500	187500	375000	6375000
29	5	Fenny Laura	EDP	8000000	2400000	1200000	400000	12000000	900000	300000	600000	10200000
30	6	Camellia Linda	Operator	5000000	1500000	750000	250000	7500000	562500	187500	375000	6375000
31	7	Prisca Suwintaty	Supervisor	8500000	2550000	1275000	425000	12750000	956250	318750	637500	10837500
32	8	Fery Danu	Supervisor	9000000	2700000	1350000	450000	13500000	1012500	337500	675000	11475000
33	9	Rhey Jilson	Advertising	6000000	1800000	900000	300000	9000000	675000	225000	450000	7650000
34	10	Reza Syawlani	Marketing	5000000	1500000	750000	250000	7500000	562500	187500	375000	6375000
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100