oatmeal_cookie_farmers_market_costing_formula_recipe.xlsx

	A	B	C	D	E	F	G	H	I	J
1	Oatmeal Raisin Cookie Recipe — Formula-Based Ingredient Costing
2	Ingredient	Package description	Package weight	Weight unit	Price per package	Recipe quantity	Recipe unit	Package grams	Recipe grams	Cost used in recipe

3	Rolled oats	Bulk bag	1000	g	$6.00	900	g	1000	900	$5.40
4	All-purpose flour	Bulk bag	10	kg	$12.00	600	g	10000	600	$0.72
5	Butter or margarine	454 g package	454	g	$6.50	500	g	454	500	$7.16
6	Brown sugar	Bag	1	kg	$3.75	550	g	1000	550	$2.06
7	Granulated sugar	Bag	2	kg	$2.75	250	g	2000	250	$0.34
8	Eggs	Dozen	12	each	$4.99	6	each	12	6	$2.50
9	Raisins	Bag	375	g	$3.98	350	g	375	350	$3.71
10	Vanilla	Bottle	250	mL	$4.00	15	mL	250	15	$0.24
11	Baking soda, cinnamon, salt	Combined estimate	1	each	$0.90	1	each	1	1	$0.90
12	Total recipe ingredient cost									$23.03
13	Target batch yield									120
14	Ingredient cost per cookie									$0.19
15	Raw dough per cookie (g)									25
16	Target total raw dough (g)									3000
17
18	How to use this sheet
19	Yellow cells are inputs. Enter the package size and package price you actually paid, plus the amount used by this 120-cookie recipe.
20	For flour example: enter 10 in Package weight, select kg in Weight unit, enter $12.00 in Price per package, and enter 600 g in Recipe quantity. The formula calculates $0.72 flour cost: $12 ÷ 10,000 g × 600 g.
21	For count-based products such as eggs, choose each for both units. For liquids such as vanilla, use mL for both units.
22	Package grams, Recipe grams, and Cost used in recipe are formula cells. Do not overwrite them.
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