Question

Brodrick Company expects to produce 21,600 units for the year ending December 31. A flexible budget...


Brodrick Company expects to produce 21,600 units for the year ending December 31. A flexible budget for 21,600 units of production reflects sales of $626,400; variable costs of $64,800; and fixed costs of $141,000.

QS 08-4 Flexible budget performance report LO P1

Assume that actual sales for the year are $752,500 (27,500 units), actual variable costs for the year are $113,100, and actual fixed costs for the year are $133,000.

Prepare a flexible budget performance report for the year. (Indicate the effect of each variance by selecting for favorable, unfavorable, and no variance.)

Homework Answers

Answer #1
Flexible budget performance report
Flexible budget Actual results variance Favorable/unfavorable
sale 797,500 752,500 45,000 unfavorable
variable expenses 82,500 113,100 30,600 unfavorable
contribution margin 715,000 639,400 14,400 unfavorable
fixed expenses 141,000 133,000 8,000 Favorable
income from operation 574,000 506,000 6,400 unfavorable
Working
sales (626,400/21,600) * 27,500=797,500
variable expenses= (64,800/21,600)*27,500=82,500

Working note

Variance of contribution margin = Sales variance - variable expense variance

Variance of income from operations = contribution margin variance - fixed expense variance

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Brodrick Company expects to produce 21,600 units for the year ending December 31. A flexible budget...
Brodrick Company expects to produce 21,600 units for the year ending December 31. A flexible budget for 21,600 units of production reflects sales of $626,400; variable costs of $64,800; and fixed costs of $141,000. QS 08-3 Flexible budget LO P1 If the company instead expects to produce and sell 27,500 units for the year, calculate the expected level of income from operations.   
Exercise 21-4 Preparing a flexible budget performance report LO P1 Xion Co. budgets a selling price...
Exercise 21-4 Preparing a flexible budget performance report LO P1 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...
Required information [The following information applies to the questions displayed below.]    Brodrick Company expects to...
Required information [The following information applies to the questions displayed below.]    Brodrick Company expects to produce 20,500 units for the year ending December 31. A flexible budget for 20,500 units of production reflects sales of $430,500; variable costs of $61,500; and fixed costs of $144,000. Assume that actual sales for the year are $538,600 (27,600 units), actual variable costs for the year are $113,200, and actual fixed costs for the year are $135,000. Prepare a flexible budget performance report...
Required information [The following information applies to the questions displayed below.]    Brodrick Company expects to...
Required information [The following information applies to the questions displayed below.]    Brodrick Company expects to produce 21,700 units for the year ending December 31. A flexible budget for 21,700 units of production reflects sales of $564,200; variable costs of $65,100; and fixed costs of $143,000. Assume that actual sales for the year are $653,000 (27,000 units), actual variable costs for the year are $113,700, and actual fixed costs for the year are $135,000. Prepare a flexible budget performance report...
QS 23-2 Flexible budget LO P1 Based on predicted production of 24,700 units, a company anticipates...
QS 23-2 Flexible budget LO P1 Based on predicted production of 24,700 units, a company anticipates $220,000 of fixed costs and $271,700 of variable costs. If the company actually produces 20,000 units, what are the flexible budget amounts of fixed and variable costs? ------Flexible Budget------ ------Flexible Budget at ------ Variable Amount per Unit Total Fixed Cost 24,700 units 20,000 units Variable cost Fixed costs Total budgeted costs $0 $0
Exercise 21-3 Preparing a flexible budget performance report LO P1 Solitaire Company’s fixed budget performance report...
Exercise 21-3 Preparing a flexible budget performance report LO P1 Solitaire Company’s fixed budget performance report for June follows. The $300,000 budgeted expenses include $272,000 variable expenses and $28,000 fixed expenses. Actual expenses include $36,500 fixed expenses. Fixed Budget Actual Results Variances Sales (in units) 8,000 10,400 Sales (in dollars) $ 400,000 $ 520,000 $ 120,000 F Total expenses 300,000 364,000 64,000 U Income from operations $ 100,000 $ 156,000 $ 56,000 F Prepare a flexible budget performance report showing...
The master budget at Western Company last period called for sales of 225,000 units at $9...
The master budget at Western Company last period called for sales of 225,000 units at $9 each. The costs were estimated to be $3.75 variable per unit and $225,000 fixed. During the period, actual production and actual sales were 230,000 units. The selling price was $9.10 per unit. Variable costs were $4.50 per unit. Actual fixed costs were $225,000.    Required: Prepare a sales activity variance analysis. (Indicate the effect of each variance by selecting "F" for favorable, or "U"...
Activity-Based Flexible Budgeting Foy Company has a welding activity and wants to develop a flexible budget...
Activity-Based Flexible Budgeting Foy Company has a welding activity and wants to develop a flexible budget formula for the activity. The following resources are used by the activity: Four welding units, with a lease cost of $14,000 per year per unit Six welding employees each paid a salary of $55,000 per year (A total of 12,000 welding hours are supplied by the six workers.) Welding supplies: $400 per job Welding hours: 4 hours used per job During the year, the...
The master budget at Western Company last period called for sales of 226,300 units at $10.3...
The master budget at Western Company last period called for sales of 226,300 units at $10.3 each. The costs were estimated to be $3.88 variable per unit and $226,300 fixed. During the period, actual production and actual sales were 231,300 units. The selling price was $10.40 per unit. Variable costs were $5.80 per unit. Actual fixed costs were $226,300. Required: Prepare a sales activity variance analysis. (Indicate the effect of each variance by selecting "F" for favorable, or "U" for...
Exercise 8-3 Preparing a flexible budget performance report LO P1 Solitaire Company’s fixed budget performance report...
Exercise 8-3 Preparing a flexible budget performance report LO P1 Solitaire Company’s fixed budget performance report for June follows. The $330,000 budgeted expenses include $264,000 variable expenses and $66,000 fixed expenses. Actual expenses include $75,000 fixed expenses. Fixed Budget Actual Results Variances Sales (in units) 8,800 11,200 Sales (in dollars) $ 440,000 $ 560,000 $ 120,000 F Total expenses 330,000 392,000 62,000 U Income from operations $ 110,000 $ 168,000 $ 58,000 F Prepare a flexible budget performance report showing...