File Materi Pivot Table

Download as xlsx, pdf, or txt
Download as xlsx, pdf, or txt
You are on page 1of 29

LAPORAN PENJUALAN BARANG

PT.MAKMUR SELALU

Nama Cabang No Dokumen Tanggal Dokumen Nama Salesman Kode Langganan


Bogor 15801 8/12/2015 Juniansyah 450419
Bogor 15802 450379
Bogor 15803 450093
Bogor 15804 8/13/2015 Arief 458224
Bogor 15805 450066
Bogor 15806 450373
Bogor 15807 452698
Bogor 15808 450366
TOTAL PENJUALAN
Sukabumi 15809 8/11/2015 Indra 462862
15810 461780
15811 460651
15812 8/13/2015 Dede 461626
15813 468206
15814 460360
TOTAL PENJUALAN
Cianjur 15815 8/11/2015 Ahmad Ramdan 477474
15816 477348
15817 470478
15818 470087
15819 450205
TOTAL PENJUALAN
ANG

Nama Langganan Total Penjualan


BUBULAK JAYA 1,207,600
TK. RDH 306,800
SETIA JAYA 294,000
HURIPAN JAYA TK 279,600
BPK. MASUM 257,600
JEMBAR JAYA PUTRA 209,700
MANDALING JAYA 178,500
SINAR KETAPANG 166,500
TOTAL PENJUALAN 2,900,300
TRI UTAMI 153,300
TK.RUDI 117,900
BANDUNG JAYA 110,100
TAOPIK 96,300
PEK CAN 96,000
HIDAYAT 92,400
TOTAL PENJUALAN 666,000
ADE BPK 89,100
TK. SUMBER REZEKI 87,000
ANDI TK / YUSUP W 85,200
ANTON 71,400
HENY 64,500
TOTAL PENJUALAN 397,200
Nama Cabang No Dokumen Tanggal Dokumen Nama Salesman Kode Langganan
Cianjur 15819 8/11/2015 Ahmad Ramdan 450205
Cianjur 15818 8/11/2015 Ahmad Ramdan 470087
Cianjur 15817 8/11/2015 Ahmad Ramdan 470478
Cianjur 15816 8/11/2015 Ahmad Ramdan 477348
Cianjur 15815 8/11/2015 Ahmad Ramdan 477474
Sukabumi 15814 8/13/2015 Dede 460360
Sukabumi 15813 8/13/2015 Dede 468206
Sukabumi 15812 8/13/2015 Dede 461626
Sukabumi 15811 8/11/2015 Indra 460651
Sukabumi 15810 8/11/2015 Indra 461780
Sukabumi 15809 8/11/2015 Indra 462862
Bogor 15808 8/13/2015 Arief 450366
Bogor 15807 8/13/2015 Arief 452698
Bogor 15806 8/13/2015 Arief 450373
Bogor 15805 8/13/2015 Arief 450066
Bogor 15804 8/13/2015 Arief 458224
Bogor 15803 8/12/2015 Juniansyah 450093
Bogor 15802 8/12/2015 Juniansyah 450379
Bogor 15801 8/12/2015 Juniansyah 450419
Nama Langganan Total Penjualan
HENY 64,500
ANTON 71,400
ANDI TK / YUSUP W 85,200
TK. SUMBER REZEKI 87,000
ADE BPK 89,100
HIDAYAT 92,400
PEK CAN 96,000
TAOPIK 96,300
BANDUNG JAYA 110,100
TK.RUDI 117,900
TRI UTAMI 153,300
SINAR KETAPANG 166,500
MANDALING JAYA 178,500
JEMBAR JAYA PUTRA 209,700
BPK. MASUM 257,600
HURIPAN JAYA TK 279,600
SETIA JAYA 294,000
TK. RDH 306,800
BUBULAK JAYA 1,207,600
Penjualan Produk Elektronik Toko " Maju Jaya"

Tanggal Produk Kategori Sales Harga Komisi


6/1/2023 Samsung AC Soleh 2,500,000 300000
6/2/2023 Sony TV Soleh 1,500,000 180000
6/3/2023 LG Kulkas Andis 7,500,000 900000
6/4/2023 LG AC Rita 2,500,000 300000
6/5/2023 LG AC Andis 1,750,000 210000
6/6/2023 Samsung Kulkas Rita 4,500,000 540000
6/7/2023 Microsoft Smartphone Rita 950,000 114000
6/8/2023 Microsoft Smartphone Soleh 1,200,000 144000
6/9/2023 Miyako Dispenser Soleh 200,000 24000
6/10/2023 Samsung Kulkas Andis 3,400,000 408000
6/11/2023 Sony TV Rita 1,750,000 210000
6/11/2023 GE Microwave Soleh 1,500,000 180000
6/12/2023 Samsung TV Edward 8,000,000 960000
6/13/2023 LG TV Rita 5,500,000 660000
6/14/2023 Miyako Dispenser Soleh 250,000 30000
6/15/2023 JVC Handycam Edward 10,000,000 1200000
6/16/2023 Samsung AC Andis 1,750,000 210000
6/17/2023 JVC Handycam Andis 13,000,000 1560000
6/18/2023 Canon Kamera Digital Edward 4,750,000 570000
6/19/2023 Sony AC Rita 1,000,000 120000
6/20/2023 Sony TV Rita 3,500,000 420000
6/21/2023 Miyako Dispenser Rita 250,000 30000
6/22/2023 LG Kulkas Andis 6,500,000 780000
6/23/2023 Nikon Kamera Digital Andis 7,500,000 900000
6/24/2023 Nikon Kamera Digital Soleh 5,600,000 672000
6/25/2023 Samsung Kulkas Soleh 6,600,000 792000
6/26/2023 JVC Sound System Soleh 1,250,000 150000
6/27/2023 Panasonic Sound System Soleh 3,000,000 360000
6/28/2023 Panasonic Sound System Edward 4,600,000 552000
6/29/2023 Nikon Kamera Digital Edward 5,500,000 660000
6/30/2023 Sony Handycam Rita 6,500,000 780000
7/1/2023 Samsung Kulkas Edward 3,400,000 408000
7/2/2023 Samsung Kulkas Soleh 4,750,000 570000
7/3/2023 LG TV Andis 1,750,000 210000
7/4/2023 Miyako Dispenser Edward 250,000 30000
7/5/2023 LG Kulkas Edward 5,500,000 660000
7/6/2023 Samsung Smartphone Andis 1,250,000 150000
7/7/2023 Canon Kamera Digital Andis 7,700,000 924000
7/8/2023 Samsung Kulkas Andis 6,250,000 750000
7/9/2023 Panasonic Sound System Soleh 3,000,000 360000
7/10/2023 Panasonic Sound System Yoni 3,750,000 450000
7/11/2023 JVC Handycam Yoni 7,700,000 924000
7/12/2023 Miyako Dispenser Yoni 225,000 27000
7/13/2023 TCL AC Yoni 2,000,000 240000
7/14/2023 TCL AC Soleh 2,500,000 300000
7/15/2023 Sony Handycam Yoni 4,500,000 540000
7/16/2023 JVC Sound System Soleh 3,750,000 450000
7/17/2023 Dell Laptop Yoni 7,700,000 924000
7/18/2023 Sony Laptop Soleh 8,900,000 1068000
7/19/2023 TCL AC Andis 2,500,000 300000
7/20/2023 Panasonic Kulkas Rita 4,900,000 588000
7/21/2023 iPhone Smartphone Rita 6,600,000 792000
7/22/2023 Samsung AC Rita 1,250,000 150000
7/23/2023 Sony Laptop Edward 7,500,000 900000
7/24/2023 Samsung AC Rita 1,250,000 150000
7/25/2023 Panasonic Kulkas Andis 5,500,000 660000
7/26/2023 Sony TV Andis 2,500,000 300000
7/27/2023 TCL AC Yoni 1,500,000 180000
7/28/2023 Samsung Kulkas Edward 5,500,000 660000
7/29/2023 Samsung Smartphone Yoni 8,900,000 1068000
7/30/2023 JVC Sound System Andis 1,250,000 150000
7/31/2023 Canon Kamera Digital Yoni 4,750,000 570000
8/1/2023 Miyako Dispenser Andis 200,000 24000
8/2/2023 LG Kulkas Yoni 4,400,000 528000
8/3/2023 LG TV Rita 2,500,000 300000
8/4/2023 LG TV Edward 2,750,000 330000
8/5/2023 Dell Laptop Andis 7,750,000 930000
8/6/2023 JVC Handycam Andis 6,000,000 720000
8/7/2023 Sony Laptop Andis 5,500,000 660000
8/8/2023 JVC Handycam Andis 4,500,000 540000
8/9/2023 TCL AC Andis 1,700,000 204000
8/10/2023 TCL AC Yoni 1,550,000 186000
8/11/2023 Nikon Kamera Digital Soleh 2,500,000 300000
8/12/2023 Canon Kamera Digital Soleh 2,600,000 312000
8/13/2023 TCL AC Soleh 1,750,000 210000
8/14/2023 Miyako AC Rita 180,000 21600
8/15/2023 LG Kulkas Rita 4,500,000 540000
8/16/2023 Samsung Kulkas Edward 6,700,000 804000
8/17/2023 Sony Kamera Digital Edward 3,000,000 360000
8/18/2023 Sony TV Rita 2,500,000 300000
8/19/2023 TCL AC Rita 3,300,000 396000
8/20/2023 Samsung AC Andis 2,500,000 300000
8/21/2023 Sony Handycam Rita 2,200,000 264000
8/22/2023 Sony Handycam Andis 2,600,000 312000
8/23/2023 Dell Laptop Rita 8,700,000 1044000
8/24/2023 Dell Laptop Yoni 5,700,000 684000
8/25/2023 Nokia Smartphone Andis 4,200,000 504000
8/26/2023 LG AC Rita 2,040,000 244800
8/27/2023 Miyako Dispenser Edward 250,000 30000
8/28/2023 LG Kulkas Soleh 2,200,000 264000
8/29/2023 Sony TV Soleh 2,500,000 300000
Data Sales
Sum of Harga
Kategori Andis Edward Rita Soleh Yoni
AC 10,200,000 11,520,000 6,750,000 5,050,000
Dispenser 200,000 500,000 250,000 450,000 225,000
Handycam 26,100,000 10,000,000 8,700,000 12,200,000
Kamera Digital 15,200,000 13,250,000 10,700,000 4,750,000
Kulkas 29,150,000 21,100,000 13,900,000 13,550,000 4,400,000
Laptop 13,250,000 7,500,000 8,700,000 8,900,000 13,400,000
Smartphone 5,450,000 7,550,000 1,200,000 8,900,000
Sound System 1,250,000 4,600,000 11,000,000 3,750,000
TV 4,250,000 10,750,000 15,750,000 4,000,000
Microwave 1,500,000
Total Result 105,050,000 67,700,000 66,370,000 58,050,000 52,675,000
Sum of Komisi Total Sum of Harga Total Sum of Komisi
Andis Edward Rita Soleh Yoni
1224000 1382400 810000 606000 33,520,000 4022400
24000 60000 30000 54000 27000 1,625,000 195000
3132000 1200000 1044000 1464000 57,000,000 6840000
1824000 1590000 1284000 570000 43,900,000 5268000
3498000 2532000 1668000 1626000 528000 82,100,000 9852000
1590000 900000 1044000 1068000 1608000 51,750,000 6210000
654000 906000 144000 1068000 23,100,000 2772000
150000 552000 1320000 450000 20,600,000 2472000
510000 1290000 1890000 480000 34,750,000 4170000
180000 1,500,000 180000
12606000 8124000 7964400 6966000 6321000 349,845,000 41981400
Sum of Harga Sales
Tanggal Kategori Produk Months Andis Edward
Jun 01
AC
Samsung
Jun
Jun 02
TV
Sony
Jun
Jun 03
Kulkas
LG 7,500,000
Jun 7,500,000
Jun 04
AC
LG
Jun
Jun 05
AC
LG 1,750,000
Jun 1,750,000
Jun 06
Kulkas
Samsung
Jun
Jun 07
Smartphone
Microsoft
Jun
Jun 08
Smartphone
Microsoft
Jun
Jun 09
Dispenser
Miyako
Jun
Jun 10
Kulkas
Samsung 3,400,000
Jun 3,400,000
Jun 11
TV
Sony
Jun
Microwave
GE
Jun
Jun 12
TV
Samsung 8,000,000
Jun 8,000,000
Jun 13
TV
LG
Jun
Jun 14
Dispenser
Miyako
Jun
Jun 15
Handycam
JVC 10,000,000
Jun 10,000,000
Jun 16
AC
Samsung 1,750,000
Jun 1,750,000
Jun 17
Handycam
JVC 13,000,000
Jun 13,000,000
Jun 18
Kamera Digital
Canon 4,750,000
Jun 4,750,000
Jun 19
AC
Sony
Jun
Jun 20
TV
Sony
Jun
Jun 21
Dispenser
Miyako
Jun
Jun 22
Kulkas
LG 6,500,000
Jun 6,500,000
Jun 23
Kamera Digital
Nikon 7,500,000
Jun 7,500,000
Jun 24
Kamera Digital
Nikon
Jun
Jun 25
Kulkas
Samsung
Jun
Jun 26
Sound System
JVC
Jun
Jun 27
Sound System
Panasonic
Jun
Jun 28
Sound System
Panasonic 4,600,000
Jun 4,600,000
Jun 29
Kamera Digital
Nikon 5,500,000
Jun 5,500,000
Jun 30
Handycam
Sony
Jun
Jul 01
Kulkas
Samsung 3,400,000
Jul 3,400,000
Jul 02
Kulkas
Samsung
Jul
Jul 03
TV
LG 1,750,000
Jul 1,750,000
Jul 04
Dispenser
Miyako 250,000
Jul 250,000
Jul 05
Kulkas
LG 5,500,000
Jul 5,500,000
Jul 06
Smartphone
Samsung 1,250,000
Jul 1,250,000
Jul 07
Kamera Digital
Canon 7,700,000
Jul 7,700,000
Jul 08
Kulkas
Samsung 6,250,000
Jul 6,250,000
Jul 09
Sound System
Panasonic
Jul
Jul 10
Sound System
Panasonic
Jul
Jul 11
Handycam
JVC
Jul
Jul 12
Dispenser
Miyako
Jul
Jul 13
AC
TCL
Jul
Jul 14
AC
TCL
Jul
Jul 15
Handycam
Sony
Jul
Jul 16
Sound System
JVC
Jul
Jul 17
Laptop
Dell
Jul
Jul 18
Laptop
Sony
Jul
Jul 19
AC
TCL 2,500,000
Jul 2,500,000
Jul 20
Kulkas
Panasonic
Jul
Jul 21
Smartphone
iPhone
Jul
Jul 22
AC
Samsung
Jul
Jul 23
Laptop
Sony 7,500,000
Jul 7,500,000
Jul 24
AC
Samsung
Jul
Jul 25
Kulkas
Panasonic 5,500,000
Jul 5,500,000
Jul 26
TV
Sony 2,500,000
Jul 2,500,000
Jul 27
AC
TCL
Jul
Jul 28
Kulkas
Samsung 5,500,000
Jul 5,500,000
Jul 29
Smartphone
Samsung
Jul
Jul 30
Sound System
JVC 1,250,000
Jul 1,250,000
Jul 31
Kamera Digital
Canon
Jul
Aug 01
Dispenser
Miyako 200,000
Aug 200,000
Aug 02
Kulkas
LG
Aug
Aug 03
TV
LG
Aug
Aug 04
TV
LG 2,750,000
Aug 2,750,000
Aug 05
Laptop
Dell 7,750,000
Aug 7,750,000
Aug 06
Handycam
JVC 6,000,000
Aug 6,000,000
Aug 07
Laptop
Sony 5,500,000
Aug 5,500,000
Aug 08
Handycam
JVC 4,500,000
Aug 4,500,000
Aug 09
AC
TCL 1,700,000
Aug 1,700,000
Aug 10
AC
TCL
Aug
Aug 11
Kamera Digital
Nikon
Aug
Aug 12
Kamera Digital
Canon
Aug
Aug 13
AC
TCL
Aug
Aug 14
AC
Miyako
Aug
Aug 15
Kulkas
LG
Aug
Aug 16
Kulkas
Samsung 6,700,000
Aug 6,700,000
Aug 17
Kamera Digital
Sony 3,000,000
Aug 3,000,000
Aug 18
TV
Sony
Aug
Aug 19
AC
TCL
Aug
Aug 20
AC
Samsung 2,500,000
Aug 2,500,000
Aug 21
Handycam
Sony
Aug
Aug 22
Handycam
Sony 2,600,000
Aug 2,600,000
Aug 23
Laptop
Dell
Aug
Aug 24
Laptop
Dell
Aug
Aug 25
Smartphone
Nokia 4,200,000
Aug 4,200,000
Aug 26
AC
LG
Aug
Aug 27
Dispenser
Miyako 250,000
Aug 250,000
Aug 28
Kulkas
LG
Aug
Aug 29
TV
Sony
Aug
Total Result 105,050,000 67,700,000
Rita Soleh Yoni Total Result

### ###
### ###

### ###
### ###

###
###

2,500,000 ###
2,500,000 ###

###
###

4,500,000 ###
4,500,000 ###

950,000 950,000
950,000 950,000

### ###
### ###

200,000 200,000
200,000 200,000

###
###

1,750,000 ###
1,750,000 ###

### ###
### ###

###
###

5,500,000 ###
5,500,000 ###

250,000 250,000
250,000 250,000

###
###

###
###

###
###

###
###

1,000,000 ###
1,000,000 ###

3,500,000 ###
3,500,000 ###

250,000 250,000
250,000 250,000
###
###

###
###

### ###
### ###

### ###
### ###

### ###
### ###

### ###
### ###

###
###

###
###

6,500,000 ###
6,500,000 ###

###
###

### ###
### ###
###
###

250,000
250,000

###
###

###
###

###
###

###
###

### ###
### ###

### ###
### ###

### ###
### ###

225,000 225,000
225,000 225,000

### ###
### ###

### ###
### ###

### ###
### ###

### ###
### ###

### ###
### ###

### ###
### ###

###
###

4,900,000 ###
4,900,000 ###

6,600,000 ###
6,600,000 ###

1,250,000 ###
1,250,000 ###

###
###

1,250,000 ###
1,250,000 ###

###
###
###
###

### ###
### ###

###
###

### ###
### ###

###
###

### ###
### ###

200,000
200,000

### ###
### ###

2,500,000 ###
2,500,000 ###

###
###

###
###
###
###

###
###

###
###

###
###

### ###
### ###

### ###
### ###

### ###
### ###

### ###
### ###

180,000 180,000
180,000 180,000

4,500,000 ###
4,500,000 ###

###
###
###
###

2,500,000 ###
2,500,000 ###

3,300,000 ###
3,300,000 ###

###
###

2,200,000 ###
2,200,000 ###

###
###

8,700,000 ###
8,700,000 ###

### ###
### ###

###
###

2,040,000 ###
2,040,000 ###

250,000
250,000

### ###
### ###

### ###
### ###
66,370,000 ### ### ###
Kategori Sum of Harga Sum of Harga Sales
AC 33,520,000 Kategori Andis
Dispenser 1,625,000 AC 10,200,000
Handycam 57,000,000 Dispenser 200,000
Kamera Digital 43,900,000 Handycam 26,100,000
Kulkas 82,100,000 Kamera Digital 15,200,000
Laptop 51,750,000 Kulkas 29,150,000
Smartphone 23,100,000 Laptop 13,250,000
Sound System 20,600,000 Smartphone 5,450,000
TV 34,750,000 Sound System 1,250,000
Microwave 1,500,000 TV 4,250,000
Total Result 349,845,000 Microwave
Total Result 105,050,000

Produk Sum of Harga


Canon 19,800,000
Dell 29,850,000
iPhone 6,600,000
JVC 47,450,000
LG 49,390,000
Microsoft 2,150,000
Miyako 1,805,000
Nikon 21,100,000
Nokia 4,200,000
Panasonic 24,750,000
Samsung 68,500,000
Sony 55,950,000
TCL 16,800,000
GE 1,500,000
Total Result 349,845,000
Edward Rita Soleh Yoni Total Result
11,520,000 6,750,000 5,050,000 33,520,000
500,000 250,000 450,000 225,000 1,625,000
10,000,000 8,700,000 12,200,000 57,000,000
13,250,000 10,700,000 4,750,000 43,900,000
21,100,000 13,900,000 13,550,000 4,400,000 82,100,000
7,500,000 8,700,000 8,900,000 13,400,000 51,750,000
7,550,000 1,200,000 8,900,000 23,100,000
4,600,000 11,000,000 3,750,000 20,600,000
10,750,000 15,750,000 4,000,000 34,750,000
1,500,000 1,500,000
67,700,000 66,370,000 58,050,000 52,675,000 349,845,000

Rp120,000,000 Data Sum of Harga Andis


Sales Edward
Rp100,000,000
Rita
Rp80,000,000 Soleh
Yoni
Rp60,000,000
Sum of Komisi Andis
Rp40,000,000 Edward
Rita
Rp20,000,000 Soleh
Rp0 Yoni
r l t
AC nse cam ita lkas top one tem TV ave sul
e y i g u a p ph ys w e
sp nd D K L rt o R
Di Ha era a nd S icr tal
m S m u M T o
Ka So

You might also like