Laporan Stock Opname Barang

Download as xlsx, pdf, or txt
Download as xlsx, pdf, or txt
You are on page 1of 12

No Kode Barang Nama Barang Satuan Harga Pokok Harga Jual

1 A-001 LCD Infinix x690 Note 7 Pcs 190,000 215,000


2 A-002 LCD Xiaomi Redmi 4 x Pcs 105,000 130,000
3 A-003 LCD Xiaomi Redmi 4A Pcs 105,000 130,000
4 A-004 LCD Realme 3 PRO Pcs 250,000 275,000
5 A-005 LCD Oppo Reno 4 F Pcs 320,000 470,000
6 A-006 LCD Infinix X650 HOT 8 Black pcs 150,000 175,000
7 A-007 LCD Infinix X680 Hot 9 Play Pcs 160,000 185,000
8 A-008 Touch Screen OPPO A1K Pcs 20,000 45,000
9 A-009 Back Cover Infinix Note 7 Pcs 30,000 50,000
10 A-010 Headset Macaron U-28/38 Pcs 6,000 10,000
11 A-011 Case OPPO A33-2020 Pcs 6,000 15,000
12 A-012 Case VIVO Y02 Pcs 6,000 15,000
13 A-013 Case VIVO Y16 Pcs 6,000 15,000
14 A-014 Case VIVO Y12 Pcs 6,000 15,000
15 A-015 Case VIVO Y91/Y95/Y93 Pcs 6,000 15,000
16 A-016 Case VIVO Y20 Pcs 6,000 15,000
17 A-017 Case OPPO A-16 E/K Pcs 6,000 15,000
18 A-018 Case OPPO A-17 2022 Pcs 6,000 15,000
19 A-019 Case OPPO A-57 2020 Pcs 6,000 15,000
20 A-020 Case OPPO F5 Pcs 6,000 15,000
21 A-021 Case Redmi 10 C Pcs 6,000 15,000
22 A-022 Case Infinix Smart 6 Pcs 6,000 15,000
23 A-023 Case Infinix Note 7 Pcs 6,000 15,000
24 A-024 Case infinix Hot 8 Pcs 6,000 15,000
25 A-025 Case Transparan OLD Pcs 6,000 12,000
26 A-026 Travel Carger G5-01 Samsung Pcs 16,000 25,000
27 A-027 Travel Carger G5-01 Infinix Pcs 16,000 25,000
28 A-028 Travel Carger G5-01 Realme Pcs 16,000 25,000
29 A-029 Travel Carger G5-01 Oppo Pcs 16,000 25,000
30 A-030 TG Full Pcs 4,000 12,000
31 A-031 TG Bening Pcs 4,000 12,000
32 A-032 Connector China Univ Pcs 1,000 10,000
33 A-033 Battry Xiaomi BN30 ( Redmi 4 A ) Pcs 54,000 80,000
34 A-034 Battry Xiaomi BM47 Pcs 60,000 85,000
35 A-035 Battry Samsung A51 Pcs 55,000 75,000
36 A-036 LEM OCA 7" Pcs 10,000 20,000
37 A-037 Cable Antena Pcs 7,500 15,000
38 A-038 Tombol Luar ( On/OFF ) Pcs 5,000 10,000
39 A-039 Buzzer OPPO A16-2021 Pcs 10,000 35,000
40 A-040 Sim Tray Xiaomi Redmi 3 Pcs 10,000 25,000
41 A-041 Flexible On Off Redmi Note 5 Pro Pcs 7,000 15,000
42 A-042 Cable Data Tipe C Pcs 5,000 10,000
43 A-043 Perdana Indosat OK Pcs 7,950 15,000
44 A-044 Perdana AXIS 5 K Pcs 7,100 15,000
45 A-045 Perdana XL OK Pcs 7,150 15,000
46 A-046 Perdana SMART Data 3Gb Pcs 10,700 15,000
47 A-047 Perdana Simpati OK Pcs 6,100 15,000
48 A-048 Perdana Tri Data 1Gb Nasional Pcs 13,900 20,000
TOTAL
LAPORAN STOCK OPNAME BARANG MOSCA GADGET
Periode 1-31 Maret 2023
Stok Awal Penjualan Barang Masuk Persediaan Akhir (Nilai pada Buku)
Jumlah Nilai Jumlah Nilai Jumlah Nilai Jumlah
1 190,000 1 215,000 1 190,000 1
1 105,000 0 0 1 105,000 1
1 105,000 0 0 1 105,000 0
1 250,000 1 275,000 1 250,000 0
1 320,000 1 470,000 1 320,000 0
1 150,000 1 175,000 1 150,000 0
1 160,000 1 185,000 1 160,000 0
1 20,000 1 45,000 1 20,000 0
1 30,000 1 50,000 1 30,000 1
5 30,000 0 0 5 30,000 10
1 6,000 1 15,000 1 6,000 1
1 6,000 1 15,000 1 6,000 1
1 6,000 0 0 1 6,000 1
1 6,000 0 0 1 6,000 1
1 6,000 0 0 1 6,000 1
1 6,000 0 0 1 6,000 1
2 12,000 1 15,000 2 12,000 1
1 6,000 0 0 1 6,000 1
1 6,000 0 0 1 6,000 1
1 6,000 1 15,000 1 6,000 0
2 12,000 1 15,000 2 12,000 1
1 6,000 1 15,000 1 6,000 0
1 6,000 1 15,000 1 6,000 0
1 6,000 1 15,000 1 6,000 0
16 96,000 0 0 21 126,000 21
1 16,000 1 25,000 1 16,000 0
1 16,000 17 425,000 1 16,000 0
1 16,000 6 150,000 1 16,000 1
1 16,000 1 25,000 1 16,000 0
15 60,000 4 48,000 15 60,000 8
1 4,000 1 12,000 1 4,000 0
10 10,000 0 0 10 10,000 10
2 108,000 1 80,000 2 108,000 1
2 120,000 2 170,000 2 120,000 0
1 55,000 1 75,000 1 55,000 0
2 20,000 1 20,000 2 20,000 1
5 37,500 0 0 5 37,500 5
1 5,000 1 10,000 1 5,000 0
1 10,000 1 35,000 1 10,000 0
1 10,000 1 25,000 1 10,000 0
1 7,000 1 15,000 1 7,000 0
5 25,000 1 10,000 5 25,000 4
5 39,750 4 60,000 5 39,750 1
5 35,500 1 15,000 5 35,500 4
5 35,750 0 0 5 35,750 5
5 53,500 1 15,000 5 53,500 5
5 30,500 0 0 5 30,500 5
4 55,600 1 20,000 4 55,600 3
126 2,338,100 62 2,770,000 131 2,368,100 97
sediaan Akhir (Nilai pada Buku) Persediaan di Gudang (Nilai Fisik) Selisih Kurang/Lebih
Keterangan
Nilai Jumlah Nilai Jumlah Nilai
190,000 1 190,000 0 0 Sold
105,000 1 105,000 0 0 For Sale
0 0 0 0 Sold
0 0 0 0 0 Sold
0 0 0 0 0 Sold
0 0 0 0 0 Sold
0 0 0 0 0 Sold
0 0 0 0 0 Sold
30,000 1 30,000 0 0 Sold
60,000 5 30,000 0 0 Available
6,000 1 6,000 0 0 Sold
6,000 1 6,000 0 0 Available
6,000 1 6,000 0 0 Available
6,000 1 6,000 0 0 Available
6,000 1 6,000 0 0 Available
6,000 1 6,000 0 0 Available
6,000 1 6,000 0 0 Available
6,000 1 6,000 0 0 Available
6,000 1 6,000 0 0 Available
0 0 0 0 0 Sold
6,000 1 6,000 0 0 Available
0 0 0 0 0 Sold
0 0 0 0 0 Sold
0 0 0 0 0 Sold
126,000 21 126,000 0 0 Available
0 0 0 0 0 Sold
0 0 0 0 0 Sold
16,000 1 16,000 0 0 Available
0 0 0 0 0 Sold
32,000 8 32,000 0 0 Available
0 0 0 0 0 Sold
10,000 10 10,000 0 0 Sold
54,000 1 54,000 0 0 Available
0 0 0 0 0 Sold
0 0 0 0 0 Sold
10,000 1 10,000 0 0 Available
37,500 5 37,500 0 0 Available
0 0 0 0 0 Sold
0 0 0 0 0 Sold
0 1 10,000 0 0 Available
0 1 7,000 0 0 Available
20,000 4 20,000 0 0 Available
7,950 1 7,950 0 0 Available
28,400 4 28,400 0 0 Available
35,750 5 35,750 0 0 Available
53,500 4 42,800 0 0 Available
30,500 5 30,500 0 0 Available
41,700 3 41,700 0 0 Available
948,300 93 924,600 0 0
No Kode Barang Nama Barang Satuan Harga Pokok Harga Jual
1 A-001 LCD Infinix x690 Note 7 Pcs 190,000 215,000
2 A-002 LCD Xiaomi Redmi 4 x Pcs 105,000 130,000
3 A-003 LCD Xiaomi Redmi 4A Pcs 105,000 130,000
4 A-004 LCD Realme 3 PRO Pcs 250,000 275,000
5 A-005 LCD Oppo Reno 4 F Pcs 320,000 470,000
6 A-006 LCD Infinix X650 HOT 8 Black pcs 150,000 175,000
7 A-007 LCD Infinix X680 Hot 9 Play Pcs 160,000 185,000
8 A-049 LCD Infinix X6511 Smart 6 Pcs 141,000 165,000
9 A-050 LCD OPPO A53 Pcs 171,000 195,000
10 A-051 LCD Vivo Y20 Pcs 122,000 150,000
11 A-008 Touch Screen OPPO A1K Pcs 20,000 45,000
12 A-009 Back Cover Infinix Note 7 Pcs 30,000 50,000
13 A-052 Back Cover Vivo Y20 Grey Pcs 25,000 50,000
14 A-010 Headset Macaron U-28/38 Pcs 6,000 10,000
15 A-011 Case OPPO A33-2020 Pcs 6,000 15,000
16 A-012 Case VIVO Y02 Pcs 6,000 15,000
17 A-013 Case VIVO Y16 Pcs 6,000 15,000
18 A-014 Case VIVO Y12 Pcs 6,000 15,000
19 A-015 Case VIVO Y91/Y95/Y93 Pcs 6,000 15,000
20 A-016 Case VIVO Y20 Pcs 6,000 15,000
21 A-017 Case OPPO A-16 E/K Pcs 6,000 15,000
22 A-018 Case OPPO A-17 2022 Pcs 6,000 15,000
23 A-019 Case OPPO A-57 2020 Pcs 6,000 15,000
24 A-020 Case OPPO F5 Pcs 6,000 15,000
25 A-021 Case Redmi 10 C Pcs 6,000 15,000
26 A-022 Case Infinix Smart 6 Pcs 6,000 15,000
27 A-023 Case Infinix Note 7 Pcs 6,000 15,000
28 A-024 Case infinix Hot 8 Pcs 6,000 15,000
29 A-025 Case Transparan OLD Pcs 6,000 12,000
30 A-026 Travel Carger G5-01 Samsung Pcs 16,000 25,000
31 A-027 Travel Carger G5-01 Infinix Pcs 16,000 25,000
32 A-028 Travel Carger G5-01 Realme Pcs 16,000 25,000
33 A-029 Travel Carger G5-01 Oppo Pcs 16,000 25,000
34 A-030 TG Full Pcs 4,000 12,000
35 A-031 TG Bening Pcs 4,000 12,000
36 A-032 Connector China Univ Pcs 1,000 10,000
37 A-033 Battry Xiaomi BN30 ( Redmi 4 A ) Pcs 54,000 80,000
38 A-034 Battry Xiaomi BM47 Pcs 60,000 85,000
39 A-035 Battry Samsung A51 Pcs 55,000 75,000
40 A-036 LEM OCA 7" Pcs 10,000 20,000
41 A-037 Cable Antena Pcs 7,500 15,000
42 A-038 Tombol Luar ( On/OFF ) Pcs 5,000 10,000
43 A-039 Buzzer OPPO A16-2021 Pcs 10,000 35,000
44 A-040 Sim Tray Xiaomi Redmi 3 Pcs 10,000 25,000
45 A-041 Flexible On Off Redmi Note 5 Pro Pcs 7,000 15,000
46 A-042 Cable Data Tipe C Pcs 5,000 10,000
47 A-043 Perdana Indosat OK Pcs 7,950 15,000
48 A-044 Perdana AXIS 5 K Pcs 7,100 15,000
49 A-045 Perdana XL OK Pcs 7,150 15,000
50 A-046 Perdana SMART Data 3Gb Pcs 10,700 15,000
51 A-047 Perdana Simpati OK Pcs 6,100 15,000
52 A-048 Perdana Tri Data 1Gb Nasional Pcs 13,900 20,000
TOTAL
LAPORAN STOCK OPNAME BARANG MOSCA GADGET
Periode 1-30 April 2023
Stok Awal Penjualan Barang Masuk Persediaan Akhir (Nilai pada Buku)
Jumlah Nilai Jumlah Nilai Jumlah Nilai Jumlah
1 190,000 1 215,000 1 190,000 1
1 105,000 0 0 1 105,000 1
1 105,000 0 0 1 105,000 0
1 250,000 1 275,000 1 250,000 0
1 320,000 1 470,000 1 320,000 0
1 150,000 1 175,000 1 150,000 0
1 160,000 1 185,000 1 160,000 0
1 141,000 1 165,000 1 141,000 0
1 171,000 1 195,000 1 171,000 0
1 122,000 1 150,000 1 122,000 0
1 20,000 1 45,000 1 20,000 0
1 30,000 1 50,000 1 30,000 0
1 25,000 1 50,000 1 25,000 0
5 30,000 0 0 5 30,000 10
1 6,000 1 15,000 1 6,000 1
1 6,000 1 15,000 1 6,000 1
1 6,000 0 0 1 6,000 1
1 6,000 0 0 1 6,000 1
1 6,000 0 0 1 6,000 1
1 6,000 0 0 1 6,000 1
2 12,000 1 15,000 2 12,000 1
1 6,000 0 0 1 6,000 1
1 6,000 0 0 1 6,000 1
1 6,000 1 15,000 1 6,000 0
2 12,000 1 15,000 2 12,000 1
1 6,000 1 15,000 1 6,000 0
1 6,000 1 15,000 1 6,000 0
1 6,000 1 15,000 1 6,000 0
16 96,000 0 0 21 126,000 21
1 16,000 1 25,000 1 16,000 0
1 16,000 17 425,000 1 16,000 0
1 16,000 6 150,000 1 16,000 1
1 16,000 1 25,000 1 16,000 0
15 60,000 4 48,000 15 60,000 8
1 4,000 1 12,000 1 4,000 0
10 10,000 0 0 10 10,000 10
2 108,000 1 80,000 2 108,000 1
2 120,000 2 170,000 2 120,000 0
1 55,000 1 75,000 1 55,000 0
2 20,000 1 20,000 2 20,000 1
5 37,500 0 0 5 37,500 5
1 5,000 1 10,000 1 5,000 0
1 10,000 1 35,000 1 10,000 0
1 10,000 1 25,000 1 10,000 0
1 7,000 1 15,000 1 7,000 0
5 25,000 1 10,000 5 25,000 4
5 39,750 4 60,000 5 39,750 1
5 35,500 1 15,000 5 35,500 4
5 35,750 0 0 5 35,750 5
5 53,500 1 15,000 5 53,500 5
5 30,500 0 0 5 30,500 5
4 55,600 1 20,000 4 55,600 3
130 2,797,100 66 3,330,000 135 2,827,100 96
sediaan Akhir (Nilai pada Buku) Persediaan di Gudang (Nilai Fisik) Selisih Kurang/Lebih
Keterangan
Nilai Jumlah Nilai Jumlah Nilai
190,000 1 190,000 0 0 Sold
105,000 1 105,000 0 0 For Sale
0 0 0 0 Sold
0 0 0 0 0 Sold
0 0 0 0 0 Sold
0 0 0 0 0 Sold
0 0 0 0 0 Sold
0 0 0 0 0 Sold
0 0 0 0 0 Sold
0 0 0 0 0 Sold
0 0 0 0 0 Sold
0 0 0 0 0 Sold
0 0 0 0 0 Sold
60,000 5 30,000 0 0 Available
6,000 1 6,000 0 0 Sold
6,000 1 6,000 0 0 Available
6,000 1 6,000 0 0 Available
6,000 1 6,000 0 0 Available
6,000 1 6,000 0 0 Available
6,000 1 6,000 0 0 Available
6,000 1 6,000 0 0 Available
6,000 1 6,000 0 0 Available
6,000 1 6,000 0 0 Available
0 0 0 0 0 Sold
6,000 1 6,000 0 0 Available
0 0 0 0 0 Sold
0 0 0 0 0 Sold
0 0 0 0 0 Sold
126,000 21 126,000 0 0 Available
0 0 0 0 0 Sold
0 0 0 0 0 Sold
16,000 1 16,000 0 0 Available
0 0 0 0 0 Sold
32,000 8 32,000 0 0 Available
0 0 0 0 0 Sold
10,000 10 10,000 0 0 Sold
54,000 1 54,000 0 0 Available
0 0 0 0 0 Sold
0 0 0 0 0 Sold
10,000 1 10,000 0 0 Available
37,500 5 37,500 0 0 Available
0 0 0 0 0 Sold
0 0 0 0 0 Sold
0 1 10,000 0 0 Available
0 1 7,000 0 0 Available
20,000 4 20,000 0 0 Available
7,950 1 7,950 0 0 Available
28,400 4 28,400 0 0 Available
35,750 5 35,750 0 0 Available
53,500 4 42,800 0 0 Available
30,500 5 30,500 0 0 Available
41,700 3 41,700 0 0 Available
918,300 92 894,600 0 0

You might also like