Robinson Company has two products, A and B. Robinson’s budget for August follows:
Master Budget | |||||||
Product A | Product B | ||||||
Sales | $ | 264,000 | $ | 396,000 | |||
Variable cost | 154,000 | 264,000 | |||||
Contribution margin | $ | 110,000 | $ | 132,000 | |||
Fixed cost | 88,000 | 66,000 | |||||
Operating income | $ | 22,000 | $ | 66,000 | |||
Selling price | $ | 120 | $ | 60 | |||
On September 1, these operating results for August were reported:
Operating Results | |||||||
Product A | Product B | ||||||
Sales | $ | 198,000 | $ | 446,400 | |||
Variable cost | 117,000 | 309,600 | |||||
Contribution margin | $ | 81,000 | $ | 136,800 | |||
Fixed cost | 88,000 | 66,000 | |||||
Operating income | $ | (7,000 | ) | $ | 70,800 | ||
Units sold | 1,800 | 7,200 | |||||
Required:
1. For each product, determine the following variances measured in dollars of contribution margin:
1. Flex budget variance
2. sales volume variance
3. sALES QUANITY
4. Sales mix variance
Answer-1 | |||||
Flexible Budget variance for Product A | |||||
Actual | Flexible budget | Variances | F/(U) | ||
Sales | $ 1,98,000 | $ 2,16,000 | $ -18,000 | (U) | |
Variable Cost | $ 1,17,000 | $ 1,26,000 | $ 9,000 | F | |
Contribution margin | $ 81,000 | $ 90,000 | $ -9,000 | (U) | |
Fixed Cost | $ 88,000 | $ 88,000 | $ - | ||
Operating Income | $ -7,000 | $ 2,000 | $ -9,000 | (U) | |
Flexible Budget variance for Product B | |||||
Actual | Flexible budget | Variances | F/(U) | ||
Sales | $ 4,46,000 | $ 4,32,000 | $ 14,000 | F | |
Variable Cost | $ 3,09,600 | $ 2,88,000 | $ -21,600 | (U) | |
Contribution margin | $ 1,36,400 | $ 1,44,000 | $ -7,600 | (U) | |
Fixed Cost | $ 66,000 | $ 66,000 | $ - | ||
Operating Income | $ 70,400 | $ 78,000 | $ -7,600 | (U) | |
Answer-2 | |||||
Sales Volume Variance = (Actual Units sold- Budgeted Units Sold)*Std Contribution p.u | |||||
Product A | Product B | ||||
Actual Sales | 1800 | 7200 | |||
Budgeted Sales units | 2200 | 6600 | |||
Difference | -400 | 600 | |||
Std Contribution p.u | $ 50 | $ 20 | |||
Sales Volume variance | $ -20,000 | $ 12,000 | |||
Total Sales Volume Variance is - $ 8,000 (U) | |||||
Answer -3 | |||||
Standard Mix ratio | |||||
25% product A | |||||
75% Product B | |||||
Total Sales during the period | |||||
1800 of product A | |||||
7200 of Product B | |||||
Unit Sales at Standard Mix | |||||
Product A =25% 9000 units = 2250 units | |||||
Product B =75% of 9000 units =6750 units | |||||
Difference between Actual Sales Quantity and sales quantity in Std mix is- | |||||
Product A | Product B | ||||
Budgeted Sales Quantity | 2200 | 6600 | |||
Unit Sales in Std mix | 2250 | 6750 | |||
Difference | 50 (F) | 150(F) | |||
Std Contribution p.u | $ 50 | $ 20 | |||
Variance | 2500(F) | 3000(F) | |||
Total Sales Quantity variance 5500 (f) | |||||
Answer 4 | |||||
Sales Mix Variance = (Actual units sold-unit Sales at Std mix )* Std. contribution per unit | |||||
Product A | Product B | ||||
Actual Sales Quantity | 1800 | 7200 | |||
Unit Sales in Std mix | 2250 | 6750 | |||
Difference | 450 (U) | 450 (F) | |||
Std Contribution p.u | $ 50 | $ 20 | |||
Variance | 22500(U) | 9000(F) | |||
Total Sales Mix variance 13500 (U) |
Robinson Company has two products, A and B. Robinson’s budget for August follows: Master Budget Product...
Robinson Company has two products, A and B. Robinson's budget for August follows: Sales Variable cost Contribution margin Fixed cost Operating income Selling price Master Budget Product A Product B $264,000 $396,000 154,000 264,000 $110,000 $ 132,000 88,000 66,000 $ 22,000 $ 66,000 $ 120 $ 60 On September 1, these operating results for August were reported: Sales Variable cost Contribution margin Fixed cost Operating income Units sold Operating Results Product A Product B $198,000 $ 446,400 117,000 309,600 $...
Master Budget Product A. Product B $396,000 264,000 $132,000 66,000 Sales $264,000 Variable cost 154,000 $110,000 88,000 Contribution margin Fixed cost $ 22,000 $66,000 Operating income 120 Selling price 60 On September 1, these operating results for August were reported: Operating Results Product A Product B $198,000 117,000 $ 81,000 88,000 Sales $446,400 309,600 $136,800 66,000 Variable cost Contribution margin Fixed cost $ (7,000) $ 70,800 Operating income Units sold 1,800 7,200 Required: 1. For each product, determine the following...
Paquindo Co. has two products: X and Y. The firm had the following budget and operating results for the period just ended. The budgeted total industry sales for both products was 324,800 units and the actual industry sales was 350,000. Master Budget Product X Product Y Total Sales $324,800 $426,300 $751,100 Variable costs 194,880 213,150 408,030 Contribution margin 129,920 213,150 $343,070 Fixed costs 162,000 130,000 292,000 Operating income ($32,080) $83,150 $51,070 Selling price per unit $160 $70 Operating Results Product...
1) Paquindo Co. has two products: X and Y. The firm had the following budget and operating results for the period just ended. The budgeted total industry sales for both products was 324,800 units and the actual industry sales was 350,000. Master Budget Product X Product Y Total Sales $324,800 $426,300 $751,100 Variable costs 194,880 213,150 408,030 Contribution margin 129,920 213,150 $343,070 Fixed costs 162,000 130,000 292,000 Operating income ($32,080) $83,150 $51,070 Selling price per unit $160 $70 Operating Results...
3. ABC Company has the master/static budget and actual of operating result (2015) as shown beloW. ABC Company Operating Results For year 2015 Master Budget 20,000 1,000,000 500,000 Actual Variance Units sold Revenue Variable cost Variable production overhead 15,000 742,500 390,000 160,000500 32,500 F 225,000 5,000 U 257,500 U 110,000 F 115,000 U 5,000 F 110,000 U Contribution margin Fixed production overhead Operating income 340,000 150,000 190,000 45,000 80,000 3.1 Prepare a flexible budget for ABC Company for vear 2015...
The budgets of four companies yield the following information: BE(Click the icon to view the budget information for the four companies.) Requirements 1. Fill in the blanks for each company. 2. Compute breakeven, in sales dollars, for each company. Which company has the lowest breakeven point in sales dollars? What cause x i Data Table Requirement 1. Fill in the blanks for each company. (Round the contribution margin per unit and ratio calculations to two decimal places.) Company Q 720,000...
In August, Deighton Inc. sold 40,000 units of its only product for $262,000, and incurred a total cost of $245,000, of which $27,000 was fixed costs. The flexible budget for August showed total sales of $320,000. Among variances of the period were: total variable cost flexible-budget variance, $6,000U; total flexible-budget variance, $67,000U; and, sales volume variance, in terms of contribution margin, $29,000U. The budgeted fixed cost for August, to the nearest dollar, was:
O'Neill's Products manufactures a single product. Cost, sales, and production information for the company and its single product is as follows: (Click the icon to view the data.) Read the requirements. Requirement 1. Prepare an income statement for the upcoming year using variable costing. O'Neill's Products X More Info Contribution Margin Income Statement (Variable Costing) For the Year Ended December 31 S 390,000 Sales revenue Selling price per unit is $65 Variable manufacturing costs per unit manufactured (includes direct materials...
As part of its comprehensive planning and control system, Mopar
Company uses a master budget and subsequent variance analysis. You
are given the following information that pertains to the company’s
only product, XL-10, for the month of December.
Required:
1. Using text Exhibit 14.4 as a guide, complete the missing
parts of the following profit report for December.
2. Based on your completed profit report, determine the dollar
amount, and label (Favorable or Unfavorable) each of the following
variances for...
The following information is available for Brownstone Products Company for the month of July: 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 Actual Units Sales revenue Variable manufacturing costs Fixed manufacturing costs Variable selling and administrative expenses Fixed selling and administrative expenses 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...