This shape represents a slicer.
Tipe Sum of Stok Terjual Slicers are supported in Excel
Rush 89 2010 or later.
Juke 81
Pajero 78 If the shape was modified in
an earlier version of Excel, or
Ignis 77
if the workbook was saved in
Swift 76 Excel 2003 or earlier, the
HRV 73 slicer cannot be used.
Mobilio 72
Xpander 72
Yaris 72
March 69
Jazz 67
Land Cruiser 63
Total Result 889
Merek (empty)
Honda
Mitsubishi kontribusi profit kotor
Nissan
Suzuki
Toyota
Total Result Hon
Mits
Niss
Suzu
Toyo
Tota
profit kotor
Honda
Mitsubishi
Nissan
Suzuki
Toyota
Total Result
Bulan Jan
Tipe (empty)
HRV
Mobilio
Pajero
Rush
Xpander
Yaris
Total Result
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
Tipe Sum of Stok Terjual
Rush 89
Juke 81 This shape represents a
Pajero 78 slicer. Slicers are supported
in Excel 2010 or later.
Ignis 77
Swift 76 If the shape was modified in
HRV 73 an earlier version of Excel,
Mobilio 72 or if the workbook was saved
Xpander 72 in Excel 2003 or earlier, the
slicer cannot be used.
Yaris 72
March 69
Jazz 67
Land Cruiser 63
Total Result 889
epresents a
s are supported
0 or later.
was modified in
sion of Excel,
kbook was saved
3 or earlier, the
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!
filter
value penjualan
rows
coloumn
filter januari
value penjualan
rows profit kotor
coloumn tipe
filter
value penjualan
rows merk
coloumn
filter
value penjualan
rows area
coloumn
filter
value penjualan
rows area
coloumn
