Predictive

[priyalvp24]

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.