Recipe_Cost_and_Pricing_Calculator.xlsx

	A	B	C	D	E	F	G	H	I
1	RECIPE COST & PRICING CALCULATOR
2	Plate Cost Calculation & Suggested Target Pricing
3
4	Item Name:	Gourmet Burger with Truffle Fries		TOTAL PLATE COST		SUGGESTED PRICE (TARGET %)
5	Category:	Main Course		$7.19		$23.98
6	Target Food Cost %:	30.0%		$7.19		$23.98
7	Yield / Portions:	1
8
9	Ingredient Name	Recipe Qty	Unit	Pack Cost ($)	Pack Size Qty	Pack Unit	Cost per Unit ($)	Cost per Portion ($)	Notes
10	Brioche Bun	1.00	pc	$6.00	12.00	pc	$0.50	$0.50	Fresh daily
11	Angus Beef Patty (8 oz)	1.00	pc	$24.00	8.00	pc	$3.00	$3.00	80/20 Blend
12	Cheddar Cheese Slice	2.00	slice	$8.00	40.00	slice	$0.20	$0.40	Aged Cheddar
13	Truffle Mayo	0.05	kg	$18.00	1.00	kg	$18.00	$0.90	House-made
14	Lettuce & Tomato	1.00	serving	$5.00	20.00	serving	$0.25	$0.25	Prep mix
15	Russet Potatoes (Fries)	0.25	kg	$10.00	5.00	kg	$2.00	$0.50	Hand-cut
16	Truffle Oil & Parm	0.02	L	$25.00	0.50	L	$50.00	$1.00	Finishing oil/cheese
17	Packaging Box	1.00	pc	$15.00	50.00	pc	$0.30	$0.30	To-go box
18	TOTAL RAW INGREDIENT EXPENSE (PLATE COST)							$6.85
19
20				Total Plate Cost (Raw Expense)			$6.85
21				Buffer / Waste Allowance (5%)			$0.34
22				Adjusted Plate Cost			$7.19
23				Target Food Cost %			30.0%
24				Target Selling Price (Plate Cost ÷ Target Food Cost %)			$23.98
25				Actual Menu Selling Price			$18.50
26				Actual Food Cost % (Plate Cost ÷ Actual Price)			38.9%
27				Gross Profit Margin per Portion			$11.31
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