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 30,000 ceiling fans and 70,000 table fans in the coming year. Product price and cost information includes: Table Fan Ceiling Fan $60 Price $15 $12 Unit variable cost Direct fixed cost $7 $45,000 $23,600 Common fixed selling and administrative expenses total $85,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 = 2. Using the sales mix from Requirement 1, form package of ceiling fans and table fans. How many ceiling fans and table fans are sold at break-even? Break-even ceiling fans Break-even table fans 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". If the product margin is negative, enter a negative amount. Vandenberg, Inc. 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". If the product margin is negative, enter a negative amount. Vandenberg, Inc. Contribution-Margin-Income Statement For the Coming Year Ceiling Fans Table Fans Total $ $ $ 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.) Break-even ceiling fans Break-even table fans