11.O112 NOVEMBER (PLAN DESEMBER).xlsx

	A	B	C	E	F	G	H
1				SIMULASI O112 BULAN BERJALAN
2				SIMULASI O112 BULAN BERJALAN
3				Optimalisasi Asset O112		BEFORE	AFTER
4	No	DESKRIPSI	DEC	No	DESKRIPSI	DEC	DEC

5	1	Total Tag O112 (Qty)	2,437	1	Saldo Awal O112 (Saldo Akhir O112 (2024)	3.957.365.115	3.957.365.115
6	2	Total Tag O112 Cut Off Des 2024 (Qty)	767	2	Penambahan Stock Gudang O112 (PM bulan Berjalan)	1.025.195.616	401.041.232
7	3	Total O112 (<= H+3 bulan Mutasi) (Qty)	1,671	3	Addition	4.982.560.731	4.358.406.347
8	4	Total O112 (> 3 bulan mutasi) (Qty)	767	4	Alokasi Stock O112	1.829.516.880	994.444.026
9	5	Total O112 Tagging 2022 keatas (Qty) (Tahun Berjalan)	63	5	Peminjaman/Buffer		37.491.834
10	6	% O112 Tagging 2022 keatas (Tahun berjalan) ( Target 5%)	2,58%	6	P4AT	1.557.332.108	1.559.182.108
11	7	Total O112 Tagging 2022 keatas (Qty) (Cut Off 2024)	34	7	Deduction	3.386.848.988	2.591.117.968
12		% O112 Tagging 2022 keatas (Cut Off) ( Target 5%)	4,43%	8	Saldo Akhir O112	1.595.711.743	1.767.288.379
13				9	On hand O112	3.153.043.851	3.363.962.321
14					>= 50% Optimalisasi Asset O112	67,97%	59,45%
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100