COGS Sheet for GSB Website

	A	B	C	D	E	G	H	I	J	K	L	N
1	Costs Of Goods Sold
2	Ingredients Available					Batch Yield & Cost
3		Price	Lbs ordered	$/lb	$/oz	Recipie(oz)	OZs	$/Batch	Yield	# of Batchs	Total Units Made	Total Reveune
4	All Purpose flour	11	10	1.100	0.069	All Purpose flour	2	0.138	12	1.000	12.000	0.000
5	Cocoa Powder	39	5	7.800	0.488	Cocoa Powder	0	0.000
6	Yeast	5.25	1	5.250	0.328	Yeast	0	0.000
7	Salt	25	50	0.500	0.031	Salt	0	0.000			$/Unit	Total COGS
8	Butter	85	30	2.833	0.177	Butter	0	0.000			$ 0.01	0.138
9	White Sugar	37	10	3.700	0.231	White Sugar	0	0.000
10	Brown Sugar	6.25	2	3.125	0.195	Brown Sugar	0	0.000				Total Profit
11	Baking Powder	8	1	8.000	0.500	Baking Powder	0	0.000				-0.138
12	Baking Soda	1.5	1	1.500	0.094	Baking Soda	0	0.000
13	Vegtable Oil	9.5	7.6	1.250	0.078	Vegtable Oil	0	0.000
14	Eggs	6	2	3.000	0.188	Eggs	0	0.000
15	Milk	5	8	0.625	0.039	Milk	0	0.000
16	Rasians	8.5	1	8.500	0.531	Rasians	0	0.000
17	Crazins	3.25	1	3.250	0.203	Crazins	0	0.000
18	Cinnamon	9	1	9.000	0.563	Cinnamon	0	0.000
19	Vanilla Extract	4.5	1	4.500	0.281	Vanilla Extract	0	0.000
20	Honey	11.5	1	11.500	0.719	Honey	0	0.000
21	Ginger	36	1	36.000	2.250	Ginger	0	0.000
22	Peppermint Extract	56	1	56.000	3.500	Peppermint Extract	0	0.000
23	Pumpkin Pie Spice	24	1	24.000	1.500	Pumpkin Pie Spice	0	0.000
24
25						Total Cost per batch		0.138
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