Chemicals Forecasting: Sr. # Chemical Unit Consumption Forecast Jan-Jun 2022 Jul-Dec 2022 Jan-Jun 2023 Jul-Dec 2023

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

Chemicals

Consumption Forecast
Sr. # Chemical Unit
Jan-Jun Jul-Dec Jan-Jun Jul-Dec
2022 2022 2023 2023
1 Potassium Carbonate - 10100032798 Ton 35 41 53 74
2 ACT-1 - 10100059238 Drum 28 34 46 58
3 Vanadium Pentoxide - 10100032797 kg 1400 1700 2000 2600
4 Potassium Nitrite - 10100032799 kg 1500 1200 900 600
5 Antifoam - 10100032792 Drum 0 0 0 1
6 Activated Carbon - 10100012455 kg 1450 0 1450 0
7 Detergent - 10100032790 kg 50 50 50 50
8 RD-11 - 10100053914 kg 0 25 0 25

Jan-Jun
Sr. # Chemical Unit 2022

Quantity Basis
1 Potassium Carbonate - 10100032798 Ton 35 1. Average potassium carryover of
~200ppm, considering chemical
2 ACT-1 - 10100059238 Drum 28 recovery.
2. Additional consumption for 01
3 Vanadium Pentoxide - 10100032797 kg 1400 Shutdown as follows,
Potassium Carbonate = 5Ton
4 Potassium Nitrite - 10100032799 kg 1500 ACT-1 = 4Drum
Vanadium Pentoxide = 200kg
5 Antifoam - 10100032792 Drum 0
6 Activated Carbon - 10100012455 kg 1450
7 Detergent - 10100032790 kg 50
8 RD-11 - 10100053914 kg 0
Chemicals Forecasting
Consumption Forecast Quantity Total
in Hand Quantity Quantity
Next Next Next Next SAP Safe on Order [In Hand +
Total On Order]
06 Month 12 Month 18 Month 24 Month Data Custody
35 76 129 203 180 0 180 0 180
28 62 108 166 59 18 77 50 127
1400 3100 5100 7700 0 1100 1100 3000 4100
1500 2700 3600 4200 0 1000 1000 1600 2600
0 0 0 1 0 0 0 1 1
1450 1450 2900 2900 4350 0 4350 0 4350
50 100 150 200 290 0 290 500 790
0 25 25 50 125 0 125 0 125

Jul-Dec Jan-Jun Jul-Dec


2022 2023 2023

Quantity Basis Quantity Basis Quantity


41 1. Average potassium carryover of 53 1. Average potassium carryover of 74
~450ppm, considering chemical ~700ppm, considering chemical
34 recovery. 46 recovery. 58
2. Additional consumption for 01 2. Additional consumption for 01
1700 Shutdown as follows, 2000 Shutdown as follows, 2600
Potassium Carbonate = 5Ton Potassium Carbonate = 5Ton
1200 ACT-1 = 4Drum 900 ACT-1 = 4Drum 600
Vanadium Pentoxide = 200kg Vanadium Pentoxide = 200kg
0 0 1
0 1450 0
50 50 50
25 0 25
Stock Available Till
[Including on Order]

Sep-23
Jul-23
Mar-23
Nov-22
Sufficent for 02 year
Sufficent for 02 year
Sufficent for 02 year
Sufficent for 02 year

Jul-Dec
2023

Basis
1. Average potassium carryover of
~1000ppm, considering chemical
recovery.
2. Additional consumption for
Turnaround as follows,
Potassium Carbonate = 20Ton
ACT-1 = 10Drum
Vanadium Pentoxide = 500kg
Lube Oils
Consumption Forecast
Sr. # Lube Oil Unit
Jan-Jun Jul-Dec Jan-Jun Jul-Dec
2022 2022 2023 2023
1 Caltex-46 - 10100032821 Drum 23 23 28 28
2 Shell T-46 - 10100032823 Drum 15 15 17 17
3 Morlina S1 B150 - 10100032824 [ MK-211] Drum 3 5 3 5
4 Morlina S2 B 220 - 10100056772 Drum 1 3 1 3
5 Synfilm GT-68 - 10100053941 Gallon 10 5 10 10
6 Shell T-68 - 10100032822 Drum 6 2 6 6
7 Shell S2 ATF D2 - 10100053931 Drum 1 0 1 1
8 TELLUS S2 M 68 - 10100032817 Drum 2 1 2 1
9 York Oil C - 10100057725 Gallon 10 30 10 30

Jan-Jun
Sr. # Lube Oil Unit 2022

Quantity Basis

1. Consumption at TK-431.
2. Normal oil consumption or 4th
1 Caltex-46 - 10100032821 Drum 23
stage seal oil recovery.
3. Additional 05 drums for 01 SD.

1. Consumption at TK-421/441 &


other small machines.
2 Shell T-46 - 10100032823 Drum 15
2. Normal oil consumption.
3. Additional 03 drums for 01 SD.

1. Consumption at K-211
3 Morlina S1 B150 - 10100032824 Drum 3 2. Normal consumption with 01
charge for LOS.

1. Consumption at K-212
4 Morlina S2 B 220 - 10100056772 Drum 1
2. Normal consumption
1. Consumption at TK-201 & MK-
212
5 Synfilm GT-68 - 10100053941 Gallon 10
2. Normal consumption + 01
charge for contigency

1. Consumption at TK-201/TP-301B
6 Shell T-68 - 10100032822 Drum 6 2. Normal consumption + 01
charge for contigency

1. Consumption at XP-301 clutch


7 Shell S2 ATF D2 - 10100053931 Drum 1 2. Normal consumption + 01
charge for contigency

1. Consumption at BOMAFA
8 TELLUS S2 M 68 - 10100032817 Drum 2 2. Normal consumption + 01
charge for LOS

9 York Oil C - 10100057725 Gallon 10 10 Gallon for contigency


Lube Oils Forecasting
Consumption Forecast Quantity Total
in Hand Quantity Quantity
Next Next Next Next SAP Safe on Order [In Hand +
Total On Order]
06 Month 12 Month 18 Month 24 Month Data Custody
23 46 74 102 70 0 70 0 70
15 30 47 64 61 0 61 0 61
3 8 11 16 6 0 6 2 8
1 4 5 8 9 0 9 0 9
10 15 25 35 20 0 20 0 20
6 8 14 20 9 0 9 0 9
1 1 2 3 2 0 2 0 2
2 3 5 6 11 0 11 20 31
10 40 50 80 90 0 90 0 90

Jul-Dec Jan-Jun Jul-Dec


2022 2023 2023

Quantity Basis Quantity Basis Quantity

1. Consumption at TK-431. 1. Consumption at TK-431.


2. Normal oil consumption or 4th 2. Normal oil consumption or 4th
23 28 28
stage seal oil recovery. stage seal oil recovery.
3. Additional 05 drums for 01 SD. 3. Additional 10 drums for 01 SD.

1. Consumption at TK-421/441 & 1. Consumption at TK-421/441 &


other small machines. other small machines.
15 17 17
2. Normal oil consumption. 2. Normal oil consumption.
3. Additional 03 drums for 01 SD. 3. Additional 05 drums for 01 SD.

1. Consumption at K-211
1. Consumption at K-211
2. Normal consumption with 01
5 3 2. Normal consumption with 01 5
charge for LOS.
3. 01 charge for contigency charge for LOS.

1. Consumption at K-212
1. Consumption at K-212
3 2. Normal consumption 1 3
2. Normal consumption
3. 01 charge for contigency
1. Consumption at TK-201 & MK- 1. Consumption at TK-201 & MK-
212
5 212 10 10
2. Normal consumption + 01
2. Normal consumption
charge for contigency

1. Consumption at TK-201/TP-301B
1. Consumption at TK-201/TP-301B
2 6 2. Normal consumption + 01 6
2. Normal consumption
charge for contigency

1. Consumption at XP-301 clutch


1. Consumption at XP-301 clutch
0 1 2. Normal consumption + 01 1
2. Normal consumption
charge for contigency

1. Consumption at BOMAFA
1. Consumption at BOMAFA
1 2. Normal consumption 2 2. Normal consumption + 01 1
charge for LOS

1. Seasonal Maintenance
30 frequency of 12 months 10 10 Gallon for contigency 30
2. 10 Gallon for contigency
Stock Available Till
[Including on Order]

Jun-23
Nov-23
Dec-22
Sufficent for 02 year
Mar-23
Feb-23
Jul-23
Sufficent for 02 year
Sufficent for 02 year

Jul-Dec
2023

Basis

1. Consumption at TK-431.
2. Normal oil consumption or 4th
stage seal oil recovery.
3. Additional 10 drums for 01 TA.

1. Consumption at TK-421/441 &


other small machines.
2. Normal oil consumption.
3. Additional 05 drums for 01 TA.

1. Consumption at K-211
2. Normal consumption with 01
charge for LOS.
3. 01 charge for contigency

1. Consumption at K-212
2. Normal consumption
3. 01 charge for contigency
1. Consumption at TK-201 & MK-212
2. Normal consumption + 01 charge
for TA

1. Consumption at TK-201/TP-301B
2. Normal consumption + 01 charge
for TA

1. Consumption at XP-301 clutch


2. Normal consumption + 01 charge
for TA

1. Consumption at BOMAFA
2. Normal consumption

1. Seasonal Maintenance frequency


of 12 months
2. 10 Gallon for contigency

You might also like