LE prmula: Add, Multiply, Divide; Cell Referencing Using Excel to Compute Multiple Product Break-Even Points PROBLEM Dixie Candle Supply makes candles. The sales mix (as a percentage of total dollar sales) and the contribution margin ratios of its three product lines, and its total fixed costs follow. 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 are as indicated. a. What is the weighted-average contribution margin ratio? Weighted average contribution margin ratio Birthday candles 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 sales dollars Total Birthday candles Standard tapered candles Large scented candles