standardized recipe project section 2
Ingredient Cost Examples
HRT 276
Solutions for the Excel Workbook:
“SampleRecipeCostingProblem276.xls”
Garlic, fresh, whole,
cloves peeled and minced
- $14.20/box ÷ 5 lb/box = $2.84/lb
- $2.84/lb ÷ 16 oz/lb = $0.178/oz
- 1 head = 2.1 oz/head x $0.178/oz = $0.374/head
- 1 head = 12 cloves
- $0.374/head ÷ 12 cloves/head = $0.031/clove
- A.P. Cost per clove = 0.031
- Yield = “Buy 6, Use 6” = 100.0%
Shallots, fresh, whole,
peeled and minced
- $7.50/box ÷ 5 lb/box = $1.50/lb
- $1.50/lb ÷ 16 oz/lb = $0.094/oz
- Trimmed/cleaned ounce weight per cup = 5.20 oz x $0.094/oz = $0.489/cup
- $0.489/cup ÷ 0.906 = $0.540/cup
- 1 cup = 16 T, so $0.489/cup ÷ 16T/cup = $0.031/T
- A.P. Cost per T = 0.034
- Yield = 90.6% (why?)
Lemon, juice, from one whole lemon,
165 ct. (2T + 1t)
- $26.08/box ÷ 165 count/box = $0.158/lemon
- Trimmed/cleaned ounce weight per AP unit =
1.65 fl oz
- $0.158/lemon ÷ 1.65 fl oz/lemon = $0.096/fl oz
- 1 fl oz = 2 T = 6 t
- $0.096/fl oz ÷ 6 t/fl oz = $0.016/t
- A.P. Cost per t = 0.016
- Yield = 100.0%
Raspberries, IQF
- $29.65/box ÷ 10 lb/box = $2.965/lb
- Number of trimmed/cleaned cups per AP unit = 3.56 cups (AP unit is lb)
- $2.965/lb ÷ 3.56 cups/lb = $0.833/cup
- A.P. Cost per cup = 0.833
- Yield = 100.0%
Beans, kidney, dark red, canned, in water
- $20.34/case ÷ 6 each #10 cans/case
= $3.39/#10 can
- Drained weight per #10 can = 66.8 ounces
- Ounce weight of one cup = 5.45 oz
- $3.39/#10 can ÷ 66.8 oz./can = $0.051/oz
- $0.051/oz x 5.45 oz/cup = $0.278/cup
- A.P. Cost per cup = 0.278
- Yield = 100.0%
Walnuts, shelled, halves and pieces,
chopped
- $39.38/case ÷ 6 lb/case (case: 3 ea./2-lb bags)
= $6.563/lb
- $6.563/lb ÷ 16 oz/lb = $0.410/oz
- Walnuts, chopped = 4.30 oz/cup
- $0.410/oz x 4.30 oz/cup = $1.760/cup
- A.P. Cost per cup = 1.760
- Yield = 100.0%
OR
- Walnuts, chopped = 3.70 cups/lb
- $6.563/lb ÷ 3.70 cup/lb = $1.774/cup
- A.P. Cost per cup = 1.774
- Yield = 100.0%
Sugar, brown, light, packed
- $26.31/bag ÷ 50 lb/bag = $0.526/lb
- $0.526/lb ÷ 16 oz/lb = $0.033/oz
- Brown sugar, packed (light or dark)
= 7.75 oz/cup
- $0.033/oz x 7.75 oz/cup = $0.256/cup
- A.P. Cost per cup = 0.256
- Yield = 100.0%
Sugar, granulated, beet
- $25.45/bag ÷ 50 lb/bag = $0.509/lb
- $0.509/lb ÷ 16 oz/lb = $0.032/oz
- Sugar, granulated (beet or cane)
= 7.10 oz/cup
- $0.032/oz x 7.10 oz/cup = $0.227/cup
- A.P. Cost per cup = 0.227
- Yield = 100.0%
Mayonnaise, whole egg
- $22.84/pail ÷ 30 lb/pail = $0.761/lb
- $0.761/lb ÷ 16 oz/lb = $0.048/oz
- Mayonnaise = 7.60 oz/cup
- $0.048/oz x 7.60 oz/cup = $0.365/cup
- A.P. Cost per cup = 0.365
- Yield = 100.0%
Rum, Bacardi, light
- $18.33/L ÷ 33.8 fl oz/L = $0.542/fl oz
- 1 cup = 8 fl oz
- $0.542/fl oz x 8 fl oz/cup = $4.336/cup
- A.P. Cost per cup = 4.336
- Yield = 100.0%
Milk, 2%, (1T + 2t)
- $6.50/gal ÷ 128 fl oz/gal = $0.051/fl oz
- 1 fl oz = 2 T = 6 t
- $0.051/fl oz ÷ 6 t/fl oz = $0.009/t
- A.P. Cost per t = 0.009
- Yield = 100.0%
Eggs, whole, grade A, large,
whites only
- You still need to buy 8 eggs to get 8 whites, so how much does one egg cost?
- $20.45/case ÷ 15 dozen/case = $1.363/dozen
- $1.363/dozen ÷ 12 eggs/dozen = $0.114/egg
- A.P. Cost per t = 0.114
- Yield = 100.0%