Chemical 2018
Chemical 2018
Lebaran 25 - 26 Juni 2017                                                    2-May           15-May     27-May           7-Jun      19-Jun            30-Jun    11-Jul            21-Jul           1-Aug           11-Aug      22-Aug          31-Aug
     Perkiraan Stop Lebaran 23 - 27 Juni 2017                                       121,132        105,600     105,600         106,800    107,800          107,800    111,000            111,000          111,000         111,000     111,000         111,000
     CRITICAL CHEMICALS DELEVERY
                                                                                                                                                                                              Monthly Delivery
                                                                   Stock
No                      Description             Qty Purchase                             Apr-18                      May-18                       Jun-18                      Jul-18                           Aug-18                      Sep-18                     Oct-18
                                                                 Warehouse
                                                                                   Qty             Date       Qty             Date        Qty              Date       Qty               Date             Qty          Date           Qty            Date        Qty          Date
     Milling days                                                                  17                         28                          20                          28                                 27                          27                          5
     TCM                                                                            147,900                   268,800                     196,000                     310,800                            299,700                      299,700                    39,150
     Ave. TCD                                                                          8,700                     9,600                      9,800                      11,100                             11,100                       11,100                      7,830
     rendemen                                                                            7.80                      7.88                       7.97                         8.02                               8.37                         8.59                      7.84
     sugar production                                                                 11543                      21171                      15624                        24931                              25086                        25751                      3068
1 Caustic Soda Liquid 48 %                        325,000 Kg                 0          20000 20 - 25 Mar          30000 1 - 6 May             30000 22 - 27 May           30000 19 - 24 Jun                  30000 10 - 15 Jul           30000 31/7 - 5/8
                                                                                                                   20000 8 - 13 May            20000 5 - 10 Jun            20000  3 - 8 Jul                   20000 24 - 29 Jul           20000 14 - 19 Aug
7 Anti Scalant NTS 232                              7,000 Kg           6,400                                                                    5000 29/5 - 3/6                                                2000 10 - 15 Jul
                                                               pemakaian                 1479                      2,688                        1960                        3108                               2997                        2997
                                                               balance                   4921                       2233                        5273                        2165                               1168                       -1829
8 Phosporic Acid                                  130,000 Kg          1,680.00       50,000 20 - 25 Mar                                    50,000 29/5 - 3/6                                               30,000 10 - 15 Jul
                                                               pemakaian             12,180                     22,136                     16,141                       25,595                             24,681                      24,681
                                                               balance               39,500                     17,364                     51,222                       25,627                             30,946                       6,265
9 Filter Aid Celite 503 RV/Radiolite               45,000 Kg          9,500.00          10000 20 - 25 Mar        20000 8 - 13 May                                        15000         3 - 8 Jul
                                                               pemakaian                5,916                   10,752                      7,840                       12,432                             11,988                      11,988
                                                               balance                  13584                   22,832                     14,992                       17,560                              5,572                       -6416
Monthly Delivery
                            Todate
                    Qty
                         152
                   1,562,050
                        7.95
                      124106
16080
                                                          3041.8
                                                                                                                                                                            Monthly Delivery
                         Estimation                                    Mar-17                     Apr-17                        May-17                             Jun-17                             Jul-17                             Aug-17                        Sep-17                         Oct-17
                                                                Qty              Date     Qty          use/day          Qty          use/day               Qty            use/day              Qty          use/day               Qty          use/day         Qty          use/day            Qty          use/day
TCM                                                                                       147,900                        268,800                            196,000                            310,800                            299,700                       299,700                                 -
rendemen                                                                                        7.80               -          7.88                -                7.97               -              8.02                 -             8.37              -          8.59                               -
sugar production                                                                           11,543                         21,171                                15,624                          24,931                             25,086                        25,751                                 -
Milling days                                                                                      17                            28                                   20                                28                                 27                           27                               0
Pemakaian Kapur (ton)                                                                       256                            465                               339.08                            537.684                           518.481                       518.481                                  0
Qty apabila slaked                                                                        393.64             23.16       715.42             25.55            521.66             26.08           827.21                29.54       797.66            29.54       797.66                29.54          0.00      #DIV/0!
Qty apabila Quick                                                                         301.02             17.71       547.09             19.54            398.92             19.95           632.57                22.59       609.98            22.59       609.98                22.59          0.00      #DIV/0!
Slaked lime
                Stock                         0.00             0.00              0.00     0.00             0.00         0.00             0.00             0.00               0.00          0.00                 0.00             0.00             0.00         0.00              0.00          0.00
           Schedule delivery                  0.00             0.00              0.00     0.00             0.00         0.00             0.00             0.00               0.00          0.00                 0.00             0.00             0.00         0.00              0.00          0.00
              Pemakaian                       0.00             0.00              0.00     0.00             0.00         0.00             0.00             0.00               0.00          0.00                 0.00             0.00             0.00         0.00              0.00          0.00
               Balance                        0.00             0.00              0.00     0.00             0.00         0.00             0.00             0.00               0.00          0.00                 0.00             0.00             0.00         0.00              0.00          0.00
Stock di warehouse di akhir minggu 50.00 120.32 155.22 130.05 153.05 126.05 146.40 118.18 138.53 158.88 99.04 136.56 139.71 142.86 96.02 99.17
Stock di warehouse apabila kedatang          50.00            200.00            270.32   255.22          280.05        253.05          276.05            246.40             268.18        288.53               158.88           199.04           286.56       289.71            242.86        246.02
kapur di awal minggu
Stock di warehouse di akhir minggu 102.33 78.07 81.22 84.38 87.53 40.68 43.84 58.29 -98.99 -158.07
Stock di warehouse apabila kedatang   249.17   202.33   228.07   231.22   234.38   187.53   190.68   193.84      58.29    -98.99       100.00 Slake        Term 2
kapur di awal minggu                                                                                                                   100.00 Est. T.Slake
TTCM
  1,522,900
     124,106 T.PRODUCT
Jika TCD > 8000T maka monitoring stock gudang harus intensif karena kebutuhan kapur bisa di atas 500T/day, sementara kapasitas gudang maksimum 300T
       2,635
     4053.26 TFL
     3099.55 TQL
TCP
      112000
                                       Revised Cane supply for 2018                                                   9          Nov-17
2018 cane supply and sugar projection
Projected Rendement
PSMI                             8.6             8.7              8.8              8.9             9.25              9.5           8.96                9          9          67,950.00
BMM                              6.8             6.9             7.01             7.03             7.37             7.55           7.06            7.15         7.15         12,012.00
Mandiri                         6.93            7.04             7.15             7.17             7.52             7.73           7.22              7.3         7.3         38,471.00
G2                              7.33            7.44             7.62             7.67             8.02             8.18           7.66              7.8         7.8          8,739.90
PTPN Bunga Mayang                                                                                                                                               8.14       127,172.90
Others (H.Tary,Noven,etc
Average                   7.8043               7.876           7.9716           8.0217           8.3704           8.5923          7.836            8.14
Ha cut                  922         1,493        1,055         1,631         1,590         1,626         153          8,470     0          8,470
Est TCH                  83           90           91            91            90            88           87           89.1
TSH
        8.02
        5.72
         6.2
        7.02
-
    105,000
      14,000
    119,000
-
-
-
#DIV/0!
        7.92
-
%
    17.1
    82.9
      0
    100
                                                                                                      Monthly Cane Delivery
           Description                    Apr-16                     May-16                     Jun-16                        Jul-16                        Aug-16                       Sep-16                       Todate
                                   Qty                         Qty                       Qty                          Qty                            Qty                          Qty
Milling days                        14                         27                        20                            27                             26                           26                                140
TCM                                105,700                    238,950                   190,000                      270,000                        260,000                       250,751                   1,315,401
Ave. TCD                             7,550                       8,850                     9,500                       10,000                         10,000                        9,644
rendemen                                 7.05                        7.6                       7.87                         8.27                           8.53                         8.74                        8.13
sugar production                         7452                    18160                     14953                        22329                          22178                        21916                      106988
Caustic Soda Liquid 48 % (Kg)        20000          30000        20000          30000      20000           30000        20000             30000        20000           30000        20000          30000          20000          320000
Delevery Date                   20 - 25 Mar     1 - 6 May   8 - 13 May 22 - 27 May 5 - 10 Jun         19 - 24 Jun   3 - 8 Jul      10 - 15 Jul    24 - 29 Jul     31/7 - 5/8   14 - 19 Aug 21 - 26 Aug      4 - 9 Sept
PROPOSAL CHEMICAL ON SEASON 2017
TCM                :                                        1,300,000
Rendemen           :                                                9
TS                 :                                          117,000
                                                                             STOCK              USAGE/ MT                       CHEMICAL NEED             PROPOSE MPR
   NO      ITEM CODE                     CHEMICALS                                                            CAL. USAGE (KG)
                                                                        WH        PROCESS         SUGAR                             (KG)         QUANTITY (KG)
CLARIFICATION AID
    1       F100.018 Quick Lime 89% CaO                                       0             0       24.878          2,910,726        2,910,726        2,800,000
    2       F100.046 Slake lime min 68% CaO                                   0             0           0.8            93,600           93,600          100,000
    3       F100.017 Phosporic Acid @35Kg/Can                                 0             0       1.0862            127,085          127,085          130,000
                     FILTER AID                                                                     0.4183             48,941           48,941           50,000
    4       F100.018 Radiolite                                                0             0       0.0057             664.77              665                0
    5       F100.014 Filter Aid Celite 503 RV @20Kg/bag                       0             0       0.3760          43,994.13           43,994           45,000
    6       F100.062 Filter Aid Celite Hyflo @22.7Kg/bag                      0             0       0.0366              4,282            4,282            5,000
                     FLOCULANT                                                                       0.073              8,541            8,541            8,500
    7       F100.015 Magnaflock LT 27 AG @25Kg/bag                            0             0       0.0155              1,814            1,814                0
    8       F100.072 Superflock A2120 @25Kg/bag                               0             0       0.0124              1,451            1,451            2,000
    9       F100.044 Kankyo SC 300 @25Kg/bag                                  0             0       0.0451              5,277            5,277            5,000
   10       F100.030 Sulphur Flake ( Belerang ) @25Kg/bag                     0                     0.0902             10,553           10,553           10,000
   11       F100.002 Aldefoam G204/food grade @200Kg/drum                     0             0       0.0039                456              456              400
   12       F100.058 Antifoam non food grade DK HT 10 @30Kg/can               0             0       0.0028                328              328              300
EVAPORATOR CHEMICAL
    1     F100.012 Caustic Soda Liquid 48 %                                   0             0        25000            325,000          325,000          325,000
    2     F100.013 Caustic Soda Flake 98%NaOH @25Kg/bag                       0             0         1000             13,000           13,000           13,000
    3     F100.024 Sulphamid Acid @25Kg/bag                                   0             0         1000             13,000           13,000           13,000
    4     F100.069 Korantin PP @190Kg/drum                                    0             0           80              1,040            1,040              950
    5     F100.007 Soda As Dense @25Kg/bag                                    0             0         2000             26,000           26,000           26,000
    6     F100.003 Alchem CP 215 @180Kg/drum                                  0             0           80              1,040            1,000            1,980
    7     F100.053 Anti Scalant NTS 232 @200Kg/drum                           0             0       0.0676              7,909            8,000            1,000
        Rp4,340,000,000
         Rp175,000,000
        Rp1,625,000,000
                   Rp0
         Rp410,400,000
          Rp45,000,000
                   Rp0
         Rp117,600,000
         Rp222,000,000
          Rp40,000,000
          Rp29,800,000
          Rp14,400,000
        Rp1,332,500,000
          Rp92,300,000
         Rp136,500,000
          Rp85,500,000
         Rp109,200,000
          Rp84,546,000
          Rp27,400,000
                    Rp0
          Rp11,400,000
          Rp25,675,000
                    Rp0
        Rp8,924,221,000
CHEMICAL MAINTENANCE DAY
8th MILLING SEASON
2016
                                                                   DOZING (KG)
NO         CHEMICAL                                                                                                              COST
                            1st    2nd     3rd     4th     5th     6th   7th       8th     9th     10th    11th   TOTAL
     SODA BOILING
 1   SODA LIQUID           20,000 20,000 20,000 20,000 20,000 20,000 20,000 20,000 20,000 20,000 20,000 220,000           Rp   770,000,000.00
 2   SODA FLAKE             2,000 2,000 2,000 2,000 2,000 2,000 2,000 2,000 2,000 2,000 2,000 22,000                      Rp   159,500,000.00
 3   SODA ASH               2,500 2,500 2,500 2,500 2,500 2,500 2,500 2,500 2,500 2,500 2,500 27,500                      Rp   115,500,000.00
 4   ALCHEM                  100   100    100    100    100    100    100    100    100    100    100 1,100               Rp    43,450,000.00
     TOTAL                                                                                                                Rp 1,088,450,000.00
   ACID SPRAYING
 5 SULPHAMIC ACID          1,500   1,500   1,500   1,500   1,500   1,500   1,500   1,500   1,500   1,500   1,500 16,500   Rp   214,500,000.00
 6 ALCHEM                   80      80      80      80      80       80      80      80      80      80      80 880       Rp    34,760,000.00
 7 KORANTINE                60      60      60      60      60       60      60      60      60      60      60 660       Rp    59,400,000.00
   TOTAL                                                                                                                  Rp   308,660,000.00
   GRAND TOTAL                                                                                                            Rp 1,397,110,000.00
                    REMARK
                                                                                  ISSUANCE (KG)
NO                     CHEMICALS
                                             2015        2016       2017   2018       2019
 1    Quick Lime                            2,221,182   2,221,182
 2    Slake lime                              135,650     135,650
 3    Caustic Soda Liquid 48 %                211,850     211,850
 4    Caustic Soda Flake                        9,750       9,750
 5    Sulphamid Acid                           10,975      10,975
 6    Korantin PP @190Kg/drum                     760         760
 7    Acid inhibitor cleaner sistem P4209           0           0
 8    As Dense                                 23,750      23,750
 9    Alchem CP 215                             1,800       1,800
 10   Anti Scalant NTS 232                      6,000       6,000
 11   Phosporic Acid                           96,355      96,355
 12   Radiolite                                                 0
 13   Filter Aid Celite 503 RV                33,860       33,860
 14   Filter Aid Celite Hyflo                    324          324
 15   Decolorising/color precipitants              0            0
 16   Magnaflock LT 27 AG                          0            0
 17   Superflock A2120                         1,375        1,375
 18   SC 300                                   4,000        4,000
 19   Pan Boiling aid Alpers NT49                400          400
 20   Avipol VZ                                    0            0
 21   Sulphur Flake ( Belerang )               8,000        8,000
 22   Aldefoam G204                              350          350
 23   Antifoam non food grade DK HT 10           245          245
 24   Sodium Hydrosulphite (Hydros)              300          300
 25   Isophropyl Alcohol                         800          800
UANCE (KG)
             2020   2021   2022   2023
CALCULATION BUDGETING OF CHEMICAL
PROCESS DIVISION
AVERAGE PER SEASON (ON)
                                                             CHEMICAL ISSUANCE
NO ITEM CODE                     CHEMICALS                                        PRICE/UNIT       TOTAL COST
                                                                   (KG)
 1   F100.018   Quick Lime 89% CaO                                    2,221,182     Rp1,450.00   Rp3,220,713,900.00
 2   F100.046   Slake lime min 68% CaO                                  135,650     Rp1,600.00    Rp217,040,000.00
 3   F100.012   Caustic Soda Liquid 48 %                                211,850     Rp3,500.00    Rp741,475,000.00
 4   F100.013   Caustic Soda Flake 98%NaOH @25Kg/bag                      9,750     Rp7,250.00     Rp70,687,500.00
 5   F100.024   Sulphamid Acid @25Kg/bag                                 10,975    Rp13,000.00    Rp142,675,000.00
 6   F100.069   Korantin PP @190Kg/drum                                     760    Rp90,000.00     Rp68,400,000.00
 7   F100.001   Acid inhibitor cleaner sistem P4209                           0    Rp22,500.00               Rp0.00
 8   F100.007   As Dense @25Kg/bag                                       23,750     Rp4,200.00     Rp99,750,000.00
 9   F100.003   Alchem CP 215 @180Kg/drum                                 1,800    Rp39,500.00     Rp71,100,000.00
10   F100.053   Anti Scalant NTS 232 @200Kg/drum                          6,000    Rp25,200.00    Rp151,200,000.00
11   F100.017   Phosporic Acid @35Kg/Can                                 96,355    Rp12,360.00   Rp1,190,947,800.00
12   F100.018   Radiolite                                                 6,000     Rp9,000.00     Rp54,000,000.00
13   F100.014   Filter Aid Celite 503 RV @20Kg/bag                       27,860     Rp9,120.00    Rp254,083,200.00
14   F100.062   Filter Aid Celite Hyflo @22.7Kg/bag                         324     Rp9,000.00       Rp2,916,900.00
15   F100.059   Decolorising/color precipitants                               0                              Rp0.00
16   F100.015   Magnaflock LT 27 AG @25Kg/bag                                 0    Rp69,000.00               Rp0.00
17   F100.072   Superflock A2120 @25Kg/bag                                1,375    Rp56,400.00     Rp77,550,000.00
18   F100.044   Kankyo SC 300 @25Kg/bag                                   4,000    Rp44,400.00    Rp177,600,000.00
19   F100.050   Pan Boiling aid Alpers NT49 @200Kg/drum                     400    Rp23,900.00       Rp9,560,000.00
20   F100.067   Avipol VZ                                                     0                              Rp0.00
21   F100.030   Sulphur Flake ( Belerang ) @25Kg/bag                      8,000     Rp3,970.00     Rp31,760,000.00
22   F100.002   Aldefoam G204/food grade @200Kg/drum                        350    Rp66,000.00     Rp23,100,000.00
23   F100.058   Antifoam non food grade DK HT 10 @30Kg/can                  245    Rp48,000.00     Rp11,760,000.00
24   F100.023   Sodium Hydrosulphite (Hydros) @50Kg/pail                    300    Rp19,000.00       Rp5,700,000.00
25   F100.070   Isophropyl Alcohol @200Ltr/drum                             800    Rp21,100.00     Rp16,880,000.00
                TOTAL CHEMICAL COST                                                              Rp6,638,899,300.00
                     PT. PEMUKASAKTI MANISINDAH
Catatan : Setiap pengiriman selain menyertai surat jalan, bukti timbang dll, harus disertakan COA/MSDS.
Date             :
                5 Januari 2017
Departemen       :
                Factory
Division         :
                Process
Section         -:                                                                 MPR No.         ____/ MPR-F/____/1_
Requisitioner : Made Widre                                                          PR No.
 1     F100.018 Quick lime 89%                KG       2,800,000            0     2,800,000 Untuk kebutuhan lime season
                                                                                            2017.
                                                                                            Alternatif suplier : 1). Sarwono, 2).
 2     F100.046 Slake Lime Min. 68%           KG        100,000             0       100,000 PT. MSK, dll
Catatan : Setiap pengiriman selain menyertai surat jalan, bukti timbang dll, harus disertakan COA/MSDS.
Date              :
                5 Januari 2017
Departemen        :
                Factory
Division          :
                Process
Section         - :                                                                    MPR No.         ____/ MPR-F/____/1_
Requisitioner : Made Widre                                                              PR No.
Catatan : Setiap pengiriman selain menyertai surat jalan, bukti timbang dll, harus disertakan COA/MSDS.
Date             :
                5 Januari 2017
Departemen       :
                Factory
Division         :
                Process
Section         -:                                                                    MPR No.           ____/ MPR-F/____/1_
Requisitioner : Made Widre                                                             PR No.
 1                   Filter aid -Food grade :      KG         50,000        0         50,000      Untuk filter aid rotary leaf filter
                     1). Celite 503RV,                                                            (filtering carbonated liquor dan
                     2).Celite Hyflo supercell,                                                   sulphited liquor) season 2017.
                     3).Radiolite                                                                 Untuk quantity masing-masing
                                                                                                  (Celite 503RV/Hyflo
                                                                                                  supercell/Radiolite) akan
                                                                                                  ditentukan saat SQ/penawaran
                                                                                                  harga. Alternatif suplier: 1).PT
                                                                                                  Lautan Luas Tbk, 2).PT Jaring Mas
                                                                                                  Sakti. dll
Catatan : Setiap pengiriman selain menyertai surat jalan, bukti timbang dll, harus disertakan COA/MSDS.
Date              :
                5 Januari 2017
Departemen        :
                Factory
Division          :
                Process
Section         - :                                                                    MPR No.        ____/ MPR-F/____/1_
Requisitioner : Made Widre                                                              PR No.
Catatan : Setiap pengiriman selain menyertai surat jalan, bukti timbang dll, harus disertakan COA/MSDS.
Catatan : Setiap pengiriman selain menyertai surat jalan, bukti timbang dll, harus disertakan COA/MSDS.
1 Caustic Soda Liquid 48 %                325,000 Kg                 0      20,000    25 - 30/Apr      20,000 30/5 - 4/6      20,000     21-27/6         20,000 17 - 23/7          20,000       15 - 20/8     20,000     11-17/9         0
                                                                                                       20,000 13 - 18/6       20,000     11 - 16/7       20,000   1 - 6/8          20,000      29/8 - 3/9     20,000      3-8/10         0
8 Phosporic Acid                          130,000 Kg               0.00     30,000        1/April      30,000     2 - 7/6     30,000       4 - 9/7                                                                                       0
                                                       pemakaian             9,035                      23421                  13680                      22532                     22400                       4510                  0.00
                                                       balance               20965                      27544                  43864                      21332                     -1068                      -5578                -5578
9 Filter Aid Celite 503 RV/Radiolite       45,000 Kg               0.00          0                     15,000     2 - 7/6                                  5,000       1 - 9/8                                     0
                                                       pemakaian             3,840                      8,848                  5,472                       9,576                    9,520                      1,804                    0
                                                       balance               -3840                      2,312                 (3,160)                     (7,736)                 (17,256)                    -19060               -19060
976,500
         8.25
-    77427.24
16080
       3041.8
    15452.344
Delivery schedule of Quick lime and Slaked lime
Slaked lime
Stock                                             175.37        175.37       175.37        35.72          0.81        0.81         0.81          0.81
Schedule delivery                                      0             0            0            0             0           0            0             0 Menghabiskan balance last season, digunakan
Pemakaian                                              0             0       139.65        34.91             0           0            0             0 pada awal giling sampai habis
Balance                                           175.37        175.37        35.72         0.81          0.81        0.81         0.81          0.81
Stock di warehouse di akhir minggu                175.37        275.37       135.72       152.92       170.97       166.38      175.22         #REF!
                                                                                                                                                     Setiap hari senin dan hari sabtu dilakukan
                                                                                                                                                     stock take oleh tenaga chemical factory
Stock di warehouse apabila kedatangan             175.37        275.37       275.37       285.72       282.92       290.97      296.38         #REF! warehouse untuk memastikan ketersediaan
kapur di awal minggu                                                                                                                                 stock kapur.
plan                  actual
       800               834.78
16/6/2016    755.76
              44.24
Delivery schedule of Quick lime and Slaked lime
Slaked lime
Stock                                      0.81      0.81      0.81       0.81      0.81      0.81
Schedule delivery                          0.00      0.00      0.00       0.00      0.00      0.00
Pemakaian                                  0.00      0.00      0.00       0.00      0.00      0.00
Balance                                    0.81      0.81      0.81       0.81      0.81      0.81
Stock di warehouse di akhir minggu 100.79 115.95 94.79 110.74 140.29 106.24
135.78 184.98
256.24 235.78