Dealer Category

Transaction Transaction Kode Tempat Metode

Time In Time Out Code Work Order No Chassis No Work KM Service Layanan Total LC
Date Open Date Close Mekanik Pengerjaan Pembayaran
(100xxx) Order

27/01/20 27/01/20 11:05 02/03/20 02/03/20 10:22 100127 15486 204FS35-20010265 MHMFE71PCHK011804 FSC 27834 Inside SB 142000 Kredit

02/03/20 02/03/20 11:16 02/03/20 02/03/20 13:39 100127 11005 204UM-20030021 MHMFE71P19K014783 GR 135099 Inside SB 85000 Tunai

15/01/20 15/01/20 15:46 02/03/20 02/03/20 10:23 100127 17874 204FS35-20010253 MHMFE84P8JK014470 FSC 27326 Inside SB 142000 Kredit

03/03/20 03/03/20 12:34 03/03/20 03/03/20 15:44 100127 10691 204UM-20030041 MHMFE71PCHK011004 GR 96550 Inside SB 752000 Tunai

03/03/20 03/03/20 15:41 04/03/20 04/03/20 15:34 100127 15486 204UM-20030044 MHMFE71P1AK015827 GR 497778 Inside SB 158400 Tunai

04/03/20 04/03/20 15:39 05/03/20 05/03/20 13:51 100127 10691 204UM-20030065 MHMFE71PCFK006560 GR 63398 Inside SB 247500 Tunai

14/02/20 14/02/20 10:22 05/03/20 05/03/20 15:09 100127 10691 204UM-20020219 MHMFE349E6R100346 GR 202721 Inside SB 1845000 Tunai

06/03/20 06/03/20 11:31 06/03/20 06/03/20 14:22 100127 10691 204UM-20030097 MHMFE74P4EK076833 GR 34152 Inside SB 265500 Tunai

21/02/20 21/02/20 10:02 06/03/20 06/03/20 09:08 100127 17874 204UM-20020328 MHMFE84P8GK008986 GR 1628 Inside SB 546250 Tunai

29/02/20 29/02/20 10:11 07/03/20 07/03/20 14:50 100127 15486 204UM-20020450 MHMFE71P17K002579 GR 150724 Inside SB 720000 Tunai

27/02/20 27/02/20 12:13 07/03/20 07/03/20 14:11 100127 10691 204UM-20020431 MHMFE71P17K003723 GR 282000 Inside SB 212500 Tunai

09/03/20 09/03/20 08:42 09/03/20 09/03/20 10:48 100127 11005 204UM-20030122 MHMFE71PCGK008325 GR 44443 Inside SB 579600 Tunai

07/03/20 07/03/20 13:52 09/03/20 09/03/20 11:18 100127 15486 204UM-20030115 MHMFE74P47K107645 GR 338445 Inside SB 579600 Tunai

09/03/20 09/03/20 11:57 09/03/20 09/03/20 15:39 100127 11005 204UM-20030136 MHMFE74P4EK077035 GR 73072 Inside SB 639200 Tunai

10/03/20 10/03/20 08:03 10/03/20 10/03/20 11:07 100127 17874 204UM-20030146 MHMFE71PCHK009514 GR 35171 Inside SB 579600 Tunai

10/03/20 10/03/20 09:46 10/03/20 10/03/20 12:01 100127 15486 204UM-20030156 MHMFE71PCJK014153 GR 9958 Inside SB 153000 Tunai

10/03/20 10/03/20 10:23 10/03/20 10/03/20 13:54 100127 10691 204UM-20030161 MHMFE71PCEK002997 GR 160016 Inside SB 580050 Tunai

10/03/20 10/03/20 11:24 10/03/20 10/03/20 15:53 100127 15486 204UM-20030163 MHMFE74P4EK0765160 GR 80933 Inside SB 974950 Tunai

12/03/20 12/03/20 09:38 12/03/20 12/03/20 13:52 100127 17874 204UM-20030195 MHMFE71P1FK053628 GR 77064 Inside SB 579600 Tunai

12/03/20 12/03/20 09:44 12/03/20 12/03/20 14:32 100127 17874 204UM-20030197 MHMFE71P1CK031883 GR 66187 Inside SB 579600 Tunai

12/03/20 12/03/20 11:05 12/03/20 12/03/20 14:22 100127 10691 204UM-20030201 MHMFE71PCJK014286 GR 71570 Inside SB 676800 Tunai

13/03/20 13/03/20 08:21 13/03/20 13/03/20 11:29 100127 17874 204UM-20030212 MHMFE75PFHK002833 GR 3027 MWS SB 292500 Tunai

07/03/20 07/03/20 08:12 13/03/20 13/03/20 16:12 100127 11005 204UM-20030108 MHMFE71P1FK055531 GR 101205 Inside SB 799000 Tunai
 Tanggal Kode Dealer Kode Sales KodeSalesman /
Transaksi (100xxx) Customer Channel Kode SVC Advisor
No. Work Order / No Harga Beli Harga Jual
No. Parts Qty
Purchase Order. (Per Pc) (Per Pc)
Customer
 Dealer
Qty Beginning Cost Dealer
Month Code Parts No Qty Incoming
Stock (Per Pc)
(100xxx)
LAMPIRAN TARGET DEALER SALES CY2020 Note : Isikan pada kolom warna kuning saja
TARGET DEALER SALES APR MEI JUN JUL AGUST SEP OKT NOP DES JAN FEB MAR Total Avg / Month
A
1. TARGET DEALER SALES Rp. 66,321,972 72,089,100 72,089,100 70,166,724 72,089,100 74,011,476 426,767,472 71,127,912

LAMPIRAN REALISASI BIAYA SPARE PART CY2020

BIAYA KARYAWAN APR MEI JUN JUL AGUST SEP OKT NOP DES JAN FEB MAR Total Avg / Month
1. GAJI & TUNJANGAN Rp. 14,284,669 17,882,138 32,166,807 16,083,404
2. UANG LEMBUR Rp. 812,619 488,266 1,300,885 650,443
3. INSENTIVE Rp. - - - -
I 4. UANG MAKAN Rp. 140,500 - 140,500 70,250
5. PENGOBATAN Rp. - - - -
6. JAMINAN LAIN - 2 Rp. - - - -
7. Rp. - 10,754,162 10,754,162 5,377,081
TOTAL BIAYA KARYAWAN Rp. - - - 15,237,788 29,124,566 - - - - - - - 44,362,354 3,696,863

BIAYA OPERASIONAL APR MEI JUN JUL AGUST SEP OKT NOP DES JAN FEB MAR Total Avg / Month
1. ALAT TULIS Rp. - - - -
2. CETAKAN/FOTO COPY Rp. - - - -
3. LISTRIK Rp. 3,101,612 3,083,864 6,185,476 3,092,738
4. TELEKOMUNIKASI Rp. 381,110 367,737 748,847 374,424
5. AIR Rp. 663,040 800,790 1,463,830 731,915
6. TRANSPORTASI Rp. 1,788,000 689,500 2,477,500 1,238,750
7. AKOMODASI Rp. - - - -
II
8. PROMOSI Rp. - - - -
9. PAJAK Rp. - - - -
10. ASURANSI Rp. - - - -
11. KIRIM BARANG / SURAT Rp. - - - -
12. KESALAHAN STOCK Rp. - - - -
13. PERALATAN KERJA Rp. - - - -
14. PERJALANAN DINAS Rp. - - - -
TOTAL BIAYA OPERASIONAL Rp. - - - 5,933,762 4,941,891 - - - - - - - 10,875,653 906,304

BIAYA PERAWATAN APR MEI JUN JUL AGUST SEP OKT NOP DES JAN FEB MAR Total Avg / Month
1. BANGUNAN Rp. - - - -
III 2. KENDARAAN Rp. - - - -
3. ALAT KANTOR Rp. - - - -
TOTAL BIAYA PERAWATAN Rp. - - - - - - - - - - - - 10,875,653 -

BIAYA PENYUSUTAN APR MEI JUN JUL AGUST SEP OKT NOP DES JAN FEB MAR Total Avg / Month
1. BANGUNAN Rp. - - -
IV 2. KENDARAAN Rp. 5,447,154 5,437,985 10,885,139 5,442,570
3. ALAT KANTOR Rp. - - - -
TOTAL BIAYA PENYUSUTAN Rp. - - - 5,447,154 5,437,985 - - - - - - - 10,885,139 907,095

BIAYA UMUM APR MEI JUN JUL AGUST SEP OKT NOP DES JAN FEB MAR Total Avg / Month
1. TAMU Rp. - - - -
V 2. SUMBANGAN Rp. - - - -
3. LAIN - LAIN Rp. - - - -
TOTAL BIAYA UMUM Rp. - - - - - - - - - - - - - -

TOTAL SELURUH BIAYA SPARE PARTS ( I + II + III + IV + V) Rp. - - - 26,618,704 39,504,442 - - - - - - - 66,123,146 5,510,262

SALDO PIUTANG S/D AKHIR BULAN INI ,DENGAN RINCIAN SBB :

KETERANGAN APR MEI JUN JUL AGUST SEP OKT NOP DES JAN FEB MAR Total Avg / Month
SALDO PIUTANG BULAN LALU Rp. - - - -
PIUTANG BULAN INI Rp. 80,612,339 158,577,873 239,190,212 119,595,106
TERTAGIH BULAN INI Rp. - - - -
SALDO PIUTANG S/D AKHIR BULAN INI Rp. - - - 80,612,339 158,577,873 - - - - - - - 239,190,212 19,932,518

MASA PEMBAYARAN PIUTANG S/D AKHIR BULAN INI :

PEMBAYARAN PIUTANG APR MEI JUN JUL AGUST SEP OKT NOP DES JAN FEB MAR Total Avg / Month
CASH Rp. - - - -
1 MINGGU Rp. - - - -
2 MINGGU Rp. - - - -
3 MINGGU Rp. - - - -
1 BULAN Rp. - - - -
LEBIH DARI 1 BULAN Rp. - - -
SALDO PIUTANG S/D AKHIR BULAN INI Rp. - - - - - - - - - - - - - -
LAMPIRAN TARGET SERVICE Note : Isikan pada kolom warna kuning saja
TARGET DEALER JAN FEB MAR APR MEI JUN JUL AGU SEP OKT NOV DES Total Avg / Month
A
Monthly Service Incoming (FS,GR,PM&CL) Unit 144 222 366 183
Service Incoming Unit (GR & PM) Unit 126 149 275 138

LAMPIRAN REALISASI BIAYA SERVICE CY2020

BIAYA KARYAWAN JAN FEB MAR APR MEI JUN JUL AGU SEP OKT NOV DES Total Avg / Month
1. GAJI & TUNJANGAN Rp. 149,372,843 149,224,899 298,597,742 149,298,871
2. UANG LEMBUR Rp. 82,203,461 94,571,173 176,774,634 88,387,317
3. INSENTIVE Rp. - - - -
I 4. UANG MAKAN Rp. 2,638,500 752,700 3,391,200 1,695,600
5. PENGOBATAN Rp. - - - -
6. JAMINAN LAIN - 2 Rp. 8,162,362 12,935,481 21,097,843 10,548,922
7. THR/BONUS Rp. - - - -
TOTAL BIAYA KARYAWAN Rp. 242,377,166 257,484,253 - - - - - - - - - - 499,861,419 41,655,118

BIAYA OPERASIONAL JAN FEB MAR APR MEI JUN JUL AGU SEP OKT NOV DES Total Avg / Month
1. ALAT TULIS Rp. 4,277,500 5,916,154 10,193,654 5,096,827
2. CETAKAN/FOTO COPY Rp. - - - -
3. LISTRIK Rp. 11,896,780 11,295,004 23,191,784 11,595,892
4. TELEKOMUNIKASI Rp. 951,174 1,121,750 2,072,924 1,036,462
5. AIR Rp. 1,742,700 1,805,400 3,548,100 1,774,050
6. TRANSPORTASI Rp. 2,995,100 2,649,850 5,644,950 2,822,475
7. AKOMODASI Rp. - - - -
II
8. PROMOSI Rp. - - - -
9. PAJAK Rp. 161,980 - 161,980 161,980
10. ASURANSI Rp. - - - -
11. KIRIM BARANG / SURAT Rp. - - - -
12. KESALAHAN STOCK Rp. - - - -
13. PERALATAN KERJA Rp. - - - -
14. PERJALANAN DINAS Rp. - - - -
TOTAL BIAYA OPERASIONAL Rp. 22,025,234 22,788,158 - - - - - - - - - - 44,813,392 3,734,449

BIAYA PERAWATAN JAN FEB MAR APR MEI JUN JUL AGU SEP OKT NOV DES Total Avg / Month
1. BANGUNAN Rp. - - - -
2. KENDARAAN (SERVICE CAR) Rp. - - - -
III
3. KENDARAAN MWS Rp. - - - -
4. ALAT KANTOR Rp. - 5,774,078 5,774,078 5,774,078
TOTAL BIAYA PERAWATAN Rp. - 5,774,078 - - - - - - - - - - 5,774,078 481,173

BIAYA PENYUSUTAN JAN FEB MAR APR MEI JUN JUL AGU SEP OKT NOV DES Total Avg / Month
1. BANGUNAN Rp. - - - -
2. KENDARAAN (SERVICE CAR) Rp. - 71,223,387 71,223,387 71,223,387
IV
3. KENDARAAN MWS Rp. - - - -
4. ALAT KANTOR Rp. 13,061,558 11,800,347 24,861,905 12,430,953
TOTAL BIAYA PENYUSUTAN Rp. 13,061,558 83,023,734 - - - - - - - - - - 96,085,292 8,007,108

BIAYA UMUM JAN FEB MAR APR MEI JUN JUL AGU SEP OKT NOV DES Total Avg / Month
1. TAMU Rp. - - - -
V 2. SUMBANGAN Rp. - - - -
3. LAIN - LAIN Rp. 1,870,000 1,930,000 3,800,000 1,900,000
TOTAL BIAYA UMUM Rp. 1,870,000 1,930,000 - - - - - - - - - - 3,800,000 316,667
Compatibility Report for ASSReport_100127_APR20 - KTB.xls
Run on 5/4/2020 6:45

The following features in this workbook are not supported by earlier versions
of Excel. These features may be lost or degraded when you save this workbook
in an earlier file format.

Significant loss of functionality # of occurrences

One or more functions in this workbook are not available in earlier versions of 12
Excel.  When recalculated in earlier versions, these functions will return a
#NAME? error instead of their current results.

'Expense Spare Parts'!S51

'Expense Spare Parts'!S55:S58

'Expense Spare Parts'!S62:S68

Minor loss of fidelity

Some formulas in this workbook are linked to other workbooks that are 4
closed. When these formulas are recalculated in earlier versions of Excel Defined Names
without opening the linked workbooks, characters beyond the 255-character
limit cannot be returned.