113k views
0 votes
Xion Co. budgets a selling price of $81 per unit, variable costs of $34 per unit, and total fixed costs of $280,000. During June, the company produced and sold 11,800 units and incurred actual variable costs of $361,000 and actual fixed costs of $295,000. Actual sales for June were $985,000. Prepare a flexible budget report showing variances between budgeted and actual results. List variable and fixed expenses separately. (Indicate the effect of each variance by selecting for favorable, unfavorable, and no variance)

2 Answers

3 votes

Final answer:

The flexible budget report shows variances between the budgeted and actual results for Xion Co. The variances for variable and fixed expenses are calculated separately. The variable expenses had an unfavorable variance of $1,000, while the fixed expenses had a favorable variance of $15,000.

Step-by-step explanation:

The flexible budget report shows variances between the budgeted and actual results for Xion Co. Given that the company budgeted a selling price of $81 per unit, variable costs of $34 per unit, and total fixed costs of $280,000, the actual results for June were 11,800 units sold, actual variable costs of $361,000, and actual fixed costs of $295,000. The actual sales for June were $985,000. Let's calculate the variances:

Variable Expenses:

Total budgeted variable costs = Budgeted units x Budgeted variable cost per unit = 11,800 x $34 = $401,200

Total actual variable costs = Actual units x Actual variable cost per unit = 11,800 x $34 = $400,200

Variance = Total actual variable costs - Total budgeted variable costs = $400,200 - $401,200 = -$1,000 (unfavorable variance)

Fixed Expenses:

Total budgeted fixed costs = $280,000

Total actual fixed costs = $295,000

Variance = Total actual fixed costs - Total budgeted fixed costs = $295,000 - $280,000 = $15,000 (favorable variance)

Therefore, the variable expenses had an unfavorable variance of $1,000, and the fixed expenses had a favorable variance of $15,000.

User Zach Mast
by
4.3k points
3 votes

Answer and Explanation:

The preparation of the flexible budget is presented below:

Particulars Flexible budget Actual Variance Fav/Unfav

Sales revenue $955,800 $985,000 $29,200 Fav

(11,800 × $81)

Less:

variable cost $401,200 $361,000 $40,200 unfav

(11,800 × $34)

Contribution margin $554,600 $624,000 $69,400 fav

Less:

Fixed cost $280,000 $295,000 $15,000 unfav

Operating income $274,600 $329,000 $54,400

We simply applied the below formula

Operating income = Sales - variable cost - fixed cost

User Sean Cavanagh
by
4.2k points