How to solve in Excel for each question (with formula).

Using Excel to Compute Multiple Product Break-Even Points Student Work Area Required: Provide input into cells shaded in yellow in this template. Use mathematical formulas with cell references to the Problem area or work area as indicated PROBLEM Dixie Candle Supply makes candies. The sales mix (as a percentage of total dollar sales) and the contribution margin ratios ofits three product lines, and its totalfixed costs follow a. What is the weighted average contribution margin ratio? Weighted average contribution margin ratio 0 1 -2 13 24 as 16 17 Birthday candies Standard tapered candles Large scented candles Contribution Sales Mix Margin Ratio 30% 20% 50% 30% 20% 45% b. What is the sales dollar amount of each type of candle that must be sold to break even? Total fixed costs $ 450,000 Break-even points in salos dollars Total Birthday candles Standard tapered candles 18 19 20 21 22 23 24 25 26 Large scented candles