Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear All,
Below is my data sheet.Please help me to calculate the predictive cost for Rate Per Kg for year 2019.
Year | Opening Stock | Production | Total Supply | Consumption | Total Supply Consumption Ratio | Closing Stock | Rate Per Kg | Avg Purchase Rate Per Bag (1 Bag=37 Kg) |
2002 | 12.16 | 75.48 | 87.64 | 69.55 | 1.26 | 18.09 | 26 | |
2003 | 18.09 | 70.36 | 88.45 | 68.87 | 1.28 | 19.58 | 22 | |
2004 | 19.58 | 79.91 | 99.49 | 68.20 | 1.46 | 31.29 | 21 | |
2005 | 31.29 | 61.18 | 92.47 | 67.53 | 1.37 | 24.94 | 33 | |
2006 | 24.94 | 60.43 | 85.37 | 66.87 | 1.28 | 18.50 | 38 | |
2007 | 18.50 | 77.37 | 95.88 | 66.21 | 1.45 | 29.66 | 56 | |
2008 | 29.66 | 65.50 | 95.16 | 65.56 | 1.45 | 29.60 | 50 | 1850.63 |
2009 | 29.60 | 65.67 | 95.27 | 64.92 | 1.47 | 30.35 | 57 | 2096.54 |
2010 | 30.35 | 65.83 | 96.18 | 64.28 | 1.50 | 31.90 | 62 | 2298.68 |
2011 | 31.90 | 58.89 | 90.79 | 63.65 | 1.43 | 27.13 | 73 | 2713.25 |
2012 | 27.13 | 76.33 | 103.46 | 63.03 | 1.64 | 40.44 | 89 | 3286.19 |
2013 | 40.44 | 63.13 | 103.57 | 62.41 | 1.66 | 41.15 | 64 | 2355.33 |
2014 | 41.15 | 53.74 | 94.89 | 61.80 | 1.54 | 33.09 | 67 | 2473.78 |
2015 | 33.09 | 50.04 | 83.13 | 61.19 | 1.36 | 21.94 | 77 | 2851.01 |
2016 | 21.94 | 56.74 | 78.68 | 60.59 | 1.30 | 18.08 | 123 | 4563.39 |
2017 | 18.08 | 71.12 | 89.20 | 60.00 | 1.49 | 29.20 | 188 | 6944.70 |
2018 | 29.20 | 50.90 | 80.10 | 59.40 | 1.35 | 20.70 | 173 | 6391.28 |
2019 | 20.70 | 50.90 | 71.60 | 59.40 | 1.21 |
Also attaching the excel file.
Thanks,
Priyal.