27 Costing Sheets

In this unit we will pull several concepts together in order to learn how to fill out a costing sheet. A costing sheet gives detailed information about how much each ingredient in a recipe costs, and then allows you to figure out how much it costs to make a recipe, as well as how much each individual serving costs. This will allow you to set a price for various items.

In the recipe below, we will look at a recipe for apple cinnamon rolls. The costing sheet lists each ingredient, as well as the weight, volume, or count of that item. By using factor labeling to make conversions, it’s possible to figure out exactly how much each ingredient costs. If the ingredient is produce, you can go on to figure out the edible portion cost. However, if the yield is 100%, you don’t have to do that step.

The costing sheet will give you yield percentages, but you will have to know or look up other conversions. For conversions between volume and weight, you should use the conversion on the chart given here.

Menu Item: Apple Cinnamon Rolls      Number of Servings: 12

Cost per Serving:                                               

Ingredient Recipe Quantity Cost Total Cost
Weight Volume Count APC/Unit Yield Percent EPC/Unit
chopped apples 8 ounces $2.49/pound 76%
milk 1 cup $3.49/gallon 100%
dry yeast LaTeX: \frac{1}{2} ounce $5.00/4 ounces 100%
brown sugar LaTeX: \frac{1}{2} cup $3.49/2 pounds 100%
butter LaTeX: \frac{1}{4} cup $4.98/pound 100%
eggs 3 $2.55/dozen 100%
flour 4 cups $1.76/5 pounds 100%
salt LaTeX: \frac{1}{2} tsp $9.15/4 pounds 100%
sugar LaTeX: \frac{1}{4} cup $4.49/4 pounds 100%
cinnamon 2 tablespoons $10.81/18 ounces 100%
Total Recipe Cost

 

We will fill out this costing sheet one ingredient at a time. We’ll start with chopped apples. The recipe calls for 8 ounces of them. We start with what we are given, 8 ounces chopped apples, and want to move to the pricing. First we have to convert the ounces to pounds, then move to the pricing:

8 ounces chopped apples times (1 pound chopped apples over 8 ounces chopped apples) times ($2.49 over 1 pound apples) equals $1.245

We’ll round to the nearest hundredth, $1.25. However, we’re not done with the apples yet. Now we need to figure out the edible portion cost. Remember that

EPC formula: EPC equals APC divided by yield percent (in decimal form)

Again, we will round to the nearest hundredth: $1.64

Next we have 1 cup milk. We will have to move from cups to gallons before we get to the pricing:

1 cup milk times (1 pint milk over 2 cups milk) times (1 quart milk over 2 pints milk) times (1 gallon milk over 4 quarts milk) times ($3.49 over 1 gallon milk) equals $0.218...

We will round to the nearest hundredth: $0.22

Next we have LaTeX: \frac{1}{2} ounce dry yeast:

1/2 ounce dry yeast times ($5.00 over 4 ounces dry yeast) equals $0.625

We will round to the nearest hundredth: $0.63

Next we have LaTeX: \frac{1}{2} cup brown sugar. We will have to do a volume to weight conversion:

1/2 cup brown sugar times (8 ounces brown sugar over 1 cup brown sugar) times (1 pound brown sugar over 16 ounce brown sugar) times ($3.49 over 2 pounds brown sugar) equals $0.436...

We will round to the nearest hundredth: $0.44

Next we have LaTeX: \frac{1}{4} cup butter, and another volume to weight conversion:

1/4 cup butter times (8 ounces butter over 1 cup butter) times (1 pound butter over 16 ounces butter) times ($4.98 over 1 pound butter) equals $0.0622...

We will round to the nearest hundredth, $0.62

Next we have 3 eggs, which are sold by the dozen, which is 12:

3 eggs times ($2.55 over 12 eggs) equals $0.637...

We will round to the nearest hundredth: $0.64

Next we have 4 cups flour. We will have to do a volume to weight conversion:

4 cups flour times (4 ounces flour over 1 cup flour) times (1 pound flour over 16 ounces flour) times ($1.76 over 5 pounds flour) equals $0.352

We will round to the nearest hundredth: $0.35

Next we have LaTeX: \frac{1}{2} teaspoon salt. We will have to use a volume to weight conversion:

1/2 teaspoon salt times (1 tablespoon salt over 3 teaspoons salt) times (2/3 ounce salt over 1 tablespoon salt) times (1 pound salt over 16 ounces salt) times ($9.15 over 4 pounds salt) equals $0.015

We will round to the nearest hundredth: $0.02

Next we have LaTeX: \frac{1}{4} cup sugar:

1/4 cup sugar time (8 ounces sugar over 1 cup sugar) times (1 pound sugar over 16 ounces sugar) times ($4.49 over 4 pounds sugar) equals $0140...

We will round to the nearest hundredth: $0.14

Finally we have 2 tablespoons cinnamon. We will have to move from volume to weight:

2 tablespoons cinnamon times (1/4 ounce cinnamon over 1 tablespoon cinnamon) times ($10.81 over 18 ounce cinnamon) equals $0.300...

We will round to the nearest hundredth: $0.30

Now we have the total cost for each of the ingredients. Our next step is to add all of the total costs up:

$1.64 + $0.22 + $0.63 + $0.44 + $0.62 + $0.64 + $0.35 + $0.02 + $0.14 + $0.30 = $5 even

Now we know how much it costs to make 12 servings of apple cinnamon rolls. To find out how much it costs to make one serving, simply divide by the number of servings, 12:

$5.00 LaTeX: \div 12 = $0.416 . . . We will round that to the nearest hundredth, $0.42

It costs $0.42 to make one serving of apple cinnamon rolls.

Menu Item: Apple Cinnamon Rolls      Number of Servings: 12

Cost per Serving:                   $ 0.42

Ingredient Recipe Quantity Cost Total Cost
Weight Volume Count APC/Unit Yield Percent EPC/Unit
chopped apples 8 ounces $2.49/pound 76% fraction numerator $ 1.25 over denominator 0.76 end fraction $ 1.64
milk 1 cup $3.49/gallon 100% $ 0.22
dry yeast LaTeX: \frac{1}{2} ounce $5.00/4 ounces 100% $ 0.63
brown sugar LaTeX: \frac{1}{2} cup $3.49/2 pounds 100% $ 0.44
butter LaTeX: \frac{1}{4} cup $4.98/pound 100% $ 0.62
eggs 3 $2.55/dozen 100% $ 0.64
flour 4 cups $1.76/5 pounds 100% $ 0.35
salt LaTeX: \frac{1}{2} teaspoon $9.15/4 pounds 100% $ 0.02
sugar LaTeX: \frac{1}{4} cup $4.49/4 pounds 100% $ 0.14
cinnamon 2 tablespoons $10.81/18 ounces 100% $ 0.30
Total Recipe Cost  $ 5.00

 

This puts an anchor at the top of the page to link to within the page.

This is the Navigation section at the top of the page.

Purpose

To practice filling out a costing sheet.

Outcomes

By completing this assignment, you will be able to…

  1. Find the cost per unit of a particular item by converting weights, volumes, and unit prices with factor labeling.
  2. For conversions between volume and weight, you should use the conversion on the chart given here.
  3. Adjust cost for yield percentage.
  4. Find the total cost of a menu item, as well as the cost per serving.

Instructions

To complete this assignment…

  1. Find the unit cost of each ingredient in the recipe below.
  2. Adjust prices for yield percent, if applicable.
  3. Find the total price of the recipe.
  4. Calculate the price per serving.

 

Tips for Success

To help in the completion of this assignment, make sure to:

  • Pay close attention to the units and convert them to match the cost.
  • Pay attention to yield percents where applicable.

Costing Sheets Assignment

Find the cost values below, numbered 1-10:

Menu Item: Blackberry Pie      Number of Servings: 8

Cost per Serving:  10)                                

Ingredient Recipe Quantity Cost Total Cost
Weight Volume Count APC/Unit Yield Percent EPC/Unit
flour 2LaTeX: \frac{1}{2} cups $5.36/5 pounds 100% 1)
salt 1 teaspoon $1.19/26 ounces 100% 2)
butter 8 ounces $5.29/1 pound 100% 3)
blackberries 144 grams $6.46/16 ounces 92% 4)
sugar LaTeX: \frac{2}{3} cup $7.52/4 pounds 100% 5)
lemon juice 2 tablespoons $7.50/48 fluid ounces 100% 6)
cornstarch 4 tablespoons $3.19/16 ounces 100% 7)
vanilla LaTeX: \frac{1}{2} teaspoon $5.98/2 fluid ounces 100% 8)
Total Recipe Cost 9)

License

Icon for the Creative Commons Attribution 4.0 International License

Bakery and Business Math Copyright © by Eunice Graham is licensed under a Creative Commons Attribution 4.0 International License, except where otherwise noted.

Share This Book