Formula: 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. Sales Mix Contribution Margin Ratio Birthday candles 30% 20% Standard tapered candles 50% 30% Large scented candles 20% 45% Total fixed costs S 450,000 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. a. What is the weighted-average contribution margin ratio? Weighted-average contribution margin ratio b. What is the sales dollar amount of each type of candle that must be sold to break even? Break-even points in sales dollars Total Birthday candles Standard tapered candles Large scented candles