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

What am I doing wrong? I am supposed to use cell references

. 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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!