Multiple-Product Break-Even and Target Profit vandenberg, Inc, produces and sells two products: a ceiling fan and a tabie fan, Vandenberg plans to seli 40,000 ceiling fans and 80,000 tabie fans in the coming year. Product price and cest information includes: Common foxed selling and administrative expenses totai $74,000 Required: 1. Whet is the sales mis estimated for next year (calculated to the lowest whole number for each proctuct)? Sales mix of cering tans to table fans = 2. Using the sales mix from Hequirement 1, form a package of ceiling faris and table fans. How many celling fans and table fans are sold at breskeven? Round your intermediate calculations and final anwers to the nearest whole number: breakreven ceiling faos 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". 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 eam operating income equai to $13,6007 Calculate the number of ceiling fank and table fans that must be sold to earn this level of operating income. (Hint: Remember to form a package of celing fans and table fans based on the sales mox and to first calculate the number of packages to earn an operating income of $13,600.) Mound your intermediate calculations and final answers to nearest number