Vandenberg, Inc., produces and sells twe products: a ceiling fan and a table fan. Vandenberg plans to sell 20,000 ceiling fans and 50,000 table fens in the coming year. Product price and cost information includes: Ceiling Fan Table Fan Price $50 515 Unit variable cost $11 $7 Direct fixed cost $20,400 $47,000 Common fixed selling and administrative expenses total $80,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 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 celing 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, entero" Enter any negative product margin and losses with a minut 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 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. 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 I 4. What if Vandenberg, Inc., wanted to eam operating income equal to $13,2007 Calculate the number of celling 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 $13,200.) Round your intermediate calculations and final answers to nearest number Break-even calling fans Break-even table fans