Question

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 effect of each variance by selecting for favorable, unfavorable, and no variance)

Homework Answers

Answer #1

  FLEXIBLE BUDGET

flexible budget actual variance favourable or unfavourable
production 11800 11800
sales 955800 985000 29200 favourable
variable cost 401200 361000 40200 favourable
fixed cost 280000 295000 (15000) unfavourable

notes:

1. fixed cost for flexible budget is same as budgeted fixed cost and actual fixed cost is given in the question.

2. budgeted variable cost = 11800/34 = $401200 and actual variable cost is given.

3. budgeted sales = 81x 11800 = $955800 and actual sales is given.

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
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...
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...
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...
Exercise 8-2 Preparing flexible budgets LO P1 Tempo Company's fixed budget (based on sales of 18,000...
Exercise 8-2 Preparing flexible budgets LO P1 Tempo Company's fixed budget (based on sales of 18,000 units) for the first quarter of calendar year 2017 reveals the following. Fixed Budget Sales (18,000 units) $ 3,744,000 Cost of goods sold Direct materials $ 414,000 Direct labor 774,000 Production supplies 486,000 Plant manager salary 214,000 1,888,000 Gross profit 1,856,000 Selling expenses Sales commissions 126,000 Packaging 252,000 Advertising 100,000 478,000 Administrative expenses Administrative salaries 264,000 Depreciation—office equip. 234,000 Insurance 204,000 Office rent 214,000...
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
Serial Problem Business Solutions LO P1 Business Solutions's second-quarter 2020 fixed budget performance report for its...
Serial Problem Business Solutions LO P1 Business Solutions's second-quarter 2020 fixed budget performance report for its computer furniture operations follows. The $161,230 budgeted expenses include $109,600 in variable expenses for desks and $18,630 in variable expenses for chairs, as well as $33,000 fixed expenses. The actual expenses include $34,300 fixed expenses. List fixed and variable expenses separately. Fixed Budget Actual Results Variances Desk sales (in units) 137 143 Chair sales (in units) 69 77 Desk sales $ 172,620 $ 178,750...
Exercise 10-4 a-b (Video) Myers Company uses a flexible budget for manufacturing overhead based on direct...
Exercise 10-4 a-b (Video) Myers Company uses a flexible budget for manufacturing overhead based on direct labor hours. Variable manufacturing overhead costs per direct labor hour are as follows. Indirect labor $1.10 Indirect materials 0.70 Utilities 0.40 Fixed overhead costs per month are Supervision $4,100, Depreciation $2,000, and Property Taxes $500. The company believes it will normally operate in a range of 7,100–12,800 direct labor hours per month. Assume that in July 2020, Myers Company incurs the following manufacturing overhead...
Bay City Company’s fixed budget performance report for July follows. The $594,000 budgeted total expenses include...
Bay City Company’s fixed budget performance report for July follows. The $594,000 budgeted total expenses include $450,000 variable expenses and $144,000 fixed expenses. Actual expenses include $134,000 fixed expenses. Fixed Budget Actual Results Variances Sales (in units) 8,100 7,000 Sales (in dollars) $ 648,000 $ 623,000 $ 25,000 U Total expenses 594,000 556,000 38,000 F Income from operations $ 54,000 $ 67,000 $ 13,000 U Prepare a flexible budget performance report that shows any variances between budgeted results and actual...
Business Solutions's second-quarter 2018 fixed budget performance report for its computer furniture operations follows. The $171,510...
Business Solutions's second-quarter 2018 fixed budget performance report for its computer furniture operations follows. The $171,510 budgeted expenses include $122,310 in variable expenses for desks and $16,200 in variable expenses for chairs, as well as $33,000 fixed expenses. The actual expenses include $34,300 fixed expenses. List fixed and variable expenses separately. Fixed Budget Actual Results Variances Desk sales (in units) 151 157 Chair sales (in units) 60 68 Desk sales $ 197,810 $ 204,100 $ 6,290 F Chair sales 30,600...
Exercise 9-14 Prepare a Flexible Budget Performance Report [LO9-4] Lavage Rapide is a Canadian company that...
Exercise 9-14 Prepare a Flexible Budget Performance Report [LO9-4] Lavage Rapide is a Canadian company that owns and operates a large automatic car wash facility near Montreal. The following table provides data concerning the company’s costs: Fixed Cost per Month Cost per Car Washed Cleaning supplies $ 0.40 Electricity $ 1,400 $ 0.10 Maintenance $ 0.20 Wages and salaries $ 4,200 $ 0.30 Depreciation $ 8,300 Rent $ 1,900 Administrative expenses $ 1,500 $ 0.03 For example, electricity costs are...