K-Deodorant creme stock

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P
1	Consistency	Fragrance	200	130	100	60	40	20	g (sum)		Req. amount (g)	Recipe	%

2	18C	Unscented							0		0	Shea butter %	35
3	2023-04-30								0		0	Coconut oil %	25
4									0		0	NaHCO3 %	26
5									0		0	ZnO %	14
6									0		0	Perfume oil %	0.4
7									0		0
8									0		Gross g (unsc)
9									0		0
10									0		Gross g (scented)
11									0		0
12	20C	Unscented							0	66	1080	Shea butter %	40
13		Fresh Air				4		10	440	1.76	540	Coconut oil %	20
14		Gucci W 2002				0		0	0	0	702	NaHCO3 %	26
15		Tunisian Opium	2	2		4		4	980	3.92	378	ZnO %	14
16		Gucci pour Homme I (1976)				4		6	360	1.44	10.8	Perfume oil %	0.4
17		Daisy				4		0	240	0.96	2700
18		Stone Pine				4		10	440	1.76	Gross g (unsc)
19		Lily Ginger						12	240	0.96	0
20		Amber & Oud						0	0	0	Gross g (scented)
21		Roja Haute Luxe						0	0	0	2700
22	25C	Unscented							0	78	1570	Shea butter %	50
23		Fresh Air				4		10	440	1.76	314	Coconut oil %	10
24		Le Male				2		6	240	0.96	816.4	NaHCO3 %	26
25		Tunisian Opium	2	2		4		10	1100	4.4	439.6	ZnO %	14
26		Gucci pour Homme I (1976)				4		10	440	1.76	12.56	Perfume oil %	0.4
27		Daisy				4		0	240	0.96	3140
28		Stone Pine				4	6	10	680	2.72	Gross g (unsc)
29		London Oud						0	0	0	0
30		Hacivat						0	0	0	Gross g (scented)
31		Pink Jasmine						0	0	0	3140
32	28C	Unscented							0	37.3	1066.8	Shea butter %	60
33		Fresh Air				2		6	240	0.96	0	Coconut oil %	0
34		Le Male				2		4	200	0.8	462.28	NaHCO3 %	26
35		Tunisian Opium	2	2		6		4	1100	4.4	248.92	ZnO %	14
36		Gucci pour Homme I (1976)				1.3		8	238	0.952	7.112	Perfume oil %	0.4
37		Gucci W 2002						0	0	0	1778
38									0	0	Gross g (unsc)
39									0	0	0
40									0	0	Gross g (scented)
41									0	0	1778
42	Total amounts needed for this batch	Containers have	70	75	75	140	150	109			3716.8	Shea butter %
43		Containers need	6	6	0	53.3	6	110	181.3		854	Coconut oil %
44		Containers left	64	69	75	86.7	144	-1	Total		1980.68	NaHCO3 %
45		Turnover estimate	222	150	0	692.9	54	660	1778.9	€	1066.52	ZnO %
46		Prod. costs estimate	39.6	25.74	0	105.534	7.92	72.6	251.394	€	30.472	Perfume oil %		Required	Before production	Diff
47		Returns estimate	182.4	124.26	0	587.366	46.08	587.4	1527.506	€		Total cream (g)		Fragrance oil (g)	Fragr. oil (g)	(g)
48									Total		Amber & Oud	0		0	1	1
49		Weight	1200	780	0	3198	240	2200	7618	g	Daisy	480		1.92	3.5	1.58
50											Fresh Air	1120		4.48	12	7.52
51											Gucci pour Homme I (1976)	1038		4.152	30	25.848
52											Gucci W 2002	0		0	30	30
53											Hacivat	0		0	1	1
54											Le Male	440		1.76	2.7	0.94
55											Lily Ginger	240		0.96	1	0.04
56											London Oud	0		0	0.8	0.8
57											Pink Jasmine	0		0	1	1
58											Roja Haute Luxe	0		0	1	1
59											Stone Pine	1120		4.48	16	11.52
60											Tunisian Opium	3180		12.72	30	17.28
61												0		0		0
62												0		0		0
63												0		0		0
64												0		0		0
65	Previous batches below here
66		2023-01-23
67
68	18C	Unscented							0		0	Shea butter %	35
69									0		0	Coconut oil %	25
70									0		0	NaHCO3 %	26
71									0		0	ZnO %	14
72									0		0	Perfume oil %	0.4
73									0		0
74									0		Gross g (unsc)
75									0		0
76									0		Gross g (scented)
77									0		0
78	20C	Unscented	4	4	2	4	2		1840	131	1080	Shea butter %	40
79		Polo Explorer	2			4		8	800	3.2	540	Coconut oil %	20
80		Le Male				2	4	10	480	1.92	702	NaHCO3 %	26
81		Tunisian Opium	1			2		8	480	1.92	378	ZnO %	14
82		Lost Cherry				4	4	8	560	2.24	10.8	Perfume oil %	0.4
83		Chinatown						10	200	0.8	5320
84		Gucci pour Homme I (1976)						12	240	0.96	Gross g (unsc)
85		Gucci pour Homme II						12	240	0.96	1840
86		Louis Vitton Ombre Nomade						12	240	0.96	Gross g (scented)
87		Roja Amber Aoud						12	240	0.96	3480
88	25C	Unscented	2	2		4		6	1020	124	1570	Shea butter %	50
89		Polo Explorer	2	2		4		8	1060	4.24	314	Coconut oil %	10
90		Gucci Guilty W	2	2		4		8	1060	4.24	816.4	NaHCO3 %	26
91		A&F Fierce	2	2		4		8	1060	4.24	439.6	ZnO %	14
92	Too much cream - not enough perfume relatively	Le Male					4	8	320	1.28	12.56	Perfume oil %	0.4
93		Tunisian Opium	2			2		6	640	2.56	6200
94		Lost Cherry				4	4	10	600	2.4	Gross g (unsc)
95		Roja Britannia						12	240	0.96	1020
96		Acqua di Gio Absolu						10	200	0.8	Gross g (scented)
97		Gucci Guilty (M)							0	0	5180
98	28C	Unscented	2			4		6	760	42	1066.8	Shea butter %	60
99		Egyptian Musk	2					8	560	2.24	0	Coconut oil %	0
100		Lost Cherry	2			4		8	800	3.2	462.28	NaHCO3 %	26