A B

Frormula: Add, Multiply, Divide; Cell Referencing

Using Excel to Compute Multiple Product Break$-$Even Points

PROBLEM

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.

$\backslash$table$[[,$Sales Mix,$\backslash$table$[[$Contribution$],[$Margin Ratio$]]],[$Birthday candles,$30\%,20\%$