Price Vandenberg, Inc., produces and sells two products: a ceiling tan and a table fan. Vandenberg plans to sell 20,000 ceiling fans and 50,000 table fans in the coming year. Product price and cost information includes: Ceiling Fan Table Fan $50 $15 Unit variable cast $7 $20,400 $47,000 Common fixed selling and administrative expenses total $80,000. Required: $11 Direct fixed cost 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 tans and table fons. How many celling fans and table tans are sold at break-even? Round your intermediate calculations and final answers to the nearest whole number 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. f an amount is zero, enter "o". Enter any negative product margin and losses with a minus sign. Do not round intermediate catellation. 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 Tabie Fans Total 1 4. What ir Vandenberg, Inc., wanted to earn operating Income equal to $13,2007 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 $13,200.) Round your intermediate calculations and final answers to nearest number Break-even celling fans Break-even table fans