1 | Flexible Budget | ||||
Units | 920 | ||||
Sales | 736,000 | ||||
variable costs | (412,160) | ||||
Contribution margin | 323,840 | ||||
Fixed costs | (150,000) | ||||
Operating income | 173,840 | ||||
2 | |||||
(a) | Sales volume variance(operating income) = SQ*SP-AQ*SP | ||||
= 1000*800-920*800 | |||||
= 64,000 (Unfavourable) | |||||
(b) | Standard margin = 800-448=352 | ||||
Sales volume variance(Contribution variance) = SQ*SP-AQ*SP | |||||
= 1000*352-920*352 | |||||
= 28,160 (Unfavorable) | |||||
3 | Flexible Budget | Actual | |||
Units | 920 | 920 | |||
Sales | 736,000 | 662,400 | |||
variable costs | (412,160) | (515,200) | |||
Contribution margin | 323,840 | 147,200 | |||
Fixed costs | (150,000) | (180,700) | |||
Operating income | 173,840 | (33,500) | 207,340 | ||
(a) | Total flexible budget variance = 1,73,840 - (-33,500) = 2,07,340 (U) | ||||
(b) | Total Variable cost flexible budget variance = 412,160-515,200 = 103,040 (U) | ||||
(c ) | Total Fixed cost flexible budget variance = 1,50,000 - 1,80,700 = 30,700 (U) | ||||
(d) | Selling price variance = AQ*SP-AQ*AP = 920*800-920*720 = 73,600 (U) |
Comparison of Actual and Budgeted Operating Income EXHIBIT 14.1 SCHMIDT MACHINERY COMPANY Analysis of Operating Income...
Assume that in October 2019 the Schmidt Machinery Company (Exhibit 14.1) manufactured and sold 950 units for $854 each. During this month, the company incurred $380,000 total variable costs and $181,900 total fixed costs. The master (static) 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 2019: a. The sales volume variance, in terms of operating income. Indicate whether this...
EXHIBIT 14.4 Breakdown of Total Operating Income Variance SCHMIDT MACHINERY COMPANY Analysis of Financial Results For October 2019 (2) (3) Flexible-Budget Flexible Variances Budget (1) (4) Sales Volume Variances (5) Master (Static) Budget Actual Units 780 0 780 1,000 Sales Variable costs Contribution margin Fixed costs Operating income $639,600 350,950 $288,650 160,650 $128,000 $15,600F 50F $15,650F 10,650U $ 5,000F $624,000 351,000 $273.000 150,000 $123,000 2200 $176,0000 99,000F $ 77,0000 $800,000 450,000 $350,000 150,000 $200,000 $77,000U Analysis of Total Operating-Income Variance...
EXHIBIT 14.4 Breakdown of Total Operating Income Variance SCHMIDT MACHINERY COMPANY Analysis of Financial Results For October 2019 (1) (2) Flexible-Budget Variances (3) Flexible Budget Sales Volume Variances (5) Master (Static) Budget Actual Units 1,000 Sales Variable costs 7800 780 2200 $639,600 $15,600F $624,000 $176,000U 350,95050F 351,000 99,000F $288,650 $ 77,0000 160,650 10,650U 150,000* 0 $128,000 $ 5,000F $123,000 $ 77,000U Contribution margin Fixed costs $15,650F $273,000 $800,000 450,000 $350,000 150,000 $200,000 Operating income Analysis of Total Operating Income Variance...
#3 only. 14-23 Flexible Budgets; Total Operating Income Variance; Breakdown of the Total Operating Income Variance; Spreadsheet Application The following information is available for Brownstone Products Company for the month of July Units Sales revenue Variable manufacturing costs Fixed manufacturing costs Variable selling and administrative expenses Fixed selling and administrative expenses Actual Master Budget 3.800 4,000 $53,200 $60,000 19.000 16,000 16.000 15,000 7,700 8,000 10.000 9,000 Required 1. What was the total operating income variance for July, rounded to the...
The following information is available for Brownstone Products Company for the month of July: Units Sales revenue Variable manufacturing costs Fixed manufacturing costs Variable selling and administrative expenses Fixed selling and administrative expenses Master Actual Budget 3,900 3,200 $55,800 $60,000 10,900 16,000 12,800 13,800 7,400 8,000 8,800 10,450 Required: 1. What was the total operating income variance for July? (Note: this variance is also called the master (static) budget variance for the period.) Was this variance favorable (F) or unfavorable...
Solid Box Fabrications manufactures boxes for workstations. The firm’s standard cost sheet prior to October of the current year and actual results for October are as follows: Required information {The following information applies to the questions displayed below.] Solid Box Fabrications manufactures boxes for workstations. The firm's standard cost sheet prior to October of the current year and actual results for October are as follows: Budget Information Standard Price and Variable Fixed Costs per Unit Costs Actual Results October 9,500...
#2 only. 14-23 Flexible Budgets; Total Operating Income Variance; Breakdown of the Total Operating Income Variance; Spreadsheet Application The following information is available for Brownstone Products Company for the month of July Units Sales revenue Variable manufacturing costs Fixed manufacturing costs Variable selling and administrative expenses Fixed selling and administrative expenses Actual Master Budget 3.800 4,000 $53.200 $60,000 19.000 16,000 16.000 15,000 7,700 5,000 10,000 9,000 Required 1. What was the total operating income variance for July, rounded to the...
Melton Enterprises manufactures tires for the Formula 1 motor racing circuit. For August 2017, it budgeted to manufacture and sell 3,300 tires at a variable cost of $75 per tire and total fixed costs of $54,500. The budgeted selling price was $111 per tire. Actual results in August 2017 were 3,200 tires manufactured and sold at a selling price of $113 per tire. The actual total variable costs were $265,600. And the actual total fixed costs were $51,000. Requirement 1....
The following information is available for Brownstone Products Company for the month of July: Master Budget Actual Units 4,000 $60, 200 $60,000 16,000 13,900 3,900 Sales revenue Variable manufacturing costs Fixed manufacturing costs Variable selling and administrative expenses Fixed selling and administrative expenses 20,000 14,900 8,700 8,000 10,100 10,000 Required: 1. What was the total operating income variance for July? (Note: this variance is also called the master (static) budget variance for the period.) Was this variance favorable (F) or...
Assume that Schmidt Machinery Company had the standard costs reflected in Exhibit 14.5. In a given month, the company used 3,535 pounds of aluminum to manufacture 937 units. The company paid $29.00 per pound during the month to purchase aluminum. At the beginning of the month, the company had 67 pounds of aluminum on hand. At the end of the month, the company had only 50 pounds of aluminum in its warehouse. Schmidt used 5,400 direct labor hours during the...