0 Replies Latest reply: Oct 19, 2018 1:41 AM by Priyal Paithankar RSS

    Predictive

    Priyal Paithankar

      Dear All,

       

      Below is my data sheet.Please help me to calculate the predictive cost for Rate Per Kg for year 2019.


            

      YearOpening StockProductionTotal SupplyConsumption Total Supply Consumption RatioClosing StockRate Per KgAvg Purchase Rate Per Bag
      (1 Bag=37 Kg)
      200212.1675.4887.6469.551.2618.0926
      200318.0970.3688.4568.871.2819.5822
      200419.5879.9199.4968.201.4631.2921
      200531.2961.1892.4767.531.3724.9433
      200624.9460.4385.3766.871.2818.5038
      200718.5077.3795.8866.211.4529.6656
      200829.6665.5095.1665.561.4529.60501850.63
      200929.6065.6795.2764.921.4730.35572096.54
      201030.3565.8396.1864.281.5031.90622298.68
      201131.9058.8990.7963.651.4327.13732713.25
      201227.1376.33103.4663.031.6440.44893286.19
      201340.4463.13103.5762.411.6641.15642355.33
      201441.1553.7494.8961.801.5433.09672473.78
      201533.0950.0483.1361.191.3621.94772851.01
      201621.9456.7478.6860.591.3018.081234563.39
      201718.0871.1289.2060.001.4929.201886944.70
      201829.2050.9080.1059.401.3520.701736391.28
      201920.7050.9071.6059.401.21

       

      Also attaching the excel file.

      Thanks,

      Priyal.