B.5. Cost Estimation and Budget Reporting

Question 1

What is the High-Low Points Method used for?

Answer 1

It can be used to estimate and segregate fixed costs from variable costs when only total historical costs are available.

The High-Low Points Method uses the highest and lowest observed activity levels of the cost driver within the relevant range and the costs associated with those values to estimate the breakdown between fixed and variable costs.

Question 2

How can estimated fixed and variable costs be segregated when only total costs are available, using the High-Low Points Method?

Answer 2

Use the highest and lowest observed activity levels of the cost driver within the relevant range and the costs associated with those values to estimate the breakdown between fixed and variable costs.

1. The variable cost per unit of the cost driver used to determine variable costs is calculated as:
   Difference in Associated Costs / Difference in Activity Levels
2. The variable cost per unit of the cost driver is multiplied by the activity level at either the highest or the lowest activity level to calculate the estimated variable cost at that activity level.
3. The estimated fixed cost is calculated as the difference between total costs at that activity level and the estimated variable costs at that activity level.

Question 3

When the estimated total fixed costs and the estimated variable cost per unit of the cost driver are known, what is the formula for the cost function that can be used to calculate total costs at any activity level?

Answer 3

ŷ = a + bx

Where:
ŷ = the predicted total cost
a = estimated fixed cost
b = estimated variable cost per unit
x = activity level, or number of units of the activity

Question 4

What does the symbol ŷ represent in the cost function
ŷ = a + bx?

Answer 4

ŷ represents the predicted total costs at a given activity level

where:
a = estimated fixed cost
b = estimated variable cost per unit
x = activity level, or number of units of the activity

Question 5

What are the assumptions of simple linear regression analysis?

Answer 5

• Variations in the dependent variable are explained by variations in one single independent variable.
• The relationship between the independent variable and the dependent variable is linear.

Question 6

What does the coefficient of correlation of a regression analysis indicate?

Answer 6

The coefficient of correlation is used to evaluate the strength of the relationship between the independent variable and the dependent variable in a regression.

The correlation coefficient expresses how closely related, or correlated, the two variables are, indicating the tendency for the two variables to change together in either the same direction or the opposite direction.

Question 7

What does a correlation coefficient of +1 indicate about a regression?

Answer 7

It indicates a perfect positive (upsloping) linear relationship between each value for x and its corresponding value for y.

• When x increases, y increases by the same proportion.
• When x decreases, y decreases by the same proportion.

Question 8

What is the coefficient of determination of a regression analysis and what does it indicate?

Answer 8

The coefficient of determination is used to evaluate the strength of the relationship between the independent variable and the dependent variable.

The coefficient of determination is the square of the coefficient of correlation, and it indicates the percentage of the total variation in the dependent variable that can be explained by variations in the independent variable.

Question 9

What is the purpose of regression analysis in estimating costs?

Answer 9

Linear regression is a statistical approach that can be used to model the relationship between one or more independent variables and a dependent variable, based on historical data points.

It can be used to estimate the breakdown between fixed and variable costs when only total historical costs are available.

Question 10

What does the constant coefficient in a regression output represent?

Answer 10

The fixed cost or the y-intercept.

Question 11

What does the variable coefficient in a regression output represent?

Answer 11

The variable cost per unit or the x variable.

Question 12

What is a budget variance report?

Answer 12

It compares actual items (revenues, expenses, or units) with budgeted amounts for the same period.

Variance reports are used to identify favorable or unfavorable variances, which can indicate performance relative to the budget.

Question 13

What are the major steps in the control loop for budgeting?

Answer 13

• Establish the budget or standards of performance.
• Measure the actual performance.
• Analyze and compare actual results with the budgeted results (variance reporting).
• Investigate significant and unexpected variances.
• Devise and implement any necessary corrective actions.
• Review and revise the budget or standards if necessary.

Question 14

What is the purpose of variance analysis in budgeting?

Answer 14

It shows management where the differences are between actual and budgeted amounts, enabling management to investigate to determine the reasons for the variances.

Question 15

What is the significance of investigating variances in budgeting?

Answer 15

Both favorable and unfavorable variances should be investigated. Investigating favorable variances can lead to process improvements throughout the organization; and investigating unfavorable variances can enable management to take corrective actions where necessary.

This process is part of the control loop in budgeting.

Question 16

What factors should be considered when determining the significance of variances?

Answer 16

• Magnitude of the variance in proportion to the budget line item.
• Trend of the variance over time.
• Likelihood that an investigation will lead to changes that could eliminate or mitigate future occurrences.