28 November28-Nov-14

483PembulatanNoTruckSJKirimBaikBaik 2B/SBS+-JumlahKarung KosongBRUTONETO2Jumlah 2bs/karungbs-bs/karung1A 9019 UI100099799749969.644985028228219999995.4485049834-3.4485049834BASAH 701700000002A 9676 W100099199149668.924955062766276399799718.3388704319-12.3388704319BASAH 77177000000003A 9123 W100099499449819.284970052325232199999915.415282392-10.415282392000000004A 9484 X100098598549368.2492501248712487399799732.3588039867-20.3588039867BASAH 66166000000005A 9125 W100098998949568.6849450136211362121002100241.2624584718-28.2624584718000000006A 9673 W4444442205.282200444400000000007A 9673 W95694894847513.76474008386838695695625.6478405316-17.6478405316000000008A 9180 W10191019101951072.28509501885118851181037103756.5448504983-38.5448504983000000009A 9028 X81181181140647.32405508118110000000000100000000000000000110000000000000000120000000000000000130000000000000000ERROR:#REF!1400000000000000001500000000000000001600000000000000170000000000000018000000000000000000000000000000000000000000000000000000000000783077787778389833.36038890064293564293520878427842195.0166112957-131.0166112957ERROR:#REF!NoTruckSJKirimBaikERROR:#VALUE!B/SBS+-JumlahBRUTONETO20

rekapPEMASUKKAN Thailand 15%,28 November 2014NoKirimBaik 1Baik 2Bruto1Bruto Input1Netto1 Bruto 2Bruto input 2Netto 2B/SB/S 2SelisihTERIMAkolitonase+-Netto1A 9019 UI1,00099799749969.644985049969.64499704985028228201999A4198899638.56099400008/B4CONFORMCONFORMCONFORMCONFORMERROR:#VALUE!2A 9676 W1,00099199149668.924955049668.9249669495506276627603997C43012150961.440150600011/C3CONFORMCONFORMCONFORMCONFORMERROR:#VALUE!3A 9123 W1,00099499449819.284970049819.28498194970052325232019992778139233.360138900007/B3CONFORMCONFORMCONFORMCONFORMERROR:#VALUE!4A 9484 X1,00098598549368.24925049368.24936849250124871248703997004/A4CONFORMCONFORMCONFORMCONFORMERROR:#VALUE!5A 9125 W1,00098998949568.684945049568.6849569494501362113621201002003/A3CONFORMCONFORMCONFORMCONFORM008/06A 9673 W4444442205.2822002205.282205220000000044010/C2500025060025060025000000177A 9673 W95694894847513.764740047513.7647514474008386838600956006/B22778139233.3613923313890008A 9180 W1,0191019101951072.285095051072.28510725095018851188511801037JMLH7778389833.3603889000JMLH7778389833.3638983338890009A 9028 X81181181140647.324055040647.3240647405500000008111000.000000000000007778389833.3603889007778389833.363898333889001100.000000000000001200.000000000000001300.000000000000001400.00.00000000000001500.000000000000001600.000000000000001700.000000000000001800.000000000000000000=7,83077787778389833.360388900389833.363898333889006429356429352087842kirimTanggalKoli BaikBaik 2Bruto BaikBruto inputNetto baikB/S koliB/S tonaseB/S koliB/S tonaseJumlahJumlah54603Koli+B/Sbruto+B/sKoli+B/Sbruto+B/s24-Nov82368236412788.320411800412788.3241278841180032141932141982681419826841420725-Nov66776677334651.240333850334651.2433465133385030134030134067071340670733599126-Nov74357435372642.20371750372642.237264237175038164538164574731645747337428727-Nov92169216461905.920460800461905.924619074608001175344117534493335344933346725128-Nov77787778389833.360388900389833.36389833388900642935642935784229357842392768A4B4/00824-Nov-146243312899.1631289931215026-Nov-1451725912.042591225850Jumlah39342393421971821.04019671001971821.041971821196710028112683281126833962312683396231984504

Target40000Sisa37718,85037718,850KUOTASISAKUOTASISA396230

koli+b/s396231985904.761981150koli+b/s39623594345JML00001533015330JML6760338811.23388113380006,7600conform26-Nov-14Baik395951984501.41979750baik40185602775CHECK000CHECK338811.2338811338000kk283.36kk-562-28.10140014003771188C4KUOTASISAC3/01124-Nov-14199399889.169988999650KUOTASISAkoli+b/s000153301533026-Nov-142398120187.761201881199005,0000CONFORM27-NovBaik40185604784.2560277527-Nov-1460930523.083052330450kk-560-28-39625-604756.25-602775JML0000JML5000250600250600250000CHECK000CHECK250600250600250000Standard SELISIH1585standar selesihstandard 475kk105.6666666667kk31.6666666667KUOTASISABaik baru39517baik baru39591C11533015330B3/00725-Nov-142695135073.4135073134750koli baru2633.75koli baru27-Nov-144065203737.8203738203250

koli+b/s396231985904.761981150Baik395951984501.41979750kk283.36JML0000JML6760338811.2338811338000KUOTASISA01400.00000000011400CHECK000KUOTASISACHECK338811.23388113380006,7600CONFORM27-Nov2067720677BA4/00425-Nov-143982199577.84199578199100CEK PERSEN0.070666027326-Nov-14101851022.165102250900

JML0000JML5000250600250600250000KUOTASISACHECK000CHECK2506002506002500005,0000conform26-Nov-14TOTAL0000A3/00326-Nov-143502175520.24175520175100TOTAL CHECK00027-Nov-14149875079.767508074900

393421971821.0401967100JML5000250600250600250000KuOTASISACHECK2506002506002500005,0000CONFORM27-Nov

B2/00627-Nov-143044152565.2815256615220028-Nov-142778139233.36139233138900REFAK25312680.361268012650

JML6075304479304479303750KuOTASISACHECK3044793044793037506,480405

010/C228-Nov-145000250600250600250000

JML5000250600250600250000KuOTASISACHECK2506002506002500005,0000

TOTAL395951984501.41984501197975040,000TOTAL CHECK1984501.419845011979750393421971821.041971821196710039,5921984351.04197960039,5951984501.41979750rebag253.0526735834kk27.947326416639848.052673583439848.0526735834

Sheet1

150.12111111250.16222222350333333450.04444444550.08555555650.12666666750.1777777850.12888888950.149999991050.061010101010101150.081111111111111250.121212121212121350.11313131313131450.0414141414141415501515151515151650.041616161616161750.081717171717171850.121818181818181950.041919191919192050.042020202020202150.082121212121212250.1222222222221101.8023232323050.081818181800242400252526000000

Sheet2PemasukkanOPOPSLAGHdebitkreditsaldodebitkreditsaldodebitkreditsaldo24-Nov-14uang makan dari MKL600,000600,00024-Nov-14UANG MAKAN OP200,000200,00024-Nov-14Uang Opslagh10,000,00010,000,00024-Nov-14uang makan harian200,000400,00024-Nov-14uang makan op200,000TOTAL600,00024-Nov-14Pengambilan uang opslagh oleh pa anda8,000,0002,000,00024-Nov-14MAKAN MALAM110,000290,000200,000490,00026-Nov-14Uang opslagh dari mkl10,000,00012,000,00025-Nov-14MAKAN MALAM150,000140,000200,000340,00027-Nov-14pengambilan uang opslagh oleh mang oman8,000,0004,000,00025-Nov-14uang makan dari MKL600,000740,000200,000940,00028-Nov-14pengembalian uang opslagh dari mang oman1,800,0005,800,00025-Nov-14uang makan untuk harian200,000540,00025-Nov-14uang makan op150,000350,000890,00026-Nov-14MAKAN MALAM105,000435,00026-Nov-14uang makan op200,000550,000985,00026-Nov-14uang makan dari MKL600,0001,035,000550,0001,585,00026-Nov-14uang makan untuk harian200,000835,000550,0001,385,00027-Nov-14uang makan dari MKL600,0001,435,00027-Nov-14UANG MAKAN OP150,000700,0002,135,00027-Nov-14uang makan untuk harian200,0001,235,000700,0001,935,00028-Nov-14UANG MAKAN DARI MKL600,0001,835,000700,0002,535,00028-Nov-14UANG MAKAN UNTUK HARIAN200,0001,635,000700,0002,335,00028-Nov-14makan malam200,0001,435,00028-Nov-14uang makan op150,000850,0002,285,000

Sheet31b 9178 uyw67833981339001A 9032 X994498194970082A 9518 X99349769496502A 9435 X99449819497003A 9431 B103051624515003A 9183 VL99649920498005B 9175 UYW67833981339004A 9176 VL99349769496506B 9196 HF63731927318505B 9912 TA63431776317007A 9479 X98449318492006A 9108 VL99850020499008A 9479 x73513507B 9449 SYK6343177631700

8A 9480 X9985002049900119A 9025 X99549869497501A 9021 UI991496694955042A 9010 UI99649920498003A 9676 W99549869497504A 9358 W10005012050000

5A 9108 VL995498694975076A 9125 W28140314007B 9811 UYT67533831337508A 9025 X997499704985083A 9673 W5172591225850114A 9673 W40720399203505A 9676 W99249719496006A 9123 W999500704995041A 9394 W99549869497502A 9673 W231153115037A 9057 VL99649920498008L 9782 UR87844005439009B 9103 SYU318159381590010B 9256 SYK637319263185011B 9511 XU640320773200012L 8443 UD3316541650011/B 9102 SYU6093052330450B 9196 HF3811909619050B 9979 WV7013513435050003/B 9102 SYU6733583350A 9480 X9954987049750B 9131 HH6393202731950A 9671 U9674846648350B 9404 HA6313162631550B 9482 UYZ16180698050007/B 9482 UYZ4652330623250b 9378 ja6363187631800b 9737 ha6373192731850b 9344 uyy6693353033450B 9100 SYU6763388133800B 9107 SYK6333172631650B 9799 RJ10552635250B 9196 HF2441222912200