Calculating Cost Per Unit in Excel

This video tutorial teaches how to calculate the cost per unit in Excel. It covers the process of adding total fixed and variable costs and dividing by the total number of units produced. The tutorial demonstrates using the sum formula to find total costs and provides a step-by-step guide to inputting the formula in Excel to calculate the cost per unit.

What is the main topic discussed in the video?

• Creating pivot tables in Excel

• Using Excel for data analysis

• Calculating cost per unit in Excel

• How to create charts in Excel

Which costs need to be added to calculate the cost per unit?

• Total fixed cost and total production cost

• Total fixed cost and total variable cost

• Total production cost and total sales cost

• Total variable cost and total sales cost

What is the next step after adding total fixed and variable costs to find the cost per unit?

• Add the number of units produced

• Multiply by the number of units produced

• Subtract the number of units produced

• Divide by the total number of units produced

What is the result of dividing the total cost by the number of units produced?

• Total variable cost

• Total production cost

• Total fixed cost

• Cost per unit

Which Excel formula is used to find the total fixed and variable costs?

• AVERAGE

• SUM

• COUNT

• PRODUCT

What is the purpose of using the SUM formula in this context?

• To calculate the average cost

• To find the total fixed and variable costs

• To count the number of units

• To multiply the costs

What is the first step in calculating cost per unit in Excel?

• Type 'equals' followed by an opening bracket

• Select the cell with units produced

• Select the cell with total variable cost

• Press the enter button

After typing 'equals' and an opening bracket, what should you do next?

• Select the cell with total variable cost

• Select the cell with total fixed cost

• Enter the divide sign

• Press the enter button

What arithmetic operation is used after selecting the cell with total fixed cost?

• Subtract

• Multiply

• Add

• Divide

Which cell should be selected after entering the plus sign?

• Cell with total variable cost

• Cell with total sales cost

• Cell with total fixed cost

• Cell with units produced