Coffee Roasting Break Even Analysis

	A	B	C	D	E	F	G	R	S	T
1
2			Instructions: Simply fill in information in the boxes.
3
4
5						START HERE
6			Coffee Consumption (kg per week)			0.4	*
7								0.3428571429
8			Roasted Bean cost per 1kg			$39.60	*
9			Green Bean cost per 1kg			$11.00	*
10
11			Green Bean moisture loss			16%
12
13			Cost of Coffee Bean Roaster			$50.00	*
14			Cost of Coffee Bean GRINDER if applicable			50	*
15			Cost of New Coffee Machine if applicable			$0.00	*
16
17			Cost of new equipment			$100.00
18
19			Cost			10
20						$594.88
21			Your annual savings based on coffee costs alone would be $594.88.
22
23
24			Factoring in buying new equipment, roasting your own beans will be cheaper after 10 weeks.
25
26
27
28
29
30									10	6
31									16	9.6
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48		Break-Even	Week	Buying Pre-Roasted	Roast Your Own	Diff
49		89.40	1	$ 15.84	$ 105.24	-$ 89.40	$ 5.24
50		78.80	2	$ 31.68	$ 110.48	-$ 78.80
51		68.19	3	$ 47.52	$ 115.71	-$ 68.19	$ 5.24
52		57.59	4	$ 63.36	$ 120.95	-$ 57.59
53		46.99	5	$ 79.20	$ 126.19	-$ 46.99
54		36.39	6	$ 95.04	$ 131.43	-$ 36.39
55		25.79	7	$ 110.88	$ 136.67	-$ 25.79
56		15.18	8	$ 126.72	$ 141.90	-$ 15.18
57		4.58	9	$ 142.56	$ 147.14	-$ 4.58
58	Break Even	6.02	10	$ 158.40	$ 152.38	$ 6.02
59	Break Even	16.62	11	$ 174.24	$ 157.62	$ 16.62
60	Break Even	27.22	12	$ 190.08	$ 162.86	$ 27.22
61	Break Even	37.82	13	$ 205.92	$ 168.10	$ 37.82
62	Break Even	48.43	14	$ 221.76	$ 173.33	$ 48.43
63	Break Even	59.03	15	$ 237.60	$ 178.57	$ 59.03
64	Break Even	69.63	16	$ 253.44	$ 183.81	$ 69.63
65	Break Even	80.23	17	$ 269.28	$ 189.05	$ 80.23
66	Break Even	90.83	18	$ 285.12	$ 194.29	$ 90.83
67	Break Even	101.44	19	$ 300.96	$ 199.52	$ 101.44
68	Break Even	112.04	20	$ 316.80	$ 204.76	$ 112.04
69	Break Even	122.64	21	$ 332.64	$ 210.00	$ 122.64
70	Break Even	133.24	22	$ 348.48	$ 215.24	$ 133.24
71	Break Even	143.84	23	$ 364.32	$ 220.48	$ 143.84
72	Break Even	154.45	24	$ 380.16	$ 225.71	$ 154.45
73	Break Even	165.05	25	$ 396.00	$ 230.95	$ 165.05
74	Break Even	175.65	26	$ 411.84	$ 236.19	$ 175.65
75	Break Even	186.25	27	$ 427.68	$ 241.43	$ 186.25
76	Break Even	196.85	28	$ 443.52	$ 246.67	$ 196.85
77	Break Even	207.46	29	$ 459.36	$ 251.90	$ 207.46
78	Break Even	218.06	30	$ 475.20	$ 257.14	$ 218.06
79	Break Even	228.66	31	$ 491.04	$ 262.38	$ 228.66
80	Break Even	239.26	32	$ 506.88	$ 267.62	$ 239.26
81	Break Even	249.86	33	$ 522.72	$ 272.86	$ 249.86
82	Break Even	260.46	34	$ 538.56	$ 278.10	$ 260.46
83	Break Even	271.07	35	$ 554.40	$ 283.33	$ 271.07
84	Break Even	281.67	36	$ 570.24	$ 288.57	$ 281.67
85	Break Even	292.27	37	$ 586.08	$ 293.81	$ 292.27
86	Break Even	302.87	38	$ 601.92	$ 299.05	$ 302.87
87	Break Even	313.47	39	$ 617.76	$ 304.29	$ 313.47
88	Break Even	324.08	40	$ 633.60	$ 309.52	$ 324.08
89	Break Even	334.68	41	$ 649.44	$ 314.76	$ 334.68
90	Break Even	345.28	42	$ 665.28	$ 320.00	$ 345.28
91	Break Even	355.88	43	$ 681.12	$ 325.24	$ 355.88
92	Break Even	366.48	44	$ 696.96	$ 330.48	$ 366.48
93	Break Even	377.09	45	$ 712.80	$ 335.71	$ 377.09
94	Break Even	387.69	46	$ 728.64	$ 340.95	$ 387.69
95	Break Even	398.29	47	$ 744.48	$ 346.19	$ 398.29
96	Break Even	408.89	48	$ 760.32	$ 351.43	$ 408.89
97	Break Even	419.49	49	$ 776.16	$ 356.67	$ 419.49
98	Break Even	430.10	50	$ 792.00	$ 361.90	$ 430.10
99	Break Even	440.70	51	$ 807.84	$ 367.14	$ 440.70
100	Break Even	451.30	52	$ 823.68	$ 372.38	$ 451.30