Question

In: Accounting

Assume that in October 2019 the Schmidt Machinery Company manufactured and sold 900 units for $710...

Assume that in October 2019 the Schmidt Machinery Company manufactured and sold 900 units for $710 each. During this month, the company incurred $387,000 total variable costs and $180,500 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 900 units. 2. Compute for October 2019: a. The sales volume variance, in terms of operating income. Indicate whether this variance was favorable (F) or unfavorable (U). b. The sales volume variance, in terms of contribution margin. Indicate whether this variance was favorable (F) or unfavorable (U). 3. Compute for October 2019: a. The total flexible-budget (FB) variance. Indicate whether this variance was favorable (F) or unfavorable (U). b. The total variable cost flexible-budget variance. Indicate whether this variance was favorable (F) or unfavorable (U). c. The total fixed cost flexible-budget (FB) variance. Indicate whether this variance was favorable (F) or unfavorable (U). d. The selling price variance. Indicate whether this variance was favorable (F) or unfavorable (U).

Given

Machinery Co.
	actual op. income	master budget	variances
units	780	1000	220 unfavorable
sales	639600 @100%	800,000 @100%	160400 unfavorable
variable costs.	350950 @55%	450,000 @56%	99,050 favorable
contribution margin	288650 @45%	350,000 @ 44%	61,350 unfavorable
fixed costs	160650 @25	150,000 @19%	10,650 unfavorable
operating income	128,000 @20%	200,000 @25%	72,000 unfavorable

actual fixed OH cost =$130,650

actual fixed selling and admin costs= $30,000

budgeted fixed factory OH costs =$120,000

budgeted fixed selling and admin costs=$30,000

1. fill in blanks

Prepare a flexible budget for the production and sale of 900 units.

unit sold
sales

	$

	$

Compute for October 2019:

a. The sales volume variance, in terms of operating income. Indicate whether this variance was favorable (F) or unfavorable (U).

b. The sales volume variance, in terms of contribution margin. Indicate whether this variance was favorable (F) or unfavorable (U).

Compute for October 2019:

a. The total flexible-budget (FB) variance. Indicate whether this variance was favorable (F) or unfavorable (U).

b. The total variable cost flexible-budget variance. Indicate whether this variance was favorable (F) or unfavorable (U).

c. The total fixed cost flexible-budget (FB) variance. Indicate whether this variance was favorable (F) or unfavorable (U).

d. The selling price variance. Indicate whether this variance was favorable (F) or unfavorable (U).

Solutions

Expert Solution

1. Prepare a flexible budget for the production and sale of 900 units

standard Price per = Cost / unit

Units sold and produced 1000

Sales = 800000

Standard Selling price = 800000 / 1000 = 800

Variable Costs 450000

Standard Variable Costs per units = 450000 / 1000 = 450

Flexible Budget @ 900 unnits
Units	900
sales ( 900 units * 800 )	$720000
Variable cost ( 450 * 900 units)	405000
Contribution margin	$315000
Fixed cost	150000
Operating income	$165000

Compute for October 2019:

a. The sales volume variance, in terms of operating income. Indicate whether this variance was favorable (F) or unfavorable (U).

Sales Volume variance (Operating Income) = Flexible Budget Operating Income – Master Budget Operating

Income

Flexible Budget Operating Income @ 900 units = $165000

Less: Master Budget Operating Income (Static ) = $200000

Sales Volume variance (Operating Income) = $35000 - (U)

b. The sales volume variance, in terms of contribution margin. Indicate whether this variance was favorable (F) or unfavorable (U).

Sales Volume variance (Contribution margin) = Flexible Budget Contribution Margin – Master Budget Contribution

Flexible Budget Contribution Margin = $315000

Less: Master Budget Contribution = $350000

Sales Volume variance (Contribution margin) = $35000 (U)

Compute for October 2019:

a. The total flexible-budget (FB) variance. Indicate whether this variance was favorable (F) or unfavorable (U).

Prepare actual budget @900 units

Company manufactured and sold 900 units for $710 each.

During this month, the company incurred $387,000 total variable costs and $180,500 total fixed costs.

Actual Budget @ 900 unnits
Units	900
sales ( 900 units * 710 )	$639000
Variable cost ( 900 units)	387000
Contribution margin	$252000
Fixed cost	180500
Operating income	$71500

Total Flexible Budget Variance= Actual Operating Income-Flexible Budget Operating Income

Actual Operating Income = $71500

Less: lexible Budget Operating Income = $165000

Total Flexible Budget Variance= 71500 - 165000 = $93500 (U)

b. The total variable cost flexible-budget variance. Indicate whether this variance was favorable (F) or unfavorable (U).

Total Variable Cost Flexible-Budget Variance = Actual Variable Cost - Flexible Budget Variable Cost

Actual Variable Cost = $387000

Flexible Budget Variable Cost = $405000

Total Variable Cost Flexible-Budget Variance = 387000 - 405000 = 18000 (F)

c. The total fixed cost flexible-budget (FB) variance. Indicate whether this variance was favorable (F) or unfavorable (U).

Total Fixed Cost flexible Budget variance = Actual Fixed Costs – Flexible Budget Fixed Costs

Actual Fixed Costs = $180500

Flexible Budget Fixed Costs = $150000

Total Fixed Cost flexible Budget variance = 180500 - 150000 = 30500 (U)

d. The selling price variance. Indicate whether this variance was favorable (F) or unfavorable (U).

Selling Price Variance = Actual Sales Revenue – Flexible Budget Sales revenue

Actual Sales Revenue = $639000

Flexible Budget Sales revenue = $720000

Selling Price Variance = 639000 - 720000 = 81000 (U)

ekkarill92 answered 2 years ago

Next > < Previous

Related Solutions

On October 1, 2018, Bullseye Company sold 250,000 gallons of diesel fuel to Schmidt Co. at...

On October 1, 2018, Bullseye Company sold 250,000 gallons of diesel fuel to Schmidt Co. at $3 per gallon. On November 8, 2018, 150,000 gallons were delivered; on December 27, 2018. Another 50,000 gallons were delivered; and on January 15, 2019, the remaining 50,000 gallons were delivered. Payment terms are 10% due on October 1, 2018, 50% due on first Delivery; 20% due on the next delivery; and the remaining 20% due on final delivery. 1. Do each of the...

Crane Company uses a periodic inventory system. For October, when the company sold 1,690 units, the...

Crane Company uses a periodic inventory system. For October, when the company sold 1,690 units, the following information is available. Units Unit Cost Total Cost October 1 inventory 580 $22 $12,760 October 8 purchase 1,160 23 26,680 October 25 purchase 580 26 15,080 2,320 $54,520 Compute the October 31 inventory and the October cost of goods sold using the FIFO method. Ending inventory $enter the ending inventory in dollars Cost of goods sold $enter the cost of goods sold in...

Brassard Company manufactured 1,500 units of its only product during 2019. The inputs for this production...

Brassard Company manufactured 1,500 units of its only product during 2019. The inputs for this production are as follows: 450 pounds of Raw Material G at $1.50 per pound 300 pounds of Raw Material H at cost of $2,75 per pound 300 direct labor hours at $20 per hour The firm manufactured 1,800 units of the same product in 2017 with the following inputs: 500 pounds of Raw Material G at a cost of $1,20 per pound 360 pounds of...

Assume the following information for a company that produced 10,000 units and sold 8,000 units during...

Assume the following information for a company that produced 10,000 units and sold 8,000 units during its first year of operations and produced 8,000 units and sold 10,000 units during its second year of operations: Per Unit Per Year Selling price $ 200 Direct materials $ 82 Direct labor $ 50 Variable manufacturing overhead $ 10 Sales commission $ 8 Fixed manufacturing overhead $ 300,000 Using absorption costing, what is the cost of goods sold for the second year of...

Marano Corporation produces and sells a single product. In October, the company sold 1,000 units. Its...

Marano Corporation produces and sells a single product. In October, the company sold 1,000 units. Its total sales were $156,000, its total variable expenses were $79,000, and its total fixed expenses were $55,900. a. Construct the company's contribution format income statement for October. (Do not round intermediate calculations.) b. Redo the company's contribution format income statement assuming that the company sells 900 units. (Do not round intermediate calculations.)

Marano Corporation produces and sells a single product. In October, the company sold 2,000 units. Its...

Marano Corporation produces and sells a single product. In October, the company sold 2,000 units. Its total sales were $148,000, its total variable expenses were $78,900, and its total fixed expenses were $55,800. Required: a. Construct the company's contribution format income statement for October. (Do not round intermediate calculations.) Net Operating Income: b. Redo the company's contribution format income statement assuming that the company sells 1,900 units.(Do not round intermediate calculations.) Net Operating Income:

Carlson Automotive Company manufactures fuel-injection systems. It manufactured and sold 60,000 units in 2018 and 64,000...

Carlson Automotive Company manufactures fuel-injection systems. It manufactured and sold 60,000 units in 2018 and 64,000 units in 2019 at $25 per unit. In 2018, the firm used 75,000 pounds of alloy TPX–45 at $7.20 per pound and used 10,000 direct labor hours at an hourly wage rate of $30. In 2019, the firm used 89,600 pounds of alloy TPX–45 at $6.80 per pound and used 10,847 direct labor hours at an hourly wage rate of $32. The total amount...

Graczyk Company uses a periodic inventory system. During October, it sold 360 units of Product Z....

Graczyk Company uses a periodic inventory system. During October, it sold 360 units of Product Z. Its beginning inventory and purchases during the month were as follows: Oct. 1 Beginning inventory 100 units @ $20 5 Purchases 100 units @ $24 10 Purchases 100 units @ $22 15 Purchases 100 units @ $24 20 Purchases 100 units @ $28 25 Purchases 100 units @ $26 Compute the cost of goods sold under each of three methods: (a) average-cost, (b) LIFO,...

Columbia Products produced and sold 900 units of the company’s only product in March. You have...

Columbia Products produced and sold 900 units of the company’s only product in March. You have collected the following information from the accounting records: Sales price (per unit) $ 448 Manufacturing costs: Fixed overhead (for the month) 50,400 Direct labor (per unit) 35 Direct materials (per unit) 112 Variable overhead (per unit) 70 Marketing and administrative costs: Fixed costs (for the month) 67,500 Variable costs (per unit) 14 Required Compute: Variable manufacturing cost per unit. Full cost per unit. Variable...

Harris Corporation produces a single product. Last year, Harris manufactured 30,420 units and sold 24,900 units....

Harris Corporation produces a single product. Last year, Harris manufactured 30,420 units and sold 24,900 units. Production costs for the year were as follows: Fixed manufacturing overhead $395,460 Variable manufacturing overhead $258,570 Direct labor $142,974 Direct materials $234,234 Sales were $1,207,650, for the year, variable selling and administrative expenses were $136,950, and fixed selling and administrative expenses were $185,562. There was no beginning inventory. Assume that direct labor is a variable cost. Under variable costing, the company's net operating income...

Subjects