EXHIBIT 14.1 Comparison of Actual and Budgeted Operating Income SCHMIDT MACHINERY COMPANY Analysis of Operating Income For October 20X1 (1) (2) Actual Operating Income Master Budget (3) Variances Units Sales 780 1,000 220 U* $639,600 100% $ 800,000 100% Variable costs 350,950 55 450,000 56 $ 160,400 U 99,050 F* ** Contribution margin $288,650 45% $ 350,000 44% $ 61,350 U *** Fixed costs 160,650 25 150,000* 19 10,650 U Operating income $128,000 20% $ 200,000 25% $72,000 U *U denotes an unfavorable effect on operating income. **F denotes a favorable effect on operating income. ***Actual fixed factory overhead cost = $130,650; actual fixed selling and administrative costs = $30,000. *Budgeted fixed factory overhead cost = $120,000; budgeted fixed selling and administrative costs = $30,000. Assume that in October 20X1 the Schmidt Machinery Company (Exhibit 14.1) manufactured and sold 950 units for $835 each. During this month, the company incurred $475,000 total variable costs and $180,000 total fixed costs. The master budget data for the month are as given in Exhibit 14.1. Required: 1. Prepare a flexible budget for the production and sale of 950 units. 2. Compute for October 20×1: a. The sales volume variance, in terms of operating income. Indicate whether this variance was favorable or unfavorable. b. The sales volume variance, in terms of contribution margin. Indicate whether this variance was favorable or unfavorable. 3. Compute for October 20×1: a. The total flexible budget variance. Indicate whether this variance was favorable or unfavorable. b. The total variable cost flexible budget variance. Indicate whether this variance was favorable or unfavorable. c. The total fixed cost flexible budget variance. Indicate whether this variance was favorable or unfavorable. d. The selling price variance. Indicate whether this variance was favorable or unfavorable. Answer is complete but not entirely correct. Complete this question by entering your answers in the tabs below. Required 1 Required 2 Required 3 Compute for October 20X1: a. The sales volume variance, in terms of operating income. Indicate whether this variance was favorable or unfavorable. b. The sales volume variance, in terms of contribution margin. Indicate whether this variance was favorable or unfavorable. Sales Volume Variance a. Operating income b. Contribution margin 6969 $ 0 Unfavorable $ 0 Unfavorable Show less▲

Excel Applications for Accounting Principles
4th Edition
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Gaylord N. Smith
Chapter23: Flexible Budgeting (flexbud)
Section: Chapter Questions
Problem 4R
icon
Related questions
Question

Compute the October 20x1

1. The sales volume variance, in terms of operating income. Indicate whether this variance was favorable or unfavorable.

2. The sales volume variance, in terms of contribution margin. Indicate whether this variance was favorable or unfavorable

Compute for October 20x1.

  1. The total flexible budget variance. Indicate whether this variance was favorable or unfavorable.
EXHIBIT 14.1 Comparison of Actual and Budgeted Operating Income
SCHMIDT MACHINERY COMPANY
Analysis of Operating Income
For October 20X1
(1)
(2)
Actual Operating Income
Master Budget
(3)
Variances
Units
Sales
780
1,000
220 U*
$639,600
100%
$ 800,000
100%
Variable costs
350,950
55
450,000
56
$ 160,400 U
99,050 F*
**
Contribution margin
$288,650
45%
$ 350,000
44%
$ 61,350 U
***
Fixed costs
160,650
25
150,000*
19
10,650 U
Operating income
$128,000
20%
$ 200,000
25%
$72,000 U
*U denotes an unfavorable effect on operating income.
**F denotes a favorable effect on operating income.
***Actual fixed factory overhead cost = $130,650; actual fixed selling and administrative costs = $30,000.
*Budgeted fixed factory overhead cost = $120,000; budgeted fixed selling and administrative costs = $30,000.
Transcribed Image Text:EXHIBIT 14.1 Comparison of Actual and Budgeted Operating Income SCHMIDT MACHINERY COMPANY Analysis of Operating Income For October 20X1 (1) (2) Actual Operating Income Master Budget (3) Variances Units Sales 780 1,000 220 U* $639,600 100% $ 800,000 100% Variable costs 350,950 55 450,000 56 $ 160,400 U 99,050 F* ** Contribution margin $288,650 45% $ 350,000 44% $ 61,350 U *** Fixed costs 160,650 25 150,000* 19 10,650 U Operating income $128,000 20% $ 200,000 25% $72,000 U *U denotes an unfavorable effect on operating income. **F denotes a favorable effect on operating income. ***Actual fixed factory overhead cost = $130,650; actual fixed selling and administrative costs = $30,000. *Budgeted fixed factory overhead cost = $120,000; budgeted fixed selling and administrative costs = $30,000.
Assume that in October 20X1 the Schmidt Machinery Company (Exhibit 14.1) manufactured and sold 950 units for $835 each.
During this month, the company incurred $475,000 total variable costs and $180,000 total fixed costs. The master budget data
for the month are as given in Exhibit 14.1.
Required:
1. Prepare a flexible budget for the production and sale of 950 units.
2. Compute for October 20×1:
a. The sales volume variance, in terms of operating income. Indicate whether this variance was favorable or unfavorable.
b. The sales volume variance, in terms of contribution margin. Indicate whether this variance was favorable or unfavorable.
3. Compute for October 20×1:
a. The total flexible budget variance. Indicate whether this variance was favorable or unfavorable.
b. The total variable cost flexible budget variance. Indicate whether this variance was favorable or unfavorable.
c. The total fixed cost flexible budget variance. Indicate whether this variance was favorable or unfavorable.
d. The selling price variance. Indicate whether this variance was favorable or unfavorable.
Answer is complete but not entirely correct.
Complete this question by entering your answers in the tabs below.
Required 1
Required 2
Required 3
Compute for October 20X1:
a. The sales volume variance, in terms of operating income. Indicate whether this variance was favorable or unfavorable.
b. The sales volume variance, in terms of contribution margin. Indicate whether this variance was favorable or unfavorable.
Sales Volume Variance
a. Operating income
b. Contribution margin
6969
$
0
Unfavorable
$
0 Unfavorable
Show less▲
Transcribed Image Text:Assume that in October 20X1 the Schmidt Machinery Company (Exhibit 14.1) manufactured and sold 950 units for $835 each. During this month, the company incurred $475,000 total variable costs and $180,000 total fixed costs. The master budget data for the month are as given in Exhibit 14.1. Required: 1. Prepare a flexible budget for the production and sale of 950 units. 2. Compute for October 20×1: a. The sales volume variance, in terms of operating income. Indicate whether this variance was favorable or unfavorable. b. The sales volume variance, in terms of contribution margin. Indicate whether this variance was favorable or unfavorable. 3. Compute for October 20×1: a. The total flexible budget variance. Indicate whether this variance was favorable or unfavorable. b. The total variable cost flexible budget variance. Indicate whether this variance was favorable or unfavorable. c. The total fixed cost flexible budget variance. Indicate whether this variance was favorable or unfavorable. d. The selling price variance. Indicate whether this variance was favorable or unfavorable. Answer is complete but not entirely correct. Complete this question by entering your answers in the tabs below. Required 1 Required 2 Required 3 Compute for October 20X1: a. The sales volume variance, in terms of operating income. Indicate whether this variance was favorable or unfavorable. b. The sales volume variance, in terms of contribution margin. Indicate whether this variance was favorable or unfavorable. Sales Volume Variance a. Operating income b. Contribution margin 6969 $ 0 Unfavorable $ 0 Unfavorable Show less▲
Expert Solution
steps

Step by step

Solved in 2 steps

Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Excel Applications for Accounting Principles
Excel Applications for Accounting Principles
Accounting
ISBN:
9781111581565
Author:
Gaylord N. Smith
Publisher:
Cengage Learning
Managerial Accounting: The Cornerstone of Busines…
Managerial Accounting: The Cornerstone of Busines…
Accounting
ISBN:
9781337115773
Author:
Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:
Cengage Learning
Managerial Accounting
Managerial Accounting
Accounting
ISBN:
9781337912020
Author:
Carl Warren, Ph.d. Cma William B. Tayler
Publisher:
South-Western College Pub
Principles of Cost Accounting
Principles of Cost Accounting
Accounting
ISBN:
9781305087408
Author:
Edward J. Vanderbeck, Maria R. Mitchell
Publisher:
Cengage Learning
Cornerstones of Cost Management (Cornerstones Ser…
Cornerstones of Cost Management (Cornerstones Ser…
Accounting
ISBN:
9781305970663
Author:
Don R. Hansen, Maryanne M. Mowen
Publisher:
Cengage Learning
Principles of Accounting Volume 2
Principles of Accounting Volume 2
Accounting
ISBN:
9781947172609
Author:
OpenStax
Publisher:
OpenStax College