Template Consumable Martabe 2022 - Rev12 (Jan 23)
Template Consumable Martabe 2022 - Rev12 (Jan 23)
Template Consumable Martabe 2022 - Rev12 (Jan 23)
25 25 26 26
1 2 3 4
27 27 28 29 30 31 32 28
5 6 7 8 9 10 11 12
28 27 27
13 14 15 16 17 18 19 20
21 22 23 24
Kebutuhan/ Avg
Sep-23 Oct-23 Nov-23 Dec-23 Remarks
Bulan by site qty/month
2 1.8 OK
100 100.0 OK
4 4.0 OK
10 8.6 OK
28 28.0 OK
2 1.8
2 1.3 OK
20 20.0 OK
20 20.0 OK
7 5.9 OK
6 3.9 Change
4 3.2 OK
3 2.3 OK
1 0.3 OK
2 1.0 OK
4 3.8 OK
4 3.8 OK
1 0.3 OK
1 0.3 OK
1 0.6 OK
1 0.2 OK
1 0.3 OK
1 1.0 OK
1 1.0 OK
1 0.7 OK
1 0.3 OK
2 1.0 OK
1 0.4 OK
3 2.7 OK
2 0.7 Change
8 7.4 OK
2 1.8 OK
5 - Change
4 2.8 OK
1 0.1 OK
5 3.3 Change
5 3.0 Change
5 3.9 OK
1 - Change
4 2.6 Change
2 - Change
2 0.6 Change
1 - Change
1 - Change
2 0.7 Change
2 0.8 Change
6 1.7 Change
2 0.9 OK
3 0.5 Change
3 2.3 OK
2 0.7 Change
2 0.8 Change
3 2.4 OK
2 1.0 OK
3 2.1 OK
3 2.9 OK
2 0.4 Change
2 0.3 Change
2 0.3 Change
2 0.2 Change
2 0.3 Change
2 0.6 Change
2 1.2 OK
1 0.3 OK
1 0.7 OK
11 10.9 OK
50 36.3 Change
1 0.4 OK
1 0.2 OK
2 0.3 Change
40 14.8 Change
3 2.2 OK
2 1.3 OK
12 5.6 Change
2 0.7 Change
1 0.4 OK
40 - Change
546 526.0 OK
73 70.4 OK
40 24.4 Change
10 1.6 Change
1 0.3 OK
1 - Change
1 0.1 OK
1 0.4 OK
50 17.5 Change
50 9.6 Change
50 19.3 Change
5 2.2 Change
1 0.1 OK
1 0.1 OK
20 16.3 Change
30 25.5 Change
4 2.5 Change
2 1.5 OK
3 1.4 Change
5 2.7 Change
6 3.7 Change
8 5.0 Change
5 2.1 Change
2 0.5 Change
4 3.5 OK
1 0.7 OK
3 0.9 Change
3 0.8 Change
2 0.3 Change
4 3.8 OK
3 0.3 Change
5 0.9 Change
2 0.9 OK
1 0.3 OK
2 0.6 Change
2 0.7 Change
2 0.7 Change
2 0.3 Change
30 27.1 OK
2 - Change
2 0.2 Change
2 0.3 Change
2 0.4 Change
2 0.1 Change
2 0.2 Change
2 0.7 Change
2 0.7 Change
2 0.7 Change
3 0.7 Change
2 0.7 Change
5 1.3 Change
1 0.5 OK
1 3.0 OK
1 0.2 OK
Status Review Harga Mei'20 Review Harga Sept'21
High Focus
High Focus
LEMBAR PERHITUNGAN
CONSUMABLE OFFICE PERHITUNGAN STOCK AKTUAL
No Jenis Barang Brand Kemasan Satuan Kebutuhan / Bulan Jan-22 Feb-22 Mar-22 Apr-22 May-22 Jun-22 Jul-22 Aug-22 Sep-22 Oct-22 Nov-22 Dec-22 Jan-23 Feb-23 Mar-23 Apr-23 May-23 Jun-23 Jul-23 Aug-23 Sep-23 Oct-23 Nov-23 Dec-23
Dihitung oleh :
1
1
1
LEMBAR PERHITUNGAN
CONSUMABLE STATIONARY PERHITUNGAN STOCK AKTUAL
Kebutuhan /
No Jenis Barang Brand Kemasan Satuan Bulan Jan-22 Feb-22 Mar-22 Apr-22 May-22 Jun-22 Jul-22 Aug-22 Sep-22 Oct-22 Nov-22 Dec-22 Jan-23 Feb-23 Mar-23 Apr-23 May-23 Jun-23 Jul-23 Aug-23 Sep-23 Oct-23 Nov-23 Dec-23
Dihitung oleh :
LEMBAR PERHITUNGAN
CONSUMABLE PLANT PERHITUNGAN STOCK AKTUAL
Kebutuhan /
No Jenis Barang Brand Kemasan Satuan Bulan Jan-22 Feb-22 Mar-22 Apr-22 May-22 Jun-22 Jul-22 Aug-22 Sep-22 Oct-22 Nov-22 Dec-22 Jan-23 Feb-23 Mar-23 Apr-23 May-23 Jun-23 Jul-23 Aug-23 Sep-23 Oct-23 Nov-23 Dec-23
12 Cangkul Buaya EA EA 1 1 1 1 1 1 0 0 0 1 0 3 0 2 0 1
Dihitung oleh :
LEMBAR PERHITUNGAN
CONSUMABLE PPE PERHITUNGAN STOCK AKTUAL
Kebutuhan /
No Jenis Barang Brand Kemasan Satuan Bulan Jan-22 Feb-22 Mar-22 Apr-22 May-22 Jun-22 Jul-22 Aug-22 Sep-22 Oct-22 Nov-22 Dec-22 Jan-23 Feb-23 Mar-23 Apr-23 May-23 Jun-23 Jul-23 Aug-23 Sep-23 Oct-23 Nov-23 Dec-23
5 Sarung Tangan Kain Bintik Kuning Matahari 1 box = 12 pcs EA 546 0 0 0 0 0 0 0 0 240 0 0 0 0 0 273
7 Earplug Permanen 3M EA EA 40 40 0 30 20 10 5 25 32 8 5 7 5 0 35 40
22
23
Dihitung oleh :
LEMBAR PERHITUNGAN
CONSUMABLE MESS PERHITUNGAN STOCK AKTUAL
Kebutuhan /
No Jenis Barang Brand Kemasan Satuan Bulan Jan-22 Feb-22 Mar-22 Apr-22 May-22 Jun-22 Jul-22 Aug-22 Sep-22 Oct-22 Nov-22 Dec-22 Jan-23 Feb-23 Mar-23 Apr-23 May-23 Jun-23 Jul-23 Aug-23 Sep-23 Oct-23 Nov-23 Dec-23
Dihitung oleh :
LEMBAR PERHITUNGAN
CONSUMABLE MAINTENANCE PERHITUNGAN STOCK AKTUAL
Kebutuhan /
No Jenis Barang Brand Kemasan Satuan Bulan Jan-22 Feb-22 Mar-22 Apr-22 May-22 Jun-22 Jul-22 Aug-22 Sep-22 Oct-22 Nov-22 Dec-22 Jan-23 Feb-23 Mar-23 Apr-23 May-23 Jun-23 Jul-23 Aug-23 Sep-23 Oct-23 Nov-23 Dec-23
1 Cable Ties CS 400 (warna Hitam) Sigma Ties 1 pack = 100 pcs Pack 3 3 2 1 2 3 2 0 3 3 3 2 1 2 2 3
2 Cable Ties CS 250 (warna Hitam) Sigma Ties 1 pack = 100 pcs Pack 3 2 1 2 2 3 2 2 3 3 2 2 2 1 1 3
Dihitung oleh :
LEMBAR ORDER
Consumable Office Mar-23 15
GL# 600300
No Jenis Barang Brand Kemasan Harga Satuan Jumlah yg harus dibeli Total Pembelian 27
45
Prepared by:
1 Air Minum Botol AQUA 1 dus = 24 x 600 ml 58,000 0 -
25 Tinta Printer epson (Isi ulang) 003 black & colour EA 99,750 0 -
No Jenis Barang Brand Kemasan Harga Satuan Jumlah yg harus dibeli Total Pembelian 27
45
Prepared by:
1 Cat Kuning - Medium Yellow 465 Avian 1 ltr 88,500 0 -
No Jenis Barang Brand Kemasan Harga Satuan Jumlah yg harus dibeli Total Pembelian 27
45
Prepared by:
1 Kacamata Safety KY2222 - Hitam/Gelap Kings 1 box = 12 pcs 59,755 0 -
Rininta Rizki
5 Sarung Tangan Kain Bintik Kuning Matahari 1 box = 12 pcs 5,035 273 1,374,555
Approved by :
6 Sarung Tangan Karet # 8 - Warna Hijau Solvex pasang 52,000 43 2,236,000
Mulyadi
10 Apron Chemical dada No Brand EA 115,000 0 -
22
23
No Jenis Barang Brand Kemasan Harga Satuan Jumlah yg harus dibeli Total Pembelian 27
45
Prepared by:
1 Mie Instan Goreng (M) Indomie 20 pcs 3,500 17 59,500
Rininta Rizki
4 Saus Sambal (M) ABC 275 ml 16,000 2 32,000
Approved by :
5 Kopi Bubuk Refill (M) Kopi Kapal Api 165 gr 20,000 1 20,000
6 Susu kental manis (M) Frisian Flag 560 gram 28,000 1 28,000
Mulyadi
9 Pasta Gigi (M) Pepsodent 190 gr 8,550 2 17,100
No Jenis Barang Brand Kemasan Harga Satuan Jumlah yg harus dibeli Total Pembelian 27
45
Prepared by:
1 Cable Ties CS 400 (warna Hitam) Sigma Ties 1 pack = 100 pcs 142,000 0 -
2 Cable Ties CS 250 (warna Hitam) Sigma Ties 1 pack = 100 pcs 131,000 0 -
Rininta Rizki
5 Chain lube Rexco 25 120 ml 55,000 1 55,000
Approved by :
6 Seal Tape Onda EA 7,315 0 -
Mulyadi
10 Kuas Cat 2" MDN EA 18,700 1 18,700
Martabe
2,500,000
2,000,000
1,500,000
1,000,000 55%
52%
47% 48% 49%
43%
500,000
0
Series1
Martabe
35,000,000
30,000,000 27,712,055
25,913,420 25,966,695 26,839,790
25,000,000 24,339,620 23,686,220
20,000,000
15,000,000
10,000,000
5,000,000
0
Jan-22 Feb-22 Mar-22 Apr-22 May-22 Jun-22
Martabe
120%
100%
100%
80%
60%
59% 57%
52% 50%
49% 48% 40%
20%
0%
0%
Martabe
35
29,402,595 29,816,700
30
26,839,790 25,901,495 26,551,305
686,220 24,018,420 25
20
15
10
5
-
-
-22 Jun-22 Jul-22 Aug-22 Sep-22 Oct-22 Nov-22 Dec-22
120%
100%
100%
80%
60%
40%
20%
0%
20%
0%
35
30
305
25
20
15
10
5
-
-
Dec-22
Jun-23 Jul-23 Aug-23 Sep-23 Oct-23 Nov-23 Dec-23
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
Price Tracking
12
10
-
Jan-22 Feb-22 Mar-22 Apr-22 May-22 Jun-22 Jul-22 Aug-22 Sep-22 Oct-22 Nov-22 Dec-22 Jan-23 Feb-23 Ma
1 2 3 4 5
10
8
Qty Order Overview
12
10
-
Jan-22 Feb-22 Mar-22 Apr-22 May-22 Jun-22 Jul-22 Aug-22 Sep-22 Oct-22 Nov-22 Dec-22 Jan-23 Feb-23 Mar-2
Price Tracking
Nov-22 Dec-22 Jan-23 Feb-23 Mar-23 Apr-23 May-23 Jun-23 Jul-23 Aug-23 Sep-23 Oct-23 Nov-23 Dec-23
6 7 8 9 10 11 12 13 14 15
Qty Order Overview
Jun-22 Jul-22 Aug-22 Sep-22 Oct-22 Nov-22 Dec-22 Jan-23 Feb-23 Mar-23
#N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A
#N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A
#N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A
#N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A
#N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A
#N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A
#N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A
#N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A
#N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A
10
8
Qty Order Overview
12
10
-
ov-22 Dec-22 Jan-23 Feb-23 Mar-23 Apr-23 May-23 Jun-23 Jul-23 Aug-23 Sep-23 Oct-23 Nov-23 Dec-23
16 17 18 19 20 21 22 23 24