Multiple-Product Ereak-Even and Target Profit Vendenberg, inc., produces and sells two products: a ceiling fan and a table fan. Vandenberg pians to sell 20,000 celing fans and 60,000 table fans in the coming year. Product price and cost information includes: Common fixed selling and administrative expenses total $96,000. Required: 1. What is the sales mix estimated for next year (calculated to thy lowest whole number for esch product)? Sales mix of celling fans to table fans = 2. Using the sales mix from Requirement 1, form a package of celling fans and table fans, How many ceiling fans and table fas are sold at break-even? Round your intermediate calculations and final answers to the nearest whole number. Brsak-even celling fans Break-even table fans 3. Prepare a contribution-margin-based income statement for Vandenberg, Inc. bosed on the unit saies calculated in flequlrement 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. 4. What if Vandenberg, Inc., wanted to earn operating income equal to $14,000 ? Calculate the number of celling fans and table fans that must be sold to eam this level of operating income. (Hint: Remember to form a package of celling fans and table fans based on the sales mix and to first calculate the number of packages to earn an operating income of $14,000.) Round your intermediate calculations and final answers to nearest number. Break-even celling fans Break-even table fans