Question: What am I doing wrong? I am supposed to use cell references and I thought that is what I am doing. Please help . M
What am I doing wrong? I am supposed to use cell references and I thought that is what I am doing. Please help

. M 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 LAB 1 Formula: Add, Multiply, Divide; Cell Referencing 2 3 Using Excel to Compute Multiple Product Break-Even 4 Points PROBLEM Dixie Candle Supply makes candies. The sales mix (as a 7 percentage 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 Totalfixed costs $450,000 17 18 19 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 $ 1.500.000 Birthday candles $ 450,000 20 Standard tapered candles $ 730.000 Large scented candles $ 300,000 M Fa Lising Excel to Compute Multiple Product Break Ivan Points Student Work Arna Required: Provide input into cells shaded in yelow in this temple. Use thematical formulas with cell references to the Problem area or work area as indicated PROBLEM Doce Candle Supply makes candies. The sales mix (as a percentage of total dolar sales) and the contribution margin ratios of its three product lines, and its total fxed costs follow 2 10 Sales Mix Corentin Margin Fatin 0.2 What is the weighted-wrage contribution margin ratin? Weighted average contribution margin ratio -SUM/D1212SUM DIBE What is the sales dollar amount of each type of candle that must be sold to break even? 12 Birthday candies Standard tapered candles Large scented candles 0.3 05 0.2 b Totalfixed CONTA 450000 15 16 17 12 Break-en points in sales de las Total SLIM D1/CI 11) Birthday candles SUMK170121 Standard tapered candles SUM7131 FARHAN Large scented candies SUM/K17-014
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
