jagomart
digital resources
picture1_Excel Sheet Download 30993 | 20170820043502 Stock Opname 2015


 213x       Filetype XLSX       File size 0.08 MB       Source: www.bandungkab.go.id


Excel Sheet Download 30993 | 20170820043502 Stock Opname 2015

icon picture XLSX Filetype Excel XLSX | Posted on 08 Aug 2022 | 3 years ago
Partial file snippet.
Sheet 1: STOCK OPNAME 2015 
STOCK OPNAME PERSEDIAAN BARANG PAKAI HABIS TAHUN ANGGARAN 2015
PER 31 DESEMBER 2015






No Nama Barang Jumlah Satuan Harga Saruan ( Rp ) Jumlah Harga ( Rp )
1 2 3 4 5

PERSEDIAAN BAHAN PAKAI HABIS




PERSEDIAAN ALAT TULIS KANTOR



1 Amplop 1 dus 14,700 14,700
2 Bak Stempel - Bh 24,800 -
3 Balpoint - lsn 28,000 -
4 Binder Clip Besar - dus 23,200 -
5 Binder Clip Kecik - dus 15,000 -
6 Binder Clip Sedang - dus 17,000 -
7 Box File Plastik - bh 10,000 -
8 Boliner Hitam - bh 19,000 -
9 Buku Bergaris 1/2 folio - bh 6,800 -
10 Buku Expedisi - bh 16,500 -
11 Buku tulis isi 200 lb - bh 31,000 -
12 Buku tulis isi 300 lb - bh 44,500 -
13 Buku folio 300 lb - bh 62,000 -
14 Cuter Besar 2 bh 15,000 30,000
15 Cuter Kecil - bh 7,500 -
16 Compac disk kosong 5 bh 8,500 42,500
17 Dokumen file - bh 15,000 -
18 HVS F4 70 gr 2 rim 40,000 80,000
19 HVS A4 70 gr 1 rim 35,000 35,000
20 HVS df 70 gr - rim 65,000 -
21 Isi cuter besar - dus 27,000 -
22 Isi cuter kecil - dus 23,000 -
23 Karbon Df 1 dus 90,500 90,500
24 Karbon Ef - dus 55,500 -
25 Penghapus Staedler - dus 69,500 -
26 Kertas Faximile 2 Rol 35,500 71,000
27 Kertas Folio bergaris - rim 33,300 -
28 Kwitansi Besar - rak 15,000 -
29 Lem Tackol sedang - bh 5,300 -
30 Map plastik jepit - bh 13,000 -
31 Map plastik snailhecter - bh 14,000 -
32 Ordner kecil - bh 14,500 -
33 Ordner besar - bh 16,500 -
34 Paper Klip - pak 34,000 -
35 Penggaris 30 cm 2 bh 7,000 14,000
36 Penggaris 60 cm besi - bh 25,000 -
37 Pensil 2 B - lsn 40,500 -
38 Verporator - bh 27,000 -
39 Pita mesin tik 2 bh 16,500 33,000
40 Spidol Kecil - bh 28,000 -
41 Spidol Snowman White board Hitam - bh 7,000 -
42 Spidol Snowman Marker besar - Bh 13,500 -
43 Stabilo - bh 10,000 -
44 Staples - lsn 34,500 -
45 Staples no 10 1 pak 13,000 13,000
46 Stop Map biasa 27 bh 1,350 36,450
47 Stop map plastik - bh 8,500 -
48 Stop Map Snalhecter - pak 30,000 -
49 Tinta printer - bh 27,500 -
50 Tinta stempel - pak 42,000 -
51 Hekter Besar 1 bh 27,000 27,000












1 2 3
4 5
52 Hekter kecil - bh 25,000 -
53 Tip Ex - dus 115,000 -
54 Flashdisk - bh 100,000 -
55 Boliner Biru - bh 19,000 -
Jumlah 487,150

PERSEDIAAN BARANG CETAKAN




BELANJA CETAK



1 Formulir H/O 1 rim 200,000 200,000
2 Formulir IMB 1 rim 200,000 200,000
3 Kop Surat 1 rim 150,000 150,000
4 Amplop Surat 1 dus 100,000 100,000
5 Formulir Hak Waris 1 rim 200,000 200,000
6 Kartu Disposisi 1 blok 15,500 15,500
7 Map Kecamatan - bh 15,000 -
8 Kartu Kendali Surat Masuk 1 blok 16,000 16,000
9 Kartu Kendali Surat Keluar - blok 16,000 -
Jumlah 881,500









Soreang, 31 Desember 2015

Pengurus/Penyimpan Barang
Mengetahui



CAMAT RANCABALI











DENI SUKENDRA



NIP. 19710306 200801 1 004 Drs. PURNAMA DRASTIS



Pembina



NIP. 19590917 199601 1 001




































Sheet 2: DAFTAR PERSEDIAAN BARANG 2016

PEMERINTAH KABUPATEN BANDUNG















KECAMATAN RANCABALI















Jl. Raya Patengan No. 83 Rancabali















DAFTAR PERSEDIAAN BARANG

SEMESTER I DAN II TAHUN ANGGARAN 2016

Januari s/d Desember 2016














Kode Nama Barang Satuan Saldo Awal Penerimaan Pengeluaran Saldo Akhir Ket

Brg
Brg Vol Hrg Satuan Jml Hrg Vol Hrg Satuan Jml Hrg Vol Hrg Satuan Jml Hrg Vol Hrg Satuan Jml Hrg


PERSEDIAAN BAHAN PAKAI HABIS















PERSEDIAAN ALAT TULIS KANTOR















Amplop Besar dus 10 15,000 150,000 10 15,000 150,000 8 15,000 120,000 2 15,000 30,000


Binder Clip Besar Bh 4 15,200 60,800 - - - - - - - - -


Balpoint lsn 5 28,000 140,000 - - - - - - - - -


Binder Clip Besar dus 4 23,500 94,000 - - - - - - - - -


Binder Clip Sedang dus 4 6,400 25,600 4 6,400 25,600 3 6,400 19,200 1 6,400 6,400


Binder Clip Kecil dus 4 3,200 12,800 - - - - - - - - -


Box Clip Plastik bh 8 10,000 80,000 - - - - - - - - -


Bolinder hitam bh 10 14,000 140,000











Buku Bergaris 1/2 Folio bh 4 7,000 28,000 - - - - - - - - -


Buku Expedisi bh 4 17,000 68,000 - - - - - - - - -


Buku tulis isi 200 lb bh 10 32,000 320,000 - - - - - - - - -


Kwitansi Besar bh 5 15,000 75,000











Lem Tackol sedang bh 5 5,300 26,500 5 5,300 26,500 2 5,300 10,600 3 5,300 15,900


Map plastik jepit bh 20 14,000 280,000 - - - - - - - - -


Odner Kecil bh 20 14,500 290,000











Odner Besar bh 40 16,500 660,000 - - - - - - - - -


Paper Klip Pack 5 34,000 170,000 - - - - - - - - -


Penggaris 30 cm bh 12 7,000 84,000 - - - - - - - - -


Pencil 2 B bh 1 4,500 4,500 - - - - - - - - -


Veparator bh 4 27,000 108,000 4 27,000 108,000 3 27,000 81,000 1 27,000 27,000


Pita mesin tik bh 5 16,000 80,000 - - - - - - - - -


Sepidol Kecil bh 10 28,000 280,000 - - - - - - - - -


Spidol Snowman White board Hitam bh 7 7,000 49,000 - - - - - - - - -


Spidol Snowman Marker besar bh 4 13,500 54,000











Stabilo bh 10 10,000 100,000 - - - - - - - - -


Staples bh 10 34,500 345,000 - - - - - - - - -


Staples no 10 bh 10 13,000 130,000 10 13,000 130,000 9 13,000 117,000 1 13,000 13,000


Stop Map biasa bh 300 1,350 405,000 300 1,350 405,000 174 1,350 234,900 126 1,350 170,100


Stop map plastik bh 80 8,500 680,000 - - - - - - - - -

Stop Map Snalhecter bh 10 30,000 300,000 - - - - - - - - -


Tinta printer botol 35 27,500 962,500 - - - - - - - - -

Tinta stempel dus 1 40,000 40,000 - - - - - - - - -


Hekter Besar bh 11 27,000 297,000 - - - - - - - - -


Tip Ex bh 5 76,020 380,100 - - - - - - - - -


Kertas HVS F4 Rim 117 35,000 4,095,000 117 35,000 4,095,000 112 35,000 3,920,000 5 35,000 175,000


Kertas HVS A4 Rim 20 33,000 660,000 - - - - - - - - -


Tinta Printer Warna bh 30 27,500 825,000 30 27,500 825,000 27 27,500 742,500 3 27,500 82,500


Pembulatan - 1 200 200 - - - - - - - - -

Jumlah Persediaan Alat tulis Kantor


12,500,000







440,600.00


PERSEDIAAN BARANG CETAKAN















Belanja Cetak















Formulir H/O rim 3 200,000 600,000 - - - - - - - - -


Formulir IMB rim 2 200,000 400,000 - - - - - - - - -


Kop Surat rim 10 150,000 1,500,000 - - - - - - - - -


Amplop Surat dus 7 100,000 700,000 - - - - - - - - -


Formulir Hak Waris rim 2 200,000 400,000 - - - - - - - - -


Penggandaan Paket 1 1,400,000 1,400,000 - - - - - - - - -

Jumlah Persediaan Barang Cetakan


5,000,000











PERSEDIAAN ALAT LISTRIK DAN ELEKTRONIK















Alat Listrik















Kabel Roll Bh 10 75,000 750,000 10 75,000 750,000 10 75,000 750,000 - - -


Neon panjang 20 watt + dudukan Bh 26 75,000 1,950,000 26 75,000 1,950,000 26 75,000 1,950,000 - - -


Bohlam kapsul Bh 35 40,000 1,400,000 35 40,000 1,400,000 35 40,000 1,400,000 - - -


Bohlam 40 Wat Bh 20 45,000 900,000 20 45,000 900,000 20 45,000 900,000 - - -


Stop Kontak Bh 20 30,000 600,000 20 30,000 600,000 20 30,000 600,000 - - -


Saklar Engkle Bh 20 20,000 400,000 20 20,000 400,000 20 20,000 400,000 - - -


MCB Bh 6 40,000 240,000 6 40,000 240,000 6 40,000 240,000 - - -


Saklar seri Bh 15 30,000 450,000 15 30,000 450,000 15 30,000 450,000 - - -


Senter Bh 6 50,000 300,000 6 50,000 300,000 6 50,000 300,000 - - -


Batu Batre Bh 29 2,000 58,000 29 2,000 58,000 29 2,000 58,000 - - -


Kabel / Roll (1 Roll = 50 m) Roll 2 226,000 452,000 2 226,000 452,000 2 226,000 452,000 - - -

Jumlah Persediaan Alat Listrik dan Elektronik


7,500,000

7,500,000

7,500,000





PERSEDIAAN PERALATAN KEBERSIHAN DAN BAHAN PEMBERSIH















Peralatan Kebersihan















Sapu Lidi bh 5 15,800 79,000 5 15,800 79,000 5 15,800 79,000 - - -


Sapu Lantai bh 8 25,000 200,000 8 25,000 200,000 8 25,000 200,000 - - -


Keset bh 4 50,000 200,000 4 50,000 200,000 4 50,000 200,000 - - -


Alat Pel bh 6 90,000 540,000 6 90,000 540,000 6 90,000 540,000 - - -


Kamoceng bh 29 10,000 290,000 29 10,000 290,000 29 10,000 290,000 - - -


Cangkul bh 4 50,000 200,000 4 50,000 200,000 4 50,000 200,000 - - -


Gunting Rumput bh 10 38,500 385,000 10 38,500 385,000 10 38,500 385,000 - - -


Ember bh 3 50,000 150,000 3 50,000 150,000 3 50,000 150,000 - - -


Gayung bh 10 12,100 121,000 10 12,100 121,000 10 12,100 121,000 - - -


Toilet Brush bh 4 45,000 180,000 4 45,000 180,000 4 45,000 180,000 - - -


Sikat Gagang bh 6 75,000 450,000 6 75,000 450,000 6 75,000 450,000 - - -


Pembulatan - 1 5,000 5,000 1 5,000 5,000 1 5,000 5,000 - - -

Jumlah Persediaan Barang Peralatan Kebersihan

2,800,000

2,800,000

2,800,000




PERSEDIAAN BELANJA JASA KANTOR















Belanja Jasa Pihak ketiga















Belanja Jasa Pihak Ketiga















Service Komputer Bh 6 200,000 1,200,000 6 200,000 1,200,000 6 200,000 1,200,000 - - -


Servise printer Bh 4 50,000 200,000 4 50,000 200,000 4 50,000 200,000 - - -


Servise Mesin Tik - 3 200,000 600,000 3 200,000 600,000 3 200,000 600,000 - - -

Jumlah Persediaan Belanja Jasa Kantor


2,000,000

2,000,000

2,000,000





PERSEDIAAN BELANJA JASA KANTOR















Belanja Air















Belanja Air Galon Gln 144 15,000 2,160,000 144 15,000 2,160,000 144 15,000 2,160,000 - - -


Belanja Kawat/Faksimile/Internet Bln 12 460,000 5,520,000 12 460,000 5,520,000 12 460,000 5,520,000 - - -


Belanja Jasa Listrik Bln 12 1,513,546 18,162,552 12 1,513,546 18,162,552 12 1,513,546 18,162,552 - - -

Jumlah Persediaan Belanja Bahan/Materi


25,842,552

25,842,552

25,842,552





PERSEDIAAN BELANJA ALAT KANTOR















Belanja Perlengkapan Kantor















Mesin Foto Copy Unit 1 32,500,000 32,500,000 1 32,500,000 32,500,000 1 32,500,000 32,500,000 - - -


PC Unit/Komputer PC Unit 4 6,000,000 24,000,000 4 6,000,000 24,000,000 4 6,000,000 24,000,000 - - -


Hardisk Ekternal Bh 5 1,200,000 6,000,000 5 1,200,000 6,000,000 5 1,200,000 6,000,000 - - -

Jumlah Persediaan Belanja Perlengkapan Kantor


69,500,000

62,500,000

62,500,000





PERSEDIAAN PERALATAN RUMAH TANGGA















Belanja Alat Alat Rumah Tangga















Gelas Lsn 2 50,000 100,000 2 50,000 100,000 2 50,000 100,000 - - -


Piring Keramik bh 5 50,000 250,000 5 50,000 250,000 5 50,000 250,000 - - -


Mangkuk Keramik bh 10 15,000 150,000 10 15,000 150,000 10 15,000 150,000 - - -


Dispenser bh 2 245,000 490,000 2 245,000 490,000 2 245,000 490,000 - - -


Sendok Lsn 5 30,000 150,000 5 30,000 150,000 5 30,000 150,000 - - -


Garpu Lsn 4 30,000 120,000 4 30,000 120,000 4 30,000 120,000 - - -


Cangkir Lsn 4 60,000 240,000 4 60,000 240,000 4 60,000 240,000 - - -


Magic Com Bh 2 250,000 500,000 2 250,000 500,000 2 250,000 500,000 - - -

Jumlah Persediaan Belanja Perlengkapan Rumah Tangga


2,000,000

2,000,000

2,000,000





PERSEDIAAN JASA KANTOR














Belanja Surat kabar/Majalah















Surat Kabar/Majalah Bln 12 167,000 2,004,000 12 167,000 2,004,000 12 167,000 2,004,000 - - -


Belanja Buku perundang-undangan\












Buku Peraturan Perundang-undangan Paket 1 2,996,000 2,996,000 1 2,996,000 2,996,000 1 2,996,000 2,996,000 - - -

Jumlah Persediaan Belanja Surat kabar dan buku perundang-undangan


5,000,000

5,000,000

5,000,000





BELANJA BARANG DAN JASA















Belanja Mebeulair















Lemari Arsip Siku Bh 2 3,500,000 7,000,000 2 3,500,000 7,000,000 2 3,500,000 7,000,000 - - -




Jumlah Persediaan Mebeulair


7,000,000

7,000,000

7,000,000





BELANJA BARANG DAN JASA















Belanja Peralatan/Suku Cadang Kendaraan Bermotor















Kendaraan Roda 4 Unit 2 8,980,000 17,960,000 2 8,980,000 17,960,000 2 8,980,000 17,960,000 - - -


Belanja Jasa Service Kendaraan Dinas















Kendaraan Roda 4 Unit 2 1,000,000 2,000,000 2 1,000,000 2,000,000 2 1,000,000 2,000,000 - - -


Belanja Surat Tanda Nomor Kendaraan















STNK Unit 2 2,500,000 5,000,000 2 2,500,000 5,000,000 2 2,500,000 5,000,000 - - -

Jumlah Persediaan Belanja Eksploitasi, suku cadang dan Stnk


24,960,000

24,960,000

24,960,000





BELANJA BARANG DAN JASA















Belanja Pakaian Dinas















Belanja Pakaian Dinas Harian (PDH) Stel 20 375,000 7,500,000 20 375,000 7,500,000 20 375,000 7,500,000 - - -

Jumlah Persediaan Belanja Pakaian Dinas


7,500,000

7,500,000

7,500,000





BELANJA BARANG DAN JASA















Belanja Pakaian Khusus hari-hari Tertentu















Pakaian KORPRI serta perlengkapannya stel 20 300,000 6,000,000 20 300,000 6,000,000 20 300,000 6,000,000 - - -

Jumlah Persediaan Belanja Pakaian Dinas


6,000,000

6,000,000

6,000,000

































Rancabali, 31 Desember 2016

Penyimpan Barang,









Mengetahui,













An. CAMAT RANCABALI













Sekretaris Camat



































DENI SUKENDRA














NIP. 19710306 200801 1 004









H. TATANG KUSNADIE, S.Pd, M.Si













NIP. 19611023 198203 1 005

Sheet 3: STOCK OPNAME 2016
DAFTAR PERSEDIAAN BARANG
SEMESTER I TAHUN ANGGARAN 2016












No Nama Barang Jumlah Satuan Harga Saruan ( Rp ) Jumlah Harga ( Rp )
1 2 3 4 5
A PERSEDIAAN BAHAN PAKAI HABIS




PERSEDIAAN ALAT TULIS KANTOR



1 Amplop Besar 2 dus 14,700 29,400
2 Amplop Kecil 2 Dus 7,500 15,000
3 Balpoint - lsn 28,000 -
4 Binder Clip Besar - dus 23,200 -
5 Binder Clip Kecil 1 dus 4,500 4,500
6 Binder Clip Sedang - dus 17,000 -
7 Box File Plastik - bh 10,000 -
8 Boliner Hitam - bh 19,000 -
9 Buku Bergaris 1/2 folio - bh 6,800 -
10 Buku Expedisi - bh 16,500 -
11 Buku tulis isi 200 lb - bh 31,000 -
12 Buku tulis isi 300 lb - bh 44,500 -
13 Buku folio 300 lb - bh 62,000 -
14 Cuter Besar - bh 15,000 -
15 Cuter Kecil 1 bh 7,500 7,500
16 Compac disk kosong - bh 8,500 -
17 Dokumen file - bh 15,000 -
18 HVS F4 70 gr 5 rim 40,000 200,000
19 HVS A4 70 gr - rim 35,000 -
20 HVS df 70 gr - rim 65,000 -
21 Isi cuter besar - dus 27,000 -
22 Isi cuter kecil - dus 23,000 -
23 Karbon Df - dus 90,500 -
24 Karbon Ef - dus 55,500 -
25 Penghapus Staedler - dus 69,500 -
26 Kertas Faximile - Rol 35,500 -
27 Kertas Folio bergaris - rim 33,300 -
28 Kwitansi Besar - rak 15,000 -
29 Lem Inakol 3 bh 5,300 15,900
30 Map plastik jepit - bh 13,000 -
31 Map plastik snailhecter - bh 14,000 -
32 Ordner kecil - bh 14,500 -
33 Ordner besar - bh 16,500 -
34 Paper Klip - pak 34,000 -
35 Penggaris 30 cm - bh 7,000 -
36 Penggaris 60 cm besi - bh 25,000 -
37 Pensil 2 B - lsn 40,500 -
38 Verporator - bh 27,000 -
39 Pita mesin tik - bh 16,500 -
40 Spidol Kecil - bh 28,000 -
41 Spidol Snowman White board Hitam - bh 7,000 -
42 Spidol Snowman Marker besar - Bh 13,500 -
43 Stabilo - bh 10,000 -
44 Staples - lsn 34,500 -
45 Staples no 10 3 pak 250 750
46 Stop Map biasa 126 bh 1,350 170,100
47 Stop map plastik - bh 8,500 -
48 Stop Map Snalhecter 2 pak 30,000 60,000
49 Tinta printer Warna 1 bh 27,500 27,500
50 Super Glue 1 bh 2,000 2,000
51 Hekter Besar - bh 27,000 -












1 2 3
4 5
52 Hekter kecil 1 bh 25,000 25,000
53 Tip Ex - dus 115,000 -
54 Flashdisk - bh 100,000 -
55 Boliner Biru - bh 19,000 -
Jumlah 557,650
B PERSEDIAAN BARANG CETAKAN




BELANJA CETAK



1 Formulir HO - rim 200,000 -
2 Formulir IMB - rim 200,000 -
3 Kop Surat - rim 150,000 -
4 Amplop Surat - dus 100,000 -
5 Formulir Hak Waris - rim 200,000 -
6 Kartu Disposisi - blok 15,500 -
7 Map Kecamatan - bh 15,000 -
8 Kartu Kendali Surat Masuk - blok 16,000 -
9 Kartu Kendali Surat Keluar - blok 4,000 -
Jumlah -

Jumlah A + B ---------------------------------------- 557,650









Soreang, Desember 2016

Pengurus/Penyimpan Barang
Mengetahui



CAMAT RANCABALI











DENI SUKENDRA



NIP. 19710306 200801 1 004 Drs. PURNAMA DRASTIS



Pembina



NIP. 19590917 199601 1 001




































The words contained in this file might help you see if this file matches what you are looking for:

...Sheet stock opname persediaan barang pakai habis tahun anggaran per desember no nama jumlah satuan harga saruan rp bahan alat tulis kantor amplop dus bak stempel bh balpoint lsn binder clip besar kecik sedang box file plastik boliner hitam buku bergaris folio expedisi isi lb cuter kecil compac disk kosong dokumen hvs f gr rim a df karbon ef penghapus staedler kertas faximile rol kwitansi rak lem tackol map jepit snailhecter ordner paper klip pak penggaris cm besi pensil b verporator pita mesin tik spidol snowman white board marker stabilo staples stop biasa snalhecter tinta printer hekter tip ex flashdisk biru cetakan belanja cetak formulir ho imb kop surat hak waris kartu disposisi blok kecamatan kendali masuk keluar soreang penguruspenyimpan mengetahui camat rancabali deni sukendra nip drs purnama drastis pembina daftar pemerintah kabupaten bandung jl raya patengan semester i dan ii januari sd kode saldo awal penerimaan pengeluaran akhir ket brg vol hrg jml bolinder odner pack pencil...

no reviews yet
Please Login to review.