Scribd Logo
Upload

Welcome to Scribd!

  • 10 views

    Water Treatment Forecasting

    Uploaded by

    valdi s
    The document contains a table listing the estimated order quantities, unit prices, and total prices for various water treatment chemicals needed over the next three years. It estimates needing a total of Rp2,067,018,674 for chemicals. A second table shows the projected consumption quantities of each chemical for years 2020 through 2022. It indicates that oxidizer will be the chemical consumed in the highest quantities, at a total of 380 units over 3 years. A third table lists the chemicals, total orders over the last 3 years, current unit prices, and resulting total prices to provide an updated cost estimate for the chemicals. It estimates a total of Rp1,546,352,820 will be needed to purchase

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd

    Water Treatment Forecasting

    Uploaded by

    valdi s
    10 views10 pages
    The document contains a table listing the estimated order quantities, unit prices, and total prices for various water treatment chemicals needed over the next three years. It estimates needing a total of Rp2,067,018,674 for chemicals. A second table shows the projected consumption quantities of each chemical for years 2020 through 2022. It indicates that oxidizer will be the chemical consumed in the highest quantities, at a total of 380 units over 3 years. A third table lists the chemicals, total orders over the last 3 years, current unit prices, and resulting total prices to provide an updated cost estimate for the chemicals. It estimates a total of Rp1,546,352,820 will be needed to purchase

    Copyright

    © © All Rights Reserved

    Available Formats

    XLSX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    The document contains a table listing the estimated order quantities, unit prices, and total prices for various water treatment chemicals needed over the next three years. It estimates needing a total of Rp2,067,018,674 for chemicals. A second table shows the projected consumption quantities of each chemical for years 2020 through 2022. It indicates that oxidizer will be the chemical consumed in the highest quantities, at a total of 380 units over 3 years. A third table lists the chemicals, total orders over the last 3 years, current unit prices, and resulting total prices to provide an updated cost estimate for the chemicals. It estimates a total of Rp1,546,352,820 will be needed to purchase

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    10 views10 pages

    Water Treatment Forecasting

    Uploaded by

    valdi s
    The document contains a table listing the estimated order quantities, unit prices, and total prices for various water treatment chemicals needed over the next three years. It estimates needing a total of Rp2,067,018,674 for chemicals. A second table shows the projected consumption quantities of each chemical for years 2020 through 2022. It indicates that oxidizer will be the chemical consumed in the highest quantities, at a total of 380 units over 3 years. A third table lists the chemicals, total orders over the last 3 years, current unit prices, and resulting total prices to provide an updated cost estimate for the chemicals. It estimates a total of Rp1,546,352,820 will be needed to purchase

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    of 10

    No Consumables Estimated Order Price per Unit Total Price

    1 Oxidator (CT3445) 380 Rp2,323,416 Rp882,898,080 Rp882,898,080


    2 Coagulant (Cl2011) 380 Rp1,167,669 Rp443,714,030 Rp1,326,612,110
    3 Flocculant (Fl2022) 217 Rp1,012,630 Rp219,740,710 Rp1,546,352,820
    4 Biocide (T722) 158 Rp2,026,996 Rp320,265,329 Rp1,866,618,149
    5 SMBS 148 Rp703,470 Rp104,113,560 Rp1,970,731,709
    6 pH Adjuster (B1414) 57 Rp1,689,245 Rp96,286,965 Rp2,067,018,674

    Total Rp2,067,018,674
    Rp1,689,245
    0.427136
    0.6418 0.214664
    0.748108 0.106308
    0.903049 0.154941
    0.953417 0.050369
    1 0.046583
    No Consumables 2020 2021 2022 Total
    1 Biocide (T722) 24 24 24 72 24
    2 Coagulant (Cl2011) 71 74 72 217 68
    3 Flocculant (Fl2022) 54 53 51 158 46
    4 Oxidator (CT3445) 133 122 125 380 44
    5 pH Adjuster (B1414) 21 17 19 57 18
    6 SMBS 48 52 48 148 12 140

    120
    Consumables Total Y1 Total Y2 Total Y3 Total
    100
    Oxidator (CT3445) 133 122 125 380 126.6667
    80

    60

    40

    20

    0
    Biocide Coa
    (T722) (Cl
    Chart Title
    140

    120

    100

    80

    60

    40

    20

    0
    Biocide Coagulant Flocculant Oxidator pH Adjuster SMBS
    (T722) (Cl2011) (Fl2022) (CT3445) (B1414)

    Column AM Column AN Column AO


    Jan-20 11 Jan-22 8 10 2
    Feb-20 13 Feb-22 12 10 -2
    Mar-20 13 Mar-22 11 10 -1
    Apr-20 10 Apr-22 10 10 0
    May-20 9 May-22 10 10 0
    Jun-20 11 Jun-22 12 10 -2
    Jul-20 13 Jul-22 8 10 2
    Aug-20 9 Aug-22 13 10 -3
    Sep-20 10 Sep-22 10 10 0
    Oct-20 13 Oct-22 9 10 1
    Nov-20 12 Nov-22 12 10 -2
    Dec-20 9 Dec-22 10 10 0
    Jan-21 13
    Feb-21 10
    Mar-21 8
    Apr-21 8
    May-21 9
    Jun-21 10
    Jul-21 12
    Aug-21 12
    Sep-21 13
    Oct-21 8
    Nov-21 10
    Dec-21 9
    Jan-22 8
    Feb-22 12
    Mar-22 11
    Apr-22 10
    May-22 10
    Jun-22 12
    Jul-22 8
    Aug-22 13
    Sep-22 10
    Oct-22 9
    Nov-22 12
    Dec-22 10
    44 44 44
    Jan-20 11 33 Jan-21 13 31 Jan-22 8 36
    Feb-20 13 20 Feb-21 10 21 Feb-22 12 24
    Mar-20 13 7 Mar-21 8 13 Mar-22 11 13
    Apr-20 10 -3 Apr-21 8 5 Apr-22 10 3
    44 44 44
    May-20 9 35 May-21 9 35 May-22 10 34
    Jun-20 11 24 Jun-21 10 25 Jun-22 12 22
    Jul-20 13 11 Jul-21 12 73 Jul-22 8 74
    Aug-20 9 2 Aug-21 12 61 Aug-22 13 61
    44 44 44
    Sep-20 10 34 Sep-21 13 31 Sep-22 10 34
    Oct-20 13 21 Oct-21 8 23 Oct-22 9 25
    Nov-20 12 9 Nov-21 10 13 Nov-22 12 13
    Dec-20 9 0 Dec-21 9 4 Dec-22 10 3
    Chemicals Order (last 3yr) Unit Price Total Price

    Oxidator (CT3445) 380 Rp2,323,416 Rp882,898,080


    Coagulant (Cl2011) 217 Rp1,167,669 Rp253,384,065
    Flocculant (Fl2022) 158 Rp1,012,630 Rp159,995,540
    Biocide (T722) 72 Rp2,026,996 Rp145,943,694

    SMBS 145 Rp703,470 Rp102,003,150


    pH Adjuster (B1414) 58 Rp1,689,245 Rp97,976,210
    No Cost Biaya pertahun
    1 Electrical Rp26,785,271
    2 Administration Rp2,500,000
    3 Handling Rp24,000,000
    4 Waste Management Rp66,741,500

    Total Rp120,026,771

    EOQ 43.9618204585 1936 Rp19,364,319,095


    132 Rp73,349,694
    2.865 Rp25,557,576 Rp73,222,455 Rp219,667,366
    Rp10,002,231 Rp220,049,081
    Rp439,716,446
    Order Frequency 3.00260541132
    Dimana:
    EOQ= Jumlah optimal barang per
    pemesanan (Q*)
    D = Permintaan tahunan barang
    persediaan dalam unit
    S = Biaya pemasangan atau
    pemesanan setiap pesanan
    H = Biaya penahan atau penyimpanan
    per unit per tahun

    You might also like