Excel Recipe Cost Calculation

This video tutorial guides viewers through setting up an Excel sheet for recipe costing. It covers listing ingredients, their purchase quantities, and costs. The tutorial explains how to use formulas to calculate the cost of ingredients needed for a recipe, determine the total recipe cost, and calculate the cost per serve. Finally, it demonstrates how to tidy up the Excel sheet for presentation.

What is the purpose of the first cell (A1) in the Excel sheet?

• To input the recipe name

• To display the purchase quantity

• To list the ingredients

• To calculate the total cost

Why is it important to measure ingredients like bicarb soda and mixed spice?

• To ensure the recipe tastes good

• To accurately calculate the cost

• To save time during cooking

• To make the recipe look appealing

Which formula is used to calculate the cost of an ingredient in the recipe?

• D4 * B4 / C4

• D4 + B4 * C4

• D4 / B4 + C4

• D4 / B4 * C4

How can you quickly apply the cost calculation formula to all ingredients?

• By typing the formula in each cell

• By using the copy and paste function

• By re-entering the data

• By dragging the formula down the column

What is the total cost of the recipe after rounding to two decimal places?

• $9.15

• $9.13

• $9.12

• $9.14

Why is it beneficial to calculate the cost per serving?

• To improve the taste of the recipe

• To determine the nutritional value

• To reduce the number of ingredients

• To understand the cost efficiency

How do you calculate the cost per serving in the Excel sheet?

• Divide the total cost by the number of servings

• Multiply the total cost by the number of servings

• Subtract the number of servings from the total cost

• Add the number of servings to the total cost

What is the cost per serving for the choc chip slice?

• $0.77

• $0.76

• $0.75

• $0.78

What is one way to ensure the Excel sheet is neat and tidy?

• Add extra columns for decoration

• Highlight all cells in yellow

• Use different fonts for each column

• Centralize the text in each column

What should you do if you want to change the width of a column?

• Double-click the column header

• Drag the column border

• Right-click and select 'Insert'

• Press the 'Delete' key