0% found this document useful (0 votes)
26 views15 pages

Pivot Table - Advanced

The document provides sales data for various car brands, including total units sold and revenue generated, with Toyota leading in both categories. It also includes detailed sales records by model, area, and month, along with cost of goods sold calculations. Overall, the total revenue across all brands amounts to 117,127,000,000, with Honda and Toyota being the top performers.
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
0% found this document useful (0 votes)
26 views15 pages

Pivot Table - Advanced

The document provides sales data for various car brands, including total units sold and revenue generated, with Toyota leading in both categories. It also includes detailed sales records by model, area, and month, along with cost of goods sold calculations. Overall, the total revenue across all brands amounts to 117,127,000,000, with Honda and Toyota being the top performers.
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

Merek Sum of Stok Terjual

Honda 212
Mitsubishi 150
Nissan 150
Suzuki 153
Toyota 224
Total Result 889
Merek Sum of Penjualan
Toyota 30,770,000,000
Honda 28,049,000,000
Suzuki 19,903,000,000
Total Result 78,722,000,000
Bulan All

Row Labels Sum of Penjualan


Honda 28,049,000,000.00
Mitsubishi 19,319,000,000.00
Nissan 19,086,000,000.00
Suzuki 19,903,000,000.00
Toyota 30,770,000,000.00
Grand Total 117,127,000,000.00
Bulan - all -

Merek Sum of Penjualan


Honda 28,049,000,000
Mitsubishi 19,319,000,000
Nissan 19,086,000,000
Suzuki 19,903,000,000
Toyota 30,770,000,000
Total Result 117,127,000,000
Merek Sum of Penjualan
Honda 28,049,000,000
Mitsubishi 19,319,000,000
Nissan 19,086,000,000
Suzuki 19,903,000,000
Toyota 30,770,000,000
Total Result 117,127,000,000
Merek Sum of Penjualan
Toyota 30,770,000,000
Honda 28,049,000,000
Suzuki 19,903,000,000
Mitsubishi 19,319,000,000
Nissan 19,086,000,000
Total Result 117,127,000,000

PROFIT/MARGIPENDAPATAN-BIAYA
COGS = HPP PERSEDIAAN AWAL-PERSEDIAAN AKHIR
Bulan Merek Tipe Area Stok Terjual Pajak Kadaluwarsa Penjualan Harga Modal
Feb Nissan March Bandung 5 2/28/2024 510000000 430000000
Bulan Merek Tipe Area Stok Terjual Pajak Kadaluwarsa Penjualan Harga Modal
Jan Honda Brio Surabaya 6 1/31/2024 774000000 522000000
Jan Honda Brio Jakarta 10 1/31/2024 1500000000 810000000
Feb Honda Brio Surabaya 11 1/31/2024 1386000000 902000000
Jan Honda Brio Surabaya 8 1/31/2024 968000000 712000000
Feb Honda Brio Bandung 5 1/31/2024 720000000 440000000
Feb Honda Brio Jakarta 8 1/31/2024 832000000 664000000
Jan Honda Brio Bandung 6 1/31/2024 858000000 528000000
Feb Honda Brio Bandung 12 1/31/2024 1692000000 984000000
Jan Honda Brio Jakarta 6 1/31/2024 798000000 504000000
Apr Honda CRV Surabaya 6 2/28/2024 714000000 498000000
Apr Honda CRV Jakarta 7 2/28/2024 868000000 602000000
Jan Honda CRV Surabaya 11 2/28/2024 1562000000 957000000
Apr Honda CRV Surabaya 5 2/28/2024 655000000 415000000
Jan Honda CRV Bandung 6 2/28/2024 744000000 498000000
Jan Honda CRV Jakarta 10 2/28/2024 1270000000 850000000
Apr Honda CRV Bandung 10 2/28/2024 1410000000 830000000
Jan Honda CRV Bandung 11 2/28/2024 1606000000 924000000
Apr Honda CRV Jakarta 7 2/28/2024 777000000 609000000
Apr Honda Jazz Surabaya 8 3/31/2024 1048000000 712000000
Apr Honda Jazz Jakarta 6 3/31/2024 840000000 486000000
Mar Honda Jazz Surabaya 6 3/31/2024 750000000 510000000
Apr Honda Jazz Surabaya 5 3/31/2024 540000000 430000000
Mar Honda Jazz Bandung 12 3/31/2024 1728000000 972000000
Mar Honda Jazz Jakarta 6 3/31/2024 864000000 534000000
Apr Honda Jazz Bandung 10 3/31/2024 1410000000 820000000
Mar Honda Jazz Bandung 9 3/31/2024 1080000000 738000000
Apr Honda Jazz Jakarta 5 3/31/2024 655000000 450000000
Merek Tipe Sum of Penjualan
Honda ###
Brio ###
CRV ###
Jazz ###
Suzuki ###
Ertiga ###
Swift ###
Toyota ###
Avanza ###
Innova ###
Land Cruiser ###
Total Result ###
Bulan Merek Tipe Area Stok Terjual Pajak Kadaluwarsa
Jan Toyota Avanza Jakarta 12 3/31/2024
Feb Toyota Innova Jakarta 12 2/28/2024
Mar Toyota Land Cruiser Jakarta 3 1/31/2024
Apr Honda Jazz Jakarta 6 3/31/2024
Apr Honda CRV Jakarta 7 2/28/2024
Jan Honda Brio Jakarta 10 1/31/2024
Feb Suzuki Ertiga Jakarta 10 3/31/2024
Mar Suzuki Swift Jakarta 5 2/28/2024
Jan Mitsubishi Xpander Jakarta 11 1/31/2024
Feb Mitsubishi Pajero Jakarta 5 3/31/2024
Mar Nissan March Jakarta 6 2/28/2024
Apr Nissan Juke Jakarta 6 1/31/2024
Apr Toyota Avanza Jakarta 11 3/31/2024
Jan Toyota Innova Jakarta 12 2/28/2024
Feb Toyota Land Cruiser Jakarta 2 1/31/2024
Mar Honda Jazz Jakarta 6 3/31/2024
Jan Honda CRV Jakarta 10 2/28/2024
Feb Honda Brio Jakarta 8 1/31/2024
Mar Suzuki Ertiga Jakarta 7 3/31/2024
Apr Suzuki Swift Jakarta 9 2/28/2024
Apr Mitsubishi Xpander Jakarta 12 1/31/2024
Jan Mitsubishi Pajero Jakarta 10 3/31/2024
Feb Nissan March Jakarta 9 2/28/2024
Mar Nissan Juke Jakarta 11 1/31/2024
Jan Toyota Avanza Jakarta 6 3/31/2024
Feb Toyota Innova Jakarta 6 2/28/2024
Mar Toyota Land Cruiser Jakarta 4 1/31/2024
Apr Honda Jazz Jakarta 5 3/31/2024
Apr Honda CRV Jakarta 7 2/28/2024
Jan Honda Brio Jakarta 6 1/31/2024
Feb Suzuki Ertiga Jakarta 7 3/31/2024
Mar Suzuki Swift Jakarta 6 2/28/2024
Jan Mitsubishi Xpander Jakarta 6 1/31/2024
Feb Mitsubishi Pajero Jakarta 5 3/31/2024
Mar Nissan March Jakarta 7 2/28/2024
Apr Nissan Juke Jakarta 6 1/31/2024
Apr Toyota Avanza Bandung 6 3/31/2024
Jan Toyota Innova Bandung 6 2/28/2024
Feb Toyota Land Cruiser Bandung 8 1/31/2024
Mar Honda Jazz Bandung 9 3/31/2024
Jan Honda CRV Bandung 11 2/28/2024
Feb Honda Brio Bandung 12 1/31/2024
Mar Suzuki Ertiga Bandung 6 3/31/2024
Apr Suzuki Swift Bandung 11 2/28/2024
Apr Mitsubishi Xpander Bandung 7 1/31/2024
Jan Mitsubishi Pajero Bandung 10 3/31/2024
Feb Nissan March Bandung 9 2/28/2024
Mar Nissan Juke Bandung 12 1/31/2024
Jan Toyota Avanza Bandung 5 3/31/2024
Feb Toyota Innova Bandung 7 2/28/2024
Mar Toyota Land Cruiser Bandung 11 1/31/2024
Apr Honda Jazz Bandung 10 3/31/2024
Apr Honda CRV Bandung 10 2/28/2024
Jan Honda Brio Bandung 6 1/31/2024
Feb Suzuki Ertiga Bandung 10 3/31/2024
Mar Suzuki Swift Bandung 6 2/28/2024
Jan Mitsubishi Xpander Bandung 6 1/31/2024
Feb Mitsubishi Pajero Bandung 12 3/31/2024
Mar Nissan March Bandung 10 2/28/2024
Apr Nissan Juke Bandung 7 1/31/2024
Apr Toyota Avanza Bandung 8 3/31/2024
Jan Toyota Innova Bandung 12 2/28/2024
Feb Toyota Land Cruiser Bandung 9 1/31/2024
Mar Honda Jazz Bandung 12 3/31/2024
Jan Honda CRV Bandung 6 2/28/2024
Feb Honda Brio Bandung 5 1/31/2024
Mar Suzuki Ertiga Bandung 11 3/31/2024
Apr Suzuki Swift Bandung 11 2/28/2024
Apr Mitsubishi Xpander Bandung 6 1/31/2024
Jan Mitsubishi Pajero Bandung 11 3/31/2024
Feb Nissan March Bandung 5 2/28/2024
Mar Nissan Juke Bandung 12 1/31/2024
Jan Toyota Avanza Surabaya 9 3/31/2024
Feb Toyota Innova Surabaya 12 2/28/2024
Mar Toyota Land Cruiser Surabaya 5 1/31/2024
Apr Honda Jazz Surabaya 5 3/31/2024
Apr Honda CRV Surabaya 5 2/28/2024
Jan Honda Brio Surabaya 8 1/31/2024
Feb Suzuki Ertiga Surabaya 7 3/31/2024
Mar Suzuki Swift Surabaya 5 2/28/2024
Jan Mitsubishi Xpander Surabaya 10 1/31/2024
Feb Mitsubishi Pajero Surabaya 6 3/31/2024
Mar Nissan March Surabaya 7 2/28/2024
Apr Nissan Juke Surabaya 6 1/31/2024
Apr Toyota Avanza Surabaya 10 3/31/2024
Jan Toyota Innova Surabaya 11 2/28/2024
Feb Toyota Land Cruiser Surabaya 11 1/31/2024
Mar Honda Jazz Surabaya 6 3/31/2024
Jan Honda CRV Surabaya 11 2/28/2024
Feb Honda Brio Surabaya 11 1/31/2024
Mar Suzuki Ertiga Surabaya 11 3/31/2024
Apr Suzuki Swift Surabaya 11 2/28/2024
Apr Mitsubishi Xpander Surabaya 9 1/31/2024
Jan Mitsubishi Pajero Surabaya 10 3/31/2024
Feb Nissan March Surabaya 10 2/28/2024
Mar Nissan Juke Surabaya 9 1/31/2024
Jan Toyota Avanza Surabaya 5 3/31/2024
Feb Toyota Innova Surabaya 11 2/28/2024
Mar Toyota Land Cruiser Surabaya 10 1/31/2024
Apr Honda Jazz Surabaya 8 3/31/2024
Apr Honda CRV Surabaya 6 2/28/2024
Jan Honda Brio Surabaya 6 1/31/2024
Feb Suzuki Ertiga Surabaya 8 3/31/2024
Mar Suzuki Swift Surabaya 12 2/28/2024
Jan Mitsubishi Xpander Surabaya 5 1/31/2024
Feb Mitsubishi Pajero Surabaya 9 3/31/2024
Mar Nissan March Surabaya 6 2/28/2024
Apr Nissan Juke Surabaya 12 1/31/2024
Penjualan Harga Modal
1,488,000,000 996,000,000
1,680,000,000 1,020,000,000
1,254,000,000 957,000,000
840,000,000 486,000,000
868,000,000 602,000,000
1,500,000,000 810,000,000
1,490,000,000 850,000,000
585,000,000 450,000,000
1,287,000,000 968,000,000
715,000,000 410,000,000
708,000,000 540,000,000
798,000,000 510,000,000
1,342,000,000 979,000,000
1,464,000,000 1,008,000,000
1,595,000,000 957,000,000
864,000,000 534,000,000
1,270,000,000 850,000,000
832,000,000 664,000,000
721,000,000 623,000,000
927,000,000 810,000,000
1,608,000,000 996,000,000
1,420,000,000 900,000,000
1,314,000,000 810,000,000
1,573,000,000 924,000,000
654,000,000 504,000,000
678,000,000 516,000,000
864,000,000 522,000,000
655,000,000 450,000,000
777,000,000 609,000,000
798,000,000 504,000,000
917,000,000 630,000,000
834,000,000 534,000,000
732,000,000 510,000,000
730,000,000 435,000,000
966,000,000 560,000,000
786,000,000 528,000,000
834,000,000 510,000,000
672,000,000 492,000,000
960,000,000 664,000,000
1,080,000,000 738,000,000
1,606,000,000 924,000,000
1,692,000,000 984,000,000
780,000,000 498,000,000
1,507,000,000 902,000,000
854,000,000 567,000,000
1,480,000,000 860,000,000
1,233,000,000 756,000,000
1,404,000,000 1,020,000,000
730,000,000 450,000,000
980,000,000 630,000,000
1,375,000,000 957,000,000
1,410,000,000 820,000,000
1,410,000,000 830,000,000
858,000,000 528,000,000
1,220,000,000 810,000,000
720,000,000 504,000,000
714,000,000 522,000,000
1,584,000,000 1,020,000,000
1,440,000,000 890,000,000
966,000,000 588,000,000
920,000,000 672,000,000
1,284,000,000 1,056,000,000
1,233,000,000 774,000,000
1,728,000,000 972,000,000
744,000,000 498,000,000
720,000,000 440,000,000
1,529,000,000 913,000,000
1,441,000,000 946,000,000
828,000,000 522,000,000
1,375,000,000 880,000,000
510,000,000 430,000,000
1,728,000,000 996,000,000
1,323,000,000 747,000,000
1,248,000,000 1,056,000,000
685,000,000 440,000,000
540,000,000 430,000,000
655,000,000 415,000,000
968,000,000 712,000,000
882,000,000 581,000,000
745,000,000 425,000,000
1,100,000,000 820,000,000
696,000,000 528,000,000
742,000,000 602,000,000
606,000,000 504,000,000
1,040,000,000 830,000,000
1,386,000,000 935,000,000
1,485,000,000 968,000,000
750,000,000 510,000,000
1,562,000,000 957,000,000
1,386,000,000 902,000,000
1,408,000,000 957,000,000
1,441,000,000 880,000,000
1,161,000,000 783,000,000
1,460,000,000 880,000,000
1,330,000,000 810,000,000
918,000,000 783,000,000
730,000,000 435,000,000
1,606,000,000 968,000,000
1,260,000,000 870,000,000
1,048,000,000 712,000,000
714,000,000 498,000,000
774,000,000 522,000,000
1,112,000,000 712,000,000
1,644,000,000 1,032,000,000
540,000,000 450,000,000
1,035,000,000 810,000,000
744,000,000 486,000,000
1,320,000,000 1,032,000,000

You might also like