IM 7.9.2 Lesson: Costs of Running a Restaurant

Record what the cell displays. Make sure to type each formula exactly as it is written here.

Predict what will happen if you type the formula =A1*C1 into cell C2 of your spreadsheet. Go back and type in the formula, and press enter to check your prediction.

Predict what will happen next if you delete the formula in cell A1 and replace it with the number 100. Go back and replace the formula with the number, and press enter to check your prediction.

Predict what will happen if you copy cell C2 and paste it into cell D2 of your spreadsheet. Go back and copy and paste the formula to check your prediction.

1. Type the information about the ingredients in your recipe into the first 3 columns of the spreadsheet.
2. Type a formula into cell D2 to automatically calculate the amount per serving for your first ingredient.
3. Copy cell D2 and paste it into the cells beneath it to calculate the amount per serving for the rest of your ingredients. Pause here so your teacher can review your work.
4. Research the cost of each ingredient in your meal, and record the information in columns E, F, and G.
5. Type a formula into cell H2 to automatically calculate the cost per purchase unit for your first ingredient.
6. Copy cell H2, and paste it into the cells beneath it to calculate the cost per purchase unit for the rest of your ingredients.
7. Complete column I with how many of your recipe unit are in 1 of your purchase unit for each ingredient. For example, if your recipe unit was cups and your purchase unit was gallons, then your conversion would be 16 because there are 16 cups in 1 gallon.
8. Type a formula into cell J2 to calculate the cost per recipe unit for your first ingredient.
9. Type a formula into cell K2 to calculate the cost per serving for your first ingredient.
10. Compare formulas with your partner. Discuss your thinking. If you disagree, work to reach an agreement.
11. Copy cells J2 and K2, and paste them into the cells beneath them to calculate the cost per recipe unit and cost per serving for the rest of your ingredients.
12. Type a formula into the first empty cell below your last ingredient in column K to calculate the total cost per serving for all of the ingredients in your recipe. Record the answer here.