Surat Jalan, Database Gaji dan Daftar Stock Barang

Dear,

Ini adalah salah satu tugas kampusku, tapi sangat bermanfaat buat kalian yang punya tugas jadi Administrasi ataupun yang berkaitan dengan file-file. Di attached ada lampiran contoh surat jalan,

SURAT JALAN
PT. ELEKTRONIK BERJAYA
Kepada : CV. DUA ELEKTRONIK No : 001/15/10/07
JL. Raya Barat No.7 Tanggal : 2/11/2007
Surabaya
No Nama Barang Unit Kg Keterangan
1 TV 2 3
2 Radio 1 1
3 Kulkas 4 20
4 Komputer 1 5
5 Dispenser 1 1
6 Mixer 1 1
7 Blender 5 1
8 AC 2 3
9 Kipas Angin 4 1
10 Setrika 4 0.5
Jakarta, 2 November 2007
Divisi Gudang Yang Menerima Yang Menyerahkan
( ) (                         ) (                               )

contoh draft database gaji,

RINCIAN GAJI OKTOBER 2007
No. Karyawan GP Insentive Komisi Transport Lembur Pot Jamsostek Pot Hutang Total
1 Robilal 975,000 50,000 10,000 200,000 30,000 19,500 0 1,265,000
2 Achmad Yazid 950,000 25,000 20,000 200,000 24,000 19,000 500,000 719,000
3 Elriad K 1,000,000 25,000 10,000 200,000 36,000 20,000 350,000 921,000
4 Ferry 1,200,000 50,000 10,000 200,000 24,000 24,000 0 1,484,000
5 Bejo 975,000 50,000 10,000 200,000 18,000 19,500 0 1,253,000
6 Hasanudin 975,000 50,000 20,000 200,000 30,000 19,500 0 1,275,000
7 Asep Sudrajat 1,000,000 25,000 10,000 200,000 30,000 20,000 0 1,265,000
8 Meidy 975,000 25,000 20,000 200,000 18,000 19,500 0 1,238,000
9 Sijan 1,200,000 50,000 10,000 200,000 24,000 24,000 500,000 984,000
10 Adi ‘ Trianto 1,200,000 25,000 10,000 200,000 24,000 24,000 200,000 1,259,000
11 Adi ‘Pos 1,000,000 50,000 10,000 200,000 30,000 20,000 150,000 1,140,000
12 Agus ‘ Supriyadi 950,000 50,000 20,000 200,000 18,000 19,000 500,000 738,000
13 Benny 975,000 50,000 10,000 200,000 36,000 19,500 0 1,271,000
14 Budi ‘ Hartono 1,200,000 25,000 20,000 200,000 30,000 24,000 0 1,475,000
15 Dwi 1,000,000 25,000 20,000 200,000 24,000 20,000 0 1,269,000
Total 15,575,000 575,000 210,000 3,000,000 396,000 311,500 2,200,000 17,556,000

dan juga contoh draft database daftar stok barang.

DAFTAR STOCK BARANG PER 31 OKTOBER 2007
PT. ELEKTRONIK BERJAYA
No Nama Barang Unit Harga Beli Rupiah
Stock Awal Masuk Keluar Stock Akhir Stock Awal Masuk Keluar Stock Akhir
1 TV 0 5 2 3 450,000 - 2,250,000 900,000 1,350,000
2 Radio 1 3 1 2 200,000 200,000 600,000 200,000 400,000
3 Kulkas 0 8 4 4 1,000,000 - 8,000,000 4,000,000 4,000,000
4 Komputer 2 5 1 4 1,500,000 3,000,000 7,500,000 1,500,000 6,000,000
5 Dispenser 0 4 1 3 650,000 - 2,600,000 650,000 1,950,000
6 Mixer 5 2 0 2 450,000 2,250,000 900,000 - 900,000
7 Blender 1 9 5 4 200,000 200,000 1,800,000 1,000,000 800,000
8 AC 0 7 2 5 1,200,000 - 8,400,000 2,400,000 6,000,000
9 Kipas Angin 3 10 4 6 35,000 105,000 350,000 140,000 210,000
10 Setrika 0 6 4 2 30,000 - 180,000 120,000 60,000
Total 12 59 24 35 5715000 5,755,000 32,580,000 10,910,000 21,670,000

Semoga Bermanfaat ! Untuk dapat file aslinya beserta rumus-rumusnya silakan download file nya klik File – PPN

About these ads

Tinggalkan Balasan

Isikan data di bawah atau klik salah satu ikon untuk log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Logout / Ubah )

Twitter picture

You are commenting using your Twitter account. Logout / Ubah )

Facebook photo

You are commenting using your Facebook account. Logout / Ubah )

Google+ photo

You are commenting using your Google+ account. Logout / Ubah )

Connecting to %s