RECIPE COST CALCULATOR
DATE
2/2/2016
DISH NAME
Kullad Chai
COST DISTRIBUTION
EST. SALE PPRICE
30.00
TOTAL COST
15.92
COST MARGIN
15%
41%
45%
53.07
NET PROFIT
14.08
PRIMARY INGREDIENTS
Product Name
Milk
Sugar
Tea Powder
Qty.
0.1
0.0075
0.0075
Cost
(per unit)
34.00
32.00
380.00
TOTAL
Total Cost
3.40
0.24
2.85
Insert a Photo of the Dish
6.49
SECONDARY INGREDIENTS
Product Name
Ginger
Cardomom
Water
Kullad
Qty
Cost
Gm
Kg/Lt
15
1
20
1
TOTAL
60.00
800.00
20.00
5.00
Total Cost
0.90
0.80
0.40
5.00
PREPARATION
7.10
UTILITY AND PREP. COST
Name
Total Cost
Preparation
Gas
Electricity
Water
2.00
0.12
0.11
0.10
TOTAL
2.33
ALLERGIES
Prepared By
Inventory Templates by Spreadsheet123
Approved By
2013 Spreadsheet123 LTD. All rights reserved
Occupation
Inventory Templates by Spreadsheet123
Occupation
2013 Spreadsheet123 LTD. All rights reserved
TOR
15%
41%
45%
Insert a Photo of the Dish
PREPARATION
Inventory Templates by Spreadsheet123
2013 Spreadsheet123 LTD. All rights reserved
Inventory Templates by Spreadsheet123
2013 Spreadsheet123 LTD. All rights reserved
RECIPE COST CALCULATOR
DATE
2/2/2016
DISH NAME
Masala Chai
COST DISTRIBUTION
EST. SALE PPRICE
35.00
TOTAL COST
10.82
COST MARGIN
22%
60%
18%
30.91
NET PROFIT
24.18
PRIMARY INGREDIENTS
Product Name
Milk
Sugar
Tea Powder
Qty.
0.1
0.0075
0.0075
Cost
(per unit)
34.00
32.00
380.00
TOTAL
Total Cost
3.40
0.24
2.85
Insert a Photo of the Dish
6.49
SECONDARY INGREDIENTS
Product Name
Ginger
Masala
Water
Qty
Cost
Gm
Kg/Lt
10
2
20
TOTAL
60.00
500.00
20.00
Total Cost
0.60
1.00
0.40
PREPARATION
2.00
UTILITY AND PREP. COST
Name
Total Cost
Preparation
Gas
Electricity
Water
2.00
0.12
0.11
0.10
TOTAL
2.33
ALLERGIES
Prepared By
Inventory Templates by Spreadsheet123
Approved By
2013 Spreadsheet123 LTD. All rights reserved
Occupation
Inventory Templates by Spreadsheet123
Occupation
2013 Spreadsheet123 LTD. All rights reserved
TOR
22%
60%
18%
Insert a Photo of the Dish
PREPARATION
Inventory Templates by Spreadsheet123
2013 Spreadsheet123 LTD. All rights reserved
Inventory Templates by Spreadsheet123
2013 Spreadsheet123 LTD. All rights reserved
RECIPE COST CALCULATOR
DATE
2/2/2016
DISH NAME
Gulkand Chai
COST DISTRIBUTION
EST. SALE PPRICE
40.00
TOTAL COST
11.52
COST MARGIN
20%
56%
23%
28.79
NET PROFIT
28.49
PRIMARY INGREDIENTS
Product Name
Milk
Sugar
Tea Powder
Qty.
0.1
0.0075
0.0075
Cost
(per unit)
34.00
32.00
380.00
TOTAL
Total Cost
3.40
0.24
2.85
Insert a Photo of the Dish
6.49
SECONDARY INGREDIENTS
Product Name
Ginger
Gulkand
Water
Qty
Cost
Gm
Kg/Lt
10
15
20
TOTAL
60.00
113.00
20.00
Total Cost
0.60
1.70
0.40
PREPARATION
2.70
UTILITY AND PREP. COST
Name
Total Cost
Preparation
Gas
Electricity
Water
2.00
0.12
0.11
0.10
TOTAL
2.33
ALLERGIES
Prepared By
Inventory Templates by Spreadsheet123
Approved By
2013 Spreadsheet123 LTD. All rights reserved
Occupation
Inventory Templates by Spreadsheet123
Occupation
2013 Spreadsheet123 LTD. All rights reserved
TOR
20%
56%
23%
Insert a Photo of the Dish
PREPARATION
Inventory Templates by Spreadsheet123
2013 Spreadsheet123 LTD. All rights reserved
Inventory Templates by Spreadsheet123
2013 Spreadsheet123 LTD. All rights reserved
RECIPE COST CALCULATOR
DATE
2/2/2016
DISH NAME
Karamati Chai
COST DISTRIBUTION
EST. SALE PPRICE
40.00
TOTAL COST
14.17
COST MARGIN
16%
16%
68%
35.43
NET PROFIT
25.83
PRIMARY INGREDIENTS
Product Name
Milk
Sugar
Tea Powder
Qty.
0.12
0.0075
0.014
Cost
(per unit)
34.00
32.00
380.00
TOTAL
Total Cost
4.08
0.24
5.32
Insert a Photo of the Dish
9.64
SECONDARY INGREDIENTS
Product Name
Ginger
Cardomom
Water
Qty
Cost
Gm
Kg/Lt
15
1
20
TOTAL
60.00
900.00
20.00
Total Cost
0.90
0.90
0.40
PREPARATION
2.20
UTILITY AND PREP. COST
Name
Total Cost
Preparation
Gas
Electricity
Water
2.00
0.12
0.11
0.10
TOTAL
2.33
ALLERGIES
Prepared By
Inventory Templates by Spreadsheet123
Approved By
2013 Spreadsheet123 LTD. All rights reserved
Occupation
Inventory Templates by Spreadsheet123
Occupation
2013 Spreadsheet123 LTD. All rights reserved
TOR
16%
16%
68%
Insert a Photo of the Dish
PREPARATION
Inventory Templates by Spreadsheet123
2013 Spreadsheet123 LTD. All rights reserved
Inventory Templates by Spreadsheet123
2013 Spreadsheet123 LTD. All rights reserved
RECIPE COST CALCULATOR
DATE
2/2/2016
DISH NAME
Dilkhush Chai
COST DISTRIBUTION
EST. SALE PPRICE
45.00
TOTAL COST
12.24
COST MARGIN
19%
20%
61%
27.20
NET PROFIT
32.76
PRIMARY INGREDIENTS
Product Name
Milk
Sugar
Tea Powder
Qty.
0.13
0.0075
0.0075
Cost
(per unit)
34.00
32.00
380.00
TOTAL
Total Cost
4.42
0.24
2.85
Insert a Photo of the Dish
7.51
SECONDARY INGREDIENTS
Product Name
Ginger
Cardomom
Qty
Cost
Gm
Kg/Lt
10
2
TOTAL
60.00
900.00
Total Cost
0.60
1.80
PREPARATION
2.40
UTILITY AND PREP. COST
Name
Total Cost
Preparation
Gas
Electricity
Water
2.00
0.12
0.11
0.10
TOTAL
2.33
ALLERGIES
Prepared By
Inventory Templates by Spreadsheet123
Approved By
2013 Spreadsheet123 LTD. All rights reserved
Occupation
Inventory Templates by Spreadsheet123
Occupation
2013 Spreadsheet123 LTD. All rights reserved
TOR
19%
20%
61%
Insert a Photo of the Dish
PREPARATION
Inventory Templates by Spreadsheet123
2013 Spreadsheet123 LTD. All rights reserved
Inventory Templates by Spreadsheet123
2013 Spreadsheet123 LTD. All rights reserved
RECIPE COST CALCULATOR
DATE
2/2/2016
DISH NAME
Lemon Mint Tea
EST. SALE PPRICE
45.00
TOTAL COST
COST MARGIN
COST DISTRIBUTION
40%
5.85
%
45%
15%
13.00
NET PROFIT
39.15
PRIMARY INGREDIENTS
Product Name
Water
Sugar
Tea Powder
Qty.
0.1
0.0075
0.001
Cost
(per unit)
20.00
32.00
380.00
TOTAL
Total Cost
2.00
0.24
0.38
Insert a Photo of the Dish
2.62
SECONDARY INGREDIENTS
Product Name
Mint
Lemon
Qty
Cost
Gm
Kg/Lt
10
10
TOTAL
40.00
50.00
Total Cost
0.40
0.50
PREPARATION
0.90
UTILITY AND PREP. COST
Name
Total Cost
Preparation
Gas
Electricity
Water
2.00
0.12
0.11
0.10
TOTAL
2.33
ALLERGIES
Prepared By
Inventory Templates by Spreadsheet123
Approved By
2013 Spreadsheet123 LTD. All rights reserved
Occupation
Inventory Templates by Spreadsheet123
Occupation
2013 Spreadsheet123 LTD. All rights reserved
TOR
40%
45%
15%
Insert a Photo of the Dish
PREPARATION
Inventory Templates by Spreadsheet123
2013 Spreadsheet123 LTD. All rights reserved
Inventory Templates by Spreadsheet123
2013 Spreadsheet123 LTD. All rights reserved
RECIPE COST CALCULATOR
DATE
2/2/2016
COST DISTRIBUTION
DISH NAME
LemonGrass Chai
EST. SALE PPRICE
40.00
TOTAL COST
10.22
COST MARGIN
23%
14%
64%
25.55
NET PROFIT
29.78
PRIMARY INGREDIENTS
Product Name
Milk
Sugar
Tea Powder
Qty.
0.1
0.0075
0.0075
Cost
(per unit)
34.00
32.00
380.00
TOTAL
Total Cost
3.40
0.24
2.85
Insert a Photo of the Dish
6.49
SECONDARY INGREDIENTS
Product Name
Lemon Grass
Water
Qty
Cost
Gm
Kg/Lt
20
20
TOTAL
50.00
20.00
Total Cost
1.00
0.40
PREPARATION
1.40
UTILITY AND PREP. COST
Name
Total Cost
Preparation
Gas
Electricity
Water
2.00
0.12
0.11
0.10
TOTAL
2.33
ALLERGIES
Prepared By
Inventory Templates by Spreadsheet123
Approved By
2013 Spreadsheet123 LTD. All rights reserved
Occupation
Inventory Templates by Spreadsheet123
Occupation
2013 Spreadsheet123 LTD. All rights reserved
TOR
23%
14%
64%
Insert a Photo of the Dish
PREPARATION
Inventory Templates by Spreadsheet123
2013 Spreadsheet123 LTD. All rights reserved
Inventory Templates by Spreadsheet123
2013 Spreadsheet123 LTD. All rights reserved
RECIPE COST CALCULATOR
DATE
2/2/2016
DISH NAME
Kashmiri Kahwa
COST DISTRIBUTION
EST. SALE PPRICE
60.00
TOTAL COST
10.45
COST MARGIN
22%
23%
55%
17.41
NET PROFIT
49.55
PRIMARY INGREDIENTS
Product Name
Water
Sugar
Green Tea
Qty.
0.1
0.0005
0.0005
Cost
(per unit)
20.00
32.00
800.00
TOTAL
Total Cost
2.00
0.02
0.40
Insert a Photo of the Dish
2.42
SECONDARY INGREDIENTS
Product Name
Ginger
Cardomom
Clove
Cinamon
Kesar
Dry Fruits
Qty
Cost
Gm
Kg/Lt
5
1
1
1
0.01
10
TOTAL
Total Cost
60.00
900.00
0.30
0.90
450.00
4.50
PREPARATION
5.70
UTILITY AND PREP. COST
Name
Total Cost
Preparation
Gas
Electricity
Water
2.00
0.12
0.11
0.10
TOTAL
2.33
ALLERGIES
Prepared By
Inventory Templates by Spreadsheet123
Approved By
2013 Spreadsheet123 LTD. All rights reserved
Occupation
Inventory Templates by Spreadsheet123
Occupation
2013 Spreadsheet123 LTD. All rights reserved
TOR
22%
23%
55%
Insert a Photo of the Dish
PREPARATION
Inventory Templates by Spreadsheet123
2013 Spreadsheet123 LTD. All rights reserved
Inventory Templates by Spreadsheet123
2013 Spreadsheet123 LTD. All rights reserved
RECIPE COST CALCULATOR
DATE
2/2/2016
DISH NAME
Nawabi Chai
COST DISTRIBUTION
EST. SALE PPRICE
70.00
TOTAL COST
21.51
COST MARGIN
11%
52%
38%
30.73
NET PROFIT
48.49
PRIMARY INGREDIENTS
Product Name
Qty.
Milk
Sugar
Tea Powder
0.2
0.015
0.01
Cost
(per unit)
34.00
32.00
380.00
TOTAL
Total Cost
6.80
0.48
3.80
Insert a Photo of the Dish
11.08
SECONDARY INGREDIENTS
Product Name
Cardomom
Kesar
Qty
Cost
Gm
Kg/Lt
8
1
TOTAL
900.00
900.00
Total Cost
7.20
0.90
PREPARATION
8.10
UTILITY AND PREP. COST
Name
Total Cost
Preparation
Gas
Electricity
Water
2.00
0.12
0.11
0.10
TOTAL
2.33
ALLERGIES
Prepared By
Inventory Templates by Spreadsheet123
Approved By
2013 Spreadsheet123 LTD. All rights reserved
Occupation
Inventory Templates by Spreadsheet123
Occupation
2013 Spreadsheet123 LTD. All rights reserved
TOR
11%
52%
38%
Insert a Photo of the Dish
PREPARATION
Inventory Templates by Spreadsheet123
2013 Spreadsheet123 LTD. All rights reserved
Inventory Templates by Spreadsheet123
2013 Spreadsheet123 LTD. All rights reserved
RECIPE COST CALCULATOR
DATE
2/2/2016
DISH NAME
Veg Sandwich
COST DISTRIBUTION
EST. SALE PPRICE
50.00
TOTAL COST
24.34
COST MARGIN
10%
34%
56%
48.68
NET PROFIT
25.66
PRIMARY INGREDIENTS
Product Name
Qty.
Bread
Mayo
Butter
2
0.02
0.01
Cost
(per unit)
5.00
125.00
125.00
TOTAL
Total Cost
10.00
2.50
1.25
Insert a Photo of the Dish
13.75
SECONDARY INGREDIENTS
Product Name
Cucumber
Tomato
Letuce
Seasning
Cheese Slice
Qty
Cost
Gm
Kg/Lt
50
50
10
2
1
TOTAL
20.00
20.00
120.00
30.00
5.00
Total Cost
1.00
1.00
1.20
0.06
5.00
PREPARATION
8.26
UTILITY AND PREP. COST
Name
Total Cost
Preparation
Gas
Electricity
Water
2.00
0.12
0.11
0.10
TOTAL
2.33
ALLERGIES
Prepared By
Inventory Templates by Spreadsheet123
Approved By
2013 Spreadsheet123 LTD. All rights reserved
Occupation
Inventory Templates by Spreadsheet123
Occupation
2013 Spreadsheet123 LTD. All rights reserved
TOR
10%
34%
56%
Insert a Photo of the Dish
PREPARATION
Inventory Templates by Spreadsheet123
2013 Spreadsheet123 LTD. All rights reserved
Inventory Templates by Spreadsheet123
2013 Spreadsheet123 LTD. All rights reserved
RECIPE COST CALCULATOR
DATE
2/2/2016
DISH NAME
Meri Wali Chi
COST DISTRIBUTION
EST. SALE PPRICE
25.00
TOTAL COST
11.02
COST MARGIN
21%
59%
20%
44.08
NET PROFIT
13.98
PRIMARY INGREDIENTS
Product Name
Milk
Sugar
Tea Powder
Qty.
0.1
0.0075
0.0075
Cost
(per unit)
34.00
32.00
380.00
TOTAL
Total Cost
3.40
0.24
2.85
Insert a Photo of the Dish
6.49
SECONDARY INGREDIENTS
Product Name
Ginger
Cardomom
Water
Qty
Cost
Gm
Kg/Lt
15
1
20
TOTAL
60.00
900.00
20.00
Total Cost
0.90
0.90
0.40
PREPARATION
2.20
UTILITY AND PREP. COST
Name
Total Cost
Preparation
Gas
Electricity
Water
2.00
0.12
0.11
0.10
TOTAL
2.33
ALLERGIES
Prepared By
Inventory Templates by Spreadsheet123
Approved By
2013 Spreadsheet123 LTD. All rights reserved
Occupation
Inventory Templates by Spreadsheet123
Occupation
2013 Spreadsheet123 LTD. All rights reserved
TOR
21%
59%
20%
Insert a Photo of the Dish
PREPARATION
Inventory Templates by Spreadsheet123
2013 Spreadsheet123 LTD. All rights reserved
Inventory Templates by Spreadsheet123
2013 Spreadsheet123 LTD. All rights reserved
