Need some help with the following question, I also need to input the answers as mathematical formulas to cell reference. Please provide the inputs that i need to use for each yellow cell. Thanks!

waxk Formula: Add. Multiply. Divide: Cell Referencing Using Excel to Compute Multiple Product Break-Even Points PROBLEM a O 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 xed costs follow. Contribution Sales Mix Margin Ratio Birthday candles 30% 20% Standard tapered candles 50% 30% Large scented candles 20% 45% Total xed costs $ 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