Question

EXERCISE 5-11 Missing Data; Basic CVP Concepts LO5-1 LO5-9 Fill in the missing amounts in each of the eight case situations below. Each case is independent of the others. (Hint: One way to find the missing amounts would be to prepare a contribution format income statement for each case, enter the known data, and then compute the missing items.) a. Assume that only one product is being sold in each of the four following case situations Contribution Net Operating Income Units Variable Margin ixe Case Sold Sales Expenses per Unit Expenses (Loss) 1 15,000 $180,000 $120,000 $50,000 $32,000 $8,000 $12,000 100,000 $(10,000) ?$100,000 ? $70,000 $13 3 10,000 4 6,000 $300,000? b. Assume that more than one product is being sold in each of the four following case situations Average Contribution Margin Ratio 20% Net Operating Variable CaseSalesExpenses Income (Loss) $7,000 Expenses 1 $500,000 2 $400,000 $260,000 3 4 $600,000 $420,000 $100,000 $130,000 $20,000 60% $(5,000)

Answer 1

Answer:

Explanation:

A) contribution per unit:

(180,000 - 120,000) / 15,000 = $4

B) net income: 180,000 - 120,000 - 50,000 = 10,000

C) units sold: contribution x units - fixed cost = income

$10 x units sold - 32,000 = 8,000

units sold: 4,000

D) variable cost:

(sales - expense) / units = contribution per unit

(100,000 - expense)/4,000 = 10

expense = 60,000

E) sales:

contribution x units + expense

10,000 x $13 + 70,000 = 200,000

F) fixed expense:

units x contribution - fixed = income

10,000 x $13 - fixed = 12,000

130,000 -12,000 = fixed = 118,000

H) contribution margin unit

contribution x units - fixed cost = income

6,000 x contribution - 100,000 = -10,000

contribution = 90,000 / 6,000 = 15

G) variable expenses:

sales = variable expense + contribution x units sold

300,000 = var expense + 15 x 6000

variable expense = 210,000