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▲
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
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.
- The total flexible
budget variance . Indicate whether this variance was favorable or unfavorable.
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps
Recommended textbooks for you
Excel Applications for Accounting Principles
Accounting
ISBN:
9781111581565
Author:
Gaylord N. Smith
Publisher:
Cengage Learning
Managerial Accounting: The Cornerstone of Busines…
Accounting
ISBN:
9781337115773
Author:
Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:
Cengage Learning
Managerial Accounting
Accounting
ISBN:
9781337912020
Author:
Carl Warren, Ph.d. Cma William B. Tayler
Publisher:
South-Western College Pub
Excel Applications for Accounting Principles
Accounting
ISBN:
9781111581565
Author:
Gaylord N. Smith
Publisher:
Cengage Learning
Managerial Accounting: The Cornerstone of Busines…
Accounting
ISBN:
9781337115773
Author:
Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:
Cengage Learning
Managerial Accounting
Accounting
ISBN:
9781337912020
Author:
Carl Warren, Ph.d. Cma William B. Tayler
Publisher:
South-Western College Pub
Principles of Cost Accounting
Accounting
ISBN:
9781305087408
Author:
Edward J. Vanderbeck, Maria R. Mitchell
Publisher:
Cengage Learning
Cornerstones of Cost Management (Cornerstones Ser…
Accounting
ISBN:
9781305970663
Author:
Don R. Hansen, Maryanne M. Mowen
Publisher:
Cengage Learning
Principles of Accounting Volume 2
Accounting
ISBN:
9781947172609
Author:
OpenStax
Publisher:
OpenStax College