AYRAN.xlsx

	B	C	D	E	F	G	H	I
1	Bottom two-row crates shipment
2	product	number of crates required at the start of the project	investment cost required at the start of the project	Number of crates needed per year	annual cost of crates	Annual Shipping Savings	return earnings	total savings
3	170 ml	28.496	₺ 176.961	34.195	₺ 212.353	₺ 1.358.756	₺ 75.329	₺ 1.044.771
4	200 ml	10.358	₺ 64.324	12.430	₺ 77.189	₺ 493.899	₺ 57.233	₺ 409.619
5	285 ml	25.341	₺ 157.368	30.409	₺ 188.841	₺ 604.158	₺ 156.635	₺ 414.583
6	Toplam	64.195	₺ 398.653	77.034	₺ 478.384	₺ 2.456.813	₺ 289.197	₺ 1.868.973
7
8
9
10	Full crates shipment
11	product	number of crates required at the start of the project	investment cost required at the start of the project	Number of crates needed per year	annual cost of crates	Annual Shipping Savings	return earnings	total savings
12	170 ml	213.721	1.327.207	256.465	1.592.648	0	75.329	-2.844.526
13	200 ml	77.686	482.431	93.223	578.917	0	57.233	-1.004.115
14	285 ml	237.572	1.475.324	285.087	1.770.389	0	156.635	-3.089.079
15	Toplam	528.979	₺ 3.284.961,91	634.775	₺ 3.941.954,29	0	₺ 289.196,85	-₺ 6.937.719,35
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
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