Multiple Product Break-Even and Target Profit Erro Vandenberg, Inc., produces and sells two products a ceiling fan and a table fan. Vandenberg plans to sell 30,000 celing fans and 70,000 tablets in the cover Product price and cost information includes Ceiling Fan Table Fan Price 560 $15 Unit variable cost $12 $2 Direct Fixed cost $23,600 $45,000 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 calling fans to table fans 3 2. Using the sales mix from Requirement 1, form a package of ceiling fans and table fans. How many calling fans and table fans are sold at break-even? Break-even ceiling fans 7,680 X Break-even table fans 5,376 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 "O", 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 Error 3. Prepare a contribution-margin-based income statement for Vandenberg, Inc., based on the unit sales calculated in Requirement. If an amount is tro, entero, 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 Sales Less: Variable expenses Contribution margin Less: Direct fixed expenses DbibH Variable expenses X Less Common fixed expenses Operating Income Feedback 4. What if Vandenberg, Inc., wanted to eam operating Income equal to $14,4007 Calculate the number of ceiling fans and table tans 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 8,400 X Break-even table fans 5,880