forecasting using bass model.xlsx

	D	E	F	I	J	K	L	M	N	O	R	S	T	U	V	W	X	Y	Z	AA	AB	AC	AD	AE	AF	AG
1
2
3
4	year	sales	cumulative sales
5	2017	10	10	innovation(p)	0.01						წელი	კვარტალი	სულ		მათ შორის:
6	2018	8	18	word of mouth(q)	0.2										მსხვილი რეალური		პროგნოზი	მთლიანი	საშუალო	მცირე			innovation(p)	0.02	es yvelaze kargia vfiqrob
7	2019	9	27	q-p	0.19								მლნ. ლარი								მთლიანი მსხვილი		word of mouth(q)	0.3		პროგნოზები
8	2020	11	38	market capacity	600								1		2				3	4			q-p	0.28
9	2021	13	51								2007	...	7072.4	2007	2129.2	2007		2129.2	2211	2732.3	122797.9		market capacity	122797.9
10	2022	15	66								2008	...	8477.4	2008	3508.1	2008	3041.058503	5170.258503	2348.6	2620.6						6
11	2023	17	83		Data table to calculate sales of 2030 for various values of q and p						2009	...	8360.8	2009	3071	2009	3838.324118	9008.582621	2208	3081.8
12	2024	19	102				q				2010	...	10445.5	2010	4546.1	2010	4780.097416	13788.68004	2426.3	3473.1		1	innovation(p)	0.02	araa kargi
13	2025	22	124			32	0.2	0.3	0.4	0.5	2011	...	17028	2011	6331.2	2011	5852.299122	19640.97916	3315.2	7381.5			word of mouth(q)	0.5
14	2026	24	148		p	0.01	32	45	38	18	2012	...	19129.8	2012	7645.4	2012	7012.985928	26653.96509	3834.2	7650.2			q-p	0.48
15	2027	27	175			0.05	24	15	6	2	2013	...	20500.2	2013	7883.5	2013	8183.45095	34837.41604	4157.4	8459.4			market capacity	122797.9
16	2028	29	204			0.1	10	4	1	0	2014	...	23072.9	2014	9034.8	2014	9245.451646	44082.86768	4679.2	9358.8
17	2029	31	235			0.15	4	1	0	0	2015	...	23908.1	2015	8926.4	2015	10051.60609	54134.47377	5043.3	9938.4		2	innovation(p)	0.02	araa kargi
18	2030	32	268			0.2	2	0	0	0	2016	...	26417.7	2016	9841.6	2016	10454.18549	64588.65927	5346.3	11229.8			word of mouth(q)	0.4
19											2017	...	29363.2	2017	11643.1	2017	10349.17124	74937.83051	6442.2	11277.9			q-p	0.38
20											2018	...	33871.5	2018	13922.3	2018	9719.231788	84657.0623	7279.6	12669.6			market capacity	122797.9
21											2019	...	38880.2	2019	16990.8	2019	8651.122515	93308.18481	8371.8	13517.6
22											2020	...	39007.1	2020	17324.4	2020	7312.136774	100620.3216	8068.3	13614.3		3	innovation(p)	0.01	kargia
23																							word of mouth(q)	0.3
24																							q-p	0.29
25																							market capacity	122797.9
26
27																						4	innovation(p)	0.03	araa kargi
28																							word of mouth(q)	0.2
29																							q-p	0.17
30																							market capacity	122797.9
31
32																						5	innovation(p)	0.02	kargia
33																							word of mouth(q)	0.3
34																							q-p	0.28
35																							market capacity	122797.9
36
37																						6	innovation(p)	0.04	araa kargi
38																							word of mouth(q)	0.2
39																							q-p	0.16
40																							market capacity	122797.9
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100