Question

In: Accounting

Static and Flexible Budgets Graham Corporation used the following data to evaluate its current operating system....

Static and Flexible Budgets Graham Corporation used the following data to evaluate its current operating system.

The company sells items for $10 each and used a budgeted selling price of $10 per unit. Actual Budgeted Units sold 1,482,000 1,500,000 Variable costs 2,815,000 3,000,000 Fixed costs 2,490,000 2,425,000 a. Prepare the actual income statement, flexible budget, and static budget. Do not use negative signs with any of your answers below. Actual Results Flexible Budget Static Budget Units sold Answer Answer Answer Revenues Answer Answer Answer Variable costs Answer Answer Answer Contribution margin Answer Answer Answer Fixed costs Answer Answer Answer Operating income Answer Answer Answer For questions b., c., and d., do not use negative signs with your answers. Select either U for Unfavorable or F for Favorable using the drop down box next to each of your variance answers. b. What is the static-budget variance of revenues? $Answer Answer c. What is the flexible budget variance for variable costs? $Answer Answer d. What is the flexible budget variance for fixed costs? $Answer Answer

Solutions

Expert Solution

Answer :-

a) The actual income statement, flexible budget, and static budget -

Actual Budget Flexible Budget Static Budget
Unit Sold 1,482,000 1,482,000 1,500,000
Selling Price $10 $10 $10

Revenues (Unit sold × Selling Price)

$14,820,000 $14,820,000 $15,000,000
Variable costs $2,815,000

$2,964,000

(Note -1)

$3,000,000
Contribution margin ( Revenue - variable cost) $12,005,000 $11,856,000 $12,000,000
Fixed costs $2,490,000

$2,425,000

(Remain same as static budget)

$2,425,000

Operating income (Contribution Margin - Fixed costs)

$9,515,000 $9,431,000

$9,575,000

Note 1 :-

Variable cost for Flexible Budget are as follows :-

Variable cost for Flexible Budget = (Static Budgeted variable cost / Static Budget Unit sold ) × Flexible Budget unit sold

Static Budgeted variable cost = $3,000,000

Static Budget Unit sold = 1,500,000 units

Flexible Budget unit sold = 1,482,000 units

Variable cost for Flexible Budget = ($3,000,000 / 1,500,000 units ) × 1,482,000 units

Variable cost for Flexible Budget = $2,964,000

b)The static-budget variance of revenues are as follows -

Static budget variance of revenues = Static budgeted revenue - Actual revenue

Static Budgeted revenue = $15,000,000

Actual revenue = $14,820,000

Static budget variance of revenues =$15,000,000 - $14,820,000

Static Budget variance of revenue = $180,000 U

c)The flexible budget variance for variable cost are as follows :-

Flexible budget variance for variable cost = Flexible budgeted variable cost - Actual variable cost

Flexible budgeted variable cost = $2,490,000

Actual variable cost = $ 2,435,000

Flexible budget variance for variable cost = $2,490,000 - $2,425,000

Flexible Budget variance for variable cost = $149,000 F

d) The flexible budget variance for fixed costs are as follows -

Flexible budget variance for fixed costs = Actual Fixed cost - Flexible budgeted Fixed cost

Actual Fixed cost = $2,490,000

Flexible Budgeted Fixed Cost = $2,425,000

Flexible budget variance for fixed costs = $2,490,000 - $2,425,000

Flexible budget variance for fixed costs = $65,000 U


Related Solutions

Static and Flexible Budgets Graham Corporation used the following data to evaluate its current operating system....
Static and Flexible Budgets Graham Corporation used the following data to evaluate its current operating system. The company sells items for $10 each and used a budgeted selling price of $10 per unit. Actual Budgeted Units sold 991,000 1,000,000 Variable costs 1,280,000 1,500,000 Fixed costs 955,000 905,000 a. Prepare the actual income statement, flexible budget, and static budget. Do not use negative signs with any of your answers below. Actual Results Flexible Budget Static Budget Units sold Answer Answer Answer...
Static and Flexible Budgets Graham Corporation used the following data to evaluate its current operating system....
Static and Flexible Budgets Graham Corporation used the following data to evaluate its current operating system. The company sells items for $10 each and used a budgeted selling price of $10 per unit. Actual Budgeted Units sold 794,000 800,000 Variable costs 1,745,000 2,000,000 Fixed costs 1,420,000 1,375,000 a. Prepare the actual income statement, flexible budget, and static budget. Do not use negative signs with any of your answers below. Actual Results Flexible Budget Static Budget Units sold Answer Answer Answer...
Flexible budgets vs static budgets What is the difference between an flexible budget and a static...
Flexible budgets vs static budgets What is the difference between an flexible budget and a static budget? What is a flexible budget? (6 senteces or more)
Stampede Corporation, a Calgary based steak house, used the following data to evaluate their current operating...
Stampede Corporation, a Calgary based steak house, used the following data to evaluate their current operating system. The company sells items for $20 each and used a budgeted selling price of $20 per unit. Actual Budgeted Units Sold 200,000units 203,000 Variable Costs 1,250,000 1,500,000 Fixed Costs 925,000 900,000 Required: 1) Prepare a Level 1 static-budget variance analysis for Stampede Corporation using an income statement in contribution margin format. Use the following three column headings: Actual Results, Static Budget, and Static-budget...
Discuss the preference for the use of Flexible Budgets instead of Static Budgets
Discuss the preference for the use of Flexible Budgets instead of Static Budgets
HammerTime is preparing their 2019 budget. They want to look at static budgets and flexible budgets...
HammerTime is preparing their 2019 budget. They want to look at static budgets and flexible budgets to determine which is best for them. They estimate sales/production will be between 2,000,000 and 4,000,000 boxes of nails per month. They want to be able to understand their budget variances as well. Question 1: Prepare some budgets in Excel for HammerTime. a) Show the static budget based on 3,000,000 units (boxes) produced. b) Show the flexible budget based on 2,000,000 units (boxes) produced....
4. What are the differences between fixed (static) and flexible budgets?
4. What are the differences between fixed (static) and flexible budgets?
Question 1 Distinguish between static and flexible budgets and explain the advantages of using a flexible...
Question 1 Distinguish between static and flexible budgets and explain the advantages of using a flexible budget for control, compared with using a static budget.
You learned Static (fixed) Budgets in chapter 7, Flexible Budgets and Standard Costs (favorable & unfavorable...
You learned Static (fixed) Budgets in chapter 7, Flexible Budgets and Standard Costs (favorable & unfavorable variances) in chapter 8; Now describe an example of how an unfavorable variance between actual and budget amounts in a fixed static (master) budget can become a favorable variance in a flexible budget report. Also, since flexible budget is more accurate in measuring performance, can company just develop flexible budget without the static budget? Why or why not?
Robinson Corporation manufactures embroidered jackets. The company prepares flexible budgets and uses a standard cost system...
Robinson Corporation manufactures embroidered jackets. The company prepares flexible budgets and uses a standard cost system to control manufacturing costs. The following standard unit cost of a jacket is based on the static budget volume of 15,000 jackets per month. Direct materials (3.0 sq. ft x $5.00 per sq. ft.) $15.00 Direct labor (2 hours x $12.00 per hour) 24.00 Manufacturing overhead: -Variable (2 hours x @$1.00 per hour) $2.00 -Fixed (2 hours x $3.00 per hour) 6.00 Total cost...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT