Data Actual Flexible Budget Flexible Sales-Volume Results Variance (2) Budget Variances Static Budget (1) = (1) - (3) (3) (4)=(3)-(5) (5) 12.000 14,000 Units sold Revenue (sales) Variable costs 1,260,000 Direct materials 621,600 Direct manufacturing labor 198,000 Variable manufacturing overhead 130,500 Total variable costs 950,100 Contribution margin 309,900 Fixed costs 285,000 Operating income 24,900 о 1,442,000 720,000 192,000 144,000 1,056,000 386,000 276,000 110,000 Requirement: Using the data above, prepare the flexible budget and relevant variances Steps to develop a flexible budget 1. Identify the actual quantity of output - use that for the flexible budget. 2. Calculate the flexible budget for revenues based on the budgeted selling price and actual quantity of output. 3. Calculate the flexible budget variable costs based on the budgeted variable cost per output unit, actual quantity of output. 4. Calculate the flexible budget fixed costs based on budgeted fixed costs.
Data Actual Flexible Budget Flexible Sales-Volume Results Variance (2) Budget Variances Static Budget (1) = (1) - (3) (3) (4)=(3)-(5) (5) 12.000 14,000 Units sold Revenue (sales) Variable costs 1,260,000 Direct materials 621,600 Direct manufacturing labor 198,000 Variable manufacturing overhead 130,500 Total variable costs 950,100 Contribution margin 309,900 Fixed costs 285,000 Operating income 24,900 о 1,442,000 720,000 192,000 144,000 1,056,000 386,000 276,000 110,000 Requirement: Using the data above, prepare the flexible budget and relevant variances Steps to develop a flexible budget 1. Identify the actual quantity of output - use that for the flexible budget. 2. Calculate the flexible budget for revenues based on the budgeted selling price and actual quantity of output. 3. Calculate the flexible budget variable costs based on the budgeted variable cost per output unit, actual quantity of output. 4. Calculate the flexible budget fixed costs based on budgeted fixed costs.
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
Related questions
Question
![Data
Actual
Flexible Budget
Flexible
Sales-Volume
Results
Variance
(2)
Budget
Variances
Static Budget
(1)
= (1) - (3)
(3)
(4)=(3)-(5)
(5)
12.000
14,000
Units sold
Revenue (sales)
Variable costs
1,260,000
Direct materials
621,600
Direct manufacturing labor
198,000
Variable manufacturing overhead
130,500
Total variable costs
950,100
Contribution margin
309,900
Fixed costs
285,000
Operating income
24,900
о
1,442,000
720,000
192,000
144,000
1,056,000
386,000
276,000
110,000
Requirement: Using the data above, prepare the flexible budget and relevant variances
Steps to develop a flexible budget
1. Identify the actual quantity of output - use that for the flexible budget.
2. Calculate the flexible budget for revenues based on the budgeted selling price and actual
quantity of output.
3. Calculate the flexible budget variable costs based on the budgeted variable cost per output
unit, actual quantity of output.
4. Calculate the flexible budget fixed costs based on budgeted fixed costs.](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F18987d14-b599-45e8-9dc9-899d19616c10%2F1d86f4c8-7173-4ef7-83d4-d278e666c375%2Fwlq8m6r_processed.png&w=3840&q=75)
Transcribed Image Text:Data
Actual
Flexible Budget
Flexible
Sales-Volume
Results
Variance
(2)
Budget
Variances
Static Budget
(1)
= (1) - (3)
(3)
(4)=(3)-(5)
(5)
12.000
14,000
Units sold
Revenue (sales)
Variable costs
1,260,000
Direct materials
621,600
Direct manufacturing labor
198,000
Variable manufacturing overhead
130,500
Total variable costs
950,100
Contribution margin
309,900
Fixed costs
285,000
Operating income
24,900
о
1,442,000
720,000
192,000
144,000
1,056,000
386,000
276,000
110,000
Requirement: Using the data above, prepare the flexible budget and relevant variances
Steps to develop a flexible budget
1. Identify the actual quantity of output - use that for the flexible budget.
2. Calculate the flexible budget for revenues based on the budgeted selling price and actual
quantity of output.
3. Calculate the flexible budget variable costs based on the budgeted variable cost per output
unit, actual quantity of output.
4. Calculate the flexible budget fixed costs based on budgeted fixed costs.
AI-Generated Solution
Unlock instant AI solutions
Tap the button
to generate a solution
Recommended textbooks for you
![FINANCIAL ACCOUNTING](https://compass-isbn-assets.s3.amazonaws.com/isbn_cover_images/9781259964947/9781259964947_smallCoverImage.jpg)
![Accounting](https://www.bartleby.com/isbn_cover_images/9781337272094/9781337272094_smallCoverImage.gif)
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
![Accounting Information Systems](https://www.bartleby.com/isbn_cover_images/9781337619202/9781337619202_smallCoverImage.gif)
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
![FINANCIAL ACCOUNTING](https://compass-isbn-assets.s3.amazonaws.com/isbn_cover_images/9781259964947/9781259964947_smallCoverImage.jpg)
![Accounting](https://www.bartleby.com/isbn_cover_images/9781337272094/9781337272094_smallCoverImage.gif)
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
![Accounting Information Systems](https://www.bartleby.com/isbn_cover_images/9781337619202/9781337619202_smallCoverImage.gif)
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
![Horngren's Cost Accounting: A Managerial Emphasis…](https://www.bartleby.com/isbn_cover_images/9780134475585/9780134475585_smallCoverImage.gif)
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
![Intermediate Accounting](https://www.bartleby.com/isbn_cover_images/9781259722660/9781259722660_smallCoverImage.gif)
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
![Financial and Managerial Accounting](https://www.bartleby.com/isbn_cover_images/9781259726705/9781259726705_smallCoverImage.gif)
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education