Question

As the new accountant for Cohen & Co., you have been asked to provide a succinct analysis of financial performance for the year just ended. You obtain the following information that pertains to the company's sole product: Units sold Sales Variable costs Fixed costs Actual 25,000 $ 408,000 238,000 161,000 Master (Static) Budget 30,000 $ 456,000 276,000 141,000 Required: 1. What was the actual operating income for the period? 2. What was the company's master (static) budget operating income for the period? 3. (a) What was the total master (static) budget variance, in terms of operating income, for the period? (b) Is this variance favorable (F) or unfavorable (U)? (Note: The total master (static) budget variance is also referred to as the total operating income variance for the period.) (If a variance has no amount, select "None" in the corresponding dropdown cell.) 4. The total master (static) budget variance for a period can be decomposed into a total flexible-budget variance and a sales volume variance. (a) What was the total flexible-budget variance for the period? (b) Was this variance favorable (F) or unfavorable (U)? (c) What was the sales volume variance for the period? (d) Was this variance favorable (F) or unfavorable (U)? (Do not round your intermediate calculations. If a variance has no amount, select "None" in the corresponding dropdown cell.) 2. 1. Actual operating income Master budget operating income Total master budget variance Total flexible-budget variance Sales volume variance 4.

Answer 1

1. Actual operating income = Sales - Variable costs - Fixed costs

= $408,000 - $238,000 - $161,000

= $9,000

2. Master budget operating income = Sales - Variable costs - Fixed costs

= $456,000 - $276,000 - $141,000

= $39,000

3. (a) Mater budget variance = Actual operating income - Mater budget operating income

= $9,000 - $39,000

= $30,000

(b) Unfavorable

4. Master budget selling price per unit = $456,000 / 30,000 = $15.2

Master budget variable costs = $276,000 / 30,000 = $9.2

Flexible budget uses the actual units and selling price, costs from master budget

Flexible budget operating income = Sales - Variable costs - Fixed costs

= (25,000 * $15.2) - (25,000 * $9.2) - $141,000

= $9,000

(a) Flexible budget variance = Actual budget - Flexible budget

= $9,000 - $9,000

= None

(b) None

(c) Sales volume variance = Flexible budget - Static budget

= $9,000 - $39,000

= $30,000

(d) Unfavorable