Recipe Project

					16 oz	1.98	0.33
					1 lb	4.14	0.69
					30 oz	6.72	1.12
					16 oz	5.16	0.86
					7 per pieces	0.58	0.09
6 b					12 per bunch	0.99	0.16
					28 oz	1.96	0.32
Total						21.53	3.57

http://www.foodnetwork.com/recipes/giada-de-laurentiis/classic-italian-lasagna-recipe-1941225

You will create an Excel spreadsheet to determine the cost of a food recipe.

Your spreadsheet program must be capable of taking input from current market prices and capable of being increased or decreased for number of servings. Except for the inputs for the current market prices and quantity, all numbers must be calculations (not hard numbers). We will discuss this project in more detail in our chats and I will demonstrate how to do this sort of costing project for you.

1 Your recipe must include at least 5 ingredients that would be considered direct materials.

2 Indirect materials (such as seasonings) can be estimated per serving. This estimate will be a minimal amount (for example, $.02 per serving.

3 You must include an input area for number of servings. This is the key number that will be used to cost out the direct materials. You will also input the current market price for all direct materials. These amounts can be determined by visiting to www.peapod.com. (You must use this site for pricing). Note that these amounts may need to be converted to what is required per the recipe. For example, your recipe may call for one egg. Since you cannot buy just one egg, you would need to input the price for a carton (12 eggs) and then divide that number by 12 to calculate the per egg cost ($.36).

4 Note the number of servings indicated in your recipe. It is typically best to first determine the cost per serving and then use that figure as a multiplier when doing your project.

5 Provide a place at the top of your Excel page for me to input number of servings. The total cost of the recipe must change as a function of my input.

6 Provide a picture (copy and paste from the Web) of the finished product as well as the recipe itself. Dont forget to include the URL for the recipe