You will create an Excel spreadsheet to determine the cost of a food recipe. The recipe must be approved by me. Find a recipe online and post the URL in the project forum. The total cost of the recipe should be reasonable. For example, an angel food cake would not cost $220! I will determine whether your proposal will suit the project requirements. Do not use recipes for cookies, cakes, pies or pizza since these tend to be more difficult to use in a project. Your spreadsheet program must be capable of taking input from current market prices (which would be a hard number) 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. I have posted a sample project in the forum as well. Avoid recipes with many spices (such as Indian food typically has) since costing this type of recipe will be more difficult. If you do not get my approval for the project, you will not receive any points for the work. I urge you to start looking for a recipe right away since the term is short and there is a lot of work to be done. If you want my feedback on your work in progress, post what you've done so far in the project forum (using the same thread you used to submit your proposed recipe and I will provide you with feedback. I will not review every calculation/formula you
You will create an Excel spreadsheet to determine the cost of a food recipe. The recipe must be approved by me. Find a recipe online and post the URL in the project forum. The total cost of the recipe should be reasonable. For example, an angel food cake would not cost $220! I will determine whether your proposal will suit the project requirements. Do not use recipes for cookies, cakes, pies or pizza since these tend to be more difficult to use in a project. Your spreadsheet program must be capable of taking input from current market prices (which would be a hard number) 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. I have posted a sample project in the forum as well. Avoid recipes with many spices (such as Indian food typically has) since costing this type of recipe will be more difficult. If you do not get my approval for the project, you will not receive any points for the work. I urge you to start looking for a recipe right away since the term is short and there is a lot of work to be done. If you want my feedback on your work in progress, post what you've done so far in the project forum (using the same thread you used to submit your proposed recipe and I will provide you with feedback. I will not review every calculation/formula you create but will give you guidance on appearance and whether your project appears to be functioning properly.
- Your recipe must include at least 5 ingredients that would be considered 'direct materials'.
- Indirect materials (such as seasonings) can be estimated per serving. This estimate will be a minimal amount (for example, $.02 per serving. Note that indirect materials would be only a small component of the recipe and will have a very low cost (such as salt). For example, saffron may be used in a small quantity but it can be very expensive.
Trending now
This is a popular solution!
Step by step
Solved in 2 steps
