Multiple-Product Break-Even and Target Profit Vandenberg, Inc, produces and selis two products: a ceiling fan and a table fart, Vandenberg plans to sell 20,000 ceiliog fans and bo, 000 table fans in the coming yeac Produet price and cost information includesi: Common foxed seling and administrative expenses total $76,000. Required: 1. What is the sales mix estimated for next year (calculated to the fowest whole number for each prochuct)? Saies mix of ceiling fons 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 ceiling fans X Break-even table fans Teestbeck " Checr My Wore 1. Sales mix is the ratio of one product to another. 2. Calculate the package unit contribution margin. Use the following formula to calculate the total number of breakeven packaget for the sailes mixi Total fixed cost/ Package contribution margin. Finally, use the ratio from Requirement 1 to determine number of break.ulven units far each product. 3. Prepare a contribution-margin-based income statement for Vandenberg, inc, based on the unt sales colculated in Requirement 2 . If an amount is xero, 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. Vesthesce Tonas Mrwon Calculate Sales, Variabie Exponses, Contribution Margin and direct fixed expenses for esch product then add them together. Don't forset to factor in common fixed expenses, 4. What if Vandenberg, Inc., wanted to earn operating income equal to $13,200 ? Calculate the number of ceiling fans and table fans that must be sold to eam this level of operating income. (Hint: Remember to form a package of ceiling fans and table fans bascd on the sales mix and to first calculate the number of packages fo eam an operating income of $13,200.)Roundyourintermediatecalculationsandfinalanswerstonearestnumber. Break-even ceiling fans Break-even table fans 4 x Feedeack: T Creck Mr Wok Calculate the package unit contribution margin. Use the following formula to calculate the total number of breakeven packages far the sales mix for the desired operating income: (Total fixed cost + Target profit)/ Package contribution margin. Finally, use the fabo from Recuairement 1 to determine number of break-even units for each product