materi_excellPoin Poin Pelatihan Pengolahan Data4 Jam 50 MenitNoDurasi (Menit)Materi115Pre test25Pengenalan menu-menu MS Excell315Pengenalan rumus rumus dasar di MS Excell - Single Cell dan Multi CellsPenjumlahanPerkalianPenguranganPembagian30Latihan 1415Pengenalan fungsi pengolahan textvlookup/hlookupleft/right, len, trim, findconcatenateifcountif/count/sumif/sumifs30Latihan 2515Pengenalan fungsi link antar sheet dalam satu worksheet dan multiple worksheet30Latihan 3615Pengenalan jenis jenis report dan teknik pengolahan data (pivot table)DailyWeeklyMonthlyYearly730Teknik visualisasi dataFormat data summaryGrafik30Latihan 4Gambaran pengembangan excel di dunia860Post test (Project)Membuat One Piece Paper Report2904 Jam 50 Menit

Latihan1PELATIHAN TEKNIK MENGOLAH DATA DENGAN MS EXCELLatihan 1Rumus-rumus perhitunganSelesaikanlah perhitungan excel berikut :15x6=30Jwb. 3026:2=3Jwb. 336-2=4Jwb. 446+2=8Jwb. 85(2+3)x6=30Jwb. 3062x(6:2)=6Jwb. 676:(3x2)=1Jwb. 18(15 x 3) : 5=9Jwb. 991a(n) merupakan jumlah angka dari urut 1 hingga ke n2a1=3cth : a1 = 1 + 23a2=6Carilah a2, a3 dan a4!4a3=105a4=1510TglProduksi (Kg)Reject QC (Ton)Jlh Penjualan (Ton)Harga Jual (Rp/Ton)Biaya Produksi (Rp/Ton)Biaya Transportasi (Rp/Ton)Revenue (Rp)1-Mar-12300,000529511,0008,500100708,0002-Mar-12350,000634411,1008,450100877,2003-Mar-12330,000732311,0508,500100791,3504-Mar-12320,000331712,0008,5001001,077,8005-Mar-12340,000533511,1508,450100871,000Total Penjualan :1614Total Revenue :4,325,350Jumlah penjualan adalah jumlah produksi dikurangi jumlah reject QCRevenue merupakan rupiah yang diterima dari hasil penjualan dikurangi biaya produksi dan biaya transportasiBerapakah total penjualan dari tgl 1 hingga 5 maret?Berapakah total revenue dari tgl 1 hingga 5 maret?

tips1Data000000000000Sales PersonJanFebMarAprMayJunJulAugSepOctNovDecTotalPencarian:0Joko222224252628303233333636347Sales PersonSolihin0Johnson101011111212131314151515151BulanMar0Indah2626272727272930303232343470Widagdo181920202021222323242525260Total Sales220Solihin1920222425252527293030313070Wahyu1617181819202224252627282600Oni1516171718181819192020222190Bambang1011111112131314141415151530Soelistyo2121212324242526272930323030Meneer2526272829292930313437403650Fathoni2224252628282931343535353520Oni2324242425262728303335373360Tika192020212224242627272830288

Latihan2PELATIHAN TEKNIK MENGOLAH DATA DENGAN MS EXCELLatihan 2Fungsi TextDiketahui data harga penjualan sesuai jenis barang adalah sebagai berikut :NoJenis BarangHarga Jual (Rp/Ton)Sales Person1A12,000Danu2B11,950Ambiri3C11,500Santoso Singh4D11,000Michael SuponoSelesaikanlah permasalahan berikut :TglJenis BarangProduksi (Kg)Reject QC (Ton)Jlh Penjualan (Ton)Biaya Produksi (Rp/Ton)Biaya Transportasi (Rp/Ton)Revenue (Rp)Sales PersonPelabuhanKota Tujuan1-Mar-12A300,00052958,5001003,540,000DanuTanjung Priok, JakartaJakarta2-Mar-12A350,00063448,4501004,128,000DanuBakaheuni, LampungLampung3-Mar-12B330,00073238,5001003,859,850AmbiriBakaheuni, LampungLampung4-Mar-12C320,00033178,5001003,645,500Santoso SinghTanjung Priok, JakartaJakarta5-Mar-12D340,00053358,4501003,685,000Michael SuponoBakaheuni, LampungLampung6-Mar-12A350,00063448,4501004,128,000DanuTanjung Priok, JakartaJakarta7-Mar-12B330,00073238,5001003,859,850AmbiriTanjung Priok, JakartaJakarta8-Mar-12C320,00033178,5001003,645,500Santoso SinghBakaheuni Port, LampungLampung9-Mar-12D340,00053358,4501003,685,000Michael SuponoTanjung Perak, SurabayaSurabayaTotal Revenue :34,176,700Jumlah penjualan adalah jumlah produksi dikurangi jumlah reject QCRevenue merupakan rupiah yang diterima dari hasil penjualan dikurangi biaya produksi dan biaya transportasi1Berapakah total revenue dari tgl 1 hingga 9 maret?34,176,7002Lengkapilah kolom sales person sesuai jenis barang yang di jual!3Berapakah total revenue dari tgl 1 hingga 9 maret untuk produk A?11,796,0004Lengkapilah kota tujuan berdasarkan isi dari kolom pelabuhan!

Latihan3Laporan Bulanan Penjualan Barang1 April - 31 Mei 20121. Kinerja Sales UnitBulanJenis BarangJlh Penjualan (Ton)Harga (Rp/Ton)Data Grafik Kinerja Jumlah PenjualanMaretTotal10,36411,803Jenis BarangJan-12Feb-12Mar-12Apr-12May-12Jun-12A1,68911,809A1,6892,3101,634B3,35711,789B3,3572,6933,184C2,30811,809C2,3081,9242,175D3,01011,809D3,0102,8542,982AprilTotal9,78111,778A2,31011,810Data Grafik Kinerja Harga PenjualanB2,69311,800Jenis BarangJan-12Feb-12Mar-12Apr-12May-12Jun-12C1,92411,739A11,80911,81011,733D2,85411,757B11,78911,80011,830MeiTotal9,97511,787C11,80911,73911,834A1,63411,733D11,80911,75711,736B3,18411,830C2,17511,834Data Grafik Kinerja Sales Person (by Jumlah Penjualan)D2,98211,736Sales PersonJan-12Feb-12Mar-12Apr-12May-12Jun-12Danu1,6892,3101,6342. Kinerja Sales PersonAmbiri3,3572,6933,184BulanJenis BarangJlh Penjualan (Ton)Harga (Rp/Ton)Santoso Singh2,3081,9242,175MaretTotal10,36411,803Michael Supono3,0102,8542,982Danu1,68911,809Ambiri3,35711,789Santoso Singh2,30811,809Michael Supono3,01011,809AprilTotal9,78111,778Danu2,31011,810Ambiri2,69311,800Santoso Singh1,92411,739Michael Supono2,85411,757MeiTotal9,97511,787Danu1,63411,733Ambiri3,18411,830Santoso Singh2,17511,834Michael Supono2,98211,736

Latihan4Laporan Bulanan Penjualan Barang1 April - 31 Mei 20121. Kinerja Sales UnitBulanJenis BarangJlh Penjualan (Ton)Harga (Rp/Ton)MaretTotal10,36411,803A1,68911,809B3,35711,789C2,30811,809D3,01011,809AprilTotal9,78111,778A2,31011,810B2,69311,800C1,92411,739D2,85411,757MeiTotal9,97511,787A1,63411,733B3,18411,830C2,17511,834D2,98211,7362. Kinerja Sales PersonBulanJenis BarangJlh Penjualan (Ton)Harga (Rp/Ton)MaretTotal10,36411,803Danu1,68911,809Ambiri3,35711,789Santoso Singh2,30811,809Michael Supono3,01011,809AprilTotal9,78111,778Danu2,31011,810Ambiri2,69311,800Santoso Singh1,92411,739Michael Supono2,85411,757MeiTotal9,97511,787Danu1,63411,733Ambiri3,18411,830Santoso Singh2,17511,834Michael Supono2,98211,736

Lat4Laporan Harian Penjualan Barang1 April - 31 Mei 2012TglJenis BarangJlh Penjualan (Ton)Harga (Rp/Ton)Revenue (Rp)Sales PersonTujuanNama Pelanggan1-Mar-12B34711,6154,030,405AmbiriSurabayaPT. Golden2-Mar-12C32811,8093,873,352Santoso SinghLampungPT. Permata3-Mar-12D34311,8094,050,487Michael SuponoBaliPT. Berlian4-Mar-12B35011,8094,133,150AmbiriSurabayaPT. Golden5-Mar-12B32511,8093,837,925AmbiriBaliPT. Berlian6-Mar-12C32811,8093,873,352Santoso SinghSurabayaPT. Golden7-Mar-12D32011,8093,778,880Michael SuponoLampungPT. Permata8-Mar-12A33611,8093,967,824DanuBaliPT. Berlian9-Mar-12B33911,8094,003,251AmbiriSurabayaPT. Golden10-Mar-12C32911,8093,885,161Santoso SinghBaliPT. Berlian11-Mar-12D33211,8093,920,588Michael SuponoSurabayaPT. Golden12-Mar-12D32211,8093,802,498Michael SuponoLampungPT. Permata13-Mar-12A32511,8093,837,925DanuBaliPT. Berlian14-Mar-12B34811,8094,109,532AmbiriSurabayaPT. Golden15-Mar-12C32811,8093,873,352Santoso SinghBaliPT. Berlian16-Mar-12D34411,8094,062,296Michael SuponoSurabayaPT. Golden17-Mar-12D32911,8093,885,161Michael SuponoLampungPT. Permata18-Mar-12A34411,8094,062,296DanuSurabayaPT. Golden19-Mar-12B32811,8093,873,352AmbiriLampungPT. Permata20-Mar-12B33211,8093,920,588AmbiriBaliPT. Berlian21-Mar-12C32711,8093,861,543Santoso SinghSurabayaPT. Golden22-Mar-12D33911,8094,003,251Michael SuponoBaliPT. Berlian23-Mar-12D34311,8094,050,487Michael SuponoSurabayaPT. Golden24-Mar-12A34211,8094,038,678DanuBaliPT. Berlian25-Mar-12B32511,8093,837,925AmbiriSurabayaPT. Golden26-Mar-12B34211,8094,038,678AmbiriLampungPT. Permata27-Mar-12C33011,8093,896,970Santoso SinghSurabayaPT. Golden28-Mar-12D33811,8093,991,442Michael SuponoLampungPT. Permata29-Mar-12A34211,8094,038,678DanuBaliPT. Berlian30-Mar-12B32111,8093,790,689AmbiriSurabayaPT. Golden31-Mar-12C33811,8093,991,442Santoso SinghBaliPT. Berlian1-Apr-12A30511,6823,563,010DanuJakartaPT. Intan2-Apr-12B31911,5573,686,683AmbiriLampungPT. Permata3-Apr-12C32011,9083,810,560Santoso SinghBaliPT. Berlian4-Apr-12D31511,5613,641,715Michael SuponoSurabayaPT. Golden5-Apr-12A33811,6933,952,234DanuLampungPT. Permata6-Apr-12B32911,9513,931,879AmbiriBaliPT. Berlian7-Apr-12C30911,7713,637,239Santoso SinghSurabayaPT. Golden8-Apr-12D30811,8883,661,504Michael SuponoBaliPT. Berlian9-Apr-12D32111,5973,722,637Michael SuponoSurabayaPT. Golden10-Apr-12A30811,7513,619,308DanuLampungPT. Permata11-Apr-12B34611,9794,144,734AmbiriBaliPT. Berlian12-Apr-12B34811,5574,021,836AmbiriBaliPT. Berlian13-Apr-12C32911,6673,838,443Santoso SinghSurabayaPT. Golden14-Apr-12D33011,9433,941,190Michael SuponoLampungPT. Permata15-Apr-12A34311,9964,114,628DanuBaliPT. Berlian16-Apr-12B34511,8604,091,700AmbiriSurabayaPT. Golden17-Apr-12C34311,8204,054,260Santoso SinghBaliPT. Berlian18-Apr-12D31211,6453,633,240Michael SuponoSurabayaPT. Golden19-Apr-12D30911,8293,655,161Michael SuponoLampungPT. Permata20-Apr-12A32711,8713,881,817DanuBaliPT. Berlian21-Apr-12B34511,9564,124,820AmbiriSurabayaPT. Golden22-Apr-12C30811,6913,600,828Santoso SinghBaliPT. Berlian23-Apr-12D31411,7393,686,046Michael SuponoSurabayaPT. Golden24-Apr-12D33311,9483,978,684Michael SuponoLampungPT. Permata25-Apr-12A34511,7104,039,950DanuBaliPT. Berlian26-Apr-12B32011,7243,751,680AmbiriSurabayaPT. Golden27-Apr-12B34111,7994,023,459AmbiriBaliPT. Berlian28-Apr-12C31511,5713,644,865Santoso SinghSurabayaPT. Golden29-Apr-12D31211,6453,633,240Michael SuponoLampungPT. Permata30-Apr-12A34411,9464,109,424DanuBaliPT. Berlian1-May-12B32811,8993,902,872AmbiriSurabayaPT. Golden2-May-12C30911,6003,584,400Santoso SinghLampungPT. Permata3-May-12D33511,5723,876,620Michael SuponoBaliPT. Berlian4-May-12B31311,8373,704,981AmbiriSurabayaPT. Golden5-May-12B34011,9774,072,180AmbiriBaliPT. Berlian6-May-12C30611,7993,610,494Santoso SinghSurabayaPT. Golden7-May-12D34211,7664,023,972Michael SuponoLampungPT. Permata8-May-12A33511,7213,926,535DanuBaliPT. Berlian9-May-12B30611,8653,630,690AmbiriSurabayaPT. Golden10-May-12C30411,9903,644,960Santoso SinghBaliPT. Berlian11-May-12D33111,6103,842,910Michael SuponoSurabayaPT. Golden12-May-12D35011,9254,173,750Michael SuponoLampungPT. Permata13-May-12A30711,7403,604,180DanuBaliPT. Berlian14-May-12B30511,7133,572,465AmbiriSurabayaPT. Golden15-May-12C30311,9843,631,152Santoso SinghBaliPT. Berlian16-May-12D31511,5753,646,125Michael SuponoSurabayaPT. Golden17-May-12D32111,7663,776,886Michael SuponoLampungPT. Permata18-May-12A30511,9423,642,310DanuSurabayaPT. Golden19-May-12B30611,6063,551,436AmbiriLampungPT. Permata20-May-12B31311,9373,736,281AmbiriBaliPT. Berlian21-May-12C34711,9134,133,811Santoso SinghSurabayaPT. Golden22-May-12D34911,5914,045,259Michael SuponoBaliPT. Berlian23-May-12D30211,8443,576,888Michael SuponoSurabayaPT. Golden24-May-12A34711,7154,065,105DanuBaliPT. Berlian25-May-12B33111,9803,965,380AmbiriSurabayaPT. Golden26-May-12B30411,5653,515,760AmbiriLampungPT. Permata27-May-12C30511,8093,601,745Santoso SinghSurabayaPT. Golden28-May-12D33711,9674,032,879Michael SuponoLampungPT. Permata29-May-12A34011,5683,933,120DanuBaliPT. Berlian30-May-12B33811,8804,015,440AmbiriSurabayaPT. Golden31-May-12C30111,7393,533,439Santoso SinghBaliPT. Berlian

post_testOPP REPORT DIVISI PENJUALANBulan :Mar-123Kinerja PenjualanJenis BarangJlh Penjualan (Ton)Harga Jual (Rp/Ton)TargetAktual% TARTargetAktual% TARA2,0001,68984.45%12,00011,80998.41%B3,5003,35795.91%11,90011,78999.07%C2,5002,30892.32%11,85011,80999.65%D3,0003,010100.33%11,80011,809100.08%Sales PersonJlh PenjualanTargetAktual% TARDanu2,0001,68984.45%Ambiri3,5003,35795.91%Santoso Singh2,5002,30892.32%Michael Supono3,0003,010100.33%Komplain/ReturnJenis BarangJlh Return (Ton)Nama PelangganA0B2C2D0Pergerakan Barang (Ton)Jenis BarangStock AwalJlh ProduksiJlh PenjualanStock AkhirTarget StockA24,1341,6891,68924,13424,000B24,1843,3573,35724,18422,000C21,6752,3082,30821,67520,500D20,9823,0103,01020,98219,500Total90,97510,36410,36490,97586,000

postLaporan Harian Penjualan Barang1 April - 31 Mei 2012TglJenis BarangJlh Penjualan (Ton)Harga (K Rp/Ton)Revenue (Rp)Sales PersonTujuanNama PelangganReturn (Ton)Bulan1-Mar-12B34711,6154,030,405AmbiriSurabayaPT. Golden32-Mar-12C32811,8093,873,352Santoso SinghLampungPT. Permata2333-Mar-12D34311,8094,050,487Michael SuponoBaliPT. Berlian34-Mar-12B35011,8094,133,150AmbiriSurabayaPT. Golden135-Mar-12B32511,8093,837,925AmbiriBaliPT. Berlian36-Mar-12C32811,8093,873,352Santoso SinghSurabayaPT. Golden37-Mar-12D32011,8093,778,880Michael SuponoLampungPT. Permata38-Mar-12A33611,8093,967,824DanuBaliPT. Berlian39-Mar-12B33911,8094,003,251AmbiriSurabayaPT. Golden310-Mar-12C32911,8093,885,161Santoso SinghBaliPT. Berlian311-Mar-12D33211,8093,920,588Michael SuponoSurabayaPT. Golden312-Mar-12D32211,8093,802,498Michael SuponoLampungPT. Permata313-Mar-12A32511,8093,837,925DanuBaliPT. Berlian314-Mar-12B34811,8094,109,532AmbiriSurabayaPT. Golden315-Mar-12C32811,8093,873,352Santoso SinghBaliPT. Berlian316-Mar-12D34411,8094,062,296Michael SuponoSurabayaPT. Golden317-Mar-12D32911,8093,885,161Michael SuponoLampungPT. Permata318-Mar-12A34411,8094,062,296DanuSurabayaPT. Golden319-Mar-12B32811,8093,873,352AmbiriLampungPT. Permata320-Mar-12B33211,8093,920,588AmbiriBaliPT. Berlian321-Mar-12C32711,8093,861,543Santoso SinghSurabayaPT. Golden322-Mar-12D33911,8094,003,251Michael SuponoBaliPT. Berlian323-Mar-12D34311,8094,050,487Michael SuponoSurabayaPT. Golden324-Mar-12A34211,8094,038,678DanuBaliPT. Berlian325-Mar-12B32511,8093,837,925AmbiriSurabayaPT. Golden1326-Mar-12B34211,8094,038,678AmbiriLampungPT. Permata327-Mar-12C33011,8093,896,970Santoso SinghSurabayaPT. Golden328-Mar-12D33811,8093,991,442Michael SuponoLampungPT. Permata329-Mar-12A34211,8094,038,678DanuBaliPT. Berlian330-Mar-12B32111,8093,790,689AmbiriSurabayaPT. Golden331-Mar-12C33811,8093,991,442Santoso SinghBaliPT. Berlian31-Apr-12A30511,6823,563,010DanuJakartaPT. Intan42-Apr-12B31911,5573,686,683AmbiriLampungPT. Permata43-Apr-12C32011,9083,810,560Santoso SinghBaliPT. Berlian44-Apr-12D31511,5613,641,715Michael SuponoSurabayaPT. Golden45-Apr-12A33811,6933,952,234DanuLampungPT. Permata46-Apr-12B32911,9513,931,879AmbiriBaliPT. Berlian47-Apr-12C30911,7713,637,239Santoso SinghSurabayaPT. Golden48-Apr-12D30811,8883,661,504Michael SuponoBaliPT. Berlian49-Apr-12D32111,5973,722,637Michael SuponoSurabayaPT. Golden410-Apr-12A30811,7513,619,308DanuLampungPT. Permata411-Apr-12B34611,9794,144,734AmbiriBaliPT. Berlian412-Apr-12B34811,5574,021,836AmbiriBaliPT. Berlian413-Apr-12C32911,6673,838,443Santoso SinghSurabayaPT. Golden414-Apr-12D33011,9433,941,190Michael SuponoLampungPT. Permata415-Apr-12A34311,9964,114,628DanuBaliPT. Berlian416-Apr-12B34511,8604,091,700AmbiriSurabayaPT. Golden417-Apr-12C34311,8204,054,260Santoso SinghBaliPT. Berlian418-Apr-12D31211,6453,633,240Michael SuponoSurabayaPT. Golden419-Apr-12D30911,8293,655,161Michael SuponoLampungPT. Permata420-Apr-12A32711,8713,881,817DanuBaliPT. Berlian421-Apr-12B34511,9564,124,820AmbiriSurabayaPT. Golden422-Apr-12C30811,6913,600,828Santoso SinghBaliPT. Berlian423-Apr-12D31411,7393,686,046Michael SuponoSurabayaPT. Golden424-Apr-12D33311,9483,978,684Michael SuponoLampungPT. Permata1425-Apr-12A34511,7104,039,950DanuBaliPT. Berlian426-Apr-12B32011,7243,751,680AmbiriSurabayaPT. Golden427-Apr-12B34111,7994,023,459AmbiriBaliPT. Berlian428-Apr-12C31511,5713,644,865Santoso SinghSurabayaPT. Golden429-Apr-12D31211,6453,633,240Michael SuponoLampungPT. Permata430-Apr-12A34411,9464,109,424DanuBaliPT. Berlian41-May-12B32811,8993,902,872AmbiriSurabayaPT. Golden52-May-12C30911,6003,584,400Santoso SinghLampungPT. Permata53-May-12D33511,5723,876,620Michael SuponoBaliPT. Berlian54-May-12B31311,8373,704,981AmbiriSurabayaPT. Golden55-May-12B34011,9774,072,180AmbiriBaliPT. Berlian56-May-12C30611,7993,610,494Santoso SinghSurabayaPT. Golden57-May-12D34211,7664,023,972Michael SuponoLampungPT. Permata58-May-12A33511,7213,926,535DanuBaliPT. Berlian59-May-12B30611,8653,630,690AmbiriSurabayaPT. Golden510-May-12C30411,9903,644,960Santoso SinghBaliPT. Berlian511-May-12D33111,6103,842,910Michael SuponoSurabayaPT. Golden512-May-12D35011,9254,173,750Michael SuponoLampungPT. Permata513-May-12A30711,7403,604,180DanuBaliPT. Berlian514-May-12B30511,7133,572,465AmbiriSurabayaPT. Golden515-May-12C30311,9843,631,152Santoso SinghBaliPT. Berlian516-May-12D31511,5753,646,125Michael SuponoSurabayaPT. Golden517-May-12D32111,7663,776,886Michael SuponoLampungPT. Permata518-May-12A30511,9423,642,310DanuSurabayaPT. Golden519-May-12B30611,6063,551,436AmbiriLampungPT. Permata520-May-12B31311,9373,736,281AmbiriBaliPT. Berlian521-May-12C34711,9134,133,811Santoso SinghSurabayaPT. Golden522-May-12D34911,5914,045,259Michael SuponoBaliPT. Berlian523-May-12D30211,8443,576,888Michael SuponoSurabayaPT. Golden524-May-12A34711,7154,065,105DanuBaliPT. Berlian525-May-12B33111,9803,965,380AmbiriSurabayaPT. Golden526-May-12B30411,5653,515,760AmbiriLampungPT. Permata527-May-12C30511,8093,601,745Santoso SinghSurabayaPT. Golden528-May-12D33711,9674,032,879Michael SuponoLampungPT. Permata529-May-12A34011,5683,933,120DanuBaliPT. Berlian530-May-12B33811,8804,015,440AmbiriSurabayaPT. Golden531-May-12C30111,7393,533,439Santoso SinghBaliPT. Berlian5

post2Laporan Harian Stok1 Januari - 31 Mei 2012Jumlah Penjualan123456789101112Jenis BarangJan-12Feb-12Mar-12Apr-12May-12Jun-12Jul-12Aug-12Sep-12Oct-12Nov-12Dec-12TotalATarget2,5002,5002,0002,5002,500Aktual001,6892,3101,634BTarget3,5003,5003,5003,5003,500Aktual003,3572,6933,184CTarget2,5002,5002,5002,5002,500Aktual002,3081,9242,175DTarget3,0003,0003,0003,0003,000Aktual003,0102,8542,982Sub TotalTarget11,50011,50011,00011,50011,50000000000Harga Penjualan123456789101112Jenis BarangJan-12Feb-12Mar-12Apr-12May-12Jun-12Jul-12Aug-12Sep-12Oct-12Nov-12Dec-12TotalATarget12,00012,00012,00012,00012,000Aktual11,80911,81011,733BTarget11,90011,90011,90011,90011,900Aktual11,78911,80011,830CTarget11,85011,85011,85011,85011,850Aktual11,80911,73911,834DTarget11,80011,80011,80011,80011,800Aktual11,80911,75711,736Sub TotalTarget Jumlah Penjualan by Sales Person123456789101112Jenis BarangJan-12Feb-12Mar-12Apr-12May-12Jun-12Jul-12Aug-12Sep-12Oct-12Nov-12Dec-12TotalDanu2,5002,5002,0002,5002,500Ambiri3,5003,5003,5003,5003,500Santoso Singh2,5002,5002,5002,5002,500Michael Supono3,0003,0003,0003,0003,000Sub Total11,50011,50011,00011,50011,50000000000Jumlah Produksi123456789101112Jenis BarangJan-12Feb-12Mar-12Apr-12May-12Jun-12Jul-12Aug-12Sep-12Oct-12Nov-12Dec-12TotalA2,3101,6341,6892,3101,634B2,6933,1843,3572,6933,184C1,9242,1752,3081,9242,175D2,8542,9823,0102,8542,982Sub Total9,7819,97510,3649,7819,97500000000Jumlah End Stock123456789101112Jenis BarangJan-12Feb-12Mar-12Apr-12May-12Jun-12Jul-12Aug-12Sep-12Oct-12Nov-12Dec-12A25,00024,13423,82323,63322,767B24,50024,18424,04123,23422,918C22,00021,67521,48320,90720,582D21,00020,98220,99220,84620,828Sub Total92,50090,97590,33988,62087,0950000000Target Jumlah End Stock123456789101112Jenis BarangJan-12Feb-12Mar-12Apr-12May-12Jun-12Jul-12Aug-12Sep-12Oct-12Nov-12Dec-12A24,50024,25024,00023,75023,50023,25023,00022,75022,50022,25022,00021,750B22,50022,25022,00021,75021,50021,25021,00020,75020,50020,25020,00019,750C21,00020,75020,50020,25020,00019,75019,50019,25019,00018,75018,50018,250D20,00019,75019,50019,25019,00018,75018,50018,25018,00017,75017,50017,250Sub Total88,00087,00086,00085,00084,00083,00082,00081,00080,00079,00078,00077,000

post2

A TargetA AktualB TargetB AktualC TargetC AktualD TargetD Aktual

Sheet2Jan-12Feb-12Mar-12Apr-12May-12Jun-12Jul-12Aug-12Sep-12Oct-12Nov-12Dec-12