Receipe costing

	A	B	C	D	E	F	I	J	K
1	Item Name	Mysore Pak (Sweet)
2	Batch size (output)	0.8	kg	Cost	401	per kg
3
4	Ingredient	Qty	UOM	Cost	Rate
5	Ghee	0.7	kg	400	280		Cost Calculations
6	Besan	0.2	kg	102	20.4		Raw Material	401	kg
7	Sugar	0.2	kg	42	8.4		Gas (15%)	60.15	kg
8	Cardomom	0.01	kg	800	8		Labour (15%)	60.15	kg
9	Water	0.2	lit	20	4		packing (2%)	8.02	kg
10					0			529.32	kg
11					0		Selling price	700	kg
12					0		profit	170.68
13					0		Raw Material Cost	57%
14					0		Total cost %	76%
15					0		profit %	24%
16					0
17					0		Please note :
18					0		1. Please calculate the yield value in case using sub reciepe or semi finished products
19		1.31			320.8
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