Multiple-Product Break-Even and Target Profit

Vandenberg, Inc., produces and sells two products: a ceiling fan and a table fan. Vandenberg plans to sell 20,000 ceiling fans and 70,000 table fans in the coming year. Product price and cost information includes:

	Ceiling Fan				Table Fan
Price		$68				$17
Unit variable cost		$10				$7
Direct fixed cost		$23,800				$45,000

Common fixed selling and administrative expenses total $98,000.

Required:

1. What is the sales mix estimated for next year (calculated to the lowest whole number for each product)? Sales mix of ceiling fans to table fans = fill in the blank 101a0fff4fcc02c_1 : fill in the blank 101a0fff4fcc02c_2

2. Using the sales mix from Requirement 1, form a package of ceiling fans and table fans. How many ceiling fans and table fans are sold at break-even? Round your intermediate calculations and final answers to the nearest whole number.

Break-even ceiling fans	fill in the blank 101a0fff4fcc02c_3
Break-even table fans	fill in the blank 101a0fff4fcc02c_4

3. Prepare a contribution-margin-based income statement for Vandenberg, Inc., based on the unit sales calculated in Requirement 2. If an amount is zero, enter "0". Enter any negative product margin and losses with a minus sign. Do not round intermediate calculations. Round your final answers to nearest dollar.

Vandenberg, Inc.
Contribution-Margin-Income Statement
For the Coming Year
	Ceiling Fans	Table Fans	Total
	$fill in the blank b82ba6fb1041064_2	$fill in the blank b82ba6fb1041064_3	$fill in the blank b82ba6fb1041064_4
	fill in the blank b82ba6fb1041064_6	fill in the blank b82ba6fb1041064_7	fill in the blank b82ba6fb1041064_8
	$fill in the blank b82ba6fb1041064_10	$fill in the blank b82ba6fb1041064_11	$fill in the blank b82ba6fb1041064_12
	fill in the blank b82ba6fb1041064_14	fill in the blank b82ba6fb1041064_15	fill in the blank b82ba6fb1041064_16
	$fill in the blank b82ba6fb1041064_18	$fill in the blank b82ba6fb1041064_19	$fill in the blank b82ba6fb1041064_20
			fill in the blank b82ba6fb1041064_22
			$fill in the blank b82ba6fb1041064_24

4. What if Vandenberg, Inc., wanted to earn operating income equal to $14,400? Calculate the number of ceiling fans and table fans that must be sold to earn this level of operating income. (Hint: Remember to form a package of ceiling fans and table fans based on the sales mix and to first calculate the number of packages to earn an operating income of $14,400.) Round your intermediate calculations and final answers to nearest number.

Break-even ceiling fans	fill in the blank f7383a083fbf03e_1
Break-even table fans	fill in the blank f7383a083fbf03e_2