Please include excel formulas + cell references in the answer. Thanks.

L M N O P Q Q R S T U V V 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 | D E F 1 Gormula: Add, Multiply, Divide; Cell Referencing 2 3 Using Excel to Compute Multiple Product Break-Even Points 4 5 PROBLEM 6 Dixie Candle Supply makes candles. The sales mix (as a percentage 7 of total dollar sales) and the contribution margin ratios of its three product lines, and its total fixed costs follow. 9 10 Contribution 11 Sales Mix Margin Ratio 12 Birthday candles 30% 20% 13 Standard tapered candles 50% 30% 14 Large scented candles 20% 45% 15 16 Total fixed costs $ 450,000 17 18 18 19 19 20 20 21 -- 22 23 24 25 26 27 2 28 29 30 31 32 33 34 35 36 37 Birthday candles Standard tapered candles Large scented candles Enter Answer + @ + 100%