Food Cost Calculator.xlsx

	A	B	C	D	E	G	K
1	FOOD COST CALCULATOR
2
3
4
5		DATE				COST DISTRIBUTION
6
7		DISH NAME
8
9		EST. SALE PPRICE	$ 100.35
10
11		TOTAL COST	$ 13.70
12
13		COST MARGIN	% 13.65
14
15		NET PROFIT	$ 86.65
16							UOM
17							UOM
18		PRIMARY INGREDIENTS					Imperial
19		Product Name	Qty.	Cost (per unit)	Total Cost
20		Wagu beef	1	$ 6.20	$ 6.20
21		Peppers	4	$ 1.00	$ 4.00
22
23		TOTAL			$ 10.20
24
25		SECONDARY INGREDIENTS
26		Product Name	Qty	Cost	Total Cost
27		Product Name	Oz	Lb/Pt	Total Cost
28		Oignon	0.5	$ 3.00	$ 0.09
29		Soy sauce	0.1	$ 4.50	$ 0.03
30		Spinach	2	$ 8.40	$ 1.05
31
32
33
34
35
36
37
38		TOTAL			$ 1.17
39
40		UTILITY AND PREP. COST
41		Name			Total Cost
42		Preparation			$ 2.00
43		Gas			$ 0.12
44		Electricity			$ 0.11
45		Water			$ 0.10
46		TOTAL			$ 2.33
47
48
49		Prepared by:			Approved by:
50
51		Position:			Position:
52
53
54
55
56	Open Pantry Restaurant Pro Suite is your all-in-one solution for restaurant inventory management.
57
58	Book a free demo today! Visit 👉			https://www.theopenpantry.com/au/restaurantpro
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