B

Formula: Add, Multiply, Divide; Cell Referencing

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

PROBLEM

Jixie Candle Supply makes candles. The sales mix $($as a percentage of total dollar sales$)$ and the contribution margin ratios of its three roduct lines, and its total fixed costs follow.

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