Question

EXERCISE 5-11 Missing Data; Basic CVP Concepts L05-10.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 cach 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 Margin per Unit Net Operating Income (Loss) Case 1 2 3 4 Units Variable Sold Sales Expenses 15,000 $180,000 $120,000 ? $100,000 ? 10,000 $70,000 6,000 $300,000 ? Fixed Expenses $50,000 $32,000 $10 $13 $8,000 $12,000 $(10,000) $100,000 b. Assume that more than one product is being sold in each of the four following case situations: Average Contribution Margin Ratio 20% Fixed Expenses Case Variable Expenses ? $260,000 Sales $500,000 $400,000 Net Operating Income (Loss) $7,000 2 $100,000 $130,000 60% $20,000 $(5,000) $600,000 $420,000 ?

Answer 1

Please give positive ratings so I can keep answering. It would help me a lot. Please comment if you have any query. Thanks!

Answer a
	A	B	C	D=(B-C)	E=D/A	F	G=D-F
	Units Sold	Sales	Variable Expenses	Contribution Margin	Contribution Margin per unit	Fixed Expenses	Net Operating Income (Loss)
Case 1	15,000.00	180,000.00	120,000.00	60,000.00	4.00	50,000.00	10,000.00
	G=E/B	A	F=A-E	E=C+D	B	C	D
	Units Sold	Sales	Variable Expenses	Contribution Margin	Contribution Margin per unit	Fixed Expenses	Net Operating Income (Loss)
Case 2	4,000.00	100,000.00	60,000.00	40,000.00	10.00	32,000.00	8,000.00
	A	F=B+E	B	E=A*C	C	G=E-D	D
	Units Sold	Sales	Variable Expenses	Contribution Margin	Contribution Margin per unit	Fixed Expenses	Net Operating Income (Loss)
Case 3	10,000.00	200,000.00	70,000.00	130,000.00	13.00	118,000.00	12,000.00
	A	B	F=B-E	E=C+D	G=E/A	C	D
	Units Sold	Sales	Variable Expenses	Contribution Margin	Contribution Margin per unit	Fixed Expenses	Net Operating Income (Loss)
Case 4	6,000.00	300,000.00	210,000.00	90,000.00	35.00	100,000.00	(10,000.00)
Answer b
	A	E=A-D	B	D=A*B	F=D-C	C
	Sales	Variable Expenses	Average Contribution Margin ratio	Contribution Margin ratio	Fixed Expenses	Net Operating Income (Loss)
Case 1	500,000.00	400,000.00	20%	100,000.00	93,000.00	7,000.00
	A	B	E=D/A	D=A-B	C	F=D-C
	Sales	Variable Expenses	Average Contribution Margin ratio	Contribution Margin ratio	Fixed Expenses	Net Operating Income (Loss)
Case 2	400,000.00	260,000.00	35%	140,000.00	100,000.00	40,000.00
	E=D/A	F=E-D	A	D=B+C	B	C
	Sales	Variable Expenses	Average Contribution Margin ratio	Contribution Margin ratio	Fixed Expenses	Net Operating Income (Loss)
Case 3	250,000.00	100,000.00	60%	150,000.00	130,000.00	20,000.00
	A	B	E=D/A	D=A-B	F=D-C	C
	Sales	Variable Expenses	Average Contribution Margin ratio	Contribution Margin ratio	Fixed Expenses	Net Operating Income (Loss)
Case 4	600,000.00	420,000.00	30%	180,000.00	185,000.00	(5,000.00)