Docstoc
EXCLUSIVE OFFER FOR DOCSTOC USERS
Try the all-new QuickBooks Online for FREE.  No credit card required.

Latihan Microsoft Excel

Document Sample
Latihan Microsoft Excel Powered By Docstoc
					LAPORAN GAJI PEGAWAI
PT SELALU MENGALAH
Jalan Tak Tentu Arah 212
SURAKARTA




NO INDUK NAMA KARYAWAN        MASA KERJA    GAJI POKOK         TUNJANGAN JABATAN
                                                                                 15%
      111   PURWADI                    12   Rp  2,000,000.00    Rp       300,000.00
      112   PURNOMO                    13   Rp  1,500,000.00    Rp       225,000.00
      113   AGUS                       10   Rp  1,000,000.00    Rp       150,000.00
      114   ARI ANWAR                  14   Rp  1,500,000.00    Rp       225,000.00
      115   JATMIKO                     9   Rp    750,000.00    Rp       112,500.00
      116   TAUFIK                      5   Rp    800,000.00    Rp       120,000.00
      117   AGUNG                       8   Rp    600,000.00    Rp         90,000.00
      118   IWAN                        7   Rp    600,000.00    Rp         90,000.00
      119   SUYANTO                    15   Rp  2,000,000.00    Rp       300,000.00
      120   PURYANTI                   12   Rp  1,750,000.00    Rp       262,500.00
      121   SUNARNO                    15   Rp  2,500,000.00    Rp       375,000.00
      122   OKTI HANDINI                9   Rp  2,000,000.00    Rp       300,000.00
      123   SRI WIDAYATO               16   Rp  1,500,000.00    Rp       225,000.00
      124   BARIYONO                   18   Rp  3,000,000.00    Rp       450,000.00
      125   YAHTO THING                14   Rp  1,500,000.00    Rp       225,000.00
            TOTAL                           Rp 23,000,000.00    Rp     3,450,000.00
            RATA-RATA                       Rp  1,533,333.33    Rp       230,000.00
            NILAI TERTINGGI                 Rp  3,000,000.00    Rp       450,000.00
            NILAI TERENDAH                  Rp    600,000.00    Rp         90,000.00
TUNJANGAN KELUARGA     TUNJANGAN HARI TUA     TUNJANGAN SEJAHTERA      TUNJANGAN SOSIAL
                  2%                     1%                       3%                2.50%
 Rp        40,000.00    Rp        20,000.00   Rp           60,000.00    Rp      50,000.00
 Rp        30,000.00    Rp        15,000.00   Rp           45,000.00    Rp      37,500.00
 Rp        20,000.00    Rp        10,000.00   Rp           30,000.00    Rp      25,000.00
 Rp        30,000.00    Rp        15,000.00   Rp           45,000.00    Rp      37,500.00
 Rp        15,000.00    Rp         7,500.00   Rp           22,500.00    Rp      18,750.00
 Rp        16,000.00    Rp         8,000.00   Rp           24,000.00    Rp      20,000.00
 Rp        12,000.00    Rp         6,000.00   Rp           18,000.00    Rp      15,000.00
 Rp        12,000.00    Rp         6,000.00   Rp           18,000.00    Rp      15,000.00
 Rp        40,000.00    Rp        20,000.00   Rp           60,000.00    Rp      50,000.00
 Rp        35,000.00    Rp        17,500.00   Rp           52,500.00    Rp      43,750.00
 Rp        50,000.00    Rp        25,000.00   Rp           75,000.00    Rp      62,500.00
 Rp        40,000.00    Rp        20,000.00   Rp           60,000.00    Rp      50,000.00
 Rp        30,000.00    Rp        15,000.00   Rp           45,000.00    Rp      37,500.00
 Rp        60,000.00    Rp        30,000.00   Rp           90,000.00    Rp      75,000.00
 Rp        30,000.00    Rp        15,000.00   Rp           45,000.00    Rp      37,500.00
 Rp       460,000.00    Rp       230,000.00   Rp          690,000.00    Rp     575,000.00
 Rp        30,666.67    Rp        15,333.33   Rp           46,000.00    Rp      38,333.33
 Rp        60,000.00    Rp        30,000.00   Rp           90,000.00    Rp      75,000.00
 Rp        12,000.00    Rp         6,000.00   Rp           18,000.00    Rp      15,000.00
TUNJANGAN MASA
KERJA                GAJI KOTOR             POTONGAN
                1%                                             1%
Rp      240,000.00   Rp      2,710,000.00   Rp          27,100.00
Rp      195,000.00   Rp      2,047,500.00   Rp          20,475.00
Rp      100,000.00   Rp      1,335,000.00   Rp          13,350.00
Rp      210,000.00   Rp      2,062,500.00   Rp          20,625.00
Rp       67,500.00   Rp        993,750.00   Rp           9,937.50
Rp       40,000.00   Rp      1,028,000.00   Rp          10,280.00
Rp       48,000.00   Rp        789,000.00   Rp           7,890.00
Rp       42,000.00   Rp        783,000.00   Rp           7,830.00
Rp      300,000.00   Rp      2,770,000.00   Rp          27,700.00
Rp      210,000.00   Rp      2,371,250.00   Rp          23,712.50
Rp      375,000.00   Rp      3,462,500.00   Rp          34,625.00
Rp      180,000.00   Rp      2,650,000.00   Rp          26,500.00
Rp      240,000.00   Rp      2,092,500.00   Rp          20,925.00
Rp      540,000.00   Rp      4,245,000.00   Rp          42,450.00
Rp      210,000.00   Rp      2,062,500.00   Rp          20,625.00
Rp    2,997,500.00   Rp     31,402,500.00   Rp         314,025.00
Rp      199,833.33   Rp      2,093,500.00   Rp          20,935.00
Rp      540,000.00   Rp      4,245,000.00   Rp          42,450.00
Rp       40,000.00   Rp        783,000.00   Rp           7,830.00
DAFTAR NILAI SISWA OPERATOR KOMPUTER

NO         NAMA                MS WORD MS EXCEL POWER POINT RATA-RATA
       1   HANDAYANI                 44       40          54            46.00
       2   ENDARSYAH                 94       58          67            73.00
       3   SYAHBUDIN                 77       95          75            82.33
       4   KURNIAWAN                 67       81          85            77.67
       5   ZAINUDIN                  59       66          82            69.00
       6   ILHAM                     52       46          49            49.00
       7   SUPARTINAH                75       58          75            69.33
       8   ESTININGSIH               96       52          80            76.00
       9   SUKARYANI                 49       70          64            61.00
      10   JECKY KUSUMASTUTI         98       72          67            79.00
      11   SUSILOWATI                64       92          93            83.00
      12   ISNAENI                   68       61          77            68.67
      13   ZULASWAN LUBIS            78       84          83            81.67
      14   HARTONO                   80       95          54            76.33
      15   SUNARTO                   68       76          45            63.00
      16   KARIYEM                   78       77          89            81.33
KETERANGAN
Tidak Lulus
Tidak Lulus
Lulus
Lulus
Tidak Lulus
Tidak Lulus
Tidak Lulus
Lulus
Tidak Lulus
Lulus
Lulus
Tidak Lulus
Lulus
Lulus
Tidak Lulus
Lulus
DAFTAR NILAI SISWA OPERATOR KOMPUTER



NO         NAMA                MS WORD MS EXCEL POWER POINT RATA-RATA
       1   HANDAYANI                 80       87          89         85.33
       2   ENDARSYAH                 94       23          88         68.33
       3   SYAHBUDIN                 85       95          75         85.00
       4   KURNIAWAN                 89       81          85         85.00
       5   ZAINUDIN                  79       90          82         83.67
       6   ILHAM                     52       46          49         49.00
       7   SUPARTINAH                75       58          75         69.33
       8   ESTININGSIH               96       78          80         84.67
       9   SUKARYANI                 49       70          64         61.00
      10   JECKY KUSUMASTUTI         98       72          67         79.00
      11   SUSILOWATI                64       92          93         83.00
      12   ISNAENI                   68       61          77         68.67
      13   ZULASWAN LUBIS            78       84          83         81.67
      14   HARTONO                   80       95          54         76.33
      15   SUNARTO                   68       76          45         63.00
      16   KARIYEM                   78       77          89         81.33
KETERANGAN *)         Nilai Huruf   Predikat
Lulus                 C             Cukup                      Lulus
Tidak Lulus           D             Kurang                     Tidak Lulus
Lulus                 C             Cukup                      Lulus
Lulus                 C             Cukup                      Lulus
Tidak Lulus           C             Cukup                      Lulus
Tidak Lulus           E             Gagal                      Tidak Lulus
Tidak Lulus           C             Cukup                      Tidak Lulus
Lulus                 C             Cukup                      Lulus
Tidak Lulus           D             Kurang                     Tidak Lulus
Tidak Lulus           C             Cukup                      Tidak Lulus
Tidak Lulus           C             Cukup                      Lulus
Tidak Lulus           D             Kurang                     Tidak Lulus
Tidak Lulus           C             Cukup                      Lulus
Tidak Lulus           C             Cukup                      Tidak Lulus
Tidak Lulus           D             Kurang                     Tidak Lulus
Tidak Lulus           C             Cukup                      Lulus

*) Jika nilai MS WORD>=80 dan nilai rata-rata>=80 maka lulus
                                                         BANK ASIA RAYA
                                                     REKAP LEMBUR KARYAWAN
                                                              Apr-05




Nama Karyawan                       Sarah Vi
NIP                                 1900922
Departemen                          Marketing
Upah Lembur/jam Hari kerja           Rp      15,000.00
Upah Lembur/jam Hari libur           Rp      25,000.00


     tanggal         Jam masuk          Jam keluar       Jam bekerja     Jam lembur
         1-Apr-05            8:00                20:00          12 Jam           3 Jam
         2-Apr-05            8:00                21:00          13 Jam           4 Jam
         3-Apr-05            8:00                22:00          14 Jam           5 Jam
         4-Apr-05            8:00                23:00          15 Jam           6 Jam
         5-Apr-05            8:00                22:00          14 Jam           5 Jam
         6-Apr-05            8:00                19:00          11 Jam           2 Jam
         7-Apr-05            8:00                23:00          15 Jam           6 Jam
         8-Apr-05            8:00                22:00          14 Jam           5 Jam
         9-Apr-05            8:00                21:00          13 Jam           4 Jam
        10-Apr-05            8:00                17:00           9 Jam             Jam
        11-Apr-05            8:00                18:00          10 Jam           1 Jam
        12-Apr-05            8:00                19:00          11 Jam           2 Jam
        13-Apr-05            8:00                22:00          14 Jam           5 Jam
        14-Apr-05            8:00                17:00           9 Jam             Jam
        15-Apr-05            8:00                23:00          15 Jam           6 Jam
        16-Apr-05            8:00                22:00          14 Jam           5 Jam
        17-Apr-05            8:00                21:00          13 Jam           4 Jam
        18-Apr-05            8:00                17:00           9 Jam             Jam
        19-Apr-05            8:00                18:00          10 Jam           1 Jam
        20-Apr-05            8:00                23:00          15 Jam           6 Jam
        21-Apr-05            8:00                22:00          14 Jam           5 Jam
        22-Apr-05            8:00                21:00          13 Jam           4 Jam
        23-Apr-05            8:00                21:00          13 Jam           4 Jam
        24-Apr-05            8:00                17:00           9 Jam             Jam
        25-Apr-05            8:00                18:00          10 Jam           1 Jam
        26-Apr-05            8:00                19:00          11 Jam           2 Jam
        27-Apr-05            8:00                22:00          14 Jam           5 Jam
        28-Apr-05            8:00                21:00          13 Jam           4 Jam
        29-Apr-05            8:00                17:00           9 Jam             Jam
        30-Apr-05            8:00                18:00          10 Jam           1 Jam
     hari        upah lembur
Jumat       Rp           45,000
Minggu      Rp          100,000
Minggu      Rp          125,000
Senin       Rp           90,000
Selasa      Rp           75,000
Rabu        Rp           30,000
Kamis       Rp           90,000
Jumat       Rp           75,000
Minggu      Rp          100,000
Minggu      Rp                -
Jumat       Rp           15,000
senin       Rp           30,000
Selasa      Rp           75,000
Kamis       Rp                -
Minggu      Rp          150,000
Jumat       Rp           75,000
Senin       Rp           60,000
Selasa      Rp                -
Rabu        Rp           15,000
Kamis       Rp           90,000
Jumat       Rp           75,000
Minggu      Rp          100,000
Senin       Rp           60,000
Kamis       Rp                -
Minggu      Rp           25,000
Jumat       Rp           30,000
Selasa      Rp           75,000
Rabu        Rp           60,000
Kamis       Rp                -
Minggu      Rp           25,000
                                                                            GAJI KARYAWAN PT. ANUGRAH JAYA
                                                                                     BULAN MEI 2011


 No      Nama     Status    Jlm. Anak       Gol        Gaji Pokok      Tunj. Istri/Suami
   1   Afli      Kawin              3   III/A     Rp    1,600,000.00   Rp   128,000.00
   2   Dina      Kawin              2   III/B     Rp    1,750,000.00   Rp   140,000.00
   3   Udin      Tidak              0   III/C     Rp    2,100,000.00   Rp          -
   4   Neira     Kawin              3   III/A     Rp    1,600,000.00   Rp   128,000.00
   5   Novi      Tidak              2   III/D     Rp    2,200,000.00   Rp          -
   6   Rosnia    Kawin              1   III/C     Rp    2,100,000.00   Rp   168,000.00
   7   Sigit     Kawin              3   III/A     Rp    1,600,000.00   Rp   128,000.00
   8   Sarita    Kawin              2   III/B     Rp    1,750,000.00   Rp   140,000.00
   9   Busha     Tidak              4   III/C     Rp    2,100,000.00   Rp          -
  10   Karyuni   Kawin              2   III/D     Rp    2,200,000.00   Rp   176,000.00




Keterangan:
Tunjangan keluarga:
Tunjangan Istri/suami jika kawin, maka 8%xgaji pokok, lainnya 0
Tunjangan anak : jika jumlah anak dihitung 3% x jumlah anak maksimal 2 orang
potongan: 2% x gaji kotor
tanda terima--> pergunakan cara yang benar
GAJI KARYAWAN PT. ANUGRAH JAYA
         BULAN MEI 2011


                Tunj. Anak            Gaji Kotor        Potongan             Gaji Bersih        Tanda Terima

           Rp       96,000.00    Rp     1,824,000.00   Rp   36,480.00   Rp   1,787,520.00   1 ……..
           Rp      105,000.00    Rp     1,995,000.00   Rp   39,900.00   Rp   1,955,100.00             2 ……..
           Rp             -      Rp     2,100,000.00   Rp   42,000.00   Rp   2,058,000.00   3 ……..
           Rp       96,000.00    Rp     1,824,000.00   Rp   36,480.00   Rp   1,787,520.00             4.
           Rp      132,000.00    Rp     2,332,000.00   Rp   46,640.00   Rp   2,285,360.00   5 ……..
           Rp       63,000.00    Rp     2,331,000.00   Rp   46,620.00   Rp   2,284,380.00                       6
           Rp       96,000.00    Rp     1,824,000.00   Rp   36,480.00   Rp   1,787,520.00   7 ……..
           Rp      105,000.00    Rp     1,995,000.00   Rp   39,900.00   Rp   1,955,100.00             8 ……..
           Rp      126,000.00    Rp     2,226,000.00   Rp   44,520.00   Rp   2,181,480.00   9 ……..
           Rp      132,000.00    Rp     2,508,000.00   Rp   50,160.00   Rp   2,457,840.00             10 ……..

              Tabel gaji pokok        GAJI POKOK                                                                1
          III/A                  Rp     1,600,000.00
          III/B                  Rp     1,750,000.00
          III/C                  Rp     2,100,000.00
          III/D                  Rp     2,200,000.00
GAJI KARYAWAN PT ANUGERAH JAYA
BULAN MEI 2011



NO          NAMA                KODE           JML ANAK     MASA KERJA          GAJI POKOK
   1   HENRY               K/7/III/D       7                    25 Tahun   Rp       3,100,000
   2   SULAIMAN            K/2/III/B       2                     3 Tahun   Rp       1,750,000
   3   ERFINA              T/2/III/C       2                     4 Tahun   Rp       2,100,000
   4   YUNI                T/3/III/D       3                    16 Tahun   Rp       3,100,000
   5   SARAH               K/2/III/B       2                    12 Tahun   Rp       2,300,000
   6   HASAN               K/1/III/D       1                     8 Tahun   Rp       2,400,000
   7   UDIN                K/2/III/c       2                     4 Tahun   Rp       2,100,000
   8   NANI                T/2/III/D       2                     5 Tahun   Rp       2,400,000




TABEL GAJI POKOK
      1-4 TH               5-8 TH          9-12 TH         >13 TH
III/A Rp       1,600,000    Rp 1,800,000    Rp 2,200,000    Rp 2,400,000
III/B Rp       1,750,000    Rp 1,900,000    Rp 2,300,000    Rp 2,500,000
III/C Rp       2,100,000    Rp 2,300,000    Rp 2,650,000    Rp 2,870,000
III/D Rp       2,200,000    Rp 2,400,000    Rp 2,700,000    Rp 3,100,000
   TUNJANGAN
                    TUNJANGAN ANAK        GAJI KOTOR           POT                 GAJI BERSIH
   ISTRI/SUAMI
Rp        248,000   Rp      93,000   Rp       3,441,000   Rp         68,820   Rp       3,372,180
Rp        140,000   Rp      52,500   Rp       1,942,500   Rp         38,850   Rp       1,903,650
Rp              -   Rp      63,000   Rp       2,163,000   Rp         43,260   Rp       2,119,740
Rp              -   Rp      93,000   Rp       3,193,000   Rp         63,860   Rp       3,129,140
Rp        184,000   Rp      69,000   Rp       2,553,000   Rp         51,060   Rp       2,501,940
Rp        192,000   Rp      72,000   Rp       2,664,000   Rp         53,280   Rp       2,610,720
Rp        168,000   Rp      63,000   Rp       2,331,000   Rp         46,620   Rp       2,284,380
Rp              -   Rp      72,000   Rp       2,472,000   Rp         49,440   Rp       2,422,560
               TANDA TERIMA

1 ..........
                    2
3
                    4
5
                    6
7
                    8
LAPORAN PENJUALAN MOBIL
PT INDRA MOBILINDO
SEMESTER II TAHUN 2010


                                  ALAMAT
  NO         KODE PENJUALAN                 TRANSMISI   MERK MOBIL      JENIS MOBIL
                                 PEMBELI
       1   at/S/J/T            Klaten      automatic    Suzuki       Jeep
       2   at/D/M/K            Sragen      standar      Daihatsu     Minibus
       3   st/M/S/K            Sukoharjo   automatic    Mitsubishi   Sedan
       4   at/M/M/K            Solo        standar      Mitsubishi   Minibus
       5   st/D/J/T            Sragen      automatic    Daihatsu     Jeep
       6   at/S/M/K            Klaten      standar      Suzuki       Minibus




           tabel harga mobil
                               Minibus    Jeep        Sedan
           Suzuki               76,789,000 65,000,000   95,000,000
           Daihatsu             76,000,000 63,000,000   89,000,000
           Mitsubishi           65,000,000 72,500,000 100,000,000
     HARGA MOBIL       HARGA TAMBAHAN      TOTAL HARGA         CARA BAYAR        POTONGAN
Rp        65,000,000   Rp     1,300,000   Rp    66,300,000   Tunai          Rp              -
Rp        76,000,000   Rp             -   Rp    76,000,000   Kredit         Rp              -
Rp       100,000,000   Rp     2,000,000   Rp   102,000,000   Kredit         Rp              -
Rp        65,000,000   Rp             -   Rp    65,000,000   Kredit         Rp              -
Rp        63,000,000   Rp     1,260,000   Rp    64,260,000   Tunai          Rp      1,927,800
Rp        76,789,000   Rp             -   Rp    76,789,000   Kredit         Rp              -
     UANG MUKA            SISA BAYAR
Rp               -   Rp       66,300,000
Rp      15,200,000   Rp       60,800,000
Rp      20,400,000   Rp       81,600,000
Rp      13,000,000   Rp       52,000,000
Rp               -   Rp       64,260,000
Rp      15,357,800   Rp       61,431,200
LAPORAN PENJUALAN MOBIL
PT INDRA MOBILINDO
SEMESTER II TAHUN 2010


                                   ALAMAT
  NO          KODE PENJUALAN                 TRANSMISI   MERK MOBIL      JENIS MOBIL
                                  PEMBELI
        8   at/D/M/T            Sragen      automatic    Daihatsu     Minibus
        2   at/D/M/K            Sragen      automatic    Daihatsu     Minibus
       18   at/D/M/K            Klaten      standar      Daihatsu     Minibus
        5   st/D/J/T            Sragen      automatic    Daihatsu     Jeep
        9   at/D/J/K            Sukoharjo   standar      Daihatsu     Jeep
       11   st/D/J/T            Sragen      standar      Daihatsu     Jeep
        3   st/M/S/K            Sukoharjo   standar      Mitsubishi   Sedan
       15   st/M/S/T            Sukoharjo   standar      Mitsubishi   Sedan
       17   st/M/J/T            Sragen      automatic    Mitsubishi   Jeep
        4   at/M/M/K            Solo        automatic    Mitsubishi   Minibus
       10   at/M/M/K            Sragen      automatic    Mitsubishi   Minibus
        6   at/S/M/T            Klaten      standar      Suzuki       Minibus
       12   st/S/M/K            Sukoharjo   automatic    Suzuki       Minibus
       14   at/S/M/K            Sragen      automatic    Suzuki       Minibus
        1   at/S/J/T            Klaten      automatic    Suzuki       Jeep
        7   at/S/J/T            Klaten      automatic    Suzuki       Jeep
       13   at/S/J/K            Klaten      automatic    Suzuki       Jeep
       16   at/S/J/K            Solo        standar      Suzuki       Jeep




            tabel harga mobil
                                Minibus    Jeep        Sedan
            Suzuki               76,789,000 65,000,000   95,000,000
            Daihatsu             76,000,000 63,000,000   89,000,000
            Mitsubishi           65,000,000 72,500,000 100,000,000
     HARGA MOBIL       HARGA TAMBAHAN      TOTAL HARGA         CARA BAYAR        POTONGAN
Rp        76,000,000   Rp     1,520,000   Rp    77,520,000   Tunai          Rp              -
Rp        76,000,000   Rp     1,520,000   Rp    77,520,000   Kredit         Rp              -
Rp        76,000,000   Rp             -   Rp    76,000,000   Kredit         Rp              -
Rp        63,000,000   Rp     1,260,000   Rp    64,260,000   Tunai          Rp      1,927,800
Rp        63,000,000   Rp             -   Rp    63,000,000   Kredit         Rp              -
Rp        63,000,000   Rp             -   Rp    63,000,000   Tunai          Rp      1,890,000
Rp       100,000,000   Rp             -   Rp   100,000,000   Kredit         Rp              -
Rp       100,000,000   Rp             -   Rp   100,000,000   Tunai          Rp              -
Rp        72,500,000   Rp     1,450,000   Rp    73,950,000   Tunai          Rp      2,218,500
Rp        65,000,000   Rp     1,300,000   Rp    66,300,000   Kredit         Rp              -
Rp        65,000,000   Rp     1,300,000   Rp    66,300,000   Kredit         Rp              -
Rp        76,789,000   Rp             -   Rp    76,789,000   Tunai          Rp              -
Rp        76,789,000   Rp     1,535,780   Rp    78,324,780   Kredit         Rp              -
Rp        76,789,000   Rp     1,535,780   Rp    78,324,780   Kredit         Rp              -
Rp        65,000,000   Rp     1,300,000   Rp    66,300,000   Tunai          Rp              -
Rp        65,000,000   Rp     1,300,000   Rp    66,300,000   Tunai          Rp              -
Rp        65,000,000   Rp     1,300,000   Rp    66,300,000   Kredit         Rp              -
Rp        65,000,000   Rp             -   Rp    65,000,000   Kredit         Rp              -
     UANG MUKA            SISA BAYAR
Rp               -   Rp       77,520,000
Rp      15,504,000   Rp       62,016,000
Rp      15,200,000   Rp       60,800,000
Rp               -   Rp       64,260,000
Rp      12,600,000   Rp       50,400,000
Rp               -   Rp       63,000,000
Rp      20,000,000   Rp       80,000,000
Rp               -   Rp      100,000,000
Rp               -   Rp       73,950,000
Rp      13,260,000   Rp       53,040,000
Rp      13,260,000   Rp       53,040,000
Rp               -   Rp       76,789,000
Rp      15,664,956   Rp       62,659,824
Rp      15,664,956   Rp       62,659,824
Rp               -   Rp       66,300,000
Rp               -   Rp       66,300,000
Rp      13,260,000   Rp       53,040,000
Rp      13,000,000   Rp       52,000,000
LAPORAN PENJUALAN MOBIL
PT INDRA MOBILINDO
SEMESTER II TAHUN 2010


                                   ALAMAT
  NO          KODE PENJUALAN                 TRANSMISI   MERK MOBIL       JENIS MOBIL
                                  PEMBELI
        8   at/D/M/T            Sragen      automatic    Daihatsu       Minibus
        2   at/D/M/K            Sragen      automatic    Daihatsu       Minibus
       18   at/D/M/K            Klaten      standar      Daihatsu       Minibus
        5   st/D/J/T            Sragen      automatic    Daihatsu       Jeep
        9   at/D/J/K            Sukoharjo   standar      Daihatsu       Jeep
       11   st/D/J/T            Sragen      standar      Daihatsu       Jeep
                                                         Daihatsu Total
        3   st/M/S/K            Sukoharjo   standar      Mitsubishi     Sedan
       15   st/M/S/T            Sukoharjo   standar      Mitsubishi     Sedan
       17   st/M/J/T            Sragen      automatic    Mitsubishi     Jeep
        4   at/M/M/K            Solo        automatic    Mitsubishi     Minibus
       10   at/M/M/K            Sragen      automatic    Mitsubishi     Minibus
                                                         Mitsubishi Total
        6   at/S/M/T            Klaten      standar      Suzuki         Minibus
       12   st/S/M/K            Sukoharjo   automatic    Suzuki         Minibus
       14   at/S/M/K            Sragen      automatic    Suzuki         Minibus
        1   at/S/J/T            Klaten      automatic    Suzuki         Jeep
        7   at/S/J/T            Klaten      automatic    Suzuki         Jeep
       13   at/S/J/K            Klaten      automatic    Suzuki         Jeep
       16   at/S/J/K            Solo        standar      Suzuki         Jeep
                                                         Suzuki Total
                                                         Grand Total




            tabel harga mobil
                                Minibus    Jeep        Sedan
            Suzuki               76,789,000 65,000,000   95,000,000
            Daihatsu             76,000,000 63,000,000   89,000,000
            Mitsubishi           65,000,000 72,500,000 100,000,000
     HARGA MOBIL       HARGA TAMBAHAN      TOTAL HARGA         CARA BAYAR        POTONGAN
Rp        76,000,000   Rp     1,520,000   Rp    77,520,000   Tunai          Rp              -
Rp        76,000,000   Rp     1,520,000   Rp    77,520,000   Kredit         Rp              -
Rp        76,000,000   Rp             -   Rp    76,000,000   Kredit         Rp              -
Rp        63,000,000   Rp     1,260,000   Rp    64,260,000   Tunai          Rp      1,927,800
Rp        63,000,000   Rp             -   Rp    63,000,000   Kredit         Rp              -
Rp        63,000,000   Rp             -   Rp    63,000,000   Tunai          Rp      1,890,000
Rp       417,000,000   Rp     4,300,000   Rp   421,300,000                  Rp      3,817,800
Rp       100,000,000   Rp             -   Rp   100,000,000   Kredit         Rp              -
Rp       100,000,000   Rp             -   Rp   100,000,000   Tunai          Rp              -
Rp        72,500,000   Rp     1,450,000   Rp    73,950,000   Tunai          Rp      2,218,500
Rp        65,000,000   Rp     1,300,000   Rp    66,300,000   Kredit         Rp              -
Rp        65,000,000   Rp     1,300,000   Rp    66,300,000   Kredit         Rp              -
Rp       402,500,000   Rp     4,050,000   Rp   406,550,000                  Rp      2,218,500
Rp        76,789,000   Rp             -   Rp    76,789,000   Tunai          Rp              -
Rp        76,789,000   Rp     1,535,780   Rp    78,324,780   Kredit         Rp              -
Rp        76,789,000   Rp     1,535,780   Rp    78,324,780   Kredit         Rp              -
Rp        65,000,000   Rp     1,300,000   Rp    66,300,000   Tunai          Rp              -
Rp        65,000,000   Rp     1,300,000   Rp    66,300,000   Tunai          Rp              -
Rp        65,000,000   Rp     1,300,000   Rp    66,300,000   Kredit         Rp              -
Rp        65,000,000   Rp             -   Rp    65,000,000   Kredit         Rp              -
Rp       490,367,000   Rp     6,971,560   Rp   497,338,560                  Rp              -
Rp     1,309,867,000   Rp    15,321,560   Rp 1,325,188,560                  Rp      6,036,300
     UANG MUKA            SISA BAYAR
Rp               -   Rp        77,520,000
Rp      15,504,000   Rp        62,016,000
Rp      15,200,000   Rp        60,800,000
Rp               -   Rp        64,260,000
Rp      12,600,000   Rp        50,400,000
Rp               -   Rp        63,000,000
Rp      43,304,000   Rp       377,996,000
Rp      20,000,000   Rp        80,000,000
Rp               -   Rp       100,000,000
Rp               -   Rp        73,950,000
Rp      13,260,000   Rp        53,040,000
Rp      13,260,000   Rp        53,040,000
Rp      46,520,000   Rp       360,030,000
Rp               -   Rp        76,789,000
Rp      15,664,956   Rp        62,659,824
Rp      15,664,956   Rp        62,659,824
Rp               -   Rp        66,300,000
Rp               -   Rp        66,300,000
Rp      13,260,000   Rp        53,040,000
Rp      13,000,000   Rp        52,000,000
Rp      57,589,912   Rp       439,748,648
Rp     147,413,912   Rp     1,177,774,648
LAPORAN PENJUALAN MOBIL
PT INDRA MOBILINDO
SEMESTER II TAHUN 2010


                                   ALAMAT
  NO          KODE PENJUALAN                 TRANSMISI   MERK MOBIL       JENIS MOBIL
                                  PEMBELI
        8   at/D/M/T            Sragen      automatic    Daihatsu       Minibus
        2   at/D/M/K            Sragen      automatic    Daihatsu       Minibus
       18   at/D/M/K            Klaten      standar      Daihatsu       Minibus
        5   st/D/J/T            Sragen      automatic    Daihatsu       Jeep
        9   at/D/J/K            Sukoharjo   standar      Daihatsu       Jeep
       11   st/D/J/T            Sragen      standar      Daihatsu       Jeep
                                                         Daihatsu Total
        3   st/M/S/K            Sukoharjo   standar      Mitsubishi     Sedan
       15   st/M/S/T            Sukoharjo   standar      Mitsubishi     Sedan
       17   st/M/J/T            Sragen      automatic    Mitsubishi     Jeep
        4   at/M/M/K            Solo        automatic    Mitsubishi     Minibus
       10   at/M/M/K            Sragen      automatic    Mitsubishi     Minibus
                                                         Mitsubishi Total
        6   at/S/M/T            Klaten      standar      Suzuki         Minibus
       12   st/S/M/K            Sukoharjo   automatic    Suzuki         Minibus
       14   at/S/M/K            Sragen      automatic    Suzuki         Minibus
        1   at/S/J/T            Klaten      automatic    Suzuki         Jeep
        7   at/S/J/T            Klaten      automatic    Suzuki         Jeep
       13   at/S/J/K            Klaten      automatic    Suzuki         Jeep
       16   at/S/J/K            Solo        standar      Suzuki         Jeep
                                                         Suzuki Total
                                                         Grand Total




            tabel harga mobil
                                Minibus    Jeep        Sedan
            Suzuki               76,789,000 65,000,000   95,000,000
            Daihatsu             76,000,000 63,000,000   89,000,000
            Mitsubishi           65,000,000 72,500,000 100,000,000
     HARGA MOBIL       HARGA TAMBAHAN      TOTAL HARGA         CARA BAYAR        POTONGAN
Rp        76,000,000   Rp     1,520,000   Rp    77,520,000   Tunai          Rp              -
Rp        76,000,000   Rp     1,520,000   Rp    77,520,000   Kredit         Rp              -
Rp        76,000,000   Rp             -   Rp    76,000,000   Kredit         Rp              -
Rp        63,000,000   Rp     1,260,000   Rp    64,260,000   Tunai          Rp      1,927,800
Rp        63,000,000   Rp             -   Rp    63,000,000   Kredit         Rp              -
Rp        63,000,000   Rp             -   Rp    63,000,000   Tunai          Rp      1,890,000
                                          Rp   421,300,000
Rp       100,000,000   Rp             -   Rp   100,000,000   Kredit         Rp              -
Rp       100,000,000   Rp             -   Rp   100,000,000   Tunai          Rp              -
Rp        72,500,000   Rp     1,450,000   Rp    73,950,000   Tunai          Rp      2,218,500
Rp        65,000,000   Rp     1,300,000   Rp    66,300,000   Kredit         Rp              -
Rp        65,000,000   Rp     1,300,000   Rp    66,300,000   Kredit         Rp              -
                                          Rp   406,550,000
Rp        76,789,000   Rp             -   Rp    76,789,000   Tunai          Rp              -
Rp        76,789,000   Rp     1,535,780   Rp    78,324,780   Kredit         Rp              -
Rp        76,789,000   Rp     1,535,780   Rp    78,324,780   Kredit         Rp              -
Rp        65,000,000   Rp     1,300,000   Rp    66,300,000   Tunai          Rp              -
Rp        65,000,000   Rp     1,300,000   Rp    66,300,000   Tunai          Rp              -
Rp        65,000,000   Rp     1,300,000   Rp    66,300,000   Kredit         Rp              -
Rp        65,000,000   Rp             -   Rp    65,000,000   Kredit         Rp              -
                                          Rp   497,338,560
                                          Rp 1,325,188,560
     UANG MUKA            SISA BAYAR
Rp               -   Rp       77,520,000
Rp      15,504,000   Rp       62,016,000
Rp      15,200,000   Rp       60,800,000
Rp               -   Rp       64,260,000
Rp      12,600,000   Rp       50,400,000
Rp               -   Rp       63,000,000

Rp      20,000,000   Rp       80,000,000
Rp               -   Rp      100,000,000
Rp               -   Rp       73,950,000
Rp      13,260,000   Rp       53,040,000
Rp      13,260,000   Rp       53,040,000

Rp               -   Rp       76,789,000
Rp      15,664,956   Rp       62,659,824
Rp      15,664,956   Rp       62,659,824
Rp               -   Rp       66,300,000
Rp               -   Rp       66,300,000
Rp      13,260,000   Rp       53,040,000
Rp      13,000,000   Rp       52,000,000
LAPORAN PENJUALAN MOBIL
PT INDRA MOBILINDO
SEMESTER II TAHUN 2010


                                   ALAMAT
  NO          KODE PENJUALAN                 TRANSMISI   MERK MOBIL       JENIS MOBIL
                                  PEMBELI
        8   at/D/M/T            Sragen      automatic    Daihatsu       Minibus
        2   at/D/M/K            Sragen      automatic    Daihatsu       Minibus
       18   at/D/M/K            Klaten      standar      Daihatsu       Minibus
        5   st/D/J/T            Sragen      automatic    Daihatsu       Jeep
        9   at/D/J/K            Sukoharjo   standar      Daihatsu       Jeep
       11   st/D/J/T            Sragen      standar      Daihatsu       Jeep
                                                         Daihatsu Total
        3   st/M/S/K            Sukoharjo   standar      Mitsubishi     Sedan
       15   st/M/S/T            Sukoharjo   standar      Mitsubishi     Sedan
       17   st/M/J/T            Sragen      automatic    Mitsubishi     Jeep
        4   at/M/M/K            Solo        automatic    Mitsubishi     Minibus
       10   at/M/M/K            Sragen      automatic    Mitsubishi     Minibus
                                                         Mitsubishi Total
        6   at/S/M/T            Klaten      standar      Suzuki         Minibus
       12   st/S/M/K            Sukoharjo   automatic    Suzuki         Minibus
       14   at/S/M/K            Sragen      automatic    Suzuki         Minibus
        1   at/S/J/T            Klaten      automatic    Suzuki         Jeep
        7   at/S/J/T            Klaten      automatic    Suzuki         Jeep
       13   at/S/J/K            Klaten      automatic    Suzuki         Jeep
       16   at/S/J/K            Solo        standar      Suzuki         Jeep
                                                         Suzuki Total
                                                         Grand Total




            tabel harga mobil
                                Minibus    Jeep        Sedan
            Suzuki               76,789,000 65,000,000   95,000,000
            Daihatsu             76,000,000 63,000,000   89,000,000
            Mitsubishi           65,000,000 72,500,000 100,000,000
     HARGA MOBIL       HARGA TAMBAHAN      TOTAL HARGA         CARA BAYAR        POTONGAN
Rp        76,000,000   Rp     1,520,000   Rp    77,520,000   Tunai          Rp              -
Rp        76,000,000   Rp     1,520,000   Rp    77,520,000   Kredit         Rp              -
Rp        76,000,000   Rp             -   Rp    76,000,000   Kredit         Rp              -
Rp        63,000,000   Rp     1,260,000   Rp    64,260,000   Tunai          Rp      1,927,800
Rp        63,000,000   Rp             -   Rp    63,000,000   Kredit         Rp              -
Rp        63,000,000   Rp             -   Rp    63,000,000   Tunai          Rp      1,890,000
Rp       417,000,000   Rp     4,300,000   Rp   421,300,000                  Rp      3,817,800
Rp       100,000,000   Rp             -   Rp   100,000,000   Kredit         Rp              -
Rp       100,000,000   Rp             -   Rp   100,000,000   Tunai          Rp              -
Rp        72,500,000   Rp     1,450,000   Rp    73,950,000   Tunai          Rp      2,218,500
Rp        65,000,000   Rp     1,300,000   Rp    66,300,000   Kredit         Rp              -
Rp        65,000,000   Rp     1,300,000   Rp    66,300,000   Kredit         Rp              -
Rp       402,500,000   Rp     4,050,000   Rp   406,550,000                  Rp      2,218,500
Rp        76,789,000   Rp             -   Rp    76,789,000   Tunai          Rp              -
Rp        76,789,000   Rp     1,535,780   Rp    78,324,780   Kredit         Rp              -
Rp        76,789,000   Rp     1,535,780   Rp    78,324,780   Kredit         Rp              -
Rp        65,000,000   Rp     1,300,000   Rp    66,300,000   Tunai          Rp              -
Rp        65,000,000   Rp     1,300,000   Rp    66,300,000   Tunai          Rp              -
Rp        65,000,000   Rp     1,300,000   Rp    66,300,000   Kredit         Rp              -
Rp        65,000,000   Rp             -   Rp    65,000,000   Kredit         Rp              -
Rp       490,367,000   Rp     6,971,560   Rp   497,338,560                  Rp              -
Rp     1,309,867,000   Rp    15,321,560   Rp 1,325,188,560                  Rp      6,036,300
     UANG MUKA            SISA BAYAR
Rp               -   Rp        77,520,000
Rp      15,504,000   Rp        62,016,000
Rp      15,200,000   Rp        60,800,000
Rp               -   Rp        64,260,000
Rp      12,600,000   Rp        50,400,000
Rp               -   Rp        63,000,000
Rp      43,304,000   Rp       377,996,000
Rp      20,000,000   Rp        80,000,000
Rp               -   Rp       100,000,000
Rp               -   Rp        73,950,000
Rp      13,260,000   Rp        53,040,000
Rp      13,260,000   Rp        53,040,000
Rp      46,520,000   Rp       360,030,000
Rp               -   Rp        76,789,000
Rp      15,664,956   Rp        62,659,824
Rp      15,664,956   Rp        62,659,824
Rp               -   Rp        66,300,000
Rp               -   Rp        66,300,000
Rp      13,260,000   Rp        53,040,000
Rp      13,000,000   Rp        52,000,000
Rp      57,589,912   Rp       439,748,648
Rp     147,413,912   Rp     1,177,774,648
LAPORAN PENJUALAN MOBIL
PT INDRA MOBILINDO
SEMESTER II TAHUN 2010


                                   ALAMAT
  NO          KODE PENJUALAN                 TRANSMISI           MERK MOBIL
                                  PEMBELI
        8   at/D/M/T            Sragen      automatic    Daihatsu
        2   at/D/M/K            Sragen      automatic    Daihatsu
       18   at/D/M/K            Klaten      standar      Daihatsu
        5   st/D/J/T            Sragen      automatic    Daihatsu
        9   at/D/J/K            Sukoharjo   standar      Daihatsu
       11   st/D/J/T            Sragen      standar      Daihatsu
                                                         Daihatsu Total
        3   st/M/S/K            Sukoharjo   standar      Mitsubishi
       15   st/M/S/T            Sukoharjo   standar      Mitsubishi
       17   st/M/J/T            Sragen      automatic    Mitsubishi
        4   at/M/M/K            Solo        automatic    Mitsubishi
       10   at/M/M/K            Sragen      automatic    Mitsubishi
                                                         Mitsubishi Total
        6   at/S/M/T            Klaten      standar      Suzuki
       12   st/S/M/K            Sukoharjo   automatic    Suzuki
       14   at/S/M/K            Sragen      automatic    Suzuki
        1   at/S/J/T            Klaten      automatic    Suzuki
        7   at/S/J/T            Klaten      automatic    Suzuki
       13   at/S/J/K            Klaten      automatic    Suzuki
       16   at/S/J/K            Solo        standar      Suzuki
                                                         Suzuki Total
                                                         Grand Total




                                                         Daihatsu Total
                                                         Mitsubishi Total
                                                         Suzuki Total




            tabel harga mobil
                                Minibus    Jeep        Sedan
            Suzuki               76,789,000 65,000,000                       95,000,000
            Daihatsu             76,000,000 63,000,000                       89,000,000
            Mitsubishi           65,000,000 72,500,000                      100,000,000
LAPORAN PENJUALAN MOBIL MERK SUZUKI

                                   ALAMAT
   NO          KODE PENJUALAN                 TRANSMISI            MERK MOBIL
                                  PEMBELI
         6   at/S/M/T           Klaten       standar      Suzuki
        12   st/S/M/K           Sukoharjo    automatic    Suzuki
        14   at/S/M/K           Sragen       automatic    Suzuki
         1   at/S/J/T           Klaten       automatic    Suzuki
         7   at/S/J/T           Klaten       automatic    Suzuki
        13   at/S/J/K           Klaten       automatic    Suzuki
        16   at/S/J/K           Solo         standar      Suzuki

LAPORAN PENJUALAN MOBIL MERK SUZUKI (JEEP)

                                   ALAMAT
   NO          KODE PENJUALAN                 TRANSMISI            MERK MOBIL
                                  PEMBELI
         1   at/S/J/T           Klaten       automatic    Suzuki
         7   at/S/J/T           Klaten       automatic    Suzuki
        13   at/S/J/K           Klaten       automatic    Suzuki
        16   at/S/J/K           Solo         standar      Suzuki
                                                          Grand Total
     JENIS MOBIL          HARGA MOBIL       HARGA TAMBAHAN      TOTAL HARGA          CARA BAYAR
Minibus              Rp        76,000,000   Rp     1,520,000   Rp    77,520,000   Tunai
Minibus              Rp        76,000,000   Rp     1,520,000   Rp    77,520,000   Kredit
Minibus              Rp        76,000,000   Rp             -   Rp    76,000,000   Kredit
Jeep                 Rp        63,000,000   Rp     1,260,000   Rp    64,260,000   Tunai
Jeep                 Rp        63,000,000   Rp             -   Rp    63,000,000   Kredit
Jeep                 Rp        63,000,000   Rp             -   Rp    63,000,000   Tunai
                                                               Rp   421,300,000
Sedan                Rp       100,000,000   Rp             -   Rp   100,000,000   Kredit
Sedan                Rp       100,000,000   Rp             -   Rp   100,000,000   Tunai
Jeep                 Rp        72,500,000   Rp     1,450,000   Rp    73,950,000   Tunai
Minibus              Rp        65,000,000   Rp     1,300,000   Rp    66,300,000   Kredit
Minibus              Rp        65,000,000   Rp     1,300,000   Rp    66,300,000   Kredit
                                                               Rp   406,550,000
Minibus              Rp        76,789,000   Rp             -   Rp    76,789,000   Tunai
Minibus              Rp        76,789,000   Rp     1,535,780   Rp    78,324,780   Kredit
Minibus              Rp        76,789,000   Rp     1,535,780   Rp    78,324,780   Kredit
Jeep                 Rp        65,000,000   Rp     1,300,000   Rp    66,300,000   Tunai
Jeep                 Rp        65,000,000   Rp     1,300,000   Rp    66,300,000   Tunai
Jeep                 Rp        65,000,000   Rp     1,300,000   Rp    66,300,000   Kredit
Jeep                 Rp        65,000,000   Rp             -   Rp    65,000,000   Kredit
                                                               Rp   497,338,560
                                                               Rp 1,325,188,560


                                                      GRAFIK PENJUALAN MOBIL TAHUN 2010
Rp     421,300,000                                               Daihatsu Total   Mitsubishi Total     Suzuki Total
Rp     406,550,000
Rp     497,338,560




                                                                                                     32%
                                                                       37%




                                                                                        31%
   JENIS MOBIL        HARGA MOBIL       HARGA TAMBAHAN      TOTAL HARGA         CARA BAYAR
Minibus          Rp        76,789,000   Rp             -   Rp    76,789,000   Tunai
Minibus          Rp        76,789,000   Rp     1,535,780   Rp    78,324,780   Kredit
Minibus          Rp        76,789,000   Rp     1,535,780   Rp    78,324,780   Kredit
Jeep             Rp        65,000,000   Rp     1,300,000   Rp    66,300,000   Tunai
Jeep             Rp        65,000,000   Rp     1,300,000   Rp    66,300,000   Tunai
Jeep             Rp        65,000,000   Rp     1,300,000   Rp    66,300,000   Kredit
Jeep             Rp        65,000,000   Rp             -   Rp    65,000,000   Kredit




   JENIS MOBIL        HARGA MOBIL       HARGA TAMBAHAN      TOTAL HARGA         CARA BAYAR
Jeep             Rp        65,000,000   Rp     1,300,000   Rp    66,300,000   Tunai
Jeep             Rp        65,000,000   Rp     1,300,000   Rp    66,300,000   Tunai
Jeep             Rp        65,000,000   Rp     1,300,000   Rp    66,300,000   Kredit
Jeep             Rp        65,000,000   Rp             -   Rp    65,000,000   Kredit
                                                           Rp   263,900,000
                   POTONGAN            UANG MUKA            SISA BAYAR
              Rp              -   Rp               -   Rp       77,520,000
              Rp              -   Rp      15,504,000   Rp       62,016,000
              Rp              -   Rp      15,200,000   Rp       60,800,000
              Rp      1,927,800   Rp               -   Rp       64,260,000
              Rp              -   Rp      12,600,000   Rp       50,400,000
              Rp      1,890,000   Rp               -   Rp       63,000,000

              Rp              -   Rp      20,000,000   Rp       80,000,000
              Rp              -   Rp               -   Rp      100,000,000
              Rp      2,218,500   Rp               -   Rp       73,950,000
              Rp              -   Rp      13,260,000   Rp       53,040,000
              Rp              -   Rp      13,260,000   Rp       53,040,000

              Rp              -   Rp               -   Rp       76,789,000
              Rp              -   Rp      15,664,956   Rp       62,659,824
              Rp              -   Rp      15,664,956   Rp       62,659,824
              Rp              -   Rp               -   Rp       66,300,000
              Rp              -   Rp               -   Rp       66,300,000
              Rp              -   Rp      13,260,000   Rp       53,040,000
              Rp              -   Rp      13,000,000   Rp       52,000,000




AN MOBIL TAHUN 2010
          Suzuki Total




        32%
     POTONGAN            UANG MUKA            SISA BAYAR
Rp              -   Rp               -   Rp       76,789,000
Rp              -   Rp      15,664,956   Rp       62,659,824
Rp              -   Rp      15,664,956   Rp       62,659,824
Rp              -   Rp               -   Rp       66,300,000
Rp              -   Rp               -   Rp       66,300,000
Rp              -   Rp      13,260,000   Rp       53,040,000
Rp              -   Rp      13,000,000   Rp       52,000,000




     POTONGAN            UANG MUKA            SISA BAYAR
Rp              -   Rp               -   Rp       66,300,000
Rp              -   Rp               -   Rp       66,300,000
Rp              -   Rp      13,260,000   Rp       53,040,000
Rp              -   Rp      13,000,000   Rp       52,000,000
LAPORAN PENJUALAN MOBIL
PT INDRA MOBILINDO
SEMESTER II TAHUN 2010


                                    ALAMAT
   NO          KODE PENJUALAN                 TRANSMISI   MERK MOBIL       JENIS MOBIL
                                   PEMBELI
         8   at/D/M/T            Sragen      automatic    Daihatsu      Minibus
         2   at/D/M/K            Sragen      automatic    Daihatsu      Minibus
        18   at/D/M/K            Klaten      standar      Daihatsu      Minibus
         5   st/D/J/T            Sragen      automatic    Daihatsu      Jeep
         9   at/D/J/K            Sukoharjo   standar      Daihatsu      Jeep
        11   st/D/J/T            Sragen      standar      Daihatsu      Jeep
                                                          Grand Total




             tabel harga mobil
                                 Minibus    Jeep        Sedan
             Suzuki               76,789,000 65,000,000   95,000,000
             Daihatsu             76,000,000 63,000,000   89,000,000
             Mitsubishi           65,000,000 72,500,000 100,000,000

LAPORAN PENJUALAN MOBIL MERK SUZUKI

                                    ALAMAT
   NO          KODE PENJUALAN                 TRANSMISI   MERK MOBIL       JENIS MOBIL
                                   PEMBELI
         6   at/S/M/T            Klaten      standar      Suzuki        Minibus
        12   st/S/M/K            Sukoharjo   automatic    Suzuki        Minibus
        14   at/S/M/K            Sragen      automatic    Suzuki        Minibus
         1   at/S/J/T            Klaten      automatic    Suzuki        Jeep
         7   at/S/J/T            Klaten      automatic    Suzuki        Jeep
        13   at/S/J/K            Klaten      automatic    Suzuki        Jeep
        16   at/S/J/K            Solo        standar      Suzuki        Jeep

LAPORAN PENJUALAN MOBIL MERK SUZUKI (JEEP)
                                ALAMAT
NO          KODE PENJUALAN                TRANSMISI   MERK MOBIL       JENIS MOBIL
                               PEMBELI
      1   at/S/J/T           Klaten      automatic    Suzuki        Jeep
      7   at/S/J/T           Klaten      automatic    Suzuki        Jeep
     13   at/S/J/K           Klaten      automatic    Suzuki        Jeep
     16   at/S/J/K           Solo        standar      Suzuki        Jeep
                                                      Grand Total
     HARGA MOBIL       HARGA TAMBAHAN      TOTAL HARGA         CARA BAYAR        POTONGAN
Rp        76,000,000   Rp     1,520,000   Rp    77,520,000   Tunai          Rp              -
Rp        76,000,000   Rp     1,520,000   Rp    77,520,000   Kredit         Rp              -
Rp        76,000,000   Rp             -   Rp    76,000,000   Kredit         Rp              -
Rp        63,000,000   Rp     1,260,000   Rp    64,260,000   Tunai          Rp      1,927,800
Rp        63,000,000   Rp             -   Rp    63,000,000   Kredit         Rp              -
Rp        63,000,000   Rp             -   Rp    63,000,000   Tunai          Rp      1,890,000
                                          Rp   421,300,000




     HARGA MOBIL       HARGA TAMBAHAN      TOTAL HARGA         CARA BAYAR        POTONGAN
Rp        76,789,000   Rp             -   Rp    76,789,000   Tunai          Rp              -
Rp        76,789,000   Rp     1,535,780   Rp    78,324,780   Kredit         Rp              -
Rp        76,789,000   Rp     1,535,780   Rp    78,324,780   Kredit         Rp              -
Rp        65,000,000   Rp     1,300,000   Rp    66,300,000   Tunai          Rp              -
Rp        65,000,000   Rp     1,300,000   Rp    66,300,000   Tunai          Rp              -
Rp        65,000,000   Rp     1,300,000   Rp    66,300,000   Kredit         Rp              -
Rp        65,000,000   Rp             -   Rp    65,000,000   Kredit         Rp              -
     HARGA MOBIL       HARGA TAMBAHAN      TOTAL HARGA         CARA BAYAR        POTONGAN
Rp        65,000,000   Rp     1,300,000   Rp    66,300,000   Tunai          Rp              -
Rp        65,000,000   Rp     1,300,000   Rp    66,300,000   Tunai          Rp              -
Rp        65,000,000   Rp     1,300,000   Rp    66,300,000   Kredit         Rp              -
Rp        65,000,000   Rp             -   Rp    65,000,000   Kredit         Rp              -
                                          Rp   263,900,000
     UANG MUKA            SISA BAYAR
Rp               -   Rp       77,520,000
Rp      15,504,000   Rp       62,016,000
Rp      15,200,000   Rp       60,800,000
Rp               -   Rp       64,260,000
Rp      12,600,000   Rp       50,400,000
Rp               -   Rp       63,000,000




     UANG MUKA            SISA BAYAR
Rp               -   Rp       76,789,000
Rp      15,664,956   Rp       62,659,824
Rp      15,664,956   Rp       62,659,824
Rp               -   Rp       66,300,000
Rp               -   Rp       66,300,000
Rp      13,260,000   Rp       53,040,000
Rp      13,000,000   Rp       52,000,000
     UANG MUKA            SISA BAYAR
Rp               -   Rp       66,300,000
Rp               -   Rp       66,300,000
Rp      13,260,000   Rp       53,040,000
Rp      13,000,000   Rp       52,000,000
RENCANA PINJAMAN UANG SAYA DI BANK BRI CABANG PURWOREJO TAHUN 2012

harga rumah                               Rp    98,000,000
uang muka                                 Rp    19,600,000
pinjaman                                  Rp    50,000,000
bunga pertahun                                      15.00%
lama angsuran                                            36

angsuran pokok                            Rp     1,733,266




  bulan ke             pinjaman                bunga           pokok angsuran
              1   Rp         50,000,000   Rp      625,000     Rp      1,108,266
              2   Rp         48,891,734   Rp      611,147     Rp      1,122,120
              3   Rp         47,769,614   Rp      597,120     Rp      1,136,146
              4   Rp         46,633,468   Rp      582,918     Rp      1,150,348
              5   Rp         45,483,119   Rp      568,539     Rp      1,164,727
              6   Rp         44,318,392   Rp      553,980     Rp      1,179,287
              7   Rp         43,139,106   Rp      539,239     Rp      1,194,028
              8   Rp         41,945,078   Rp      524,313     Rp      1,208,953
              9   Rp         40,736,125   Rp      509,202     Rp      1,224,065
             10   Rp         39,512,060   Rp      493,901     Rp      1,239,366
             11   Rp         38,272,694   Rp      478,409     Rp      1,254,858
             12   Rp         37,017,837   Rp      462,723     Rp      1,270,543
             13   Rp         35,747,293   Rp      446,841     Rp      1,286,425
             14   Rp         34,460,868   Rp      430,761     Rp      1,302,506
             15   Rp         33,158,362   Rp      414,480     Rp      1,318,787
             16   Rp         31,839,575   Rp      397,995     Rp      1,335,272
             17   Rp         30,504,304   Rp      381,304     Rp      1,351,963
             18   Rp         29,152,341   Rp      364,404     Rp      1,368,862
             19   Rp         27,783,479   Rp      347,293     Rp      1,385,973
             20   Rp         26,397,506   Rp      329,969     Rp      1,403,298
             21   Rp         24,994,208   Rp      312,428     Rp      1,420,839
             22   Rp         23,573,370   Rp      294,667     Rp      1,438,599
             23   Rp         22,134,770   Rp      276,685     Rp      1,456,582
             24   Rp         20,678,189   Rp      258,477     Rp      1,474,789
             25   Rp         19,203,399   Rp      240,042     Rp      1,493,224
             26   Rp         17,710,176   Rp      221,377     Rp      1,511,889
             27   Rp         16,198,286   Rp      202,479     Rp      1,530,788
             28   Rp         14,667,498   Rp      183,344     Rp      1,549,923
             29   Rp         13,117,576   Rp      163,970     Rp      1,569,297
             30   Rp         11,548,279   Rp      144,353     Rp      1,588,913
             31   Rp          9,959,366   Rp      124,492     Rp      1,608,774
             32   Rp          8,350,592   Rp      104,382     Rp      1,628,884
             33   Rp          6,721,708   Rp       84,021     Rp      1,649,245
             34   Rp          5,072,463   Rp       63,406     Rp      1,669,861
             35   Rp          3,402,602   Rp       42,533     Rp      1,690,734
36   Rp      1,711,868    Rp       21,398    Rp   1,711,868
37   Rp             (0)   Rp           (0)   Rp   1,733,266
38   Rp     (1,733,266)   Rp      (21,666)   Rp   1,754,932
39   Rp     (3,488,199)   Rp      (43,602)   Rp   1,776,869
40   Rp     (5,265,068)   Rp      (65,813)   Rp   1,799,080
41   Rp     (7,064,147)   Rp      (88,302)   Rp   1,821,568
42   Rp     (8,885,716)   Rp     (111,071)   Rp   1,844,338
43   Rp    (10,730,053)   Rp     (134,126)   Rp   1,867,392
44   Rp    (12,597,446)   Rp     (157,468)   Rp   1,890,734
45   Rp    (14,488,180)   Rp     (181,102)   Rp   1,914,369
46   Rp    (16,402,549)   Rp     (205,032)   Rp   1,938,298
47   Rp    (18,340,847)   Rp     (229,261)   Rp   1,962,527
48   Rp    (20,303,374)   Rp     (253,792)   Rp   1,987,059
49   Rp    (22,290,433)   Rp     (278,630)   Rp   2,011,897
50   Rp    (24,302,329)   Rp     (303,779)   Rp   2,037,046
51   Rp    (26,339,375)   Rp     (329,242)   Rp   2,062,509
52   Rp    (28,401,884)   Rp     (355,024)   Rp   2,088,290
53   Rp    (30,490,174)   Rp     (381,127)   Rp   2,114,394
54   Rp    (32,604,567)   Rp     (407,557)   Rp   2,140,824
55   Rp    (34,745,391)   Rp     (434,317)   Rp   2,167,584
56   Rp    (36,912,975)   Rp     (461,412)   Rp   2,194,679
57   Rp    (39,107,653)   Rp     (488,846)   Rp   2,222,112
58   Rp    (41,329,765)   Rp     (516,622)   Rp   2,249,888
59   Rp    (43,579,654)   Rp     (544,746)   Rp   2,278,012
60   Rp    (45,857,666)   Rp     (573,221)   Rp   2,306,487
61   Rp    (48,164,153)   Rp     (602,052)   Rp   2,335,318
62   Rp    (50,499,471)   Rp     (631,243)   Rp   2,364,510
63   Rp    (52,863,981)   Rp     (660,800)   Rp   2,394,066
64   Rp    (55,258,047)   Rp     (690,726)   Rp   2,423,992
65   Rp    (57,682,039)   Rp     (721,025)   Rp   2,454,292
66   Rp    (60,136,331)   Rp     (751,704)   Rp   2,484,971
67   Rp    (62,621,302)   Rp     (782,766)   Rp   2,516,033
68   Rp    (65,137,335)   Rp     (814,217)   Rp   2,547,483
69   Rp    (67,684,818)   Rp     (846,060)   Rp   2,579,327
70   Rp    (70,264,144)   Rp     (878,302)   Rp   2,611,568
71   Rp    (72,875,713)   Rp     (910,946)   Rp   2,644,213
72   Rp    (75,519,925)   Rp     (943,999)   Rp   2,677,265
73   Rp    (78,197,191)   Rp     (977,465)   Rp   2,710,731
74   Rp    (80,907,922)   Rp   (1,011,349)   Rp   2,744,615
75   Rp    (83,652,538)   Rp   (1,045,657)   Rp   2,778,923
76   Rp    (86,431,461)   Rp   (1,080,393)   Rp   2,813,660
77   Rp    (89,245,121)   Rp   (1,115,564)   Rp   2,848,830
78   Rp    (92,093,951)   Rp   (1,151,174)   Rp   2,884,441
79   Rp    (94,978,392)   Rp   (1,187,230)   Rp   2,920,496
80   Rp    (97,898,888)   Rp   (1,223,736)   Rp   2,957,003
81   Rp   (100,855,891)   Rp   (1,260,699)   Rp   2,993,965
82   Rp   (103,849,856)   Rp   (1,298,123)   Rp   3,031,390
83   Rp   (106,881,245)   Rp   (1,336,016)   Rp   3,069,282
84   Rp   (109,950,527)   Rp   (1,374,382)   Rp   3,107,648
85   Rp   (113,058,175)   Rp   (1,413,227)   Rp   3,146,494
 86   Rp   (116,204,669)   Rp   (1,452,558)   Rp   3,185,825
 87   Rp   (119,390,494)   Rp   (1,492,381)   Rp   3,225,648
 88   Rp   (122,616,141)   Rp   (1,532,702)   Rp   3,265,968
 89   Rp   (125,882,110)   Rp   (1,573,526)   Rp   3,306,793
 90   Rp   (129,188,902)   Rp   (1,614,861)   Rp   3,348,128
 91   Rp   (132,537,030)   Rp   (1,656,713)   Rp   3,389,979
 92   Rp   (135,927,009)   Rp   (1,699,088)   Rp   3,432,354
 93   Rp   (139,359,363)   Rp   (1,741,992)   Rp   3,475,258
 94   Rp   (142,834,622)   Rp   (1,785,433)   Rp   3,518,699
 95   Rp   (146,353,321)   Rp   (1,829,417)   Rp   3,562,683
 96   Rp   (149,916,004)   Rp   (1,873,950)   Rp   3,607,216
 97   Rp   (153,523,220)   Rp   (1,919,040)   Rp   3,652,307
 98   Rp   (157,175,527)   Rp   (1,964,694)   Rp   3,697,961
 99   Rp   (160,873,488)   Rp   (2,010,919)   Rp   3,744,185
100   Rp   (164,617,673)   Rp   (2,057,721)   Rp   3,790,987
101   Rp   (168,408,660)   Rp   (2,105,108)   Rp   3,838,375
102   Rp   (172,247,035)   Rp   (2,153,088)   Rp   3,886,354
103   Rp   (176,133,389)   Rp   (2,201,667)   Rp   3,934,934
104   Rp   (180,068,323)   Rp   (2,250,854)   Rp   3,984,120
105   Rp   (184,052,443)   Rp   (2,300,656)   Rp   4,033,922
106   Rp   (188,086,365)   Rp   (2,351,080)   Rp   4,084,346
107   Rp   (192,170,711)   Rp   (2,402,134)   Rp   4,135,400
108   Rp   (196,306,112)   Rp   (2,453,826)   Rp   4,187,093
109   Rp   (200,493,204)   Rp   (2,506,165)   Rp   4,239,431
110   Rp   (204,732,636)   Rp   (2,559,158)   Rp   4,292,424
111   Rp   (209,025,060)   Rp   (2,612,813)   Rp   4,346,080
112   Rp   (213,371,140)   Rp   (2,667,139)   Rp   4,400,406
113   Rp   (217,771,546)   Rp   (2,722,144)   Rp   4,455,411
114   Rp   (222,226,956)   Rp   (2,777,837)   Rp   4,511,103
115   Rp   (226,738,060)   Rp   (2,834,226)   Rp   4,567,492
116   Rp   (231,305,552)   Rp   (2,891,319)   Rp   4,624,586
117   Rp   (235,930,138)   Rp   (2,949,127)   Rp   4,682,393
118   Rp   (240,612,531)   Rp   (3,007,657)   Rp   4,740,923
119   Rp   (245,353,454)   Rp   (3,066,918)   Rp   4,800,185
120   Rp   (250,153,638)   Rp   (3,126,920)   Rp   4,860,187
     sisa
Rp    48,891,734
Rp    47,769,614
Rp    46,633,468
Rp    45,483,119
Rp    44,318,392
Rp    43,139,106
Rp    41,945,078
Rp    40,736,125
Rp    39,512,060
Rp    38,272,694
Rp    37,017,837
Rp    35,747,293
Rp    34,460,868
Rp    33,158,362
Rp    31,839,575
Rp    30,504,304
Rp    29,152,341
Rp    27,783,479
Rp    26,397,506
Rp    24,994,208
Rp    23,573,370
Rp    22,134,770
Rp    20,678,189
Rp    19,203,399
Rp    17,710,176
Rp    16,198,286
Rp    14,667,498
Rp    13,117,576
Rp    11,548,279
Rp     9,959,366
Rp     8,350,592
Rp     6,721,708
Rp     5,072,463
Rp     3,402,602
Rp     1,711,868
Rp             (0)
Rp     (1,733,266)
Rp     (3,488,199)
Rp     (5,265,068)
Rp     (7,064,147)
Rp     (8,885,716)
Rp    (10,730,053)
Rp    (12,597,446)
Rp    (14,488,180)
Rp    (16,402,549)
Rp    (18,340,847)
Rp    (20,303,374)
Rp    (22,290,433)
Rp    (24,302,329)
Rp    (26,339,375)
Rp    (28,401,884)
Rp    (30,490,174)
Rp    (32,604,567)
Rp    (34,745,391)
Rp    (36,912,975)
Rp    (39,107,653)
Rp    (41,329,765)
Rp    (43,579,654)
Rp    (45,857,666)
Rp    (48,164,153)
Rp    (50,499,471)
Rp    (52,863,981)
Rp    (55,258,047)
Rp    (57,682,039)
Rp    (60,136,331)
Rp    (62,621,302)
Rp    (65,137,335)
Rp    (67,684,818)
Rp    (70,264,144)
Rp    (72,875,713)
Rp    (75,519,925)
Rp    (78,197,191)
Rp    (80,907,922)
Rp    (83,652,538)
Rp    (86,431,461)
Rp    (89,245,121)
Rp    (92,093,951)
Rp    (94,978,392)
Rp    (97,898,888)
Rp   (100,855,891)
Rp   (103,849,856)
Rp   (106,881,245)
Rp   (109,950,527)
Rp   (113,058,175)
Rp   (116,204,669)
Rp   (119,390,494)
Rp   (122,616,141)
Rp   (125,882,110)
Rp   (129,188,902)
Rp   (132,537,030)
Rp   (135,927,009)
Rp   (139,359,363)
Rp   (142,834,622)
Rp   (146,353,321)
Rp   (149,916,004)
Rp   (153,523,220)
Rp   (157,175,527)
Rp   (160,873,488)
Rp   (164,617,673)
Rp   (168,408,660)
Rp   (172,247,035)
Rp   (176,133,389)
Rp   (180,068,323)
Rp   (184,052,443)
Rp   (188,086,365)
Rp   (192,170,711)
Rp   (196,306,112)
Rp   (200,493,204)
Rp   (204,732,636)
Rp   (209,025,060)
Rp   (213,371,140)
Rp   (217,771,546)
Rp   (222,226,956)
Rp   (226,738,060)
Rp   (231,305,552)
Rp   (235,930,138)
Rp   (240,612,531)
Rp   (245,353,454)
Rp   (250,153,638)
Rp   (255,013,825)

				
DOCUMENT INFO
Shared By:
Categories:
Stats:
views:377
posted:7/6/2011
language:Indonesian
pages:48
Description: Latihan Microsoft Excel, Excel, Latihan, Vlookup, Fungsi Excel