Answered step by step
Verified Expert Solution
Question
1 Approved Answer
please please please provide cell functions as well and i eil lbe sure to like!! thabk you so kuch Formula: Add, Multiply, Divide; Cell Referencing
please please please provide cell functions as well and i eil lbe sure to like!! thabk you so kuch
Formula: Add, Multiply, Divide; Cell Referencing Using Excel to Compute Multiple Product Break-Even Points 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 fixed costs follow. Contribution \begin{tabular}{lcc} & Sales Mix & Margin Ratio \\ \hline Birthday candles & 30% & 20% \\ Standard tapered candles & 50% & 30% \\ Large scented candles & 20% & 45% \\ Total fixed costs & $450,000 & \end{tabular} Merge \& Center $%%0.00 Conditional Forma G H2I j K L 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. 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 tatai Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started