Scribd
Upload
25 views12 pages

Pivot Table Mini Course

The document provides a detailed summary of vehicle sales across various brands and models for the months of January to April. It includes total sales figures, stock sold, and profit contributions for different car types and brands. The overall total sales amount to Rp117,137,000,000.00.

Uploaded by

ira
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
25 views12 pages

Pivot Table Mini Course

The document provides a detailed summary of vehicle sales across various brands and models for the months of January to April. It includes total sales figures, stock sold, and profit contributions for different car types and brands. The overall total sales amount to Rp117,137,000,000.00.

Uploaded by

ira
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
You are on page 1/ 12

Sum of Penjualan Bulan

Tipe Jan Feb Mar Apr


March Rp4,387,000,000.00 Rp4,600,000,000.00
HRV Rp5,182,000,000.00 Rp4,424,000,000.00
Ignis Rp5,621,000,000.00 Rp4,438,000,000.00
Jazz Rp4,422,000,000.00 Rp4,493,000,000.00
Juke Rp5,623,000,000.00 Rp4,476,000,000.00
Land Cruiser Rp5,273,000,000.00 Rp5,438,000,000.00
Mobilio Rp4,898,000,000.00 Rp4,630,000,000.00
Pajero Rp5,735,000,000.00 Rp4,760,000,000.00
Rush Rp4,806,000,000.00 Rp6,192,000,000.00
Swift Rp4,528,000,000.00 Rp5,316,000,000.00
Xpander Rp4,373,000,000.00 Rp4,451,000,000.00
Yaris Rp4,935,000,000.00 Rp4,136,000,000.00
Total Result Rp29,929,000,000.00 Rp30,863,000,000.00 Rp29,049,000,000.00 Rp27,296,000,000.00
Total Result
Rp8,987,000,000.00
Rp9,606,000,000.00
Rp10,059,000,000.00
Rp8,915,000,000.00
Rp10,099,000,000.00
Rp10,711,000,000.00
Rp9,528,000,000.00
Rp10,495,000,000.00
Rp10,998,000,000.00
Rp9,844,000,000.00
Rp8,824,000,000.00
Rp9,071,000,000.00
Rp117,137,000,000.00
Bulan Jan

Tipe (empty)
HRV
Mobilio
Pajero
Rush
Xpander
Yaris
Total Result
Bulan - all -

Merek (empty)
Honda
Mitsubishi
Nissan Kontribusi Profit Kotor
Suzuki
Toyota
Total Result
usi Profit Kotor

Honda
Mitsubishi
Nissan
Suzuki
Toyota
Total Result
Tipe Sum of Stok Terjual This shape represents a slicer.
Rush 89 Slicers are supported in Excel
Juke 81 2010 or later.
Pajero 78
If the shape was modified in
Ignis 77 an earlier version of Excel, or
Swift 76 if the workbook was saved in
HRV 73 Excel 2003 or earlier, the
Mobilio 72 slicer cannot be used.
Xpander 72
Yaris 72
March 69
Jazz 67
Land Cruiser 63
Total Result 889
Merek Sum of Stok Terjual This shape represents a This shape represents a
Toyota 224 slicer. Slicers are supported slicer. Slicers are supported
Honda 212 in Excel 2010 or later. in Excel 2010 or later.
Suzuki 153
If the shape was modified in If the shape was modified in
Mitsubishi 150
an earlier version of Excel, an earlier version of Excel,
Nissan 150 or if the workbook was saved or if the workbook was saved
Total Result 889 in Excel 2003 or earlier, the in Excel 2003 or earlier, the
slicer cannot be used. slicer cannot be used.
Bulan Merek Tipe Area Stok Terjual Pajak Kadaluwarsa Penjualan Harga Modal
Apr Toyota Yaris Bandung 6 3/31/2024 Rp834,000,000.00 Rp510,000,000.00
Jan Toyota Yaris Bandung 5 3/31/2024 Rp730,000,000.00 Rp450,000,000.00
Apr Toyota Yaris Bandung 8 3/31/2024 Rp920,000,000.00 Rp672,000,000.00
Feb Honda Mobilio Bandung 12 1/31/2024 Rp1,692,000,000.00 Rp984,000,000.00
Jan Honda Mobilio Bandung 6 1/31/2024 Rp858,000,000.00 Rp528,000,000.00
Feb Honda Mobilio Bandung 5 1/31/2024 Rp720,000,000.00 Rp440,000,000.00
Jan Honda HRV Bandung 11 2/28/2024 Rp1,606,000,000.00 Rp924,000,000.00
Apr Honda HRV Bandung 10 2/28/2024 Rp1,410,000,000.00 Rp830,000,000.00
Jan Honda HRV Bandung 6 2/28/2024 Rp744,000,000.00 Rp498,000,000.00
Mar Suzuki Ignis Bandung 6 3/31/2024 Rp780,000,000.00 Rp498,000,000.00
Feb Suzuki Ignis Bandung 10 3/31/2024 Rp1,220,000,000.00 Rp810,000,000.00
Mar Suzuki Ignis Bandung 11 3/31/2024 Rp1,529,000,000.00 Rp913,000,000.00
Jan Toyota Rush Bandung 6 2/28/2024 Rp672,000,000.00 Rp492,000,000.00
Feb Toyota Rush Bandung 7 2/28/2024 Rp980,000,000.00 Rp630,000,000.00
Jan Toyota Rush Bandung 12 2/28/2024 Rp1,284,000,000.00 Rp1,056,000,000.00
Mar Honda Jazz Bandung 9 3/31/2024 Rp1,080,000,000.00 Rp738,000,000.00
Apr Honda Jazz Bandung 10 3/31/2024 Rp1,410,000,000.00 Rp820,000,000.00
Mar Honda Jazz Bandung 12 3/31/2024 Rp1,728,000,000.00 Rp972,000,000.00
Mar Nissan Juke Bandung 12 1/31/2024 Rp1,404,000,000.00 Rp1,020,000,000.00
Apr Nissan Juke Bandung 7 1/31/2024 Rp966,000,000.00 Rp588,000,000.00
Mar Nissan Juke Bandung 12 1/31/2024 Rp1,728,000,000.00 Rp996,000,000.00
Feb Toyota Land Cruiser Bandung 8 1/31/2024 Rp960,000,000.00 Rp664,000,000.00
Mar Toyota Land Cruiser Bandung 11 1/31/2024 Rp1,375,000,000.00 Rp957,000,000.00
Feb Toyota Land Cruiser Bandung 9 1/31/2024 Rp1,233,000,000.00 Rp774,000,000.00
Feb Nissan March Bandung 9 2/28/2024 Rp1,233,000,000.00 Rp756,000,000.00
Mar Nissan March Bandung 10 2/28/2024 Rp1,440,000,000.00 Rp890,000,000.00
Feb Nissan March Bandung 5 2/28/2024 Rp510,000,000.00 Rp430,000,000.00
Jan Mitsubishi Pajero Bandung 10 3/31/2024 Rp1,480,000,000.00 Rp860,000,000.00
Feb Mitsubishi Pajero Bandung 12 3/31/2024 Rp1,584,000,000.00 Rp1,020,000,000.00
Jan Mitsubishi Pajero Bandung 11 3/31/2024 Rp1,375,000,000.00 Rp880,000,000.00
Apr Suzuki Swift Bandung 11 2/28/2024 Rp1,507,000,000.00 Rp902,000,000.00
Mar Suzuki Swift Bandung 6 2/28/2024 Rp720,000,000.00 Rp504,000,000.00
Apr Suzuki Swift Bandung 11 2/28/2024 Rp1,441,000,000.00 Rp946,000,000.00
Apr Mitsubishi Xpander Bandung 7 1/31/2024 Rp854,000,000.00 Rp567,000,000.00
Jan Mitsubishi Xpander Bandung 6 1/31/2024 Rp714,000,000.00 Rp522,000,000.00
Apr Mitsubishi Xpander Bandung 6 1/31/2024 Rp828,000,000.00 Rp522,000,000.00
Jan Toyota Yaris Jakarta 12 3/31/2024 Rp1,498,000,000.00 Rp996,000,000.00
Apr Toyota Yaris Jakarta 11 3/31/2024 Rp1,342,000,000.00 Rp979,000,000.00
Jan Toyota Yaris Jakarta 6 3/31/2024 Rp654,000,000.00 Rp504,000,000.00
Jan Honda Mobilio Jakarta 10 1/31/2024 Rp1,500,000,000.00 Rp810,000,000.00
Feb Honda Mobilio Jakarta 8 1/31/2024 Rp832,000,000.00 Rp664,000,000.00
Jan Honda Mobilio Jakarta 6 1/31/2024 Rp798,000,000.00 Rp504,000,000.00
Apr Honda HRV Jakarta 7 2/28/2024 Rp868,000,000.00 Rp602,000,000.00
Jan Honda HRV Jakarta 10 2/28/2024 Rp1,270,000,000.00 Rp850,000,000.00
Apr Honda HRV Jakarta 7 2/28/2024 Rp777,000,000.00 Rp609,000,000.00
Feb Suzuki Ignis Jakarta 10 3/31/2024 Rp1,490,000,000.00 Rp850,000,000.00
Mar Suzuki Ignis Jakarta 7 3/31/2024 Rp721,000,000.00 Rp623,000,000.00
Feb Suzuki Ignis Jakarta 7 3/31/2024 Rp917,000,000.00 Rp630,000,000.00
Feb Toyota Rush Jakarta 12 2/28/2024 Rp1,680,000,000.00 Rp1,020,000,000.00
Jan Toyota Rush Jakarta 12 2/28/2024 Rp1,464,000,000.00 Rp1,008,000,000.00
Feb Toyota Rush Jakarta 6 2/28/2024 Rp678,000,000.00 Rp516,000,000.00
Apr Honda Jazz Jakarta 6 3/31/2024 Rp840,000,000.00 Rp486,000,000.00
Mar Honda Jazz Jakarta 6 3/31/2024 Rp864,000,000.00 Rp534,000,000.00
Apr Honda Jazz Jakarta 5 3/31/2024 Rp655,000,000.00 Rp450,000,000.00
Apr Nissan Juke Jakarta 6 1/31/2024 Rp798,000,000.00 Rp510,000,000.00
Mar Nissan Juke Jakarta 11 1/31/2024 Rp1,573,000,000.00 Rp924,000,000.00
Apr Nissan Juke Jakarta 6 1/31/2024 Rp786,000,000.00 Rp528,000,000.00
Mar Toyota Land Cruiser Jakarta 3 1/31/2024 Rp1,254,000,000.00 Rp957,000,000.00
Feb Toyota Land Cruiser Jakarta 2 1/31/2024 Rp1,595,000,000.00 Rp957,000,000.00
Mar Toyota Land Cruiser Jakarta 4 1/31/2024 Rp864,000,000.00 Rp522,000,000.00
Mar Nissan March Jakarta 6 2/28/2024 Rp708,000,000.00 Rp540,000,000.00
Feb Nissan March Jakarta 9 2/28/2024 Rp1,314,000,000.00 Rp810,000,000.00
Mar Nissan March Jakarta 7 2/28/2024 Rp966,000,000.00 Rp560,000,000.00
Feb Mitsubishi Pajero Jakarta 5 3/31/2024 Rp715,000,000.00 Rp410,000,000.00
Jan Mitsubishi Pajero Jakarta 10 3/31/2024 Rp1,420,000,000.00 Rp900,000,000.00
Feb Mitsubishi Pajero Jakarta 5 3/31/2024 Rp730,000,000.00 Rp435,000,000.00
Mar Suzuki Swift Jakarta 5 2/28/2024 Rp585,000,000.00 Rp450,000,000.00
Apr Suzuki Swift Jakarta 9 2/28/2024 Rp927,000,000.00 Rp810,000,000.00
Mar Suzuki Swift Jakarta 6 2/28/2024 Rp834,000,000.00 Rp534,000,000.00
Jan Mitsubishi Xpander Jakarta 11 1/31/2024 Rp1,287,000,000.00 Rp968,000,000.00
Apr Mitsubishi Xpander Jakarta 12 1/31/2024 Rp1,608,000,000.00 Rp996,000,000.00
Jan Mitsubishi Xpander Jakarta 6 1/31/2024 Rp732,000,000.00 Rp510,000,000.00
Jan Toyota Yaris Surabaya 9 3/31/2024 Rp1,323,000,000.00 Rp747,000,000.00
Apr Toyota Yaris Surabaya 10 3/31/2024 Rp1,040,000,000.00 Rp830,000,000.00
Jan Toyota Yaris Surabaya 5 3/31/2024 Rp730,000,000.00 Rp435,000,000.00
Jan Honda Mobilio Surabaya 8 1/31/2024 Rp968,000,000.00 Rp712,000,000.00
Feb Honda Mobilio Surabaya 11 1/31/2024 Rp1,386,000,000.00 Rp902,000,000.00
Jan Honda Mobilio Surabaya 6 1/31/2024 Rp774,000,000.00 Rp522,000,000.00
Apr Honda HRV Surabaya 5 2/28/2024 Rp655,000,000.00 Rp415,000,000.00
Jan Honda HRV Surabaya 11 2/28/2024 Rp1,562,000,000.00 Rp957,000,000.00
Apr Honda HRV Surabaya 6 2/28/2024 Rp714,000,000.00 Rp498,000,000.00
Feb Suzuki Ignis Surabaya 7 3/31/2024 Rp882,000,000.00 Rp581,000,000.00
Mar Suzuki Ignis Surabaya 11 3/31/2024 Rp1,408,000,000.00 Rp957,000,000.00
Feb Suzuki Ignis Surabaya 8 3/31/2024 Rp1,112,000,000.00 Rp712,000,000.00
Feb Toyota Rush Surabaya 12 2/28/2024 Rp1,248,000,000.00 Rp1,056,000,000.00
Jan Toyota Rush Surabaya 11 2/28/2024 Rp1,386,000,000.00 Rp935,000,000.00
Feb Toyota Rush Surabaya 11 2/28/2024 Rp1,606,000,000.00 Rp968,000,000.00
Apr Honda Jazz Surabaya 5 3/31/2024 Rp540,000,000.00 Rp430,000,000.00
Mar Honda Jazz Surabaya 6 3/31/2024 Rp750,000,000.00 Rp510,000,000.00
Apr Honda Jazz Surabaya 8 3/31/2024 Rp1,048,000,000.00 Rp712,000,000.00
Apr Nissan Juke Surabaya 6 1/31/2024 Rp606,000,000.00 Rp504,000,000.00
Mar Nissan Juke Surabaya 9 1/31/2024 Rp918,000,000.00 Rp783,000,000.00
Apr Nissan Juke Surabaya 12 1/31/2024 Rp1,320,000,000.00 Rp1,032,000,000.00
Mar Toyota Land Cruiser Surabaya 5 1/31/2024 Rp685,000,000.00 Rp440,000,000.00
Feb Toyota Land Cruiser Surabaya 11 1/31/2024 Rp1,485,000,000.00 Rp968,000,000.00
Mar Toyota Land Cruiser Surabaya 10 1/31/2024 Rp1,260,000,000.00 Rp870,000,000.00
Mar Nissan March Surabaya 7 2/28/2024 Rp742,000,000.00 Rp602,000,000.00
Feb Nissan March Surabaya 10 2/28/2024 Rp1,330,000,000.00 Rp810,000,000.00
Mar Nissan March Surabaya 6 2/28/2024 Rp744,000,000.00 Rp486,000,000.00
Feb Mitsubishi Pajero Surabaya 6 3/31/2024 Rp696,000,000.00 Rp528,000,000.00
Jan Mitsubishi Pajero Surabaya 10 3/31/2024 Rp1,460,000,000.00 Rp880,000,000.00
Feb Mitsubishi Pajero Surabaya 9 3/31/2024 Rp1,035,000,000.00 Rp810,000,000.00
Mar Suzuki Swift Surabaya 5 2/28/2024 Rp745,000,000.00 Rp425,000,000.00
Apr Suzuki Swift Surabaya 11 2/28/2024 Rp1,441,000,000.00 Rp880,000,000.00
Mar Suzuki Swift Surabaya 12 2/28/2024 Rp1,644,000,000.00 Rp1,032,000,000.00
Jan Mitsubishi Xpander Surabaya 10 1/31/2024 Rp1,100,000,000.00 Rp820,000,000.00
Apr Mitsubishi Xpander Surabaya 9 1/31/2024 Rp1,161,000,000.00 Rp783,000,000.00
Jan Mitsubishi Xpander Surabaya 5 1/31/2024 Rp540,000,000.00 Rp450,000,000.00
Intruksi :
1 Buatlah rangkuman penjualan dari masing-masing tipe mobil!
2 Hitunglah profit kotor penjualan dari masing-masing type mobil di bulan januari!
3 Buatlah grafik kontribusi profit kotor penjualan dari masing-masing merk mobil!
4 Carilah jumlah mobil terjual dengan kuantiti terbesar pada masing-masing area!
5 Carilah jumlah mobil terjual dengan kuantiti terbesar pada setiap bulannya!

1 Rangkuman Penjualan Type


2 Januari Type Profit Kotor (Penjualan-Modal)
3 Merk Grafik Kontribusi = Grafik Pie Chart Profit Kotor
4 Kuantiti Type/Merk Area Terbesar
5 Kuantiti Terbesar Type/Merk Tiap Bulan

You might also like