Need some help working out the yellow cells on excel. I have to submit the cells using formulas using excel. Otherwise it will come up as incorrect. Please let me know what i need to enter in each 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