Overview
Download the Excel spreadsheet that has the recipe for a Minestrone soup here. Writing formulas in Excel, you will
- calculate out the EP Cost (per quantity unit that the recipe calls for) for each ingredient
- calculate the recipe cost for each of the ingredients
- number of cost per portion
- menu price
- profit margin
Each cell calculation is worth 0.3 points. After you are done with the spreadsheet, please upload to the assignment. You can upload multiple times if you feel like you want to correct things after having submitted once. I will consider only the final upload unless you tell me otherwise.
If you don't write formulas, and use a calculator and give me the answers without showing your math in Excel, you will collect ONLY 50% of the points available, provided that your answer is 100% accurate. One wrong decimal and you will get zero percent of the grade, since I have no idea how you arrive at the number.
The formulas for what you need to calculate are provided either as tips or in parenthesis near the fields.